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

[amykhar]

Here's a bit of what you want to do to exclude private forums. Find in vbstats.php:

PHP Code:

 $topthreadmax=$incoming[topthreadmax]; 


Insert this right after that:

PHP Code:

  $eaex = $DB_site->query_first("SELECT exforum FROM vbstats_options"); 


Then, change the various popular threads and forums queries. example:

PHP Code:

 $topthread3 = mysql_query("select * from forum where allowposting<>0  and forumid not in ($eaex[exforum]) order by replycount DESC limit $topthreadmax"); 


This just a rough draft of a fix. I suggest you all wait until Bane updates before fixing this yourself unless you know what you are doing.

Amy

[Bane]

Whoops, I slept a bit late today.. let me wake up and look at all the problems a bit.

[Bane]

Amy: I put the old file right back in.. its fixed now.

drumsy: Uninstall works splendid.

WizyWyg: When you extract the zip, it will be pathed. When you go into the directory you unzipped into, take a look into the /admin directory. the install_vbstats.php file should be in there.

Floleb7: Style colors would have been great, I probably should have used only that. But I wanted the numbers configurable seperately. I should mention again however that since vbstats is made for vbulletin, everything is modified by templates. You will find the vbstats templates in the same place as the rest of them, you can change the colors there if you wish.

Silviu: The division by zero error is from having no info, when you include the file in your phpinclude or global.php you will stop getting that error and just make a link off your forums to vbstats.php and you should be fine.

Lesane: Thats Kiers showmods.php hack... I guess my way of saying everyone should have it

Delhaze: Thanks for your button program, hehe, it doesn't work for me, but what an addition to the community!.. I would love once I get this working for everyone in a stable manner to figure out the switches with you to make it work on windows based servers, feel free to grab my ICQ or shoot me an email. I believe this would benefit some others as well.

Thanks to everyone for picking up my slack a bit. The download is updated (again) I'm still working on a better country detection method that doesnt default to .com and such. Once again thanks for being patient with me.

The new color4 and exforum settings can be set in the control panel.

[Justice]

ah, finally the long awaited stats hack.

Is the private forums thing fixed in the install? I'll wait til then before installing...

thanks Bane

[dxb]

first of all thank you very much for this lovely hack Bane

I'm having troble with the memberrefer and I've seen the same problem with Don ->LKSAB on the second page of this hack

http://www.lksab.com/forum/vbstats.p...on=memberrefer

and it dose not seem to be tracking the memberrefer

other than that everything is working fine

[Bane]

Justice: You can exclude forums you dont wish to show by entering the forumid in the control panel.

dxb: Do you have the referral system turned on in vbulletin? Check this in options.

[dxb]

yes it was turned off and i turned it on and tried sending email using the refer system but still no change in the memberrefer list

[Bane]

dxb I just registered.. but didnt see the referrer box?

[MarkB]

Originally posted by Bane
Justice: You can exclude forums you dont wish to show by entering the forumid in the control panel.

I've tried that for categories, which were showing up, but no luck... any ideas? Or is it a different tweak?

Still lovin' it!

[dxb]

I'm sorry Bane I dont know what you mean ... where your supposed to see the reffere box do you mean the user info page