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!!!!

[JTMON]

Hmmm, strange. I had an issue where it was loading slow so I emailed my hosters. We are back to superspeed with the last 24 hours in there.

[|DarkManX|]

could someone help me out with this index.php part of the code, i get a mysql error.....

[SWFans.net]

JTMON: Are you on a dedicated or shared host? I have been having the speed problems/load time issues for over a week(since I added the 24 hour stats to the forumhome) and at first thought it a host issue, but with it lasting so long, I decided to start experimenting. Removing those queries helped my load time a great deal.

Could you PM me the URL of your board and your host provider information, if its not too much trouble?

Dark: Bane provided instrictions and the ones I provided also work, but don't include as many stats as Bane's. Did you revert back to your original index.php and try reapplying the hack?

[JTMON]

Sure SWF, Pm'ing you now.

[Bane]

Dark: Try using the zip that has changed. There was a teeny problem This new one works swell. (or should) I'll attach to this post. Let me know.

The only difference between this version and the excellent Idea from SWFans is this one uses a seperate template. And has a few more stats.

[Pady]

Thanx Bane gunna give this one a try

[orca]

I think you have an error in the following line for the index.php modification:

PHP Code:

$topref = $DB_site->query_first("SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users LEFT JOIN user ON (users.referrerid = user.userid) WHERE users.referrerid <> 0 AND user.userid NOT IN ($norefer1) GROUP BY users.referrerid ORDER BY referrals DESC LIMIT 1"); 


I get a mySQL error there. Looking at the code I think that the variable $norefer1 isn't defined.

[|DarkManX|]

Originally posted by Bane
Dark: Try using the zip that has changed. There was a teeny problem This new one works swell. (or should) I'll attach to this post. Let me know.

The only difference between this version and the excellent Idea from SWFans is this one uses a seperate template. And has a few more stats.

thanks bane, i gave it a try, but i got this error

Database error in vBulletin 2.2.0:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0 AND
user.userid NOT IN ()
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1
mysql error: You have an error in your SQL syntax near ')
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1' at line 4

mysql error number: 1064

Date: Sunday 18th of November 2001 11:34:11 AM
Script: http://www.partylounge.net/tof/tof/index.php?
Referer: http://www.partylounge.net/tof/online.php?

[orca]

Darkman, that was exactly the error I got and I think it's related to that $norefer1 isn't declared.

[|DarkManX|]

hmmmmmmm............i dunno, do you think its just a typo in the code somewhere, or more to it than that?