[Text]GraphicPath=[lookup db=prefs.db&value=PRODUCT_GRAPHIC_PATH&lookInField=PREF&returnField=value][/Text]

[!]---------------------------------------------------------------------[/!]
[!]  If user change currency from Merchant page, it will update    [/!] 
[!]  automatically. WC              [/!]
[!]---------------------------------------------------------------------[/!]
[search db=prefs.db&eqPREFdatarq=CURRENCY]
  [founditems] [text show=f]Currency=[value][/text] [/founditems] 
[/search]

<tr>
<td align="right"><b>SKU/ID:</b></td>
<td  colspan="3"><input name="__SKU" value="[SKU]" size="10"></td>

<td>
<input type="submit" name="action" value="Update">
</td>

</tr>
<tr>
<td align="right"><b>Title:</b></td>
<td  colspan="3"><input name="__TITLE" value="[input][TITLE][/input]" size="30"></td>
</tr>
<tr>
<td align="right" valign="top"><b>Description:</b></td>
<td  colspan="3"><textarea name="__DESCRIPTION" rows="6" cols="40" wrap="virtual">[input][DESCRIPTION][/input]</textarea></td>
</tr>

<tr>
<td  align="right"><b>Price:</b></td>
<td>[Currency]<input name="__PRICE" value="[PRICE]" size="10"></td>

<td align="right"><b>Taxable:</b></td>
<td><select name="__TAXABLE">
<option value="T" [showif [TAXABLE]=T]selected[/showif]>Yes
<option value="F" [showif [TAXABLE]=F]selected[/showif]>No
</select></td>
</tr>

<tr>
<td align="right"><b>Weight:</b></td>
<td><input name="__WEIGHT" value="[WEIGHT]" size="4">lbs.</td>

<TD ALIGN="right" VALIGN="middle"><b>Cell Phone Special (WAP):</b></td>
<TD VALIGN="top"><select name="__WAP_ENABLED">
<option value="T" [showif [WAP_ENABLED]=T]selected[/showif]>Yes
<option value="F" [showif [WAP_ENABLED]=]selected[/showif][showif [WAP_ENABLED]=F]selected[/showif]>No
</select>
<A HREF="javascript:GetHelp('__WAP_ENABLED')"><IMG SRC="Graphics/question.gif" BORDER="0" ALIGN="top"></A>
</td>
</tr>

<tr>
<TD ALIGN="right" VALIGN="middle"><b>Electronic:</b></td>
<TD VALIGN="top"><select name="__CANEMAIL">
<option value="F" [showif [canemail]=F]selected[/showif]>No
<option value="T" [showif [canemail]=T]selected[/showif]>Yes
</select>
<A HREF="javascript:GetHelp('__CANEMAIL')"><IMG SRC="Graphics/question.gif" BORDER="0" ALIGN="top"></A>
</td>

<TD ALIGN="right" VALIGN="middle"><b>Physical:</b></td>
<TD VALIGN="top">
<select name="__CANSHIP">
<option value="T" [showif [canship]=T]selected[/showif]>Yes
<option value="F" [showif [canship]=F]selected[/showif]>No
</select>
<A HREF="javascript:GetHelp('__CANSHIP')"><IMG SRC="Graphics/question.gif" BORDER="0" ALIGN="top"></A>
</td>
</tr>

<tr>
<td align="right"><b>Quantity:</b></td>
<td><input name="__Quantity" value="[Quantity]" size="4"></td>

<TD ALIGN="right" VALIGN="middle"><b>Home Page Special:</b></td>
<TD VALIGN="top"><select name="__H_P_SPECIAL">
<option value="F" [showif [H_P_SPECIAL]=F]selected[/showif]>No
<option value="T" [showif [H_P_SPECIAL]=T]selected[/showif]>Yes
</select>
<A HREF="javascript:GetHelp('__H_P_SPECIAL')"><IMG SRC="Graphics/question.gif" BORDER="0" ALIGN="top"></A>
</td>
</tr>

