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:

[solent]

ok that sounds resonable enought TECK i will rebuild my board from scratch and this time i will be more carefull on installing hacks.

thanks

[SiGmA_X]

First off, I love this hack, really great; thank you

Now, I have a few comments.. Perhaps they have been covered, but I don't want to read through all of the many posts in this thread..

How does vBulletin figure out how many queries were executed? I am trying to write a script for my main site, but this is stumping me...

vbMicroStats uses @exec("uptime") to figure out the load. The problem is, many professional servers disallow the httpd/www-data user (Might be called something else, but it's the one that Apache spawns under) from executing things such as system() or exec() for obvious security reasons, you would have near-root permissions. On my server, this is the case. Here's what I came up with the get around it; Perhaps not as clean as yours, but it works

File: FORUM/admin/functions.php

PHP Code:

if ($stats=@exec('uptime')) {
  preg_match('/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/',$stats,$regs);
  $serverload=' [Server Load: <font color="{ hovercolor}"><b>'.$regs[1].'</b></font> " '.$regs[2].' : '.$regs[3].']';
} else {
  $serverload='';
} 


My Fix:

PHP Code:

if ( $stats = @fopen('/proc/loadavg', 'r') ) {
  if ($fd = fopen('/proc/loadavg', 'r')) {
    $load = split(' ', fgets($fd, 4096));
    fclose($fd);
  } else
    $load = array('N.A.','N.A.','N.A.');
  $serverload = ' [Server Load: <font color="{ hovercolor}"><b>';
  $serverload .= $load[0] . '</b></font> " ' . $load[1] . ' : ' . $load[2] . ']';
} 


For me, this has worked flawlessly. The only thing that I can think to go wrong would be the loadavg file not being in /proc/loadavg, but on most (If not all) UNIX/Linux systems, it is there.

[TECK]

If I'm correct, that won't work in safe mode...

[Hobbes]

I cant get them to show up......

[Hobbes]

ok, my new attach wouldn't show....

[N9ne]

For those having trouble with the functions.php replacement on 2.3.0 Final, replace your entire dovars section with the following code [it works] (NOTE!: this is for an unhacked vB! If you have modified this section at all with other hacks, don't use this!)

PHP Code:

// ###################### Start dovars #######################
function dovars($newtext, $sendheader = 1)
{
    // parses replacement vars

    global $PHP_SELF, $DB_site, $replacementsetid, $gzipoutput, $gziplevel, $newpmmsg, $microstats;
    static $vars;

    if (connection_status())
    {
        exit;
    }

    if (!is_array($vars))
    {
        // build an array of $vars containing find/replace values
        $vars = array();
        $replacements = $DB_site->query("
            SELECT findword, replaceword, replacementsetid
            FROM replacement
            WHERE replacementsetid IN(-1, '" . intval($replacementsetid) . "')
            ORDER BY replacementsetid, replacementid DESC
        ");
        while ($replacement = $DB_site->fetch_array($replacements))
        {
            if ($replacement['findword'] != '')
            {
                $vars["$replacement[findword]"] = $replacement['replaceword'];
            }
        }
        unset($replacement);
        $DB_site->free_result($replacements);
    }

    $newtext = str_replace( '{getmicrostats}' , $microstats , $newtext );

    if (PHPVERSION < '4.0.5' or 1)
    {
        // do each replacement in turn for PHP < 4.0.5
        reset($vars);
        while(list($find, $replace) = each($vars))
        {
            $newtext = str_replace($find, $replace, $newtext);
        }
    }
    else
    {
        // do all replacements in one go (PHP >= 4.0.5 only)
        $newtext = str_replace(array_keys($vars), $vars, $newtext);
    }

    if ($newpmmsg)
    {
        if (substr($PHP_SELF,-strlen('private.php')) == 'private.php')
        {
            // do nothing
        }
        else
        {
            $newtext = preg_replace("/<body/i", "<body onload=\"Javascript:confirm_newpm()\"", $newtext);
        }
    }

    if ($gzipoutput and !headers_sent())
    {
        $newtext = gzipoutput($newtext, $gziplevel);
    }

    if ($sendheader)
    {
        @header("Content-Length: " . strlen($newtext));
    }

    return $newtext;
} 


[ogden2k]

Page generated in 0.09366798 seconds (71.57% PHP - 28.43% MySQL) with 21 queries.

Does that sound accurate? Which is better, more php then mysql or the other way around?

[Lethal]

that looks just fine

[Lethal]

ok so the reason my serverload is not showing is possibly because my server doesn't allow the @exec("uptime") to be used, at least thats what I have read. If i ask them will they allow it, because I really would like to know what my server load is. Any suggestions on how to get around it?

[Zxin]

If you have a problem look at the part of the instructions that say
Template: home_microstats

Do NOT create a new template called home_microstats

*DO* create a template called microstats

and bing, your {getmicrostats} will show up!