Cron Problem

[Sethenor2]

Hi i bought a modification not so long ago but unfortunately it doesn't work so i was hoping the community would help

The error is

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 `dealer_global` WHERE `D_userid` =

 

And the cron code

<?php
include "globals.php";
global $_CONFIG;

define("MONO_ON", 1);
require "class/class_db_mysql.php";
$db = new database;
$db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']);
$db->connect();
$c = $db->connection_id;










//add drugs
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(10,20)." WHERE drugID=1");
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(5,15)." WHERE drugID=2");
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(10,15)." WHERE drugID=3");
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(5,10)." WHERE drugID=4");
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(5,10)." WHERE drugID=5");
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(5,10)." WHERE drugID=6");



$addheat = mt_rand(0,5);
$info = $db->query("SELECT * FROM `dealer_global` WHERE `D_userid` = ".$userid);
if(!$db->num_rows($info)) {
echo "Invalid source";
exit;
}
$user = $db->fetch_row($info);
if($user['heat'] > 5) {
$db->query("UPDATE dealer_global SET heat = heat - 5 WHERE D_userid = ".$userid);
}
if($user['addiction'] > 5) {
$db->query("UPDATE dealer_global SET addiction = addiction - 5 WHERE D_userid = ".$userid);
}

if(!$user['martime'] || $user['martime'] < 0) {
$db->query("UPDATE dealer_global SET martime = - 1, marijuana = marijuana + 1, heat = heat + $addheat WHERE D_userid = ".$userid);
event_add($userid,"You finished growing your marijuana.");
} else {
$db->query("UPDATE dealer_global SET martime = martime - 1 WHERE D_userid = ".$userid);
}
if(!$user['coketime'] || $user['coketime'] < 0) {
$db->query("UPDATE dealer_global SET coketime = - 1, cocaine = cocaine + 1, heat = heat + $addheat WHERE D_userid = ".$userid);
event_add($userid,"You finished making cocaine.");
} else {
$db->query("UPDATE dealer_global SET coketime = coketime - 1 WHERE D_userid = ".$userid);
}
if(!$user['acidtime'] || $user['acidtime'] < 0) {
$db->query("UPDATE dealer_global SET acidtime = - 1, acid = acid + 1, heat = heat + $addheat WHERE D_userid = ".$userid);
event_add($userid,"You finished making acid.");
} else {
$db->query("UPDATE dealer_global SET acidtime = acidtime - 1 WHERE D_userid = ".$userid);
}
if(!$user['etime'] || $user['etime'] < 0) {
$db->query("UPDATE dealer_global SET etime = - 1, ecstasy = ecstasy + 1, heat = heat + $addheat WHERE D_userid = ".$userid);
event_add($userid,"You finished making ecstasy.");
} else {
$db->query("UPDATE dealer_global SET etime = etime - 1 WHERE D_userid = ".$userid);
}
if(!$user['herointime'] || $user['herointime'] < 0) {
$db->query("UPDATE dealer_global SET herointime = - 1, heroin = heroin + 1, heat = heat + $addheat WHERE D_userid = ".$userid);
event_add($userid,"You finished making heroin.");
} else {
$db->query("UPDATE dealer_global SET herointime = herointime - 1 WHERE D_userid = ".$userid);
}
if(!$user['methtime'] || $user['methtime'] < 0) {
$db->query("UPDATE dealer_global SET methtime = - 1, meth = meth + 1, heat = heat + $addheat WHERE D_userid = ".$userid);
event_add($userid,"You finished making meth.");
} else {
$db->query("UPDATE dealer_global SET methtime = methtime - 1 WHERE D_userid = ".$userid);
}

?>

 

and the database table

