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:

[Entourage]

K, I took a clean verion of functions, gobal and db_mysql and re-edit it with the txt doc of TECK (https://vborg.vbsupport.ru/attachmen...&postid=359609) and everything is working great now! (ps. I only had to rename a template)


generated in 0.09475398 seconds (77.18% PHP - 22.82% MySQL) with 16 queries.
[Debug Mode OFF] [PHP v4.3.1] [GZIP disabled] [Server Load: 0.09 ? 0.05 : 0.01]

[sabret00the]

04-01-03 at 01:28 PM Erwin said this in Post #769
The dovars bit in the Final Release of 2.3.0 is different to the fix TECK posted. You can work around it, but I'm sure TECK will post an updated fix for the Final Release soon. I managed to get mine working by slowly comparing the codes in any case...

will you do it since teck aint?

[Mr. X]

Just wondering, and sorry if its been posted already, but can and how can I move the [Debug Mode OFF] [PHP v4xxx] [GZIP disabled] [Server Load: xxx» xxx: xxx] line so that it is after the Page Generated line? Im using the PHP based code, not the template to have it appear in my footer. It appears fine for users, but for admins we see the 2nd line, and for some reason its adding an ugly space to my footer. Is there anyway to just move that line up after the Page Generated line, so it'll be just one sentence?

[TECK]

Today at 01:23 PM Entourage said this in Post #781
K, I took a clean verion of functions, gobal and db_mysql and re-edit it with the txt doc of TECK (https://vborg.vbsupport.ru/attachmen...&postid=359609) and everything is working great now! (ps. I only had to rename a template)


generated in 0.09475398 seconds (77.18% PHP - 22.82% MySQL) with 16 queries.
[Debug Mode OFF] [PHP v4.3.1] [GZIP disabled] [Server Load: 0.09 ? 0.05 : 0.01]

If you clear your browser temp files, you don't even have to rename that template... the typo was corrected my myself about 285 years ago...

[Oblivion Knight]

Page generated in 0.14942503 seconds (61.14% PHP - 38.86% MySQL) with 22 queries.
[Debug Mode OFF] [PHP v4.1.1] [GZIP disabled]

Everything appears to be working..
I'll contact my host about the server load part of the hack tomorrow.

Thankyou TECK
[high]* Oblivion Knight clicks install.[/high]

[GoTTi]

PHP Code:

Page generated in 1,050,098,789.69630003 seconds (100.00% PHP - 0.00% MySQL) with 30 queries.
[Debug Mode OFF] [PHP v4.2.1] [GZIP disabled] [Server Load: 0.36 ? 0.62 : 0.79] 


how is it that 0% is mySQL? isnt that impossible?

[Stadler]

> Page generated in 1,050,098,789.69630003 seconds

I think, something went wrong there. Mybe you should recheck all the changes.

[Sebastian]

Today at 06:08 PM Da_GoTTi said this in Post #786

PHP Code:

Page generated in 1,050,098,789.69630003 seconds (100.00% PHP - 0.00% MySQL) with 30 queries.
[Debug Mode OFF] [PHP v4.2.1] [GZIP disabled] [Server Load: 0.36 ? 0.62 : 0.79] 


how is it that 0% is mySQL? isnt that impossible?

cool, 100% PHP , its like vitamin C, mysql is not very healthy

.. not sure though... check you properly hacked the files.

[TECK]

04-11-03 at 11:08 PM Da_GoTTi said this in Post #786

PHP Code:

Page generated in 1,050,098,789.69630003 seconds (100.00% PHP - 0.00% MySQL) with 30 queries.
[Debug Mode OFF] [PHP v4.2.1] [GZIP disabled] [Server Load: 0.36 ? 0.62 : 0.79] 


how is it that 0% is mySQL? isnt that impossible?

Search the thread for an answer.

[trafix]

I have modified everything successfully except the last stage of the anmin/functions there is a major difference in the text that should be there and what is currently there. all i can presume is that either i have a hack that also modifies that area but i cant recognoise it.
this is what should be there

PHP Code:

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

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

  if (connection_status()) {
    exit;
  }

  if (!isset($vars)) {
    $vars=$DB_site->query("SELECT findword,replaceword FROM replacement WHERE replacementsetid IN(-1,'$replacementsetid') ORDER BY replacementsetid DESC,replacementid DESC");
  } else {
    $DB_site->data_seek(0,$vars);
  }

  while ($var=$DB_site->fetch_array($vars)) {
    if ($var['findword']!="") {
      $newtext=str_replace($var['findword'],$var['replaceword'],$newtext);
    }
  } 


This is what is currently in my functions.php

PHP Code:

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

  global $DB_site,$replacementsetid,$gzipoutput,$gziplevel,$newpmmsg,$fullpm,$bbuserinfo,$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);
    }

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

// ###################### Start standarderror( ####################### 


Can anyone help ???