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:

[Peabody]

Does this show for the members too? I don't like the idea of anyone knowing which verison of PHP I'm running, since there always a new vulnerability being discovered.

[TECK]

no. only to admins.

[Boofo]

In a few posts back they said that the PHP and GZIP part of it (along with the details) only showed to the Admin (as long as the Admin was set to the default on your board, which is 6), so you're safe.

[Erwin]

Just to confirm - with the new db_mysql, I cannot access ?showqueries=1 or ?explain=1 - no wonder!

[TECK]

you are correct erwin. due to some mods needed for php421, db_mysql.php was modified. i will drop that part when 226 is released. until then, i leave it like that. you can remove the link details, it will not work with the new file.

[DWZ]

I'm sort of confused...

I have 2.2.5 installed with the PHP 4.2.0 version of db_mysql that I got of vb.com (from this thread: http://www.vbulletin.com/forum/showt...threadid=44820)

Now, uploading that deleted all the changes I had made to my old db_mysql file, so I just went back then to update the file so I dont get the 100% PHP and 0% MySQL error, and I cant find

PHP Code:

  function query($query_string) {
    global $query_count; 


Now, what I did find was this:

PHP Code:

  function query($query_string) {
    global $query_count,$showqueries,$explain,$querytime; 


which looks like it already has part of this hack installed in it? The code below that also has bits of this hack in it....

Im really sort of confused here :\

What do I need to replace and with what to stop the 100% PHP / 0% MySQL thing?

[TECK]

DWZ, in the first post of this thread is a link with all the instructions necesary to download the new db_mysql.php file and also how to mod it.

[DWZ]

ahh, ok, sorry

Done that and its working fine now

[mtf169]

There was somebody several postings back that had the same exact problem I'm having now. I've tried installing this hack a dozen times with no success. I get all of the edits done and the one that seems to be breaking everything is:

  while ($var=$DB_site->fetch_array($vars) and $i++) {
    if ($var['findword']!="") {
      $findwords[$i]=$var['findword'];
      $replacewords[$i]=$var['replaceword'];
    }
  }

  $newtext=str_replace($findwords,$replacewords,$newtext);

The other guy posted this image which is exactly what's happening to me. How did he get this working?
https://vborg.vbsupport.ru/attachmen...&postid=239359

Thanks.

By the way, I installed your vbhome(lite) and love it. Awesome hack.

[TECK]

ahh, the pic you show in the link was due to the PHP version. it was to old. what MySQL and PHP ver you run?