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]

I put up a new zip with that removed.. kindof a stupid mistake on my part since I took out the top referrer bit in the display. It didnt come up on the test board since I never turned on the referrer system.

Please note, If you want to add the top referrer to your front page you can add the following code..

PHP Code:

// Set this to ids you dont want counted, seperated by , 0 for none
$norefer1="0";

// Top Referrer
    if ($usereferrer) {
        $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");
    $tl_refid = $topref[userid];
    $tl_refname = $topref[username];
    $tl_refnum = $topref[referrals];
} 


And in your vbstats_forumhome template add:

<smallfont>Top Referrer: <b><a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$tl_refid">$tl_refname</a></b> (<smallfont color="$tl_color1">$tl_refnum referrals!</smallfont>)
&nbsp;[<a href="vbstats.php?s=$session[sessionhash]&action=memberrefer">Full List</a>] &nbsp; [ <a href="misc.php?s=$session[sessionhash]&action=faq&page=2#referrals">Help</a> ]</smallfont>

This is not fully tested as Im about to go to lunch but it should work dandy. The non referrer top stats is in the zip sorry about the messup.

[|DarkManX|]

thanks, that did the trick

[jselwyn]

1) Excuse my ignorance but what does Activity Level represent?
2) On forum stats I have over 300 views this week and going up all the time but on views in last 24 hours it shows 0 even though total views continues to increase - is this something different?
3) Is it possible to insert some code to find out how many different people viewed the site over a set period of time (even better who viewed the site)?
By the way why is this bulletin board so wide on my screen when none of the others are?
cheers

[Bane]

1) Activity level is percentage of your users that have at least one post. "Active on your board"

2) What server do you run on? It may be possible its not doing the 24 hour function correctly, or that you need to change the var name, not sure.

3) This will be logged per day in the next release. So you can find out how many today, this week, etc..

Because there is code in it and for some reason it doesnt pop out of the table like vbs so..

[|DarkManX|]

my 24 hour stats won't update.....

take a look.....

[Bane]

Like I said A quickie. Try putting this code right after

// Today [FireFly]

$tltoday=time()-(86400);

[Wordplay]

Excuse me but i'm really new to this board. And was just wondering... it says v2.21 in the subject, but your post says that it's v2.03 compatible. Does that mean that it was originally designed for 2.03 but also works for 2.21 or did somebody mess up the subject/post ?

[Bane]

What it means is that for some reason the admin/moderator of this board has taken it upon himself to change the title of the post. It will work with 2.2.1 with the changes that were explained earlier in the thread. But yes, it was originally made for 2.0.3 and yes, I find it as annoying as you do.

[BaldNut]

couple of little problems im having getting this running

first my hands are too cold

secondly i cant find my online.php in on my server ? but it is in my local machine in my vb folder

thirdly i get this message when i click on the online users link

Warning: Failed opening './counter.php' for inclusion (include_path='') in /home/sites/site4/web/vbp_includes.php on line 12

ive also tried changing it to: include("vbs_counter.php"); in the vbp_includes.php file ?

and if i go to http://www.golden-springs.com/vbstats.php i get a blank page ?


i have not changed the hacks on the online.php because it aint their, i looked in the one on my local machine but i could not find the parts i needed to change ? any help will be appreciated

Many thanx

Balds.

PS your all doing a great job here, keep up the good work

[JTMON]

BaldNut,

You put the include statement in your phpinclude TEMPLATE. Not file.