vbStats

For vBulletin version: 2.3.x
Files added: vbs_counter.php, vbstats.php, vbstats_admin.php, vbstats_set.php
Files to edit: None! (all hacking is optional)
Current Version: 230.b (02.14.03 - 3am CST)

What does it do?

• Tracks + Displays Visitors Browser
• Tracks + Displays Visitors OS
• Tracks Referring Sites
• Tracks Total Hits
• Tracks Top Posters
• Tracks Top Forums
• Tracks Top Threads
• Displays a Massive Amount of Stats
• Link Queue!
• Install File!
• Un-Install File
• Intergration with vBPortal 2.x/3.x
• Members,Staff,Active,Non-Active,Activity Level,Newest Member,Top Referrer
• Threads,Posts,PMs,Thread Views,Page Views
• (vBPortal) News Stories,Comments,Weekly Surveys
• (vBPortal 3.x) Link Categories, Links
• More but I'm tired of typing already

Check the samples:
Stats
http://www.talkloud.net/forums/vbstats.php
Incoming Referrals
http://www.talkloud.net/forums/vbsta...ction=incoming
Member Referrals
http://www.talkloud.net/forums/vbsta...on=memberrefer
Top Posters
http://www.talkloud.net/forums/vbsta...ion=topposters
Top Threads/Forums
http://www.talkloud.net/forums/vbsta...ion=topthreads
Top Visitors Countries
http://www.talkloud.net/forums/vbsta...action=country


Here's the newest version, it's only been a year and a half since the last update!

Translations have been removed as it just made it easy for people to get the hack even without a license. I am hoping people who make translations will be kind enough to post here.

Special Note: I am about as far as it gets from a PHP guru. This is my first hack or addon or whatchamacallit. If this somehow nukes your system Im quite apologetic, but I know you will all be smart enough to BACK UP YOUR DATABASE BEFORE INSTALLING THIS.. I have faith Brad and Chen have both checked this out and given their stamps on it but that doesnt mean it will all Gel for you. Be smart, back it up.

Install: There is a self install file that takes care of the templates and tables, simply unzip the package and upload it (with paths) to your vbulletin directory. Then run the install. Please be sure you add your site (yoursite.com) to the excluded urls in the CP. If you dont your site will get counted as a referrer and that can get messy.

Demo: You can of course see the demo at http://www.talkloud.net/ however if you'd like to see it in use on some other boards check out vbstats page where I will try to keep a list of installs for you to check out. If you do install it please let me know so I can put your site up!

I tested this on my test forum, and on one public forum, and all went well, if there are any problems you notice please report them here as soon as possible.

-------
CHANGELOG

[230.b] Changed Active Users to fix a small bug.
[230.b] Like, tested it and stuff..
[230.a] The MySQL Row=O error is now customized to say add to the template!!!!
hopefully no more "where did I go wrong?" posts! Muahahaha!
[230.a] Fixed Upgrade Counter (?action=upgrade)
[230.a] Set Excluded URL.. Now lists URLS
[230.a] Updated Istall to be compatible with vB 2.3.0
[230.a] Changed Most Number Results to Have a , format (ie 1,000 instead of 1000)
[230.a] I decided Frosted Flakes really are pretty tasty.
[230.a] Implemented Kurafires Member Referrer Changes, thanks Kura
[230.a] Implemented Kurafires Top Posters rewrite.



DEAR GOD CHECK THE SECOND POST OF THIS THREAD BEFORE YOU ASK A QUESTION!!!!

[JJR512]

In the "Exclude vbStats URL" part of what's installed into the Admin CP, I put my URL in (as "jjr512.com", no quotes), but when I check it, it once again says "domain.com". It seems this field is not saving. Any ideas?

[JJR512]

Also, about the setting for "Date Statistics Begin" setting. The default is "952001". What is the format for this field...is it MDYYYY (Sept. 5, 2001) or DMYYYY (May 9, 2001) or something else? How would I put in October 22, 2001?

[JJR512]

