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/'); } }