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.

[Oblivion Knight]

Thanks TECK..
Erwin's version just didn't feel right without the MySQL and PHP percentage.. Heh.

[Tarion]

Originally Posted by Oblivion Knight

Thanks TECK..
Erwin's version just didn't feel right without the MySQL and PHP percentage.. Heh.

I get an error division by zero from this two lines in the code, and i can't find out what's wrong.

PHP Code:

$msphp = vb_number_format(((($totaltime - $querytime) / $totaltime) * 100),2) . '% PHP';
$mssql = vb_number_format((($querytime / $totaltime) * 100),2) . '% MySQL'; 


Please help me

[TECK]

Originally Posted by sabret00the

sorry to be a pain, but i'm encountering an error on line 1843

	$ms .= '		<td class="tcat"' . iif($vboptions['allowchangestyles'], ' colspan="2"') . '><div class="smallfont">';

the error is

Parse error: parse error, unexpected T_STRING in K:\Network\xampp\htdocs\forums\includes\functions.php on line 1843

Fatal error: Call to undefined function: exec_nocache_headers() in K:\Network\xampp\htdocs\forums\admincp\global.php on line 37

You made a little mistake while editing the code, please check your steps.

Originally Posted by Tarion

I get an error division by zero from this two lines in the code, and i can't find out what's wrong.

PHP Code:

$msphp = vb_number_format(((($totaltime - $querytime) / $totaltime) * 100), 2) . '% PHP';
$mssql = vb_number_format((($querytime / $totaltime) * 100), 2) . '% MySQL'; 


Please help me

One of your values has to be returned as zero somewhere, or as a value that PHP will convert to a zero when it converts it to an integer.
Something is wrong with the code, you cannot have either the $totaltime or $querytime as zero.

[Tarion]

Ok i got it to work i edit this line

PHP Code:

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


as i delet the vb_ prefix for the vb_number_format funktion it work, wenn i add this prefix the error returns.

[TECK]

Hmm, really wierd.
The vb_number_format() is the same like number_format(), except with a little cleanup/replace in chars... use it this way if it's working for you.

[JoergZ]

I confirm, that I have the same division by 0 error. After changing the code as suggested by Tarion it works.

Anyway: Installed

[TECK]

Thanks for the input JoergZ.
Let's see if other people will have the same problem... I will post a link to his fix (link added to first post).

Thanks for helping.

[Christine]

Hi Tech, and thanks for porting this. One of my alltime favorites!

Edit: Nevermind -- I got it working.

[r.cakir]

Installed and double checked the modifications, but still getting wrong result in PHP and MySQL percentage:

Page generated in 0,24497795 seconds (0,00% PHP - 0,00% MySQL) with 11 queries
4 Uncached Templates | DEBUG Mode OFF | GZIP ON (level 1)

I know, I made a mistake somewhere. Maybe someone can put me in the right direction.

Thanks!

r.cakir

[Gary King]

Originally Posted by r.cakir

Installed and double checked the modifications, but still getting wrong result in PHP and MySQL percentage:

Page generated in 0,24497795 seconds (0,00% PHP - 0,00% MySQL) with 11 queries
4 Uncached Templates | DEBUG Mode OFF | GZIP ON (level 1)

I know, I made a mistake somewhere. Maybe someone can put me in the right direction.

Thanks!

r.cakir

I think it might be a server configuration problem; first question: are you on Windows?