gurpreet Posted October 20, 2007 Posted October 20, 2007 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.