SELECT * FROM global_whitelist

SELECT id FROM global_blacklist 
				WHERE   ipaddress='216.73.216.155'

SELECT * FROM global_remote_text_block

SELECT * FROM global_whitelist

Application Variables:
ACCESS_ID=ap@trenka.ch
ADMINURL=Admin
ADMINVERSION=2024051601
applicationname=trenka.ch
APPLS=Query (9)
APPLSLIST=BLOGmaster,CMSmaster,DNSmaster,EVENTmaster,FORUMmaster,iSHOPmaster,MEMBERmaster,NEWSmaster,SURVEYmaster
COLLECTIONPATH=I:\www\trenka.ch\collections
CURRENCY2=EUR
DATASOURCE=trenka_cms
DATASOURCE2=trenka_mm
DATASOURCE_ADM=trenka_cms
DIRHM=I:\www\trenka.ch\
DM_DOMAINS=dm_test_domains
dns_last_restart={ts '2025-07-28 16:55:00'}
dns_restart=false
dns_timeout=0.003472222222
DNSMASTERAID=domains@trenka.net
DNSMASTERDFZ=d3_neu.dns
DNSMASTERNS1=cetus.trenka.ch
DNSMASTERNS2=daneb.trenka.net
DNSMASTERNS3=lyra.trenka.com
DNSMASTERPIP=93.188.75.100
DOCSPATH=docs
EVENTMASTER_EMAIL=eventmaster@event-master.ch
FILTER_LINKS_BOTTOM_VISIBLE=n
FILTER_LINKS_TOP_VISIBLE=y
FM_SETTINGS=Struct (29)
FORUMSETTINGS=
FROM=test.trenka.ch <info@trenka.ch>
FRONTPAGE=Component (admin.forummaster.cfcs.frontpage)
GaleryMarginBottom=20
GaleryMarginTop=0
GLOBAL_DOMAIN_CONTACT_TABLE=dm_test_domain_contacts
HM=/
KATEGORIE=Component (admin.forummaster.cfcs.kategorie)
LZ=200
MAILSERVICE=Component (admin.forummaster.cfcs.mailService)
MAXROWS=50
MENU=cms_MMenu.cfm
MESSAGE=Component (admin.forummaster.cfcs.message)
MWST_INOROUT=exclusive
MYEMAIL=ap@trenka.ch
MYURL=https://test.trenka.ch/
NAME=test.trenka.ch
ORDERDOCUMENTBASEPATH=I:\www\trenka.ch\orders
ORDERDOCUMENTBASEURL=/orders
PAGES=Struct (7)
PERMISSION=Component (admin.forummaster.cfcs.permission)
REFCURRENCY=CHF
REFLAND=CHE
REFSPRACHE=-ch
RIGHTS=Struct (3)
S_CONTACT=P-SZS1161
S_LOGIN=trenka
S_PW=IPA-2020-ss
S_URL=https://api-ote.rrpproxy.net:8083/xmlrpc
SHOP_MYPOS_PRIVATECERT_PATH=converted_privateKey.pem
SHOP_MYPOS_PUBLICCERT_PATH=converted_apiCertificate_converted_with_a_new_filename.pem
SHOP_MYPOS_STOREID=000000000000010
SHOP_MYPOS_URL=https://www.mypos.com/vmp/checkout-test
SHOP_MYPOS_WALLETID=61938166610
SHOP_PAYPAL_MERCHID=AQ6_RCijUOmgDPbcmEEDySpmXcJbZXLdbq6PAbE3R_N2AXLGd3tYiS3mFUK6gWiaqDm1DwOa69iw5xyM
SHOP_PAYPAL_SECRET=EJqr0-3HNnVyLOauCkAtHXzyawU24YFgWQyHPOEi4ab32jWN8xFiJn64CU4J43AMGCkDB8uRlt1_1iDR
SHOP_PAYPAL_URL=https://api-m.sandbox.paypal.com
SHOP_RECHNUNG_BILD=docs/Angebot.png
SHOP_RECHNUNG_CREDITORADDRESS1=Seefeldstrasse 108
SHOP_RECHNUNG_CREDITORCITY=Zurich
SHOP_RECHNUNG_CREDITORLAND=CH
SHOP_RECHNUNG_CREDITORNAME=Trenka Informatik AG
SHOP_RECHNUNG_CREDITORNO=21
SHOP_RECHNUNG_CREDITORPOSTCODE=8008
SHOP_RECHNUNG_QRIBAN=CH1930000001852761327
SHOP_RECHNUNG_TEXT=PHN0eWxlPgkNCgkJCSNIZWFkZXJJbmZvew0KDQoJCQkJdGV4dC1hbGlnbjogbGVmdDsNCgkJCQlmb250LWZhbWlseTogc2Fucy1zZXJpZjsNCiAgICAgICAgICAgICAgICBmb250LXNpemU6N3B0Ow0KCQkJCWNvbG9yOiAjMDA5NTlkOw0KCQkJfQkNCgkJCTwvc3R5bGU+DQoJCQk8ZGl2IGlkPSJIZWFkZXJJbmZvIj4NCiAgICANCgkJCQk8dGFibGUgc3R5bGU9IndpZHRoOjEwMCU7Ij4NCgkJCQkJPHRyPg0KCQkJCQkJPHRkIHN0eWxlPSJ3aWR0aDo1NSUiPjxpbWcgc3JjPSIvZG9jcy9Mb2dvLnBuZyI+PC90ZD4gDQogICAgICAgICAgICAgICAgICAgICAgICA8dGQ+DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgPHRhYmxlIHN0eWxlPSJ3aWR0aDoxMDAlOyI+DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDx0cj4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDx0ZD5UcmVua2EgSW5mb3JtYXRpayBBRzwvdGQ+IDx0ZD5UZWwgICArNDEgNDQgMzgzIDYzIDA3PC90ZD4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPC90cj4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPHRyPg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPHRkPlNlZWZlbGRzdHJhc3NlIDEwODwvdGQ+IDx0ZD5GYXggICArNDEgNDQgMzgzIDYzIDEwPC90ZD4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPC90cj4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPHRyPg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPHRkPkNILTgwMDggWsO8cmljaDwvdGQ+IDx0ZD53d3cudHJlbmthLmNoPC90ZD4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPC90cj4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICA8L3RhYmxlPg0KICAgICAgICAgICAgICAgICAgICAgICAgPC90ZD4NCgkJCQkJPC90cj4NCgkJCQk8L3RhYmxlPg0KCQkJCQ0KCQkJPC9kaXY+
SHOP_SAFERPAY_CUSTOMERID=273744
SHOP_SAFERPAY_PASSWORD=7*T3m!KEH)2Qw&ABC
SHOP_SAFERPAY_PAYMETHODS=VISA,MASTERCARD,MAESTRO,TWINT
SHOP_SAFERPAY_TERMINALID=17764678
SHOP_SAFERPAY_URL=https://test.saferpay.com
SHOP_SAFERPAY_USERNAME=API_273744_92364895
SHOPAKTION=n
SHOPBCC=ap@trenka.ch
shopFaceProperties=pdf editOrder report
SHOPFROM=trenka.ch <info@trenka.ch>
SHOPTOCC=ap@trenka.ch
SITEMAPROUTES=de-hauptmenu,en-hauptmenu
SORTIERUNG_OBEN_VISIBLE=y
SPAMcheckemail=Array (0)
SPAMcheckIPs=Array (1)
SPRACHEN=de,en
sprachen_lang_de=Struct (331)
sprachen_lang_en=Struct (331)
STATUS=Open
SURVEYACCOUNT=trenka
SURVEYDB=trenka_cms
SURVEYEMAIL=info@trenka.ch
SURVEYVIEW=/survey.cfm
THREAD=Component (admin.forummaster.cfcs.thread)
TimeoutcheckIPs=Array (1)
USER=Component (admin.forummaster.cfcs.user)
UTILS=Component (admin.forummaster.cfcs.utils)

