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:

[scubasteve]

thanks for the quick clarifications to the new db_mysql. i see the 'explain' function was removed, ostensibly because of a security concern - now i'm trying to figure out how that created insecurity

anyways, thx for the update

oh, since it is disabled, you might want to change this line of code in admin/functions.php:

PHP Code:

$adminstats="PHP version $versionphp with $gziptext. [<a href=\"$PHP_SELF?explain=1\" target=\"_blank\">details</a>]"; 


to

PHP Code:

$adminstats="PHP version $versionphp $debugmode with $gziptext."; 


[TECK]

i wait for the new VB226 release.. and i think i will add those back as part of the hack.. the tables. i will ask then firefly or anyone here who knows well VB security if the mod is reliable.

[scubasteve]

sounds like a plan

[Jawelin]

Hi. With the new modified db_mysql.php version (post #306), does someone have noticed an increment (BY 1, only...) of query counts ?

I switched, on the same forumhome page, from 40 to 41 queries (nakkid, grin!!! ) right after the upload of such hacked file.

Thanks.
Bye

[TECK]

i just tried with the old file to do an explain=1. it's the same number of queries, in forumhome (i did a refresh on the page). maybe you forgot some template out of the equation? could be anything... let me know jawelin. curious on this.

[Jawelin]

No.... :O
Simply I loaded my forumhome in the browser...
With that index.php page displayed, I uploaded the db_mysql.php file ONLY to server via FTP, and after the successful transfer i pressed the 'page reload' button.

Very very strange: before 40 queries, after (and now, since then) 41 !!!
It's just a mistery, not a problem, of course....

I've no time at the moment to investigate into db flow, but that's my black-box experiment....
Thanks

[TECK]

let us know if you find out something.

[Lethal]

Works great, thanks.

Page generated in 0.1183040 seconds (73.35% PHP - 26.65% MySQL) with 19 queries

[Pauly]

can someone heeellllpppp me!1..lol

i have vb 2.2.5 installed on my pc along with mysql 3.23 & php 4.2.0 ....i have installed the hack but still getting 100 php and 0 mysql.....have checked the updated db_mysql.php ....but copy i have does not tally with copy that peeps have adjusted in this thread...is it just me?....can someone point me in right direction...cos its doing my nut in!! ...even if i do a fresh installl can u tell me what i need to do with db_mysql.php from scratch!!...sorry for being a little dumb!! gotta start somewhere!!

[TECK]

you probably have the old db_mysql.php file. make sure you download the new one from the link.