<% ' Comersus BackOffice Lite ' e-commerce ASP Open Source ' Comersus Open Technologies LC ' 2005 ' http://www.comersus.com %> <% on error resume next dim mySQL, conntemp, rstemp mySQL="SELECT idSettingGroup, idSetting, settingKey, settingValue, comments FROM settings ORDER by idSettingGroup, idSetting " call getFromDatabase(mySQL, rstemp, "comersus_backoffice_settingsform.asp") if rstemp.eof then response.redirect "comersus_backoffice_message.asp?message="& Server.Urlencode("Empty settings table. ") end if %>

Settings

<% pPrevGroup ="" do while not rstemp.eof if trim(pPrevGroup) <> trim(rstemp("idSettingGroup")) then pPrevGroup = rstemp("idSettingGroup") Select Case pPrevGroup Case 1: pGroupName = "Company" Case 2: pGroupName = "Email" Case 3: pGroupName = "Shipment" Case 4: pGroupName = "Payment" Case 5: pGroupName = "PowerPack" Case 6: pGroupName = "Cart Behavior" Case 7: pGroupName = "Prefixes" Case 8: pGroupName = "Stock" Case 9: pGroupName = "Date" Case 10: pGroupName = "Currency" Case 11: pGroupName = "Customer" Case 12: pGroupName = "Fraud Prevention" Case 13: pGroupName = "Digital Goods" Case 14: pGroupName = "Taxes" Case 15: pGroupName = "Other" End Select pGroupName = pGroupName & " Settings" %> <% end if if rstemp("settingKey")="pStoreFrontDemoMode" _ or trim(rstemp("settingKey"))="pRunInstallationWizard" _ or trim(rstemp("settingKey"))="pCompareWithAmazon" _ or trim(rstemp("settingKey"))="pDisableState" _ or trim(rstemp("settingKey"))="pSuppliersList" _ or trim(rstemp("settingKey"))="pShowNews" _ or trim(rstemp("settingKey"))="pShowCategories" _ or trim(rstemp("settingKey"))="pShowSearchBox" _ or trim(rstemp("settingKey"))="pShowSuppliersList" _ or trim(rstemp("settingKey"))="pShowAddedToday" _ or trim(rstemp("settingKey"))="pAutogenerateNews" _ or trim(rstemp("settingKey"))="pEmailNoStock" _ or trim(rstemp("settingKey"))="pEnableCustomerTracking" _ or trim(rstemp("settingKey"))="pUseVatNumber" _ or trim(rstemp("settingKey"))="pPayPalExpressCheckout" _ or trim(rstemp("settingKey"))="pDateSwitch" _ or trim(rstemp("settingKey"))="pTaxIncluded" _ or trim(rstemp("settingKey"))="pRssFeedServer" _ or trim(rstemp("settingKey"))="pSecureStoreGraph" then %> <% elseif rstemp("settingKey")="pCompany" then %> <% elseif rstemp("settingKey")="pCompanyAddress" then %> <% elseif rstemp("settingKey")="pCompanyZip" then %> <% elseif rstemp("settingKey")="pCompanyCity" then %> <% elseif rstemp("settingKey")="pCompanyStateCode" then %> <% elseif rstemp("settingKey")="pCompanyCountryCode" then %> <% elseif rstemp("settingKey")="pCompanyPhone" then %> <% elseif rstemp("settingKey")="pCompanyFax" then %> <% elseif rstemp("settingKey")="pCompanyLogo" then %> <% elseif rstemp("settingKey")="pCartQuantityLimit" then %> <% elseif rstemp("settingKey")="pMaxAddCartQuantity" then %> <% elseif rstemp("settingKey")="pOrderPrefix" then %> <% elseif rstemp("settingKey")="pCustomerPrefix" then %> <% elseif rstemp("settingKey")="pEmailAdmin" then %> <% elseif rstemp("settingKey")="pEmailSender" then %> <% elseif rstemp("settingKey")="pSmtpServer" then %> <% elseif rstemp("settingKey")="pDebugEmail" then %> <% elseif rstemp("settingKey")="pEmailComponent" then %> <% elseif rstemp("settingKey")="pUnderStockBehavior" then %> <% elseif rstemp("settingKey")="pIdStore" then %> <% elseif rstemp("settingKey")="pShowStockView" then %> <% elseif rstemp("settingKey")="pCurrencySign" then %> <% elseif rstemp("settingKey")="pDecimalSign" then %> <% elseif rstemp("settingKey")="pDateFormat" then %> <% elseif rstemp("settingKey")="pDefaultLanguage" then %> <% elseif rstemp("settingKey")="pUseShippingAddress" then %> <% elseif rstemp("settingKey")="pRandomPassword" then %> <% elseif rstemp("settingKey")="pMinimumPurchase" then %> <% elseif rstemp("settingKey")="pAllowNewCustomer" then %> <% elseif rstemp("settingKey")="pStoreLocation" then %> <% elseif rstemp("settingKey")="pForceSelectOptionals" then %> <% elseif rstemp("settingKey")="pEncryptionPassword" then %> <% elseif rstemp("settingKey")="pWishList" then %> <% elseif rstemp("settingKey")="pIndexVisitsCounter" then %> <% elseif rstemp("settingKey")="pShowBtoBPrice" then %> <% elseif rstemp("settingKey")="pStoreNews" then %> <% elseif rstemp("settingKey")="pUseEncryptedTotal" then %> <% elseif rstemp("settingKey")="pForgotPassword" then %> <% elseif rstemp("settingKey")="pListBestSellers" then %> <% elseif rstemp("settingKey")="pRelatedProducts" then %> <% elseif rstemp("settingKey")="pGetRelatedProductsLimit" then %> <% elseif rstemp("settingKey")="pProductReviews" then %> <% elseif rstemp("settingKey")="pProductReviewsAutoActive" then %> <% elseif rstemp("settingKey")="pEmailToFriend" then %> <% elseif rstemp("settingKey")="pNewsLetter" then %> <% elseif rstemp("settingKey")="pGiftRandom" then %> <% elseif rstemp("settingKey")="pPercentageToDiscount" then %> <% elseif rstemp("settingKey")="pAuctions" then %> <% elseif rstemp("settingKey")="pRealTimeShipping" then %> <% elseif rstemp("settingKey")="pUpsDefaultFee" then %> <% elseif rstemp("settingKey")="pUpsDefaultServiceType" then %> <% elseif rstemp("settingKey")="pUSPSDefaultServiceType" then %> <% elseif rstemp("settingKey")="pUSPSDefaultFee" then %> <% elseif rstemp("settingKey")="pPriceList" then %> <% elseif rstemp("settingKey")="pSendPlainText" then %> <% elseif rstemp("settingKey")="pCurrencyConversion" then %> <% elseif rstemp("settingKey")="pOneStepCheckout" then %> <% elseif rstemp("settingKey")="pPayPalMerchantEmail" then %> <% elseif rstemp("settingKey")="pRowsShown" then %> <% elseif rstemp("settingKey")="pPriceListShowStock" then %> <% elseif rstemp("settingKey")="pFraudPreventionMode" then %> <% elseif rstemp("settingKey")="pDownloadGoodsType" then %> <% elseif rstemp("settingKey")="pFraudPreventionSmallField" then %> <% elseif rstemp("settingKey")="pFraudPreventionPriceField" then %> <% elseif rstemp("settingKey")="pWhatsNewIdProductFrom" then %> <% elseif rstemp("settingKey")="pSerialCodeOnlyOnce" then %> <% elseif rstemp("settingKey")="pStockQuantityControl" then %> <% elseif rstemp("settingKey")="pDisableSaveOrderEmail" then %> <% elseif rstemp("settingKey")="pStoreClosed" then %> <% elseif rstemp("settingKey")="pDownloadDigitalGoods" then %> <% elseif rstemp("settingKey")="pShippingTaxable" then %> <% elseif rstemp("settingKey")="pMoneyDontRound" then %> <% elseif rstemp("settingKey")="pAllowDelayPayment" then %> <% elseif rstemp("settingKey")="pOfferBoxEnabled" then %> <% elseif rstemp("settingKey")="pCompareProducts" then %> <% elseif rstemp("settingKey")="pBoxCodeRegistration" then %> <% elseif rstemp("settingKey")="pSendDigitalGoodsByEmail" then %> <% elseif rstemp("settingKey")="pLastChanceListing" then %> <% elseif rstemp("settingKey")="pByPassShipping" then %> <% elseif rstemp("settingKey")="pUseJavaCalendar" then %> <% elseif rstemp("settingKey")="pListProductsByLetter" then %> <% elseif rstemp("settingKey")="pAffiliatesStoreFront" then %> <% elseif rstemp("settingKey")="pAffiliatesStoreFront" then %> <% elseif rstemp("settingKey")="pCookiesDetection" then %> <% elseif rstemp("settingKey")="pSearchLog" then %> <% elseif rstemp("settingKey")="pRecommendations" then %> <% elseif rstemp("settingKey")="pCategoriesAlphOrder" then %> <% elseif rstemp("settingKey")="pChangeDecimalPoint" then %> <% elseif rstemp("settingKey")="pUpsPickupType" then %> <% elseif rstemp("settingKey")="pUpsPackagingType" then %> <% elseif rstemp("settingKey")="pUpsExcludeServiceTypes" then %> <% elseif rstemp("settingKey")="pUpsResidentialAddress" then %> <% ' default for new additions else%> <% end if %> <%rstemp.movenext loop%>

