crystal market

[montyash]

when i try to buy crystals it says this can any 1 help

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 'where userid=1' at line 1

Query was UPDATE users SET crystals=crystals+ where userid=1

[Ragnar]

Re: crystal market

Go to function crystal_buy

It should be...

$db->query("UPDATE users SET crystals=crystals+{$r['cmQTY']} where userid=$userid");

if that's what it currently is, try

$db->query("UPDATE users SET crystals=crystals+'{$r['cmQTY']}' where userid=$userid");

{$r['cmQTY']} is what's not being registered.

[montyash]

Re: crystal market

nice try but they dnt work

[AlabamaHit]

Re: crystal market

post your query...in the buy function