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!

[KW802]

Any thoughts on if we don't see the server load with either version?

[Erwin]

Originally Posted by Torqued

Ok. I fixed it... don't know why it works, but it does! LOL

I took the code @ the bottom of 1.2 for evaluating/displaying uncached templates and put that code in the same spot in 1.02 and it works!

Now how is it that I fix uncached templates? I'm running vBAdvanced CMPS 1.0.0 and vBLinks 1.0.0. The two uncached templates are related to the links directory.

Add to the list of cached templates at the top of the PHP file (each uncached templates add 1 unnecessary database query).

[Delphiprogrammi]

nice one i clicked install

[MindTrix]

Dont know if this has been covered, but if you have shoutbox installed it shows up in the bottom of that aswell on the forum homepage. Just thought i would mention, other wise its nice and simple thanks. 23 querys on main page, ouch.

[dwh]

This hack is the bomb if you do any real hacking. Must have.

[SaN-DeeP]

for some reason (i am not sure)
[Server Loads: 0.57 0.64 : 0.51] -> this line is not visible on my new server ?
i am on a VPS solution on this server any idea ?

Help is appreciated.
Page generated in 0.23279 seconds with 8 queries -> only this line appears not the server loads.

I have tried using both the code versions mentioned.

Regards,

[Rhoads]

Oke nice hack, but I wonder myself is this bad or good, and wat can I do if it's bad, I run 15 modules

Page generated in 0,85302 seconds with 26 queries (2 queries for uncached templates)
Uncached templates: adv_portal_ (1)
Uncached templates: board_inactive_warning (1)

[dwh]

You need to add those templates at the beginning of the php page that you saw the message on. It will speed up the page and reduce the number of queries to the database which will be good for all of your vb installation.

[Erwin]

Originally Posted by dwh

You need to add those templates at the beginning of the php page that you saw the message on. It will speed up the page and reduce the number of queries to the database which will be good for all of your vb installation.

Except for "board_inactive_warning" template - that's when your board is turned off, and there's no need to globally cache it.

[Rhoads]

Originally Posted by dwh

You need to add those templates at the beginning of the php page that you saw the message on. It will speed up the page and reduce the number of queries to the database which will be good for all of your vb installation.

Oke Thanks for the answer.

But can you explain a litllebit how it's works.
Thnx