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

[Bane]

Originally posted by Animaniac1217
What you ahd done (in a later version, that I didn't modify) was that you allowed certain forums to be blocked. I wrote code that will only show if you have access. So if you have access you will see the forum and it's threads, if not you will not see them, and you see everything else just the same. This is for the top 10.

Just to be clear.. You are trying to sell a slight mod to my hack?

[Bane]

GenSec: If that works for JJR512 I will put it in the next release btw, your link in your sig doesnt work?

[JJR512]

Originally posted by Bane
JJR512: Have you pruned threads? I'm looking at my board and it seems to be just the difference of how many posts in the test board.

Maybe try updating the counters?

Nope, I've never pruned. Updating counters didn't do anything; in fact, I even ran a script provided by someone else here a while ago that updates every member's post count with the actual number of posts on record for that member in the database. Sometimes the post count record does get a bit off. My post count came out to be the same thing, though.

Originally posted by GenSec
O, sorry. I forgot to say that above this you shoud change

      $result1=$DB_site->query_first("SELECT username FROM user WHERE userid=$user1[userid]");

to

      $result1=$DB_site->query_first("SELECT username,posts FROM user WHERE userid=$user1[userid]");

OK, I did that and now my correct post count is displayed. So thanks! But there is still one problem left: I am at the top of the list, but the second person has more posts than I do.

[GenSec]

Originally posted by Bane
GenSec: your link in your sig doesnt work?

It's common vB problem. Double http://

[GenSec]

Originally posted by JJR512

But there is still one problem left: I am at the top of the list, but the second person has more posts than I do.

Frankly, I like to have 2 type stats:
based on all posts & based on user counted posts
But if you prefer the last one
change in topposters to

    $toppost1=$DB_site->query("SELECT *
                    FROM user
                               ORDER BY posts DESC
                    LIMIT $toppostmax");
    $bgcolor="{firstaltcolor}";
    while ($user1=$DB_site->fetch_array($toppost1)) {
        $result_1=$DB_site->query_first("SELECT COUNT(*) AS threads
            FROM thread WHERE postuserid=$user1[userid]");
        $threads1=$result_1['threads'];
        $topposters1.="<tr><td width=100% bgcolor=$bgcolor><smallfont><a href=\"member.php?action=getinfo&userid=$user1[userid]\">$user1[username]</a></td><td bgcolor=$bgcolor align=right nowrap><smallfont>$user1[posts] / </smallfont></td><td bgcolor=$bgcolor align=right><smallfont>$threads1</smallfont></td></tr>";
        if ($bgcolor=="{firstaltcolor}") {
            $bgcolor="{secondaltcolor}";
        } else {
            $bgcolor="{firstaltcolor}";
        }
    }

[GenSec]

Btw this code will count not only posts, but also the threads

[epi]

i am new to the vbulliten community and i need some help
i followed the instructions on how to install this hack but it does not show up on my we page.

1. where do i put the code so their is a link to the stats under the view new posts link, and what is the code

2. where do i add websites to exclude from the count

please be specific

[Bane]

Let me answer number 2 first. If you made the changes to the vb Admin CP you click Exclude vbStats URL in your admin CP. If not set your browser to view http://yourdomain.com/forums/admin/v...php?action=add

A screen will come up with Add New Excluded URL simply place the domain you wish to exclude in the text entry box. repeat as needed.

As for where to link it on your site, that is a matter of taste. As an example you could open your forumhome template and find

You last visited: $bbuserinfo[lastvisitdate].

and change it to

You last visited: $bbuserinfo[lastvisitdate].<br>
<a href="vbstats.php">View Forum Statistics</a>

[epi]

thanks a lot that worked great.
another question can you make it display different version of windows instead of all the other operating systems.

[DarkReaper]

What features will the new version contain, and when do you think it'll be released?