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

[liquidblaze]

this hack doesnt seem to work for me.. at least the images dont get displayed - i edited all files and upped ads.php but whenever i set something in the adverts panel it doesnt get displayed. the strange thing though is that the visits get counted ...

[MrNase]

are you sure you used "<img src="....">" ???! You should include ALL html code and not just the url to the image


btw: working for me! Very cool work! Thanks!

[liquidblaze]

well i dont think of myself as the UEBER php/sql pro but i know quite a lot about html

im using a full <img> tag incl. alt and all surrounded by a link - it doesnt work with or without link nor with or without alt

[MrNase]

adjust the time (last setting when adding a new one or updating a new one...) standard is 29th january 2003 and that is wrong... change it to ... ... 2004 or whatever

[liquidblaze]

all done .. date is set and all works - the countdown (how many exposures are left) works too, it just doesnt show the image - neither via hotlinking nor via a local (on the server itself) file.

any more hints for people who are no total morons?

i mean.. setting it up was no prob - using it neither, i just dont see the images...

[madhouse]

Liquidblaze , just a question but did you add $advert to you header template?

[liquidblaze]

ah yes someone is looking like the absolute noob now... thx for your help

[Spyke1]

is it possible to use this to manage banners on a site (outside vbulletin)?

[Big J]

Originally Posted by ladyfyre

Hey PPN, just wanted to let you know, i found a bug.

i have mine set to unlimited exposures...but the exposure count for all adverts only went to 32767 for Houston, Austin, and Dallas, and will not go any higher....so the counter has a bug somewhere....

I'm having the same issue. Could comeone please PM me the fix!! Thanks!

[madhouse]

Read my post here :https://vborg.vbsupport.ru/showpost....&postcount=206

If u are having the same issue....