[!]-----
This code will generate static html pages for a given sku. It will generate [sku].htm
in admin/staticpages folder.
-----[/!]
[Text]StaticPagesPath=../staticpages/[/Text]
[Text]GraphicPath=..\..\[lookup db=prefs.db&value=GRAPHIC_PATH&lookInField=PREF&returnField=value][/Text]
[Text]writeTo=[StaticPagesPath][sku].htm[/Text]
[!]---------------------------------------------------------------------[/!]
[!] Generate Static HTML file [/!]
[!]---------------------------------------------------------------------[/!]
[WriteFile file=[writeTo]][UnURL]%0D%0A[/UnURL]
[UnURL]%0D%0A[/UnURL][UnURL]%0D%0A[/UnURL][UnURL]%0D%0A[/UnURL][/WriteFile]
[Text]title=[lookup db=products.db&value=[sku]&lookInField=SKU&returnField=title][/Text]
[Text]big_picture=[lookup db=products.db&value=[sku]&lookInField=SKU&returnField=big_picture][/Text]
[Text]description=[lookup db=products.db&value=[sku]&lookInField=SKU&returnField=description][/Text]
[Text]company=[lookup db=products.db&value=[sku]&lookInField=SKU&returnField=company][/Text]
[Text]weight=[lookup db=products.db&value=[sku]&lookInField=SKU&returnField=weight][/Text]
[AppendFile file=[writeTo]][UnURL]%0D%0A[/UnURL]
[!]---------------------------------------------------------------------[/!]
[!] Prev Pages Link [/!]
[!]---------------------------------------------------------------------[/!]
[Search db=products.db&lsSKUdata=[SKU]&max=1&asSKUsort=1][Founditems]Previous Product
[UnURL]%0D%0A[/UnURL][/Founditems][/Search]
[!]---------------------------------------------------------------------[/!]
[!] Next Pages Link [/!]
[!]---------------------------------------------------------------------[/!]
[Search db=products.db&grSKUdata=[SKU]&max=1&asSKUsort=1][Founditems]Next Product
[UnURL]%0D%0A[/UnURL][/Founditems][/Search]
[/AppendFile]