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]

HELP, my stats page has been working great and then I went to turn off the Use vbPortal Weblinks Additions? and then I get this
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cnczone/public_html/vbstats.php on line 353

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cnczone/public_html/vbstats.php on line 354

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cnczone/public_html/vbstats.php on line 355

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cnczone/public_html/vbstats.php on line 357

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/cnczone/public_html/vbstats.php on line 358
Table 'cnczone_cnczoneforum.nuke_links_links' doesn't exist

[Host Directory]

Does anyone know how to add the other options available in the demo version - http://www.talkloud.net/forums/vbstats.php ( [Stats] [Referring Sites] [User Styles]
[Posters] [Forums/Threads] [Attachments] [Recruiters]
[Browser/OS] [Display] [Time Zones] [Regions]
[Errors] [Your Info] [Search] )?

I would really like to add the time zones and the other options.

Also does anyone know how to place the the referring urls box on my forum homepage and add a statistics link to the page?

Currently there seems no way for my visitors to reach the stats page.

Thanks for any help in advance.

[Host Directory]

11-18-01 at 10:51 PM Bane said this in Post #341
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.

I don't really understand what i am supposed to be with the above code, i did download the zip file and have uploaded to my site and added the template, but there still is no stats on my homepage - www.hostcompanies.com/forums

Have i missed something?

Any help really really appreciated.

[Host Directory]

I am having an awful lot of trouble trying to work out addon forumhome hack which is downloaded from here - https://vborg.vbsupport.ru/showthrea...06#post201406.

I have done exactly as the instructions have stated but nothing has changed on my homepage.

I noticed that others have had this problem,

First - https://vborg.vbsupport.ru/showthrea...821#post213821

Now the solution mentioned here is something about changing

PHP Code:

al("\$vbstats = \"".gettemplate('vbstats_forumhome')."\";"); 


Something about the 'external' name of this 'bit' was actually $vbstats and not $vbstats_forumhome as I tried to insert before into forumhome template

I tryed changing the above code to

PHP Code:

eval("\$vbstats = \"".gettemplate('$vbstats')."\";"); 


Still nothing changed on my forum homepage.

So i began my search again and i found this,

Second - https://vborg.vbsupport.ru/showthrea...465#post232465

Bane mentioned something about adding $vbstats in the forumhome template?

I really dont understand....

Could someone help me.... id really really appreciated it, i have spent hours going through the posts 1 by 1 and after about 60 and racking my brain to try to understand the solution i am near to giving up.

Can anyone help ...?

Problem Fixed, for anyone wishing to display the stats on their homepage this is what you do - in clear instructions

1) Goto this post and download the attachment ( addon forumhome.zip ) - https://vborg.vbsupport.ru/showthrea...06#post201406.

2) Inside the instructions, you must add some code to your index.php file. Add the code and now search for - // Today [FireFly]

Just after that code insert

PHP Code:

$tltoday=time()-(86400); 


( if you dont, it means your 24 stats on your homepage wont work properly.

3) Follow the instructions in the attachment and make the template vbstats_forumhome with the code provided.

4) Now here comes the confusing part - it also was not mentioned in the instructions - Find the template forumhome ( under the Forum Home Page Templates catagory ) . At this point it is important to point out that forumhome is NOT the same template as the one you just made in the instructions.

5) In the forumhome template add $vbstats where you want your stats to appear on your forum homepage. For people not familiar with php code, some good advice is to find $birthdaybits and add $vbstats below this.

6) Now go to your forum and you can see how the stats have been added. Even for people that do not know php code, you should be able to work out how to change where the stats appear by going back to the forumhome template and changing the location of $vbstats

7) Be pleased you did not spent 20 hours plus working this out like i did

gre:

[kristiesks]

Hopefully someone can help me. I DLed the stuff, read the install readme and followed all the directions. Up until Step 7 I had no problems at all, and I did successfully finish & upload all file hacks.

What happened with step 7 is that although I DID follow the directions and added

include("./vbs_counter.php"); to my phpincludes template, so that my template looks like this:

// This code is PHP4 only:
// ob_start();
// require("yourheader.html");
// $header = ob_get_contents();
// ob_end_clean();
include("./vbs_counter.php");

when I click "view vb stats" in my control panel I get this message:

vbStats Error!
Be sure to add this line to your phpinclude template:

include("./vbs_counter.php");

you can find you phpinclude template in your vbulletin
admin panel and in the menu templates click |edit| you
should click on the set you wish to edit and scroll down
until you see the name: phpinclude

Your template should look something like this:

// This code is PHP4 only:
// ob_start();
// require("yourheader.html");
// $header = ob_get_contents();
// ob_end_clean();
include("./vbs_counter.php");
__________________________________________________ _

I don't know what to do. I've triple checked to make sure that I added that line, and my phpincludes template looks EXACTLY like what the error page says it should. The vbstats config and the exclude URL pages work perfectly.

I read through the first 17 pages of this thread looking to see if any other users experienced this same problem but I didn't find any, sorry if I overlooked something and am asking this question again.

Hope someone can help, thanks!

[Host Directory]

Does anyone know how i may get the Link Queue to appear on my homepage?

I have already installed the addon forumhome hack, i would like to have the Link Queue appear in my forum homepage along with the other vbstats statistics - http://www.hostcompanies.com/forums/

Does anyone know how to do this?

[bolynn]

I have some broken images on the vbstats.php page....Im not sure why...

its under browsers:

and

Operating system:

Besides that the hack worked fine...I dont think im going to use it, but I wanted to play with it on my test site..

thanks in advance for help on images problem..

[Buczilla]

Thanks a lot Bane... this really helps!

[ev0lute]

call to undefined

[ev0lute]

sorry about my last reply, i had an error that said, called to undefined function adminlog()