Add a banner image to each forum (vb3.5)

/* -----------------8/11/2005-----------------
[HowTo] Add a banner option image w/ Link or HTML paste to each forum V.1.6
Tested on vBulletin: 3.5.0 RC2

Zachariah - http://www.gzhq.net

This is a VB3.5 Ver of my previous hack:

*** Add a banner image to each forum (VB 3.0x)
https://vborg.vbsupport.ru/showthread.php?t=61555

*** Info:
This modification will Add an image banner w/ link Or paste in your own HTML code option per forum. These files can be any image. (png, jpg, gif, ect). This will be located after the $navbar on FORMDISPLAY. This images can be located on the localhost or on a remote server.
--------------------------------------------------*/

Upload the "plug-in" and edit 2 template, It's a snap.



Changelog:
------------
1.6
Banner shows up on each thread
adds: 1 more template edit to the install
Requested by: - Ryan McBain

** Note: 1.5 - 1.6 needs only to edit SHOWTHREAD not Reinstall the XML files

1.5
Added HTML option (tested w/ Java and Iframe from phpadsnew output)
Added 3.x to VB 3.5 upgrade XML file.

** Random Banner Code Java

**Please click " Install " to track updates.

[Zachariah]

going to do a an update in a wook or so ;D

[skcyber]

thanks you for your answer, it's working..

i love your plug !!! lol

[megnin]

I think I'm closing in on my problem getting this to work...
In the "(vb3.x) add banner to forum 1.6.txt" file where it says:

/////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////NEW INSTALL////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////

// Adds fields to forum table called banner, bannerlink, banneralt, bannercode.

//////////////////////
Run Query:
//////////////////////

ALTER TABLE `forum` ADD `banner` VARCHAR( 50 ) NOT NULL ;
ALTER TABLE `forum` ADD `bannerlink` VARCHAR( 250 ) NOT NULL ;
ALTER TABLE `forum` ADD `banneralt` VARCHAR( 250 ) NOT NULL ;
ALTER TABLE `forum` ADD `bannercode` mediumtext ;

...I assumed that was code that would execute during install. I now believe that I'm suppose to run those four query commands to add those fields to the forum table. I still don't know how to do that though.
Under "Maintenance" is "Execute SQL Query". Is that where I run the above query?
When I click on "Execute SQL Query" in the Control Panel it says, "You are not authorized to execute SQL queries".

I'm stuck.

[Zachariah]

Originally Posted by megnin

I think I'm closing in on my problem getting this to work...
In the "(vb3.x) add banner to forum 1.6.txt" file where it says:


...I assumed that was code that would execute during install. I now believe that I'm suppose to run those four query commands to add those fields to the forum table. I still don't know how to do that though.
Under "Maintenance" is "Execute SQL Query". Is that where I run the above query?
When I click on "Execute SQL Query" in the Control Panel it says, "You are not authorized to execute SQL queries".

I'm stuck.

Product:
banner_image.xml

Runs all of that for you on install. Placement of html edites in 2 templates is all you have to do.

--------------------------------------------------*/
1) Choose the right XML file.

*** How to Install:

In your Admin Control Panel

Admincp => Plugin System => Manage Products
Click [Add/Import Product]
Browse for the file "banner_image.xml"
Allow Overwrite should be on
Import

---------------------------------
2) Edit and add / replace(old code).

*** Edit 2 Template(s) : FORUMDISPLAY, SHOWTHREAD

Find:
$navbar

below add:


<if condition="$foruminfo['banner'] AND $foruminfo['bannerlink']"><center><a href="$foruminfo[bannerlink]" target="_blank"><img src="$foruminfo[banner]" alt="$foruminfo[banneralt]" border="0" /></a></center><br />
<else />
<if condition="$foruminfo['banner']"><center><img src="$foruminfo[banner]" alt="$foruminfo[banneralt]" border="0" /></center><br />
<else />
<if condition="$foruminfo['bannercode']"><center>$foruminfo[bannercode]</center><br />
</if>
</if>
</if>


--------------------------------------------
*** Useage:

These files can be any image. (png, jpg, gif, ect) or paste your HTML code.

To add banners go to Forums & Moderators => Forum Manager => Edit forum => scroll do to the bottom enter your details.

[rnmcd]

Would it be a major change to have multiple (but smaller) banner ads to each forum?

[Zachariah]

I used the "html area" to paste custom code.
- Java rotation , custom html, dhtml, ect.

2 images w/ link in HTML area.
http://www.gzhq.net/forums/forumdisplay.php?f=235
EX:

<a href="http://www.google.com">
<img border="0" src="http://www.google.com/logos/winter_holiday05_1.gif" width="276" height="120"></a>
<a href="http://www.google.com">
<img border="0" src="http://www.google.com/logos/winter_holiday05_1.gif" width="276" height="120"></a>

[rnmcd]

Originally Posted by Zachariah

I used the "html area" to paste custom code.
- Java rotation , custom html, dhtml, ect.

2 images w/ link in HTML area.
http://www.gzhq.net/forums/forumdisplay.php?f=235
EX:

<a href="http://www.google.com">
<img border="0" src="http://www.google.com/logos/winter_holiday05_1.gif" width="276" height="120"></a>
<a href="http://www.google.com">
<img border="0" src="http://www.google.com/logos/winter_holiday05_1.gif" width="276" height="120"></a>

Sorry buy I'm quite a novice :nervous: and I don't understand your previous post.

Are you saying that we don't need your hack to post banners? Just add code to the html area?

[Zachariah]

Originally Posted by rnmcd

Sorry buy I'm quite a novice :nervous: and I don't understand your previous post.

Are you saying that we don't need your hack to post banners? Just add code to the html area?

Hello,

After hack install:

In the creation of the forum or edit of the forum you wish to have the banner there is an "Html Code" area. This can be used for custom code if you want more than 1 banner.
https://vborg.vbsupport.ru/attachmen...9&d=1125806409

In the EX shown in post: #186 - I pasted the above code.

You can also use a simple Java rotation script in that "html code" area.
https://vborg.vbsupport.ru/showpost....1&postcount=80

[Karsh]

no XML file in the zip i downloaded..

[davesx]

thanks for this zach, works great.

just wanted to know if there is a way i can add this to the bottom? like above the quick reply but after the last post in the thread?

would i just update showthread and forum display and put the same code in the right spot...or would i likely run into problems because that would display the same image twice? like that would only work if i were doing adsense, not banners?

thanks