[protect ADMIN,[lookup db=prefs.db&lookinfield=PREF&value=ADMIN&returnfield=value]] [showif [action]=Add] [listwords words=[url][S_NAME][/url]&delimiters=%0D%0A] [hideif [url][word][/url]=] [math show=f]the_ID=[search db=sections.db&neS_IDdatarq=find_all&deS_IDsort=1&S_IDtype=number&max=1][founditems][S_ID][/founditems][/search]+1[/math] [math show=f]the_Rank=[search db=sections.db&eqS_RELATEDdatarq=[__S_RELATED]&deS_RANKsort=1&S_RANKtype=number&max=1][founditems][S_RANK][/founditems][/search]+1[/math] [append db=sections.db]S_ID=[the_ID]&S_RANK=[the_Rank]&S_NAME=[url][word][/url]&[formvariables name=__&exact=F]&[getchars start=3][name][/getchars]=[url][value][/url][/formvariables][/append] [commitdatabase db=sections.db] [/hideif] [/listwords] [/showif] [showif [action]=Update] [replace db=sections.db&eqS_IDdatarq=[s_id]][formvariables name=__&exact=F][getchars start=3][name][/getchars]=[url][value][/url]&[/formvariables][/replace] [commitdatabase db=sections.db] [/showif] [showif [action]=Delete] [include file=sections_delete.inc] [delete db=sections.db&eqS_IDdatarq=[s_id]] [commitdatabase db=sections.db] [search db=related.db&woR_NAMEdatarq=[s_id]&R_NAMEword=ww&eqR_CTYPEdatarq=S] [founditems] [text]New_Sections=[/text] [listwords words=[R_NAME]&delimiters=[url]+ [/url]] [hideif [word]=][hideif [word]=[s_id]][text]New_Sections=[new_sections][word]+[/text][/hideif][/hideif] [/listwords] [replace db=products.db&eqSKUdatarq=[url][R_SKU][/url]]sections=[url][New_Sections][/url][/replace] [commitdatabase db=products.db] [replace db=related.db&eqR_SKUdatarq=[url][R_SKU][/url]&eqR_CTYPEdatarq=S]R_NAME=[url][New_Sections][/url][/replace] [commitdatabase db=related.db] [/founditems] [/search] [/showif] [include body_tag.inc] [hideif [action]=New] [hideif [action]=Edit] [text]page_title=Categories[/text] [text]helpid=categories[/text] [include banner.inc]

[search db=sections.db&eqS_TYPEdatarq=M&S_RANKtype=number&asS_NAMEsort=1][founditems] [/founditems][/search] [S_NAME] [include file=sections_loop.inc]

New Root Category

[/hideif] [/hideif] [showif [action]=New] [text]page_title=Add New Categories[/text] [text]helpid=categories_new[/text] [include banner.inc]

[showif [type]=M] [/showif] [hideif [type]=M] [/hideif]

Name:(s) (cr's after each)

[/showif] [showif [action]=Edit] [text]page_title=Edit Category[/text] [text]helpid=categories_edit[/text] [include banner.inc]
[search db=sections.db&eqS_IDdatarq=[s_id]][founditems]

Name:
Rank:

[/founditems][/search] [/showif]