<% response.write pGroupName %>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > NONE > JMAIL > JMAIL HTML > SERVEROBJECTSASPMAIL1 > SERVEROBJECTSASPMAIL2 > PERSITSASPMAIL > CDONTS > CDONTS HTML > CDOSYS WIN-2003 > BAMBOOSMTP > OCXMail > AspSmartMail > DundasMail <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > NONE > DONTADD > BACKORDER <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > . > , <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > DD/MM/YY > MM/DD/YY <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > USPS > UPS > CA > FEDEX > INTERSHIPPER > NONE
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > NONE > STATIC > DYNAMIC <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > paranoid > caution > none
<%=rstemp("settingKey")%>	"> > NONE > ASPUPLOAD > ZIP > STRONGCUBE
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" VALUE="<%=rstemp("settingValue")%>" SIZE="<%=len(rstemp("settingValue"))+5%>"> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > Daily Pickup > Customer Counter > One Time Pickup > On Call Air Pickup > Suggested Retail Rates(UPS Store) > Letter Center > Air Service Center <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > UPS Letter/Envelope > Package > UPS Tube > UPS Pak > UPS Express Box > UPS 25Kg Box > UPS 10Kg Box <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	01 (Next Day Air)" value="01" <%If Instr(rstemp("settingValue"), "01") > 0 Then response.write "Checked" %>> 02 (2nd Day Air) " value="02" <%If Instr(rstemp("settingValue"), "02") > 0 Then response.write "Checked" %>> 03 (Ground) " value="03" <%If Instr(rstemp("settingValue"), "03") > 0 Then response.write "Checked" %>> 07 (Worldwide Express) " value="07" <%If Instr(rstemp("settingValue"), "07") > 0 Then response.write "Checked" %>> 08 (Worldwide Expedited) " value="08" <%If Instr(rstemp("settingValue"), "08") > 0 Then response.write "Checked" %>> 11 (Standard) " value="11" <%If Instr(rstemp("settingValue"), "11") > 0 Then response.write "Checked" %>> 12 (3 Day Select) " value="12" <%If Instr(rstemp("settingValue"), "12") > 0 Then response.write "Checked" %>> 13 (Next Day Air Saver) " value="13" <%If Instr(rstemp("settingValue"), "13") > 0 Then response.write "Checked" %>> 14 (Next Day Air Early A.M.) " value="14" <%If Instr(rstemp("settingValue"), "14") > 0 Then response.write "Checked" %>> 54 (Worldwide Express Plus) " value="54" <%If Instr(rstemp("settingValue"), "54") > 0 Then response.write "Checked" %>> 59 (2nd Day Air A.M.) " value="59" <%If Instr(rstemp("settingValue"), "59") > 0 Then response.write "Checked" %>> 65 (Express Saver) " value="65" <%If Instr(rstemp("settingValue"), "65") > 0 Then response.write "Checked" %>> <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	"> > YES > NO <%=rstemp("comments")%>
<%=rstemp("settingKey")%>	" value="<%=rstemp("settingValue")%>"> <%=rstemp("comments")%>

<%call closeDb()%>