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!

[Ocean]

Originally Posted by the Sandman

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

I'm seeing those as well, but so far, I have only seen them on the Login Redirect screen.

[Erwin]

Originally Posted by the Sandman

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

Odd - which version are you using? The proc one (1.2) or the older non-proc one (1.02)? I'm using version 1.2 since my server has proc, and it's working normally.

[the Sandman]

I'm also using version 1.2. As far as I know, it was working normally, and then I suddenly noticed these crazy values. I did go ahead and re-upload the file to my server, but that made no difference. :ermm:

Kathy did just have Apache recompiled on the server - could it be related to that?

[Erwin]

Originally Posted by the Sandman

I'm also using version 1.2. As far as I know, it was working normally, and then I suddenly noticed these crazy values. I did go ahead and re-upload the file to my server, but that made no difference. :ermm:

Kathy did just have Apache recompiled on the server - could it be related to that?

No, because my Apache was recently recompiled too.

[the Sandman]

I swapped in version 1.02 in place of 1.2, but the high page generation values remained. I swapped 1.2 back in. I guess it's a problem in the server...

[Ocean]

Originally Posted by the Sandman

I swapped in version 1.02 in place of 1.2, but the high page generation values remained. I swapped 1.2 back in. I guess it's a problem in the server...

That doesn't explain why I get it on the Login Redirect pages. And they've been that way from the start.

Does anyone else have that?

[the Sandman]

Something else weird I noticed. I copied these server load averages from the AdminCP:

Server Load Averages 283 244 203 | 41 Users Online (12 members and 29 guests)

At the same time the Microstats read:

Page generated in 20,799 seconds with 11 queries [Server Loads: 3.35 : 2.51 : 2.04]

There's quite a discrepancy in the server loads averages reported and it appears (I hope) that the correct values are from Microstats and the AdminCP values are way off, most likely by a factor of 100...

[AN-net]

anyone else notice the seconds are being reported like that>_> it is susposed to be a demical and most of us hope it is a decimal.

[the Sandman]

I still think it's a server issue. I uninstalled Erwin's Microstats and installed Teck's Microstats. I'm still getting the ridiculously high page generation times from Microstats and the screwy server load averages in the AdminCP...

[HakkieDEV]

Awesome hack mate, using it with pleasure!

/me clicks install