Banner Ads System

Banner Ads System
Author: Thinh Nguyen (tnguy3n)
Support: www.vbviet.org

###############
Banner Ads System Expanded version supports Adsense, Adbrite, Flash, Inframe, etc.
Click on the link below for more info & to purchase:
http://www.vbviet.com/index.php?act=...od&productId=8
###############

This simple rotational banner ads system get random ads from your database and display globally under navbar on your board.
It's been fully tested on vb 3.5.2, but it should work fine for all 3.5 Gold version.

FEATURES:
- Banner stats tracker
- Ability to enable/disable
- Admin ability to add/modify/delete banners
- Admin ability to view banner stats/detail for each banner
- more

#################
STRUCTURE:
- New Files: 3
- New Template: 1
- New db tables: 2
- Product: 1


#################
INSTALLATION:

1. Upload files to appropriate dir in your forumroot
2. UPload product xml file in your Product Manager

#################
If you find this hack useful or wish to sponsor/support future development of the hack, you can donate to


If you need custom version of this hack, pls contact me.

:::::UPDATE:::::
The product xml above will add 2 plugins and the ads stays fixed under navbar. This, however, may not be working with some custom skins if navbar template's codebit are changed. To fix that problem, open Banner System plugin (at global_start hook), replace the whole content with:

PHP Code:

// Banner Ads System by tnguy3n
if($vbulletin->options['bannersys_mode'])
{
    $getads = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "

bannersys_banners WHERE status = '1' ORDER BY RAND() LIMIT 1");
    $ads = $vbulletin->db->fetch_array($getads);

    // print banner ads
    eval('$bannerads = "' . fetch_template('bannerads') . '";');

    $vbulletin->db->free_result($getads);
    unset($getads);
} 


Next step, you'll have to modify some templates in order to display the ads, place this following code:

$bannerads

anywhere you want to show the ads.
If you want to show the ads globally on your forums, put that code in either header or navbar or footer template.

To enable/disable or change other settings of Banner System: vBulletin Options -> Banner System Settings
- Banner System Mode: yes = enable, no = disable
- Show Banners to Logged In Users: yes = everyone (including logged in users), no = only guests
- Ads In New Window: yes = open in new window, no = open in same window

[tnguy3n]

I'll write the docs for this later. For those who want to show the ads somewhere else, alter the codes in Banner System plugin.

[djkristoff]

Database error in vBulletin 3.5.3:

Invalid SQL:
CREATE TABLE IF NOT EXISTS bannersys_banners (
bannerid int(10) NOT NULL auto_increment,
bannername varchar(200) NOT NULL,
bannerdesc varchar(250) NOT NULL,
bannerurl varchar(250) NOT NULL,
imgurl varchar(250) NOT NULL,
bwidth mediumint(4) NOT NULL,
bheight mediumint(4) NOT NULL,
status tinyint(1) NOT NULL default '1',
PRIMARY KEY (bannerid)
) ENGINE=MyISAM AUTO_INCREMENT=1;

MySQL Error : You have an error in your SQL syntax near 'ENGINE=MyISAM AUTO_INCREMENT=1
' at line 11
Error Number : 1064
Date : Sunday, January 8th 2006 @ 11:15:54 AM
IP Address : 68.148.132.214
Username : kristoff
Classname : vb_database

[djkristoff]

works fine after you remove the MyISAM etc ...

A few suggestions that would really help boost this package would be:

- Scheduled Banner Expiration (give a start / end date to which the banner is valid)
- Allow the banners to be uploaded to the board into a folder or the db, instead of linking from an external source
- if there is no link for the banner, remove the <a href> and just show it as a normal image. some people just dont have a website to link to and are just interested in showing their banner.

other than that great job! nice package. helps alot.

[TheAllusionist]

Originally Posted by tnguy3n

I'll write the docs for this later. For those who want to shade the ads somewhere else, alter the codes in Banner System plugin.

Thanks! This is a sweet plugin thanks for sharing it.

[tnguy3n]

Originally Posted by djkristoff

works fine after you remove the MyISAM etc ....

thanks, will fix that. I used MyISAM as default engine.

[guyfox]

I actually had to click no then yes again to get it to work lol. Works great though. Does exactly what it needs to, well done.

[EchoZA]

Originally Posted by djkristoff

works fine after you remove the MyISAM etc ...

A few suggestions that would really help boost this package would be:

- Scheduled Banner Expiration (give a start / end date to which the banner is valid)
- Allow the banners to be uploaded to the board into a folder or the db, instead of linking from an external source
- if there is no link for the banner, remove the <a href> and just show it as a normal image. some people just dont have a website to link to and are just interested in showing their banner.

other than that great job! nice package. helps alot.

I had the same problem, removed the MyISAM line, re-upload the .xml file and all ran fine, but now when I try log into my ADMIN CP I get the following error,

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT * FROM bannersys_banners WHERE status = '1' ORDER BY RAND() LIMIT 1;

MySQL Error  : Table 'vbulletin_treatingyourself_com.bannersys_banners' doesn't exist
Error Number : 1146
Date         : Monday, January 9th 2006 @ 08:46:34 AM
Script       : http://www.treatingyourself.com/vbulletin/login.php
Referrer     : 
IP Address   : 209.203.59.78
Username     : Administrator
Classname    : vb_database

Please help!

[EchoZA]

^^^ I'm going to install phpmyadmin see if I can add the tables manually, looks like the tables were not added

[EchoZA]

If I add the code from the .xml in via phpmyadmin, as follows.

("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "bannersys_banners (
  bannerid int(10) NOT NULL auto_increment,
  bannername varchar(200) NOT NULL,
  bannerdesc varchar(250) NOT NULL,
  bannerurl varchar(250) NOT NULL,
  imgurl varchar(250) NOT NULL,
  bwidth mediumint(4) NOT NULL,
  bheight mediumint(4) NOT NULL,
  status tinyint(1) NOT NULL default '1',
  PRIMARY KEY (bannerid)
) 
");

I get the following error,

#1064 - You have an error in your SQL syntax near '("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "bannersys_banners (
  bannerid' at line 1

Please could I have some help, I'm a little new at this

[tnguy3n]

Originally Posted by EchoZA

If I add the code from the .xml in via phpmyadmin, as follows.

("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "bannersys_banners (
  bannerid int(10) NOT NULL auto_increment,
  bannername varchar(200) NOT NULL,
  bannerdesc varchar(250) NOT NULL,
  bannerurl varchar(250) NOT NULL,
  imgurl varchar(250) NOT NULL,
  bwidth mediumint(4) NOT NULL,
  bheight mediumint(4) NOT NULL,
  status tinyint(1) NOT NULL default '1',
  PRIMARY KEY (bannerid)
) 
");

I get the following error,

#1064 - You have an error in your SQL syntax near '("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "bannersys_banners (
  bannerid' at line 1

Please could I have some help, I'm a little new at this

because you didn't get the database table right.
try:

PHP Code:

CREATE TABLE IF NOT EXISTS bannersys_banners (
  bannerid int(10) NOT NULL auto_increment,
  bannername varchar(200) NOT NULL,
  bannerdesc varchar(250) NOT NULL,
  bannerurl varchar(250) NOT NULL,
  imgurl varchar(250) NOT NULL,
  bwidth mediumint(4) NOT NULL,
  bheight mediumint(4) NOT NULL,
  status tinyint(1) NOT NULL default '1',
  PRIMARY KEY (bannerid)
) 


and if you have table prefix, add it before the table name.