vB Tetris v2.5 | Leaderboard, Comments and High Score System v2.5 :)

hack removed, someone please delete this thread.

Apparently the 6 days solid I spend supporting this wasn't good enough (not to mention the 65 page total).

Thanks

[John]

Originally posted by NuclioN
Yahooo, now it's become "open source"

Has it?

[NuclioN]

Well no, just teasing John.

[Martin64]

Originally posted by john.eovie


Hey - I'm open to other people's help. Make it secure and post it back up here if you have the time.

Afraid I don't have the skills.

[high]* Martin64 looks at Lesane
[/high]
[high]* Martin64 looks at Stuwee[/high]

[Schorsch]

Originally posted by LightBringer
John, I installed the new arcade hack and I'm now experiencing issues with not being able to reach the comment section after a game is played.

*this was with tetris...trying the other games now*
I'm coming up with a request to login/permission denied.

http://www.brainphreeze.com/forums/arcade.php

Ok, tested all games and this is what I come up after finishing any of the games.

what did you change that it works now ?

[John]

Just make a small change to compensate for the fact that he has reigster_globals turned off.

[John]

If the arcade hack gives you the same no permission error, just get in touch and I'll send you the other version of the file

[Schorsch]

If somebody needs an arcade button (standard vB style), please look here.

[trilOByte]

With regard to making *only* each users best score show up on the leaderboard......

Originally posted by futureal


This can be done. Here's an example:

http://www.shadowsofnamek.com/forum/...game=tetris&s=

Or another, from a different game:

http://www.shadowsofnamek.com/forum/...me=breakout&s=

Only each user's best score is shown. To accomplish this, you need to alter the query used in tetris.php for the "leaderboard" action.

From the original tetris.php file, you will want to replace this:

PHP Code:

$leaderboard_q = $DB_site->query("SELECT * FROM arcade WHERE game='tetris' ORDER BY score DESC LIMIT 10"); 


with this:

PHP Code:

  $leaderboard_q = $DB_site->query("SELECT game,userid,comment,max(score) as maxscore
                                    FROM arcade
                                    WHERE game='tetris'
                                    GROUP BY userid
                                    ORDER BY maxscore DESC
                                    LIMIT 10"); 


That should achieve the result you're looking for.

Well I tried this, but no luck I'm afraid. There are two instances of the code you said to look for. When I replaced both instances with your replacement code, it did list the users only once, but i lost the comments and the actual score.

I think this is very close, but i dont know enough about drawing info from SQL DB's to work it out myself - any ideas anyone?

Thanks.

[John]

Originally posted by Schorsch
If somebody needs an arcade button (standard vB style), please look here.

Sweet, shame we have to sign up to vBGermany to get the file

[Schorsch]

Originally posted by john.eovie


Sweet, shame we have to sign up to vBGermany to get the file

ok, full credit to Anke123 from the vBulletin-germany.com forum!!

I hope she has nothing against it that I attach here button here.