Search

SELECT DISTINCT ACA.int_actor_type_id
			FROM tbl_access_control_rules ACR
			INNER JOIN tbl_access_control_allow ACA ON ACR.int_access_rule_id = ACA.int_access_rule_id
			WHERE
				
					str_fuse_action LIKE ? 
				AND ISNULL(ACA.int_actor_type_id,'')<>''
				AND ACA.bit_allow = 1

SET NOCOUNT ON

	DECLARE @UsesRefundRequest CHAR(1)

	SET @UsesRefundRequest = 0
	SET @UsesRefundRequest = (
			SELECT 1
			FROM RefundPaymentMethods
			WHERE RefundPaymentMethodID = 7
				AND STATUS = 'A'
			)

	SELECT TOP 1 rg.RegionID
		, rg.NAME
		, rg.Address1
		, rg.Address2
		, rtrim(rg.City) + ', ' + rg.STATE + '  ' + rg.Zip AS CSZ
		, rg.Phone1
		, rg.SiteTitle
		, rg.Footer
		/**/
		, rg.prefooter
		, rg.brandingfooter
		/**/
		, rg.MetaText
		, rg.EmailAux4
		, IsNull((
				SELECT Fee
				FROM Products
				WHERE Code = 'REGFEE'
					AND STATUS = 'A'
					AND RegionID = rg.RegionID
				), 0.00) AS RegistrationFee
		, IsNull((
				SELECT Fee
				FROM Products
				WHERE Code = 'DEFERRED_PAYMENT_FEE'
					AND STATUS = 'A'
					AND RegionID = rg.RegionID
				), 0.00) AS deferred_payment_fee
		, fc.*
		, @UsesRefundRequest AS UsesRefundRequest
		, rg.privacy_data_mask_id
		, rg.str_google_verify
		, rg.str_yahoo_verify
		, rg.str_hubspot_portal_id
		, rg.str_hubspot_salog_version
		, rg.str_hubspot_ppa
		, rg.str_genoo_api_key
		, rg.str_genoo_tracking_code
		, rg.TimeZoneHourAdjustment
		/**/
		/**/
		/**/
		, e.str_erp_name
		/**/
		/**/
		, CAST(DecryptByKeyAutoCert(cert_id('LumensCert'), NULL, ec.varbin_erp_password) AS NVARCHAR(500)) AS str_erp_password_decrypted
		/**/
		/**/
		, rg.theURL
		, rg.URLText
		, rg.str_analytics_linked_domains
		, rg.GTMContainerID
		, rg.str_social_media_sharing
		, ec.*
		, (
			SELECT TOP 1 Description
			FROM PaymentMethods
			WHERE PaymentMethodID >= 200
				AND STATUS = 'A'
		) AS str_internal_payment_method_name
	FROM FeatureConfiguration fc
	INNER JOIN Regions rg ON fc.RegionID = rg.RegionID
	LEFT JOIN tbl_erp e ON fc.int_erp_id = e.int_erp_id
	LEFT JOIN tbl_erp_config ec ON ec.str_erp_url <> ''
	WHERE rg.STATUS = 'A'

SELECT regionId,orgID
				FROM featureConfigurationQry
				WHERE baseurl LIKE '%v8testing7.augusoft.net%'

