Uur wijzigen

Serial · 29 Mei 2011

Ik ben sinds kort weer begonnen met een crimegame en ben na een onderbreking van een aantal jaar enkele zaken vergeten. Ik vraag me nu dus af hoe ik het uur van mijn site (vendetta source) wijzig. Dit staat momenteel op 16u35 en moet dus 18u35 worden. Dat is dus twee uur verschil.

Groeten,
Serial.

arendjee · 29 Mei 2011

de tijd van je server goed zetten ?:p

Tim · 29 Mei 2011

Of bij elke time() 60*60*2 erbij optellen.

T.Nijborg · 29 Mei 2011

Dit gaat niet via php of sql. Dit gaat (meestal) via de server tijd, dus je hoeft alleen de server tijd recht te zetten.

Malik · 29 Mei 2011

1. Contact opnemen met je host en vragen om een wijziging in de servertijd.

2. date_default_timezone_set('...'); Op ... de tijdzone invullen en bovenaan in je config/script zetten.

2b.

PHP

date_default_timezone_set('Europe/Amsterdam');

Serial · 4 Juni 2011

Weet je zeker dat dit in het config script moet, Malik?

Mijn configscript ziet er zo uit:

PHP

<?php /* ------------------------- */
/*********************************************************************************************
Config van CrimeCity
**********************************************************************************************/
$mysql_host = "***";
$mysql_pass = "***";
$mysql_user = "***";
$mysql_database = "***";
$admin_email = "***";
$img_root_url = "***";
error_reporting(E_ALL);
  if(!(@mysql_pconnect($mysql_host,$mysql_user,$mysql_pass) && @mysql_select_db($mysql_database))) {
   print <<<ENDHTML
<html>
<head>
  <title>CrimeCity</title>
<link rel="stylesheet" type="text/css" href="style.css">
<META HTTP-EQUIV='refresh' CONTENT='60'; URL='$PHP_SELF'>
</head>
  <table width=100%>
       <tr>
    <td class="subTitle"><b>MYSQL ERROR</b></td>
  </tr>
  <tr><td>&nbsp;&nbsp;</td></tr>
  <tr>
    <td class="mainTxt">
	Er is een fout opgetreden tijdens het verbinding maken met de database. Onze excuses voor het ongemak.    </td></tr>
  </table>
</body>


</html>
ENDHTML;
    exit;
  }
  session_start();
 if(isset($_SESSION['login'])) {
    $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`pc`) AS `pc`,UNIX_TIMESTAMP(`transport`) AS `transport`,UNIX_TIMESTAMP(`bc`) AS `bc`,UNIX_TIMESTAMP(`slaap`) AS `slaap`,UNIX_TIMESTAMP(`kc`) AS `kc`,UNIX_TIMESTAMP(`start`) AS `start`,UNIX_TIMESTAMP(`crime`) AS `crime`,UNIX_TIMESTAMP(`ac`) AS `ac` FROM `users` WHERE `login`='{$_SESSION['login']}'");
    $data				= mysql_fetch_object($dbres);
    $blata = mysql_num_rows($dbres);
include("rangen.php");
include("tijden.php");
include("rangmsg.php");
include("pageviewlimit.php");
//include("ban.php");


/* if ($data->bank > 60000000) { $pi = $_SERVER['REMOTE_ADDR']; mysql_query("INSERT INTO `bans`(`ip`,`reden`,`door`) values('$pi','Bug exploiting','Auto')"); } */
	mysql_query("UPDATE `users` SET `health`='100' WHERE (`health` > 100)");
	mysql_query("UPDATE `users` SET `se`='100' WHERE (`se` > 100)");
	mysql_query("UPDATE `users` SET `stad`='Hasselt' WHERE `stad`=''");
	mysql_query("UPDATE `users` SET `paid`='0' WHERE (`paid` < 0)");
	mysql_query("UPDATE `casino` SET `status`='0' WHERE `owner`=''");
	$time = time();
	mysql_query("UPDATE `users` SET `paid`=`paid`-1,`paidtime1`='0' WHERE (`paidtime1`-$time < 0) AND `paidtime1`!='0'");
	mysql_query("UPDATE `users` SET `paid`=`paid`-1,`paidtime2`='0' WHERE (`paidtime2`-$time < 0) AND `paidtime2`!='0'");
	mysql_query("UPDATE `users` SET `paid`=`paid`-1,`paidtime3`='0' WHERE (`paidtime3`-$time < 0) AND `paidtime3`!='0'");
	mysql_query("UPDATE `famillie` SET `crusher`='0',`aantal`='0' WHERE `crusher`-$time < 0");
