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

[PhotoGenie]

Here is my installation of eva2000's hit counter hack.. I created a text file in order to save the install for myself.

[Lucky]

Working on 2.2.2, but for some reason it is counting 2 at a time.

Any ideas?

Thank you.

[PhotoGenie]

Originally posted by Lucky
Working on 2.2.2, but for some reason it is counting 2 at a time.

Any ideas?

Thank you.

Read a couple of post above yours

[Lucky]

I realize this, but I want to show total page views not just on the forum home page but all.

[PhotoGenie]

Good luck

[wolfe]

how do i make it have a , like this

67,482

[Jakeman]

installed, works

[nuno]

nice hack george
how can we make it to show daily views also?

[eva2000]

Originally posted by wolfe
how do i make it have a , like this


67,482

change what you have in phpincludes to

PHP Code:

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


[eva2000]

Originally posted by nuno
nice hack george
how can we make it to show daily views also?

use bane's vBstats hack or install www.phpee.com