SET NOCOUNT ON

			SELECT OrgID
				, RegionID
				, MenuItemID
				, MenuItemType
				, MainLevel
				, SubLevel
				
				,MainLevelSortOrder
				, SubLevelSortOrder
				, 
					SiteURL
				
				, AccessLevel
				, IsNull(DisplayCriteria_1, '') AS DisplayCriteria_1
				
				, IsNull(DisplayValue_1, '') AS DisplayValue_1
				, IsNull(DisplayCriteria_2, '') AS DisplayCriteria_2
				, IsNull(DisplayValue_2, '') AS DisplayValue_2
				, Condition
				, LTRIM(RTRIM(IsNull(NewWindowName, ''))) AS NewWindowName
				, m.Label AS UniqueLable
				
				, CASE
					WHEN str_user_nav_label IS NULL
						THEN CASE
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9440'
									THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Membership', 'Membership')
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9620'
									THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Member', 'Member')
										/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'Donate'
									THEN Replace(m.Label, 'Donate', 'Support OLLI-UHM')
										/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'MERCHANDISE'
									THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
								WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
									THEN Replace(m.Label, 'Scholarships', 'Scholarship')
								ELSE Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"')
								END
					ELSE
						/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
						CASE
							WHEN str_menu_label LIKE 'Donate'
								THEN (str_user_nav_label)
							ELSE str_user_nav_label
							END
						/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
					END AS Label
				
				, CASE
					WHEN str_user_nav_label IS NULL
						THEN CASE
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9440'
									THEN Replace(m.Label, 'Membership', 'Membership')
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9620'
									THEN Replace(m.Label, 'Member', 'Member')
									/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'Donate'
									THEN Replace(m.Label, 'Donate', 'Support OLLI-UHM')
									/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'MERCHANDISE'
									THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
								WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
									THEN Replace(m.Label, 'Scholarships', 'Scholarship')
								ELSE m.Label
								END
					ELSE
						/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
						CASE
							WHEN str_menu_label LIKE 'Donate'
								THEN dbo.fun_strip_html((str_user_nav_label))
							ELSE dbo.fun_strip_html(str_user_nav_label)
							END
						/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
					END AS LabelNoHTML 
				
				, ISNULL(int_parent_id,0) as int_parent_id
				, int_sort_order
				, m.UniqueLabel
				, m.bit_default_behavior
			FROM MenuItems m
			LEFT JOIN tbl_user_nav_menu_label u ON m.MenuItemID = u.int_menu_item_id
			WHERE STATUS = 'A'
				AND SubCategoryID IS NULL
				AND (
					
						int_actor_type_id = ?
						OR
						(
							int_actor_type_id IS NULL
							AND AccessLevel = ?
						)
					
				)
				
				AND ISNULL(SiteURL, '') NOT LIKE 'index.cfm?fuseaction=1010' /*29 MAY 2012 NEO 00043 TRACKER 29863*/
				
			ORDER BY int_sort_order

SET ANSI_NULLS ON

		SELECT IsNull((
					CASE
						WHEN str_dashboard_name = ''
							THEN NULL
						ELSE str_dashboard_name
						END
					), CASE
					WHEN ActorTypeID = 55
						THEN 'Dashboard'
					ELSE 'my dashboard'
					END) AS str_dashboard_name /* 02 APRIL 2014 NEO 0088 TRACKER 40005 */
		FROM ActorTypes
		WHERE ActorTypeID = ?

SELECT pfo.int_order
				, pf.str_field_display_name
				, pf.str_field_name
				, pfo.int_profile_field_tab_id
				, pf.str_actor_types
				, pf.chr_field_type
			FROM tbl_profile_field_order pfo
			INNER JOIN tbl_profile_field pf ON pfo.int_profile_field_id = pf.int_profile_field_id
			WHERE pf.int_region_id = ?
				AND bit_enabled = ?
				AND
				(
					(
						pf.chr_field_type not in ('C','O')
					)
					
						OR
						(
							pf.chr_field_type in ('C','O') AND
							(
								pf.str_actor_types LIKE ? 
							)
						)
					
				)
			ORDER BY pfo.int_profile_field_tab_id
				, pfo.int_order ASC

select * from tbl_social_media_details WHERE int_region_id = ?
			order by int_order asc

select * from UIVariables where RegionID = ?

SELECT menitms.SiteURL AS nav_site_url
			, menitms.label AS nav_label
			, menitms.rowNum
			, COUNT(menitms.rowNum) OVER () AS Total_Rows
			, menitms.DisplayCriteria_1
			, menitms.DisplayValue_1
			, menitms.DisplayCriteria_2
			, menitms.DisplayValue_2
			, menitms.Condition
			, menitms.NewWindowName
		FROM (
			SELECT SiteURL
				, label
				, DisplayCriteria_1
				, DisplayValue_1
				, DisplayCriteria_2
				, DisplayValue_2
				, Condition
				, Row_Number() OVER (
					ORDER BY MenuitemID ASC
					) AS rowNum
				, NewWindowName
			FROM MenuItems
			WHERE AccessLevel 
			
					= ? 
			
				AND RegionID = ?
			AND bit_display_in_nav=1
				AND STATUS = ?
				
	) menitms

