Update von XTC 2.0  RC 1.2 -> 3.0.2
 

1. Datenbank und Dateien Sichern, kann ja immer mal was schief gehen.

2. Kopiere die Dateien von xtCommerce_v3.0.2 in die 2.0 und überschreibe die Dateien oder erstelle einen neuen Ordner und passe gegebenenfalls die configure.php Datein von 2.0 rc1.2 an.


3. Datenbank updaten:


ALTER TABLE admin_access add orders_edit int(1) not null DEFAULT '0' AFTER blacklist;

ALTER TABLE customers add customers_vat_id varchar (20) AFTER customers_cid;

ALTER TABLE customers add customers_vat_id_status int(2) DEFAULT '0' not null AFTER customers_vat_id;

ALTER TABLE customers add password_request_key varchar(32) not null AFTER account_type;

ALTER TABLE orders add customers_vat_id varchar(20) AFTER customers_cid;

ALTER TABLE products add products_ean varchar(128) AFTER products_id;

ALTER TABLE specials add specials_quantity int(4) not null AFTER products_id;

ALTER TABLE content_manager add group_ids text AFTER parent_id;

ALTER TABLE content_manager add sort_order int(4) AFTER content_text;

ALTER TABLE products_content add group_ids text AFTER products_id;



CREATE TABLE newsletter_recipients (

mail_id int(11) NOT NULL auto_increment,

customers_email_address varchar(96) NOT NULL default '',

customers_id int(11) NOT NULL default '0',

customers_status int(5) NOT NULL default '0',

customers_firstname varchar(32) NOT NULL default '',

customers_lastname varchar(32) NOT NULL default '',

mail_status int(1) NOT NULL default '0',

mail_key varchar(32) NOT NULL default '',

date_added datetime NOT NULL default '0000-00-00 00:00:00',

PRIMARY KEY? (mail_id)

);



DROP TABLE IF EXISTS orders_recalculate;

CREATE TABLE orders_recalculate (

orders_recalculate_id int(11) NOT NULL auto_increment,

orders_id int(11) NOT NULL default '0',

n_price decimal(15,4) NOT NULL default '0.0000',

b_price decimal(15,4) NOT NULL default '0.0000',

tax decimal(15,4) NOT NULL default '0.0000',

tax_rate decimal(7,4) NOT NULL default '0.0000',

class varchar(32) NOT NULL default '',

PRIMARY KEY? (orders_recalculate_id)

);



DROP TABLE IF EXISTS products_images;

CREATE TABLE products_images (

image_id INT NOT NULL auto_increment,

products_id INT NOT NULL ,

image_nr SMALLINT NOT NULL ,

image_name VARCHAR( 254 ) NOT NULL ,

PRIMARY KEY ( image_id )

);



Drop TABLE if exists payment_qenta;

CREATE TABLE payment_qenta (

q_TRID varchar(255) NOT NULL default '',

q_DATE datetime NOT NULL default '0000-00-00 00:00:00',

q_QTID bigint(18) unsigned NOT NULL default '0',

q_ORDERDESC varchar(255) NOT NULL default '',

q_STATUS tinyint(1) NOT NULL default '0',

q_ORDERID int(11) unsigned NOT NULL default '0',

PRIMARY KEY? (q_TRID)

);





INSERT INTO `content_manager` VALUES (99998, 0, 0, '', 1, 'Sitemap', '', '', 0, 0, 'sitemap.php', 1, 8, 0);

