SELECT sPageName, pkiPageID 
	FROM tPages 
	WHERE fkiParent = 0 
		AND iPosition = 1 
	ORDER BY iOrder

SELECT sPageName, pkiPageID, sIncludeFile, vcContent
	FROM tPages 
	WHERE fkiParent = 0 
		AND iPosition = 0 
		AND bIsAdmin = 0 
		AND bIsMenuItem = 1
	ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 108 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 232 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 1 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 342 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 5 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 124 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 177 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 224 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 242 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 244 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT sPageName, pkiPageID,fkiParent  
			FROM tPages 
			WHERE fkiParent = 17 
				AND bIsMenuItem = 1
			ORDER BY iOrder

SELECT 
	    bIsAdmin,
		fkiParent,
		sPagename,
		sPageTitle,
		sIncludeFile,
		vcContent 
	FROM tPages 
	WHERE pkiPageID = 340

SELECT pkiPageID,sPageName FROM tPages WHERE pkiPageID = 224

Application Variables:
applicationname=u-bag.14x0x0
APPLICATIONURLPATH=/ubag.skybags365.com
BASEPATH=/home/skybagsc/public_html/ubag.skybags365.com/
BLNDEBUGMODE=false
BLNUNDERCONSTRUCTION=false
cfcLocation=CFC.FinalQuote
cfcRealLocation=CFC
DIRECTORYPATH=/home/skybagsc/public_html/ubag.skybags365.com/
DOCUMENTSFOLDER=/home/skybagsc/public_html/ubag.skybags365.com/documents
EmailAddress=info@u-bag.com
EXTRASFOLDER=/home/skybagsc
EXTRASFOLDER01=/home/skybagsc/public_html/ubag.skybags365.com
IMAGEBASEPATH=/home/skybagsc/public_html/ubag.skybags365.com/
IMAGEWEBPATH=https://www.ubag.skybags365.com/images/
PROJECTFOLDER=/home/skybagsc/public_html/ubag.skybags365.com/
ROOTCODEPATH=/home/skybagsc/
ROOTCODEPATHDEV=/home/skybagsc/code
ROOTDIR=/home/skybagsc/public_html/ubag.skybags365.com/
smsLink=253
STRDEFUALTCURR=ZAR
STRFOLDERDELIMITER=/
strSmsService=u-bag@sms.entelligence.co.za
thisDSN=UBag_14x0x0

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=/home/skybagsc/public_html/ubag.skybags365.com/index.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=*/*
http_accept_encoding=gzip, br, zstd, deflate
http_accept_language=
http_connection=close
http_cookie=cfid=c3638570-424a-4923-b71a-07032a8850e6; cftoken=0
http_host=www.ubag.skybags365.com
http_referer=
http_user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
https=on
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=178.159.5.243
local_host=greyhound.dnshostnetwork.com
path_info=
path_translated=/home/skybagsc/public_html/ubag.skybags365.com/index.cfm
query_string=CFID=3413e78b-23c3-4538-b182-b47ee0d57093&CFTOKEN=0&pageid=340
remote_addr=216.73.217.23
remote_host=216.73.217.23
remote_user=
request_method=GET
request_url=https://www.ubag.skybags365.com/index.cfm?CFID=3413e78b-23c3-4538-b182-b47ee0d57093&CFTOKEN=0&pageid=340
script_name=/index.cfm
server_name=www.ubag.skybags365.com
server_port=443
server_port_secure=1
server_protocol=HTTP/1.1
server_software=
web_server_api=

Cookie Variables:
cfid=c3638570-424a-4923-b71a-07032a8850e6
cftoken=0

Request Variables:
org.apache.catalina.AccessLog.Protocol=HTTP/1.1
org.apache.catalina.AccessLog.RemoteAddr=216.73.217.23
org.apache.catalina.AccessLog.RemoteHost=216.73.217.23
org.apache.catalina.AccessLog.ServerName=www.ubag.skybags365.com
org.apache.catalina.AccessLog.ServerPort=443
org.apache.tomcat.remoteAddr=216.73.217.23
org.apache.tomcat.request.forwarded=true

Server Variables:
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.0.6=Complex type
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.1.1=Complex type
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.1.2=Complex type
CACHE=Struct (188)
CACHE_TIMESTAMPS=Struct (188)
cbox-javaloader-1B50254DE719A76B2ADC708B9F6D56EE=Component (modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-52B877CA0494DF462AFAE4B19932AA27=Component (modules.contentbox.modules.contentbox-deps.modules.cbmarkdown.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-554E0B2DF76810BDA83FB33DA8A8ABE9=Component (modules.contentbox.modules.contentbox-deps.modules.cbmarkdown.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-757114FCCFB5C490D952526BFDF3987E=Component (modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-7C624209BA64FDFA88C5C8208DA20E5C=Component (modules.quick.modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-8E03551109DB0559698D811C86B103EB=Component (modules.contentbox.modules.contentbox-deps.modules.cbmarkdown.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-AEAAE1EF90B4BB57161501BD525097AE=Component (modules.BCrypt.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-D3D5EEDE3F35A4658B10897E5F82E29A=Component (modules.relax.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-D98F90619134ECE764EC062DCA91FCE0=Component (modules.quick.modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-DDCEE58D59F22F146C90D6E97C07CA45=Component (modules.relax.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-F4E336252BF14F02E265FDC3C6BA95E1=Component (modules.quick.modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
coldfusion=Struct (9)
java=Struct (8)
LOGIN_BRIDGE=Struct (0)
lucee=Struct (8)
os=Struct (8)
PRODSTRUCT=Struct (1)
RECENT_ORDERS=Array (16)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)
ZONESTR=Struct (0)

Session Variables:
blnDebugMode=false
cfid=c3638570-424a-4923-b71a-07032a8850e6
cftoken=0
email=
firstname=
isAdmin=0
isCountry=0
lastvisit={ts '2026-08-07 04:02:31'}
sessionid=u-bag.14x0x0_c3638570-424a-4923-b71a-07032a8850e6_0
surname=
timecreated={ts '2026-08-07 04:02:11'}
toCountry=0
urltoken=CFID=c3638570-424a-4923-b71a-07032a8850e6&CFTOKEN=0
username=
validated=0

URL Variables:
CFID=3413e78b-23c3-4538-b182-b47ee0d57093
CFTOKEN=0
pageid=340