Ok... thanks I have it working now. I just switched from phpBB to Vbulletin and there are couple of minor differences in the control panel. :smoke:

thanks for your help :D

I have done the update. It is still not working for me.

Thanks for the reply but I get this error now:

Invalid SQL: SELECT title, html, url, type, status, width, height FROM banners WHERE status = '1' AND adid != ORDER BY RAND() LIMIT 1
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY RAND() LIMIT 1' at line 1

mysql error number: 1064

Ok, sorry for the inconvenience, please do this,
Select the whole thing you've added, REPLACE by this
Thanks,

Awesome work, thank you very much! :)

the banners look fine in IE, but not in Firefox. here's a link http://www.texas4x4.org/index.php

just a quicktip: to save 1 query on every page

Open global.php
FIND 'phpinclude_end',

Below ADD
'banner',

:)

@PAWS - you're welcome ;)

@Rastus - I looked your forum source code and I figured out that you want the banners to be centered. So you changed the default banner template a bit but you somehow missed and it just 'goes out of bound' :) If you want the banner to be center aligned, do this,
REPLACE your banner template with this
[html]
<!-- Banner Rotation by AnhTuanCool -->
<div class="smallfont" align="center">
<if condition="$getbanner[type] == 1">
<a href="$getbanner[url]" target="_blank"><img src="$getbanner[html]" width="$getbanner[width]" height="$getbanner[height]" alt="$getbanner[title]" border="0" align="center" /></a>
<else />
<OBJECT CLASSID="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" WIDTH="$getbanner[width]" HEIGHT="$getbanner[height]" CODEBASE="http://active.macromedia.com/flash6/cabs/">
<PARAM NAME="MOVIE" VALUE="$getbanner[html]">
<PARAM NAME="PLAY" VALUE="true">
<PARAM NAME="LOOP" VALUE="true">
<PARAM NAME="QUALITY" VALUE="high">
<embed src="$getbannerSave ;)

@zurih - thanks much for the tip, I'll consider adding it for the next version. Thanks, :)

Hey AnhTuanCool,
I'm a real rookie to PHP but I'm really excited about this mod. I'm was clipping along fine until i ran into step 5. I'm confused as to what to do. Do I make a new file with nothing else? If so, does it matter what I name it? Does this go into a specific file ( I don't see any file name).

Thanks for the hack and for your help.

Here is the instruction I'm confused with:


5. Add New Template

Title: banner

Template:

==================================

<!-- Banner Rotation by AnhTuanCool -->

<div class="smallfont" style="float:left">

<if condition="$getbanner[type] == 1">

<a href="$getbanner[url]" target="_blank"><img src="$getbanner[html]" width="$getbanner[width]" height="$getbanner[height]" alt="$getbanner[title]" border="0"/></a>

<else />

<OBJECT CLASSID="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" WIDTH="$getbanner[width]" HEIGHT="$getbanner[height]" CODEBASE="http://active.macromedia.com/flash6/cabs/">

<PARAM NAME="MOVIE" VALUE="$getbanner[html]">

<PARAM NAME="PLAY" VALUE="true">

<PARAM NAME="LOOP" VALUE="true">

<PARAM NAME="QUALITY" VALUE="high">

<embed src="$getbanner[html]" width="$getbanner[width]" height="60" play="true" loop="true" quality="high" PLUGINSPAGE="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed>

</OBJECT>

</if>

</div>

<!-- Banner Rotation by AnhTuanCool -->

==================================

I get what you say, here is how you Add New Template

Get in your AdminCP > Style Manager > Click on the drop-down menu next to the style title and cho Add New Template (see attachment for detail) and do as I described in the instruction. :)