'.$lang['sql_tablesofdb'].' `'.$databases['Name'][$dbid].'` '.$lang['sql_edit'].'';
if(isset($_GET['kill'])) {
if($_GET['anz']==1)
echo ''.$lang['sql_nofielddelete'].'
';
else {
$sql_alter="ALTER TABLE `".$databases['Name'][$dbid]."`.`".$_GET['tablename']."` DROP COLUMN `".$_GET['kill']."`";
MSD_DoSQL($sql_alter);
echo '';
echo '
'.$lang['sql_fielddelete1'].' `'.$_GET['kill'].'` '.$lang['sql_deleted'].'.
'.highlight_sql($out).'
'.$lang['sql_nodest_copy'].'
';
} elseif(Table_Exists($databases['Name'][$dbid],$_POST['tablecopyname'])) {
echo ''.$lang['sql_desttable_exists'].'
';
} else {
Table_Copy("`".$databases['Name'][$dbid]."`.`".$table_edit_name."`",$_POST['tablecopyname'],$_POST['copyatt']);
echo '';
echo ($_POST['copyatt']==0) ? '
'.sprintf($lang['sql_scopy'],$table_edit_name,$_POST['tablecopyname']).'.
' : '
'.sprintf($lang['sql_tcopy'],$table_edit_name,$_POST['tablecopyname']).'
';
echo highlight_sql($out).'
'.$lang['sql_tablenoname'].'
';
} else {
$sql_alter="CREATE TABLE `".$databases['Name'][$dbid]."`.`".$_POST['newtablename']."` (`id` int(11) unsigned not null AUTO_INCREMENT PRIMARY KEY ) ".((MSD_NEW_VERSION) ? "ENGINE" : "TYPE")."=MyISAM;";
MSD_DoSQL($sql_alter);
echo SQLOutput($out,$lang['table'].' `'.$_POST['newtablename'].'` '.$lang['sql_created']);
}
}
if(isset($_POST['t_edit_submit'])) {
$sql_alter="ALTER TABLE `".$databases['Name'][$dbid]."`.`".$_POST['table_edit_name']."` ";
if($_POST['t_edit_name']=="")
echo ''.$lang['sql_tblnameempty'].'
';
elseif(MSD_NEW_VERSION && $_POST['t_edit_collate']!="" && substr($_POST['t_edit_collate'],0,strlen($_POST['t_edit_charset']))!=$_POST['t_edit_charset'])
echo ''.$lang['sql_collatenotmatch'].'
';
else {
if($_POST['table_edit_name']!=$_POST['t_edit_name']) {
$sql_alter.="RENAME TO `".$_POST['t_edit_name']."`, ";
$table_edit_name=$_POST['t_edit_name'];
} else $table_edit_name=$_POST['table_edit_name'];
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['table'].' `'.$_POST['table_edit_name'].'` '.$lang['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']=="") {
echo ''.$lang['sql_fieldnamenotvalid'].' ('.$_POST['f_name'].')
';
$field_fehler=1;
} else {
//alter Key
$oldkeys[0]=$_POST['f_primary'];
$oldkeys[1]=$_POST['f_unique'];
$oldkeys[2]=$_POST['f_index'];
$oldkeys[3]=$_POST['f_fulltext'];
//neuer Key
$newkeys[0]=($_POST['f_index_new']=="primary")? 1 : 0;
$newkeys[1]=($_POST['f_index_new']=="unique")? 1 : 0;
$newkeys[2]=($_POST['f_index_new']=="index")? 1 : 0;
$newkeys[3]=(isset($_POST['f_indexfull'])) ? 1 : 0;
$add_sql.=ChangeKeys($oldkeys,$newkeys,$_POST['f_name'],$_POST['f_size'],"drop_only");
$sql_stamm="ALTER TABLE `".$databases['Name'][$dbid]."`.`$table_edit_name` ";
$sql_alter=$sql_stamm.((isset($_POST['editfield'])) ? "CHANGE COLUMN `".$_POST['fieldname']."` `".$_POST['f_name']."` " : "ADD COLUMN `".$_POST['f_name']."` ");
$sql_alter.=$_POST['f_type'];
$wl=stripslashes($_POST['f_size']);
if($wl!="" && !preg_match('@^(DATE|DATETIME|TIME|TINYBLOB|TINYTEXT|BLOB|TEXT|MEDIUMBLOB|MEDIUMTEXT|LONGBLOB|LONGTEXT)$@i', $_POST['f_type'])) {
$sql_alter.="($wl) ";
} elseif ($_POST['f_size']=="" && preg_match('@^(VARCHAR)$@i', $_POST['f_type'])) {
$sql_alter.="("."255".") ";
} else $sql_alter.=" ";
$sql_alter.=$_POST['f_attribut']." ";
$sql_alter.=$_POST['f_null']." ";
$sql_alter.=($_POST['f_default']!="") ? "DEFAULT '".$_POST['f_default']."' " :"";
if(MSD_NEW_VERSION && $_POST['f_collate']!="") $sql_alter.="COLLATE ".$_POST['f_collate']." ";
if($_POST['f_extra']=="AUTO_INCREMENT") {
$sql_alter.=" AUTO_INCREMENT ";
}
if($newkeys[0]==1) $sql_alter.=" PRIMARY KEY ";
if($newkeys[1]==1) $sql_alter.=" UNIQUE INDEX ";
if($newkeys[2]==1) $sql_alter.=" INDEX ";
if($newkeys[3]==1) $sql_alter.=" FULLTEXT INDEX ";
$sql_alter.=$_POST['f_position']." ;";
if($add_sql!="") {
$add_sql=$sql_stamm.$add_sql;
$sql_alter="$sql_alter;\n$add_sql;\n";
}
MSD_DoSQL($sql_alter);
echo '';
echo '
`'.$_POST['f_name'].'` '.((isset($_POST['editfield'])) ? $lang['sql_changed'] : $lang['sql_created']).'.
';
echo highlight_sql($out).'
';
if($table_edit_name!="") {
$sqlf="SHOW FULL FIELDS FROM `".$databases['Name'][$dbid]."`.`$table_edit_name` ;";
$res=MSD_query($sqlf) or die(SQLError($sqlf,mysql_error()));
$anz_fields=mysql_num_rows($res);
//Array füllen
$fields_infos=FillFieldinfos($databases['Name'][$dbid],$table_edit_name);
if(MSD_NEW_VERSION)
$t_engine=(isset($fields_infos['_tableinfo_']['ENGINE'])) ? $fields_infos['_tableinfo_']['ENGINE'] : "MyISAM";
else
$t_engine=(isset($fields_infos['_tableinfo_']['TYPE'])) ? $fields_infos['_tableinfo_']['TYPE'] : "MyISAM";
$t_charset=(isset($fields_infos['_tableinfo_']['DEFAULT CHARSET'])) ? $fields_infos['_tableinfo_']['DEFAULT CHARSET'] : "";
$t_collation=isset($row['Collation']) ? $row['Collation'] : ""; //(isset($fields_infos['_tableinfo_']['COLLATE'])) ? $fields_infos['_tableinfo_']['COLLATE'] : "";
$t_comment=(isset($fields_infos['_tableinfo_']['COMMENT'])) ? substr($fields_infos['_tableinfo_']['COMMENT'],1,strlen($fields_infos['_tableinfo_']['COMMENT'])-2) : "";
$t_rowformat=(isset($fields_infos['_tableinfo_']['ROW_FORMAT'])) ? $fields_infos['_tableinfo_']['ROW_FORMAT'] : "";
echo "Tabelle `$table_edit_name`
";
$td='';
//Tabelleneigenschaften
echo ' ';
$field_fehler=0;
echo 'Felder der Tabelle `'.$table_edit_name.'`';
if(isset($_GET['newfield']) || isset($_GET['editfield']) || $field_fehler>0 || isset($_POST['newfield_posted'])) {
if(isset($_GET['editfield'])) $id=$_GET['editfield'];
$d_name=(isset($_GET['editfield'])) ? $fields_infos[$id]['name'] : "";
$d_type=(isset($_GET['editfield'])) ? $fields_infos[$id]['type'] : "";
$d_size=(isset($_GET['editfield'])) ? $fields_infos[$id]['size'] : "";
$d_null=(isset($_GET['editfield'])) ? $fields_infos[$id]['null'] : "";
$d_attribute=(isset($_GET['editfield'])) ? $fields_infos[$id]['attribut'] : "";
$d_default=(isset($_GET['editfield'])) ? substr($fields_infos[$id]['default'],1,strlen($fields_infos[$id]['default'])-2) : "";
$d_extra=(isset($_GET['editfield'])) ? $fields_infos[$id]['extra'] : "";
$d_primary=$d_unique=$d_index=$d_fulltext=0;
$d_collate=(isset($_GET['editfield'])) ? $fields_infos[$id]['collate'] : "";
$d_comment=(isset($_GET['editfield'])) ? $fields_infos[$id]['comment'] : "";
$d_privileges=(isset($_GET['editfield'])) ? $fields_infos[$id]['privileges'] : "";
if(isset($_GET['editfield'])) {
$d_primary=(isset($fields_infos['_primarykey_']) && $fields_infos['_primarykey_']==$fields_infos[$id]['name']) ? 1 : 0;
if(isset($fields_infos['_key_'])) {
for($i=0;$i';
if (isset($_GET['editfield'])) echo '';
if(isset($_POST['newtablesubmit'])) echo '';
echo '';
echo '';
echo ' ';
} else
echo ''.$lang['sql_insertnewfield'].'
';
//Felder ausgeben
echo '';
for($i=0;$i<$anz_fields;$i++) {
$cl= ($i % 2) ? "dbrow" : "dbrow1";
if($i==0) echo '| | Field | Type | Size | NULL | Key | Attribute | Default | Extra | Sortierung |
|---|
';
echo '';
echo ' ';
echo ' ';
echo ' | '.$fields_infos[$i]['name'].' | '.$fields_infos[$i]['type'].' | '.$fields_infos[$i]['size'].' | ';
echo ''.$fields_infos[$i]['null'].' | ';
//key
if($fields_infos['_primarykey_']==$fields_infos[$i]['name']) echo ' ';
if(isset($fields_infos['_fulltextkey_'])) {
for($ii=0;$ii'; break;
}
}
}
if(isset($fields_infos['_uniquekey_'])) {
for($ii=0;$ii'; break;
}
}
}
if(isset($fields_infos['_key_'])) {
for($ii=0;$ii".$fields_infos['_key_'][$ii]['columns']."";
if($fields_infos['_key_'][$ii]['name']==$fields_infos[$i]['name']) {
echo ' '; break;
}
}
}
echo ' | '.$fields_infos[$i]['attribut'].' | ';
echo ''.$fields_infos[$i]['default'].' | '.$td.$fields_infos[$i]['extra'].'';
echo ''.((MSD_NEW_VERSION) ? $fields_infos[$i]['collate'] : " ").' | ';
}
echo '
';
echo ''.$lang['sql_tableindexes'].' `'.$table_edit_name.'`';
echo '| | Index-Name | '.((MSD_NEW_VERSION) ? 'Typ | ' : '').''.$lang['sql_allowdups'].' | '.$lang['sql_cardinality'].' | Spalten |
|---|
';
$sqlk="SHOW KEYS FROM `".$databases['Name'][$dbid]."`.`$table_edit_name`;";
$res=MSD_query($sqlk) or die(SQLError($sqlk,mysql_error()));
$num=mysql_numrows($res);
if($num==0) {
echo '| '.$lang['sql_tablenoindexes'].' | ';
} else {
for($i=0;$i<$num;$i++) {
$row=mysql_fetch_array($res);
$cl= ($i % 2) ? "dbrow" : "dbrow1";
//Images
echo '| | ';
echo ''.$row['Key_name'].' | ';
if(MSD_NEW_VERSION) echo ''.$row['Index_type'].' | ';
echo ''.(($row['Non_unique']==1) ? $lang['yes']: $lang['no']).' | ';
echo ''.(($row['Cardinality']>=0) ? $row['Cardinality'] : "keine").' | ';
echo ''.$row['Column_name'].' | ';
echo ' ';
}
}
echo '
';
echo '
';print_r($fields_infos);echo ' ';*/
}
?>
| !['.$lang['sql_enumsethelp'].']('.$config['files']['iconpath'].'help16.gif "'.$lang['sql_enumsethelp'].'"){kind=small}
';
echo '
';
echo '