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);