# dbg MySQL-Dump
# version 1.00.00
# http://www.amalla.com
#
# Host: localhost
# Generation Time: Mar 18, 2008 at 11:01 AM 
# Server version: 4.1.22-standard 
# PHP Version: 4.4.4
#
# Database : homebizs_arp3
# --------------------------------------------------------
#
# Table structure for table `arp3_aut`
#
DROP TABLE IF EXISTS `arp3_aut`;
CREATE TABLE `arp3_aut` ( 
	`id` int(11) NOT NULL auto_increment,
	`unsubscribe_link` int(11) NOT NULL ,
	`unsubscribe_all` int(11) NOT NULL ,
	`affiliate_link` int(11) NOT NULL ,
	`email_control` int(11) NOT NULL ,
	`form_control` int(11) NOT NULL ,
	`unsubscribe_confirmation` int(1) NOT NULL ,
	`unsubscribe_reason` int(1) NOT NULL ,
	`subscribe_notify` int(11) NOT NULL ,
	`unsubscribe_notify` int(11) NOT NULL ,
	`allow_duplicates` int(11) NOT NULL ,
	`immediate_message_id` int(11) NOT NULL ,
	`use_double` int(11) NOT NULL ,
	`edit_format` int(11) NOT NULL ,
	`edit_subscription_type` int(11) NOT NULL ,
	`completion` char(1) NOT NULL ,
	`loop_ar` int(11) NOT NULL ,
	`loop_message` int(11) NOT NULL ,
	`loop_interval` int(11) NOT NULL ,
	`use_habeas` int(1) NOT NULL ,
	`status` char(1) NOT NULL ,
	`listens_on` varchar(255) NOT NULL ,
	`unsubscribeaid` varchar(255) NOT NULL ,
	`description` varchar(255) NOT NULL ,
	`published_description` varchar(255) NOT NULL ,
	`reply_name` varchar(255) NOT NULL ,
	`reply_email` varchar(255) NOT NULL ,
	`reply_to` varchar(255) NOT NULL ,
	`optin_success` varchar(255) NOT NULL ,
	`optin_failure` varchar(255) NOT NULL ,
	`v2_id` varchar(255) NOT NULL ,
	`double_subject` varchar(255) NOT NULL ,
	`header_text` text NOT NULL ,
	`html_header_text` text NOT NULL ,
	`footer_text` text NOT NULL ,
	`html_footer_text` text NOT NULL ,
	`message_order` text NOT NULL ,
	`double_text` text NOT NULL ,
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`)
) TYPE= ;

#
# Dumping data for table `arp3_aut`
#
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('1', '1', '0', '1', '1', '1', '', '', '1', '1', '1', '1', '', '', '', 'F', '1', '1', '1', '', 'A', 'tryme', '', 'Test Autoresponder', '', 'Test', 'admin@homebizsoftware.biz', '', '', '', '', 'Subscription Confirmation', '', '', '', '', '|1||2||3|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('2', '1', '0', '1', '1', '1', '', '', '1', '1', '1', '4', '1', '', '', 'A', '1', '1', '1', '', 'A', 'dpcinfo', '', 'Subscribers to Digital Products Club', 'Digital Products Club', 'Digital Products Club', 'admin@homebizsoftware.biz', '', '', '', '', 'Subscription Confirmation', '', '', '', '', '|4||5||6||7|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('3', '1', '0', '1', '1', '1', '', '', '1', '1', '', '0', '1', '', '', 'A', '1', '1', '1', '', 'A', 'member', '', 'Subscribers', 'Member of Home Biz Software', 'SSI Marketing', 'john@homebizsoftware.biz', 'john@homebizsoftware.biz', '', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('4', '1', '0', '1', '1', '1', '', '', '1', '1', '', '0', '1', '', '', 'A', '1', '1', '1', '', 'A', 'blogmarketing', '', 'Complete Cash Lovers Guide to Blog Marketing', 'Blog Marketing', 'John Templin', 'admin@homebizsoftware.biz', 'admin@homebizsoftware.biz', '', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('5', '1', '0', '1', '1', '1', '', '', '1', '1', '', '8', '1', '', '', 'A', '1', '1', '1', '', 'A', 'silostructure', '', 'Silo Structure', 'Silo Structure', 'John Templin', 'john@mms-pro.com', 'john@mms-pro.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '|8|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('6', '1', '0', '1', '1', '1', '', '', '1', '', '', '0', '1', '', '', 'A', '1', '1', '1', '', 'A', 'articlepublisher', '', 'Viral Article Publisher', 'Viral Article Publisher Software', 'John Templin', 'john@homebizsoftware.biz', 'john@homebizsoftware.biz', 'http://mms-pro.com/vipthanks.html', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('7', '1', '0', '1', '1', '1', '', '', '1', '', '1', '0', '1', '', '', 'A', '1', '1', '1', '', 'A', 'snapvideo', '', 'Snap Video Pro', '', 'John Templin', 'sales@digital-products-club.com', 'admin@digital-products-club.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('8', '1', '0', '1', '1', '1', '', '', '1', '', '1', '9', '1', '', '', 'A', '1', '1', '1', '', 'A', 'vmprofits', '', 'Video Marketing Profits', '', 'John Templin', 'admin@homebizsoftware.biz', 'admin@homebizsoftware.biz', 'http://digital-products-club.com/vmpoto.html', 'http://digital-products-club.com', '', 'Subscription Confirmation', '', '', '', '', '|9|', 'Hello\r\n\r\nThank you for requesting Video Marketing Profits book. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser. You will then be taken to your download link.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you,\r\n\r\nJohn Templin\r\nDigital Products Membership Club\r\nhttp://digital-products-club.com\r\n***************************\r\nDigital Videos Articles and Tips\r\nhttp://digital-products-club.com/digitalvideo\r\n');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('9', '1', '0', '1', '1', '1', '', '', '1', '', '1', '11', '1', '', '', 'A', '1', '1', '1', '', 'A', 'bigsystem', '', 'Big System book for Autopilot Profits', 'Big System book for Autopilot Profits', 'John Templin', 'admin@mms-pro.com', 'admin@mms-pro.com', 'http://autopilotprofits.mms-pro.com', '', '', 'Subscription Confirmation', '', '', '', '', '|11|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('10', '1', '0', '1', '1', '1', '', '', '1', '', '', '10', '1', '', '', 'A', '1', '1', '1', '', 'A', 'autopilot', '', 'Autopilot Profits', 'Autopilot Profits', 'John Templin', 'admin@mms-pro.com', 'admin@mms-pro.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('11', '1', '0', '1', '1', '1', '', '', '1', '', '', '12', '1', '1', '', 'A', '1', '1', '1', '', 'A', 'dogob', '', 'Dog Obedience', 'Eliminate Dog Behavior Problems', 'John Templin', 'admin@johntemplin.com', 'admin@johntemplin.com', 'http://dogobedience.johntemplin.com/index3.php', 'http://dogobedience.johntemplin.com/index3.php', '', 'Subscription Confirmation', '', '', '', '', '|12||13||14||15||16||17||18||19||20||21|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('12', '1', '0', '1', '1', '1', '', '', '1', '', '', '22', '1', '', '', 'A', '1', '1', '1', '', 'A', 'videoprofits', '', 'Video Profits Lost Chapter', 'Video Profits', 'John Templin', 'admin@homebizsoftware.biz', 'admin@homebizsoftware.biz', 'http://videoprofits.johntemplin.com', 'http://videoprofits.johntemplin.com', '', 'Subscription Confirmation', '', '', '', '', '|22||23||24|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('13', '1', '0', '1', '1', '1', '', '', '1', '', '', '25', '1', '', '', 'A', '1', '1', '1', '', 'A', 'fatloss', '', 'Fat Loss 4 Idiots', 'Fat Loss 4 Idiots', 'John Templin', 'admin@homebizsoftware.biz', 'admin@homebizsoftware.biz', 'http://fatloss.johntemplin.com/index3.php', '', '', 'Subscription Confirmation', '', '', '', '', '|25||26||27||36|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('14', '1', '0', '1', '1', '1', '', '', '1', '', '', '0', '', '', '', 'A', '1', '1', '1', '', 'A', 'abs', '', 'Love Handles', 'Lose The Love Handles', 'John Templin', 'john@mms-pro.com', 'john@mms-pro.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('15', '1', '0', '1', '1', '1', '', '', '1', '', '', '28', '1', '', '', 'A', '1', '1', '1', '', 'A', 'keywordanalyzer', '', 'Desktop Keyword Analyzer', 'Desktop Keyword Analyzer', 'Digital Products Club', 'admin@digital-products-club.com', 'admin@digital-products-club.com', 'http://digital-products-club.com/keyword.htm', 'http://digital-products-club.com', '', 'Subscription Confirmation', '', '', '', '', '|28|', 'Hello\r\n\r\nThank you for requesting your copy of Desktop Keyword Analyzer. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser. You will immediately be taken to your download page.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('16', '1', '0', '1', '1', '1', '', '', '1', '', '', '29', '1', '', '', 'A', '1', '1', '1', '', 'A', 'digitalproducts', '', 'Digital Products Club', 'Digital Products Club Subscribers', 'John Templin', 'admin@digital-products-club.com', 'admin@digital-products-club.com', 'http://digital-products-club.com/productmakeover.pdf', 'http://digital-products-club.com', '', 'Subscription Confirmation', '', '', '', '', '|29|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('17', '1', '0', '1', '1', '1', '', '', '1', '', '', '30', '', '', '', 'A', '1', '1', '1', '', 'A', 'digitalproductsclub', '', 'Digital Products Club', 'Digital Products Club Subscribers', 'Digital Products Club', 'admin@digital-products-club.com', 'admin@digital-products-club.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '|30|', 'Hello\r\n\r\nThank you for joining my Digital Products Club. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('21', '1', '0', '1', '1', '1', '', '', '1', '', '', '33', '1', '', '', 'A', '1', '1', '1', '', 'A', 'jvm', '', 'JV Manager Version 1 Buyers', 'JV Manager Version 1', 'John Templin', 'john@homebizsoftware.biz', 'john@homebizsoftware.biz', '', '', '', 'Subscription Confirmation', '', '', '', '', '|33|', 'Hello\r\n\r\nThank you for Purchasing JV Manager Version 1. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you,\r\n\r\nJohn Templin\r\nDigital Products Club\r\nhttp://www.Digital-Products-Club.com\r\n');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('18', '1', '0', '1', '1', '1', '', '', '1', '', '', '0', '1', '', '', 'A', '1', '1', '1', '', 'A', 'affiliates', '', 'Affiliate subscribers', 'Digital Products Club Affiliates', 'Digital Products Club', 'admin@digital-products-club.com', 'admin@digital-products-club.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for becoming an affiliate for Digital Products Club. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('19', '1', '0', '1', '1', '1', '', '', '1', '', '', '31', '', '', '', 'A', '1', '1', '1', '', 'A', '47newbievideos', '', '47 Newbie Videos', '47 Newbie Videos. Who Else Wants 47 “Closely Guarded” Videos That’ll Take You From Internet Marketing ‘Zero’ to ‘Hero’…', 'John Templin', 'admin@internet-marketing-estore.com', 'admin@internet-marketing-estore.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '|31|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('20', '1', '0', '1', '1', '1', '', '', '1', '', '', '32', '', '', '', 'A', '1', '1', '1', '', 'A', 'rap_affiliates', '', 'Affiliate subscribers', 'Affiliate subscribers', 'John Templin', 'admin@internet-marketing-estore.com', 'admin@internet-marketing-estore.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '|32|', 'Hello\r\n\r\nThank you for becoming an affiliate for my products. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('22', '1', '0', '1', '1', '1', '', '', '1', '', '', '34', '1', '', '', 'A', '1', '1', '1', '', 'A', 'homebizmktgtips', '', 'Home Business Marketing Tips', 'Home Business Marketing Tips', 'Home Business Marketing Tips', 'admin@digital-products-club.com', 'admin@digital-products-club.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '|34||35|', 'Hello\r\n\r\nThank you for subscribing to my Home Business Marketing Tips eMagazine. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you,\r\n\r\nJohn Templin\r\nDigital Products Club.com\r\n');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('23', '1', '0', '1', '1', '1', '', '', '1', '', '', '0', '1', '', '', 'A', '1', '1', '1', '', 'A', 'membersite', '', 'Membership Site Secrets', 'Membership Site Secrets', 'John Templin', 'admin@homebizsoftware.biz', 'admin@homebizsoftware.biz', 'http://membershipsite.johntemplin.com/index2.html', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('24', '1', '0', '1', '1', '1', '', '', '1', '', '', '0', '', '', '', 'A', '1', '1', '1', '', 'A', 'digitalmembership', '', 'FREE Digital Products Membership', 'FREE Digital Products Membership', 'John Templin', 'admin@digital-products-club.com', 'admin@homebizsoftware.biz', '', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('25', '1', '0', '1', '1', '1', '', '', '1', '', '', '0', '1', '', '', 'A', '1', '1', '1', '', 'A', 'diabetes', '', 'Diabetes - Lower Your Blood Sugar', 'Diabetes - Lower Your Blood Sugar', 'John Templin', 'john@mms-pro.com', 'john@mms-pro.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('26', '1', '0', '1', '1', '1', '', '', '1', '', '', '41', '', '', '', 'A', '1', '1', '1', '', 'A', 'dpm', '', 'Digital Products Membership', 'Digital Products Membership', 'John Templin', 'john@homebizsoftware.biz', 'john@homebizsoftware.biz', '', '', '', 'Subscription Confirmation', '', '', '', '', '|41||47|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('27', '1', '0', '1', '1', '1', '', '', '1', '', '', '42', '1', '', '', 'A', '1', '1', '1', '', 'A', 'viralmktg', '', 'Viral Marketing', 'Viral Marketing', 'John Templin', 'admin@johntemplin.com', 'admin@johntemplin.com', 'http://viralmarketing.johntemplin.com/info/', '', '', 'Subscription Confirmation', '', '', '', '', '|42||43||45||44||46|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('28', '1', '0', '1', '1', '1', '', '', '1', '', '', '37', '1', '', '', 'A', '1', '1', '1', '', 'A', 'wahws', '', 'Work At Home Wealth System', 'Work At Home Wealth System', 'John Templin', 'admin@digital-products-club.com', 'admin@digital-products-club.com', 'http://workathome.johntemplin.com/1089874945.pdf', '', '', 'Subscription Confirmation', '', '', '', '', '|37||38||39||40|', 'Hello\r\n\r\nThank you for requesting our Work At Home Wealth Formula ebook. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser. You will then be taken directly to your download URL.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('29', '1', '0', '1', '1', '1', '', '', '1', '', '', '0', '', '', '', 'A', '1', '1', '1', '', 'A', 'imestoreaff', '', 'IMeStore Affiliates', 'Internet Marketing eStore Affiliates', 'John Templin', 'john@internet-marketing-estore.com', 'john@internet-marketing-estore.com', '', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('30', '1', '0', '1', '1', '1', '', '', '1', '', '', '0', '1', '', '', 'A', '1', '1', '1', '', 'A', 'ewriterpro', '', 'eWriter Pro', 'eWriter Pro PDF Creator', 'John Templin', 'john@homebizsoftware.biz', 'john@homebizsoftware.biz', '', '', '', 'Subscription Confirmation', '', '', '', '', '', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
INSERT INTO `arp3_aut` (`id`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `email_control`, `form_control`, `unsubscribe_confirmation`, `unsubscribe_reason`, `subscribe_notify`, `unsubscribe_notify`, `allow_duplicates`, `immediate_message_id`, `use_double`, `edit_format`, `edit_subscription_type`, `completion`, `loop_ar`, `loop_message`, `loop_interval`, `use_habeas`, `status`, `listens_on`, `unsubscribeaid`, `description`, `published_description`, `reply_name`, `reply_email`, `reply_to`, `optin_success`, `optin_failure`, `v2_id`, `double_subject`, `header_text`, `html_header_text`, `footer_text`, `html_footer_text`, `message_order`, `double_text`)  VALUES ('31', '1', '0', '1', '1', '1', '', '', '1', '', '', '48', '1', '', '', 'A', '1', '1', '1', '', 'A', 'ebookexplosion', '', 'Viral Eabook Explosion Website', 'Viral Eabook Explosion', 'John Templin', 'john@homebizsoftware.biz', 'john@homebizsoftware.biz', '', '', '', 'Subscription Confirmation', '', '', '', '', '|48|', 'Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.');
# --------------------------------------------------------

#
# Table structure for table `arp3_bat`
#
DROP TABLE IF EXISTS `arp3_bat`;
CREATE TABLE `arp3_bat` ( 
	`id` int(11) NOT NULL auto_increment,
	`create_date` int(11) NOT NULL ,
	`header` int(11) NOT NULL ,
	`footer` int(11) NOT NULL ,
	`omit_duplicates` int(11) NOT NULL ,
	`omit_unsubscribers` int(11) NOT NULL ,
	`omit_unconfdouble` int(11) NOT NULL ,
	`email_conf` int(11) NOT NULL ,
	`subscribers` int(11) NOT NULL ,
	`num_sent` int(11) DEFAULT '0' NOT NULL ,
	`num_opened` int(11) DEFAULT '0' NOT NULL ,
	`progress` int(11) DEFAULT '0' NOT NULL ,
	`duplicates_removed` int(11) NOT NULL ,
	`unsubscribe_link` int(11) NOT NULL ,
	`unsubscribe_all` int(11) NOT NULL ,
	`affiliate_link` int(11) NOT NULL ,
	`sessions` int(11) NOT NULL ,
	`runtime` int(11) NOT NULL ,
	`use_habeas` int(1) NOT NULL ,
	`track_opens` int(1) NOT NULL ,
	`confirmation_override` int(1) NOT NULL ,
	`format_preference` char(1) NOT NULL ,
	`send_date` varchar(255) NOT NULL ,
	`status` varchar(255) NOT NULL ,
	`reply_to` varchar(255) NOT NULL ,
	`from_email` varchar(255) NOT NULL ,
	`from_name` varchar(255) NOT NULL ,
	`subject` varchar(255) NOT NULL ,
	`attachments` varchar(255) NOT NULL ,
	`schedule` varchar(255) NOT NULL ,
	`rss_item_title` varchar(255) NOT NULL ,
	`rss_content` varchar(255) NOT NULL ,
	`rss_content_url` varchar(255) NOT NULL ,
	`rss_enclosure_url` varchar(255) NOT NULL ,
	`rss_enclosure_length` varchar(255) NOT NULL ,
	`rss_enclosure_type` varchar(255) NOT NULL ,
	`rss_item_description` text NOT NULL ,
	`plain_text` mediumtext NOT NULL ,
	`html_text` mediumtext NOT NULL ,
	`rss_text` mediumtext NOT NULL ,
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`)
) TYPE= ;