if ($blata == 0) { header('Location login.php'); }
if ($data->status != dood) { mysql_query("UPDATE `users` SET `online`=NOW() WHERE `login`='{$data->login}'"); }
$huis = $data->stad;
$ctime = time();
}
  $dbre = mysql_query("SELECT *, UNIX_TIMESTAMP(`time`) AS `getime` FROM `jail` WHERE `login`='{$data->login}'");
  $jisin = mysql_num_rows($dbre);
  $jail = mysql_fetch_object($dbre);
  $tim = ($jail->getime - time());
if ($jisin == 1) {
if ($tim == 1) { $time = gmdate('s', $tim); $word = seconde; $boete = $jail->boete; }
elseif ($tim < 61) { $time = gmdate('s', $tim); $word = seconden; $boete = $jail->boete; }
else { $time = gmdate('i:s', $tim); $word = minuten; $boete = $jail->boete; }
}
mysql_query("DELETE FROM `jail` WHERE UNIX_TIMESTAMP(`time`)-UNIX_TIMESTAMP(NOW()) < 0");
 	$dete = mysql_query("SELECT * FROM `detectives` WHERE UNIX_TIMESTAMP(`time`)-UNIX_TIMESTAMP(NOW()) < 0");
	while($det = mysql_fetch_object($dete)) {
	$suspect = mysql_query("SELECT * FROM `users` WHERE `login`='{$det->van}'");
	$sus = mysql_fetch_object($suspect);
  	$victim = mysql_query("SELECT * FROM `users` WHERE `login`='{$det->naar}'");
  	$vic = mysql_fetch_object($victim);
	$randomdetective = rand(1,5);
if ($det->stad == $vic->stad && $randomdetective == 1) {
  mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$sus->login}','Gevonden','Je detective heeft {$vic->login} gevonden in {$det->stad}.')"); mysql_query("DELETE FROM `detectives` WHERE `naar`='{$vic->login}' AND `stad`='{$det->stad}'");
}
else{
  mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$sus->login}','Niet gevonden','Je detective heeft {$vic->login} niet gevonden.')"); mysql_query("DELETE FROM `detectives` WHERE `naar`='{$vic->login}' AND `stad`='{$det->stad}'");
}
 mysql_query("DELETE FROM `detectives` WHERE UNIX_TIMESTAMP(`time`)-UNIX_TIMESTAMP(NOW()) < 0");
}
$ip = $_SERVER['REMOTE_ADDR'];
$iban = mysql_fetch_object(mysql_query("SELECT * FROM `bans` WHERE `IP`='$ip'"));
$lban = mysql_fetch_object(mysql_query("SELECT * FROM `bans` WHERE `IP`='$ip' OR `login`='{$data->login}'"));
$ban = ($data->login) ? $lban : $iban;
 if ($ban) {
    print <<<ENDHTML
<html>
<head>
<title>CrimeCity</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
  <table width=100%>
    <tr>
    <td class="subTitle"><b>Verbannen</b></td>
  </tr>
  <tr><td>&nbsp;&nbsp;</td></tr>
  <tr>
    <td class="mainTxt">
	Je bent verbannen van Crimecity<br><br>Reden: $ban->reden<br>
	Ben je het hier niet mee eens, mail dan $admin_email.
    </td></tr>
  </table>
</body>
</html>
ENDHTML;
unset($_SESSION['login']);
    exit;
  }
