-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 18, 2011 at 11:06 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;

--
-- Database: `mnuke_install`
--

-- --------------------------------------------------------

--
-- Table structure for table `article_navigation`
--

DROP TABLE IF EXISTS `product_bonus`;

DROP TABLE IF EXISTS `article_navigation`;
CREATE TABLE IF NOT EXISTS `article_navigation` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) NOT NULL,
  `to` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `site_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `article_navigation`
--


-- --------------------------------------------------------

--
-- Table structure for table `bonus`
--

DROP TABLE IF EXISTS `bonus`;
CREATE TABLE IF NOT EXISTS `bonus` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `primary` tinyint(1) NOT NULL DEFAULT '0',
  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `bonusproduct` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `value` smallint(3) NOT NULL,
  `excerpt` text COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `bonusproduct` (`bonusproduct`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `bonus`
--

INSERT INTO `bonus` (`id`, `primary`, `title`, `bonusproduct`, `description`, `enabled`, `value`, `excerpt`, `image`, `type`, `url`) VALUES
(1, 1, 'Exclusive Bonus# {bonus_number} » ', 'Quick Cash Confidential', '\r\n<p>QuickCashConfidential Shows You How Using A Free Method Helping Regular People Make Money From Home!&nbsp;<br />\r\n	<br />\r\n	You can have <span style="font-style: italic; ">this <span style="color: rgb(128, 0, 0); font-weight: bold; ">66 pages book for free</span></span> as an exclusive bonus when you buy the <span style="text-decoration: underline; font-weight: bold; ">{product_title}</span>.<br />\r\n	<br />\r\n	It will literally take you by the hands and demonstrate how you can make $1,000 online.&nbsp;Whether you have already made $1,000 online or not this book can help you finally make some money online.</p>\r\n<div>\r\n	<ul class="handarrow">\r\n	</ul></div>                                                                                                                                                                      ', 0, 47, '\r\n<p>Here is a FREE Method That is Helping Regular People Make Money From Home! Earn Your First or Next $1,000 Online!</p>\r\n<div><span style="font-weight: bold;">Inside You''ll Discover:</span></div>\r\n<div>\r\n	<ul class="handarrow">\r\n		<li>A surefire method for profiting online that has worked over and over again!</li>\r\n		<li>The entire step-by-step strategy used by a 17 year old in high school to make his first $1,000 online.</li>\r\n		<li>How to create a simple converting site in a short time that can generate your profits over and over again.</li>\r\n		<li>A proven marketing system that has worked for generating traffic and profits for thousands of people and businesses.</li>\r\n	</ul></div>                                                                                                                                                                     ', 'qcconfl_bonus.jpg', '', 'http://www.quickcashconfidential.com/895SPthanks.php');

-- --------------------------------------------------------

--
-- Table structure for table `coupons`
--

DROP TABLE IF EXISTS `coupons`;
CREATE TABLE IF NOT EXISTS `coupons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_code` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `product_id` tinyint(1) DEFAULT NULL,
  `expiry` datetime DEFAULT NULL,
  `amount` int(11) NOT NULL,
  `site_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `coupons`
--


-- --------------------------------------------------------

--
-- Table structure for table `email_templates`
--

DROP TABLE IF EXISTS `email_templates`;
CREATE TABLE IF NOT EXISTS `email_templates` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `default_text` text COLLATE utf8_unicode_ci NOT NULL,
  `is_enabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=36 ;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` (`id`, `title`, `subject`, `text`, `default_text`, `is_enabled`) VALUES
(2, 'receipt', '{site_name} - Order Receipt', 'Dear {user_name}, \r\n\r\nThank you for your order. Here are your order details:\r\n\r\nProduct: {product_name}\r\nTransaction#: {transaction_id}\r\n\r\nAnd here are your login details to download the product\r\nLogin url: {site_url}/login \r\nYour User ID: {user_email} \r\nYour Password: {user_pass} \r\n\r\n--\r\n\r\nBest Regards,\r\n{admin_name}\r\n{site_name}', 'Dear {user_name}, \r\n\r\nThank you for your order. Here are your order details:\r\n\r\nProduct: {product_name}\r\nTransaction#: {transaction_id}\r\n\r\nAnd here are your login details to download the product\r\nLogin url: {site_url}/login \r\nYour User ID: {user_email} \r\nYour Password: {user_pass} \r\n\r\n--\r\n\r\nBest Regards,\r\n{admin_name}\r\n{site_name}', 1),
(3, 'registration', '{site_name} - Membership Information', 'Dear {user_name}, \r\n\r\nYour account has been created! If you have ordered any product, you will receive another email with your order details.\r\n\r\nLogin url: {site_url}/login \r\nYour User ID: {user_email} \r\nYour Password: {user_pass} \r\n\r\n--\r\nBest Regards, \r\n{admin_name} \r\n{site_name}', 'Dear {user_name}, \r\n\r\nYour account has been created! If you have ordered any product, you will receive another email with your order details.\r\n\r\nLogin url: {site_url}/login \r\nYour User ID: {user_email} \r\nYour Password: {user_pass} \r\n\r\n--\r\nBest Regards, \r\n{admin_name} \r\n{site_name}', 1),
(34, 'password recovery', '{site_name} - Password recovery', 'Dear {user_name},\r\n\r\nAs per your request here are your account details\r\n\r\nURL: {site_url}/login\r\nYour email is: {user_email}\r\nYour password is: {user_pass}\r\n\r\n\r\n--\r\n\r\nBest Regards,\r\n{admin_name}\r\n{site_name}', 'Dear {user_name},\r\n\r\nAs per your request here are your account details\r\n\r\nURL: {site_url}/login\r\nYour email is: {user_email}\r\nYour password is: {user_pass}\r\n\r\n\r\n--\r\n\r\nBest Regards,\r\n{admin_name}\r\n{site_name}', 1),
(35, 'affiliate sale', '{site_name} - new affiliate sale', 'Dear {user_name},\r\n\r\nCongratulations! ... You just made new affiliate sale of {product_name}.\r\n\r\nYou may login to your affiliate panel to see the statistics.\r\nLogin url: {site_url}/login \r\nYour User ID: {user_email} \r\nYour Password: {user_pass} \r\n\r\n--\r\nBest Regards,\r\n{admin_name}\r\n{site_name}', 'Dear {user_name},\r\n\r\nCongratulations! ... You just made new affiliate sale of {product_name}.\r\n\r\nYou may login to your affiliate panel to see the statistics.\r\nLogin url: {site_url}/login \r\nYour User ID: {user_email} \r\nYour Password: {user_pass} \r\n\r\n--\r\nBest Regards,\r\n{admin_name}\r\n{site_name}', 1);

-- --------------------------------------------------------

--
-- Table structure for table `flow`
--

