public static function es_subscriber_default() { $result = es_cls_dbquery::es_view_subscriber_count(0); if ($result == 0) { $form["es_email_mail"] = get_option('admin_email'); $form["es_email_name"] = "Admin"; $form["es_email_group"] = "Public"; $form["es_email_status"] = "Confirmed"; es_cls_dbquery::es_view_subscriber_ins($form, "insert"); $form["es_email_mail"] = "*****@*****.**"; $form["es_email_name"] = "Example"; $form["es_email_group"] = "Public"; $form["es_email_status"] = "Confirmed"; es_cls_dbquery::es_view_subscriber_ins($form, "insert"); } return true; }
?> </p> <label for="tag-display-status"><?php _e('Select default group', 'email-subscribers'); ?> </label> <select name="es_registered_group" id="es_email_group"> <option value=''><?php _e('Select', 'email-subscribers'); ?> </option> <?php $thisselected = ""; $groups = array(); $groups = es_cls_dbquery::es_view_subscriber_group(); if (count($groups) > 0) { $i = 1; foreach ($groups as $group) { if ($group["es_email_group"] == $es_registered_group) { $thisselected = "selected='selected'"; } ?> <option value='<?php echo $group["es_email_group"]; ?> ' <?php echo $thisselected; ?> ><?php echo $group["es_email_group"];
<a class="button add-new-h2" href="javascript:void(0);" onClick="javascript:_es_sendemailsearch('J,K,L')">J,K,L</a> <a class="button add-new-h2" href="javascript:void(0);" onClick="javascript:_es_sendemailsearch('M,N,O')">M,N,O</a> <a class="button add-new-h2" href="javascript:void(0);" onClick="javascript:_es_sendemailsearch('P,Q,R')">P,Q,R</a> <a class="button add-new-h2" href="javascript:void(0);" onClick="javascript:_es_sendemailsearch('S,T,U')">S,T,U</a> <a class="button add-new-h2" href="javascript:void(0);" onClick="javascript:_es_sendemailsearch('V,W,X,Y,Z')">V,W,X,Y,Z</a> <a class="button add-new-h2" href="javascript:void(0);" onClick="javascript:_es_sendemailsearch('0,1,2,3,4,5,6,7,8,9')">0-9</a> <a class="button add-new-h2" href="javascript:void(0);" onClick="javascript:_es_sendemailsearch('ALL')">ALL</a> <span> </div> </td> </tr> <tr> <td colspan="2"> <?php $subscribers = array(); $subscribers = es_cls_dbquery::es_view_subscriber_sendmail($es_search_query, $es_email_group); $i = 1; $count = 0; if (count($subscribers) > 0) { echo "<table border='0' cellspacing='0'><tr>"; $col = 3; foreach ($subscribers as $subscriber) { $to = $subscriber['es_email_mail']; $id = $subscriber['es_email_id']; //$ToAddress = trim($to) . '<||>' . trim($id); if ($to != "") { echo "<td style='padding-top:4px;padding-bottom:4px;padding-right:10px;'>"; ?> <input class="radio" type="checkbox" checked="checked" value='<?php echo $id; ?>
// Check errors in the query string if ($form['db'] == '' || $form['email'] == '' || $form['guid'] == '') { $noerror = false; } else { if (!is_numeric($form['db'])) { $noerror = false; } if (!filter_var($form['email'], FILTER_VALIDATE_EMAIL)) { $noerror = false; } } // Load default message $data = array(); $data = es_cls_settings::es_setting_select(1); if ($noerror) { $result = es_cls_dbquery::es_view_subscriber_job("Unsubscribed", $form['db'], $form['guid'], $form['email']); if ($result) { $message = esc_html(stripslashes($data['es_c_unsubhtml'])); $message = str_replace("\r\n", "<br />", $message); } else { $message = esc_html(stripslashes($data['es_c_message2'])); } if ($message == "") { $message = __('Oops.. We are getting some technical error. Please try again or contact admin.', 'email-subscribers'); } echo $message; } else { $message = esc_html(stripslashes($data['es_c_message2'])); $message = str_replace("\r\n", "<br />", $message); if ($message == "") { $message = __('Oops.. We are getting some technical error. Please try again or contact admin.', 'email-subscribers');
public static function es_view_subscriber_widget($data = array()) { global $wpdb; $prefix = $wpdb->prefix; $arrRes = array(); $currentdate = date('Y-m-d G:i:s'); //$sSql = "SELECT * FROM `".$prefix."es_emaillist` WHERE"; //$sSql = $sSql . " es_email_mail = %s"; //$sSql = $sSql . " es_email_group = %s"; //$sSql = $sSql . " Limit 1"; //$sSql = $wpdb->prepare($sSql, array($data["es_email_mail"], $data["es_email_group"])); //$arrRes = $wpdb->get_results($sSql, ARRAY_A); $sSql = "SELECT * FROM `" . $prefix . "es_emaillist` where es_email_mail='" . $data["es_email_mail"] . "' and es_email_group='" . trim($data["es_email_group"]) . "'"; $arrRes = $wpdb->get_results($sSql, ARRAY_A); if (count($arrRes) > 0) { if ($arrRes[0]['es_email_status'] == "Confirmed") { return "ext"; } else { $action = ""; $form['es_email_name'] = $data["es_email_name"]; $form['es_email_mail'] = $data["es_email_mail"]; $form['es_email_group'] = $data["es_email_group"]; $form['es_email_status'] = $data["es_email_status"]; $form['es_email_id'] = $arrRes[0]["es_email_id"]; $action = es_cls_dbquery::es_view_subscriber_ins($form, $action = "update"); return $action; } } else { $action = es_cls_dbquery::es_view_subscriber_ins($data, $action = "insert"); return $action; } }
function es_sync_registereduser($user_id) { $es_c_emailsubscribers = get_option('es_c_emailsubscribers', 'norecord'); if ($es_c_emailsubscribers == 'norecord' || $es_c_emailsubscribers == "") { // No action is required } else { if ($es_c_emailsubscribers['es_registered'] == "YES" && $user_id != "") { $es_registered = $es_c_emailsubscribers['es_registered']; $es_registered_group = $es_c_emailsubscribers['es_registered_group']; $user_info = get_userdata($user_id); $user_firstname = $user_info->user_firstname; if ($user_firstname == "") { $user_firstname = $user_info->user_login; } $user_mail = $user_info->user_email; $form['es_email_name'] = $user_firstname; $form['es_email_mail'] = $user_mail; $form['es_email_group'] = $es_c_emailsubscribers['es_registered_group']; $form['es_email_status'] = "Confirmed"; $action = es_cls_dbquery::es_view_subscriber_ins($form, "insert"); if ($action == "sus") { //Inserted successfully. Below 3 line of code will send WELCOME email to subscribers. $subscribers = array(); $subscribers = es_cls_dbquery::es_view_subscriber_one($user_mail); es_cls_sendmail::es_sendmail("welcome", $template = 0, $subscribers, "welcome", 0); } } } }
if ($samedomain !== false && $samedomain < 5) { $action = ""; global $wpdb; $form['es_email_name'] = $es_name; $form['es_email_mail'] = $es_email; $form['es_email_group'] = $es_group; $data = es_cls_settings::es_setting_select(1); if ($data['es_c_optinoption'] == "Double Opt In") { $form['es_email_status'] = "Unconfirmed"; } else { $form['es_email_status'] = "Single Opt In"; } $action = es_cls_dbquery::es_view_subscriber_widget($form); if ($action == "sus") { $subscribers = array(); $subscribers = es_cls_dbquery::es_view_subscriber_one($es_email); if ($data['es_c_optinoption'] == "Double Opt In") { es_cls_sendmail::es_sendmail("optin", $template = 0, $subscribers, "optin", 0); echo "subscribed-pending-doubleoptin"; } else { if ($data['es_c_usermailoption'] == "YES") { es_cls_sendmail::es_sendmail("welcome", $template = 0, $subscribers, "welcome", 0); } echo "subscribed-successfully"; } } elseif ($action == "ext") { echo "already-exist"; } } else { echo "unexpected-error"; }
public static function es_prepare_newsletter_manual($template, $recipients) { $subscribers = array(); $subscribers = es_cls_dbquery::es_view_subscriber_manual($recipients); es_cls_sendmail::es_sendmail("newsletter", $template, $subscribers, "manual", 0); }
function form($instance) { $defaults = array('es_af_title' => '', 'es_af_desc' => '', 'es_af_name' => '', 'es_af_name_mand' => '', 'es_af_email' => '', 'es_af_email_mand' => '', 'es_af_group' => '', 'es_af_group_mand' => '', 'es_af_group_list' => ''); $instance = wp_parse_args((array) $instance, $defaults); $es_af_title = $instance['es_af_title']; $es_af_desc = $instance['es_af_desc']; $es_af_name = $instance['es_af_name']; $es_af_name_mand = $instance['es_af_name_mand']; $es_af_email = $instance['es_af_email']; $es_af_email_mand = $instance['es_af_email_mand']; $es_af_group = $instance['es_af_group']; $es_af_group_mand = $instance['es_af_group_mand']; $es_af_group_list = $instance['es_af_group_list']; ?> <p> <label for="<?php echo $this->get_field_id('es_af_title'); ?> "><?php _e('Widget title', ES_AF_TDOMAIN); ?> </label> <input class="widefat" id="<?php echo $this->get_field_id('es_af_title'); ?> " name="<?php echo $this->get_field_name('es_af_title'); ?> " type="text" value="<?php echo $es_af_title; ?> " /> </p> <p> <label for="<?php echo $this->get_field_id('es_af_desc'); ?> "><?php _e('Short description', ES_AF_TDOMAIN); ?> </label> <input class="widefat" id="<?php echo $this->get_field_id('es_af_desc'); ?> " name="<?php echo $this->get_field_name('es_af_desc'); ?> " type="text" value="<?php echo $es_af_desc; ?> " /> <?php _e('Short description about your subscription form.', ES_AF_TDOMAIN); ?> </p> <p> <label for="<?php echo $this->get_field_id('es_af_name'); ?> "><?php _e('Display NAME box', ES_AF_TDOMAIN); ?> </label> <select class="widefat" id="<?php echo $this->get_field_id('es_af_name'); ?> " name="<?php echo $this->get_field_name('es_af_name'); ?> "> <option value="YES" <?php $this->es_af_selected($es_af_name == 'YES'); ?> >YES</option> <option value="NO" <?php $this->es_af_selected($es_af_name == 'NO'); ?> >NO</option> </select> </p> <p> <label for="<?php echo $this->get_field_id('es_af_name_mand'); ?> "><?php _e('Do you want to set NAME box is mandatory box?', ES_AF_TDOMAIN); ?> </label> <select class="widefat" id="<?php echo $this->get_field_id('es_af_name_mand'); ?> " name="<?php echo $this->get_field_name('es_af_name_mand'); ?> "> <option value="YES" <?php $this->es_af_selected($es_af_name_mand == 'YES'); ?> >YES</option> <option value="NO" <?php $this->es_af_selected($es_af_name_mand == 'NO'); ?> >NO</option> </select> </p> <p> <label for="<?php echo $this->get_field_id('es_af_email'); ?> "><?php _e('Display EMAIL box', ES_AF_TDOMAIN); ?> </label> <select class="widefat" id="<?php echo $this->get_field_id('es_af_email'); ?> " name="<?php echo $this->get_field_name('es_af_email'); ?> "> <option value="YES" <?php $this->es_af_selected($es_af_email == 'YES'); ?> >YES</option> </select> </p> <p> <label for="<?php echo $this->get_field_id('es_af_email_mand'); ?> "><?php _e('Do you want to set EMAIL box is mandatory box?', ES_AF_TDOMAIN); ?> </label> <select class="widefat" id="<?php echo $this->get_field_id('es_af_email_mand'); ?> " name="<?php echo $this->get_field_name('es_af_email_mand'); ?> "> <option value="YES" <?php $this->es_af_selected($es_af_email_mand == 'YES'); ?> >YES</option> </select> </p> <p> <label for="<?php echo $this->get_field_id('es_af_group'); ?> "><?php _e('Display GROUPS options', ES_AF_TDOMAIN); ?> </label> <select class="widefat" id="<?php echo $this->get_field_id('es_af_group'); ?> " name="<?php echo $this->get_field_name('es_af_group'); ?> "> <option value="YES" <?php $this->es_af_selected($es_af_group == 'YES'); ?> >YES</option> <option value="NO" <?php $this->es_af_selected($es_af_group == 'NO'); ?> >NO</option> </select> </p> <p> <label for="<?php echo $this->get_field_id('es_af_group_mand'); ?> "><?php _e('Do you want to set mandatory option for GROUP box?', ES_AF_TDOMAIN); ?> </label> <select class="widefat" id="<?php echo $this->get_field_id('es_af_group_mand'); ?> " name="<?php echo $this->get_field_name('es_af_group_mand'); ?> "> <option value="YES" <?php $this->es_af_selected($es_af_group_mand == 'YES'); ?> >YES</option> <option value="NO" <?php $this->es_af_selected($es_af_group_mand == 'NO'); ?> >NO</option> </select> </p> <p> <label for="<?php echo $this->get_field_id('es_af_group_list'); ?> "><?php _e('Enter GROUP name to display (coma separated value)', ES_AF_TDOMAIN); ?> </label> <input class="widefat" id="<?php echo $this->get_field_id('es_af_group_list'); ?> " name="<?php echo $this->get_field_name('es_af_group_list'); ?> " type="text" value="<?php echo $es_af_group_list; ?> " /> <?php if (is_plugin_active('email-subscribers/email-subscribers.php')) { $groups = array(); $groups = es_cls_dbquery::es_view_subscriber_group(); if (count($groups) > 0) { $i = 1; foreach ($groups as $group) { if ($i != 1) { echo ", "; } else { echo "<br>Existing Groups : "; } echo $group["es_email_group"]; $i = $i + 1; } } } ?> </p> <?php }
public static function es_prepare_send_cronmail($cronmailqueue = array(), $crondeliveryqueue = array()) { $subscriber = array(); $htmlmail = false; $wpmail = false; $type = $cronmailqueue[0]['es_sent_source']; $content = $cronmailqueue[0]['es_sent_preview']; $subject = $cronmailqueue[0]['es_sent_subject']; $cacheid = es_cls_common::es_generate_guid(100); $replacefrom = array("<ul><br />", "</ul><br />", "<li><br />", "</li><br />", "<ol><br />", "</ol><br />", "</h2><br />", "</h1><br />"); $replaceto = array("<ul>", "</ul>", "<li>", "</li>", "<ol>", "</ol>", "</h2>", "</h1>"); $count = 1; $settings = es_cls_settings::es_setting_select(1); if (trim($settings['es_c_fromname']) == "" || trim($settings['es_c_fromemail']) == '') { get_currentuserinfo(); $sender_name = $user_login; $sender_email = $user_email; } else { $sender_name = $settings['es_c_fromname']; $sender_email = $settings['es_c_fromemail']; } if ($settings['es_c_mailtype'] == "WP HTML MAIL" || $settings['es_c_mailtype'] == "PHP HTML MAIL") { $htmlmail = true; } if ($settings['es_c_mailtype'] == "WP HTML MAIL" || $settings['es_c_mailtype'] == "WP PLAINTEXT MAIL") { $wpmail = true; } $headers = "From: \"{$sender_name}\" <{$sender_email}>\n"; $headers .= "Return-Path: <" . $sender_email . ">\n"; $headers .= "Reply-To: \"" . $sender_name . "\" <" . $sender_email . ">\n"; $headers .= "X-Mailer: PHP" . phpversion() . "\n"; if ($htmlmail) { $headers .= "MIME-Version: 1.0\n"; $headers .= "Content-Type: " . get_bloginfo('html_type') . "; charset=\"" . get_bloginfo('charset') . "\"\n"; $headers .= "Content-type: text/html\r\n"; } else { $headers .= "MIME-Version: 1.0\n"; $headers .= "Content-Type: text/plain; charset=\"" . get_bloginfo('charset') . "\"\n"; } $url = home_url('/'); $viewstatus = '<img src="' . $url . '?es=viewstatus&delvid=###DELVIID###" width="1" height="1" />'; foreach ($crondeliveryqueue as $crondelivery) { $es_email_id = $crondelivery['es_deliver_emailid']; $es_deliver_id = $crondelivery['es_deliver_id']; $subscriber = es_cls_dbquery::es_view_subscriber_search("", $es_email_id); if (count($subscriber) > 0) { $unsublink = $settings['es_c_unsublink']; $unsublink = str_replace("###DBID###", $subscriber[0]["es_email_id"], $unsublink); $unsublink = str_replace("###EMAIL###", $subscriber[0]["es_email_mail"], $unsublink); $unsublink = str_replace("###GUID###", $subscriber[0]["es_email_guid"], $unsublink); $unsublink = $unsublink . "&cache=" . $cacheid; $unsubtext = stripslashes($settings['es_c_unsubtext']); $unsubtext = str_replace("###LINK###", $unsublink, $unsubtext); if ($settings['es_c_mailtype'] == "WP HTML MAIL" || $settings['es_c_mailtype'] == "PHP HTML MAIL") { $unsubtext = '<br><br>' . $unsubtext; } else { $unsubtext = '\\n\\n' . $unsubtext; } $viewstslink = str_replace("###DELVIID###", $es_deliver_id, $viewstatus); $content_send = str_replace("###EMAIL###", $subscriber[0]["es_email_mail"], $content); $content_send = str_replace("###NAME###", $subscriber[0]["es_email_name"], $content_send); if ($settings['es_c_mailtype'] == "WP HTML MAIL" || $settings['es_c_mailtype'] == "PHP HTML MAIL") { $content_send = nl2br($content_send); $content_send = str_replace($replacefrom, $replaceto, $content_send); } else { $content_send = str_replace("<br />", "\r\n", $content_send); $content_send = str_replace("<br>", "\r\n", $content_send); } if ($wpmail) { wp_mail($subscriber[0]["es_email_mail"], $subject, $content_send . $unsubtext . $viewstslink, $headers); } else { mail($subscriber[0]["es_email_mail"], $subject, $content_send . $unsubtext . $viewstslink, $headers); } es_cls_delivery::es_delivery_ups_cron($es_deliver_id); $count = $count + 1; } if ($count % 25 == 0) { sleep(60); //sleep 60 seconds for every 25 emails. } } $es_cron_adminmail = get_option('es_cron_adminmail'); if ($es_cron_adminmail != "") { $adminmail = $settings['es_c_adminemail']; $crondate = date('Y-m-d G:i:s'); $count = $count - 1; $es_cron_adminmail = str_replace("###COUNT###", $count, $es_cron_adminmail); $es_cron_adminmail = str_replace("###DATE###", $crondate, $es_cron_adminmail); $es_cron_adminmail = str_replace("###SUBJECT###", $subject, $es_cron_adminmail); if ($htmlmail) { $es_cron_adminmail = nl2br($es_cron_adminmail); } else { $es_cron_adminmail = str_replace("<br />", "\r\n", $es_cron_adminmail); $es_cron_adminmail = str_replace("<br>", "\r\n", $es_cron_adminmail); } if ($wpmail) { wp_mail($adminmail, "Cron URL has been triggered successfully", $es_cron_adminmail, $headers); } else { mail($adminmail, "Cron URL has been triggered successfully", $es_cron_adminmail, $headers); } } }
//} if (preg_match('#' . basename(__FILE__) . '#', $_SERVER['PHP_SELF'])) { die('You are not allowed to call this page directly.'); } ?> <script language="javaScript" src="<?php echo ES_URL; ?> subscribers/view-subscriber.js"></script> <?php //$_SESSION['es_exportcsv'] = "YES"; $home_url = home_url('/'); $cnt_subscriber = 0; $cnt_users = 0; $cnt_comment_author = 0; $cnt_subscriber = es_cls_dbquery::es_view_subscriber_count(0); $cnt_users = $wpdb->get_var("select count(DISTINCT user_email) from " . $wpdb->prefix . "users"); $cnt_comment_author = $wpdb->get_var("SELECT count(DISTINCT comment_author_email) from " . $wpdb->prefix . "comments WHERE comment_author_email <> ''"); ?> <div class="wrap"> <div id="icon-plugins" class="icon32"></div> <h2><?php _e(ES_PLUGIN_DISPLAY, ES_TDOMAIN); ?> </h2> <div class="tool-box"> <h3 class="title"><?php _e('Export email address in csv format', ES_TDOMAIN); ?> </h3>
public static function es_subscriber_default() { $result = es_cls_dbquery::es_view_subscriber_count(0); if ($result == 0) { $form["es_email_mail"] = get_option('admin_email'); $form["es_email_name"] = "Admin"; //XTEC ************ MODIFICAT - Changed default group from Public to Portada //2016.03.29 @sarjona $form["es_email_group"] = 'Portada'; //************ ORIGINAL /* $form["es_email_group"] = "Public"; */ //************ FI $form["es_email_status"] = "Confirmed"; es_cls_dbquery::es_view_subscriber_ins($form, "insert"); $form["es_email_mail"] = "*****@*****.**"; $form["es_email_name"] = "Example"; //XTEC ************ MODIFICAT - Changed default group from Public to Portada //2016.03.29 @sarjona $form["es_email_group"] = 'Portada'; //************ ORIGINAL /* $form["es_email_group"] = "Public"; */ //************ FI $form["es_email_status"] = "Confirmed"; es_cls_dbquery::es_view_subscriber_ins($form, "insert"); } return true; }
//$path_parts = pathinfo($fullPath); //$extension = strtolower($path_parts["extension"]); $tmpname = $_FILES['es_csv_name']['tmp_name']; if ($extension === 'csv') { $csv = es_cls_common::es_readcsv($tmpname); } if (count($csv) > 0) { $inserted = 0; $duplicate = 0; $invalid = 0; for ($i = 1; $i < count($csv) - 1; $i++) { $form["es_email_mail"] = trim($csv[$i][0]); $form["es_email_name"] = trim($csv[$i][1]); $form["es_email_group"] = "Public"; $form["es_email_status"] = "Confirmed"; $action = es_cls_dbquery::es_view_subscriber_ins($form, "insert"); if ($action == "sus") { $inserted = $inserted + 1; } elseif ($action == "ext") { $duplicate = $duplicate + 1; } elseif ($action == "invalid") { $invalid = $invalid + 1; } // Reset the form fields $form = array('es_email_name' => '', 'es_email_status' => '', 'es_email_group' => '', 'es_email_mail' => ''); } ?> <div class="updated fade"> <p><strong><?php echo $inserted; ?>