wid."'")or die(mysql_error()); while($row = mysql_fetch_array($sql)){ $hero = $row["hero"]; }; if ( $hero == 0 ) { die('You have not trained a hero yet! '); } $sql = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE id='".$session->uid."'")or die(mysql_error()); while($row = mysql_fetch_array($sql)){ $silver = $row["silver"]; }; if ($silver <500) { die('Sorry you dont have enough Silver'); } mysql_query("UPDATE s1_users SET `silver` = `silver`- 500 WHERE id =".$session->uid."")or die(mysql_error()); mysql_query("UPDATE ".TB_PREFIX."hero SET `head` = 4 WHERE uid='".$session->uid."'")or die(mysql_error()); mysql_query("UPDATE ".TB_PREFIX."hero SET `experience` = `experience`+500 WHERE uid='".$session->uid."'")or die(mysql_error()); header("Location: hero.php"); ?>