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

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.

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

Easy hack great job!

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.

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

Yep I used phpmyadmin.

all phrases are global

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.

[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.

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