I know this has been covered but how do you add adverts to your forum

[fonzerelli_79]

Im trying to add advertisements to the section headings of my forum

I amended forumhome_forumbit_level1_nopost but now the ad appears in every section.

i know that this has been covered before but can someone please print the code again

cheers

[Admin]

There is a hack in the releases forum (by me) that does this. :)

[fonzerelli_79]

ive looked but i cant find it

what page is it on

[Admin]

First page...

http://www.vbulletin.com/forum/showthread.php?s=&threadid=26818

[fonzerelli_79]

thanks a lot

[fonzerelli_79]

I did everything to a T but got this message -

Database error in vBulletin Control Panel: Invalid SQL: UPDATE forum
SET
styleid='1', title='Non Shopping Related Topics', description='',
active='1', displayorder='3', parentid='-1', parentlist='13,-1',
allowposting='1', cancontainthreads='0',
sponsorname='',sponsorimg='',
sponsorurl='Database error in vBulletin Control Panel: Invalid SQL: UPDATE forum',daysprune='30',
newpostemail='', newthreademail='',
moderatenew='0', allowhtml='0', allowbbcode='1',
allowimages='0', allowsmilies='1', allowicons='1',
styleoverride='0', allowratings='1', countposts='1',
moderateattach='0'
WHERE forumid='13'
mysql error: Unknown column 'sponsorname' in 'field list'
mysql error number: 1054
Date: Monday 22nd of October 2001 10:28:09 PM
Script: /forums/admin/forum.php
Referer: http://www.presents4them.com/forums/admin/forum.php?action=edit&forumid=13




What do you think is wrong

p.s. thanks for all your help with this mate

[Admin]

You didn't run the queries maybe?

[fonzerelli_79]

i didnt

how exactly do i do that

(your quick)

[Admin]

See this thread:
http://www.vbulletin.com/forum/showthread.php?s=&threadid=18558

[fonzerelli_79]

I downloaded the files and uploaded them but i dont think ive did it correctly


:D

cheers anyway

[fonzerelli_79]

Firefly

ive messed about with it and finally got it working

thanks for all your help mate

much appreciated

check out the links i posted on my forum - there class

Funny links (http://www.presents4them.com/forums/showthread.php?threadid=7)

[fonzerelli_79]

when i run the query i get this

Results of query ALTER TABLE forum ADD sponsorname VARCHAR(100) not null AFTER cancontainthreads, ADD sponsorimg VARCHAR(100) not null AFTER sponsorname, ADD sponsorurl VARCHAR(255) not null AFTER sponsorimg
--------------------------------------------------------------------------------
Error 1060: Duplicate column name 'sponsorname'

Whats wrong

[Admin]

I thought you already installed this? :confused:

Anyway, run this query:
ALTER TABLE forum DROP sponsorname, DROP sponsorimg, DROP sponsorurl
(note: you will lose any sponsors you already have set up)

[fonzerelli_79]

and then what

it was working fine by the way, then it come up with that error

[Admin]

Why did you run this query again?
ALTER TABLE forum ADD sponsorname VARCHAR(100) not null AFTER cancontainthreads, ADD sponsorimg VARCHAR(100) not null AFTER sponsorname, ADD sponsorurl VARCHAR(255) not null AFTER sponsorimg
You only need to run it once when installing.

[fonzerelli_79]

firefly,

once again, i thank you for all your help.

its fine again but it was last night too, then when i woke up in the morning i was getting errors

this php stuff would make you go nuts

[fonzerelli_79]

once again, ive got the error

its weird.

its ok for a while then it messes up

check out the error at the top of the page at http://www.presents4them.com/forums/

and tell me what you think

[fonzerelli_79]

to save you time, here is the error

Warning: Cannot add header information - headers already sent by (output started at /home/sites/site7/web/forums/index.php:2) in /home/sites/site7/web/forums/admin/functions.php on line 1459