Arcade - Leader Board (v1.4)

This addon provides you with a Leader Board for v3arcade. Currently, it cannot be used for ibProArcade - if you adapt it, please share the code so that it can be added to the zip. You'll be credited for the work.

Dechevious has written a similar addon to this, but this code has been written from scratch and is far more optimized.. Currently, it is not fully phrased - but then again neither is v3arcade itself. Thanks to DRJ for his contributions toward v1.4. Enjoy!


Version History:
? [high]1.0[/high] - Original mod released.
? [high]1.1[/high] - Cached 2 previously uncached templates.
? [high]1.2[/high] - Query changed, orders count by DESC and userid by ASC.
? [high]1.3[/high] - *CRITICAL UPDATE* - Optimized query, improved performance.
? [high]1.4[/high] - arcade.php code block and arcade_kings_bit template changed.


Please click install if you find this useful..

[DRJ]

Great hack. Easy to install, only a few minutes.

I did make two changes for myself

in Arcade.php I ordered by username ASC instead of userid ASC since that makes more sense to me.

In template arcade_kings_bit

I wanted to fix the plural Titles for when there was only 1 title

Find

$kings[count] Arcade Titles

Replace With

<if condition="$kings['count']==1">
$kings[count] Arcade Title
<else />
$kings[count] Arcade Titles
</if>

Thanks for the hack.

[DRJ]

I also made this mod. What I wanted was if there was a tie for a certain place then everyone should get that trophy. So if there is a tie for first then both users should have a gold, there would then be no silver and the next prize would be bronze.

If there is a three way (or more tie) then they would all get gold and there would be no silver or bronze. I believe I have this working properly, but it is hard to tell for sure. So maybe some other users that have a tie for first, second, or third could test this.

Here is the whole mod for arcade.php

PHP Code:

// ######################### ARCADE LEADER BOARD ###########################
if ($_GET['do'] == "lboard") {

    $globaltemplates = array(
        'ARCADE',
        'arcade_header',
        'arcade_kings',
        'arcade_kings_bit'
    );

    require_once('./global.php');
    require_once('./includes/functions_user.php');
    require_once('./includes/functions_arcade.php');

    $navbits = array("arcade.php?$session[sessionurl]" => "Arcade");
    $navbits[""] = "Leader Board";
    $highscorers = $DB_site->query("
        SELECT COUNT(games.highscorerid) AS count, user.username, user.userid FROM " . TABLE_PREFIX . "games AS games
        LEFT JOIN " . TABLE_PREFIX . "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.username ASC LIMIT 10
    ");
    $row = '0';
                $awards = '0';
                $leaders = '0';

    while ($kings = $DB_site->fetch_array($highscorers)) {
$leaders++;
if ($awards<>$kings[count]){
                                $row=$leaders; 
                                }
                                $awards=$kings[count];
                                eval('$listkings .= "' . fetch_template('arcade_kings_bit') . '";');
                }

    $DB_site->free_result($highscorers);
    eval('$arcadebody = "' . fetch_template('arcade_kings') . '";'); 
} 


[Oblivion Knight]

Originally Posted by DRJ

in Arcade.php I ordered by username ASC instead of userid ASC since that makes more sense to me.

It was done as userid because I felt that there should be some advantages to being an older member.. - It's all down to personal perference with that one.

The other 2 changes you've made may be integrated into 1.4 once tested and confirmed as working, you'll be given credit for this of course.

[Sleepyk]

Real nice add-on worked easy

[frankenberrie]

Very nice addition. Added to my Arcade!

[BlackxRam]

Any way this will get adapted to work for the other arcade system and not V3acade?

[Oblivion Knight]

Originally Posted by BlackxRam

Any way this will get adapted to work for the other arcade system and not V3acade?

Not by me.. I have no plans to make the switch from v3arcade.

[MauriceReed]

it would be an excellent addition to IBPRO tho...anyone up for having a bash at the conversion??

[msimplay]

Originally Posted by Oblivion Knight

Not by me.. I have no plans to make the switch from v3arcade.

i second that i have no plans to move from v3arcade just yet

[Lionel]

Originally Posted by msimplay

i second that i have no plans to move from v3arcade just yet

me third