Add-On Releases - v3 Arcade Winners Podium

I've reworked the Arcade Winners Podium, the original file edits didn't work properly - due to some database queries that weren't needed and some Italian language in the code.

I've also cleaned up the template and added new images.

Import the product

Go to: Admin CP > Plugin System > Manage Products > [Add/Import Product]
Import the "product-v3ArcadePodium.xml" file.

Upload images

Upload the images to your arcade/images folder

Edit Files

Open arcade.php in a text editor

Find:

($hook = vBulletinHook::fetch_hook('arcade_main_complete')) ? eval($hook) : false;

Above it, add:

    // Start Arcade Podium
    if ($vbulletin->options['dispawards'] == '1')
    {
        $champs = $db->query_read("SELECT user.username, user.userid, count(games.highscorerid) as total, user.userid FROM " . TABLE_PREFIX . "v3arcade_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 total DESC, user.userid ASC
        LIMIT 3");
        $champ1 = array(); $champ2 = array(); $champ3 = array(); $champ4 = array(); $userids = array();
        While ($champ = $db->fetch_array($champs)) 
        {
            array_push($champ1, $champ['username']);
            array_push($champ2, fetch_seo_url('member', fetch_userinfo($champ['userid']), array('tab' => 'v3arcade_stats')));
               array_push($champ3, $champ['total']);
            array_push($userids, $champ[userid]);
        };
        for($counter=0;$counter<3;){
                if ($champ2[$counter] != ''){
                    $supposta = fetch_avatar_url($userids[$counter]);
                    if ($supposta == '')
                        $champ4[$counter] = '/images/arcade/noavatar.gif';
                    else
                        $champ4[$counter] = $supposta[0];
                }
                $counter++;
        }
}
    // Finish Arcade Podium

Find:

$templater->register('waittournaments', $waittournaments);

Below it, add:

 // Start Arcade Podium Mod
    $templater->register('champ1', $champ1);
    $templater->register('champ2', $champ2);
    $templater->register('champ3', $champ3);
    $templater->register('champ4', $champ4);
    // Start Arcade Podium Mod

Edit Templates

Open template: v3ARCADE_MAIN

Find:

<!-- category tabs -->

Above it, Add:

<!-- Start Arcade Podium Modded -->
<vb:if condition="$vboptions['dispawards'] == '1'">
<div>
            <h3 class="blockhead">                
<center><img src="{vb:raw vboptions.arcadeimages}/crown_podium.gif" /><b> Arcade Kings and Queens of {vb:raw vboptions.bbtitle}! </b><img src="{vb:raw vboptions.arcadeimages}/crown_podium.gif" /></center>
</h3>
<table class="tborder" cellpadding="3" cellspacing="3" border="1" width="100%">
<tr>
    <td class="alt1" nowrap="nowrap" width="33%" valign="middle" align="center"><div style="padding: 5px 5px 5px 5px;"><img src="{vb:raw vboptions.arcadeimages}/no1.gif" /></div></td>
    <td class="alt1" nowrap="nowrap" width="33%" valign="middle" align="center"><div style="padding: 5px 5px 5px 5px;"><img src="{vb:raw vboptions.arcadeimages}/no2.gif" /></div></td>
    <td class="alt1" nowrap="nowrap" width="33%" valign="middle" align="center"><div style="padding: 5px 5px 5px 5px;"><img src="{vb:raw vboptions.arcadeimages}/no3.gif" /></div></td>
</tr>
<tr>
    <td class="alt1" nowrap="nowrap" width="33%" valign="middle" align="center"><vb:if condition="$champ4[0] != ''"><div style="padding: 20px 20px 20px 20px;"><img src="{vb:raw champ4.0}" height="75"><vb:else /><div class="smallfont"><b><div style="padding: 20px 20px 20px 20px;">Can You Become The Champion?<br><img src="{vb:raw vboptions.arcadeimages}/trophy.gif"> Claim Now! <img src="{vb:raw vboptions.arcadeimages}/trophy.gif"></b></div></div></vb:if></td>
    <td class="alt1" nowrap="nowrap" width="33%" valign="middle" align="center"><vb:if condition="$champ4[1] != ''"><div style="padding: 20px 20px 20px 20px;"><img src="{vb:raw champ4.1}" height="75"><vb:else /><div class="smallfont"><b><div style="padding: 20px 20px 20px 20px;">Make Your Challenge For Top Spot<br><img src="{vb:raw vboptions.arcadeimages}/trophy.gif"> Claim Now! <img src="{vb:raw vboptions.arcadeimages}/trophy.gif"></b></div></div></vb:if></td>
    <td class="alt1" nowrap="nowrap" width="33%" valign="middle" align="center"><vb:if condition="$champ4[2] != ''"><div style="padding: 20px 20px 20px 20px;"><img src="{vb:raw champ4.2}" height="75"><vb:else /><div class="smallfont"><b><div style="padding: 20px 20px 20px 20px;">Prove You Are The Best<br><img src="{vb:raw vboptions.arcadeimages}/trophy.gif"> Claim Now! <img src="{vb:raw vboptions.arcadeimages}/trophy.gif"></b></div></div></vb:if></td>
</tr>
<tr>
    <td class="alt1" nowrap="nowrap" width="33%" valign="middle" align="center"><div class="smallfont"><vb:if condition="$champ1[0] != ''"><a href="{vb:raw champ2.0}"><b>{vb:raw champ1.0}</b></a><br><b>with {vb:raw champ3.0} highscores</b> <vb:else /> - Empty - </vb:if></div></td>
    <td class="alt1" nowrap="nowrap" width="33%" valign="middle" align="center"><div class="smallfont"><vb:if condition="$champ1[1] != ''"><a href="{vb:raw champ2.1}"><b>{vb:raw champ1.1}</b></a><br><b>with {vb:raw champ3.1} highscores</b> <vb:else /> - Empty - </vb:if></div></td>
    <td class="alt1" nowrap="nowrap" width="33%" valign="middle" align="center"><div class="smallfont"><vb:if condition="$champ1[2] != ''"><a href="{vb:raw champ2.2}"><b>{vb:raw champ1.2}</b></a><br><b>with {vb:raw champ3.2} highscores</b> <vb:else /> - Empty - </vb:if></div></td>
</tr>
</table>
<div style="padding: 10px 0px 0px 0px;"></div>
<vb:else />
</vb:if>
<!-- Finish Arcade Podium Modded-->
<div style="padding: 5px 0px 0px 0px;"></div>

The podium is enabled upon install but can be disabled by going to Admin CP > v3 Arcade > v3Arcade Settings > v3Arcade General Settings and setting Display Arcade Awards Podium to No

To upgrade from version 1.01 to 1.0.2 replace the arcade.php file edit.

Mod History
1.0.2 - Cleaned up code a little, fixed error with avatars not showing
1.01 - Initial Release

If anyone wants to further develop any of my addons, you are free to do so.

[Rckcrwlr]

Tagged for future

[doctorsexy]

Installed working on 4.1.3 ..thanks Gemma

[Claudi]

Thanks Gemma

[snow2000]

Works fine! Thank you Gemma

[Gemma]

Your welcome

[dmm2020]

Good job, I like it. Using the v3Arcade system as a way of making downloadable games available for testing where our members can review them before downloading.

[GamersChallenge]

not working for me. when I make the changes to arcade.php I get a white page. when I restore the old arcade.php page works fine again.

you cann see it here http://www.gamerschallenge.net/arcade.php

[Gemma]

Just done a fresh install on my site and it works fine. Please double check your arcade.php file edits.

Also which version of the arcade are you running?

[GamersChallenge]

got it working. just re-done everything, I have no idea what happend. thanx for the fast reaply and for the good work.