Add a banner image to each forum

Works on: VB3 RC3 - 3.1+

This modification will Add an image banner w/ link option per forum.

This hack modifies/adds :

1 php file
2 templates
4 query / table field
4 added phrase

*1.6 Update 12.18.05

Useage:
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.

Admincp -> Forums & Moderators -> Forum Manager -> Edit Forum -> Fill out the banner info.

Banner Image - (location of image)
Banner URL - (Link that you go to when u click the banner)
Alt Tag (if you mouse over the banner; pop-up text)
HTML Paste (added)

You can also fill out the info when you make a new forum.

NOTES:


Changes:
--------
1.6
Banner shows up on each thread
adds: 1 more template edit to the install

*1.5
+Added HTML option

*1.2
+ Added Alt text for each banner(admincp)
+ Images no longer must be on the server
You can use a local image off your webserver or use a image at another location.
EX: /images/banner/someimage.jpg or http://www.yoursite.com/someimage.jpg

*1.1
+ Added option for image to have a link

*1.0
+ Image banner for every forum under the $navbar

*//


JAVA BANNER ROTATION

FYI-

I did some playing around took the <if></if> statement added to the ForumsDisplay template. You can insted place it in the header / footer template and it will show up also.

VB3.5X ver
https://vborg.vbsupport.ru/showthread.php?t=94119

[Spinball]

Originally Posted by HarryButt

I am working on some updates. Should have something by monday 05.24.04

Excellent. Hope you took onboard the HTML suggestion. I used a modified version of this hack when I upgraded to vB3 last weekend. I added some ALT text as a third additional field in the forum table.
I would, however like to replace it all with the HTML or preferably processed contents of a PHP file.
Example of a banner rotation script if anyone finds this useful:

PHP Code:

<?php
$banners = array (
    "avforums_avsales.gif|avforums_avsales.pl|Providing Audio and Visual equipment for over 15 years. Home cinema centre and on-line store.|0|468|60",
    "avforums_digitaldirect.gif|avforums_digitaldirect.pl|Save ?'s Off High St Prices|0|468|60",
    "avforums_discounttv.gif|avforums_discounttv.pl|Discount electrical uk - exclusive deals for av forums. Click here|0|468|60",
    "avforums_richer.gif|avforums_richer.pl|Richer Sounds, The UK's Biggest Hi-Fi Retailer|0|468|60"

);
$banner = $banners[mt_rand(0,sizeof($banners) - 1)];
list($imgsrc,$myurl,$alttext,$border,$width,$height) = explode ('|',$banner);
echo("<A HREF=\"http://www.avforums.com/cgi-bin/$myurl\" TARGET = \"_blank\"><IMG src=\"http://www.avforums.com/adverts/banners/$imgsrc?" . mt_rand(1,999) . "\" border=\"$border\" width=\"$width\" height = \"$height\" alt=\"$alttext\"></A>");

?>

[Zachariah]

Spinball,

Ill take a look at that . This is just some small updates.

[Spinball]

Cool - thanks, Harry.

[reteep]

Originally Posted by Spinball

Excellent. Hope you took onboard the HTML suggestion. I used a modified version of this hack when I upgraded to vB3 last weekend. I added some ALT text as a third additional field in the forum table.
I would, however like to replace it all with the HTML or preferably processed contents of a PHP file.
Example of a banner rotation script if anyone finds this useful:

Can you explain how to use that rotation script with the banner hack?

[Spinball]

Originally Posted by stormblast

Can you explain how to use that rotation script with the banner hack?

Unfortunately you can't. I posted the rotation script as an example so Harry would consider altering this hack so it could be used.
Basically if the idea of having an image, URL and ALT text for each forum should be dropped completely and instead a single field which links to a php script.
The php script is evaluated and the results put at the top of the forum.
This script could contain my rotation script.

[run.exe]

1) I frequently peruse this outstanding resource, and I was intrigued by this hack.

2) I followed every step, to the letter; however, no banners are being displayed.

3) I am running vBulletin (release code) v3.0.1

Any clarification/assistance would be most appreciated; my board is here:

http://www.500Ecstasy.com/forums


Thank you very much, in advance.

Kind regards,

[Spinball]

Run - it's impossible to tell what you've done wrong just by looking at your board. Most likely you have misnamed the banner images or put the wrong link to them in your forum table. What URL have you used for your banners?

[FWF]

how do i UNdo the SQL edits, i tryed to install this hack however it wont work. So id like to undo the SQL edits. thanks in advance.

[Zachariah]

Originally Posted by FWF

how do i UNdo the SQL edits, i tryed to install this hack however it wont work. So id like to undo the SQL edits. thanks in advance.

If ya need help yell :nervous:

But to kill the sql install :

ALTER TABLE `forum` DROP `banner`, DROP `bannerlink`, DROP `banneralt`;

works for me :ermm: whats up ?

[SnowBot]

hhmm cant install this

Error

SQL-query :

ALTER TABLE `forum` ADD `banner` VARCHAR( 50 ) NOT NULL AFTER `description`

MySQL said:


Duplicate column name 'banner'

any help ?