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

[Scott MacVicar]

Sorted the problem, the best idea is to download the hack again, drop the ads table and then re-upload the ads.php file to admin, reapply code in global.php and recreate table. There has been many changes recently to all code concerned with this hack.

[Floris]

Wow, you solved it! Great, I will try to re-apply the hack again soon!! w000 h00000

[Scott MacVicar]

If you need to know it was something real real real real simple, wasnt even any php coding.

I had made the time column a small integer which isn't enough to accomodate a timestamp as its 10 characters long. But i added some more features any way.

[Floris]

Uninstalled the hack, then installed the latest .zip from the first post, and it seems to work just fine!


Oh,
what if I now want to exclude files? can I still apply that little code you provided or will that not work properly with this new version?

https://vborg.vbsupport.ru/showthrea...950#post254950

[Scott MacVicar]

Yeah it'll still work, Im going to look into a way of adding an advert to seperate forums.

[Floris]

A nice challange maybe (or maybe I am trying to hard)

Showing banners on announcement pages. (or at least on all of them)

[Scott MacVicar]

Banners should be shown on announcement pages as they have a $forumid specified and this should invoke the code which loads banner code.

Presuming you have a banner set for the forum that your viewing the announcements for.

[Floris]

Ah great

Just added a few banners from MadOnion to my site and they look great in the footer Works perfectly, especially that little code to exclude some pages.

No, let's see how rich I will become !

[Stealthy]

Thanks PPN! Works great!

*installed*

[merit5]

Has there been a way figured out to have for instance.. 2 calls of the $advert tag and have it as two different banners or will it always call the same banner when calling multiple banners on the same page?

thanks for the update.. this hack is great..