None of my crons_day work except streets :'(

[gurpreet]

Ok all my crons_day dont work except for the streets, which i just added. I ot someone to set my game up for me, so if anything is wrong please tell me. Thanks

 

crons_day

 

<?php

include "config.php";

global $_CONFIG;

if($_GET['code'] != $_CONFIG['code']) { die(""); }

define("MONO_ON", 1);

require "class/class_db_{$_CONFIG['driver']}.php";

$db=new database;

$db->configure($_CONFIG['hostname'],

$_CONFIG['username'],

$_CONFIG['password'],

$_CONFIG['database'],

$_CONFIG['persistent']);

$db->connect();

$c=$db->connection_id;

$db->query("UPDATE fedjail set fed_days=fed_days-1");

$q=$db->query("SELECT * FROM fedjail WHERE fed_days=0");

$ids=array();

while($r=$db->fetch_row($q))

{

$ids[]=$r['fed_userid'];

}

if(count($ids) > 0)

{

$db->query("UPDATE users SET fedjail=1 WHERE userid IN(".implode (",", $ids).")");

}

$db->query("DELETE FROM fedjail WHERE fed_days=0");

$db->query("UPDATE users SET crystals=100", $c);

$db->query("UPDATE users SET turns=100");

$db->query("UPDATE users SET tokens=100", $c);

$db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 1");

$db->query("UPDATE users SET daysold=daysold+1, boxes_opened=1");

$db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 1");

$db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 1");

$db->query("UPDATE users SET cdays=cdays-1 WHERE course > 1");

$db->query("UPDATE passreset SET time=time-1 WHERE time > 1",$c) or die(mysql_error());

$db->query("DELETE FROM passreset WHERE time<=0",$c) or die(mysql_error());

$db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>1");

$db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>1");

$db->query("UPDATE users SET investmentbank=investmentbank+(investmentbank/100*7) where investmentbank>1");

$db->query("UPDATE users SET gymp=gymp-1 WHERE gymp > 1",$c);

$q=$db->query("SELECT * FROM users WHERE cdays=0 AND course > 1");

while($r=$db->fetch_row($q))

{

$cd=$db->query("SELECT * FROM courses WHERE crID={$r['course']}");

$coud=$db->fetch_row($cd);

$userid=$r['userid'];

$db->query("INSERT INTO coursesdone VALUES({$r['userid']},{$r['course']})");

$upd="";

$ev="";

if($coud['crSTR'] > 0)

{

$upd.=",us.strength=us.strength+{$coud['crSTR']}";

$ev.=", {$coud['crSTR']} strength";

}

if($coud['crGUARD'] > 0)

{

$upd.=",us.guard=us.guard+{$coud['crGUARD']}";

$ev.=", {$coud['crGUARD']} guard";

}

if($coud['crLABOUR'] > 0)

{

$upd.=",us.labour=us.labour+{$coud['crLABOUR']}";

$ev.=", {$coud['crLABOUR']} labour";

}

if($coud['crAGIL'] > 0)

{

$upd.=",us.agility=us.agility+{$coud['crAGIL']}";

$ev.=", {$coud['crAGIL']} agility";

}

if($coud['crIQ'] > 0)

{

$upd.=",us.IQ=us.IQ+{$coud['crIQ']}";

$ev.=", {$coud['crIQ']} IQ";

}

$ev=substr($ev,1);

if ($upd) {

$db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid SET us.userid=us.userid $upd WHERE u.userid= $userid");

}

$db->query("INSERT INTO events VALUES('',$userid,unix_timestamp(),0,'Congratulations, you completed the {$coud['crNAME']} and gained $ev!')");

}

$db->query("UPDATE users SET course=0 WHERE cdays=0");

$db->query("TRUNCATE TABLE votes");

?>

Please help me. Thanks