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
