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

and here the screenshots :)

This looks great, it would it possible to have it intergrated with the store hack, so every time a user clicks on the banner, he gets a point. He/she can only click on that anner every xx hours!

something like that any way...

nice hack though :)

of, course thats possible. Just integrate it in my click.php file with an UPDATE SQL Statement :)

Very cute - thank you! I will install it later.

Would it be possible to integrate this with vbPortal's banner admin system?

Would it also be possible to enhance this hack further to accommodate button and icon ads?

of course. It should work currently

You can choose a banner/button/icon, whatever you want. It works with the image-tag ;)

How though? Does it pull the info from the vbPortal banner system, such as Impressions, Imp left, Client name/contact, etc? Or does this have its own database section which would require an advertiser to login to both the vbPortals banner stats section and this hack's stats section separately?

Will this hack add a second banner to the top of pages that already have a banner ad up there via vbPortal's banner admin system?

oh sorry, I think I misunderstood you. You can place the bannercode created with my hack also on vbportal. That was what I mean, but you're right, at the moment there is no possibility to integrate it with the bannersystem of vbportal. This would be to complex, sorry ;)

Ah well... maybe one day someone will create an all-encompassing banner admin system!

Until then, at least this one supports button and icon ads! :)

does the system work with html banners?

this is fantastic...

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

Change to...

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

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

@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 :)

Thanks, will install it later

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! :)

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.

It works like a charm now!

I have a request...can you make an addon: If in Admin panel one could type that memberid "1,2,3,..." will not count against views/hits.

thank you!

Karate Kid:

Nice work. I was just wondering if you thought of adding a variable such as groupid. You could add this row to the table and add a Group ID to your banners. If they fall into the same group then you could have a random command pick first one banner then the others that are in that group. Then if it doesn't have a groupid then you just display that banner.

So let's say you have 3 banners that you want to rotate within the same place on your web page and they would all have the same groupid. If there is no groupid associated with the inserted code into your web page then it is the sole banner that gets displayed.

Clear as mud? :)

Ideas?

Thanks,
Parker

@bandersen: If I have the time at weekend, I'll try to implement this. It will be easy ;)


@Parker Clack: I could do this. It would be no problem. But then I would make a features, which PPN still allows with his ads hack and I don't want to copy an idea, so just take his hack in combination with this one :)

Greetings

KarateKid:

The idea may be the same but the implementation of it would be different.

As I stated this would add a groupid to the banner table. Then you would do a check in your click.php and view.php files to see if they are in the same groupid or not and if they are then post them in the same place in a random fashion. It the bannerid does not share a groupid with any other banner then it would be the only thing displayed.

I would do this myself but I am not sure how to write the code.

Thanks,
Parker

This is a very nice mod. Thanks!

sch?ner hack!
gef?llt mir!

da ich ja weiss wer du bist bin ich mal so frei und schreibe deutsch:D

When I try to delete banners it goes to a 404 page not found screen ?

HM

Also where do I insert the code to make the banners apear between catagories ?

HM

@ ModshackUK:

- hm deleting the banners isn't a problem on my board? Did you implement all parts of the code?
- for putting the banner between two categorys you've the possibility to create a new template with the value of the code or to put the code threre in where the categories are breaked :)

Hi KK :)

I did the install to the letter and for some reason when I try to delete the banner it just goes to a page not found page ? I will go over it again step by step as its probably something I have or have not done :)

Also will the same banner be placed between each catagory or can I use different ones ?

Thanks for the help

HM

Hi,

You can place there only one banner. But you can of course change it ;)



For the deleting-bug I'll search in the next days ;)

Cheers m8 your a star :)

HM

I was just wondering if this would work on skyscraper banners (120X600 and 160X600). Can anyone help on what template I should revise to have the banners appear at the right side of the screen? TIA.

@ rsuplido:

You should put them into forumhome oder header template, but the position has nothing to do with the hack, or?

can someone help me out i keep getting this error:

----------------------------------------------------------------------------
Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO banner (url_to_banner, redirector_url, height, width, banner_text) VALUES ('http://www.mysite.com/images/twis2.jpg', 'http://www.mysite.com/forums/showthread.php?threadid=10818', '60', '468', ?banner?)
mysql error: You have an error in your SQL syntax near 's Twisted! 2')' at line 1

mysql error number: 1064

Date: Tuesday 23rd of July 2002 11:42:42 PM
Script: http://www.mysite.com/forums/forums/...ner_manage.php
Referer: http://www.mysite.com/forums/admin/b...php?action=add
------------------------------------------------------------------------

-thanks

i dont understand why its looking for the script @

hm,

have you done all database modifications including adding the extra tables?

Greetings

Seems like a great hack.
Isn't it possible to add a text right below the banner ?

A text under a banner can eaily dbl. the clicks on a banner.

Cheers

currently it isn't possible, sorry

should I add both tables at once or at two different instances?