> 2)=$horse"); $gamblers = mysql_num_rows($dbresh); while($datah = mysql_fetch_assoc($dbresh)) { $amount = floor($jackpot / $gamblers * (((25 * pow(2,($datah['code'] & 0x0003)-1))/100))); mysql_query("UPDATE `[users]` SET bank=`bank`+". $amount ." WHERE login='". $datah['login'] ."'"); mysql_query("INSERT INTO `[logs]`(`time`,`login`,`person`,`code`,`area`) values(NOW(),'Paardenrace','". $datah['login'] ."',". $amount .",'donate')"); mysql_query("INSERT INTO `[messages]`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Paardenrace','". $datah['login'] ."','Paardenrace','Gefeliciteerd! Je hebt € ". $amount ." gewonnen')"); } mysql_query("DELETE FROM `[temp]` WHERE `area`='horserace'"); mysql_query("OPTIMIZE TABLE `[temp]`"); mysql_query("INSERT INTO `[logs]`(`code`,`area`,`time`) values(". $horse .",'horserace_num',NOW())"); mysql_query("INSERT INTO `[logs]`(`code`,`area`,`time`) values(". $jackpot .",'horserace_jackpot',NOW())"); mysql_query("INSERT INTO `[logs]`(`code`,`area`,`time`) values(". $gamblers .",'horserace_winners',NOW())"); ?>