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

[JustAskJulie]

Tried to run the first SQL query and got this

[JustAskJulie]

Tried to install the first SQL query and got this error:

Error

SQL-query :  

CREATE TABLE `ads` (

`adid` smallint( 5 ) NOT NULL auto_increment,
`name` varchar( 25 ) NOT NULL default '',
`forumid` smallint( 5 ) NOT NULL default '0',
`wholeforum` smallint( 1 ) NOT NULL default '0',
`exposed` smallint( 10 ) NOT NULL default '0',
`exposures` smallint( 10 ) NOT NULL default '0',
`time` int( 10 ) NOT NULL default '0',
`advert` text NOT NULL ,
KEY `adid` ( `adid` ) 
) 

MySQL said: 


You have an error in your SQL syntax near '`ads` ( `adid` smallint(5) NOT NULL auto_increment, `name` varchar(25) NOT NULL ' at line 1

[Sidewindr]

I NEED this for VB3!!!! Desperatley.

[chet]

This is posted in VB3 but does it work in VB3, the title reads "Advert Management
For vBulletin 2.2.6"

Regards

Chet

Sorry about that, right forum wrong post, is it ready for vB3 at all

Chet

[White Knight]

Nope... Nothing for VB3 yet.. lots of people waiting for it though. One of the hacks I greatly missed when I was running 2.0

[Sidewindr]

I have ended up using phpAdsNew, seems to be VERY good

[White Knight]

Originally Posted by Sidewindr

I have ended up using phpAdsNew, seems to be VERY good

yeah it works if your just trying to do banners.

I was accually using this for the html addition into certian subbords.. I was able to add tables images just like "second menu"

[94supratt]

Is it possible to have multiple ads appear at the same time? I would like to have them side by side at the top of my forum.

[M.C.]

just join to everyone who waiting for vB 3x port!!! bump bump bump !!!

[jamiepryer@hotm]

hey, can someone post up a link to a forum this is working on please