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

[grahamvonbaron]

I have the 2.2.8 version and I have been able to install some hacks myself, however I could use some help with this Adv manager hack.

Actually, I am open for somebody to be my go to guy for overseaing maintenance/upgrades and new hacks, I will pay a nominal fee or trade for your services. thanks,

graham@rcnow.com

[SpeedStreet]

Like everyone else, I am seeing an issue after a certain time of running this hack. However, I have uncovered something that I find VERY strange...

The only advertisement that loads on my page now is the most current one in the database...when I go into PHPmyAdmin, all the rows EXCEPT the most recent one return ok values. The most recent ID, when I try to browse its data, returns zero values and appears as if I was making a query versus a view.

Does ANYBODY know what could be causing this issue? How can we fix this? This is a great hack, and I hate to see it go by the wayside just cuz of a simple error....

[Julio]

Yes. I would even pay to get this hack working! :tired:

[SpeedStreet]

I just posted a general distress call, hoping other PHP gurus would come in here and help this hack out.

This is one of the best hacks period...to see it languish like this is sad

[Okiewan]

Pretty wild it's just getting dropped like this. Dissapointing.

[Scott MacVicar]

Most of my hacks have been re-written for vB3 and I have other things to do. Though I will definately try and debug this hack on a fresh install tonight.

/me adds this to his todo list.

[Okiewan]

Great! Thank you.

[Scott MacVicar]

ok i can't figure out why ORDER BY RAND() refuses to be working, its actually quite wierd and it appears to be the source of the problem.

[SpeedStreet]

PPN,

Thank you for picking this back up!!! We will all wait patiently for you to fix it

If you need a tester, I am here for you!

[Julio]

PPN: Same here as for test site. In fact I wrote that I would be willing to pay to fix this hack, since my board most probably be sponsored and I definately NEED to use this hack.

You have no idea how reconfortable is to know most of your hacks are being coded for VB3. This greatly increases the chances for me to update sooner, but it will pass a while until I do some tests, etc before upgrading. It needs to be seamless.

As always... keep the good work.