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:

[Sebastian]

Originally posted by TECK
You are running PHP in safe mode. My host does it also. That's life... you can't do nothing about it.

yeah you can, get a dedicated server

they can however disable safemode for just one site .. it is possible, i have done it. you can ask them to disable it on just your site.

[mute]

Anyone using vbmicrostats and apache 2?

vbMs works fine on my 1.3.27+php 4.2.3 server:


Page generated in 0.20286000 seconds (85.72% PHP - 14.28% MySQL) with 16 queries.

but on my 2.0.43+php 4.2.3 server i get:

Page generated in 1,040,133,629.17236805 seconds (100.00% PHP - 0.00% MySQL) with 19 queries.

Both have the same php.ini as well.

Anyone seen that before? (forgive me if its been mentioned, 45 pages of thread were a bit much for me to surf through)

-k

Edit: I surfed back a ways and felt the need to add this:

Both servers are using the same php files (I rsync them to the other server after editing them), so I'm pretty sure the db_mysql.php is hacked properly.

[TECK]

You didn't hack properly the db_mysql.php file. Double check please.

[Boofo]

Believe it or not, Teck, but I got that same error with microstats when I installed in in vBHome Lite until I added your additional code that you posted for it over there.

[mute]

If its not hacked properly, how come one server works with it, and the other server doesn't?

I am 150% sure they are using the same file, as i rsync the two servers to ensure both webservers are feeding off of the same source..

[TECK]

Hmm... is wierd. I have it working perfectly on Apache 2.0.43 and Windows XP, on my localhost...
The error not showing the right time is because it doesn't see the microtime in the startpage variable, that's why you get 1,8765988768976 numbers.

[mute]

I rehacked the db_mysql file just to be 100% certain, and rsync'd it back over, and it worked 100% on server1, but not on server2 :/

any other ideas?

[TECK]

Give me your environment where you run the problem VB? os, php, mysql, etc

[mute]

Evidentally I am an idiot

[high]* mute bows
[/high]

TECK, thanks for your help, if theres anything wrong with this hack is that its not idiot proof enough

[TECK]

What was wrong? Just curious?
Don't worry, I make also mistake... like anyone else here... is human.