Beiträge von jotest

# ----------------------------------------------------------------------
# UTF-8 encoding
# ----------------------------------------------------------------------


# Use UTF-8 encoding for anything served text/plain or text/html
AddDefaultCharset utf-8


# Force UTF-8 for a number of file formats
#AddCharset utf-8 .html .css .js .xml .json .rss .atom .php


# Wenn Sie 1und1 benutzen, setzen Sie die nächsten beiden Zeilen aktiv (Einschalten PHP5.4) Bei 1und1 sollte weiter unten der Punkt RewriteBase / auch auskommentiert werden
#AddHandler x-mapp-php6 .php3 .php4 .php .phtml


# ----------------------------------------------------------------------
# Expires headers (for better cache control)
# ----------------------------------------------------------------------




<IfModule mod_expires.c>
  ExpiresActive on


# Perhaps better to whitelist expires rules? Perhaps.
  ExpiresDefault                          "access plus 1 month"


  ExpiresByType text/cache-manifest       "access plus 0 seconds"
  ExpiresByType text/html                 "access plus 0 seconds"
  ExpiresByType text/xml                  "access plus 0 seconds"
  ExpiresByType application/xml           "access plus 0 seconds"
  ExpiresByType application/json          "access plus 0 seconds"
  ExpiresByType application/rss+xml       "access plus 1 hour"
  ExpiresByType application/atom+xml      "access plus 1 hour"
  ExpiresByType image/x-icon              "access plus 1 week" 
  ExpiresByType image/gif                 "access plus 1 month"
  ExpiresByType image/png                 "access plus 1 month"
  ExpiresByType image/jpg                 "access plus 1 month"
  ExpiresByType image/jpeg                "access plus 1 month"
  ExpiresByType video/ogg                 "access plus 1 month"
  ExpiresByType audio/ogg                 "access plus 1 month"
  ExpiresByType video/mp4                 "access plus 1 month"
  ExpiresByType video/webm                "access plus 1 month"
  ExpiresByType text/x-component          "access plus 1 month"
  ExpiresByType font/truetype             "access plus 1 month"
  ExpiresByType font/opentype             "access plus 1 month"
  ExpiresByType application/x-font-woff   "access plus 1 month"
  ExpiresByType image/svg+xml             "access plus 1 month"
  ExpiresByType application/vnd.ms-fontobject "access plus 1 month"
  ExpiresByType text/css                  "access plus 1 year"
  ExpiresByType application/javascript    "access plus 1 year"
  ExpiresByType application/x-javascript  "access plus 1 year"


  
  <IfModule mod_headers.c>
    Header append Cache-Control "public"
  </IfModule>

</IfModule>


# BEGIN Cache-Control Headers
<ifmodule mod_headers.c>
	<filesmatch "\\.(ico|jpe?g|png|gif|swf)$">
		Header set Cache-Control "max-age=31536000, public"
	</filesmatch>
	<filesmatch "\\.(css)$">
		Header set Cache-Control "max-age=31536000, public"
	</filesmatch>
	<filesmatch "\\.(js)$">
		Header set Cache-Control "max-age=31536000, public"
	</filesmatch>
	<filesmatch "\\.(jgz)$">
		Header set Cache-Control "max-age=31536000, public"
	</filesmatch>
	<filesmatch "\\.(ico)$">
		Header set Cache-Control "max-age=31536000, public"
	</filesmatch>	
	<filesmatch "\\.(html)$">
		Header set Cache-Control "max-age=31536000, public"
	</filesmatch>
	Header unset ETag
	<filesmatch "\.(js|css|xml|gz|jgz)$">
		Header append Vary: Accept-Encoding
	</filesmatch>
</ifmodule>


<ifmodule mod_deflate.c>
<filesmatch "\\.(js|css|html|htm|php|xml)$">
SetOutputFilter DEFLATE
</filesmatch>
</ifmodule>


# ----------------------------------------------------------------------
# Gzip compression
# ----------------------------------------------------------------------


<IfModule mod_deflate.c>