#
# Dumping data for table `arp3_bat`
#
INSERT INTO `arp3_bat` (`id`, `create_date`, `header`, `footer`, `omit_duplicates`, `omit_unsubscribers`, `omit_unconfdouble`, `email_conf`, `subscribers`, `num_sent`, `num_opened`, `progress`, `duplicates_removed`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `sessions`, `runtime`, `use_habeas`, `track_opens`, `confirmation_override`, `format_preference`, `send_date`, `status`, `reply_to`, `from_email`, `from_name`, `subject`, `attachments`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_enclosure_url`, `rss_enclosure_length`, `rss_enclosure_type`, `rss_item_description`, `plain_text`, `html_text`, `rss_text`)  VALUES ('3', '1204818754', '0', '0', '1', '1', '1', '1', '3', '3', '0', '3', '0', '1', '', '1', '1', '10', '0', '', '', 'T', '1205042400', 'C', 'admin@digital-products-club.com', 'john@homebizsoftware.biz', 'John Templin', '{FIRSTNAME}, something BIG Happens Tomorrow.', '', 'SPE', '', '', '', '', '', '', '', 'Hi {FIRSTNAME}\r\n\r\nThis is John Templin.\r\n\r\nFinally, it\'s set to lau`nch tomorrow.\r\n\r\n\r\nRemember a couple of days ago I asked you to\r\nstay tuned for a BIG announcement?\r\n\r\n\r\nFinally, the moment we\'ve all been waiting for\r\nis almost here.\r\n\r\nA massive giveaway launches\r\ntomorrow. Offering tons of gifts:\r\n\r\n-tons of ebooks\r\n-tons of scripts\r\n-tons of everything you\'ve ever wanted\r\n\r\nAll valued at thousands and thousands of dollars\r\nat no cost to you whatsoever.\r\n\r\nI just can\'t hide the excitement. I\'ll shoot you\r\na quick message so you\'ll be the first to know and\r\nget all the freebies.\r\n\r\n\r\nWarmly,\r\n\r\nJohn Templin', '', '');
INSERT INTO `arp3_bat` (`id`, `create_date`, `header`, `footer`, `omit_duplicates`, `omit_unsubscribers`, `omit_unconfdouble`, `email_conf`, `subscribers`, `num_sent`, `num_opened`, `progress`, `duplicates_removed`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `sessions`, `runtime`, `use_habeas`, `track_opens`, `confirmation_override`, `format_preference`, `send_date`, `status`, `reply_to`, `from_email`, `from_name`, `subject`, `attachments`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_enclosure_url`, `rss_enclosure_length`, `rss_enclosure_type`, `rss_item_description`, `plain_text`, `html_text`, `rss_text`)  VALUES ('4', '1204818889', '0', '0', '1', '1', '1', '1', '3', '3', '0', '3', '0', '1', '', '1', '1', '4', '0', '', '', 'T', '1205125200', 'C', 'admin@digital-products-club.com', 'john@homebizsoftware.biz', 'John Templin', 'Its a go {FIRSTNAME}! Just Unveiled :)', '', 'SPE', '', '', '', '', '', '', '', 'My friend Scott Case just released the \r\ninternet\'s most massive giveaway ever:\r\n\r\n\r\nhttp://massivemonthlygiveaway.com/March08/go/58\r\n\r\n\r\nSimply sign up and get the scoop.\r\n\r\n-tons of ebooks\r\n-tons of scripts\r\n-tons of everything you\'ve ever wanted\r\n\r\n\r\nWhere did all these goodies come from?\r\n\r\n\r\nI teamed up with Scott Case who has \r\ncalled in some favors from a whole bunch of top online \r\nmarketers and convinced them all to give you TONS of Products at no cost to you.\r\n\r\n\r\nIt is our way of saying \"thank you\"!\r\n\r\n\r\nThese products are worth thousands and thousands of dollars\r\nand have already made the owners thousands and thousands\r\nof dollars.\r\n\r\nI just can\'t hide the excitement. This is probably the \r\nmost exciting news I\'ve ever shared with you.\r\n\r\nGo get it now!\r\nhttp://massivemonthlygiveaway.com/March08/go/58\r\n\r\n\r\nWarmly,\r\n\r\nJohn Templin', '', '');
INSERT INTO `arp3_bat` (`id`, `create_date`, `header`, `footer`, `omit_duplicates`, `omit_unsubscribers`, `omit_unconfdouble`, `email_conf`, `subscribers`, `num_sent`, `num_opened`, `progress`, `duplicates_removed`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `sessions`, `runtime`, `use_habeas`, `track_opens`, `confirmation_override`, `format_preference`, `send_date`, `status`, `reply_to`, `from_email`, `from_name`, `subject`, `attachments`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_enclosure_url`, `rss_enclosure_length`, `rss_enclosure_type`, `rss_item_description`, `plain_text`, `html_text`, `rss_text`)  VALUES ('5', '1205181898', '0', '0', '1', '1', '1', '1', '3', '3', '0', '3', '0', '1', '', '1', '1', '12', '', '', '', 'T', '1205298000', 'C', 'admin@digital-products-club.com', 'john@homebizsoftware.biz', 'John Templin', '{FIRSTNAME}, Have You Taken The Scoop Yet?', '', 'SPE', '', '', '', '', '', '', '', 'Just a quick reminder: did you get the Massive\r\nGiveaway yet?\r\n\r\n\r\nHow would you like to get tons of resources that you\'d\r\nnormally spend thousands of dollars on?\r\n\r\nAll at no cost to you?\r\n\r\n\r\nSimply join the internet\'s most MASSIVE GIVEAWAY\r\nhttp://massivemonthlygiveaway.com/March08/go/58\r\n\r\n\r\nNothing to pay, just a way of saying \"Thank You!\" for\r\nbeing my subscriber.\r\n\r\n\r\nRemember, we only have a few days left.\r\n\r\n\r\nAfter that it\'s gone forever. Here you go:\r\n\r\nhttp://massivemonthlygiveaway.com/March08/go/58\r\n\r\n\r\n\r\nWarmly,\r\n\r\nJohn Templin\r\n\r\nP.S. - I\'m sure you must be asking asking yourself\r\n\"What\'s the catch?\"\r\n\r\nThere\'s NONE. You simply enter your name and email, \r\nand you will be given instant access to TONS of\r\ngoodies at no cost whatsoever.\r\n\r\nTalk about an internet boom... :)', '', '');
INSERT INTO `arp3_bat` (`id`, `create_date`, `header`, `footer`, `omit_duplicates`, `omit_unsubscribers`, `omit_unconfdouble`, `email_conf`, `subscribers`, `num_sent`, `num_opened`, `progress`, `duplicates_removed`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `sessions`, `runtime`, `use_habeas`, `track_opens`, `confirmation_override`, `format_preference`, `send_date`, `status`, `reply_to`, `from_email`, `from_name`, `subject`, `attachments`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_enclosure_url`, `rss_enclosure_length`, `rss_enclosure_type`, `rss_item_description`, `plain_text`, `html_text`, `rss_text`)  VALUES ('6', '1204819254', '0', '0', '1', '1', '1', '1', '3', '3', '0', '3', '0', '1', '', '1', '1', '8', '0', '', '', 'T', '1205557200', 'C', 'admin@digital-products-club.com', 'john@homebizsoftware.biz', 'John Templin', '{FIRSTNAME}, 2 Days Left For Massive Give-Away', '', 'SPE', '', '', '', '', '', '', '', 'Only two days left for the most MASSIVE GIVEAWAY\r\never\r\n\r\n\r\n\r\nYes, only 2 days.\r\n\r\n\r\nThis is just a quick reminder just in case you\'ve not\r\nhad a chance to take your scoop of MASSIVE GIVEAWAY.\r\n\r\nAfter 2 days, it will be closed forever and you\'ll \r\nhave to pay for it :(\r\n\r\nJust get it now if you haven\'t already. As my way of\r\nsaying thank you for being my subscriber, I\'d not\r\nwant you to miss it. When you succeed, I also \r\nsucceed.\r\n\r\nhttp://massivemonthlygiveaway.com/March08/go/58\r\n\r\n\r\n{FIRSTNAME}, don\'t miss this for any reason. It\'s one\r\nof those once-in-a-lifetime chances that will not come\r\nback.\r\n\r\n\r\nWarmly,\r\n\r\nJohn Templin\r\n\r\nP.S. - I\'m sure you must be asking asking yourself\r\n\"What\'s the catch?\"\r\n\r\nThere\'s NONE. You simply enter your name and email, \r\nand you will be given instant access to TONS of\r\ngoodies at no cost whatsoever.\r\n\r\nTalk about an internet boom... :)', '', '');
INSERT INTO `arp3_bat` (`id`, `create_date`, `header`, `footer`, `omit_duplicates`, `omit_unsubscribers`, `omit_unconfdouble`, `email_conf`, `subscribers`, `num_sent`, `num_opened`, `progress`, `duplicates_removed`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `sessions`, `runtime`, `use_habeas`, `track_opens`, `confirmation_override`, `format_preference`, `send_date`, `status`, `reply_to`, `from_email`, `from_name`, `subject`, `attachments`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_enclosure_url`, `rss_enclosure_length`, `rss_enclosure_type`, `rss_item_description`, `plain_text`, `html_text`, `rss_text`)  VALUES ('2', '1204582588', '0', '0', '1', '1', '1', '1', '5', '2', '0', '2', '0', '1', '', '1', '1', '9', '0', '', '', 'T', '1204783200', 'C', 'john@homebizsoftware.biz', 'john@homebizsoftware.biz', 'John Templin', '{FIRSTNAME}, a Massive Giveaway Happens in 4 days', '', 'SPE', '', '', '', '', '', '', '', 'Hi {FIRSTNAME}\r\n\r\nThis is John Templin.\r\n\r\nSomething very big is happening in the next\r\n4 days.\r\n\r\nAnd it\'s only going to involve a few selected \r\nmarketers. That\'s why I\'m sending you this \r\nprivate invitation as a valued subscriber.\r\n\r\nI was just speaking with Scott Case \r\n(a well-known Internet Marketer), and we both \r\nrealized something very important...\r\n\r\n...and it has to do with you\r\n\r\nYou see, most Marketers could be making a lot \r\nmore money if they only had more traffic coming \r\nto their website.\r\n\r\nand easy access to marketing tools that have \r\nmade other marketers work easier, and made them \r\na lot of money.\r\n\r\nso...\r\n\r\nScott Case has called in some favors \r\nfrom a whole bunch of top online marketers and \r\nconvinced them all to give you TONS of f.ree \r\nProducts and Services at no cost to you. \r\n\r\n-ebooks\r\n-scripts\r\n-memberships\r\n\r\nYou mention it, it\'s there.\r\n\r\nRemember, this is coming in just 4 days. \r\n\r\nStay tuned, I\'ll let you know as soon as this is \r\nreleased. It\'s the most exciting news I\'ve had the\r\nopportunity to share with you in a long time.\r\n\r\nWarmly,\r\n\r\nJohn Templin\r\n\r\nP.S. - You may be wondering, \"what\'s the catch?\" well,\r\nthere ISN\'T one.\r\n\r\nThis is my way of saying thank you for being my \r\nsubscriber, and I hope that you will make lots of money \r\nselling and using those products.', '', '');
INSERT INTO `arp3_bat` (`id`, `create_date`, `header`, `footer`, `omit_duplicates`, `omit_unsubscribers`, `omit_unconfdouble`, `email_conf`, `subscribers`, `num_sent`, `num_opened`, `progress`, `duplicates_removed`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `sessions`, `runtime`, `use_habeas`, `track_opens`, `confirmation_override`, `format_preference`, `send_date`, `status`, `reply_to`, `from_email`, `from_name`, `subject`, `attachments`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_enclosure_url`, `rss_enclosure_length`, `rss_enclosure_type`, `rss_item_description`, `plain_text`, `html_text`, `rss_text`)  VALUES ('7', '1204819368', '0', '0', '1', '1', '1', '1', '3', '3', '0', '3', '0', '1', '', '1', '1', '12', '0', '', '', 'T', '1205643600', 'C', 'admin@digital-products-club.com', 'john@homebizsoftware.biz', 'John Templin', 'Quick Reminder {FIRSTNAME}, Tomorrow Last Day', '', 'SPE', '', '', '', '', '', '', '', 'Only ONE day left for the most MASSIVE GIVEAWAY\r\never. Get it here if you haven\'t yet:\r\n\r\nhttp://massivemonthlygiveaway.com/March08/go/58\r\n\r\n\r\nAfter tomorrow it\'s gone for ever.\r\n\r\n\r\nI\'m out for now {FIRSTNAME}.\r\n\r\n\r\nTake care,\r\n\r\nJohn Templin', '', '');
INSERT INTO `arp3_bat` (`id`, `create_date`, `header`, `footer`, `omit_duplicates`, `omit_unsubscribers`, `omit_unconfdouble`, `email_conf`, `subscribers`, `num_sent`, `num_opened`, `progress`, `duplicates_removed`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `sessions`, `runtime`, `use_habeas`, `track_opens`, `confirmation_override`, `format_preference`, `send_date`, `status`, `reply_to`, `from_email`, `from_name`, `subject`, `attachments`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_enclosure_url`, `rss_enclosure_length`, `rss_enclosure_type`, `rss_item_description`, `plain_text`, `html_text`, `rss_text`)  VALUES ('8', '1204819466', '0', '0', '1', '1', '1', '1', '3', '3', '0', '3', '0', '1', '', '1', '1', '13', '0', '', '', 'T', '1205730000', 'C', 'admin@digital-products-club.com', 'john@homebizsoftware.biz', 'John Templin', '{FIRSTNAME}, Today Last Day For Massive Give-Away', '', 'SPE', '', '', '', '', '', '', '', 'Unfortunately today is the last day for the biggest\r\nMassive Giveaway on the internet ever.\r\n\r\nIf you have not already taken advantage of it, do it\r\nnow. Don\'t hold it for another day.\r\n\r\nIt will not be there tomorrow:\r\n\r\nhttp://massivemonthlygiveaway.com/March08/go/58\r\n\r\n\r\nJust to recap:\r\nHundreds of internet marketers have come out in one of\r\nthe biggest give-away of all time.\r\n\r\nOffering tons of gifts worth thousands of dollars at no\r\ncost to you:\r\n\r\n-tons of ebooks\r\n-tons of scripts\r\n-tons of everything you\'ve ever wanted\r\n\r\n\r\nDon\'t miss this one {FIRSTNAME}.\r\nhttp://massivemonthlygiveaway.com/March08/go/58\r\n\r\nIt will be gone after today and it won\'t come back.\r\n\r\nTake care,\r\n\r\nJohn Templin\r\n\r\nPS: - It\'s always been a pleasure having you as a \r\nsubscriber. I\'ve been quite privileged to extend\r\nthis offer to you. I hope you make tons of money\r\nout of this. Thank you.', '', '');
INSERT INTO `arp3_bat` (`id`, `create_date`, `header`, `footer`, `omit_duplicates`, `omit_unsubscribers`, `omit_unconfdouble`, `email_conf`, `subscribers`, `num_sent`, `num_opened`, `progress`, `duplicates_removed`, `unsubscribe_link`, `unsubscribe_all`, `affiliate_link`, `sessions`, `runtime`, `use_habeas`, `track_opens`, `confirmation_override`, `format_preference`, `send_date`, `status`, `reply_to`, `from_email`, `from_name`, `subject`, `attachments`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_enclosure_url`, `rss_enclosure_length`, `rss_enclosure_type`, `rss_item_description`, `plain_text`, `html_text`, `rss_text`)  VALUES ('9', '1205773629', '0', '0', '1', '1', '1', '1', '14', '14', '2', '14', '0', '1', '', '1', '1', '5', '0', '1', '', 'H', '', 'C', 'john@homebizsoftware.biz', 'john@homebizsoftware.biz', 'John Templin', 'Invite Contributors to Easter JV 2008', '', 'NOW', '', '', '', '', '', '', '', 'Hey {FIRSTNAME},\r\n\r\nI\'ve been given BACK DOOR Access to the famous\r\nEaster JV Giveaway 2008, and this allows me to\r\ninvite a few other people to contribute to the event.\r\n\r\nI know you\'re on my list as my JV Partner so let\'s\r\nblow this thing sky high and build a list of\r\nthousands over the Easter break.\r\n\r\nBrad and Guido are using their magic new system,\r\ncalled Giveaway Manager 2, to handle the event.\r\nIt\'s the system that earned Odinn Sorrenson several\r\nthousands of dollars of cash, on top of thousands\r\nof eager subscribers, in just a few short days.\r\n\r\nIf you want to be part of the event and build your\r\nhuge list of subscribers then Easter JV Giveaway 2008\r\nis going to be the place where your online career\r\nstarts. \r\n\r\nThis event kicks off on March 19th, so Signup here\r\nnow, time is ticking away!\r\n\r\nhttp://easterjv2008.com/contributor.php?id=1659\r\n\r\nTo Your Massive Success!\r\n\r\nJohn\r\n\r\nPS. This is a limited opportunity so be sure to\r\nact now !\r\nhttp://easterjv2008.com/contributor.php?id=1659', '<p><font face=\"Verdana\">Hey {FIRSTNAME},<br>\r\n<br>\r\nI\'ve been given BACK DOOR Access to the famous<br>\r\nEaster JV Giveaway 2008, and this allows me to<br>\r\ninvite a few other people to contribute to the event.<br>\r\n<br>\r\nI know you\'re on my list as my JV Partner so let\'s<br>\r\nblow this thing sky high and build a list of<br>\r\nthousands over the Easter break.<br>\r\n<br>\r\nBrad and Guido are using their magic new system,<br>\r\ncalled Giveaway Manager 2, to handle the event.<br>\r\nIt\'s the system that earned Odinn Sorrenson several<br>\r\nthousands of dollars of cash, on top of thousands<br>\r\nof eager subscribers, in just a few short days.<br>\r\n<br>\r\nIf you want to be part of the event and build your<br>\r\nhuge list of subscribers then Easter JV Giveaway 2008<br>\r\nis going to be the place where your online career<br>\r\nstarts. <br>\r\n<br>\r\nThis event kicks off on March 19th, so Signup here<br>\r\nnow, time is ticking away!<br>\r\n<br>\r\n<a href=\"http://easterjv2008.com/contributor.php?id=1659\">\r\nhttp://easterjv2008.com/contributor.php?id=1659</a></font></p>\r\n<p><font face=\"Verdana\">To Your Massive Success!<br>\r\n<br>\r\nJohn<br>\r\n<br>\r\nPS. This is a limited opportunity so be sure to<br>\r\nact now !<br>\r\n<a href=\"http://easterjv2008.com/contributor.php?id=1659\">\r\nhttp://easterjv2008.com/contributor.php?id=1659</a></font></p>\r\n\r\n<br><br><br><br><br><br><br><br><br><br>', '');
# --------------------------------------------------------

#
# Table structure for table `arp3_cam`
#
DROP TABLE IF EXISTS `arp3_cam`;
CREATE TABLE `arp3_cam` ( 
	`id` int(11) NOT NULL auto_increment,
	`aid` int(11) DEFAULT '0' NOT NULL ,
	`last_message` int(11) NOT NULL ,
	`last_date` int(11) NOT NULL ,
	`subscribe_date` int(11) NOT NULL ,
	`unsubscribe_date` int(11) NOT NULL ,
	`failures` int(11) NOT NULL ,
	`double_status` int(11) NOT NULL ,
	`double_requested` int(11) NOT NULL ,
	`double_confirmed` int(11) NOT NULL ,
	`cron_send` int(1) NOT NULL ,
	`send_confirmation` int(1) NOT NULL ,
	`rss_next` int(1) NOT NULL ,
	`source` char(1) NOT NULL ,
	`subscription_type` char(1) NOT NULL ,
	`format_preference` char(1) NOT NULL ,
	`message_id` varchar(255) NOT NULL ,
	`full_name` varchar(255) NOT NULL ,
	`v2_aid` varchar(255) NOT NULL ,
	`last_name` varchar(255) NOT NULL ,
	`middle_name` varchar(255) NOT NULL ,
	`title` varchar(255) NOT NULL ,
	`first_name` varchar(255) NOT NULL ,
	`import_id` varchar(255) NOT NULL ,
	`import_timestamp` varchar(255) NOT NULL ,
	`status` char(1) NOT NULL ,
	`tracking_tag` varchar(255) NOT NULL ,
	`ip_address` varchar(255) NOT NULL ,
	`email` varchar(200) NOT NULL ,
	`pin` varchar(255) NOT NULL ,
	`hash_pin` varchar(32) NOT NULL ,
	`company` varchar(255) NOT NULL ,
	`department` varchar(255) NOT NULL ,
	`street` varchar(255) NOT NULL ,
	`city` varchar(255) NOT NULL ,
	`state` varchar(255) NOT NULL ,
	`zip` varchar(255) NOT NULL ,
	`country` varchar(255) NOT NULL ,
	`phone1` varchar(255) NOT NULL ,
	`phone2` varchar(255) NOT NULL ,
	`phone3` varchar(255) NOT NULL ,
	`fax1` varchar(255) NOT NULL ,
	`fax2` varchar(255) NOT NULL ,
	`unsubscribe_reason` text NOT NULL ,
	`notes` text NOT NULL ,
	`custom_fields` text NOT NULL ,
	`send_log` text NOT NULL ,
	`batch_codes` text NOT NULL ,
	`link_hit_codes` text NOT NULL ,
	`message_open_codes` text NOT NULL ,
	`batch_hit_codes` text NOT NULL ,
	`batch_open_codes` text NOT NULL ,
	PRIMARY KEY (`id`),
	KEY `email` (`email`),
	KEY `aid_status` (`aid`, `status`),
	KEY `aid_email` (`aid`, `email`),
	KEY `message_id` (`message_id`)
) TYPE= ;

#
# Dumping data for table `arp3_cam`
#
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('188', '26', '1', '1205694208', '1205694208', '0', '0', '0', '0', '0', '0', '0', '0', 'F', 'E', 'D', '1427_238379_623368_928725', '', '', '', '', '', 'Sarah', '', '', 'A', '', '86.132.35.244', 'mamagumdrop@yahoo.co.uk', '1205694208.320280', '9524b091c0c412a0114a9f9067f88322', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '16 Mar 2008 14:03:28|Autoresponder: dpm #1|SENT OK\n', '', '', '', '', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('187', '26', '1', '1205605538', '1205605538', '0', '0', '0', '0', '0', '0', '0', '0', 'F', 'E', 'D', '597559_567826_194552_507661', '', '', '', '', '', 'John', '', '', 'A', '', '68.58.137.52', 'admin@marketingclubpro.com', '1205605538.064880', 'f71db5213883c136d12f603b21e2c1c2', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '15 Mar 2008 13:25:38|Autoresponder: dpm #1|SENT OK\n', '', '', '', '', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('118', '16', '1', '1203493493', '1203388076', '0', '0', '1', '1203388076', '1203493493', '0', '0', '0', 'F', 'E', 'D', '908430_135482_796068_770586', '', '', '', '', '', 'Toni', '', '', 'A', '', '62.162.74.236', 'toni@mail.com.mk', '1203388076.605996', '7d68a05fc7a3876de9e676d284c11c86', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '20 Feb 2008 01:44:53|Autoresponder: digitalproducts #1|SENT OK\n06 Mar 2008 00:00:16|Broadcast: {FIRSTNAME}, a Massive Giveaway Happens in 4 days|SENT OK\n09 Mar 2008 00:00:24|Broadcast: {FIRSTNAME}, something BIG Happens Tomorrow.|SENT OK\n09 Mar 2008 00:00:29|Broadcast: Its a go {FIRSTNAME}! Just Unveiled :)|SENT OK\n12 Mar 2008 00:00:22|Broadcast: {FIRSTNAME}, Have You Taken The Scoop Yet?|SENT OK\n15 Mar 2008 00:00:20|Broadcast: {FIRSTNAME}, 2 Days Left For Massive Give-Away|SENT OK\n16 Mar 2008 00:00:23|Broadcast: Quick Reminder {FIRSTNAME}, Tomorrow Last Day|SENT OK\n17 Mar 2008 00:00:23|Broadcast: {FIRSTNAME}, Today Last Day For Massive Give-Away|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n', '', '', '', '|[2]|[3]|[4]|[5]|[6]|[7]|[8]|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('165', '26', '1', '1205256043', '1205163825', '0', '0', '1', '1205251740', '0', '0', '0', '0', 'F', 'E', 'D', '749661_84579_300111_421268', '', '', '', '', '', 'Barb', '', '', 'A', '', '24.33.70.16', 'bmelloh@cinci.rr.com', '1205163825.609674', '2265f49f0a33e083ec32b08b321d8e84', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '11 Mar 2008 12:20:43|Autoresponder: dpm #1|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n', '', '', '|[41]', '|[9]', '|[9]');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('166', '26', '2', '1205816419', '1205171079', '0', '0', '1', '1205171079', '1205208354', '0', '0', '0', 'F', 'E', 'D', '103902_425674_991863_874292', '', '', '', '', '', 'mark', '', '', 'A', '', '75.12.159.11', 'markt9292@yahoo.com', '1205171079.131993', '5f2dc025c37c5a334a509ecbaefdd5b5', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '10 Mar 2008 23:05:58|Autoresponder: dpm #1|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n18 Mar 2008 00:00:19|Autoresponder: dpm #2|SENT OK\n', '', '', '|[41]|[47]', '|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('172', '26', '1', '1205256071', '1205183892', '0', '0', '1', '1205251783', '1205262505', '0', '0', '0', 'F', 'E', 'D', '238178_867450_294238_21906', '', '', '', '', '', 'Natalie', '', '', 'A', '', '71.198.176.73', 'c_sapphire2000@yahoo.com', '1205183892.674203', 'bd2ce2246d72bcb012b21f7964db66bb', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '11 Mar 2008 12:21:11|Autoresponder: dpm #1|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n', '', '', '|[41]', '|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('168', '26', '2', '1205805609', '1205173535', '0', '0', '1', '1205173536', '1205198948', '0', '0', '0', 'F', 'E', 'D', '752189_250180_325936_58591', '', '', '', '', '', 'Arael', '', '', 'A', '', '67.126.202.101', 'synlady@sbcglobal.net', '1205173535.887096', '18c4d0c97f81e79821fe5de8700e8a2a', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '10 Mar 2008 20:29:09|Autoresponder: dpm #1|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n17 Mar 2008 21:00:09|Autoresponder: dpm #2|SENT OK\n', '', '', '|[41]', '|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('134', '16', '1', '1204652117', '1204651807', '0', '0', '1', '1204651807', '1204652116', '0', '0', '0', 'F', 'E', 'D', '554455_465812_465589_789065', '', '', '', '', '', 'steve', '', '', 'A', '', '41.204.224.33', 'stevomozo@yahoo.com', '1204651806.999917', '645d8981d8d3547c17119dda7d6c057a', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '04 Mar 2008 11:35:17|Autoresponder: digitalproducts #1|SENT OK\n09 Mar 2008 00:00:24|Broadcast: {FIRSTNAME}, something BIG Happens Tomorrow.|SENT OK\n09 Mar 2008 00:00:29|Broadcast: Its a go {FIRSTNAME}! Just Unveiled :)|SENT OK\n12 Mar 2008 00:00:22|Broadcast: {FIRSTNAME}, Have You Taken The Scoop Yet?|SENT OK\n15 Mar 2008 00:00:20|Broadcast: {FIRSTNAME}, 2 Days Left For Massive Give-Away|SENT OK\n16 Mar 2008 00:00:23|Broadcast: Quick Reminder {FIRSTNAME}, Tomorrow Last Day|SENT OK\n17 Mar 2008 00:00:23|Broadcast: {FIRSTNAME}, Today Last Day For Massive Give-Away|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n', '', '', '', '|[3]|[4]|[5]|[6]|[7]|[8]|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('147', '27', '5', '1205449207', '1205082802', '0', '0', '1', '1205082803', '1205082847', '0', '0', '0', 'F', 'E', 'D', '492976_457024_247587_674244', '', '', '', '', '', 'moo', '', '', 'A', '', '91.198.254.100', 'moomarket@gmail.com', '1205082802.908742', '0cee8f0f507825cc55453390b8bbe448', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '09 Mar 2008 14:24:19|Autoresponder: viralmktg #1|SENT OK\n10 Mar 2008 15:00:04|Autoresponder: viralmktg #2|SENT OK\n11 Mar 2008 16:00:17|Autoresponder: viralmktg #3|SENT OK\n12 Mar 2008 17:00:08|Autoresponder: viralmktg #4|SENT OK\n13 Mar 2008 18:00:07|Autoresponder: viralmktg #5|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n', '', '', '', '|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('173', '26', '1', '1205256093', '1205208512', '0', '0', '1', '1205251810', '1205278917', '0', '0', '0', 'F', 'E', 'D', '624879_675925_381404_695322', '', '', '', '', '', 'shauna', '', '', 'A', '', '68.210.4.129', 'hoosierslr@msn.com', '1205208512.912616', 'e76a84ed871f6a46a513aba6592b0bcb', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '11 Mar 2008 12:21:33|Autoresponder: dpm #1|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n', '', '', '|[41]', '|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('174', '26', '2', '1205838011', '1205229171', '0', '0', '1', '1205229171', '1205231931', '0', '0', '0', 'F', 'E', 'D', '906404_81355_379831_804017', '', '', '', '', '', 'Jason', '', '', 'A', '', '144.134.93.115', 'cash2deposit@yahoo.com.au', '1205229171.507661', 'c805de62823f4718cda6be778fbc1740', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '11 Mar 2008 05:38:51|Autoresponder: dpm #1|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n18 Mar 2008 06:00:11|Autoresponder: dpm #2|SENT OK\n', '', '', '|[41]', '|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('175', '26', '1', '1205256110', '1205233187', '0', '0', '1', '1205233187', '1205262103', '0', '0', '0', 'F', 'E', 'D', '280162_33183_383079_825279', '', '', '', '', '', 'Violet', '', '', 'A', '', '4.224.237.223', 'violet2012@gmail.com', '1205233187.703878', 'bd0cbaf7be0ada3b717df2844fcd2051', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '11 Mar 2008 12:21:50|Autoresponder: dpm #1|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n', '', '', '', '|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('176', '26', '1', '1205256130', '1205243498', '0', '0', '1', '1205243498', '0', '0', '0', '0', 'F', 'E', 'D', '672747_836896_941103_831447', '', '', '', '', '', 'Wally', '', '', 'A', '', '70.109.235.121', 'cashhost@earthlink.net', '1205243498.200622', 'bfb3e59c0a755f1b46afdcbf1688416f', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '11 Mar 2008 12:22:10|Autoresponder: dpm #1|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n', '', '', '|[41]', '|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('179', '26', '1', '1205335874', '1205335874', '0', '0', '0', '0', '0', '0', '0', '0', 'F', 'E', 'D', '289346_919989_78844_810102', '', '', '', '', '', 'Bob', '', '', 'A', '', '205.188.116.18', 'bobgulden@aol.com', '1205335874.509343', 'bdb8e11fb8137a2c2cdb63a4e9f80dee', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '12 Mar 2008 10:31:14|Autoresponder: dpm #1|SENT OK\n', '', '', '|[41]', '', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('180', '26', '1', '1205337529', '1205337528', '0', '0', '0', '0', '0', '0', '0', '0', 'F', 'E', 'D', '90806_639474_674482_501749', '', '', '', '', '', 'Arnold', '', '', 'A', '', '152.2.81.112', 'armoorejr@gmail.com', '1205337528.941778', 'd922949499e6c7ae2364fd8895f2b922', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '12 Mar 2008 10:58:49|Autoresponder: dpm #1|SENT OK\n', '', '', '|[41]', '', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('181', '26', '1', '1205531137', '1205531137', '0', '0', '0', '0', '0', '0', '0', '0', 'F', 'E', 'D', '123754_573962_454493_931592', '', '', '', '', '', 'George', '', '', 'A', '', '69.117.229.129', 'gelutz314@optonline.net', '1205531137.373907', '8c2c55d53f32b63f00dbf2b237f445a2', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '14 Mar 2008 16:45:37|Autoresponder: dpm #1|SENT OK\n', '', '', '|[41]', '', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('182', '26', '1', '1205544965', '1205544964', '0', '0', '0', '0', '0', '0', '0', '0', 'F', 'E', 'D', '539522_716521_465430_786111', '', '', '', '', '', 'Donna Kay', '', '', 'A', '', '67.187.12.250', 'donnakay63@gmail.com', '1205544964.653186', '32a38524902a2b401c3c6da224aced0c', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '14 Mar 2008 20:36:05|Autoresponder: dpm #1|SENT OK\n', '', '', '|[41]', '', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('170', '26', '2', '1205784007', '1205175307', '0', '0', '1', '1205175307', '1205178151', '0', '0', '0', 'F', 'E', 'D', '182202_684685_30046_965784', '', '', '', '', '', 'Howard', '', '', 'A', '', '76.178.62.78', 'howard@reseller-profits-vault.com', '1205175307.438737', '06d8b63eaf5e6e07fccb3646a73b3e12', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '10 Mar 2008 14:42:32|Autoresponder: dpm #1|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n17 Mar 2008 15:00:07|Autoresponder: dpm #2|SENT OK\n', '', '', '|[41]|[47]', '|[9]', '|[9]');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('171', '26', '2', '1205784007', '1205177801', '0', '0', '1', '1205177802', '1205179161', '0', '0', '0', 'F', 'E', 'D', '202075_988826_739037_36119', '', '', '', '', '', 'Gabriele', '', '', 'A', '', '67.177.207.117', 'gabriele.kajba@gmx.net', '1205177801.677155', '692265dfd9028df3079fd1efb5678beb', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '10 Mar 2008 14:59:22|Autoresponder: dpm #1|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n17 Mar 2008 15:00:07|Autoresponder: dpm #2|SENT OK\n', '', '', '', '|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('127', '12', '3', '1204700414', '1204520793', '0', '0', '1', '1204520794', '1204520821', '0', '0', '0', 'F', 'E', 'D', '7761_421632_386381_917992', '', '', '', '', '', 'Ken', '', '', 'A', 'videoprofits', '69.105.239.5', 'rock@whitehatguys.com', '1204520793.626620', 'c8c3c61e7060b69c00ba0e713fbed41e', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '02 Mar 2008 23:07:02|Autoresponder: videoprofits #1|SENT OK\n04 Mar 2008 00:00:39|Autoresponder: videoprofits #2|SENT OK\n05 Mar 2008 01:00:14|Autoresponder: videoprofits #3|SENT OK\n06 Mar 2008 00:00:16|Broadcast: {FIRSTNAME}, a Massive Giveaway Happens in 4 days|SENT OK\n09 Mar 2008 00:00:24|Broadcast: {FIRSTNAME}, something BIG Happens Tomorrow.|SENT OK\n09 Mar 2008 00:00:29|Broadcast: Its a go {FIRSTNAME}! Just Unveiled :)|SENT OK\n12 Mar 2008 00:00:22|Broadcast: {FIRSTNAME}, Have You Taken The Scoop Yet?|SENT OK\n15 Mar 2008 00:00:20|Broadcast: {FIRSTNAME}, 2 Days Left For Massive Give-Away|SENT OK\n16 Mar 2008 00:00:23|Broadcast: Quick Reminder {FIRSTNAME}, Tomorrow Last Day|SENT OK\n17 Mar 2008 00:00:23|Broadcast: {FIRSTNAME}, Today Last Day For Massive Give-Away|SENT OK\n17 Mar 2008 12:07:14|Broadcast: Invite Contributors to Easter JV 2008|SENT OK\n', '', '', '', '|[2]|[3]|[4]|[5]|[6]|[7]|[8]|[9]', '');
INSERT INTO `arp3_cam` (`id`, `aid`, `last_message`, `last_date`, `subscribe_date`, `unsubscribe_date`, `failures`, `double_status`, `double_requested`, `double_confirmed`, `cron_send`, `send_confirmation`, `rss_next`, `source`, `subscription_type`, `format_preference`, `message_id`, `full_name`, `v2_aid`, `last_name`, `middle_name`, `title`, `first_name`, `import_id`, `import_timestamp`, `status`, `tracking_tag`, `ip_address`, `email`, `pin`, `hash_pin`, `company`, `department`, `street`, `city`, `state`, `zip`, `country`, `phone1`, `phone2`, `phone3`, `fax1`, `fax2`, `unsubscribe_reason`, `notes`, `custom_fields`, `send_log`, `batch_codes`, `link_hit_codes`, `message_open_codes`, `batch_hit_codes`, `batch_open_codes`)  VALUES ('192', '26', '1', '1205835317', '1205835317', '0', '0', '0', '0', '0', '0', '0', '0', 'F', 'E', 'D', '264275_516084_459391_87403', '', '', '', '', '', 'Jason', '', '', 'A', '', '144.138.73.162', 'cashcreations@yahoo.com.au', '1205835317.629240', '9acf498f5d847045fc60e4dc05f62bf4', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '18 Mar 2008 05:15:17|Autoresponder: dpm #1|SENT OK\n', '', '', '', '', '');
# --------------------------------------------------------

#
# Table structure for table `arp3_fil`
#
DROP TABLE IF EXISTS `arp3_fil`;
CREATE TABLE `arp3_fil` ( 
	`id` int(11) NOT NULL auto_increment,
	`use_from` int(11) NOT NULL ,
	`use_to` int(11) NOT NULL ,
	`negate` int(1) NOT NULL ,
	`order_1` char(1) NOT NULL ,
	`status` varchar(255) NOT NULL ,
	`double_status` varchar(255) NOT NULL ,
	`format` varchar(255) NOT NULL ,
	`link_hit_codes` varchar(255) NOT NULL ,
	`message_open_codes` text NOT NULL ,
	`batch_hit_codes` text NOT NULL ,
	`batch_open_codes` text NOT NULL ,
	`name` varchar(255) NOT NULL ,
	`last_message` varchar(255) NOT NULL ,
	`failures` varchar(255) NOT NULL ,
	`email` varchar(255) NOT NULL ,
	`custom` varchar(255) NOT NULL ,
	`from_day` varchar(255) NOT NULL ,
	`from_month` varchar(255) NOT NULL ,
	`from_year` varchar(255) NOT NULL ,
	`to_day` varchar(255) NOT NULL ,
	`to_month` varchar(255) NOT NULL ,
	`to_year` varchar(255) NOT NULL ,
	`criteria` text NOT NULL ,
	`aid` text NOT NULL ,
	`tt` text NOT NULL ,
	`subtype` text NOT NULL ,
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`)
) TYPE= ;

