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

[Doc203]

Sorry I have been reading till my head hurts can you tell me what these errors are.

("_TOPCOUNTRYERROR","No country information has been logged."); ?> ?>
Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 159

Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 165

Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 162

Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 186

Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 148

Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 139

Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 145

Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 142

Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 136

Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 151

Warning: Division by zero in /usr/local/plesk/apache/vhosts/searchforautoparts.com/httpdocs/vbstats.php on line 154

[Dark_Wizard]

Doc203 >> you forgot to add this include("vbs_counter.php"); to your phpinclude template!

[iblis]

I'm really sorry, I just had to make this little tweak, because it annoyed me
Don't shoot me if it allready have been adressed..

When adding the vbstats to admin/index.php you don't have much coice on where to insert it, it has to be the top or the bottom, or you get a parse error (at least I do). And frankly, I don't like when hacks mess up my menuorder.. I want it pretty much default, so I won't get to confused

Anyways.. here is what I came up with when trying to customize it.
This will allow you to descide for yourself where to put the vbstats-menu in theadmin CP-menu.

If you allready have the vbstats menu installed in admin Cp,. do the following.. else skip this step
Find and erase following in admin/index.php

<!-- vbStats -->
<tr><td><hr></td></tr>

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("vbStats"); ?>
</table>
<a href="vbstats_set.php"> vbStats Config </a><br>
<a href="../vbstats.php"> View Public Statistics </a><br>
<a href="vbstats_set.php?action=add"> Exclude vbStats URL </a><br>
</td></tr>
<!-- vbStats -->

now, find

makenavselect("Announcements");
// ***

and below, add

// HACK VBSTATS
makenavoption("vbStats Config","vbstats_set.php?action=edit","<br>");
makenavoption("View Publis Stats","../vbstats.php?action=stats","<br>");
makenavoption("Exclude vbStats URL","vbstats_set.php?action=add");
makenavselect("vbStats");
// HACK VBSTATS
// ***

this will add the vbstats menu below the announcements.
if you want to position it somewhere else, you can move it to somewhere else on the list, just make sure you insert the code after a "// ***"


Sorry if this "edit" has allready been mentioned or something.. just a little gadget I found useful

[e3ashig]

There are way too many pages to read in here...
Is anyone here kind enough to answr this question.. does this hack work on version 2.2.9 of vBuliten.?
and if so, do i download the file that is in the first post of this thread or is it somewhere else?

[Domenico]

I have this hack installed and it works fine until I made a new template and made it default.

When I go to /vbstats.php all I get is a blank screen.
What is wrong here?

Thanks!

[Ninth Dimension]

when you said you make a new template, do you mean you make a new template set? if so, this page is not working because you don't have the templates that it needs to run.

My recomendation is that you download, and then upload your current template set when making new ones, this wil ensure that you don't miss any of the templates needed.

[Domenico]

So what is next? Should I reinstall it (removing the part that makes the tables)?

[Ninth Dimension]

To be honest with you, the best thing to do is download/upload the old template-set that you was using before (not deleting the new one). Then you should get all the changes you made in the new template you made before and apply them to the freshly uploaded template.

Mind you, if this is the only hack that you have applied to the forum, you might be able to get away with just installing the templates that this hack uses.

I hope that makes sense?

[Akujin]

Right... I'm getting this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/plesk/apache/vhosts/vertical12.net/httpdocs/forum/vbstats.php on line 283

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/plesk/apache/vhosts/vertical12.net/httpdocs/forum/vbstats.php on line 284

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/plesk/apache/vhosts/vertical12.net/httpdocs/forum/vbstats.php on line 285

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/plesk/apache/vhosts/vertical12.net/httpdocs/forum/vbstats.php on line 287

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/local/plesk/apache/vhosts/vertical12.net/httpdocs/forum/vbstats.php on line 288
Table 'lparker.nuke_links_links' doesn't exist

And I installed it correctly. No clue what the problem is though..

[Xer]

fully working on 2.2.9...
thx~