DHC Banner Ads - Upgrade [1.4]

Upgrade now available

DHC Banner Ads Hack

This script allows you to manage the banner advertisments on your vBulletin board from within the Admin Control Panel. Currently not integrated with PayPal, NoChex so payment will have to remain seperate, although this is set for later releases.

Features

? Display Banner Ads on every page
? Limit display of ads to so many clicks or views
? Turn off display of ads for certain usergroups
? Count clicks and views through Admin CP
? Keep banner ads in database but dont include them in rotation (ie: If maximum views has been reached)
? Auto deactivate when maximum clicks/views are reached
? Displays stats of ads in specified users control panel
? End date and time for banners (Limit or Unlimited)
? Multiple banners per page, using a locations script

Please don't forget to hit the Install button if you use this hack - It helps me judge how popular this hack is and how far to carry on supporting it



*UPDATE* [17th Apr 05] v1.4 Released! Download new ZIP file and either do fresh install or upgrade from previous version!

v1.2.1 - All queries now include TABLE_PREFIX for boards that use this function
Steps have also been taken to prevent SQL Injection

[Blue Moose Aaron]

My banner will display for a time and then I revisit my site and nothing is showing. So for some reason it is disableing itself..

[Xenatino]

also, when I click a banner, its going to www.xxx.com/clickthru.php and NOT /forum/clickthru.php.

So if i move clickthru.php to root then i get error msgs that /.global.php cannot be found.

Download the file attached to this reply and replace the current /includes/functions_bannerads.php file.

It has a few bug fixes and should fix this clickthru.php error.

[Protoman]

Originally Posted by Blue Moose Aaron

My banner will display for a time and then I revisit my site and nothing is showing. So for some reason it is disableing itself..

open clickthru.php and find:

PHP Code:

if ($Select['limit_type'] == "clicks" && ($Select[clicks]+1) >= $Select[limit_to]) 


replace with:

PHP Code:

if ($Select['limit_type'] == "clicks" && ($Select[clicks]+1) >= $Select[limit_num]) 


how it's currently setup it validates that you are limiting by clicks.. then looks for a nonexistant variable in the database.. returned 0.. and tada, 1 click, ad turns off.

[dennisuello]

i installed it and followed all the instrucation, now i get:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT displayads FROM usergroup WHERE usergroupid='6'
mysql error: Table 'reno4x4_vbulletin.usergroup' doesn't exist

mysql error number: 1146

[The Realist]

As the error states "Table 'reno4x4_vbulletin.usergroup' doesn't exist"

Create it

Originally Posted by dennisuello

i installed it and followed all the instrucation, now i get:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT displayads FROM usergroup WHERE usergroupid='6'
mysql error: Table 'reno4x4_vbulletin.usergroup' doesn't exist

mysql error number: 1146

[dennisuello]

my forum worked just fine before this, now i get this error. doesn't this table exist already?

all my tables start with vb3, like vb3_usergroup.

how do i uninstall this hack?

[The Realist]

If you want to uninstall it you have 2 options.

1) Reinstall the backup of your forum you should do before installing hacks.
2) Follow the instructions in reverse and put the edits etc back as they were.

Originally Posted by dennisuello

my forum worked just fine before this, now i get this error. doesn't this table exist already?

all my tables start with vb3, like vb3_usergroup.

how do i uninstall this hack?

[dennisuello]

Originally Posted by The Realist

2) Follow the instructions in reverse and put the edits etc back as they were.

what about reversing changes made by "install_bannerads.php"

[Big J]

Hi,

I get the following error when I try to add a banner: Warning: Cannot modify header information - headers already sent by (output started at /home/extreme-/public_html/forums/includes/adminfunctions.php:223) in /admincp/dhcbannerads.php on line 337

im running vb3.0.7

please help.

[MissKalunji]

Originally Posted by Big J

Hi,

I get the following error when I try to add a banner: Warning: Cannot modify header information - headers already sent by (output started at /home/extreme-/public_html/forums/includes/adminfunctions.php:223) in /admincp/dhcbannerads.php on line 337

im running vb3.0.7

please help.

it still saves up your settings......i have the same error 2....