Hosted Exchange

SELECT * FROM global_whitelist

SELECT id FROM global_blacklist 
				WHERE   ipaddress='3.20.240.115'

SELECT * FROM global_remote_text_block

SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE, AuthObject, AnzSubKat, Description, AuthObject, PageTitle, ThemaKeyWords, LastChangeTime
				FROM         Themen 
				where ThemaID='de-Hosting' and Phase='online'

SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, ThemaLink, THEMATEMPLATE
				FROM         Themen
				where Hauptthema='DEmenu1' and Phase='online' order by ThemaPrio

SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, ThemaLink, AnzSubKat, AuthObject, PageTitle
				FROM         Themen 
				where Hauptthema='DE-HauptMenu' and Phase='online' order by ThemaPrio

SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, ThemaLink, THEMATEMPLATE, AnzSubKat
				FROM         Themen
				where Hauptthema='DEUntereNavigation' and Phase='online' order by ThemaPrio

SELECT      
			Artikel.ArtikelID, 
			Artikel.Titel, 
			Artikel.Link1, 
			Artikel.Bild1, 
			Artikel.Text1, 
			Artikel.Text2,
			Artikel.Link2,
			Artikel.ErstellZeit,
			Artikel.AendernZeit,
			Artikel.ErstelltUser,
			Artikel.OnlineVon,
			Artikel.AdminText
			FROM Artikel RIGHT JOIN (Themen LEFT JOIN Themen_Artikel ON Themen.ThemaID = Themen_Artikel.ThemaID) ON Artikel.ArtikelID = Themen_Artikel.ArtikelID
			where Themen.ThemaID = 'de-Hosting'
			AND Artikel.Phase = 'online' 
			AND (Artikel.OnlineVon is null or Artikel.OnlineVon < {ts '2025-04-26 12:29:27'})
			AND (Artikel.OnlineBis is null or Artikel.OnlineBis > {ts '2025-04-26 12:29:27'})
			Order By Themen_Artikel.SortPos asc;

SELECT      
			Artikel.ArtikelID, 
			Artikel.Titel, 
			Artikel.Link1, 
			Artikel.Link2, 
			Artikel.Bild1, 
			Artikel.Bild2, 
			Artikel.Text1, 
			Artikel.Text2,
			Artikel.ErstellZeit,
			Artikel.AendernZeit,
			Artikel.ErstelltUser,
			Artikel.Tags,
			Artikel.FELD1,
			Artikel.OnlineVon,
			Artikel.AdminText
			FROM Artikel 
			where Artikel.ArtikelID = 'deHostedExchange'

select Bild1, Text1, Link1 
			from Artikel a inner join Themen_Artikel ta on (a.ArtikelID = ta.ArtikelID)
			where (ThemaID = 'ads') and (Phase = 'Online')
			order by SortPos asc

SELECT strCatID, strCatName, strHCatID, strCatok, glbCatDesc
	FROM tblStCat 
	where (strHCatID = 'Produkte' or strHCatID = 'hauptkat') AND strCatok = 1
	ORDER BY strCatSort ASC;

SELECT ThemaID, AnzSubKat, AuthObject, PageTitle, ThemaLink, ThemaName, Thematext
                                      FROM Themen
                                      where Hauptthema='de-Hosting' and Phase='online' order by ThemaPrio

SELECT ThemaID, AnzSubKat, AuthObject, PageTitle, ThemaLink, ThemaName, Thematext
                                      FROM Themen
                                      where Hauptthema='de-Internet' and Phase='online' order by ThemaPrio

SELECT ThemaID, AnzSubKat, AuthObject, PageTitle, ThemaLink, ThemaName, Thematext
                                      FROM Themen
                                      where Hauptthema='de-IT-Services' and Phase='online' order by ThemaPrio

SELECT ThemaID, AnzSubKat, AuthObject, PageTitle, ThemaLink, ThemaName, Thematext
                                      FROM Themen
                                      where Hauptthema='de-Firma' and Phase='online' order by ThemaPrio