DROP TABLE IF EXISTS `flow`;
CREATE TABLE IF NOT EXISTS `flow` (
  `page_id` int(11) NOT NULL,
  `exit_page_id` int(11) NOT NULL,
  `id` tinyint(4) NOT NULL,
  `site_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `flow`
--


-- --------------------------------------------------------

--
-- Table structure for table `hits`
--

DROP TABLE IF EXISTS `hits`;
CREATE TABLE IF NOT EXISTS `hits` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `affiliate_id` int(11) NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `datetime` datetime NOT NULL,
  `page_id` int(11) NOT NULL,
  `site_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `hits`
--


-- --------------------------------------------------------

--
-- Table structure for table `ipn_logs`
--

DROP TABLE IF EXISTS `ipn_logs`;
CREATE TABLE IF NOT EXISTS `ipn_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `get` text COLLATE utf8_unicode_ci NOT NULL,
  `post` text COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `other` text COLLATE utf8_unicode_ci NOT NULL,
  `site_id` int(11) NOT NULL,
  `transaction_id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `ipnlog` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ipn_logs`
--


-- --------------------------------------------------------

--
-- Table structure for table `loginvr`
--

DROP TABLE IF EXISTS `loginvr`;
CREATE TABLE IF NOT EXISTS `loginvr` (
  `usr` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pwd` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ud` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fd` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` tinyint(1) NOT NULL,
  `warning` int(1) NOT NULL,
  `version` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `em` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `loginvr`
--

INSERT INTO `loginvr` (`usr`, `pwd`, `ud`, `fd`, `value`, `warning`, `version`, `em`) VALUES
('a2Vud2I=', 'cGl4YXB5cmVqOQ==', '20111230', 'MjAxMjAxMDY=', 2, 0, '0', 'kenwb@sympatico.ca');

-- --------------------------------------------------------

--
-- Table structure for table `log_emails`
--

DROP TABLE IF EXISTS `log_emails`;
CREATE TABLE IF NOT EXISTS `log_emails` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `time` datetime NOT NULL,
  `subject` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `receivers` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `log_emails`
--


-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

DROP TABLE IF EXISTS `pages`;
CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_page_id` int(11) NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `seftitle` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `text` longtext COLLATE utf8_unicode_ci NOT NULL,
  `default_text` text COLLATE utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `published` int(3) NOT NULL DEFAULT '1',
  `description_meta` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `keywords_meta` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `theme` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `product_id` tinyint(4) NOT NULL,
  `commentable` tinyint(1) NOT NULL,
  `on_footer` tinyint(4) NOT NULL,
  `on_squeezefooter` tinyint(4) NOT NULL,
  `site_id` int(11) NOT NULL,
  `header_code` text COLLATE utf8_unicode_ci NOT NULL,
  `footer_code` text COLLATE utf8_unicode_ci NOT NULL,
  `exit_text` text COLLATE utf8_unicode_ci NOT NULL,
  `orderbutton` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `is_primary` tinyint(1) NOT NULL,
  `to_show` tinyint(1) NOT NULL,
  `coupon_code` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `site_page_id`, `title`, `seftitle`, `text`, `default_text`, `date`, `published`, `description_meta`, `keywords_meta`, `type`, `theme`, `product_id`, `commentable`, `on_footer`, `on_squeezefooter`, `site_id`, `header_code`, `footer_code`, `exit_text`, `orderbutton`, `is_primary`, `to_show`, `coupon_code`) VALUES
