PDA

Click to See Complete Forum and Search --> : hhhmmm... a script problem has arrized...

Sexay_Hamster
11-19-2003, 05:51 PM
well its a thing that lets people pay 1500 shockz(money on my boards) to change there title. when i do it tho it automatically sets my shockz to -4138 instead of subtracting 1500...

here is the code:

if($action)
{
$sql = "UPDATE ".TABLE_USERS." SET title = '" . $title . "' WHERE displayname = '" . $userdata[displayname] . "'";

$exe = mysql_query($sql);

$query = "SELECT shockz FROM ".TABLE_USERS." WHERE displayname = '" . $userdata[displayname] . "'";

$shockz = mysql_query($query) or die(mysql_error());

$spent_shockz = $shockz - 1500;

$query = "UPDATE ".TABLE_USERS." SET shockz ='".$spent_shockz."' WHERE displayname = '" . $userdata[displayname] . "'";

mysql_query($query) or die(mysql_error());
pyro
11-19-2003, 06:05 PM
The logic is a bit off. Try it like this:

<?PHP
$sql = "UPDATE ".TABLE_USERS." SET title = '" . $title . "' WHERE displayname = '" . $userdata[displayname] . "'";
$exe = mysql_query($sql);
$query = "SELECT shockz FROM ".TABLE_USERS." WHERE displayname = '" . $userdata[displayname] . "'";
$results = mysql_query($query) or die(mysql_error());
$data = mysql_fetch_array($results, MYSQL_ASSOC);
$shockz = $data['shockz'];
$spent_shockz = $shockz - 1500;
$query = "UPDATE ".TABLE_USERS." SET shockz ='".$spent_shockz."' WHERE displayname = '" . $userdata[displayname] . "'";
mysql_query($query) or die(mysql_error());
?>
Sexay_Hamster
11-19-2003, 10:03 PM
w00t!!! w00t!!!

it works :D

thanx pyro :D
pyro
11-19-2003, 10:20 PM
Happy to help. :)