Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[xTRUTECHNIQUEx]

This error just kind of showed up so to speak. At 1st i never got this but now everytime I leave a player I get this error.

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 exp=exp+0, WHERE userid=1

[Danny696]

remove the , before WHERE

[ReignFire]

that should do it!

[Danny696]

The point of posting that was.....

[mentaljason]

It needs the wehere =1 other wise no one will ever get exp, maybe it's "," before the where?

[JoshuaDams]

Query was UPDATE users SET exp=exp+0, WHERE userid=1

$db->query("UPDATE users SET exp=exp+0 WHERE userid=1");

Wth is that even for? lol

That's like saying..

run a HUGE query and Set EVERYONES EXP to what their XP already is.

See the humor in this ?

[Danny696]

LMAFO