2 /* vim: set expandtab sw=4 ts=4 sts=4: */
11 require_once 'libraries/common.inc.php';
12 $response = PMA_Response
::getInstance();
13 $header = $response->getHeader();
14 $scripts = $header->getScripts();
15 $scripts->addFile('server_databases.js');
17 require 'libraries/server_common.inc.php';
19 include_once 'libraries/replication.inc.php';
21 $replication_types = array();
22 $replication_info = null;
24 require 'libraries/build_html_for_db.lib.php';
27 * Sets globals from $_POST
34 foreach ($post_params as $one_post_param) {
35 if (isset($_POST[$one_post_param])) {
36 $GLOBALS[$one_post_param] = $_POST[$one_post_param];
41 * avoids 'undefined index' errors
43 if (empty($_REQUEST['sort_by'])) {
44 $sort_by = 'SCHEMA_NAME';
46 $sort_by_whitelist = array(
48 'DEFAULT_COLLATION_NAME',
52 'SCHEMA_INDEX_LENGTH',
56 if (in_array($_REQUEST['sort_by'], $sort_by_whitelist)) {
57 $sort_by = $_REQUEST['sort_by'];
59 $sort_by = 'SCHEMA_NAME';
63 if (isset($_REQUEST['sort_order'])
64 && strtolower($_REQUEST['sort_order']) == 'desc'
71 $dbstats = empty($_REQUEST['dbstats']) ?
0 : 1;
72 $pos = empty($_REQUEST['pos']) ?
0 : (int) $_REQUEST['pos'];
76 * Drops multiple databases
79 // workaround for IE behavior (it returns some coordinates based on where
80 // the mouse was on the Drop image):
81 if (isset($_REQUEST['drop_selected_dbs_x'])) {
82 $_REQUEST['drop_selected_dbs'] = true;
85 if ((isset($_REQUEST['drop_selected_dbs']) ||
isset($_REQUEST['query_type']))
86 && ($is_superuser ||
$cfg['AllowUserDropDatabase'])
88 if (! isset($_REQUEST['selected_dbs']) && ! isset($_REQUEST['query_type'])) {
89 $message = PMA_Message
::error(__('No databases selected.'));
91 $action = 'server_databases.php';
92 $submit_mult = 'drop_db';
93 $err_url = 'server_databases.php?' . PMA_generate_common_url();
94 if (isset($_REQUEST['selected_dbs'])
95 && !isset($_REQUEST['is_js_confirmed'])
97 $selected_db = $_REQUEST['selected_dbs'];
99 if (isset($_REQUEST['is_js_confirmed'])) {
101 'query_type' => $submit_mult,
102 'selected' => $_REQUEST['selected_dbs'],
103 'mult_btn' => __('Yes'),
104 'db' => $GLOBALS['db'],
105 'table' => $GLOBALS['table']);
107 include 'libraries/mult_submits.inc.php';
108 unset($action, $submit_mult, $err_url, $selected_db, $GLOBALS['db']);
109 if (empty($message)) {
110 if ($mult_btn == __('Yes')) {
111 $number_of_databases = count($selected);
113 $number_of_databases = 0;
115 $message = PMA_Message
::success(
117 '%1$d database has been dropped successfully.',
118 '%1$d databases have been dropped successfully.',
122 $message->addParam($number_of_databases);
125 if ($GLOBALS['is_ajax_request'] && $message instanceof PMA_Message
) {
126 $response = PMA_Response
::getInstance();
127 $response->isSuccess($message->isSuccess());
128 $response->addJSON('message', $message);
134 * Displays the sub-page heading
137 . PMA_Util
::getImage('s_db.png')
138 . ($dbstats ?
__('Databases statistics') : __('Databases')) . "\n"
144 if ($cfg['ShowCreateDb']) {
145 echo '<ul><li id="li_create_database" class="no_bullets">' . "\n";
146 include 'libraries/display_create_database.lib.php';
147 echo ' </li>' . "\n";
152 * Gets the databases list
155 $databases = PMA_DBI_getDatabasesFull(
156 null, $dbstats, null, $sort_by, $sort_order, $pos, true
158 $databases_count = count($GLOBALS['pma']->databases
);
160 $databases_count = 0;
168 if ($databases_count > 0) {
169 $html .= '<div id="tableslistcontainer">';
171 $first_database = current($databases);
173 $column_order = PMA_getColumnOrder();
175 $_url_params = array(
177 'dbstats' => $dbstats,
178 'sort_by' => $sort_by,
179 'sort_order' => $sort_order,
182 $html .= PMA_Util
::getListNavigator(
183 $databases_count, $pos, $_url_params, 'server_databases.php',
184 'frame_content', $GLOBALS['cfg']['MaxDbList']
187 $_url_params['pos'] = $pos;
188 $_url_params['drop_selected_dbs'] = 1;
190 $html .= '<form class="ajax" action="server_databases.php" ';
191 $html .= 'method="post" name="dbStatsForm" id="dbStatsForm">' . "\n";
192 $html .= PMA_generate_common_hidden_inputs($_url_params);
194 $_url_params['sort_by'] = 'SCHEMA_NAME';
195 $_url_params['sort_order'] = ($sort_by == 'SCHEMA_NAME' && $sort_order == 'asc') ?
'desc' : 'asc';
197 $html .= '<table id="tabledatabases" class="data">' . "\n"
200 . ($is_superuser ||
$cfg['AllowUserDropDatabase'] ?
' <th></th>' . "\n" : '')
201 . ' <th><a href="server_databases.php' . PMA_generate_common_url($_url_params) . '">' . "\n"
202 . ' ' . __('Database') . "\n"
203 . ($sort_by == 'SCHEMA_NAME' ?
' ' . PMA_Util
::getImage('s_' . $sort_order . '.png', ($sort_order == 'asc' ?
__('Ascending') : __('Descending'))) . "\n" : '')
204 . ' </a></th>' . "\n";
206 foreach ($column_order as $stat_name => $stat) {
207 if (array_key_exists($stat_name, $first_database)) {
208 if ($stat['format'] === 'byte') {
210 $colspan = ' colspan="2"';
215 $_url_params['sort_by'] = $stat_name;
216 $_url_params['sort_order'] = ($sort_by == $stat_name && $sort_order == 'desc') ?
'asc' : 'desc';
217 $html .= ' <th' . $colspan . '>'
218 . '<a href="server_databases.php' . PMA_generate_common_url($_url_params) . '">' . "\n"
219 . ' ' . $stat['disp_name'] . "\n"
220 . ($sort_by == $stat_name ?
' ' . PMA_Util
::getImage('s_' . $sort_order . '.png', ($sort_order == 'asc' ?
__('Ascending') : __('Descending'))) . "\n" : '')
221 . ' </a></th>' . "\n";
225 foreach ($replication_types as $type) {
226 if ($type=="master") {
227 $name = __('Master replication');
228 } elseif ($type == "slave") {
229 $name = __('Slave replication');
231 if ($
{"server_{$type}_status"}) {
232 $html .= ' <th>'. $name .'</th>' . "\n";
236 if ($is_superuser && ! PMA_DRIZZLE
) {
237 $html .= ' <th>' . ($cfg['PropertiesIconic'] ?
'' : __('Action')) . "\n"
240 $html .= '</tr>' . "\n"
245 foreach ($databases as $current) {
246 $tr_class = $odd_row ?
'odd' : 'even';
247 if (PMA_is_system_schema($current['SCHEMA_NAME'], true)) {
248 $tr_class .= ' noclick';
250 $html .= '<tr class="' . $tr_class . '">' . "\n";
251 $odd_row = ! $odd_row;
253 list($column_order, $generated_html) = PMA_buildHtmlForDb(
262 $html .= $generated_html;
264 $html .= '</tr>' . "\n";
265 } // end foreach ($databases as $key => $current)
266 unset($current, $odd_row);
268 $html .= '</tbody><tfoot><tr>' . "\n";
269 if ($is_superuser ||
$cfg['AllowUserDropDatabase']) {
270 $html .= ' <th></th>' . "\n";
272 $html .= ' <th>' . __('Total') . ': <span id="databases_count">'
273 . $databases_count . '</span></th>' . "\n";
274 foreach ($column_order as $stat_name => $stat) {
275 if (array_key_exists($stat_name, $first_database)) {
276 if ($stat['format'] === 'byte') {
277 list($value, $unit) = PMA_Util
::formatByteDown($stat['footer'], 3, 1);
278 } elseif ($stat['format'] === 'number') {
279 $value = PMA_Util
::formatNumber($stat['footer'], 0);
281 $value = htmlentities($stat['footer'], 0);
283 $html .= ' <th class="value">';
284 if (isset($stat['description_function'])) {
285 $html .= '<dfn title="'
286 . $stat['description_function']($stat['footer']) . '">';
289 if (isset($stat['description_function'])) {
292 $html .= '</th>' . "\n";
293 if ($stat['format'] === 'byte') {
294 $html .= ' <th class="unit">' . $unit . '</th>' . "\n";
299 foreach ($replication_types as $type) {
300 if ($
{"server_{$type}_status"}) {
301 $html .= ' <th></th>' . "\n";
306 $html .= ' <th></th>' . "\n";
308 $html .= '</tr>' . "\n";
309 $html .= '</tfoot>' . "\n"
311 unset($column_order, $stat_name, $stat, $databases, $table_columns);
313 if ($is_superuser ||
$cfg['AllowUserDropDatabase']) {
314 $common_url_query = PMA_generate_common_url(
316 'sort_by' => $sort_by,
317 'sort_order' => $sort_order,
318 'dbstats' => $dbstats
321 $html .= '<img class="selectallarrow" src="'
322 . $pmaThemeImage . 'arrow_' . $text_dir . '.png"'
323 . ' width="38" height="22" alt="' . __('With selected:') . '" />' . "\n"
324 . '<input type="checkbox" id="dbStatsForm_checkall" class="checkall_box" '
325 . 'title="' . __('Check All') . '" /> '
326 . '<label for="dbStatsForm_checkall">' . __('Check All') . '</label> '
327 . '<i style="margin-left: 2em">' . __('With selected:') . '</i>' . "\n";
328 $html .= PMA_Util
::getButtonOrImage(
330 'mult_submit' . ' ajax',
332 __('Drop'), 'b_deltbl.png'
336 if (empty($dbstats)) {
337 $html .= '<ul><li id="li_switch_dbstats"><strong>' . "\n";
338 $html .= '<a href="server_databases.php?' . $url_query . '&dbstats=1"'
339 . ' title="' . __('Enable Statistics') . '">' . "\n"
340 . ' ' . __('Enable Statistics');
341 $html .= '</a></strong><br />' . "\n";
343 __('Note: Enabling the database statistics here might cause heavy traffic between the web server and the MySQL server.')
345 $html .= '</li>' . "\n" . '</ul>' . "\n";
350 $html .= __('No databases');
352 unset($databases_count);