#
# Dumping data for table `arp3_fil`
#

# --------------------------------------------------------

#
# Table structure for table `arp3_links`
#
DROP TABLE IF EXISTS `arp3_links`;
CREATE TABLE `arp3_links` ( 
	`id` int(11) NOT NULL auto_increment,
	`create_date` int(11) NOT NULL ,
	`link` varchar(255) NOT NULL ,
	`description` varchar(255) NOT NULL ,
	`impressions` int(11) DEFAULT '0' NOT NULL ,
	`clicks` int(11) DEFAULT '0' NOT NULL ,
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`)
) TYPE= ;

#
# Dumping data for table `arp3_links`
#

# --------------------------------------------------------

#
# Table structure for table `arp3_locks`
#
DROP TABLE IF EXISTS `arp3_locks`;
CREATE TABLE `arp3_locks` ( 
	`id` int(11) NOT NULL auto_increment,
	`create_date` int(11) NOT NULL ,
	`lock_type` varchar(255) NOT NULL ,
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`)
) TYPE= ;

#
# Dumping data for table `arp3_locks`
#

# --------------------------------------------------------

#
# Table structure for table `arp3_mes`
#
DROP TABLE IF EXISTS `arp3_mes`;
CREATE TABLE `arp3_mes` ( 
	`id` int(11) NOT NULL auto_increment,
	`aid` int(11) NOT NULL ,
	`use_header` int(11) NOT NULL ,
	`use_footer` int(11) NOT NULL ,
	`track_opens` int(1) NOT NULL ,
	`rss_item_usearheader` int(1) NOT NULL ,
	`rss_item_usearfooter` int(1) NOT NULL ,
	`num_sent` int(11) DEFAULT '0' NOT NULL ,
	`num_opened` int(11) DEFAULT '0' NOT NULL ,
	`subject` varchar(255) NOT NULL ,
	`time_interval` varchar(255) NOT NULL ,
	`default_format` varchar(255) NOT NULL ,
	`attachments` varchar(255) NOT NULL ,
	`cc` varchar(255) NOT NULL ,
	`bcc` varchar(255) NOT NULL ,
	`schedule` varchar(255) NOT NULL ,
	`rss_item_title` varchar(255) NOT NULL ,
	`rss_content` varchar(255) NOT NULL ,
	`rss_content_url` varchar(255) NOT NULL ,
	`rss_item_description` text NOT NULL ,
	`rss_text` mediumtext NOT NULL ,
	`plain_text` mediumtext NOT NULL ,
	`html_text` mediumtext NOT NULL ,
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`)
) TYPE= ;

#
# Dumping data for table `arp3_mes`
#
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('1', '1', '0', '0', '0', '0', '0', '1', '0', 'Test Subject 1', '1', 'T', '', '', '', 'IMM', 'Test Message #1', 'RSS', '', 'This is Test Message #1', '<html>\n<head>\n<title>Test RSS Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#FF6600\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; Test RSS Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is RSS message 1</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>', 'TEST AUTORESPONDER\n\nThis is plain message 1\n\n{NEXT_LINK_TEXT}\n{NEXT_LINK}', '<html>\n<head>\n<title>Test Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#003366\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; Test Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is HTML message 1</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('2', '1', '0', '0', '0', '0', '0', '1', '0', 'Test Subject 2', '1', 'T', '', '', '', 'NEX', 'Test Message #2', 'RSS', '', 'This is Test Message #2', '<html>\n<head>\n<title>Test RSS Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#FF6600\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; Test RSS Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is RSS message 2</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>', 'TEST AUTORESPONDER\n\nThis is plain message 2\n\n{NEXT_LINK_TEXT}\n{NEXT_LINK}', '<html>\n<head>\n<title>Test Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#003366\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; Test Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is HTML message 2</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('3', '1', '0', '0', '0', '0', '0', '1', '0', 'Test Subject 3', '1', 'T', '', '', '', 'NEX', 'Test Message #3', 'RSS', '', 'This is Test Message #3', '<html>\n<head>\n<title>Test RSS Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#FF6600\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; Test RSS Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is RSS message 3</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>', 'TEST AUTORESPONDER\n\nThis is plain message 3', '<html>\n<head>\n<title>Test Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#003366\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; Test Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is HTML message 3</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('4', '2', '', '', '', '', '', '4', '0', 'Welcome {FIRSTNAME}', '1', 'T', '', '', '', 'INT', '', '', '', '', '', 'Hi {FIRSTNAME},\r\n\r\nWelcome to Digital Products Club Membership Site.\r\n\r\n\r\n\r\n{SIGNATURE 1}\r\n', '');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('5', '2', '0', '0', '', '', '', '3', '0', 'Test Subject 1', '1', 'T', '', '', '', 'INT', '', '', '', '', '', 'TEST AUTORESPONDER\n\nThis is plain message 1\n\n{NEXT_LINK_TEXT}\n{NEXT_LINK}', '<html>\n<head>\n<title>Test Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#003366\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; Test Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is HTML message 1</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('6', '2', '0', '0', '', '', '', '3', '0', 'Test Subject 2', '1', 'T', '', '', '', 'NEX', '', '', '', '', '', 'TEST AUTORESPONDER\n\nThis is plain message 2\n\n{NEXT_LINK_TEXT}\n{NEXT_LINK}', '<html>\n<head>\n<title>Test Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#003366\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; Test Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is HTML message 2</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('7', '2', '0', '0', '', '', '', '3', '0', 'Test Subject 3', '1', 'T', '', '', '', 'NEX', '', '', '', '', '', 'TEST AUTORESPONDER\n\nThis is plain message 3', '<html>\n<head>\n<title>Test Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#003366\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; Test Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is HTML message 3</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('8', '5', '', '', '', '', '', '2', '0', 'Here are your download instructions {FIRSTNAME}', '1', 'T', '', '', '', 'INT', '', '', '', '', '', 'Hi {FIRSTNAME},\r\n\r\nThank you for requesting my Report, I hope you find it useful and profitable for you business!\r\n\r\nYou can download your Report at http://mms-pro.com/beyondsilo2.pdf\r\n\r\n{SIGNATURE 1}\r\n\r\n', '');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('9', '8', '', '', '', '', '', '3', '0', 'The Report you requested - {FIRSTNAME}', '1', 'T', '', '', '', 'INT', '', '', '', '', '', 'Hi {FIRSTNAME},\r\n\r\nThank you for requesting my \"Video Marketing Profits\" Report. You can download the report at http://www.digital-products-club.com/vmp.zip\r\n\r\nTo your success,\r\n\r\nJohn Templin\r\n', '');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('12', '11', '', '', '', '', '', '6', '0', 'Have you picked a dog yet?', '1', 'H', '', '', '', 'INT', '', '', '', '', '', 'Hey {FIRSTNAME},\r\n\r\nCongratulations on your decision to become\r\na dog owner.\r\n\r\nYou have joined the ranks of some of the\r\nhappiest people on earth and you are about\r\nto discover that the old maxim \"Man\'s Best\r\nFriend\" is no exaggeration!\r\n\r\nBut there are a LOT of things you need to\r\nbe aware of, as well...\r\n\r\nThings like:\r\n\r\n* Deciding what kind of dog to get...\r\n* Choosing a responsible and reputable breeder...\r\n* Diet and nutrition...\r\n* Choosing a Veterinarian...\r\n* Training and nurturing...\r\n\r\nThe list goes on and on, but don\'t be concerned-\r\n\r\nThat\'s exactly why you have ME!\r\n\r\nIn the coming days, I am going to share with you\r\nmany hard-learned lessons from my own adventures\r\nas a dog owner, but if you\'re the impatient type\r\nlike me, you can cut to the chase and gain access\r\nto hundreds of top dog training secrets right\r\nhere and now:\r\n\r\nhttp://dogobedience.johntemplin.com/index3.php\r\n\r\nIn the power-packed guide to Dog ownership,\r\nSitStayFetch, you will uncover every important\r\naspect to being a proud owner of an obedient\r\ndog and canine companion... things like:\r\n\r\n* The Canine growth stages and how to deal with\r\neach. TIP: They can be much like a human two-year\r\nold at times ;-)\r\n\r\n* Training secrets, including techniques and\r\ncommands to use, and when to use the crate method\r\n(and how)...\r\n\r\n* Understanding your dog’s body language and\r\ncommunicating with her...\r\n\r\n* How to deal with and FIX destructive behavior\r\nlike digging...aggression...biting and nipping...\r\nbarking...\r\n\r\n* And dozens more tips - how to deal with doggy\r\nno-no\'s like jumping on furniture, jealousy,\r\n2 dogs in the same house, even bad breath and\r\nflatulence!\r\n\r\nIn SitStayFetch you will gain the power to have\r\ncomplete mastery over your dog, and develop and\r\nincredibly rich and beautiful bond between you\r\nand your best friend!\r\n\r\nFrankly the powerful secrets to training and\r\ndeveloping the fullest possible relationship\r\nwith your dog contained in SitStayFetch are\r\nimpossible to enumerate fully in one e-mail.\r\n\r\nI strongly urge you to see for yourself. Secure\r\na copy of this powerful guide today, and never\r\nwonder what your dog is thinking again.\r\n\r\nhttp://dogobedience.johntemplin.com/index3.php\r\n\r\nTo Being Best Friends!\r\n\r\nJohn Templin\r\n\r\nPS - Watch your email closely over the next few\r\nweeks, as I will be sending you some powerful\r\ninformation and tips  that you can implement\r\nimmediately, or if you simply cannot wait - just\r\nshortcut the process and grab ALL the powerful\r\ndog training secrets you\'ll need to know,\r\nright here:\r\n\r\nhttp://dogobedience.johntemplin.com/index3.php\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '<html>\r\n\r\n<head>\r\n<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 5.0\">\r\n<meta name=\"ProgId\" content=\"FrontPage.Editor.Document\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">\r\n<title>New Page 3</title>\r\n</head>\r\n\r\n<body>\r\n\r\n<p><font face=\"Verdana\">Hey {FIRSTNAME},<br>\r\n<br>\r\nCongratulations on your decision to become a dog owner.<br>\r\n<br>\r\nYou have joined the ranks of some of the happiest people<br>\r\non earth and you are \r\nabout to discover that the old maxim,<br>\r\n&quot;Man\'s Best Friend&quot; is no exaggeration!<br>\r\n<br>\r\nBut there are a LOT of things you need to be aware of, as well...<br>\r\n<br>\r\nThings like:<br>\r\n<br>\r\n* Deciding what kind of dog to get...<br>\r\n* Choosing a responsible and reputable breeder...<br>\r\n* Diet and nutrition...<br>\r\n* Choosing a Veterinarian...<br>\r\n* Training and nurturing...<br>\r\n<br>\r\nThe list goes on and on, but don\'t be concerned-<br>\r\n<br>\r\nThat\'s exactly why you have ME!<br>\r\n<br>\r\nIn the coming days, I am going to share with you many<br>\r\nhard-learned lessons from \r\nmy own adventures as a dog owner,<br>\r\nbut if you\'re the impatient type like me, you \r\ncan cut to the<br>\r\nchase and gain access to hundreds of top dog training secrets<br>\r\nright here and now:<br>\r\n<br>\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">http://www.johntemplin.com/</a><br>\r\n<br>\r\nIn the power-packed guide to Dog ownership, SitStayFetch,<br>\r\nyou will uncover every \r\nimportant aspect to being a proud owner<br>\r\nof an obedient dog and canine \r\ncompanion... things like:<br>\r\n<br>\r\n* The Canine growth stages and how to deal with each.<br>\r\nTIP: They can be much like \r\na human two-year old at times ;-)<br>\r\n<br>\r\n* Training secrets, including techniques and commands to use,<br>\r\nand when to use \r\nthe crate method (and how)...<br>\r\n<br>\r\n* Understanding your dog’s body language and communicating<br>\r\nwith her...<br>\r\n<br>\r\n* How to deal with and FIX destructive behavior like \r\ndigging...<br>\r\naggression...biting and nipping...barking...<br>\r\n<br>\r\n* And dozens more tips - how to deal with doggy no-no\'s like<br>\r\njumping on \r\nfurniture, jealousy, 2 dogs in the same house, even<br>\r\nbad breath and flatulence!<br>\r\n<br>\r\nIn SitStayFetch you will gain the power to have complete mastery<br>\r\nover your dog, \r\nand develop and incredibly rich and beautiful bond<br>\r\nbetween you and your best \r\nfriend!<br>\r\n<br>\r\nFrankly the powerful secrets to training and developing the fullest<br>\r\npossible \r\nrelationship with your dog contained in SitStayFetch are<br>\r\nimpossible to enumerate \r\nfully in one e-mail.<br>\r\n<br>\r\nI strongly urge you to see for yourself. Secure a copy of this powerful<br>\r\nguide \r\ntoday, and never wonder what your dog is thinking again.<br>\r\n<br>\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">http://www.johntemplin.com/</a><br>\r\n<br>\r\nTo Being Best Friends!<br>\r\n<br>\r\nJohn Templin<br>\r\n<br>\r\nPS - Watch your email closely over the next few weeks, as I will be<br>\r\nsending you \r\nsome powerful information and tips that you can<br>\r\nimplement immediately, or if you \r\nsimply cannot wait - just shortcut<br>\r\nthe process and grab ALL the powerful dog \r\ntraining secrets you\'ll<br>\r\nneed to know, right here:<br>\r\n<br>\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">http://www.johntemplin.com/</a><br>\r\n&nbsp;</font></p>\r\n\r\n</body>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n\r\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('11', '9', '', '', '1', '', '', '0', '1', '{FIRSTNAME Fellow Marketer}, Here is the report you requested', '1', 'T', '', '', '', 'INT', '', '', '', '', '', 'Hi {FIRSTNAME},\r\n\r\nThank you for requesting my Big System to Making Money on the Internet. Please download your ebook at: http://autopilotprofits.mms-pro.com/dnld4567/big.pdf\r\n\r\nIf you have any questions feel free to contact me at: admin@mms-pro.com\r\n\r\nTo Your Success,\r\n\r\nJohn Templin\r\n\r\n=============================================\r\nDigital Videos Blog\r\nDigital Video Articles and Tips\r\nhttp://digital-products-club.com/digitalvideo\r\n=============================================\r\nDigital Products Membership Club\r\nYour Source for Profitable Digital Products\r\nhttp://digital-products-club.com\r\n=============================================\r\nJVManager Version 1\r\nSmall Office/Home Office Automation Software\r\nhttp://SOHO-Automation.com\r\n=============================================\r\n', '');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('13', '11', '', '', '', '', '', '4', '0', 'How\'s the relationship with your dog coming?', '2', 'H', '', '', '', 'INT', '', '', '', '', '', 'Hey {FIRSTNAME},\r\n\r\nI just wanted to check in and see how your dog ownership adventure is coming?\r\n\r\nMyself, I had a couple of problems crop up between me and my best friend not that long ago...\r\n\r\nYou see, my Golden Lab puppy has recently developed an urge to chew my shoes when I\'m out of the house.  I was at my wits end trying to figure out how to cure this *expensive* annoyance.\r\n\r\nLuckily, this behavior, and much more, is covered in exhaustive detail in my OTHER constant companion, SitStayFetch! http://dogobedience.johntemplin.com/index3.php\r\n\r\nHere\'s what I discovered: It\'s my own darn FAULT.\r\n\r\nIt seems that the tug-of-war games we\'ve been playing with an old shoe have taught my dog that it\'s ok to chew shoes.\r\n\r\nSo the pros from SitStayFetch suggested that I stop this, and further, that I make sure my dog had plenty of her own toys to chew.  They also suggested that I treat the old shoe with a bitter apple solution that you can pick up for next to nothing at your local pet store.\r\n\r\nIn addition, she needs to get plenty of exercise before I leave for the day, and if I\'m going to be gone a long time, it is important that I have someone come by and let her out to run a bit, because as it turns out...\r\n\r\nThis destructive behavior is not your dog trying to be mean or anything... It\'s usually because they are BORED.\r\n\r\nOnce I put these suggestions into practice, it wasn\'t a matter of but a few days, and my dog quit chewing my shoes completely.\r\n\r\nNow it\'s hard to argue with results like that!\r\n\r\nIf you\'re struggling with problems with your puppy or dog, then don\'t waste another second before grabbing your copy of SitStayFetch. It\'s available for instant download so you\'ll get the answers you need immediately!\r\n\r\nhttp://dogobedience.johntemplin.com/index3.php\r\n\r\nTo Being Best Friends!\r\n\r\nJohn Templin\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '<html>\r\n\r\n<head>\r\n<meta http-equiv=\"Content-Language\" content=\"en-us\">\r\n<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 5.0\">\r\n<meta name=\"ProgId\" content=\"FrontPage.Editor.Document\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">\r\n<title>New Page 1</title>\r\n</head>\r\n\r\n<body>\r\n\r\n<p><font face=\"Verdana\">Hey {FIRSTNAME},<br>\r\n&nbsp;</font></p><font face=\"Verdana\">I just wanted to check in and see how your dog ownership adventure<br>\r\nis coming?<br>\r\n<br>\r\nMyself, I had a couple of problems crop up between me and my best <br>\r\nfriend not that long ago...<br>\r\n<br>\r\nYou see, my Golden Lab puppy has recently developed an urge to chew<br>\r\nmy shoes when I\'m out of the house. I was at my wits end trying to figure<br>\r\nout how to cure this *expensive* annoyance.<br>\r\n<br>\r\nLuckily, this behavior, and much more, is covered in exhaustive detail in my<br>\r\nOTHER constant companion, SitStayFetch!\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">\r\nhttp://www.johntemplin.com/</a><br>\r\n<br>\r\nHere\'s what I discovered: It\'s my own darn FAULT.<br>\r\n<br>\r\nIt seems that the tug-of-war games we\'ve been playing with an old shoe<br>\r\nhave taught my dog that it\'s ok to chew shoes.<br>\r\n<br>\r\nSo the pros from SitStayFetch suggested that I stop this, and further, that I<br>\r\nmake sure my dog had plenty of her own toys to chew. They also suggested<br>\r\nthat I treat the old shoe with a bitter apple solution that you can pick up for<br>\r\nnext to nothing at your local pet store.<br>\r\n<br>\r\nIn addition, she needs to get plenty of exercise before I leave for the day,<br>\r\nand if I\'m going to be gone a long time, it is important that I have someone<br>\r\ncome by and let her out to run a bit, because as it turns out...<br>\r\n<br>\r\nThis destructive behavior is not your dog trying to be mean or anything...<br>\r\nIt\'s usually because they are BORED.<br>\r\n<br>\r\nOnce I put these suggestions into practice, it wasn\'t a matter of but a few days, and my dog quit chewing my shoes completely.<br>\r\n<br>\r\nNow it\'s hard to argue with results like that!<br>\r\n<br>\r\nIf you\'re struggling with problems with your puppy or dog, then don\'t waste<br>\r\nanother second before grabbing your copy of SitStayFetch. It\'s available for<br>\r\ninstant download so you\'ll get the answers you need immediately!<br>\r\n<br>\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">\r\nhttp://www.johntemplin.com/</a><br>\r\n<br>\r\nTo Being Best Friends!<br>\r\n<br>\r\nJohn Templin<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n&nbsp;</font></p>\r\n\r\n</body>\r\n\r\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('14', '11', '', '', '', '', '', '4', '0', 'Do you know what your dog is saying?', '2', 'H', '', '', '', 'INT', '', '', '', '', '', 'Hey {FIRSTNAME},\r\n\r\nWere you aware that when your dog\'s ears are slightly flat to her head and pulled back that she is probably feeling anxious?\r\n\r\nAnd how about when she narrows her eyes, and leaves a lot of the whites showing?\r\n\r\nWell, chances are she\'s afraid or submissive!\r\n\r\nThese and hundreds of other useful and helpful body language tips are covered in detail in the incredible guide to everything dog, SitStayFetch.\r\n\r\nhttp://dogobedience.johntemplin.com/index3.php\r\n\r\nIn SitStayFetch you\'ll discover:\r\n\r\n* That the \"grinning\" dog you think looks so happy may actually be exhibiting anxiety...\r\n\r\n* That tail wagging can mean several things depending on how the tail is held- not all of them happy...\r\n\r\n* That rolling over doesn\'t mean playtime - it means submission...\r\n\r\n* And hundreds more useful and interesting facts about your dog.\r\n\r\nI have learned SO much from this incredible guide, I can\'t even begin to tell you. And the effect it\'s had on my relationship with my dog has been profound.\r\n\r\nNo more do I say \"I wonder what she\'s thinking\". I usually KNOW.\r\n\r\nYour dog is actually talking to you!\r\n\r\nAre you listening?\r\n\r\nhttp://dogobedience.johntemplin.com/index3.php\r\n\r\nTo Talking To Your Best Friend!\r\n\r\nJohn Templin\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '<html>\r\n\r\n<head>\r\n<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 5.0\">\r\n<meta name=\"ProgId\" content=\"FrontPage.Editor.Document\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">\r\n<title>New Page 3</title>\r\n</head>\r\n\r\n<body>\r\n\r\n<p><font face=\"Verdana\">Hey {FIRSTNAME},<br>\r\n<br>\r\nWere you aware that when your dog\'s ears are slightly flat to her<br>\r\nhead and \r\npulled back that she is probably feeling anxious?<br>\r\n<br>\r\nAnd how about when she narrows her eyes, and leaves a lot of<br>\r\nthe whites showing?<br>\r\n<br>\r\nWell, chances are she\'s afraid or submissive!<br>\r\n<br>\r\nThese and hundreds of other useful and helpful body language<br>\r\ntips are covered in \r\ndetail in the incredible guide to everything<br>\r\ndog, SitStayFetch.<br>\r\n<br>\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">http://www.johntemplin.com/</a><br>\r\n<br>\r\nIn SitStayFetch you\'ll discover:<br>\r\n<br>\r\n* That the &quot;grinning&quot; dog you think looks so happy may actually<br>\r\nbe exhibiting \r\nanxiety...<br>\r\n<br>\r\n* That tail wagging can mean several things depending on how the<br>\r\ntail is held- \r\nnot all of them happy...<br>\r\n<br>\r\n* That rolling over doesn\'t mean playtime - it means submission...<br>\r\n<br>\r\n* And hundreds more useful and interesting facts about your dog.<br>\r\n<br>\r\nI have learned SO much from this incredible guide, I can\'t even<br>\r\nbegin to tell \r\nyou. And the effect it\'s had on my relationship with<br>\r\nmy dog has been profound.<br>\r\n<br>\r\nNo more do I say &quot;I wonder what she\'s thinking&quot;. I usually KNOW.<br>\r\n<br>\r\nYour dog is actually talking to you!<br>\r\n<br>\r\nAre you listening?<br>\r\n<br>\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">http://www.johntemplin.com/</a><br>\r\n<br>\r\nTo Talking To Your Best Friend!<br>\r\n<br>\r\nJohn Templin<br>\r\n&nbsp;</p>\r\n\r\n</body>\r\n</font><font face=\"Verdana\">\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n<br>\r\n</font>\r\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('15', '11', '', '', '', '', '', '4', '0', 'You are what you eat, so is your dog!', '2', 'H', '', '', '', 'INT', '', '', '', '', '', 'Hey {FIRSTNAME},\r\n\r\nThe old maxim of \"you are what you eat\" applies equally to your dog!\r\n\r\nThat\'s why there are some great tips in my \"doggy bible\", SitStayFetch, that cover everything you need to know about canine feeding and nutrition.\r\n\r\nhttp://dogobedience.johntemplin.com/index3.php\r\n\r\nA lot of people advocate \"free-feeding\", but the pros at SitStayFetch believe that you should have regular feeding times for your dog, and they suggest that you feed AFTER you feed your family.\r\n\r\nTheir experience is this: Not only do you get your dog accustomed to a regular, balanced, and healthy eating schedule, but by feeding them after YOU...\r\n\r\nYou also reinforce the pecking order- you help establish and maintain your dominance over the dog in the pack, which is critical to controlling your dog\'s behavior, and can head off all SORTS of bad habits, like chewing, aggression, dominance issues, etc.\r\n\r\nSo by simply making a small change in my dog\'s feeding routine, I was able to settle my dog down, assert control in a gentle and non-combative way, and also control her weight while still keeping her happy and well fed!\r\n\r\nThis and hundreds of more bits of incredibly useful doggy wisdom can be had in the powerful SitStayFetch...\r\n\r\nGet your copy today, and get on your way to an incredibly rich and rewarding experience with your best pal.\r\n\r\nQuit flying blind...\r\n\r\nhttp://dogobedience.johntemplin.com/index3.php\r\n\r\nTo A Healthy And Happy Best Friend!\r\n\r\nJohn Templin\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '<html>\r\n\r\n<head>\r\n<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 5.0\">\r\n<meta name=\"ProgId\" content=\"FrontPage.Editor.Document\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">\r\n<title>New Page 3</title>\r\n</head>\r\n\r\n<body>\r\n\r\n<p><font face=\"Verdana\">Hey {FIRSTNAME},<br>\r\n<br>\r\nThe old maxim of &quot;you are what you eat&quot; applies equally to your dog!<br>\r\n<br>\r\nThat\'s why there are some great tips in my &quot;doggy bible&quot;, SitStayFetch,<br>\r\nthat \r\ncover everything you need to know about canine feeding and nutrition.<br>\r\n<br>\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">\r\nhttp://www.johntemplin.com/</a><br>\r\n<br>\r\nA lot of people advocate &quot;free-feeding&quot;, but the pros at SitStayFetch<br>\r\nbelieve \r\nthat you should have regular feeding times for your dog, and they<br>\r\nsuggest that \r\nyou feed AFTER you feed your family.<br>\r\n<br>\r\nTheir experience is this: Not only do you get your dog accustomed to a<br>\r\nregular, \r\nbalanced, and healthy eating schedule, but by feeding them after YOU...<br>\r\n<br>\r\nYou also reinforce the pecking order- you help establish and maintain<br>\r\nyour \r\ndominance over the dog in the pack, which is critical to controlling your<br>\r\ndog\'s \r\nbehavior, and can head off all SORTS of bad habits, like chewing,<br>\r\naggression, \r\ndominance issues, etc.<br>\r\n<br>\r\nSo by simply making a small change in my dog\'s feeding routine, I was able<br>\r\nto \r\nsettle my dog down, assert control in a gentle and non-combative way,<br>\r\nand also \r\ncontrol her weight while still keeping her happy and well fed!<br>\r\n<br>\r\nThis and hundreds of more bits of incredibly useful doggy wisdom can be<br>\r\nhad in \r\nthe powerful SitStayFetch...<br>\r\n<br>\r\nGet your copy today, and get on your way to an incredibly rich and rewarding<br>\r\nexperience with your best pal.<br>\r\n<br>\r\nQuit flying blind...<br>\r\n<br>\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">\r\nhttp://www.johntemplin.com/</a><br>\r\n<br>\r\nTo A Healthy And Happy Best Friend!<br>\r\n<br>\r\nJohn Templin<br>\r\n&nbsp;</font></p>\r\n\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n\r\n</body>\r\n\r\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('16', '11', '', '', '', '', '', '4', '0', 'If you want your dog to listen to you...', '2', 'H', '', '', '', 'INT', '', '', '', '', '', 'Hey {FIRSTNAME},\r\n\r\nIf you want obedience from your dog, there are a few tips\r\nthat the pros from SitStayFetch http://dogobedience.johntemplin.com/index3.php say that YOU\r\nneed to do to make sure that you get your message across...\r\n\r\nFirst thing: BE CONSISTENT.\r\n\r\nThis is SO critical- your dog is going to get very confused\r\nif everyone in the household uses different commands, praise,\r\nand scolding to get the same point across-\r\n\r\nYou need to have a plan, and everyone needs to be following it,\r\nor you will just confuse her.\r\n\r\nAnd how will a confused dog react?\r\n\r\nWell, usually the same way as a confused child...\r\n\r\nThey\'ll IGNORE YOU.\r\n\r\nSecond thing: BOND WITH YOUR DOG\r\n\r\nSpend as much quality time with your dog as you can.\r\nGo for walks, runs, whatever, but do something! The more\r\ntime you spend with your dog, the deeper the feeling she\r\nwill have for you, and the greater respect.\r\n\r\nThese are just a couple of the most important things I\'ve\r\ndiscovered in SitStayFetch that have opened my eyes to\r\na whole new level of love and interaction with my dog...\r\n\r\nAnd I would love for you to discover the incredible\r\nrichness that your relationship with your best friend could\r\nbecome, if you just knew what she was telling you...\r\n\r\nGo and get your copy right now, and discover how to\r\nbecome a \"dog whisperer\" in your own right.\r\n\r\nhttp://dogobedience.johntemplin.com/index3.php\r\n\r\nTo Being Best Friends!\r\n\r\nJohn Templin\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '<html>\r\n\r\n<head>\r\n<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 5.0\">\r\n<meta name=\"ProgId\" content=\"FrontPage.Editor.Document\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">\r\n<title>New Page 3</title>\r\n</head>\r\n\r\n<body>\r\n\r\n<p><font face=\"Verdana\">Hey {FIRSTNAME},<br>\r\n<br>\r\nIf you want obedience from your dog, there are a few tips that the pros<br>\r\nfrom SitStayFetch say that YOU need to do to make sure that you get<br>\r\nyour message \r\nacross...</font></p>\r\n<p><font face=\"Verdana\">\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">\r\nhttp://www.johntemplin.com/</a></font></p>\r\n\r\n<p><font face=\"Verdana\">First thing: BE CONSISTENT.<br>\r\n<br>\r\nThis is SO critical- your dog is going to get very confused if everyone in<br>\r\nthe \r\nhousehold uses different commands, praise, and scolding to get the<br>\r\nsame point \r\nacross-<br>\r\n<br>\r\nYou need to have a plan, and everyone needs to be following it, or you<br>\r\nwill just \r\nconfuse her.<br>\r\n<br>\r\nAnd how will a confused dog react?<br>\r\n<br>\r\nWell, usually the same way as a confused child...<br>\r\n<br>\r\nThey\'ll IGNORE YOU.<br>\r\n<br>\r\nSecond thing: BOND WITH YOUR DOG<br>\r\n<br>\r\nSpend as much quality time with your dog as you can. Go for walks,<br>\r\nruns, \r\nwhatever, but do something! The more time you spend with your dog,<br>\r\nthe deeper \r\nthe feeling she will have for you, and the greater respect.<br>\r\n<br>\r\nThese are just a couple of the most important things I\'ve discovered in<br>\r\nSitStayFetch that have opened my eyes to a whole new level of love and<br>\r\ninteraction with my dog...<br>\r\n<br>\r\nAnd I would love for you to discover the incredible richness that your<br>\r\nrelationship with your best friend could become, if you just knew what<br>\r\nshe was \r\ntelling you...<br>\r\n<br>\r\nGo and get your copy right now, and discover how to become a<br>\r\n&quot;dog whisperer&quot; in \r\nyour own right.<br>\r\n<br>\r\n&nbsp;</font></p>\r\n\r\n<p><font face=\"Verdana\">\r\n<a href=\"http://dogobedience.johntemplin.com/index3.php\">\r\nhttp://www.johntemplin.com/</a></font></p>\r\n\r\n<p><font face=\"Verdana\">To Being Best Friends!<br>\r\n<br>\r\nJohn Templin<br>\r\n&nbsp;</font></p>\r\n\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n\r\n</body>\r\n\r\n</html>');
INSERT INTO `arp3_mes` (`id`, `aid`, `use_header`, `use_footer`, `track_opens`, `rss_item_usearheader`, `rss_item_usearfooter`, `num_sent`, `num_opened`, `subject`, `time_interval`, `default_format`, `attachments`, `cc`, `bcc`, `schedule`, `rss_item_title`, `rss_content`, `rss_content_url`, `rss_item_description`, `rss_text`, `plain_text`, `html_text`)  VALUES ('17', '11', '', '', '', '', '', '4', '0', 'You don\'t have to act like a dog...', '2', 'H', '', '', '', 'INT', '', '', '', '', '', 'Hey {FIRSTNAME},\r\n\r\nWhen you\'re training 