Banners & Ads System

Banners & Ads System
---------------------------------
by AnhTuanCool

Fully Tested on vb 3.0.5

Description:
Banners & Ads System allows you to have a slot on every pages in your forum for showing banners and ads. Banners and ads in database will randomly pickout to show everytime new page is loaded. Admin options in admincp allow you to fully administrate your banners and ads.

Feautures:
- Show Random Banner or Ad on everypage
- Clickable Link (of course )

Admin Feautures:
- Master Switch on/off
- Fully Add/Edit/Delete Banners, Ads Factors (such as title, dimension, links, etc...)
- Enable/Disable Banners To Be Shown (if you set Disable to a banner, it will not show)
- Banner Template Layout Alterable
- Show Banner Anywhere on your global templates

Updates:
Jan 28th - Add update to display banner anywhere rather than the nav

Install Instruction and Screenshots:
See attachments.

If you find this hack useful, also get informed by any new release & update, please click INSTALL. Thanks,

[serg]

I still can't figure out how to install this thing. anyone??????

[speedracer68]

I tried this edit to set up two banners. My entire site crashed when I made this change. I uploaded the previous global.php and all is well. I did it twice to see if I missed something. Same effect.

Also, when I place the banner on the left or center there is a blank gap below the banner. When I put it on the right there is no gap and less wasted forum space.

Any thoguhts?

Great hack by the way!!!

The is the error I get

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT title, html, url, type, status, width, height FROM banners WHERE status = '1' AND adid != ORDER BY RAND() LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY RAND() LIMIT 1' at line 1

mysql error number: 1064

Date: Saturday 05th of March 2005 11:33:41 PM
Script: http://www.my-site.com/forum/
Referer:
Username: My name
IP Address: my ip







Quote:



@PAWS - 1. Install the Update which I attached as txt file at this thread
2. Do this:
In your forumroot/global.php
Look for the whole code you've put in your global.php and REPLACE it with

PHP Code:

// Start banner rotating by Anhtuancool
if ($vboptions['enbanners'])
{
    // select random banner and display it
    $getbanner = $DB_site->query_first("SELECT title, html, url, type, status, width, height FROM " . TABLE_PREFIX . "banners WHERE status = '1' ORDER BY RAND() LIMIT 1");
    
    eval('$banner = "' . fetch_template('banner') . '";');
    $avoidid = $getbanner['adid'];
    unset($getbanner);

    // select random banner and display it secplace
    $getbanner = $DB_site->query_first("SELECT title, html, url, type, status, width, height FROM " . TABLE_PREFIX . "banners WHERE status = '1' AND adid != $avoidid ORDER BY RAND() LIMIT 1");
    
    eval('$banner2 = "' . fetch_template('banner') . '";');
    unset($getbanner);
}
// End banner 


Save, and place $banner2 in the footer or wherever you want your second banner slot to show up.

[redlabour]

Very nice ! Thx ....

[redlabour]

This is the last ++++ i ever seen .... in IE everything is ok. If you use Firefox you will see that this Hack isn?t HTML Valid. irate:

[ajk]

Originally Posted by redlabour

This is the last ++++ i ever seen .... in IE everything is ok. If you use Firefox you will see that this Hack isn?t HTML Valid. irate:

I use FireFox 1.0.1 and it runs fine.

[drex]

GREAT HACK!

Is there a way to add click tracking (not who clicks, just how much per ad) to follow the amount of clicks on the ads?

Would be a great addition to this awesome hack.

See it in action at www.x5world.com

[bos98]

OK this thing is great, works like a charm but......

I cant get it to load on my portal.....

the site is www.blackberry101.com

check it out and let me know, i tried inserting $navbar in the portal template, i tried inserting the code for the banner directly.....

I am stumped

Edit:

To be more clear, the banner is loading via the Navbar template using $banner,

on every page this works fine, but on the portal.php page which is using vBadvanced CMPS system it will not load, i have checked the source code after loading the portal page and it just seems to be ignoring the $banner variable within the navbar template.....

I can make the banner load if i put it directly in my header code....but i really dont want to do this if i dont have to

[bos98]

forget it i just put it in the header, not wasting any more time

[ajk]

Hi Bos,

Forum looks great!

Did you see the second text file?

Under the main File and instructions, there is directions to install elsewhere.

Check it out, it's easy!

[Starsurfer]

Is it possible for me to add a javascript randomiser in there? Please tell me, the code I have is:
<script language="JavaScript" src="http://impgb.tradedoubler.com/imp/pool/js/63240/1069018" charset="ISO-8859-1"></script>