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

[KarateKid]

Of cource, yes, for creating the tables in your database as I wrote in the install file!

[JGUNS]

there is where my problem is. When I tried to do myphpadmin, I created a new folder called "xxxphp" in my forums directory and uploaded the phpmyadmin files. when I log on to http://www.mysite.com/forum/xxxphp I get a black, bold "PHPMyadmin" and then below that, where the db is supposed to be listed, it says config.inc.php. When I click on it, I get an error screen. What did I do wrong?

[KarateKid]

öhm, did you enter the right values into the config file?

Is php enabled on this webspace?

could you show me the link?

[JGUNS]

See PM for link. I changed the following values inthe config file:

Your phpMyAdmin url
*
* Complete the variable below with the full url ie
* http://www.mysite.com/jgunsphp/

$cfg['Servers'][$i]['host'] = 'mysql.mysite.com';

and I added the password to my site under:
$cfg['Servers'][$i]['password']


Otherwise I left everything else alone. Incidentally, when I changed the config file and saved it, is said it was removing all formating. I guess that it becomes a pure text file. Did I not fill out the variables correctly?

[LouChipher]

Can I add in the Url for inside Links "$session[sessionhash]" ?

[KarateKid]

@JGUNS:

I don't find a solution. Could you use the search function in this board hier. I think, there will be some threads about phpmyadmin configuration

@LouChipher:

Why not? Yes, try it out, it should work

[LouChipher]

KarateKid, wenn ich es im CP einbinde, also bei der URL Angabe, dann geht es zwar, aber die Session wird beim klicken nicht eingefügt, sondern eben die Variable ist nur zu sehen...

[JGUNS]

What about this I changed the config file and now I get something.

I installed phpmyadmin and I get a screen with all of my threads and folders from my root and subdirectories. On the top it has my sqldatabase name- root directory name. You can pick between others. When I go to mysqlusername with no root directory it says "access denied, password NO"

Where do I run a query from? I don't see any query buttons. BTW, php myadmin is installed in the root directory, I dont know if that makes a difference. My bulletin board is in a subdirectory called "forum" Thanks for any help.

[KarateKid]

@JGUNS:

The location of phpmyadmin doesn't matter. Only the right variables are important.

@LouChipher:

[german]hm, dann geht es wohl doch nicht. Bin grad am ?berlegen warum nicht, was willst du denn genau machen, dass du interne links verwenden musst um die Session zu erhalten, vielleicht kann ich dir so helfen [/german]

[hypedave]

ok got this installed now question, how do I get the banner ads to dispay your instruction arent to detailed as to how to get a banner to show on the home page?

oh yes when I go to delete a banner I get the following error

The requested URL /forums/admin/banner.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request