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

[KuraFire]

Originally posted by DarkReaper
Also, for the last 30 days...it could be right, but most likely isn't...800 posts in 30 days? Um..yea.

Bwhahaha, forum-n00b!

I once posted 2000 posts in 30 days, not a single post was spam or anything. It can be done easily, y'know. Just work in a position where you can surf online all day long and you can easily amount up to 3K of posts a month, less if you actually post LONG posts all the time (like I usually do... *shudder*).


Anyway...

TheRealist: you have to add a line to your phpinclude template. You can find that in your Admin Panel > Styles: Modify > Edit Fonts/colors > first template is the phpinclude template. Add this line to that template:

include("vbs_counter.php");

That should take care of all the Division by zero errors.
The other problem, I don't know..

[FWC]

Originally posted by KuraFire
And to FWC: Would you please tell me how you have the whole Statistics block coded into your Forum Home page? I'm talking about the block that starts with a link to the vbstats.php and ends with "Hottest thread this week" - I would LOVE to have that overview on my forum home as well, please tell me how to code this in there. I'd be very grateful

That isn't vBstats, though I did put the link to vBstats at the top. That's a couple of hacks I merged together and modified. It's just one chunk of code and one template now. Send me an email and I'll work up some instructions and send you the stuff.

[DarkReaper]

Originally posted by KuraFire


Bwhahaha, forum-n00b!

I once posted 2000 posts in 30 days, not a single post was spam or anything. It can be done easily, y'know. Just work in a position where you can surf online all day long and you can easily amount up to 3K of posts a month, less if you actually post LONG posts all the time (like I usually do... *shudder*).

Bah. What about my other problem, with the most posts ever counts varying?

[KuraFire]

Not sure about the other issue DR, sorry. I can only come up with it something to do with the fact that they messed around Big time with postcounts on those forums - seeing as how they don't show up anywhere aside of on the vbstats page, I think it safe to assume they Might have messed with the post counts on different locations as well, which, in turn, could be the reason these postcounts are messed up in different places.

Also, could be just something to do with the way they have the queries in vbstats implemented - i.e. do vbstats' queries select posts from the user's Current Postcount, or all of the users posts INCLUDING those in forums that don't COUNT towards your post count, and/or does it include deleted posts?

It's probably something with queries combined with their messing about, but again: I am not sure on Any of all this!

[DarkReaper]

I run those boards, and haven't touched the post counts. I removed post counts from displaying because of issues with them, and spam...

[The Realist]

Any help on the below chaps?..................Please.

I have 2 problems.

1) I am running version 2.2.1 and in admin/index.php I cannot find:

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("Stats & Logs"); ?>

BUT I can find something similar to:
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">

So I placed the requiered txt above that "IS THIS CORRECT" OR WERE SHOULD I PLACE IT"

Also I am getting the following errors when wiewing the "View Public Statistics" in CP.

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 159

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 165

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 162

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 186

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 148

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 139

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 145

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 142

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 136

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 151

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 154

Any help please?

[FWC]

Originally posted by The Realist
Any help on the below chaps?..................Please.

Message #482 above:

Originally posted by KuraFire
Anyway...

TheRealist: you have to add a line to your phpinclude template. You can find that in your Admin Panel > Styles: Modify > Edit Fonts/colors > first template is the phpinclude template. Add this line to that template:

include("vbs_counter.php");

That should take care of all the Division by zero errors.
The other problem, I don't know..

For your other issue. Put this:

PHP Code:

// vbStats 
makenavoption("Config","vbstats_set.php?action=edit","<br>"); 
makenavoption("View Public Statistics","../vbstats.php?action=stats","<br>"); 
makenavoption("Exclude URL","vbstats_set.php?action=add"); 
makenavselect("vbStats","<hr>"); 
// vbStats 


under this:

PHP Code:

// ***
makenavoption("Statistics","stats.php?action=index","<br>");
makenavoption("Admin Log","adminlog.php?action=choose");
makenavselect("Statistics & Logs",$df);
//*** 


You should be set to go.

[DarkReaper]

Me next, me next!

[FWC]

Originally posted by DarkReaper
Me next, me next!

vBstats directly queries the database and pulls the current post totals. It does not filter for forums where you exlcude post counts. It is a real time total post count as far as I know.

[KuraFire]

Originally posted by FWC
vBstats directly queries the database and pulls the current post totals. It does not filter for forums where you exlcude post counts. It is a real time total post count as far as I know.

Yeah but there was someone who added to the vBStats-query to make it count ONLY realtime posts, thus Excluding those from forums that don't count posts. That query is SOMEWHERE in this thread, but I'll be damned to know what page exactly!

And that's why I would love to see someone make an overview again. But my guess is that Bane is really busy so I'll be patient and shut up again