(1, 0, 'Affiliate Registration', 'affiliate-registration', ' <h1 style="font-size: 40px; text-shadow: none; line-height: 50px;" class="impactfnt"><span class="blacktext">Thanks for Your Interest in Promoting</span><br /> {site_name}!</h1> <p>You will earn {aff_commission} commission paid your Paypal account by promoting {site_name}.</p> <p>Commissions work a little differently than you may be used to. Instead of receiving x% of each sale, you will receive <span style="font-weight: bold;">100% commissions</span> on {aff_commission} of your sales. This works out to the exact same amount, but allows you to be paid for your sales immediately into your Paypal account.</p> <p>Just register, using the form below. We''ll send you a promotional link that you can mail to your readers, or advertise in other ways to earn commissions.&nbsp;</p> <p><span style="font-weight: bold;">Existing affiliate may <a href="{site_url}login">login here</a>. OR to get your affiliate tools <a href="{site_url}tools">Click Here</a></span></p> ', ' <h1 style="font-size: 40px; text-shadow: none; line-height: 50px;" class="impactfnt"><span class="blacktext">Thanks for Your Interest in Promoting</span><br /> {site_name}!</h1> <p>You will earn {aff_commission} commission paid your Paypal account by promoting {site_name}.</p> <p>Commissions work a little differently than you may be used to. Instead of receiving x% of each sale, you will receive <span style="font-weight: bold;">100% commissions</span> on {aff_commission} of your sales. This works out to the exact same amount, but allows you to be paid for your sales immediately into your Paypal account.</p> <p>Just register, using the form below. We''ll send you a promotional link that you can mail to your readers, or advertise in other ways to earn commissions.&nbsp;</p> <p><span style="font-weight: bold;">Existing affiliate may <a href="{site_url}login">login here</a>. OR to get your affiliate tools <a href="{site_url}tools">Click Here</a></span></p> ', '0000-00-00 00:00:00', 1, '', '', 'aff_registration', '', 0, 0, 0, 0, 0, '', '', '', '', 1, 1, ''),
(2, 0, 'Affiliate Tools', 'tools', ' <h1 style="font-size: 40px; text-shadow: none; line-height: 50px;" class="impactfnt"><span class="blacktext">Thanks for Your Interest in Promoting</span><br /> {site_name}!</h1> <div> <p style="text-align: center;">Simply enter your {processorname}affiliate id (nickname) in the textbox below, and all the following affiliate tools and affiliate links will be personalized with your affiliate id that you can use to promote<br /> <span style="font-weight: bold;">{site_name}</span>. <br /> {affform}</p> <p style="text-align: center;">&nbsp;</p> <h2>Your Affiliate URL</h2> <div class="affurl">{affurl}</div> <p><br /> </p> <h2>Promo Emails</h2> <p> Below are 2 sample emails to promote the Prelaunch. If you wish, feel free to edit the emails to give it your personality.</p> <p><span class="highlighttext" style="font-weight: bold;">Remember:</span><br /> - Replace [fname] with whatever tag your autoresponder uses for the First Name of your subscriber. eg. If you are using <span style="font-weight: bold;">Aweber</span>, you need to change it to {!firstname_fix}.</p> <p> - Also, at the end of each email, replace "Your Name" with your actual name.</p>{email_tools} <p>&nbsp;</p> <h2>Banner Ads:</h2> <p> Use the following banners to put on your website or your blog.</p> <p><span style="font-weight: bold;"><span style="font-weight: bold;" class="redtxt"><span style="font-weight: bold;" class="redtext">IMPORTANT</span></span></span><br /> <span style="font-weight: bold;">Please do not save the banner images on your hard drive</span>. Simply copy the code and paste it on your webpage. All images will be pulled in from our servers.<br /> <br /> </p>{banner_tools} <p>&nbsp;</p> <div> <h2 style="border-width: initial; border-color: initial; ">Product Images:</h2> <p>You may also use following images to put on your website or your blog.</p> <p><span style="font-weight: bold; "><span class="redtxt" style="font-weight: bold; "><span class="redtext" style="font-weight: bold; ">IMPORTANT</span></span></span><br /> <span style="font-weight: bold; ">Please do not save the images on your hard drive or your server</span>. Simply copy the code and paste it on your webpage. All images will be pulled in from our servers.<br /> <br /> </p>{productimage_tools}</div> <p><br /> </p> <div> <h2 style="border-width: initial; border-color: initial; border-width: initial; border-color: initial; ">HTML CODES:</h2> <p>You may also use following html code on your page such as thank you pages, confirmation pages etc.</p> <p><span style="font-weight: bold; "><span class="redtxt" style="font-weight: bold; "><span class="redtext" style="font-weight: bold; ">IMPORTANT</span></span></span><br /> <span style="font-weight: bold; ">Please </span> copy the code provided in the textarea and paste it on your webpage. <br /> <br /> </p>{htmlcodes_tools}</div></div> ', ' <h1 style="font-size: 40px; text-shadow: none; line-height: 50px;" class="impactfnt"><span class="blacktext">Thanks for Your Interest in Promoting</span><br /> {site_name}!</h1> <div> <p style="text-align: center;">Simply enter your {processorname}affiliate id (nickname) in the textbox below, and all the following affiliate tools and affiliate links will be personalized with your affiliate id that you can use to promote<br /> <span style="font-weight: bold;">{site_name}</span>. <br /> {affform}</p> <p style="text-align: center;">&nbsp;</p> <h2>Your Affiliate URL</h2> <div class="affurl">{affurl}</div> <p><br /> </p> <h2>Promo Emails</h2> <p> Below are 2 sample emails to promote the Prelaunch. If you wish, feel free to edit the emails to give it your personality.</p> <p><span class="highlighttext" style="font-weight: bold;">Remember:</span><br /> - Replace [fname] with whatever tag your autoresponder uses for the First Name of your subscriber. eg. If you are using <span style="font-weight: bold;">Aweber</span>, you need to change it to {!firstname_fix}.</p> <p> - Also, at the end of each email, replace "Your Name" with your actual name.</p>{email_tools} <p>&nbsp;</p> <h2>Banner Ads:</h2> <p> Use the following banners to put on your website or your blog.</p> <p><span style="font-weight: bold;"><span style="font-weight: bold;" class="redtxt"><span style="font-weight: bold;" class="redtext">IMPORTANT</span></span></span><br /> <span style="font-weight: bold;">Please do not save the banner images on your hard drive</span>. Simply copy the code and paste it on your webpage. All images will be pulled in from our servers.<br /> <br /> </p>{banner_tools} <p>&nbsp;</p> <div> <h2 style="border-width: initial; border-color: initial; ">Product Images:</h2> <p>You may also use following images to put on your website or your blog.</p> <p><span style="font-weight: bold; "><span class="redtxt" style="font-weight: bold; "><span class="redtext" style="font-weight: bold; ">IMPORTANT</span></span></span><br /> <span style="font-weight: bold; ">Please do not save the images on your hard drive or your server</span>. Simply copy the code and paste it on your webpage. All images will be pulled in from our servers.<br /> <br /> </p>{productimage_tools}</div> <p><br /> </p> <div> <h2 style="border-width: initial; border-color: initial; border-width: initial; border-color: initial; ">HTML CODES:</h2> <p>You may also use following html code on your page such as thank you pages, confirmation pages etc.</p> <p><span style="font-weight: bold; "><span class="redtxt" style="font-weight: bold; "><span class="redtext" style="font-weight: bold; ">IMPORTANT</span></span></span><br /> <span style="font-weight: bold; ">Please </span> copy the code provided in the textarea and paste it on your webpage. <br /> <br /> </p>{htmlcodes_tools}</div></div> ', '0000-00-00 00:00:00', 1, '', '', 'aff_tools', '', 0, 0, 1, 0, 0, '', '', '', '', 1, 1, ''),
(3, 0, 'Thankyou', 'thankyou', 'a:2:{s:4:"text";s:479:" <div class="greenalert"> <h2 align="center">Thank you for purchasing <br /> <span style="font-weight: bold;">{product_title}</span></h2> <p align="center">Your transaction id is <span style="font-weight: bold;">{transaction_id}. </span></p> <p align="center">Amount received: <span style="font-weight: bold;">{sale_amount}.</span></p></div> <div align="center"><a href="{member_area}"><span style="font-weight: bold;">Go to Members area to download the product</span></a></div> ";s:10:"error_text";s:199:" <div class="greenalert"> <h2 align="center">Sorry! you have reached the wrong page</h2> <p align="center">If you have paid for the product, please contact us with the transaction details.</p></div> ";}', 'a:2:{s:4:"text";s:479:" <div class="greenalert"> <h2 align="center">Thank you for purchasing <br /> <span style="font-weight: bold;">{product_title}</span></h2> <p align="center">Your transaction id is <span style="font-weight: bold;">{transaction_id}. </span></p> <p align="center">Amount received: <span style="font-weight: bold;">{sale_amount}.</span></p></div> <div align="center"><a href="{member_area}"><span style="font-weight: bold;">Go to Members area to download the product</span></a></div> ";s:10:"error_text";s:199:" <div class="greenalert"> <h2 align="center">Sorry! you have reached the wrong page</h2> <p align="center">If you have paid for the product, please contact us with the transaction details.</p></div> ";}', '0000-00-00 00:00:00', 1, '', '', 'thankyou', '', 0, 0, 0, 0, 0, '', '', '', '', 1, 1, ''),
(4, 0, 'Member Home', 'members', 'a:2:{s:4:"text";s:1977:" <p>Hello <span style="font-weight: bold;">{user_fname} {user_lname}</span>,</p> <p> Welcome to <span style="font-weight: bold;">{site_name}</span> and thank you for your investment. This is one of the best decisions you''ve ever made!If you need any help, contact me at the helpdesk (link at the bottom of this page)</p> <p style="text-align: center;">{aff_stats}<br /> </p> <h2 align="center">Download Instructions</h2> <div style="line-height: normal;" class="dlbox"> <p>Please note that you will need <span style="font-weight: bold;">Adobe Acrobat Reader to open PDF files.</span> Most computers already have Adobe Reader installed. If your computer doesn''t have it, you can get a FREE download of the latest version <a target="_blank" href="http://www.adobe.com/products/acrobat/readstep2.html">here.</a></p> <p><span style="font-weight: bold;">Adobe Acrobat Reader</span> has versions for both PC and Macintosh computers. The PDF documents here can be opened and read on either a PC or a Macintosh with Adobe Reader.</p> <p>You will also need an "unzip" program to open any zipped applications and you can download the following if you don''t have them installed already:</p> <p><span style="font-weight: bold;">PC Users:</span> I recommend usingWinRAR or <a target="_blank" href="http://www.winzip.com/">WinZip</a>. A free evaluation version is available. <br /> <span style="font-weight: bold;"> Mac/Linux Users:</span> I recommend using <a target="_blank" href="http://www.aladdinsys.com/">StuffIt Xpander</a>.<br /> <br /> Below you''ll see the download link for your purchased products including bonuses. To start saving them to your computer, simply click on the link and&nbsp;a download screen asking you where on your computer you want to save the files will appear.</p> <p>Simply follow the instructions to download the file and unzip it using the any of the unzip tool.</p></div> <div>{member_downloads}</div> <div><br /> </div> <div>{member_bonuses}<br /> </div> ";s:8:"aff_text";s:235:" <p>Hello <span style="font-weight: bold;">{user_fname} {user_lname}</span>,</p> <p>Thank You For Your Interest, You may get your affiliate links from "tools" page</p> <p style="text-align: center;">{aff_stats}</p><br /> <p>&nbsp;</p> ";}', 'a:2:{s:4:"text";s:1977:" <p>Hello <span style="font-weight: bold;">{user_fname} {user_lname}</span>,</p> <p> Welcome to <span style="font-weight: bold;">{site_name}</span> and thank you for your investment. This is one of the best decisions you''ve ever made!If you need any help, contact me at the helpdesk (link at the bottom of this page)</p> <p style="text-align: center;">{aff_stats}<br /> </p> <h2 align="center">Download Instructions</h2> <div style="line-height: normal;" class="dlbox"> <p>Please note that you will need <span style="font-weight: bold;">Adobe Acrobat Reader to open PDF files.</span> Most computers already have Adobe Reader installed. If your computer doesn''t have it, you can get a FREE download of the latest version <a target="_blank" href="http://www.adobe.com/products/acrobat/readstep2.html">here.</a></p> <p><span style="font-weight: bold;">Adobe Acrobat Reader</span> has versions for both PC and Macintosh computers. The PDF documents here can be opened and read on either a PC or a Macintosh with Adobe Reader.</p> <p>You will also need an "unzip" program to open any zipped applications and you can download the following if you don''t have them installed already:</p> <p><span style="font-weight: bold;">PC Users:</span> I recommend usingWinRAR or <a target="_blank" href="http://www.winzip.com/">WinZip</a>. A free evaluation version is available. <br /> <span style="font-weight: bold;"> Mac/Linux Users:</span> I recommend using <a target="_blank" href="http://www.aladdinsys.com/">StuffIt Xpander</a>.<br /> <br /> Below you''ll see the download link for your purchased products including bonuses. To start saving them to your computer, simply click on the link and&nbsp;a download screen asking you where on your computer you want to save the files will appear.</p> <p>Simply follow the instructions to download the file and unzip it using the any of the unzip tool.</p></div> <div>{member_downloads}</div> <div><br /> </div> <div>{member_bonuses}<br /> </div> ";s:8:"aff_text";s:235:" <p>Hello <span style="font-weight: bold;">{user_fname} {user_lname}</span>,</p> <p>Thank You For Your Interest, You may get your affiliate links from "tools" page</p> <p style="text-align: center;">{aff_stats}</p><br /> <p>&nbsp;</p> ";}', '2011-07-12 17:21:03', 1, '', '', 'memberarea', '', 0, 0, 0, 0, 0, '', '', '', '', 1, 1, ''),
(5, 0, 'Disclaimer', 'disclaimer', ' <h2>DISCLAIMER AND TERMS OF USE AGREEMENT </h2> <p>The author and publisher of this {site_name} and the accompanying materials have used their best efforts in preparing this {site_name}. The author and publisher make no representation or warranties with respect to the accuracy, applicability, fitness, or completeness of the contents of this {site_name}. The information contained in this {site_name} is strictly for educational purposes. Therefore, if you wish to apply ideas contained in this {site_name}, you are taking full responsibility for your actions. </p> <p>EVERY EFFORT HAS BEEN MADE TO ACCURATELY REPRESENT THIS PRODUCT AND IT''S POTENTIAL. EVEN THOUGH THIS INDUSTRY IS ONE OF THE FEW WHERE ONE CAN WRITE THEIR OWN CHECK IN TERMS OF EARNINGS, THERE IS NO GUARANTEE THAT YOU WILL EARN ANY MONEY USING THE TECHNIQUES AND IDEAS IN THESE MATERIALS. EXAMPLES IN THESE MATERIALS ARE NOT TO BE INTERPRETED AS A PROMISE OR GUARANTEE OF EARNINGS. EARNING POTENTIAL IS ENTIRELY DEPENDENT ON THE PERSON USING OUR PRODUCT, IDEAS AND TECHNIQUES. WE DO NOT PURPORT THIS AS A "GET RICH SCHEME". </p> <p>ANY CLAIMS MADE OF ACTUAL EARNINGS OR EXAMPLES OF ACTUAL RESULTS CAN BE VERIFIED UPON REQUEST. YOUR LEVEL OF SUCCESS IN ATTAINING THE RESULTS CLAIMED IN OUR MATERIALS DEPENDS ON THE TIME YOU DEVOTE TO THE KNOWLEDGE AND VARIOUS SKILLS. SINCE THESE FACTORS DIFFER ACCORDING TO INDIVIDUALS, WE CANNOT GUARANTEE YOUR SUCCESS OR INCOME LEVEL. NOR ARE WE RESPONSIBLE FOR ANY OF YOUR ACTIONS.</p> <p>MATERIALS IN OUR PRODUCT AND OUR WEBSITE MAY CONTAIN INFORMATION THAT INCLUDES OR IS BASED UPON FORWARD-LOOKING STATEMENTS WITHIN THE MEANING OF THE SECURITIES LITIGATION REFORM ACT OF 1995. FORWARD-LOOKING STATEMENTS GIVE OUR EXPECTATIONS OR FORECASTS OF FUTURE EVENTS. YOU CAN IDENTIFY THESE STATEMENTS BY THE FACT THAT THEY DO NOT RELATE STRICTLY TO HISTORICAL OR CURRENT FACTS. THEY USE WORDS SUCH AS "ANTICIPATE", "ESTIMATE", "EXPECT", "PROJECT", "INTEND", "PLAN", "BELIEVE", AND OTHER WORDS AND TERMS OF SIMILAR MEANING IN CONNECTION WITH A DESCRIPTION OF POTENTIAL EARNINGS OR FINANCIAL PERFORMANCE.</p> <p>ANY AND ALL FORWARD LOOKING STATEMENTS HERE OR ON ANY OF OUR SALES MATERIAL ARE INTENDED TO EXPRESS OUR OPINION OF EARNINGS POTENTIAL. MANY FACTORS WILL BE IMPORTANT IN DETERMINING YOUR ACTUAL RESULTS AND NO GUARANTEES ARE MADE THAT YOU WILL ACHIEVE RESULTS SIMILAR TO OURS OR ANYBODY ELSES, IN FACT NO GUARANTEES ARE MADE THAT YOU WILL ACHIEVE ANY RESULTS FROM OUR IDEAS AND TECHNIQUES IN OUR MATERIAL.</p> <p>The author and publisher disclaim any warranties (express or implied), merchantability, or fitness for any particular purpose. The author and publisher shall in no event be held liable to any party for any direct, indirect, punitive, special, incidental or other consequential damages arising directly or indirectly from any use of this material, which is provided "as is, and without warranties. <br /> </p> <p>As always, the advice of a competent legal, tax, accounting or other professional should be sought.</p> <p>The author and publisher do not warrant the performance, effectiveness or applicability of any sites listed or linked to in this {site_name}. </p> <p>All links are for information purposes only and are not warranted for content, accuracy or any other implied or explicit purpose. {site_name} is &copy; copyrighted by {admin_fname} {admin_lname} with ALL rights reserved. No part of this may be copied, or changed in any format, sold, or used in any way other than what is outlined within this {site_name} under any circumstances without express permission from {admin_fname} {admin_lname}.</p> ', '', '2010-11-27 09:01:21', 1, '', '', 'legalpages', '', 0, 0, 0, 0, 0, '', '', '', '', 0, 1, ''),
(6, 0, 'Privacy Policy', 'privacy-policy', ' <h2>Privacy Policy</h2>{siteurl_no_prefix} strives to offer its visitors the many advantages of Internet technology and to provide an interactive and personalized experience. We may use Personally Identifiable Information (your name, e-mail address, street address, telephone number) subject to the terms of this privacy policy. We will never sell, barter, or rent your email address to any unauthorized third party. Period." <p style="font-weight: bold;">How we gather information from users</p> <p>How we collect and store information depends on the page you are visiting, the activities in which you elect to participate and the services provided. For example, you may be asked to provide information when you register for access to certain portions of our site or request certain features, such as newsletters or when you make a purchase. You may provide information when you participate in sweepstakes and contests, message boards and chat rooms, and other interactive areas of our site. Like most Web sites, {siteurl_no_prefix} also collects information automatically and through the use of electronic tools that may be transparent to our visitors. For example, we may log the name of your Internet Service Provider or use cookie technology to recognize you and hold information from your visit. Among other things, the cookie may store your user name and password, sparing you from having to re-enter that information each time you visit, or may control the number of times you encounter a particular advertisement while visiting our site. As we adopt additional technology, we may also gather information through other means. In certain cases, you can choose not to provide us with information, for example by setting your browser to refuse to accept cookies, but if you do you may be unable to access certain portions of the site or may be asked to re-enter your user name and password, and we may not be able to customize the site''s features according to your preferences. </p> <p style="font-weight: bold;">What we do with the information we collect</p> <p>Like other Web publishers, we collect information to enhance your visit and deliver more individualized content and advertising. We respect your privacy and do not share your information with anyone. Aggregated Information (information that does not personally identify you) may be used in many ways. For example, we may combine information about your usage patterns with similar information obtained from other users to help enhance our site and services (e.g., to learn which pages are visited most or what features are most attractive). Aggregated Information may occasionally be shared with our advertisers and business partners. Again, this information does not include any Personally Identifiable Information about you or allow anyone to identify you individually. We may use Personally Identifiable Information collected on {siteurl_no_prefix} to communicate with you about your registration and customization preferences; our Terms of Service and privacy policy; services and products offered by {siteurl_no_prefix} and other topics we think you might find of interest. Personally Identifiable Information collected by {siteurl_no_prefix} may also be used for other purposes, including but not limited to site administration, troubleshooting, processing of ecommerce transactions, administration of sweepstakes and contests, and other communications with you. Certain third parties who provide technical support for the operation of our site (our Web hosting service for example) may access such information. We will use your information only as permitted by law. In addition, from time to time as we continue to develop our business, we may sell, buy, merge or partner with other companies or businesses. In such transactions, user information may be among the transferred assets. We may also disclose your information in response to a court order, at other times when we believe we are reasonably required to do so by law, in connection with the collection of amounts you may owe to us, and/or to law enforcement authorities whenever we deem it appropriate or necessary. Please note we may not provide you with notice prior to disclosure in such cases.</p> <p style="font-weight: bold;">Affiliated sites, linked sites and advertisements</p> <p>{siteurl_no_prefix} expects its partners, advertisers and affiliates to respect the privacy of our users. Be aware, however, that third parties, including our partners, advertisers, affiliates and other content providers accessible through our site, may have their own privacy and data collection policies and practices. For example, during your visit to our site you may link to, or view as part of a frame on a {siteurl_no_prefix} page, certain content that is actually created or hosted by a third party. Also, through {siteurl_no_prefix} you may be introduced to, or be able to access, information, Web sites, features, contests or sweepstakes offered by other parties. {siteurl_no_prefix} is not responsible for the actions or policies of such third parties. You should check the applicable privacy policies of those third parties when providing information on a feature or page operated by a third party.</p> <p>While on our site, our advertisers, promotional partners or other third parties may use cookies or other technology to attempt to identify some of your preferences or retrieve information about you. For example, some of our advertising is served by third parties and may include cookies that enable the advertiser to determine whether you have seen a particular advertisement before. Other features available on our site may offer services operated by third parties and may use cookies or other technology to gather information. {siteurl_no_prefix} does not control the use of this technology by third parties or the resulting information, and is not responsible for any actions or policies of such third parties. </p> <p>You should also be aware that if you voluntarily disclose Personally Identifiable Information on message boards or in chat areas, that information can be viewed publicly and can be collected and used by third parties without our knowledge and may result in unsolicited messages from other individuals or third parties. Such activities are beyond the control of {siteurl_no_prefix} and this policy. </p> <p style="font-weight: bold;">Children</p> <p>{siteurl_no_prefix} does not knowingly collect or solicit Personally Identifiable Information from or about children under 13 except as permitted by law. If we discover we have received any information from a child under 13 in violation of this policy, we will delete that information immediately. If you believe {siteurl_no_prefix} has any information from or about anyone under 13, please contact us at the address listed below. Contacting Us. </p> <p style="font-weight: bold;">We can be reached by contacting:</p> <p>{siteurl_no_prefix}<br /> {admin_fname}&nbsp;{admin_lname}<br /> {webmaster_address}<br /> {helpdesk_url}</p> <p style="font-weight: bold;">Changes to this Policy</p> <p>{siteurl_no_prefix} reserves the right to change this policy at any time. Please check this page periodically for changes. Your continued use of our site following the posting of changes to these terms will mean you accept those changes. Information collected prior to the time any change is posted will be used according to the rules and laws that applied at the time the information was collected.</p> <p style="font-weight: bold;">Governing law</p> <p>This policy and the use of this Site are governed by ___________law. If a dispute arises under this Policy we agree to first try to resolve it with the help of a mutually agreed-upon mediator in the following location: ___________. Any costs and fees other than attorney fees associated with the mediation will be shared equally by each of us. </p> <p>If it proves impossible to arrive at a mutually satisfactory solution through mediation, we agree to submit the dispute to binding arbitration at the following location: Nebraska, under the rules of the American Arbitration Association. Judgment upon the award rendered by the arbitration may be entered in any court with jurisdiction to do so. {siteurl_no_prefix} is controlled, operated and administered entirely within Nebraska. This statement and the policies outlined herein are not intended to and do not create any contractual or other legal rights in or on behalf of any party.<br /> </p> ', '', '2010-11-27 09:01:21', 1, '', '', 'legalpages', '', 0, 0, 0, 0, 0, '', '', '', '', 0, 1, ''),
(7, 0, 'Terms of Use', 'terms-of-use', ' <h2>WEB SITE TERMS OF USE<br /> </h2> <p>Wow! You actually came to this page. Our lawyers made us include it and made us use a precious button on our home page to get you here. At first, we thought the lawyers were a real pain. But then we read the page. What a Netwakening! It''s really important stuff. We took the legalese the lawyers wrote and translated it into readable English. So be a smart net head and read the stuff on this page. It could prevent you from hearing from our lawyers, or worse yet, from really nasty people, like prosecutors.</p> <p>Here''s the deal:</p> <p>We run this site so that people like you (and people you like) can use it for personal entertainment, information, education, communication, and cybergratification. So go ahead and browse around all you like. You can even download stuff from the site but only for noncommercial, personal use. If you do, though, don''t fool around with the copyright and other notices all over the stuff. They''re there for a really good reason. And don''t even think about distributing, modifying, transmitting, reusing, re-posting, or anything else uncool with any of the stuff, including the text, images, audio, and video, for public or commercial purposes unless we give you written permission. And its not likely we will.</p> <p>If you visit our site, you''re also legally obligated to [read: stuck with] the terms and conditions listed below and any other law or regulation that applies to the site, the Internet or the World Wide Web. You shouldn''t access or browse the site if you have any problem with that, because once you start, there''s no turning back" you are bound by [read: stuck with] the terms and conditions.</p> <p>So here''s the scoop on our Top Ten Rules for Cybersurfers who hang out on our site:</p> <p>1. For everyone''s sake, just assume that everything on the site is copyrighted unless we say its not. So you cant use the stuff except how we say you can on this page or anywhere else on the site without our written permission. And like we said before, its not likely well give you permission anyway. In fact, even if we wanted to, the lawyers are likely to veto any deal anyway. So its better you don''t even ask.</p> <p>2. While we try to include accurate stuff on the site, were not promising you its accurate. In fact, were not promising you anything except fun and entertainment. So if you use stuff on the site, you''re using it at your own risk. Don''t call us if there''s a problem because we assume no liability or responsibility for errors or omissions on the site.</p> <p>3. We and anybody else who helped us create, produce, or deliver the site are not liable for any damages you suffer when you use it. In particular, the lawyers want you to know that our disclaimer includes "direct, incidental, consequential, indirect, or punitive damages arising out of your access to, or use of, the site. Without limiting the foregoing, everything on the site is provided to you AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THEIMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON INFRINGEMENT. Please note that some jurisdictions may not allow the exclusion of implied warranties, so some of the above exclusions may not apply to you. Check your local laws for any restrictions or limitations regarding the exclusion of implied warranties. " Ugh! What a mouthful from the mouthpieces. We put all of that in quotes because we couldn''t figure out any other way to say it that the lawyers would accept. But here''s the bottom line, we''re not responsible if you''re browsing around and the site damages you or your computer or infects it with any nasty viruses. We sure hope that doesn''t happen, but if it does, don''t call us.</p> <p>4. If you don''t want the world to know something, don''t post in on the site in any bulletin board or anyplace else. That''s because anything you disclose to us is ours. That''s right ours. So we can do anything we want with the stuff you post. We can reproduce it, disclose it, transmit it, publish it, broadcast it, and post it someplace else. We can even send it to your mother (as soon as we find her address). Not only that, we can even use any ideas, concepts, know-how, or techniques you post any way we want to, including, developing, manufacturing and marketing products or other stuff using the information you post.</p> <p>5. Pictures of people or places shown on the site are either our property or someone else''s property were using with their permission. No matter what, it''s definitely not your property. You or any of your net-friends can''t use it unless we said you could on this page or somewhere else on the site. And guess what we won''t say yes. So be careful, Bunky, because unauthorized use may violate all sorts of nasty laws. Be smart, keep the stuff you download to yourself.</p> <p>6. There are also a lot of trademarks, logos, and service marks on the site that either we own or were using with someone else''s permission. So don''t think you have any kind of license or right to use them, because you don''t and were not about to give you one. If you don''t leave them alone and mess with our trademarks, logos and service marks on our site, well probably go ballistic, so will the companies that own the other trademarks, logos and service marks. That means that were likely to sue you or to ask a prosecutor to come after you for messing around with our property or the property of others.</p> <p>7. You''ll probably notice we''ve linked our site to lots of others. While that''s cool, it doesn''t mean we''ve looked at all those sites, much less checked them out periodically to see what''s going on. So don''t blame us if some site you link to is bad or has stuff on it that offends you or your pets. Go ahead and link, but remember, you''re doing it at your risk.</p> <p>8. That brings us to what you do on our own site. While we occasionally listen in on chat groups, or look at the posting in our discussion groups or on our bulletin boards, we take no responsibility and assume no liability for the content of those locations or for any mistakes, defamation, libel, slander, omissions, falsehoods, obscenity, pornography, or profanity you might encounter when you visit such places on our site. And don''t be stupid by posting or transmitting any unlawful, threatening, libelous, defamatory, obscene, scandalous, inflammatory, pornographic, nasty, mean, or profane material or any material that law enforcement types may consider a criminal offense, get someone in court on a civil lawsuit, or for that matter violate any law anywhere, anytime. While we certainly respect your privacy, we have no choice but to fully cooperate with any law enforcement authorities or court which might ask us who might have posted nasty stuff on our site.</p> <p>9. Software/Product that we use on this Site is protected by all sorts of patriotic U.S. laws. Because of that, you cant download or send it to anyone in the vacation travel spots of Cuba, Iraq, Libya, North Korea, Iran, Syria, or any other country where United States has embargoed goods; or (get this) to anyone on the United States Treasury Departments list of Specially Designated Nationals, the U.S. Commerce Departments Table of Deny Orders, or the FBIs Most Wanted Internet Creeps List (just kidding on the last one). As if that were not tough enough, if you live in or are a national of any of those lovely places, you''re not even supposed to be reading this page, so beat it!</p> ', '', '2010-11-27 09:01:21', 1, '', '', 'legalpages', '', 0, 0, 0, 0, 0, '', '', '', '', 0, 1, ''),
(8, 0, 'Anti-Spam Policy', 'anti-spam', ' <h2>Anti-Spam Policy</h2> Anti-Spam Policy text goes here.This statement applies to {site_name} websites and services that display or link to this notice ("Services"). {site_name} prohibits the use of the Services in any manner associated with the transmission, distribution or delivery of any unsolicited bulk or unsolicited commercial e-mail ("Spam). You may not use any Services to send Spam. You also may not deliver Spam or cause Spam to be delivered to any of {site_name}s Services or customers.<br /> <br /> In addition, e-mail sent, or caused to be sent, to or through the Services may not:<br /> <br /> 1. Use or contain invalid or forged headers;<br /> 2. Use or contain invalid or non-existent domain names;<br /> 3. Employ any technique to otherwise misrepresent, hide or obscure any information in identifying the point of origin or the transmission path;<br /> 4. Use other means of deceptive addressing;<br /> 5. Use a third party''s internet domain name, or be relayed from or through a third party''s equipment, without permission of the third party;<br /> 6. Contain false or misleading information in the subject line or otherwise contain false or misleading content;<br /> 7. Fail to comply with additional technical standards described below; or<br /> 8. Otherwise violate the applicable Terms of Use for the Services.<br /> <br /> {site_name} does not authorize the harvesting, mining or collection of e-mail addresses or other information from or through the Services. {site_name} does not permit or authorize others to use the Services to collect, compile or obtain any information about {site_name}s customers or subscribers, including but not limited to subscriber e-mail addresses, which are {site_name}s confidential and proprietary information.&nbsp;<br /> <br /> Use of the Services is also subject to the applicable Privacy Statement and Terms of Use.<br /> <br /> {site_name} does not permit or authorize any attempt to use the Services in a manner that could damage, disable, overburden or impair any aspect of any of the Services, or that could interfere with any other party''s use and enjoyment of any Service.<br /> <br /> If {site_name} believes that unauthorized or improper use is being made of any Service, it may, without notice, take such action as it, in its sole discretion, deems appropriate, including blocking messages from a particular internet domain, mail server or IP address. {site_name} may immediately terminate any account on any Service, which it determines, in its sole discretion, is transmitting or is otherwise connected with any e-mail that violates this policy.&nbsp;<br /> <br /> Nothing in this policy is intended to grant any right to transmit or send e-mail to, or through, the Services. Failure to enforce this policy in every instance does not amount to a waiver of {site_name}s rights.<br /> <br /> Unauthorized use of the Services in connection with the transmission of unsolicited e-mail, including the transmission of e-mail in violation of this policy, may result in civil, criminal, or administrative penalties against the sender and those assisting the sender.<br /> ', '', '2010-11-27 09:01:21', 1, '', '', 'legalpages', '', 0, 0, 0, 0, 0, '', '', '', '', 0, 1, '');
INSERT INTO `pages` (`id`, `site_page_id`, `title`, `seftitle`, `text`, `default_text`, `date`, `published`, `description_meta`, `keywords_meta`, `type`, `theme`, `product_id`, `commentable`, `on_footer`, `on_squeezefooter`, `site_id`, `header_code`, `footer_code`, `exit_text`, `orderbutton`, `is_primary`, `to_show`, `coupon_code`) VALUES
(9, 0, 'Affiliate Agreement', 'affiliate-agreement', ' <h2>Affiliate Agreement</h2> <p>PLEASE READ THE ENTIRE AGREEMENT. YOU MAY PRINT THIS PAGE FOR YOUR RECORDS. THIS IS A LEGAL AGREEMENT BETWEEN YOU AND {site_name} at {siteurl_no_prefix}.<br /> </p> <p>BY SUBMITTING THE ONLINE APPLICATION YOU ARE AGREEING THAT YOU HAVE READ AND UNDERSTAND THE TERMS AND CONDITIONS OF THIS AGREEMENT AND THAT YOU AGREE TO BE LEGALLY RESPONSIBLE FOR EACH AND EVERY TERM AND CONDITION.</p> <p><span style="font-weight: bold;">1. Overview</span></p> <p>This Agreement contains the complete terms and conditions that apply to you becoming an affiliate in {siteurl_no_prefix}''s Affiliate Program. The purpose of this Agreement is to allow HL linking between your web site and the {siteurl_no_prefix} web site. Please note that throughout this Agreement, "we," "us," and "our" refer to {siteurl_no_prefix}, and "you," "your," and "yours" refer to the affiliate.</p> <p><span style="font-weight: bold;">2. Affiliate Obligations</span></p> <p>2.1. To begin the enrollment process, you will complete and submit the online application at the ShareASale.com server. The fact that we auto-approve applications does not imply that we may not re-evaluate your application at a later time. We may reject your application at our sole discretion. We may cancel your application if we determine that your site is unsuitable for our Program, including if it:</p> <p>2.1.1. Promotes sexually explicit materials<br /> 2.1.2. Promotes violence<br /> 2.1.3. Promotes discrimination based on race, sex, religion, nationality, disability, sexual orientation, or age<br /> 2.1.4. Promotes illegal activities<br /> 2.1.5. Incorporates any materials which infringe or assist others to infringe on any copyright, trademark or other intellectual property rights or to violate the law<br /> 2.1.6. Includes "Merchant" or variations or misspellings thereof in its domain name<br /> 2.1.7. Is otherwise in any way unlawful, harmful, threatening, defamatory, obscene, harassing, or racially, ethnically or otherwise objectionable to us in our sole discretion.<br /> 2.1.8. Contains software downloads that potentially enable diversions of commission from other affiliates in our program.<br /> 2.1.9. You may not create or design your website or any other website that you operate, explicitly or implied in a manner which resembles our website nor design your website in a manner which leads customers to believe you are {siteurl_no_prefix} or any other affiliated business.</p> <p>2.2. As a member of {siteurl_no_prefix}''s Affiliate Program, you will have access to Affiliate Account Manager. Here you will be able to review our Programs details and previously-published affiliate newsletters, download HL code (that provides for links to web pages within the {siteurl_no_prefix} web site) and banner creatives, browse and get tracking codes for our coupons and deals. In order for us to accurately keep track of all guest visits from your site to ours, you must use the HL code that we provide for each banner, text link, or other affiliate link we provide you with.</p> <p>2.3. {siteurl_no_prefix} reserves the right, at any time, to review your placement and approve the use of Your Links and require that you change the placement or use to comply with the guidelines provided to you.</p> <p>2.4. The maintenance and the updating of your site will be your responsibility. We may monitor your site as we feel necessary to make sure that it is up-to-date and to notify you of any changes that we feel should enhance your performance.</p> <p>2.5. It is entirely your responsibility to follow all applicable intellectual property and other laws that pertain to your site. You must have express permission to use any person''s copyrighted material, whether it be a writing, an image, or any other copyrightable work. We will not be responsible (and you will be solely responsible) if you use another person''s copyrighted material or other intellectual property in violation of the law or any third party rights.</p> <p><span style="font-weight: bold;">3. {siteurl_no_prefix} Rights and Obligations</span></p> <p>3.1. We have the right to monitor your site at any time to determine if you are following the terms and conditions of this Agreement. We may notify you of any changes to your site that we feel should be made, or to make sure that your links to our web site are appropriate and to notify further you of any changes that we feel should be made. If you do not make the changes to your site that we feel are necessary, we reserve the right to terminate your participation in the {siteurl_no_prefix} Affiliate Program.</p> <p>3.2. {siteurl_no_prefix} reserves the right to terminate this Agreement and your participation in the {siteurl_no_prefix} Affiliate Program immediately and without notice to you should you commit fraud in your use of the {siteurl_no_prefix} Affiliate Program or should you abuse this program in any way. If such fraud or abuse is detected, {siteurl_no_prefix} shall not be liable to you for any commissions for such fraudulent sales.</p> <p>3.3. This Agreement will begin upon our acceptance of your Affiliate application, and will continue unless terminated hereunder.</p> <p><span style="font-weight: bold;">4. Termination</span></p> <p>Either you or we may end this Agreement AT ANY TIME, with or without cause, by giving the other party written notice. Written notice can be in the form of mail, email or fax. In addition, this Agreement will terminate immediately upon any breach of this Agreement by you.</p> <p><span style="font-weight: bold;">5. Modification</span></p> <p>We may modify any of the terms and conditions in this Agreement at any time at our sole discretion. In such event, you will be notified by email. Modifications may include, but are not limited to, changes in the payment procedures and {siteurl_no_prefix}''s Affiliate Program rules. If any modification is unacceptable to you, your only option is to end this Agreement. Your continued participation in {siteurl_no_prefix}''s Affiliate Program following the posting of the change notice or new Agreement on our site will indicate your agreement to the changes.</p> <p><span style="font-weight: bold;">6. Payment</span></p> <p>{siteurl_no_prefix} may use third party to handle the tracking and payment. The third party is ____clickbank/paydotcom______ affiliate network. Kindly review the networks payment terms and conditions.</p> <p><span style="font-weight: bold;">7. Access to Affiliate Account Interface</span></p> <p>You will create a password so that you may enter secure affiliate account interface. There, you will be able to receive your reports that will describe our calculation of the commissions due to you.</p> <p><span style="font-weight: bold;">8. Promotion Restrictions</span></p> <p>8.1. You are free to promote your own web sites, but naturally any promotion that mentions {siteurl_no_prefix} could be perceived by the public or the press as a joint effort. You should know that certain forms of advertising are always prohibited by {siteurl_no_prefix}. For example, advertising commonly referred to as "spamming" is unacceptable to us and could cause damage to our name. Other generally prohibited forms of advertising include the use of unsolicited commercial email (UCE), postings to non-commercial newsgroups and cross-posting to multiple newsgroups at once. In addition, you may not advertise in any way that effectively conceals or misrepresents your identity, your domain name, or your return email address. You may use mailings to customers to promote {siteurl_no_prefix} so long as the recipient is already a customer or subscriber of your services or web site, and recipients have the option to remove themselves from future mailings. Also, you may post to newsgroups to promote {siteurl_no_prefix} so long as the news group specifically welcomes commercial messages. At all times, you must clearly represent yourself and your web sites as independent from {siteurl_no_prefix}. If it comes to our attention that you are spamming, we will consider that cause for immediate termination of this Agreement and your participation in the {siteurl_no_prefix} Affiliate Program. Any pending balances owed to you will not be paid if your account is terminated due to such unacceptable advertising or solicitation.</p> <p>8.2. Affiliates that among other keywords or exclusively bid in their Pay-Per-Click campaigns on keywords such as {siteurl_no_prefix}, merchant, www.merchant, www.{siteurl_no_prefix}, and/or any misspellings or similar alterations of these " be it separately or in combination with other keywords " and do not direct the traffic from such campaigns to their own website prior to re-directing it to ours, will be considered trademark violators, and will be banned from Merchants Affiliate Program. We will do everything possible to contact the affiliate prior to the ban. However, we reserve the right to expel any trademark violator from our affiliate program without prior notice, and on the first occurrence of such PPC bidding behavior.</p> <p>8.3. Affiliates are not prohibited from keying in prospects information into the lead form as long as the prospects information is real and true, and these are valid leads (i.e. sincerely interested in Merchants service).</p> <p>8.4. Affiliate shall not transmit any so-called "interstitials, "Parasiteware, "Parasitic Marketing, "Shopping Assistance Application, "Toolbar Installations and/or Add-ons, "Shopping Wallets or "deceptive pop-ups and/or pop-unders to consumers from the time the consumer clicks on a qualifying link until such time as the consumer has fully exited Merchants site (i.e., no page from our site or any {siteurl_no_prefix}s content or branding is visible on the end-users screen). As used herein a. "Parasiteware and "Parasitic Marketing shall mean an application that (a) through accidental or direct intent causes the overwriting of affiliate and non affiliate commission tracking cookies through any other means than a customer initiated click on a qualifying link on a web page or email; (b) intercepts searches to redirect traffic through an installed software, thereby causing, pop ups, commission tracking cookies to be put in place or other commission tracking cookies to be overwritten where a user would under normal circumstances have arrived at the same destination through the results given by the search (search engines being, but not limited to, Google, MSN, Yahoo, Overture, AltaVista, Hotbot and similar search or directory engines); (c) set commission tracking cookies through loading of Merchant site in IFrames, hidden links and automatic pop ups that open {siteurl_no_prefix}s site; (d) targets text on web sites, other than those web sites 100% owned by the application owner, for the purpose of contextual marketing; (e) removes, replaces or blocks the visibility of Affiliate banners with any other banners, other than those that are on web sites 100% owned by the owner of the application.</p> <p><span style="font-weight: bold;">9. Grant of Licenses</span></p> <p>9.1. We grant to you a non-exclusive, non-transferable, revocable right to (i) access our site through HL links solely in accordance with the terms of this Agreement and (ii) solely in connection with such links, to use our logos, trade names, trademarks, and similar identifying material (collectively, the "Licensed Materials") that we provide to you or authorize for such purpose. You are only entitled to use the Licensed Materials to the extent that you are a member in good standing of {siteurl_no_prefix}''s Affiliate Program. You agree that all uses of the Licensed Materials will be on behalf of {siteurl_no_prefix} and the good will associated therewith will inure to the sole benefit of {siteurl_no_prefix}.</p> <p>9.2. Each party agrees not to use the other''s proprietary materials in any manner that is disparaging, misleading, obscene or that otherwise portrays the party in a negative light. Each party reserves all of its respective rights in the proprietary materials covered by this license. Other than the license granted in this Agreement, each party retains all right, title, and interest to its respective rights and no right, title, or interest is transferred to the other.</p> <p><span style="font-weight: bold;">10. Disclaimer</span></p> <p>{siteurl_no_prefix} MAKES NO EXPRESS OR IMPLIED REPRESENTATIONS OR WARRANTIES REGARDING {siteurl_no_prefix} SERVICE AND WEB SITE OR THE PRODUCTS OR SERVICES PROVIDED THEREIN, ANY IMPLIED WARRANTIES OF {siteurl_no_prefix} ABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON-INFRINGEMENT ARE EXPRESSLY DISCLAIMED AND EXCLUDED. IN ADDITION, WE MAKE NO REPRESENTATION THAT THE OPERATION OF OUR SITE WILL BE UNINTERRUPTED OR ERROR FREE, AND WE WILL NOT BE LIABLE FOR THE CONSEQUENCES OF ANY INTERRUPTIONS OR ERRORS.</p> <p><span style="font-weight: bold;">11. Representations and Warranties</span></p> <p>You represent and warrant that:</p> <p>11.1. This Agreement has been duly and validly executed and delivered by you and constitutes your legal, valid, and binding obligation, enforceable against you in accordance with its terms;</p> <p>11.2. You have the full right, power, and authority to enter into and be bound by the terms and conditions of this Agreement and to perform your obligations under this Agreement, without the approval or consent of any other party;</p> <p>11.3. You have sufficient right, title, and interest in and to the rights granted to us in this Agreement.</p> <p><span style="font-weight: bold;">12. Limitations of Liability</span></p> <p>WE WILL NOT BE LIABLE TO YOU WITH RESPECT TO ANY SUBJECT MATTER OF THIS AGREEMENT UNDER ANY CONTRACT, NEGLIGENCE, TORT, STRICT LIABILITY OR OTHER LEGAL OR EQUITABLE THEORY FOR ANY INDIRECT, INCIDENTAL, CONSEQUENTIAL, SPECIAL OR EXEMPLARY DAMAGES (INCLUDING, WITHOUT LIMITATION, LOSS OF REVENUE OR GOODWILL OR ANTICIPATED PROFITS OR LOST BUSINESS), EVEN IF WE HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. FURTHER, NOTWITHSTANDING ANYTHING TO THE CONTRARY CONTAINED IN THIS AGREEMENT, IN NO EVENT SHALL {siteurl_no_prefix}''S CUMULATIVE LIABILITY TO YOU ARISING OUT OF OR RELATED TO THIS AGREEMENT, WHETHER BASED IN CONTRACT, NEGLIGENCE, STRICT LIABILITY, TORT OR OTHER LEGAL OR EQUITABLE THEORY, EXCEED THE TOTAL COMMISSION FEES PAID TO YOU UNDER THIS AGREEMENT.</p> <p><span style="font-weight: bold;">13. Indemnification</span></p> <p>You hereby agree to indemnify and hold harmless {siteurl_no_prefix}, and its subsidiaries and affiliates, and their directors, officers, employees, agents, shareholders, partners, members, and other owners, against any and all claims, actions, demands, liabilities, losses, damages, judgments, settlements, costs, and expenses (including reasonable attorneys'' fees) (any or all of the foregoing hereinafter referred to as "Losses") insofar as such Losses (or actions in respect thereof) arise out of or are based on (i) any claim that our use of the affiliate trademarks infringes on any trademark, trade name, service mark, copyright, license, intellectual property, or other proprietary right of any third party, (ii) any misrepresentation of a representation or warranty or breach of a covenant and agreement made by you herein, or (iii) any claim related to your site, including, without limitation, content therein not attributable to us.</p> <p><span style="font-weight: bold;">14. Confidentiality</span></p> <p>All confidential information, including, but not limited to, any business, technical, financial, and customer information, disclosed by one party to the other during negotiation or the effective term of this Agreement which is marked "Confidential," will remain the sole property of the disclosing party, and each party will keep in confidence and not use or disclose such proprietary information of the other party without express written permission of the disclosing party.</p> <p><span style="font-weight: bold;">15. Miscellaneous</span></p> <p>15.1. You agree that you are an independent contractor, and nothing in this Agreement will create any partnership, joint venture, agency, franchise, sales representative, or employment relationship between you and {siteurl_no_prefix}. You will have no authority to make or accept any offers or representations on our behalf. You will not make any statement, whether on Your Site or any other of Your Site or otherwise, that reasonably would contradict anything in this Section.</p> <p>15.2. Neither party may assign its rights or obligations under this Agreement to any party, except to a party who obtains all or substantially all of the business or assets of a third party.</p> <p>15.3. This Agreement shall be governed by and interpreted in accordance with the laws of the State of New York without regard to the conflicts of laws and principles thereof.</p> <p>15.4. You may not amend or waive any provision of this Agreement unless in writing and signed by both parties.</p> <p>15.5. This Agreement represents the entire agreement between us and you, and shall supersede all prior agreements and communications of the parties, oral or written.</p> <p>15.6. The headings and titles contained in this Agreement are included for convenience only, and shall not limit or otherwise affect the terms of this Agreement.</p> <p>15.7. If any provision of this Agreement is held to be invalid or unenforceable, that provision shall be eliminated or limited to the minimum extent necessary such that the intent of the parties is effectuated, and the remainder of this agreement shall have full force and effect.<br /> </p><br /> ', '', '2010-11-27 09:01:21', 1, '', '', 'legalpages', '', 0, 0, 0, 0, 0, '', '', '', '', 0, 1, ''),
(10, 0, 'Refund Policy', 'refund-policy', ' <h2>Refund Policy<br /> </h2> Refund Policy text goes here.<br /> <br /> ', '', '2010-11-27 09:01:21', 1, '', '', 'legalpages', '', 0, 0, 0, 0, 0, '', '', '', '', 0, 1, '');

