Jump to content
MakeWebGames

hour_cron.php HELP!!!

gideon prewett

By gideon prewett
in General Discussion

 Share

Recommended Posts

gideon prewett Newbie

gideon prewett

Posted
Posted

this is my hour cron basically my org crimes count down but in 2 hours rather than 1 and it go's in to - numbers

 

<?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;
$set=array();
$settq=$db->query("SELECT * FROM settings");
while($r=$db->fetch_row($settq))
{
$set[$r['conf_name']]=$r['conf_value'];
}
$db->query("UPDATE gangs SET gangCHOURS=gangCHOURS-1 WHERE gangCRIME>0",$c);
$q=$db->query("SELECT g.*,oc.* FROM gangs g LEFT JOIN orgcrimes oc ON g.gangCRIME=oc.ocID WHERE g.gangCRIME > 0 AND g.gangCHOURS = 0",$c);
while($r=mysql_fetch_row($q))
{
$suc=rand(0,1);
if($suc) {
$log=$r['ocSTARTTEXT'].$r['ocSUCCTEXT'];
$muny=(int) (rand($r['ocMINMONEY'],$r['ocMAXMONEY']));
$log=str_replace(array("{muny}","'"),array($muny,"''"),$log);
$db->query("UPDATE gangs SET gangMONEY=gangMONEY+$muny,gangCRIME=0 WHERE gangID={$r['gangID']}",$c);
$db->query("INSERT INTO oclogs VALUES ('',{$r['ocID']},{$r['gangID']}, '$log', 'success', $muny, '{$r['ocNAME']}', unix_timestamp())",$c);
$i=mysql_insert_id($c);
$qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}",$c);
while($rm=mysql_fetch_row($qm))
{
event_add($rm['userid'],"Your Gang's Organised Crime Succeeded. Go [url='oclog.php?ID=$i']here[/url] to view the details.",$c);
}
}
else
{
$log=$r['ocSTARTTEXT'].$r['ocFAILTEXT'];
$muny=0;
$log=str_replace(array("{muny}","'"),array($muny,"''"),$log);
$db->query("UPDATE gangs SET gangCRIME=0 WHERE gangID={$r['gangID']}",$c);
$db->query("INSERT INTO oclogs VALUES ('',{$r['ocID']},{$r['gangID']}, '$log', 'failure', $muny, '{$r['ocNAME']}', unix_timestamp())",$c);
$i=mysql_insert_id($c);
$qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}",$c);
while($rm=mysql_fetch_row($qm))
{
event_add($rm['userid'],"Your Gang's Organised Crime Failed. Go [url='oclog.php?ID=$i']here[/url] to view the details.",$c);
}
}
}
if(date('G')==17)
{
$db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET u.money=u.money+jr.jrPAY, u.exp=u.exp+(jr.jrPAY/20) 
WHERE u.job > 0 AND u.jobrank > 0");
$db->query("UPDATE userstats us LEFT JOIN users u ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET us.strength=(us.strength+1)+jr.jrSTRG-1,us.labour=(us.labour+1)+jr.jrLABOURG-1,us.IQ=(us.IQ+1)+jr.jrIQG-1 WHERE u.job > 0 AND u.jobrank > 0");
}
if($set['validate_period'] == 60 && $set['validate_on'])
{
$db->query("UPDATE users SET verified=0");
}
$db->query("UPDATE races SET rHOURS=rHOURS-1 WHERE rHOURS>0",$c);
$er=$db->query("SELECT * FROM races WHERE rHOURS=0",$c);
while($r=$db->fetch_row($er))
{
$oi=$db->query("SELECT i.*,h.* FROM pets i LEFT JOIN horses h ON h.hITEM=i.item_id WHERE i.item_id={$r['rHORSE1']} AND h.hUSERID={$r['rUSER1']}",$c) or die($db->error());
$io=$db->fetch_row($oi);
$qq=$db->query("SELECT i.*,h.* FROM pets i LEFT JOIN horses h ON h.hITEM=i.item_id WHERE i.item_id={$r['rHORSE2']} AND h.hUSERID={$r['rUSER2']}",$c) or die($db->error());
$q=$db->fetch_row($qq);
$h1=$io['Pet']+$io['hSPEED'];
$h2=$q['Pet']+$q['hSPEED'];
if($h1 > $h2)
{$win="1";}else{$win="2";}
$money=$r['rBET']*$r['rBETS'];
$racers=$money*0.1;
$mon=($racers/$r['rBETS'])+$r['rBET'];
$u1=$db->query("SELECT * FROM users WHERE userid={$r['rUSER1']}",$c) or die($db->error());
$u=$db->fetch_row($u1);
$u2=$db->query("SELECT * FROM users WHERE userid={$r['rUSER2']}",$c) or die($db->error());
$u3=$db->fetch_row($u2);
$ty=$db->query("SELECT * FROM betsmade WHERE bRACE={$r['rID']}",$c) or die($db->error());
while($yt=$db->fetch_row($ty))
{
if($yt['bHORSE'] == $win)
{
$db->query("UPDATE users SET money=money+$mon WHERE userid={$yt['bUSER']}",$c) or die($db->error());
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$yt['bUSER']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$yt['bUSER']},unix_timestamp(),0,'You bet on the dog fight between {$u['username']}\'s dog and {$u3['username']}\'s dog and won \${$mon}.')",$c) or die($db->error());
}
else
{
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$yt['bUSER']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$yt['bUSER']},unix_timestamp(),0,'You bet on the dog fight between {$u['username']}\'s dog and {$u3['username']}\'s dog and lost.')",$c) or die($db->error()); 
}
}
$db->query("UPDATE users SET money=money+$racers WHERE userid={$u3['userid']}",$c) or die($db->error());
if($win == 1)
{
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$u['userid']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$u['userid']},unix_timestamp(),0,'Your dog won the fight against {$u3['username']} and you won \${$racers} as a commission!')",$c) or die($db->error());
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$u3['userid']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$u3['userid']},unix_timestamp(),0,'Your dog lost the fight against {$u['username']} and you received \${$racers} as a commission!')",$c) or die($db->error());
}
else
{
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$u3['userid']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$u3['userid']},unix_timestamp(),0,'Your dog won the fight against {$u['username']} and you won \${$racers} as a commission!')",$c) or die($db->error());
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$u['userid']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$u['userid']},unix_timestamp(),0,'Your dog lost the fight against {$u3['username']} and you received \${$racers} as a commission!')",$c) or die($db->error());
}
$db->query("UPDATE users SET money=money+$racers WHERE userid={$u['userid']}",$c) or die($db->error());
print "Cron Done {$h1} {$h2}
";
$db->query("INSERT INTO racesdone VALUES('{$r['rID']}','{$r['rUSER1']}','{$r['rHORSE1']}','{$r['rUSER2']}','{$r['HORSE2']}',unix_timestamp(),'0','{$r['rBET']}','{$r['rBETS']}')",$c);
$db->query("DELETE FROM races WHERE rID={$r['rID']}",$c);
}
$qq=$db->query("SELECT * FROM horses WHERE hWATER=0 AND hFOOD=0 AND hHAPPY=0 AND hHEALTH=0",$c);
while($q=$db->fetch_row($qq))
{
$db->query("DELETE FROM horses WHERE hID={$q['hID']}",$c);
}

