IP : 3.15.138.82Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
./
softaculous/
s9y/
../
flarum/
../
joomla16/
../
grav/
../
abante/
abante.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `[[dbprefix]]collection_descriptions` --
CREATE TABLE `[[dbprefix]]collection_descriptions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `collection_id` int(11) NOT NULL, `language_id` int(11) NOT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `meta_keywords` text CHARACTER SET utf8 COLLATE utf8_bin, `meta_description` text CHARACTER SET utf8 COLLATE utf8_bin, PRIMARY KEY (`id`), UNIQUE KEY `collection_language_idx` (`collection_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `[[dbprefix]]email_templates` --
CREATE TABLE `[[dbprefix]]email_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `status` tinyint(1) NOT NULL, `text_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `language_id` int(11) NOT NULL, `headers` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `html_body` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `text_body` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `allowed_placeholders` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `date_deleted` timestamp NULL DEFAULT NULL, `store_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `email_templates_text_id_idx` (`text_id`,`language_id`,`store_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;
-- -- Dumping data for table `[[dbprefix]]email_templates` --
INSERT INTO `[[dbprefix]]email_templates` VALUES (1, 1, 'storefront_reset_password_link', 1, '', '{{store_name}} - Password reset', 'A password reset was requested from {{store_name}}<br />\r\nTo reset your password click link below:<br />\r\n<a href="{{ reset_link }}">{{ reset_link }}</a >\r\n<br /><br />\r\n{{{ text_project_label }}}', 'A password reset was requested from {{store_name}} \r\nTo reset your password click link below:\r\n{{ reset_link }}\r\n\r\n\r\n{{{ text_project_label }}}', 'store_name, reset_link, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0), (2, 1, 'storefront_welcome_email_activated', 1, '', 'Welcome, {{store_name}}', '<html>\r\n <head>\r\n <meta http-equiv="Content-Type" content="text/html; charset=utf-8">\r\n </head>\r\n <body>\r\n <table style="font-family: Verdana,sans-serif; font-size: 11px; color: #374953; width: 600px;">\r\n <tr>\r\n <td class="align_left">\r\n <a href="{{ store_url }}" title="{{ store_name }}">\r\n {{# logo_uri}}\r\n <img src="{{ logo_uri }}" alt="{{store_name}}" style="border: none;">\r\n {{/ logo_uri}}\r\n {{^ logo_uri}}\r\n {{# logo_html}}\r\n {{logo_html}}\r\n {{/ logo_html}}\r\n {{/ logo_uri}}\r\n </a>\r\n </td>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>Welcome and thank you for registering at {{ store_name }}</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n Your account has now been created and you can log in by using your email address and password by visiting our website or at the following URL:<br/>\r\n<a href="{{ login_url }}">{{ login_url }}</a><br/>\r\nOnce you logging in, you will be able to access, your wishlist, order history, printing invoices and editing your account information.\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n Thank you.<br/>\r\n {{ store_name }}\r\n<br/><br/>\r\n{{{ text_project_label }}}\r\n </td>\r\n </tr>\r\n </table>\r\n </body>\r\n</html>', 'Welcome and thank you for registering at {{ store_name }}\r\n\r\nYour account has now been created and you can log in by using your email address and password by visiting our website or at the following URL:\r\n{{ login_url }}\r\n\r\nOnce you logging in, you will be able to access, your wishlist, order history, printing invoices and editing your account information.\r\n\r\nThank you.\r\n{{ store_name }}\r\n{{{ text_project_label }}}', 'store_name, login_url, store_url, logo_html, logo_uri, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0), (3, 1, 'storefront_welcome_email_approval', 1, '', 'Welcome, {{store_name}}', '<html>\r\n <head>\r\n <meta http-equiv="Content-Type" content="text/html; charset=utf-8">\r\n </head>\r\n <body>\r\n <table style="font-family: Verdana,sans-serif; font-size: 11px; color: #374953; width: 600px;">\r\n <tr>\r\n <td class="align_left">\r\n <a href="{{ store_url }}" title="{{ store_name }}">\r\n {{#logo_uri}}\r\n <img src="{{ logo_uri }}" alt="{{store_name}}" style="border: none;">\r\n {{/logo_uri}}\r\n {{^logo_uri}}\r\n {{#logo_html}}\r\n {{logo_html}}\r\n {{/logo_html}}\r\n {{/logo_uri}}\r\n </a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>Welcome and thank you for registering at {{ store_name }}</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n Your account must be approved before you can login. Once approved you can log in by using your email address and password by visiting our website or at the following URL:<br/>\r\n<a href="{{ login_url }}">{{ login_url }}</a><br/>\r\nOnce you logging in, you will be able to access, your wishlist, order history, printing invoices and editing your account information.\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n Thank you.<br/>\r\n {{ store_name }}\r\n<br/><br/>\r\n{{{ text_project_label }}}\r\n </td>\r\n </tr>\r\n </table>\r\n </body>\r\n</html>', 'Welcome and thank you for registering at {{ store_name }}\r\n\r\nYour account must be approved before you can login. Once approved you can log in by using your email address and password by visiting our website or at the following URL:\r\n{{ login_url }}\r\n\r\nOnce you logging in, you will be able to access, your wishlist, order history, printing invoices and editing your account information.\r\n\r\nThank you.\r\n{{ store_name }}\r\n{{{ text_project_label }}}', 'store_name, login_url, store_url, logo_html, logo_uri, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0), (4, 1, 'storefront_send_activate_link', 1, '', '{{store_name}} - Thank you for registering', '<html>\r\n <head>\r\n <meta http-equiv="Content-Type" content="text/html; charset=utf-8">\r\n </head>\r\n <body>\r\n <table style="font-family: Verdana,sans-serif; font-size: 11px; color: #374953; width: 600px;">\r\n <tr>\r\n <td class="align_left">\r\n <a href="{{ store_url }}" title="{{ store_name }}">\r\n {{#logo_uri}}\r\n <img src="{{ logo_uri }}" alt="{{store_name}}" style="border: none;">\r\n {{/logo_uri}}\r\n {{^logo_uri}}\r\n {{#logo_html}}\r\n {{logo_html}}\r\n {{/logo_html}}\r\n {{/logo_uri}}\r\n </a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>Welcome and thank you for registering at {{ store_name }}</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n Before we can activate your account one last step must be taken to complete your registration.<br/>\r\nYou must complete this last step to become a registered member. Please click the following link to activate your account:<br/>\r\n{{{ activate_url }}}<br/>\r\n\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n Thank you.<br/>\r\n {{ store_name }}\r\n<br/>\r\n<br/>\r\n{{{ text_project_label }}}\r\n </td>\r\n </tr>\r\n </table>\r\n </body>\r\n</html>', 'Welcome and thank you for registering at {{ store_name }}!\r\n\r\nBefore we can activate your account one last step must be taken to complete your registration.\r\nYou must complete this last step to become a registered member. Please click the following link to activate your account\r\n{{ activate_url }}\r\n\r\nThank you,\r\n{{ store_name }}\r\n\r\n{{{ text_project_label }}}', 'store_name, activate_url, logo_uri, logo_html, store_url, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0), (5, 1, 'storefront_reset_password_notify', 1, '', '{{store_name}} - Password reset', 'Your password was successfully reset on {{store_name}}\r\n<br/>\r\n{{{ text_project_label }}}', 'Your password was successfully reset on {{store_name}}\r\n\r\n{{{ text_project_label }}}', 'store_name, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0), (6, 1, 'storefront_send_login_name', 1, '', '{{store_name}} - Login name reminder', 'Login name reminder was requested from {{store_name}} <br/>\r\n<br/>\r\nYour login name is: {{ login_name }}\r\n\r\n<br/>\r\n{{store_name}} \r\n<br/>\r\n<br/>\r\n{{{ text_project_label }}}', 'Login name reminder was requested from {{store_name}} \r\n\r\nYour login name is: {{ login_name }}\r\n\r\n{{store_name}} \r\n\r\n{{{ text_project_label }}}', 'store_name, login_name, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0), (7, 1, 'storefront_order_confirm', 1, '', '{{store_name}} - Order {{ order_id }}', '<html>\r\n<head>\r\n <meta http-equiv="Content-Type" content="text/html; charset=utf-8">\r\n <title> {{store_name}} - Order {{ order_id }} </title>\r\n</head>\r\n<body>\r\n<table style="font-family: Verdana,sans-serif; font-size: 11px; color: #374953; width: 600px;">\r\n <tr>\r\n <td class="align_left">\r\n <a href="{{ store_url }}" title="{{ store_name }}">\r\n {{# logo_uri}}\r\n <img src="{{ logo_uri }}" alt="{{store_name}}" style="border: none;">\r\n {{/ logo_uri}}\r\n {{^ logo_uri}}\r\n {{# logo_html}}\r\n {{logo_html}}\r\n {{/ logo_html}}\r\n {{/ logo_uri}}\r\n </a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left">Thank you for your interest in {{store_name}} products. Your order has been received and will be processed after payment is confirmed.</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left"\r\n style="background-color: #069; color:#FFF; font-size: 12px; font-weight: bold; padding: 0.5em 1em;">Order Details</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left">Order ID: <span\r\n style="color: #069; font-weight: bold;">{{ order_id }}</span><br/>\r\n Date Ordered: {{ date_added }}<br>\r\n Payment Method: <strong>{{ payment_method }}</strong><br/>\r\n Shipping Method: <strong>{{ shipping_method }}</strong><br/>\r\n <br/>\r\n Email: <strong>{{ customer_email }}</strong><br/>\r\n Telephone: <strong>{{ customer_telephone }}</strong><br/>\r\n {{# customer_mobile_phone }}\r\n Telephone: <strong>{{ customer_mobile_phone }}</strong><br/>\r\n {{/ customer_mobile_phone }}\r\n {{# customer_fax }}\r\n Fax: <strong>{{ customer_fax }}</strong><br/>\r\n {{/ customer_fax }}\r\n IP Address:<strong>{{ customer_ip }}</strong>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <table style="width: 100%; font-family: Verdana,sans-serif; font-size: 11px; color: #FFFFFF;">\r\n <tr style="background-color: #CCCCCC; text-transform: uppercase;">\r\n <th style="text-align: left; padding: 0.3em;">Shipping Address</th>\r\n <th style="text-align: left; padding: 0.3em;">Payment Address</th>\r\n </tr>\r\n <tr>\r\n <td style="padding: 0.3em; background-color: #EEEEEE; color: #000;">\r\n{{# shipping_data }}\r\n{{ firstname }} {{lastname}} <br/>\r\n{{# company }}\r\n{{{ company }}} <br/> \r\n{{/ company }}\r\n{{# address_1 }}\r\n{{{ address_1 }}} <br/> \r\n{{/ address_1 }}\r\n{{# address_2 }}\r\n{{{ address_2 }}} <br/> \r\n{{/ address_2 }}\r\n{{{ city }}} {{{ postcode }}} <br/> \r\n{{# zone }}\r\n{{{ zone }}} <br/> \r\n{{/ zone }}\r\n{{{ country }}}\r\n{{/ shipping_data }}\r\n</td>\r\n<td style="padding: 0.3em; background-color: #EEEEEE; color: #000;">\r\n{{# payment_data }}\r\n{{ firstname }} {{lastname}} <br/>\r\n{{# company }}\r\n{{{ company }}} <br/> \r\n{{/ company }}\r\n{{# address_1 }}\r\n{{{ address_1 }}} <br/> \r\n{{/ address_1 }}\r\n{{# address_2 }}\r\n{{{ address_2 }}} <br/> \r\n{{/ address_2 }}\r\n{{{ city }}} {{{ postcode }}} <br/> \r\n{{# zone }}\r\n{{{ zone }}} <br/> \r\n{{/ zone }}\r\n{{{ country }}}\r\n{{/ payment_data }}\r\n</td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left">\r\n <table style="width: 100%; font-family: Verdana,sans-serif; font-size: 11px; color: #000000;">\r\n <tr style="background-color: #CCCCCC;">\r\n <th style="width: 40%; padding: 0.3em; color: #FFFFFF;">Product</th>\r\n <th class="align_left" style="color: #FFFFFF;">Model</th>\r\n<th class="align_right"\r\n style="width: 10%; padding: 0.3em; color: #FFFFFF;">Price</th>\r\n <th class="align_right"\r\n style="width: 15%; padding: 0.3em; color: #FFFFFF;">Quantity</th>\r\n <th class="align_right"\r\n style="width: 20%; padding: 0.3em; color: #FFFFFF;">Total</th>\r\n </tr>\r\n {{# products }}\r\n <tr style="background-color: #EEEEEE; text-align: center;">\r\n <td class="align_left" style="text-align: left;">{{ name }}\r\n {{# option }}\r\n <br/>\r\n &nbsp;&nbsp;- {{ name}} {{ value }} \r\n {{/ option }}\r\n <td class="align_left"> {{ model }} </td>\r\n <td class="align_right"> {{ price }} </td>\r\n <td class="align_right"> {{ quantity }} </td>\r\n <td class="align_right"> {{ total }}</td>\r\n </tr>\r\n {{/ products }}\r\n {{# totals }}\r\n <tr style="text-align: right;">\r\n <td colspan="3">&nbsp;</td>\r\n <td style="background-color: #EEEEEE; font-weight: bold; padding: 0.3em;">{{ title }} </td>\r\n <td style="background-color: #EEEEEE; padding: 0.3em;"> {{ text }}</td>\r\n </tr>\r\n {{/ totals }}\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left"\r\n style="background-color: #069; color: #FFF; font-size: 12px; font-weight: bold; padding: 0.5em 1em;"></td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n {{# comment }}\r\n <tr>\r\n<td class="align_left"\r\n style="background-color: #069; color: #FFF; font-size: 12px; font-weight: bold; padding: 0.5em 1em;">The comments for your order are:</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left"> {{{ comment }}} </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n {{/ comment }}\r\n {{# invoice }}\r\n <tr>\r\n <td class="align_left"\r\n style="background-color: #069; color: #FFF; font-size: 12px; font-weight: bold; padding: 0.5em 1em;">To view your order click on the link below:</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left"><a href="{{ invoice }}"> {{ invoice }}</a></td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n{{/ invoice }}\r\n <tr>\r\n <td class="align_center"\r\n style="font-size: 10px; border-top: 1px solid #069; text-decoration: none; color: #374953;">\r\n <a href="{{ store_url }}"\r\n style="color: #069; font-weight: bold; text-decoration: none;">{{ store_name }}</a>\r\n{{{ text_project_label }}}\r\n </td>\r\n </tr>\r\n</table>\r\n</body>\r\n</html>\r\n', 'Thank you for your interest in {{store_name}} products. Your order has been received and will be processed after payment is confirmed.\r\n\r\nOrder Details\r\n\r\nOrder ID: {{ order_id }}\r\nDate Ordered: {{ date_added }}\r\nPayment Method: {{ payment_method }}\r\nShipping Method: {{ shipping_method }}\r\n\r\nEmail: {{ customer_email }}\r\nTelephone: {{ customer_telephone }}\r\n{{# customer_mobile_phone }}\r\nTelephone: {{ customer_mobile_phone }}\r\n{{/ customer_mobile_phone }}\r\n{{# customer_fax }}\r\nFax: {{ customer_fax }}\r\n{{/ customer_fax }}\r\nIP Address: {{ customer_ip }}\r\n\r\n{{# shipping_data }}\r\nShipping Address:\r\n{{{ firstname }}} {{{lastname}}}\r\n{{{ company }}} \r\n{{{ address_1 }}} \r\n{{{ address_2 }}}\r\n{{{ city }}} {{{ postcode }}}\r\n{{{ zone }}}\r\n{{{ country }}}\r\n{{/ shipping_data }}\r\n\r\n{{# payment_data }}\r\nPayment Address:\r\n{{{ firstname }}} {{{lastname}}}\r\n{{{ company }}} \r\n{{{ address_1 }}} \r\n{{{ address_2 }}}\r\n{{{ city }}} {{{ postcode }}}\r\n{{{ zone }}}\r\n{{{ country }}}\r\n{{/ payment_data }}\r\n\r\n\r\nProduct Model Price Quantity Total\r\n{{# products }}\r\n \r\n{{ name }} {{ model }} {{ price }} {{ quantity }} {{ total }}\r\n {{# option }}\r\n - {{ name}} {{ value }} \r\n {{/ option }}\r\n\r\n\r\n{{/ products }}\r\n{{# totals }}\r\n {{ title }} {{ text }}\r\n{{/ totals }}\r\n\r\n\r\n{{# comment }}\r\n The comments for your order are:\r\n {{{ comment }}} \r\n{{/ comment }}\r\n\r\n{{# invoice }}\r\nTo view your order click on the link below:\r\n{{ invoice }}\r\n{{/ invoice }}\r\n\r\n{{ store_name }}\r\n{{ text_project_label }}', 'store_name, order_id, store_url, logo_uri, logo_html, date_added, payment_method, shipping_method, customer_email, customer_telephone, customer_mobile_phone, customer_fax, customer_ip, shipping_data, payment_data, products, totals, comment, invoice, text_project_label, ', '[[regtime]]', '[[regtime]]', NULL, 0), (8, 1, 'storefront_order_confirm_admin_notify', 1, '', '{{store_name}} - Order {{ order_id }}', '<html>\r\n<head>\r\n <meta http-equiv="Content-Type" content="text/html; charset=utf-8">\r\n <title> {{store_name}} - Order {{ order_id }} </title>\r\n</head>\r\n<body>\r\n<table style="font-family: Verdana,sans-serif; font-size: 11px; color: #374953; width: 600px;">\r\n <tr>\r\n <td class="align_left">\r\n <a href="{{ store_url }}" title="{{ store_name }}">\r\n {{# logo_uri}}\r\n <img src="{{ logo_uri }}" alt="{{store_name}}" style="border: none;">\r\n {{/ logo_uri}}\r\n {{^ logo_uri}}\r\n {{# logo_html}}\r\n {{logo_html}}\r\n {{/ logo_html}}\r\n {{/ logo_uri}}\r\n </a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left">You have received an order.</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left"\r\n style="background-color: #069; color:#FFF; font-size: 12px; font-weight: bold; padding: 0.5em 1em;">Order Details</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left">Order ID: <span\r\n style="color: #069; font-weight: bold;">{{ order_id }}</span><br/>\r\n Date Ordered: {{ date_added }}<br>\r\n Payment Method: <strong>{{ payment_method }}</strong><br/>\r\n Shipping Method: <strong>{{ shipping_method }}</strong><br/>\r\n <br/>\r\n Email: <strong>{{ customer_email }}</strong><br/>\r\n Telephone: <strong>{{ customer_telephone }}</strong><br/>\r\n {{# customer_mobile_phone }}\r\n Telephone: <strong>{{ customer_mobile_phone }}</strong><br/>\r\n {{/ customer_mobile_phone }}\r\n {{# customer_fax }}\r\n Fax: <strong>{{ customer_fax }}</strong><br/>\r\n {{/ customer_fax }}\r\n IP Address:<strong>{{ customer_ip }}</strong>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <table style="width: 100%; font-family: Verdana,sans-serif; font-size: 11px; color: #FFFFFF;">\r\n <tr style="background-color: #CCCCCC; text-transform: uppercase;">\r\n <th style="text-align: left; padding: 0.3em;">Shipping Address</th>\r\n <th style="text-align: left; padding: 0.3em;">Payment Address</th>\r\n </tr>\r\n <tr>\r\n <td style="padding: 0.3em; background-color: #EEEEEE; color: #000;">\r\n{{# shipping_data }}\r\n{{ firstname }} {{lastname}} <br/>\r\n{{# company }}\r\n{{{ company }}} <br/> \r\n{{/ company }}\r\n{{# address_1 }}\r\n{{{ address_1 }}} <br/> \r\n{{/ address_1 }}\r\n{{# address_2 }}\r\n{{{ address_2 }}} <br/> \r\n{{/ address_2 }}\r\n{{{ city }}} {{{ postcode }}} <br/> \r\n{{# zone }}\r\n{{{ zone }}} <br/> \r\n{{/ zone }}\r\n{{{ country }}}\r\n{{/ shipping_data }}\r\n</td>\r\n <td style="padding: 0.3em; background-color: #EEEEEE; color: #000;">\r\n{{# payment_data }}\r\n{{ firstname }} {{lastname}} <br/>\r\n{{# company }}\r\n{{{ company }}} <br/> \r\n{{/ company }}\r\n{{# address_1 }}\r\n{{{ address_1 }}} <br/> \r\n{{/ address_1 }}\r\n{{# address_2 }}\r\n{{{ address_2 }}} <br/> \r\n{{/ address_2 }}\r\n{{{ city }}} {{{ postcode }}} <br/> \r\n{{# zone }}\r\n{{{ zone }}} <br/> \r\n{{/ zone }}\r\n{{{ country }}}\r\n{{/ payment_data }}\r\n</td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n<td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left">\r\n <table style="width: 100%; font-family: Verdana,sans-serif; font-size: 11px; color: #000000;">\r\n <tr style="background-color: #CCCCCC;">\r\n <th style="width: 40%; padding: 0.3em; color: #FFFFFF;">Product</th>\r\n <th class="align_left" style="color: #FFFFFF;">Model</th>\r\n <th class="align_right"\r\n style="width: 10%; padding: 0.3em; color: #FFFFFF;">Price</th>\r\n <th class="align_right"\r\n style="width: 15%; padding: 0.3em; color: #FFFFFF;">Quantity</th>\r\n <th class="align_right"\r\n style="width: 20%; padding: 0.3em; color: #FFFFFF;">Total</th>\r\n </tr>\r\n {{# products }}\r\n <tr style="background-color: #EEEEEE; text-align: center;">\r\n <td class="align_left" style="text-align: left;">{{ name }}\r\n {{# option }}\r\n <br/>\r\n &nbsp;&nbsp;- {{ name}} {{ value }} \r\n {{/ option }}\r\n <td class="align_left"> {{ model }} </td>\r\n <td class="align_right"> {{ price }} </td>\r\n <td class="align_right"> {{ quantity }} </td>\r\n <td class="align_right"> {{ total }}</td>\r\n </tr>\r\n {{/ products }}\r\n {{# totals }}\r\n <tr style="text-align: right;">\r\n <td colspan="3">&nbsp;</td>\r\n <td style="background-color: #EEEEEE; font-weight: bold; padding: 0.3em;">{{ title }} </td>\r\n <td style="background-color: #EEEEEE; padding: 0.3em;"> {{ text }}</td>\r\n </tr>\r\n {{/ totals }}\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left"\r\n style="background-color: #069; color: #FFF; font-size: 12px; font-weight: bold; padding: 0.5em 1em;"></td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n {{# comment }}\r\n <tr>\r\n <td class="align_left"\r\n style="background-color: #069; color: #FFF; font-size: 12px; font-weight: bold; padding: 0.5em 1em;">The comments for your order are:</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left"> {{{ comment }}} </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n {{/ comment }}\r\n {{# invoice }}\r\n <tr>\r\n <td class="align_left"\r\n style="background-color: #069; color: #FFF; font-size: 12px; font-weight: bold; padding: 0.5em 1em;">To view your order click on the link below:</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n<td class="align_left"><a href="{{ invoice }}"> {{ invoice }}</a></td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n{{/ invoice }}\r\n <tr>\r\n <td class="align_center"\r\n style="font-size: 10px; border-top: 1px solid #069; text-decoration: none; color: #374953;">\r\n <a href="{{ store_url }}"\r\n style="color: #069; font-weight: bold; text-decoration: none;">{{ store_name }}</a>\r\n{{{ text_project_label }}}\r\n </td>\r\n </tr>\r\n</table>\r\n</body>\r\n</html>\r\n', 'You have received an order.\r\n\r\nOrder Details\r\n\r\nOrder ID: {{ order_id }}\r\nDate Ordered: {{ date_added }}\r\nPayment Method: {{ payment_method }}\r\nShipping Method: {{ shipping_method }}\r\n\r\nEmail: {{ customer_email }}\r\nTelephone: {{ customer_telephone }}\r\n{{# customer_mobile_phone }}\r\nTelephone: {{ customer_mobile_phone }}\r\n{{/ customer_mobile_phone }}\r\n{{# customer_fax }}\r\nFax: {{ customer_fax }}\r\n{{/ customer_fax }}\r\nIP Address: {{ customer_ip }}\r\n\r\n{{# shipping_data }}\r\nShipping Address:\r\n{{{ firstname }}} {{{lastname}}}\r\n{{{ company }}}\r\n{{{ address_1 }}} \r\n{{{ address_2 }}}\r\n{{{ city }}} {{{ postcode }}}\r\n{{{ zone }}}\r\n{{{ country }}}\r\n{{/ shipping_data }}\r\n\r\n{{# payment_data }}\r\nPayment Address:\r\n{{{ firstname }}} {{{lastname}}} \r\n{{{ company }}}\r\n{{{ address_1 }}}\r\n{{{ address_2 }}}\r\n{{{ city }}} {{{ postcode }}}\r\n{{{ zone }}}\r\n{{{ country }}}\r\n{{/ payment_data }}\r\n\r\n\r\nProduct Model Price Quantity Total\r\n{{# products }}\r\n \r\n{{ name }} {{ model }} {{ price }} {{ quantity }} {{ total }}\r\n {{# option }}\r\n - {{ name}} {{ value }} \r\n {{/ option }}\r\n\r\n\r\n{{/ products }}\r\n{{# totals }}\r\n {{ title }} {{ text }}\r\n{{/ totals }}\r\n\r\n\r\n{{# comment }}\r\n The comments for your order are:\r\n {{{ comment }}} \r\n{{/ comment }}\r\n\r\n{{# invoice }}\r\nTo view your order click on the link below:\r\n{{ invoice }}\r\n{{/ invoice }}\r\n\r\n{{ store_name }}\r\n{{ text_project_label }}', 'store_name, order_id, store_url, logo_uri, logo_html, date_added, payment_method, shipping_method, customer_email, customer_telephone, customer_mobile_phone, customer_fax, customer_ip, shipping_data, payment_data, products, totals, comment, invoice, text_project_label, order_total', '[[regtime]]', '[[regtime]]', NULL, 0), (11, 1, 'admin_order_status_notify', 1, '', '{{ store_name }} - Order Update {{ order_id }}', 'Order: {{ order_id }} <br/>\r\nDate added: {{ order_date_added }} <br/>\r\nOrder status: {{ order_status }} <br/>\r\nInvoice: {{ invoice }}<br/>\r\n<br/>\r\n\r\nComment:<br/>\r\n{{{ comment }}}<br/>\r\n\r\n<br/>\r\n\r\nPlease reply to this email if you have any questions.\r\n', 'Order: {{ order_id }} \r\nDate added: {{ order_date_added }} \r\nOrder status: {{ order_status }} \r\nInvoice: {{ invoice }}\r\n\r\nComment:\r\n{{{ comment }}}\r\n\r\nPlease reply to this email if you have any questions.\r\n', 'store_name, order_id, order_date_added, order_status, invoice, comment', '[[regtime]]', '[[regtime]]', NULL, 0), (12, 1, 'admin_new_transaction_notify', 1, '', 'New transaction has been posted to your {{store_name}} account', 'New transaction has been posted to your {{ store_name }} account in the amount of {{ amount }}. For more details, login to {{ store_name }} account', 'New transaction has been posted to your {{ store_name }} account in the amount of {{ amount }}. For more details, login to {{ store_name }} account', 'store_name, amount, transactions_url', '[[regtime]]', '[[regtime]]', NULL, 0), (13, 1, 'admin_approval_email', 1, '', '{{ store_name}} - Your Account has been activated!', '<a href="{{ store_url }}" title="{{ store_name }}">\r\n {{# logo_uri}}\r\n <img src="{{ logo_uri }}" alt="{{store_name}}" style="border: none;">\r\n {{/ logo_uri}}\r\n {{^ logo_uri}}\r\n {{# logo_html}}\r\n {{logo_html}}\r\n {{/ logo_html}}\r\n {{/ logo_uri}}\r\n </a>\r\n\r\nWelcome and thank you for registering at {{ store_name }} <br/>\r\nYour account has now been created and you can log in by using your email address and password by visiting our website or at the following URL: <br/>\r\n{{ store_url }}<br/>\r\n<br/>\r\n\r\nOnce you logging in, you will be able to access, your wishlist, order history, printing invoices and editing your account information.<br/>\r\n<br/>\r\nThank you,<br/>\r\n {{ store_name}} <br/>\r\n\r\n{{ text_project_label }}', 'Welcome and thank you for registering at {{ store_name }} \r\nYour account has now been created and you can log in by using your email address and password by visiting our website or at the following URL: \r\n{{ store_url }}\r\n\r\nOnce you logging in, you will be able to access, your wishlist, order history, printing invoices and editing your account information.\r\n\r\nThank you,\r\n {{ store_name}} \r\n\r\n{{text_project_label}}', 'store_name, store_url, text_project_label, logo_uri, logo_html', '[[regtime]]', '[[regtime]]', NULL, 0), (14, 1, 'storefront_password_reset_notify', 1, '', '{{store_name}} Notification', 'Your password has been updated! If you did not do any changes, please contact site owner<br/>', 'Your password has been updated! If you did not do any changes, please contact site owner', 'store_name, loginname, customer_id, firstname, lastname', '[[regtime]]', '[[regtime]]', NULL, 0), (15, 1, 'storefront_customer_account_update', 1, '', '{{store_name}} Account update notification', 'Your account has been updated! If you did not do any changes, please contact site owner ', ' Your account has been updated! If you did not do any changes, please contact site owner ', 'store_name, firstname, lastname, telephone, fax, email, loginname, customer_id, old_loginname, old_email', '[[regtime]]', '[[regtime]]', NULL, 0), (16, 1, 'storefront_contact_us_mail', 1, '', 'Enquiry from {{ first_name }}', '<html>\r\n<head>\r\n <meta http-equiv="Content-Type" content="text/html; charset=utf-8">\r\n <title>{{ title }}</title>\r\n</head>\r\n<body>\r\n<table style="font-family: Verdana,sans-serif; font-size: 11px; color: #374953; width: 600px;">\r\n <tr>\r\n <td class="align_left">\r\n <a href="{{ store_url }}" title="{{ store_name }}">\r\n {{# logo_uri }}\r\n <img src="{{ logo_uri }}" alt="{{ store_name }}" style="border: none;">\r\n {{/ logo_uri }}\r\n {{# logo_html }}\r\n {{ logo_html }}\r\n {{/ logo_html }} \r\n </a>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r<td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left"\r\n style="background-color: #069; color:#FFF; font-size: 12px; font-weight: bold; padding: 0.5em 1em;">{{ entry_enquiry }}</td>\r\n </tr>\r\n <tr>\r\n <td class="align_left"\r\n style=" font-size: 12px; padding: 0.5em 1em;">{{{ enquiry }}}</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <table style="width: 100%; font-family: Verdana,sans-serif; font-size: 11px; color: #FFFFFF;">\r\n {{# tpl_form_fields }}\r\n <tr>\r\n <td style="padding: 0.3em; background-color: #EEEEEE; color: #000;">{{ name }}</td>\r\n <td style="padding: 0.3em; background-color: #EEEEEE; color: #000;">{{ value }}</td>\r\n </tr>\r\n {{/ tpl_form_fields }}\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td class="align_center"\r\n style="font-size: 10px; border-top: 1px solid #069; text-decoration: none; color: #374953;">\r\n <a href="{{ store_url }}"\r\n style="color: #069; font-weight: bold; text-decoration: none;">{{ store_name }}</a><br>\r\n{{{ text_project_label }}}\r\n </td>\r\n </tr>\r\n</table>\r\n</body>\r\n</html>\r\n', '{{ store_name }}\r\n\r\n{{ entry_enquiry }}\r\n{{{ enquiry }}}\r\n\r\n\r\n{{# tpl_form_fields }}\r\n{{ name }} {{ value }}\r\n{{/ tpl_form_fields }}\r\n\r\n{{{ text_project_label }}}', 'first_name, title, store_url, store_name, logo_uri, logo_html, entry_enquiry, enquiry, tpl_form_fields, form_fields, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0), (17, 1, 'storefront_contact_us_mail_admin_notify', 1, '', 'New enquiry from customer', ' You have got new enquiry from customer ({{first_name}}, {{email}})!', ' You have got new enquiry from customer ({{first_name}}, {{email}})! ', 'first_name, email', '[[regtime]]', '[[regtime]]', NULL, 0), (18, 1, 'storefront_new_customer_admin_notify', 1, '', ' New Customer {{ firstname }} {{ lastname }} has been registered!', ' New Customer {{ firstname }} {{ lastname }} has been registered!', ' New Customer {{ firstname }} {{ lastname }} has been registered!', 'firstname, lastname', '[[regtime]]', '[[regtime]]', NULL, 0), (19, 1, 'storefront_new_subscriber_admin_notify', 1, '', ' New Subscriber {{ firstname }} {{ lastname }} has been registered!', ' New Subscriber {{ firstname }} {{ lastname }} has been registered!', ' New Subscriber {{ firstname }} {{ lastname }} has been registered!', 'firstname, lastname', '[[regtime]]', '[[regtime]]', NULL, 0), (21, 1, 'storefront_product_out_of_stock_admin_notify', 1, '', 'Product with ID #{{ product_id }} is out of Stock. ', ' Product with ID #{{ product_id }} is out of Stock. \r\n<br/><br/>\r\n{{{ text_project_label }}}', ' Product with ID #{{ product_id }} is out of Stock. \r\n\r\n{{{ text_project_label }}}', 'product_id, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0), (22, 1, 'storefront_product_review_admin_notify', 1, '', ' New product review has been added.', ' New product review has been added. See details {{ product_url }}\r\n<br/><br/>\r\n{{{ text_project_label }}}', ' New product review has been added. See details {{ product_url }}\r\n\r\n{{{ text_project_label }}}', 'product_url, product_id, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0), (23, 1, 'storefront_welcome_email_approved', 1, '', 'Welcome, {{store_name}} ', '<html>\r\n <head>\r\n <meta http-equiv="Content-Type" content="text/html; charset=utf-8">\r\n </head>\r\n <body>\r\n <table style="font-family: Verdana,sans-serif; font-size: 11px; color: #374953; width: 600px;">\r\n <tr>\r\n <td class="align_left">\r\n <a href="{{ store_url }}" title="{{ store_name }}">\r\n {{# logo_uri}}\r\n <img src="{{ logo_uri }}" alt="{{store_name}}" style="border: none;">\r\n {{/ logo_uri}}\r\n {{^ logo_uri}}\r\n {{# logo_html}}\r\n {{logo_html}}\r\n {{/ logo_html}}\r\n {{/ logo_uri}}\r\n </a>\r\n </td>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>Welcome and thank you for registering at {{ store_name }}</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n Your account has now been created and you can log in by using your email address and password by visiting our website or at the following URL:<br/>\r\n<a href="{{ login_url }}">{{ login_url }}</a><br/>\r\nOnce you logging in, you will be able to access, your wishlist, order history, printing invoices and editing your account information.\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n Thank you.<br/>\r\n {{ store_name }}\r\n<br/><br/>\r\n{{{ text_project_label }}}\r\n </td>\r\n </tr>\r\n </table>\r\n </body>\r\n</html>', 'Welcome and thank you for registering at {{ store_name }}\r\n\r\nYour account has now been created and you can log in by using your email address and password by visiting our website or at the following URL:\r\n{{ login_url }}\r\n\r\nOnce you logging in, you will be able to access, your wishlist, order history, printing invoices and editing your account information.\r\n\r\nThank you.\r\n{{ store_name }}\r\n{{{ text_project_label }}}', 'store_name, login_url, store_url, logo_html, logo_uri, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0), (24, 1, 'fast_checkout_welcome_email_guest_registration', 1, '', 'Welcome, {{store_name}}', '<html>\r\n <head>\r\n <meta http-equiv="Content-Type" content="text/html; charset=utf-8">\r\n </head>\r\n <body>\r\n <table style="font-family: Verdana,sans-serif; font-size: 11px; color: #374953; width: 600px;">\r\n <tr>\r\n <td class="align_left">\r\n <a href="{{ store_url }}" title="{{ store_name }}">\r\n {{# logo_uri}}\r\n <img src="{{ logo_uri }}" alt="{{store_name}}" style="border: none;">\r\n {{/ logo_uri}}\r\n {{^ logo_uri}}\r\n {{# logo_html}}\r\n {{logo_html}}\r\n {{/ logo_html}}\r\n {{/ logo_uri}}\r\n </a>\r\n </td>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>Welcome and thank you for registering at {{ store_name }}</td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n Your account has now been created and you can log in by using your email address and password by visiting our website or at the following URL:<br/>\r\n<a href="{{ login_url }}">{{ login_url }}</a><br/>\r\n<br/>\r\nYour Login Name: {{login}} <br/>\r\nYour Password: {{password}} <br/>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>&nbsp;</td>\r\n </tr>\r\n <tr>\r\n <td>\r\n Thank you.<br/>\r\n {{ store_name }}\r\n<br/><br/>\r\n{{{ text_project_label }}}\r\n </td>\r\n </tr>\r\n </table>\r\n </body>\r\n</html>', 'Welcome and thank you for registering at {{ store_name }}\r\n\r\nYour account has now been created and you can log in by using your email address and password by visiting our website or at the following URL:\r\n{{ login_url }}\r\n\r\nYour Login Name: {{login}}\r\nYour Password: {{password}}\r\n\r\n\r\nThank you.\r\n{{ store_name }}\r\n{{{ text_project_label }}}', 'store_name, login_url, store_url, logo_html, logo_uri, text_project_label, login, password', '[[regtime]]', '[[regtime]]', NULL, 0), (25, 1, 'admin_reset_password_link', 1, '', '{{store_name}} - Password reset', 'A password reset was requested from {{store_name}}<br />\r\nTo reset your password click link below:<br />\r\n<a href="{{ reset_link }}">{{ reset_link }}</a >\r\n<br /><br />\r\n{{{ text_project_label }}}', 'A password reset was requested from {{store_name}} \r\nTo reset your password click link below:\r\n{{ reset_link }}\r\n\r\n\r\n{{{ text_project_label }}}', 'store_name, reset_link, text_project_label', '[[regtime]]', '[[regtime]]', NULL, 0);
-- -- Table structure for table `[[dbprefix]]field_descriptions` --
CREATE TABLE `[[dbprefix]]field_descriptions` ( `field_id` int(11) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL COMMENT 'translatable', `description` varchar(255) NOT NULL DEFAULT '' COMMENT 'translatable', `language_id` int(11) NOT NULL, `error_text` varchar(255) NOT NULL DEFAULT '' COMMENT 'translatable', PRIMARY KEY (`field_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -- Dumping data for table `[[dbprefix]]field_descriptions` --
INSERT INTO `[[dbprefix]]field_descriptions` VALUES (11, 'First name:', '', 1, 'Name must be between 3 and 32 characters!'), (12, 'Email:', '', 1, 'E-Mail Address does not appear to be valid!'), (13, 'Enquiry:', '', 1, 'Enquiry must be between 10 and 3000 characters!'), (14, 'Enter the code in the box below:', '', 1, 'Human verification has failed! Please try agan.');
-- -- Table structure for table `[[dbprefix]]orders` --
CREATE TABLE `[[dbprefix]]orders` ( `order_id` int(11) NOT NULL AUTO_INCREMENT, `invoice_id` int(11) NOT NULL DEFAULT '0', `invoice_prefix` varchar(10) NOT NULL DEFAULT '', `store_id` int(11) NOT NULL DEFAULT '0', `store_name` varchar(64) NOT NULL, `store_url` varchar(255) NOT NULL, `customer_id` int(11) NOT NULL DEFAULT '0', `customer_group_id` int(11) NOT NULL DEFAULT '0', `firstname` varchar(32) NOT NULL DEFAULT '', `lastname` varchar(32) NOT NULL, `telephone` varchar(32) NOT NULL DEFAULT '', `fax` varchar(32) NOT NULL DEFAULT '', `email` varchar(96) NOT NULL DEFAULT '', `shipping_firstname` varchar(32) NOT NULL, `shipping_lastname` varchar(32) NOT NULL DEFAULT '', `shipping_company` varchar(32) NOT NULL, `shipping_address_1` varchar(128) NOT NULL, `shipping_address_2` varchar(128) NOT NULL, `shipping_city` varchar(128) NOT NULL, `shipping_postcode` varchar(10) NOT NULL DEFAULT '', `shipping_zone` varchar(128) NOT NULL, `shipping_zone_id` int(11) NOT NULL, `shipping_country` varchar(128) NOT NULL, `shipping_country_id` int(11) NOT NULL, `shipping_address_format` text NOT NULL, `shipping_method` varchar(128) NOT NULL DEFAULT '', `shipping_method_key` varchar(128) NOT NULL DEFAULT '', `payment_firstname` varchar(32) NOT NULL DEFAULT '', `payment_lastname` varchar(32) NOT NULL DEFAULT '', `payment_company` varchar(32) NOT NULL, `payment_address_1` varchar(128) NOT NULL, `payment_address_2` varchar(128) NOT NULL, `payment_city` varchar(128) NOT NULL, `payment_postcode` varchar(10) NOT NULL DEFAULT '', `payment_zone` varchar(128) NOT NULL, `payment_zone_id` int(11) NOT NULL, `payment_country` varchar(128) NOT NULL, `payment_country_id` int(11) NOT NULL, `payment_address_format` text NOT NULL, `payment_method` varchar(128) NOT NULL DEFAULT '', `payment_method_key` varchar(128) NOT NULL DEFAULT '', `comment` text NOT NULL, `total` decimal(15,4) NOT NULL DEFAULT '0.0000', `order_status_id` int(11) NOT NULL DEFAULT '0', `language_id` int(11) NOT NULL, `currency_id` int(11) NOT NULL, `currency` varchar(3) NOT NULL, `value` decimal(15,8) NOT NULL, `coupon_id` int(11) NOT NULL, `date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `ip` varchar(50) NOT NULL DEFAULT '', `payment_method_data` text NOT NULL, PRIMARY KEY (`order_id`,`customer_id`,`order_status_id`), KEY `ac_orders_idx` (`invoice_id`,`store_id`,`customer_group_id`,`shipping_zone_id`,`shipping_country_id`,`payment_zone_id`,`payment_country_id`,`language_id`,`currency_id`,`coupon_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
-- -- Dumping data for table `[[dbprefix]]orders` --
-- -- Table structure for table `[[dbprefix]]product_descriptions` --
CREATE TABLE `[[dbprefix]]product_descriptions` ( `product_id` int(11) NOT NULL, `language_id` int(11) NOT NULL, `name` varchar(255) NOT NULL COMMENT 'translatable', `meta_keywords` varchar(255) NOT NULL COMMENT 'translatable', `meta_description` varchar(255) NOT NULL COMMENT 'translatable', `description` longtext NOT NULL COMMENT 'translatable', `blurb` text NOT NULL COMMENT 'translatable', PRIMARY KEY (`product_id`,`language_id`), KEY `name` (`name`), KEY `ac_product_descriptions_name_idx` (`product_id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -- Dumping data for table `[[dbprefix]]product_descriptions` --
INSERT INTO `[[dbprefix]]product_descriptions` VALUES (73, 1, 'Highlighting Expressions', '', '', '<p>\r\n WHAT<br />\r\n Pantene Pro-V COLOUR HAIR SOLUTIONS Highlighting Expressions™ Conditioner protects and enhances colour treated hair and infuses blonde highlights with shine. The advanced Pro-Vitamin formula restores shine to dull highlights and protects hair from daily damage. This non-colour depositing formula works for all blonde highlights.</p>\r\n<p>\r\n WHY<br />\r\n Pantene uncovered that oxidative colouring changes hair’s structure. Internally, the chemistry in hair colour attacks strength-giving proteins in hair and makes the fibre more porous, leading to weaker hair that fades more quickly. The surface of the hair fibres becomes uneven and the protective layer of the hair fibre disintegrates. Without the protective layer, the hair fibre is prone to micro-scarring and damage, which changes the way it interacts with light and leads to a dull appearance.</p>\r\n<p>\r\n HOW<br />\r\n Pantene’s non-colour depositing conditioner is designed to reinforce the structure of blonde highlighted hair and give it what it needs to reveal vibrant, glossy colour. Conditioning ingredients help revitalize and replenish highlighted hair while delivering brilliant shine and protecting from future damage. The result is healthy-looking hair rejuvenated with shimmering blonde highlights.</p>\r\n<p>\r\n USE<br />\r\n For rich, vibrant colour that’s shiny and healthy-looking, use with Pantene Pro-V Pantene COLOUR HAIR SOLUTIONS Highlighting Expressions™ Shampoo and Colour Nourishing Treatment.</p>\r\n', ''), (74, 1, 'Curls to straight Shampoo', '', '', '<p>\r\n YOUR HAIR’S STARTING POINT<br />\r\n Curly</p>\r\n<p>\r\n WHAT<br />\r\n Pantene Curly Hair Series Curls to Straight Shampoo gently removes build-up, adding softness and control to your curls. The cleansing formula helps align and smooth the hair fibers. The result is healthy-looking hair that’s protected from frizz and ready for straight styling.</p>\r\n<p>\r\n WHY<br />\r\n Research shows that each curly hair fibre grows in a unique pattern, twisting and turning in all directions. This unpredictable pattern makes it difficult to create and control straight styles. The curved fibres of curly hair intersect with each other more often than any other hair type, causing friction which can result in breakage. The curvature of the hair fibre also provides a large amount of volume in curly hair, which can be hard to tame.</p>\r\n<p>\r\n HOW<br />\r\n Pantene’s straight shampoo contains micro-smoothers that aid you in loosening and unwinding curls from their natural pattern. Curly hair is left ready for frizz controlled straight styling, and protected from styling damage.</p>\r\n<p>\r\n USE<br />\r\n For healthy-looking, curly hair that’s styled straight, use with Curls to Straight Conditioner and Anti-Frizz Straightening Crème.</p>\r\n', ''), (75, 1, 'Dove Men Care Body Wash', '', '', '<p>\r\n A body and face wash developed for men''s skin with Micromoisture technology.<br />\r\n Micromoisture activates on skin when lathering up, clinically proven to fight skin dryness.<br />\r\n Deep cleansing gel that rinses off easily. With purifying grains.<br />\r\n Dermatologist recommended.</p>\r\n', ''), (76, 1, 'Men Care Clean Comfort Deodorant', '', '', '<p>\r\n The first scented deodorant from Dove® specifically designed with a non-irritating formula to give men the power of 48-hour protection against underarm odor with advanced ¼ moisturizer technology. The bottom line? It’s tough on odor, not on skin</p>\r\n', ''), (77, 1, 'Men Care Active Clean Shower Tool', 'tool, man', '', '<p>\r\n Dove® Men CareTM Active Clean Dual-Sided Shower Tool works with body wash for extra scrubbing power you can’t get from just using your hands. The mesh side delivers the perfect amount of thick cleansing lather, and the scrub side helps exfoliate for a deeper clean. Easy to grip and easy to hang. For best results, replace every 4-6 weeks.</p>\r\n', ''), (78, 1, 'ck IN2U Eau De Toilette Spray for Him', '', '', '<p>\r\n Fresh but warm; a tension that creates sexiness.Spontaneous - sexy - connectedCK IN2U him is a fresh woody oriental that penetrates with lime gin fizz and rushes into a combination of cool musks that radiate from top to bottom and leaves you wanting more.</p>\r\n', ''), (79, 1, 'ck One Gift Set', '', '', '<p>\r\n 2 PC Gift Set includes 3.4 oz EDT Spray Magnets. Ck One Cologne by Calvin Klein, Two bodies, two minds, and two souls are merged into the heat and passion of one. This erotic cologne combines man and woman with one provocative scent. This clean, refreshing fragrance has notes of bergamot, cardamom, pineapple, papaya, amber, and green tea.</p>\r\n', ''), (50, 1, 'Skinsheen Bronzer Stick', '', '', '<p>\r\n Bronzes, shapes and sculpts the face. Sheer-to-medium buildable coverage that looks naturally radiant and sunny. Stashable - and with its M·A·C Surf, Baby look – way cool. Limited edition.</p>\r\n', ''), (51, 1, 'BeneFit Girl Meets Pearl', '', '', '<p>\r\n Luxurious liquid pearl…the perfect accessory! This soft golden pink liquid pearl glides on for a breathtakingly luminous complexion. Customise your pearlessence with the easy to use twist up package … a few clicks for a subtle sheen, more clicks for a whoa! glow. Pat the luminous liquid over make up or wear alone for dewy lit from within radiance. It''s pure pearly pleasure. Raspberry and chamomile for soothing. Light reflecting pigments for exquisite radiance. Sweet almond seed for firming and smoothing. Sesame seed oil for moisturising.Fresh red raspberry scent.</p>\r\n', ''), (52, 1, 'Benefit Bella Bamba', '', '', '<p>\r\n Amplify cheekbones and create the illusion of sculpted features with this 3D watermelon blush. Laced with shimmering gold undertones, bellabamba is taking eye popping pretty to the third dimension…you’ll never use traditional blush again! Tip: For a poreless complexion that pops, sweep bellabamba on cheeks after applying professional</p>\r\n', ''), (53, 1, 'Tropiques Minerale Loose Bronzer', '', '', '<p>\r\n Precious earths, exclusively selected for their luxurious silky texture and gentle quality, are layered with mineral pigments in this lightweight powder to mimic the true color of tanned skin. Unique technology with inalterable earths ensures exquisite wear all day. Mineral blend smoothes complexion, while Aloe Vera helps protect skin from dryness.</p>\r\n', ''), (54, 1, 'L''EXTRÊME Instant Extensions Lengthening Mascara', '', '', '<p>\r\n Extend your lashes up to 60% instantly! This exclusive Fibrestretch formula takes even the smallest natural lashes to dramatic lengths. The patented Extreme Lash brush attaches supple fibers to every eyelash for an instant lash extension effect.</p>\r\n', ''), (55, 1, 'LE ROUGE ABSOLU Reshaping & Replenishing LipColour SPF 15', '', '', '<p>\r\n Smoother. Fuller. Absolutely replenished lips. This advanced lip color provides 6-hour care with continuous moisture and protective Vitamin E. Features plumping polymer and non-feathering color to define and reshape lips. Choose from an array of absolutely luxurious shades with a lustrous pearl or satin cream finish.</p>\r\n', ''), (56, 1, 'Waterproof Protective Undereye Concealer', '', '', '<p>\r\n This natural coverage concealer lets you instantly eliminate tell-tale signs of stress and fatigue. Provides complete, natural-looking coverage, evens skin tone, covers dark circles and minimizes fine lines around the eyes. The Result: A soft, matte finish</p>\r\n', ''), (57, 1, 'Delicate Oil-Free Powder Blush', '', '', '<p>\r\n A sparkling shimmer of colour for a radiant glow. Silky soft, micro-bubble formula glides on easily and evenly. Lasts for hours. Oil-free and oil-absorbing, yet moisture-balancing. Perfect for all skin types.</p>\r\n', ''), (58, 1, 'Product with stock locations', '', '', '<p>\r\n There are degrees of cover-up…some like less, some like more! Our blendable powder formula with SPF 15 goes on beautifully sheer &amp; builds easily for customized coverage. Sweep on with the accompanying brush for a sheer, natural finish or apply with the sponge for full coverage or spot cover-up. Our 6 flattering shades (2 light, 2 medium, 2 deep) make it incredibly easy to find your perfect shade. Once gals apply "hello flawless!" they''ll finally have met their match q!</p>\r\n', ''), (59, 1, 'Viva Glam Lipstick', '', '', '<p>\r\n Time to wham up the GLAM in VIVA GLAM! It''s a gaga-glamorous look at our abiding passion: The M·A·C AIDS Fund and the VIVA GLAM program are the heart and soul of M·A·C Cosmetics. Ladies and gentlemen, we give you the sensational Cyndi Lauper and the electric Lady Gaga</p>\r\n', ''), (60, 1, 'Nail Lacquer', '', '', '<p>\r\n Revolutionary new high gloss formula. Three long-wearing finishes - Cream, Sheer, and Frosted. Visibly different. Provides no-streak/no-chip finish. Contains conditioners and UV protection. Go hi-lacquer!</p>\r\n', ''), (61, 1, 'Color Design Eye Brightening All in One 5 Shadow & Liner Palette', '', '', '<p>\r\n Infinitely luminous. Sensationally smooth. All-in-one 5 shadow palette to brighten eyes. Lancome’s new versatile, all-in-one palette conveniently creates a full eye look for day or night. Experience the newest generation of luminosity as silky lustrous powders transparently wrap the skin, allowing a seamless layering of pure color for a silky sheen and radiant finish. Build with absolute precision and apply the shades in 5 simple steps (all over, lid, crease, highlighter and liner) to design your customized eye look. Contour, sculpt and lift in soft day colors or intensify with dramatic evening hues for smoldering smoky effects. Long wear, 8-hour formula. Color does not fade, continues to stay true</p>\r\n', ''), (62, 1, 'ck one shock for him Deodorant', '', '', '<p>\r\n Shock Off! cK one shock for him opens with pure freshness, the heart pulses with spice and finishes with a masculine tobacco musk. Experience ck one shock, the newest fragrance from Calvin Klein with this 2.6 oz Deodorant.</p>\r\n', ''), (63, 1, 'Pour Homme Eau de Toilette', '', '', '<p>\r\n An intriguing masculine fragrance that fuses the bracing freshness of Darjeeling tea with the intensity of spice and musk. For those seeking a discreet accent to their personality.</p>\r\n', ''), (64, 1, 'Beauty Eau de Parfum', '', '', '<p>\r\n Beauty by Calvin Klein is a sophisticated and feminine fragrance presenting a new scructure to modern florals. Radiating rich and intense luminosity; Beauty leaves a complex and memorable impression. Experience the glamour and strength with the Beauty Eau de Parfum</p>\r\n', ''), (65, 1, 'Absolue Eye Precious Cells', '', '', '<p>\r\n Smoothes – Tightens – Regenerates Radiance Exclusive innovation from Lancôme A powerful combination of unique ingredients – Reconstruction Complex and Pro-Xylane™ – has been shown to improve the condition around the stem cells, and stimulate cell regeneration to reconstruct skin to a denser quality*. Results Immediately, the eye contour appears smoother and more radiant. Day 7, signs of fatigue are minimized and the appearance of puffiness is reduced. Day 28, density is improved. Skin is soft and looks healthier. The youthful look of the eye contour is restored. Ophthalmologist – tested. Dermatologist – tested for safety.</p>\r\n', ''), (66, 1, 'Total Moisture Facial Cream', '', '', '<p>\r\n Say good-bye to dry skin and hello to “total moisture”. This facial cream provides concentrated immediate &amp; long-term hydration for an ultra radiant complexion. Contains exclusive tri-radiance complex to help develop the skin’s reserves of water &amp; reinforce skin’s moisture barrier for a radiantly refreshed complexion. For normal to dry skin.</p>\r\n', ''), (67, 1, 'Flash Bronzer Body Gel', '', '', '<p>\r\n Look irresistible! Discover the self-tanning results you dream of: Instant bronzed glowing body Enriched with natural caramel extract for an immediate, gorgeous, bronzed glow. Exquisitely beautiful tan The perfect balance of self-tanning ingredients helps to achieve an ideal color, providing an even, natural-looking, golden tan. Color development within 30 minutes, lasting up to 5 days. Transfer-resistant formula With an exclusive Color-Set™ complex that smoothes on without streaks, dries in 4 minutes and protects clothes against rub-off. Hydrating &amp; smoothing action Leaves skin soft, smooth, and hydrated. Pure Vitamin E delivers antioxidant protection, helping to reduce signs of premature aging. Indulgent experience Delightfully scented with hints of jasmine and honey in a silky, non-greasy formula</p>\r\n', ''), (68, 1, 'Absolute Anti-Age Spot Replenishing Unifying TreatmentSPF 15', '', '', '<p>\r\n A luxurious and comprehensive hand treatment that addresses the special needs of mature hands. Diminishes and discourages the appearance of age spots, while replenishing and protecting the skin. RESULT: Immediately, skin on hands is hydrated, soft and luminous. With continued use, skin becomes more uniform, looks firmer and youthful.Massage into hands and cuticles as needed.</p>\r\n', ''), (69, 1, 'Seaweed Conditioner', '', '', '<p>\r\n What it is:<br />\r\n A lightweight detangler made with marine seaweed and spirulina.</p>\r\n<p>\r\n What it does:<br />\r\n This conditioner gently detangles, nourishes, softens, and helps to manage freshly washed hair.</p>\r\n<p>\r\n What it is formulated WITHOUT:<br />\r\n - Parabens</p>\r\n<p>\r\n What else you need to know:<br />\r\n Made with marine greens for practically anyone (and ideal for frequent bathers), this conditioner is best paired with Seaweed Shampoo. It''s also safe for use on color-treated hair.</p>\r\n<p>\r\n -Sea Silk Extract: Nourishes scalp; promotes healthy looking hair.<br />\r\n -Ascophyllum Nudosum (Seaweed) Extract: Moisturizes; adds elasticity, luster, softness, body; reduces flyaways.<br />\r\n -Macrocystis Pyrifera (Sea Kelp) Extract: Adds shine and manageability.<br />\r\n -Spirulina Maxima Extract: Hydrates.</p>\r\n', ''), (70, 1, 'Eau Parfumee au The Vert Shampoo', '', '', '<p>\r\n Structured around the refreshing vitality and purtiy of green tea, Bvlgari Eau the Vert Shampoo is an expression of elegance and personal indulgence. Delicately perfumed Eau Parfumée au thé vert shampoo gentle cleansing action makes it perfect for daily use.</p>\r\n', ''), (71, 1, 'Pantene Pro-V Conditioner, Classic Care', '', '', '<p>\r\n Conditions hair for healthy shine. How Can You See Healthy Hair? Pantene Complete Therapy Conditioner has a unique pro-vitamin complex that deeply infuses every strand - So you see 6 signs of health hair: Shine; Softness; Strength; Body; Less Frizz; Silkiness. Pantene Complete Therapy Conditioner: The ultimate pro-vitamin therapy provides gentle daily nourishing moisture for enhanced shine; Helps hair detangle easily; Helps prevent frizz and flyaways. Simply use and in just 10 days - and very day after - see shiny hair that''s soft with less frizz. Best of all, healthy Pantene hair that is strong and more resistant to damage. Made in USA.</p>\r\n', ''), (72, 1, 'Brunette expressions Conditioner', '', '', '<p>\r\n YOUR HAIR’S STARTING POINT<br />\r\n Colour-Treated or Highlighted</p>\r\n<p>\r\n WHAT<br />\r\n Pantene Pro-V COLOUR HAIR SOLUTIONS Brunette Expressions™ Conditioner hydrates hair for rich colour that is protected from daily stress and damage. This non-colour depositing formula works for all shades of brunette hair.</p>\r\n<p>\r\n WHY<br />\r\n Pantene uncovered that oxidative colouring changes hair’s surface. Internally, the chemistry in hair colour attacks strength-giving proteins in hair and makes the fibre more porous, leading to weaker hair and that fades more quickly. The surface of the hair fibres then becomes uneven and the protective layer of the hair fibre disintegrates. Without the protective layer, the hair fibre is prone to micro-scarring and damage, which changes the way it interacts with light and leads to a dull appearance.</p>\r\n<p>\r\n HOW<br />\r\n Pantene’s advanced Pro-Vitamin formula enhances brunette colour for great intensity and radiant shine. Non-colour depositing conditioning ingredients enhance and protect colour treated hair, while helping to restore shine to coloured strands. Hair is moisturized and infused with radiant shine.</p>\r\n<p>\r\n USE<br />\r\n For rich, vibrant colour that’s shiny and healthy-looking, use with Pantene Pro-V Pantene COLOUR HAIR SOLUTIONS Brunette Expressions™ Shampoo and Colour Nourishing Treatment.</p>\r\n', ''), (80, 1, 'Acqua Di Gio Pour Homme', '', '', '<p>\r\n A resolutely masculine fragrance born from the sea, the sun, the earth, and the breeze of a Mediterranean island. Transparent, aromatic, and woody in nature Aqua Di Gio Pour Homme is a contemporary expression of masculinity, in an aura of marine notes, fruits, herbs, and woods.</p>\r\n<p>\r\n Notes:<br />\r\n Marine Notes, Mandarin, Bergamot, Neroli, Persimmon, Rosemary, Nasturtium, Jasmine, Amber, Patchouli, Cistus.<br />\r\n Style:<br />\r\n Transparent, modern, and masculine.</p>\r\n', ''), (81, 1, 'Armani Eau de Toilette Spray ', '', '', '<p>\r\n This confidently masculine embodiment of the sophisticated ease and understated elegance of Giorgio Armani fashions - is a simply tailored, yet intensely sensual combination of sparkling fresh fruits, robust spices, and rich wood notes.<br />\r\n Notes:<br />\r\n Lime, Bergamot, Mandarin, Sweet Orange, Petitgrain, Cinnamon, Clove, Nutmeg, Jasmine, Neroli, Coriander, Lavender, Oakmoss, Sandalwood, Patchouli, Vetiver, Cedar.<br />\r\n Style:<br />\r\n Fresh, masculine, and discreet.</p>\r\n', ''), (82, 1, 'Armani Code after shave balm', '', '', '<p>\r\n Splash on this refreshing balm post-shave to soothe and calm the skin. Scents skin with a hint of seductive Code.<br />\r\n <br />\r\n Ingredients<br />\r\n Alcohol, Aqua/Water/Eau, Parfum/Fragrance, PEG 8, PEG 60 Hydrogenated Castor Oil, BHT, Allantoin (Comfrey Root), Linalool, Geraniol, Alpha Isomethyl Ionone, Coumarin, Limonene, Hydroxyisohexl 3 Cyclohexene Carboxaldehyde, Hydroxycitronellal, Citronellol, Citral, Butylphenyl Methlyproprional, Hexylcinnamal</p>\r\n', ''), (83, 1, 'Armani Code Sport', '', '', '<p>\r\n Sport. It''s a rite of seduction. A vision of Giorgio Armani, translated into a fragrance.<br />\r\n <br />\r\n This scent opens with an explosive freshness that features spearmint, peppermint, and wild mint—surprising and unusual top notes with a stunning effect. The citrusy heart of the fragrance reveals Code Sport''s seductive power. Notes of vetiver from Haiti reveal a woody and distinguished character, at once wet and dry. Like a crisp coating of ice, a note of hivernal prolongs the dialogue between the scent''s cool crispness and sensual breath, giving the fragrance an almost unlimited life.<br />\r\n <br />\r\n Notes:<br />\r\n Spearmint, Peppermint, Wild Mint, Citrus, Hivernal, Hatian Vetiver, Nigerian Ginger.<br />\r\n Style:<br />\r\n Stunning. Cool. Seductive.</p>\r\n', ''), (84, 1, 'Armani Code Pour Femme', '', '', '<p>\r\n A seductive new fragrance for women, Armani Code Pour Femme is a fresh, sexy, feminine blend of zesty blood orange, ginger, and pear sorbet softened with hints of sambac jasmine, orange blossom, and lavender honey, warmed with precious woods and vanilla.<br />\r\n <br />\r\n Notes:<br />\r\n Blood Orange, Ginger, Pear Sorbet, Sambac Jasmine, Orange Blossom, Seringa Flower, Lavender Honey, Precious Woods Complex, Vanilla.<br />\r\n Style:<br />\r\n Fresh. Sexy. Feminine.</p>\r\n', ''), (85, 1, 'Forbidden euphoria Eau de Parfum Spray ', '', '', '<p>\r\n Possessing an innate confidence and sophistication, she is just starting to explore her sexuality. What she doesn''t yet know is that she already is every man''s fantasy.<br />\r\n <br />\r\n A younger interpretation of Euphoria, this fruity floriental scent capitalizes on a modern, fresh sexiness with a mysterious twist. Its sparkling top notes seduce the senses with a blend of forbidden fruit such as mandarin, passion fruit, and iced raspberry. The heart blooms with a hypnotic bouquet of tiger orchid and jasmine. Underneath its exotic floralcy lies a layer of addictive patchouli and a sophisticated blend of musks and cashmere woods for an everlasting impression.<br />\r\n <br />\r\n Notes:<br />\r\n Sparkling Mandarin, Peach Blossom, Iced Raspberry, Pink Peony, Tiger Orchid, Jasmine, Cashmere Woods, Patchouli Absolute, Skin Musk.<br />\r\n Style:<br />\r\n Sophisticated. Confident. Forbidden.</p>\r\n', ''), (86, 1, 'Euphoria Men Intense Eau De Toilette Spray', '', '', '<p>\r\n Launched by the design house of Calvin Klein in 2008, EUPHORIA MEN INTENSE is a men''s fragrance that possesses a blend of Rain Water, Pepper, Ginger, Sage, Frosted Sudachi, Cedar leaf, Patchouli, Myrrh, Labdanum, Amber Solid, Vetiver</p>\r\n', ''), (87, 1, 'MAN Eau de Toilette Spray', '', '', '<p>\r\n Man by Calvin Klein was launched in October of 2007 and proposed as a new classic for the modern Calvin Klein man, aged from 25 to 40. The name itself is programmatic and unambiguous, like an English translation of L''Homme by Yves Saint Laurent. Simple, brief, to the point. You are going to smell the essence of masculinity if you are to take your cue from the name of the fragrance. The packaging is sleek, modernist, with an architectural sense of proportions and looks good. The fragrance was created by perfumers Jacques Cavallier and Harry Fremont from Firmenich in collaboration with consultant Ann Gottlieb. All these people are old hands at marketing successful mainstream fragrances. Man offers therefore a mainstream palatability but without coming across as depersonalized. It plays the distinctiveness card, but in a well reined in manner. The fragrance bears a typical masculine fresh aromatic, woody and spicy signature around the linear heart of the scent which itself is dark, fruity, and sweet enough to feel feminine. This rich amber-fruity accord is made even more seductive thanks to just the right amount of citrus-y counterpoint, which never clarifies the scent but on the contrary helps to deepen the dark fruity sensation.<br />\r\n </p>\r\n', ''), (88, 1, 'ck one Summer 3.4 oz', '', '', '<p>\r\n It''s a concert on a hot summer night. The stage is set and the show''s about to start. Feel the breeze, catch the vibe, and move to the beat with the pulsating energy of this limited-edition fragrance. A unisex scent, it is fresh, clean, and easy to wear. The fragrance opens with a burst of crisp melon. In the heart notes, an invigorating blend of green citrus and the zesty herbaceous effect of verbena creates a cool, edgy freshness. A base of exotic incense and earthy oakmoss is wrapped in the light, sensuous warmth of cedarwood, musk, and peach skin. Notes:Tangerine, Water Fern, Melon, Lemon, Sea Breeze Accord, Blue Freesia, Verbena, Rhubarb, Cedarwood, Skin Musk, Incense, Peach Skin. Style:Invigorating. Crisp. Cool.</p>\r\n', ''), (89, 1, 'Secret Obsession Perfume', '', '', '<p>\r\n Calvin Klein Secret Obsession eau de parfum spray for women blends notes of forbidden fruits, exotic flowers and a sultry wood signature to create an intoxicating aroma that is provocative and addictive.Calvin Klein is one of World of Shops most popular brands, and this Calvin Klein Secret Obsession eau de parfum spray for women is a firm favourite amongst our customers for its deep, feminine aroma that is perfect for those special evenings out.</p>\r\n', ''), (90, 1, 'Obsession Night Perfume', '', '', '<p>\r\n Launched by the design house of Calvin Klein in 2005, OBSESSION NIGHT is a women''s fragrance that possesses a blend of gardenia, tonka bean, bergamot, vanilla, sandalwood, jasmine, rose, amber, muguet and mandarin. It is recommended for evening wear.</p>\r\n<p>\r\n Ingredients<br />\r\n Notes: Bergamot, Bitter Orange, Mandarin, White Floral, Angelica Root, Gardenia, Rose, Muguet, Night-Blooming Jasmine, Vanilla, Tonka Bean, Amber, Labdanum, Sandalwood, Cashmere Wood</p>\r\n', ''), (91, 1, 'Jasmin Noir Body Lotion 6.8 fl oz', '', '', '<p>\r\n A bath collection for the body, scented with the Jasmin Noir fragrance. A tribute to ultimate femininity. Seduction and personal indulgence.<br />\r\n Body Lotion Fragrance: The new emblematic creation within the Bvlgari Pour Femme Collection Jasmin Noir, perfectly embodies the luxury and prestige of Bvlgari fine jewelry.<br />\r\n Jasmin Noir is a flower of the imagination. Precious jasmine, white and immaculate, in its noire interpretation. A flower of pure mystery. A rich and delicate flower that at nightfall, reveals its intriguing sensuality. A precious floral woody fragrance with ambery accents centered around one of the true jewels of perfumery: the jasmin flower. A scent that conjures forth the bewildering seductiveness of feminity as elegant as it is profoundly sensual.<br />\r\n Jasmin Noir tells a voluptuous floral story that begins with the pure radiance of luminous light given by green and scintillating notes: Vegetal Sap and fresh Gardenia Petals. Then, tender and seductive, the Sambac Jasmine Absolute, delivers its generous and bewitching notes. Unexpectedly allied with a transparent silky almond accord, it reveals a heart that is light yet thoroughly exhilarating and marvelously addictive. The scent''s sumptuously rich notes repose on a bed of Precious Wood and ambery undertones, bringing together the depth and mystery of Patchouli, the warmth of Tonka Bean and the comfort of silky Musks for an elegant and intimate sensuality.<br />\r\n An exquisite fragrance of incomparable prestige, Jasmin Noir captures the very essence of the jeweler.<br />\r\n Made in Italy<br />\r\n </p>\r\n', ''), (92, 1, 'Body Cream by Bulgari', '', '', '<p>\r\n BVLGARI (Bulgari) by Bvlgari Body Cream 6.7 oz for Women Launched by the design house of Bvlgari in 1994, BVLGARI is classified as a refined, floral fragrance. This feminine scent possesses a blend of violet, orange blossom, and jasmine. Common spellings: Bulgari, Bvlgary, Bulgary.</p>\r\n', ''), (93, 1, 'Creme Precieuse Nuit 50ml', '', '', '<p>\r\n A luxurious, melting night cream to repair skin during sleep Features Polypeptides that boost production of collagen &amp; elastin Improves skin elasticity &amp; firmness Visibly reduces appearance of wrinkles, fine lines &amp; brown spots Enriched with Bvlgari Gem Essence to restore radiance Skin appears smooth, energized &amp; luminous in morning Perfect for all skin types</p>\r\n', ''), (94, 1, 'Night Care Crema Nera Obsidian Mineral Complex', '', '', '<p>\r\n When it comes to body, skin or eye care, you want to look to our products and you will find the best there is. These are the most exceptional personal care products available. They meet the strictest standards for quality sourcing, environmental impact, results and safety. Our body care products truly allows you to be good to your whole body.</p>\r\n<p>\r\n Giorgio Armani - Cream Nera - Night Care Crema Nera Obsidian Mineral Complex3 Restoring Cream SPF 15 50ml/1.69oz A lavish, fresh &amp; weightless anti-aging creamProvides shielding &amp; moisturizing benefitsDeveloped with Obsidian Mineral Complex technology Formulated with iron, silicon &amp; perlite to create a potent dermal restructuring system Contains Pro-XylaneTM &amp; Hyaluronique Acid Targets loss of substance, sagging of features &amp; deepening of wrinkles Reveals firmer, sleeker &amp; plumper skin in a youthful look. With a fabulous Skincare product like this one, you''ll be sure to enjoy the ultimate in a Skincare experience with promising results.</p>\r\n', ''), (95, 1, 'Skin Minerals For Men Cleansing Cream', '', '', '<p>\r\n Ultra-purifying skincare enriched with essential moisturizing minerals, designed to instantly moisturize / purify the skin.<br />\r\n Active Ingredients<br />\r\n - Sodium and Potassium System: to preserve cutaneous hydration.<br />\r\n - Salicylic Acid and Hamamelis Extract: to tighten the pores and tone skin.<br />\r\n High Performances: the figures.<br />\r\n Self-assessment*:<br />\r\n - leaves the skin clean 100%<br />\r\n - leaves the skin comfortable 93%<br />\r\n - leaves the skin smooth 95%<br />\r\n - skin complexion is uniform 89%<br />\r\n - skin texture is refined 80%<br />\r\n * use test: 60 men 20 -65 years old 4 weeks of self-assessment</p>\r\n', ''), (96, 1, 'Eye master', '', '', '<p>\r\n The volcanic force of minerals concentrated in multi action skincare specifically designed to target wrinkles, bags and dark circles of the delicate eye area. To combat signs of aging and fatigue and visibly improve skin quality.<br />\r\n Active Ingredients<br />\r\n - Volcanic Complex: an innovative combination of energy charged minerals, inspired by volcanic rocks<br />\r\n - Caffeine extract: to fight puffiness<br />\r\n - Conker and butcher’s broom extracts to stimulate cutaneous blood micro-circulation<br />\r\n High Performances: the figures.<br />\r\n Proven immediate anti-puffiness action*:<br />\r\n - 15 minutes after application –19%<br />\r\n *instrumental test, 40 men, 42-65 years old<br />\r\n Self-assessment<br />\r\n - instantly revitalizes skin 77%**<br />\r\n - wrinkles appear reduced 78%***<br />\r\n - diminishes the appearance of dark circles 68%***<br />\r\n ** use test, 40 men 42-65 years old, single application, self-assessment<br />\r\n *** use test, 40 men 42-65 years old, 4 weeks, self-assessment</p>\r\n', ''), (97, 1, 'Eye Rejuvenating Serum', '', '', '<p>\r\n The first advanced rejuvenating ‘weapon’ thanks to a corrective and smoothing texture and a power amplifying applicator.<br />\r\n The alliance of the [3.R] technology combined with an intensive re-smoothing system.<br />\r\n The eye rejuvenation serum also comes in an easily portable tube that boasts a silver bevelled applicator to ensure a good delivery of the product to the eye area as well as offering a means to improve circulation and reduce puffiness and eye bags.</p>\r\n<p>\r\n Rarely women have been so convinced of its efficiency on skin rejuvenation:</p>\r\n<p>\r\n EYE CONTOUR LOOKS SMOOTHER 85%*<br />\r\n EYES LOOK YOUNGER 91%*<br />\r\n EYE PUFFINESS LOOKS SOFTENED 83%*</p>\r\n<p>\r\n *% of women – self assessment on 60 women after 4 weeks</p>\r\n', ''), (98, 1, 'Shaving cream', '', '', '<p>\r\n Moisturizing, charged with minerals and enriched with ultra softening agents. Its specific formula ensures an optimal, extremely gentle shave. Even four hours after shaving, the skin remains hydrated, soft and supple.<br />\r\n Active Ingredients<br />\r\n - Sodium and Potassium System: to preserve cutaneous hydration<br />\r\n - Bisabolol: to soothe skin<br />\r\n High Performances: the figures.<br />\r\n Measurements 4 hours after shaving:<br />\r\n - skin hydration 29%*<br />\r\n - skin softness 61%**<br />\r\n - skin suppleness 18%**<br />\r\n - skin dryness -39%**</p>\r\n<p>\r\n <br />\r\n * instrumental test, 20 men, 20-70 years old<br />\r\n ** clinical scorage, 20 men, 20-70 years old</p>\r\n', ''), (99, 1, 'Fluid shine nail polish', '', '', '<p>\r\n Luxurious color at your fingertips. Fluid shine coats nails with intense shine and long-lasting, sophisticated color. The essential accessory to any makeup wardrobe.</p>\r\n<p>\r\n Discover the Bronze collection 2010<br />\r\n Finish this season’s high summer look with a cranberry n°43 or blackberry n°44 nail, to echo the wet lips with intense color.</p>\r\n', ''), (100, 1, 'Smooth silk lip pencils', '', '', '<p>\r\n An incredibly soft lip pencil for subtle, precise definition. The silky texture allows for easy application and flawless results. To extend the hold of your lip color, fill lips in completely with Smooth silk lip pencil before applying your lipstick. Choose from a wide range of shades to complement every color in your lipstick wardrobe.</p>\r\n', ''), (101, 1, 'Pro-V Color Hair Solutions Color Preserve Shine Conditioner', 'pantene, shampoo', '', '<p>\r\n PANTENE''s color preserve shine shampoo and conditioner system with micro-polishers smoothes and refinishes the hair’s outer layer. So your hair reflects light and shines brilliantly. Help preserve your multi-dimensional color.</p>\r\n<p>\r\n <strong>Product Features</strong><br />\r\n Micro-polishers smooth the outer layer of hair to help Protect color and leave hair shiny<br />\r\n Lightweight moisturizers provide protection against damage<br />\r\n Designed for color-treated hair; Gentle enough for permed hair</p>\r\n<p>\r\n <strong>Ingredients</strong><br />\r\n Water, Stearyl Alcohol, Behentrimonium Methosulfate, Cetyl Alcohol, Fragrance, Bis-Aminopropyl Dimethicone, Isopropyl Alcohol, Benzyl Alcohol, Disodium EDTA, Panthenol, Panthenyl Ethyl Ether, Methylchloroisothiazolinone, Methylisothiazolinone</p>\r\n<p>\r\n </p>\r\n', ''), (102, 1, 'Gucci Guilty', 'gicci, spray', '', '<ul>\r\n <li>\r\n Notes Consist Of Mandarin, Pink Pepper, Peach, Lilac, Geranium, Amber And Patchouli</li>\r\n <li>\r\n For Casual Use</li>\r\n</ul>\r\n<p>\r\n <em>Gucci Guilty</em> is a warm yet striking oriental floral with hedonism at its heart.<br />\r\n <br />\r\n The scent seizes the attention with a flamboyant opening born of the natural rush that is mandarin shimmering alongside an audacious fist of pink pepper.<br />\r\n <br />\r\n The middle notes are an alluring concoction of heady lilac and geranium, laced with the succulent tactility of peach - all velvet femininity with a beguiling hint of provocation.<br />\r\n <br />\r\n The patchouli that is the hallmark of Gucci fragrances here conveys a message of strength, while the voluptuousness of amber suggests deep femininity.</p>\r\n', ''), (103, 1, 'Jasmin Noir L''Essence Eau de Parfum Spray 75ml', '', '', '<p>\r\n A carnal impression of the immaculate jasmine flower, Bvlgari Jasmin Noir L''Essence dresses the purity of the bloom in jet black mystery.<br />\r\n <br />\r\n The fragrance is a more concentrated Eau de Parfum than the original Jasmin Noir, a blend of rare and precious ingredients that are more seductive, and more addictive than ever before. The profoundly sensual elixir captivates the senses, and enchants its wearer with its generous and bewitching touches.<br />\r\n <br />\r\n A luminous bottle that honours the heritage of Bvlgari.</p>\r\n', ''), (104, 1, 'Calvin Klein Obsession For Women EDP Spray', '', '', '<p>\r\n Citrus, vanilla and greens lowering to notes of sandalwood, spices and musk. Recommended Use daytime</p>\r\n<p>\r\n <em>''Obsession''</em> perfume was launched by the design house of Calvin Klein in 1985</p>\r\n<p>\r\n When you think about Calvin Klein, initially you think of his clothing line – specifically his jeans and underwear lines (not to mention the famous ad with a young Brooke Shields). But Calvin Klein’s penchant for perfume was equally as cutting edge as his foray into fashion.</p>\r\n', ''), (105, 1, 'Bvlgari Aqua', '', '', '<p>\r\n Bvlgari Aqua (Pour Homme) Eau De Toilette Spray is an enticing and fresh cologne that exudes masculinity from its unique blend of amber santolina, posidonia and mandarin.</p>\r\n<p>\r\n Bvlgari Aqua (Pour Homme) Eau De Toilette Spray scent lasts throughout the day without having an overpowering smell. It is subtle enough for daytime use and masculine enough for night wear.</p>\r\n', ''), (106, 1, 'Omnia Eau de Toilette 65ml', 'bvlgary, omnia, EDT', '', '<p>\r\n Choose Your scent</p>\r\n<p>\r\n </p>\r\n<p>\r\n <strong>Omnia Coral:</strong> Inspired by the shimmering hues of precious red coral, Omnia Coral is a radiant floral-fruity Eau de Toilette of tropical Hibiscus and juicy Pomegranate, reminiscent of Summer, the sun, resplendent nature and far-off oceans.</p>\r\n<p>\r\n <strong>Omnia Amethyst:</strong> Inspired by the shimmering hues of the amethyst gemstone, this floral Eau de Toilette captures the myriad scents of Iris and Rose gardens caressed with morning dew.</p>\r\n<p>\r\n <strong>Omnia Crystalline:</strong> Created from the glowing clarity and purity of crystal, Omnia Crystalline is a sparkling jewel of light, illuminating and reflecting the gentle sensuality and luminous femininity. Sparkling like a precious jewel, like the rarest of crystals, in an exquisite jewel flacon.</p>\r\n', ''), (107, 1, 'Lancome Slimissime 360 Slimming Activating Concentrate Unisex Treatment', '', '', '<ul>\r\n <li>\r\n An anti-cellulite body treatment</li>\r\n <li>\r\n Features a special gel-cream texture &amp; a quick-dissolving formula</li>\r\n <li>\r\n Formulated with an exclusive 360 Complex</li>\r\n</ul>\r\n<p>\r\n An anti-cellulite body treatment. Features a special gel-cream texture &amp; a quick-dissolving formula. Formulated with an exclusive 360 Complex. Helps combat presence of cellulite &amp; reduce existing cellulite. Provides immediate invigorating &amp; firming results. Concentrated with micro-pearl particles to illuminate skin. Creates svelte &amp; re-sculpted body contours....</p>\r\n', ''), (108, 1, 'Lancome Hypnose Doll Lashes Mascara 4-Piece Gift Set', '', '', '<p>\r\n Lancome Hypnose Doll Lashes Mascara 4-Piece Gift Set! Limited Edition!</p>\r\n<ol>\r\n <li>\r\n 0.22 oz full-size Hypnôse Doll Lashes Mascara in Black</li>\r\n <li>\r\n 0.07 oz full-size Le Crayon Khol Eyeliner in Black Ebony</li>\r\n <li>\r\n 0.07 oz travel-size Cils Booster XL Super Enhancing Mascara Base</li>\r\n <li>\r\n 1.7 fl oz travel-size Bi-Facil Double-Action Eye Makeup Remover</li>\r\n</ol>\r\n', ''), (109, 1, 'Lancome Visionnaire Advanced Skin Corrector', '', '', '<p>\r\n Lancôme innovates with VISIONNAIRE [LR 2412 4%], its first skincare product formulated to fundamentally recreate truly beautiful skin.<br />\r\n <br />\r\n A Lancôme technological breakthrough has identified a miraculous new molecule.<br />\r\n <br />\r\n The name of this molecule: LR 2412.<br />\r\n <br />\r\n A molecule that is able to “self-propel” through the layers of the epidermis, to set off a series of tissular micro-transformations. The result is that skin is visibly transformed: the texture is inner, wrinkles are erased, pigmentary and vascular irregularities are reduced and pores are tightened.</p>\r\n<p>\r\n </p>\r\n<p>\r\n <em></em></p>\r\n', ''), (110, 1, 'Flora By Gucci Eau Fraiche', '', '', '<ul>\r\n <li>\r\n Perfect for all occasions</li>\r\n <li>\r\n This item is not a tester; New and sealed</li>\r\n <li>\r\n Contains natural ingredients</li>\r\n</ul>\r\n<p>\r\n Gucci presents the new spring version of this perfume called flora by Gucci eau fraiche in 2011. Even younger, more airy, vivid, sparkling and fresher than the original, the new fragrance is enriched with additional aromas of citruses in the top notes and aquatic and green nuances in the heart, while the base remains unchanged. The composition begins with mandarin, bergamot, kumquat, lemon and peony. The heart is made of rose petals and Osman thus with green and aquatic additions, laid on the base of sandalwood, patchouli and pink pepper.</p>\r\n', ''), (111, 1, 'New French With Ease (1 book 1 mp3 CD)', '', '', 'This title is available in book and CD. All Assimil courses are based on intuitive assimilations[registered], an original principle that is simple yet highly effective. Assimil has taken this natural process, through which you learned to speak your own language, and adapted it to their book and audio courses. Working progressively, with natural, lively dialogues, simple text notes and exercises, you will progress steadily to a level where you are able to converse in everyday situations. The first part of the course is the passive phase: you immerse yourself in the language by reading and repeating each lesson. During the second, the active phase, you use the structures and reflexes you have already absorbed while continuing to advance and learn. In just a few months, you will be able to speak French easily, fluently and naturally.<br />\r\n&nbsp;\r\n<ul style="color: rgb(51, 51, 51); padding: 0px; list-style-type: none; font-size: 13px; font-family: verdana, arial, helvetica, sans-serif; line-height: 19px; orphans: auto; text-align: start; text-indent: 0px;">\r\n <li>Audio CD: 610 pages</li>\r\n <li>Publisher: ASSiMiL (3 April 2008)</li>\r\n <li>Language: English</li>\r\n <li>ISBN-10: 2700570057</li>\r\n <li>ISBN-13: 978-2700570052</li>\r\n <li>Product Dimensions: 23.6 x 17.8 x 5.1 cm</li>\r\n</ul>\r\n', ''), (112, 1, 'The Miracle Morning: The Not-So-Obvious Secret Guaranteed to Transform Your Life', '', '', 'What if you could miraculously wake up tomorrow and any&mdash;or every area of your life was transformed? What would be different? Would you be happier? Healthier? More successful? In better shape? Would you have more energy? Less Stress? More Money? Better relationships? Which of your problems would be solved?<br />\r\n&nbsp;\r\n<ul style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal;">\r\n <li><b style="font-weight: 700; font-family: verdana, arial, helvetica, sans-serif;">Print Length:</b> 172 pages</li>\r\n <li><b style="font-weight: 700; font-family: verdana, arial, helvetica, sans-serif;">Page Numbers Source ISBN:</b> 0979019710</li>\r\n <li><b style="font-weight: 700; font-family: verdana, arial, helvetica, sans-serif;">Publication Date:</b> December 7, 2012</li>\r\n <li><b style="font-weight: 700; font-family: verdana, arial, helvetica, sans-serif;">Language:</b> English</li>\r\n <li><b style="font-weight: 700; font-family: verdana, arial, helvetica, sans-serif;">ASIN:</b> B00AKKS278</li>\r\n</ul>\r\n\r\n<hr />\r\nAbout the Author\r\n<p>At age 20, Hal Elrod was hit head on by a drunk driver at 70 mph, was dead for 6 minutes, and doctors told his parents that if Hal ever came out of his coma, he had permanent brain damage and may never walk again. After 6 days of fighting for his life, Hal proved that we all have the ability to overcome any obstacle and create the life of our dreams. Not only did he walk, he became an ultra-marathon runner, hall of fame business achiever, international Keynote Speaker, Success Coach, husband, father, hip-hop recording artist, and multiple time #1 bestselling author of &quot;The Miracle Morning: The Not-So-Obvious Secret Guaranteed To Transform Your Life... (Before 8AM)&quot; and &quot;Taking Life Head On: How To Love the Life You Have While You Create the Life of Your Dreams&quot;&mdash;two of the highest rated and most acclaimed books on Amazon.com. (Just read a few of the 200 five-star reviews, and you&rsquo;ll see why.) Hal has appeared on dozens of radio and TV shows, and he&rsquo;s been featured in numerous books, including The Education of Millionaires, Cutting Edge Sales, Living College Life in the Front Row, The Author&rsquo;s Guide To Building An Online Platform, The 800-Pound Gorilla of Sales and the bestselling Chicken Soup for the Soul series. To contact Hal about media appearances, speaking at your event, or if you just want to receive free training videos and resources, visit www.YoPalHal.com. To connect with Hal on Twitter, follow @HalElrod, and on Facebook at www.Facebook.com/YoPalHal.</p>\r\n', ''), (113, 1, 'Paper Towns by John Green', '', '', '<strong>Winner of the Edgar Award<br />\r\nThe #1 New York Times Bestseller<br />\r\nPublishers Weekly and USA Today Bestseller</strong><br />\r\n<br />\r\n<em>Millions of Copies Sold</em><br />\r\n<br />\r\nQuentin Jacobsen has spent a lifetime loving the magnificent Margo Roth Spiegelman from afar. So when she cracks open a window and climbs back into his life&mdash;summoning him for an ingenious campaign of revenge&mdash;he follows. When their all-nighter ends and a new day breaks, Margo has disappeared. But Q soon learns that there are clues&mdash;and they&rsquo;re for him. Embarking on an exhilarating adventure to find her, the closer Q gets, the less he sees the girl he thought he knew.<br />\r\n<br />\r\nOctober 2008<br />\r\n352 pages<br />\r\nISBN 9781101010938<br />\r\nTitle: Paper Towns<br />\r\nAuthor: John Green', ''), (114, 1, 'Allegiant by Veronica Roth', '', '', 'Now includes an excerpt from the upcoming Four: A Divergent Collection.<br />\r\n<br />\r\nWhat if your whole world was a lie? What if a single revelation&mdash;like a single choice&mdash;changed everything? What if love and loyalty made you do things you never expected?<br />\r\nThe explosive conclusion to Veronica Roth&#39;s #1 New York Times bestselling Divergent trilogy reveals the secrets of the dystopian world that has captivated millions of readers in <em>Divergent</em> and <em>Insurgent</em>.<br />\r\n<br />\r\nOctober 2013<br />\r\n544 pages<br />\r\nISBN 9780062209276<br />\r\nTitle: Allegiant<br />\r\nAuthor: Veronica Roth', ''); INSERT INTO `[[dbprefix]]product_descriptions` VALUES (115, 1, 'Fiorella Purple Peep Toes', '', '', 'Add more charm to your casual footwear collection with these purple peep toes from the house of Fiorella. Featuring a non-leather upper and lining, these slip-ons ate high on durability and style. While the wedge heels add extra inches to your silhouette, the resin sole ensures optimal traction for your feet. Team these peep toes with your casual outfits to complete your look for the day.<br />\r\n<br />\r\nSole Material&nbsp; <strong>Resin Sheet</strong><br />\r\nInner Lining&nbsp;&nbsp; &nbsp;<strong>SYNTHETIC</strong><br />\r\nClosing&nbsp;&nbsp; &nbsp;<strong>&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; Slip On</strong><br />\r\nHeel shape&nbsp;&nbsp;&nbsp;&nbsp; <strong>Wedge</strong><br />\r\nHeel height&nbsp;&nbsp; &nbsp;<strong> Medium: 2.5-3.5 Inch</strong>\r\n<hr />&nbsp;\r\n<table style="margin: 0px; padding: 0px; width: 385px; color: rgb(34, 34, 34); font-family: Arial; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 18px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);">\r\n <tbody style="margin: 0px; padding: 0px;">\r\n <tr style="margin: 0px; padding: 0px;">\r\n <th style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap;">Euro Size</th>\r\n <th style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap;">UK Size</th>\r\n <th style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap;">Foot Size (In Cm)</th>\r\n </tr>\r\n <tr class="even" style="margin: 0px; padding: 0px;">\r\n <td class="f-bold" style="margin: 0px; padding: 7px; font-weight: bold; text-align: center; white-space: nowrap; background: rgb(238, 238, 238);">36</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap; background: rgb(238, 238, 238);">3</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap; background: rgb(238, 238, 238);">22.8-23.2</td>\r\n </tr>\r\n <tr style="margin: 0px; padding: 0px;">\r\n <td class="f-bold" style="margin: 0px; padding: 7px; font-weight: bold; text-align: center; white-space: nowrap;">37</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap;">4</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap;">23.4-23.7</td>\r\n </tr>\r\n <tr class="even" style="margin: 0px; padding: 0px;">\r\n <td class="f-bold" style="margin: 0px; padding: 7px; font-weight: bold; text-align: center; white-space: nowrap; background: rgb(238, 238, 238);">38</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap; background: rgb(238, 238, 238);">5</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap; background: rgb(238, 238, 238);">24.0-24.6</td>\r\n </tr>\r\n <tr style="margin: 0px; padding: 0px;">\r\n <td class="f-bold" style="margin: 0px; padding: 7px; font-weight: bold; text-align: center; white-space: nowrap;">39</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap;">6</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap;">24.8-25.2</td>\r\n </tr>\r\n <tr class="even" style="margin: 0px; padding: 0px;">\r\n <td class="f-bold" style="margin: 0px; padding: 7px; font-weight: bold; text-align: center; white-space: nowrap; background: rgb(238, 238, 238);">40</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap; background: rgb(238, 238, 238);">6.5</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap; background: rgb(238, 238, 238);">25.4-25.7</td>\r\n </tr>\r\n <tr style="margin: 0px; padding: 0px;">\r\n <td class="f-bold" style="margin: 0px; padding: 7px; font-weight: bold; text-align: center; white-space: nowrap;">41</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap;">7</td>\r\n <td style="margin: 0px; padding: 7px; text-align: center; white-space: nowrap;">26.0-26.4</td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n', ''), (116, 1, 'New Ladies High Wedge Heel Toe Thong Diamante Flip Flop Sandals', '', '', '<p>The annual Summer trend for wedges is back with these classic flip flop wedge heels. The sandals have a toe thong design, diamante detailing to the front and look fab worn with a maxi dress for a classic Summer look. Available in a choice of five different colours.</p>\r\n\r\n<ul>\r\n <li>Available in 5 different colours</li>\r\n <li>Diamante detailing to the front</li>\r\n <li>Outer Material: <em>Synthetic</em></li>\r\n <li>Inner Material: <em>Manmade</em></li>\r\n <li>Heel Height: <em>9.5 centimetres</em></li>\r\n <li>Heel Type: Wedge</li>\r\n <li>Sandals have a toe thong design</li>\r\n <li>Classic flip flop wedge heels</li>\r\n <li><strong>Perfect for the Summer!</strong></li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n', ''), (117, 1, 'Ruby Shoo Womens Jada T-Bar', '', '', '<p>Ruby Shoo is made up of a small team based in north London, England, with a passion for creating unique shoes and accessories that generate smiles whenever they are worn. We simply love it when we are asked the question: &quot;Where did you get your shoes?&quot;</p>\r\n\r\n<ul>\r\n <li style="list-style-type: square; margin-left: 20px;">Occasion footwear</li>\r\n <li style="list-style-type: square; margin-left: 20px;">Flower detail</li>\r\n <li style="list-style-type: square; margin-left: 20px;">Outer Material: Synthetic</li>\r\n <li style="list-style-type: square; margin-left: 20px;">Inner Material: Manmade</li>\r\n <li style="list-style-type: square; margin-left: 20px;">Sole: Manmade</li>\r\n <li style="list-style-type: square; margin-left: 20px;">Closure: Buckle</li>\r\n <li style="list-style-type: square; margin-left: 20px;">Heel Height: 9 centimetres</li>\r\n <li style="list-style-type: square; margin-left: 20px;">Heel Type: Stiletto</li>\r\n</ul>\r\n', ''), (118, 1, 'Womens high heel point toe stiletto sandals ankle strap court shoes', '', '', '<p>Fashion Thirsty&reg; branded products are only available exclusively through Fashion Thirsty</p>\r\n<ul>\r\n <li>Brand New In Box</li>\r\n <li>Available In A Range Of Colours And Fabrics</li>\r\n <li>Outer Material: Synthetic</li>\r\n <li>Inner Material: Manmade</li>\r\n <li>Sole: manmade</li>\r\n <li>Closure: Buckle</li>\r\n <li>Heel Height: 4.3</li>\r\n <li>Heel Type: Stiletto</li>\r\n <li>Approx Heel Height: 4.3 Inches / 10.8 cm</li>\r\n <li>Approx Platform Height: 0.1 inches / 0.3 cm</li>\r\n <li>Ankle Strap With Buckle Fastening</li>\r\n</ul>\r\n\r\n', ''), (119, 1, 'Fruit of the Loom T-Shirts 5 Pack - Super Premium', '', '', '5x Fruit of the Loom T-Shirt Super Premium T<br />\r\n10 Colors - Sizes: S, M, L, XL, XXL oder XXXL\r\n<hr />The purchase of this 5-packs, you have the following choice:<br />\r\n&bull; 5 of the same color t-shirts (available in 18 colors)<br />\r\n&bull; 5 different colored T-shirts (given in 8 color sets available)<br />\r\nYou have the freedom to choose from the adult sizes S, M, L, XL, XXL or XXXL.', ''), (120, 1, 'Jersey Cotton Striped Polo Shirt', '', 't-shirs, men', '<p>Classically designed Charles Wilson polo shirts now available.<br />\r\nThis premium polo collection is a result of many years experience in designing and manufacturing polo shirts.<br />\r\nPart of our Jersey Stripe polo range this colourful jersey cotton polo shirt is a must have piece for any casual wardrobe.<br />\r\nDesigned in the UK<br />\r\n100% Cotton<br />\r\nJersey Stripe Polo<br />\r\nMulti-Stripe Design<br />\r\nThree Button Design<br />\r\nMachine Washable at 40 Degrees</p>\r\n', ''), (121, 1, 'Designer Men Casual Formal Double Cuffs Grandad Band Collar Shirt Elegant Tie', '', '', 'Superb style double cuffs shirt. Made using highest quality cotton. Grandad collar. Slim Fit. Highest quality - made in Turkey. Great as casual or formal shirt.', ''), (122, 1, 'Product with options and stock locations', '', '', 'Designed by slim fit style FOR men and women in highest qualities and workmanship to bring buyers A different outlook on life of fashion Casual Basic Slim Fit Polo Shirts\r\n<ul>\r\n <li>100% COTTON</li>\r\n <li>If you buy these Polo shits, You&#39;ll never regret about purchase. Because it is so nice designed shirts for your daily look.</li>\r\n <li>Soft Elastic Decent slim fit &amp; Button placket &amp; sleeve ribbing with contrast trim.</li>\r\n <li>Machine Wash / Hand Wash Recommended</li>\r\n</ul>\r\n', ''), (123, 1, 'Casual 3/4 Sleeve Baseball T-Shirt', 't-shirt', 'Rich Cotton Raglan T-Shirts', 'This classic raglan t-shirt is perfect for all occasions. Whether you are working out or hanging out, this shirt is a win for the versatility. Perfect to join your friends to watch and cheer for your favorite team in all sports: basketball, football, football, hockey or baseball.<br /><br /><!--n--><!--n-->The raglan t-shirts are great options for men and women looking for a stylish look in their casual looks. For mild days bet on the 3/4 sleeve model in contrasting color. <br />Made in 100% cotton fabric, features slim fit and round neckline.', ''), (124, 1, 'Test name: Infinite Comfort Performance Jackson''s Running Shoes with Shock Absorption Technology - AirFlex Pro Elite Series', 'Running shoes, Performance footwear, Shock absorption technology, Comfortable running sneakers, Athletic footwear, Jogging shoes, Elite series shoes, Sports shoes, Cushioned running shoes, Breathable mesh upper, Impact reduction shoes, Fitness footwear, M', 'Step into ultimate comfort and performance with the AirFlex Pro Elite Series running shoes. Engineered with advanced shock absorption technology, these athletic sneakers offer a smooth and cushioned ride', '<p>The annual Summer trend for wedges is back with these classic flip flop wedge heels. The sandals have a toe thong design, diamante detailing to the front and look fab worn with a maxi dress for a classic Summer look. Available in a choice of five different colours.</p>\r\n\r\n<ul>\r\n <li>Available in 5 different colours</li>\r\n <li>Diamante detailing to the front</li>\r\n <li>Outer Material: <em>Synthetic</em></li>\r\n <li>Inner Material: <em>Manmade</em></li>\r\n <li>Heel Height: <em>9.5 centimetres</em></li>\r\n <li>Heel Type: Wedge</li>\r\n <li>Sandals have a toe thong design</li>\r\n <li>Classic flip flop wedge heels</li>\r\n <li><strong>Perfect for the Summer!</strong></li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n', 'Step into a world of unparalleled comfort and performance with our AirFlex Pro Elite Series, the ultimate running shoes for athletes and fitness enthusiasts.');
-- -- Table structure for table `[[dbprefix]]reviews` --
CREATE TABLE `[[dbprefix]]reviews` ( `review_id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL, `customer_id` int(11) NOT NULL, `author` varchar(64) NOT NULL DEFAULT '', `text` longtext NOT NULL, `rating` int(1) NOT NULL, `verified_purchase` tinyint(4) NOT NULL DEFAULT '0', `status` int(1) NOT NULL DEFAULT '0', `date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`review_id`), KEY `ac_reviews_idx` (`product_id`,`customer_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=87 ;
-- -- Dumping data for table `[[dbprefix]]reviews` --
INSERT INTO `[[dbprefix]]reviews` VALUES (63, 77, 6, 'Bernard Horne', 'I thought since it was made for men that it was the perfect thing to go with the body wash. Its too small and doesnt lather up very well.', 3, 1, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (62, 54, 2, 'Juliana Davis', 'I''ve been wearing all Lancome mascara''s and I''m just get really upset when I''m out. I''ve tried other Brands, but it''s always right back to the Lancome productss. The extend L''EXTREME is by far the best!!! Really Long and Great! ', 5, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (61, 56, 0, 'Cassandra', 'Fortunately, I got this as a gift. BUT, I am willing to purchase this when I run out. This may be expensive but it is sooooo worth it! I love this concealer and I wouldn''t even dare to use other brands. One more thing, the little tube lasts for a long time. I''ve been using it everyday for 8 months now and I still have about 1/4 left.', 5, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (64, 76, 7, 'James', 'Finally a deodorant for men that doesn''t smell like cheap cologne. I''ve been using this for a couple of weeks now and I can''t say anything bad about it. To me it just smells fresh', 4, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (65, 100, 0, 'Juli', 'Smooth Silk is an accurate name for this creamy lip liner. It is by far the best lip pencil I have ever encountered.', 5, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (66, 100, 0, 'Marianne', 'Nice pencil! This is a smooth, long lasting pencil, wonderful shades!', 4, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (67, 97, 0, 'Ann', 'Really reduces shades and swellings)', 4, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (68, 99, 0, 'Alice', 'This is much darker than the picture', 2, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (69, 57, 0, 'Jane', 'When it arrived, the blush had cracked and was crumbling all over, so I''m only able to use half of it.', 2, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (70, 55, 0, 'Kristin K.', 'These lipsticks are moisturizing and have good pigmentation; however, their lasting power is not as advertised! ', 4, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (71, 55, 0, 'lara', 'This is quite simply good stuff. \nThe color payout is rich, the texture creamy and moist, and best of all no scent. No taste.', 5, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (72, 93, 0, 'L. D.', 'I totally love it.it smells heavenly . It smells so natural and my skin just loves it. ', 5, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (73, 93, 0, 'Walton', 'This creme is a bit heavy for my skin; however, as the day goes on it does not create an oily build-up. A little goes a long way, and I could see improvements in my skin tone within a week. Good product, will be purchasing again.', 4, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (74, 74, 0, 'Stefania V', 'it works very well moisturing and cleaning and unlike many other healthy shampoos it doesn''t open the hair platelets too far and therefore doesn''t feel so dry and sticky so I can get away without using a conditioner. Great value.', 4, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (75, 102, 0, 'Mary', 'This is more of a evening fragrance. I love it', 4, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (76, 110, 0, 'Lara', 'Product was very reasonably priced. It will make a nice gift.', 5, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (77, 111, 0, 'Mr. G. Thomas', 'I would totally recommend product for anyone keen to learn a foreign language quickly. \nHowever, you must be fully committed and be ready to dedicate your time for study every day!', 5, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (78, 119, 0, 'F Buckley ', 'Good quality. Also good enough to wear out.\n\nWould order more in the future. ', 5, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (79, 111, 13, 'Eric', ' I''ve tried every other course out there and this gives you a feeling of instant gratification. The focus is on speaking.', 4, 0, 0, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (80, 75, 15, 'Alex', 'This worked awesomely for me. This product is perfect for my dry skin.', 5, 0, 1, '2022-06-27 11:11:27', '2022-06-27 11:11:27'), (81, 78, 14, 'Howard', 'This has to be one of my favorite scents.', 5, 1, 1, '2022-06-28 12:46:45', '2022-06-28 12:46:59'), (82, 51, 16, 'Annabelle', 'Unlike most powder highlights, it''s very long-lasting.', 4, 1, 1, '2022-06-28 12:50:13', '2022-06-28 12:50:26'), (83, 118, 0, 'Rebecca Hellon', 'They are very comfortable and easy to go. ', 4, 0, 1, '2022-06-28 13:08:52', '2022-06-28 13:09:13'), (84, 124, 0, 'Adena Heath', 'I bought these sandals for my summer vacation and I dont love them! They are not comfortable and not stylish.', 1, 1, 1, '2023-12-05 19:04:55', '2023-12-07 12:28:56'), (85, 124, 0, 'Odesa Hamilton', 'The wedge heel gives me some extra height and the diamante detail adds some sparkle to my outfit. They are easy to slip on and off and they fit true to size. I got many compliments on them and they look great with dresses, shorts, or jeans. They are also very durable and well-made. I have worn them several times and they still look new. I would highly recommend these sandals to anyone looking for a cute and versatile pair of shoes.', 5, 0, 1, '2023-12-05 19:05:25', '2023-12-05 19:05:41'), (86, 124, 0, 'Adara Brennan', 'Not published review\nNot published review\nNot published review', 3, 0, 0, '2023-12-05 19:06:21', '2023-12-05 19:06:21');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;