v3arcade Leader Board v1.6.0

This modification displays the top X players of your arcade.

v1.6.0 is an upgraded version of v1.5, which was previously a beta. This brings a couple of new options to the mix in preparation for v2.0 (hopefully a 100% plugin without code modification). If you wish to convert more than the top 3 ranks in to images, you will have to design these yourself and upload them as kingx.gif (replace x with the rank number).

If you attempt to edit the arcade_king_bit template, vBulletin will report a malformed statement. Ignore this, it works fine..


Compatability: 1.0.0 - 1.0.2.1
Screenshots attached..

[croportal]

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

[divided_by_fear]

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

[croportal]

Originally Posted by divided_by_fear

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

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

[divided_by_fear]

Originally Posted by croportal

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

lol np

[WildEye]

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!

[swa]

nice hack!

[Oblivion Knight]

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.

[Gizmo5h1t3]

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??

[Oblivion Knight]

Originally Posted by Gizmo5h1t3

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).

[Gizmo5h1t3]

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??