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,

[shadiguy1]

i installed this in 3.0.3 and it wont dosplay the banner but it is inside of my admincp will thius work with this version of Vb.

[MentaL]

anyone care to explain why it appears in navbar for me and not in the footer or any other place i insert the tag too?

www.ragezone.com

[Rastus]

I'm lost. Into what table or page does this go?

2. Master switch
==================================
INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'setting_enbanners_title', 'Enable Banners & Ads System', 5000);
INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'setting_enbanners_desc', 'If this option set to Yes, overal show banners and ads on navbar function will be turned on.', 5000);

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('enbanners', 'general', '1', '1', 'yesno', '1000', '0', '0');
==================================

[AnhTuanCool]

@Rastus - just run them as you run other queries.
@mentalrz - Did you INSTALL the Update?
@shadyguy1 - I'll try to install this hack on vb 3.0.3 later, see if it needs something else

[Rastus]

Ok, so I can make the banners now, see them in the CP, but when I choose save I get this error : "Could not find phrase 'save_banners_x_successfully'."

[PAWS]

Great hack!

One question, I have 2 ad spots (top & bottom) and I was wondering if there was a way that they could show different banners instead of rotating in the same ones at the same time?

[LauraFL]

Ok. I still cannot get this to show up. The banner shows up in my ACP. But there is nothing on the forum.

Can someone please help me?

[AnhTuanCool]

@Rastus - Did you ADD the phrase as Control Panel Stop Message phrase type? If you ain't sure then re-add it and remember to choose Control Panel Stop Message as phrase type.

@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.

@LauraFL - try to install the Update txt which I attached in this thread.

[Rastus]

No, I did not. somehow I missed those

the "phrase" is another SQL Query ?

[AnhTuanCool]

Take a look at the attachment see what I was talking about