}
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'] : "";
