<?php
/*
* 8 = loterij
* 9 = Black Jack
* 10 = Keno
* 11 = Card War
* 12 = Roulette
* 13 = Racetrack
* 14 = Dobbelen
* 15 = SLotmachine
*/
$sql = mysql_query("SELECT `owner` FROM `casino` WHERE `bezit_id`=8") ;
$res = mysql_fetch_assoc($sql);
$owner = $res['owner'];
$total = mysql_query("SELECT COUNT(1) FROM `loterij`") ;
$total = mysql_result($total, 0);
$pot = $total * 25000;
$price[1] = round($pot * 25.47);
$price[2] = round($pot * 20.23);
$price[3] = round($pot * 15.12);
$qHas = mysql_query("SELECT COUNT(1) FROM `loterij` WHERE `user`='$data->login'") ;
$has = false;
if(mysql_result($qHas, 0) >= 1){
$has = true;
}
$winners = array();
$sql = mysql_query("SELECT `price`, `username` FROM `loterij_winnaars` LEFT JOIn `[users]` ON `[users]`.`login`=`loterij_winnaars`.`id` ORDER BY `price` DESC") ;
$i = 1;
while($res = mysql_fetch_assoc($sql)){
$winners[$i]['username'] = $res['username'];
$winners[$i]['price'] = $res['price'];
$i++;
}
if(isset($_POST['buy'])){
if($has){
$msg = bad("Je hebt al een lot!");
} elseif($data->cash < 25000){
$msg = bad("Je hebt geen <b>$25,000</b> contant!");
} else {
mysql_query("INSERT INTO `loterij`(`user`) VALUES ('$data->login')") ;
if($owner != 0){
mysql_query("UPDATE `[users]` SET `bankmoney`=`bankmoney`+1800 WHERE `login`=".$owner) ;
mysql_query("UPDATE `casino` SET `winst`=`winst`+1800, `winst_hour`=`winst_hour`+1800 WHERE `bezit_id`=8") ;
}
mysql_query("UPDATE [users] SET `cash`=`cash`-25000 WHERE id='$data->login'") ;
$msg = good("Je hebt een lot gekocht voor <b>$25,000!</b>");
}
}
/*
if(isset($_GET['x']) && $_GET['x'] == 'buy'){
if($owner > 0){
$msg = bad("De loterij heeft al een eigenaar!");
} elseif(hasPoses(8) > 0){
$msg = bad("Je hebt al een loterij! Let op: Biedingen op de markt tellen ook mee!");
} elseif($data->cash < 500000){
$msg = bad("Je hebt niet genoeg geld contant staan!");
} elseif(hasBescherming()){
$msg = bad("Met bescherming kan je geen bezitting kopen!");
} else {
mysql_query("UPDATE `[users]` SET `cash`=`cash`-500000 WHERE `id`='$data->login'") ;
mysql_query("UPDATE `casino` SET `winst`=0, `winst_hour`=0, `owner`='$data->login' WHERE `bezit_id`=8")
;
$msg = good("Je hebt de <b>loterij</b> gekocht voor <b>$500,000!</b>");
$owner = ID;
}
}*/
/*
$total = mysql_query("SELECT COUNT(1) FROM `loterij`") ;
$total = mysql_result($total, 0);
$pot = $total * 25000;
$price[1] = round($pot * 0.47);
$price[2] = round($pot * 0.23);
$price[3] = round($pot * 0.12);
mysql_query("TRUNCATE TABLE `loterij_winnaars`");
$sql = mysql_query("SELECT `user` FROM `loterij` ORDER BY RAND() LIMIT 3") ;
$i = 1;
while($res = mysql_fetch_assoc($sql)){
mysql_query("UPDATE `[users]` SET `bankmoney`=`bankmoney`+".$price[$i]." WHERE `id`=".$res['user']);
mysql_query("INSERT INTO `loterij_winnaars`(`id`, `price`) VALUES (".$res['user'].", ".$price[$i].")") ;
$bericht = "Je hebt de <b>".$i."e</b> prijs gewonnen met de loterij ter waarde van <b>$".number_format($price[$i])."<b>!<br><br>";
mysql_query("INSERT INTO `berichten`(`verzender_id`, `ontvanger_id`, `bericht`, `date`)
VALUES
(-1, ".$res['user'].", '".$bericht."', NOW() )") ;
$i++;
}
mysql_query("TRUNCATE TABLE `loterij`");*/
?>
<form method='post'> <table border='0' cellspacing='1' width='96%' bgcolor='#000' align="center"> <tr> <td class='top' colspan="2"> Loterij </td> </tr> <tr> <td class="container" width="30%"> <img src="IMG/loterij.jpg" alt="" /> </td> <td class="container" width="70%"> <table border='0' cellspacing='1' width='86%' bgcolor='#000' align="center"> <tr> <td class='subtop'> Loterij van vandaag </td> </tr> <tr> <td class="container">
<center>
<?php
if(isset($msg)){
echo $msg."<br>";
} elseif(!$has){
echo bad("Je hebt nog geen lot, een lot kost <b>$25,000!</b>");
echo "<BR><input type='submit' name='buy' value='Koop een lot!' /><br><br>";
} else {
echo good("Je hebt al een lot voor deze trekking!<br>
");
}
?></center> <table border='0' cellspacing='1' width='86%' bgcolor='#000' align="center"> <tr> <td class='subtop' colspan="2"> Prijzen </td> </tr> <tr> <td class="inhoud" width="40%"> <table border='0' cellspacing='0' style='margin: 0px;'> <tr> <td> <img src='/images/icons/tag_blue.png' alt='' border='0'> </td> <td> Status: </td> </tr> </table> </td> <td class="inhoud" width="60%"> Nog niet gevallen </td> </tr> <tr> <td class="inhoud" width="40%"> <table border='0' cellspacing='0' style='margin: 0px;'> <tr> <td> <img src='/images/icons/award_star_gold_1.png' alt='' border='0'> </td> <td> Eerste prijs: </td> </tr> </table> </td> <td class="inhoud" width="60%"> $<?=number_format($price[1]);?> </td> </tr> <tr> <td class="inhoud" width="40%"> <table border='0' cellspacing='0' style='margin: 0px;'> <tr> <td> <img src='/images/icons/award_star_silver_1.png' alt='' border='0'> </td> <td> Tweede prijs: </td> </tr> </table> </td> <td class="inhoud" width="60%"> $<?=number_format($price[2]);?> </td> </tr> <tr> <td class="inhoud" width="40%"> <table border='0' cellspacing='0' style='margin: 0px;'> <tr> <td> <img src='/images/icons/award_star_bronze_1.png' alt='' border='0'> </td> <td> Derde prijs: </td> </tr> </table> </td> <td class="inhoud" width="60%"> $<?=number_format($price[3]);?> </td> </tr> </table> </td> </tr> </table> <table border="0" cellspacing="1" width="86%" bgcolor="#000" align="center"> <tr> <td class="subtop" colspan="2"> Laatste winnaars </td> </tr>
<?php
foreach($winners AS $plaats => $data){
echo "
<tr> <td class='inhoud' width='40%'> <table border='0' cellspacing='0' style='margin: 0px;'> <tr> <td> <img src='/images/icons/award_star_".$plaats.".png' alt='' border='0'> </td> <td> <b>#".$plaats.":</b> <a href='?p=profile&x=".$data['username']."'>".$data['username']."</a> </td> </tr> </table> </td> <td class='inhoud' width='60%'> <b>$".number_format($data['price'])."</b> </td> </tr>
";
}
?>
<BR><BR><center>Er zijn al <b><?=number_format($total);?></b> loten verkocht voor deze trekking!<br><br>
Deze <b>loterij trekking</b> is om de week!</center><BR>
</form> </td> </tr><table></table>
</table>
|