CGI Variables:
auth_password=
auth_type=
auth_user=
cert_cookie=
cert_flags=
cert_issuer=
cert_keysize=256
cert_secretkeysize=3072
cert_serialnumber=
cert_server_issuer=C=US, O=Let's Encrypt, CN=R11
cert_server_subject=CN=test.trenka.ch
cert_subject=
cf_template_path=I:\WWW\trenka.ch\en\shop_vserver.cfm
content_length=
content_type=
context_path=
gateway_interface=CGI/1.1
http_accept=*/*
http_accept_encoding=gzip, br, zstd, deflate
http_accept_language=
http_connection=close
http_cookie=CF_CLIENT_TRENKA_CH322_TC=1754403098356; CF_CLIENT_TRENKA_CH322_LV=1754403098356; CF_CLIENT_TRENKA_CH322_HC=2; cftoken=0; cfid=9f12173b-ab36-48fe-b3e3-c8a96152fcef
http_host=test.trenka.ch
http_referer=https://test.trenka.ch/en/635C5835-AD2E-409A-A80F350B3E29EDEA
http_user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
https=on
https_keysize=256
https_secretkeysize=
https_server_issuer=C=US, O=Let's Encrypt, CN=R11
https_server_subject=CN=test.trenka.ch
local_addr=10.0.16.113
local_host=Euros
path_info=
path_translated=I:\WWW\trenka.ch\en\shop_vserver.cfm
query_string=
remote_addr=216.73.216.155
remote_host=216.73.216.155
remote_user=
request_method=GET
request_url=https://test.trenka.ch/en/shop_vserver.cfm
script_name=/en/shop_vserver.cfm
server_name=test.trenka.ch
server_port=443
server_port_secure=1
server_protocol=HTTP/1.1
server_software=
web_server_api=

Client Variables:
cfid=9f12173b-ab36-48fe-b3e3-c8a96152fcef
cftoken=0
hitcount=2
lastvisit={ts '2025-08-05 16:11:38'}
timecreated={ts '2025-08-05 16:11:38'}
urltoken=CFID=9f12173b-ab36-48fe-b3e3-c8a96152fcef&CFTOKEN=0

Cookie Variables:
cf_client_trenka_ch322_hc=2
cf_client_trenka_ch322_lv=1754403098356
cf_client_trenka_ch322_tc=1754403098356
cfid=9f12173b-ab36-48fe-b3e3-c8a96152fcef
cftoken=0

Request Variables:
javax.servlet.request.key_size=3072

Server Variables:
CMSMASTER=Struct (2)
coldfusion=Struct (9)
counters=Struct (23)
java=Struct (9)
lucee=Struct (9)
os=Struct (8)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)

Session Variables:
ActAppl=CMSmaster
ADS=Query (0)
CartID=59962E27-E631-48DB-BDCB6A8A3E866BC3
cfid=9f12173b-ab36-48fe-b3e3-c8a96152fcef
cftoken=0
EditMode=fckeditor
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
IPADDR=216.73.216.155
lastvisit={ts '2025-08-05 16:11:38'}
MP_THEMAID=
MP_THEMALINK=
MP_THEMANAME=
RefererID=
sessionid=trenka.ch_9f12173b-ab36-48fe-b3e3-c8a96152fcef_0
SESSLASTCLICK={ts '2025-08-05 16:11:38'}
SESSSTARTTIME={ts '2025-08-05 16:11:38'}
sprache=en
strCustID=
THEMAID=635C5835-AD2E-409A-A80F350B3E29EDEA
timecreated={ts '2025-08-05 16:11:38'}
URLLIST=https://test.trenka.ch/cms_default.cfm?404;https://test.trenka.ch:443/en/635C5835-AD2E-409A-A80F350B3E29EDEA {ts '2025-08-05 16:11:38'},
https://test.trenka.ch/en/shop_vserver.cfm {ts '2025-08-05 16:11:38'}
urltoken=CFID=9f12173b-ab36-48fe-b3e3-c8a96152fcef&CFTOKEN=0
whitelisted=false