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

[trainer]

does the system work with html banners?

[Dean C]

this is fantastic...

[X-Fan]

Just found a couple of typos in banner_manage.php (also edited it to have double quotes instead of single in the output code).

Find...

PHP Code:

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


Change to...

PHP Code:

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


[Velocd]

I fail to understand what this does exactly, but it looks interesting enough..

[freeshares1]

This looks really interesting but i have 2 questions

1/ I have already installed ppn advert hack do i need to uninstall that one before adding this one or can i just add this as well?

2/ Is it possible to restict the banner so that is is just shown to guest or members with less than X posts

[KarateKid]

@X-Fan: It also works as it is, with single quotes

@Velocd: It manages your banners and count the clicks of users/guests and the views


@freeshares1:

your 1. point: I dont't know. I think you must not deinstall his hack. You can use my hack and his hack together. Just put my code generated through my banneradmin into PPNs pannel

your 2. point: Of course, just write something like if($user[posts]<XXX) ....
It should work

[freeshares1]

Thanks, will install it later

[X-Fan]

KK, yeah, I know single quotes work, but I like double quotes

Also, did you catch the typo? You had heigth instead of height in that line.

[KarateKid]

Originally posted by X-Fan
KK, yeah, I know single quotes work, but I like double quotes

Also, did you catch the typo? You had heigth instead of height in that line.

hehe, ok for the quotes.

ups, sorry for the typo, I'll fix it later!

[bandersen]

I use 2.2.6 and php 4.2.1
and get this error when trying to run the queries:

Invalid SQL: 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;

mysql error: You have an error in your SQL syntax near ';
' at line 6

mysql error number: 1064

EDIT: it seems to work now... I put the code in the non-select SQL query field at first.... will test.