[springbok]

Hi,

Please be warned that I have never coded a line of PHP before tonight, but have come up with a solution to the rotation for VB Banner Control 1.2. (Through much hacking of other people code and testing)

I have installed and tested both the Ad Management and VB Banner Control on my site but found the VB Banner Control to be the better (for my needs), but lacking a rotation facility. So I have removed the Ad Management one completely, installed VB Banner Control 1.2 from scratch again and made the following changes to get rotation working.

I do not know whether I am allowed to post this modification, if not please feel free to delete this post immediately.

I can confirm that I have been testing this for the past 4 hours and its working fine but - USE THIS AT YOUR OWN RISK - I cannot be held responsible if anything goes wrong.

1. So, do a complete installation of VB Banner Control 1.2 (I am using VBulletin 2.2.7 and its working great.).
2. Open /global.php
3. Find:

PHP Code:

  if ($getforum['styleoverride']==1 or $bbuserinfo['styleid']<2) {
    $codestyleid=$getforum['styleid'];
  }
} 


Below that add:

PHP Code:

// Banner Management
$bannerad=$DB_site->query_first("SELECT * FROM banner ORDER BY RAND()");

$bannerid=$bannerad['id'];
$bannerheight=$bannerad['height'];
$bannerwidth=$bannerad['width'];
$banner_text=$bannerad['banner_text']; 


No further file modifications required. So save or upload this file.

4. Normally with the VB Banner Control hack you would go through the Control Panel and use the getcode link and copy and paste that text into wherever you would want the banner to appear. Normally the Header template. If you are using this tweak you will not have to do this again. Just replace it with the following:


<a target='blank' href='http://www.yourdomain.com/click.php?bannerid=$bannerid'><img border='0' width='$bannerwidth' heigth='$bannerheight' alt='$banner_text' src='http://www.yourdomain.com/view.php?bannerid=$bannerid'></a>


Change the www.yourdomain.com with your sites correct domain name.

And that's it. Now you will have a fully operational banner rotation with all the banners you have in the banners table.