[MikaK]

Originally Posted by Dechevious

"games SET highscorerid=," this is your problem.

If your allowing guests to play, it cannot register a highscorerid because they have no id. You can either disallow visitors from playing, or, you can place an id check prior to the score write, to fix that.

If their not logged in, they shouldnt be able to play anyway. Thats your best bet.

I have the same problem. Here's the error message:

PHP Code:

Database error in vBulletin 3.0.3:
 
Invalid SQL: UPDATE scllgames SET highscorerid=,highscore=82 WHERE 
shortname='homerun'
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 'highscore=82 WHERE shortname='homerun'' at line 1
 
mysql error number: 1064
 
Date: Sunday 23rd of January 2005 12:39:24 AM
Script: http://www.soundchilds.net/loud_lounge/cron.php?&rand=395242
Referer: http://www.soundchilds.net/loud_lounge/statistic.php?do=spider
Username: MikaK
IP Address: XXX 


When I tried to look into disabling guest play I couldn?t find which
option to change. General options are currently set as below:

Is the Arcade Active?
If not, only Administrators will be able to view the arcade Yes

Is netPlay Installed?
Enables multiplayer gaming if netPlay is installed No

Display Arcade Awards in Postbit?
If enabled, highest scorers will have awards displayed in their postbit templates. Yes

Allow Quick Registration?
Prompts to register if an unregistered user tries to play Yes

Enable Automatic Score Pruning?
Auto-prune options can be found in the "Score Settings" section No

User's Highest Scores Only?
Only the a user's highest score will be listed in the leaderboards (IN DEVELOPMENT) No

vBCode Enabled in Comments?
Allows users to use vBCode in their comments Yes

IMG Code Enabled in Comments?
Allows users to post images in their comments, not recommended No

Smilies Enabled in Comments?
Allows users to use smilies in their comments Yes

Allow Email Notification?
Allows users to enable email notification for arcade events Yes

Allow Challenge Results in High Scores?
Challenge scores will appear in the leaderboards. No

What code should I use for the id check prior to the score write?

Thanks for any hints.

-Mika