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($GLOBALS['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(
 103                     $GLOBALS['db'],
 104                     $selected
 105                 );
 106                 break;
 107             } // end switch
 108         }
 109     } elseif (isset($selected_fld) && !empty($selected_fld)) {
 110         // coming from table structure view - do something with
 111         // selected columns
 112         $selected = $selected_fld;
 113         list(
 114                 $what_ret, $query_type_ret, $is_unset_submit_mult, $mult_btn_ret,
 115                 $centralColsError
 116                 )
 117                     = PMA_getDataForSubmitMult(
 118                         $submit_mult, $GLOBALS['db'], $table,
 119                         $selected, $action
 120                     );
 121         //update the existing variables
 122         if (isset($what_ret)) {
 123             $what = $what_ret;
 124         }
 125         if (isset($query_type_ret)) {
 126             $query_type = $query_type_ret;
 127         }
 128         if ($is_unset_submit_mult) {
 129             unset($submit_mult);
 130         }
 131         if (isset($mult_btn_ret)) {
 132             $mult_btn = $mult_btn_ret;
 133         }
 134     } else {
 135         // coming from browsing - do something with selected rows
 136         $what = 'row_delete';
 137         $selected = $_REQUEST['rows_to_delete'];
 138     }
 139 } // end if
 140
 141 if (empty($db)) {
 142     $db = '';
 143 }
 144 if (empty($table)) {
 145     $table = '';
 146 }
 147 $views = $GLOBALS['dbi']->getVirtualTables($db);
 148
 149 /**
 150  * Displays the confirmation form if required
 151  */
 152 if (!empty($submit_mult) && !empty($what)) {
 153     unset($message);
 154
 155     /** @var PMA_String $pmaString */
 156     $pmaString = $GLOBALS['PMA_String'];
 157     if (/*overload*/mb_strlen($table)) {
 158         include './libraries/tbl_common.inc.php';
 159         $url_query .= '&amp;goto=tbl_sql.php&amp;back=tbl_sql.php';
 160         include './libraries/tbl_info.inc.php';
 161     } elseif (/*overload*/mb_strlen($db)) {
 162         include './libraries/db_common.inc.php';
 163         include './libraries/db_info.inc.php';
 164     } else {
 165         include_once './libraries/server_common.inc.php';
 166     }
 167
 168     // Builds the query
 169     list($full_query, $reload, $full_query_views)
 170         = PMA_getQueryFromSelected(
 171             $what, $db, $table, $selected, $views
 172         );
 173
 174     // Displays the confirmation form
 175     $_url_params = PMA_getUrlParams(
 176         $what, $reload, $action, $db, $table, $selected, $views,
 177         isset($original_sql_query)? $original_sql_query : null,
 178         isset($original_url_query)? $original_url_query : null
 179     );
 180
 181     if ($what == 'replace_prefix_tbl' || $what == 'copy_tbl_change_prefix') {
 182         echo PMA_getHtmlForReplacePrefixTable($what, $action, $_url_params);
 183     } elseif ($what == 'add_prefix_tbl') {
 184         echo PMA_getHtmlForAddPrefixTable($action, $_url_params);
 185     } else {
 186         echo PMA_getHtmlForOtherActions($what, $action, $_url_params, $full_query);
 187     }
 188     exit;
 189
 190 } elseif (! empty($mult_btn) && $mult_btn == __('Yes')) {
 191     /**
 192      * Executes the query - dropping rows, columns/fields, tables or dbs
 193      */
 194     if ($query_type == 'drop_db'
 195         || $query_type == 'drop_tbl'
 196         || $query_type == 'drop_fld'
 197     ) {
 198         include_once './libraries/relation_cleanup.lib.php';
 199     }
 200
 201     if ($query_type == 'primary_fld') {
 202         // Gets table primary key
 203         $GLOBALS['dbi']->selectDb($db);
 204         $result = $GLOBALS['dbi']->query(
 205             'SHOW KEYS FROM ' . PMA_Util::backquote($table) . ';'
 206         );
 207         $primary = '';
 208         while ($row = $GLOBALS['dbi']->fetchAssoc($result)) {
 209             // Backups the list of primary keys
 210             if ($row['Key_name'] == 'PRIMARY') {
 211                 $primary .= $row['Column_name'] . ', ';
 212             }
 213         } // end while
 214         $GLOBALS['dbi']->freeResult($result);
 215     }
 216
 217     if (! isset($_REQUEST['fk_check'])
 218         && ($query_type == 'drop_tbl'
 219         || $query_type == 'empty_tbl'
 220         || $query_type == 'row_delete')
 221     ) {
 222         $default_fk_check_value = $GLOBALS['dbi']->fetchValue(
 223             'SHOW VARIABLES LIKE \'foreign_key_checks\';', 0, 1
 224         ) == 'ON';
 225
 226         // for disabling foreign key checks while dropping tables
 227         $GLOBALS['dbi']->query('SET FOREIGN_KEY_CHECKS = 0;');
 228     }
 229
 230     list(
 231         $result, $rebuild_database_list, $reload_ret,
 232         $run_parts, $use_sql, $sql_query, $sql_query_views
 233     ) = PMA_getQueryStrFromSelected(
 234         $query_type, $selected, $db, $table, $views,
 235         isset($primary) ? $primary : null,
 236         isset($from_prefix) ? $from_prefix : null,
 237         isset($to_prefix) ? $to_prefix : null
 238     );
 239     //update the existed variable
 240     if (isset($reload_ret)) {
 241         $reload = $reload_ret;
 242     }
 243
 244     if ($query_type == 'drop_tbl') {
 245         if (!empty($sql_query)) {
 246             $sql_query .= ';';
 247         } elseif (!empty($sql_query_views)) {
 248             $sql_query = $sql_query_views . ';';
 249             unset($sql_query_views);
 250         }
 251     }
 252
 253     if ($use_sql) {
 254         /**
 255          * Parse and analyze the query
 256          */
 257         include_once 'libraries/parse_analyze.inc.php';
 258
 259         PMA_executeQueryAndSendQueryResponse(
 260             $analyzed_sql_results, false, $db, $table, null, null, null,
 261             false, null, null, null, $goto, $pmaThemeImage, null, null,
 262             $query_type, $sql_query, $selected, null
 263         );
 264     } elseif (!$run_parts) {
 265         $GLOBALS['dbi']->selectDb($db);
 266         $result = $GLOBALS['dbi']->tryQuery($sql_query);
 267         if ($result && !empty($sql_query_views)) {
 268             $sql_query .= ' ' . $sql_query_views . ';';
 269             $result = $GLOBALS['dbi']->tryQuery($sql_query_views);
 270             unset($sql_query_views);
 271         }
 272
 273         if (! $result) {
 274             $message = PMA_Message::error($GLOBALS['dbi']->getError());
 275         }
 276     }
 277     if (! isset($_REQUEST['fk_check'])
 278         && ($query_type == 'drop_tbl'
 279         || $query_type == 'empty_tbl'
 280         || $query_type == 'row_delete')
 281         && $default_fk_check_value
 282     ) {
 283         $GLOBALS['dbi']->query('SET FOREIGN_KEY_CHECKS = 1;');
 284     }
 285     if ($rebuild_database_list) {
 286         // avoid a problem with the database list navigator
 287         // when dropping a db from server_databases
 288         $GLOBALS['pma']->databases->build();
 289     }
 290 } else {
 291     if (isset($submit_mult)
 292         && ($submit_mult == 'sync_unique_columns_central_list'
 293         || $submit_mult == 'delete_unique_columns_central_list'
 294         || $submit_mult == 'add_to_central_columns'
 295         || $submit_mult == 'remove_from_central_columns'
 296         || $submit_mult == 'make_consistent_with_central_list')
 297     ) {
 298         if (isset($centralColsError) && $centralColsError !== true) {
 299             $message = $centralColsError;
 300         } else {
 301             $message = PMA_Message::success(__('Success!'));
 302         }
 303     } else {
 304         $message = PMA_Message::success(__('No change'));
 305     }
 306 }
 307 ?>