[skhms]

You have found some bugs it looks like

Originally Posted by kes

Can anyone help with this..

ive installed this add on just fine, but i want guests to be able to play aswell.

but they are getting this message

"you need to have a reputation of at least 0 points. Your current reputation stands at points"

I thought setting this to zero in unregistered guests permissions would allow them to play - am i missing something ?

I fixed it this way
In arcade.php, find:

PHP Code:

$vbulletin->userinfo['posts'] = 0; 


Below it add:

PHP Code:

$vbulletin->userinfo['reputation'] = 0 


Originally Posted by 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

This one I have never seen before. It seems that it will occur when a guest plays and there is no score since before. When you have one score this will not be a issue any more.
But I guess it could be fixed this way:
In arcade.php, find:

PHP Code:

        $scores = $db->query_read("SELECT arcade_sessions.*, user.username, user.arcadeoptions FROM " . TABLE_PREFIX . "arcade_sessions AS arcade_sessions
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid=arcade_sessions.userid)
        WHERE arcade_sessions.valid=1 AND arcade_sessions.gameid=$game[gameid] AND ($scorecache)
        ORDER BY score " . iif($game['isreverse']==1, 'ASC', 'DESC') . ", arcade_sessions.finish DESC
        LIMIT " . $vbulletin->options['scoresperpage']); 


and replace it with:

PHP Code:

        $scores = $db->query_read("SELECT arcade_sessions.*, user.username, user.arcadeoptions FROM " . TABLE_PREFIX . "arcade_sessions AS arcade_sessions
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid=arcade_sessions.userid)
        WHERE arcade_sessions.valid=1 AND arcade_sessions.gameid=$game[gameid] " . iif( $scorecache, "AND ($scorecache)" ) . "
        ORDER BY score " . iif($game['isreverse']==1, 'ASC', 'DESC') . ", arcade_sessions.finish DESC
        LIMIT " . $vbulletin->options['scoresperpage']); 


/SK