|
= 50000 && $db == 'information_schema') {
$cfg['ShowStats'] = FALSE;
pma_TableHeader(FALSE, FALSE);
} else {
pma_TableHeader();
}
$i = $sum_entries = 0;
(double) $sum_size = 0;
(double) $overhead_size = 0;
$overhead_check = '';
$checked = (!empty($checkall) ? ' checked="checked"' : '');
$num_columns = ($cfg['PropertiesNumColumns'] > 1 ? (ceil($num_tables / $cfg['PropertiesNumColumns']) + 1) : 0);
$row_count = 0;
if ($cfg['NaturalOrder']) {
$tables_temp = $tables;
foreach (array_keys($tables_temp) as $each) {
$tables_sort[$each] = $tables_temp[$each]['Name'];
}
natsort($tables_sort);
$sort_i = 0;
foreach (array_keys($tables_sort) as $each) {
$tables_temp[$sort_i] = $tables[$each];
$sort_i++;
}
$tables = $tables_temp;
}
foreach ($tables AS $keyname => $sts_data) {
$table = $sts_data['Name'];
$table_encoded = urlencode($table);
$table_name = htmlspecialchars($table);
$is_view = (PMA_MYSQL_INT_VERSION >= 50000
&& !isset($sts_data['Type'])
&& $sts_data['Comment'] == 'view');
$alias = (!empty($tooltip_aliasname) && isset($tooltip_aliasname[$table]))
? htmlspecialchars($tooltip_aliasname[$table])
: htmlspecialchars($sts_data['Name']);
$truename = (!empty($tooltip_truename) && isset($tooltip_truename[$table]))
? htmlspecialchars($tooltip_truename[$table])
: htmlspecialchars($sts_data['Name']);
// Sets parameters for links
$tbl_url_query = $url_query . '&table=' . $table_encoded;
$bgcolor = ($i++ % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
echo "\n";
if ($GLOBALS['cfg']['BrowsePointerEnable'] == TRUE) {
$on_mouse = ' onmouseover="setPointer(this, ' . $i . ', \'over\', \'' . $bgcolor . '\', \'' . $GLOBALS['cfg']['BrowsePointerColor'] . '\', \'' . $GLOBALS['cfg']['BrowseMarkerColor'] . '\');"'
. ' onmouseout="setPointer(this, ' . $i . ', \'out\', \'' . $bgcolor . '\', \'' . $GLOBALS['cfg']['BrowsePointerColor'] . '\', \'' . $GLOBALS['cfg']['BrowseMarkerColor'] . '\');"';
} else {
$on_mouse = '';
}
if ($GLOBALS['cfg']['BrowseMarkerEnable'] == TRUE) {
$on_mouse .= ' onmousedown="setPointer(this, ' . $i . ', \'click\', \'' . $bgcolor . '\', \'' . $GLOBALS['cfg']['BrowsePointerColor'] . '\', \'' . $GLOBALS['cfg']['BrowseMarkerColor'] . '\');"';
}
$click_mouse = ' onmousedown="document.getElementById(\'checkbox_tbl_' . $i . '\').checked = (document.getElementById(\'checkbox_tbl_' . $i . '\').checked ? false : true);" ';
$row_count++;
if ($num_columns > 0 && $num_tables > $num_columns && (($row_count % ($num_columns)) == 0)) {
$bgcolor = $cfg['BgcolorTwo'];
$row_count = 1;
?>
|
>
|
/>
|
>
|
= 50000 && $db == 'information_schema')) {
echo '' . $titles['Browse'] . '';
} else {
echo $titles['NoBrowse'];
}
?>
|
= 50000 && $db == 'information_schema')) {
echo ''
. $titles['Search'] . '';
} else {
echo $titles['NoSearch'];
}
?>
|
= 50000 && $db == 'information_schema') {
// rabus: We cannot insert into information_schema tables!
echo $titles['NoInsert'];
} else {
?>
|
|
= 40000) {
echo urlencode('TRUNCATE ' . PMA_backquote($table))
. '&zero_rows='
. urlencode(sprintf($strTableHasBeenEmptied, htmlspecialchars($table)))
. '" onclick="return confirmLink(this, \'TRUNCATE ';
} else {
echo urlencode('DELETE FROM ' . PMA_backquote($table))
. '&zero_rows='
. urlencode(sprintf($strTableHasBeenEmptied, htmlspecialchars($table)))
. '" onclick="return confirmLink(this, \'DELETE FROM ';
}
echo PMA_jsFormat($table) . '\')">' . $titles['Empty'] . '';
} else {
echo $titles['NoEmpty'];
}
$drop_query = 'DROP '
. ($is_view ? 'VIEW' : 'TABLE')
. ' ' . PMA_backquote($table);
$drop_message = sprintf(($is_view ? $strViewHasBeenDropped : $strTableHasBeenDropped), htmlspecialchars($table));
?>
|
= 50000 && $db == 'information_schema') {
echo $titles['NoDrop'];
} else {
?>
|
to get valid
// statistics whatever is the table type
if (isset($sts_data['Rows']) || (PMA_MYSQL_INT_VERSION >= 50000 && $db == 'information_schema')) {
// MyISAM, ISAM or Heap table: Row count, data size and index size
// is accurate.
if (isset($sts_data['Type']) && preg_match('@^(MyISAM|ISAM|HEAP)$@', $sts_data['Type'])) {
if ($cfg['ShowStats']) {
$tblsize = doubleval($sts_data['Data_length']) + doubleval($sts_data['Index_length']);
$sum_size += $tblsize;
list($formated_size, $unit) = PMA_formatByteDown($tblsize, 3, ($tblsize > 0) ? 1 : 0);
if (isset($sts_data['Data_free']) && $sts_data['Data_free'] > 0) {
list($formated_overhead, $overhead_unit) = PMA_formatByteDown($sts_data['Data_free']);
$overhead_size += $sts_data['Data_free'];
}
}
$sum_entries += $sts_data['Rows'];
$display_rows = number_format($sts_data['Rows'], 0, $number_decimal_separator, $number_thousands_separator);
}
// InnoDB table: Row count is not accurate but data and index
// sizes are.
else if (isset($sts_data['Type']) && $sts_data['Type'] == 'InnoDB') {
if ($cfg['ShowStats']) {
$tblsize = $sts_data['Data_length'] + $sts_data['Index_length'];
$sum_size += $tblsize;
list($formated_size, $unit) = PMA_formatByteDown($tblsize, 3, ($tblsize > 0) ? 1 : 0);
}
//$display_rows = ' - ';
// get row count with another method
if ($sts_data['Rows'] < $cfg['MaxExactCount']) {
$local_query = 'SELECT COUNT(*) AS count FROM '
. PMA_backquote($db) . '.'
. PMA_backquote($table);
$table_info_result = PMA_DBI_query($local_query);
list($row_count) = PMA_DBI_fetch_row($table_info_result);
PMA_DBI_free_result($table_info_result);
unset($table_info_result);
$sum_entries += $row_count;
} else {
$row_count = $sts_data['Rows'];
$sum_entries += $sts_data['Rows'];
}
$display_rows = number_format($row_count, 0, $number_decimal_separator, $number_thousands_separator);
}
// Merge or BerkleyDB table: Only row count is accurate.
else if (isset($sts_data['Type']) && preg_match('@^(MRG_MyISAM|BerkeleyDB)$@', $sts_data['Type'])) {
if ($cfg['ShowStats']) {
$formated_size = ' - ';
$unit = '';
}
$sum_entries += $sts_data['Rows'];
$display_rows = number_format($sts_data['Rows'], 0, $number_decimal_separator, $number_thousands_separator);
}
// Unknown table type.
else {
if ($cfg['ShowStats']) {
$formated_size = 'unknown';
$unit = '';
}
$display_rows = 'unknown';
}
// Don't display number of rows for information_schema tables.
if (!(PMA_MYSQL_INT_VERSION >= 50000 && $db == 'information_schema')) {
?>
>
|
1)) {
echo ' ' . "\n"
. ' ' . (isset($sts_data['Type']) ? $sts_data['Type'] : ' ') . ' ' . "\n"
. ' | ' . "\n";
if (PMA_MYSQL_INT_VERSION >= 40100) {
echo ' ' . "\n"
. ' ' . (isset($sts_data['Collation']) ? '' . $sts_data['Collation'] . '' : '---') . ' ' . "\n"
. ' | ' . "\n";
}
}
if ($cfg['ShowStats']) {
echo "\n";
?>
>
|
>
' . $formated_overhead . ' ' . $overhead_unit . '' . "\n";
unset($formated_overhead);
$overhead_check .= "document.getElementById('checkbox_tbl_$i').checked = true;";
} else {
echo " - \n";
}
?>
|
= 50000 && $sts_data['Comment'] == 'view') {
// rabus: We've found a view
?>
-
|
|
---
|
-
|
-
|
>
|
';
$titles['NoBrowse'] = $iconic_spacer . '
';
$titles['Search'] = $iconic_spacer . '
';
$titles['NoSearch'] = $iconic_spacer . '
';
$titles['Insert'] = $iconic_spacer . '
';
$titles['NoInsert'] = $iconic_spacer . '
';
$titles['Structure'] = $iconic_spacer . '
';
$titles['Drop'] = $iconic_spacer . '
';
$titles['NoDrop'] = $iconic_spacer . '
';
$titles['Empty'] = $iconic_spacer . '
';
$titles['NoEmpty'] = $iconic_spacer . '
';
if ($propicon == 'both') {
$titles['Browse'] .= ' ' . $strBrowse . '';
$titles['Search'] .= ' ' . $strSearch . '';
$titles['NoBrowse'] .= ' ' . $strBrowse . '';
$titles['NoSearch'] .= ' ' . $strSearch . '';
$titles['Insert'] .= ' ' . $strInsert . '';
$titles['NoInsert'] .= ' ' . $strInsert . '';
$titles['Structure'] .= ' ' . $strStructure . '';
$titles['Drop'] .= ' ' . $strDrop . '';
$titles['NoDrop'] .= ' ' . $strDrop . '';
$titles['Empty'] .= ' ' . $strEmpty . '';
$titles['NoEmpty'] .= ' ' . $strEmpty . '';
}
} else {
$titles['Browse'] = $strBrowse;
$titles['Search'] = $strSearch;
$titles['NoBrowse'] = $strBrowse;
$titles['NoSearch'] = $strSearch;
$titles['Insert'] = $strInsert;
$titles['NoInsert'] = $strInsert;
$titles['Structure'] = $strStructure;
$titles['Drop'] = $strDrop;
$titles['NoDrop'] = $strDrop;
$titles['Empty'] = $strEmpty;
$titles['NoEmpty'] = $strEmpty;
}
// 1. No tables
if ($num_tables == 0) {
echo $strNoTablesFound . "\n";
}
// 2. Shows table informations - staybyte - 11 June 2001
else {
?>
';
}
echo $strPrintView . '';
?>
';
if($cfg['PropertiesIconic']){
echo '
';
}
echo $strDataDict . '';
?>