function check_login() {
$res = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `login`='{$_SESSION['login']}'"));
    if($res == 0) {
        unset($_SESSION['login']);
return FALSE;
}
else { return TRUE; }
}
if ($data->xp < 10) { $jailtime = (TIME() + 20); $boete = 250; }
elseif ($data->xp < 20) { $jailtime = (TIME() + 40); $boete = 500; }
elseif ($data->xp < 50) { $jailtime = (TIME() + 60); $boete = 750; }
elseif ($data->xp < 150) { $jailtime = (TIME() + 90); $boete = 1000; }
elseif ($data->xp < 500) { $jailtime = (TIME() + 120); $boete = 5000;  }
elseif ($data->xp < 1000) { $jailtime = (TIME() + 180); $boete = 7500; }
elseif ($data->xp < 2000) { $jailtime = (TIME() + 190); $boete = 12500; }
elseif ($data->xp < 3000) { $jailtime = (TIME() + 230); $boete = 25000; }
elseif ($data->xp < 4500) { $jailtime = (TIME() + 270); $boete = 50000; }
elseif ($data->xp < 6000) { $jailtime = (TIME() + 320); $boete = 60000; }
elseif ($data->xp < 8000) { $jailtime = (TIME() + 370); $boete = 75000; }
elseif ($data->xp < 11000) { $jailtime = (TIME() + 420); $boete = 85000; }
elseif ($data->xp < 15000) { $jailtime = (TIME() + 480); $boete = 100000; }
elseif ($data->xp < 20000) { $jailtime = (TIME() + 540); $boete = 125000; }
elseif ($data->xp >= 20000) { $jailtime = (TIME() + 600); $boete = 150000; }
if (!$data->famillie) { $famillie = "Geen"; }
else { $famillie = $data->famillie; }
    $dbres				= mysql_query("SELECT UNIX_TIMESTAMP(`time`) AS `time`,`name` FROM `cron`");
    while($x = mysql_fetch_object($dbres))
      $update[$x->name]		= $x->time;
