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:

[TLfuRy]

I installed the new version of this hack after upgrading to 2.3.0, and nothing shows up in my footer now. I have uploaded the original files and re-applied the hack three times....and I'm sure I'm doing it right.

Any thoughts?

[Xenon]

Teck is currently not availabla, becaus of making holidays for three weeks

but i can say the hack works with 2.3.0 on my board, so you must do something wrong i think...

[TLfuRy]

Thanks. I'll try it again.

[Ghostsuit]

I installed the new version of this hack after upgrading to 2.3.0, and nothing shows up in my footer now. I have uploaded the original files and re-applied the hack three times....and I'm sure I'm doing it right.

Any thoughts?

I had this problem as well. You need to name the template microstats not home_microstats as it says in the instructions.

[TLfuRy]

That worked! Thanks!

[Doubledoom]

Installed and working for me on 2.3.0 RC3 with VBportal 3.0 (2.2) and showing on portal and forum pages correctly.

Needs correction as mentioned a little earlier but apart from that its fine.

[Craigr]

Thanks.

Craig

[Talisman]

Hi all,

Just installed this and ran into the conflict replacing variables in the dovars section of the ADMIN/functions.php file between this hack and Chen's {bbusername} auto name hack.

On pages 29 and 40/41 of this thread, I read that we can integrate the two by finding this in Teck's vbMicroStats hack:

PHP Code:

$findwords=array(0 => '{getmicrostats}');
$replacewords=array(0 => $microstats);
$i=1; 


And replacing that with this:

PHP Code:

$findwords=array(0 => '{getmicrostats}', 1 => '{bbusername}');
$replacewords=array(0 => $microstats, 1 => $bbusername);
$i=2; 


Well, this actually did not work in my case. The {bbusername} portion of the variables wasn't correct. To solve it, I had to replace it with this, instead:

PHP Code:

$findwords=array(0 => '{getmicrostats}', 1 => '{bbusername}');
$replacewords=array(0 => $microstats, 1 => "$bbuserinfo[username]");
$i=2; 


Don't know if anyone else has had a problem with this, but thought I'd mention it, just in case.

Thanks for the great hack, Teck.

Cheers!

<< Now I'm off to lower the number of queries running rampant on all these pages before my site blows up. >>

[Flash69]

I had problems with this hack working on v 2.2.9 in the dovars section of the ADMIN/functions.php

PHP Code:

 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); 


I had to change it to:

PHP Code:

 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);
    }
  } 


I am a new vbulletin person but I think this is a typo in the main hack posted at the begining of this thread. If no-one else has had this problem please disregard this post. If I made a newbie mistake please disregard this post.

Thanks.
Flash

[Flash69]

Double post.