EDIT: I see the problem...I removed some users who had the high score on the particular game and it's screwing things up...just gotta remove their high scores and we'll be good to go.

I havn't read the whole thread, it's too big :) but how would I put some stats on the home page, or who's playing what etc

Could someone please help me with the problem I mentioned earlier? I got more data on it, and apparently, the user DramaQueen, played simon and got a score of 7. This was nowhere near the incredibly high score that SoftBallRawkStar already had (36), and yet the championship is now appearing for DramaQueen in the postbit, and in the arcade profile. It still shows SoftBallRawkStar as the champion in the high scores list. I really badly need to fix this because SoftBallRawkStar is very proud of her high score and feels it is very injust that DramaQueen holds the championship for it.

I have a theory on what's going on here. Perhaps no one expected anybody to get a score that high on simon. Maybe although it still shows up as 36, internally, it started at zero again at 30. This would make the internal score that determines the championships 6, which is one less than DramaQueen's 7. Is this possible?

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?

Dark Dragon, that's a damaged database error IIRC. Check the status of your database tables?

Table Op Msg_type Msg_text
tmrforum_TMRmySQL.gamechallenges check status OK
tmrforum_TMRmySQL.gamenews check status OK
tmrforum_TMRmySQL.games check status OK
tmrforum_TMRmySQL.gamesessions check status OK
tmrforum_TMRmySQL.user check status OK

They seem to be okay.

I have the same problem. :( I have double checked my work, but still no fix. Does anyone have any ideas? This worked fine on my test BB and it is the only hack installed.

yetti sports seal bounce john is that avaibale for editing? as u have the 1st two

http://www.threadsdev.com/forum/show...p/Number/94361

If you ever find a fix I'd love to know it since it's lacking an uninstall option and the arcade is quite useless at it is right now.