$db->query("UPDATE horses SET hWATER=hWATER-2 WHERE hWATER> 0");
$db->query("UPDATE horses SET hWATER=0 WHERE hWATER< 0");

$db->query("UPDATE horses SET hFOOD=hFOOD-4 WHERE hFOOD> 0");
$db->query("UPDATE horses SET hFOOD=0 WHERE hFOOD< 0");

$db->query("UPDATE horses SET hHAPPY=hHAPPY-5 WHERE hHAPPY> 0");
$db->query("UPDATE horses SET hHAPPY=0 WHERE hHAPPY< 0");
$db->query("UPDATE gangs SET gangCHOURS=gangCHOURS-1 WHERE gangCRIME>0",$c);



print"Done";

?>
Dayo Experienced

Dayo

Posted
Posted

Re: hour_cron.php HELP!!!

you have two

$db->query("UPDATE gangs SET gangCHOURS=gangCHOURS-1 WHERE gangCRIME>0",$c);

queries delet one of them (to finf press ctrl + F

  • 2 weeks later...
gideon prewett Newbie

gideon prewett

Posted
  • Author
Posted

Re: hour_cron.php HELP!!!

okay i have been trying to get this bloody cron working for months

i fixed the jobs at 1 point but now they don't work again and the org crimes count down but now they stop at 0 and don't finish any help would be good

 

<?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;
$set=array();
$settq=$db->query("SELECT * FROM settings");
while($r=$db->fetch_row($settq))
{
$set[$r['conf_name']]=$r['conf_value'];
}
$db->query("UPDATE gangs SET gangCHOURS=gangCHOURS-1 WHERE gangCHOURS > 0 AND gangCRIME>0",$c);
$q=$db->query("SELECT g.*,oc.* FROM gangs g LEFT JOIN orgcrimes oc ON g.gangCRIME=oc.ocID WHERE g.gangCRIME > 0 AND g.gangCHOURS = 0",$c);
while($r=mysql_fetch_row($q))
{
$suc=rand(0,1);
if($suc) {
$log=$r['ocSTARTTEXT'].$r['ocSUCCTEXT'];
$muny=(int) (rand($r['ocMINMONEY'],$r['ocMAXMONEY']));
$log=str_replace(array("{muny}","'"),array($muny,"''"),$log);
$db->query("UPDATE gangs SET gangMONEY=gangMONEY+$muny,gangCRIME=0 WHERE gangID={$r['gangID']}",$c);
$db->query("INSERT INTO oclogs VALUES ('',{$r['ocID']},{$r['gangID']}, '$log', 'success', $muny, '{$r['ocNAME']}', unix_timestamp())",$c);
$i=mysql_insert_id($c);
$qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}",$c);
while($rm=mysql_fetch_row($qm))
{
event_add($rm['userid'],"Your Gang's Organised Crime Succeeded. Go [url='oclog.php?ID=$i']here[/url] to view the details.",$c);
}
}
else
{
$log=$r['ocSTARTTEXT'].$r['ocFAILTEXT'];
$muny=0;
$log=str_replace(array("{muny}","'"),array($muny,"''"),$log);
$db->query("UPDATE gangs SET gangCRIME=0 WHERE gangID={$r['gangID']}",$c);
$db->query("INSERT INTO oclogs VALUES ('',{$r['ocID']},{$r['gangID']}, '$log', 'failure', $muny, '{$r['ocNAME']}', unix_timestamp())",$c);
$i=mysql_insert_id($c);
$qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}",$c);
while($rm=mysql_fetch_row($qm))
{
event_add($rm['userid'],"Your Gang's Organised Crime Failed. Go [url='oclog.php?ID=$i']here[/url] to view the details.",$c);
}
}
}
if(date('G')==17)
{
$db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET u.money=u.money+jr.jrPAY, u.exp=u.exp+(jr.jrPAY/20) 
WHERE u.job > 0 AND u.jobrank > 0");
$db->query("UPDATE userstats us LEFT JOIN users u ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET us.strength=(us.strength+1)+jr.jrSTRG-1,us.labour=(us.labour+1)+jr.jrLABOURG-1,us.IQ=(us.IQ+1)+jr.jrIQG-1 WHERE u.job > 0 AND u.jobrank > 0");
}
if($set['validate_period'] == 60 && $set['validate_on'])
{
$db->query("UPDATE users SET verified=0");
}
$db->query("UPDATE races SET rHOURS=rHOURS-1 WHERE rHOURS>0",$c);
$er=$db->query("SELECT * FROM races WHERE rHOURS=0",$c);
while($r=$db->fetch_row($er))
{
$oi=$db->query("SELECT i.*,h.* FROM pets i LEFT JOIN horses h ON h.hITEM=i.item_id WHERE i.item_id={$r['rHORSE1']} AND h.hUSERID={$r['rUSER1']}",$c) or die($db->error());
$io=$db->fetch_row($oi);
$qq=$db->query("SELECT i.*,h.* FROM pets i LEFT JOIN horses h ON h.hITEM=i.item_id WHERE i.item_id={$r['rHORSE2']} AND h.hUSERID={$r['rUSER2']}",$c) or die($db->error());
$q=$db->fetch_row($qq);
$h1=$io['Pet']+$io['hSPEED'];
$h2=$q['Pet']+$q['hSPEED'];
if($h1 > $h2)
{$win="1";}else{$win="2";}
$money=$r['rBET']*$r['rBETS'];
$racers=$money*0.1;
$mon=($racers/$r['rBETS'])+$r['rBET'];
$u1=$db->query("SELECT * FROM users WHERE userid={$r['rUSER1']}",$c) or die($db->error());
$u=$db->fetch_row($u1);
$u2=$db->query("SELECT * FROM users WHERE userid={$r['rUSER2']}",$c) or die($db->error());
$u3=$db->fetch_row($u2);
$ty=$db->query("SELECT * FROM betsmade WHERE bRACE={$r['rID']}",$c) or die($db->error());
while($yt=$db->fetch_row($ty))
{
if($yt['bHORSE'] == $win)
{
$db->query("UPDATE users SET money=money+$mon WHERE userid={$yt['bUSER']}",$c) or die($db->error());
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$yt['bUSER']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$yt['bUSER']},unix_timestamp(),0,'You bet on the dog fight between {$u['username']}\'s dog and {$u3['username']}\'s dog and won \${$mon}.')",$c) or die($db->error());
}
else
{
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$yt['bUSER']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$yt['bUSER']},unix_timestamp(),0,'You bet on the dog fight between {$u['username']}\'s dog and {$u3['username']}\'s dog and lost.')",$c) or die($db->error()); 
}
}
$db->query("UPDATE users SET money=money+$racers WHERE userid={$u3['userid']}",$c) or die($db->error());
if($win == 1)
{
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$u['userid']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$u['userid']},unix_timestamp(),0,'Your dog won the fight against {$u3['username']} and you won \${$racers} as a commission!')",$c) or die($db->error());
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$u3['userid']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$u3['userid']},unix_timestamp(),0,'Your dog lost the fight against {$u['username']} and you received \${$racers} as a commission!')",$c) or die($db->error());
}
else
{
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$u3['userid']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$u3['userid']},unix_timestamp(),0,'Your dog won the fight against {$u['username']} and you won \${$racers} as a commission!')",$c) or die($db->error());
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$u['userid']}",$c) or die($db->error());
$db->query("INSERT INTO events VALUES('',{$u['userid']},unix_timestamp(),0,'Your dog lost the fight against {$u3['username']} and you received \${$racers} as a commission!')",$c) or die($db->error());
}
$db->query("UPDATE users SET money=money+$racers WHERE userid={$u['userid']}",$c) or die($db->error());
print "Cron Done {$h1} {$h2}
";
$db->query("INSERT INTO racesdone VALUES('{$r['rID']}','{$r['rUSER1']}','{$r['rHORSE1']}','{$r['rUSER2']}','{$r['HORSE2']}',unix_timestamp(),'0','{$r['rBET']}','{$r['rBETS']}')",$c);
$db->query("DELETE FROM races WHERE rID={$r['rID']}",$c);
}
$qq=$db->query("SELECT * FROM horses WHERE hWATER=0 AND hFOOD=0 AND hHAPPY=0 AND hHEALTH=0",$c);
while($q=$db->fetch_row($qq))
{
$db->query("DELETE FROM horses WHERE hID={$q['hID']}",$c);
}

$db->query("UPDATE horses SET hWATER=hWATER-2 WHERE hWATER> 0");
$db->query("UPDATE horses SET hWATER=0 WHERE hWATER< 0");

$db->query("UPDATE horses SET hFOOD=hFOOD-4 WHERE hFOOD> 0");
$db->query("UPDATE horses SET hFOOD=0 WHERE hFOOD< 0");

$db->query("UPDATE horses SET hHAPPY=hHAPPY-5 WHERE hHAPPY> 0");
$db->query("UPDATE horses SET hHAPPY=0 WHERE hHAPPY< 0");




print"Done";

?>

 

please help :?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...