interface/main/myadmin/mult_submits.inc.php

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5
   6 /**
   7  * Prepares the work and runs some other scripts if required
   8  */
   9 if (!empty($submit_mult)
  10     && ($submit_mult != $strWithChecked)
  11     && (  !empty($selected_db)
  12        || !empty($selected_tbl)
  13        || !empty($selected_fld)
  14        || !empty($rows_to_delete)
  15          )) {
  16
  17     if (!empty($selected_db)) {
  18         $selected     = $selected_db;
  19         $what         = 'drop_db';
  20     } else if (!empty($selected_tbl)) {
  21         if ($submit_mult == $strPrintView) {
  22             require('./tbl_printview.php');
  23         } else {
  24            $selected = $selected_tbl;
  25            switch ($submit_mult) {
  26                case 'drop_db':
  27                    $what = 'drop_db';
  28                    break;
  29                case $strDrop:
  30                    $what = 'drop_tbl';
  31                    break;
  32                case $strEmpty:
  33                    $what = 'empty_tbl';
  34                    break;
  35                case $strCheckTable:
  36                    unset($submit_mult);
  37                    $query_type = 'check_tbl';
  38                    $mult_btn   = $strYes;
  39                    break;
  40                case $strOptimizeTable:
  41                    unset($submit_mult);
  42                    $query_type = 'optimize_tbl';
  43                    $mult_btn   = $strYes;
  44                    break;
  45                case $strRepairTable:
  46                    unset($submit_mult);
  47                    $query_type = 'repair_tbl';
  48                    $mult_btn   = $strYes;
  49                    break;
  50                case $strAnalyzeTable:
  51                    unset($submit_mult);
  52                    $query_type = 'analyze_tbl';
  53                    $mult_btn   = $strYes;
  54                    break;
  55            } // end switch
  56         }
  57     } else if (!empty($selected_fld)) {
  58         $selected     = $selected_fld;
  59         if ($submit_mult == $strDrop) {
  60             $what     = 'drop_fld';
  61         } else {
  62             require('./tbl_alter.php');
  63         }
  64     } else {
  65         $what = 'row_delete';
  66         $selected = $rows_to_delete;
  67     }
  68 } // end if
  69
  70
  71 /**
  72  * Displays the confirmation form if required
  73  */
  74 if (!empty($submit_mult) && !empty($what)) {
  75     $js_to_run = 'functions.js';
  76     unset($message);
  77     if (!empty($table)) {
  78         require('./tbl_properties_common.php');
  79         $url_query .= '&amp;goto=tbl_properties.php&amp;back=tbl_properties.php';
  80         require('./tbl_properties_table_info.php');
  81     }
  82     elseif (!empty($db)) {
  83         require('./db_details_common.php');
  84         require('./db_details_db_info.php');
  85     }
  86     // Builds the query
  87     $full_query     = '';
  88     $selected_cnt   = count($selected);
  89     $i = 0;
  90     foreach($selected AS $idx => $sval) {
  91         $i++;
  92         switch ($what) {
  93             case 'row_delete':
  94                 $full_query .= htmlspecialchars(urldecode($sval))
  95                             . ';<br />';
  96                 break;
  97             case 'drop_db':
  98                 $full_query .= 'DROP DATABASE '
  99                             . PMA_backquote(htmlspecialchars(urldecode($sval)))
 100                             . ';<br />';
 101                 break;
 102
 103             case 'drop_tbl':
 104                 $full_query .= (empty($full_query) ? 'DROP TABLE ' : ', ')
 105                             . PMA_backquote(htmlspecialchars(urldecode($sval)))
 106                             . (($i == $selected_cnt - 1) ? ';<br />' : '');
 107                 break;
 108
 109             case 'empty_tbl':
 110                 if (PMA_MYSQL_INT_VERSION >= 40000) {
 111                     $full_query .= 'TRUNCATE ';
 112                 } else {
 113                     $full_query .= 'DELETE FROM ';
 114                 }
 115                 $full_query .= PMA_backquote(htmlspecialchars(urldecode($sval)))
 116                             . ';<br />';
 117                 break;
 118
 119             case 'drop_fld':
 120                 if ($full_query == '') {
 121                     $full_query .= 'ALTER TABLE '
 122                                 . PMA_backquote(htmlspecialchars($table))
 123                                 . '<br />&nbsp;&nbsp;DROP '
 124                                 . PMA_backquote(htmlspecialchars(urldecode($sval)))
 125                                 . ',';
 126                 } else {
 127                     $full_query .= '<br />&nbsp;&nbsp;DROP '
 128                                 . PMA_backquote(htmlspecialchars(urldecode($sval)))
 129                                 . ',';
 130                 }
 131                 if ($i == $selected_cnt-1) {
 132                     $full_query = preg_replace('@,$@', ';<br />', $full_query);
 133                 }
 134                 break;
 135         } // end switch
 136     }
 137
 138     // Displays the form
 139     echo $strDoYouReally . '&nbsp;:<br />' . "\n";
 140     echo '<tt>' . $full_query . '</tt>&nbsp;?<br/>' . "\n";
 141     ?>
 142 <form action="<?php echo $action; ?>" method="post">
 143     <?php
 144     echo "\n";
 145     if (strpos(' ' . $action, 'db_details') == 1) {
 146         echo PMA_generate_common_hidden_inputs($db);
 147     } else if (strpos(' ' . $action, 'tbl_properties') == 1
 148               || $what == 'row_delete') {
 149         echo PMA_generate_common_hidden_inputs($db,$table);
 150     } else  {
 151         echo PMA_generate_common_hidden_inputs();
 152     }
 153     foreach($selected AS $idx => $sval) {
 154         echo '    <input type="hidden" name="selected[]" value="' . htmlspecialchars($sval) . '" />' . "\n";
 155     }
 156     ?>
 157     <input type="hidden" name="query_type" value="<?php echo $what; ?>" />
 158     <?php
 159     if ($what == 'row_delete') {
 160         echo '<input type="hidden" name="original_sql_query" value="' . $original_sql_query . '" />' . "\n";
 161         echo '<input type="hidden" name="original_pos" value="' . $original_pos . '" />' . "\n";
 162         echo '<input type="hidden" name="original_url_query" value="' . $original_url_query . '" />' . "\n";
 163     }
 164     ?>
 165     <input type="submit" name="mult_btn" value="<?php echo $strYes; ?>" />
 166     <input type="submit" name="mult_btn" value="<?php echo $strNo; ?>" />
 167 </form>
 168     <?php
 169     echo"\n";
 170
 171     require_once('./footer.inc.php');
 172 } // end if
 173
 174
 175 /**
 176  * Executes the query
 177  */
 178 else if ($mult_btn == $strYes) {
 179
 180     if ($query_type == 'drop_db' || $query_type == 'drop_tbl' || $query_type == 'drop_fld') {
 181         require_once('./libraries/relation_cleanup.lib.php');
 182     }
 183
 184     $sql_query      = '';
 185     $selected_cnt   = count($selected);
 186     for ($i = 0; $i < $selected_cnt; $i++) {
 187         switch ($query_type) {
 188             case 'row_delete':
 189                 $a_query = urldecode($selected[$i]);
 190                 break;
 191
 192             case 'drop_db':
 193                 PMA_relationsCleanupDatabase($selected[$i]);
 194                 $a_query   = 'DROP DATABASE '
 195                            . PMA_backquote(urldecode($selected[$i]));
 196                 $reload    = 1;
 197                 break;
 198
 199             case 'drop_tbl':
 200                 PMA_relationsCleanupTable($db, $selected[$i]);
 201                 $sql_query .= (empty($sql_query) ? 'DROP TABLE ' : ', ')
 202                            . PMA_backquote(urldecode($selected[$i]))
 203                            . (($i == $selected_cnt-1) ? ';' : '');
 204                 $reload    = 1;
 205                 break;
 206
 207             case 'check_tbl':
 208                 $sql_query .= (empty($sql_query) ? 'CHECK TABLE ' : ', ')
 209                            . PMA_backquote(urldecode($selected[$i]));
 210                 break;
 211
 212             case 'optimize_tbl':
 213                 $sql_query .= (empty($sql_query) ? 'OPTIMIZE TABLE ' : ', ')
 214                            . PMA_backquote(urldecode($selected[$i]));
 215                 break;
 216
 217             case 'analyze_tbl':
 218                 $sql_query .= (empty($sql_query) ? 'ANALYZE TABLE ' : ', ')
 219                            . PMA_backquote(urldecode($selected[$i]));
 220                 break;
 221
 222             case 'repair_tbl':
 223                 $sql_query .= (empty($sql_query) ? 'REPAIR TABLE ' : ', ')
 224                            . PMA_backquote(urldecode($selected[$i]));
 225                 break;
 226
 227             case 'empty_tbl':
 228                 if (PMA_MYSQL_INT_VERSION >= 40000) {
 229                     $a_query = 'TRUNCATE ';
 230                 } else {
 231                     $a_query = 'DELETE FROM ';
 232                 }
 233                 $a_query .= PMA_backquote(htmlspecialchars(urldecode($selected[$i])));
 234                 break;
 235
 236             case 'drop_fld':
 237                 PMA_relationsCleanupTable($db, $table, $selected[$i]);
 238                 $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_backquote($table) : ',')
 239                            . ' DROP ' . PMA_backquote(urldecode($selected[$i]))
 240                            . (($i == $selected_cnt-1) ? ';' : '');
 241                 break;
 242         } // end switch
 243
 244         // All "DROP TABLE","DROP FIELD", "OPTIMIZE TABLE" and "REPAIR TABLE"
 245         // statements will be run at once below
 246         if ($query_type != 'drop_tbl'
 247             && $query_type != 'drop_fld'
 248             && $query_type != 'repair_tbl'
 249             && $query_type != 'analyze_tbl'
 250             && $query_type != 'optimize_tbl'
 251             && $query_type != 'check_tbl') {
 252
 253             $sql_query .= $a_query . ';' . "\n";
 254
 255             if ($query_type != 'drop_db') {
 256                 PMA_mysql_select_db($db);
 257             }
 258             $result = @PMA_mysql_query($a_query) or PMA_mysqlDie('', $a_query, FALSE, $err_url);
 259         } // end if
 260     } // end for
 261
 262     if ($query_type == 'drop_tbl'
 263         || $query_type == 'drop_fld') {
 264         PMA_mysql_select_db($db);
 265         $result = @PMA_mysql_query($sql_query) or PMA_mysqlDie('', '', FALSE, $err_url);
 266     } elseif ($query_type == 'repair_tbl'
 267         || $query_type == 'analyze_tbl'
 268         || $query_type == 'check_tbl'
 269         || $query_type == 'optimize_tbl') {
 270         require('./sql.php');
 271     }
 272
 273 }
 274
 275 ?>