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

Nice little hack...Could be used.

Nice, I like this. :)

Excellent...I've been waiting for this!

Thanks :)

Can you HTL it, please? ;) If you do I'll install it.

Aaron

Excuse my ignorance guys.....but what is HTL?

Cheers,
Synwave

hack Tracking Log
https://vborg.vbsupport.ru/showthrea...&highlight=HTL

I would if I could but like I said I'm a total noob at this, I will have a look in to it and see if I can :)

I'll try and convert it for you. I need the practice.

Aaron

Go for it :) I don't have HTL installed, so I've never played with it.

Almost there. Inquiring about some roadblocks I'm running into but hopefully something soon. You should check the HTL. It's great. I'm only installing hacks using it and my goal is to use it to write hacks (though this is the first one I'm trying to put into HTL as if I'm writing it)...

Aaron

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 ;)

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"

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

Any ideas?

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:

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

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?

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

:D

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

Sent you a pm.

Dan

file uploaded.

Dan

Pmed ya again.
Thanks,
Dan

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

Dan

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:

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

Where i should put those phases and HOW?

any help please?

Go to AdminCP then Languages & Phrases/phrase manager, then add new phrase

Can you use google adsence with this somehow???

I'm sure it could be modified to retrieve HTML files rather that pictures, but I'm not sure about using both together, after all you only usually have one Google ad account.

I do have only one google ad account but I use the ad code on all my sites. Seems to work.. I would like to use google ad sence buttons. I think they would fit perfectly.

How hard would it be to mod this???

Thanks

Sorry I was thinking I was replying to my rotating banner mod, it's been a long day :surprised:

I will have a look at it for you see what I can do :)

No Problem..lol

Thanks so much for helping! :)

Great Hack BTW

Doesn't the Adsense TOS specifically state that there can be only one instance of their ads per page?

I'm not really sure but why would they care? When ever somebody clicks they are making much more than us???

Unfortunatly I do not have any paid advertisers yet other than Google...

Good hack but I get this message when I try to add a banner to my main forum.

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE forum SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'General',
description = 'Post general bike related questions, and join in the banter!',
fhbanner = 'test.jpg',
fhbannerlink = '',
fhmessage = '',
link = '',
displayorder = '1',
daysprune = '1',
parentid = '24',
newpostemail = '',
newthreademail = '',
styleid = '0',
password = '',
options = '97991',
parentlist = '1,24,-1'
WHERE forumid=1
mysql error: Unknown column 'fhbanner' in 'field list'

mysql error number: 1054

Check your mysql table it looks like you don't have fhbanner in it, also do your forum tables have a prefix on them?