-- --------------------------------------------------------

--
-- Table structure for table `pdc_details`
--

DROP TABLE IF EXISTS `pdc_details`;
CREATE TABLE IF NOT EXISTS `pdc_details` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `pdc_session` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `txn_id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `pdc_transaction_id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `site_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `pdc_details`
--


-- --------------------------------------------------------

--
-- Table structure for table `processors`
--

DROP TABLE IF EXISTS `processors`;
CREATE TABLE IF NOT EXISTS `processors` (
  `id` int(11) NOT NULL,
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `vendor` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `key` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `site_id` int(11) NOT NULL,
  PRIMARY KEY (`id`,`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `processors`
--


-- --------------------------------------------------------

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
CREATE TABLE IF NOT EXISTS `products` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `title` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `download_details` text COLLATE utf8_unicode_ci NOT NULL,
  `normal_price` decimal(10,2) NOT NULL,
  `affiliate_commission_percent` int(3) DEFAULT NULL,
  `affiliate_commission_fixed` int(3) DEFAULT NULL,
  `url` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  `processor_id` int(11) NOT NULL,
  `processor_product_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `site_id` int(11) NOT NULL,
  `is_primary` tinyint(1) NOT NULL,
  `salespage` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `exit_offer` tinyint(1) NOT NULL DEFAULT '0',
  `offer_salespage` int(10) NOT NULL,
  `offer_price` decimal(10,2) NOT NULL,
  `offer_processor_product_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `showsalespage` tinyint(1) NOT NULL DEFAULT '0',
  `instantpay` tinyint(1) NOT NULL DEFAULT '0',
  `instant_commission` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ar_email` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `products`
--


-- --------------------------------------------------------

--
-- Table structure for table `product_bonus`
--

CREATE TABLE IF NOT EXISTS `product_bonus` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `bonus_title` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `product_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `bonus_title` (`bonus_title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `product_bonus`
--


-- --------------------------------------------------------

--
-- Table structure for table `qrcode`
--

DROP TABLE IF EXISTS `qrcode`;
CREATE TABLE IF NOT EXISTS `qrcode` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `size` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `qrcode`
--


-- --------------------------------------------------------

--
-- Table structure for table `sales`
--

DROP TABLE IF EXISTS `sales`;
CREATE TABLE IF NOT EXISTS `sales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_time` datetime NOT NULL,
  `transaction_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `product_id` int(11) NOT NULL,
  `download_page_token` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `download_url_token` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `download_expiry_time` int(11) unsigned NOT NULL,
  `affiliate_id` int(11) NOT NULL,
  `affiliate_commission` decimal(10,2) NOT NULL,
  `affiliate_commission_paid_amount` decimal(10,2) NOT NULL,
  `affiliate_commission_paid` tinyint(1) NOT NULL,
  `affiliate_commission_payment_date` date NOT NULL,
  `affiliate_commission_payment_method` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `masspay_file` varchar(48) COLLATE utf8_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `coupon_code` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `payment_method` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `site_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `sales`
--


-- --------------------------------------------------------

--
-- Table structure for table `sites`
--

DROP TABLE IF EXISTS `sites`;
CREATE TABLE IF NOT EXISTS `sites` (
  `id` int(11) NOT NULL,
  `site_name` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `site_url` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `same_server` tinyint(1) NOT NULL,
  `key` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `path_deprecated` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `site_code` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `published` tinyint(1) NOT NULL,
  `admin_email` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `sandbox` tinyint(1) NOT NULL,
  `affiliate` tinyint(1) NOT NULL,
  `affiliate_commission_percent` int(11) NOT NULL,
  `affiliate_commission_fixed` int(11) NOT NULL,
  `helpdesk` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `webmaster_address` text COLLATE utf8_unicode_ci NOT NULL,
  `webmaster_phone` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `admin_fname` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `admin_lname` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `theme` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `host_username` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `host_password` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `folder_path_h` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `folder_path` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `redirect_url` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `mredirect_url` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `ar_email` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `ipn_debug` tinyint(1) NOT NULL,
  `disqus` tinyint(1) NOT NULL DEFAULT '0',
  `facebook` tinyint(1) NOT NULL DEFAULT '0',
  `disqus_shortname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sites`
--


-- --------------------------------------------------------

--
-- Table structure for table `tools`
--

DROP TABLE IF EXISTS `tools`;
CREATE TABLE IF NOT EXISTS `tools` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `category_id` tinyint(4) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `site_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tools`
--


-- --------------------------------------------------------

--
-- Table structure for table `tool_categories`
--

DROP TABLE IF EXISTS `tool_categories`;
CREATE TABLE IF NOT EXISTS `tool_categories` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `tool_categories`
--

INSERT INTO `tool_categories` (`id`, `name`) VALUES
(1, 'Banner'),
(2, 'Email'),
(3, 'Forum'),
(4, 'Tweets'),
(5, 'Reviews'),
(6, 'Pressrelease'),
(7, 'PPCads'),
(8, 'Classified'),
(9, 'Blogposts'),
(10, 'ProductImage'),
(11, 'HtmlCodes');

-- --------------------------------------------------------

--
-- Table structure for table `upsell`
--

DROP TABLE IF EXISTS `upsell`;
CREATE TABLE IF NOT EXISTS `upsell` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `affurl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bannerimage` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `price` int(5) NOT NULL,
  `commission` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `processor` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `upsell`
--


-- --------------------------------------------------------

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `type` tinyint(1) NOT NULL,
  `paypal` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users`
--


--
-- Constraints for dumped tables
--

--
-- Constraints for table `product_bonus`
--
ALTER TABLE `product_bonus`
  ADD CONSTRAINT `product_bonus_ibfk_2` FOREIGN KEY (`bonus_title`) REFERENCES `bonus` (`bonusproduct`) ON UPDATE CASCADE;

/*!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 */;

