Uur wijzigen

Serial

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

de tijd van je server goed zetten ?:p

Tim

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

T.Nijborg

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

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

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')");
  }
}




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

Meer tonen

Malik

Ja tuurlijk zet maar ergens bovenaan

date_default_timezone_set('Europe/Amsterdam');

Serial

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

Darsstar

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

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

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')");
  }
}




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

Meer tonen

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

MoBSter

zoals eerder reeds gezegt !!

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

Klaar !

Darsstar

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

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

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

L.Groot

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

SimonD

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

ICTscripters

Dé plek voor IT

Dé plek voor IT

[Beta] Ottomaan: gratis browserspel met een echte, levende stad. Feedback gezocht!

Port Father: beta van een browsergame in Antwerpen 1931, feedback welkom

Maffia Hotel: een browsergame waarin je van lobbygast naar spil van het hotel groeit

Crime Club volledig herschreven vanaf nul

Malavita (nieuwe maffia game, van 0)

Herkent deze Notion-structuurscan echte problemen?

🚀 WE ZOEKEN TESTERS! 🚀

Luchtvaartsoftware: Hoe technologie de moderne luchtvaart verandert

[Verkoop] G4G (Gangsters 4 Gangsters): volledige broncode, nieuw gebouwd in PHP 8.3 | € 30 per domein

[TE KOOP] Malavita.be [Maffiaspel, gebaseerd op omicidio.nl, unieke code]

TK: Kraai.eu

Uur wijzigen

Registratie

PHP waarschuwt voor twee ernstige bugs die makkelijk uit te buiten lijken

Functioneel ontwerp

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

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

Gebruikers die dit topic bekijken