Gang OC cron hour error

Goatus · February 2, 2011

Hi i seem to have a problem with the cron hour file regarding gang OC's

Here is the error

Your gang decides to rob a drug dealer associated to a rival gang. drives to the street corner and jumps out with a gun...You drive to the dealer and get out. He''s got security and you start shooting but are clearly outgunned. You each take a bullet.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 1Query was update gangs set gangCRIME=0 where gangID=

And here is my gang table i hope someone kind can help would be appreciated

[mysql]-- Table structure for table `gangs`--

CREATE TABLE IF NOT EXISTS `gangs` ( `gangID` int(11) NOT NULL auto_increment, `gangNAME` varchar(255) NOT NULL default '', `gangDESC` text NOT NULL, `gangPREF` varchar(3) NOT NULL, `gangSUFF` varchar(12) NOT NULL default '', `gangMONEY` int(11) NOT NULL default '0', `gangCRYSTALS` int(11) NOT NULL default '0', `gangRESPECT` int(11) NOT NULL default '0', `gangPRESIDENT` int(11) NOT NULL default '0', `gangVICEPRES` int(11) NOT NULL default '0', `gangCAPACITY` int(11) NOT NULL default '0', `gangCRIME` int(11) NOT NULL default '0', `gangCHOURS` int(11) NOT NULL default '0', `gangAMENT` longtext NOT NULL, `gangSTATUS` enum('Peaceful','Aggressive') NOT NULL default 'Peaceful', `gangSTATUSDAYS` int(11) NOT NULL default '0', `gangIMAGE` varchar(300) NOT NULL, PRIMARY KEY (`gangID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; [/mysql]

Cron Hour

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;$fo=fopen("hospshouts.txt","w");fclose($fo);$fo=fopen("jailshouts.txt","w");fclose($fo);$set=array();$settq=$db->query("SELECT * FROM settings");while($r=$db->fetch_row($settq)){$set[$r['conf_name']]=$r['conf_value'];}



function event_add($userid,$text,$connection=0){global $db;$db->query("INSERT INTO events VALUES('',$userid,UNIX_TIMESTAMP(),0,'$text')");$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$userid}");return 1;}


$db->query("UPDATE gangs SET gangCHOURS=gangCHOURS-1 WHERE gangCRIME>0 AND gangCHOURS>0");$db->query("UPDATE oclist SET oclTIME=oclTIME-1 WHERE oclTIME > 0 ");
$q=$db->query("SELECT * FROM oclist ol               LEFT JOIN orgcrimes oc                ON ol.oclOC = oc.ocID               LEFT JOIN gangs g               ON g.gangID = ol.oclGANG               WHERE ol.oclTIME <= '0'") or die(mysql_error());
while($r=$db->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);$log.= "\n\nYou have gained " . number_format($r['ocRESPECT']) . " respect!";
for($i=1; $i<7; $i++){$crimeuser = "oclUSER" . $i;if($r[$crimeuser]){$usern = "user" . $i;$name = $db->query("SELECT username FROM users WHERE userid = {$r[$crimeuser]}");$n = $db->fetch_row($name);$log = str_replace('['.$usern.']', $n['username'], $log);}}echo $log;$db->query("UPDATE gangs SET gangMONEY=gangMONEY+$muny,gangRESPECT=gangRESPECT+{$r['ocRESPECT']},gangCRIME=0 WHERE gangID={$r['gangID']}");$db->query("INSERT INTO `oclogs` VALUES ('', {$r['ocID']}, {$r['gangID']}, '$log', 'success', $muny, '{$r['ocNAME']}', unix_timestamp(),'{$r['ocRESPECT']}')");$i=$db->insert_id();$qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}");while($rm = mysql_fetch_array($qm))    {        event_add($rm['userid'],"Your Gang\'s Organised Crime Succeeded. Go here to view the details.",$c);    }}

else{$log=$r['ocSTARTTEXT'].$r['ocFAILTEXT'];$muny=0;$log=str_replace(array("{muny}","'"),array($muny,"''"),$log);
for($i=1; $i<7; $i++){$crimeuser = "oclUSER" . $i;if($r[$crimeuser]){$usern = "user" . $i;$name = $db->query("SELECT username FROM users WHERE userid = {$r[$crimeuser]}");$n = $db->fetch_row($name);$log = str_replace('['.$usern.']', $n['username'], $log);}}echo $log;$db->query("update gangs set gangCRIME=0 where gangID={$r['gangID']}");$db->query("INSERT INTO `oclogs` VALUES ('', {$r['ocID']}, {$r['gangID']}, '$log', 'failure', $muny, '{$r['ocNAME']}', unix_timestamp(),'{$r['ocRESPECT']}')");

$i=$db->insert_id();$qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}");while($rm=$db->fetch_row($qm)){event_add($rm['userid'],"Your Gang\'s Organised Crime Failed. Go here to view the details.",$c);}}for($i=1; $i<7; $i++){$crimeuser = "oclUSER" . $i;if($r[$crimeuser]){ $db->query("UPDATE `users` SET `orgcrime` = '0' WHERE `userid` = $r[$crimeuser]");}}}$db->query("DELETE FROM `oclist` WHERE oclTIME <= '0'");?>

OClist

CREATE TABLE IF NOT EXISTS `oclist` (  `oclID` int(11) NOT NULL auto_increment,  `oclGANG` varchar(255) NOT NULL default '0',  `oclTIME` int(11) NOT NULL default '0',  `oclUSER1` int(11) NOT NULL default '0',  `oclUSER2` int(11) NOT NULL default '0',  `oclUSER3` int(11) NOT NULL default '0',  `oclUSER4` int(11) NOT NULL default '0',  `oclUSER5` int(11) NOT NULL default '0',  `oclUSER6` int(11) NOT NULL default '0',  `oclOC` int(11) NOT NULL default '0',  PRIMARY KEY  (`oclID`),  KEY `oclGANG` (`oclGANG`)) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=289 ;

Thanks

sniko · February 2, 2011

Post up the code from cron_hour.

-sniko

Goatus · February 2, 2011

Any more help please?

sniko · February 2, 2011

Try

<?phpinclude "config.php";global $_CONFIG;
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;$fo=fopen("hospshouts.txt","w");fclose($fo);$fo=fopen("jailshouts.txt","w");fclose($fo);$set=array();$settq=$db->query("SELECT * FROM settings");while($r=$db->fetch_row($settq)){$set[$r['conf_name']]=$r['conf_value'];}



function event_add($userid,$text,$connection=0){global $db;$db->query("INSERT INTO events VALUES('',$userid,UNIX_TIMESTAMP(),0,'$text')");$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$userid}");return 1;}


$db->query("UPDATE gangs SET gangCHOURS=gangCHOURS-1 WHERE gangCRIME>0 AND gangCHOURS>0");$db->query("UPDATE oclist SET oclTIME=oclTIME-1 WHERE oclTIME > 0 ");
$q=$db->query("SELECT * FROM oclist ol               LEFT JOIN orgcrimes oc                ON ol.oclOC = oc.ocID               LEFT JOIN gangs g               ON g.gangID = ol.oclGANG               WHERE ol.oclTIME <= '0'") or die(mysql_error());
while($r=$db->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);$log.= "\n\nYou have gained " . number_format($r['ocRESPECT']) . " respect!";
for($i=1; $i<7; $i++){$crimeuser = "oclUSER" . $i;if($r[$crimeuser]){$usern = "user" . $i;$name = $db->query("SELECT username FROM users WHERE userid = {$r[$crimeuser]}");$n = $db->fetch_row($name);$log = str_replace('['.$usern.']', $n['username'], $log);}}echo $log;$db->query("UPDATE gangs SET gangMONEY=gangMONEY+$muny,gangRESPECT=gangRESPECT+{$r['ocRESPECT']},gangCRIME=0 WHERE gangID={$r['gangID']}");$db->query("INSERT INTO `oclogs` VALUES ('', {$r['ocID']}, {$r['gangID']}, '$log', 'success', $muny, '{$r['ocNAME']}', unix_timestamp(),'{$r['ocRESPECT']}')");$i=$db->insert_id();$qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}");while($rm = mysql_fetch_array($qm))    {        event_add($rm['userid'],"Your Gang\'s Organised Crime Succeeded. Go <a href=\'oclog.php?ID=$i\'>here</a> to view the details.",$c);    }}

else{$log=$r['ocSTARTTEXT'].$r['ocFAILTEXT'];$muny=0;$log=str_replace(array("{muny}","'"),array($muny,"''"),$log);
for($i=1; $i<7; $i++){$crimeuser = "oclUSER" . $i;if($r[$crimeuser]){$usern = "user" . $i;$name = $db->query("SELECT username FROM users WHERE userid = {$r[$crimeuser]}");$n = $db->fetch_row($name);$log = str_replace('['.$usern.']', $n['username'], $log);}}echo $log;$db->query("update gangs set gangCRIME=0 where gangID={$r[oclGANG']}");$db->query("INSERT INTO `oclogs` VALUES ('', {$r['ocID']}, {$r['gangID']}, '$log', 'failure', $muny, '{$r['ocNAME']}', unix_timestamp(),'{$r['ocRESPECT']}')");

$i=$db->insert_id();$qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}");while($rm=$db->fetch_row($qm)){event_add($rm['userid'],"Your Gang\'s Organised Crime Failed. Go <a href=\'oclog.php?ID=$i\'>here</a> to view the details.",$c);}}for($i=1; $i<7; $i++){$crimeuser = "oclUSER" . $i;if($r[$crimeuser]){ $db->query("UPDATE `users` SET `orgcrime` = '0' WHERE `userid` = $r[$crimeuser]");}}}$db->query("DELETE FROM `oclist` WHERE oclTIME <= '0'");?>

Diesl · February 2, 2011

I'm pretty sure that since the cron_hour code is not able to reference the gangID that the problem lies with this line:

$q=$db->query("SELECT * FROM oclist ol LEFT JOIN orgcrimes oc ON ol.oclOC = oc.ocID LEFT JOIN gangs g ON g.gangID = ol.oclGANG WHERE ol.oclTIME <= '0'") or die(mysql_error());

use this instead

$q=$db->query("SELECT ol.*, g.gangID FROM oclist ol LEFT JOIN orgcrimes oc ON ol.oclOC = oc.ocID LEFT JOIN gangs g ON g.gangID = ol.oclGANG WHERE ol.oclTIME <= '0'") or die(mysql_error());

Goatus · February 3, 2011

That

I'm pretty sure that since the cron_hour code is not able to reference the gangID that the problem lies with this line:

$q=$db->query("SELECT * FROM oclist ol LEFT JOIN orgcrimes oc ON ol.oclOC = oc.ocID LEFT JOIN gangs g ON g.gangID = ol.oclGANG WHERE ol.oclTIME <= '0'") or die(mysql_error());

use this instead

$q=$db->query("SELECT ol.*, g.gangID FROM oclist ol LEFT JOIN orgcrimes oc ON ol.oclOC = oc.ocID LEFT JOIN gangs g ON g.gangID = ol.oclGANG WHERE ol.oclTIME <= '0'") or die(mysql_error());

Hi mate that did not work. Also sniko cant seem to use your code as when i copy it its all messed up and squashed together lol

Sign In

Gang OC cron hour error

Recommended Posts

Goatus

sniko

Goatus

sniko

Diesl

Goatus

Join the conversation

Browse

Activity

Hosting