$rand = rand(500,2000);
    if(floor($update['kogels']/ 130) != floor(time()/ 130)) {
      $dbres				= mysql_query("SELECT GET_LOCK('kogels_update',0)");
      if(mysql_result($dbres,0) == 1) {
        mysql_query("UPDATE `cron` SET `time`=NOW() WHERE `name`='kogels'");
mysql_query("DELETE FROM `messages` WHERE `to`=''");
mysql_query("DELETE FROM `iplog` WHERE `login`=''");


		mysql_query("UPDATE `stad` SET `kogels`='100',`prijs`='$rand'");
                mysql_query("SELECT RELEASE_LOCK('kogels_update')");
      }
    }


        if(floor($update['uur']/ 3600) != floor(time()/ 3600)) {
      $dbres				= mysql_query("SELECT GET_LOCK('uur_update',0)");
      if(mysql_result($dbres,0) == 1) {
        mysql_query("UPDATE `cron` SET `time`=NOW() WHERE `name`='uur'");
		mysql_query("UPDATE `casino` SET `winst`=`winst`+100 WHERE `spel`='kogelfabriek'");
       mysql_query("SELECT RELEASE_LOCK('uur_update')");
      }
    }
            if(floor($update['day']/ 86400) != floor(time()/ 86400)) {
      $dbres				= mysql_query("SELECT GET_LOCK('day_update',0)");
      if(mysql_result($dbres,0) == 1) {
	  mysql_query("UPDATE `cron` SET `time`=NOW() WHERE `name`='day'");




	mysql_query("DELETE FROM `kras`");
$abrussel = rand(1000,6000);
$aleuven = rand(1000,6000);
$agent = rand(1000,6000);
$abrugge = rand(1000,6000);
$aantwerpen = rand(1000,6000);
$ahasselt = rand(1000,6000);
$aamsterdam = rand(1000,6000);
$aenschede = rand(1000,6000);
$ubrussel = rand(6000,15000);
$uleuven = rand(6000,15000);
$ugent = rand(6000,15000);
$ubrugge = rand(6000,15000);
$uantwerpen = rand(6000,15000);
$uhasselt = rand(6000,15000);
$uamsterdam = rand(6000,15000);
$uenschede = rand(6000,15000);
mysql_query("UPDATE `stad` SET `drugsp`='$ubrussel',`drankp`='$abrussel' WHERE `stad`='Brussel'");
mysql_query("UPDATE `stad` SET `drugsp`='$uleuven',`drankp`='$aleuven' WHERE `stad`='Leuven'");
mysql_query("UPDATE `stad` SET `drugsp`='$ugent',`drankp`='$agent' WHERE `stad`='Gent'");
mysql_query("UPDATE `stad` SET `drugsp`='$ubrugge',`drankp`='$abrugge' WHERE `stad`='Brugge'");
mysql_query("UPDATE `stad` SET `drugsp`='$uantwerpen',`drankp`='$aantwerpen' WHERE `stad`='Antwerpen'");
mysql_query("UPDATE `stad` SET `drugsp`='$uhasselt',`drankp`='$ahasselt' WHERE `stad`='Hasselt'");
mysql_query("UPDATE `stad` SET `drugsp`='$uamsterdam',`drankp`='$aamsterdam' WHERE `stad`='Amsterdam'");
mysql_query("UPDATE `stad` SET `drugsp`='$uenschede',`drankp`='$aenschede' WHERE `stad`='Enschede'");
mysql_query("SELECT RELEASE_LOCK('day_update')");
      }
    }
        if(floor($update['week']/ 604800) != floor(time()/ 604800)) {
      $dbres				= mysql_query("SELECT GET_LOCK('week_update',0)");
      if(mysql_result($dbres,0) == 1) {
        mysql_query("UPDATE `cron` SET `time`=NOW() WHERE `name`='week'");
$blah = mysql_query("SELECT * FROM `users` WHERE `activated`='1' AND `status`='levend'");
while($blahh = mysql_fetch_object($blah)) {
$rp = round($blahh->xp / 50);
if ($rp > 0) { mysql_query("UPDATE `users` SET `rp`='$rp' WHERE `login`='{$blahh->login}'"); }
}
        mysql_query("SELECT RELEASE_LOCK('week_update')");
      }
    }


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;
	mysql_query("UPDATE `user` 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;
	mysql_query("UPDATE `user` 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;
	mysql_query("UPDATE `user` 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;
	mysql_query("UPDATE `user` 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("Brussel","Leuven","Gent","Brugge","Hasselt","Antwerpen","Enschede","Amsterdam");
    $rstad = rand(0,7);
    $stad = "$steden[$rstad]";
	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;
	mysql_query("UPDATE `user` 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;
	mysql_query("UPDATE `user` 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;
	mysql_query("UPDATE `user` 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;
	mysql_query("UPDATE `user` 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')");
  }
}




/* ------------------------- */
?>

Toon Meer

Malik · 4 Juni 2011

Ja tuurlijk zet maar ergens bovenaan

date_default_timezone_set('Europe/Amsterdam');

Serial · 4 Juni 2011

Lukt toch niet hoor, gelijk waar ik het plaats in het config script.

Darsstar · 4 Juni 2011

PHP

date_default_timezone_set('Europe/Amsterdam');
mysql_query("SET time_zone = 'Europe/Amsterdam'");

Try that.

PS. Die eerste regel mag je van mij zo hoog mogelijk neer zetten. De tweede moet tussen de mysql_(p)connect() en de eerste mysql_query() komen te staan.

Serial · 4 Juni 2011

Lukt ook niet met die tweede code erbij.

Heb die eerste code net onder de sterretjes gezet en de tweede code tussen de mysql_connect() en de eerste mysql_query().

Dus voor dit:

PHP

$dbres                = mysql_query("SELECT *,UNIX_TIMESTAMP(`pc`) AS `pc`,UNIX_TIMESTAMP(`transport`) AS `transport`,UNIX_TIMESTAMP(`bc`) AS `bc`,UNIX_TIMESTAMP(`slaap`) AS `slaap`,UNIX_TIMESTAMP(`kc`) AS `kc`,UNIX_TIMESTAMP(`start`) AS `start`,UNIX_TIMESTAMP(`crime`) AS `crime`,UNIX_TIMESTAMP(`ac`) AS `ac` FROM `users` WHERE `login`='{$_SESSION['login']}'");

Malik · 4 Juni 2011

PHP

<?php /* ------------------------- */
/*********************************************************************************************
Config van CrimeCity
**********************************************************************************************/
date_default_timezone_set('Europe/Amsterdam');


$mysql_host = "***";
$mysql_pass = "***";
$mysql_user = "***";
$mysql_database = "***";
$admin_email = "***";
$img_root_url = "***";
error_reporting(E_ALL);
  if(!(@mysql_pconnect($mysql_host,$mysql_user,$mysql_pass) && @mysql_select_db($mysql_database))) {
   print <<<ENDHTML
<html>
<head>
  <title>CrimeCity</title>
<link rel="stylesheet" type="text/css" href="style.css">
<META HTTP-EQUIV='refresh' CONTENT='60'; URL='$PHP_SELF'>
</head>
  <table width=100%>
       <tr>
    <td class="subTitle"><b>MYSQL ERROR</b></td>
  </tr>
  <tr><td>&nbsp;&nbsp;</td></tr>
  <tr>
    <td class="mainTxt">
    Er is een fout opgetreden tijdens het verbinding maken met de database. Onze excuses voor het ongemak.    </td></tr>
  </table>
</body>


</html>
ENDHTML;
    exit;
  }
  session_start();
mysql_query("SET time_zone = 'Europe/Amsterdam'");  
 if(isset($_SESSION['login'])) {
    $dbres                = mysql_query("SELECT *,UNIX_TIMESTAMP(`pc`) AS `pc`,UNIX_TIMESTAMP(`transport`) AS `transport`,UNIX_TIMESTAMP(`bc`) AS `bc`,UNIX_TIMESTAMP(`slaap`) AS `slaap`,UNIX_TIMESTAMP(`kc`) AS `kc`,UNIX_TIMESTAMP(`start`) AS `start`,UNIX_TIMESTAMP(`crime`) AS `crime`,UNIX_TIMESTAMP(`ac`) AS `ac` FROM `users` WHERE `login`='{$_SESSION['login']}'");
    $data                = mysql_fetch_object($dbres);
    $blata = mysql_num_rows($dbres);
include("rangen.php");
include("tijden.php");
include("rangmsg.php");
include("pageviewlimit.php");
//include("ban.php");


/* if ($data->bank > 60000000) { $pi = $_SERVER['REMOTE_ADDR']; mysql_query("INSERT INTO `bans`(`ip`,`reden`,`door`) values('$pi','Bug exploiting','Auto')"); } */
    mysql_query("UPDATE `users` SET `health`='100' WHERE (`health` > 100)");
    mysql_query("UPDATE `users` SET `se`='100' WHERE (`se` > 100)");
    mysql_query("UPDATE `users` SET `stad`='Hasselt' WHERE `stad`=''");
    mysql_query("UPDATE `users` SET `paid`='0' WHERE (`paid` < 0)");
    mysql_query("UPDATE `casino` SET `status`='0' WHERE `owner`=''");
    $time = time();
    mysql_query("UPDATE `users` SET `paid`=`paid`-1,`paidtime1`='0' WHERE (`paidtime1`-$time < 0) AND `paidtime1`!='0'");
    mysql_query("UPDATE `users` SET `paid`=`paid`-1,`paidtime2`='0' WHERE (`paidtime2`-$time < 0) AND `paidtime2`!='0'");
    mysql_query("UPDATE `users` SET `paid`=`paid`-1,`paidtime3`='0' WHERE (`paidtime3`-$time < 0) AND `paidtime3`!='0'");
    mysql_query("UPDATE `famillie` SET `crusher`='0',`aantal`='0' WHERE `crusher`-$time < 0");
if ($blata == 0) { header('Location login.php'); }
if ($data->status != dood) { mysql_query("UPDATE `users` SET `online`=NOW() WHERE `login`='{$data->login}'"); }
$huis = $data->stad;
$ctime = time();
}
  $dbre = mysql_query("SELECT *, UNIX_TIMESTAMP(`time`) AS `getime` FROM `jail` WHERE `login`='{$data->login}'");
  $jisin = mysql_num_rows($dbre);
  $jail = mysql_fetch_object($dbre);
  $tim = ($jail->getime - time());
if ($jisin == 1) {
if ($tim == 1) { $time = gmdate('s', $tim); $word = seconde; $boete = $jail->boete; }
elseif ($tim < 61) { $time = gmdate('s', $tim); $word = seconden; $boete = $jail->boete; }
else { $time = gmdate('i:s', $tim); $word = minuten; $boete = $jail->boete; }
}
mysql_query("DELETE FROM `jail` WHERE UNIX_TIMESTAMP(`time`)-UNIX_TIMESTAMP(NOW()) < 0");
     $dete = mysql_query("SELECT * FROM `detectives` WHERE UNIX_TIMESTAMP(`time`)-UNIX_TIMESTAMP(NOW()) < 0");
    while($det = mysql_fetch_object($dete)) {
    $suspect = mysql_query("SELECT * FROM `users` WHERE `login`='{$det->van}'");
    $sus = mysql_fetch_object($suspect);
      $victim = mysql_query("SELECT * FROM `users` WHERE `login`='{$det->naar}'");
      $vic = mysql_fetch_object($victim);
    $randomdetective = rand(1,5);
if ($det->stad == $vic->stad && $randomdetective == 1) {
  mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$sus->login}','Gevonden','Je detective heeft {$vic->login} gevonden in {$det->stad}.')"); mysql_query("DELETE FROM `detectives` WHERE `naar`='{$vic->login}' AND `stad`='{$det->stad}'");
}
else{
  mysql_query("INSERT INTO `messages`(`time`,`from`,`to`,`subject`,`message`) values(NOW(),'Notificatie','{$sus->login}','Niet gevonden','Je detective heeft {$vic->login} niet gevonden.')"); mysql_query("DELETE FROM `detectives` WHERE `naar`='{$vic->login}' AND `stad`='{$det->stad}'");
}
 mysql_query("DELETE FROM `detectives` WHERE UNIX_TIMESTAMP(`time`)-UNIX_TIMESTAMP(NOW()) < 0");
}
$ip = $_SERVER['REMOTE_ADDR'];
$iban = mysql_fetch_object(mysql_query("SELECT * FROM `bans` WHERE `IP`='$ip'"));
$lban = mysql_fetch_object(mysql_query("SELECT * FROM `bans` WHERE `IP`='$ip' OR `login`='{$data->login}'"));
$ban = ($data->login) ? $lban : $iban;
 if ($ban) {
    print <<<ENDHTML
<html>
<head>
<title>CrimeCity</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
  <table width=100%>
    <tr>
    <td class="subTitle"><b>Verbannen</b></td>
  </tr>
  <tr><td>&nbsp;&nbsp;</td></tr>
  <tr>
    <td class="mainTxt">
    Je bent verbannen van Crimecity<br><br>Reden: $ban->reden<br>
    Ben je het hier niet mee eens, mail dan $admin_email.
    </td></tr>
  </table>
</body>
</html>
ENDHTML;
unset($_SESSION['login']);
    exit;
  }
function check_login() {
$res = mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `login`='{$_SESSION['login']}'"));
    if($res == 0) {
        unset($_SESSION['login']);
return FALSE;
}
else { return TRUE; }
}
if ($data->xp < 10) { $jailtime = (TIME() + 20); $boete = 250; }
elseif ($data->xp < 20) { $jailtime = (TIME() + 40); $boete = 500; }
elseif ($data->xp < 50) { $jailtime = (TIME() + 60); $boete = 750; }
elseif ($data->xp < 150) { $jailtime = (TIME() + 90); $boete = 1000; }
elseif ($data->xp < 500) { $jailtime = (TIME() + 120); $boete = 5000;  }
elseif ($data->xp < 1000) { $jailtime = (TIME() + 180); $boete = 7500; }
elseif ($data->xp < 2000) { $jailtime = (TIME() + 190); $boete = 12500; }
elseif ($data->xp < 3000) { $jailtime = (TIME() + 230); $boete = 25000; }
elseif ($data->xp < 4500) { $jailtime = (TIME() + 270); $boete = 50000; }
elseif ($data->xp < 6000) { $jailtime = (TIME() + 320); $boete = 60000; }
elseif ($data->xp < 8000) { $jailtime = (TIME() + 370); $boete = 75000; }
elseif ($data->xp < 11000) { $jailtime = (TIME() + 420); $boete = 85000; }
elseif ($data->xp < 15000) { $jailtime = (TIME() + 480); $boete = 100000; }
elseif ($data->xp < 20000) { $jailtime = (TIME() + 540); $boete = 125000; }
elseif ($data->xp >= 20000) { $jailtime = (TIME() + 600); $boete = 150000; }
if (!$data->famillie) { $famillie = "Geen"; }
else { $famillie = $data->famillie; }
    $dbres                = mysql_query("SELECT UNIX_TIMESTAMP(`time`) AS `time`,`name` FROM `cron`");
    while($x = mysql_fetch_object($dbres))
      $update[$x->name]        = $x->time;
$rand = rand(500,2000);
    if(floor($update['kogels']/ 130) != floor(time()/ 130)) {
      $dbres                = mysql_query("SELECT GET_LOCK('kogels_update',0)");
      if(mysql_result($dbres,0) == 1) {
        mysql_query("UPDATE `cron` SET `time`=NOW() WHERE `name`='kogels'");
mysql_query("DELETE FROM `messages` WHERE `to`=''");
mysql_query("DELETE FROM `iplog` WHERE `login`=''");


        mysql_query("UPDATE `stad` SET `kogels`='100',`prijs`='$rand'");
                mysql_query("SELECT RELEASE_LOCK('kogels_update')");
      }
    }


        if(floor($update['uur']/ 3600) != floor(time()/ 3600)) {
      $dbres                = mysql_query("SELECT GET_LOCK('uur_update',0)");
      if(mysql_result($dbres,0) == 1) {
        mysql_query("UPDATE `cron` SET `time`=NOW() WHERE `name`='uur'");
        mysql_query("UPDATE `casino` SET `winst`=`winst`+100 WHERE `spel`='kogelfabriek'");
       mysql_query("SELECT RELEASE_LOCK('uur_update')");
      }
    }
            if(floor($update['day']/ 86400) != floor(time()/ 86400)) {
      $dbres                = mysql_query("SELECT GET_LOCK('day_update',0)");
      if(mysql_result($dbres,0) == 1) {
      mysql_query("UPDATE `cron` SET `time`=NOW() WHERE `name`='day'");




    mysql_query("DELETE FROM `kras`");
$abrussel = rand(1000,6000);
$aleuven = rand(1000,6000);
$agent = rand(1000,6000);
$abrugge = rand(1000,6000);
$aantwerpen = rand(1000,6000);
$ahasselt = rand(1000,6000);
$aamsterdam = rand(1000,6000);
$aenschede = rand(1000,6000);
$ubrussel = rand(6000,15000);
$uleuven = rand(6000,15000);
$ugent = rand(6000,15000);
$ubrugge = rand(6000,15000);
$uantwerpen = rand(6000,15000);
$uhasselt = rand(6000,15000);
$uamsterdam = rand(6000,15000);
$uenschede = rand(6000,15000);
mysql_query("UPDATE `stad` SET `drugsp`='$ubrussel',`drankp`='$abrussel' WHERE `stad`='Brussel'");
mysql_query("UPDATE `stad` SET `drugsp`='$uleuven',`drankp`='$aleuven' WHERE `stad`='Leuven'");
mysql_query("UPDATE `stad` SET `drugsp`='$ugent',`drankp`='$agent' WHERE `stad`='Gent'");
mysql_query("UPDATE `stad` SET `drugsp`='$ubrugge',`drankp`='$abrugge' WHERE `stad`='Brugge'");
mysql_query("UPDATE `stad` SET `drugsp`='$uantwerpen',`drankp`='$aantwerpen' WHERE `stad`='Antwerpen'");
mysql_query("UPDATE `stad` SET `drugsp`='$uhasselt',`drankp`='$ahasselt' WHERE `stad`='Hasselt'");
mysql_query("UPDATE `stad` SET `drugsp`='$uamsterdam',`drankp`='$aamsterdam' WHERE `stad`='Amsterdam'");
mysql_query("UPDATE `stad` SET `drugsp`='$uenschede',`drankp`='$aenschede' WHERE `stad`='Enschede'");
mysql_query("SELECT RELEASE_LOCK('day_update')");
      }
    }
        if(floor($update['week']/ 604800) != floor(time()/ 604800)) {
      $dbres                = mysql_query("SELECT GET_LOCK('week_update',0)");
      if(mysql_result($dbres,0) == 1) {
        mysql_query("UPDATE `cron` SET `time`=NOW() WHERE `name`='week'");
$blah = mysql_query("SELECT * FROM `users` WHERE `activated`='1' AND `status`='levend'");
while($blahh = mysql_fetch_object($blah)) {
$rp = round($blahh->xp / 50);
if ($rp > 0) { mysql_query("UPDATE `users` SET `rp`='$rp' WHERE `login`='{$blahh->login}'"); }
}
        mysql_query("SELECT RELEASE_LOCK('week_update')");
      }
    }


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;
    mysql_query("UPDATE `user` 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;
    mysql_query("UPDATE `user` 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;
    mysql_query("UPDATE `user` 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;
    mysql_query("UPDATE `user` 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("Brussel","Leuven","Gent","Brugge","Hasselt","Antwerpen","Enschede","Amsterdam");
    $rstad = rand(0,7);
    $stad = "$steden[$rstad]";
    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;
    mysql_query("UPDATE `user` 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;
    mysql_query("UPDATE `user` 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;
    mysql_query("UPDATE `user` 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;
    mysql_query("UPDATE `user` 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')");
  }
}




/* ------------------------- */
?>

Toon Meer

Probeer dit en anders moet je contact opnemen met je host.

MoBSter · 4 Juni 2011

zoals eerder reeds gezegt !!

Contact opnemen met je host en vragen om een wijziging in de servertijd.

Klaar !

Darsstar · 4 Juni 2011

Jippy, er is blijkbaar een grote kans dat 'Europe/Amsterdam' niet herkend word als tijd zone in mysql...
Dit moeten werken:

PHP

mysql_query("SET time_zone='".substr_replace(date('O'), ':', 3, 0)."'")

Wanneer je controleert of het werkt, gebruik dan aub nieuwe data...

PS. met werken bedoel ik dat de query succesvol uitgevoerd word
PPS. als je PHP 5.1.3 of hoger gebruikt kun je substr_replace(date('O'), ':', 3, 0) vervangen door date('P')

Serial · 7 Juli 2011

Heb het allemaal geprobeerd maar telkens werd mijn site helemaal wit op een klein deel na.

Hoe moet ik trouwens contact opnemen met de host? Ik bedoel: wat moet ik dan precies vragen?

FrankY · 8 Juli 2011

Dan vraag je of ze de servertijd goed willen zetten. Wel zo vriendelijk mogelijk natuurlijk, niet gaan zeuren haha. :$

L.Groot · 8 Juli 2011

Je kan ook iets in je htaccess zetten, dan is het meteen voor je hele site aangepast.

SimonD · 8 Juli 2011

Maak een variabele in je sql_conections ofzo (script die je altijd oproept)
$time = time() + 60*60*2;

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Plesk installer

cpanel / whm themes

PHP Point of Sale

Probleem omtrent Tinymce

Kunnen jullie mij helpen met deze enquete

een eigen cloud sever

Probleem C++ en CL

193 Nieuwe domeinnamen April 2025

228 Nieuwe domeinnamen Maart 2025

285 Nieuwe domeinnamen Februari 2025

Uur wijzigen

Participate now!

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2

Delen