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!

[atomic fireball]

Thanks, Erwin.

Worked like a charm!

[ShiningArcanine]

Erwin, why not just replace $vartext with $output and then place the hack in phpinclude_end? It eliminates the need to hack functions.php and is executed right below where you recommend placing the hack.

[Erwin]

Originally Posted by ShiningArcanine

Erwin, why not just replace $vartext with $output and then place the hack in phpinclude_end? It eliminates the need to hack functions.php and is executed right below where you recommend placing the hack.

Because putting it in phpinclude_end may not give you an accurate count of queries perhaps? And it may not work? I haven't thought about it, and haven't tried it - maybe you can try and compare the 2 and see if there is a difference.

[ShiningArcanine]

I tried it; there is no difference in query count and it works like a charm.

[Erwin]

There you go. Never thought it would work as well - the vB3 debug stats are all in functions.php, hence the reason why this hack went to the same spot too.

[SaN-DeeP]

hi erwin thnx for the nice hack

Version 1.1 works fine for me
Page generated in 0.21845 seconds with 10 queries [Server Loads: 0.24 0.23 : 0.18]

just a small question: as you specified in ur instructions.

Information shown:
1) Page loading times
2) Number of Queries
3) Server Loads
4) Any Uncached Templates

were are these uncached templates seen ?

Regards,

[Jolten]

If their are uncached templates the number of them will be shown at the end of the line.. e.g. "2 queries for uncached templates"

[Erwin]

UPDATE:
-----------

Version 1.2 (servers with proc - more efficient) or Version 1.02 (servers without proc - still works)

-> now the names of all uncached templates show up - helpful to find and cached any uncached templates to save queries.

[PET]

On my forum i have 1.2. Now i hear of a 1.02. WTF ? What do i need to modify to have the new version, also, what new things this new version has ?

[the Sandman]

All of a sudden, I'm getting erroneous, very large load times listed:

Page generated in 18,859 seconds with 11 queries [Server Loads: 0.69 1.66 : 2.03]