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.

hi Scott can you post here?

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

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

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

And what did you earn by doing that?

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

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!

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

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.

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