INSERT INTO `content_manager` VALUES (99999, 0, 0, '', 2, 'Sitemap', '', '', 0, 0, 'sitemap.php', 1, 8, 0);

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'MAX_DISPLAY_NEW_PRODUCTS_DAYS', '30', 3, 22, 'NULL', '', NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'MO_PICS', '0', '4', '3', '', '0000-00-00 00:00:00', NULL , NULL);

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'IMAGE_MANIPULATOR', 'image_manipulator_GD2.php', '4', '3', '', '0000-00-00 00:00:00', NULL , 'xtc_cfg_select_option(array('image_manipulator_GD2.php', 'image_manipulator_GD1.php'),');

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'DB_CACHE', 'false', 11, 5, NULL, '', NULL, 'xtc_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'DB_CACHE_EXPIRE', '3600', 11, 6, NULL, '', NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'DOWNLOAD_UNALLOWED_PAYMENT', 'banktransfer,cod,invoice,moneyorder', 13, 5, NULL, '', NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'DOWNLOAD_MIN_ORDERS_STATUS', '1', 13, 5, NULL, '', NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'ACCOUNT_COMPANY_VAT_CHECK', 'true', 18, 4, '', '', NULL, 'xtc_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'STORE_OWNER_VAT_ID', '', 18, 3, '', '', NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'DEFAULT_CUSTOMERS_VAT_STATUS_ID', '1', 18, 23, '', '', 'xtc_get_customers_status_name', 'xtc_cfg_pull_down_customers_status_list(');

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'ACCOUNT_COMPANY_VAT_LIVE_CHECK', 'true', 18, 4, '', '', NULL, 'xtc_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'ACCOUNT_COMPANY_VAT_GROUP', 'true', 18, 4, '', '', NULL, 'xtc_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'ACCOUNT_VAT_BLOCK_ERROR', 'true', 18, 4, '', '', NULL, 'xtc_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GOOGLE_CONVERSION_ID', '', '19', '2', NULL , '0000-00-00 00:00:00', NULL , NULL);

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GOOGLE_LANG', 'de', '19', '3', NULL , '0000-00-00 00:00:00', NULL , NULL);

INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GOOGLE_CONVERSION', 'false', '19', '0', NULL , '0000-00-00 00:00:00', NULL , 'xtc_cfg_select_option(array('true', 'false'),');

INSERT INTO configuration_group VALUES ('18', 'Vat ID', 'Vat ID', '18', '1');

INSERT INTO configuration_group VALUES ('19', 'Google Conversion', 'Google Conversion-Tracking', '19', '1');

DELETE FROM configuration WHERE configuration_key = 'DOWNLOAD_MAX_DAYS';

DELETE FROM configuration WHERE configuration_key = 'DOWNLOAD_MAX_COUNT';


UPDATE zones_to_geo_zones SET geo_zone_id='5' WHERE zone_country_id='56';

UPDATE zones_to_geo_zones SET geo_zone_id='5' WHERE zone_country_id='189';

UPDATE zones_to_geo_zones SET geo_zone_id='5' WHERE zone_country_id='170';

UPDATE zones_to_geo_zones SET geo_zone_id='5' WHERE zone_country_id='97';

INSERT INTO `configuration` ( `configuration_id` , `configuration_key` , `configuration_value` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )

VALUES (

'', 'DEFAULT_CUSTOMERS_VAT_STATUS_ID_LOCAL', '3', '18', '24', NULL , '0000-00-00 00:00:00', 'xtc_get_customers_status_name', 'xtc_cfg_pull_down_customers_status_list('

);

DELETE FROM configuration WHERE configuration_key='SESSION_BLOCK_SPIDERS';






Falls ein eigenes Template verwendet wird, müssen folgende Änderungen durchgeführt werden:



module/login.html

<form action="{$FORM_ACTION}" method="post" name="login">

Durch

{$FORM_ACTION}

ersetzen


module/gift_cart.html

<form name="gift_coupon" action="{$FORM_ACTION}" method="post">

Durch

{$FORM_ACTION}

ersetzen


module/shopping_cart.html

<form name="cart_quantity" action="{$FORM_ACTION}" method="post">

Durch

{$FORM_ACTION}

ersetzen


module/product_info/*.html

<form name="cart_quantity" action="{$FORM_ACTION}" method="post">

Durch

{$FORM_ACTION}

ersetzen.