Add-On Releases - v3 arcade High-score Champs on Forum Home

Shows v3 arcade High-score Champs on Forum Home..Version 1.0

///Add 3 images///

Add the images to the images/arcade folder..


///Add 1 phrases///

Languages & Phrases >> Phrase Manager >> Add New Phrase :

Varname: v3arcade_champions
Text: v3arcade High-score Champions

Save...


///Import Product: v3arcade_champs_on_forum_home.xml///

Plugins & Products >> Download / Upload Plugins : Upload the
v3arcade_champs_on_forum_home.xml file from your computer.


///Edit 1 template///

//forum home template: FORUMHOME//

//Find:

$navbar


//Below add:

<!-- v3arcade champs on forumhome -->

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center" style="border-bottom-width:0px">

<tr>
		<td class="tcat" colspan="2">
			<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_v3arcade_champs')"><img id="collapseimg_forumhome_v3arcade_champs" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_v3arcade_champs].gif" alt="" border="0" /></a>
			<phrase 1="$vboptions[bbtitle]">$vbphrase[v3arcade_champions]</phrase>
		</td>
	</tr>
</tbody>


<tbody  id="collapseobj_forumhome_v3arcade_champs" style="$vbcollapse[collapseobj_forumhome_v3arcade_champs]">
	<tr>
		
		<td class="alt1" width="100%">
		<div class="smallfont">
			
<center>
<img src="$vboptions[bburl]/images/arcade/1st.gif" border=0 hspace=2 vspace=1 align=absmiddle><b>$champv3username0</b>:(<i><b>$champv3highscorerid0</b> High-scores</i>)   &nbsp;&nbsp;
<img src="$vboptions[bburl]/images/arcade/2nd.gif" border=0 hspace=2 vspace=1 align=absmiddle><b>$champv3username1</b>:(<i><b>$champv3highscorerid1</b> High-scores</i>)   &nbsp;&nbsp;
<img src="$vboptions[bburl]/images/arcade/3rd.gif" border=0 hspace=2 vspace=1 align=absmiddle><b>$champv3username2</b>:(<i><b>$champv3highscorerid2</b> High-scores</i>)
</center>

	</div>
		</td>
	</tr>
</table>

<br />

<!-- /v3arcade champs on forumhome -->

///thats it///
Enjoy
stanger5

If you use this add-on,,please Mark as Installed..

This modification may not be copied, reproduced, published or posted for download elsewhere without my permission.

[Invalid ID]

I saw it first...

Any Demo or Screen Shots?

[stangger5]

Screen Shot added...

[projectego]

Nice one! Thanks a bunch, stangger5!

[stangger5]

If you use this add-on,,please Mark as Installed..

[Invalid ID]

Got an error, so uninstalled, yet getting the following error:

Database error in vBulletin 3.6.4:

Invalid SQL:

        SELECT COUNT(games.highscorerid) AS count, user.username, user.userid
FROM arcade_games AS games
        LEFT JOIN 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.userid ASC
LIMIT 3;

MySQL Error  : Table 'apni_forum.arcade_games' doesn't exist
Error Number : 1146

How can I remove this error?

Note: I have already undone all the steps I took to install it.

[stangger5]

This add-on is for v3arcade...

If you dont have arcade_games table,,your not useing v3arcade..

[Deadly Assassin]

Brilliant!! :up:

[badboyz]

not showing the user name

[stangger5]

Originally Posted by badboyz

not showing the user name

What arcade are you useing badboyz,,,v3arcade or ibProarcade ??

You posted in the ibProArcade section,,that you was having problems with ibProArcade...

The add-on in this thread is for v3arcade...

If you want this add-on for ibProArcade,,, click here ..