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
}
}
