Working in 3.7.2, Thanks! :)

Installed and working on 3.7.2.

How do we enable this option to work for multiple usergroups ?
We want Administrators, super-moderators and moderator usergroups to be able to check server load.s

thanks

How would I go about moving the location of the text that gets printed out?

I would like to put it with the copyright text... Otherwise it screws with my design:

http://www.8wayrun.com/forums.php

Worked on 373PL1 :up:

It is possible to see which query is taking how much time to execute? So that we can debug or optimize those queries. i am facing issued when clicking on the Forums to go to forumdisplay.php. Its taking like 25 secs on load 43 queries on a forumdisplay.php page. How can view those queries and how much they are taking. This is most urgent please.

I don't think this hack can be used to time individual queries, it only marks the time difference between the page request and when it is complete.

43 queries on a forumdisplay.php page seems like quite a bit of them. I just loaded the forumdisplay.php page on two forums I admin. The more customized one ran 26 queries on a forumdisplay, one that is a little closer to stock ran 21 queries. To figure out what is taking so long on yours, I'd disable all plug-ins, then re-enable them 1 by 1 until you see the page load time increase dramatically.

works with 3.8.0 beta 4 as well

Go to Plugin & Products System -> Product Manager -> Microstats.

Remove the current code, replace with..

$pageendtime = microtime();
$starttime = explode(' ', $pagestarttime);
$endtime = explode(' ', $pageendtime);
$totaltime = vb_number_format($endtime[0] - $starttime[0] + $endtime[1] - $starttime[1], 5);
$debughtml = '<center><span class="smallfont">Page generated in <b>' . $totaltime . '</b> seconds with <b>' . $vbulletin->db->querycount . '</b> queries';
$usergroupid = $vbulletin->userinfo['usergroupid'];

if ($usergroupid == 5 || $usergroupid == 6 || $usergroupid == 7) {

if ($loadavg = @file_get_contents("/proc/loadavg")) {

$regs = explode(" ",$loadavg);
$serverload = ' [Server Loads: <b>' . $regs[0] .'</b> ' . $regs[1] . ' : ' . $regs[2] . ']';

}elseif ($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] . ']';

}elseif ($loadavg = @`sysctl vm.loadavg|cut -d" " -f3-5`) {

$regs = explode(" ",$loadavg);
$serverload = ' [Server Loads: <b>' . $regs[0] .'</b> ' . $regs[1] . ' : ' . $regs[2] . ']';

}

$debughtml .= iif($_TEMPLATEQUERIES, ' (<b>' . sizeof($_TEMPLATEQUERIES) . '</b> queries for uncached templates)', '') . "$serverload";

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>';
}
}

}

$debughtml .= "</span></center>";

if (!$vbulletin->config['Microstats']['replacementvariable']) {

$vbulletin->config['Microstats']['replacementvariable'] = '</body>';

}

if (($vbulletin->config['Microstats']['adminonly'] and $vbulletin->userinfo['usergroupid'] == 5 || $usergroupid == 6 || $usergroupid == 7) or !$vbulletin->config['Microstats']['adminonly']){

$output = str_replace($vbulletin->config['Microstats']['replacementvariable'], $debughtml . $vbulletin->config['Microstats']['replacementvariable'], $output);

}

Where you see the usergroupid = 5, 6 & 7, replace those numbers with whatever your usergroup id's are that you want to see the microstats.

Hope this helps :)

I need this plugin :

generated this page in 0.21 seconds (79.54% PHP - 20.46% MySQL) with 11 queries.

from forum http://forums.offtopic.com/

p.s. good forum... Posts: 112,870,447 :)