Another question. On the stats page, on the Top Posters section, how are the numbers generated? I ask because in the "Ever" part, for me it says my post count is 9873. My post count is 9553; if you click on the link of my name to see my profile, that's the number it shows. It looks like everyone's post counts are wrong.

[fury]

Forgive me if this error has already been pointed out, but I just skimmed through the posts in this thread.

I tried installing, and got a mysql error and an internet explorer crash, so I couldn't copy down the error.

I called the script again, hit uninstall, and here's what I got:

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE user DROP INDEX referrerid
mysql error: Can't DROP 'referrerid'. Check that column/key exists
mysql error number: 1091
Date: Tuesday 23rd of October 2001 02:55:11 AM
Script: /forum/admin/install_vbstats.php?s=&step=2
Referer: http://localhost/forum/admin/install_vbstats.php?

So then I tried to reinstall it. Here's what I got:

Database error in vBulletin Control Panel: Invalid SQL: CREATE TABLE vbstats_counter (
type varchar(80) NOT NULL,
var varchar(80) NOT NULL,
count int(10) unsigned NOT NULL
)
mysql error: Table 'vbstats_counter' already exists
mysql error number: 1050
Date: Tuesday 23rd of October 2001 02:53:02 AM
Script: /forum/admin/install_vbstats.php?s=&step=3
Referer: http://localhost/forum/admin/install_vbstats.php?

It will not go any further in the install process, so I'm pretty much stuck. The board still works, so I'm sure the database hasn't been corrupted.

Note: This is on a different board than the one in my sig.

[patvdv]

I would have to second JJR512's remarks. The number of posts on my stats page are also wrong. vbstats is showing more than posts than the actual number????

I noticed in second instance that it is only for myself. Could this be linked to posts that have been deleted? Is vbstats showing the total number of posts ever made, regardless whether they still exist or not?

[amykhar]

Originally posted by JJR512
In the "Exclude vbStats URL" part of what's installed into the Admin CP, I put my URL in (as "jjr512.com", no quotes), but when I check it, it once again says "domain.com". It seems this field is not saving. Any ideas?

It is saving Check your database. That field will allow you to enter more domains to exclude. For example, my forums have two domains. I can exclude both of them.

Amy

[amykhar]

Originally posted by JJR512
Another question. On the stats page, on the Top Posters section, how are the numbers generated? I ask because in the "Ever" part, for me it says my post count is 9873. My post count is 9553; if you click on the link of my name to see my profile, that's the number it shows. It looks like everyone's post counts are wrong.

I believe it is looking at actual posts for a given period. Do you have some forums where posting doesn't count towards the post counts? That would cause the problem you are seeing.

Amy

[amykhar]

Fury,
Go to phpmyadmin, and manually delete the extra tables that were created. Then, go to your control panel and manually delete the new templates. Then try to reinstall

Amy

[Bane]

Originally posted by JJR512
In the "Exclude vbStats URL" part of what's installed into the Admin CP, I put my URL in (as "jjr512.com", no quotes), but when I check it, it once again says "domain.com". It seems this field is not saving. Any ideas?

This is saving, it just allows you to put in multiple domains, I really need to work on the entry method

Originally posted by JJR512
Also, about the setting for "Date Statistics Begin" setting. The default is "952001". What is the format for this field...is it MDYYYY (Sept. 5, 2001) or DMYYYY (May 9, 2001) or something else? How would I put in October 22, 2001?

Whatever you want it to, It is just used for a couple of "Since 09-04-2001" type things, for display only so whatever format you like.

Originally posted by JJR512
Another question. On the stats page, on the Top Posters section, how are the numbers generated? I ask because in the "Ever" part, for me it says my post count is 9873. My post count is 9553; if you click on the link of my name to see my profile, that's the number it shows. It looks like everyone's post counts are wrong.

Right now it is counting the number of posts in forums that dont increment post counts. For example if you have a testing forum where post counts dont go up with posts it will count that too.

Amy: Thanks for the help

[amykhar]

Originally posted by Bane

Amy: Thanks for the help

What can I say? I'm a morning person.

Amy