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

[Beermonster]

Originally Posted by 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

There's no ; at the end of the last line, it should be
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` ;

but you are still missing the r in the error, try deleting fhbanner, fhbannerlink & fhmessage tables and run the query again, are you using phpmyadmin or admincp? also did you do a standard install of vb? or did you give the tables a prefix?

[paul_r]

ahh forund the problem in myphp

forum didnt exist so i had to change it to vb3_forum

workes a treat

thanks

www.mx5roadsters.com/forums

[Beermonster]

Originally Posted by paul_r

ahh forund the problem in myphp

forum didnt exist so i had to change it to vb3_forum

workes a treat

thanks

www.mx5roadsters.com/forums

np glad you got it working, feel free to click install

[sneakyc2e]

Sent you a pm.

Dan

[sneakyc2e]

file uploaded.

Dan

[sneakyc2e]

Pmed ya again.
Thanks,
Dan

[sneakyc2e]

Thanks for going way beyond supporting me on this one bro. Clicking Install.

Dan

[Jpax]

I installed everything and checked over all the lines, i get absoulty nothing that comes up. i can see the feilds were i can add the links and text but when i add them nothing happens. Right now i am using a dev folder so the url for the images are /dev/html/forum/admincp/images/fhbanner/ssbanner.gif
but i can see the pic but if i put it in the url what am i doing wrong? :ermm:

[Jpax]

never mind im an idiot, you have to lok in the admin pannel to add the files and links. GezzUuZZz this is awesome!

[sam]

Add these phrases:

Varname:
fhbanner

text:
Postbits Banner Image<br>(Places a image on your forum postbits) EX: banner.jpg

Varname:
fhbannerlink

text:
Postbits Banner Image Link<br>(http://www.yoursite.com)

Varname:
fhmessage

text:
Postbits Banner text i.e. Sponsored By or Affiliate with

Where i should put those phases and HOW?

any help please?