vbMicroStats: page load time, queries, GZIP and PHP version

[high]Looking for VB3 version? Is here.[/high]

This hack will add at the bottom of each vBulletin(powered) page the following stats:
- load time of specified page in microseconds (with custom no. of digits to show)
- number of queries executed
- server GZIP library compression status
- vBulletin DEBUG mode
- PHP version
- PHP percent page usage
- MySQL percent page usage
- Server Load
[high]This is not only estethic, it will also help you troubleshoot any wierd queries that you have in your scripts.
The hack is template based so you can edit it the way you want in few seconds.[/high]
NOTE: From users experiences, this hack will work only with PHP 4.0.6 or higher. Let me know if it works with a lower PHP version.

THE FIX FOR VB2.3.0 IS HERE.

HACK UPDATES
Version 2.1
------------------------------------
Changes:
- added Server Load

NOTE: I spoked with Kevin 'tubedogg' from vBulletin Support team and he explained to me that not all the servers are configured to support the [high]@exec("uptime")[/high].
Contact your host for more details and ask them about this issue.
For a full explanation of your 3 server load values, read more here.

*If you want to have the stats viewable only by admins, read this post.

Version 2.0
------------------------------------
Changes:
- added vBulletin DEBUG Mode
- removed the Details link
- cleaned a little the code to match VB2.2.6
- better explanations into the install file.

Version 1.7
------------------------------------
[high]VB2.2.5:[/high]
Minor change in admin/db_mysql.php. Read more here on how to update your hack.
Minor change in forum/global.php. Read more here on how to update your hack.

Changes:
- corrected negative values on certain servers.

Version 1.6
------------------------------------
Changes:
- PHP version and GZIP library status viewable only to admin.
- added a link to Detailed Stats View (generated by vBulletin), for that specific page. Only admins can view that link.

To see how it looks a Detailed View, click here.

Version 1.5
------------------------------------
Added:
- GZIP library status is now related to your vBulletion options.
- GZIP library compression level.

Version 1.4
------------------------------------
Bugs corrected:
- GZIP library status not displayed properly on certain servers.

Version 1.3
------------------------------------
Bugs corrected:
- vbPortal display code in modules

The hack is template based now.
All you have to do is call it with the {getmicrostats} string, anywhere you want (for example in footer).
You also have the choice to install it as template based or coded directly into your functions.php file.

Version 1.2
------------------------------------
Added the PHP and MySQL page percentage.
(Addon by Chen 'FireFly' Avinadav)

Version 1.1
------------------------------------
vB.org decided to add this hack to their board.

Bugs corrected:
- incorrect time load
- incorrect query count

You like this hack? Please click on the [high]Install[/high] button.
To download the latest version of this hack, click below:

[nuno]

+-----------------------------------------------+
| FINAL STEPS |
+-----------------------------------------------+
| To call your vbMicroStats, simply place the string {getmicrostats}
| anywhere you want in your templates (for example in footer).

there's no need to call {getmicrostats}
replace

PHP Code:

$microstats='Page generated in '.$trimmedtime.' seconds ('.$percentphp.' - '.$percentsql.') with '.$query_count.' queries.<br>'.$adminstats; 


with

PHP Code:

$vartext .='<center><smallfont>Page generated in '.$trimmedtime.' seconds ('.$percentphp.' - '.$percentsql.') with '.$query_count.' queries.<br></smallfont></center>'.$adminstats; 


and no longer is needed template editing aranoid:

[Boofo]

If you did it this way, you wouldn't be able to decide where it goes. And where would it show up with the way you have it here?

Originally posted by nuno

there's no need to call {getmicrostats}
replace

PHP Code:

$microstats='Page generated in '.$trimmedtime.' seconds ('.$percentphp.' - '.$percentsql.') with '.$query_count.' queries.<br>'.$adminstats; 


with

PHP Code:

$vartext .='<center><smallfont>Page generated in '.$trimmedtime.' seconds ('.$percentphp.' - '.$percentsql.') with '.$query_count.' queries.<br></smallfont></center>'.$adminstats; 


and no longer is needed template editing aranoid:

[nuno]

like this it goes below copyright text

[Boofo]

I tried it but couldn't get it to display right. The second line (for Admin only) was in normalfont and spaced an extra line below the first line. When I tried to moved the center and smallfont, if gave me a blank page when I tried to load my site.

[TECK]

nuno, the {getmicrostats} variable is useful to users who want more control over their html code.
for example, if you have vbPortal installed, it will show ur stats in every block, if you do it your way.

[Henry-RS]

$templatesused.=',pagenav,pagenav_curpage,pagenav_firstlink,pagenav_lastlink,pagenav_nextlink,pagenav_pagelink,pagenav_prevlink';

That code, is not even in /forum/global.php >=(

Ahh, nevermind. I was just having one of those moments. :embarrased:

[Jadelit]

I am getting this error..

Parse error:  parse error, expecting `','' or `';'' in C:\Inetpub\****\board\admin\functions.php</b> on line 474

Fatal error:  Call to undefined function:  iif() in C:\Inetpub\****\board\admin\functions.php on line 352

im using vb 2.2.6

[The Piper]

This script is really great, I have it working on my site and it's really useful. A suggestion I'd like to make: how about adding stats on the server loads as well?

Thanks a lot and congrats nakkid on an awesome script!

Paulo

[TECK]

thanks for your nice words. a quick thing.. i noticed you have 48queries on your main page. this is extremly high. over 40, your server goes on the red line, on a busy site.

[The Piper]

Thanks for the advice, nakkid. Yeah, I'm trying to lower that. I took the polls off but it's still pretty high. I'm planning on reinstalling vbIndex because I'm running an older version, so I'll be able to mess up with the code a bit to try and lower that.