page - hit counter in mysql

Who would ever think me releasing something

Being a newbie at php/mysql programming i had help from tutorials all over the place and from freakysid from SPF forums

1. MySQL based counter

You need:
1. phpmyadmin - http://sourceforge.net/projects/phpmyadmin/ -phpmyadmin install and use guide to add a table named mycounter to your existing vB database.

you need to select you vb database name listed in the left of phpmyadmin and run the following queries once in phpmyadmin

CREATE TABLE mycounter (count INT(11) UNSIGNED NOT NULL);
INSERT INTO mycounter SET count = 0;

i.e. if my vb database is named usertest you should enter like this the screen cap below or here.

2. need to edit your phpinclude template and add the following in:

PHP Code:

$result = mysql_query("SELECT count FROM mycounter");
$mycounter = mysql_result($result, 0) + 1;
$result = mysql_query("UPDATE mycounter SET count = count + 1"); 


save changes

3. then place $mycounter in your footer template

[Whome]

Thank you...installed this one

[Lucky]

Thanks for the , eva2000

[Thomas P]

Sorry, have to reactivate that thread...

@George: Does your counter also show the hits per day?

I have the same problem as you once, my file-based counter resets itself 2-3 times a day (www.mcseboard.de)
http://www.vbulletin.com/forum/showt...threadid=26508

Thanks,
-Tom

P.S.: I'm looking for a replacement of this one:
https://vborg.vbsupport.ru/showthrea...threadid=18096
I joined the club, it now resets itself, too

[Thomas P]

Okay, switched to yours - working fine
Changed it to display daily hits as well as the total hits...
cu,
-Tom

[Davey]

Hey eva2000; this is an awesome hack! JUST what I was looking for.
However, if you could, I'd like to see an IP logging function, where all IP addresses are logged to a PHP/text file in the /admin/ directory.
This would be a wonderful feature, in my opinion, and I hope you can make it possible .

Dave.

PS: If not, then I might attempt myself. In which case, how do you return an ip/hostname?