libraries/mult_submits.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Helper for multi submit forms
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 require_once 'libraries/transformations.lib.php';
  13 require_once 'libraries/bookmark.lib.php';
  14 require_once 'libraries/sql.lib.php';
  15 require_once 'libraries/mult_submits.lib.php';
  16
  17 $request_params = array(
  18     'clause_is_unique',
  19     'from_prefix',
  20     'goto',
  21     'mult_btn',
  22     'original_sql_query',
  23     'query_type',
  24     'reload',
  25     'selected',
  26     'selected_fld',
  27     'selected_recent_table',
  28     'sql_query',
  29     'submit_mult',
  30     'table_type',
  31     'to_prefix',
  32     'url_query'
  33 );
  34
  35 foreach ($request_params as $one_request_param) {
  36     if (isset($_REQUEST[$one_request_param])) {
  37         $GLOBALS[$one_request_param] = $_REQUEST[$one_request_param];
  38     }
  39 }
  40
  41 /**
  42  * Prepares the work and runs some other scripts if required
  43  */
  44 if (! empty($submit_mult)
  45     && $submit_mult != __('With selected:')
  46     && (! empty($selected_db)
  47     || ! empty($_POST['selected_tbl'])
  48     || ! empty($selected_fld)
  49     || ! empty($_REQUEST['rows_to_delete']))
  50 ) {
  51     define('PMA_SUBMIT_MULT', 1);
  52     if (isset($selected_db) && !empty($selected_db)) {
  53         // coming from server database view - do something with
  54         // selected databases
  55         $selected     = $selected_db;
  56         $what         = 'drop_db';
  57     } elseif (! empty($_POST['selected_tbl'])) {
  58         // coming from database structure view - do something with
  59         // selected tables
  60         if ($submit_mult == 'print') {
  61             include './tbl_printview.php';
  62         } else {
  63             $selected = $_POST['selected_tbl'];
  64             switch ($submit_mult) {
  65             case 'add_prefix_tbl':
  66             case 'replace_prefix_tbl':
  67             case 'copy_tbl_change_prefix':
  68             case 'drop_db':
  69             case 'drop_tbl':
  70             case 'empty_tbl':
  71                 $what = $submit_mult;
  72                 break;
  73             case 'check_tbl':
  74             case 'optimize_tbl':
  75             case 'repair_tbl':
  76             case 'analyze_tbl':
  77                 $query_type = $submit_mult;
  78                 unset($submit_mult);
  79                 $mult_btn   = __('Yes');
  80                 break;
  81             case 'export':
  82                 unset($submit_mult);
  83                 include 'db_export.php';
  84                 exit;
  85                 break;
  86             case 'show_create':
  87                 $show_create = PMA_getHtmlShowCreate($db, $selected);
  88                 // Send response to client.
  89                 $response = PMA_Response::getInstance();
  90                 $response->addJSON('message', $show_create);
  91                 exit;
  92             case 'sync_unique_columns_central_list':
  93                 include_once 'libraries/central_columns.lib.php';
  94                 $centralColsError = PMA_syncUniqueColumns($selected);
  95                 break;
  96             case 'delete_unique_columns_central_list':
  97                 include_once 'libraries/central_columns.lib.php';
  98                 $centralColsError = PMA_deleteColumnsFromList($selected);
  99                 break;
 100             case 'make_consistent_with_central_list':
 101                 include_once 'libraries/central_columns.lib.php';
 102                 $centralColsError = PMA_makeConsistentWithList($db, $selected);
 103                 break;
 104             } // end switch
 105         }
 106     } elseif (isset($selected_fld) && !empty($selected_fld)) {
 107         // coming from table structure view - do something with
 108         // selected columns
 109         $selected = $selected_fld;
 110         list(
 111                 $what_ret, $query_type_ret, $is_unset_submit_mult, $mult_btn_ret,
 112                 $centralColsError
 113                 )
 114                     = PMA_getDataForSubmitMult(
 115                         $submit_mult, $db, $table,
 116                         $selected, $action
 117                     );
 118         //update the existing variables
 119         if (isset($what_ret)) {
 120             $what = $what_ret;
 121         }
 122         if (isset($query_type_ret)) {
 123             $query_type = $query_type_ret;
 124         }
 125         if ($is_unset_submit_mult) {
 126             unset($submit_mult);
 127         }
 128         if (isset($mult_btn_ret)) {
 129             $mult_btn = $mult_btn_ret;
 130         }
 131     } else {
 132         // coming from browsing - do something with selected rows
 133         $what = 'row_delete';
 134         $selected = $_REQUEST['rows_to_delete'];
 135     }
 136 } // end if
 137
 138 if (empty($db)) {
 139     $db = '';
 140 }
 141 if (empty($table)) {
 142     $table = '';
 143 }
 144 $views = $GLOBALS['dbi']->getVirtualTables($db);
 145
 146 /**
 147  * Displays the confirmation form if required
 148  */
 149 if (!empty($submit_mult) && !empty($what)) {
 150     unset($message);
 151
 152     if (strlen($table)) {
 153         include './libraries/tbl_common.inc.php';
 154         $url_query .= '&amp;goto=tbl_sql.php&amp;back=tbl_sql.php';
 155         include './libraries/tbl_info.inc.php';
 156     } elseif (strlen($db)) {
 157         include './libraries/db_common.inc.php';
 158         include './libraries/db_info.inc.php';
 159     } else {
 160         include_once './libraries/server_common.inc.php';
 161     }
 162
 163     // Builds the query
 164     list($full_query, $reload, $full_query_views)
 165         = PMA_getQueryFromSelected(
 166             $what, $db, $table, $selected, $action, $views
 167         );
 168
 169     // Displays the confirmation form
 170     $_url_params = PMA_getUrlParams(
 171         $what, $reload, $action, $db, $table, $selected, $views,
 172         isset($original_sql_query)? $original_sql_query : null,
 173         isset($original_url_query)? $original_url_query : null
 174     );
 175
 176     if ($what == 'replace_prefix_tbl' || $what == 'copy_tbl_change_prefix') {
 177         echo PMA_getHtmlForReplacePrefixTable($what, $action, $_url_params);
 178     } elseif ($what == 'add_prefix_tbl') {
 179         echo PMA_getHtmlForAddPrefixTable($action, $_url_params);
 180     } else {
 181         echo PMA_getHtmlForOtherActions($what, $action, $_url_params, $full_query);
 182     }
 183     exit;
 184
 185 } elseif (! empty($mult_btn) && $mult_btn == __('Yes')) {
 186     /**
 187      * Executes the query - dropping rows, columns/fields, tables or dbs
 188      */
 189     if ($query_type == 'drop_db'
 190         || $query_type == 'drop_tbl'
 191         || $query_type == 'drop_fld'
 192     ) {
 193         include_once './libraries/relation_cleanup.lib.php';
 194     }
 195
 196     if ($query_type == 'primary_fld') {
 197         // Gets table primary key
 198         $GLOBALS['dbi']->selectDb($db);
 199         $result = $GLOBALS['dbi']->query(
 200             'SHOW KEYS FROM ' . PMA_Util::backquote($table) . ';'
 201         );
 202         $primary = '';
 203         while ($row = $GLOBALS['dbi']->fetchAssoc($result)) {
 204             // Backups the list of primary keys
 205             if ($row['Key_name'] == 'PRIMARY') {
 206                 $primary .= $row['Column_name'] . ', ';
 207             }
 208         } // end while
 209         $GLOBALS['dbi']->freeResult($result);
 210     }
 211
 212     list(
 213         $result, $rebuild_database_list, $reload_ret,
 214         $run_parts, $use_sql, $sql_query, $sql_query_views
 215     ) = PMA_getQueryStrFromSelected(
 216         $query_type, $selected, $db, $table, $views,
 217         isset($primary) ? $primary : null,
 218         isset($from_prefix) ? $from_prefix : null,
 219         isset($to_prefix) ? $to_prefix : null
 220     );
 221     //update the existed variable
 222     if (isset($reload_ret)) {
 223         $reload = $reload_ret;
 224     }
 225
 226     if ($query_type == 'drop_tbl') {
 227         $default_fk_check_value = $GLOBALS['dbi']->fetchValue(
 228             'SHOW VARIABLES LIKE \'foreign_key_checks\';', 0, 1
 229         ) == 'ON';
 230         if (!empty($sql_query)) {
 231             $sql_query .= ';';
 232         } elseif (!empty($sql_query_views)) {
 233             $sql_query = $sql_query_views . ';';
 234             unset($sql_query_views);
 235         }
 236     }
 237
 238     if ($use_sql) {
 239         /**
 240          * Parse and analyze the query
 241          */
 242         include_once 'libraries/parse_analyze.inc.php';
 243
 244         PMA_executeQueryAndSendQueryResponse(
 245             $analyzed_sql_results, false, $db, $table, null, null, null,
 246             false, null, null, null, null, $goto, $pmaThemeImage, null, null,
 247             $query_type, $sql_query, $selected, null
 248         );
 249     } elseif (!$run_parts) {
 250         $GLOBALS['dbi']->selectDb($db);
 251         // for disabling foreign key checks while dropping tables
 252         if (! isset($_REQUEST['fk_check']) && $query_type == 'drop_tbl') {
 253             $GLOBALS['dbi']->query('SET FOREIGN_KEY_CHECKS = 0;');
 254         }
 255         $result = $GLOBALS['dbi']->tryQuery($sql_query);
 256         if (! isset($_REQUEST['fk_check'])
 257             && $query_type == 'drop_tbl'
 258             && $default_fk_check_value
 259         ) {
 260             $GLOBALS['dbi']->query('SET FOREIGN_KEY_CHECKS = 1;');
 261         }
 262         if ($result && !empty($sql_query_views)) {
 263             $sql_query .= ' ' . $sql_query_views . ';';
 264             $result = $GLOBALS['dbi']->tryQuery($sql_query_views);
 265             unset($sql_query_views);
 266         }
 267
 268         if (! $result) {
 269             $message = PMA_Message::error($GLOBALS['dbi']->getError());
 270         }
 271     }
 272     if ($rebuild_database_list) {
 273         // avoid a problem with the database list navigator
 274         // when dropping a db from server_databases
 275         $GLOBALS['pma']->databases->build();
 276     }
 277 } else {
 278     if (isset($submit_mult)
 279         && ($submit_mult == 'sync_unique_columns_central_list'
 280         || $submit_mult == 'delete_unique_columns_central_list'
 281         || $submit_mult == 'add_to_central_columns'
 282         || $submit_mult == 'remove_from_central_columns'
 283         || $submit_mult == 'make_consistent_with_central_list')
 284     ) {
 285         if (isset($centralColsError) && $centralColsError !== true) {
 286             $message = $centralColsError;
 287         } else {
 288             $message = PMA_Message::success(__('Success!'));
 289         }
 290     } else {
 291         $message = PMA_Message::success(__('No change'));
 292     }
 293 }
 294 ?>