<?PHP


if(!(@mysql_connect("localhost","wwwdemo_crime","1234567890") && @mysql_select_db("wwwdemo_crime"))) {

	echo 'We hebben een probleem met de verbinding naar de database..';

	exit;

}


mysql_query("UPDATE `[users]` SET `IPs`=''");

mysql_query("UPDATE `[clans]` SET `IPs`=''");

mysql_query("UPDATE `[users]` SET `cash`=`cash`+500,`bank`=`bank`+1000 WHERE `vipdagen` > 0");

mysql_query("UPDATE `[users]` SET `vermoord`=`vermoord`-'1' WHERE `vermoord` > 0");

mysql_query("UPDATE `[users]` SET `maffiamode`='0'");

mysql_query("UPDATE `[users]` SET `gijzel`='10'");

 mysql_query("UPDATE `[users]` SET `kliktijd`=`kliktijd`=0 WHERE `kliktijd` > 0");


    $dbres				= mysql_query("SELECT * FROM `[clans]`");

    while($clan = mysql_fetch_object($dbres)) 

{


$a=$clan->nachtclub; 

$b=250;

$nachtclubbank=$a*$b;


$c=$clan->nachtclub; 

$d=150;

$nachtclubcontant=$c*$d;


$e=$clan->money_lvl9; 

$f=150;

$boorbank=$e*$f;


$g=$clan->money_lvl9; 

$h=50;

$boorcontant=$g*$h;


$i=$clan->snackbar; 

$j=50;

$snackbarcontant=$i*$j;


$g=$clan->snackbar; 

$h=100;

$snackbarbank=$g*$h;


$i=$clan->cafee; 

$j=100;

$cafeecontant=$i*$j;


$g=$clan->cafee; 

$h=200;

$cafeebank=$g*$h;


$i=$clan->casino; 

$j=200;

$casinocontant=$i*$j;


$g=$clan->casino; 

$h=500;

$casinobank=$g*$h;


$i=$clan->restaurant; 

$j=150;

$restaurantcontant=$i*$j;


$g=$clan->restaurant; 

$h=250;

$restaurantbank=$g*$h;


$totaalgeldclancash=$nachtclubcontant+$boorcontant+$snackbarcontant+$cafeecontant+$casinocontant+$restaurantcontant;

$totaalgeldclanbc=$totaalgeldclancash*24;


$totaalgeldclanbank=$nachtclubbank+$boorbank+$snackbarbank+$cafeebank+$casinobank+$restaurantbank;

$totaalgeldclanbb=$totaalgeldclanbank*24;


$totaalgeldclan=$energiebank+$energiecontant+$boorcontant+$boorbank+$coffeecontant+$coffeebank;

$totaalgeldclanb=$totaalgeldclan*24;


 mysql_query("UPDATE `[users]` SET cash=cash+'".$totaalgeldclancash."', bank=bank+'".$totaalgeldclanbank."' WHERE clan='".$clan->name."'");


}


//  $dbres        = mysql_query("SELECT * FROM `[clans]`");

//  while($clan = mysql_fetch_object($dbres)) {

//    if($clan->type == 1)

//      mysql_query("UPDATE `[users]` SET `cash`=`cash`+". (50*$clan->nachtclub) .",`bank`=`bank`+". (150*$clan->nachtclub) ." WHERE `clan`='{$clan->name}'");

//    else if($clan->type == 1)

//      mysql_query("UPDATE `[users]` SET `cash`=`cash`+". (100*$clan->cafee) .",`bank`=`bank`+". (100*$clan->cafee) ." WHERE `clan`='{$clan->name}'");

//    else if($clan->type == 1)

//      mysql_query("UPDATE `[users]` SET `bank`=`bank`+". (rand(150,300)*$clan->restaurant) ." WHERE `clan`='{$clan->name}'");

//  }


$dbres = mysql_query("SELECT bitches,ramen,login FROM `[users]`");

while($user = mysql_fetch_object($dbres))

{

	$bitch = rand(50,150);

	$hoer = rand(150,400);

	
	$bitches = $user->bitches*$bitch;

	$raam = ($user->bitches*$hoer)-($user->ramen*100);

	
	mysql_query("UPDATE `[users]` SET `bank`=`bank`+".($raam+$bitches).", bitchesgezocht='0' WHERE `login`='".$user->login."'");

}

?>