Microstats (only for admin) - load times, server loads, queries, uncached templates!

Version 1.0 - works for most servers
Updated 1.1 - optimized code
Updated 1.2 - added names of uncached templates!

Okay, the original was by TECK. This is NOT based on his code - it is based on vB3's native code. If TECK wants me to remove this, I will do so. This is just my version that I use for my private forums.

Information shown:
1) Page loading times
2) Number of Queries
3) Server Loads
4) Number of Any Uncached Templates
5) Name of Uncached Templates (NEW!)

By default only an Admin (usergroup 6) can see it. Feel free to modify this bit.

It's very easy to install.

Open includes/functions.php:

Find:

PHP Code:

// ####################################################################
    // temporary code
    global $_TEMPLATEQUERIES, $tempusagecache, $DEVDEBUG, $_SERVER, $debug; 


UNDERNEATH, ADD:

Version 1.2 - more optimized but requires /proc on your server - try this, if server loads don't show up use Version 1.02 below

PHP Code:

// Microstats hack
if ($bbuserinfo[usergroupid]==6) {
                $pageendtime = microtime(); 
                $starttime = explode(' ', $pagestarttime); 
                $endtime = explode(' ', $pageendtime); 
                $totaltime = vb_number_format($endtime[0] - $starttime[0] + $endtime[1] - $starttime[1], 5); 
                $loadavg = @file_get_contents("/proc/loadavg"); 
                if ($loadavg) { 
                        $regs = explode(" ",$loadavg); 
                        $serverload=' [Server Loads: <b>'.$regs[0].'</b> '.$regs[1].' : '.$regs[2].']'; 
                } 
                $debughtml = "<center><span class=\"smallfont\">Page generated in <b>$totaltime</b> seconds with <b>$query_count</b> queries" . iif($_TEMPLATEQUERIES, " (<b>" . sizeof($_TEMPLATEQUERIES) . "</b> queries for uncached templates)", '') . "$serverload</span></center>"; 
    ksort($tempusagecache);
    foreach ($tempusagecache AS $tempname => $times)
    {
    if ($_TEMPLATEQUERIES["$tempname"]) $debughtml .= "<center><span class=\"smallfont\">Uncached templates: <font color=\"red\"><b>$tempname</b></font> ($times)</span></center>";
    }
                $vartext = str_replace('</body>', "$debughtml\n</body>", $vartext); 
 
}
//Microstats Hack 


Version 1.02 - Use this if Version 1.1 doesn't work for you.

PHP Code:

// Microstats hack 
if ($bbuserinfo[usergroupid]==6) {
$pageendtime = microtime(); 
$starttime = explode(' ', $pagestarttime); 
$endtime = explode(' ', $pageendtime); 
$totaltime = vb_number_format($endtime[0] - $starttime[0] + $endtime[1] - $starttime[1], 5); 
if ($stats=@exec('uptime')) { 
     preg_match('/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/',$stats,$regs); 
     $serverload=' [Server Loads: <b>'.$regs[1].'</b> ? '.$regs[2].' : '.$regs[3].']'; 
     } 
$debughtml = "<center><span class=\"smallfont\">Page generated in <b>$totaltime</b> seconds with <b>$query_count</b> queries" . iif($_TEMPLATEQUERIES, " (<b>" . sizeof($_TEMPLATEQUERIES) . "</b> queries for uncached templates)", '') . "$serverload</span>"; 
$vartext = str_replace('</body>', "$debughtml\n</body>", $vartext); 
    ksort($tempusagecache);
    foreach ($tempusagecache AS $tempname => $times)
    {
    if ($_TEMPLATEQUERIES["$tempname"]) $debughtml .= "<center><span class=\"smallfont\">Uncached templates: <font color=\"red\"><b>$tempname</b></font> ($times)</span></center>";
    }
}
//Microstats Hack 


Done! As simple as that. No need to enable debug mode.

