<?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> </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> </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 € $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 € $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 € $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 € $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')");
}
}
/* ------------------------- */
?>
|
