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

[NexDog]

John,

Any chance of fixing that link on the leaderboard?

[John]

If I had that problem I would just mess around with the colour code until it worked - I can't give you a solution off the top of my head...

[Castel]

Originally posted by NexDog
John,

Any chance of fixing that link on the leaderboard?

look for:

PHP Code:

$thefooter = "<normalfont color="{tableheadtextcolor}"><center>Want to try again? Click <a href="$bburl/tetris.php?action=play&s=$session[sessionhash]"><b>here</b></a>.</center></normalfont>"; 


and change it to:

PHP Code:

$thefooter = "<normalfont color="{tableheadtextcolor}"><center>Want to try again? Click <a href="$bburl/tetris.php?action=play&s=$session[sessionhash]"><font color="{tableheadtextcolor}"><b>here</b></font></a>.</center></normalfont>"; 


and the same principle of the other $thefooter line

[NexDog]

I tried this but it didn't work, no change.

$thefooter = "<normalfont color=\"{tableheadtextcolor}\"><center>Want to try again? Click </normalfont><a href=\"$bburl/tetris.php?action=play&s=$session[sessionhash]\"><b><font color=#FFE600>here</b></a>.</center></font>";

[NexDog]

Ah ok, cool, brb.

[Castel]

First of all nice hack john. I didn't read all of the posts in this thread so just ignore me if this was already mentioned. I wanted to change the amount of leaders displayed to 50 instead of 10 and noticed you have a single query for each user name on the list.

Edited with better instructions for Jashugan

All instruction below need to be done twice!

Change both instances of $leaderboard_q to (replace 10 with whatever number of leaders you want shown):

PHP Code:

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


Under $s_userid = $leadloop['userid']; add:

PHP Code:

$s_username = $leadloop['username']; 


Delete the following block

PHP Code:

$user_result = $DB_site->query("SELECT username FROM user WHERE userid='$s_userid'");
$details_array=$DB_site->fetch_array($user_result);
$s_username = $details_array['username']; 


This will save you 10 queries on the leader board or in my case 50

[NexDog]

Tried that code but no change. saw a <normal font> tag out of place and rectified it with:

$thefooter = "<normalfont color=\"{tableheadtextcolor}\"><center>Want to try again? Click </normalfont><a href=\"$bburl/tetris.php?action=play&s=$session[sessionhash]\"><font color=\"{tableheadtextcolor}\"><b>here</b></font></a>.</center>";

But still no change.
http://www.hostnexus.com/forum/tetri...on=leaderboard

[Jashugan]

Castel

Umm, list of 50 members sounds good but where will we put these codes that you post above? If add then after or before which code, if replace then which?

[Castel]

NexDog, neither of the 2 samples you posted are an exact paste of the code I gave. I made some template edits moving hardcode stuff into the template but that really shouldn't matter.

My line looks like this:

PHP Code:

$thefooter = "<a href="$bburl/tetris.php?action=play&s=$session[sessionhash]"><font color="{tableheadtextcolor}">Want to try again? Click here</font></a>"; 


With the rest of the tags moved to the template, previously I posted a line that should work with the default template.

[NexDog]

Could you post what needs to be added to the templates and where? I'm dealing with a HD failure right now.