[yabba]

Hello John

2 little errors in the arcarde.php. I think thats a prefix problem again:

Failure One:

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL:
SELECT user.userid AS userid, gamesessions.score AS score, games.shortname AS shortname FROM vb3_gamesessions
LEFT JOIN vb3_user AS user ON user.userid = gamesessions.userid
LEFT JOIN vb3_games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='asteroids' AND score='34620') OR (gamename='chopper' AND score='1883') OR (gamename='pacman' AND score='26180') OR (gamename='simon' AND score='30') OR (gamename='snake' AND score='1905') OR (gamename='spaceinvaders' AND score='41010') OR (gamename='tetris' AND score='57400') AND sessiontype=1 ORDER BY gamesessions.gamename DESC

mysql error: Unknown table 'gamesessions' in field list

mysql error number: 1109

Date: Tuesday 20th of January 2004 02:39:40 AM
Username: Nicht registriert

and the Second :

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL:
SELECT user.userid AS userid, gamesessions.score AS score, games.shortname AS shortname FROM vb3_gamesessions
LEFT JOIN vb3_user AS user ON user.userid = gamesessions.userid
LEFT JOIN vb3_games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='asteroids' AND score='34620') OR (gamename='chopper' AND score='1883') OR (gamename='pacman' AND score='26180') OR (gamename='simon' AND score='30') OR (gamename='snake' AND score='1905') OR (gamename='spaceinvaders' AND score='41010') OR (gamename='tetris' AND score='57400') AND sessiontype=1 ORDER BY gamesessions.gamename DESC

mysql error: Unknown table 'gamesessions' in field list

mysql error number: 1109

Date: Tuesday 20th of January 2004 08:25:10 AM

Greets yabba