}
break;
case "rights":
break;
}
echo '</form></div></div><br>';
}
}
echo '<br><form action="sql.php?context=3" method="post"><input type="hidden" name="dbwantaction" value="1">';
echo '<div><table class="bdr">';
echo '<tr><td colspan="2" align="center"><strong>' . $lang['L_CREATE_DATABASE'] . '</strong></td></tr>';
echo '<tr><td>Name:</td><td><input type="text" class="text" name="db_create" size="20"></td></tr>';
echo '<tr><td>' . $lang['L_DEFAULT_CHARSET'] . ':</td><td><select name="db_default_charset">';
echo make_options($config['mysql_possible_character_sets'], get_index($config['mysql_possible_character_sets'], $config['mysql_standard_character_set']));
echo '</select></td></tr>';
echo '<tr><td>' . $lang['L_COLLATION'] . '</td><td><select name="db_collate">' . CollationCombo('', 1) . '</select></td></tr>';
echo '<tr><td colspan="2"><input type="submit" name="db_createnew" value="' . $lang['L_CREATE'] . '" class="Formbutton"></td></tr>';
echo '</table>';
echo '<br><table class="bdr">';
echo '<tr class="thead"><th>' . $lang['L_DBS'] . '</th><th>' . $lang['L_SQL_ACTIONS'] . '</th></tr>';
for ($i = 0; $i < count($databases['Name']); $i++) {
$cl = $i % 2 ? "dbrow" : "dbrow1";
echo $i == $databases['db_selected_index'] ? '<tr class="dbrowsel">' : '<tr class="' . $cl . '">';
echo '<td><a href="sql.php?db=' . $databases['Name'][$i] . '&dbid=' . $i . '">' . $databases['Name'][$i] . '</a></td>';
echo '<td nowrap="nowrap"><input type="text" class="text" name="db_rename' . $i . '" size="20">';
echo ' <select name="db_do_action_' . $i . '" onchange="db_do_' . $i . '.disabled=false;">';
echo '<option value="">-- ' . $lang['L_SQL_CHOOSEACTION'] . ' --</option>';
echo '<option value="drop">' . $lang['L_SQL_DELETEDB'] . '</option>';
echo '<option value="empty">' . $lang['L_SQL_EMPTYDB'] . '</option>';
if (MSD_NEW_VERSION) {
echo '<option value="rename">' . $lang['L_SQL_RENAMEDB'] . '</option>';
echo '<td>Size <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['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";
echo '<p class="error">' . $lang['sql_namedest_missing'] . '</p>';
} else {
echo '<input type="submit" name="dbdosubmit" value="' . $lang['do_now'] . '" class="SQLbutton">';
}
break;
case "rights":
break;
}
echo "</form></div></div><br>";
}
}
echo '<br><form action="sql.php?context=3" method="post"><input type="hidden" name="dbwantaction" value="1">';
echo '<div align="center"><table class="border">';
echo '<tr><td colspan="3" align="center"><strong>' . $lang['create_database'] . '</strong></td></tr>';
echo '<tr><td colspan="3">Name: <input type="text" class="text" name="db_create" size="20">';
echo ' ' . $lang['collation'] . ': <select name="db_collate">' . CollationCombo('', 1) . '</select> ';
echo '<input type="submit" name="db_createnew" value="' . $lang['create'] . '" class="SQLbutton"></td></tr></table>';
echo '<p> </p><table class="border">';
echo '<tr class="thead"><th>' . $lang['dbs'] . '</th><th>' . $lang['sql_actions'] . '</th></tr>';
for ($i = 0; $i < count($databases['Name']); $i++) {
$cl = $i % 2 ? "dbrow" : "dbrow1";
echo $i == $databases['db_selected_index'] ? '<tr class="dbrowsel">' : '<tr class="' . $cl . '">';
echo '<td><a href="sql.php?db=' . $databases['Name'][$i] . '&dbid=' . $i . '">' . $databases['Name'][$i] . '</a></td>';
echo '<td nowrap><input type="text" class="text" name="db_rename' . $i . '" size="20">';
echo ' <select name="db_do_action_' . $i . '" onchange="db_do_' . $i . '.disabled=false;">';
echo '<option value="">-- ' . $lang['sql_chooseaction'] . ' --</option>';
echo '<option value="drop">' . $lang['sql_deletedb'] . '</option>';
echo '<option value="empty">' . $lang['sql_emptydb'] . '</option>';
if (MSD_NEW_VERSION) {
echo '<option value="rename">' . $lang['sql_renamedb'] . '</option>';
}
