IP : 3.144.41.28Hostname : 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/
soplanning/
./
../
bbpress/
../
wp60/
../
cube/
cube.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]]CubeCart_category` --
CREATE TABLE `[[dbprefix]]CubeCart_category` ( `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `cat_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `cat_desc` text COLLATE utf8mb4_unicode_ci, `cat_parent_id` int(10) unsigned NOT NULL DEFAULT '0', `cat_image` int(10) NOT NULL, `per_ship` decimal(20,2) NOT NULL DEFAULT '0.00', `item_ship` decimal(20,2) NOT NULL DEFAULT '0.00', `item_int_ship` decimal(20,2) NOT NULL DEFAULT '0.00', `per_int_ship` decimal(20,2) NOT NULL DEFAULT '0.00', `hide` smallint(1) NOT NULL DEFAULT '0', `seo_meta_title` text COLLATE utf8mb4_unicode_ci, `seo_meta_description` text COLLATE utf8mb4_unicode_ci, `seo_meta_keywords` text COLLATE utf8mb4_unicode_ci, `priority` smallint(6) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '1', `cat_hier_position` int(11) NOT NULL DEFAULT '0', `cat_parse` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`cat_id`), KEY `cat_parent_id` (`cat_parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;
-- -- Dumping data for table `[[dbprefix]]CubeCart_category` --
INSERT INTO `[[dbprefix]]CubeCart_category` VALUES (1, 'Test Category', 'This is a test category setup during install. It can be edited or deleted from the store admin control panel.', 0, 0, 0.00, 0.00, 0.00, 0.00, 0, '', '', '', 1, 1, 0, 0);
-- -- Table structure for table `[[dbprefix]]CubeCart_documents` --
CREATE TABLE `[[dbprefix]]CubeCart_documents` ( `doc_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `doc_parent_id` int(10) unsigned NOT NULL DEFAULT '0', `doc_status` tinyint(1) unsigned NOT NULL DEFAULT '1', `doc_order` int(10) unsigned NOT NULL DEFAULT '0', `doc_terms` tinyint(1) unsigned NOT NULL DEFAULT '0', `doc_home` tinyint(1) unsigned NOT NULL DEFAULT '0', `doc_privacy` tinyint(1) unsigned NOT NULL DEFAULT '0', `doc_lang` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `doc_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `doc_content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `doc_url` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `doc_url_openin` tinyint(1) unsigned DEFAULT NULL, `seo_meta_title` text COLLATE utf8mb4_unicode_ci, `seo_meta_description` text COLLATE utf8mb4_unicode_ci, `seo_meta_keywords` text COLLATE utf8mb4_unicode_ci, `navigation_link` tinyint(1) unsigned NOT NULL DEFAULT '1', `doc_parse` tinyint(1) NOT NULL DEFAULT '0', `hide_title` enum('0','1') COLLATE utf8mb4_unicode_ci DEFAULT '0', PRIMARY KEY (`doc_id`), KEY `doc_parent_id` (`doc_parent_id`), KEY `doc_status` (`doc_status`), KEY `doc_home` (`doc_home`), KEY `doc_privacy` (`doc_privacy`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ;
-- -- Dumping data for table `[[dbprefix]]CubeCart_documents` --
INSERT INTO `[[dbprefix]]CubeCart_documents` VALUES (1, 0, 1, 1, 0, 1, 0, 'en-GB', 'Welcome to [[store_name]]', '<ul class="bxslider">\n <li><img src="skins/foundation/images/examples/slide1.jpg" title="Promotional Message One" /></li>\n <li><img src="skins/foundation/images/examples/slide2.jpg" /></li>\n <li><img src="skins/foundation/images/examples/slide3.jpg" title="Promotional Message Two" /></li>\n</ul>\n<p>This message and the slider above (including the images) can be edited using the <strong><span style="color: red;">Rich</span> <span style="color: blue;">Text</span> <span style="color: green;">Editor</span></strong> which can be found in the admin control panel of your store under <i>File Manager > Documents</i>.</p>', NULL, NULL, NULL, NULL, NULL, 1, 0, '0'), (2, 0, 1, 2, 0, 0, 0, 'en-GB', 'About Us', 'This can be managed under <span class="navTitle">Documents in the admin control panel.</span>', NULL, NULL, NULL, NULL, NULL, 1, 0, '0'), (3, 0, 1, 3, 1, 0, 0, 'en-GB', 'Terms and Conditions', 'This can be managed under <span class="navTitle">Documents in the admin control panel.</span>', NULL, NULL, NULL, NULL, NULL, 1, 0, '0'), (4, 0, 1, 4, 0, 0, 1, 'en-GB', 'Privacy Policy', 'This can be managed under <span class="navTitle">Documents in the admin control panel.</span>', NULL, NULL, NULL, NULL, NULL, 1, 0, '0'), (5, 0, 1, 5, 0, 0, 0, 'en-GB', 'Returns Policy', 'This can be managed under <span class="navTitle">Documents in the admin control panel.</span>', NULL, NULL, NULL, NULL, NULL, 1, 0, '0');
-- -- Table structure for table `[[dbprefix]]CubeCart_email_content` --
CREATE TABLE `[[dbprefix]]CubeCart_email_content` ( `content_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `content_type` varchar(70) COLLATE utf8mb4_unicode_ci NOT NULL, `language` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `subject` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `content_html` text COLLATE utf8mb4_unicode_ci NOT NULL, `content_text` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`content_id`), KEY `content_type` (`content_type`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=14 ;
-- -- Dumping data for table `[[dbprefix]]CubeCart_email_content` --
INSERT INTO `[[dbprefix]]CubeCart_email_content` VALUES (1, '', 'admin.password_recovery', 'en-GB', 'Admin Password Recovery', '<p>Dear {$DATA.name},</p>\n<p>To regain access to the stores administration control panel. Please follow the link below:</p>\n<p><a href="{$DATA.link}">{$DATA.link}</a></p>\n<p>If the link above doesn''t work, please copy and paste it into your browser address bar.</p>', 'Dear {$DATA.name},\n\nTo regain access to the stores administration control panel. Please follow the link below:\n\n{$DATA.link}\n\nIf the link above doesn''t work, please copy and paste it into your browser address bar.'), (2, '', 'cart.order_complete', 'en-GB', 'Order Complete', '<p>Hi {$DATA.first_name|capitalize},</p>\n<p>We are pleased to say that order number {$DATA.cart_order_id} is complete. If you have ordered physical goods they should arrive shortly.</p>{if !empty($DATA.ship_tracking)}<p>Track your order:<br>{$DATA.ship_tracking}</p>{/if}', 'Hi {$DATA.first_name|capitalize},\n\nWe are pleased to say that order number {$DATA.cart_order_id} is complete. If you have ordered physical goods they should arrive shortly.\n{if !empty($DATA.ship_tracking)}\nTrack your order:\n{$DATA.ship_tracking}\n{/if}'), (3, '', 'cart.order_cancelled', 'en-GB', 'Order Cancelled', '<p>Hi {$DATA.first_name|capitalize},</p>\n<p>Order number {$DATA.cart_order_id} has been cancelled.</p>', 'Hi {$DATA.first_name|capitalize},\n\nOrder number {$DATA.cart_order_id} has been cancelled.'), (4, '', 'cart.order_confirmation', 'en-GB', 'Order Confirmation #{$DATA.cart_order_id}', '<p>Thank you {$DATA.first_name|capitalize}!</p>\n<p>Your order {$DATA.cart_order_id} has been received which was placed on {$DATA.order_date}. Please keep this email for your records. It is possible to view the status of your order online.</p> \n<p><a href="{$DATA.link}">{$DATA.link}</a></p>\n<table width="100%">\n<tr>\n<td valign="top" width="50%"><strong>Billing address:</strong><br>\n{$BILLING.first_name|capitalize} {$BILLING.last_name|capitalize}<br>\n{if !empty($BILLING.company_name)}{$BILLING.company_name}<br>\n{/if}\n{$BILLING.line1|capitalize}<br>\n{if !empty($BILLING.line2)}{$BILLING.line2|capitalize}<br>\n{/if}\n{$BILLING.town|upper}<br>\n{if !empty($BILLING.state)}{$BILLING.state|upper}<br>{/if}\n{$BILLING.postcode}<br>\n{$BILLING.country}{if !empty($BILLING.w3w)}<div class="w3w">///<a href="https://what3words.com/{$BILLING.w3w}">{$BILLING.w3w}</a></div>{/if}<br>\n{$BILLING.phone}<br>\n<br>\n<strong>Email:</strong><br>\n{$BILLING.email}</td>\n<td valign="top" width="50%"><strong>Shipping address:</strong><br>\n{$SHIPPING.first_name|capitalize} {$SHIPPING.last_name|capitalize}<br>\n{if !empty($SHIPPING.company_name)}{$SHIPPING.company_name} <br>\n{/if}{$SHIPPING.line1|capitalize}<br>\n{if !empty($SHIPPING.line2)}{$SHIPPING.line2|capitalize} <br>\n{/if}{$SHIPPING.town|upper}<br>\n{if !empty($SHIPPING.state)}{$SHIPPING.state|upper}<br>{/if}\n{$SHIPPING.postcode}<br>\n{$SHIPPING.country}{if !empty($SHIPPING.w3w)}<div class="w3w">///<a href="https://what3words.com/{$SHIPPING.w3w}">{$SHIPPING.w3w}</a></div>{/if}</td>\n</tr>\n</table>\n<table border="0" cellpadding="3" cellspacing="0" width="100%">\n<tbody>\n<tr>\n<td><strong>Item</strong></td>\n<td><strong>Quantity</strong></td>\n<td><strong>Cost</strong></td>\n</tr>\n{foreach from=$PRODUCTS item=product}\n<tr>\n<td>{$product.name} <br>{$product.product_options}</td>\n<td>{$product.quantity}</td>\n<td>{$product.price}</td>\n</tr>\n{/foreach}\n<tr>\n<td> </td>\n<td> {if !empty($DATA.ship_method)}{$DATA.ship_method}:{if !empty($DATA.ship_product)} ({$DATA.ship_product}){/if}{else}Shipping:{/if}</td>\n<td> {$DATA.shipping}</td>\n</tr>\n<tr>\n<td> </td>\n<td> Discount:</td>\n<td> {$DATA.discount}</td>\n</tr>\n<tr>\n<td> </td>\n<td> Subtotal:</td>\n<td> {$DATA.subtotal}</td>\n</tr>\n{foreach from=$TAXES item=tax}\n<tr>\n<td> </td>\n<td> {$tax.tax_name}: ({$tax.tax_percent}%)</td>\n<td> {$tax.tax_amount}</td>\n</tr>\n{/foreach}\n{if $DATA.show_credit}\n<tr>\n<td> </td>\n<td>Credit:</td>\n<td>({$DATA.credit_used})</td>\n</tr>\n{/if}\n<tr>\n<td> </td>\n<td><strong>Order Total: </strong></td>\n<td><strong>{$DATA.total}</strong></td>\n</tr>\n</tbody>\n</table>\n{if !empty($DATA.note_to_customer)}\n<p>"{$DATA.note_to_customer}"</p>\n{/if}', 'Thank you {$DATA.first_name|capitalize}!\n\nYour order {$DATA.cart_order_id} has been received which was placed on {$DATA.order_date}. Please keep this email for your records. It is possible to view the status of your order online. \n\n{$DATA.link}\n\n----------------------------------------------------------------------\nBilling address:\n{$BILLING.first_name|capitalize} {$BILLING.last_name|capitalize}\n{if !empty($BILLING.company_name)}{$BILLING.company_name}\n{/if}{$BILLING.line1|capitalize}\n{if !empty($BILLING.line2)}{$BILLING.line2|capitalize}\n{/if}{$BILLING.town|upper}\n{if !empty($BILLING.state)}{$BILLING.state|upper}\n{/if}{$BILLING.postcode}\n{$BILLING.country}{if !empty($BILLING.w3w)}\n///{$BILLING.w3w}{/if}\n{$BILLING.phone}\n\nEmail:\n{$BILLING.email}\n\nShipping address:\n{$SHIPPING.first_name|capitalize} {$SHIPPING.last_name|capitalize}\n{if !empty($SHIPPING.company_name)}{$SHIPPING.company_name}\n{/if}{$SHIPPING.line1|capitalize}\n{if !empty($SHIPPING.line2)}{$SHIPPING.line2|capitalize}\n{/if}{$SHIPPING.town|upper}\n{if !empty($SHIPPING.state)}{$SHIPPING.state|upper}\n{/if}{$SHIPPING.postcode}\n{$SHIPPING.country}{if !empty($SHIPPING.w3w)}\n///{$SHIPPING.w3w}{/if}\n\n----------------------------------------------------------------------\nItems in Your Order\n\n{foreach from=$PRODUCTS item=product}\n-----------------------------------\n{$product.name}\n{$product.product_options}\n\nPart Number: {$product.product_code}\nUnit Price: {$product.price}\nQty: {$product.quantity}\n\n{/foreach}\n-----------------------------------\nSubtotal: {$DATA.subtotal}\nDiscount: {$DATA.discount}\n{if !empty($DATA.ship_method)}{$DATA.ship_method}:{if !empty($DATA.ship_product)} ({$DATA.ship_product}){/if}{else}Shipping:{/if} {$DATA.shipping}\n{foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n{/foreach}{if $DATA.show_credit}\nCredit: ({$DATA.credit_used})\n{/if}--------------------------\nOrder Total: {$DATA.total}\n==========================\n{if !empty($DATA.note_to_customer)}\n"{$DATA.note_to_customer}"{/if}'), (5, '', 'cart.payment_fraud', 'en-GB', 'Order Problem', '<p>Hi {$DATA.first_name|capitalize},</p>\n<p>We are very sorry but we have not been able to accept the payment for order {$DATA.cart_order_id}. Please feel free to contact a member of staff if you have any questions.</p>', 'Hi {$DATA.first_name|capitalize},\n\nWe are very sorry but we have not been able to accept the payment for order {$DATA.cart_order_id}. Please feel free to contact a member of staff if you have any questions.'), (6, '', 'account.password_recovery', 'en-GB', 'Password Recovery', '<p>Dear {$DATA.first_name|capitalize} {$DATA.last_name|capitalize},<br>\n<br>\nTo reset your password, please click on the link below or copy and paste the address onto your web browser''s address window. Once you''re on the web page, you will be instructed to enter and confirm your new password.<br> \n<br>\n<a href="{$DATA.reset_link}">{$DATA.reset_link}</a><br>\n<br>\nIf you require further assistance in resetting your password, please contact us.</p>', 'Hi {$DATA.first_name|capitalize},\n\nTo reset your password, please click on the link below or copy and paste the address onto your web browser''s address window. Once you''re on the web page, you will be instructed to enter and confirm your new password.\n\n{$DATA.reset_link}\n\nIf you require further assistance in resetting your password, please contact us.'), (7, '', 'admin.order_received', 'en-GB', 'New Order #{$DATA.cart_order_id}', '<p>{$DATA.first_name|capitalize} {$DATA.last_name|capitalize} {if !empty($BILLING.company_name)}({$BILLING.company_name}){/if} just placed order number {$DATA.cart_order_id} on {$DATA.order_date}.</p>\n<p>This order can be managed online by following the link below.</p>\n<p><a href="{$DATA.link}">{$DATA.link}</a></p>\n<table width="100%">\n<tr>\n<td valign="top" width="50%"><strong>Billing address:</strong><br>\n{$BILLING.first_name|capitalize} {$BILLING.last_name|capitalize}<br>\n{if !empty($BILLING.company_name)}{$BILLING.company_name}<br>\n{/if}\n{$BILLING.line1|capitalize}<br>\n{if !empty($BILLING.line2)}{$BILLING.line2|capitalize}<br>\n{/if}\n{$BILLING.town|upper}<br>\n{if !empty($BILLING.state)}{$BILLING.state|upper}<br>{/if}\n{$BILLING.postcode}<br>\n{$BILLING.country}{if !empty($BILLING.w3w)}<div class="w3w">///<a href="https://what3words.com/{$BILLING.w3w}">{$BILLING.w3w}</a></div>{/if}<br>\n{$BILLING.phone}<br>\n<br>\n<strong>Email:</strong><br>\n{$BILLING.email}</td>\n<td valign="top" width="50%"><strong>Shipping address:</strong><br>\n{$SHIPPING.first_name|capitalize} {$SHIPPING.last_name|capitalize}<br>\n{if !empty($SHIPPING.company_name)}{$SHIPPING.company_name} <br>\n{/if}{$SHIPPING.line1|capitalize}<br>\n{if !empty($SHIPPING.line2)}{$SHIPPING.line2|capitalize} <br>\n{/if}{$SHIPPING.town|upper}<br>\n{if !empty($SHIPPING.state)}{$SHIPPING.state|upper}<br>{/if}\n{$SHIPPING.postcode}<br>\n{$SHIPPING.country}{if !empty($SHIPPING.w3w)}<div class="w3w">///<a href="https://what3words.com/{$SHIPPING.w3w}">{$SHIPPING.w3w}</a></div>{/if}</td>\n</tr>\n</table>\n<table border="0" cellpadding="3" cellspacing="0" width="100%">\n<tbody>\n<tr>\n<td><strong>Item</strong></td>\n<td><strong>Quantity</strong></td>\n<td><strong>Cost</strong></td>\n</tr>\n{foreach from=$PRODUCTS item=product}\n<tr>\n<td>{$product.name} <br>{$product.product_options}</td>\n<td>{$product.quantity}</td>\n<td>{$product.price}</td>\n</tr>\n{/foreach}\n<tr>\n<td> </td>\n<td> {if !empty($DATA.ship_method)}{$DATA.ship_method}:{if !empty($DATA.ship_product)} ({$DATA.ship_product}){/if}{else}Shipping:{/if}</td>\n<td> {$DATA.shipping}</td>\n</tr>\n<tr>\n<td> </td>\n<td> Discount:</td>\n<td> {$DATA.discount}</td>\n</tr>\n<tr>\n<td> </td>\n<td> Subtotal:</td>\n<td> {$DATA.subtotal}</td>\n</tr>\n{foreach from=$TAXES item=tax}\n<tr>\n<td> </td>\n<td> {$tax.tax_name}: ({$tax.tax_percent}%)</td>\n<td> {$tax.tax_amount}</td>\n</tr>\n{/foreach}\n{if $DATA.show_credit}\n<tr>\n<td> </td>\n<td>Credit:</td>\n<td>({$DATA.credit_used})</td>\n</tr>\n{/if}\n<tr>\n<td> </td>\n<td><strong>Order Total: </strong></td>\n<td><strong>{$DATA.total}</strong></td>\n</tr>\n</tbody>\n</table>', '{$DATA.first_name|capitalize} {$DATA.last_name|capitalize} {if !empty($BILLING.company_name)}({$BILLING.company_name}){/if} just placed order number {$DATA.cart_order_id} on {$DATA.order_date}.\n\nThis order can be managed online by following the link below.\n\n{$DATA.link}\n\n----------------------------------------------------------------------\nBilling address:\n{$BILLING.first_name|capitalize} {$BILLING.last_name|capitalize}\n{if !empty($BILLING.company_name)}{$BILLING.company_name}\n{/if}{$BILLING.line1|capitalize}\n{if !empty($BILLING.line2)}{$BILLING.line2|capitalize}\n{/if}{$BILLING.town|upper}\n{if !empty($BILLING.state)}{$BILLING.state|upper}\n{/if}{$BILLING.postcode}\n{$BILLING.country}{if !empty($BILLING.w3w)}\n///{$BILLING.w3w}{/if}\n{$BILLING.phone}\n\nEmail:\n{$BILLING.email}\n\nShipping address:\n{$SHIPPING.first_name|capitalize} {$SHIPPING.last_name|capitalize}\n{if !empty($SHIPPING.company_name)}{$SHIPPING.company_name}\n{/if}{$SHIPPING.line1|capitalize}\n{if !empty($SHIPPING.line2)}{$SHIPPING.line2|capitalize}\n{/if}{$SHIPPING.town|upper}\n{if !empty($SHIPPING.state)}{$SHIPPING.state|upper}\n{/if}{$SHIPPING.postcode}\n{$SHIPPING.country}{if !empty($SHIPPING.w3w)}\n///{$SHIPPING.w3w}{/if}\n\n----------------------------------------------------------------------\nItems in Your Order\n\n{foreach from=$PRODUCTS item=product}\n-----------------------------------\n{$product.name}\n{$product.product_options}\n\nPart Number: {$product.product_code}\nUnit Price: {$product.price}\nQty: {$product.quantity}\n\n{/foreach}\n-----------------------------------\nSubtotal: {$DATA.subtotal}\nDiscount: {$DATA.discount}\n{if !empty($DATA.ship_method)}{$DATA.ship_method}:{if !empty($DATA.ship_product)} ({$DATA.ship_product}){/if}{else}Shipping:{/if} {$DATA.shipping}\n{foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n{/foreach}{if $DATA.show_credit}\nCredit: ({$DATA.credit_used})\n{/if}--------------------------\nOrder Total: {$DATA.total}\n=========================='), (8, '', 'admin.review_added', 'en-GB', 'New Product Review', '{$DATA.name} has submit a new review/comment about ''{$DATA.product_name}''. This can be moderated following the link below.\n <p><strong>Moderation Link:</strong><br><a href=''{$DATA.link}''>{$DATA.link}</a></p>\n <p><strong>Review Text:</strong><br>{$DATA.review}</p>', '{$DATA.name} has submit a new review/comment about ''{$DATA.product_name}''. This can be moderated following the link below.\n\nModeration Link:\n{$DATA.link}\nReview Text:\n{$DATA.review}'), (9, '', 'cart.digital_download', 'en-GB', 'Your Purchased Downloads', '<p>Hi {$DATA.first_name|capitalize},</p>\n<p>Your digital files are now ready for download. Please use the links provided below to access them below:</p>\n{foreach from=$DOWNLOADS item=download}\n<p><strong>{$download.name}:</strong> (Link expires on {$download.expire}<strong>)</strong><br>\n<a href="{$download.url}">{$download.url}</a></p>\n{/foreach}\n<p>If the links above don''t work, please try copy and pasting them it into your browser address bar. You can also find access to these files from your the customer area of our website.</p> \n<p> </p>', 'Hi {$DATA.first_name|capitalize},\n\nYour digital files are now ready for download. Please use the links provided below to access them below:\n\n{foreach from=$DOWNLOADS item=download}\n{$download.name}: (Link expires on {$download.expire})\n{$download.url}\n{/foreach}\n\nIf the links above don''t work, please try copy and pasting them it into your browser address bar. You can also find access to these files from your the customer area of our website.'), (10, '', 'cart.gift_certificate', 'en-GB', 'Your Gift Card', '<p>Dear {$DATA.name},</p>\n<p>We are pleased to be sending you this gift card which you can use towards the purchase of any items on our website.</p>\n<p><strong>From: </strong>{$DATA.first_name|capitalize} {$DATA.last_name|capitalize}<br>\n<strong>Amount: </strong>{$DATA.value}<br>\n<strong>Claim Code:</strong> {$DATA.code}<br>\n<strong>Gift Message:</strong> {$DATA.message}</p>\n<p>-------------------</p>\n<p>To redeem this gift card please enter the "Claim Code" above into the text field labeled "Promotional code or gift card" during checkout.</p>\n<p>Why not spend it now?</p>', 'Dear {$DATA.name},\n\nWe are pleased to be sending you this gift card which you can use towards the purchase of any item(s) on our website.\n\nHappy shopping!\n\nFrom: {$DATA.first_name|capitalize} {$DATA.last_name|capitalize}\nAmount: {$DATA.value}\nClaim Code: {$DATA.code}\nGift Message: {$DATA.message}\n\n-------------------\n\nTo redeem this gift card please enter the "Claim Code" above into the text field labeled "Promotional code or gift card" during checkout.\n\nWhy not spend it now?'), (11, '', 'catalogue.tell_friend', 'en-GB', '{$DATA.from} has recommended something', 'Dear {$DATA.to},\n<p>Your friend <strong>{$DATA.from}</strong> thought that you might be interested in <strong>{$DATA.name}</strong>.</p>\n<p><strong>Product Link:</strong> <a href="{$DATA.link}">{$DATA.name}</a></p>\n<p>{$DATA.message}</p>', 'Dear {$DATA.to},\n\nYour friend {$DATA.from} thought that you might be interested in ''{$DATA.name}''.\n\n{$DATA.name}\nProduct Link: {$DATA.link}\n\n{$DATA.message}'), (12, '', 'cart.payment_received', 'en-GB', 'Thank you for your payment!', '<p>Hi {$DATA.first_name|capitalize},</p>\n<p>Thank you. We have received a payment of {$DATA.total} for order number {$DATA.cart_order_id}.</p>', 'Hi {$DATA.first_name|capitalize},\n\nThank you. We have received a payment of {$DATA.total} for order number {$DATA.cart_order_id}.'), (13, '', 'newsletter.verify_email', 'en-GB', 'Confirm your subscription', '<p>{$DATA.email} has been subscribed to our newsletter. To confirm your subscription please follow the link below:</p><p><a href="{$DATA.link}">{$DATA.link}</a></p>', '{$DATA.email} has been subscribed to our newsletter.\n\nTo confirm your subscription please follow the link below:\n\n{$DATA.link}');
-- -- Table structure for table `[[dbprefix]]CubeCart_hooks` --
CREATE TABLE `[[dbprefix]]CubeCart_hooks` ( `hook_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `plugin` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `hook_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'A descriptive name for the hook', `enabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'All hooks should be disabled by DEFAULT', `trigger` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The trigger used to call the hook', `filepath` text COLLATE utf8mb4_unicode_ci NOT NULL, `priority` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`hook_id`), KEY `trigger` (`trigger`), KEY `enabled` (`enabled`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
/*!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 */;