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

[Stealthy]

PPN, excuse my naivety but this is the first time for me doing banners.

Question: When filling in the section 'Code to be shown as advert', what exactly does this mean? Could you show an example of one please?

Also, do I have to have the banners on my server? I would like to link the banners to the advertisers' servers. How can this be accomplished?

Thanks for your help and great hack!

[active]

help need please this is just the hack i need to can not seem to install it any one help me out please

[Scott MacVicar]

Stealthy, for the Code to be shown you can put in whatever you like and it will replace $advert in any of your code, it can be images, text or javascript. Its up to you it doesn't matter what you have.

I have

<a href="http://www.site.com"><img src="http://www.site.com/banners.gif" alt="Website" /></a>

active, do what the instructions say in the text file within the zip. Make the code changes and then upload ads.php then run the sql query at the top to create the table.

[Parker Clack]

PPN:

Sorry. I meant January 1, 2002. If I delete the ad and reenter it at say 2200 then at 0001 it gets reset back to January 1, 2002.

Sorry if I wasn't clear before.

Parker

[active]

sorry to be a pain but were do i run the sql?

[Stealthy]

Thanks PPN, I will give it a try.

Also, I am getting the same problem as Parker. When I save the advert, I save it as 30 June 2002 but when I go back in to modify, it is set to 1 January 2002. Maybe this is why I cannot get the banner to show up as it is expired??

[Scott MacVicar]

What version of php are you running Parker? Its now 01:21 and its running fine on my local board which is php 4.2.1. Also what mysql version are you running?

[Floris]

I had a problem, you meantioned to upgrade, I did, and problem disappeared, I could move threads again. But now I can't use this hack. The adverts won't show up.

[Floris]

Ah, I see now.
It does say 2002 in my hear, but resets the dates to jan 1st, 2002. If i change them, then goto 'edit' it still says '1 jan 2002'. So that is why they wont' show up.

[Scott MacVicar]

Ok i obviously have a date problem I cant find on linux i'll play with it tonight after work.