Help With Crons If Anyone Could ..

[moyles]

hey :)

well my daily cron isnt working rigth as it is taken away the ddays and the vip days but it is not resetting nothing like the streets

can anyone help me ??

[Danny]

Re: Help With Crons If Anyone Could ..

hit me up on msn [email protected] and ill have a look at em

[Klikoka]

Re: Help With Crons If Anyone Could ..

Or PM Me For Help

[Danny]

Re: Help With Crons If Anyone Could ..

ive had a look at this cron and done it this is what is now is

 

<?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;




// FED JAIL UPDATE
$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");
// END FED JAIL UPDATE

$db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0");
$db->query("UPDATE users SET VIPdays=VIPdays-1 WHERE VIPdays > 0");
$db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0");
$db->query("UPDATE users SET daysold=daysold+1 WHERE daysold > 0");
$db->query("UPDATE users SET boxes_opened=0");
$db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0");
$db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0");
$db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney > 0");
$db->query("UPDATE users SET cbank=cbank+(cbank/50) where cbank>0 AND daysinactive > 7");
$db->query("UPDATE `marriages` SET `marriage_days` = `marriage_days` + '1'");
$db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*6) where cybermoney>0 AND daysinactive >7"); 
$db->query("TRUNCATE TABLE voting;");
$db->query("UPDATE users SET turns=100");
$db->query("UPDATE users SET ctempleturns=0");
$db->query("UPDATE users SET csmuggling=csmuggling+10 WHERE csmuggling > 0");
$db->query("UPDATE users SET log=log-1 WHERE log > 0",$c);
//START EDUCATION
$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");
// END EDUCATION



?>

[supernova800]

Re: Help With Crons If Anyone Could ..

 

ive had a look at this cron and done it this is what is now is

 

<?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;




// FED JAIL UPDATE
$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");
// END FED JAIL UPDATE

$db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0");
$db->query("UPDATE users SET VIPdays=VIPdays-1 WHERE VIPdays > 0");
$db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0");
$db->query("UPDATE users SET daysold=daysold+1 WHERE daysold > 0");
$db->query("UPDATE users SET boxes_opened=0");
$db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0");
$db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0");
$db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney > 0");
$db->query("UPDATE users SET cbank=cbank+(cbank/50) where cbank>0 AND daysinactive > 7");
$db->query("UPDATE `marriages` SET `marriage_days` = `marriage_days` + '1'");
$db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*6) where cybermoney>0 AND daysinactive >7"); 
$db->query("TRUNCATE TABLE voting;");
$db->query("UPDATE users SET turns=100");
$db->query("UPDATE users SET ctempleturns=0");
$db->query("UPDATE users SET csmuggling=csmuggling+10 WHERE csmuggling > 0");
$db->query("UPDATE users SET log=log-1 WHERE log > 0",$c);
//START EDUCATION
$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");
// END EDUCATION



?>

 

This is what I have, identical, but when the course day = 0 it just stops there and wont end the course. Just says you are currently busy and have 0 days remaining...