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

[BradM]

Originally Posted by Eternal2u

is there any possiblity of changing this to make it where you can enable a random banner to appear..

so you cna put in say 10+ banners, and just have one randomly appear...would be kinda easy i think with a nice php sscript...hmm i think i might have a go at that now tha ti think of it...if you don't mind me editing your mod a bit eh?

Pretty sure he said a few posts back he was working on it.

[Spinball]

This hack is the basis of what I'm looking for and crucial to my upgrade from vB2 to vB3 since I have several sponsors with banners in specific forums.
I do need to be able to specify ALT text for the banners and also to have them rotate randomly.

[Silviu]

What about flash banner? Or html code, for getting the banner from some adserver?

[xgaboard]

Easy hack great job!

[Flow Fusion]

Ok I have two questions...one in the databas quiery it says ...// Adds fields to forum table called banner and bannerlink.

Run Query:

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

So these are to be one field line correct?

And my other question is it says Add these phrases:

are these to be global? or what? Thanks.

[Flow Fusion]

Hello? Can I get some help on this? An update..something?

[Zachariah]

Originally Posted by Flow Fusion

Ok I have two questions...one in the databas quiery it says ...// Adds fields to forum table called banner and bannerlink.

Run Query:
ALTER TABLE `forum` ADD `banner` VARCHAR( 50 ) NOT NULL AFTER `description` ;
ALTER TABLE `forum` ADD `bannerlink` VARCHAR( 250 ) NOT NULL AFTER `banner`

So these are to be one field line correct?

And my other question is it says Add these phrases:

are these to be global? or what? Thanks.

Yep I used phpmyadmin.

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

all phrases are global

[Flow Fusion]

I don't understand "description?"
Database error in vBulletin 3.0.0:

Invalid SQL: UPDATE forum SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'The Arts',
description = '',
banner = '',
bannerlink = '',
link = '',
displayorder = '3',
daysprune = '30',
parentid = '-1',
newpostemail = '',
newthreademail = '',
styleid = '0',
password = '',
options = '86017',
parentlist = '5,-1'
WHERE forumid=5
mysql error: Unknown column 'banner' in 'field list'

mysql error number: 1054

can I get some help? This happens when I try to show the forum in the drop down menu.

[Zachariah]

[QUOTE=Flow Fusion]I don't understand "description?"
[QUOTE]

Forum table
description is a row already there.
The comands place banner and bannerlink under the description row.

see attached.

Note: I changed description type to "blob" for something else. It has nothing to do with this hack.

[Flow Fusion]

Thanks I'll try this from scrach and see what happens.