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

[Densit5]

K bypassed that problem - then i came across a prefix problem in functions_bannerads.php

line 34
is
$GetUsergroup = $DB_site->query_first("SELECT displayads FROM usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'");

should be
$GetUsergroup = $DB_site->query_first("SELECT displayads FROM ".TABLE_PREFIX."usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'");

[Xenatino]

Densit5: Sorry for the errors, can you tell me please how you bypassed that error and I will try and incorporate it into the script.

Also, I will be sure to include that update above into the script

[sunnycher]

So we shouldn't install this until you have fixed the problem densit5 is having?
I'm so looking forward to this one!
Thank you X!

[Xenatino]

All changes have been made. Installation runs smoothy now, tested on 2 different servers!

[dynaimc]

Good feature, installed!

Is there a way to add a feature in the next version that will allow you to have the link open in a new (_blank) window or the same (_self) window? So ads that relate to in-forum ads (like promoting a new feature or forum in the same forum) open in the same window, and external links open in a new window?

Thanks!

[sunnycher]

Great idea dynamic! That way they don't leave your forum.
Thanks Xenatino!!

[sunnycher]

I'm coming up with a Parse error: parse error, unexpected '/' in /home/content/c/h/e/cher123/html/community/global.php on line 522 while installing. can't get past it.

[sunnycher]

----------------------------------------------------------------------
/global.php (1 Change)
----------------------------------------------------------------------
FIND

eval('$headinclude = "' . fetch_template('headinclude') . '";');
eval('$header = "' . fetch_template('header') . '";');
eval('$footer = "' . fetch_template('footer') . '";');

ADD ABOVE

// <DHC>
require_once('./includes/functions_bannerads.php');
$TotalSlots = get_banner_slots();
for ($x=1; $x < ($TotalSlots+1); $x++)
{
$banner_ad[$x] = print_random_banner($x);
}
// </DHC>
----------------------------------------------------------------------

This is where I'm having the problems so far.
If I do this to my global.php that is in my FORUM root directory, I get the above error.
Looking at this /global.php (1 Change) it makes it look as though there should be a global.php in my main ROOT directory?

[Xenatino]

Originally Posted by dynaimc

Good feature, installed!

Is there a way to add a feature in the next version that will allow you to have the link open in a new (_blank) window or the same (_self) window? So ads that relate to in-forum ads (like promoting a new feature or forum in the same forum) open in the same window, and external links open in a new window?

Thanks!

Thank you for this suggestion, I will be usre to implement it into the next release

[Densit5]

Been busy the past week - i am now looking back at the problem i am still having - I think its a problem with my v bulletin site - as i run the install_bannerads.php file - when i hit the Start installation button - it redirects me to .php which does not exist.

code i have is :-

<!-- form started: 5 queries executed -->
<form action=".php" name="messageform" method="post">
<input type="hidden" name="do" value="" />
<br />
<table cellpadding="4" cellspacing="0" border="0" align="center" width="65%" class="tborder">
<tr>
<td class="tcat" align="center" colspan="2"><b>vBulletin Message</b></td>

</tr>
<tr valign="top">
<td class="alt1" colspan="2"><blockquote><br />This script will install the necessary MySQL data to run DHC Banner Ads...<br /><br /><input type="submit" value="Start Installation"><input type="hidden" name="do" value="sql"><br /><br /></blockquote></td>
</tr>
<tr>
<td class="tfoot" colspan="2" align="center"> <input type="button" class="button" value="Go Back" tabindex="1" onclick="window.location='javascript:history.back(1)';"/> </td>
</tr>
</table>
</form>
<!-- form ended: 5 queries executed -->

i think its a problem in my global.php file somewhere, am investigating. i by passed it by creating some manual form code in the install php file that call the sql function, which worked. So i dont think your code is at fault here. But i will find out why hopefully soon.