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:

[TECK]

Fazle, i will see what i can do with it to make you happy.
vB.org variable test:

Page generated in 0.35182405 seconds (26.11% PHP - 73.89% MySQL) with 27 queries

the code above was called with a variable.
as you notice, the higher you place it on the page, the lower are the values...

[Tim Wheatley]

Why are my percentages coming through wrong??

Page generated in 0.1624170 (-5,389.35% PHP - 5,489.35% MySQL) seconds with 116 queries.
PHP version 4.1.2 (Debug mode) with GZIP compression library disabled.

[TECK]

reload the page, it will be ok. and btw, if you have 116 queries, you are in big trouble. you must check your hacked board. you have a huge error there.

hmmm.. i just checked your forum. you probably didnt updated all files. did you downloaded the previous version 1.1? in that case, you must clear your cookies to see the actual file. when you view the attachment, it will pull it the one from temp folder not the actual file.

make sure you edit forum/admin/db_mysql.php

let me know.

[psico]

Version 1.2 has problems with vBPortal...
Shows the message under every Block on vBPortal!!!

Any solution for that?

And shows me 199 queries!!! mmmm

[TECK]

i'm working on a mod right now, so you can enter a variable instead. it will cure your prob.. give me another 15min

[Admin]

Originally posted by psico
And shows me 199 queries!!! mmmm

LOL now I remember why we don't use vbPortal.

[Tim Wheatley]

It seems to be working now for me... did I clear cookies? I don't know.

[Jawelin]

I always get PHP percentage negative.... ????
(even reloading and reloading).

Always something like :

Page generated in 0.37837 seconds (-54.60% PHP v4.1.2 - 154.60% MySQL) with 34 queries.

I DON'T have VbPortal and use vb 2.2.2 yet...
Thanks

[Tim Wheatley]

I have too many queries then I guess? Why would that be? Am I looping something?

[TECK]

yes you do. this is extremly high. after 50 queries, the server start to go on the red side. i'm surprised your host didnt contact you yet.

ok.. i went to sleep yesterday. so i'm gonna start the mod right now. gimme 30min for my breakfest and keep in mind that i should do my luggage instead of posting here. tomorrow at 8 i have the plane taking me away to my baby sweet loving woman..