} else { if ($_POST['tablename'] == "") { echo $lang['specify_tbl']; } else { echo "<form action='?table=" . urlencode($_POST['tablename']) . "&action=index_create&confirm=1' method='post'>"; $num = intval($_POST['numcolumns']); $query = "PRAGMA table_info(" . $db->quote_id($_POST['tablename']) . ")"; $result = $db->selectArray($query); echo "<fieldset><legend>" . $lang['define_index'] . "</legend>"; echo "<label for='index_name'>" . $lang['index_name'] . ":</label> <input type='text' name='name' id='index_name'/><br/>"; echo "<label for='index_duplicate'>" . $lang['dup_val'] . ":</label>"; echo "<select name='duplicate' id='index_duplicate'>"; echo "<option value='yes'>" . $lang['allow'] . "</option>"; echo "<option value='no'>" . $lang['not_allow'] . "</option>"; echo "</select><br/>"; if (version_compare($db->getSQLiteVersion(), '3.8.0') >= 0) { echo "<label for='index_where'>WHERE:</label> <input type='text' name='where' id='index_where'/> " . helpLink($lang['help10']); } echo "</fieldset>"; echo "<br/>"; echo "<fieldset><legend>" . $lang['define_in_col'] . "</legend>"; for ($i = 0; $i < $num; $i++) { echo "<select name='" . $i . "_field'>"; echo "<option value=''>--" . $lang['ignore'] . "--</option>"; for ($j = 0; $j < sizeof($result); $j++) { echo "<option value='" . htmlencode($result[$j][1]) . "'>" . htmlencode($result[$j][1]) . "</option>"; } echo "</select> "; echo "<select name='" . $i . "_order'>"; echo "<option value=''></option>"; echo "<option value=' ASC'>" . $lang['asc'] . "</option>";