i have problem, top list 10 players and on main is 2 time 9 look screenshot

its cause there both tied for 9th they both have 3 wins

okay thank you very much...i am so stupid

lol np

EDIT: never mind. Had a typo in the filename for the xml file. works great :)

Installed this and getting an SQL error.

Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT COUNT(games.highscorerid) AS count, user.username, user.userid FROM arcade_games AS games
LEFT JOIN user AS user ON user.userid = games.highscorerid
WHERE user.userid IS NOT NULL
GROUP BY user.username, user.userid ORDER BY count DESC, user.userid ASC LIMIT;

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 '' at line 4 Error Number : 1064
Date : Wednesday, December 7th 2005 @ 12:27:25 PM
Script : http://********/forum/arcade.php?do=lboard
Referrer : http://*******/forum/arcade.php
IP Address : *************
Username : ***********
Classname : vb_database


Any help would be appreciated!

nice hack!

v1.6.1 is now in the works, which will add a condition if there are no arcade champions yet (fresh installations perhaps?), added pagenav goodness and a fix for that malformed statement bug.

right, in reply to my earlier question about "view stats" in the leaderboard....the pop up wporks on the member names OUTSIDE the leaderboard page...ie...in the arcade index etc...but not when i hover over "view stats" on the leaderboard page...

any help oblivion??

I'm not sure why it'd work on the arcade index and high scores page, and not on the leader board.

Try reverting your arcade_king_bit and arcade_kings templates, and make sure you're running the latest version of this addon (1.6.0).

cant revert them mate, theyre not highlighted in the admin cp, as theyre unaltered??

also, the second pic in the original thread shows text in the admin cp options...where mine is blank....any ideas??

the boxes are there, but theres no text to show what they are??