[code]$result = dbquery("SELECT wp.def,wp.name,wp.id,wp.price,uk.money,uk.armor FROM ".DB_PREFIX."user_skills uk, ".DB_PREFIX."armors wp WHERE
					uk.id = $user_id AND uk.level >= wp.level");[/code]

[code]<?php
$dactons = dbquery("SELECT `money` FROM ".DB_PREFIX."user_skills WHERE id = $user_id");
$dactons = dbresult($dactons,0);
echo $dactons;
?>[/code]







[code]if (isset($_POST['buy'])) {
	$buy = $_POST['buy'];
	$result = dbquery("SELECT wp.price FROM ".DB_PREFIX."user_skills uk, ".DB_PREFIX."armors wp WHERE
						wp.id != uk.armor AND uk.money >= wp.price AND wp.level <= uk.level AND wp.id = $buy AND uk.id = $user_id");
	if (dbrows($result) == 0) echo '<font color="red"><b>Es wurde eine ung&uuml;ltige R&uuml;stung ausgew&auml;hlt!</b></font><br /><br />';[/code]
[code]

		$price = dbresult($result,0);
		dbquery("UPDATE ".DB_PREFIX."user_skills Set `armor` = $buy, `money` = `money`-$price WHERE id = $user_id")
					or die('SCHWERER FEHLER: Die Waffe konnten nicht angelegt werden!');
		?>
[/code]

[code]$round++;
	$_SESSION['round'] = $round;
	dbquery("UPDATE ".DB_PREFIX."user_skills Set `leben` = $s_leben WHERE `id` = $user_id") or die('<br /><font color="red">SCHWERER FEHLER: Konnte die Lebenspunkte nicht aktualisieren!</font>');[/code]
[code]
$username = "SELECT user_name FROM ".DB_PREFIX."users WHERE user_id = '$user_id'";
$username = dbquery($username);
$username = dbresult($username,0);[/code]

[code]	$skills = dbquery("SELECT exp,level FROM ".DB_PREFIX."user_skills WHERE id = $user_id");[/code]

[code]		$skills = dbquery("SELECT level,exp,money,statpoints FROM ".DB_PREFIX."user_skills WHERE id = $user_id");[/code]

[code]		$skills = dbquery("SELECT money,exp,max_leben,level FROM ".DB_PREFIX."user_skills WHERE id = $user_id");[/code]

[code]$weapon = dbquery("SELECT $aod FROM ".DB_PREFIX.$stat."s WHERE id = $use");[/code]
[code]
		$weapon = dbquery("SELECT $aod FROM ".DB_PREFIX.$stat."s WHERE id = $use");[/code]

[code]$result = dbquery("SELECT uk.leben,uk.atk,uk.def,uk.level,uk.max_leben,wp.atk,am.def,uk.img_id,uk.statpoints,uk.armor,uk.weapon FROM ".DB_PREFIX."user_skills uk, ".DB_PREFIX."weapons wp, ".DB_PREFIX."armors am[/code]


[code]
$result = dbquery("SELECT id,name,level,weapon,armor FROM ".DB_PREFIX."enemies WHERE level = $s_level ORDER BY rand()");[/code]


[code]$result = dbquery("SELECT `fighting` FROM ".DB_PREFIX."user_skills WHERE id = $user_id");[/code]

[code]
dbquery("UPDATE ".DB_PREFIX."user_skills Set `fighting` = $ooo WHERE id = $user_id");[/code]

[code]$result = dbquery("UPDATE ".DB_PREFIX."user_skills Set `leben` = $leben,[/code]

[code]
$result = dbquery("UPDATE ".DB_PREFIX."user_skills Set `level` = $level,[/code]


[code]	$result = dbquery("UPDATE ".DB_PREFIX."user_skills Set `leben` = $s_leben, `exp` = $exp_sum WHERE id = $user_id");[/code]
[code]
$result = dbquery("SELECT uk.leben,uk.atk,uk.def,uk.level,uk.max_leben,wp.atk,am.def,uk.img_id,uk.statpoints,uk.armor,uk.weapon,uk.money,uk.exp,wp.name,am.name,uk.fighting FROM ".DB_PREFIX."user_skills uk, ".DB_PREFIX."weapons wp, ".DB_PREFIX."armors am
					WHERE uk.weapon = wp.id AND uk.armor = am.id AND uk.id = $user_id");[/code]

[code]$username = "SELECT user_name FROM ".DB_PREFIX."users WHERE user_id = '$user_id'";[/code]

[code]	$statp = dbquery("SELECT `statpoints` FROM ".DB_PREFIX."user_skills WHERE id = $user_id");[/code]


[code]dbquery("UPDATE ".DB_PREFIX."user_skills Set `leben` = `max_leben`+$zus_leben,`max_leben` = `max_leben`+$zus_leben, `statpoints` = `statpoints`-1 WHERE id = $user_id");[/code]
[code]
dbquery("UPDATE ".DB_PREFIX."user_skills Set `atk` = `atk`+1, `statpoints` = `statpoints`-1 WHERE id = $user_id");
[/code]


[code]dbquery("UPDATE ".DB_PREFIX."user_skills Set `def` = `def`+1, `statpoints` = `statpoints`-1 WHERE id = $user_id");[/code]


[code]
dbquery("UPDATE ".DB_PREFIX."user_skills Set `img_id` = $new WHERE id = $user_id") or die('SCHWERER FEHLER: Konnte das Characterbild nicht &auml;ndern!');[/code]


DAs sind alle Codes

