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

[Jeremy W.]

So, does this do rotations if there are more then one ad for a certain forum?

[Parker Clack]

Jeremy:

Yes as long as you have them in the same forum they will show up together. You chose the forum(s) that you want the banner(s) to show up in. So you can have multiple banners for a single forum.

PPN:

I did notice though if you have more than one banner for a forum though it will create multiple of the banners. Say I put in banner1 and banner2 to show up in forum1. When I go back to the admin for the banners I will see three banner1s show up and 1 banner2. Now if I go back and delete the extra banner1s they will not show up again but when you first add them they are often times multiples.

Parker

[Scott MacVicar]

Will test it now, this shouldn't really happen as there is only one query. Does it appear 3 times when you add banner1 or does it only appear 3 times when you after you add banner2?

xiphoid: to exclude pages you have to start doing more checking, what files are you wanting to exclude? Tell me and i'll try and get the code done to do it.

[Floris]

showthread.php (maybe) We are still discussing this

but at least:
newthread.php
newreply.php
editpost.php
report.php
postings.php

[Scott MacVicar]

Not many files then

You'll need to add this code below

PHP Code:

eval("\$advert = trim("".str_replace("\'", "'", addslashes($advert['advert']))."");"); 


PHP Code:

if (substr($PHP_SELF,-strlen('newthread.php'))=='newthread.php' or substr($PHP_SELF,-strlen('newreply.php'))=='newreply.php' or substr($PHP_SELF,-strlen('editpost.php'))=='editpost.php' or substr($PHP_SELF,-strlen('report.php'))=='report.php' or substr($PHP_SELF,-strlen('postings.php'))=='postings.php') {
  $advert='';
} 


[Floris]

You the man
(and firefly ofcourse)

I will tweak it now (global.php I assume)

[update]
Yep, global.php and it works perfectly !!

[Sparkz]

I am pretty sure I am a man too.
/me checks between his legs...

Yup, definitely a man...

[Parker Clack]

PPN:

It happens after I add the second banner. The first one will get tripled.

I also noticed that the move function doesn't work with having the $advert array in global.php. Somehow it messes with postings.php and the move function thinks that you are trying to move it back to the same forumid. If I put the code in forumdisplay.php and showthread.php it works as I want it.

Would putting the check that you have written above resolve the issue with postings.php?

Thanks,
Parker

[Henry-RS]

Ok, I installed this without a problem, but there doesn't seem to be a feature that rotates the banners if you add two different ones to one specific forum, using the one "$advert" variable.

How can I make them rotate, by picking random banners that were assigned to that area?

[Parker Clack]

Henry:

If you put more than one banner for a forum the script will randomly pick the banner to display out of the ones that you have assigned to that forum area. From what I have experienced they are about one a one to one footing. Your mileage may vary.

Parker