# Force deflate for mangled headers developer.yahoo.com/blogs/ydn/posts/2010/12/pushing-beyond-gzipping/
<IfModule mod_setenvif.c>
  <IfModule mod_headers.c>
    SetEnvIfNoCase ^(Accept-EncodXng|X-cept-Encoding|X{15}|~{15}|-{15})$ ^((gzip|deflate)\s*,?\s*)+|[X~-]{4,13}$ HAVE_Accept-Encoding
    RequestHeader append Accept-Encoding "gzip,deflate" env=HAVE_Accept-Encoding
  </IfModule>
</IfModule>
</IfModule>


# HTML, TXT, CSS, JavaScript, JSON, XML, HTC:
<IfModule filter_module>
  FilterDeclare   COMPRESS
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $text/html
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $text/css
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $text/plain
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $text/xml
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $text/x-component
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $application/javascript
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $application/json
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $application/xml
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $application/xhtml+xml
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $application/rss+xml
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $application/atom+xml
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $application/vnd.ms-fontobject
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $image/svg+xml
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $application/x-font-ttf
  FilterProvider  COMPRESS  DEFLATE resp=Content-Type $font/opentype
  FilterChain     COMPRESS
  FilterProtocol  COMPRESS  DEFLATE change=yes;byteranges=no
</IfModule>




# ----------------------------------------------------------------------
# ETag removal
# ----------------------------------------------------------------------


#   developer.yahoo.com/performance/rules.html#etags
FileETag None


# Zusatzparameter PHP
#php_flag zlib.output_compression On


# Dateiauflisting unterbinden
Options -Indexes


# Kommentieren Sie diese Zeile aus, wenn Sie einen Fehler 500 (Internal Server Error) erhalten
#Options +FollowSymlinks


<IfModule mod_rewrite.c>
	RewriteEngine On


	# Javascripte gezip ausliefern