SELECT menitms.SiteURL
			, menitms.label
			, menitms.AccessLevel
			, menitms.rowNum
			, ((rowNum - 1) / 4) + 1 AS block
			, menitms.DisplayCriteria_1
			, menitms.DisplayValue_1
			, menitms.DisplayCriteria_2
			, menitms.DisplayValue_2
			, menitms.Condition
			, menitms.NewWindowName
		FROM (
			SELECT SiteURL
				, label
				, AccessLevel
				, DisplayCriteria_1
				, DisplayValue_1
				, DisplayCriteria_2
				, DisplayValue_2
				, Condition
				, Row_Number() OVER (
					ORDER BY MenuitemID ASC
					) AS rowNum
				, NewWindowName
			FROM MenuItems
			WHERE AccessLevel
			
			
					= ? 
			
				AND RegionID = ?
			AND bit_display_in_footer=1
				AND STATUS = ?
				
	) menitms

DECLARE @currentTime DATETIME2 = ?
				UPDATE tbl_cart_class_detail
				SET EnteredDate = @currentTime
				WHERE SessionID = ?;
				UPDATE tbl_cart_merchandise_detail
				SET EnteredDate = @currentTime
				WHERE SessionID = ?;

DECLARE @expireRequestsAfter DATETIME2 = ?;
						DELETE FROM tbl_cart_class_detail WHERE EnteredDate <= @expireRequestsAfter;
						DELETE FROM tbl_cart_merchandise_detail WHERE EnteredDate <= @expireRequestsAfter;

SELECT str_header_script
				, str_footer_script
			FROM tbl_style_settings WITH (NOLOCK)
			-- WHERE int_region_id = Commented as long as multiple regions are not there

select * from UIVariables where RegionID = ?

select * from qTempMenu where MenuItemID NOT IN  (510)

select * from qSocialMedia order by int_order desc

SELECT isNull(str_user_nav_label,'') AS str_menu_label
		FROM tbl_user_nav_menu_label
		WHERE int_actor_type_id = ?
		AND str_menu_label LIKE 'DONATE'
		AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';

SELECT isNull(str_user_nav_label,'') AS str_menu_label
		FROM tbl_user_nav_menu_label
		WHERE int_actor_type_id = ?
		AND str_menu_label LIKE 'DONATE'
		AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';

SELECT isNull(str_user_nav_label,'') AS str_menu_label
		FROM tbl_user_nav_menu_label
		WHERE int_actor_type_id = ?
		AND str_menu_label LIKE 'DONATE'
		AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

select * from qMenu where int_parent_id = 597

select * from qMenu where int_parent_id = 525

select * from qMenu where int_parent_id = 598

select * from qMenu where int_parent_id = 595

select * from qMenu where int_parent_id = 596

select * from qMenu where int_parent_id = 503

select * from qMenu where int_parent_id = 2

select * from qMenu where int_parent_id = 5

select * from qMenu where int_parent_id = 6

select * from qMenu where int_parent_id = 7

SELECT OrgID, RegionID, CustomizationID, rtrim(ltrim(FuseAction)) as fuseAction, Status, 
	CASE Status When 'A' Then 'Active' When 'I' Then 'Inactive' END AS StatusDesc,
	CreateDate, CustomizationName, CustomizationDesc
	FROM Customizations c
	WHERE Status = 'A'
	AND RegionID = 1
	Order By Status, Fuseaction

SELECT ContentID
		, OrgID
		, RegionID
		, Section
		, Path
		, Contents
		, ContentsNoHTML
		, Description
		, Name
		, emailTemplate
		, str_default_condition
		, str_page_title
		, str_meta_description
		, str_keywords
	FROM Contents
	WHERE Path = ?
		AND	orgid = ?
		AND	regionid= ?

