$controls->messages = 'Activation email resent to ' . $user->email; } if ($controls->is_action('resend_welcome')) { $user = NewsletterUsers::instance()->get_user($controls->button_data); $opts = get_option('newsletter'); NewsletterSubscription::instance()->mail($user->email, $newsletter->replace($opts['confirmed_subject'], $user), $newsletter->replace($opts['confirmed_message'], $user)); $controls->messages = 'Welcome email resent.'; } if ($controls->is_action('remove')) { $wpdb->query($wpdb->prepare("delete from " . NEWSLETTER_USERS_TABLE . " where id=%d", $controls->button_data)); unset($controls->data['subscriber_id']); } // We build the query condition $where = "where 1=1"; $query_args = array(); $text = trim($controls->get_value('search_text')); if ($text) { $query_args[] = '%' . $text . '%'; $query_args[] = '%' . $text . '%'; $query_args[] = '%' . $text . '%'; $where .= " and (email like %s or name like %s or surname like %s)"; } //if (isset($controls->data['search_test'])) { // $where .= " and test=1"; //} if (!empty($controls->data['search_status'])) { if ($controls->data['search_status'] == 'T') { $where .= " and test=1"; } else { $query_args[] = $controls->data['search_status']; $where .= " and status=%s";