} if ($_POST['t_edit_engine'] != "") { $sql_alter .= (MSD_NEW_VERSION ? "ENGINE=" : "TYPE=") . $_POST['t_edit_engine'] . ", "; } if ($_POST['t_edit_rowformat'] != "") { $sql_alter .= "ROW_FORMAT=" . $_POST['t_edit_rowformat'] . ", "; } if (MSD_NEW_VERSION && $_POST['t_edit_charset'] != "") { $sql_alter .= "DEFAULT CHARSET=" . $_POST['t_edit_charset'] . ", "; } if (MSD_NEW_VERSION && $_POST['t_edit_collate'] != "") { $sql_alter .= "COLLATE " . $_POST['t_edit_collate'] . ", "; } $sql_alter .= "COMMENT='" . $_POST['t_edit_comment'] . "' "; MSD_DoSQL($sql_alter); echo SQLOutput($out, $lang['L_TABLE'] . ' `' . $_POST['table_edit_name'] . '` ' . $lang['L_SQL_CHANGED']); } } else { if (!isset($table_edit_name) || $table_edit_name == "") { $table_edit_name = isset($_GET['tablename']) ? $_GET['tablename'] : ""; if (isset($_POST['tableselect'])) { $table_edit_name = $_POST['tableselect']; } if (isset($_POST['newtablesubmit'])) { $table_edit_name = $_POST['newtablename']; } } } if (isset($_POST['newfield_posted'])) { //build sql for alter if ($_POST['f_name'] == '') {
case "rename": $dbold = $databases['Name'][$db_index]; DB_Copy($dbold, $newname, 1); echo SQLOutput($out, '<p class="success">' . $lang['L_DB'] . ' `' . $dbold . '` ' . $lang['L_SQL_RENAMEDTO'] . ' `' . $newname . '`.</p>'); $changed = true; break; case "copy": $dbold = $databases['Name'][$db_index]; DB_Copy($dbold, $newname); $changed = true; echo SQLOutput($out, '<p class="success">' . sprintf($lang['L_SQL_DBCOPY'], $dbold, $newname) . '</p>'); break; case "structure": DB_Copy($databases['Name'][$db_index], $newname, 0, 0); $changed = true; echo SQLOutput($out, '<p class="success">' . sprintf($lang['L_SQL_DBSCOPY'], $databases['Name'][$db_index], $newname) . '</p>'); break; case "rights": break; } if ($changed = true) { SetDefault(); include $config['files']['parameter']; echo '<script language="JavaScript" type="text/javascript">parent.MySQL_Dumper_menu.location.href="menu.php?action=dbrefresh";</script>'; } } if (isset($_POST['dbwantaction'])) { if (isset($_POST['db_createnew'])) { $newname = trim($_POST['db_create']); if (!empty($newname)) { $sqlc = "CREATE DATABASE `{$newname}`";
} echo '</p><p class="tablename">' . ($tn != '' ? $lang['L_TABLE'] . ' <strong>`' . $databases['db_actual'] . '`.`' . $tn . '`</strong><br>' : ''); if (isset($msg)) { echo $msg; } $numrowsabs = -1; $numrows = 0; // vorgehensweise - zwischen SELECT und FROM alles rausschneiden und durch count(*) ersetzen // es soll die Summe der Datensaetze ermittelt werden, wenn es kein LIMIT geben wuerde, um die // Blaettern-Links korrekt anzuzeigen $skip_mysql_execution = false; if ($sql_to_display_data == 0) { //mehrere SQL-Statements $numrowsabs = $numrows = 0; MSD_DoSQL($sql['sql_statement']); echo SQLOutput($out); $skip_mysql_execution = true; } else { $sql_temp = strtolower($sql['sql_statement']); if (substr($sql_temp, 0, 7) == 'select ') { if (false !== strpos($sql_temp, ' limit ')) { // es wurde ein eigenes Lmit im Query angegeben - eigene Berechnung abbrechen $numrowsabs = -1; } else { $pos = strpos($sql_temp, 'from '); $sql_temp = 'SELECT count(*) as anzahl ' . substr($sql['sql_statement'], $pos, strlen($sql['sql_statement']) - $pos); $res = @MSD_query($sql_temp, false); if ($res) { if ($row = mysql_fetch_object($res)) { $numrowsabs = $row->anzahl; }
case "rename": $dbold = $databases['Name'][$db_index]; DB_Copy($dbold, $newname, 1); echo SQLOutput($out, '<p class="success">' . $lang['db'] . ' `' . $dbold . '` ' . $lang['sql_renamedto'] . ' `' . $newname . '`.</p>'); $changed = true; break; case "copy": $dbold = $databases['Name'][$db_index]; DB_Copy($dbold, $newname); $changed = true; echo SQLOutput($out, '<p class="success">' . sprintf($lang['sql_dbcopy'], $dbold, $newname) . '</p>'); break; case "structure": DB_Copy($databases['Name'][$db_index], $newname, 0, 0); $changed = true; echo SQLOutput($out, '<p class="success">' . sprintf($lang['sql_dbscopy'], $databases['Name'][$db_index], $newname) . '</p>'); break; case "rights": break; } if ($changed = true) { SetDefault(); include $config['files']['parameter']; echo '<script language="JavaScript">parent.MySQL_Dumper_menu.location.href="menu.php?action=dbrefresh";</script>'; } } if (isset($_POST['dbwantaction'])) { if (isset($_POST['db_createnew'])) { $newname = $_POST['db_create']; if (!empty($newname)) { $col = MSD_NEW_VERSION ? $_POST['db_collate'] : "";