SELECT asf.str_field_display_name
				, asf.int_advanced_search_field_id
				, asf.int_order
				, CASE asf.chr_field_type
					WHEN 'S'
						THEN 'Standard'
					WHEN 'C'
						THEN 'Custom'
					WHEN 'O'
						THEN 'Optional'
					END AS str_field_type
				, asf.str_field_name
				, asf.bit_is_customized
				, asf.str_original_field_display_name
				, asf.int_form_field_type_id
				, fft.description
				, CASE
					WHEN asf.int_form_field_type_id NOT IN (5, 6)
						THEN CASE
								WHEN bfc.base_field_id IS NOT NULL
									THEN (
											SELECT JSON_QUERY(CONCAT (
														'['
														, STRING_AGG(CONCAT (
																'"'
																, str_search_field_value
																, '"'
																), ',') WITHIN GROUP (ORDER BY sort_order)
														, ']'
														))
											FROM (
												SELECT bfcv.str_search_field_value, MIN(bfcv.sort_order) AS sort_order
												FROM base_field_customized_value bfcv
												WHERE bfcv.base_field_id = bfc.base_field_id
													AND bfcv.is_displayed = 1
													AND NULLIF(TRIM(bfcv.str_search_field_value),'') IS NOT NULL
												GROUP BY bfcv.str_search_field_value
												) t
											)
								WHEN fc.custom_field_id IS NOT NULL
									THEN (
											SELECT JSON_QUERY(CONCAT (
														'['
														, STRING_AGG(CONCAT (
																'"'
																, str_search_field_value
																, '"'
																), ',') WITHIN GROUP (ORDER BY sort_order)
														, ']'
														))
											FROM (
												SELECT fcv.str_search_field_value, MIN(fcv.sort_order) AS sort_order
												FROM field_customized_value fcv
												WHERE fcv.custom_field_id = fc.custom_field_id
													AND fcv.is_displayed = 1
													AND NULLIF(TRIM(fcv.str_search_field_value),'') IS NOT NULL
												GROUP BY fcv.str_search_field_value
												) t
											)
								END
					END AS fieldValueOptions
			FROM tbl_advanced_search_field asf
			INNER JOIN form_field_type fft ON fft.form_field_type_id = asf.int_form_field_type_id
			LEFT JOIN base_field_customized bfc ON asf.chr_field_type = 'O'
				AND bfc.base_field = asf.str_field_name
				AND bfc.customized_base_field_id IS NULL
				AND bfc.base_table_id = 2
			LEFT JOIN field_customized fc ON fc.custom_field_id = CASE WHEN asf.chr_field_type = 'C' THEN CAST(REPLACE(asf.str_field_name, 'custom_field_', '') AS INT) END
			WHERE asf.int_region_id = ? 
					AND asf.bit_enabled = ? 
				AND asf.bit_active = 1
				
					AND asf.int_order > 0
				
			ORDER BY CASE
					WHEN asf.int_order = 0
						THEN 1000 * asf.int_default_order
					ELSE asf.int_order
					END ASC

SELECT ContentID
		, OrgID
		, RegionID
		, Section
		, Path
		, Contents
		, ContentsNoHTML
		, Description
		, Name
		, emailTemplate
		, str_default_condition
		, str_page_title
		, str_meta_description
		, str_keywords
	FROM Contents
	WHERE Path = ?
		AND	regionid= ?

