/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_Settings` (
  `name` varchar(255) NOT NULL DEFAULT '',
  `idCategory` int(11) NOT NULL DEFAULT '0',
  `fieldType` varchar(255) NOT NULL DEFAULT '',
  `label` varchar(255) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  `options` text NOT NULL,
  `description` text NOT NULL,
  `required` enum('y','n') NOT NULL DEFAULT 'y',
  `system` enum('y','n') NOT NULL DEFAULT 'n',
  `sorter` int(11) NOT NULL DEFAULT '0',
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES ('adminEmail',1,'emails','General Notification Email Address(es) &nbsp; <span class=\"label_description\">Enter email address(es) that should receive a notification email regarding all the form submissions on your website</span>','test@vityk.fr-wd.com, test@sha.fr-wd.com, qsf@kloo.fr-wd.com, jaam@adaptainc.com','','Use commas to separate email addresses','y','n',10,'2009-04-16 18:00:47','2012-12-06 18:08:15'),('siteFrom',1,'text','From Email','Adapta Interactive Framework <qsf@adaptainc.com>','','','y','n',20,'2009-04-16 18:00:47','2012-12-06 18:08:15'),('userRegistrationEmailFrom',4,'text','From Email Address','','','','n','n',159,'2010-10-01 17:41:39','2012-10-19 12:56:59'),('userRegistrationAdminEmailBody',4,'HtmlEditor','Message Body','<p>\r\n	New User has been registered&nbsp;at&nbsp; Adapta Interactive Framework website.</p>\r\n<p>\r\n	Name: <strong>{firstName}</strong><strong> {lastName}</strong><br />\r\n	Email: <strong>{email}</strong><br />\r\n	Phone Number:<strong> {phone}</strong><br />\r\n	<br />\r\n	<a href=\"{link}\" target=\"_blank\">Click here to view details</a>.</p>\r\n','Basic','Constants: {firstName} {lastName} {email} {phone} {link}','y','n',600,'2010-10-01 17:23:18','2012-10-19 12:56:59'),('deliveryHandlingFedEx',6,'numeric','FedEx ($)','5.00','','','n','n',170,'0000-00-00 00:00:00','2012-11-29 09:24:16'),('deliveryHandlingHeader',6,'header','Delivery Handlings','','','','n','n',150,'0000-00-00 00:00:00','0000-00-00 00:00:00'),('deliveryHandlingManual',6,'numeric','Manual ($)','7.98','','','n','n',190,'0000-00-00 00:00:00','2012-11-29 09:24:16'),('userRegistrationAdminEmailFrom',4,'text','From Email Address','','','','n','n',501,'2010-10-01 17:23:18','2012-10-19 12:56:59'),('footer',1,'htmlEditor','Footer','<table style=\"width:100%\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n				<p>\r\n					Copyright &copy; {currentYear} Adapta Interactive Framework | <a href=\"site-credits.html\" onclick=\"window.open(this.href, \'QuickSiteFramework_frwd_sc\', \'width=500,height=212\').focus(); return false;\" target=\"_blank\">Site Credits</a> | <a href=\"site-map.html\">Site Map</a> | <a href=\"{BASE_URL_HTTP}/contact\">Contact Us</a></p>\r\n			</td>\r\n			<td>\r\n				<p style=\"text-align:right; font-size:12px\">\r\n					To schedule an appointment, call <strong>952.767.6700</strong></p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n','','Constants: {currentYear}','y','n',30,'2009-09-11 12:35:43','2012-12-06 18:08:15'),('contactFormEmailHeader',2,'header','','Contact Form Submission Notification','','','n','n',10,'2010-07-13 11:22:59','2010-07-13 11:22:59'),('contactFormEmailSubject',2,'text','Subject','New comments have been submitted','','','y','n',20,'2010-07-13 11:28:19','2012-12-07 16:26:23'),('contactFormEmailFrom',2,'text','From Email Address','Adapta Interactive Framework <qsf@adaptainc.com>','','','y','n',30,'2010-07-13 11:29:43','2012-12-07 16:26:23'),('contactFormEmailTo',2,'emails','To Email Address(es) &nbsp; <span class=\"label_description\">Enter email address(es) that should receive a notification email regarding Contact form submissions on your website</span>','','','Use commas to separate email addresses','n','n',40,'2010-07-13 11:30:45','2012-12-07 16:26:23'),('contactFormEmailBody',2,'HtmlEditor','Message Body','New comments have been submitted.<br />\r\n<br />\r\nName: <b>{name}</b><br />\r\nEmail or phone number: <b>{emailOrPhone}</b><br />\r\nReason for Contact: <strong>{reason}</strong><br />\r\nComments:\r\n<blockquote>\r\n	<b>{comments}</b></blockquote>\r\n<br />\r\n<br />\r\nClick <a href=\"{link}\">here</a> to view details.<br />\r\n<br />\r\n','','Constants: {name} {emailOrPhone} {reason} {comments} {link}','y','n',50,'2010-07-13 11:34:51','2012-12-07 16:26:23'),('stsAuthLink',1,'htmlEditor','STS Link Text','<p>\r\n	Need a change made? Use our online support system. <a class=\"ai_btn\" href=\"{url}\" target=\"_blank\">Log In Now</a></p>\r\n<ul id=\"soc-list\">\r\n	<li>\r\n		<a class=\"ai_btn\" href=\"http://www.twitter.com/adaptainc\" target=\"_blank\">t</a></li>\r\n	<li>\r\n		<a class=\"ai_btn\" href=\"http://www.facebook.com/pages/Adapta-Interactive/332475043438985\" target=\"_blank\">f</a></li>\r\n	<li>\r\n		<a class=\"ai_btn\" href=\"http://www.linkedin.com/company/adapta-interactive\" target=\"_blank\">in</a></li>\r\n</ul>\r\n','','Constants: {url}','y','y',40,'2010-08-25 00:00:00','2012-12-03 16:38:05'),('forgotPasswordEmailHeader',4,'header','','User \"Forgot Password\" Email Template','','','n','n',90,'2010-09-13 15:54:08','2010-09-13 15:54:08'),('forgotPasswordEmailSubject',4,'text','Subject','Recovery account password at Adapta Interactive Framework','','','y','n',100,'2010-09-13 15:54:08','2012-10-19 12:56:59'),('userRegistrationEmailHeader',4,'header','','User Registration Email Template (sends to user)','','','y','n',140,'2010-10-01 16:40:17','2010-10-01 16:40:17'),('forgotPasswordEmailFrom',4,'text','From Email Address','','','','n','n',120,'2010-09-13 15:54:08','2012-10-19 12:56:59'),('forgotPasswordEmailBody',4,'HtmlEditor','Message Body','<div style=\"font-family: Arial,Helvetica,sans-serif;\">\r\n	<p>\r\n		You or someone on your behalf has requested your password reset for the Adapta Interactive Framework website.</p>\r\n	<p>\r\n		Email Address: <strong>{email}</strong><br />\r\n		Expiration date for request: <strong>{recoverCodeExpirationDate}</strong></p>\r\n	<p>\r\n		To change your password please click on the link below:<br />\r\n		<a href=\"{link}\" target=\"_blank\">{link}</a></p>\r\n</div>\r\n','','Constants: {firstName} {lastName} {email} {recoverCodeExpirationDate} {link}','y','n',130,'2010-09-13 15:54:08','2012-10-19 12:56:59'),('userRegistrationEmailSubject',4,'text','Subject','You have created an account at Adapta Interactive Framework','','','y','n',150,'2010-10-01 16:40:17','2012-10-19 12:56:59'),('userRegistrationEmailBody',4,'HtmlEditor','Message Body','<div style=\"font-family: Arial,Helvetica,sans-serif;\">\r\n<p>Congratulations! You have been successfully registered at Adapta Interactive Framework web site!</p>\r\n<p>Your Email: <strong>{email}</strong><br />\r\nYour Password: <strong>{password}</strong></p>\r\n<p><a href=\"{link}\" target=\"_blank\">Click here to login at Quick Site Framework web site</a>.</p>\r\n</div>','','Constants: {firstName} {lastName} {email} {password} {phone} {link}','y','n',160,'2010-10-01 16:40:17','2012-10-19 12:56:59'),('userRegistrationAdminEmailHeader',4,'Header','','User Registration Email Template (sends to admin)','','','n','n',400,'2010-10-01 17:23:18','2010-10-01 17:23:18'),('userRegistrationAdminEmailSubject',4,'text','Subject','New User has been registered','','','y','n',500,'2010-10-01 17:23:18','2012-10-19 12:56:59'),('analyticsCode',1,'text','Google Analytics Tracking Code','','','Example: UA-xxxxxx-x','n','n',100,'2011-05-09 00:00:00','2012-12-06 18:08:15'),('lockObjectTimeout',1,'text','Lock Object Period (seconds)','180','','a default period of the edited object being blocked for others.','y','y',70,'2012-04-27 16:20:51','2012-12-03 16:38:05'),('lockRefreshTimeout',1,'text','Lock Refresh Cycle (seconds)','90','','a cycle of the “lock object period” value for the edited object being refreshed.','y','y',80,'2012-04-27 16:22:26','2012-12-03 16:38:05'),('SanityCheck_File:lastRefreshTime',1,'text','','','','','n','y',0,'2012-05-03 12:00:00','2012-12-03 16:38:05'),('viewControllerLogLiveTime',5,'App_ViewControllerLog_Admin_Form_Element_LiveTime','Automatically delete tracking information older than','1','','Action Log history has been stored on the website since <b>{minDate}</b> and is taking up <b>{size}</b> of space.\r\n','y','n',0,'2012-05-18 00:00:00','2012-11-27 17:16:34'),('newsletterFormEmailHeader',2,'header','','Newsletter Signup Submission Admin Notification','','','n','n',60,'2012-06-04 14:52:11','2012-06-04 14:52:11'),('newsletterFormEmailSubject',2,'text','Subject','New subscription has been submitted','','','y','n',70,'2012-06-04 14:52:11','2012-12-07 16:26:23'),('newsletterFormEmailFrom',2,'text','From Email Address','Adapta Interactive Framework <qsf@adaptainc.com>','','','y','n',80,'2012-06-04 14:52:11','2012-12-07 16:26:23'),('newsletterFormEmailTo',2,'emails','To Email Address(es) &nbsp; <span class=\"label_description\">Enter email address(es) that should receive a notification email regarding Newsletter signup submissions on your website</span>','','','Use commas to separate email addresses','n','n',90,'2012-06-04 14:52:11','2012-12-07 16:26:23'),('newsletterFormEmailBody',2,'HtmlEditor','Message Body','<p>\r\n	New subscription has been submitted.<br />\r\n	<br />\r\n	Name: <b>{name}</b><br />\r\n	Email Address: <b>{email}</b><br />\r\n	<br />\r\n	Click <a href=\"{link}\">here</a> to view details.<br />\r\n	&nbsp;</p>\r\n','','Constants: {name} {email} {link}','y','n',100,'2012-06-04 14:52:11','2012-12-07 16:26:23'),('newsletterFormUserEmailHeader',2,'header','','Newsletter Signup Submission User Notification','','','n','n',110,'2012-06-19 12:32:30','2012-06-19 12:32:30'),('newsletterFormUserEmailSubject',2,'text','Subject','You have successfully subscribed to our newsletter','','','y','n',120,'2012-06-19 12:32:30','2012-12-07 16:26:23'),('newsletterFormUserEmailFrom',2,'text','From Email Address','Adapta Interactive Framework <qsf@adaptainc.com>','','','y','n',130,'2012-06-19 12:32:30','2012-12-07 16:26:23'),('newsletterFormUserEmailBody',2,'HtmlEditor','Message Body','<p>\r\n	You have successfully subscribed to our newsletter.<br />\r\n	<br />\r\n	Name: <b>{name}</b><br />\r\n	Email Address: <b>{email}</b><br />\r\n	&nbsp;</p>\r\n','','Constants: {name} {email} {link}','y','n',140,'2012-06-19 12:32:30','2012-12-07 16:26:23'),('giftCardEmailHeader',2,'header','','Gift Cards Notification (to User)','','','n','n',150,'2010-07-13 11:22:59','2010-07-13 11:22:59'),('giftCardEmailSubject',2,'text','Subject','New gift card has been issued','','','y','n',160,'2010-07-13 11:28:19','2012-12-07 16:26:23'),('giftCardEmailFrom',2,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',170,'2010-07-13 11:29:43','2012-12-07 16:26:23'),('giftCardEmailBody',2,'HtmlEditor','Message Body','<p>\r\n	<strong>New gift card has been issued</strong></p>\r\n<p>\r\n	<br />\r\n	Card Code - <strong>{cardCode}</strong></p>\r\n<p>\r\n	Card Value - <strong>${cardValue}</strong></p>\r\n<p>\r\n	Expiration Date - <strong>{expirationDate}</strong></p>\r\n<p>\r\n	Created -&nbsp; <strong>{created}</strong></p>\r\n<p>\r\n	First Name - <strong>{firstName}</strong></p>\r\n<p>\r\n	Last Name - <strong>{lastName}</strong></p>\r\n<p>\r\n	Email - <strong>{email}</strong></p>\r\n','','Constants: {cardCode} {cardValue} {expirationDate} {created} {firstName} {lastName} {email}','y','n',180,'2010-07-13 11:34:51','2012-12-07 16:26:23'),('deliveryHandlingUps',6,'numeric','UPS ($)','50.00','','','n','n',160,'0000-00-00 00:00:00','2012-11-29 09:24:16'),('deliveryHandlingUsps',6,'numeric','USPS ($)','4.50','','','n','n',180,'0000-00-00 00:00:00','2012-11-29 09:24:16'),('orderPriceHeader',6,'header','Prices','','','','y','n',130,'0000-00-00 00:00:00','0000-00-00 00:00:00'),('orderPriceTax',6,'text','Product tax (%)','3','','','n','n',140,'0000-00-00 00:00:00','2012-11-29 09:24:16'),('senderAddressHeader',6,'header','Sender\'s Address Options','','','','n','n',100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),('senderStateCode',6,'text','State Code','MN','','','y','n',110,'0000-00-00 00:00:00','2012-11-29 09:24:16'),('senderZipCode',6,'text','Zip Code','55441','','','y','n',120,'0000-00-00 00:00:00','2012-11-29 09:24:16'),('eCommerceOrderOrderStatusNewUserEmailHeader',7,'header','','Order Status Changed to NEW (User Notification)','','','n','n',10,'2012-09-20 16:46:51','2012-09-20 16:46:51'),('eCommerceOrderOrderStatusNewUserEmailSubject',7,'text','Subject','Order status has been changed','','','y','n',20,'2012-09-20 17:04:07','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusNewUserEmailFrom',7,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',30,'2012-09-20 17:13:14','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusNewUserEmailBody',7,'HtmlEditor','Message Body','<p>\r\n	<strong>Order #{orderId} status has been changed to &quot;NEW&quot;</strong></p>\r\n<p>\r\n	Click <a href=\"{link}\">here</a> to view details.</p>\r\n','','Constants: {orderId} {link}','y','n',40,'2012-09-20 17:28:27','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusPackedUserEmailHeader',7,'header','','Order Status Changed to PACKED (User Notification)','','','n','n',100,'2012-09-20 16:48:19','2012-09-20 16:48:19'),('eCommerceOrderOrderStatusPackedUserEmailSubject',7,'text','Subject','Order status has been changed','','','y','n',110,'2012-09-20 17:09:11','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusPackedUserEmailFrom',7,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',120,'2012-09-20 17:13:42','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusPackedUserEmailBody',7,'HtmlEditor','Message Body','<p>\r\n	<strong>Order&nbsp; #{orderId} status has been changed to &quot;PACKED&quot;</strong></p>\r\n<p>\r\n	Click <a href=\"{link}\">here</a> to view details.</p>\r\n','','Constants: {orderId} {link}','y','n',130,'2012-09-20 17:29:50','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusSentUserEmailHeader',7,'header','','Order Status Changed to SENT (User Notification)','','','n','n',200,'2012-09-20 16:48:57','2012-09-20 16:48:57'),('eCommerceOrderOrderStatusSentUserEmailSubject',7,'text','Subject','Order status has been changed','','','y','n',210,'2012-09-20 17:09:34','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusSentUserEmailFrom',7,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',220,'2012-09-20 17:13:58','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusSentUserEmailBody',7,'HtmlEditor','Message Body','<p>\r\n	<strong>Order #{orderId} status has been changed to &quot;SENT&quot;</strong></p>\r\n<p>\r\n	Click <a href=\"{link}\">here</a> to view details.</p>\r\n','','Constants: {orderId} {link}','y','n',230,'2012-09-20 17:30:22','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusClosedUserEmailHeader',7,'header','','Order Status Changed to CLOSED (User Notification)','','','n','n',300,'2012-09-20 16:49:31','2012-09-20 16:49:31'),('eCommerceOrderOrderStatusClosedUserEmailSubject',7,'text','Subject','Order status has been changed','','','y','n',310,'2012-09-20 17:09:49','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusClosedUserEmailFrom',7,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',320,'2012-09-20 17:14:13','2012-12-13 11:32:49'),('eCommerceOrderOrderStatusClosedUserEmailBody',7,'HtmlEditor','Message Body','<p>\r\n	<strong>Order #{orderId} status has been changed to &quot;CLOSED&quot;</strong></p>\r\n<p>\r\n	Click <a href=\"{link}\">here</a> to view details.</p>\r\n','','Constants: {orderId} {link}','y','n',330,'2012-09-20 17:32:00','2012-12-13 11:32:49'),('eCommerceOrderPaidStatusYesUserEmailHeader',7,'header','','Paid Status changed to YES (User Notification)','','','n','n',400,'2012-09-20 16:59:15','2012-09-20 16:59:15'),('eCommerceOrderPaidStatusYesUserEmailSubject',7,'text','Subject','Order status has been changed','','','y','n',410,'2012-09-20 17:10:35','2012-12-13 11:32:49'),('eCommerceOrderPaidStatusYesUserEmailFrom',7,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',420,'2012-09-20 17:14:29','2012-12-13 11:32:49'),('eCommerceOrderPaidStatusYesUserEmailBody',7,'HtmlEditor','Message Body','<p>\r\n	<strong>Order #{orderId} paid status has been changed to &quot;YES&quot;</strong></p>\r\n<p>\r\n	Click <a href=\"{link}\">here</a> to view details.</p>\r\n','','Constants: {orderId} {link}','y','n',430,'2012-09-20 17:33:01','2012-12-13 11:32:49'),('eCommerceOrderPaidStatusNoUserEmailHeader',7,'header','','Paid Status changed to NO (User Notification)','','','n','n',500,'2012-09-20 16:59:37','2012-09-20 16:59:37'),('eCommerceOrderPaidStatusNoUserEmailSubject',7,'text','Subject','Order status has been changed','','','y','n',510,'2012-09-20 17:10:48','2012-12-13 11:32:49'),('eCommerceOrderPaidStatusNoUserEmailFrom',7,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',520,'2012-09-20 17:14:46','2012-12-13 11:32:49'),('eCommerceOrderPaidStatusNoUserEmailBody',7,'HtmlEditor','Message Body','<p>\r\n	<strong>Order #{orderId} paid status has been changed to &quot;NO&quot;</strong></p>\r\n<p>\r\n	Click <a href=\"{link}\">here</a> to view details.</p>\r\n','','Constants: {orderId} {link}','y','n',530,'2012-09-20 17:33:40','2012-12-13 11:32:49'),('eCommerceOrderSubmitUserEmailHeader',7,'header','','Order submitted (User Notification)','','','n','n',540,'2012-09-20 16:59:37','2012-09-20 16:59:37'),('eCommerceOrderSubmitUserEmailSubject',7,'text','Subject','New Order has been submitted','','','y','n',550,'2012-09-20 17:10:48','2012-12-13 11:32:49'),('eCommerceOrderSubmitUserEmailFrom',7,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',560,'2012-09-20 17:14:46','2012-12-13 11:32:49'),('eCommerceOrderSubmitUserEmailBody',7,'HtmlEditor','Message Body','<h1>\r\n	New Order #: {orderId} has been submitted</h1>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n	<tbody>\r\n		<tr valign=\"top\">\r\n			<td>\r\n				<h3>\r\n					General Info</h3>\r\n				<strong>Order #:</strong> {orderId}<br />\r\n				<strong>Status:</strong> {status}<br />\r\n				<strong>Gift Card:</strong> {giftCard}<br />\r\n				<strong>Promo Code:</strong> {promo}</td>\r\n			<td width=\"10\">\r\n				&nbsp;</td>\r\n			<td>\r\n				<h3>\r\n					Billing Address</h3>\r\n				{billingFirstName} {billingLastName}<br />\r\n				{billingAddress}<br />\r\n				{billingCity} {billingState} {billingZip}</td>\r\n			<td width=\"10\">\r\n				&nbsp;</td>\r\n			<td>\r\n				<h3>\r\n					Shipping Address</h3>\r\n				{shippingNameTitle} {shippingServiceCodeTitle}<br />\r\n				{shippingFirstName} {shippingLastName}<br />\r\n				{shippingAddress}<br />\r\n				{shippingCity}</td>\r\n			<td width=\"10\">\r\n				&nbsp;</td>\r\n			<td>\r\n				<h3>\r\n					Payment Method</h3>\r\n				<strong>Payment Type:</strong> {paymentTypeTitle}<br />\r\n				<strong>Paid:</strong> {paid}</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	<br />\r\n	{cartItems}</p>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n	<tbody>\r\n		<tr valign=\"top\">\r\n			<td width=\"48%\">\r\n				<h4>\r\n					Customer Notes</h4>\r\n				{userAdditionalNote}</td>\r\n			<td width=\"4%\">\r\n				&nbsp;</td>\r\n			<td width=\"48%\">\r\n				<h4>\r\n					Staff Only Notes</h4>\r\n				{adminAdditionalNote}</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<hr />\r\n<p style=\"font-family: Arial; font-size:12px;\">\r\n	<br />\r\n	Click <a href=\"{link}\" target=\"_blank\">here</a> for details</p>\r\n','','Constants: {orderId} {billingFirstName} {billingLastName} {billingAddress} {billingCity} {billingState} {billingZip} {shippingFirstName} {shippingLastName} {shippingAddress} {shippingCity} {shippingNameTitle} {shippingServiceCodeTitle} {paymentTypeTitle} {paid} {status} {promo} {giftCard} {subtotal} {tax} {total} {cartItems} {adminAdditionalNote} {userAdditionalNote} {link}','y','n',570,'2012-09-20 17:33:40','2012-12-13 11:32:49'),('eCommerceOrderSubmitAdminEmailHeader',7,'header','','Order submitted (Admin Notification)','','','n','n',580,'2012-09-20 16:59:37','2012-09-20 16:59:37'),('eCommerceOrderSubmitAdminEmailSubject',7,'text','Subject','New Order has been submitted','','','y','n',590,'2012-09-20 17:10:48','2012-12-13 11:32:49'),('eCommerceOrderSubmitAdminEmailFrom',7,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',600,'2012-09-20 17:14:46','2012-12-13 11:32:49'),('eCommerceOrderSubmitAdminEmailTo',7,'emails','To Email Address(es) &nbsp; <span class=\"label_description\">Enter email address(es) that should receive a notification email regarding New order on your site</span>','','','Use commas to separate email addresses','n','n',605,'2012-08-02 12:24:20','2012-12-13 11:32:49'),('eCommerceOrderSubmitAdminEmailBody',7,'HtmlEditor','Message Body','<h1>\r\n	New Order #: {orderId} has been submitted</h1>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n	<tbody>\r\n		<tr valign=\"top\">\r\n			<td width=\"22%\">\r\n				<h3>\r\n					General Info</h3>\r\n				<strong>Order #:</strong> {orderId}<br />\r\n				<strong>Status:</strong> {status}<br />\r\n				<strong>Gift Card:</strong> {giftCard}<br />\r\n				<strong>Promo Code:</strong> {promo}</td>\r\n			<td width=\"2%\">\r\n				&nbsp;</td>\r\n			<td width=\"22%\">\r\n				<h3>\r\n					Billing Address</h3>\r\n				{billingFirstName} {billingLastName}<br />\r\n				{billingAddress}<br />\r\n				{billingCity} {billingState} {billingZip}</td>\r\n			<td width=\"2%\">\r\n				&nbsp;</td>\r\n			<td width=\"22%\">\r\n				<h3>\r\n					Shipping Address</h3>\r\n				{shippingNameTitle} {shippingServiceCodeTitle}<br />\r\n				{shippingFirstName} {shippingLastName}<br />\r\n				{shippingAddress}<br />\r\n				{shippingCity}</td>\r\n			<td width=\"2%\">\r\n				&nbsp;</td>\r\n			<td width=\"22%\">\r\n				<h3>\r\n					Payment Method</h3>\r\n				<strong>Payment Type:</strong> {paymentTypeTitle}<br />\r\n				<strong>Paid:</strong> {paid}</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	<br />\r\n	{cartItems}</p>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n	<tbody>\r\n		<tr valign=\"top\">\r\n			<td width=\"48%\">\r\n				<h4>\r\n					Customer Notes</h4>\r\n				{userAdditionalNote}</td>\r\n			<td width=\"4%\">\r\n				&nbsp;</td>\r\n			<td width=\"48%\">\r\n				<h4>\r\n					Staff Only Notes</h4>\r\n				{adminAdditionalNote}</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<hr />\r\n<p style=\"font-family: Arial; font-size:12px;\">\r\n	<br />\r\n	Click <a href=\"{link}\" target=\"_blank\">here</a> for details</p>\r\n','','Constants: {orderId} {billingFirstName} {billingLastName} {billingAddress} {billingCity} {billingState} {billingZip} {shippingFirstName} {shippingLastName} {shippingAddress} {shippingCity} {shippingNameTitle} {shippingServiceCodeTitle} {paymentTypeTitle} {paid} {status} {promo} {giftCard} {subtotal} {tax} {total} {cartItems} {adminAdditionalNote} {userAdditionalNote} {link}','y','n',610,'2012-09-20 17:33:40','2012-12-13 11:32:49'),('eCommerceOrderChangedUserEmailHeader',7,'header','','Order changed (User Notification)','','','n','n',620,'2012-09-20 16:59:37','2012-09-20 16:59:37'),('eCommerceOrderChangedUserEmailFrom',7,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',630,'2012-09-20 17:14:46','2012-12-13 11:32:49'),('eCommerceOrderChangedUserEmailSubject',7,'text','Subject','Order has been changed','','','y','n',640,'2012-09-20 17:10:48','2012-12-13 11:32:49'),('eCommerceOrderChangedUserEmailBody',7,'HtmlEditor','Message Body','<h1>\r\n	Order #: {orderId} has been changed</h1>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n	<tbody>\r\n		<tr valign=\"top\">\r\n			<td width=\"22%\">\r\n				<h3>\r\n					General Info</h3>\r\n				<strong>Order #:</strong> {orderId}<br />\r\n				<strong>Status:</strong> {status}<br />\r\n				<strong>Gift Card:</strong> {giftCard}<br />\r\n				<strong>Promo Code:</strong> {promo}</td>\r\n			<td width=\"2%\">\r\n				&nbsp;</td>\r\n			<td width=\"22%\">\r\n				<h3>\r\n					Billing Address</h3>\r\n				{billingFirstName} {billingLastName}<br />\r\n				{billingAddress}<br />\r\n				{billingCity} {billingState} {billingZip}</td>\r\n			<td width=\"2%\">\r\n				&nbsp;</td>\r\n			<td width=\"22%\">\r\n				<h3>\r\n					Shipping Address</h3>\r\n				{shippingNameTitle} {shippingServiceCodeTitle}<br />\r\n				{shippingFirstName} {shippingLastName}<br />\r\n				{shippingAddress}<br />\r\n				{shippingCity}</td>\r\n			<td width=\"2%\">\r\n				&nbsp;</td>\r\n			<td width=\"22%\">\r\n				<h3>\r\n					Payment Method</h3>\r\n				<strong>Payment Type:</strong> {paymentTypeTitle}<br />\r\n				<strong>Paid:</strong> {paid}</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	<br />\r\n	{cartItems}</p>\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n	<tbody>\r\n		<tr valign=\"top\">\r\n			<td>\r\n				<h4>\r\n					Customer Notes</h4>\r\n				{userAdditionalNote}</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<hr />\r\n<p style=\"font-family: Arial; font-size:12px;\">\r\n	<br />\r\n	Click <a href=\"{link}\" target=\"_blank\">here</a> for details</p>\r\n','','Constants: {orderId} {billingFirstName} {billingLastName} {billingAddress} {billingCity} {billingState} {billingZip} {shippingFirstName} {shippingLastName} {shippingAddress} {shippingCity} {shippingNameTitle} {shippingServiceCodeTitle} {paymentTypeTitle} {paid} {status} {promo} {giftCard} {subtotal} {tax} {total} {cartItems} {adminAdditionalNote} {userAdditionalNote} {link}','y','n',650,'2012-09-20 17:33:40','2012-12-13 11:32:49'),('checkoutFooter',6,'htmlEditor','Checkout Footer','<table>\r\n	<tbody>\r\n		<tr>\r\n			<td style=\"padding-right: 10px; vertical-align:middle;\">\r\n				<p style=\"padding-top:5px;\">\r\n					<span style=\"color:#575757;\"><strong><img alt=\"\" src=\"{BASE_URL}/images/ecommerce/ssl/lock-icon.png\" style=\"width: 13px; height: 16px; margin-top:-5px;\" /> <span style=\"font-size:12px;\">Your order is safe and secure.</span></strong></span></p>\r\n				<p>\r\n					<span style=\"font-size:11px;\"><span style=\"color: rgb(117, 117, 117);\">All transactions with this website are secure,<br />\r\n					indicated by the icon in your browser window.</span></span></p>\r\n			</td>\r\n			<td style=\"padding-right: 10px; vertical-align:middle;\">\r\n				<!--img alt=\"\" src=\"{BASE_URL}/images/ecommerce/ssl/scaner-seal-by-godaddy.png\" style=\"width: 137px; height: 31px; margin-top: 5px; margin-bottom: 5px;\" /><br />--><img alt=\"\" src=\"{BASE_URL}/images/ecommerce/ssl/verified-and-secured-by-godaddy.png\" style=\"width: 132px; height: 31px;\" /></td>\r\n			<td style=\"padding-right: 10px; vertical-align:middle;\">\r\n				<img alt=\"\" src=\"{BASE_URL}/images/ecommerce/ssl/Verified-Merchant.png\" style=\"width: 90px; height: 72px;\" /></td>\r\n			<td style=\"padding-right: 10px; vertical-align:middle;\">\r\n				<img alt=\"\" src=\"{BASE_URL}/images/ecommerce/ssl/paypal-seal.png\" style=\"width: 72px; height: 72px;\" /></td>\r\n			<td style=\"padding-right: 10px; vertical-align:middle;\">\r\n				<!-- PayPal Logo -->\r\n				<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n					<tbody>\r\n						<tr>\r\n							<td align=\"center\">\r\n								<a href=\"#\" onclick=\"javascript:window.open(\'https://www.paypal.com/uk/cgi-bin/webscr?cmd=xpt/Marketing/popup/OLCWhatIsPayPal-outside\',\'olcwhatispaypal\',\'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=yes, width=400, height=500\');return false;\"><img alt=\"PayPal-Standard-Logo\" border=\"0\" src=\"https://www.paypal.com/en_GB/Marketing/i/logo/PayPal_logo_80x35.gif\" /></a></td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n				<!-- PayPal Logo --></td>\r\n			<td style=\"padding-right: 10px; vertical-align:middle;\">\r\n				<img alt=\"\" src=\"{BASE_URL}/images/ecommerce/ssl/cards.png\" style=\"width: 147px; height: 21px;\" /></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<p>\r\n	&nbsp;</p>\r\n','','','n','n',200,'2012-11-20 12:23:48','2012-11-29 09:24:16'),('checkoutHeader',6,'header','Other Settings','','','','n','n',199,'0000-00-00 00:00:00','0000-00-00 00:00:00'),('blogCommentEmailHeader',2,'header','','Blog Comment Submission Notification','','','n','n',200,'2012-12-03 12:27:12','2012-12-03 12:27:12'),('blogCommentEmailSubject',2,'text','Subject','New comment on the blog post has been submitted','','','y','n',210,'2012-12-03 12:27:12','2012-12-07 16:26:23'),('blogCommentEmailFrom',2,'text','From Email Address','Adapta Interactive Framework <qsf@adaptainc.com>','','','y','n',220,'2012-12-03 12:27:12','2012-12-07 16:26:23'),('blogCommentEmailTo',2,'emails','To Email Address(es) &nbsp; <span class=\"label_description\">Enter email address(es) that should receive a notification email regarding Blog comments submissions on your website</span>','blog@vityk.fr-wd.com','','Use commas to separate email addresses','n','n',230,'2012-12-03 12:27:12','2012-12-07 16:26:23'),('blogCommentEmailBody',2,'HtmlEditor','Message Body','<p>\r\n	New comment on the blog post has been submitted.<br />\r\n	<br />\r\n	Post Title: <strong>{postTitle}</strong><br />\r\n	Comment Title: <strong>{commentTitle}</strong><br />\r\n	Author Name: <strong>{author}</strong><br />\r\n	Author Email: <strong>{email}</strong><br />\r\n	Comment:<br />\r\n	<strong>{comment}</strong><br />\r\n	<br />\r\n	Click <a href=\"{link}\">here</a> to view details.</p>\r\n','','Constants: {postTitle} {commentTitle} {author} {email} {comment} {link}','y','n',240,'2012-12-03 12:27:12','2012-12-07 16:26:23');