Warenkorb zum anpassen

SELECT * FROM global_whitelist

SELECT id FROM global_blacklist 
				WHERE   ipaddress='18.217.160.127'

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-Produkte' 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-Produkte'
			AND Artikel.Phase = 'online' 
			AND (Artikel.OnlineVon is null or Artikel.OnlineVon < {ts '2025-04-26 07:20:30'})
			AND (Artikel.OnlineBis is null or Artikel.OnlineBis > {ts '2025-04-26 07:20:30'})
			Order By Themen_Artikel.SortPos asc;

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 strCatID, strCatName, strHCatID, strCatok, glbCatDesc
		FROM tblStCat 
		where strHCatID = '' AND strCatok = 1
		ORDER BY strCatSort ASC;

SELECT strItmID, strPartNum, strItmName, strTeaser, strItmImg, dblItmCost, strText5, strWert5, strText6, strText7, intGewicht, tblC_I.strCatID as strCatID, strsort,tblStItm.strHttpLink, tblStItm.glbItmDesc2
			FROM tblStItm
			INNER JOIN tblC_I ON tblStItm.strItmID = tblC_I.strItmID 
			WHERE      
								(strCatID = '')
								
								
						
						AND (strok = 1)
						
			
			ORDER BY case when strsort in('','0') then 1 else 0 end, strsort ASC

SELECT strCatID, strCatName, glbCatDesc, strFilter
		FROM tblStCat 
		where strCatID = ''

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

DELETE FROM tblCtItm WHERE strCrtIDPK = 'B86BBD2C-CD83-49E0-8AA335CDDC1EF448' AND intQty = 0

SELECT id, strItmIDPK, strItmID, strPartNum, strItmName, strItmImg, tblStItm.dblItmCost as dblItmCost, tblStItm.dblItmCost2, tblStItm.dblItmCost3, tblStItm.dblItmCost4, intQty, tblCtItm.strWert1, intgewicht, mwstsatz, tblCtItm.strOptions
	  FROM tblStItm, tblCtItm
	  WHERE strItmID = strItmIDPK AND strCrtIDPK = 'B86BBD2C-CD83-49E0-8AA335CDDC1EF448'

select Sum(tblStItm.dblItmCost*intQty) as TotalCost, MWSTsatz, Sum(tblStItm.dblItmCost*MWSTsatz/100*intQty) as TotalMWST
	FROM tblStItm, tblCtItm
	WHERE strItmID = strItmIDPK AND strCrtIDPK = 'B86BBD2C-CD83-49E0-8AA335CDDC1EF448'
	GROUP BY MWSTsatz

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 (0)
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\shop_warenkorb.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\shop_warenkorb.cfm
query_string=
remote_addr=18.217.160.127
remote_host=18.217.160.127
remote_user=
request_method=GET
request_url=https://test.trenka.ch/shop_warenkorb.cfm
script_name=/shop_warenkorb.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=73e6c759-7d7e-4b93-9a75-5f08902d9799
cftoken=0
hitcount=1
lastvisit={ts '2025-04-26 07:20:30'}
timecreated={ts '2025-04-26 07:20:30'}
urltoken=CFID=73e6c759-7d7e-4b93-9a75-5f08902d9799&CFTOKEN=0

Cookie Variables:
cfid=73e6c759-7d7e-4b93-9a75-5f08902d9799
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=B86BBD2C-CD83-49E0-8AA335CDDC1EF448
cfid=73e6c759-7d7e-4b93-9a75-5f08902d9799
cftoken=0
EditMode=fckeditor
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
IPADDR=18.217.160.127
lastvisit={ts '2025-04-26 07:20:30'}
LIMITID=1000
MP_THEMAID=
MP_THEMALINK=
MP_THEMANAME=
RefererID=
sessionid=trenka.ch_73e6c759-7d7e-4b93-9a75-5f08902d9799_0
SESSLASTCLICK={ts '2025-04-26 07:20:30'}
SESSSTARTTIME={ts '2025-04-26 07:20:30'}
SORTID=ST
sprache=de
strCustID=
timecreated={ts '2025-04-26 07:20:30'}
URLLIST=https://test.trenka.ch/shop_warenkorb.cfm {ts '2025-04-26 07:20:30'}
urltoken=CFID=73e6c759-7d7e-4b93-9a75-5f08902d9799&CFTOKEN=0
whitelisted=false