$submit_mult, 'selected' => $_REQUEST['selected_dbs'], 'mult_btn' => __('Yes'), 'db' => $GLOBALS['db'], 'table' => $GLOBALS['table']); } include 'libraries/mult_submits.inc.php'; unset($action, $submit_mult, $err_url, $selected_db, $GLOBALS['db']); if (empty($message)) { if ($mult_btn == __('Yes')) { $number_of_databases = count($selected); } else { $number_of_databases = 0; } $message = PMA_Message::success(_ngettext('%1$d database has been dropped successfully.', '%1$d databases have been dropped successfully.', $number_of_databases)); $message->addParam($number_of_databases); } } if ($GLOBALS['is_ajax_request'] && $message instanceof PMA_Message) { PMA_ajaxResponse($message, $message->isSuccess()); } } /** * Displays the sub-page heading */ echo '

' . "\n" . PMA_getImage('s_db.png') . ($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 ? ' ' . PMA_getImage('s_' . $sort_order . '.png', ($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' ? ' ' . PMA_getImage('s_' . $sort_order . '.png', ($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"; echo PMA_getButtonOrImage('drop_selected_dbs', 'mult_submit' . ($cfg['AjaxEnable'] ? ' ajax' : ''), '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'; ?>