phpmyadmin/libraries/mult_submits.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * functions for multi submit forms
   5  *
   6  * @usedby  mult_submits.inc.php
   7  *
   8  * @package PhpMyAdmin
   9  */
  10 if (! defined('PHPMYADMIN')) {
  11     exit;
  12 }
  13
  14 /**
  15  * Gets url params
  16  *
  17  * @param string $what               mult submit type
  18  * @param bool   $reload             is reload
  19  * @param string $action             action type
  20  * @param string $db                 database name
  21  * @param string $table              table name
  22  * @param array  $selected           selected rows(table,db)
  23  * @param array  $views              table views
  24  * @param string $original_sql_query original sql query
  25  * @param string $original_url_query original url query
  26  *
  27  * @return array
  28  */
  29 function PMA_getUrlParams(
  30     $what, $reload, $action, $db, $table, $selected, $views,
  31     $original_sql_query, $original_url_query
  32 ) {
  33     $_url_params = array(
  34         'query_type' => $what,
  35         'reload' => (! empty($reload) ? 1 : 0),
  36     );
  37     if (/*overload*/mb_strpos(' ' . $action, 'db_') == 1) {
  38         $_url_params['db']= $db;
  39     } elseif (/*overload*/mb_strpos(' ' . $action, 'tbl_') == 1
  40         || $what == 'row_delete'
  41     ) {
  42         $_url_params['db']= $db;
  43         $_url_params['table']= $table;
  44     }
  45     foreach ($selected as $sval) {
  46         if ($what == 'row_delete') {
  47             $_url_params['selected'][] = 'DELETE FROM '
  48                 . PMA_Util::backquote($table)
  49                 . ' WHERE ' . urldecode($sval) . ' LIMIT 1;';
  50         } else {
  51             $_url_params['selected'][] = $sval;
  52         }
  53     }
  54     if ($what == 'drop_tbl' && !empty($views)) {
  55         foreach ($views as $current) {
  56             $_url_params['views'][] = $current;
  57         }
  58     }
  59     if ($what == 'row_delete') {
  60         $_url_params['original_sql_query'] = $original_sql_query;
  61         if (! empty($original_url_query)) {
  62             $_url_params['original_url_query'] = $original_url_query;
  63         }
  64     }
  65
  66     return  $_url_params;
  67 }
  68
  69 /**
  70  * Gets query results from
  71  *
  72  * @param string $query_type  query type
  73  * @param array  $selected    selected tables
  74  * @param string $db          db name
  75  * @param string $table       table name
  76  * @param array  $views       table views
  77  * @param string $primary     table primary
  78  * @param string $from_prefix from prefix original
  79  * @param string $to_prefix   to prefix original
  80  *
  81  * @return array
  82  */
  83 function PMA_getQueryStrFromSelected(
  84     $query_type, $selected, $db, $table, $views, $primary,
  85     $from_prefix, $to_prefix
  86 ) {
  87     $rebuild_database_list = false;
  88     $reload = null;
  89     $a_query = null;
  90     $sql_query = '';
  91     $sql_query_views = null;
  92     // whether to run query after each pass
  93     $run_parts = false;
  94     // whether to execute the query at the end (to display results)
  95     $use_sql = false;
  96     $result = null;
  97
  98     if ($query_type == 'drop_tbl') {
  99         $sql_query_views = '';
 100     }
 101
 102     $selected_cnt   = count($selected);
 103     $deletes = false;
 104
 105     for ($i = 0; $i < $selected_cnt; $i++) {
 106         switch ($query_type) {
 107         case 'row_delete':
 108             $deletes = true;
 109             $a_query = $selected[$i];
 110             $run_parts = true;
 111             break;
 112
 113         case 'drop_db':
 114             PMA_relationsCleanupDatabase($selected[$i]);
 115             $a_query   = 'DROP DATABASE '
 116                        . PMA_Util::backquote($selected[$i]);
 117             $reload    = 1;
 118             $run_parts = true;
 119             $rebuild_database_list = true;
 120             break;
 121
 122         case 'drop_tbl':
 123             PMA_relationsCleanupTable($db, $selected[$i]);
 124             $current = $selected[$i];
 125             if (!empty($views) && in_array($current, $views)) {
 126                 $sql_query_views .= (empty($sql_query_views) ? 'DROP VIEW ' : ', ')
 127                           . PMA_Util::backquote($current);
 128             } else {
 129                 $sql_query .= (empty($sql_query) ? 'DROP TABLE ' : ', ')
 130                            . PMA_Util::backquote($current);
 131             }
 132             $reload    = 1;
 133             break;
 134
 135         case 'check_tbl':
 136             $sql_query .= (empty($sql_query) ? 'CHECK TABLE ' : ', ')
 137                        . PMA_Util::backquote($selected[$i]);
 138             $use_sql    = true;
 139             break;
 140
 141         case 'optimize_tbl':
 142             $sql_query .= (empty($sql_query) ? 'OPTIMIZE TABLE ' : ', ')
 143                        . PMA_Util::backquote($selected[$i]);
 144             $use_sql    = true;
 145             break;
 146
 147         case 'analyze_tbl':
 148             $sql_query .= (empty($sql_query) ? 'ANALYZE TABLE ' : ', ')
 149                        . PMA_Util::backquote($selected[$i]);
 150             $use_sql    = true;
 151             break;
 152
 153         case 'checksum_tbl':
 154             $sql_query .= (empty($sql_query) ? 'CHECKSUM TABLE ' : ', ')
 155                        . PMA_Util::backquote($selected[$i]);
 156             $use_sql    = true;
 157             break;
 158
 159         case 'repair_tbl':
 160             $sql_query .= (empty($sql_query) ? 'REPAIR TABLE ' : ', ')
 161                        . PMA_Util::backquote($selected[$i]);
 162             $use_sql    = true;
 163             break;
 164
 165         case 'empty_tbl':
 166             $deletes = true;
 167             $a_query = 'TRUNCATE ';
 168             $a_query .= PMA_Util::backquote($selected[$i]);
 169             $run_parts = true;
 170             break;
 171
 172         case 'drop_fld':
 173             PMA_relationsCleanupColumn($db, $table, $selected[$i]);
 174             $sql_query .= (empty($sql_query)
 175                 ? 'ALTER TABLE ' . PMA_Util::backquote($table)
 176                 : ',')
 177                        . ' DROP ' . PMA_Util::backquote($selected[$i])
 178                        . (($i == $selected_cnt-1) ? ';' : '');
 179             break;
 180
 181         case 'primary_fld':
 182             $sql_query .= (empty($sql_query)
 183                 ? 'ALTER TABLE ' . PMA_Util::backquote($table) . (empty($primary)
 184                     ? ''
 185                     : ' DROP PRIMARY KEY,') . ' ADD PRIMARY KEY( '
 186                 : ', ')
 187                        . PMA_Util::backquote($selected[$i])
 188                        . (($i == $selected_cnt-1) ? ');' : '');
 189             break;
 190
 191         case 'index_fld':
 192             $sql_query .= (empty($sql_query)
 193                 ? 'ALTER TABLE ' . PMA_Util::backquote($table) . ' ADD INDEX( '
 194                 : ', ')
 195                        . PMA_Util::backquote($selected[$i])
 196                        . (($i == $selected_cnt-1) ? ');' : '');
 197             break;
 198
 199         case 'unique_fld':
 200             $sql_query .= (empty($sql_query)
 201                 ? 'ALTER TABLE ' . PMA_Util::backquote($table) . ' ADD UNIQUE( '
 202                 : ', ')
 203                        . PMA_Util::backquote($selected[$i])
 204                        . (($i == $selected_cnt-1) ? ');' : '');
 205             break;
 206
 207         case 'spatial_fld':
 208             $sql_query .= (empty($sql_query)
 209                 ? 'ALTER TABLE ' . PMA_Util::backquote($table) . ' ADD SPATIAL( '
 210                 : ', ')
 211                        . PMA_Util::backquote($selected[$i])
 212                        . (($i == $selected_cnt-1) ? ');' : '');
 213             break;
 214
 215         case 'fulltext_fld':
 216             $sql_query .= (empty($sql_query)
 217                 ? 'ALTER TABLE ' . PMA_Util::backquote($table) . ' ADD FULLTEXT( '
 218                 : ', ')
 219                        . PMA_Util::backquote($selected[$i])
 220                        . (($i == $selected_cnt-1) ? ');' : '');
 221             break;
 222
 223         case 'add_prefix_tbl':
 224             $newtablename = $_POST['add_prefix'] . $selected[$i];
 225             // ADD PREFIX TO TABLE NAME
 226             $a_query = 'ALTER TABLE '
 227                 . PMA_Util::backquote($selected[$i])
 228                 . ' RENAME '
 229                 . PMA_Util::backquote($newtablename);
 230             $run_parts = true;
 231             break;
 232
 233         case 'replace_prefix_tbl':
 234             $current = $selected[$i];
 235             $subFromPrefix = /*overload*/mb_substr(
 236                 $current,
 237                 0,
 238                 /*overload*/mb_strlen($from_prefix)
 239             );
 240             if ($subFromPrefix == $from_prefix) {
 241                 $newtablename = $to_prefix
 242                     . /*overload*/mb_substr(
 243                         $current,
 244                         /*overload*/mb_strlen($from_prefix)
 245                     );
 246             } else {
 247                 $newtablename = $current;
 248             }
 249             // CHANGE PREFIX PATTERN
 250             $a_query = 'ALTER TABLE '
 251                 . PMA_Util::backquote($selected[$i])
 252                 . ' RENAME '
 253                 . PMA_Util::backquote($newtablename);
 254             $run_parts = true;
 255             break;
 256
 257         case 'copy_tbl_change_prefix':
 258             $current = $selected[$i];
 259             $newtablename = $to_prefix .
 260                 /*overload*/mb_substr($current, /*overload*/mb_strlen($from_prefix));
 261             // COPY TABLE AND CHANGE PREFIX PATTERN
 262             $a_query = 'CREATE TABLE '
 263                 . PMA_Util::backquote($newtablename)
 264                 . ' SELECT * FROM '
 265                 . PMA_Util::backquote($selected[$i]);
 266             $run_parts = true;
 267             break;
 268
 269         } // end switch
 270
 271         // All "DROP TABLE", "DROP FIELD", "OPTIMIZE TABLE" and "REPAIR TABLE"
 272         // statements will be run at once below
 273         if ($run_parts) {
 274             $sql_query .= $a_query . ';' . "\n";
 275             if ($query_type != 'drop_db') {
 276                 $GLOBALS['dbi']->selectDb($db);
 277             }
 278             $result = $GLOBALS['dbi']->query($a_query);
 279
 280             if ($query_type == 'drop_db') {
 281                 PMA_clearTransformations($selected[$i]);
 282             } elseif ($query_type == 'drop_tbl') {
 283                 PMA_clearTransformations($db, $selected[$i]);
 284             } else if ($query_type == 'drop_fld') {
 285                 PMA_clearTransformations($db, $table, $selected[$i]);
 286             }
 287         } // end if
 288     } // end for
 289
 290     if ($deletes && ! empty($_REQUEST['pos'])) {
 291         $_REQUEST['pos'] = PMA_calculatePosForLastPage(
 292             $db, $table, isset($_REQUEST['pos']) ? $_REQUEST['pos'] : null
 293         );
 294     }
 295
 296     return array(
 297         $result, $rebuild_database_list, $reload,
 298         $run_parts, $use_sql, $sql_query, $sql_query_views
 299     );
 300 }
 301
 302 /**
 303  * Gets HTML for replace_prefix_tbl or copy_tbl_change_prefix
 304  *
 305  * @param string $what        mult_submit type
 306  * @param string $action      action type
 307  * @param array  $_url_params URL params
 308  *
 309  * @return string
 310  */
 311 function PMA_getHtmlForReplacePrefixTable($what, $action, $_url_params)
 312 {
 313     $html  = '<form action="' . $action . '" method="post">';
 314     $html .= PMA_URL_getHiddenInputs($_url_params);
 315     $html .= '<fieldset class = "input">';
 316     $html .= '<legend>';
 317     if ($what == 'replace_prefix_tbl') {
 318         $html .= __('Replace table prefix:');
 319     } else {
 320         $html .= __('Copy table with prefix:');
 321     }
 322     $html .= '</legend>';
 323     $html .= '<table>';
 324     $html .= '<tr>';
 325     $html .= '<td>' . __('From') . '</td>';
 326     $html .= '<td>';
 327     $html .= '<input type="text" name="from_prefix" id="initialPrefix" />';
 328     $html .= '</td>';
 329     $html .= '</tr>';
 330     $html .= '<tr>';
 331     $html .= '<td>' . __('To') . '</td>';
 332     $html .= '<td>';
 333     $html .= '<input type="text" name="to_prefix" id="newPrefix" />';
 334     $html .= '</td>';
 335     $html .= '</tr>';
 336     $html .= '</table>';
 337     $html .= '</fieldset>';
 338     $html .= '<fieldset class="tblFooters">';
 339     $html .= '<input type="hidden" name="mult_btn" value="' . __('Yes') . '" />';
 340     $html .= '<input type="submit" value="' . __('Submit') . '" id="buttonYes" />';
 341     $html .= '</fieldset>';
 342     $html .= '</form>';
 343
 344     return $html;
 345 }
 346
 347 /**
 348  * Gets HTML for add_prefix_tbl
 349  *
 350  * @param string $action      action type
 351  * @param array  $_url_params URL params
 352  *
 353  * @return string
 354  */
 355 function PMA_getHtmlForAddPrefixTable($action, $_url_params)
 356 {
 357     $html  = '<form action="' . $action . '" method="post">';
 358     $html .= PMA_URL_getHiddenInputs($_url_params);
 359     $html .= '<fieldset class = "input">';
 360     $html .= '<legend>' . __('Add table prefix:') . '</legend>';
 361     $html .= '<table>';
 362     $html .= '<tr>';
 363     $html .= '<td>' . __('Add prefix') . '</td>';
 364     $html .= '<td>';
 365     $html .= '<input type="text" name="add_prefix" id="txtPrefix" />';
 366     $html .= '</td>';
 367     $html .= '</tr>';
 368     $html .= '<tr>';
 369     $html .= '</table>';
 370     $html .= '</fieldset>';
 371     $html .= '<fieldset class="tblFooters">';
 372     $html .= '<input type="hidden" name="mult_btn" value="' . __('Yes') . '" />';
 373     $html .= '<input type="submit" value="' . __('Submit') . '" id="buttonYes" />';
 374     $html .= '</fieldset>';
 375     $html .= '</form>';
 376
 377     return $html;
 378 }
 379
 380 /**
 381  * Gets HTML for other mult_submits actions
 382  *
 383  * @param string $what        mult_submit type
 384  * @param string $action      action type
 385  * @param array  $_url_params URL params
 386  * @param string $full_query  full sql query string
 387  *
 388  * @return string
 389  */
 390 function PMA_getHtmlForOtherActions($what, $action, $_url_params, $full_query)
 391 {
 392     $html = '<form action="' . $action . '" method="post">';
 393     $html .= PMA_URL_getHiddenInputs($_url_params);
 394     $html .= '<fieldset class="confirmation">';
 395     $html .= '<legend>';
 396     if ($what == 'drop_db') {
 397         $html .=  __('You are about to DESTROY a complete database!') . ' ';
 398     }
 399     $html .= __('Do you really want to execute the following query?');
 400     $html .= '<input type="submit" name="mult_btn" value="'
 401         . __('Yes') . '" />';
 402     $html .= '<input type="submit" name="mult_btn" value="'
 403         . __('No') . '" />';
 404     $html .= '</legend>';
 405     $html .= '<code>' . $full_query . '</code>';
 406     $html .= '</fieldset>';
 407     $html .= '<fieldset class="tblFooters">';
 408     // Display option to disable foreign key checks while dropping tables
 409     if ($what === 'drop_tbl' || $what === 'empty_tbl' || $what === 'row_delete') {
 410         $html .= '<div id="foreignkeychk">';
 411         $html .= PMA_Util::getFKCheckbox();
 412         $html .= '</div>';
 413     }
 414     $html .= '<input id="buttonYes" type="submit" name="mult_btn" value="'
 415         . __('Yes') . '" />';
 416     $html .= '<input id="buttonNo" type="submit" name="mult_btn" value="'
 417         . __('No') . '" />';
 418     $html .= '</fieldset>';
 419     $html .= '</form>';
 420
 421     return $html;
 422 }
 423
 424 /**
 425  * Get query string from Selected
 426  *
 427  * @param string $what     mult_submit type
 428  * @param string $table    table name
 429  * @param array  $selected the selected columns
 430  * @param array  $views    table views
 431  *
 432  * @return array
 433  */
 434 function PMA_getQueryFromSelected($what, $table, $selected, $views)
 435 {
 436     $reload = false;
 437     $full_query_views = null;
 438     $full_query     = '';
 439
 440     if ($what == 'drop_tbl') {
 441         $full_query_views = '';
 442     }
 443
 444     $selected_cnt   = count($selected);
 445     $i = 0;
 446     foreach ($selected as $sval) {
 447         switch ($what) {
 448         case 'row_delete':
 449             $full_query .= 'DELETE FROM '
 450                 . PMA_Util::backquote(htmlspecialchars($table))
 451                 // Do not append a "LIMIT 1" clause here
 452                 // (it's not binlog friendly).
 453                 // We don't need the clause because the calling panel permits
 454                 // this feature only when there is a unique index.
 455                 . ' WHERE ' . urldecode(htmlspecialchars($sval))
 456                 . ';<br />';
 457             break;
 458         case 'drop_db':
 459             $full_query .= 'DROP DATABASE '
 460                 . PMA_Util::backquote(htmlspecialchars($sval))
 461                 . ';<br />';
 462             $reload = true;
 463             break;
 464
 465         case 'drop_tbl':
 466             $current = $sval;
 467             if (!empty($views) && in_array($current, $views)) {
 468                 $full_query_views .= (empty($full_query_views) ? 'DROP VIEW ' : ', ')
 469                     . PMA_Util::backquote(htmlspecialchars($current));
 470             } else {
 471                 $full_query .= (empty($full_query) ? 'DROP TABLE ' : ', ')
 472                     . PMA_Util::backquote(htmlspecialchars($current));
 473             }
 474             break;
 475
 476         case 'empty_tbl':
 477             $full_query .= 'TRUNCATE ';
 478             $full_query .= PMA_Util::backquote(htmlspecialchars($sval))
 479                         . ';<br />';
 480             break;
 481
 482         case 'primary_fld':
 483             if ($full_query == '') {
 484                 $full_query .= 'ALTER TABLE '
 485                     . PMA_Util::backquote(htmlspecialchars($table))
 486                     . '<br />&nbsp;&nbsp;DROP PRIMARY KEY,'
 487                     . '<br />&nbsp;&nbsp; ADD PRIMARY KEY('
 488                     . '<br />&nbsp;&nbsp;&nbsp;&nbsp; '
 489                     . PMA_Util::backquote(htmlspecialchars($sval))
 490                     . ',';
 491             } else {
 492                 $full_query .= '<br />&nbsp;&nbsp;&nbsp;&nbsp; '
 493                     . PMA_Util::backquote(htmlspecialchars($sval))
 494                     . ',';
 495             }
 496             if ($i == $selected_cnt-1) {
 497                 $full_query = preg_replace('@,$@', ');<br />', $full_query);
 498             }
 499             break;
 500
 501         case 'drop_fld':
 502             if ($full_query == '') {
 503                 $full_query .= 'ALTER TABLE '
 504                     . PMA_Util::backquote(htmlspecialchars($table));
 505             }
 506             $full_query .= '<br />&nbsp;&nbsp;DROP '
 507                 . PMA_Util::backquote(htmlspecialchars($sval))
 508                 . ',';
 509             if ($i == $selected_cnt - 1) {
 510                 $full_query = preg_replace('@,$@', ';<br />', $full_query);
 511             }
 512             break;
 513         } // end switch
 514         $i++;
 515     }
 516
 517     if ($what == 'drop_tbl') {
 518         if (!empty($full_query)) {
 519             $full_query .= ';<br />' . "\n";
 520         }
 521         if (!empty($full_query_views)) {
 522             $full_query .= $full_query_views . ';<br />' . "\n";
 523         }
 524         unset($full_query_views);
 525     }
 526
 527     $full_query_views = isset($full_query_views)? $full_query_views : null;
 528
 529     return array($full_query, $reload, $full_query_views);
 530 }
 531