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:

[mute]

the problem was evidentally in global.php. I'm not sure why, but my rsync isn't updating as recursively as it should

[Herman]

Thanks TECK!

/me clicks install

[SiXXGuNNZ]

edit: fingered it out

[TECK]

Good.

[Dribbles]

Just curious, are these stats bad? The server load and MySQL % seems high but I'm not sure what it means (I'm a noob):

Page generated in 1.27131300 seconds (22.60% PHP - 77.40% MySQL) with 29 queries.
[Debug Mode OFF] [PHP v4.2.3] [GZIP enabled - level 1] [Server Load: 13.96 ? 15.02 : 12.76]

Also, I noticed that the queries goes up with each additional post I make to a thread ... is this normal? thnx guys

[NTLDR]

Originally posted by Dribbles
[Server Load: 13.96 ? 15.02 : 12.76]

The server load is way too high, you want it be around 1 or lower if you can, the lower the better

Also, I noticed that the queries goes up with each additional post I make to a thread ... is this normal? thnx guys

No this isn't normal, and is very bad, I suggest you uninstall the hack thats causing this

[Dribbles]

The server load is way too high, you want it be around 1 or lower if you can, the lower the better

Hi, thnx. Is the server load something on my side, or could it just be the server company I use?

No this isn't normal, and is very bad, I suggest you uninstall the hack thats causing this

Is there a way for me to find out which hack is doing this? Could it be Lesane's Store Hack? thnx again

[Dribbles]

Update - I just double checked, the queries seem to only go up with the first reply I make ... I made a reply and queries went up to 32, but then made 3 more replies right after it and the queries stayed the same ... any difference? thnx

[TECK]

Is normal. That's how VB works. But 32 queries is huge... normally you should have the default ones 17-20 (with poll), on an unhacked BB. remove all the nasty hacks.

[Dribbles]

I knew it looked a bit large. My forum view page is only 20 queries, then when you go in to see the actual threads, some of them get up to 32 queries. I think it's because I did something where I added a custom profile field (3 of them: 1 for avatar url, 1 for avatar width, and one for avatar height) and have those fields called up in everyone's postbit?? Thnx for the reply BTW

I'm about to install your "Quick Delete Post" ( https://vborg.vbsupport.ru/showthrea...=&pagenumber=4 ) hack right now. That was the reason I installed this hack ... someone posted on that thread something about queries ... so I figured I would install this hack to see for myself if it affected queries or something