[mysql]CREATE TABLE IF NOT EXISTS `dealer_global` (

`Did` int(11) NOT NULL AUTO_INCREMENT,

`D_userid` int(11) NOT NULL DEFAULT '0',

`suitcase` tinyint(1) unsigned NOT NULL DEFAULT '0',

`marijuana` bigint(11) NOT NULL DEFAULT '0',

`cocaine` bigint(11) NOT NULL DEFAULT '0',

`acid` bigint(11) NOT NULL DEFAULT '0',

`ecstasy` bigint(11) NOT NULL DEFAULT '0',

`heroin` bigint(11) NOT NULL DEFAULT '0',

`meth` bigint(11) NOT NULL DEFAULT '0',

`addiction` bigint(11) NOT NULL DEFAULT '0',

`heat` bigint(11) NOT NULL DEFAULT '0',

`martime` tinyint(11) NOT NULL DEFAULT '-1',

`coketime` tinyint(11) NOT NULL DEFAULT '-1',

`acidtime` tinyint(11) NOT NULL DEFAULT '-1',

`etime` tinyint(11) NOT NULL DEFAULT '-1',

`herointime` tinyint(11) NOT NULL DEFAULT '-1',

`methtime` tinyint(11) NOT NULL DEFAULT '-1',

`tutorial` tinyint(11) NOT NULL DEFAULT '0',

`supply1` tinyint(1) unsigned NOT NULL DEFAULT '0',

`supply2` tinyint(1) unsigned NOT NULL DEFAULT '0',

`supply3` tinyint(1) unsigned NOT NULL DEFAULT '0',

`supply4` tinyint(1) unsigned NOT NULL DEFAULT '0',

`supply5` tinyint(1) unsigned NOT NULL DEFAULT '0',

`supply6` tinyint(1) unsigned NOT NULL DEFAULT '0',

PRIMARY KEY (`Did`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

[/mysql]

[Oo-Savage-oO]

u can try this not sure it will work though did it in a huryy

 

<?php
include "globals.php";











//add drugs
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(10,20)." WHERE drugID=1");
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(5,15)." WHERE drugID=2");
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(10,15)." WHERE drugID=3");
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(5,10)." WHERE drugID=4");
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(5,10)." WHERE drugID=5");
$db->query("UPDATE dealer_data SET drugAMOUNT = ".mt_rand(5,10)." WHERE drugID=6");



$addheat = mt_rand(0,5);
$info = $db->query("SELECT * FROM `dealer_global` WHERE `D_userid` = $userid");
if(!$db->num_rows($info)) {
echo "Invalid source";
exit;
}
$user = $db->fetch_row($info);
if($user['heat'] > 5) {
$db->query("UPDATE dealer_global SET heat = heat - 5 WHERE D_userid = $userid");
}
if($user['addiction'] > 5) {
$db->query("UPDATE dealer_global SET addiction = addiction - 5 WHERE D_userid = $userid");
}

if(!$user['martime'] || $user['martime'] < 0) {
$db->query("UPDATE dealer_global SET martime = - 1, marijuana = marijuana + 1, heat = heat + $addheat WHERE D_userid = $userid");
event_add($userid,"You finished growing your marijuana.");
} else {
$db->query("UPDATE dealer_global SET martime = martime - 1 WHERE D_userid = $userid");
}
if(!$user['coketime'] || $user['coketime'] < 0) {
$db->query("UPDATE dealer_global SET coketime = - 1, cocaine = cocaine + 1, heat = heat + $addheat WHERE D_userid = $userid");
event_add($userid,"You finished making cocaine.");
} else {
$db->query("UPDATE dealer_global SET coketime = coketime - 1 WHERE D_userid = $userid");
}
if(!$user['acidtime'] || $user['acidtime'] < 0) {
$db->query("UPDATE dealer_global SET acidtime = - 1, acid = acid + 1, heat = heat + $addheat WHERE D_userid = $userid");
event_add($userid,"You finished making acid.");
} else {
$db->query("UPDATE dealer_global SET acidtime = acidtime - 1 WHERE D_userid = $userid");
}
if(!$user['etime'] || $user['etime'] < 0) {
$db->query("UPDATE dealer_global SET etime = - 1, ecstasy = ecstasy + 1, heat = heat + $addheat WHERE D_userid = $userid");
event_add($userid,"You finished making ecstasy.");
} else {
$db->query("UPDATE dealer_global SET etime = etime - 1 WHERE D_userid = $userid");
}
if(!$user['herointime'] || $user['herointime'] < 0) {
$db->query("UPDATE dealer_global SET herointime = - 1, heroin = heroin + 1, heat = heat + $addheat WHERE D_userid = $userid");
event_add($userid,"You finished making heroin.");
} else {
$db->query("UPDATE dealer_global SET herointime = herointime - 1 WHERE D_userid = $userid");
}
if(!$user['methtime'] || $user['methtime'] < 0) {
$db->query("UPDATE dealer_global SET methtime = - 1, meth = meth + 1, heat = heat + $addheat WHERE D_userid = $userid");
event_add($userid,"You finished making meth.");
} else {
$db->query("UPDATE dealer_global SET methtime = methtime - 1 WHERE D_userid = $userid");
}

?>

[lucky3809]

$db->query("SELECT * FROM `dealer_global` WHERE `D_userid` = ".$userid);

that dont look right the ". by $userid take that part off and just leave $userid

[Kieran-R]

Theres nothing wrong with ".$userid itself.

But you may not be defining $userid anywhere.

Try using $_SESSION['id'], or $ir['userid']

[rulerofzu]

This is a cron so not something being used by a player. Therefore where would it get a userid from? which is your error. There is no user.

So you either need to grab all the users involved so it has ID's.