Beispiel #1
0
}
// 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']}";
Beispiel #3
0
    $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]);
}
}
Beispiel #4
0
@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]);