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]

DM, Im going to try to repair the country detection as soon as I am able (time willing) perhaps the queen could hand down a edict of some sort should the miracle pass and I get time to do anything. I will *try* to look at it in the next day or so, as well as at least upgrading the instructions for 2.2.2 ...

[Gutspiller]

There is something wrong with the top posters in this hack. Here is the top posters ever for my site using this hack:

http://www.theforumz.com/forumz/vbst...ion=topposters

Now here is the top posters that is just part of 2.0.3:

http://www.theforumz.com/forumz/memb...ers&perpage=15

Why isn't your hack doing it right?

Also, how do I change the default font for this hack to something different?

I would really like to show the top posters for the Last 24 Hours on the front page. Is there a varaible that gets that info?

On the Members Referred page, I would like the reffered names small and aligned to the left, not centered. (Please help me with this one as it is really annoying)

Also I have another hack installed that in the regular whos online it puts the letters PM behind their name and allows you to PM that person that way. On your hack when it shows the people online, on the first person farthest to the left it shows a PM behind their name, but nobody else. What gives?

If you could help me with these problems, I would really really REALLY appreciate it. I love the hack so far, but I am having troubles customizing it and if somebody could help me I would greatly appreciate it.

Thanks.

[Bane]

Gutspiller, most of your customization can be done through the vbstats templates, just like every other part of vb. As far as the top posters, Im aware of the problem, just havent hit on a solution.

[Gutspiller]

Originally posted by Bane
Gutspiller, most of your customization can be done through the vbstats templates, just like every other part of vb. As far as the top posters, Im aware of the problem, just havent hit on a solution.

Maybe it's the way it executes the vbstats then, because I did a search for "Members Referred" Which should of taken me to about where I wanted to be, and yet I searched every new template, and all the php files I modified and couldn't find it. Did I miss it or do I need to search for something else in other files?

[Lionel]

I have been enjoying vbstats from day one. Yesterday I placed the following important code in my php include

ob_start();
require("/var/www/aboutus/textads/textad.php");
$textads = ob_get_contents();
ob_end_clean();

and vbstats stopped working with the following error:

Warning: Supplied argument is not a valid MySQL result resource in /var/www/haitianforums/vbstats.php on line 555
No Database Selected

The code that I placed is very useful and I need them both.

Any idea why this will conflict with vbstats? Once I remove it, vbstats works.

My entire php include looks like this:

include("vbs_counter.php");

// start - get online users (hack by firefly)
$datecut=time()-$cookietimeout;
$headerguests=$DB_site->query_first("SELECT COUNT(*) AS count FROM session WHERE userid=0 AND lastactivity>$datecut");
$headerusers=$DB_site->query_first("SELECT COUNT(DISTINCT(userid)) AS count FROM session WHERE session.userid>0 AND session.lastactivity>$datecut");
$headerguests=$headerguests[count];
$headerusers=$headerusers[count];
$headeronline=$headerguests+$headerusers;
// end - get online users (hack by firefly)

ob_start();
require("/var/www/aboutus/textads/textad.php");
$textads = ob_get_contents();
ob_end_clean();

[FWC]

Have you tried changing the order around? Put the vBStats include last and see what happens.

[Lionel]

I tried reversing the order.

[lifesourcerec]

Originally posted by Bane

I have opted not to modify any VB php files, so how do I add these domains to the exclude list?

Simply point your browser to your vb admin directory address and run the file vbstats_set.php?action=add


What are excluded domains anyhow?

Excluded domains are domains that are not counted as referrers. They wont show up in your referrer list or on the link queue.

I added my URL to the exclude list and it said updated, yet the stats still include my URL.

[FWC]

Originally posted by lifesourcerec


I added my URL to the exclude list and it said updated, yet the stats still include my URL.

Your URL is already entered in the referrers table. You need to delete the entry with phpMyAdmin (or use a mySQL query if you don't have it).

[lifesourcerec]

Originally posted by FWC
Your URL is already entered in the referrers table. You need to delete the entry with phpMyAdmin (or use a mySQL query if you don't have it).

Ok, I removed it from the referrer table and left it in the excluded list. Thanks Now, I'm feeling better everyday on the $160 I spent for vBulletin.