Godhand Posted October 10, 2007 Share Posted October 10, 2007 I was adding in features in the game adding in 2 extra donator crons in my five min cron to find that my cron day file decided to stop working. No output just isn't working. I haven't done anything in that file itself in a while. <?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 daysingang=daysingang+1 WHERE gang > 0"); $db->query("UPDATE users SET daysold=daysold+1, boxes_opened=0"); $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 cdays=1 WHERE course > 0 AND cdays<-1"); $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0"); $db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney*(2/100)) WHERE bankmoney>0"); $db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney*(8/100)) WHERE cybermoney>0"); $db->query("UPDATE users SET donatorcrystalbank=donatorcrystalbank+(donatorcrystalbank*(1/10)) WHERE donatorcrystalbank>0"); $db->query("UPDATE users SET ultramoney=ultramoney+(ultramoney*(30/100)) WHERE ultramoney>0"); $db->query("UPDATE users SET dmoney=dmoney+(dmoney*(14/100)) WHERE dmoney>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!')"); } $db->query("UPDATE users SET course=0 WHERE cdays=0"); $db->query("TRUNCATE TABLE votes;"); Quote Link to comment Share on other sites More sharing options...
Will Posted October 11, 2007 Share Posted October 11, 2007 Re: (v2 cron stop working) I don't see any ?> at the end. Perhaps that is it. Quote Link to comment Share on other sites More sharing options...
Godhand Posted October 11, 2007 Author Share Posted October 11, 2007 Re: (v2 cron stop working) I see that could be weird though because it got deleted also before I pasted it from a back up. Also how could I run this manually to check? I've been wondering that a while. I know I could set it in my cron jobs for now but besides that is there any way? Quote Link to comment Share on other sites More sharing options...
Will Posted October 12, 2007 Share Posted October 12, 2007 Re: (v2 cron stop working) You just copy the url n the cron table remove the "curl " at the beginning and put it in you address bar. Quote Link to comment Share on other sites More sharing options...
Godhand Posted October 12, 2007 Author Share Posted October 12, 2007 Re: (v2 cron stop working) Ty apparently that was all that was wrong. Although I still don't know how it originally got deleted.. any guesses? 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.