3 // vim: expandtab sw=4 ts=4 sts=4:
7 * Prepares the work and runs some other scripts if required
9 if (!empty($submit_mult)
10 && (!empty($selected_db) ||
!empty($selected_tbl) ||
!empty($selected_fld))) {
12 if (!empty($selected_db)) {
13 $selected = $selected_db;
15 } else if (!empty($selected_tbl)) {
16 if ($submit_mult == $strPrintView) {
17 include('./tbl_printview.php3');
20 $selected = $selected_tbl;
21 switch ($submit_mult) {
28 case $strOptimizeTable:
30 $query_type = 'optimize_tbl';
35 $query_type = 'repair_tbl';
41 $selected = $selected_fld;
42 if ($submit_mult == $strDrop) {
45 include('./tbl_alter.php3');
53 * Displays the confirmation form if required
55 if (!empty($submit_mult) && !empty($what)) {
58 $selected_cnt = count($selected);
59 for ($i = 0; $i < $selected_cnt; $i++
) {
62 $full_query .= 'DROP DATABASE '
63 . PMA_backquote(htmlspecialchars(urldecode($selected[$i])))
68 $full_query .= (empty($full_query) ?
'DROP TABLE ' : ', ')
69 . PMA_backquote(htmlspecialchars(urldecode($selected[$i])))
70 . (($i == $selected_cnt - 1) ?
';<br />' : '');
74 if (PMA_MYSQL_INT_VERSION
>= 40000) {
75 $full_query .= 'TRUNCATE ';
77 $full_query .= 'DELETE FROM ';
79 $full_query .= PMA_backquote(htmlspecialchars(urldecode($selected[$i])))
84 if ($full_query == '') {
85 $full_query .= 'ALTER TABLE '
86 . PMA_backquote(htmlspecialchars($table))
87 . '<br /> DROP '
88 . PMA_backquote(htmlspecialchars(urldecode($selected[$i])))
91 $full_query .= '<br /> DROP '
92 . PMA_backquote(htmlspecialchars(urldecode($selected[$i])))
95 if ($i == $selected_cnt-1) {
96 $full_query = ereg_replace(',$', ';<br />', $full_query);
103 echo $strDoYouReally . ' :<br />' . "\n";
104 echo '<tt>' . $full_query . '</tt> ?<br/>' . "\n";
106 <form action
="<?php echo $action; ?>" method
="post">
109 if (strpos(' ' . $action, 'db_details') == 1) {
110 echo PMA_generate_common_hidden_inputs($db);
111 } else if (strpos(' ' . $action, 'tbl_properties') == 1) {
112 echo PMA_generate_common_hidden_inputs($db,$table);
114 for ($i = 0; $i < $selected_cnt; $i++
) {
115 echo ' <input type="hidden" name="selected[]" value="' . htmlspecialchars($selected[$i]) . '" />' . "\n";
118 <input type
="hidden" name
="query_type" value
="<?php echo $what; ?>" />
119 <input type
="submit" name
="mult_btn" value
="<?php echo $strYes; ?>" />
120 <input type
="submit" name
="mult_btn" value
="<?php echo $strNo; ?>" />
125 include('./footer.inc.php3');
133 else if ($mult_btn == $strYes) {
136 $selected_cnt = count($selected);
137 for ($i = 0; $i < $selected_cnt; $i++
) {
138 switch ($query_type) {
140 $a_query = 'DROP DATABASE '
141 . PMA_backquote(urldecode($selected[$i]));
146 $sql_query .= (empty($sql_query) ?
'DROP TABLE ' : ', ')
147 . PMA_backquote(urldecode($selected[$i]))
148 . (($i == $selected_cnt-1) ?
';' : '');
153 $sql_query .= (empty($sql_query) ?
'OPTIMIZE TABLE ' : ', ')
154 . PMA_backquote(urldecode($selected[$i]))
155 . (($i == $selected_cnt-1) ?
';' : '');
159 $sql_query .= (empty($sql_query) ?
'REPAIR TABLE ' : ', ')
160 . PMA_backquote(urldecode($selected[$i]))
161 . (($i == $selected_cnt-1) ?
';' : '');
165 $a_query = 'DELETE FROM '
166 . PMA_backquote(urldecode($selected[$i]));
170 $sql_query .= (empty($sql_query) ?
'ALTER TABLE ' . PMA_backquote($table) : ',')
171 . ' DROP ' . PMA_backquote(urldecode($selected[$i]))
172 . (($i == $selected_cnt-1) ?
';' : '');
176 // All "DROP TABLE","DROP FIELD", "OPTIMIZE TABLE" and "REPAIR TABLE"
177 // statements will be run at once below
178 if ($query_type != 'drop_tbl'
179 && $query_type != 'drop_fld'
180 && $query_type != 'repair_tbl'
181 && $query_type != 'optimize_tbl') {
182 $sql_query .= $a_query . ';' . "\n";
184 if ($query_type != 'drop_db') {
185 PMA_mysql_select_db($db);
187 $result = @PMA_mysql_query
($a_query) or PMA_mysqlDie('', $a_query, FALSE, $err_url);
191 if ($query_type == 'drop_tbl'
192 ||
$query_type == 'drop_fld'
193 ||
$query_type == 'repair_tbl'
194 ||
$query_type == 'optimize_tbl') {
195 PMA_mysql_select_db($db);
196 $result = @PMA_mysql_query
($sql_query) or PMA_mysqlDie('', '', FALSE, $err_url);
199 PMA_showMessage($strSuccess);