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

[alkatraz]

Great hack! But I'll wait for a clickthrough tracking system to be added =)

[Tigga]

I seem to be having some of the same problems as other people. If I add more than one ad, it will only display the newest one I added. I also noticed the problem with ads being created multiple times. It seemed to only do this whenever I refreshed the page right after adding one though. I'm sure I have the new version because I had never downloaded it before and it has the option to set a date for the ad to expire. Any idea's on what I did wrong?

Thanks,
Brian

[DannyITR]

Same problem here. It was working fine alternating between banners and all of a sudden it only displays the newest one. I've even re-installed the hack. Help!

[Okiewan]

Originally posted by DannyITR
Same problem here. It was working fine alternating between banners and all of a sudden it only displays the newest one. I've even re-installed the hack. Help!

Ditto

[DannyITR]

Guys, you must help us lost souls.

[Julio]

I installed and ran the queries.... worked OK, but whenever I set an ad and try to view it in the board I get the following error:

Parse error: parse error, unexpected T_STRING in c:\MYPATH\global.php on line 237

Fatal error: Call to undefined function: getpermissions() in c:\MYPATH\index.php on line 10

Any help?

[DannyITR]

help!

[Julio]

Nevermind... fixed it.

1) Anyone knows the code I should use to have some flash, or videos show up?

2) Why when I add an ad, it doesn't show start date? It only shows end date. How can I do that?

[Okiewan]

Same problem here. It was working fine alternating between banners and all of a sudden it only displays the newest one. I've even re-installed the hack. Help!

Pretty Please?

[DrkFusion]

At last, I have found the best use for this.

Thanks PPN!
-Arunan