?> <table width="640" border="1"> <tr> <th scope="col" colspan="5">Manage Websites </th> </tr> <tr align="center"><td width="20%"> <form name="wordlist" action="" method="post"> <input type="submit" name='addsite' value="Add Website" onclick="this.value=prompt('Please Enter the New Website:','http://');" > <select name='<?php echo FLD_SITE_ID; ?> ' size="18" onChange='this.form.submit();'> <OPTGROUP LABEL=" - Available Websites - "> <?php echo sp_fill_combo_conditionally("select " . FLD_SITE_ID . "," . FLD_SITE_NAME . ", if(" . FLD_SITE_ENABLE_SPIDER . ",'font-weight:bold','') as style from " . TBL_SITES . " order by " . FLD_SITE_ENABLE_SPIDER . " desc", $FLD_SITE_ID, $DB); ?> </optgroup> </select> </form> </td> <td> <?php if (is_array($edit_array)) { ?> <form name="wordlist" action="" method="post"> <input type="hidden" name="<?php echo FLD_SITE_ID; ?> " value='<?php echo $FLD_SITE_ID;
<select name='<?php echo FLD_WORD_CATEGORY_ID; ?> ' onChange='this.form.submit();'> <option>Available Categorys</option> <?php echo sp_fill_combo_conditionally("select " . FLD_WORD_CATEGORY_ID . "," . FLD_WORD_CATEGORY_CATEGORY . " from " . TBL_WORD_CATEGORY, $FLD_WORD_CATEGORY_ID, $DB); ?> </select><br> <input type="submit" name='addcat' value="Add Category" onclick="this.value=prompt('Please Enter the Category Name:','');" > <input type="submit" name='remcat' value="Remove Category"> <br/> <select name='word_cat[]' size="11" <?php echo $FLD_WORD_CATEGORY_ID > 0 ? "" : 'disabled'; ?> multiple> <OPTGROUP LABEL=" - Words in Catagory - "> <?php echo sp_fill_combo_conditionally("select wl." . FLD_WORD_ID . ", concat(" . FLD_WORD_WORD . ",' ('," . FLD_WORD_WEIGHT . ",')'), if(" . FLD_WORD_TYPE . "='required','font-weight:bold','') as style\n\tfrom " . TBL_WORD_LIST . " as wl, " . TBL_WL_WC . " as lc \n\twhere wl." . FLD_WORD_ID . " = lc. " . FLD_WORD_ID . " \n\tand lc." . FLD_WORD_CATEGORY_ID . " = '{$FLD_WORD_CATEGORY_ID}' group by " . FLD_WORD_ID, null, $DB); ?> </OPTGROUP> </select> </td> </tr> </table> </form> <p> </p>