libraries/mult_submits.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package PhpMyAdmin
   6  */
   7 if (! defined('PHPMYADMIN')) {
   8     exit;
   9 }
  10
  11 require_once 'libraries/transformations.lib.php';
  12
  13 $request_params = array(
  14     'clause_is_unique',
  15     'from_prefix',
  16     'goto',
  17     'mult_btn',
  18     'original_sql_query',
  19     'query_type',
  20     'reload',
  21     'rows_to_delete',
  22     'selected',
  23     'selected_fld',
  24     'selected_recent_table',
  25     'sql_query',
  26     'submit_mult',
  27     'table_type',
  28     'to_prefix',
  29     'url_query'
  30 );
  31
  32 foreach ($request_params as $one_request_param) {
  33     if (isset($_REQUEST[$one_request_param])) {
  34         $GLOBALS[$one_request_param] = $_REQUEST[$one_request_param];
  35     }
  36 }
  37
  38 /**
  39  * Prepares the work and runs some other scripts if required
  40  */
  41 if (! empty($submit_mult)
  42     && $submit_mult != __('With selected:')
  43     && (! empty($selected_db) || ! empty($selected_tbl) || ! empty($selected_fld) || ! empty($rows_to_delete))
  44 ) {
  45     define('PMA_SUBMIT_MULT', 1);
  46     if (isset($selected_db) && !empty($selected_db)) {
  47         // coming from server database view - do something with selected databases
  48         $selected     = $selected_db;
  49         $what         = 'drop_db';
  50     } elseif (isset($selected_tbl) && !empty($selected_tbl)) {
  51         // coming from database structure view - do something with selected tables
  52         if ($submit_mult == 'print') {
  53             include './tbl_printview.php';
  54         } else {
  55             $selected = $selected_tbl;
  56             switch ($submit_mult) {
  57             case 'add_prefix_tbl':
  58             case 'replace_prefix_tbl':
  59             case 'copy_tbl_change_prefix':
  60             case 'drop_db':
  61             case 'drop_tbl':
  62             case 'empty_tbl':
  63                 $what = $submit_mult;
  64                 break;
  65             case 'check_tbl':
  66             case 'optimize_tbl':
  67             case 'repair_tbl':
  68             case 'analyze_tbl':
  69                 $query_type = $submit_mult;
  70                 unset($submit_mult);
  71                 $mult_btn   = __('Yes');
  72                 break;
  73             case 'export':
  74                 unset($submit_mult);
  75                 include 'db_export.php';
  76                 exit;
  77                 break;
  78             } // end switch
  79         }
  80     } elseif (isset($selected_fld) && !empty($selected_fld)) {
  81         // coming from table structure view - do something with selected columns/fileds
  82         $selected     = $selected_fld;
  83         switch ($submit_mult) {
  84         case 'drop':
  85             $what     = 'drop_fld';
  86             break;
  87         case 'primary':
  88             // Gets table primary key
  89             PMA_DBI_select_db($db);
  90             $result      = PMA_DBI_query('SHOW KEYS FROM ' . PMA_Util::backquote($table) . ';');
  91             $primary     = '';
  92             while ($row = PMA_DBI_fetch_assoc($result)) {
  93                 // Backups the list of primary keys
  94                 if ($row['Key_name'] == 'PRIMARY') {
  95                     $primary .= $row['Column_name'] . ', ';
  96                 }
  97             } // end while
  98             PMA_DBI_free_result($result);
  99             if (empty($primary)) {
 100                 // no primary key, so we can safely create new
 101                 unset($submit_mult);
 102                 $query_type = 'primary_fld';
 103                 $mult_btn   = __('Yes');
 104             } else {
 105                 // primary key exists, so lets as user
 106                 $what = 'primary_fld';
 107             }
 108             break;
 109         case 'index':
 110             unset($submit_mult);
 111             $query_type = 'index_fld';
 112             $mult_btn   = __('Yes');
 113             break;
 114         case 'unique':
 115             unset($submit_mult);
 116             $query_type = 'unique_fld';
 117             $mult_btn   = __('Yes');
 118             break;
 119         case 'spatial':
 120             unset($submit_mult);
 121             $query_type = 'spatial_fld';
 122             $mult_btn   = __('Yes');
 123             break;
 124         case 'ftext':
 125             unset($submit_mult);
 126             $query_type = 'fulltext_fld';
 127             $mult_btn   = __('Yes');
 128             break;
 129         case 'change':
 130             PMA_displayHtmlForColumnChange($db, $table, $selected, $action);
 131             // execution stops here but PMA_Response correctly finishes
 132             // the rendering
 133             exit;
 134         case 'browse':
 135             // this should already be handled by tbl_structure.php
 136         }
 137     } else {
 138         // coming from browsing - do something with selected rows
 139         $what = 'row_delete';
 140         $selected = $rows_to_delete;
 141     }
 142 } // end if
 143
 144 $views = PMA_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     $full_query     = '';
 165     if ($what == 'drop_tbl') {
 166         $full_query_views = '';
 167     }
 168     $selected_cnt   = count($selected);
 169     $i = 0;
 170     foreach ($selected AS $idx => $sval) {
 171         switch ($what) {
 172         case 'row_delete':
 173             $full_query .= 'DELETE FROM ' . PMA_Util::backquote($db) . '.' . PMA_Util::backquote($table)
 174                 . ' WHERE ' . urldecode($sval) . ' LIMIT 1'
 175                 . ';<br />';
 176             break;
 177         case 'drop_db':
 178             $full_query .= 'DROP DATABASE '
 179                 . PMA_Util::backquote(htmlspecialchars($sval))
 180                 . ';<br />';
 181             $reload = 1;
 182             break;
 183
 184         case 'drop_tbl':
 185             $current = $sval;
 186             if (!empty($views) && in_array($current, $views)) {
 187                 $full_query_views .= (empty($full_query_views) ? 'DROP VIEW ' : ', ')
 188                     . PMA_Util::backquote(htmlspecialchars($current));
 189             } else {
 190                 $full_query .= (empty($full_query) ? 'DROP TABLE ' : ', ')
 191                     . PMA_Util::backquote(htmlspecialchars($current));
 192             }
 193             break;
 194
 195         case 'empty_tbl':
 196             $full_query .= 'TRUNCATE ';
 197             $full_query .= PMA_Util::backquote(htmlspecialchars($sval))
 198                         . ';<br />';
 199             break;
 200
 201         case 'primary_fld':
 202             if ($full_query == '') {
 203                 $full_query .= 'ALTER TABLE '
 204                     . PMA_Util::backquote(htmlspecialchars($table))
 205                     . '<br />&nbsp;&nbsp;DROP PRIMARY KEY,'
 206                     . '<br />&nbsp;&nbsp; ADD PRIMARY KEY('
 207                     . '<br />&nbsp;&nbsp;&nbsp;&nbsp; '
 208                     . PMA_Util::backquote(htmlspecialchars($sval))
 209                     . ',';
 210             } else {
 211                 $full_query .= '<br />&nbsp;&nbsp;&nbsp;&nbsp; '
 212                     . PMA_Util::backquote(htmlspecialchars($sval))
 213                     . ',';
 214             }
 215             if ($i == $selected_cnt-1) {
 216                 $full_query = preg_replace('@,$@', ');<br />', $full_query);
 217             }
 218             break;
 219
 220         case 'drop_fld':
 221             if ($full_query == '') {
 222                 $full_query .= 'ALTER TABLE '
 223                     . PMA_Util::backquote(htmlspecialchars($table));
 224             }
 225             $full_query .= '<br />&nbsp;&nbsp;DROP '
 226                 . PMA_Util::backquote(htmlspecialchars($sval))
 227                 . ',';
 228             if ($i == $selected_cnt - 1) {
 229                 $full_query = preg_replace('@,$@', ';<br />', $full_query);
 230             }
 231             break;
 232         } // end switch
 233         $i++;
 234     }
 235     if ($what == 'drop_tbl') {
 236         if (!empty($full_query)) {
 237             $full_query .= ';<br />' . "\n";
 238         }
 239         if (!empty($full_query_views)) {
 240             $full_query .= $full_query_views . ';<br />' . "\n";
 241         }
 242         unset($full_query_views);
 243     }
 244
 245     // Displays the confirmation form
 246     $_url_params = array(
 247         'query_type' => $what,
 248         'reload' => (! empty($reload) ? 1 : 0),
 249     );
 250     if (strpos(' ' . $action, 'db_') == 1) {
 251         $_url_params['db']= $db;
 252     } elseif (strpos(' ' . $action, 'tbl_') == 1 || $what == 'row_delete') {
 253         $_url_params['db']= $db;
 254         $_url_params['table']= $table;
 255     }
 256     foreach ($selected as $idx => $sval) {
 257         if ($what == 'row_delete') {
 258             $_url_params['selected'][] = 'DELETE FROM ' . PMA_Util::backquote($db) . '.' . PMA_Util::backquote($table)
 259             . ' WHERE ' . urldecode($sval) . ' LIMIT 1;';
 260         } else {
 261             $_url_params['selected'][] = $sval;
 262         }
 263     }
 264     if ($what == 'drop_tbl' && !empty($views)) {
 265         foreach ($views as $current) {
 266             $_url_params['views'][] = $current;
 267         }
 268     }
 269     if ($what == 'row_delete') {
 270         $_url_params['original_sql_query'] = $original_sql_query;
 271         if (! empty($original_url_query)) {
 272             $_url_params['original_url_query'] = $original_url_query;
 273         }
 274     }
 275     if ($what == 'replace_prefix_tbl' || $what == 'copy_tbl_change_prefix') { ?>
 276         <form action="<?php echo $action; ?>" method="post">
 277         <?php echo PMA_generate_common_hidden_inputs($_url_params); ?>
 278         <fieldset class = "input">
 279                 <legend><?php echo ($what == 'replace_prefix_tbl' ? __('Replace table prefix') : __('Copy table with prefix')) ?>:</legend>
 280                 <table>
 281                 <tr>
 282                 <td><?php echo __('From'); ?></td><td><input type="text" name="from_prefix" id="initialPrefix" /></td>
 283                 </tr>
 284                 <tr>
 285                 <td><?php echo __('To'); ?> </td><td><input type="text" name="to_prefix" id="newPrefix" /></td>
 286                 </tr>
 287                 </table>
 288         </fieldset>
 289         <fieldset class="tblFooters">
 290                 <input type="hidden" name="mult_btn" value="<?php echo __('Yes'); ?>" />
 291                 <input type="submit" value="<?php echo __('Submit'); ?>" id="buttonYes" />
 292         </fieldset>
 293         </form>
 294     <?php
 295     } elseif ($what == 'add_prefix_tbl') { ?>
 296         <form action="<?php echo $action; ?>" method="post">
 297         <?php echo PMA_generate_common_hidden_inputs($_url_params); ?>
 298         <fieldset class = "input">
 299                 <legend><?php echo __('Add table prefix') ?>:</legend>
 300                 <table>
 301                 <tr>
 302                 <td><?php echo __('Add prefix'); ?></td>     <td><input type="text" name="add_prefix" id="txtPrefix" /></td>
 303                 </tr>
 304                 </table>
 305         </fieldset>
 306         <fieldset class="tblFooters">
 307                 <input type="hidden" name="mult_btn" value="<?php echo __('Yes'); ?>" />
 308                 <input type="submit" value="<?php echo __('Submit'); ?>" id="buttonYes" />
 309         </fieldset>
 310         </form>
 311     <?php
 312     } else { ?>
 313         <fieldset class="confirmation">
 314             <legend><?php
 315                 if ($what == 'drop_db') {
 316                     echo  __('You are about to DESTROY a complete database!') . '&nbsp;';
 317                 }
 318                 echo __('Do you really want to execute the following query?');
 319             ?>:</legend>
 320             <code><?php echo $full_query; ?></code>
 321         </fieldset>
 322         <fieldset class="tblFooters">
 323             <form action="<?php echo $action; ?>" method="post">
 324             <?php
 325             echo PMA_generate_common_hidden_inputs($_url_params);
 326             // Display option to disable foreign key checks while dropping tables
 327             if ($what == 'drop_tbl') { ?>
 328                 <div id="foreignkeychk">
 329                 <span class="fkc_switch"><?php echo __('Foreign key check:'); ?></span>
 330                 <span class="checkbox"><input type="checkbox" name="fk_check" value="1" id="fkc_checkbox"<?php
 331                 $default_fk_check_value = (PMA_DBI_fetch_value('SHOW VARIABLES LIKE \'foreign_key_checks\';', 0, 1) == 'ON') ? 1 : 0;
 332                 echo ($default_fk_check_value) ? ' checked="checked"' : '' ?>/></span>
 333                 <span id="fkc_status" class="fkc_switch"><?php echo ($default_fk_check_value) ? __('(Enabled)') : __('(Disabled)'); ?></span>
 334                 </div><?php
 335             } ?>
 336             <input type="hidden" name="mult_btn" value="<?php echo __('Yes'); ?>" />
 337             <input type="submit" value="<?php echo __('Yes'); ?>" id="buttonYes" />
 338             </form>
 339
 340             <form action="<?php echo $action; ?>" method="post">
 341                 <?php echo PMA_generate_common_hidden_inputs($_url_params); ?>
 342                 <input type="hidden" name="mult_btn" value="<?php echo __('No'); ?>" />
 343                 <input type="submit" value="<?php echo __('No'); ?>" id="buttonNo" />
 344             </form>
 345         </fieldset>
 346     <?php
 347     }
 348     exit;
 349
 350 } elseif (! empty($mult_btn) && $mult_btn == __('Yes')) {
 351     /**
 352      * Executes the query - dropping rows, columns/fields, tables or dbs
 353      */
 354     if ($query_type == 'drop_db' || $query_type == 'drop_tbl' || $query_type == 'drop_fld') {
 355         include_once './libraries/relation_cleanup.lib.php';
 356     }
 357
 358     $sql_query      = '';
 359     if ($query_type == 'drop_tbl') {
 360         $sql_query_views = '';
 361     }
 362     $selected_cnt   = count($selected);
 363     $run_parts      = false; // whether to run query after each pass
 364     $use_sql        = false; // whether to include sql.php at the end (to display results)
 365
 366     if ($query_type == 'primary_fld') {
 367         // Gets table primary key
 368         PMA_DBI_select_db($db);
 369         $result      = PMA_DBI_query('SHOW KEYS FROM ' . PMA_Util::backquote($table) . ';');
 370         $primary     = '';
 371         while ($row = PMA_DBI_fetch_assoc($result)) {
 372             // Backups the list of primary keys
 373             if ($row['Key_name'] == 'PRIMARY') {
 374                 $primary .= $row['Column_name'] . ', ';
 375             }
 376         } // end while
 377         PMA_DBI_free_result($result);
 378     }
 379
 380     $rebuild_database_list = false;
 381
 382     for ($i = 0; $i < $selected_cnt; $i++) {
 383         switch ($query_type) {
 384         case 'row_delete':
 385             $a_query = $selected[$i];
 386             $run_parts = true;
 387             break;
 388
 389         case 'drop_db':
 390             PMA_relationsCleanupDatabase($selected[$i]);
 391             $a_query   = 'DROP DATABASE '
 392                        . PMA_Util::backquote($selected[$i]);
 393             $reload    = 1;
 394             $run_parts = true;
 395             $rebuild_database_list = true;
 396             break;
 397
 398         case 'drop_tbl':
 399             PMA_relationsCleanupTable($db, $selected[$i]);
 400             $current = $selected[$i];
 401             if (!empty($views) && in_array($current, $views)) {
 402                 $sql_query_views .= (empty($sql_query_views) ? 'DROP VIEW ' : ', ')
 403                           . PMA_Util::backquote($current);
 404             } else {
 405                 $sql_query .= (empty($sql_query) ? 'DROP TABLE ' : ', ')
 406                            . PMA_Util::backquote($current);
 407             }
 408             $reload    = 1;
 409             break;
 410
 411         case 'check_tbl':
 412             $sql_query .= (empty($sql_query) ? 'CHECK TABLE ' : ', ')
 413                        . PMA_Util::backquote($selected[$i]);
 414             $use_sql    = true;
 415             break;
 416
 417         case 'optimize_tbl':
 418             $sql_query .= (empty($sql_query) ? 'OPTIMIZE TABLE ' : ', ')
 419                        . PMA_Util::backquote($selected[$i]);
 420             $use_sql    = true;
 421             break;
 422
 423         case 'analyze_tbl':
 424             $sql_query .= (empty($sql_query) ? 'ANALYZE TABLE ' : ', ')
 425                        . PMA_Util::backquote($selected[$i]);
 426             $use_sql    = true;
 427             break;
 428
 429         case 'repair_tbl':
 430             $sql_query .= (empty($sql_query) ? 'REPAIR TABLE ' : ', ')
 431                        . PMA_Util::backquote($selected[$i]);
 432             $use_sql    = true;
 433             break;
 434
 435         case 'empty_tbl':
 436             $a_query = 'TRUNCATE ';
 437             $a_query .= PMA_Util::backquote($selected[$i]);
 438             $run_parts = true;
 439             break;
 440
 441         case 'drop_fld':
 442             PMA_relationsCleanupColumn($db, $table, $selected[$i]);
 443             $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_Util::backquote($table) : ',')
 444                        . ' DROP ' . PMA_Util::backquote($selected[$i])
 445                        . (($i == $selected_cnt-1) ? ';' : '');
 446             break;
 447
 448         case 'primary_fld':
 449             $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_Util::backquote($table) . (empty($primary) ? '' : ' DROP PRIMARY KEY,') . ' ADD PRIMARY KEY( ' : ', ')
 450                        . PMA_Util::backquote($selected[$i])
 451                        . (($i == $selected_cnt-1) ? ');' : '');
 452             break;
 453
 454         case 'index_fld':
 455             $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_Util::backquote($table) . ' ADD INDEX( ' : ', ')
 456                        . PMA_Util::backquote($selected[$i])
 457                        . (($i == $selected_cnt-1) ? ');' : '');
 458             break;
 459
 460         case 'unique_fld':
 461             $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_Util::backquote($table) . ' ADD UNIQUE( ' : ', ')
 462                        . PMA_Util::backquote($selected[$i])
 463                        . (($i == $selected_cnt-1) ? ');' : '');
 464             break;
 465
 466         case 'spatial_fld':
 467             $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_Util::backquote($table) . ' ADD SPATIAL( ' : ', ')
 468                        . PMA_Util::backquote($selected[$i])
 469                        . (($i == $selected_cnt-1) ? ');' : '');
 470             break;
 471
 472         case 'fulltext_fld':
 473             $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_Util::backquote($table) . ' ADD FULLTEXT( ' : ', ')
 474                        . PMA_Util::backquote($selected[$i])
 475                        . (($i == $selected_cnt-1) ? ');' : '');
 476             break;
 477
 478         case 'add_prefix_tbl':
 479             $newtablename = $_POST['add_prefix'] . $selected[$i];
 480             $a_query = 'ALTER TABLE ' . PMA_Util::backquote($selected[$i]) . ' RENAME ' . PMA_Util::backquote($newtablename); // ADD PREFIX TO TABLE NAME
 481             $run_parts = true;
 482             break;
 483
 484         case 'replace_prefix_tbl':
 485             $current = $selected[$i];
 486             if (substr($current, 0, strlen($from_prefix)) == $from_prefix) {
 487                 $newtablename = $to_prefix . substr($current, strlen($from_prefix));
 488             } else {
 489                 $newtablename = $current;
 490             }
 491             $a_query = 'ALTER TABLE '
 492                 . PMA_Util::backquote($selected[$i])
 493                 . ' RENAME '
 494                 . PMA_Util::backquote($newtablename) ; // CHANGE PREFIX PATTERN
 495             $run_parts = true;
 496             break;
 497
 498         case 'copy_tbl_change_prefix':
 499             $current = $selected[$i];
 500             if (substr($current, 0, strlen($from_prefix)) == $from_prefix) {
 501                 $newtablename = $to_prefix . substr($current, strlen($from_prefix));
 502             } else {
 503                 $newtablename = $current;
 504             }
 505             $newtablename = $to_prefix . substr($current, strlen($from_prefix));
 506             $a_query = 'CREATE TABLE '
 507                 . PMA_Util::backquote($newtablename)
 508                 . ' SELECT * FROM '
 509                 . PMA_Util::backquote($selected[$i]) ; // COPY TABLE AND CHANGE PREFIX PATTERN
 510             $run_parts = true;
 511             break;
 512
 513         } // end switch
 514
 515         // All "DROP TABLE", "DROP FIELD", "OPTIMIZE TABLE" and "REPAIR TABLE"
 516         // statements will be run at once below
 517         if ($run_parts) {
 518             $sql_query .= $a_query . ';' . "\n";
 519             if ($query_type != 'drop_db') {
 520                 PMA_DBI_select_db($db);
 521             }
 522             $result = PMA_DBI_query($a_query);
 523
 524             if ($query_type == 'drop_db') {
 525                 PMA_clearTransformations($selected[$i]);
 526             } elseif ($query_type == 'drop_tbl') {
 527                 PMA_clearTransformations($db, $selected[$i]);
 528             } else if ($query_type == 'drop_fld') {
 529                 PMA_clearTransformations($db, $table, $selected[$i]);
 530             }
 531
 532         } // end if
 533     } // end for
 534
 535     if ($query_type == 'drop_tbl') {
 536         $default_fk_check_value = (PMA_DBI_fetch_value('SHOW VARIABLES LIKE \'foreign_key_checks\';', 0, 1) == 'ON') ? 1 : 0;
 537         if (!empty($sql_query)) {
 538             $sql_query .= ';';
 539         } elseif (!empty($sql_query_views)) {
 540             $sql_query = $sql_query_views . ';';
 541             unset($sql_query_views);
 542         }
 543     }
 544
 545     if ($use_sql) {
 546         include './sql.php';
 547     } elseif (!$run_parts) {
 548         PMA_DBI_select_db($db);
 549         // for disabling foreign key checks while dropping tables
 550         if (! isset($_REQUEST['fk_check']) && $query_type == 'drop_tbl') {
 551             PMA_DBI_query('SET FOREIGN_KEY_CHECKS = 0;');
 552         }
 553         $result = PMA_DBI_try_query($sql_query);
 554         if (! isset($_REQUEST['fk_check'])
 555             && $query_type == 'drop_tbl'
 556             && $default_fk_check_value
 557         ) {
 558             PMA_DBI_query('SET FOREIGN_KEY_CHECKS = 1;');
 559         }
 560         if ($result && !empty($sql_query_views)) {
 561             $sql_query .= ' ' . $sql_query_views . ';';
 562             $result = PMA_DBI_try_query($sql_query_views);
 563             unset($sql_query_views);
 564         }
 565
 566         if (! $result) {
 567             $message = PMA_Message::error(PMA_DBI_getError());
 568         }
 569     }
 570     if ($rebuild_database_list) {
 571         // avoid a problem with the database list navigator
 572         // when dropping a db from server_databases
 573         $GLOBALS['pma']->databases->build();
 574     }
 575 } else {
 576     $message = PMA_Message::success(__('No change'));
 577 }
 578 ?>