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

Sounds like the product file messed up or something.. Those phrases should be added automatically.

I have installed with no erors except where do I go to view the leader board

Is their a url or a link in the main Arcade window I dont see anything different than before I instaaled it except in the admincp I now have the xtra menu options at the bottom as per original SS

Thanks in advance

phrases or templates??

Make sure you did the edit on your arcade_main template.

It should add a link to the following URL:
arcade.php?do=lboard


Both, but it sounds like the problem you're having is related to the phrase installation..

Far from trying to re-import the product file again, there's not much more I can suggest unless you're willing to e-mail me with a temporary admin login to your forums for me to take a look.? :(

the phrases thing seems to be sorted...god knows how that hapened...i didnt touch anything...lmao...


but, its weird how the po up on the stats doesnt work...
only thing i can think of is, one of the other hacks in the arcade is interfering with it...

i have the alternative layout hack running, mebbe its that???

one thing i did notice is....when i hover over the "stats" link, all thats added to that URL is "#" at tthe end.is that correct??

ie....
http://www.********.org/board/arcade.php?do=lboard#

Very weird indeed, and you're the only person that appears to be having problems with it.. :speechless:

I have the alternative layout hack, and it works fine with it.. Although the alternative layout currently doesn't have that pop-up on the arcade index, and instead currently links to the member's profile. Not sure if I'll change that or not though.


Yes, the URL is supposed to have a # at the end of it..

You should notice the same behaviour with things like Smilies and other things.

Thanks I was looking in the wrong spot

excellent clicking install :o

it starts looking ok to me. untill I change the arcade.php
the arcade ends up being a white page
post 15 also stated this(white page)
I have edited it 4 times and am at a loss
any suggestions?

did I do something wrong?

Eager for 2.0 version :rolleyes:

Thanks, works on 3.5.3. ;)

I'd like to request that the top 3 be converted into a vBa CMPS module.

Thanks.

Great hack! Installed.

Would love an option to show users' avatars in the Leader Board, right by their name...

Just noticed odd, inconsistent behavior, wanted to point it out. My settings are such that three trophies (1st, 2nd, 3rd) were expected:

But for a while the trophies on my forum were dispersed this way:
10 Arcade Titles - First Place
6 Arcade Titles - Second Place
6 Arcade Titles - Second Place
4 Arcade Titles
3 Arcade Titles

...which made sense, sorta, since there was a tie for 2nd place. But I noted that no 3rd place trophy was awarded?

And now, some trophies have changed hands, and the trophy dynamic shifted:

10 Arcade Titles - First Place
7 Arcade Titles - Second Place
6 Arcade Titles - Third Place
6 Arcade Titles - Third Place
2 Arcade Titles

How come when there was a tie for 2nd place, there was no 3rd place trophy at all? Is this expected behavior?

This is correct.. Think of the olympics, if 2 golds are awarded - there is no silver and if there are 2 silvers, there is no bronze. I'm not sure about 2 bronzes, but I think that this is correct also.

In the first scenario, the official rankings would be...
1
2
2
4
5

...and in the second
1
2
3
3
5

well ... what i would be interested in is showing the place-images in the postbit(_legacy)?!? :)

I put this on my site, love it, and clicked installed. Thanks!

does this work for 3.53 i installed but its not working

Yes, it works fine.. :rambo:

damn i got to try it again then. thanks nothing new shows on the page

Been tinkering with this, no dice. :ermm: Any help?

I just get a blank page when I click on leaderboard. What could I have missed?

I have v3 Arcade ver 1.0.2 on vB 3.5.1

Thanks in advance

I'll have a look at this for you tomorrow..


I suggest checking a couple of basic things.. Did you upload your modified arcade.php file in ASCII mode, and have confirmed that the file is complete? Have you imported the .xml product file?

Yes I have done all of teh above. I just removed the mod and tried everything again. Still just getting a blank page.

when I add this code (the last step)

<div class="smallfont"><strong><a href="$vboptions[bburl]/arcade.php?$session[sessionurl]do=lboard">[ $vbphrase[leader_board] ]</a></strong></div>

I get this Error
Not Acceptable
An appropriate representation of the requested resource /admincp/template.php could not be found on this server.

how is this file not uploaded, I re-uploaded it twice.

That sounds like something pretty major, not caused by this addon.

I suggest you post a thread over at vbulletin.com in their "troubleshooting" forum, and see what could possibly cause this. Please note however, that officially they do not support modified boards, so they may ask you to disable your plugins to try and isolate the problem..

ok man, thanks.

tehy'll pretty much make me shutdown plugins then and then leave it or do you think they will help me?

Hmm. Maybe just for the 1st, 2nd, and 3rd place trophy holders?

Any idea on an update for this?

Heard that the version 2.0 is on the way...:rolleyes: