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

[PAINTBALLM]

i'd like to see the option to output a statistics page for your sponsors/advertisers to view, so they know that they arent getting done dirty.

[d3nnis]

Originally Posted by Scott MacVicar

Its not a bug its the limit of mysql smallint.
Ill icq you the fix.

hi Scott can you post here?

[d3nnis]

found the solution... i alter ad table , exposed field to bigint(10)

[TheLab]

Originally Posted by d3nnis

found the solution... i alter ad table , exposed field to bigint(10)

What does this change? And whats the exact query you run?

[d3nnis]

Originally Posted by TheLab

What does this change? And whats the exact query you run?

i used phpmyadmin, under ads table, field -> exposed, click on action -> change

[TheLab]

And what did you earn by doing that?

Edit: Forget it.. i found out what this does.. :nervous:

[d3nnis]

some info about mysql numeric types..

http://www.mysql.com/doc/en/Numeric_types.html

smallint can only goes up to 32767

so by changing to bigint, I can expect it to goes up to 9223372036854775807!

[PAINTBALLM]

Scott, I installed this hack, and what I did was modified the variables and installed it again so I could have a different banner system for both the top and bottom of my site. I changed all of the advert variables for the footer system to advert2, and changed all the ads to ads2, then the variable I put in the footer is $advert2 instead of $advert... It works nice..

Accept, one problem is confusing me, as I am not a PHP expert, and you are :P I think you can help me..

First, go here, and look at the footer, notice it works.. http://www.paintballmessage.com/forums

Now go here, and look at the footer, notice.. its not working... http://www.paintballmessage.com/foru...p?s=&forumid=8

It seems to work on every page accept two, those two being the showthread.php and the forumdisplay.php...

Could you tell me how to fix this?

Thanks scott

Justin

[d3nnis]

Originally Posted by d3nnis

some info about mysql numeric types..

http://www.mysql.com/doc/en/Numeric_types.html

smallint can only goes up to 32767

so by changing to bigint, I can expect it to goes up to 9223372036854775807!

by the way, exposure max limit will also be 32767 since the datatype value is smallint.

if you wish to go beyond 32767, you have to change it to bigint as well.

[PAINTBALLM]

Originally Posted by Super Ted

^^^Bump^^^ I am sure others would like to know too!

Ted what you could do is make a php file in your forum directory, and have it call the global and functions files.... And then put $advert in that, in a table with 0 border and 0 cell padding spanning 100% x 100% centered.. Make it transparent on the non vb page, and it would work like a dream thats what I do