ID == get_option('ALO_em_subsc_page')) unset ($pages[$i]);
}
return $pages;
}
/**
* Manage the user's page 'Your courses'
*/
function ALO_em_subscr_page ($atts, $content = null) {
ob_start();
include(ABSPATH . 'wp-content/plugins/alo-easymail/easymail-subscr-page.php');
$contents = ob_get_contents();
ob_end_clean();
return $contents;
}
add_shortcode('ALO-EASYMAIL-PAGE', 'ALO_em_subscr_page');
/*************************************************************************
* SUBSCRIPTION FUNCTIONS
*************************************************************************/
// Check is there is already a subscriber with that email and return ID subscriber
function ALO_em_is_subscriber($email) {
global $wpdb;
$is_subscriber = $wpdb->get_var( $wpdb->prepare("SELECT ID FROM {$wpdb->prefix}easymail_subscribers WHERE email='%s' LIMIT 1", $email) );
return (($is_subscriber)? $is_subscriber : 0); // ID in db tab subscribers
}
// Check the state of a subscriber (active/not-active)
function ALO_em_check_subscriber_state($email) {
global $wpdb;
$is_activated = $wpdb->get_var( $wpdb->prepare("SELECT active FROM {$wpdb->prefix}easymail_subscribers WHERE email='%s' LIMIT 1", $email) );
return $is_activated;
}
// Modify the state of a subscriber (active/not-active) (BY ADMIN)
function ALO_em_edit_subscriber_state_by_id($id, $newstate) {
global $wpdb;
$output = $wpdb->update( "{$wpdb->prefix}easymail_subscribers",
array ( 'active' => $newstate ),
array ( 'ID' => $id)
);
return $output;
}
// Modify the state of a subscriber (active/not-active) (BY SUBSCRIBER)
function ALO_em_edit_subscriber_state_by_email($email, $newstate="1", $unikey) {
global $wpdb;
$output = $wpdb->update( "{$wpdb->prefix}easymail_subscribers",
array ( 'active' => $newstate ),
array ( 'email' => $email, 'unikey' => $unikey )
);
return $output;
}
// Add a new subscriber
function ALO_em_add_subscriber($email, $name, $newstate=0) {
global $wpdb;
// if there is NOT a subscriber with this email address: add new subscriber and send activation email
if (ALO_em_is_subscriber($email) == false){
$unikey = substr(md5(uniqid(rand(), true)), 0,24); // a personal key to manage the subscription
// try to send activation mail, otherwise will not add subscriber
if ($newstate == 0) {
if ( !ALO_em_send_activation_email($email, $name, $unikey) ) return false;
}
$wpdb->insert ("{$wpdb->prefix}easymail_subscribers",
array( 'email' => $email, 'name' => $name, 'join_date' => date("Y-m-d H:i:s"), 'active' => $newstate, 'unikey' => $unikey)
);
return true;
} else {
// if there is ALREADY a subscriber with this email address, and if is NOT confirmed yet: re-send an activation email
if ( ALO_em_check_subscriber_state($email) == 0) {
// retrieve existing unique key
$exist_unikey = $wpdb->get_var( $wpdb->prepare("SELECT unikey FROM {$wpdb->prefix}easymail_subscribers WHERE ID='%s' LIMIT 1", ALO_em_is_subscriber($email) ) );
if ( ALO_em_send_activation_email($email, $name, $exist_unikey) ) {
// update join date to today
$output = $wpdb->update( "{$wpdb->prefix}easymail_subscribers",
array ( 'join_date' => date("Y-m-d H:i:s") ),
array ( 'ID' => ALO_em_is_subscriber($email) )
);
return true;
} else {
return false;
}
} else {
return false;
}
}
}
// Delete a subscriber (BY ADMIN/REGISTERED-USER)
function ALO_em_delete_subscriber_by_id($id) {
global $wpdb;
$output = $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}easymail_subscribers WHERE ID=%d LIMIT 1", $id ) );
return $output;
}
// Delete a subscriber (BY SUBSCRIBER)
function ALO_em_delete_subscriber_by_email($email, $unikey) {
global $wpdb;
$output = $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}easymail_subscribers WHERE email='%s' AND unikey='%s' LIMIT 1", $email, $unikey ) );
return $output;
}
// Check if can access subscription page (BY SUBSCRIBER) (check EMAIL<->UNIKEY)
// @action activate|unsubscribe
function ALO_em_can_access_subscrpage ($email, $unikey) {
global $wpdb;
// check if email and unikey match
$check = $wpdb->get_var( $wpdb->prepare("SELECT ID FROM {$wpdb->prefix}easymail_subscribers WHERE email='%s' AND unikey='%s' LIMIT 1", $email, $unikey) );
if ($check == true) {
return true;
} else {
return false;
}
//return true;
}
// Send email with activation link
function ALO_em_send_activation_email($email, $name, $unikey) {
// Headers
$mail_sender = "noreply@". str_replace("www.","", $_SERVER['HTTP_HOST']);
$headers = "MIME-Version: 1.0\n";
$headers .= "From: ".get_option('blogname')." <".$mail_sender.">\n";
$headers .= "Content-Type: text/plain; charset=\"". get_bloginfo('charset') . "\"\n";
// Subject
$subject = "Confirm your subscription to " .get_option('blogname') . " Newsletter";
// Main content
$content = "Hi ". $name ."\r\nto complete your subscription to ".get_option('blogname') ."'s newsletter you need to click the follow link (or paste it in the address bar of your browser):\r\n";
$div_email = explode("@", $email); // for link
$content .= get_option ('siteurl') . "/?page_id=". get_option('ALO_em_subsc_page'). "&ac=activate&em1=" . $div_email[0] . "&em2=" . $div_email[1] . "&uk=" . $unikey . "\r\n";
$content .= "If you didn't require this subscription simply ignore this message.\r\n";
$content .= "Thank you\r\n".get_option('blogname')."\r\n";
//echo "