Banner ad on forum Home

Adapted from "Add a banner image to each forum" script by Harrybutt
https://vborg.vbsupport.ru/showthread.php?t=61555

This modification will add an image banner with link and text to each forum you choose, and display it in on your forumhome, you can have a different banner for each forum with additional text above the banner like Sponsored by or affiliated with, or you can choose to have no text.

I have used 100x25px images for the example screen shot, but you can use what ever size you like, but remember it will effect the way your forum looks.

Hope people find this usful, this is my first hack as I'm still a big noob when it come's to hacking

Opps sorry made a slight error in the dir name, it's fixed now


For 3.5.x look here

[webrats]

would be cool if we could have both hack on the same admin page say small banner for forum home
and big banner for top of forums

[Beermonster]

Originally Posted by webrats

would be cool if we could have both hack on the same admin page say small banner for forum home
and big banner for top of forums

You can all you need to do is install them both

[hooolala]

what does add field to forum table means?

[Beermonster]

Originally Posted by hooolala

what does add field to forum table means?

You need to go to phpmyadmin and Run SQL query/queries on database just paste this code in the box and press "go"

ALTER TABLE `forum` ADD `fhbanner` VARCHAR( 50 ) NOT NULL AFTER `description` ;
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanner` ;
ALTER TABLE `forum` ADD `fhmessage` VARCHAR( 50 ) NOT NULL AFTER `fhbannerlink` ;

[sneakyc2e]

I did the banner hack and checked it three times to make sure I did every thing right and the banner is not showing up. Everything shows up in the user cp fine. This is the first time I have run a sql query but I went back to phpmyadmin and they show in there.

Any ideas. I really need this hack and it looks awesome in your screenshots.

I am on vBulletin Version 3.0.1

Thanks,
Dan

[Beermonster]

Originally Posted by sneakyc2e

I did the banner hack and checked it three times to make sure I did every thing right and the banner is not showing up. Everything shows up in the user cp fine. This is the first time I have run a sql query but I went back to phpmyadmin and they show in there.

Any ideas. I really need this hack and it looks awesome in your screenshots.

I am on vBulletin Version 3.0.1

Thanks,
Dan

I've sent you a pm, not sure what could be wrong, AFAIK no one else has had problems

[sneakyc2e]

Any ideas?

[paul_r]

just ran the query and heres what i got

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanne' at line 1

any ideas ? :ermm: :surprised:

[Beermonster]

I don't think you've pasted it in right, if you look at it it says "NOT NULL AFTER `fhbanne' " it should be fhbanner

[paul_r]

i dont think so m8

here the query error window copied and pasted



Query
ALTER TABLE `forum` ADD `fhbanner` VARCHAR( 50 ) NOT NULL AFTER `description` ;
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanner` ;
ALTER TABLE `forum` ADD `fhmessage` VARCHAR( 50 ) NOT NULL AFTER `fhbannerlink`



vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanne' at line 1