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

[GeorgeofCS]

great hack One question though is there a way to get it so that ads that are selected as any forum will run on pages like forum home, etc? It only appears to run on my site in the forums themselves and I'd like to make it so it would run pretty much throughout the site. :classic:

[active]

please help this looks like just the hack i need for my site but i can not get it to work im new to vbullititon any help would be very gratefull

[Tech_Koss]

Originally posted by active
sorry to be a pain but were do i run the sql?

run that in your "phpmyadmin"

if you dont know what the link is ask your host

[Scott MacVicar]

OK i cant get the time thing to work, time to pester chen and see if he can find a solution to why it is not updating.
I presume Parker that you dropped the ads table and re created it or altered the table to add the time column.

[Parker Clack]

PPN:

I just took out the time check and that column from the ads table.
Works just fine that way.

Parker

[Slynderdale]

i get a parse error with the ads.php and when i add the code to global.php

Parse error: parse error in /home/public_html/forum/admin/ads.php on line 246

[Scott MacVicar]

Upload the file in ASCII

[Slynderdale]

i did, they still didnt work

[Slynderdale]

works now, got my self a new ftp client

[Slynderdale]

hmm, i found a bug, i set the advert to show for one year but it doesnt show