select httpcharset, activatedlanguage from ECO_LANGUAGETHEME where language_id = #val(request.currentlanguage)# and activatedlanguage = 1 select httpcharset from ECO_LANGUAGETHEME where language_id = 0 ///////////////////////////////////////////////////////////////// // If the users current language isn't active reset to default // ///////////////////////////////////////////////////////////////// if (langcheck.recordcount eq 0) { variables.currentlanguage = 0; variables.charset = langdefault.httpcharset; request.currentlanguage = 0; request.charset = langdefault.httpcharset; } else { variables.charset = langcheck.httpcharset; request.charset = langcheck.httpcharset; } ///////////////////////////////////////////////////////////////// // Set Page Variables // ///////////////////////////////////////////////////////////////// variables.pagedir = getcurrenttemplatepath(); request.pagedir = getcurrenttemplatepath(); variables.binfile = getfilefrompath(variables.pagedir); request.binfile = getfilefrompath(variables.pagedir); variables.minusroot = replacenocase(variables.pagedir, request.systemroot,"","all"); request.minusroot = replacenocase(variables.pagedir, request.systemroot,"","all"); variables.callerroot = replacenocase(variables.minusroot, variables.binfile,"","all"); request.callerroot = replacenocase(variables.minusroot, variables.binfile,"","all"); variables.filenoext = replacenoCase(variables.binfile, ".cfm", "", "all"); request.filenoext = replacenoCase(variables.binfile, ".cfm", "", "all"); variables.userkeysglobal = 0; variables.contenteditor = 0; request.userkeysglobal = 0; request.contenteditor = 0; select pb.pagebaseid,pb.menudefault,pb.ismodule,pb.modulecode,pb.filename,pb.pagedirectory,pb.keyed, pb.keyid,pb.nokeybehave,pb.redirectlocation,pb.editkey,pb.deletekey,pbl.nokeymessage, pbl.statelocation,pbl.pagetitle,pbl.pagedescription,pbl.pagekeywords,pb.menudefault from ECO_PAGEBASE pb,ECO_PAGEBASELANGUAGES pbl where (pb.pagebaseid = pbl.pagebaseid and pbl.setlanguage = #request.currentlanguage#) and (pb.filename = '#trim(request.binfile)#' and pb.pagedirectory like '#trim(request.callerroot)#') select editkey,deletekey,createkey,newpagekey,deletepagekey,editpagekey from ECO_PAGEBASEDIRECTORIES where directorybase like '#trim(request.callerroot)#' select accountcreated, login_id, company_name, first_name, middle_int, last_name, emailaddress,dob, show_dob, show_age, usergender, useraddress, usercity, userstate, userzip, usercountry, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16, field17, field18, field19, field20, field21, field22, field23, field24, setlanguage, timezone, previous_ip, last_ip, previous_login, last_login, state_time, state_location, passgroup, passkeys, session_hash from ECO_MEMBERS where member_id = #val(cookie.member_id)# update ECO_MEMBERS set state_time = #now()#, state_location = '#pageproperty.statelocation#' where member_id = #val(cookie.member_id)# select pass_key from ECO_PASSRELATIONS where pass_group = #memberglobal.passgroup# if (listlen(valuelist(mengroup.pass_key))) { variables.userkeysglobal = listappend(variables.userkeysglobal, valuelist(mengroup.pass_key)); request.userkeysglobal = listappend(request.userkeysglobal, valuelist(mengroup.pass_key)); } if (len(memberglobal.passkeys)) { variables.userkeysglobal = listappend(variables.userkeysglobal, memberglobal.passkeys); request.userkeysglobal = listappend(request.userkeysglobal, memberglobal.passkeys); } if (listfind(variables.userkeysglobal,pageproperty.editkey)) { variables.contenteditor = 1; request.contenteditor = 1; } if (listfind(variables.userkeysglobal,pageproperty.deletekey)) { variables.contenteditor = 1; request.contenteditor = 1; } if (listfind(variables.userkeysglobal,dirproperty.editkey)) { variables.contenteditor = 1; request.contenteditor = 1; } if (listfind(variables.userkeysglobal,dirproperty.deletekey)) { variables.contenteditor = 1; request.contenteditor = 1; } if (listfind(variables.userkeysglobal,dirproperty.createkey)) { variables.contenteditor = 1; request.contenteditor = 1; } if (listfind(variables.userkeysglobal,dirproperty.newpagekey)) { variables.contenteditor = 1; request.contenteditor = 1; } if (listfind(variables.userkeysglobal,dirproperty.deletepagekey)) { variables.contenteditor = 1; request.contenteditor = 1; } if (listfind(variables.userkeysglobal,dirproperty.editpagekey)) { variables.contenteditor = 1; request.contenteditor = 1; } select customtagtype,tagfilename,moduledirectory,mytag from ECO_CUSTOMTAGS temp = structinsert(request.ctstruct, "ctag:#listct.customtagtype#filename", listct.tagfilename); temp = structinsert(request.ctstruct, "ctag:#listct.customtagtype#dir", listct.moduledirectory); temp = structinsert(request.ctstruct, "ctag:#listct.customtagtype#mytag", listct.mytag); select menufragid, passkey, menufragmentname, menuhorizontal, divider, dividerimage, dividersymbol, tablewidth, tableborder, tablebordercolor, tablecellcolor, tablecellpadding, tablealign from ECO_MENUFRAGMENT order by menufragid select menuid, menuname, menucode, menutype, menuorder, menupath, passkey, reaction, showif, rollover, isimg, popup, windowwidth, windowheight, extraattrib, tdextraattrib, pextraattrib, leftmargin, rightmargin, popupprops, autosize from ECO_MENU where menufragmentid = #listmf.menufragid# and languageset = #request.currentlanguage# order by menuorder asc temp = structinsert(request.menustruct, "menu#listmenu.menuid#:id", listmenu.menuid); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:name", listmenu.menuname); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:code", listmenu.menucode); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:type", listmenu.menutype); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:path", listmenu.menupath); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:passkey", listmenu.passkey); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:reaction", listmenu.reaction); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:showif", listmenu.showif); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:isroll", listmenu.rollover); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:isimg", listmenu.isimg); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:ispopup", listmenu.popup); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:wwidth", listmenu.windowwidth); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:wheight", listmenu.windowheight); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:tdextras", listmenu.tdextraattrib); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:pextras", listmenu.pextraattrib); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:extras", listmenu.extraattrib); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:leftmargin", listmenu.leftmargin); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:rightmargin", listmenu.rightmargin); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:popupprops", listmenu.popupprops); temp = structinsert(request.menustruct, "menu#listmenu.menuid#:autosize", listmenu.autosize); variables.olist = listappend(variables.olist, listmenu.menuid); temp = structinsert(request.menustruct, "frag:#listmf.menufragid#", listmf.menufragmentname); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#id", listmf.menufragid); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#passkey", listmf.passkey); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#olist", variables.olist); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#icount", listlen(variables.olist)); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#ishorz", listmf.menuhorizontal); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#showdivider", listmf.divider); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#isdividerimg", listmf.dividerimage); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#dividersymbol", listmf.dividersymbol); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#tablewidth", listmf.tablewidth); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#tableborder", listmf.tableborder); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#tablebordercolor", listmf.tablebordercolor); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#tablecellcolor", listmf.tablecellcolor); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#tablecellpadding", listmf.tablecellpadding); temp = structinsert(request.menustruct, "frag:#listmf.menufragmentname#tablealign", listmf.tablealign);