' . "\n";
$odd_row = ! $odd_row;
if ($is_superuser || $cfg['AllowUserDropDatabase']) {
echo ' | ' . "\n";
if ($current['SCHEMA_NAME'] != 'mysql' && (PMA_MYSQL_INT_VERSION < 50002 || $current['SCHEMA_NAME'] != 'information_schema')) {
echo ' ' . "\n";
} else {
echo ' ' . "\n";
}
echo ' | ' . "\n";
}
echo ' ' . "\n"
. ' ' . "\n"
. ' ' . htmlspecialchars($current['SCHEMA_NAME']) . "\n"
. ' ' . "\n"
. ' | ' . "\n";
foreach ($column_order as $stat_name => $stat) {
if (array_key_exists($stat_name, $current)) {
if (is_numeric($stat['footer'])) {
$column_order[$stat_name]['footer'] += $current[$stat_name];
}
if ($stat['format'] === 'byte') {
list($value, $unit) = PMA_formatByteDown($current[$stat_name], 3, 1);
} elseif ($stat['format'] === 'number') {
$value = PMA_formatNumber($current[$stat_name], 0);
} else {
$value = htmlentities($current[$stat_name], 0);
}
echo ' ';
if (isset($stat['description_function'])) {
echo '';
}
echo $value;
if (isset($stat['description_function'])) {
echo '';
}
echo ' | ' . "\n";
if ($stat['format'] === 'byte') {
echo ' ' . $unit . ' | ' . "\n";
}
}
}
if ($is_superuser) {
echo ' ' . "\n"
. ' '. "\n"
. ' ' .($cfg['PropertiesIconic'] ? ' ' : $strCheckPrivs). "\n"
. ' | ' . "\n";
}
echo '
' . "\n";
} // end foreach ($databases as $key => $current)
unset($current, $odd_row);
echo '
'
: '')
. ($dbstats ? $strDatabasesStats : $strDatabases) . "\n"
.'' . "\n";
/**
* Gets the databases list
*/
if ($server > 0) {
$databases = PMA_DBI_get_databases_full(null, $dbstats, null, $sort_by,
$sort_order, $pos, true);
$databases_count = $PMA_List_Database->count();
} else {
$databases_count = 0;
}
/**
* Displays the page
*/
if ($databases_count > 0) {
reset($databases);
$first_database = current($databases);
// table col order
// there is no db specific collation or charset prior 4.1.0
if (PMA_MYSQL_INT_VERSION >= 40100) {
$column_order['DEFAULT_COLLATION_NAME'] = array(
'disp_name' => $strCollation,
'description_function' => 'PMA_getCollationDescr',
'format' => 'string',
'footer' => PMA_getServerCollation(),
);
}
$column_order['SCHEMA_TABLES'] = array(
'disp_name' => $strNumTables,
'format' => 'number',
'footer' => 0,
);
$column_order['SCHEMA_TABLE_ROWS'] = array(
'disp_name' => $strRows,
'format' => 'number',
'footer' => 0,
);
$column_order['SCHEMA_DATA_LENGTH'] = array(
'disp_name' => $strData,
'format' => 'byte',
'footer' => 0,
);
$column_order['SCHEMA_INDEX_LENGTH'] = array(
'disp_name' => $strIndexes,
'format' => 'byte',
'footer' => 0,
);
$column_order['SCHEMA_LENGTH'] = array(
'disp_name' => $strTotalUC,
'format' => 'byte',
'footer' => 0,
);
$column_order['SCHEMA_DATA_FREE'] = array(
'disp_name' => $strOverhead,
'format' => 'byte',
'footer' => 0,
);
$_url_params = array(
'pos' => $pos,
'dbstats' => $dbstats,
'sort_by' => $sort_by,
'sort_order' => $sort_order,
);
PMA_listNavigator($databases_count, $pos, $_url_params, 'server_databases.php', 'frame_content', $GLOBALS['cfg']['MaxDbList']);
$_url_params['pos'] = $pos;
echo '';
} else {
echo $strNoDatabases;
}
unset($databases_count);
/**
* Create new database.
*/
if ($cfg['ShowCreateDb']) {
echo '