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; }
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 ($es_email_group == '') { $es_email_group = "Public"; } 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"] = $es_email_group; $form["es_email_status"] = $es_email_status; $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; ?>
$es_errors[] = __('Please enter subscriber email address.', 'email-subscribers'); $es_error_found = TRUE; } $form['es_email_group'] = isset($_POST['es_email_group']) ? $_POST['es_email_group'] : ''; $form['es_email_id'] = isset($_POST['es_email_id']) ? $_POST['es_email_id'] : '0'; if ($form['es_email_group'] != "") { $special_letters = es_cls_common::es_special_letters(); if (preg_match($special_letters, $form['es_email_group'])) { $es_errors[] = __('Error: Special characters are not allowed in the group name.', 'email-subscribers'); $es_error_found = TRUE; } } // No errors found, we can add this Group to the table if ($es_error_found == FALSE) { $action = ""; $action = es_cls_dbquery::es_view_subscriber_ins($form, "update"); if ($action == "sus") { $es_success = __('Email was successfully updated.', 'email-subscribers'); } elseif ($action == "ext") { $es_errors[] = __('Email already exist for this group.', 'email-subscribers'); $es_error_found = TRUE; } } } if ($es_error_found == TRUE && isset($es_errors[0]) == TRUE) { ?> <div class="error fade"><p><strong><?php echo $es_errors[0]; ?> </strong></p></div><?php }
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; }