Advert Management

This is a script to allow you to manage the adverts on your forums, you can have any sort of advert you can imagine there is no actual limit with this hack to what it can be, javascript, flash, image, text and images.

You add adverts to a category or a forum or the whole board. If the category has child forums they will inherit the adverts as well as their own adverts if they have any.
Adverts can have a set exposure such as 10,000 views and once it has reached that it will stop.

It fills a variable called $advert which you just place in any template, such as the header, you can also use variables and replacements within the adverts, such as $bbuserinfo[userid] for the persons userid in a link within an advert.

Updated June 9th at 19:44 GMT

Added date limits and options for unlimited exposures.
To upgrade from an older version, reapply code in global.php, upload ads.php and run this sql query to alter the ads table you made.

[sql]ALTER TABLE `ads` ADD `time` INT(10) DEFAULT '0' NOT NULL;[/sql]

[sql]ALTER TABLE `ads` ADD `wholeforum` SMALLINT(1) DEFAULT '0' NOT NULL;[/sql]
If you already run that query though are still experiencing problems with the time always being January 1st run

[sql]ALTER TABLE `ads` CHANGE `time` `time` INT(10) DEFAULT '0' NOT NULL[/sql]

New features include showing the advert on the entire forum by using a radio button, some highlighting in the admin panel, italic name indicates the time period has ended and a bold name means the advert has met its quota for exposures.

You must chance RAND() to RAND(NOW()) if you have mysql 3.23.52 or above

Scott

[PAINTBALLM]

i hope scott is on vacation or something, beacuse hes not responding

[Super Ted]

I want to try and maximise my ad space or whatever free space is available on the forum pages or my non vb homepage. However I don't want it looking a mess or too intrusive. I have seen boards that have a column down the left that contain ads, plus ones at the top of individual forums. I also need to be able to count page impressions for these ads. So multiple ads per page plus the ability to count ad impressions. Do any of you do this already? or have a site that has maximised its ads potential without making a mess of the forum.

[midnightz]

I have installed this before, But on my friends board, it wont go past the first advert and cycle, i have tested it for about 30 minutes? This is quite strange

anybody come accross this? I looked in admin settings and count won't change on variation after the first. It just wont join in the cycle?!?

[Dan Flynn]

This is a very very great hack.

Thank You

[lorden]

Some silly question it seems as though my whole hack has run flawlessly, i just don't know where to add $advert.

i tried doing some reading and tried adding it just as a test to newthread.php for example.

I keep getting line errors, i'll kepe looking hopefully someone can reply with the simple answer to this...

[Super Ted]

In the header or footer is your best bet.

[LadyBeth]

Two silly questions from a newbie...
1. will this work in 3.0 gamma
2. can it be set up to work on the main index/forums pag ein the upper right hand corner....

ok so it is three questions...
3. if yes, how?

Sorry to be so...new at this...

[SpeedStreet]

To my knowledge, it will not work with vB 3....though I *thought* there was some talk on vb.com about adding this in.

[Dez_U]

great hack.

Question, is there a plan to update it to run on vb 3 ?

thanks again

[BradM]

I personally would love to see it in v3