_cron_hour.php

Time 4 Crime online

<?php /* ------------------------- */

  if($cron_pass != "secretcronpassword")
    exit;

  mysql_query("UPDATE `[users]` SET `cash`=`cash`+250 WHERE `activated`='1' AND `health`>'0' AND `level`>'0'");
  mysql_query("UPDATE `[users]` SET `bank`=`bank`+150 WHERE `type`=3 AND `activated`='1' AND `health`>'0' AND `level`>'0'");
  mysql_query("UPDATE `[clans]` SET `cash`=`cash`+100,`bank`=`bank`+250");


  $select = mysql_query("SELECT * FROM `[buildings]` WHERE `type`='bulletfactory' AND `active`>='25'");
   while($aantal = mysql_fetch_object($select)) {
	$pricPhour = ($aantal->active == 0) ? "0" : "$pricPhour";
	$pricPhour = ($aantal->active == 25) ? "2500" : "$pricPhour";
	$pricPhour = ($aantal->active == 50) ? "6500" : "$pricPhour";
	$pricPhour = ($aantal->active == 100) ? "17500" : "$pricPhour";
	$pricPhour = ($aantal->active == 250) ? "50000" : "$pricPhour";

	$select = mysql_query("SELECT `login` FROM `[users]` WHERE `login`='{$aantal->owner}' AND `cash`<'$pricPhour'");
	  while($teweinig = mysql_fetch_object($select)) {
		mysql_query("UPDATE `[buildings]` SET `active`='0' WHERE `owner`='{$teweinig->login}' AND `type`='bulletfactory'");
	  }
	  if(mysql_num_rows($select) == 0) {
		mysql_query("UPDATE `[buildings]` SET `amount`=`amount`+$aantal->active WHERE `type`='bulletfactory' AND `active`>='25'");
		mysql_query("UPDATE `[users]` SET `cash`=`cash`-$pricPhour WHERE `login`='{$aantal->owner}'");
		mysql_query("UPDATE `[buildings]` SET `profit`=`profit`-$pricPhour WHERE `type`='bulletfactory' AND `active`>='25'");
	  }
   }



   $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`time`) AS `time` FROM `[messages]` WHERE `saved`='0' AND `read`='1'");
   while($message = mysql_fetch_object($dbres)) {
       if(round($message->time/3600-time()/3600) + 48 <= 0)
	mysql_query("DELETE FROM `[messages]` WHERE `id`='{$message->id}'");
   }
      $dbres				= mysql_query("SELECT *,UNIX_TIMESTAMP(`signup`) AS `signup` FROM `[users]` WHERE `activated`='0'");
   while($activate = mysql_fetch_object($dbres)) {
       if(round($activate->signup/3600-time()/3600) + 48 <= 0)
	mysql_query("DELETE FROM `[users]` WHERE `id`='{$activate->id}'");
   }

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