xt eCommerce Templates Module SEO Support: GPL Shop: Update 3.0.2 -> 3.0.3

[Pommes]

Update 3.0.2 --> 3.0.3
Shopsystem updaten

Schritt 1

Mache ein Backup aller Dateien Deines Shops und ebenfalls ein
Backup Deiner Datenbank. Benutze dazu phpMyadmin

Schritt 2

Benutze ein FTP Programm und überschreibe alle Dateien der alten 3.0.2 Version Deines Shops auf dem Server
mit den Dateien des xtcommerce Ordners im Update Archiv.
Einschließlich aller Ordner.

Du brauchst anschließend keine Neuinstallation durchzuführen.

Schritt 3

Benutzen phpMyadmin.

Zum Anpassen der 3.0.2er Datenbank an die 3.0.3er Datenbank führe bitte folgende SQL Befehle an Deiner Datenbank durch:

ALTER TABLE admin_access add popup_image int(1) NOT NULL default '0' AFTER orders_edit;
ALTER TABLE admin_access add csv_backend int(1) NOT NULL default '0' AFTER popup_image;
ALTER TABLE admin_access add products_vpe int(1) NOT NULL default '0' AFTER csv_backend;
UPDATE admin_access SET popup_image = '1',**csv_backend ='1', products_vpe = '1' WHERE customers_id = 1;
UPDATE admin_access SET popup_image = '2',**csv_backend ='2', products_vpe = '2' WHERE customers_id ='groups';
ALTER TABLE orders add afterbuy_success INT(1) DEFAULT'0' NOT NULL AFTER language;
ALTER TABLE orders add afterbuy_id INT(32) DEFAULT '0' NOT NULL AFTER afterbuy_success;

ALTER TABLE products add products_vpe int(11) NOT NULL AFTER products_fsk18;
ALTER TABLE products add products_vpe_status int(1) NOT NULL DEFAULT '0' AFTER products_vpe;
ALTER TABLE products add products_vpe_value decimal(15,4) NOT NULL AFTER products_vpe_status;

DROP TABLE IF EXISTS products_vpe;
CREATE TABLE products_vpe (
products_vpe_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '0',
products_vpe_name varchar(32) NOT NULL default ''
);

DELETE FROM configuration WHERE**configuration_key='ALLOW_GUEST_TO_TELL_A_FR IEND';


INSERT INTO configuration (configuration_id,**configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES** ('', 'DEFAULT_PRODUCTS_VPE_ID', '',**6, 0, 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** ('', 'CSV_TEXTSIGN', '"', '20', '1', 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** ('', 'CSV_SEPERATOR', ';', '20', '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** ('', 'COMPRESS_EXPORT', 'false', '20', '3', NULL , '0000-00-00 00:00:00', 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** ('', 'AFTERBUY_PARTNERID', '', '21', '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** ('', 'AFTERBUY_PARTNERPASS', '', '21', '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** ('', 'AFTERBUY_USERID', '', '21', '4', 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** ('', 'AFTERBUY_ORDERSTATUS', '0', '21', '5', NULL , '0000-00-00 00:00:00', 'xtc_get_order_status_name' , 'xtc_cfg_pull_down_order_statuses(');
INSERT INTO configuration (configuration_id,**configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES** ('', 'AFTERBUY_ACTIVATED', 'false', '21', '6', NULL , '0000-00-00 00:00:00', NULL , 'xtc_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration_group VALUES ('20', 'Import/Export', 'Import/Export', '20', '1');
INSERT INTO configuration_group VALUES ('21', 'Afterbuy', 'Afterbuy.de', '21', '1');


Schritt 4

Logge dich in Deinem Shop als Admin ein und wechseln in die Administrationsebene.
Dort kannst Du das neue xhtml Template "xtc3" unter
Konfiguration --> Mein Shop -->Templateset/Theme einstellen



Schritt 5

Inhalte der Ordner templates_c und cache löschen (bis auf index.html datei).


Update erfolgt auf eigene Gefahr !!!