query($queryEmailAddress);
$queryMapping = "CREATE TABLE IF NOT EXISTS xyz_em_address_list_mapping (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ea_id` bigint(20) NOT NULL,
`el_id` int(11) NOT NULL,
`create_time` int(30) NOT NULL,
`last_update_time` int(30) NOT NULL,
`status` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";
$wpdb->query($queryMapping);
$queryFieldValues = "CREATE TABLE IF NOT EXISTS xyz_em_additional_field_value (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ea_id` int(11) NOT NULL,
`field1` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ";
$wpdb->query($queryFieldValues);
$queryCampaign = "CREATE TABLE IF NOT EXISTS xyz_em_email_campaign (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` int(1) NOT NULL,
`subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`body` longtext COLLATE utf8_unicode_ci NOT NULL,
`alt_body` longtext COLLATE utf8_unicode_ci NOT NULL,
`list_id` int(11) NOT NULL,
`campaign_template_id` int(11) NOT NULL,
`status` int(2) NOT NULL,
`batch_size` int(11) NOT NULL,
`sender_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sender_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sender_email_id` int(11) NOT NULL,
`last_send_mapping_id` int(11) NOT NULL,
`send_count` int(11) NOT NULL,
`last_fired_time` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`unsubscription_link` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
`start_time` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`track_count` int(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ";
$wpdb->query($queryCampaign);
$queryAttachment = "CREATE TABLE IF NOT EXISTS xyz_em_attachment (
`id` int(11) NOT NULL AUTO_INCREMENT,
`campaigns_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ";
$wpdb->query($queryAttachment);
$queryFieldInfo = "CREATE TABLE IF NOT EXISTS xyz_em_additional_field_info (
`id` int(11) NOT NULL AUTO_INCREMENT,
`field_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` int(1) NOT NULL,
`default_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`options` longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ";
$wpdb->query($queryFieldInfo);
$infoCount = $wpdb->query( 'SELECT default_value FROM xyz_em_additional_field_info WHERE field_name="Name" ' ) ;
if($infoCount == 0){
$wpdb->insert('xyz_em_additional_field_info',array('field_name'=>"Name",'type'=>"0",'default_value'=>"User",'options'=>""),array('%s','%d','%s','%s'));
}
$queryemailTemplate = "CREATE TABLE IF NOT EXISTS xyz_em_email_template (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subject` text COLLATE utf8_unicode_ci NOT NULL,
`message` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";
$wpdb->query($queryemailTemplate);
$emailTemplateWelcomeCount = $wpdb->query( 'SELECT subject FROM xyz_em_email_template WHERE id=1' ) ;
if($emailTemplateWelcomeCount == 0){
$wpdb->insert('xyz_em_email_template',array('id'=>1,'subject'=>"Subscription Active",'message'=>"Hi {field1},
\r\nThank you for subscribing to our list.
\r\nYour subscription is active now.
\r\nRegards
\r\nYoursite.com
\r\n
"),
array('%d','%s','%s'));
}
$emailTemplateWelcomeCount = $wpdb->query( 'SELECT subject FROM xyz_em_email_template WHERE id=2' ) ;
if($emailTemplateWelcomeCount == 0){
$wpdb->insert('xyz_em_email_template',array('id'=>2,'subject'=>"Email Unsubscribed",'message'=>"Hi {field1},
\r\nYour email address has been successfully unsubscribed from our list.
\r\nRegards
\r\nYoursite.com
"),
array('%d','%s','%s'));
}
$emailTemplateWelcomeCount = $wpdb->query( 'SELECT subject FROM xyz_em_email_template WHERE id=3' ) ;
if($emailTemplateWelcomeCount == 0){
$wpdb->insert('xyz_em_email_template',array('id'=>3,'subject'=>"Subscription Pending",'message'=>'Hi {field1},
Thank you for subscribing to our list.
You are one click away from activating your subscription.
Just click the link below to activate your subscription
Confirm now
Regards
Yoursite.com
'),
array('%d','%s','%s'));
}
// add_option('xyz_em_afterSubscription','');
// add_option('xyz_em_emailConfirmation','');
// add_option('xyz_em_redirectAfterLink','');
$the_page_unsubscribe = $wpdb->get_results("SELECT * FROM wp_postmeta WHERE meta_key='xyz_em_unsubscribe_page' AND meta_value='1'");
if (!$the_page_unsubscribe)
{
// Create post object
$_p = array();
$_p['post_title'] = "Email Unsubscribed";
$_p['post_content'] = '[xyz_em_unsubscribe]';
$_p['post_status'] = 'publish';
$_p['post_type'] = 'page';
$_p['comment_status'] = 'closed';
$_p['ping_status'] = 'closed';
$_p['post_category'] = array(1); // the default 'Uncatrgorised'
// Insert the post into the database
$post_id = wp_insert_post($_p);
$meta_key = 'xyz_em_unsubscribe_page';
$meta_value = 1;
add_post_meta($post_id, $meta_key, $meta_value);
$unsubscribeLink = get_permalink( $post_id );
update_option('xyz_em_redirectAfterLink',$unsubscribeLink);
}else{
$the_page_unsubscribe = $the_page_unsubscribe[0];
$pageIdUnsubscribe = $the_page_unsubscribe->post_id;
// $unsubscribeLink = get_permalink( $pageIdUnsubscribe );
// update_option('xyz_em_redirectAfterLink',$unsubscribeLink);
$wpdb->update('wp_posts', array('post_status'=>'publish'), array('id'=>$pageIdUnsubscribe));
}
$the_page_thanks = $wpdb->get_results("SELECT * FROM wp_postmeta WHERE meta_key='xyz_em_thanks_page' AND meta_value='2'");
if (!$the_page_thanks)
{
// Create post object
$_p = array();
$_p['post_title'] = "Email Subscribed";
$_p['post_content'] = '[xyz_em_thanks]';
$_p['post_status'] = 'publish';
$_p['post_type'] = 'page';
$_p['comment_status'] = 'closed';
$_p['ping_status'] = 'closed';
$_p['post_category'] = array(1); // the default 'Uncatrgorised'
// Insert the post into the database
$post_id = wp_insert_post($_p);
$meta_key = 'xyz_em_thanks_page';
$meta_value = 2;
add_post_meta($post_id, $meta_key, $meta_value);
$thanksLink = get_permalink( $post_id );
update_option('xyz_em_afterSubscription',$thanksLink);
}else{
$the_page_thanks = $the_page_thanks[0];
$pageIdThanks = $the_page_thanks->post_id;
// $thanksLink = get_permalink( $pageIdThanks );
// update_option('xyz_em_afterSubscription',$thanksLink);
$wpdb->update('wp_posts', array('post_status'=>'publish'), array('id'=>$pageIdThanks));
}
$the_page_confirm = $wpdb->get_results("SELECT * FROM wp_postmeta WHERE meta_key='xyz_em_confirm_page' AND meta_value='3'");
if (!$the_page_confirm)
{
// Create post object
$_p = array();
$_p['post_title'] = "Subscription Confirmed";
$_p['post_content'] = '[xyz_em_confirm]';
$_p['post_status'] = 'publish';
$_p['post_type'] = 'page';
$_p['comment_status'] = 'closed';
$_p['ping_status'] = 'closed';
$_p['post_category'] = array(1); // the default 'Uncatrgorised'
// Insert the post into the database
$post_id = wp_insert_post($_p);
$meta_key = 'xyz_em_confirm_page';
$meta_value = 3;
add_post_meta($post_id, $meta_key, $meta_value);
$confirmLink = get_permalink( $post_id );
update_option('xyz_em_emailConfirmation',$confirmLink);
}else{
$the_page_confirm = $the_page_confirm[0];
$pageIdConfirm = $the_page_confirm->post_id;
// $confirmLink = get_permalink( $pageIdConfirm );
// update_option('xyz_em_emailConfirmation',$confirmLink);
$wpdb->update('wp_posts', array('post_status'=>'publish'), array('id'=>$pageIdConfirm));
}
//Bug fix:
$wpdb->query( 'delete from xyz_em_address_list_mapping WHERE ea_id=0' ) ;
}
register_activation_hook(XYZ_EM_PLUGIN_FILE,'em_install');
?>