phpmyadmin/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 global $db, $table,  $clause_is_unique, $from_prefix, $goto,
  42        $mult_btn, $original_sql_query, $query_type, $reload,
  43        $selected, $selected_fld, $selected_recent_table, $sql_query,
  44        $submit_mult, $table_type, $to_prefix, $url_query, $pmaThemeImage;
  45
  46 /**
  47  * Prepares the work and runs some other scripts if required
  48  */
  49 if (! empty($submit_mult)
  50     && $submit_mult != __('With selected:')
  51     && (! empty($selected_db)
  52     || ! empty($_POST['selected_tbl'])
  53     || ! empty($selected_fld)
  54     || ! empty($_REQUEST['rows_to_delete']))
  55 ) {
  56     define('PMA_SUBMIT_MULT', 1);
  57     if (isset($selected_db) && !empty($selected_db)) {
  58         // coming from server database view - do something with
  59         // selected databases
  60         $selected     = $selected_db;
  61         $what         = 'drop_db';
  62     } elseif (! empty($_POST['selected_tbl'])) {
  63         // coming from database structure view - do something with
  64         // selected tables
  65         $selected = $_POST['selected_tbl'];
  66         switch ($submit_mult) {
  67         case 'add_prefix_tbl':
  68         case 'replace_prefix_tbl':
  69         case 'copy_tbl_change_prefix':
  70         case 'drop_db':
  71         case 'drop_tbl':
  72         case 'empty_tbl':
  73             $what = $submit_mult;
  74             break;
  75         case 'check_tbl':
  76         case 'optimize_tbl':
  77         case 'repair_tbl':
  78         case 'analyze_tbl':
  79         case 'checksum_tbl':
  80             $query_type = $submit_mult;
  81             unset($submit_mult);
  82             $mult_btn   = __('Yes');
  83             break;
  84         case 'export':
  85             unset($submit_mult);
  86             include 'db_export.php';
  87             exit;
  88             break;
  89         case 'show_create':
  90             $show_create = PMA\Template::get('database/structure/show_create')
  91                 ->render(
  92                     array(
  93                         'db'         => $GLOBALS['db'],
  94                         'db_objects' => $selected,
  95                     )
  96                 );
  97             // Send response to client.
  98             $response = PMA_Response::getInstance();
  99             $response->addJSON('message', $show_create);
 100             exit;
 101         case 'sync_unique_columns_central_list':
 102             include_once 'libraries/central_columns.lib.php';
 103             $centralColsError = PMA_syncUniqueColumns($selected);
 104             break;
 105         case 'delete_unique_columns_central_list':
 106             include_once 'libraries/central_columns.lib.php';
 107             $centralColsError = PMA_deleteColumnsFromList($selected);
 108             break;
 109         case 'make_consistent_with_central_list':
 110             include_once 'libraries/central_columns.lib.php';
 111             $centralColsError = PMA_makeConsistentWithList(
 112                 $GLOBALS['db'],
 113                 $selected
 114             );
 115             break;
 116         } // end switch
 117     } elseif (isset($selected_fld) && !empty($selected_fld)) {
 118         // coming from table structure view - do something with
 119         // selected columns
 120         // handled in StructrueController
 121     } else {
 122         // coming from browsing - do something with selected rows
 123         $what = 'row_delete';
 124         $selected = $_REQUEST['rows_to_delete'];
 125     }
 126 } // end if
 127
 128 if (empty($db)) {
 129     $db = '';
 130 }
 131 if (empty($table)) {
 132     $table = '';
 133 }
 134 $views = $GLOBALS['dbi']->getVirtualTables($db);
 135
 136 /**
 137  * Displays the confirmation form if required
 138  */
 139 if (!empty($submit_mult) && !empty($what)) {
 140     unset($message);
 141
 142     /** @var PMA_String $pmaString */
 143     $pmaString = $GLOBALS['PMA_String'];
 144     if (/*overload*/mb_strlen($table)) {
 145         include './libraries/tbl_common.inc.php';
 146         $url_query .= '&amp;goto=tbl_sql.php&amp;back=tbl_sql.php';
 147         include './libraries/tbl_info.inc.php';
 148     } elseif (/*overload*/mb_strlen($db)) {
 149         include './libraries/db_common.inc.php';
 150
 151         list(
 152             $tables,
 153             $num_tables,
 154             $total_num_tables,
 155             $sub_part,
 156             $is_show_stats,
 157             $db_is_system_schema,
 158             $tooltip_truename,
 159             $tooltip_aliasname,
 160             $pos
 161         ) = PMA_Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');
 162
 163     } else {
 164         include_once './libraries/server_common.inc.php';
 165     }
 166
 167     // Builds the query
 168     list($full_query, $reload, $full_query_views)
 169         = PMA_getQueryFromSelected(
 170             $what, $table, $selected, $views
 171         );
 172
 173     // Displays the confirmation form
 174     $_url_params = PMA_getUrlParams(
 175         $what, $reload, $action, $db, $table, $selected, $views,
 176         isset($original_sql_query)? $original_sql_query : null,
 177         isset($original_url_query)? $original_url_query : null
 178     );
 179
 180     $response = PMA_Response::getInstance();
 181
 182     if ($what == 'replace_prefix_tbl' || $what == 'copy_tbl_change_prefix') {
 183         $response->addHTML(
 184             PMA_getHtmlForReplacePrefixTable($what, $action, $_url_params)
 185         );
 186     } elseif ($what == 'add_prefix_tbl') {
 187         $response->addHTML(PMA_getHtmlForAddPrefixTable($action, $_url_params));
 188     } else {
 189         $response->addHTML(
 190             PMA_getHtmlForOtherActions($what, $action, $_url_params, $full_query)
 191         );
 192     }
 193     exit;
 194
 195 } elseif (! empty($mult_btn) && $mult_btn == __('Yes')) {
 196     /**
 197      * Executes the query - dropping rows, columns/fields, tables or dbs
 198      */
 199     if ($query_type == 'drop_db'
 200         || $query_type == 'drop_tbl'
 201         || $query_type == 'drop_fld'
 202     ) {
 203         include_once './libraries/relation_cleanup.lib.php';
 204     }
 205
 206     if ($query_type == 'primary_fld') {
 207         // Gets table primary key
 208         $GLOBALS['dbi']->selectDb($db);
 209         $result = $GLOBALS['dbi']->query(
 210             'SHOW KEYS FROM ' . PMA_Util::backquote($table) . ';'
 211         );
 212         $primary = '';
 213         while ($row = $GLOBALS['dbi']->fetchAssoc($result)) {
 214             // Backups the list of primary keys
 215             if ($row['Key_name'] == 'PRIMARY') {
 216                 $primary .= $row['Column_name'] . ', ';
 217             }
 218         } // end while
 219         $GLOBALS['dbi']->freeResult($result);
 220     }
 221
 222     if ($query_type == 'drop_tbl'
 223         || $query_type == 'empty_tbl'
 224         || $query_type == 'row_delete'
 225     ) {
 226         $default_fk_check_value = PMA_Util::handleDisableFKCheckInit();
 227     }
 228
 229     list(
 230         $result, $rebuild_database_list, $reload_ret,
 231         $run_parts, $use_sql, $sql_query, $sql_query_views
 232     ) = PMA_getQueryStrFromSelected(
 233         $query_type, $selected, $db, $table, $views,
 234         isset($primary) ? $primary : null,
 235         isset($from_prefix) ? $from_prefix : null,
 236         isset($to_prefix) ? $to_prefix : null
 237     );
 238     //update the existed variable
 239     if (isset($reload_ret)) {
 240         $reload = $reload_ret;
 241     }
 242
 243     if ($query_type == 'drop_tbl') {
 244         if (!empty($sql_query)) {
 245             $sql_query .= ';';
 246         } elseif (!empty($sql_query_views)) {
 247             $sql_query = $sql_query_views . ';';
 248             unset($sql_query_views);
 249         }
 250     }
 251
 252     if ($use_sql) {
 253
 254         /**
 255          * Parse and analyze the query
 256          */
 257         include_once 'libraries/parse_analyze.inc.php';
 258
 259         PMA_executeQueryAndSendQueryResponse(
 260             $analyzed_sql_results, // analyzed_sql_results
 261             false, // is_gotofile
 262             $db, // db
 263             $table, // table
 264             null, // find_real_end
 265             null, // sql_query_for_bookmark
 266             null, // extra_data
 267             null, // message_to_show
 268             null, // message
 269             null, // sql_data
 270             $goto, // goto
 271             $pmaThemeImage, // pmaThemeImage
 272             null, // disp_query
 273             null, // disp_message
 274             $query_type, // query_type
 275             $sql_query, // sql_query
 276             $selected, // selectedTables
 277             null // complete_query
 278         );
 279     } elseif (!$run_parts) {
 280         $GLOBALS['dbi']->selectDb($db);
 281         $result = $GLOBALS['dbi']->tryQuery($sql_query);
 282         if ($result && !empty($sql_query_views)) {
 283             $sql_query .= ' ' . $sql_query_views . ';';
 284             $result = $GLOBALS['dbi']->tryQuery($sql_query_views);
 285             unset($sql_query_views);
 286         }
 287
 288         if (! $result) {
 289             $message = PMA_Message::error($GLOBALS['dbi']->getError());
 290         }
 291     }
 292     if ($query_type == 'drop_tbl'
 293         || $query_type == 'empty_tbl'
 294         || $query_type == 'row_delete'
 295     ) {
 296         PMA_Util::handleDisableFKCheckCleanup($default_fk_check_value);
 297     }
 298     if ($rebuild_database_list) {
 299         // avoid a problem with the database list navigator
 300         // when dropping a db from server_databases
 301         $GLOBALS['pma']->databases->build();
 302     }
 303 } else {
 304     if (isset($submit_mult)
 305         && ($submit_mult == 'sync_unique_columns_central_list'
 306         || $submit_mult == 'delete_unique_columns_central_list'
 307         || $submit_mult == 'add_to_central_columns'
 308         || $submit_mult == 'remove_from_central_columns'
 309         || $submit_mult == 'make_consistent_with_central_list')
 310     ) {
 311         if (isset($centralColsError) && $centralColsError !== true) {
 312             $message = $centralColsError;
 313         } else {
 314             $message = PMA_Message::success(__('Success!'));
 315         }
 316     } else {
 317         $message = PMA_Message::success(__('No change'));
 318     }
 319 }