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

[rave42]

im trying to get vB Banner 1.3 to work with 3.0.3 and its not going very well.

Under VB Banner Control when i click add i get
Fatal error: Call to undefined function: makeinputcode() in
C:\Inetpub\wwwroot\site\forums\admincp\banner_mana ge.php on line 37

and when i click on Modify i get
Fatal error: Call to undefined function: doformheader() in
C:\Inetpub\wwwroot\site\forums\admincp\banner_mana ge.php on line 171

so it would seem im its not working at all. Any sugestions would be greatly appreciated.

[Omar_2002]

Same problem here (v3.0.3)

[SKerr]

Oops, my bad.. it would help if I included the right banner_manage.php file (I was working on this at home over the weekend and forgot to get the updated file from my ftp server).

Try this new one instead..

[Omar_2002]

Thanks Steve,

Also, one other minor error: in click.php - it throws up an error, because "bid" in the insert statement should be "bannerid"

Thanks for the great hack

- Omar

[SKerr]

Oh yeah.. I see. The line in click.php:

INSERT INTO userclicks (userid, bid, clicks) VALUES ('$boarduser', '$bid', '1')");

should be

INSERT INTO userclicks (userid, bannerid, clicks) VALUES ('$boarduser', '$bid', '1')");

And thank KarateKid for the hack.. I just needed it to work for a client who just upgraded to 3.0.3.

[Omar_2002]

Steve,

I'm not quite sure what you are saying in your post.

When using the click.php as-is, I was getting a db error when clicking on a banner, saying the column "bid" was not found in the table.

I assumed that this was to do with the following line in click.php:

$DB_site->query("INSERT INTO userclicks (userid, bid, clicks) VALUES ('$boarduser', '$bid', '1')");

Specifically the "(userid, bid, clicks)" - I have limited php knowledge, but I figured that this might have been the reason for the db error because the column is called "bannerid" and not "bin".

Please correct me if what I have done is wrong and/or might cause instabilities.

Thanks
- Omar

[Omar_2002]

lol, you beat me to the post. Good to know that I'm not going crazy

Thanks KarateKid!!!

[computer1]

dus this work whit vb 3.0.7 ??

[FD929]

Ok I'm kinda stuck here now. I have the banners rotating perfectly in my header. The banners belong to my two sponsors who have forums hosted on my board. What I would like to do is add those banners into the area specified on the attached email. The way I would like to do it, is through a global variable. i.e. the forum id is 47 and the banner id is 47. Therefore, banner 47 should show in the appropriate cell called by the variable in the forum bits. See what I'm saying? I think that was the intent of this post, but since the information refers to vb2 rather than 3, the information doesn't match up, and I can't figure it out.

If anyone can help, it would be greatly appreciated.

[FD929]

Originally Posted by computer1

dus this work whit vb 3.0.7 ??

yes it does