function qum_handle_email_confirmation_cases()
{
global $current_user;
global $wpdb;
//die($current_user);
$url = trim($_POST['URL']);
$todo = trim($_POST['todo']);
$user_email = trim($_POST['user_email']);
if (current_user_can('delete_users')) {
if ($todo != '' && $user_email != '') {
$results = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->base_prefix . "signups WHERE active = 0 AND user_email = %s", $user_email));
if (count($results) != 1) {
die(__("There was an error performing that action!", "quickusermanager"));
} elseif ($todo == 'delete') {
$sql_result = $wpdb->delete($wpdb->base_prefix . 'signups', array('user_login' => $results[0]->user_login, 'user_email' => $results[0]->user_email));
if ($sql_result) {
die('ok');
} else {
die(__("The selected user couldn't be deleted", "quickusermanager"));
}
} elseif ($todo == 'confirm') {
die(qum_manual_activate_signup($results[0]->activation_key));
} elseif ($todo == 'resend') {
$sql_result = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . $wpdb->base_prefix . "signups WHERE user_login = %s AND user_email = %s", $results[0]->user_login, $results[0]->user_email), ARRAY_A);
if ($sql_result) {
qum_signup_user_notification(trim($sql_result['user_login']), trim($sql_result['user_email']), $sql_result['activation_key'], $sql_result['meta']);
die(__("Email notification resent to user", "quickusermanager"));
}
}
}
}
die(__("You either don't have permission for that action or there was an error!", "quickusermanager"));
}
function qum_process_bulk_action()
{
global $current_user;
global $wpdb;
if (current_user_can('delete_users')) {
if ('delete' === $this->current_action()) {
foreach ($_GET['user'] as $user) {
$sql_result = $wpdb->query($wpdb->prepare("DELETE FROM " . $wpdb->base_prefix . "signups WHERE user_email = %s", $user));
if (!$sql_result) {
$this->qum_process_bulk_action_message(sprintf(__("%s couldn't be deleted", "quickusermanager"), $result->user_login), get_bloginfo('url') . '/wp-admin/users.php?page=unconfirmed_emails');
}
}
$this->qum_process_bulk_action_message(__('All users have been successfully deleted', 'quickusermanager'), get_bloginfo('url') . '/wp-admin/users.php?page=unconfirmed_emails');
} elseif ('confirm' === $this->current_action()) {
foreach ($_GET['user'] as $user) {
$sql_result = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . $wpdb->base_prefix . "signups WHERE user_email = %s", $user), ARRAY_A);
if ($sql_result) {
qum_manual_activate_signup($sql_result['activation_key']);
}
}
$this->qum_process_bulk_action_message(__('The selected users have been activated', 'quickusermanager'), get_bloginfo('url') . '/wp-admin/users.php?page=unconfirmed_emails');
} elseif ('resend' === $this->current_action()) {
foreach ($_GET['user'] as $user) {
$sql_result = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . $wpdb->base_prefix . "signups WHERE user_email = %s", $user), ARRAY_A);
if ($sql_result) {
qum_signup_user_notification(esc_sql($sql_result['user_login']), esc_sql($sql_result['user_email']), $sql_result['activation_key'], $sql_result['meta']);
}
}
$this->qum_process_bulk_action_message(__('The selected users have had their activation emails resent', 'quickusermanager'), get_bloginfo('url') . '/wp-admin/users.php?page=unconfirmed_emails');
}
} else {
$this->qum_process_bulk_action_message(__("Sorry, but you don't have permission to do that!", "quickusermanager"), get_bloginfo('url') . '/wp-admin/');
}
}