SET NOCOUNT ON
	DECLARE @PhoneNumber VARCHAR(20)
		, @Email VARCHAR(255)
		, @State VARCHAR(255)
		, @City VARCHAR(255)
		, @InstructorFName VARCHAR(50)
		, @ERPID VARCHAR(20)
		, @InstructorNameSearch VARCHAR(50)
		, @ExternalCourseProviderInstructorCode VARCHAR(20)
		, @InstructorID INT
		, @Zip VARCHAR(10)

	
	

	SELECT i.OrgID
		, i.RegionID
		, i.InstructorID
		, u.ActorTypeID
		, i.LName
		, i.FName
		, u.LOGIN
		, i.InternalComments
		, i.Lname + ', ' + i.FName AS InstrName
		, i.STATUS
		, i.graphic
		/**/
		, i.Zip
		, i.Phone1
		, i.Email
		, i.STATE
		, i.City
		/**/
		, CASE i.STATUS
			WHEN 'A'
				THEN 'Active'
			WHEN 'I'
				THEN 'Inactive'
			WHEN 'T'
				THEN 'Draft'
			END AS StatusDesc
		, (
			SELECT count(ipr.Instructor_PrerequisitesID) AS PrereqCount
			FROM Instructor_Prerequisites ipr
			INNER JOIN Prerequisites prr ON prr.PrerequisiteID = ipr.PrerequisitesID
				AND prr.Display > 0
			WHERE ipr.InstructorID = i.InstructorID
				AND ipr.selected > 0
			) AS PrereqCount
		, (
			SELECT count(int_Class_ID)
			FROM tbl_class_instructor ci WITH (NOLOCK)
			INNER JOIN classes cl WITH (NOLOCK) ON ci.int_class_id = cl.classid
			WHERE cl.STATUS NOT LIKE 'X'
				AND cl.STATUS NOT LIKE 'D'
				AND ci.int_instructor_id = i.InstructorID
			) AS XUsed
		
		, (
			SELECT count(int_Class_ID)
			FROM tbl_class_instructor ci WITH (NOLOCK)
			INNER JOIN classes cl WITH (NOLOCK) ON ci.int_class_id = cl.classid
			WHERE ci.int_instructor_id = i.InstructorID
			) AS XUsedC
		
		, i.ExternalCourseProviderID
		, i.ExternalCourseProviderInstructorCode
		, i.int_record_grade_after_class_end /*BEGIN 1 NOV 2011 NEO 00043 TRACKER 26817 */
		
		, str_alt_sys_instructor_id
		, bit_sync_to_erp
		
		, (
			SELECT TOP 1 LEN(str_password) AS str_password
			FROM tbl_user_password
			WHERE int_user_id = u.UserID
			ORDER BY int_user_password_id DESC
		  ) AS HashedPasswordLen
		, u.userid
		
			, NULL AS LinkedActorType1
			, NULL AS LinkedActorType2
		
		FROM Instructors i
		INNER JOIN Users u WITH (NOLOCK) ON i.InstructorID = u.ActorID and u.ActorTypeID = 20
	
	WHERE i.RegionID = ? 
			AND i.status in ('A')
		
			AND EXISTS (
					SELECT TOP 1 1
					FROM tbl_class_instructor ci WITH (NOLOCK)
					INNER JOIN tbl_class_listing cl WITH (NOLOCK) ON ci.int_class_id = cl.classid
					WHERE ci.int_instructor_id = i.InstructorID
				)
		
	ORDER BY i.LName
		, i.FName
		, i.STATUS

SELECT DISTINCT City
	FROM Locations Loc
	INNER join tbl_classSchedules tc on tc.int_location_id = loc.locationID
	INNER JOIN Classes cl ON cl.classid = tc.classid
	WHERE Loc.RegionID = 1 
	AND Loc.Status = 'A' 
	AND cl.status IN ('A','C')
	AND Loc.City IS NOT NULL
	ORDER BY City

/**/
	SELECT Loc.LocationID
		, Loc.NAME AS LocationName
		, Loc.City AS CityName
		, Loc.STATE
	FROM Locations Loc
	/**/
	INNER JOIN vwclasslocation vcl ON vcl.LocationID = Loc.LocationID
	INNER JOIN Classes cl WITH (NOLOCK) ON Cl.classid = vcl.classid
	/**/
	WHERE Loc.RegionID = 1
		AND Loc.STATUS = 'A'
		AND cl.STATUS IN (
			'A'
			, 'C'
			)
	GROUP BY Loc.NAME
		, Loc.LocationID
		, Loc.City
		, Loc.STATE
	ORDER BY Loc.NAME