[listfields db=products.db]
[showif [fieldname]~#]
<tr>
<td ALIGN="right" VALIGN="middle"><B>[getchars start=2][fieldname][/getchars]:</B></td>
<td colspan="3"><input name="__[fieldname]" value="[interpret][[fieldname]][/interpret]"></td>
</tr>
[/showif]
[/listfields]

<tr>
<td align="right"><b>Visible:</b></td>
<td><select name="__VISIBLE">
<option value="T" [showif [VISIBLE]=T]selected[/showif]>Yes
<option value="F" [showif [VISIBLE]=F]selected[/showif]>No
</select>
</td>
</tr>

<!--
<tr>
<td align="right"><b>Owner:</b></td>
<td colspan=3><select name="__OWNER">
[!]<option value="[uppercase][username][/uppercase]" [showif [url][username][/url]=[url][OWNER][/url]]selected[/showif]>[username][/!]
[search db=Users.db&eqGROUPSdatarq=[lookup db=prefs.db&lookinfield=PREF&value=ADMIN&returnfield=value]][founditems]
<option value="[user]" [showif [url][user][/url]=[url][OWNER][/url]]selected[/showif]>[user]
[/founditems][/search]
[search db=Users.db&eqGROUPSdatarq=[lookup db=prefs.db&lookinfield=PREF&value=GROUPS&returnfield=value]][founditems]
<option value="[user]" [showif [url][user][/url]=[url][OWNER][/url]]selected[/showif]>[user]
[/founditems][/search]
</select>
</td>
</tr>
-->

<tr>
  <td align=right><b>Category:</b>
  </td>
  <td>
      <INPUT TYPE="SUBMIT" NAME="Select_Category" VALUE="Select">
  </td>
</tr>

  [ListWords Words=[sections]&delimiters=+]
  <tr>
    <td><BR></td>
    <td colspan=3>
    [!]words[index] = [word]<BR>[/!]
    
    [Text]cat=[/Text]
    [Text]curr=[word][/Text]
    [loop start=1&end=10&advance=1]
      [Text]t=[lookup db=sections.db&value=[curr]&lookInField=S_ID&returnField=S_NAME&notFound=][/Text]
      [Text]maincat=[lookup db=sections.db&value=[curr]&lookInField=S_ID&returnField=S_TYPE&notFound=][/Text]
      [Text]curr=[lookup db=sections.db&value=[curr]&lookInField=S_ID&returnField=S_RELATED&notFound=][/Text]
      [Showif [t]!]
          [Text]cat=[Showif [maincat]=M]<b>[/showif][t][Showif [maincat]=M]</b>[/showif] [Showif [cat]!]<IMG SRC="Graphics/rightarrow.gif"> [cat][/Showif][/Text]
        [/Showif]
    [/loop]
    
    [cat]<BR>
    </td>
  </tr>
  [/ListWords]

</tr>

[!]---------------------------------------------------------------------[/!]
[!]  Options                                                            [/!]
[!]---------------------------------------------------------------------[/!]
[Search db=categories.db&neC_IDdata=Find_All&asC_IDsort=1&C_IDtype=num]
[Founditems]
<tr>
  <td align=right valign=top><b>[C_NAME]:</b>
  </td>
  <td colspan=3>
      <TABLE BGCOLOR="#FFFFCC" border=0 cellpadding= cellspacing= >
      <TR>
        
        [Showif [C_CART]!]
          <TD bgcolor="#006666" align=center><FONT face="Verdana, Helvetica, Sans-serif" color=white size="-1">Description</FONT></TD>
        [/Showif]
        [Showif [C_CART]=]
          <TD bgcolor="#006666" align=center><FONT face="Verdana, Helvetica, Sans-serif" color=white size="-1">SKU</FONT></TD>
        [/Showif]
          
        [Showif [C_OVERRIDE]=Y]
          <TD bgcolor="#006666" align=center><FONT face="Verdana, Helvetica, Sans-serif" color=white size="-1">Ovr. Price</FONT></TD>
          <TD bgcolor="#006666" align=center><FONT face="Verdana, Helvetica, Sans-serif" color=white size="-1">Ovr. SKU</FONT></TD>
        [/Showif]
        <TD bgcolor="#006666" align=center><FONT face="Verdana, Helvetica, Sans-serif" color=white size="-1">Rank</FONT></TD>
        <TD bgcolor="#006666" align=center><FONT face="Verdana, Helvetica, Sans-serif" color=white size="-1">Add/Delete</FONT></TD>
        
      </TR>

    [Search db=related.db&eqR_CATEGORYdatarq=[C_ID]&eqR_SKUdatarq=[sku]&asR_RANKsort=1&asR_NAMEsort=2]
    [Founditems]        
      <TR>
        <TD>
          <input type="text" name="EDITDESC_[R_ID]" value="[R_NAME]" size="10">
        </TD>
        [Showif [C_OVERRIDE]=Y]
          <TD>
          <input type="text" name="EDITPRICE_[R_ID]" value="[R_OVR_PRICE]" size="10">
          </TD>
          <TD>
          <input type="text" name="EDITSKU_[R_ID]" value="[R_OVR_SKU]" size="10">
          </TD>
        [/Showif]
        <TD>
        <input type="text" name="EDITRANK_[R_ID]" value="[R_RANK]" size="2">
        </TD>
        <TD>
        <INPUT TYPE="SUBMIT" NAME="DELOPTION_[R_ID]" VALUE="Delete">
        </TD>
      </TR>
    [/Founditems]
    [/Search]
    
      <TR>
        <TD>
          <input type="text" name="ADDDESC_[C_ID]" value="" size="10">
        </TD>
        [Showif [C_OVERRIDE]=Y]
          <TD>
          <input type="text" name="ADDPRICE_[C_ID]" value="" size="10">
          </TD>
          <TD>
          <input type="text" name="ADDSKU_[C_ID]" value="" size="10">
          </TD>
        [/Showif]
        <TD>
        <input type="text" name="ADDRANK_[C_ID]" value="" size="2">
        </TD>
        <TD>
        <INPUT TYPE="hidden" NAME="ADDCTYPE_[C_ID]" VALUE="[C_TYPE]">
        <INPUT TYPE="SUBMIT" NAME="AddOption_New" VALUE="Add New">
        </TD>
      </TR>
    </TABLE>
  </td>
</tr>
[/Founditems]
[/Search]
[!]---------------------------------------------------------------------[/!]
[!]  Options                                                            [/!]
[!]---------------------------------------------------------------------[/!]

<tr><td colspan=4><HR></td></tr>
<tr>
  <td colspan=2><b>Big Picture</b><BR>
  
  [Showif [BIG_PICTURE]!]
    <IMG SRC="../[GraphicPath][url][BIG_PICTURE][/url]" border=1> <BR>
  [/Showif]

  <SELECT NAME="__BIG_PICTURE" SIZE="1">
    <OPTION [Showif [BIG_PICTURE]=]SELECTED[/Showif]>[SelectOne]
    [ListFiles ../[GraphicPath]]
    <OPTION [Showif [BIG_PICTURE]=[FileName]]SELECTED[/Showif]>[FileName]
    [/ListFiles]
  </SELECT>
  </td>

  <td colspan=2><b>Small Picture</b><BR>
  [Showif [PICTURE]!]
    <IMG SRC="../[GraphicPath][url][PICTURE][/url]" border=1> <BR>
  [/Showif]

  <SELECT NAME="__PICTURE" SIZE="1">
    <OPTION [Showif [PICTURE]=]SELECTED[/Showif]>[SelectOne]
    [ListFiles ../[GraphicPath]]
    <OPTION [Showif [PICTURE]=[FileName]]SELECTED[/Showif]>[FileName]
    [/ListFiles]
  </SELECT>

  </td>
</tr>

[!]This needs to be finished...[/!]
[showif [include file=protection.inc&owner=[url][OWNER][/url]]^A]
[/showif] [!]This is the protection one...[/!]