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

[Dez_U]

lets Bump it again in the hopes that someone is ready to releas this as a 3.5 plug in

[Julie]

Originally Posted by Dez_U

lets Bump it again in the hopes that someone is ready to releas this as a 3.5 plug in

With you on that bump! *bump*

[94supratt]

All of my ads have expired because the last date I can set an ad to expire is Dec 31, 2005. How do I resolve this?

[94supratt]

Originally Posted by Scott MacVicar

change this wee bit in global.php

PHP Code:

if(isset($advert_forumid)) {
  $foruminfo = getforuminfo($advert_forumid);
  $advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} else {
  $advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',-1,')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} 


to

PHP Code:

if(isset($advert_forumid)) {
  $foruminfo = getforuminfo($advert_forumid);
  $advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} else {
  $advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',-1,')>0 AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} 


This will disable the time length function until i get it sorted.

I did this to disable the time length function in the mean time.

[bradg]

Originally Posted by Dez_U

lets Bump it again in the hopes that someone is ready to releas this as a 3.5 plug in

I second that bump! I desperately need this for 3.5.3!!

[Andy R]

Yes, this would be excellent for 3.5!

[Marco van Herwaarden]

This is a 4 year old vB2 hack.

Nobody ever migrated it to vB3.0 i the last 2 years, so i doubt someone will do it for 3.5 now.

Probably enough alternatives.

[bradg]

I've looked around and can't find anything that does exactly what this one did. If you know of anything it would be a huge help to me as well as the several others who have replied with the same response as mine.