<cfset Request.prefix_db_lookup = "hhapowerpath" />
<cfset Request.prefix_db_agency = "prefix_db_agency_invalid" />

<cfif isDefined("URL.cron") and URL.cron eq 1>
	<cfset Request.Agency_ID = true />
</cfif>

<cfif isDefined("FORM.prefix_db_agency_id")>
	<cfif isNumeric(FORM.prefix_db_agency_id)>
		<cfset Request.prefix_db_agency = "agency_"&FORM.prefix_db_agency_id />
		<cfset Request.Agency_ID = FORM.prefix_db_agency_id />
	</cfif>

	<!--- delete agency_id to resolve conflict with cfinsert/cfupdate --->
	<cfset rc = StructDelete(FORM, "prefix_db_agency_id", "True")>
<cfelseif isDefined("URL.prefix_db_agency_id") or isDefined("URL.passthrough_data")>
	<cfif isDefined("URL.passthrough_data") and URL.passthrough_data neq "">
		<cfset ptd = listToArray(#URL.passthrough_data#, "||", false, true) />

		<cfloop from="1" to="#arrayLen(ptd)#" index="i">
			<cfset key = gettoken(ptd[i],1,"|") />
			<cfset value = gettoken(ptd[i],2,"|") />

			<cfif key eq "prefix_db_agency_id">
				<cfset Request.prefix_db_agency = "agency_"&value />
				<cfset Request.Agency_ID = value />
				<cfset Request.agency_found = true />
			</cfif>
		</cfloop>
	<cfelse>
		<cfif isNumeric(URL.prefix_db_agency_id)>
			<cfquery name="get_Agency" datasource='#Application.DataSrc#'>
				SELECT agency_id FROM Agency WHERE agency_id = #URL.prefix_db_agency_id# or agency_login = #URL.prefix_db_agency_id# limit 1
			</cfquery>

			<cfif get_Agency.RecordCount gt 0>
				<cfset Request.agency_found = true />

				<cfquery name="check_db" datasource='#Application.DataSrc#'>
					SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'agency_#get_Agency.agency_id#'
				</cfquery>

				<cfif check_db.RecordCount gt 0>
					<cfset Request.prefix_db_agency = "agency_"&get_Agency.agency_id />
					<cfset Request.Agency_ID = get_Agency.agency_id />
				</cfif>
			</cfif>
		</cfif>
	</cfif>
<cfelseif isDefined("Session.Super_AgencyId") and isDefined("FORM.Super_AgencyId")>
	<cfset Session.Super_AgencyId = FORM.Super_AgencyId />

	<cfset Request.prefix_db_agency = "agency_"&FORM.Super_AgencyId />
	<cfset Request.Agency_ID = FORM.Super_AgencyId />
<cfelseif isDefined("session.Super_AgencyId")>
	<cfset Request.prefix_db_agency = "agency_"&session.Super_AgencyId />
	<cfset Request.Agency_ID = session.Super_AgencyId />
<cfelseif isDefined("session.AgencyId")>
	<cfset Request.prefix_db_agency = "agency_"&session.AgencyId />
	<cfset Request.Agency_ID = session.AgencyId />
</cfif>

<cfif Request.prefix_db_agency eq 'agency_455'>
	<cfset table_files = Request.prefix_db_lookup&'.files_old' />
<cfelse>
	<cfset table_files = Request.prefix_db_agency&'.files' /> 
</cfif>

<!--- don't delete the following IPs comment --->
<!--- Site down under maintenance --->
<!--- <cfif isDefined("CGI.REMOTE_ADDR") and CGI.REMOTE_ADDR neq '202.142.184.114'> --->
<!--- <cfif isDefined("CGI.REMOTE_ADDR") and (CGI.REMOTE_ADDR neq '202.142.184.114' and CGI.REMOTE_ADDR neq '74.75.125.24' and CGI.REMOTE_ADDR neq '117.218.247.154')>
	<img width="" src="http://www.immigration.go.th/nov2004/under-maintenance.jpg" alt="Site down under maintenance">
	<cfabort />
</cfif> --->