Dies ist aber nur den "einfache" anzeige dass dass teil in ein update procedure ins Datenbank feld geschrieben ist also versions nr.
Heist dan nicht noch dass alles richtig updated worden ist.
den cseov2plus.sql hat hier den datum 05-08-2014 also wen man dies in Kunden download wo do es gekauft hat nicht downloaden kan gibt es noch ein par möglichkeiten zum check ich hoffe es ist ok als ich hier etwas hilfe leiste (admin? ) pm mir f
ür den sql!
( wen man mit phpmyadmin fit ist, ein extra databank dort anlegen kan mit deiner sql datei, dan die teilen von update sql dort updaten dan hast Du ein komplettes, ja ist viel arbeit unsw)
Kan nichts dafür dass kein neue cpl sql datei bei dir gibt ....
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';
Alles anzeigen