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

[cnczone]

Today at 08:15 AM Weasel said this in Post #1130
I went through the code and found that he is trying to do math operations on variables that have been number_formatted, so this error occurs when the number of registered users goes above 1000 and a comma is put into the number to represent the thousands place.

To fix find this:

PHP Code:

    // How Many?
    $numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
    $numbermembers=number_format($numbersmembers['users']);

    // Active/Non?
    $snonposters=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0');
    $nonposters=number_format($snonposters['users']);
    $activemembers=number_format($numbermembers-$nonposters);
 $activityrate=sprintf("%.2f",(100*$activemembers/$numbermembers));

    // Newest Member 


and REPLACE with this:

PHP Code:

    // How Many?
    $numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
    $numbermembers=$numbersmembers['users'];

    // Active/Non?
    $snonposters=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0');
   $nonposters = $snonposters['users'];
    $activemembers=$numbermembers-$nonposters;
    $activityrate=sprintf("%.2f",(100*$activemembers/$numbermembers));
    $numbermembers = number_format($numbermembers);
   $nonposters = number_format($nonposters);
   $activemembers = number_format($activemembers);

    // Newest Member 


What php file is this in?

[Larry Sanders]

The above code is in vbstats.php.

~~~~~~~~~~~~~~

On another note, I have had v2.0.3 installed for a long time on my site. I just upgraded to v2.3. All seems well but I keep getting:

Parse error: parse error in /usr/local/etc/httpd/htdocs/Forums/global.php(313) : eval()'d code on line 6

at the top of each page. FreeBSD server - pretty standard setup without many 'hacks'.

The error disappears when I take --> include("./vbs_counter.php); <-- out of my phpinclude template.

I looked at line 6 of global.php and it reads --< $explain = 1; <---

Anyone know what the 1 is or what's happening?

http://Elsmar.com/Forums/

Any thoughts appreciated.

[zajako]

id like to get my hands on the server stats and all the other ones on talk aloud that do not come normaly.

[Floris]

When can we expect a new version for vbulletin 2.3.0 ?

[NinjaBelly]

When I add this hack it works fine in my forums but then on my vbHome lite it generates these code errors on the top of the page:

Warning: Unknown(./vbs_counter.php): failed to create stream: No such file or directory in /home/hilaryfn/public_html/global.php(929) : eval()'d code on line 6

Warning: Unknown(): Failed opening './vbs_counter.php' for inclusion (include_path='') in /home/hilaryfn/public_html/global.php(929) : eval()'d code on line 6

Any ideas? Thanks.

[ogden2k]

05-24-03 at 09:30 PM NinjaBelly said this in Post #1135
When I add this hack it works fine in my forums but then on my vbHome lite it generates these code errors on the top of the page:

Warning: Unknown(./vbs_counter.php): failed to create stream: No such file or directory in /home/hilaryfn/public_html/global.php(929) : eval()'d code on line 6

Warning: Unknown(): Failed opening './vbs_counter.php' for inclusion (include_path='') in /home/hilaryfn/public_html/global.php(929) : eval()'d code on line 6

Any ideas? Thanks.

Same here...

Also, I don't like when you load a new page, it adds another count to the user's browser / OS in the stats... Shouldnt it count this per IP session?

[Bane]

for the problem with vbhome you may have to take the counter out of the phpinclude template and put it in your global.php.

[ogden2k]

Ok, can you be more specific?

[Mrpolish]

Can you include top 5 posters on you forumhome template ?

[hashesh]

I cant get the exculde userid to actually exclude.. any thoughts?