VB Banner Control 1.2

Hi,

with the allowance of Firefly I repost this hack. At first I want to mention that I used PPNs ads hack only for one file in the adminoptions as a template. He made this file so perfect that I looked how he solved the adminconfigurations file for his hack.
The rest is without viewing on other hacks coded by me.

This hack has the following features:

- allows you to create banners dynamicly
- you can view stats:
-> guestclicks ( how many not logged in guests clicked on the banner )
-> userclicks ( which user has clicked how often on which banner )
-> views ( how often is the banner viewed )
- control theses stats over an admin cp script which let you:
-> add new banners
-> edit banners
-> remove banners
-> view the stats
-> remove the stats
- NEW in 1.1: Useroverview:
-> you can give a user of your forum the possibility to view the stats via ACP
-> he can see the views, userclicks and guestclicks
- NEW in 1.2: Put Banners between categories
-> you can assign each category via phpmyadmin an banner which is under this category shown
-> therefor you've to split the categories, that you have space between them

For an example, you can have a view on www.kampfkunst-board.info. The 2 banners in the middle are created dynamicly by my scripts

Here in this post I add the hack, in the next post, the screenshots

[mateo1221]

Installation question: in the first line it says to add the following tables... which database or does it matter???

[KarateKid]

Yesterday at 10:58 PM mateo1221 said this in Post #131
Installation question: in the first line it says to add the following tables... which database or does it matter???

of course same database as vbulletin!

[mateo1221]

Yeah, realized just how dumb that sounded as soon as I posted it... Now here's a second question... when it says to search for a line of code:

makenavselect("Statistics & Logs","<hr>",$df);

and insert lines below it, where do I search for code? I have looked everywhere and I've seen it 1000000 times before, it's just evading me for some reason... :cross-eyed:

[KarateKid]

which vbulletin version do you have?

[Dean C]

KarateKid - i had this installed a while ago and i installed it again this week.

You have a little bug in there regarding the use of single quotes to output the relevant HTML. It should always be double quotes and this is my code:

PHP Code:

$code = "<a href=\"$forumurl/click.php?bannerid=$bannerid\" target=\"new\"><img src=\"$forumurl/view.php?bannerid=$bannerid\" border=\"0\" width=\"$width\" height=\"$height\"></a>"; 


- miSt

[KarateKid]

ok,

I know that this hack is buggy,

but I'll fix all the bugs, when I redevelop the hack for vb3.

Regards

KarateKid

[Madacc]

I get really frusterated trying to find answers to problems that no one solves. I have fixes to all the problems that were caused with the banner rotation addon by springbok.


Problem: Banner pictures are not showing up
HIS CODE WAS THIS:

Find:

PHP Code:

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


Add After:

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']; 


Solution (Do this instead)
Find:

PHP Code:

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


Add After:

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']; 


Problem: Banners are leading to the wrong URL (after clicking)

Open: click.php
Find:

PHP Code:

error_reporting(7); 


Add After:

PHP Code:

$thebannerid = $_GET['bannerid']; 


Find:

PHP Code:

$boarduser = $bbuserinfo['userid']; 


Add After:

PHP Code:

$bannerid = $thebannerid; 


Save and reupload click.php


That should solve the problems people have been having. I hope I just saved a bunch of people

[PAINTBALLM]

**Installs** good work karatekid

[Sia Bani]

Would this work with VB3 beta 7?

[DiscussAnything]

I installed this on a test forum that's running 2.3.0, and i'm pretty sure I did everything correctly. The ads to show up, but its a broken image. When I click the link it does link to the correct referrer though. I was doing this on a localhost, which links images from the internet (from a site that does allow image linking). Also, the views/clicks were not updated and remained 0. Is there anything obvious I overlooked or does it not work for a localhost install?

Are there any other banner hacks which track the traffic, perhaps?