0) { while ($tmp = PMA_mysql_fetch_array($result)) { // if in use memorize tablename if (preg_match('@in_use=[1-9]+@i', $tmp[0])) { $sot_cache[$tmp[0]] = TRUE; } } mysql_free_result($result); if (isset($sot_cache)) { $local_query = 'SHOW TABLES FROM ' . PMA_backquote($db); $result = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url); if ($result != FALSE && mysql_num_rows($result) > 0) { while ($tmp = PMA_mysql_fetch_array($result)) { if (!isset($sot_cache[$tmp[0]])) { $local_query = 'SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ' LIKE \'' . addslashes($tmp[0]) . '\''; $sts_result = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url); $sts_tmp = PMA_mysql_fetch_array($sts_result); $tables[] = $sts_tmp; } else { // table in use $tables[] = array('Name' => $tmp[0]); } } mysql_free_result($result); $sot_ready = TRUE; } } } } if (!isset($sot_ready)) { $local_query = 'SHOW TABLE STATUS FROM ' . PMA_backquote($db); $result = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url); if ($result != FALSE && mysql_num_rows($result) > 0) { while ($sts_tmp = PMA_mysql_fetch_array($result)) { $tables[] = $sts_tmp; } mysql_free_result($result); } } $num_tables = (isset($tables) ? count($tables) : 0); if ($cfgRelation['commwork']) { $comment = PMA_getComments($db); /** * Displays DB comment */ if (is_array($comment)) { ?>
= 3.23.03 - staybyte - 11 June 2001 else { ?>
' . $strSize . ''; } echo "\n"; ?> | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0) { list($formated_size, $unit) = PMA_formatByteDown($tblsize, 3, 1); } else { list($formated_size, $unit) = PMA_formatByteDown($tblsize, 3, 0); } } else if ($cfg['ShowStats']) { $formated_size = ' - '; $unit = ''; } $sum_entries += $sts_data['Rows']; } // MyISAM MERGE Table else if ($cfg['ShowStats'] && $mergetable == TRUE) { $formated_size = ' - '; $unit = ''; } else if ($cfg['ShowStats']) { $formated_size = 'unknown'; $unit = ''; } ?> | ' . number_format($sts_data['Rows'], 0, $number_decimal_separator, $number_thousands_separator) . '' . "\n"; } else { echo number_format($sts_data['Rows'], 0, $number_decimal_separator, $number_thousands_separator) . "\n"; } ?> |
';
} else {
$needs_break = '';
}
if ((isset($sts_data['Create_time']) && !empty($sts_data['Create_time']))
|| (isset($sts_data['Update_time']) && !empty($sts_data['Update_time']))
|| (isset($sts_data['Check_time']) && !empty($sts_data['Check_time']))) {
echo $needs_break;
?>
|
|||||||||||
-- |