03laceys Posted August 23, 2008 Share Posted August 23, 2008 i am having a slight problem with my voting and schools... They are not resetting. <?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=0 WHERE userid IN(".implode(",", $ids).")"); } $db->query("DELETE FROM fedjail WHERE fed_days=0"); $db->query("UPDATE users SET log=log-1 WHERE log > 0"); $db->query("UPDATE users SET gymp=gymp-1 WHERE gymp > 0"); $db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0"); $db->query("UPDATE users SET daysold=daysold+1"); $db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0"); $db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0"); $db->query("UPDATE users SET daysmarried=daysmarried+1 WHERE married > 0"); $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0"); $db->query("UPDATE users SET course=0 WHERE cdays=0"); $db->query("TRUNCATE TABLE votes"); $db->query("TRUNCATE TABLE rating"); $db->query("UPDATE users SET boxes_opened=0"); $db->query("UPDATE passreset SET time=time-1 WHERE time > 0") or die(mysql_error()); $db->query("DELETE FROM passreset WHERE time<=0") or die(mysql_error()); $db->query("UPDATE users SET bankmoney=bankmoney*bankpercent+bankmoney WHERE bankmoney>0 AND laston>unix_timestamp()-432000"); $db->query("UPDATE users SET banklevel=1 WHERE bankmoney>0"); $db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) WHERE cybermoney>0 laston>unix_timestamp()-432000"); $db->query("UPDATE users set ttime=ttime-1 WHERE ttime>0"); $q=$db->query("SELECT * FROM users WHERE cdays=0 AND course > 0"); 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!')")"); } ?> Any help? Quote Link to comment Share on other sites More sharing options...
Floydian Posted August 23, 2008 Share Posted August 23, 2008 Re: Cron trouble? You've got a syntax error at the very end there Replace this: $db->query("INSERT INTO events VALUES("$userid,unix_timestamp(),0,'Congratulations, you completed the {$coud['crNAME']} and gained $ev!')")"); } ?> With this: $db->query("INSERT INTO events VALUES($userid,unix_timestamp(),0,'Congratulations, you completed the {$coud['crNAME']} and gained $ev!')"); } ?> And see if that doesn't fix it. Quote Link to comment Share on other sites More sharing options...
03laceys Posted August 23, 2008 Author Share Posted August 23, 2008 Re: Cron trouble? thank you will edit and re-upload now and we will find out tomorrow. Thank you. Quote Link to comment Share on other sites More sharing options...
Zero-Affect Posted August 23, 2008 Share Posted August 23, 2008 Re: Cron trouble? i have the weirdest cron problem ever no errors runs perfectly when i manually run it but the cron jobs wow another story only runs about 1/4 of the coding and it runs one of them twice lol but my hosting insists its my problem lol any pointers? Quote Link to comment Share on other sites More sharing options...
Floydian Posted August 23, 2008 Share Posted August 23, 2008 Re: Cron trouble? Check your cron logs? Register an error handler so you can log any errors that might be missed by the cpanel error deal (that deal gets you fatal errors, but not necessarily minor errors) Send cron output to an email you can check (do this from cpanel) OR alternatively, you can put in some debug type echoes through your cron file, snatch them all up using an output buffer, and mail them to an email (this is done completely from within your cron) Quote Link to comment Share on other sites More sharing options...
Zero-Affect Posted August 23, 2008 Share Posted August 23, 2008 Re: Cron trouble? Oh wait i understand lol Quote Link to comment Share on other sites More sharing options...
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.