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!

[AlexanderT]

Is it possible to split the page load time into time needed for php and time needed for mysql (similar to the 2.x microstat hack)?

[Red Blaze]

I can't get it to work. I get a parse error and a fatal error.

I'm gonna try to edit the php file in Windows see what I get. I'm using a MAC right now, maybe that's why. >_>; I hate macs.

[Gary King]

Originally Posted by Sonikku

I can't get it to work. I get a parse error and a fatal error.

I'm gonna try to edit the php file in Windows see what I get. I'm using a MAC right now, maybe that's why. >_>; I hate macs.

Macs rule!

[Red Blaze]

Tried to install it on Windows and works perfectly.

[Boofo]

Originally Posted by AlexanderT

Is it possible to split the page load time into time needed for php and time needed for mysql (similar to the 2.x microstat hack)?

Not with this version, I don't think.

[Oblivion Knight]

Originally Posted by Boofo

Not with this version, I don't think.

http://www.bearfacts2.com/forums

Spill the beans.!

[AlexanderT]

Page generated in 0.16018701 seconds (87.84% PHP - 12.16% MySQL) with 13 queries.

Would you mind sharing it with us? Btw, I had 25 queries the first time I entered your site, then I had those 13 queries you see above. Both seems like a lot to me given that the unhacked forumindex has something like 8 queries.

[Frank]

Great hack, cheers

[Boofo]

Originally Posted by AlexanderT

Would you mind sharing it with us? Btw, I had 25 queries the first time I entered your site, then I had those 13 queries you see above. Both seems like a lot to me given that the unhacked forumindex has something like 8 queries.

I think an unhacked version is like 11 queries, isn't it? 13 queries is damned good with all the stats I have on the forumhome. And 25 is when the stats cache gets updated (every 10 minutes).

You guys will have to go to the site to get it. I can't release it here since it basically is just the version Teck released for vB2 re-worked for vB3.

[AlexanderT]

Originally Posted by Boofo

You guys will have to go to the site to get it. I can't release it here since it basically is just the version Teck released for vB2 re-worked for vB3.

Thanks, will do!