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

[Kars10]

Originally posted by danielhollands
FIND:

PHP Code:

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


REPLACE WITH:

PHP Code:

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


This will need to be done twice, and <number> needs to be replaced with whatever number you want on the highscore.

This however produces produces more queries based on the number you are showing in the leader board (one extra for each person). There was another suggestion in this thread about how to reduce this, but I don't know if it works with the latest verson or not.

Hope this helps?

It works with the new version. Thanx! :rambo:

[John]

thanks to Minifreunde for voting for this on Hack of the Month :banana:

*nudge* https://vborg.vbsupport.ru/showthrea...215#post288215 *nudge*

[Ninth Dimension]

*WOOF!*
Private joke

[NexDog]

Daniel,

Changing the limits in tetris.php is the easiestoption and doesn't produce any more queries.

[John]

That's exactly what his code does.. :\

[Ninth Dimension]

Originally posted by NexDog
Daniel,

Changing the limits in tetris.php is the easiestoption and doesn't produce any more queries.

I could be wrong, but from the code I can see that for each score in the leader board it does another query to get the users username, this line:

PHP Code:

$user_result = $DB_site->query("SELECT username FROM user WHERE userid='$s_userid'"); 


This will result in a query for each person listed on the leaderboard

[NexDog]

Okay, me baka.

[Kars10]

Originally posted by john.eovie
thanks to Minifreunde for voting for this on Hack of the Month :banana:

*nudge* https://vborg.vbsupport.ru/showthrea...215#post288215 *nudge*

I thank you John for giving us this great hack!!
Like i said you create a Monster!! *lol* :bunny:

[John]

Ok, I think this *should* fix the session timeouts and no permission problems...

Give me feedback

[Ninth Dimension]

I've just uploaded the new tetris.php file, and so far as I can see there are no problems, but then I was not getting problems in the first place.