RewriteCond %{HTTP:Accept-Encoding} gzip
RewriteCond %{REQUEST_FILENAME}.jgz -f
RewriteRule (.*)\.js$ $1\.js.jgz [L]
AddType "text/javascript" .js.jgz
AddEncoding gzip .jgz

	#Sicherheit
	## Begin - Rewrite rules to block out some common exploits.
	# If you experience problems on your site block out the operations listed below
	# Block out any script trying to base64_encode data within the URL.
	RewriteCond %{QUERY_STRING} base64_encode[^(]*\([^)]*\) [OR]
	# Block out any script that includes a <script> tag in URL.
	RewriteCond %{QUERY_STRING} (<|%3C)([^s]*s)+cript.*(>|%3E) [NC,OR]
	# Block out any script trying to set a PHP GLOBALS variable via URL.
	RewriteCond %{QUERY_STRING} GLOBALS(=|\[|\%[0-9A-Z]{0,2}) [OR]
	# Block out any script trying to modify a _REQUEST variable via URL.
	RewriteCond %{QUERY_STRING} _REQUEST(=|\[|\%[0-9A-Z]{0,2})
	# Return 403 Forbidden header and show the content of the root homepage
	RewriteRule .* index.php [F]
	#
	## End - Rewrite rules to block out some common exploits.
	# Port Scanner
	RewriteCond %{HTTP_USER_AGENT} 					^w00tw00t.at.ISC.SANS.DFind
	RewriteRule ^.*$ 								403.php [L]

	# sitemap.xml auf Dynamische umleiten
	RewriteRule ^(.*)sitemap.xml$					sitemap-xml.php [qsappend,L]



	Options +SymLinksIfOwnerMatch


	# Umleitung auf Adresse mit www, wenn www fehlt und nicht Subdomain und nicht localhost und nicht ssl.webpack.de
	RewriteCond %{HTTP:X-Forwarded-Server} 	!^ssl\.webpack\.de$ [NC]
	RewriteCond %{HTTP:X-Forwarded-Server} 	!^sslsites\.de$ [NC]
	RewriteCond %{HTTP_HOST}   				!^www\..* [NC]
	RewriteCond %{HTTP_HOST}   				!^.*\..*\..* [NC]
	RewriteCond %{HTTP_HOST}   				!^localhost(.*)$ [NC]
	RewriteRule ^(.*)          				http://www.%{HTTP_HOST}/$1 [R=301,L]


	###################################################################################################
	########	Shopstat - URL Format --- by Webdesign Erfurt
	########

	##-- Kategorien
	RewriteCond %{REQUEST_URI} 								(.*)---([_0-9]+)-([_0-9]+)\.html$
	RewriteRule (.*)---([_0-9]+)-([_0-9]+)\.html$ 			index.php?cPath=$2&page=$3 [qsappend,L]

	RewriteCond %{REQUEST_URI} 								(.*)---([_0-9]+)\.html$
	RewriteRule (.*)---([_0-9]+)\.html$ 					index.php?cPath=$2 [qsappend,L]


	##-- Produkte
	RewriteRule (.*)--(.+)\.html$ 							product_info.php?products_id=$2 [qsappend,L]


	##-- Content
	RewriteRule (.*)-_-([0-9]+)\.html$ 						shop_content.php?coID=$2 [qsappend,L]


	########
	########
	####################################################################################################


	###################################################################################################
	########	Shopstat - URL Format ::: by Shopstat
	########

	##-- Kategorien
	RewriteCond %{REQUEST_URI} 								(.*):::([_0-9]+)-([_0-9]+)\.html$
	RewriteRule (.*):::([_0-9]+)-([_0-9]+)\.html$ 			index.php?cPath=$2&page=$3 [qsappend,L]

	RewriteCond %{REQUEST_URI} 								(.*):::([_0-9]+)\.html$
	RewriteRule (.*):::([_0-9]+)\.html$ 					index.php?cPath=$2 [qsappend,L]


	##-- Produkte
	RewriteRule (.*)::(.+)\.html$ 							product_info.php?products_id=$2 [qsappend,L]


	##-- Content
	RewriteRule (.*):_:([0-9]+)\.html$ 						shop_content.php?coID=$2 [qsappend,L]


	########
	########
	####################################################################################################



	# immer auf den root verweisen, damit die Startseite (/index.php) nicht zweimal vorkommt
	# die folgenden beiden Zeilen auskommentieren wenn Sie eine index.html nutzen wollen
	RewriteCond %{THE_REQUEST} ^[A-Z]{3,9}\ /index\.(html?|php)\ HTTP/
	RewriteRule ^index\.(html?|php)$ http://%{HTTP_HOST}/ [R=301,L]


	# Editieren Sie die untenstehende Zeile wenn ihr Shop in einem Unterordner läuft.
	# Aber auch wenn Sie einen Fehler 500 (Internal Server Error) bekommen.
	# Beispiel: Ist ihr Shop im Verzeichnis www.domain.de/shop ändern Sie die Zeile wie folgt: "RewriteBase /shop/"
	#RewriteBase /


	RewriteCond %{REQUEST_FILENAME} -f [OR]
	RewriteCond %{REQUEST_FILENAME} -d


	RewriteRule ^(.+) - [PT,L]

	# Alte Kategorien ohne Slash umleiten auf mit slash / Raute in den 4 Zeilen entfernen
	#RewriteCond %{REQUEST_URI} !(.*)/$
	#RewriteCond %{REQUEST_URI} !\..+$
	#RewriteCond %{REQUEST_URI} !/$
	#RewriteRule (.*) http://%{HTTP_HOST}/$1/ [R=301,L]


	RewriteRule ^(.*)(.+)404.php$								404.php [qsappend,L]


	RewriteRule ^(.*)tag/(.*([a-zßöüäA-ZÖÜÄ0-9]))/$ taglisting.php?tag=$1$2 [qsappend,L]
	RewriteRule ^(.*)hashtag/(.*([a-zßöüäA-ZÖÜÄ0-9]))$		hashtags.php?hashtags=$1$2 [qsappend,L]
	RewriteRule ^(.*)keywords/(.*([a-zßöüäA-ZÖÜÄ0-9]))$		advanced_search_result.php?keywords=$1$2 [qsappend,L]
	RewriteRule ^(.*)manufacturer-(.*[0-9])/(.*([a-zßöüäA-ZÖÜÄ0-9]))$	index.php?manufacturers_id=$2 [qsappend,L]
	RewriteRule ^(.*)review-(.*[0-9])/(.*([a-zßöüäA-ZÖÜÄ0-9]))$		product_reviews_info.php?reviews_id=$2 [qsappend,L]
	##boosted BLOG-START
	RewriteRule (.*/)?blog.html blog.php [L]


	RewriteCond %{REQUEST_FILENAME} !\.html$ [OR]
	RewriteCond %{REQUEST_FILENAME} !\.php$ [OR]
	RewriteRule ^(.*)$											commerce_seo_url.php?linkurl=$1 [qsappend,L]
</IfModule>




ErrorDocument 404 /404.php
ErrorDocument 403 /403.php

UPDATE database_version SET version = 'commerce:SEO v2next 2.5.5';




DROP TABLE IF EXISTS withdrawals;
CREATE TABLE withdrawals (
  withdrawal_id int(11) NOT NULL AUTO_INCREMENT,
  order_id int(11) NOT NULL,
  customer_id int(11) NOT NULL,
  customer_gender varchar(16) NOT NULL,
  customer_firstname varchar(255) NOT NULL,
  customer_lastname varchar(255) NOT NULL,
  customer_street_address varchar(255) NOT NULL,
  customer_postcode varchar(255) NOT NULL,
  customer_city varchar(255) NOT NULL,
  customer_country varchar(255) NOT NULL,
  customer_email varchar(255) NOT NULL,
  order_date varchar(12) NOT NULL,
  delivery_date varchar(12) NOT NULL,
  withdrawal_date varchar(12) NOT NULL,
  withdrawal_content text NOT NULL,
  date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  created_by_admin tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (withdrawal_id)
);


INSERT INTO admin_navigation VALUES (NULL, 'configuration', 'Retouren Einstellungen', 'seo_config', 'configuration.php', 1005, 1, NULL, 30);
INSERT INTO admin_navigation VALUES (NULL, 'configuration', 'RMA Settings', 'seo_config', 'configuration.php', 1005, 2, NULL, 30);


ALTER TABLE shipping_status ADD info_link_active TINYINT NOT NULL DEFAULT "1";
ALTER TABLE products ADD product_type TINYINT( 1 ) NOT NULL DEFAULT '1';
UPDATE products SET product_type = 1;
ALTER TABLE orders_products ADD product_type INT NOT NULL DEFAULT "1";
INSERT INTO configuration VALUES (NULL, 'VRRL_ACTIVE', 'true', 333, 35, NULL, NOW(), NULL, "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration VALUES (NULL, 'WITHDRAWAL_DOWNLOAD', 'false', 333, 36, NULL, NOW(), NULL, "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration VALUES (NULL, 'WITHDRAWAL_SERVICE', 'false', 333, 37, NULL, NOW(), NULL, "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration VALUES (NULL, 'WITHDRAWAL_WEBFORM_ACTIVE', 'false', 333, 38, NULL, NOW(), NULL, "xtc_cfg_select_option(array('true', 'false'),");
DELETE FROM configuration WHERE configuration_key = 'DISPLAY_WIDERRUFSRECHT_ON_CHECKOUT';


INSERT INTO configuration VALUES (NULL, 'COMPANY_NAME', '', 1, 3, NULL, NOW(), NULL, '');
INSERT INTO configuration VALUES (NULL, 'TRADER_FIRSTNAME', '', 1, 4, NULL, NOW(), NULL, '');
INSERT INTO configuration VALUES (NULL, 'TRADER_NAME', '', 1, 5, NULL, NOW(), NULL, '');
INSERT INTO configuration VALUES (NULL, 'TRADER_STREET', '', 1, 6, NULL, NOW(), NULL, '');
INSERT INTO configuration VALUES (NULL, 'TRADER_STREET_NUMBER', '', 1, 7, NULL, NOW(), NULL, '');
INSERT INTO configuration VALUES (NULL, 'TRADER_ZIPCODE', '', 1, 8, NULL, NOW(), NULL, '');
INSERT INTO configuration VALUES (NULL, 'TRADER_LOCATION', '', 1, 9, NULL, NOW(), NULL, '');
INSERT INTO configuration VALUES (NULL, 'TRADER_TEL', '', 1, 12, NULL, NOW(), NULL, '');
INSERT INTO configuration VALUES (NULL, 'TRADER_FAX', '', 1, 13, NULL, NOW(), NULL, '');
UPDATE configuration SET sort_order = "1" WHERE configuration_key = 'STORE_NAME';
UPDATE configuration SET sort_order = "2" WHERE configuration_key = 'STORE_OWNER';
UPDATE configuration SET sort_order = "10" WHERE configuration_key = 'STORE_COUNTRY';
UPDATE configuration SET sort_order = "11" WHERE configuration_key = 'STORE_ZONE';
UPDATE configuration SET sort_order = "14" WHERE configuration_key = 'STORE_OWNER_EMAIL_ADDRESS';
UPDATE configuration SET sort_order = "15" WHERE configuration_key = 'EMAIL_FROM';
UPDATE configuration SET sort_order = "17" WHERE configuration_key = 'STORE_NAME_ADDRESS';
UPDATE configuration SET sort_order = "18" WHERE configuration_key = 'EXPECTED_PRODUCTS_SORT';
UPDATE configuration SET sort_order = "19" WHERE configuration_key = 'EXPECTED_PRODUCTS_FIELD';
UPDATE configuration SET sort_order = "20" WHERE configuration_key = 'USE_DEFAULT_LANGUAGE_CURRENCY';
UPDATE configuration SET sort_order = "21" WHERE configuration_key = 'DISPLAY_CART';
UPDATE configuration SET sort_order = "22" WHERE configuration_key = 'ADVANCED_SEARCH_DEFAULT_OPERATOR';
UPDATE configuration SET sort_order = "23" WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID_ADMIN';
UPDATE configuration SET sort_order = "24" WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID_GUEST';
UPDATE configuration SET sort_order = "25" WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID';
UPDATE configuration SET sort_order = "26" WHERE configuration_key = 'ALLOW_ADD_TO_CART';

INSERT INTO emails (id, email_name, languages_id, email_address, email_address_name, email_replay_address, email_replay_address_name, email_subject, email_forward, email_content_html, email_content_text, email_backup_html, email_backup_text, email_timestamp) 
VALUES 
('', 'withdrawal', 2, 'info@ak811.de', 'Web', 'info@ak811.de', 'Web', 'Ihr Widerruf zur Bestellung {$nr}', '', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de" lang="de">\r\n<head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />\r\n<title>Widerrufsbestätigung</title>\r\n{literal}\r\n<style type="text/css">\r\nbody, table {font-size:11.5px; font-family:Helvetica, sans-serif;color:#444}\r\ntable.outerTable {border: 1px solid #ccc}\r\ntd.TopRightDesc {letter-spacing: 1px; font-weight: 600;}\r\n.ProductsTable td {color:#6d88b1;background: #f1f1f1}\r\n.ProductsAttributes td, .ProductsName {background: #ffffff}\r\n.bt {border-top:1px solid #ccc}\r\n.bb {border-bottom:1px solid #ccc}\r\n.bl {border-left:1px solid #ccc}\r\n.br {border-right:1px solid #ccc}\r\n.fs85 {font-size:85%}\r\n</style>\r\n{/literal}\r\n{load_language_text section="withdrawal"}\r\n</head>\r\n<body>\r\n<table width="90%" border="0" cellpadding="10" cellspacing="0" align="center" class="outerTable">\r\n <tr>\r\n <td>\r\n <table width="100%" border="0" cellpadding="0" cellspacing="0">\r\n <tr>\r\n  <td width="50%">\r\n  <img src="{$logo_path}logo.gif" alt="" />\r\n  </td>\r\n  <td width="50%" class="TopRightDesc" align="right">\r\n  {$txt.mail_withdrawal}\r\n  </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <table width="100%" border="0" cellpadding="0" cellspacing="0">\r\n <tr>\r\n  <td width="100%">\r\n			<strong>{$txt.customer_greeting}</strong><br />\r\n			<br />\r\n			<span>{$txt.process_cancellation}<br /></span>\r\n			<div style="font-style: italic">\r\n				<p>{$txt.withdrawal_to}:</p>\r\n				<p>\r\n					{$smarty.const.COMPANY_NAME}<br />\r\n					{$smarty.const.TRADER_FIRSTNAME} {$smarty.const.TRADER_NAME}<br />\r\n					{$smarty.const.TRADER_STREET} {$smarty.const.TRADER_STREET_NUMBER}<br />\r\n					{$smarty.const.TRADER_ZIPCODE} {$smarty.const.TRADER_LOCATION}<br />\r\n					<br />\r\n					{if $smarty.const.TRADER_TEL !=	''''}{$txt.phone}: {$smarty.const.TRADER_TEL}<br />{/if}\r\n					{if $smarty.const.TRADER_FAX != ''''}{$txt.fax}: {$smarty.const.TRADER_FAX}<br />{/if}\r\n					{if $smarty.const.STORE_OWNER_EMAIL_ADDRESS != ''''}{$txt.mail}: <a href="mailto:{$smarty.const.STORE_OWNER_EMAIL_ADDRESS}">{$smarty.const.STORE_OWNER_EMAIL_ADDRESS}</a><br />{/if}\r\n					<br />\r\n				</p>\r\n				<p>{$txt.withdrawal_yourData}:</p>\r\n				<p>\r\n					{$CUSTOMER_GENDER}<br />\r\n					{$CUSTOMER_NAME}<br />\r\n					{$CUSTOMER_STREET_ADDRESS}<br />\r\n					{$CUSTOMER_POSTCODE} {$CUSTOMER_CITY}<br />\r\n					{$CUSTOMER_COUNTRY}<br />\r\n				</p>\r\n				<p>\r\n					{if $ORDER_DATE}{$txt.order_date}: {$ORDER_DATE}<br />{/if}\r\n					{if $DELIVERY_DATE}{$txt.deliverydate_t}: {$DELIVERY_DATE}<br />{/if}\r\n					{$txt.withdrawal_date}: {$WITHDRAWAL_DATE}<br />\r\n				</p>\r\n				<p>{$txt.withdrawal}:</p>\r\n				<p>{$WITHDRAWAL_CONTENT}</p>\r\n			</div>\r\n  </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n</table>', '{load_language_text section="withdrawal"}\r\n{$txt.customer_greeting}\r\n\r\n{$txt.process_cancellation}\r\n\r\n{$txt.withdrawal_to}:\r\n\r\n{$smarty.const.COMPANY_NAME}\r\n{$smarty.const.TRADER_FIRSTNAME} {$smarty.const.TRADER_NAME}\r\n{$smarty.const.TRADER_STREET} {$smarty.const.TRADER_STREET_NUMBER}\r\n{$smarty.const.TRADER_ZIPCODE} {$smarty.const.TRADER_LOCATION}\r\n\r\n{if $smarty.const.TRADER_TEL != ''''}{$txt.phone}: {$smarty.const.TRADER_TEL}{/if}\r\n\r\n{if $smarty.const.TRADER_FAX != ''''}{$txt.fax}: {$smarty.const.TRADER_FAX}{/if}\r\n\r\n{if $smarty.const.STORE_OWNER_EMAIL_ADDRESS != ''''}{$txt.mail}: {$smarty.const.STORE_OWNER_EMAIL_ADDRESS}{/if}\r\n\r\n\r\n\r\n{$txt.withdrawal_yourData}:\r\n\r\n{$CUSTOMER_GENDER}\r\n{$CUSTOMER_NAME}\r\n{$CUSTOMER_STREET_ADDRESS}\r\n{$CUSTOMER_POSTCODE} {$CUSTOMER_CITY}\r\n{$CUSTOMER_COUNTRY}\r\n\r\n{if $ORDER_DATE}{$txt.order_date}: {$ORDER_DATE}{/if}\r\n{if $DELIVERY_DATE}{$txt.deliverydate_t}: {$DELIVERY_DATE}{/if}\r\n\r\n{$txt.withdrawal_date}: {$WITHDRAWAL_DATE}\r\n\r\n{$txt.withdrawal}:\r\n{$WITHDRAWAL_CONTENT}\r\n', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="de" lang="de">\r\n<head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />\r\n<title>Widerrufsbestätigung</title>\r\n{literal}\r\n<style type="text/css">\r\nbody, table {font-size:11.5px; font-family:Helvetica, sans-serif;color:#444}\r\ntable.outerTable {border: 1px solid #ccc}\r\ntd.TopRightDesc {letter-spacing: 1px; font-weight: 600;}\r\n.ProductsTable td {color:#6d88b1;background: #f1f1f1}\r\n.ProductsAttributes td, .ProductsName {background: #ffffff}\r\n.bt {border-top:1px solid #ccc}\r\n.bb {border-bottom:1px solid #ccc}\r\n.bl {border-left:1px solid #ccc}\r\n.br {border-right:1px solid #ccc}\r\n.fs85 {font-size:85%}\r\n</style>\r\n{/literal}\r\n{load_language_text section="withdrawal"}\r\n</head>\r\n<body>\r\n<table width="90%" border="0" cellpadding="10" cellspacing="0" align="center" class="outerTable">\r\n <tr>\r\n <td>\r\n <table width="100%" border="0" cellpadding="0" cellspacing="0">\r\n <tr>\r\n  <td width="50%">\r\n  <img src="{$logo_path}logo.gif" alt="" />\r\n  </td>\r\n  <td width="50%" class="TopRightDesc" align="right">\r\n  {$txt.mail_withdrawal}\r\n  </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <table width="100%" border="0" cellpadding="0" cellspacing="0">\r\n <tr>\r\n  <td width="100%">\r\n			<strong>{$txt.customer_greeting}</strong><br />\r\n			<br />\r\n			<span>{$txt.process_cancellation}<br /></span>\r\n			<div style="font-style: italic">\r\n				<p>{$txt.withdrawal_to}:</p>\r\n				<p>\r\n					{$smarty.const.COMPANY_NAME}<br />\r\n					{$smarty.const.TRADER_FIRSTNAME} {$smarty.const.TRADER_NAME}<br />\r\n					{$smarty.const.TRADER_STREET} {$smarty.const.TRADER_STREET_NUMBER}<br />\r\n					{$smarty.const.TRADER_ZIPCODE} {$smarty.const.TRADER_LOCATION}<br />\r\n					<br />\r\n					{if $smarty.const.TRADER_TEL !=	''''}{$txt.phone}: {$smarty.const.TRADER_TEL}<br />{/if}\r\n					{if $smarty.const.TRADER_FAX != ''''}{$txt.fax}: {$smarty.const.TRADER_FAX}<br />{/if}\r\n					{if $smarty.const.STORE_OWNER_EMAIL_ADDRESS != ''''}{$txt.mail}: <a href="mailto:{$smarty.const.STORE_OWNER_EMAIL_ADDRESS}">{$smarty.const.STORE_OWNER_EMAIL_ADDRESS}</a><br />{/if}\r\n					<br />\r\n				</p>\r\n				<p>{$txt.withdrawal_yourData}:</p>\r\n				<p>\r\n					{$CUSTOMER_GENDER}<br />\r\n					{$CUSTOMER_NAME}<br />\r\n					{$CUSTOMER_STREET_ADDRESS}<br />\r\n					{$CUSTOMER_POSTCODE} {$CUSTOMER_CITY}<br />\r\n					{$CUSTOMER_COUNTRY}<br />\r\n				</p>\r\n				<p>\r\n					{if $ORDER_DATE}{$txt.order_date}: {$ORDER_DATE}<br />{/if}\r\n					{if $DELIVERY_DATE}{$txt.deliverydate_t}: {$DELIVERY_DATE}<br />{/if}\r\n					{$txt.withdrawal_date}: {$WITHDRAWAL_DATE}<br />\r\n				</p>\r\n				<p>{$txt.withdrawal}:</p>\r\n				<p>{$WITHDRAWAL_CONTENT}</p>\r\n			</div>\r\n  </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n</table>\r\n', '{load_language_text section="withdrawal"}\r\n{$txt.customer_greeting}\r\n\r\n{$txt.process_cancellation}\r\n\r\n{$txt.withdrawal_to}:\r\n\r\n{$smarty.const.COMPANY_NAME}\r\n{$smarty.const.TRADER_FIRSTNAME} {$smarty.const.TRADER_NAME}\r\n{$smarty.const.TRADER_STREET} {$smarty.const.TRADER_STREET_NUMBER}\r\n{$smarty.const.TRADER_ZIPCODE} {$smarty.const.TRADER_LOCATION}\r\n\r\n{if $smarty.const.TRADER_TEL != ''''}{$txt.phone}: {$smarty.const.TRADER_TEL}{/if}\r\n\r\n{if $smarty.const.TRADER_FAX != ''''}{$txt.fax}: {$smarty.const.TRADER_FAX}{/if}\r\n\r\n{if $smarty.const.STORE_OWNER_EMAIL_ADDRESS != ''''}{$txt.mail}: {$smarty.const.STORE_OWNER_EMAIL_ADDRESS}{/if}\r\n\r\n\r\n\r\n{$txt.withdrawal_yourData}:\r\n\r\n{$CUSTOMER_GENDER}\r\n{$CUSTOMER_NAME}\r\n{$CUSTOMER_STREET_ADDRESS}\r\n{$CUSTOMER_POSTCODE} {$CUSTOMER_CITY}\r\n{$CUSTOMER_COUNTRY}\r\n\r\n{if $ORDER_DATE}{$txt.order_date}: {$ORDER_DATE}{/if}\r\n{if $DELIVERY_DATE}{$txt.deliverydate_t}: {$DELIVERY_DATE}{/if}\r\n\r\n{$txt.withdrawal_date}: {$WITHDRAWAL_DATE}\r\n\r\n{$txt.withdrawal}:\r\n{$WITHDRAWAL_CONTENT}\r\n', 1263483589);


#UPDATE products SET product_type = '2';




UPDATE database_version SET version = 'commerce:SEO v2next 2.5.6';


ALTER TABLE customers_basket_attributes ADD products_option_ft VARCHAR(50) NOT NULL AFTER products_options_value_id;
ALTER TABLE blog_items ADD blog_image VARCHAR( 254 ) NULL;


UPDATE database_version SET version = 'commerce:SEO v2next 2.5.7';




DELETE FROM configuration WHERE configuration_key = 'CSEO_URL_ADMIN_ON';
DELETE FROM configuration WHERE configuration_key = 'ADMIN_CSEO_START_RSS';
INSERT INTO configuration VALUES (NULL, 'ADMIN_CSEO_ORDER_COMMENT', 'false', 1003, 17, NULL, NOW(), NULL, "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration VALUES (NULL, 'ADMIN_CSEO_ORDER_SEND', 'false', 1003, 18, NULL, NOW(), NULL, "xtc_cfg_select_option(array('true', 'false'),");
INSERT INTO configuration VALUES (NULL, 'ADMIN_DEFAULT_LISTING_NUM', '20', 1003, 19, NULL, NOW(), NULL, "xtc_cfg_select_option(array('20', '50', '100', '250', '10000'),");
ALTER TABLE content_manager ADD last_modified DATETIME NOT NULL;
UPDATE content_manager SET last_modified = now();


UPDATE database_version SET version = 'commerce:SEO v2next 2.5.10';