VB3 MicroStats

You asked for... but it was available for VB2 only? There you go, you have it now.

Looking for 3.5.4 version? Get it here.

VERSION 1.2 RELEASED
Basically the only difference you will notice is a dropdown menu that will display the unchached templates.
In this way, you can add it to the cache and save one or more queries.

[high]THIS HACK WAS TESTED IN A DEFAULT, CODE UNMODIFIED BOARD.[/high]

This hack will add at the bottom of each vBulletin(powered) page the following stats:
REGULAR USERS STATS
- load time of specified page in microseconds (with custom no. of digits to show)
- percentages of PHP/MySQL usage
- number of queries executed

ADMINISTRATOR STATS
- number/name of uncached templates (name highlighted in blue, for uncached template)
- vBulletin DEBUG mode status
- server GZIP library compression status
- average Server Loads

[high]This is not only estethic, it will also help you troubleshoot any wierd queries that you have in your scripts.[/high]

IMPORTANT
If you get results like:
Page generated in 3.35731196 seconds (9.05% PHP - [high]90.95%[/high] MySQL) with 17 queries
You probably use a bad piece of code, because vBulletin will never generate those extreme results.
Imagine this: the code uses only 10% the resources to read the actual PHP code and the rest of 90% is used only to scan the tables... WOW!
That means the code forces to read into the database for each user who visits the site at this percentage... if you have 1000 users viewing the page in the same time.. you can get a picture of it...
If you compare this with vBulletin, the software does the opposite, 90% PHP and 10% MySQL... the right way.

DIVISION BY ZERO ERROR? Read this.
INVALID STATS IF MYSQL COMPILED IN A NON-ENGLISH LANGUAGE? Read this.

NOTE: The blue highlighting is not working in Opera 7.23 version. (Thanks Christine)

Have fun.

[freakyshiat]

Is it possible to add the hostname at the bottom? I am running mutiple web servers, it would help me out

[Deska]

This hack seems not work for vb 3.0.3
Any update for this?

Thank's...

[Onkel_Tom]

I use also vB3.0.3 and have still this hack installed and works fine.

[Colin F]

I don't have any problems with vB3.0.3 and this Hack either
What error are you getting?

[Deska]

I solved my problem.
Sorry for that,

[TTG]

Installed and works fine with 3.0.1. Thanks Tech .. clicked Install

Page generated in 0.25623298 seconds (90.58% PHP - 9.42% MySQL) with 12 queries on main page .. No uncached templates

Page generated in 0.29059601 seconds (81.53% PHP - 18.47% MySQL) with 25 queries on CMPS v1.0.0 portal .. 2 uncached templates

[bilco105]

I am coming to my wits end with this script now,

Parse error: parse error, unexpected T_STRING in /home/dislexik/public_html/forum/includes/functions.php on line 1865

Heres a quote of lines surround 1865, any advice would be good.

	$ms = '<tr align="right">' . "\n";
	$ms .= '		<td class="tcat"' . iif($vboptions['allowchangestyles'], ' colspan="2"') . '><div class="smallfont">';
	$ms .= 'Page generated in ' . $totaltime . ' seconds (' . $msphp . ' - ' . $mssql . ') with ';
	$ms .= $query_count . ' queries</div></td>' . "\n";
	$ms .= '</tr>' . "\n";

[MickDoneDee]

Thanks very much Teck. Have installed and clicked Install.

Using vB3.0.3 and had no problems following the version 1.2 text instructions.

I edited using EditPad Lite. It uses Tabs so that you can have two files open and tab between them for easy comparison.

I don't use a portal and the stats produced on the forum home page with 6 users and 2 spiders online were:

Page generated in 0.13130212 seconds (83.33% PHP - 16.67% MySQL) with 9 queries
DEBUG Mode OFF | GZIP ON (level 1) | 0.04 : 0.13 : 0.17 No uncached templates

That looks relatively normal for a lightly hacked site without a portal and using a shared server.

On one of the Forum Display pages with 6 users online:

Page generated in 0.19516301 seconds (79.20% PHP - 20.80% MySQL) with 14 queries

Server load: 0.06 : 0.23 : 0.21 No uncached templates

You can see that 5 extra queries has increased the server load slightly.

The Members List seems to be more server intensive still:
Server load: 0.33 : 0.31 : 0.24 with only 9 queries.

But still quick loading: Page generated in 0.16052389 seconds (81.20% PHP - 18.80% MySQL)

[Logician]

Apparently the hack produces invalid stats if MYSQL is compiled in a non-english language. This happens because MYSQL can be configured to use different 'lang_decimalsep' and 'lang_thousandsep' variable values which bothers the number formating through vb_number_format() function.

To fix it, I suggest to find:

PHP Code:

$totaltime = vb_number_format($endtime[0] - $starttime[0] + $endtime[1] - $starttime[1], $msdecimal); 


in the hack code inside functions.php

and BEFORE that add:

PHP Code:

$bbuserinfo['lang_decimalsep']='.'; $bbuserinfo['lang_thousandsep']=','; 


This fix forces to use English seperators which the hack code depends so regardless of MYSQL configuration the formatting works fine.

[HuangA]

On forum home (Admin):
Page generated in 0.11859798 seconds (93.17% PHP - 6.83% MySQL) with 9 queries
Page generated in 0.11566091 seconds (92.98% PHP - 7.02% MySQL) with 9 queries
On forum home (Guest):
Page generated in 0.12545395 seconds (92.30% PHP - 7.70% MySQL) with 9 queries
Page generated in 0.11924601 seconds (93.99% PHP - 6.01% MySQL) with 9 queries
On vBAdvanced Homepage (Admin):
Page generated in 0.16185904 seconds (86.56% PHP - 13.44% MySQL) with 9 queries
Page generated in 0.09283090 seconds (91.52% PHP - 8.48% MySQL) with 9 queries
On vBAdvanced Homepage (Guest):
Page generated in 0.08898401 seconds (93.35% PHP - 6.65% MySQL) with 7 queries
Page generated in 0.10263205 seconds (93.28% PHP - 6.72% MySQL) with 7 queries

Looks pretty good so far... Let's see how this works later when I add more hacks to it ^^