UBB.Developers Forums UBB.threads 6 V6 Modifications Finished-[6.0-6.1-6.2-6.3] Small Site Statistics 1.0

Mod Name / Version: Small Site Statistics 1.0

Description: This modification will collect and display in a box (like a pals box) the hits per month on your site. It can be altered to show the OS used, language etc.

Working Under: UBB.Threads 6.0-6.1-6.2-6.3

Mod Status: Finished

Any pre-requisites: none

Author(s): dimopoulos

Date: 06/06/03

Credits: Nikos Dimopoulos

Files Altered: The file that you want to collect the data, usually index.php

New Files: statistics.php

Database Altered: Yes, new table visits created

Info/Instructions: CAUTION!!!
This script will most probably increase the load on your database significantly, especially if you have a busy site. If you place the script that collects data in your front page then every visitor will require one hit in the database, so be careful before implementing it.

Instructions are included in the attached file.

Disclaimer: Please backup every file that you intend to modify.
If the modification modifies the database, it's a good idea to backup your database before doing so.

Note: If you modify your UBB.Threads code, you may be giving up your right for "official" support from Infopop.If you need official support, you'll need to restore unmodified files.

Screenshot of what you will be able to see in a few months if you implement this modification.

Very nice:

http://zlosnik.pl - look at the bottom of page

Does this record hits, or unique visits?

Very cool Nikos.

Looks like it counts hits... I went to Slawek_L's link, hit refresh and it counted the refresh.

I'd like something like this for unique visitors myself, I have some users who just sit on the site all day and refresh.

Very cool!

Very nice work

Thanks guys.

Josh (other) and Zackary. Yes it will count hits even if they come from people that sit all day long and refresh the page.

I was thinking of incorporating some sort of a cookie to the user's machine which will tell the script that this user has visited the site and no longer do we need to keep these statistics. But how can you justify what is a valid time to live for a browsing? To me if a user hits refresh on a page just to increase the counter is not a valid hit, but the person who is there and reads some posts, does something else later and then refreshes the page again is a valid hit.

We can definitely enhance the script to become a proper pal box and to have it integrated with IIP providing information like the hits per day/month/year, referrer checks etc.

Once again this is not meant to replace retro stats or any other statistics package (especially your raw webserver files). And make sure that if you run this script on your site to monitor the MySQL performance over the period that you run the script. From personal experience, if you have a small site like mine circa 150 hits a day on average then you are fine. For more hits a day, please run your own metrics and let us all know about it.

For the life of me I can't get this to work. I know the answer is staring me in my face.

I keep getting SQL Database only visible to forum administrator's.

I have cleared cookies. I have checked the MYDSL tables and I have even flushed and recreated. The code below is what I enter into the index.php

// --------------------------------------------------------------------------------------------------

// Include the threads main.inc.php file
include_once("{$palspath}/main.inc.php");

// Get the referrer information
$strPathInfo = addslashes(find_environmental("PATH_INFO"));
$strPathTranslated = addslashes(find_environmental("PATH_TRANSLATED"));
$strRemoteAddress = addslashes(find_environmental("REMOTE_ADDR"));
$strRemoteHost = addslashes(find_environmental("REMOTE_HOST"));
$strHTTPAccept = addslashes(find_environmental("HTTP_ACCEPT"));
$strHTTPAcceptLanguage = addslashes(find_environmental("HTTP_ACCEPT_LANGUAGE"));
$strHTTPUserAgent = addslashes(find_environmental("HTTP_USER_AGENT"));
$strHTTPCookie = addslashes(find_environmental("HTTP_COOKIE"));

// Initialize variables
$strQuery = "";

$strQuery = "
INSERT INTO visits
(
path_info,
path_translated,
remote_addr,
remote_host,
http_accept,
http_accept_language,
http_user_agent,
http_cookie
)
VALUES
(
'$strPathInfo',
'$strPathTranslated',
'$strRemoteAddress',
'$strRemoteHost',
'$strHTTPAccept',
'$strHTTPAcceptLanguage',
'$strHTTPUserAgent',
'$strHTTPCookie'
)
";
$dbh -> do_query($strQuery);

$strQuery = "SELECT COUNT(*) FROM ffff_visits";
$sth = $dbh -> do_query($strQuery);
list($lngTotalVisits) = $dbh -> fetch_array($sth);

$lngTotalVisits = number_format($lngTotalVisits);

$dbh -> finish_sth($sth);

// --------------------------------------------------------------------------------------------------

Chuck,

There is a slight error in the instructions (I should have used find/replace).

In my database I call the table ffff_visits while in the modification that I havge posted it is called visits. Hence the statement:

should be in fact

Sorry about that everybody. I have ammended the instructions and also added an image file (bluebar.jpg) which needs to be in the images folder or wherever you need it to be (your choice in the script)

Nope must not like my server

If I put this in my index.php all I get is a white screen.

Same with statistics.php. I look and the table visits has a recorded entry for me. So its half working. But it stops the page from loading.

Weird. Let me check the scripts once more and I will let you know Chuck.

I solved my problem by placing your script inbetween the Threada header and footer statements. So basically I modified it a bit.

You can see what I did. I placed your code in my index.php and then the resulting left code of statistics.php I made into the following attached.

Good points Nikos.

I'll consider this. I run the server here in my home and I don't get a HUGE amount of hits, but I hate to get "inflated" stats because I check the site between 5-10 times a day and I know other users do as well.

I have no other software or services to track stats on my site and this would be handy.

Thanks again for the great mod, I've added it to my "to add" list for when I upgrade to 6.3.

Chuck,

I can see what you did. Since I had that modification as a "pals" box on my site, I was sending the header and footer a lot earlier than this so I didn't need it. With your implementation you can have it even as a standalone page.

Thanks for that

Zackary,

I don't think that checking the site five or ten times a day makes inflated stats but I see what you mean. I had the same problem with a stupid person who managed to go and refresh so many times just to bring the counter up to 500,000. Fortunately I got there in time and killed his connection.

There is of course room for improvement on this script and if we all decide what is the acceptable time to live for a connection to become new then I can modify it to write to a cookie hence not double count hits.

Nikos yes I found out f from inadvertantly realizing from your directions you did not say pal box etc. So I tried running it standalone and realized wait it does not know what a tablewrapper variable is. HMM Okay let me add this and that. It's all good.

Nikos yes I found out f from inadvertantly realizing from your directions you did not say pal box etc. I did notice on this thread though it says can run in a box ( like a pal box ) So I tried running it standalone and realized wait it does not know what a tablewrapper variable is. HMM Okay let me add this and that. It's all good.