echo '<td>NULL<br><select name="f_null">' . GetOptionsCombo($feldnulls, $d_null) . '</select></td>';
echo '<td align="center">Default<br><input type="text" class="text" name="f_default" value="' . $d_default . '" size="10"></td>';
echo '<td align="center">Extra<br><select name="f_extra">' . GetOptionsCombo($feldextras, $d_extra) . '</select></td>';
echo '</tr><tr><td align="center">' . $lang['L_SQL_INDEXES'] . '<br>';
echo '<input type="radio" class="radio" name="f_index_new" id="k_no_index" value="no" ' . ($d_primary + $d_unique + $d_index + $d_fulltext == 0 ? 'checked="checked"' : '') . '>';
echo '<label for="k_no_index">' . $icon['key_nokey'] . '</label> ';
echo '<input type="radio" class="radio" name="f_index_new" id="k_primary" value="primary" ' . ($d_primary == 1 ? "checked" : "") . '>';
echo '<label for="k_primary">' . $icon['key_primary'] . '</label> ';
echo '<input type="radio" class="radio" name="f_index_new" id="k_unique" value="unique" ' . ($d_unique == 1 ? "checked" : "") . '>';
echo '<label for="k_unique">' . $icon['key_unique'] . '</label> ';
echo '<input type="radio" class="radio" name="f_index_new" id="k_index" value="index" ' . ($d_index == 1 ? "checked" : "") . '> ';
echo '<label for="k_index">' . $icon['index'] . '</label> ';
echo '<input type="checkbox" class="checkbox" name="f_indexfull" id="k_fulltext" value="1" ' . ($d_fulltext == 1 ? "checked" : "") . '>';
echo '<label for="k_fulltext">' . $icon['key_fulltext'] . '</label> </td>';
echo '<td align="center" colspan="2" >' . $lang['L_COLLATION'] . '<br><select name="f_collate">' . CollationCombo($d_collate) . '</select></td>';
echo '<td align="center">' . $lang['L_SQL_ATTRIBUTES'] . '<br><select name="f_attribut">' . AttributeCombo($d_attribute) . '</select></td>';
echo '<td align="center">' . $lang['L_SQL_ATPOSITION'] . ':<br><select name="f_position"><option value=""></option><option value="FIRST">' . $lang['L_SQL_FIRST'] . '</option>';
if ($anz_fields > 0) {
for ($i = 0; $i < $anz_fields; $i++) {
echo '<option value="AFTER `' . $fields_infos[$i]['name'] . '`">' . $lang['L_SQL_AFTER'] . ' `' . $fields_infos[$i]['name'] . '`</option>';
}
}
echo '</select></td><td align="center"><input type="submit" name="newfieldsubmit" value="' . (isset($_GET['editfield']) ? $lang['L_SQL_CHANGEFIELD'] : $lang['L_SQL_INSERTFIELD']) . '" class="Formbutton"></td></tr></table></form><p> </p>';
} else {
echo '<a style="font-size:8pt;padding-bottom:8px;" href="' . $p . '&newfield=1">' . $lang['L_SQL_INSERTNEWFIELD'] . '</a><br><br>';
}
//Felder ausgeben
echo '<table class="bdr">';
for ($i = 0; $i < $anz_fields; $i++) {
$cl = $i % 2 ? "dbrow" : "dbrow1";
if ($i == 0) {
echo '<input type="hidden" name="f_index" value="' . $d_index . '"><input type="hidden" name="f_fulltext" value="' . $d_fulltext . '">';
echo '<table class="bordersmall"><tr class="thead"><th colspan="6" align="center">' . (isset($_GET['editfield']) ? $lang['sql_editfield'] . " `" . $d_name . "`" : $lang['sql_newfield']) . '</th></tr>';
echo '<tr><td class="small">Name<br><input type="text" class="text" value="' . $d_name . '" name="f_name" size="30"></td>';
echo '<td>Type<br><select name="f_type">' . GetOptionsCombo($feldtypen, $d_type) . '</select></td>';
echo '<td>Size <img src="' . $config['files']['iconpath'] . 'help16.gif" alt="' . $lang['sql_enumsethelp'] . '" title="' . $lang['sql_enumsethelp'] . '" width="12" height="12" border="0"><br><input type="text" class="text" value="' . $d_size . '" name="f_size" size="3" maxlength="80"></td>';
echo '<td>NULL<br><select name="f_null">' . GetOptionsCombo($feldnulls, $d_null) . '</select></td>';
echo '<td align="center">Default<br><input type="text" class="text" name="f_default" value="' . $d_default . '" size="10"></td>';
echo '<td align="center">Extra<br><select name="f_extra">' . GetOptionsCombo($feldextras, $d_extra) . '</select></td>';
echo '</tr><tr><td align="center">' . $lang['sql_indexes'] . '<br>';
echo '<img src="' . $config['files']['iconpath'] . 'nokey.gif" width="12" height="13" border="0" alt="No Index"><input type="radio" class="radio" name="f_index_new" value="no" ' . ($d_primary + $d_unique + $d_index + $d_fulltext == 0 ? "checked" : "") . '> ';
echo '<img src="' . $config['files']['iconpath'] . 'primary.gif" width="12" height="13" border="0" alt="Primary Key"><input type="radio" class="radio" name="f_index_new" value="primary" ' . ($d_primary == 1 ? "checked" : "") . '> ';
echo '<img src="' . $config['files']['iconpath'] . 'unique.gif" width="13" height="12" border="0" alt="Unique Index"><input type="radio" class="radio" name="f_index_new" value="unique" ' . ($d_unique == 1 ? "checked" : "") . '> ';
echo '<img src="' . $config['files']['iconpath'] . 'key.gif" width="13" height="12" border="0" alt="Index"><input type="radio" class="radio" name="f_index_new" value="index" ' . ($d_index == 1 ? "checked" : "") . '> ';
echo '<img src="' . $config['files']['iconpath'] . 'fulltext.gif" width="13" height="12" border="0" alt="Fulltext Index"><input type="checkbox" class="checkbox" name="f_indexfull" value="1" ' . ($d_fulltext == 1 ? "checked" : "") . '> </td>';
echo '<td align="center" colspan="2" >' . $lang['collation'] . '<br><select name="f_collate">' . CollationCombo($d_collate) . '</select></td>';
echo '<td align="center">' . $lang['sql_attributes'] . '<br><select name="f_attribut">' . AttributeCombo($d_attribute) . '</select></td>';
echo '<td align="center">' . $lang['sql_atposition'] . ':<br><select name="f_position"><option value=""></option><option value="FIRST">' . $lang['sql_first'] . '</option>';
if ($anz_fields > 0) {
for ($i = 0; $i < $anz_fields; $i++) {
echo '<option value="AFTER `' . $fields_infos[$i]['name'] . '`">' . $lang['sql_after'] . ' `' . $fields_infos[$i]['name'] . '`</option>';
}
}
echo '</select></td><td align="center"><input type="submit" name="newfieldsubmit" value="' . (isset($_GET['editfield']) ? $lang['sql_changefield'] : $lang['sql_insertfield']) . '" class="SQLbutton"></td></tr></table></form><p> </p>';
} else {
echo '<a style="font-size:8pt;padding-bottom:8px;" href="' . $p . '&newfield=1">' . $lang['sql_insertnewfield'] . '</a><br><br>';
}
//Felder ausgeben
echo '<table class="bordersmall">';
for ($i = 0; $i < $anz_fields; $i++) {
$cl = $i % 2 ? "dbrow" : "dbrow1";
if ($i == 0) {