SELECT ThemaID, AnzSubKat, AuthObject, PageTitle, ThemaLink, ThemaName, Thematext
                                      FROM Themen
                                      where Hauptthema='de-support' and Phase='online' order by ThemaPrio

Application Variables:
ACCESS_ID=ap@trenka.ch
ADMINURL=Admin
ADMINVERSION=2024051601
applicationname=trenka.ch
APPLS=Query (8)
APPLSLIST=BLOGmaster,CMSmaster,DNSmaster,EVENTmaster,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-04-16 23:40: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
FROM=test.trenka.ch <info@trenka.ch>
GaleryMarginBottom=20
GaleryMarginTop=0
GLOBAL_DOMAIN_CONTACT_TABLE=dm_test_domain_contacts
HM=/
LZ=200
MAXROWS=50
MENU=cms_MMenu.cfm
MWST_INOROUT=exclusive
MYEMAIL=ap@trenka.ch
MYURL=https://test.trenka.ch/
NAME=test.trenka.ch
ORDERDOCUMENTBASEPATH=I:\www\trenka.ch\orders
ORDERDOCUMENTBASEURL=/orders
REFCURRENCY=CHF
REFLAND=CHE
REFSPRACHE=-ch
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 (2)
SPRACHEN=de,en
sprachen_lang_de=Struct (325)
sprachen_lang_en=Struct (325)
STATUS=Open
SURVEYACCOUNT=trenka
SURVEYDB=surveydb_trenka
SURVEYEMAIL=info@trenka.ch
TimeoutcheckIPs=Array (0)

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\cms_default.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=
http_host=test.trenka.ch
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=256
https_secretkeysize=
https_server_issuer=C=US, O=Let's Encrypt, CN=R11
https_server_subject=CN=test.trenka.ch
local_addr=193.16.211.4
local_host=Euros
path_info=
path_translated=I:\WWW\trenka.ch\cms_default.cfm
query_string=404;https://test.trenka.ch:443/DE/de-Hosting/a/deHostedExchange
remote_addr=3.20.240.115
remote_host=3.20.240.115
remote_user=
request_method=GET
request_url=https://test.trenka.ch/cms_default.cfm?404;https://test.trenka.ch:443/DE/de-Hosting/a/deHostedExchange
script_name=/cms_default.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=ffe4cb04-20c7-431f-a1fa-fa83d63415a2
cftoken=0
hitcount=1
lastvisit={ts '2025-04-26 12:29:27'}
timecreated={ts '2025-04-26 12:29:27'}
urltoken=CFID=ffe4cb04-20c7-431f-a1fa-fa83d63415a2&CFTOKEN=0

Cookie Variables:
cfid=ffe4cb04-20c7-431f-a1fa-fa83d63415a2
cftoken=0

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

Server Variables:
CMSMASTER=Struct (2)
coldfusion=Struct (9)
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=2530F986-EFC0-4664-93543B73E0720199
cfid=ffe4cb04-20c7-431f-a1fa-fa83d63415a2
cftoken=0
EditMode=fckeditor
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
IPADDR=3.20.240.115
lastvisit={ts '2025-04-26 12:29:27'}
MP_THEMAID=
MP_THEMALINK=
MP_THEMANAME=
RefererID=
sessionid=trenka.ch_ffe4cb04-20c7-431f-a1fa-fa83d63415a2_0
SESSLASTCLICK={ts '2025-04-26 12:29:27'}
SESSSTARTTIME={ts '2025-04-26 12:29:27'}
sprache=DE
strCustID=
timecreated={ts '2025-04-26 12:29:27'}
URLLIST=https://test.trenka.ch/cms_default.cfm?404;https://test.trenka.ch:443/DE/de-Hosting/a/deHostedExchange {ts '2025-04-26 12:29:27'}
urltoken=CFID=ffe4cb04-20c7-431f-a1fa-fa83d63415a2&CFTOKEN=0
whitelisted=false

URL Variables:
404;https://test=Struct (1)
404;https://test.trenka.ch:443/DE/de-Hosting/a/deHostedExchange=