DECLARE @TimeZoneShift AS FLOAT
		SET @TimeZoneShift = IsNull((
					SELECT TimeZoneHourAdjustment
					FROM Regions WITH (NOLOCK)
					WHERE RegionID = 1
					), 0);
		SELECT TermID
			, Code
			, NAME
			, STATUS
		FROM InstructionCalendar
		WHERE 1 = 1
			AND Status IN ('A','F')
			
				AND CatalogStartDate < DateAdd(hh, @TimeZoneShift, dbo.fun_GetDateCT()) AND CatalogEndDate > DateAdd(hh, @TimeZoneShift, dbo.fun_GetDateCT())
			
		ORDER BY
			
				CatalogStartDate

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\Lumens\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=AWSALBAPP-0=AAAAAAAAAAD9HR/1Tzg/pqwbaPI+bimLJbsrx+xfXMaf+vHBFR6utEF3fA0aE5nSyqEibcDYDRGndp5o0KKsmkrxa6vo0zL67Hp4NAI55W0SP5pW+4XXwk5nq5hc1rfTaAH02jKE5fUZcw==; AWSALBAPP-1=_remove_; JSESSIONID=1EF16BE47A0360FF7F5FE1B8E0762664.cfusion; AWSALBAPP-2=_remove_; LUMPERSIST=00C9C293AD8084BA0A9CFAB481D35D11; AWSALBAPP-3=_remove_
HTTP_HOST=v8testing7.augusoft.net
HTTP_REFERER=https://v8testing7.augusoft.net/info/landing/index.cfm?fuseaction=1070
HTTP_URL=/index.cfm?fuseaction=1070
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.31.100.171
PATH_INFO=
PATH_TRANSLATED=E:\Lumens\index.cfm
QUERY_STRING=fuseaction=1070
REMOTE_ADDR=172.31.102.152
REMOTE_HOST=172.31.102.152
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=v8testing7.augusoft.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
AWSALBAPP-0=AAAAAAAAAAD9HR/1Tzg/pqwbaPI bimLJbsrx xfXMaf vHBFR6utEF3fA0aE5nSyqEibcDYDRGndp5o0KKsmkrxa6vo0zL67Hp4NAI55W0SP5pW 4XXwk5nq5hc1rfTaAH02jKE5fUZcw
AWSALBAPP-1=_remove_
AWSALBAPP-2=_remove_
AWSALBAPP-3=_remove_
JSESSIONID=1EF16BE47A0360FF7F5FE1B8E0762664.cfusion
LUMPERSIST=00C9C293AD8084BA0A9CFAB481D35D11

Session Variables:
actortypeid=90
addtoken=CFID=14082359&CFTOKEN=e8445908504fa91e-15F07F58-B5A9-2630-032EBD5E3BF088EA&jsessionid=1EF16BE47A0360FF7F5FE1B8E0762664.cfusion
allowunmaskeddata=0
appname=v8Testing7
basecfcs=versions.v81QA
basecode=/versions/v81QA
bit_canvas_failed_process=false
bit_member=0
customcct=
customcfcs=Customers.v8Testing7
customerid=495
custompath=/Customers/v8Testing7/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=v8testing7.augusoft.net
ds=v8Testing7
enabledlivechat=false
enabledsupportwidget=false
enteredsiteusingipaddress=1
foundeo_firewall_ip=3.144.230.177
foundeo_firewall_ua=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
loggedin=No
loggeduseremail=
loggeduserfname=Guest
loggeduserlname=
membershiptypeid=0
menuid=1
orgid=1
privacypolicyack=
regionid=1
sessionid=1EF16BE47A0360FF7F5FE1B8E0762664.cfusion
sitepath=/Customers/v8Testing7
sslreturnurl=https://v8testing7.augusoft.net/
stylesheetpath=/Customers/v8Testing7/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=14082359&CFTOKEN=e8445908504fa91e-15F07F58-B5A9-2630-032EBD5E3BF088EA&jsessionid=1EF16BE47A0360FF7F5FE1B8E0762664.cfusion
version=v81QA

URL Parameters:
fuseaction=1070