I installed this hack a while back and it was working fine. I haven't touched it, and today now I get this error:
Database error in vBulletin 3.0.0:
Invalid SQL:
SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM gamesessions AS gamesessions
LEFT JOIN user AS user ON user.userid = gamesessions.userid
LEFT JOIN games AS games ON gamesessions.gamename = games.shortname
WHERE (gamename='alienattack' AND score='138') OR (gamename='aliens' AND score='39665') OR (gamename='asteroids' AND score='24470') OR (gamename='bloodypingu' AND score='1160') OR (gamename='breakout' AND score='17380') OR (gamename='chopper' AND score='3075') OR (gamename='copter' AND score='2017') OR (gamename='curveball' AND score='25345') OR (gamename='discoracer' AND score='10250') OR (gamename='flashpoker' AND score='4294967295') OR (gamename='funkypong' AND score='11') OR (gamename='hexxagon' AND score='38') OR (gamename='joust' AND score='4200') OR (gamename='kickups' AND score='212') OR (gamename='killkenny' AND score='64400') OR (gamename='maeda' AND score='9190') OR (gamename='marsrover' AND score='1372') OR (gamename='mcsnake' AND score='88') OR (gamename='minikickups' AND score='126') OR (gamename='monkeylander' AND score='21295') OR (gamename='pacman' AND score='25660') OR (gamename='penguin' AND score='3235') OR (gamename='pinguslap' AND score='640') OR (gamename='radialsnake' AND score='118') OR (gamename='ronnorthjewels' AND score='54050') OR (gamename='simon' AND score='20') OR (gamename='snake' AND score='2571') OR (gamename='spaceinvaders' AND score='24320') OR (gamename='target' AND score='2700') OR (gamename='tetris' AND score='94661') OR (gamename='towerball' AND score='12910') AND sessiontype=1 ORDER BY gamesessions.gamename DESC
mysql error: Got error 28 from table handler
mysql error number: 1030
Date: Tuesday 23rd of March 2004 03:11:26 PM
Script:
http://www.tmrforums.com/arcade.php?
Can somebody please help me get this fixed?