[kes]

Hi all,

getting another issue when unregistered users finish the game, it gives them a database error as below. (i want unregistered to be able to play so thats ok)

Invalid SQL:
SELECT arcade_sessions.*, user.username, user.arcadeoptions FROM vb_arcade_sessions AS arcade_sessions
LEFT JOIN vb_user AS user ON (user.userid=arcade_sessions.userid)
WHERE arcade_sessions.valid=1 AND arcade_sessions.gameid=139 AND ()
ORDER BY score DESC, arcade_sessions.finish DESC
LIMIT 10;

MySQL 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 ')
ORDER BY score DESC, arcade_sessions.finish DESC
LIMIT 10' at line 3
Error Number : 1064
Date : Thursday, June 12th 2008 @ 12:37:37 PM