} // end of the 'localisedDate()' function ////////////////////// END FUNCTION LIST ///////////////////////////////////// $HTMLOUT = ''; $HTMLOUT .= "<h2>Mysql Server Status</h2>"; //$res = @mysql_query('SHOW STATUS') or sqlerr(__FILE__,__LINE__); $res = @sql_query('SHOW GLOBAL STATUS') or sqlerr(__FILE__, __LINE__); while ($row = mysql_fetch_row($res)) { $serverStatus[$row[0]] = $row[1]; } @mysql_free_result($res); unset($res); unset($row); $res = @sql_query('SELECT UNIX_TIMESTAMP() - ' . $serverStatus['Uptime']); $row = mysql_fetch_row($res); $HTMLOUT .= "<table class='torrenttable' border='1'>\r\n <tr>\r\n <td>This MySQL server has been running for " . timespanFormat($serverStatus['Uptime']) . ". It started up on " . localisedDate($row[0]) . "\r\n\r\n\r\n </td>\r\n </tr>\r\n </table><br />"; mysql_free_result($res); unset($res); unset($row); //Get query statistics $queryStats = array(); $tmp_array = $serverStatus; foreach ($tmp_array as $name => $value) { if (substr($name, 0, 4) == 'Com_') { $queryStats[str_replace('_', ' ', substr($name, 4))] = $value; unset($serverStatus[$name]); } } unset($tmp_array); $TRAFFIC_STATS = ''; $TRAFFIC_STATS_HEAD = "<!-- Server Traffic -->\r\n <b>Server traffic:</b> These tables show the network traffic statistics of this MySQL server since its startup";
} // end of the 'localisedDate()' function ////////////////////// END FUNCTION LIST ///////////////////////////////////// $HTMLOUT = ''; $HTMLOUT .= "<h2>{$lang['mysql_stats_status']}</h2>"; //$res = @mysql_query('SHOW STATUS') or sqlerr(__FILE__,__LINE__); $res = @sql_query('SHOW GLOBAL STATUS') or sqlerr(__FILE__, __LINE__); while ($row = mysqli_fetch_row($res)) { $serverStatus[$row[0]] = $row[1]; } @(mysqli_free_result($res) || is_object($res) && get_class($res) == "mysqli_result" ? true : false); unset($res); unset($row); $res = @sql_query('SELECT UNIX_TIMESTAMP() - ' . $serverStatus['Uptime']); $row = mysqli_fetch_row($res); $HTMLOUT .= "<table class='torrenttable' border='1'>\n <tr>\n <td>{$lang['mysql_stats_server']}" . timespanFormat($serverStatus['Uptime']) . $lang['mysql_stats_started'] . localisedDate($row[0]) . "\n\n\n </td>\n </tr>\n </table><br />"; mysqli_free_result($res) || is_object($res) && get_class($res) == "mysqli_result" ? true : false; unset($res); unset($row); //Get query statistics $queryStats = array(); $tmp_array = $serverStatus; foreach ($tmp_array as $name => $value) { if (substr($name, 0, 4) == 'Com_') { $queryStats[str_replace('_', ' ', substr($name, 4))] = $value; unset($serverStatus[$name]); } } unset($tmp_array); $TRAFFIC_STATS = ''; $TRAFFIC_STATS_HEAD = "<!-- Server Traffic -->\n <b>{$lang['mysql_stats_traffic_per_hour']}</b>{$lang['mysql_stats_tables']}";
$serverStatus[$row[0]] = $row[1]; } @mysql_free_result($res); unset($res); unset($row); /** * Displays the page */ //Uptime calculation $res = @mysql_query('SELECT UNIX_TIMESTAMP() - ' . $serverStatus['Uptime']); $row = mysql_fetch_row($res); //echo sprintf("Server Status Uptime", timespanFormat($serverStatus['Uptime']), localisedDate($row[0])) . "\n"; ?> <table id="torrenttable" border="1"><tr><td> <? print("This MySQL server has been running for ". timespanFormat($serverStatus['Uptime']) .". It started up on ". localisedDate($row[0])) . "\n"; ?> </td></tr></table> <? mysql_free_result($res); unset($res); unset($row); //Get query statistics $queryStats = array(); $tmp_array = $serverStatus; foreach($tmp_array AS $name => $value) { if (substr($name, 0, 4) == 'Com_') { $queryStats[str_replace('_', ' ', substr($name, 4))] = $value; unset($serverStatus[$name]); } }
@mysql_free_result($res); unset($res); unset($row); /** * Displays the page */ //Uptime calculation $res = @sql_query('SELECT UNIX_TIMESTAMP() - ' . $serverStatus['Uptime']); $row = mysql_fetch_row($res); //echo sprintf("Server Status Uptime", timespanFormat($serverStatus['Uptime']), localisedDate($row[0])) . "\n"; ?> <table id="torrenttable" border="1"><tr><td> <?php print $lang_mysql_stats['text_running'] . "<font color=red>" . timespanFormat($serverStatus['Uptime']) . "</font>" . $lang_mysql_stats['text_started'] . "<font color=red>" . localisedDate($row[0]) . "</font>\n"; ?> </td></tr></table> <?php mysql_free_result($res); unset($res); unset($row); //Get query statistics $queryStats = array(); $tmp_array = $serverStatus; foreach ($tmp_array as $name => $value) { if (substr($name, 0, 4) == 'Com_') { $queryStats[str_replace('_', ' ', substr($name, 4))] = $value; unset($serverStatus[$name]);