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:

[Dark Shogun]

Can anyone tell me why my stats say php %100 and mysql 0% on all pages? I know that can't be true. Thats the only problem.

Dark Shogun

[TECK]

is because you didnt hack properly db_mysql.php

[Dark Shogun]

Seems I left out that step somehow. Well it is fixed now. Thanks Teck.

Dark Shogun

[KimG]

Hi there,
Looks a great hack and one I would find useful. My server load seems to magically increase from time to time so I would like to track down the culprit!

Unfortuneatly I have PHP 4.04 installed on my server, and a host who is very slow to do anything! Is there a version of microstats which would work under this version of PHP?

I have the first microstats which does work, butgives incorrect times/queries! The latest version does not parse the php when I update functions.php because of the php version. Is there an inbetween microstats I could use?

Many thanks,
Kim

[TECK]

hello KimG... unfortunatelly no. the lowest version that vbMicrostats will work is PHP 4.06.

[N9ne]

ignore post, matter resolved by myself

[exTracT]

Just curious how these stats look. I am on a shared server
13 members online. i have about 10 lil hacks installed.
almost 1000 members.

thanks

Page generated in 0.30253804 seconds (40.66% PHP - 59.34% MySQL) with 24 queries.
[Debug Mode OFF] [PHP v4.2.2] [GZIP enabled - level 1] [Server Load: 1.96 » 2.64 : 2.64]

[Ian]

exTracT, those stats look fine to me.

[TECK]

smart decision to leave the gzip to 1. that cuts the bandwidth alot. dont go higher then this.
24 queries on forumhome? make sure you installed properly your hacks.. not alot of hacks add queries.. and is defalut 17 for vbulletin.

so i would do an ?explain=1 on your forumhome just to see if i didnt forget any templates to add. that the most frequent mistake people do...
if you see in the explain=1 some template title then you missed that one...

[NTLDR]

Hi TECK,

I don't know if there is a soloution to this or not, but my current work around is a very long one, so I thought I'd ask

On a board with FireFly's change { bbusername } to the viewers username hack installed and this one there is a section of code that allows you (at present) to either have this hack working or FireFly's.

PHP Code:

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

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


In the { bbusername } hack you have:

PHP Code:

$findwords=array(0 => '{ bbusername }');
  $replacewords=array(0 => $bbuerinfo[username]); 


As well as the microstats code, but which ever one is directly before the while loop works and the other one just displays {text} I have tried everything I can to get it to work, but have failed

Any ideas? Currently I have edited a whole bunch of files and used str_replace everywhere I can think of that { bbusername } could appear.