Forum Home Enhancements - Top ibp Champs on Forum Home 3.7

This shows Top ibProArcade Champs on Forum Home..

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

(New) This version shows username group color ..

1.
Import Product: ibp-champs-forum-home.xml

Plugins & Products >> Manage Products >> [Add/Import Product]:
Upload the ibp-champs-forum-home.xml file from your computer.


2.
Edit 1 template

Styles & Templates >> Style Manager >> forum home template >> FORUMHOME
Find:

$navbar


Below add:

<!-- ibp top three champs on forumhome 3.7-->

<table cellpadding="1" cellspacing="1" border="0" style="width:100%" class="tborder">
<tbody>
 <tr class="thead">
  <td width="100%" align="left"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('ibpchamp')"><img id="collapseimg_ibpchamp" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_ibpchamp].gif" alt="" border="0" /></a>
   <span class="normalfont">&nbsp;<b>Top ibProArcade Champs</b></span>
  </td>
 </tr>
</tbody>

<tbody id="collapseobj_ibpchamp" style="$vbcollapse[collapseobj_ibpchamp]">
	<tr>
		
		<td class="alt1" width="100%">
		<div class="smallfont">
<center>			
$top_three
</center>
	</div>
		</td>
	</tr>
</tbody>
</table>

<br />
<!-- /ibp top three champs on forumhome 3.7-->

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.

[rinkrat]

This is cool! Not too overbearing, nice and discreet.

THANKS!!

[rinkrat]

Uncached templates: top_three (3)

[Veer]

I've got this error message on beta 3 :

XML Error: XML_WAR_UNKNOWN_VERSION at Line 64

[Magnumutz]

Do you mind showing us a Demo?

[stangger5]

Originally Posted by rinkrat

Uncached templates: top_three (3)

Just added that to the update..

Originally Posted by Pehchaan

I've got this error message on beta 3 :

I`ve installed this on vb3.6.7 and vb3.7.4..
Dont know why it would error for beta 3..

Originally Posted by Magnumutz

Do you mind showing us a Demo?

Added a image to the first post..
The only difference is the user names will use the usergroup colors,,,if you use different colors for them...

[rinkrat]

The new version doesn't work for me. It shows the box and title but no three users.

[Trip3151]

werid nothing shows up i get the Top ibProArcade Champs but nothing under it

[stangger5]

Sorry,,,,its fixed now...

Zip updated...

[Magnumutz]

I get this error:

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:
    SELECT c.*, g.gcat, g.gid, g.gname,u.username,u.usergroupid,cat.password,COUNT(champ_mid) AS total
                            FROM games_list AS g, games_cats AS cat, games_champs AS c 
    LEFT JOIN user AS u ON(c.champ_name = u.username)
    
    
    
                            WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND cat.password=''
        GROUP BY userid                    ORDER BY total DESC LIMIT 0,3;

MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number  : 1267
Date          : Thursday, February 14th 2008 @ 10:16:33 AM
Script        : http://www.domain.com/index.php
Referrer      : http://www.domain.com/admincp/index.php?do=head
IP Address    : ...
Username      : ...
Classname     : ...
MySQL Version : 4.1.22-standard-log

I got a similar error when I installed the arcade... but when i disable the product, everything's ok... Any suggestions?