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

[springbok]

My little mod to this hack just allows rotation. KarateKid is the true master behind this hack though.

[Marty McFly]

Originally posted by springbok
Which template did you put the

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

link into? Please confirm that you did the mai hack install as per normal and then made the changes I have suggested.

i put it on forumhome, forumdisplay, and viewthread. i did the whole banner hack, then the rotation hack...still nothing.

[KarateKid]

hm, I'll have a look on your rotation addon, maybe then I can help you in your problem

regards.

[clangrounds.com]

Hmmm, yes this hack would be absolutely excellent if it had the ability to rotate the ads on a timed basis, or even a refresh for that matter.

[KarateKid]

yes I can imagine, but that was not my intention. What I want is a hack which counts views and clicks and thats what this hack does currently.

[digitalJE5U5]

Anyway to get this to support FLASH banners?

All my banners are .swf, but Id like to use your tracking system.

Thanks,
/DJ

[KarateKid]

hm, in this case you have to modify my hack a little bit, so that it doesn't place the <img> Tag but the right tag for your flash banners. Just have a look on my code.

If it doesn't work you could format your flash to gif, or?

Best Regards.

[digitalJE5U5]

Just have a look on my code.

Which code are you referring to, exactly?

Thanks for the help,
/DJ

[KarateKid]

hm,

you have to change many things, at first the tags you place in forumhome, because they aren't <img> tags anymore.

[nissanpower]

Hello,

I followed the installationinstructions.txt file to the T and when I attempted to create the mysql tables, this is the error message I received.

SQL-query : [Edit]

CREATE TABLE banner (
id int(11) NOT NULL auto_increment,
url_to_banner varchar(255) NOT NULL default \'\',
redirector_url varchar(255) NOT NULL default \'\',
height int(11) NOT NULL default \'0\',
width int(11) NOT NULL default \'0\',
banner_text varchar(255) NOT NULL default \'0\',
guestclicks int(11) NOT NULL default \'0\',
userclicks int(11) NOT NULL default \'0\',
views int(11) NOT NULL default \'0\',
reportuserid int(11) NOT NULL default \'0\',
PRIMARY KEY (id)
) TYPE=MyISAM;

MySQL said:

You have an error in your SQL syntax near '\'\',
redirector_url varchar(255) NOT NULL default \'\',
height int(11) NO' at line 3

I also attempted to create the second table and this is what I got.....

CREATE TABLE userclicks (
userid int(11) NOT NULL default '0',
bannerid int(11) NOT NULL default '0',
clicks int(11) NOT NULL default '0',
PRIMARY KEY (userid,bannerid)
) TYPE=MyISAM;

I'm just copying and pasting them over. I tried several times, so I'm sure I'm not typing anything incorrectly. Can someone give me any ideas what could be wrong here?

Thanks!
-Gabriel