addParam(count($selected)); } else { $message->addParam(0); } } } } /** * Displays the links */ require './libraries/server_links.inc.php'; /** * Displays the sub-page heading */ echo '

' . "\n" . ($GLOBALS['cfg']['MainPageIconic'] ? '' : '') . ($dbstats ? __('Databases statistics') : __('Databases')) . "\n" .'

' . "\n"; /** * Create database. */ if ($cfg['ShowCreateDb']) { echo '' . "\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 = count($GLOBALS['pma']->databases); } else { $databases_count = 0; } /** * Displays the page */ if ($databases_count > 0) { echo '
'; reset($databases); $first_database = current($databases); // table col order $column_order = PMA_getColumnOrder(); $_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 '
' . "\n" . PMA_generate_common_hidden_inputs($_url_params); $_url_params['sort_by'] = 'SCHEMA_NAME'; $_url_params['sort_order'] = ($sort_by == 'SCHEMA_NAME' && $sort_order == 'asc') ? 'desc' : 'asc'; echo '' . "\n" . '' . "\n" . '' . "\n" . ($is_superuser || $cfg['AllowUserDropDatabase'] ? ' ' . "\n" : '') . ' ' . "\n"; $table_columns = 3; foreach ($column_order as $stat_name => $stat) { if (array_key_exists($stat_name, $first_database)) { if ($stat['format'] === 'byte') { $table_columns += 2; $colspan = ' colspan="2"'; } else { $table_columns++; $colspan = ''; } $_url_params['sort_by'] = $stat_name; $_url_params['sort_order'] = ($sort_by == $stat_name && $sort_order == 'desc') ? 'asc' : 'desc'; echo ' ' .'' . "\n" .' ' . $stat['disp_name'] . "\n" .($sort_by == $stat_name ? ' ' . ($sort_order == 'asc' ? __('Ascending') : __('Descending')) . '' . "\n" : '') .' ' . "\n"; } } foreach ($replication_types as $type) { if ($type=="master") $name = __('Master replication'); elseif ($type == "slave") $name = __('Slave replication'); if (${"server_{$type}_status"}) echo ' ' . "\n"; } if ($is_superuser && !PMA_DRIZZLE) { echo ' ' . "\n"; } echo '' . "\n" . '' . "\n" . '' . "\n"; $odd_row = true; foreach ($databases as $current) { $tr_class = $odd_row ? 'odd' : 'even'; if (PMA_is_system_schema($current['SCHEMA_NAME'], true)) { $tr_class .= ' noclick'; } echo '' . "\n"; $odd_row = ! $odd_row; list($column_order, $generated_html) = PMA_buildHtmlForDb($current, $is_superuser, (isset($checkall) ? $checkall : ''), $url_query, $column_order, $replication_types, $replication_info); echo $generated_html; echo '' . "\n"; } // end foreach ($databases as $key => $current) unset($current, $odd_row); echo '' . "\n"; if ($is_superuser || $cfg['AllowUserDropDatabase']) { echo ' ' . "\n"; } echo ' ' . "\n"; foreach ($column_order as $stat_name => $stat) { if (array_key_exists($stat_name, $first_database)) { if ($stat['format'] === 'byte') { list($value, $unit) = PMA_formatByteDown($stat['footer'], 3, 1); } elseif ($stat['format'] === 'number') { $value = PMA_formatNumber($stat['footer'], 0); } else { $value = htmlentities($stat['footer'], 0); } echo ' ' . "\n"; if ($stat['format'] === 'byte') { echo ' ' . "\n"; } } } foreach ($replication_types as $type) { if (${"server_{$type}_status"}) echo ' ' . "\n"; } if ($is_superuser) { echo ' ' . "\n"; } echo '' . "\n"; echo '' . "\n" .'
' . "\n" . ' ' . __('Database') . "\n" . ($sort_by == 'SCHEMA_NAME' ? ' ' . ($sort_order == 'asc' ? __('Ascending') : __('Descending')) . '' . "\n" : '') . ' '. $name .'' . ($cfg['PropertiesIconic'] ? '' : __('Action')) . "\n" . '
' . __('Total') . ': ' . $databases_count . ''; if (isset($stat['description_function'])) { echo ''; } echo $value; if (isset($stat['description_function'])) { echo ''; } echo '' . $unit . '
' . "\n"; unset($column_order, $stat_name, $stat, $databases, $table_columns); if ($is_superuser || $cfg['AllowUserDropDatabase']) { $common_url_query = PMA_generate_common_url(array('sort_by' => $sort_by, 'sort_order' => $sort_order, 'dbstats' => $dbstats)); echo '' . __('With selected:') . '' . "\n" . '' . "\n" . ' ' . __('Check All') . ' / ' . "\n" . '' . "\n" . ' ' . __('Uncheck All') . '' . "\n" . '' . __('With selected:') . '' . "\n"; PMA_buttonOrImage('drop_selected_dbs', 'mult_submit', 'drop_selected_dbs', __('Drop'), 'b_deltbl.png'); } if (empty($dbstats)) { echo '' . "\n"; } echo '
'; echo '
'; } else { echo __('No databases'); } unset($databases_count); /** * Sends the footer */ require './libraries/footer.inc.php'; ?>