if(floor($update['loterij']/ 259200) != floor(time()/ 259200)) {
  $dbres = mysql_query("SELECT GET_LOCK('loterij_update',0)");
  if(mysql_result($dbres,0) == 1) {
    $sql = mysql_query("SELECT * FROM `loterij`");
	$nroflot = mysql_num_rows($sql);
	if($nroflot < 1){$nroflot = 1;}


	$a = rand(1,$nroflot);
	$b = rand(1,$nroflot);
	$c = rand(1,$nroflot);
	$d = rand(1,$nroflot);
	$e = rand(1,$nroflot);
	$f = rand(1,$nroflot);
	$g = rand(1,$nroflot);
	$h = rand(1,$nroflot);
	$i = rand(1,$nroflot);


	$sql = mysql_query("SELECT `login` FROM `loterij` WHERE `id`='{$a}'");
	$a = mysql_num_rows($sql);
	$jackpot = $nroflot*10000;
	$a = mysql_fetch_object($sql);
	mysql_query("UPDATE `users` SET `zak`=`zak`+$jackpot WHERE `login`='{$a->login}'");
	mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$a->login}','Loterij','Je hebt &euro; $jackpot gewonnen met de loterij.')"); 
	$sql = mysql_query("SELECT `login` FROM `loterij` WHERE `id`='{$b}'");
	$b = mysql_num_rows($sql);
	$prijs = 1000000;
	$b = mysql_fetch_object($sql);
	mysql_query("UPDATE `users` SET `zak`=`zak`+$prijs WHERE `login`='{$b->login}'");
	mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$b->login}','Loterij','Je hebt &euro; $prijs gewonnen met de loterij.')"); 
	$sql = mysql_query("SELECT `login` FROM `loterij` WHERE `id`='{$c}'");
	$c = mysql_num_rows($sql);
	$prijs = 500000;
	$c = mysql_fetch_object($sql);
	mysql_query("UPDATE `users` SET `zak`=`zak`+$prijs WHERE `login`='{$c->login}'");
	mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$c->login}','Loterij','Je hebt &euro; $prijs gewonnen met de loterij.')"); 
	$sql = mysql_query("SELECT `login` FROM `loterij` WHERE `id`='{$d}'");
	$d = mysql_num_rows($sql);
	$prijs = 250000;
	$d = mysql_fetch_object($sql);
	mysql_query("UPDATE `users` SET `zak`=`zak`+$prijs WHERE `login`='{$d->login}'");
	mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$d->login}','Loterij','Je hebt &euro; $prijs gewonnen met de loterij.')"); 
	$sql = mysql_query("SELECT `login` FROM `loterij` WHERE `id`='{$e}'");
	$e = mysql_num_rows($sql);
	$prijs = 400000;
	$steden = Array("PWG","VLD","TLS","OBS","Slinge");
    $rstad = rand(0,7);
    $stad = "$steden[$rstad]";
	$e = mysql_fetch_object($sql);
	mysql_query("INSERT INTO `garage`(`login`,`naam`,`waarde`,`damage`,`stad`) values('{$e->login}','$prijs','$prijs','0','$stad')");
	mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$e->login}','Loterij','Je hebt een Mercedes W124 Avus Streamling met 0% schade gewonnen met de loterij.')"); 
	$sql = mysql_query("SELECT `login` FROM `loterij` WHERE `id`='{$f}'");
	$f = mysql_num_rows($sql);
	$prijs = 3000;
	$f = mysql_fetch_object($sql);
	mysql_query("UPDATE `users` SET `kogels`=`kogels`+$prijs WHERE `login`='{$f->login}'");
	mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$f->login}','Loterij','Je hebt $prijs kogels gewonnen met de loterij.')"); 
	$sql = mysql_query("SELECT `login` FROM `loterij` WHERE `id`='{$g}'");
	$g = mysql_num_rows($sql);
	$prijs = 2000;
	$g = mysql_fetch_object($sql);
	mysql_query("UPDATE `users` SET `kogels`=`kogels`+$prijs WHERE `login`='{$g->login}'");
	mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$g->login}','Loterij','Je hebt $prijs kogels gewonnen met de loterij.')"); 
	$sql = mysql_query("SELECT `login` FROM `loterij` WHERE `id`='{$h}'");
	$h = mysql_num_rows($sql);
	$prijs = 1000;
	$h = mysql_fetch_object($sql);
	mysql_query("UPDATE `users` SET `kogels`=`kogels`+$prijs WHERE `login`='{$h->login}'");
	mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$h->login}','Loterij','Je hebt $prijs kogels gewonnen met de loterij.')"); 
	$sql = mysql_query("SELECT `login` FROM `loterij` WHERE `id`='{$i}'");
	$i = mysql_num_rows($sql);
	$prijs = 500;
	$i = mysql_fetch_object($sql);
	mysql_query("UPDATE `users` SET `kogels`=`kogels`+$prijs WHERE `login`='{$i->login}'");
	mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$i->login}','Loterij','Je hebt $prijs kogels gewonnen met de loterij.')"); 
    mysql_query("UPDATE `cron` SET `time`=NOW() WHERE `name`='loterij'");
    mysql_query("TRUNCATE TABLE `loterij`");


    mysql_query("SELECT RELEASE_LOCK('loterij_update')");
  }
}