function wppb_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->wppb_process_bulk_action_message(sprintf(__("%s couldn't be deleted", "profile-builder"), $result->user_login), get_bloginfo('url') . '/wp-admin/users.php?page=unconfirmed_emails'); } } $this->wppb_process_bulk_action_message(__('All users have been successfully deleted', 'profile-builder'), 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) { wppb_manual_activate_signup($sql_result['activation_key']); } } $this->wppb_process_bulk_action_message(__('The selected users have been activated', 'profile-builder'), 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) { wppb_signup_user_notification(esc_sql($sql_result['user_login']), esc_sql($sql_result['user_email']), $sql_result['activation_key'], $sql_result['meta']); } } $this->wppb_process_bulk_action_message(__('The selected users have had their activation emails resent', 'profile-builder'), get_bloginfo('url') . '/wp-admin/users.php?page=unconfirmed_emails'); } } else { $this->wppb_process_bulk_action_message(__("Sorry, but you don't have permission to do that!", "profile-builder"), get_bloginfo('url') . '/wp-admin/'); } }
function wppb_handle_email_confirmation_cases() { global $current_user; global $wpdb; //die($current_user); $url = trim($_POST['URL']); $todo = trim($_POST['todo']); $userID = trim($_POST['userID']); if (current_user_can('delete_users')) { if ($todo != '' && $userID != '') { $iterator = 0; $result = mysql_query("SELECT * FROM " . $wpdb->prefix . "signups WHERE active=0"); if ($todo == 'delete') { while ($row = mysql_fetch_row($result)) { if ((string) $iterator === $userID) { $result2 = mysql_query("DELETE FROM " . $wpdb->prefix . "signups WHERE user_login='******' AND user_email='" . $row[4] . "'"); if ($result2) { die('ok'); } else { $failed = __("The selected user couldn't be deleted.", "profilebuilder"); die($failed); } } $iterator++; } } elseif ($todo == 'confirm') { while ($row = mysql_fetch_row($result)) { if ((string) $iterator === $userID) { $ret = wppb_manual_activate_signup($row[8]); die($ret); } $iterator++; } } } } $failed = __("You either don't have permission for that action or there was an error!", "profilebuilder"); die($failed); }
function wppb_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->prefix . "signups WHERE active = 0 AND user_email = %s", $user_email)); if (count($results) != 1) { die(__("There was an error performing that action!", "profilebuilder")); } elseif ($todo == 'delete') { $sql_result = $wpdb->delete($wpdb->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", "profilebuilder")); } } elseif ($todo == 'confirm') { die(wppb_manual_activate_signup($results[0]->activation_key)); } elseif ($todo == 'resend') { $sql_result = $wpdb->get_row($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "signups WHERE user_login = %s AND user_email = %s", $results[0]->user_login, $results[0]->user_email), ARRAY_A); if ($sql_result) { wppb_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", "profilebuilder")); } } } } die(__("You either don't have permission for that action or there was an error!", "profilebuilder")); }
/** ************************************************************************ * Optional. You can handle your bulk actions anywhere or anyhow you prefer. * For this example package, we will handle it in the class to keep things * clean and organized. * * @see $this->prepare_items() **************************************************************************/ function process_bulk_action() { global $current_user; global $wpdb; if (current_user_can('delete_users')) { $iterator = 0; $bulkResult = mysql_query("SELECT * FROM " . $wpdb->prefix . "signups WHERE active=0"); //Detect when a bulk action is being triggered... if ('delete' === $this->current_action()) { while ($bulkRow = mysql_fetch_row($bulkResult)) { if (in_array((string) $iterator, $_GET['user'])) { $bulkResult1 = mysql_query("DELETE FROM " . $wpdb->prefix . "signups WHERE user_login='******' AND user_email='" . $bulkRow[4] . "'"); if (!$bulkResult1) { $message = $bulkRow[3] . __("couldn't be deleted.", "profilebuilder"); ?> <script type="text/javascript"> confirmECActionBulk('<?php echo get_bloginfo('url') . '/wp-admin/users.php?page=unconfirmed_emails'; ?> ', '<?php echo $message; ?> '); </script> <?php } } $iterator++; } $message = __("All users have been successfully deleted.", "profilebuilder"); ?> <script type="text/javascript"> confirmECActionBulk('<?php echo get_bloginfo('url') . '/wp-admin/users.php?page=unconfirmed_emails'; ?> ', '<?php echo $message; ?> '); </script> <?php } elseif ('confirm' === $this->current_action()) { while ($bulkRow = mysql_fetch_row($bulkResult)) { if (in_array((string) $iterator, $_GET['user'])) { $ret = wppb_manual_activate_signup($bulkRow[8]); } $iterator++; } $message = __("The selected users have been activated.", "profilebuilder"); ?> <script type="text/javascript"> confirmECActionBulk('<?php echo get_bloginfo('url') . '/wp-admin/users.php?page=unconfirmed_emails'; ?> ', '<?php echo $message; ?> '); </script> <?php } } else { $message = __("Sorry, but you don't have permission to do that!", "profilebuilder"); ?> <script type="text/javascript"> confirmECActionBulk('<?php echo get_bloginfo('url') . '/wp-admin/'; ?> ', '<?php echo $message; ?> '); </script> <?php } }