If you want only yourself to have this information, change:
if ($bbuserinfo[usergroupid]==6) {
to
if ($bbuserinfo[userid]==1) {

And replace 1 with your userid.

To let everyone see it, remove that line, and the last } of the code above.

Below is a screenshot of how my forumhome microstats look.

EDIT: Thanks to kmike, I optimized the code. This should lessen the load when checking the server loads slightly.

Version 1.2 and 1.02 now has added code to show NAMES OF UNCACHED TEMPLATES!

[Vigile]

Originally Posted by Erwin

You have 3 uncached templates, which is causing that page to have 3 extra unnecessary queries. You need to add these templates to the template cache by editing that PHP file. To know which templates, you need to switch debug to on. My hack tells you how many templates are uncached, but not which ones.

Sorry, I know Im getting outside the confines of this topic thread, but Im was able to drop 2 of them but they are being caused by an eval statement to my phpinclude, so I can drop in a variable $shadow instead of long drawn out code. Is there an easy fix for this that wont generate a query? Mind you.. I have added $shadow to about 70 templates so far. So one less query (and an easy fix for it) would be a good thing.

all I've done is

PHP Code:

eval('$shadow = "' . fetch_template('shadow') . '";'); 


any help appreciated. If ya want to cut this and move to a proper forum, please do.

[Erwin]

Originally Posted by Vigile

Sorry, I know Im getting outside the confines of this topic thread, but Im was able to drop 2 of them but they are being caused by an eval statement to my phpinclude, so I can drop in a variable $shadow instead of long drawn out code. Is there an easy fix for this that wont generate a query? Mind you.. I have added $shadow to about 70 templates so far. So one less query (and an easy fix for it) would be a good thing.

all I've done is

PHP Code:

eval('$shadow = "' . fetch_template('shadow') . '";'); 


any help appreciated. If ya want to cut this and move to a proper forum, please do.

Instead of adding it to all your templates, if it's in your phpinclude, add it to global.php in the forum directory (at least that's where you do it in vB2, not sure about vB3).

[Roderik]

Works great!

Page generated in 0.09473 seconds with 8 queries [Server Loads: 0.00 - 0.02 - 0.07]

changed the code to fit my 150px sidebar, see modified code below.

PHP Code:

    // Microstats hack
    if ($bbuserinfo[usergroupid]==6) {
        $pageendtime = microtime();
        $starttime = explode(' ', $pagestarttime);
        $endtime = explode(' ', $pageendtime);
        $totaltime = vb_number_format($endtime[0] - $starttime[0] + $endtime[1] - $starttime[1], 5);
        if ($stats=@exec('uptime')) {
            preg_match('/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/',$stats,$regs);
            $serverload=' [Server Loads: <b>'.$regs[1].'</b> - '.$regs[2].' - '.$regs[3].']';
        }
        $debughtml = "<table width="100%" cellpadding="0" cellspading="0" border="0"><tr><td width="150" nowrap="nowrap">&nbsp;</td><td algin="center" class="smallfont"><center>Page generated in <b>$totaltime</b> seconds with <b>$query_count</b> queries" . iif($_TEMPLATEQUERIES, " (<b>" . sizeof($_TEMPLATEQUERIES) . "</b> queries for uncached templates)", '') . "$serverload</center></td></tr></table>";
        $vartext = str_replace('</body>', "$debughtml\n</body>", $vartext);
    }
    //Microstats Hack 


[Limitter]

thanks Erwin very nice & easy

L.

[Gary King]

Maybe you should phrases for this hack, by the way

[corn]

* clicks install*

[The_Wanderer]

just the hack i was looking for ^^

[muse.mu]

Parse error: parse error in /home/xxxxx/public_html/xxxxxx/includes/functions.php on line 1782

Fatal error: Call to undefined function: is_browser() in /home/xxxxxx/public_html/xxxxxx/global.php on line 59

=/

[NTLDR]

Don't edit functions.php with Dreamweaver.

[muse.mu]

Originally Posted by NTLDR

Don't edit functions.php with Dreamweaver.

argh. thanks a bunch for the heads up! that is like....the only thing i use :S

can you suggest an alternative please?