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

nice work, works a treat..

[eva2000]

nearly forgot about this

For the record it's still working on my forums

Pageviews since Aug 27, 2001 - 10:00 am (AEST): 2668665

[MrLister]

hehe that's quite a few... i guess it works great.

[maverick1236]

NICELY DONE!!!

Works Perfect!!

Thank You!!

[eva2000]

thanks.. i had help from freakysid too so not all my work

[SWFans.net]

I was curious if there was any way to use the figures generated by this hack to come up with page views for the last 24 hours?

[Chrysalis]

the hack worked but it wouldnt accept the following command

CREATE TABLE mycounter (count INT(11) UNSIGNED NOT NULL);

so i used CREATE TABLE mycounter (count INT(11)); instead and the hack works a treat.

[Bedhead]

Great job!

[PhotoGenie]

Great hack.. Only thing I see that should be changed is the placement of it in your page. Someone posted above that they thought avatars might be registering as visits and that his visits were going up 5 times more than they should be. What happens is you put the counter in your footer and then your really just registering clicks and not how many visits to the home page. Your footer shows everywhere so every time a page is loading it is counted as a visit. If you put it in your forumhome template It will only register your main page.

Example:

Welcome to our newest member, <a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$newuserid"><b>$newusername </b></a><br>
There has been <b>$mycounter</b> visits to this page since July 16th, 2001
</smallfont></td>
<td align="right"><smallfont>
The time now is $timenow.<br>


Thanks for the hack I'm using it now.

[PhotoGenie]

Still counting clicks after making changes above. I went back and tried a few other things and got it fixed where it is only counting visits to the main page. Here's the changes below.

I removed :

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

from my phpinclude template.

Open index.php:

find around line 69

$birthdaybits="";

just above it insert

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

and that will fix it to where it only counts the index page.

You can now insert:

$mycounter

Wherever you want your count to appear.