function _crmInstall()
{
try {
$result = \Cx\Lib\UpdateUtil::sql('SELECT `id` FROM `' . DBPREFIX . 'core_text` WHERE `section` = \'crm\'');
if (!$result || $result->RecordCount() == 0) {
// add core mail template table because it is possible it doesn't yet exist
\Cx\Lib\UpdateUtil::table(DBPREFIX . 'core_mail_template', array('key' => array('type' => 'tinytext'), 'section' => array('type' => 'tinytext', 'after' => 'key'), 'text_id' => array('type' => 'INT(10)', 'unsigned' => true, 'after' => 'section'), 'html' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'text_id'), 'protected' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'html')), null, 'MyISAM', 'cx3upgrade');
Cx\Lib\UpdateUtil::sql("\n ALTER TABLE `" . DBPREFIX . "core_mail_template`\n ADD PRIMARY KEY (`key` (32), `section` (32))\n ");
// migrate mail templates
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_bcc\', \'\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_cc\', \'\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_from\', \'info@example.com\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_message\', \'Guten Tag,\\r\\n\\r\\nNachfolgend erhalten Sie Ihre persönlichen Zugangsdaten zur Website http://www.example.com/\\r\\n\\r\\nBenutzername: [CRM_CONTACT_USERNAME]\\r\\nKennwort: [CRM_CONTACT_PASSWORD]\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_message_html\', \'<div>Guten Tag,<br />\\r\\n<br />\\r\\nNachfolgend erhalten Sie Ihre persönlichen Zugangsdaten zur Website <a href="http://www.example.com/">http://www.example.com/</a><br />\\r\\n<br />\\r\\nBenutzername: [CRM_CONTACT_USERNAME]<br />\\r\\nKennwort: [CRM_CONTACT_PASSWORD]</div>\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_name\', \'Benachrichtigung über Benutzerkonto\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_reply\', \'info@example.com\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_sender\', \'Ihr Firmenname\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_subject\', \'Ihr persönlischer Zugang\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_to\', \'[CRM_CONTACT_EMAIL]\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_bcc\', \'\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_cc\', \'\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_from\', \'info@example.com\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_message\', \'Der Mitarbeiter [CRM_TASK_CREATED_USER] hat eine neue Aufgabe erstellt und Ihnen zugewiesen: [CRM_TASK_URL]\\r\\n\\r\\nBeschreibung: [CRM_TASK_DESCRIPTION_TEXT_VERSION]\\r\\n\\r\\nFällig am: [CRM_TASK_DUE_DATE]\\r\\n\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_message_html\', \'<div style="padding:0px; margin:0px; font-family:Tahoma, sans-serif; font-size:14px; width:620px; color: #333;">\\r\\n<div style="padding: 0px 20px; border:1px solid #e0e0e0; margin-bottom: 10px; width:618px;">\\r\\n<h1 style="background-color: #e0e0e0;color: #3d4a6b;font-size: 18px;font-weight: normal;padding: 15px 20px;margin-top: 0 !important;margin-bottom: 0 !important;margin-left: -20px !important;margin-right: -20px !important;-webkit-margin-before: 0 !important;-webkit-margin-after: 0 !important;-webkit-margin-start: -20px !important;-webkit-margin-end: -20px !important;">Neue Aufgabe wurde Ihnen zugewiesen</h1>\\r\\n\\r\\n<p style="margin-top: 20px;word-wrap: break-word !important;">Der Mitarbeiter [CRM_TASK_CREATED_USER] hat eine neue Aufgabe erstellt und Ihnen zugewiesen: [CRM_TASK_LINK]</p>\\r\\n\\r\\n<p style="margin-top: 20px;word-wrap: break-word !important;">Beschreibung: [CRM_TASK_DESCRIPTION_HTML_VERSION]<br />\\r\\nFällig am: [CRM_TASK_DUE_DATE]</p>\\r\\n</div>\\r\\n</div>\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_name\', \'Neue Aufgabe\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_reply\', \'info@example.com\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_sender\', \'Ihr Firmenname\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_subject\', \'Neue Aufgabe : [CRM_TASK_NAME]\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_to\', \'[CRM_ASSIGNED_USER_EMAIL]\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_bcc\', \'\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_cc\', \'\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_from\', \'info@example.com\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_message\', \'Im CRM wurde ein neuer Kontakt erfasst: [CRM_CONTACT_DETAILS_URL]\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_message_html\', \'<div style="padding:0px; margin:0px; font-family:Tahoma, sans-serif; font-size:14px; width:620px; color: #333;">\\r\\n<div style="padding: 0px 20px; border:1px solid #e0e0e0; margin-bottom: 10px; width:618px;">\\r\\n<h1 style="background-color: #e0e0e0;color: #3d4a6b;font-size: 18px;font-weight: normal;padding: 15px 20px;margin-top: 0 !important;margin-bottom: 0 !important;margin-left: -20px !important;margin-right: -20px !important;-webkit-margin-before: 0 !important;-webkit-margin-after: 0 !important;-webkit-margin-start: -20px !important;-webkit-margin-end: -20px !important;">Neuer Kontakt im CRM</h1>\\r\\n\\r\\n<p style="margin-top: 20px;word-wrap: break-word !important;">Neuer Kontakt: [CRM_CONTACT_DETAILS_LINK].</p>\\r\\n</div>\\r\\n</div>\\r\\n\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_name\', \'Benachrichtigung an Mitarbeiter über neue Kontakte\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_reply\', \'info@example.com\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_sender\', \'Ihr Firmenname\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_subject\', \'Neuer Kontakt erfasst\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_to\', \'[CRM_ASSIGNED_USER_EMAIL]\')');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_mail_template` (`key`, `section`, `text_id`, `html`, `protected`) VALUES(\'crm_user_account_created\', \'crm\', 12, 1, 1)');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_mail_template` (`key`, `section`, `text_id`, `html`, `protected`) VALUES(\'crm_notify_staff_on_contact_added\', \'crm\', 14, 1, 1)');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_mail_template` (`key`, `section`, `text_id`, `html`, `protected`) VALUES(\'crm_task_assigned\', \'crm\', 13, 1, 1)');
\Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES (\'crm\',\'numof_mailtemplate_per_page_backend\',\'config\',\'text\',\'25\',\'\',1001)');
}
} catch (\Cx\Lib\UpdateException $e) {
return \Cx\Lib\UpdateUtil::DefaultActionHandler($e);
}
}
function _shopInstall()
{
try {
\Cx\Lib\UpdateUtil::table(DBPREFIX . 'core_country', array('id' => array('type' => 'INT(10)', 'unsigned' => true, 'notnull' => true, 'auto_increment' => true, 'primary' => true), 'alpha2' => array('type' => 'CHAR(2)', 'notnull' => true, 'default' => '', 'after' => 'id'), 'alpha3' => array('type' => 'CHAR(3)', 'notnull' => true, 'default' => '', 'after' => 'alpha2'), 'ord' => array('type' => 'INT(5)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'alpha3'), 'active' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '1', 'after' => 'ord')), null, 'MyISAM', 'cx3upgrade');
\Cx\Lib\UpdateUtil::sql("\n INSERT INTO `" . DBPREFIX . "core_country` (`id`, `alpha2`, `alpha3`, `ord`, `active`)\n VALUES (1, 'AF', 'AFG', 0, 0),\n (2, 'AL', 'ALB', 0, 0),\n (3, 'DZ', 'DZA', 0, 0),\n (4, 'AS', 'ASM', 0, 0),\n (5, 'AD', 'AND', 0, 0),\n (6, 'AO', 'AGO', 0, 0),\n (7, 'AI', 'AIA', 0, 0),\n (8, 'AQ', 'ATA', 0, 0),\n (9, 'AG', 'ATG', 0, 0),\n (10, 'AR', 'ARG', 0, 0),\n (11, 'AM', 'ARM', 0, 0),\n (12, 'AW', 'ABW', 0, 0),\n (13, 'AU', 'AUS', 0, 0),\n (14, 'AT', 'AUT', 0, 1),\n (15, 'AZ', 'AZE', 0, 0),\n (16, 'BS', 'BHS', 0, 0),\n (17, 'BH', 'BHR', 0, 0),\n (18, 'BD', 'BGD', 0, 0),\n (19, 'BB', 'BRB', 0, 0),\n (20, 'BY', 'BLR', 0, 0),\n (21, 'BE', 'BEL', 0, 0),\n (22, 'BZ', 'BLZ', 0, 0),\n (23, 'BJ', 'BEN', 0, 0),\n (24, 'BM', 'BMU', 0, 0),\n (25, 'BT', 'BTN', 0, 0),\n (26, 'BO', 'BOL', 0, 0),\n (27, 'BA', 'BIH', 0, 0),\n (28, 'BW', 'BWA', 0, 0),\n (29, 'BV', 'BVT', 0, 0),\n (30, 'BR', 'BRA', 0, 0),\n (31, 'IO', 'IOT', 0, 0),\n (32, 'BN', 'BRN', 0, 0),\n (33, 'BG', 'BGR', 0, 0),\n (34, 'BF', 'BFA', 0, 0),\n (35, 'BI', 'BDI', 0, 0),\n (36, 'KH', 'KHM', 0, 0),\n (37, 'CM', 'CMR', 0, 0),\n (38, 'CA', 'CAN', 0, 0),\n (39, 'CV', 'CPV', 0, 0),\n (40, 'KY', 'CYM', 0, 0),\n (41, 'CF', 'CAF', 0, 0),\n (42, 'TD', 'TCD', 0, 0),\n (43, 'CL', 'CHL', 0, 0),\n (44, 'CN', 'CHN', 0, 0),\n (45, 'CX', 'CXR', 0, 0),\n (46, 'CC', 'CCK', 0, 0),\n (47, 'CO', 'COL', 0, 0),\n (48, 'KM', 'COM', 0, 0),\n (49, 'CG', 'COG', 0, 0),\n (50, 'CK', 'C*K', 0, 0),\n (51, 'CR', 'CRI', 0, 0),\n (52, 'CI', 'CIV', 0, 0),\n (53, 'HR', 'HRV', 0, 0),\n (54, 'CU', 'CUB', 0, 0),\n (55, 'CY', 'CYP', 0, 0),\n (56, 'CZ', 'CZE', 0, 0),\n (57, 'DK', 'DNK', 0, 0),\n (58, 'DJ', 'DJI', 0, 0),\n (59, 'DM', 'DMA', 0, 0),\n (60, 'DO', 'DOM', 0, 0),\n (61, 'TP', 'TMP', 0, 0),\n (62, 'EC', 'ECU', 0, 0),\n (63, 'EG', 'EGY', 0, 0),\n (64, 'SV', 'SLV', 0, 0),\n (65, 'GQ', 'GNQ', 0, 0),\n (66, 'ER', 'ERI', 0, 0),\n (67, 'EE', 'EST', 0, 0),\n (68, 'ET', 'ETH', 0, 0),\n (69, 'FK', 'FLK', 0, 0),\n (70, 'FO', 'FRO', 0, 0),\n (71, 'FJ', 'FJI', 0, 0),\n (72, 'FI', 'FIN', 0, 0),\n (73, 'FR', 'FRA', 0, 0),\n (74, 'FX', 'FXX', 0, 0),\n (75, 'GF', 'GUF', 0, 0),\n (76, 'PF', 'PYF', 0, 0),\n (77, 'TF', 'ATF', 0, 0),\n (78, 'GA', 'GAB', 0, 0),\n (79, 'GM', 'GMB', 0, 0),\n (80, 'GE', 'GEO', 0, 0),\n (81, 'DE', 'DEU', 0, 1),\n (82, 'GH', 'GHA', 0, 0),\n (83, 'GI', 'GIB', 0, 0),\n (84, 'GR', 'GRC', 0, 0),\n (85, 'GL', 'GRL', 0, 0),\n (86, 'GD', 'GRD', 0, 0),\n (87, 'GP', 'GLP', 0, 0),\n (88, 'GU', 'GUM', 0, 0),\n (89, 'GT', 'GTM', 0, 0),\n (90, 'GN', 'GIN', 0, 0),\n (91, 'GW', 'GNB', 0, 0),\n (92, 'GY', 'GUY', 0, 0),\n (93, 'HT', 'HTI', 0, 0),\n (94, 'HM', 'HMD', 0, 0),\n (95, 'HN', 'HND', 0, 0),\n (96, 'HK', 'HKG', 0, 0),\n (97, 'HU', 'HUN', 0, 0),\n (98, 'IS', 'ISL', 0, 0),\n (99, 'IN', 'IND', 0, 0),\n (100, 'ID', 'IDN', 0, 0),\n (101, 'IR', 'IRN', 0, 0),\n (102, 'IQ', 'IRQ', 0, 0),\n (103, 'IE', 'IRL', 0, 0),\n (104, 'IL', 'ISR', 0, 0),\n (105, 'IT', 'ITA', 0, 0),\n (106, 'JM', 'JAM', 0, 0),\n (107, 'JP', 'JPN', 0, 0),\n (108, 'JO', 'JOR', 0, 0),\n (109, 'KZ', 'KAZ', 0, 0),\n (110, 'KE', 'KEN', 0, 0),\n (111, 'KI', 'KIR', 0, 0),\n (112, 'KP', 'PRK', 0, 0),\n (113, 'KR', 'KOR', 0, 0),\n (114, 'KW', 'KWT', 0, 0),\n (115, 'KG', 'KGZ', 0, 0),\n (116, 'LA', 'LAO', 0, 0),\n (117, 'LV', 'LVA', 0, 0),\n (118, 'LB', 'LBN', 0, 0),\n (119, 'LS', 'LSO', 0, 0),\n (120, 'LR', 'LBR', 0, 0),\n (121, 'LY', 'LBY', 0, 0),\n (122, 'LI', 'LIE', 0, 1),\n (123, 'LT', 'LTU', 0, 0),\n (124, 'LU', 'LUX', 0, 0),\n (125, 'MO', 'MAC', 0, 0),\n (126, 'MK', 'MKD', 0, 0),\n (127, 'MG', 'MDG', 0, 0),\n (128, 'MW', 'MWI', 0, 0),\n (129, 'MY', 'MYS', 0, 0),\n (130, 'MV', 'MDV', 0, 0),\n (131, 'ML', 'MLI', 0, 0),\n (132, 'MT', 'MLT', 0, 0),\n (133, 'MH', 'MHL', 0, 0),\n (134, 'MQ', 'MTQ', 0, 0),\n (135, 'MR', 'MRT', 0, 0),\n (136, 'MU', 'MUS', 0, 0),\n (137, 'YT', 'MYT', 0, 0),\n (138, 'MX', 'MEX', 0, 0),\n (139, 'FM', 'FSM', 0, 0),\n (140, 'MD', 'MDA', 0, 0),\n (141, 'MC', 'MCO', 0, 0),\n (142, 'MN', 'MNG', 0, 0),\n (143, 'MS', 'MSR', 0, 0),\n (144, 'MA', 'MAR', 0, 0),\n (145, 'MZ', 'MOZ', 0, 0),\n (146, 'MM', 'MMR', 0, 0),\n (147, 'NA', 'NAM', 0, 0),\n (148, 'NR', 'NRU', 0, 0),\n (149, 'NP', 'NPL', 0, 0),\n (150, 'NL', 'NLD', 0, 0),\n (151, 'AN', 'ANT', 0, 0),\n (152, 'NC', 'NCL', 0, 0),\n (153, 'NZ', 'NZL', 0, 0),\n (154, 'NI', 'NIC', 0, 0),\n (155, 'NE', 'NER', 0, 0),\n (156, 'NG', 'NGA', 0, 0),\n (157, 'NU', 'NIU', 0, 0),\n (158, 'NF', 'NFK', 0, 0),\n (159, 'MP', 'MNP', 0, 0),\n (160, 'NO', 'NOR', 0, 0),\n (161, 'OM', 'OMN', 0, 0),\n (162, 'PK', 'PAK', 0, 0),\n (163, 'PW', 'PLW', 0, 0),\n (164, 'PA', 'PAN', 0, 0),\n (165, 'PG', 'PNG', 0, 0),\n (166, 'PY', 'PRY', 0, 0),\n (167, 'PE', 'PER', 0, 0),\n (168, 'PH', 'PHL', 0, 0),\n (169, 'PN', 'PCN', 0, 0),\n (170, 'PL', 'POL', 0, 0),\n (171, 'PT', 'PRT', 0, 0),\n (172, 'PR', 'PRI', 0, 0),\n (173, 'QA', 'QAT', 0, 0),\n (174, 'RE', 'REU', 0, 0),\n (175, 'RO', 'ROM', 0, 0),\n (176, 'RU', 'RUS', 0, 0),\n (177, 'RW', 'RWA', 0, 0),\n (178, 'KN', 'KNA', 0, 0),\n (179, 'LC', 'LCA', 0, 0),\n (180, 'VC', 'VCT', 0, 0),\n (181, 'WS', 'WSM', 0, 0),\n (182, 'SM', 'SMR', 0, 0),\n (183, 'ST', 'STP', 0, 0),\n (184, 'SA', 'SAU', 0, 0),\n (185, 'SN', 'SEN', 0, 0),\n (186, 'SC', 'SYC', 0, 0),\n (187, 'SL', 'SLE', 0, 0),\n (188, 'SG', 'SGP', 0, 0),\n (189, 'SK', 'SVK', 0, 0),\n (190, 'SI', 'SVN', 0, 0),\n (191, 'SB', 'SLB', 0, 0),\n (192, 'SO', 'SOM', 0, 0),\n (193, 'ZA', 'ZAF', 0, 0),\n (194, 'GS', 'SGS', 0, 0),\n (195, 'ES', 'ESP', 0, 0),\n (196, 'LK', 'LKA', 0, 0),\n (197, 'SH', 'SHN', 0, 0),\n (198, 'PM', 'SPM', 0, 0),\n (199, 'SD', 'SDN', 0, 0),\n (200, 'SR', 'SUR', 0, 0),\n (201, 'SJ', 'SJM', 0, 0),\n (202, 'SZ', 'SWZ', 0, 0),\n (203, 'SE', 'SWE', 0, 0),\n (204, 'CH', 'CHE', 0, 1),\n (205, 'SY', 'SYR', 0, 0),\n (206, 'TW', 'TWN', 0, 0),\n (207, 'TJ', 'TJK', 0, 0),\n (208, 'TZ', 'TZA', 0, 0),\n (209, 'TH', 'THA', 0, 0),\n (210, 'TG', 'TGO', 0, 0),\n (211, 'TK', 'TKL', 0, 0),\n (212, 'TO', 'TON', 0, 0),\n (213, 'TT', 'TTO', 0, 0),\n (214, 'TN', 'TUN', 0, 0),\n (215, 'TR', 'TUR', 0, 0),\n (216, 'TM', 'TKM', 0, 0),\n (217, 'TC', 'TCA', 0, 0),\n (218, 'TV', 'TUV', 0, 0),\n (219, 'UG', 'UGA', 0, 0),\n (220, 'UA', 'UKR', 0, 0),\n (221, 'AE', 'ARE', 0, 0),\n (222, 'GB', 'GBR', 0, 0),\n (223, 'US', 'USA', 0, 0),\n (224, 'UM', 'UMI', 0, 0),\n (225, 'UY', 'URY', 0, 0),\n (226, 'UZ', 'UZB', 0, 0),\n (227, 'VU', 'VUT', 0, 0),\n (228, 'VA', 'VAT', 0, 0),\n (229, 'VE', 'VEN', 0, 0),\n (230, 'VN', 'VNM', 0, 0),\n (231, 'VG', 'VGB', 0, 0),\n (232, 'VI', 'VIR', 0, 0),\n (233, 'WF', 'WLF', 0, 0),\n (234, 'EH', 'ESH', 0, 0),\n (235, 'YE', 'YEM', 0, 0),\n (236, 'YU', 'YUG', 0, 0),\n (237, 'ZR', 'ZAR', 0, 0),\n (238, 'ZM', 'ZMB', 0, 0),\n (239, 'ZW', 'ZWE', 0, 0)\n ON DUPLICATE KEY UPDATE `id` = `id`\n ");
\Cx\Lib\UpdateUtil::table(DBPREFIX . 'core_mail_template', array('key' => array('type' => 'tinytext'), 'section' => array('type' => 'tinytext', 'after' => 'key'), 'text_id' => array('type' => 'INT(10)', 'unsigned' => true, 'after' => 'section'), 'html' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'text_id'), 'protected' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'html')), null, 'MyISAM', 'cx3upgrade');
Cx\Lib\UpdateUtil::sql("\n ALTER TABLE `" . DBPREFIX . "core_mail_template`\n ADD PRIMARY KEY (`key` (32), `section` (32))\n ");
\Cx\Lib\UpdateUtil::sql("\n INSERT INTO `" . DBPREFIX . "core_mail_template` (`key`, `section`, `text_id`, `html`, `protected`)\n VALUES ('customer_login', 'shop', 1, 1, 1),\n ('order_complete', 'shop', 2, 1, 1),\n ('order_confirmation', 'shop', 3, 1, 1)\n ON DUPLICATE KEY UPDATE `key` = `key`\n ");
\Cx\Lib\UpdateUtil::table(DBPREFIX . 'core_setting', array('section' => array('type' => 'VARCHAR(32)', 'default' => '', 'primary' => true), 'name' => array('type' => 'VARCHAR(255)', 'default' => '', 'primary' => true), 'group' => array('type' => 'VARCHAR(32)', 'default' => '', 'primary' => true), 'type' => array('type' => 'VARCHAR(32)', 'notnull' => true, 'default' => 'text', 'after' => 'group'), 'value' => array('type' => 'text', 'notnull' => true, 'after' => 'type'), 'values' => array('type' => 'text', 'notnull' => true, 'after' => 'value'), 'ord' => array('type' => 'INT(10)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'values')), null, 'MyISAM', 'cx3upgrade');
\Cx\Lib\UpdateUtil::sql("\n INSERT INTO `" . DBPREFIX . "core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`)\n VALUES ('core', 'numof_countries_per_page_backend', 'country', 'text', '30', '', 101),\n ('shop', 'address', 'config', 'text', 'MaxMuster AG\r\nFirmenstrasse 1\r\n4321 Irgendwo', '', 20),\n ('shop', 'company', 'config', 'text', 'MaxMuster AG', '', 19),\n ('shop', 'country_id', 'config', 'text', '204', '', 13),\n ('shop', 'datatrans_active', 'config', 'text', '1', '', 29),\n ('shop', 'datatrans_merchant_id', 'config', 'text', '123456789', '', 28),\n ('shop', 'datatrans_request_type', 'config', 'text', 'CAA', '', 30),\n ('shop', 'datatrans_use_testserver', 'config', 'text', '1', '', 31),\n ('shop', 'email', 'config', 'text', '*****@*****.**', '', 1),\n ('shop', 'email_confirmation', 'config', 'text', '*****@*****.**', '', 5),\n ('shop', 'fax', 'config', 'text', '012 3456790', '', 7),\n ('shop', 'numof_coupon_per_page_backend', 'config', 'text', '25', '', 58),\n ('shop', 'numof_customers_per_page_backend', 'config', 'text', '25', '', 55),\n ('shop', 'numof_mailtemplate_per_page_backend', 'config', 'text', '25', '', 57),\n ('shop', 'numof_manufacturers_per_page_backend', 'config', 'text', '25', '', 56),\n ('shop', 'numof_orders_per_page_backend', 'config', 'text', '25', '', 54),\n ('shop', 'numof_products_per_page_backend', 'config', 'text', '25', '', 216),\n ('shop', 'numof_products_per_page_frontend', 'config', 'text', '25', '', 53),\n ('shop', 'orderitems_amount_max', 'config', 'text', '0', '', 45),\n ('shop', 'payment_lsv_active', 'config', 'text', '1', '', 18),\n ('shop', 'paypal_account_email', 'config', 'text', '*****@*****.**', '', 9),\n ('shop', 'paypal_active', 'config', 'text', '1', '', 10),\n ('shop', 'paypal_default_currency', 'config', 'text', 'EUR', '', 17),\n ('shop', 'postfinance_accepted_payment_methods', 'config', 'text', '', '', 25),\n ('shop', 'postfinance_active', 'config', 'text', '1', '', 12),\n ('shop', 'postfinance_authorization_type', 'config', 'text', 'SAL', '', 8),\n ('shop', 'postfinance_hash_signature_in', 'config', 'text', 'sech10zeichenminimum', '', 47),\n ('shop', 'postfinance_hash_signature_out', 'config', 'text', 'sech10zeichenminimum', '', 48),\n ('shop', 'postfinance_mobile_ijustwanttotest', 'config', 'text', '1', '', 51),\n ('shop', 'postfinance_mobile_sign', 'config', 'text', 'geheime_signatur', '', 50),\n ('shop', 'postfinance_mobile_status', 'config', 'text', '0', '', 52),\n ('shop', 'postfinance_mobile_webuser', 'config', 'text', 'Benutzername', '', 49),\n ('shop', 'postfinance_shop_id', 'config', 'text', 'demoShop', '', 11),\n ('shop', 'postfinance_use_testserver', 'config', 'text', '1', '', 26),\n ('shop', 'product_sorting', 'config', 'text', '1', '', 27),\n ('shop', 'register', 'config', 'dropdown', 'optional', '0:mandatory,1:optional,2:none', 46),\n ('shop', 'saferpay_active', 'config', 'text', '1', '', 3),\n ('shop', 'saferpay_finalize_payment', 'config', 'text', '1', '', 15),\n ('shop', 'saferpay_id', 'config', 'text', '12345-12345678', '', 2),\n ('shop', 'saferpay_use_test_account', 'config', 'text', '1', '', 14),\n ('shop', 'saferpay_window_option', 'config', 'text', '2', '', 16),\n ('shop', 'show_products_default', 'config', 'text', '1', '', 32),\n ('shop', 'telephone', 'config', 'text', '012 3456789', '', 6),\n ('shop', 'thumbnail_max_height', 'config', 'text', '999', '', 22),\n ('shop', 'thumbnail_max_width', 'config', 'text', '180', '', 21),\n ('shop', 'thumbnail_quality', 'config', 'text', '95', '', 23),\n ('shop', 'user_profile_attribute_customer_group_id', 'config', 'dropdown_user_custom_attribute', '2', '', 351),\n ('shop', 'user_profile_attribute_notes', 'config', 'dropdown_user_custom_attribute', '1', '', 352),\n ('shop', 'usergroup_id_customer', 'config', 'dropdown_usergroup', '6', '', 341),\n ('shop', 'usergroup_id_reseller', 'config', 'dropdown_usergroup', '7', '', 342),\n ('shop', 'vat_default_id', 'config', 'text', '1', '', 41),\n ('shop', 'vat_enabled_foreign_customer', 'config', 'text', '0', '', 33),\n ('shop', 'vat_enabled_foreign_reseller', 'config', 'text', '0', '', 34),\n ('shop', 'vat_enabled_home_customer', 'config', 'text', '1', '', 35),\n ('shop', 'vat_enabled_home_reseller', 'config', 'text', '1', '', 36),\n ('shop', 'vat_included_foreign_customer', 'config', 'text', '0', '', 37),\n ('shop', 'vat_included_foreign_reseller', 'config', 'text', '0', '', 38),\n ('shop', 'vat_included_home_customer', 'config', 'text', '1', '', 39),\n ('shop', 'vat_included_home_reseller', 'config', 'text', '1', '', 40),\n ('shop', 'vat_other_id', 'config', 'text', '1', '', 42),\n ('shop', 'weight_enable', 'config', 'text', '0', '', 24),\n ('egov', 'postfinance_shop_id', 'config', 'text', 'Ihr Kontoname', '', 1),\n ('egov', 'postfinance_active', 'config', 'checkbox', '0', '1', 2),\n ('egov', 'postfinance_authorization_type', 'config', 'dropdown', 'SAL', 'RES:Reservation,SAL:Verkauf', 3),\n ('egov', 'postfinance_hash_signature_in', 'config', 'text', 'Mindestens 16 Buchstaben, Ziffern und Zeichen', '', 5),\n ('egov', 'postfinance_hash_signature_out', 'config', 'text', 'Mindestens 16 Buchstaben, Ziffern und Zeichen', '', 6),\n ('egov', 'postfinance_use_testserver', 'config', 'checkbox', '1', '1', 7),\n ('shop', 'use_js_cart', 'config', 'checkbox', '0', '1', 47),\n ('shop', 'shopnavbar_on_all_pages', 'config', 'checkbox', '1', '1', 48),\n ('filesharing', 'permission', 'config', 'text', 'off', '', 0),\n ('shop','payment_lsv_active','config','text','1','','18'),\n ('shop','paymill_active','config','text','1','',3),\n ('shop','paymill_live_private_key','config','text','','',0),\n ('shop','paymill_live_public_key','config','text','','',0),\n ('shop','paymill_live_public_key','config','text','','',0),\n ('shop','paymill_test_private_key','config','text','','',2),\n ('shop','paymill_test_public_key','config','text','','',16),\n ('shop','paymill_use_test_account','config','text','0','',15)\n ON DUPLICATE KEY UPDATE `section` = `section`\n ");
\Cx\Lib\UpdateUtil::table(DBPREFIX . 'core_text', array('id' => array('type' => 'INT(10)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'primary' => true), 'lang_id' => array('type' => 'INT(10)', 'unsigned' => true, 'notnull' => true, 'default' => '1', 'primary' => true, 'after' => 'id'), 'section' => array('type' => 'VARCHAR(32)', 'notnull' => true, 'default' => '', 'primary' => true, 'after' => 'lang_id'), 'key' => array('type' => 'VARCHAR(255)', 'notnull' => true, 'primary' => 32, 'after' => 'section'), 'text' => array('type' => 'text', 'after' => 'key')), array('text' => array('fields' => array('text'), 'type' => 'FULLTEXT')), 'MyISAM', 'cx3upgrade');
\Cx\Lib\UpdateUtil::sql("\n INSERT INTO `" . DBPREFIX . "core_text` (`id`, `lang_id`, `section`, `key`, `text`)\n VALUES (1, 1, 'core', 'core_country_name', 'Afghanistan'),\n (1, 1, 'shop', 'attribute_name', 'Zusatzleistungen'),\n (1, 1, 'shop', 'core_mail_template_bcc', ''),\n (1, 1, 'shop', 'core_mail_template_cc', ''),\n (1, 1, 'shop', 'core_mail_template_from', '*****@*****.**'),\n (1, 1, 'shop', 'core_mail_template_message', '[CUSTOMER_SALUTATION]\r\n\r\nHier Ihre Zugangsdaten zum Shop:[[CUSTOMER_LOGIN]\r\nBenutzername: [CUSTOMER_USERNAME]\r\nPasswort: [CUSTOMER_PASSWORD][CUSTOMER_LOGIN]]\r\n\r\nMit freundlichen Grüssen\r\nIhr [SHOP_COMPANY] Online Shop Team\r\n\r\n[SHOP_HOMEPAGE]\r\n'),\n (1, 1, 'shop', 'core_mail_template_message_html', '[CUSTOMER_SALUTATION]<br />\r\n<br />\r\nHier Ihre Zugangsdaten zum Shop:<br /><!-- [[CUSTOMER_LOGIN] -->\r\nBenutzername: [CUSTOMER_USERNAME]<br />\r\nPasswort: [CUSTOMER_PASSWORD]<br /><!-- [CUSTOMER_LOGIN]] -->\r\n<br />\r\nMit freundlichen Grüssen<br />\r\nIhr [SHOP_COMPANY] Online Shop Team<br />\r\n<br />\r\n[SHOP_HOMEPAGE]<br />\r\n'),\n (1, 1, 'shop', 'core_mail_template_name', 'Zugangsdaten'),\n (1, 1, 'shop', 'core_mail_template_reply', '*****@*****.**'),\n (1, 1, 'shop', 'core_mail_template_sender', 'Contrexx Demo'),\n (1, 1, 'shop', 'core_mail_template_subject', 'Zugangsdaten'),\n (1, 1, 'shop', 'core_mail_template_to', '*****@*****.**'),\n (1, 1, 'shop', 'discount_group_article', 'Telefone'),\n (1, 1, 'shop', 'discount_group_customer', 'Neukunden'),\n (1, 1, 'shop', 'discount_group_name', 'Mengenrabatt'),\n (1, 1, 'shop', 'discount_group_unit', 'Stück'),\n (1, 1, 'shop', 'manufacturer_name', 'Comvation Internet Solutions'),\n (1, 1, 'shop', 'manufacturer_uri', 'http://www.comvation.com'),\n (1, 1, 'shop', 'option_name', 'Leder-Etui'),\n (12, 1, 'shop', 'product_uri', 'http://www.htc.com/de/'),\n (1, 1, 'shop', 'shipper_name', 'PostPac Priority'),\n (1, 1, 'shop', 'vat_class', 'Nicht Taxpflichtig'),\n (1, 1, 'shop', 'zone_name', 'All'),\n (1, 2, 'shop', 'category_name', 'Gadgets'),\n (1, 2, 'shop', 'currency_name', 'Schweizer Franken'),\n (2, 1, 'core', 'core_country_name', 'Albania'),\n (2, 1, 'shop', 'core_mail_template_bcc', ''),\n (2, 1, 'shop', 'core_mail_template_cc', ''),\n (2, 1, 'shop', 'core_mail_template_from', '*****@*****.**'),\n (2, 1, 'shop', 'core_mail_template_message', '[CUSTOMER_SALUTATION]\r\n\r\nIhre Bestellung wurde ausgeführt. Sie werden in den nächsten Tagen ihre Lieferung erhalten.\r\n\r\nHerzlichen Dank für das Vertrauen.\r\nWir würden uns freuen, wenn Sie uns weiterempfehlen und wünschen Ihnen noch einen schönen Tag.\r\n\r\nMit freundlichen Grüssen\r\nIhr [SHOP_COMPANY] Online Shop Team\r\n\r\n[SHOP_HOMEPAGE]\r\n'),\n (2, 1, 'shop', 'core_mail_template_name', 'Auftrag abgeschlossen'),\n (2, 1, 'shop', 'core_mail_template_reply', '*****@*****.**'),\n (2, 1, 'shop', 'core_mail_template_sender', 'Contrexx Demo'),\n (2, 1, 'shop', 'core_mail_template_subject', 'Auftrag abgeschlossen'),\n (2, 1, 'shop', 'core_mail_template_to', '*****@*****.**'),\n (2, 1, 'shop', 'discount_group_customer', 'Stammkunden'),\n (2, 1, 'shop', 'manufacturer_name', 'Apple, Inc.'),\n (2, 1, 'shop', 'manufacturer_uri', 'http://www.apple.com/'),\n (2, 1, 'shop', 'option_name', 'Pimp my Handy Kit'),\n (2, 1, 'shop', 'payment_name', 'VISA, Mastercard (Saferpay)'),\n (2, 1, 'shop', 'shipper_name', 'Express Post'),\n (2, 1, 'shop', 'vat_class', 'Deutschland Normalsatz'),\n (2, 1, 'shop', 'zone_name', 'Schweiz'),\n (3, 1, 'core', 'core_country_name', 'Algeria'),\n (3, 1, 'shop', 'core_mail_template_bcc', ''),\n (3, 1, 'shop', 'core_mail_template_cc', ''),\n (3, 1, 'shop', 'core_mail_template_from', '*****@*****.**'),\n (3, 1, 'shop', 'core_mail_template_message', '[CUSTOMER_SALUTATION],\r\n\r\nHerzlichen Dank für Ihre Bestellung im [SHOP_COMPANY] Online Shop.\r\n\r\nIhre Auftrags-Nr. lautet: [ORDER_ID]\r\nIhre Kunden-Nr. lautet: [CUSTOMER_ID]\r\nBestellungszeit: [ORDER_DATE] [ORDER_TIME]\r\n\r\n------------------------------------------------------------------------\r\nBestellinformationen\r\n------------------------------------------------------------------------[[ORDER_ITEM]\r\nID: [PRODUCT_ID]\r\nArtikel Nr.: [PRODUCT_CODE]\r\nMenge: [PRODUCT_QUANTITY]\r\nBeschreibung: [PRODUCT_TITLE][[PRODUCT_OPTIONS]\r\n [PRODUCT_OPTIONS][PRODUCT_OPTIONS]]\r\nStückpreis: [PRODUCT_ITEM_PRICE] [CURRENCY] Total [PRODUCT_TOTAL_PRICE] [CURRENCY][[USER_DATA]\r\nBenutzername: [USER_NAME]\r\nPasswort: [USER_PASS][USER_DATA]][[COUPON_DATA]\r\nGutschein Code: [COUPON_CODE][COUPON_DATA]][ORDER_ITEM]]\r\n------------------------------------------------------------------------\r\nZwischensumme: [ORDER_ITEM_COUNT] Artikel [ORDER_ITEM_SUM] [CURRENCY][[DISCOUNT_COUPON]\r\nGutschein Code: [DISCOUNT_COUPON_CODE] [DISCOUNT_COUPON_AMOUNT] [CURRENCY][DISCOUNT_COUPON]]\r\n------------------------------------------------------------------------[[SHIPMENT]\r\nVersandart: [SHIPMENT_NAME] [SHIPMENT_PRICE] [CURRENCY][SHIPMENT]][[PAYMENT]\r\nBezahlung: [PAYMENT_NAME] [PAYMENT_PRICE] [CURRENCY][PAYMENT]][[TAX]\r\n[TAX_TEXT] [TAX_PRICE] [CURRENCY][TAX]]\r\n------------------------------------------------------------------------\r\nGesamtsumme [ORDER_SUM] [CURRENCY]\r\n------------------------------------------------------------------------\r\n\r\nIhre Kundenadresse:\r\n[CUSTOMER_COMPANY]\r\n[CUSTOMER_FIRSTNAME] [CUSTOMER_LASTNAME]\r\n[CUSTOMER_ADDRESS]\r\n[CUSTOMER_ZIP] [CUSTOMER_CITY]\r\n[CUSTOMER_COUNTRY][[SHIPPING_ADDRESS]\r\n\r\n\r\nLieferadresse:\r\n[SHIPPING_COMPANY]\r\n[SHIPPING_FIRSTNAME] [SHIPPING_LASTNAME]\r\n[SHIPPING_ADDRESS]\r\n[SHIPPING_ZIP] [SHIPPING_CITY]\r\n[SHIPPING_COUNTRY][SHIPPING_ADDRESS]]\r\n\r\nIhr Link zum Online Store: [SHOP_HOMEPAGE][[CUSTOMER_LOGIN]\r\n\r\nIhre Zugangsdaten zum Shop:\r\nBenutzername: [CUSTOMER_USERNAME]\r\nPasswort: [CUSTOMER_PASSWORD][CUSTOMER_LOGIN]]\r\n\r\nWir freuen uns auf Ihren nächsten Besuch im [SHOP_COMPANY] Online Store und wünschen Ihnen noch einen schönen Tag.\r\n\r\nP.S. Diese Auftragsbestätigung wurde gesendet an: [CUSTOMER_EMAIL]\r\n\r\nMit freundlichen Grüssen\r\nIhr [SHOP_COMPANY] Online Shop Team\r\n\r\n[SHOP_HOMEPAGE]\r\n'),\n (3, 1, 'shop', 'core_mail_template_message_html', '[CUSTOMER_SALUTATION],<br />\r\n<br />\r\nHerzlichen Dank für Ihre Bestellung im [SHOP_COMPANY] Online Shop.<br />\r\n<br />\r\nIhre Auftrags-Nr. lautet: [ORDER_ID]<br />\r\nIhre Kunden-Nr. lautet: [CUSTOMER_ID]<br />\r\nBestellungszeit: [ORDER_DATE] [ORDER_TIME]<br />\r\n<br />\r\n<br />\r\n<table cellspacing=\"1\" cellpadding=\"1\" style=\"border: 0;\">\r\n <tbody>\r\n <tr>\r\n <td colspan=\"6\">Bestellinformationen</td>\r\n </tr>\r\n <tr>\r\n <td><div style=\"text-align: right;\">ID</div></td>\r\n <td><div style=\"text-align: right;\">Artikel Nr.</div></td>\r\n <td><div style=\"text-align: right;\">Menge</div></td>\r\n <td>Beschreibung</td>\r\n <td><div style=\"text-align: right;\">Stückpreis</div></td>\r\n <td><div style=\"text-align: right;\">Total</div></td>\r\n </tr><!--[[ORDER_ITEM]-->\r\n <tr>\r\n <td><div style=\"text-align: right;\">[PRODUCT_ID]</div></td>\r\n <td><div style=\"text-align: right;\">[PRODUCT_CODE]</div></td>\r\n <td><div style=\"text-align: right;\">[PRODUCT_QUANTITY]</div></td>\r\n <td>[PRODUCT_TITLE]<!--[[PRODUCT_OPTIONS]--><br />\r\n [PRODUCT_OPTIONS]<!--[PRODUCT_OPTIONS]]--></td>\r\n <td><div style=\"text-align: right;\">[PRODUCT_ITEM_PRICE] [CURRENCY]</div></td>\r\n <td><div style=\"text-align: right;\">[PRODUCT_TOTAL_PRICE] [CURRENCY]</div></td>\r\n </tr><!--[[USER_DATA]-->\r\n <tr>\r\n <td colspan=\"3\"> </td>\r\n <td>Benutzername: [USER_NAME]<br />Passwort: [USER_PASS]</td>\r\n <td colspan=\"2\"> </td>\r\n </tr><!--[USER_DATA]]--><!--[[COUPON_DATA]-->\r\n <tr>\r\n <td colspan=\"3\"> </td>\r\n <td>Gutschein Code: [COUPON_CODE]</td>\r\n <td colspan=\"2\"> </td>\r\n </tr><!--[COUPON_DATA]]--><!--[ORDER_ITEM]]-->\r\n <tr style=\"border-top: 4px none;\">\r\n <td colspan=\"2\">Zwischensumme</td>\r\n <td><div style=\"text-align: right;\">[ORDER_ITEM_COUNT]</div></td>\r\n <td colspan=\"2\">Artikel</td>\r\n <td><div style=\"text-align: right;\">[ORDER_ITEM_SUM] [CURRENCY]</div></td>\r\n </tr><!--[[DISCOUNT_COUPON]-->\r\n <tr style=\"border-top: 4px none;\">\r\n <td colspan=\"3\">Gutscheincode</td>\r\n <td colspan=\"2\">[DISCOUNT_COUPON_CODE]</td>\r\n <td><div style=\"text-align: right;\">[DISCOUNT_COUPON_AMOUNT] [CURRENCY]</div></td>\r\n </tr><!--[DISCOUNT_COUPON]]-->\r\n <tr style=\"border-top: 2px none;\">\r\n <td colspan=\"3\">Versandart</td>\r\n <td colspan=\"2\">[SHIPMENT_NAME]</td>\r\n <td><div style=\"text-align: right;\">[SHIPMENT_PRICE] [CURRENCY]</div></td>\r\n </tr>\r\n <tr style=\"border-top: 2px none;\">\r\n <td colspan=\"3\">Bezahlung</td>\r\n <td colspan=\"2\">[PAYMENT_NAME]</td>\r\n <td><div style=\"text-align: right;\">[PAYMENT_PRICE] [CURRENCY]</div></td>\r\n </tr>\r\n <tr style=\"border-top: 2px none;\">\r\n <td colspan=\"5\">[TAX_TEXT]</td>\r\n <td><div style=\"text-align: right;\">[TAX_PRICE] [CURRENCY]</div></td>\r\n </tr>\r\n <tr style=\"border-top: 4px none;\">\r\n <td colspan=\"5\">Gesamtsumme</td>\r\n <td><div style=\"text-align: right;\">[ORDER_SUM] [CURRENCY]</div></td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n<br />\r\n<br />\r\nIhre Kundenadresse:<br />\r\n[CUSTOMER_COMPANY]<br />\r\n[CUSTOMER_FIRSTNAME] [CUSTOMER_LASTNAME]<br />\r\n[CUSTOMER_ADDRESS]<br />\r\n[CUSTOMER_ZIP] [CUSTOMER_CITY]<br />\r\n[CUSTOMER_COUNTRY]<br /><!--[[SHIPPING_ADDRESS]-->\r\n<br />\r\n<br />\r\nLieferadresse:<br />\r\n[SHIPPING_COMPANY]<br />\r\n[SHIPPING_FIRSTNAME] [SHIPPING_LASTNAME]<br />\r\n[SHIPPING_ADDRESS]<br />\r\n[SHIPPING_ZIP] [SHIPPING_CITY]<br />\r\n[SHIPPING_COUNTRY]<br /><!--[SHIPPING_ADDRESS]]-->\r\n<br />\r\n<br />\r\nIhr Link zum Online Store: [SHOP_HOMEPAGE]<br /><!--[[CUSTOMER_LOGIN]-->\r\n<br />\r\nIhre Zugangsdaten zum Shop:<br />\r\nBenutzername: [CUSTOMER_USERNAME]<br />\r\nPasswort: [CUSTOMER_PASSWORD]<br /><!--[CUSTOMER_LOGIN]]-->\r\n<br />\r\nWir freuen uns auf Ihren nächsten Besuch im [SHOP_COMPANY] Online Store und wünschen Ihnen noch einen schönen Tag.<br />\r\n<br />\r\nP.S. Diese Auftragsbestätigung wurde gesendet an: [CUSTOMER_EMAIL]<br />\r\n<br />\r\nMit freundlichen Grüssen<br />\r\nIhr [SHOP_COMPANY] Online Shop Team<br />\r\n<br />\r\n[SHOP_HOMEPAGE]<br />\r\n<br />\r\n'),\n (3, 1, 'shop', 'core_mail_template_name', 'Bestellungsbestätigung'),\n (3, 1, 'shop', 'core_mail_template_reply', '*****@*****.**'),\n (3, 1, 'shop', 'core_mail_template_sender', 'Contrexx Demo'),\n (3, 1, 'shop', 'core_mail_template_subject', 'Bestellungsbestätigung'),\n (3, 1, 'shop', 'core_mail_template_to', '*****@*****.**'),\n (3, 1, 'shop', 'discount_group_customer', 'Goldkunden'),\n (3, 1, 'shop', 'shipper_name', 'Schweizerische Post'),\n (3, 1, 'shop', 'vat_class', 'Deutschland ermässigt'),\n (3, 1, 'shop', 'zone_name', 'Deutschland'),\n (3, 2, 'shop', 'category_name', 'Mitgliedschaft'),\n (4, 1, 'core', 'core_country_name', 'American Samoa'),\n (4, 1, 'shop', 'shipper_name', 'Direct to Me'),\n (4, 1, 'shop', 'vat_class', 'Deutschland stark ermässigt'),\n (4, 2, 'shop', 'currency_name', 'Euro'),\n (5, 1, 'core', 'core_country_name', 'Andorra'),\n (5, 1, 'shop', 'vat_class', 'Deutschland Zwischensatz 1'),\n (5, 2, 'shop', 'currency_name', 'United States Dollars'),\n (6, 1, 'core', 'core_country_name', 'Angola'),\n (1, 1, 'shop', 'currency_name', 'Schweizer Franken'),\n (3, 1, 'shop', 'option_name', 'Headset'),\n (13, 1, 'shop', 'product_name', 'Contrexx® Premium'),\n (3, 1, 'shop', 'manufacturer_name', 'HTC'),\n (3, 1, 'shop', 'manufacturer_uri', 'http://www.htc.com/'),\n (11, 1, 'shop', 'category_name', 'Mitgliedschaft'),\n (6, 1, 'shop', 'vat_class', 'Deutschland Zwischensatz 2'),\n (7, 1, 'core', 'core_country_name', 'Anguilla'),\n (7, 1, 'shop', 'vat_class', 'Österreich Normalsatz'),\n (8, 1, 'core', 'core_country_name', 'Antarctica'),\n (8, 1, 'shop', 'vat_class', 'Österreich ermässigt'),\n (9, 1, 'core', 'core_country_name', 'Antigua and Barbuda'),\n (9, 1, 'shop', 'payment_name', 'Nachnahme'),\n (9, 1, 'shop', 'vat_class', 'Österreich Zwischensatz'),\n (10, 1, 'core', 'core_country_name', 'Argentina'),\n (10, 1, 'shop', 'vat_class', 'Schweiz'),\n (11, 1, 'core', 'core_country_name', 'Armenia'),\n (11, 1, 'shop', 'vat_class', 'Schweiz ermässigt 1'),\n (12, 1, 'core', 'core_country_name', 'Aruba'),\n (12, 1, 'shop', 'payment_name', 'Paypal'),\n (12, 1, 'shop', 'vat_class', 'Schweiz ermässigt 2'),\n (13, 1, 'core', 'core_country_name', 'Australia'),\n (13, 1, 'shop', 'payment_name', 'LSV'),\n (13, 1, 'shop', 'vat_class', 'Great Britain'),\n (14, 1, 'core', 'core_country_name', 'Österreich'),\n (14, 1, 'shop', 'payment_name', 'PostFinance (PostCard, Kreditkarte)'),\n (14, 1, 'shop', 'vat_class', 'Great Britain reduced'),\n (15, 1, 'core', 'core_country_name', 'Azerbaijan'),\n (15, 1, 'shop', 'payment_name', 'Datatrans'),\n (16, 1, 'core', 'core_country_name', 'Bahamas'),\n (17, 1, 'core', 'core_country_name', 'Bahrain'),\n (18, 1, 'core', 'core_country_name', 'Bangladesh'),\n (19, 1, 'core', 'core_country_name', 'Barbados'),\n (20, 1, 'core', 'core_country_name', 'Belarus'),\n (21, 1, 'core', 'core_country_name', 'Belgium'),\n (22, 1, 'core', 'core_country_name', 'Belize'),\n (23, 1, 'core', 'core_country_name', 'Benin'),\n (24, 1, 'core', 'core_country_name', 'Bermuda'),\n (25, 1, 'core', 'core_country_name', 'Bhutan'),\n (26, 1, 'core', 'core_country_name', 'Bolivia'),\n (27, 1, 'core', 'core_country_name', 'Bosnia and Herzegowina'),\n (28, 1, 'core', 'core_country_name', 'Botswana'),\n (29, 1, 'core', 'core_country_name', 'Bouvet Island'),\n (30, 1, 'core', 'core_country_name', 'Brazil'),\n (31, 1, 'core', 'core_country_name', 'British Indian Ocean Territory'),\n (32, 1, 'core', 'core_country_name', 'Brunei Darussalam'),\n (33, 1, 'core', 'core_country_name', 'Bulgaria'),\n (34, 1, 'core', 'core_country_name', 'Burkina Faso'),\n (35, 1, 'core', 'core_country_name', 'Burundi'),\n (36, 1, 'core', 'core_country_name', 'Cambodia'),\n (37, 1, 'core', 'core_country_name', 'Cameroon'),\n (38, 1, 'core', 'core_country_name', 'Canada'),\n (39, 1, 'core', 'core_country_name', 'Cape Verde'),\n (40, 1, 'core', 'core_country_name', 'Cayman Islands'),\n (41, 1, 'core', 'core_country_name', 'Central African Republic'),\n (42, 1, 'core', 'core_country_name', 'Chad'),\n (43, 1, 'core', 'core_country_name', 'Chile'),\n (44, 1, 'core', 'core_country_name', 'China'),\n (45, 1, 'core', 'core_country_name', 'Christmas Island'),\n (46, 1, 'core', 'core_country_name', 'Cocos (Keeling) Islands'),\n (47, 1, 'core', 'core_country_name', 'Colombia'),\n (48, 1, 'core', 'core_country_name', 'Comoros'),\n (49, 1, 'core', 'core_country_name', 'Congo'),\n (50, 1, 'core', 'core_country_name', 'Cook Islands'),\n (51, 1, 'core', 'core_country_name', 'Costa Rica'),\n (52, 1, 'core', 'core_country_name', 'Cote D''Ivoire'),\n (53, 1, 'core', 'core_country_name', 'Croatia'),\n (54, 1, 'core', 'core_country_name', 'Cuba'),\n (55, 1, 'core', 'core_country_name', 'Cyprus'),\n (56, 1, 'core', 'core_country_name', 'Czech Republic'),\n (57, 1, 'core', 'core_country_name', 'Denmark'),\n (58, 1, 'core', 'core_country_name', 'Djibouti'),\n (59, 1, 'core', 'core_country_name', 'Dominica'),\n (60, 1, 'core', 'core_country_name', 'Dominican Republic'),\n (61, 1, 'core', 'core_country_name', 'East Timor'),\n (62, 1, 'core', 'core_country_name', 'Ecuador'),\n (63, 1, 'core', 'core_country_name', 'Egypt'),\n (64, 1, 'core', 'core_country_name', 'El Salvador'),\n (65, 1, 'core', 'core_country_name', 'Equatorial Guinea'),\n (66, 1, 'core', 'core_country_name', 'Eritrea'),\n (67, 1, 'core', 'core_country_name', 'Estonia'),\n (68, 1, 'core', 'core_country_name', 'Ethiopia'),\n (69, 1, 'core', 'core_country_name', 'Falkland Islands (Malvinas)'),\n (70, 1, 'core', 'core_country_name', 'Faroe Islands'),\n (71, 1, 'core', 'core_country_name', 'Fiji'),\n (72, 1, 'core', 'core_country_name', 'Finland'),\n (73, 1, 'core', 'core_country_name', 'France'),\n (74, 1, 'core', 'core_country_name', 'France, Metropolitan'),\n (75, 1, 'core', 'core_country_name', 'French Guiana'),\n (76, 1, 'core', 'core_country_name', 'French Polynesia'),\n (77, 1, 'core', 'core_country_name', 'French Southern Territories'),\n (78, 1, 'core', 'core_country_name', 'Gabon'),\n (79, 1, 'core', 'core_country_name', 'Gambia'),\n (80, 1, 'core', 'core_country_name', 'Georgia'),\n (81, 1, 'core', 'core_country_name', 'Deutschland'),\n (82, 1, 'core', 'core_country_name', 'Ghana'),\n (83, 1, 'core', 'core_country_name', 'Gibraltar'),\n (84, 1, 'core', 'core_country_name', 'Greece'),\n (85, 1, 'core', 'core_country_name', 'Greenland'),\n (86, 1, 'core', 'core_country_name', 'Grenada'),\n (87, 1, 'core', 'core_country_name', 'Guadeloupe'),\n (88, 1, 'core', 'core_country_name', 'Guam'),\n (89, 1, 'core', 'core_country_name', 'Guatemala'),\n (90, 1, 'core', 'core_country_name', 'Guinea'),\n (91, 1, 'core', 'core_country_name', 'Guinea-bissau'),\n (92, 1, 'core', 'core_country_name', 'Guyana'),\n (93, 1, 'core', 'core_country_name', 'Haiti'),\n (94, 1, 'core', 'core_country_name', 'Heard and Mc Donald Islands'),\n (95, 1, 'core', 'core_country_name', 'Honduras'),\n (96, 1, 'core', 'core_country_name', 'Hong Kong'),\n (97, 1, 'core', 'core_country_name', 'Hungary'),\n (98, 1, 'core', 'core_country_name', 'Iceland'),\n (99, 1, 'core', 'core_country_name', 'India'),\n (100, 1, 'core', 'core_country_name', 'Indonesia'),\n (101, 1, 'core', 'core_country_name', 'Iran (Islamic Republic of)'),\n (102, 1, 'core', 'core_country_name', 'Iraq'),\n (103, 1, 'core', 'core_country_name', 'Ireland'),\n (104, 1, 'core', 'core_country_name', 'Israel'),\n (105, 1, 'core', 'core_country_name', 'Italy'),\n (106, 1, 'core', 'core_country_name', 'Jamaica'),\n (107, 1, 'core', 'core_country_name', 'Japan'),\n (108, 1, 'core', 'core_country_name', 'Jordan'),\n (109, 1, 'core', 'core_country_name', 'Kazakhstan'),\n (110, 1, 'core', 'core_country_name', 'Kenya'),\n (111, 1, 'core', 'core_country_name', 'Kiribati'),\n (112, 1, 'core', 'core_country_name', 'Korea, Democratic People''s Republic of'),\n (113, 1, 'core', 'core_country_name', 'Korea, Republic of'),\n (114, 1, 'core', 'core_country_name', 'Kuwait'),\n (115, 1, 'core', 'core_country_name', 'Kyrgyzstan'),\n (116, 1, 'core', 'core_country_name', 'Lao People''s Democratic Republic'),\n (117, 1, 'core', 'core_country_name', 'Latvia'),\n (118, 1, 'core', 'core_country_name', 'Lebanon'),\n (119, 1, 'core', 'core_country_name', 'Lesotho'),\n (120, 1, 'core', 'core_country_name', 'Liberia'),\n (121, 1, 'core', 'core_country_name', 'Libyan Arab Jamahiriya'),\n (122, 1, 'core', 'core_country_name', 'Liechtenstein'),\n (123, 1, 'core', 'core_country_name', 'Lithuania'),\n (124, 1, 'core', 'core_country_name', 'Luxembourg'),\n (125, 1, 'core', 'core_country_name', 'Macau'),\n (126, 1, 'core', 'core_country_name', 'Macedonia, The Former Yugoslav Republic of'),\n (127, 1, 'core', 'core_country_name', 'Madagascar'),\n (128, 1, 'core', 'core_country_name', 'Malawi'),\n (129, 1, 'core', 'core_country_name', 'Malaysia'),\n (130, 1, 'core', 'core_country_name', 'Maldives'),\n (131, 1, 'core', 'core_country_name', 'Mali'),\n (132, 1, 'core', 'core_country_name', 'Malta'),\n (133, 1, 'core', 'core_country_name', 'Marshall Islands'),\n (134, 1, 'core', 'core_country_name', 'Martinique'),\n (135, 1, 'core', 'core_country_name', 'Mauritania'),\n (136, 1, 'core', 'core_country_name', 'Mauritius'),\n (137, 1, 'core', 'core_country_name', 'Mayotte'),\n (138, 1, 'core', 'core_country_name', 'Mexico'),\n (139, 1, 'core', 'core_country_name', 'Micronesia, Federated States of'),\n (140, 1, 'core', 'core_country_name', 'Moldova, Republic of'),\n (141, 1, 'core', 'core_country_name', 'Monaco'),\n (142, 1, 'core', 'core_country_name', 'Mongolia'),\n (143, 1, 'core', 'core_country_name', 'Montserrat'),\n (144, 1, 'core', 'core_country_name', 'Morocco'),\n (145, 1, 'core', 'core_country_name', 'Mozambique'),\n (146, 1, 'core', 'core_country_name', 'Myanmar'),\n (147, 1, 'core', 'core_country_name', 'Namibia'),\n (148, 1, 'core', 'core_country_name', 'Nauru'),\n (149, 1, 'core', 'core_country_name', 'Nepal'),\n (150, 1, 'core', 'core_country_name', 'Netherlands'),\n (151, 1, 'core', 'core_country_name', 'Netherlands Antilles'),\n (152, 1, 'core', 'core_country_name', 'New Caledonia'),\n (153, 1, 'core', 'core_country_name', 'New Zealand'),\n (154, 1, 'core', 'core_country_name', 'Nicaragua'),\n (155, 1, 'core', 'core_country_name', 'Niger'),\n (156, 1, 'core', 'core_country_name', 'Nigeria'),\n (157, 1, 'core', 'core_country_name', 'Niue'),\n (158, 1, 'core', 'core_country_name', 'Norfolk Island'),\n (159, 1, 'core', 'core_country_name', 'Northern Mariana Islands'),\n (160, 1, 'core', 'core_country_name', 'Norway'),\n (161, 1, 'core', 'core_country_name', 'Oman'),\n (162, 1, 'core', 'core_country_name', 'Pakistan'),\n (163, 1, 'core', 'core_country_name', 'Palau'),\n (164, 1, 'core', 'core_country_name', 'Panama'),\n (165, 1, 'core', 'core_country_name', 'Papua New Guinea'),\n (166, 1, 'core', 'core_country_name', 'Paraguay'),\n (167, 1, 'core', 'core_country_name', 'Peru'),\n (168, 1, 'core', 'core_country_name', 'Philippines'),\n (169, 1, 'core', 'core_country_name', 'Pitcairn'),\n (170, 1, 'core', 'core_country_name', 'Poland'),\n (171, 1, 'core', 'core_country_name', 'Portugal'),\n (172, 1, 'core', 'core_country_name', 'Puerto Rico'),\n (173, 1, 'core', 'core_country_name', 'Qatar'),\n (174, 1, 'core', 'core_country_name', 'Reunion'),\n (175, 1, 'core', 'core_country_name', 'Romania'),\n (176, 1, 'core', 'core_country_name', 'Russian Federation'),\n (177, 1, 'core', 'core_country_name', 'Rwanda'),\n (178, 1, 'core', 'core_country_name', 'Saint Kitts and Nevis'),\n (179, 1, 'core', 'core_country_name', 'Saint Lucia'),\n (180, 1, 'core', 'core_country_name', 'Saint Vincent and the Grenadines'),\n (181, 1, 'core', 'core_country_name', 'Samoa'),\n (182, 1, 'core', 'core_country_name', 'San Marino'),\n (183, 1, 'core', 'core_country_name', 'Sao Tome and Principe'),\n (184, 1, 'core', 'core_country_name', 'Saudi Arabia'),\n (185, 1, 'core', 'core_country_name', 'Senegal'),\n (186, 1, 'core', 'core_country_name', 'Seychelles'),\n (187, 1, 'core', 'core_country_name', 'Sierra Leone'),\n (188, 1, 'core', 'core_country_name', 'Singapore'),\n (189, 1, 'core', 'core_country_name', 'Slovakia (Slovak Republic)'),\n (190, 1, 'core', 'core_country_name', 'Slovenia'),\n (191, 1, 'core', 'core_country_name', 'Solomon Islands'),\n (192, 1, 'core', 'core_country_name', 'Somalia'),\n (193, 1, 'core', 'core_country_name', 'South Africa'),\n (194, 1, 'core', 'core_country_name', 'South Georgia and the South Sandwich Islands'),\n (195, 1, 'core', 'core_country_name', 'Spain'),\n (196, 1, 'core', 'core_country_name', 'Sri Lanka'),\n (197, 1, 'core', 'core_country_name', 'St. Helena'),\n (198, 1, 'core', 'core_country_name', 'St. Pierre and Miquelon'),\n (199, 1, 'core', 'core_country_name', 'Sudan'),\n (200, 1, 'core', 'core_country_name', 'Suriname'),\n (201, 1, 'core', 'core_country_name', 'Svalbard and Jan Mayen Islands'),\n (202, 1, 'core', 'core_country_name', 'Swaziland'),\n (203, 1, 'core', 'core_country_name', 'Sweden'),\n (204, 1, 'core', 'core_country_name', 'Schweiz'),\n (205, 1, 'core', 'core_country_name', 'Syrian Arab Republic'),\n (206, 1, 'core', 'core_country_name', 'Taiwan'),\n (207, 1, 'core', 'core_country_name', 'Tajikistan'),\n (208, 1, 'core', 'core_country_name', 'Tanzania, United Republic of'),\n (209, 1, 'core', 'core_country_name', 'Thailand'),\n (210, 1, 'core', 'core_country_name', 'Togo'),\n (211, 1, 'core', 'core_country_name', 'Tokelau'),\n (212, 1, 'core', 'core_country_name', 'Tonga'),\n (213, 1, 'core', 'core_country_name', 'Trinidad and Tobago'),\n (214, 1, 'core', 'core_country_name', 'Tunisia'),\n (215, 1, 'core', 'core_country_name', 'Turkey'),\n (216, 1, 'core', 'core_country_name', 'Turkmenistan'),\n (217, 1, 'core', 'core_country_name', 'Turks and Caicos Islands'),\n (218, 1, 'core', 'core_country_name', 'Tuvalu'),\n (219, 1, 'core', 'core_country_name', 'Uganda'),\n (220, 1, 'core', 'core_country_name', 'Ukraine'),\n (221, 1, 'core', 'core_country_name', 'United Arab Emirates'),\n (222, 1, 'core', 'core_country_name', 'United Kingdom'),\n (223, 1, 'core', 'core_country_name', 'United States'),\n (224, 1, 'core', 'core_country_name', 'United States Minor Outlying Islands'),\n (225, 1, 'core', 'core_country_name', 'Uruguay'),\n (226, 1, 'core', 'core_country_name', 'Uzbekistan'),\n (227, 1, 'core', 'core_country_name', 'Vanuatu'),\n (228, 1, 'core', 'core_country_name', 'Vatican City State (Holy See)'),\n (229, 1, 'core', 'core_country_name', 'Venezuela'),\n (230, 1, 'core', 'core_country_name', 'Viet Nam'),\n (231, 1, 'core', 'core_country_name', 'Virgin Islands (British)'),\n (232, 1, 'core', 'core_country_name', 'Virgin Islands (U.S.)'),\n (233, 1, 'core', 'core_country_name', 'Wallis and Futuna Islands'),\n (234, 1, 'core', 'core_country_name', 'Western Sahara'),\n (235, 1, 'core', 'core_country_name', 'Yemen'),\n (236, 1, 'core', 'core_country_name', 'Yugoslavia'),\n (237, 1, 'core', 'core_country_name', 'Zaire'),\n (238, 1, 'core', 'core_country_name', 'Zambia'),\n (239, 1, 'core', 'core_country_name', 'Zimbabwe'),\n (4, 2, 'shop', 'category_name', 'Lorem ipsum1'),\n (4, 2, 'shop', 'category_description', 'lorem ipsum lorem ipsum lorem ipsum lorem ipsum'),\n (5, 2, 'shop', 'category_name', 'Lorem ipsum2'),\n (5, 2, 'shop', 'category_description', 'lorem ipsum lorem ipsum lorem ipsum lorem ipsum'),\n (6, 2, 'shop', 'category_name', 'Lorem ipsum3'),\n (6, 2, 'shop', 'category_description', 'lorem ipsum lorem ipsum lorem ipsum lorem ipsum'),\n (12, 1, 'shop', 'product_short', 'Als eines der ersten Smartphones besitzt das HTC One X einen Quad-Core-Prozessor – d.h. die Leistung verteilt sich auf 4 Rechenkerne. Dies macht das HTC One X extrem schnell und leistungsfähig.'),\n (12, 1, 'shop', 'product_long', '<table border=\"0\">\r\n <tbody>\r\n <tr>\r\n <td style=\"width: 120px;\">\r\n <strong>Größe:</strong></td>\r\n <td>\r\n 134,36 x 69,9 x 8,9 mm</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <strong>Gewicht:</strong></td>\r\n <td>\r\n 130 g mit Akku</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <strong>Display:</strong></td>\r\n <td>\r\n HD 720P Touchscreen</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <strong>Bildschirm:</strong></td>\r\n <td>\r\n 4,7“ (1280 x 720 Auflösung)</td>\r\n </tr>\r\n </tbody>\r\n</table>'),\n (12, 1, 'shop', 'product_keys', 'HTC, HTC One X'),\n (12, 1, 'shop', 'product_code', ''),\n (10, 1, 'shop', 'category_description', 'Alle Versionen des Contrexx Content Management Systems zur Verwaltung Ihrer Website.'),\n (12, 1, 'shop', 'product_name', 'HTC One X'),\n (10, 1, 'shop', 'category_name', 'Contrexx CMS Software'),\n (9, 1, 'shop', 'category_name', 'Mobile Phones'),\n (9, 1, 'shop', 'category_description', 'Mobile Phones von über 10 Marken wie Apple, HTC & Samsung.'),\n (8, 2, 'shop', 'category_name', 'Iphone'),\n (8, 2, 'shop', 'category_description', 'lorem ipsum lorem ipsum lorem ipsum lorem ipsum'),\n (13, 1, 'shop', 'product_code', ''),\n (13, 1, 'shop', 'product_uri', 'http://www.contrexx.com'),\n (13, 1, 'shop', 'product_keys', 'Contrexx CMS'),\n (13, 1, 'shop', 'product_long', 'Mit dem Contrexx CMS stehen Ihnen über 20 Anwendungen zur Verfügung, beispielsweise ein kompletter Online Shop, ein umfangreiches Newsletter-Modul und eine mehrsprachige Website.'),\n (13, 1, 'shop', 'product_short', 'Contrexx® CMS für die schnelle Verwaltung Ihrer Website.'),\n (7, 2, 'shop', 'category_name', 'Samsung'),\n (7, 2, 'shop', 'category_description', 'lorem ipsum lorem ipsum lorem ipsum lorem ipsum'),\n (1, 2, 'shop', 'manufacturer_name', 'Samsung'),\n (1, 2, 'shop', 'manufacturer_uri', 'http://www.samsung.com'),\n (2, 2, 'shop', 'manufacturer_name', 'Apple, Inc.'),\n (2, 2, 'shop', 'manufacturer_uri', 'http://www.apple.com/'),\n (4, 1, 'shop', 'manufacturer_name', 'Contrexx'),\n (4, 1, 'shop', 'manufacturer_uri', 'http://www.contrexx.com'),\n (11, 1, 'shop', 'category_description', 'Zum Erwerben von Mitgliedschaften bei verschiedenen Vereienen und Organisationen.'),\n (14, 1, 'shop', 'product_name', 'Mitglied von der MaxMuster-Foundation'),\n (14, 1, 'shop', 'product_short', 'Unterstützen Sie die MaxMuster-Foundation und werden Sie noch heute Mitglied! Sie profitieren von MItgliederrabatten an verschiedenen Anlässen.'),\n (14, 1, 'shop', 'product_long', 'Die Foundation hilft Schulen und Ausbildungsinstitutionen seit 10 Jahren sich technisch weiterzuentwickeln und den Lernenden so verbesserte Ausbildungsmöglichkeiten zu bieten. Durch eine Mitgliedschaft erhalten Sie Rabatte an verschiedenen Firmenanlässen der MaxMuster AG.'),\n (14, 1, 'shop', 'product_keys', ''),\n (14, 1, 'shop', 'product_code', ''),\n (14, 1, 'shop', 'product_uri', ''),\n (5, 1, 'shop', 'manufacturer_name', 'MaxMuster AG'),\n (5, 1, 'shop', 'manufacturer_uri', ''),\n (2, 1, 'shop', 'core_mail_template_message_html', '[CUSTOMER_SALUTATION]<br />\r\n<br />\r\nIhre Bestellung wurde ausgeführt. Sie werden in den nächsten Tagen ihre Lieferung erhalten.<br />\r\n<br />\r\nHerzlichen Dank für das Vertrauen.<br />\r\nWir würden uns freuen, wenn Sie uns weiterempfehlen und wünschen Ihnen noch einen schönen Tag.<br />\r\n<br />\r\nMit freundlichen Grüssen<br />\r\nIhr [SHOP_COMPANY] Online Shop Team<br />\r\n<br />\r\n[SHOP_HOMEPAGE]'),\n (4, 1, 'shop', 'currency_name', 'Euro'),\n (5, 1, 'shop', 'currency_name', 'United States Dollars'),\n (16,1,'shop','payment_name','Kreditkarte (Paymill)'),\n (16,2,'shop','payment_name','paymill'),\n (17,1,'shop','payment_name','ELV (Paymill)'),\n (18,1,'shop','payment_name','IBAN/BIC (Paymill)')\n ON DUPLICATE KEY UPDATE `id` = `id`\n ");
try {
$queries = array('INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","payment_lsv_active","config","text","1","",18)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_active","config","text","1","",3)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_live_private_key","config","text","","",0)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_live_public_key","config","text","","",0)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_live_public_key","config","text","","",0)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_test_private_key","config","text","","",2)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_test_public_key","config","text","","",16)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_use_test_account","config","text","0","",15)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES (\'shop\',\'orderitems_amount_min\',\'config\',\'text\',\'0\',\'\',0);');
foreach ($queries as $query) {
\Cx\Lib\UpdateUtil::sql($query);
}
} catch (\Cx\Lib\UpdateException $e) {
return \Cx\Lib\UpdateUtil::DefaultActionHandler($e);
}
} catch (\Cx\Lib\UpdateException $e) {
return \Cx\Lib\UpdateUtil::DefaultActionHandler($e);
}
}
}
}
$_SESSION['contrexx_update']['newsletter_links_decoded'] = true;
} catch (\Cx\Lib\UpdateException $e) {
return \Cx\Lib\UpdateUtil::DefaultActionHandler($e);
}
// shop
$table_name = DBPREFIX . 'module_shop_currencies';
if (\Cx\Lib\UpdateUtil::table_exist($table_name) && \Cx\Lib\UpdateUtil::column_exist($table_name, 'name')) {
$query = "\n UPDATE `{$table_name}`\n SET sort_order = 0 WHERE sort_order IS NULL";
\Cx\Lib\UpdateUtil::sql($query);
// Currencies table fields
\Cx\Lib\UpdateUtil::table($table_name, array('id' => array('type' => 'INT(10)', 'unsigned' => true, 'notnull' => true, 'auto_increment' => true, 'primary' => true), 'code' => array('type' => 'CHAR(3)', 'notnull' => true, 'default' => ''), 'symbol' => array('type' => 'VARCHAR(20)', 'notnull' => true, 'default' => ''), 'name' => array('type' => 'VARCHAR(50)', 'notnull' => true, 'default' => ''), 'rate' => array('type' => 'DECIMAL(10,4)', 'unsigned' => true, 'notnull' => true, 'default' => '1.0000'), 'sort_order' => array('type' => 'INT(5)', 'unsigned' => true, 'notnull' => true, 'default' => '0'), 'status' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '1'), 'is_default' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '0')));
}
$table_name = DBPREFIX . 'module_shop_payment_processors';
if (Cx\Lib\UpdateUtil::table_exist($table_name)) {
\Cx\Lib\UpdateUtil::table($table_name, array('id' => array('type' => 'INT(10)', 'unsigned' => true, 'notnull' => true, 'auto_increment' => true, 'primary' => true), 'type' => array('type' => 'ENUM(\'internal\',\'external\')', 'notnull' => true, 'default' => 'internal'), 'name' => array('type' => 'VARCHAR(255)', 'notnull' => true, 'default' => ''), 'description' => array('type' => 'TEXT'), 'company_url' => array('type' => 'VARCHAR(255)', 'notnull' => true, 'default' => ''), 'status' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '1'), 'picture' => array('type' => 'VARCHAR(255)', 'notnull' => true, 'default' => '')));
}
}
if ($objUpdate->_isNewerVersion($_CONFIG['coreCmsVersion'], '3.1.0')) {
// contact core_module
// update the content pages
$em = \Env::get('em');
$cl = \Env::get('ClassLoader');
$cl->loadFile(ASCMS_CORE_MODULE_PATH . '/contact/admin.class.php');
$pageRepo = $em->getRepository('Cx\\Core\\ContentManager\\Model\\Entity\\Page');
$Contact = new \ContactManager();
$Contact->initContactForms();
foreach ($Contact->arrForms as $id => $form) {
foreach ($form['lang'] as $langId => $lang) {
if ($lang['is_active'] == true) {
