?>
<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>
