Cron

[Saberman]

Does anyone know what is the problem with this cron

this is the error i get when i run it.

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Query was SELECT * FROM rentals WHERE reRENTER=

 

<?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("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.jobpoints=u.jobpoints+jr.jrPOINTS, 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");
$db->query("DELETE FROM fedjail WHERE fed_days=0");
$db->query("UPDATE users SET userCONTRACT = userCONTRACT - 1 WHERE userCONTRACT > 0");
$db->query("UPDATE users SET userBANKAMMT = userBANKAMMT + (userBANKAMMT/100*5.5) WHERE userBANKAMMT > 0 AND investlevel = 1");
$db->query("UPDATE users SET userBANKAMMT = userBANKAMMT + (userBANKAMMT/100*3.0) WHERE userBANKAMMT > 0 AND investlevel = 0");
$db->query("UPDATE users SET userBANKAMMT = userBANKAMMT + (userBANKAMMT/100*7.2) WHERE userBANKAMMT > 0 AND investlevel = 2");
$db->query("UPDATE users SET userDAYS=userDAYS-1 WHERE userDAYS>0");
$db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0");
$db->query("UPDATE users SET daysold=daysold+1, tired='0', 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=cdays-1 WHERE course > 0");
$db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/200) where bankmoney>0");
$db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>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("UPDATE rentals set reDAYS=reDAYS-1");
$io=$db->query("SELECT * FROM users where rent>0");
$hu=$db->fetch_row($io);
$gd=$db->query("SELECT * FROM rentals WHERE reRENTER={$hu['userid']}");
$hd=$db->fetch_row($gd);
$db->query("UPDATE users set money=money-{$hd['reCOST']} WHERE userid={$hd['reRENTER']}");
$q=$db->query("SELECT * FROM rentals WHERE reDAYS=0");
$ids=array();
while($r=$db->fetch_row($q))
{
if (!$r['reDAYS'])
{
$rf=$db->query("SELECT * FROM properties WHERE prID={$r['rePID']}");
$gf=$db->fetch_row($rf);
$db->query("DELETE FROM properties WHERE prID={$r['rePID']}");
$db->query("UPDATE users SET rent=0 WHERE userid={$r['reRENTER']}");
$db->query("INSERT INTO `properties` (`prID`, `prOWNER`, `prHOUSE`) VALUES
('{$r['rePID']}', '{$r['reOWNER']}', '{$gf['prHOUSE']}');",$c);
$db->query("DELETE FROM rentals WHERE reDAYS=0");
}
}
?>

[Strats]

Re: Cron

Not sure about it all but at the end I think you could have it like :

 

$db->query("DELETE FROM rentals WHERE reDAYS=0");
}
?>

[Saberman]

Re: Cron

Parse error: syntax error, unexpected $end in /home/shafiq/public_html/ImPoRtAnT/cron_day.php on line 103

[Strats]

Re: Cron

Take out the } at the end and see if it's any better

Where do you get the error?

What page meaning.

[shrek1609]

Re: Cron

i think your problem is here...

 

$io=$db->query("SELECT * FROM users where rent>0");
$hu=$db->fetch_row($io);
$gd=$db->query("SELECT * FROM rentals WHERE reRENTER={$hu['userid']}");
$hd=$db->fetch_row($gd);

 

i think the first query is pulling up a blank result so then the second query can't run...