} 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>'; }