php
/* $Id: mysql_overview.php,v 1.01 2005/08/05 19:11:48 CoLdFuSiOn Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:


require "include/bittorrent.php";
dbconn(false);
loggedinorreturn();

/**
* Checks if the user is allowed to do what he tries to...
*/
if (get_user_class() < UC_SYSOP)
stderr("Error", "Permission denied.");

//Do we wanna continue here, or skip to just the overview?
if (isset($_GET['Do']) && isset($_GET['table'])) {
$Do = ($_GET['Do'] === "T") ? sqlesc($_GET['Do']) : ""; //for later use!
//Make sure the GET only has alpha letters and nothing else
if(!ereg('[^A-Za-z_]+', $_GET['table'])) {
$Table = '`'.$_GET['table'].'`';//add backquotes to GET or we is doomed!
}else{
print("Pig Dog!");//Silly boy doh!!
exit;
}

$sql = "OPTIMIZE TABLE $Table";
//preg match the sql incase it was hijacked somewhere!(will use CHECK|ANALYZE|REPAIR|later
if (preg_match('@^(CHECK|ANALYZE|REPAIR|OPTIMIZE)[[:space:]]TABLE[[:space:]]'.$Table.'$@i', $sql)) {
//all good? Do it!
@mysql_query($sql) or die("Something was not right!
Query: " . $sql . "
Error: (" . mysql_errno() . ") " . htmlspecialchars(mysql_error()));
//all done, redirect back to calling page
$return_url = "mysql_overview.php?Do=F";
header("Location: http://" . $_SERVER['HTTP_HOST']
. dirname($_SERVER['PHP_SELF'])
. "/" . $return_url);
exit;
}
}
//byteunit array to prime formatByteDown function
$GLOBALS["byteUnits"] = array('Bytes', 'KB', 'MB', 'GB', 'TB', 'PB', 'EB');

////////////////// FUNCTION LIST /////////////////////////

function formatByteDown($value, $limes = 2, $comma = 0)
{
$dh = pow(10, $comma);
$li = pow(10, $limes);
$return_value = $value;
$unit = $GLOBALS['byteUnits'][0];

for ( $d = 6, $ex = 15; $d >= 1; $d--, $ex-=3 ) {
if (isset($GLOBALS['byteUnits'][$d]) && $value >= $li * pow(10, $ex)) {
$value = round($value / ( pow(1024, $d) / $dh) ) /$dh;
$unit = $GLOBALS['byteUnits'][$d];
break 1;
} // end if
} // end for

if ($unit != $GLOBALS['byteUnits'][0]) {
$return_value = number_format($value, $comma, '.', ',');
} else {
$return_value = number_format($value, 0, '.', ',');
}

return array($return_value, $unit);
} // end of the 'formatByteDown' function
////////////////// END FUNCTION LIST /////////////////////////


stdhead("Stats");

/**
* Displays the sub-page heading
*/
echo '

' . "\n"
. ' Mysql Server Table Status' . "\n"
. '

' . "\n";
?>


































$count = 0;
/**
* Sends the query and buffers the result
*/
$res = @mysql_query('SHOW TABLE STATUS FROM `tsdev`') or Die(mysql_error());
while ($row = mysql_fetch_array($res)) {
list($formatted_Avg, $formatted_Abytes) = formatByteDown($row['Avg_row_length']);
list($formatted_Dlength, $formatted_Dbytes) = formatByteDown($row['Data_length']);
list($formatted_Ilength, $formatted_Ibytes) = formatByteDown($row['Index_length']);
list($formatted_Dfree, $formatted_Fbytes) = formatByteDown($row['Data_free']);
$tablesize = ($row['Data_length']) + ($row['Index_length']);
list($formatted_Tsize, $formatted_Tbytes) = formatByteDown($tablesize, 3, ($tablesize > 0) ? 1 : 0);

$thispage = "?Do=T&table=".$row['Name'];
$overhead = ($formatted_Dfree > 0) ? "".$formatted_Dfree." ".$formatted_Fbytes."" : $formatted_Dfree." ".$formatted_Fbytes;

echo "".
"".
"".
"".
"".
"".
"".
"";
//do sums
$count++;

}//end while
echo "";
?>

Name	Size	Rows	Avg row length	Data length	Index length	Overhead
{$row['Name']}	{$formatted_Tsize} {$formatted_Tbytes}	{$row['Rows']}	{$formatted_Avg} {$formatted_Abytes}	{$formatted_Dlength} {$formatted_Dbytes}	{$formatted_Ilength} {$formatted_Ibytes}	{$overhead}
Row Format: {$row['Row_format']}". " Create Time: {$row['Create_time']}". " Update Time: {$row['Update_time']}". " Check Time: {$row['Check_time']}
Tables: {$count}	If it's RED it probably needs optimising!!

stdfoot();
?>