» Please visit plugin site for more info and feedback: www.eventualo.net
» If you use this plugin consider the idea of donating and supporting its development:
");
define("ALO_EM_INTERVAL_MIN", 10); // cron interval in minutes (default: 10) (NOTE: to apply the change you need to reactivate the plugin)
define("ALO_EM_MAX_ONE_SEND", 60); // max mails sent in one sending (default: 60)
/**
* On plugin activation
*/
function ALO_em_install() {
global $wpdb;
if (!get_option('ALO_em_template')) add_option('ALO_em_template', 'Hi [USER-NAME],
I have published a new post [POST-TITLE]. [POST-EXCERPT] Please visit my site [SITE-LINK] to read it and leave your comment about it.
Hope to see you online!
[SITE-LINK]');
if (!get_option('ALO_em_list')) add_option('ALO_em_list', '');
if (!get_option('ALO_em_lastposts')) add_option('ALO_em_lastposts', 10);
if (!get_option('ALO_em_dayrate')) add_option('ALO_em_dayrate', 1500);
if (!get_option('ALO_em_sender_email')) {
$admin_email = get_option('admin_email');
add_option('ALO_em_sender_email', $admin_email);
}
if (!get_option('ALO_em_optin_msg')) add_option('ALO_em_optin_msg', '' );
if (!get_option('ALO_em_optout_msg')) add_option('ALO_em_optout_msg', '');
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
//-------------------------------------------------------------------------
// TO MODIFY IF UPDATE NEEDED
$database_version = '1.14';
// Db version
$installed_db = get_option('ALO_em_db_version');
//if ( $database_version != $installed_db ) {
$table_name = $wpdb->prefix . "easymail_subscribers";
if($wpdb->get_var("show tables like '$table_name'") != $table_name || $database_version != $installed_db) {
if( defined( 'DB_COLLATE' ) && constant( 'DB_COLLATE' ) != '' ) {
$collate = constant( 'DB_COLLATE' );
} else {
$collate = constant( 'DB_CHARSET' );
}
// Create the table structure
$sql = "CREATE TABLE ".$table_name." (
ID int(11) unsigned NOT NULL auto_increment,
email varchar(100) NOT NULL,
name varchar(100) NOT NULL,
join_date datetime NOT NULL,
active INT( 1 ) NOT NULL DEFAULT '0',
unikey varchar(24) NOT NULL,
PRIMARY KEY (ID),
UNIQUE KEY `email` (`email`)
) DEFAULT CHARSET=".$collate.";
CREATE TABLE {$wpdb->prefix}easymail_sendings (
ID int(11) unsigned NOT NULL auto_increment,
start_at datetime DEFAULT NULL,
last_at datetime DEFAULT NULL,
user int(11) unsigned DEFAULT NULL,
headers text DEFAULT NULL,
subject varchar(250) DEFAULT NULL,
content text DEFAULT NULL,
recipients mediumtext DEFAULT NULL,
sent INT( 1 ) NOT NULL DEFAULT '0',
PRIMARY KEY (ID)
) DEFAULT CHARSET=".$collate.";
";
dbDelta($sql);
update_option( "ALO_em_db_version", $database_version );
}
//}
//-------------------------------------------------------------------------
// Create/update the page with subscription
// check if page already exists
$my_page_id = get_option('ALO_em_subsc_page');
$my_page = array();
$my_page['post_title'] = 'Newsletter Subscription';
$my_page['post_content'] = '[ALO-EASYMAIL-PAGE]';
$my_page['post_status'] = 'publish';
$my_page['post_author'] = 1;
$my_page['comment_status'] = 'closed';
$my_page['post_type'] = 'page';
if ($my_page_id) {
// if exists update
$my_page['ID'] = $my_page_id;
wp_update_post($my_page);
} else {
// insert the post into the database
$my_page_id = wp_insert_post( $my_page );
// The page's ID for later updates
add_option('ALO_em_subsc_page', $my_page_id);
}
// add scheduled cleaner
wp_schedule_event(time(), 'twicedaily', 'ALO_em_schedule');
// add scheduled cron batch
wp_schedule_event( time() +60, 'ALO_em_interval', 'ALO_em_batch' ); /* hourly */
}
register_activation_hook(__FILE__,'ALO_em_install');
/**
* For batch sending (every tot mins)
*/
function ALO_em_more_reccurences() {
return array(
'ALO_em_interval' => array('interval' => 60*(ALO_EM_INTERVAL_MIN), 'display' => 'ALO EasyMail interval')
);
}
add_filter('cron_schedules', 'ALO_em_more_reccurences');
/**
* Clean the new subscription not yet activated after too much time
*/
function ALO_em_clean_no_actived() {
global $wpdb;
// delete subscribes not yet activated after 5 days
$limitdate = date ("Y-m-d",mktime(0,0,0,date("m"),date("d")-5,date("Y")));
$output = $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}easymail_subscribers WHERE join_date <= '%s' AND active = '0'", $limitdate ) );
//return $output;.
}
add_action('ALO_em_schedule', 'ALO_em_clean_no_actived');
add_action( 'ALO_em_batch' , 'ALO_em_batch_sending');
/**
* On plugin adectivation
*/
function ALO_em_uninstall() {
// delete subscription page
wp_delete_post( get_option('ALO_em_subsc_page') );
// delete scheduled cleaner
wp_clear_scheduled_hook('ALO_em_schedule');
// delete cron batch sending
wp_clear_scheduled_hook('ALO_em_batch');
}
register_deactivation_hook( __FILE__, 'ALO_em_uninstall' );
/**
* Add menu pages
*/
function ALO_em_add_admin_menu() {
add_options_page('EasyMail Newsletter', 'EasyMail Newsletter', 8, 'alo-easymail-options', 'ALO_em_option_page');
//add_management_page ('Alo EasyMail', 'Alo EasyMail', 8, 'alo-easymail/alo-easymail_main.php'); deleted GAL
// GAL change access level to 3 if editors can send emails
if (get_option('alo_em_editor_ok')=='checked') $access_level = 3; else $access_level = 8; // added GAL
add_management_page ('EasyMail Newsletter', 'EasyMail Newsletter', $access_level, 'alo-easymail/alo-easymail_main.php'); // added GAL
add_submenu_page('users.php', __("Newsletter subscribers", "alo-easymail"), __("Newsletter subscribers", "alo-easymail"), 8, 'alo-easymail/alo-easymail_subscribers.php');
}
add_action('admin_menu', 'ALO_em_add_admin_menu');
//>>>>>>>>>>>>>>> added GAL
require_once('alo-easymail-widget.php');
add_action( 'show_user_profile', 'ALO_em_user_profile_optin' );
add_action( 'edit_user_profile', 'ALO_em_user_profile_optin' );
function ALO_em_user_profile_optin($user) {
// get the current setting
//if (ALO_easymail_get_optin($user->ID)=='yes'){ // deleted ALO
if (ALO_em_is_subscriber($user->user_email)){ // added ALO
$optin_selected = 'selected';
$optout_selected = '';
}
else{
$optin_selected = '';
$optout_selected = 'selected';
}
$html = "
ID == get_option('ALO_em_subsc_page')) unset ($pages[$i]);
}
return $pages;
}
/**
* Manage the newsletter subscription page
*/
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');
/**
* Add help image with tooltip
*/
function ALO_em_help_tooltip ( $text ) {
$text = str_replace( array("'", '"'), "", $text );
$html = "";
return $html;
}
/*************************************************************************
* 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 = sprintf(__("Confirm your subscription to %s Newsletter", "alo-easymail"), get_option('blogname') );
//$subject = "Confirm your subscription to " .get_option('blogname') . " Newsletter";
// Main content
$content = sprintf(__("Hi %s\nto complete your subscription to %s newsletter you need to click on the following link (or paste it in the address bar of your browser):\n", "alo-easymail"), $name, get_option('blogname') );
$div_email = explode("@", $email); // for link
$content .= get_option ('home') . "/?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 did not ask for this subscription ignore this message.", "alo-easymail"). "\n";
$content .= __("Thank you", "alo-easymail")."\n".get_option('blogname')."\n";
//echo " ".$headers." ".$subscriber->email." ". $subject." ". $content ."" ; // DEBUG
$sending = @wp_mail( $email, $subject, $content, $headers);
return ($sending ? true : false);
}
/*************************************************************************
* AJAX 'SACK' FUNCTION
*************************************************************************/
add_action('wp_head', 'ALO_em_ajax_js' );
function ALO_em_ajax_js()
{
// use JavaScript SACK library for Ajax
wp_print_scripts( array( 'sack' ));
// Define custom JavaScript function
?>
user_firstname." ". $current_user->user_lastname , 1);
} else {
ALO_em_delete_subscriber_by_id( ALO_em_is_subscriber($user_email) );
}
// Compose JavaScript for return
$feedback = "";
$feedback .= "document.getElementById('alo_easymail_widget_feedback').innerHTML = '". __("Successfully updated", "alo-easymail"). ".';";
$feedback .= "document.getElementById('alo_easymail_widget_feedback').className = 'alo_easymail_widget_ok';";
// END!
die($feedback);
}
}
// For NOT-logged-in pubblic visitors
function ALO_em_pubblic_form_callback() {
global $wpdb, $user_ID;
if (isset($_POST['alo_em_opt_name']) && isset($_POST['alo_em_opt_email'])){
$error_on_adding = "";
$just_added = false;
//if (!preg_match('/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/' , trim($_POST['alo_em_opt_email']) )) {
if (!is_email(trim($_POST['alo_em_opt_email']))) {
$error_on_adding .= __("The e-email address is not correct", "alo-easymail"). " ";
}
if ( stripslashes(trim($_POST['alo_em_opt_name'])) == "") {
$error_on_adding .= __("The name field is empty", "alo-easymail") . ". ";
}
if ($error_on_adding == "") { // if no error
// try to add new subscriber (and send mail if necessary) and return TRUE if success
if ( ALO_em_add_subscriber( stripslashes(trim($_POST['alo_em_opt_email'])), trim($_POST['alo_em_opt_name']), 0) ) {
$just_added = true;
} else {
$error_on_adding = __("Error during sending: please try again", "alo-easymail"). ". ";
}
}
if ($just_added == true) {
$output = __("Subscription successful. You will receive an e-mail with a link. You have to click on the link to activate your subscription.", "alo-easymail");
$classfeedback = "alo_easymail_widget_ok";
} else {
$output = $error_on_adding;
$classfeedback = "alo_easymail_widget_error";
}
// Compose JavaScript for return
$feedback = "";
$feedback .= "document.alo_easymail_widget_form.submit.disabled = false;";
$feedback .= "document.alo_easymail_widget_form.submit.value = '". __("Subscribe", "alo-easymail"). "';";
$feedback .= "document.getElementById('alo_easymail_widget_feedback').innerHTML = '$output';";
$feedback .= "document.getElementById('alo_easymail_widget_feedback').className = '$classfeedback';";
// END!
die($feedback);
}
}
/*************************************************************************
* BATCH SENDING
*************************************************************************/
/**
* Add a new newsletter to batch sending
*/
function ALO_em_add_new_batch ( $headers, $user_ID, $subject, $content, $recipients ) {
global $wpdb;
$add_newsletter = $wpdb->insert(
"{$wpdb->prefix}easymail_sendings",
array( 'start_at' => date("Y-m-d H:i:s"), 'last_at' => date("Y-m-d H:i:s"), 'headers' => $headers, 'user' => $user_ID, 'subject' => $subject,
'content' => $content, 'sent' => '0', 'recipients' => $recipients )
);
return $add_newsletter;
}
/**
* Send the newsletter to a fraction of recipients every X minutes
*/
function ALO_em_batch_sending () {
global $wpdb;
// retrieve info of oldest newsletter to send
$sending_info = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}easymail_sendings WHERE sent = 0 ORDER BY ID ASC LIMIT 1");
// if no sending there is nothing to send: batch has finished
if ($sending_info == false) return;
// the recipient of sending
$recipients = unserialize( $sending_info->recipients );
// search the interval between now and previous sending
$diff_time = strtotime(date("Y-m-d H:i:s")) - strtotime($sending_info->last_at);
// so... how much recipients for this interval? // (86400 = seconds in a day)
$day_rate = get_option('ALO_em_dayrate');
$tot_recs = max ( floor(($day_rate * $diff_time / 86400)) , 1);
// for each sent mail add 1 to recs
$n_recs = 0;
for ($r=0; $r < count($recipients); $r++) {
// if already sent to this recipient skip it
if ($recipients[$r]['result'] != "") {
continue; // go to next rec
}
// For each recipient delete TAGs update
$updated_content = $sending_info->content;
$updated_content = str_replace("\n", " ", $updated_content);
// TAG: [USER-NAME]
if ($recipients[$r]['name']) {
$updated_content = str_replace("[USER-NAME]", $recipients[$r]['name'], $updated_content);
} else {
$updated_content = str_replace("[USER-NAME]", "", $updated_content);
}
//>>>>>>> added GAL
// TAG: [USER-FIRST-NAME]
if ($recipients[$r]['firstname']) {
$updated_content = str_replace("[USER-FIRST-NAME]", $recipients[$r]['firstname'], $updated_content);
} else {
$updated_content = str_replace("[USER-FIRST-NAME]", "", $updated_content);
}
//<<<<<<<<< end added GAL
// Unsubscribe link, only if subscriber
if ($recipients[$r]['unikey']) {
$div_email = explode("@", $recipients[$r]['email']); // for link
$updated_content .= "
". __("You have received this message because you subscribed to our newsletter. If you want to unsubscribe: ", "alo-easymail");
$updated_content .= "".__("click here", "alo-easymail") .".";
$updated_content .= "
";
}
// ---- Send MAIL ----
$mail_engine = @wp_mail($recipients[$r]['email'], $sending_info->subject, $updated_content, $sending_info->headers);
if($mail_engine) {
$recipients[$r]['result'] = 1;
} else {
$recipients[$r]['result'] = -1;
}
// add as sent
$n_recs ++;
// sent to all of this sending? or too much sending stop sending!
if ($n_recs == $tot_recs || $n_recs >= ALO_EM_MAX_ONE_SEND) break;
// after each email it sleep a little: (x')/n°recipients
//$timesleep = max (floor ( ALO_EM_INTERVAL_MIN *60 / $tot_recs ), 1);
//sleep($timesleep);
//sleep(1);
}
// check if batch completed
$has_finished = 1;
foreach ($recipients as $recipient) {
if ( !isset($recipient['result']) ) {
$has_finished = 0;
break;
}
}
// update sending info
$wpdb->update("{$wpdb->prefix}easymail_sendings",
array( 'last_at' => date("Y-m-d H:i:s"), 'recipients' => serialize ($recipients), 'sent' => $has_finished ),
array( 'ID' => $sending_info->ID )
);
}
?>