Jump to content
MakeWebGames

crystal market


montyash

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 4 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...