/**
* Executes an scheduled job
* @param int $cronid
*/
function wangguard_cronjob_runner($cronid)
{
global $wpdb, $wangguard_api_key, $wangguard_cronjob_actions_options, $wangguard_is_network_admin;
if (wangguard_is_multisite()) {
$spamFieldName = "spam";
} else {
$spamFieldName = "user_status";
}
//get job ID
$cronid = (int) $cronid;
$cronjobs_table_name = $wpdb->base_prefix . "wangguardcronjobs";
$wgcron = $wpdb->get_results("select * from {$cronjobs_table_name} where id = {$cronid}");
if (!isset($wgcron[0])) {
return;
}
//init vars
$cronjob = $wgcron[0];
$checkedUsers = $detectedSploggers = 0;
$cleanUsers = array();
$sploggersUsers = array();
$message = 'WangGuard Cron Job # ' . $cronid . "\n\n";
//setup cron args
$args = array((int) $cronjob->id);
//delete the job, prevents being locked and runned again, WP should re schedule it
$timestamp = wp_next_scheduled('wangguard_cronjob_runner', $args);
wp_unschedule_event($timestamp, 'wangguard_cronjob_runner', $args);
//store last run time
$wpdb->query("update {$cronjobs_table_name} set LastRun = CURRENT_TIMESTAMP where id = {$cronid}");
//re schedule the job at the configured time
$timestampNextRun = wangguard_get_next_schedule($cronjob->RunOn, $cronjob->RunAt);
wp_schedule_single_event($timestampNextRun, 'wangguard_cronjob_runner', $args);
$humanizedNextRun = date(get_option('date_format') . ' ' . get_option('time_format'), $timestampNextRun);
//api key is valid?
$valid = wangguard_verify_key($wangguard_api_key);
if ($valid == 'failed' || $valid == 'invalid') {
$message .= __('Your WangGuard API KEY is invalid.', 'wangguard');
} else {
$userStatusTable = $wpdb->base_prefix . "wangguarduserstatus";
$message .= __("Action", 'wangguard') . ": " . $wangguard_cronjob_actions_options[$cronjob->Action] . "\n\n";
$timeFrom = mktime(0, 0, 0, date('n'), date('j'), date('Y')) - $cronjob->UsersTF * 86400;
set_time_limit(300);
$goodUsers = $wpdb->get_col("select ID from {$wpdb->users} where user_registered >= FROM_UNIXTIME( {$timeFrom} )");
if (count($goodUsers)) {
$message .= sprintf(__("Verifying %d new users since", 'wangguard'), count($goodUsers)) . ' ' . date(get_option('date_format'), $timeFrom) . "\n\n";
foreach ($goodUsers as $userid) {
$user_check_status = "-";
set_time_limit(120);
$user_object = new WP_User($userid);
//get the WangGuard user status, if status is force-checked then ignore the user
$user_status = $wpdb->get_var($wpdb->prepare("select user_status from {$userStatusTable} where ID = %d", $userid));
if ($user_status == 'force-checked' || $user_status == 'buyer') {
$user_check_status = "force-checked";
} else {
//verify the user only if it's not already flagged
$user_check_status = $user_status != "reported" ? wangguard_verify_user($user_object) : "reported";
}
$checkedUsers++;
if ($user_check_status == "reported") {
//user was detected as splogger
$detectedSploggers++;
$sploggersUsers[] = $user_object->display_name . " (" . $user_object->user_email . ")";
//what to do with this user
switch ($cronjob->Action) {
case "f":
// Now we mark a user as spam, there is a problem related to BuddyPress permissions, so the splogger activity will not removed. http://buddypress.trac.wordpress.org/ticket/5233
if (function_exists('update_user_status')) {
update_user_status($userid, 'spam', '1');
} else {
$wpdb->query($wpdb->prepare("update {$wpdb->users} set {$spamFieldName} = 1 where ID = %d", $userid));
}
break;
case "d":
//Delete detected Sploggers----------------------------------------------------------------------------------------------------------
wangguard_delete_user_and_blogs($userid);
break;
}
} else {
$cleanUsers[] = $user_object->display_name . " (" . $user_object->user_email . ")";
}
}
if (count($cleanUsers)) {
$message .= __("--- Verified Users ---", 'wangguard') . "\n" . implode("\n", $cleanUsers) . "\n\n";
}
if (count($sploggersUsers)) {
$message .= __("--- Detected Sploggers ---", 'wangguard') . "\n" . implode("\n", $sploggersUsers) . "\n\n";
}
} else {
$message .= __("No new users to verify since ", 'wangguard') . date(get_option('date_format'), $timeFrom);
}
}
//bottom link
$urlFunc = "admin_url";
if ($wangguard_is_network_admin && function_exists("network_admin_url")) {
$urlFunc = "network_admin_url";
}
$site_url = $urlFunc("admin.php?page=wangguard_users");
$message .= "\n\n" . __("Next run ", "wangguard") . $humanizedNextRun;
$message .= "\n\n" . __("Click here to manage users: ", "wangguard") . "\n" . $site_url;
$message .= "\n\nWangGuard - www.wangguard.com";
//Notify admin
$admin_email = get_site_option('admin_email');
if ($admin_email == '') {
$admin_email = 'support@' . $_SERVER['SERVER_NAME'];
}
$from_name = get_site_option('site_name') == '' ? 'WordPress' : esc_html(get_site_option('site_name'));
$message_headers = "From: \"{$from_name}\" <{$admin_email}>\n" . "Content-Type: text/plain; charset=\"" . get_option('blog_charset') . "\"\n";
if (is_multisite()) {
$current_site = new stdClass();
$current_site = get_current_site();
} else {
$current_site = new stdClass();
}
if (empty($current_site->site_name)) {
$current_site->site_name = 'WordPress';
}
$subject = sprintf('WangGuard Cron Job # ' . $cronid . ' - ' . __('Verified: %d - Sploggers: %d'), $checkedUsers, $detectedSploggers);
@wp_mail($admin_email, $subject, $message, $message_headers);
}
function wangguard_wizard()
{
global $wpdb, $wangguard_nonce, $wangguard_api_key, $wangguard_is_network_admin;
$urlFunc = "admin_url";
if ($wangguard_is_network_admin && function_exists("network_admin_url")) {
$urlFunc = "network_admin_url";
}
if (wangguard_is_multisite()) {
$spamFieldName = "spam";
$sqlSpamWhere = "spam = 1";
$sqlNoSpamWhere = "spam = 0";
} else {
$spamFieldName = "user_status";
$sqlSpamWhere = "user_status = 1";
$sqlNoSpamWhere = "user_status <> 1";
}
if (!current_user_can('level_10')) {
die(__('Cheatin’ uh?', 'wangguard'));
}
$step = 0;
if (isset($_REQUEST['wangguard_step'])) {
$step = (int) $_REQUEST['wangguard_step'];
}
if (isset($_POST['submit']) || !empty($step)) {
check_admin_referer($wangguard_nonce);
}
?>
<div class="wrap" id="wangguard-wizard-cont">
<div class="wangguard-confico"><img src="<?php
echo WP_PLUGIN_URL;
?>
/wangguard/img/wizard.png" alt="<?php
echo htmlentities(__('WangGuard Wizard', 'wangguard'));
?>
" /></div>
<div class="icon32" id="icon-wangguard"><br></div>
<h2><?php
_e('WangGuard Wizard', 'wangguard');
?>
</h2>
<script type="text/javascript">
function wangguard_progress() {
jQuery("#wangguard-visible-step-status").hide();
jQuery("#wangguard-hidden-step-status").show();
return true;
}
jQuery(document).ready(function() {
jQuery(".wangguard-hidewhendone").hide();
});
</script>
<form action="admin.php" method="get" id="wangguardWizardForm" name="wangguardWizardForm" onsubmit="return wangguard_progress()">
<input type="hidden" name="page" value="wangguard_wizard" />
<?php
echo wp_nonce_field($wangguard_nonce);
?>
<?php
switch ($step) {
case "1":
?>
<div id="wangguard-visible-step-status">
<h3><?php
echo __("Reporting spam users to WangGuard...", "wangguard");
?>
</h3>
<?php
$usersPerStint = 50;
//how many users to check on each iteration
$fromUser = isset($_REQUEST['wangguard_wiz_from']) ? (int) $_REQUEST['wangguard_wiz_from'] : 0;
if ($fromUser < 0) {
$fromUser = 0;
}
$spamUsersTotal = $wpdb->get_col("select count(*) from {$wpdb->users} where {$sqlSpamWhere}");
$spamUsersTotal = $spamUsersTotal[0];
$step1Finished = $fromUser > 0 && $fromUser >= $spamUsersTotal;
if (!$step1Finished) {
$spamUsers = $wpdb->get_col("select ID from {$wpdb->users} where {$sqlSpamWhere} order by ID LIMIT {$fromUser} , {$usersPerStint}");
$userCount = count($spamUsers);
$reportingUserFrom = $fromUser + $usersPerStint;
$reportingUserFrom = $reportingUserFrom > $spamUsersTotal ? $spamUsersTotal : $reportingUserFrom;
if ($userCount == 0) {
?>
<p><?php
echo __("No spam users were found on your site. Click the button below to check your users.", "wangguard");
?>
</p>
<input type="hidden" name="wangguard_step" value="2" />
<p class="submit"><input type="submit" name="submit" class="button-primary" value="<?php
_e('Continue', 'wangguard');
?>
" /></p>
<?php
} else {
?>
<p><img id="wangguard-progress-wait" style="vertical-align: middle; margin-right: 8px;" src="<?php
echo esc_url(admin_url('images/wpspin_light.gif'));
?>
" alt="..." /><?php
echo sprintf(__("The WangGuard wizard is reporting %d of %d spam users as Sploggers.", "wangguard"), $reportingUserFrom, $spamUsersTotal);
?>
</p>
<?php
@flush();
?>
<?php
@ob_flush();
?>
<?php
$progress = 0;
$reported = 0;
$lastProgressSent = 0;
foreach ($spamUsers as $userid) {
//get the WangGuard user status, if status is force-checked then ignore the user
$table_name = $wpdb->base_prefix . "wangguarduserstatus";
$user_status = $wpdb->get_var($wpdb->prepare("select user_status from {$table_name} where ID = %d", $userid));
if ($user_status == 'force-checked') {
continue;
}
$dummyArr = array();
$dummyArr[] = $userid;
set_time_limit(15);
wangguard_report_users($dummyArr, "email", false);
$reported++;
}
?>
<input type="hidden" name="wangguard_wiz_from" value="<?php
echo $fromUser + $usersPerStint;
?>
" />
<script type="text/javascript">
document.getElementById('wangguardWizardForm').onsubmit='';
jQuery(document).ready(function() {
location.href='admin.php?page=wangguard_wizard&wangguard_step=1&wangguard_wiz_from=<?php
echo $fromUser + $usersPerStint;
?>
&_wpnonce=<?php
echo wp_create_nonce($wangguard_nonce);
?>
';
});
</script>
<input type="hidden" name="wangguard_step" value="1" />
<?php
}
?>
<?php
} else {
?>
<p><?php
echo __("The WangGuard wizard has finished reporting spam users. Click the button below to check the rest of your users.", "wangguard");
?>
</p>
<input type="hidden" name="wangguard_step" value="2" />
<p class="submit"><input type="submit" name="submit" class="button-primary" value="<?php
_e('Continue', 'wangguard');
?>
" /></p>
<?php
}
?>
</div>
<?php
if ($step1Finished) {
?>
<div id="wangguard-hidden-step-status" style="display: none">
<h3><?php
echo __("Verifying users against the WangGuard service...", "wangguard");
?>
</h3>
<?php
$goodUsers = $wpdb->get_col("select ID from {$wpdb->users} where {$sqlNoSpamWhere}");
$userCount = count($goodUsers);
if ($userCount == 0) {
?>
<p><img id="wangguard-progress-wait" style="vertical-align: middle; margin-right: 8px;" src="<?php
echo esc_url(admin_url('images/wpspin_light.gif'));
?>
" alt="..." /></p>
<?php
} else {
?>
<p><img id="wangguard-progress-wait" style="vertical-align: middle; margin-right: 8px;" src="<?php
echo esc_url(admin_url('images/wpspin_light.gif'));
?>
" alt="..." /><?php
echo sprintf(__("The WangGuard wizard is verifying %d users against the WangGuard service.", "wangguard"), $userCount);
?>
</p>
<?php
}
?>
</div>
<?php
}
?>
<?php
break;
case "2":
?>
<div id="wangguard-visible-step-status">
<h3><?php
echo __("Verifying users against the WangGuard service...", "wangguard");
?>
</h3>
<?php
$usersPerStint = 50;
//how many users to check on each iteration
$fromUser = isset($_REQUEST['wangguard_wiz_from']) ? (int) $_REQUEST['wangguard_wiz_from'] : 0;
if ($fromUser < 0) {
$fromUser = 0;
}
$goodUsersTotal = $wpdb->get_col("select count(*) from {$wpdb->users} where {$sqlNoSpamWhere}");
$goodUsersTotal = $goodUsersTotal[0];
$step2Finished = $fromUser > 0 && $fromUser >= $goodUsersTotal;
$reported = isset($_REQUEST['reported']) ? (int) $_REQUEST['reported'] : 0;
$noUsersToCheck = false;
if (!$step2Finished) {
$goodUsers = $wpdb->get_col("select ID from {$wpdb->users} where {$sqlNoSpamWhere} ORDER BY ID LIMIT {$fromUser} , {$usersPerStint}");
$userCount = count($goodUsers);
$reportingUserFrom = $fromUser + $usersPerStint;
$reportingUserFrom = $reportingUserFrom > $goodUsersTotal ? $goodUsersTotal : $reportingUserFrom;
if ($userCount == 0) {
$step2Finished = true;
$noUsersToCheck = true;
?>
<p><?php
echo __("No users were found on your site.", "wangguard");
?>
</p>
<?php
} else {
?>
<p><img id="wangguard-progress-wait" style="vertical-align: middle; margin-right: 8px;" src="<?php
echo esc_url(admin_url('images/wpspin_light.gif'));
?>
" alt="..." /><?php
echo sprintf(__("The WangGuard wizard is verifying %d of %d users against the WangGuard service.", "wangguard"), $reportingUserFrom, $goodUsersTotal);
?>
</p>
<?php
@flush();
?>
<?php
@ob_flush();
?>
<?php
$progress = 0;
$verified = 0;
$lastProgressSent = 0;
foreach ($goodUsers as $userid) {
//get the WangGuard user status, if status is force-checked then ignore the user
$table_name = $wpdb->base_prefix . "wangguarduserstatus";
$user_status = $wpdb->get_var($wpdb->prepare("select user_status from {$table_name} where ID = %d", $userid));
if ($user_status == 'force-checked') {
continue;
}
$dummyArr = array();
$dummyArr[] = $userid;
$user_object = new WP_User($userid);
set_time_limit(15);
$user_check_status = wangguard_verify_user($user_object);
if ($user_check_status == "reported") {
$reported++;
if (function_exists("update_user_status")) {
update_user_status($userid, $spamFieldName, 1);
} else {
$wpdb->query($wpdb->prepare("update {$wpdb->users} set {$spamFieldName} = 1 where ID = %d", $userid));
}
}
$verified++;
}
?>
<input type="hidden" name="wangguard_wiz_from" value="<?php
echo $fromUser + $usersPerStint;
?>
" />
<script type="text/javascript">
document.getElementById('wangguardWizardForm').onsubmit='';
jQuery(document).ready(function() {
location.href='admin.php?page=wangguard_wizard&wangguard_step=2&reported=<?php
echo $reported;
?>
&wangguard_wiz_from=<?php
echo $fromUser + $usersPerStint;
?>
&_wpnonce=<?php
echo wp_create_nonce($wangguard_nonce);
?>
';
});
</script>
<input type="hidden" name="wangguard_step" value="2" />
<?php
}
}
if ($step2Finished) {
$table_name = $wpdb->base_prefix . "wangguarduserstatus";
$reportedUsers = $wpdb->get_col("select count(*) from {$table_name} where user_status IN ( 'reported', 'autorep' )");
$reportedUsersCount = $reportedUsers[0];
if (!$noUsersToCheck) {
?>
<p><?php
echo sprintf(__("The WangGuard wizard has finished verifying your users and found <strong>%d</strong> Sploggers.", "wangguard"), $reported);
?>
</p>
<?php
}
?>
<input type="hidden" name="wangguard_step" value="3" />
<input type="hidden" name="wangguard_splogcnt" value="<?php
echo $reportedUsersCount;
?>
" />
<?php
if ($reportedUsersCount) {
?>
<p><?php
echo sprintf(__("There are <strong>%d</strong> users identified as Sploggers, you can delete them or manage them by clicking the buttons below.", "wangguard"), $reportedUsersCount);
?>
</p>
<?php
}
?>
<div id="wangguard-visible-step-status">
<input type="hidden" value="" name="wangguard_delete_splogguers" id="wangguard_delete_splogguers" />
<p class="submit">
<?php
if ($reportedUsersCount) {
?>
<input type="submit" name="do_wangguard_delete_splogguers" class="button-primary" id="do_wangguard_delete_splogguers" value="<?php
_e('Delete all Sploggers', 'wangguard');
?>
" />
<input type="button" name="button" class="button-primary" onclick="document.location='admin.php?page=wangguard_users&type=spl'" value="<?php
_e('Manage Sploggers', 'wangguard');
?>
" />
<?php
}
?>
<input type="submit" name="submit" class="button-primary" value="<?php
_e('Finish', 'wangguard');
?>
" />
</p>
</div>
<script type="text/javascript">
jQuery(document).ready(function() {
jQuery("#do_wangguard_delete_splogguers").click(function() {
if (confirm('<?php
echo addslashes(__('Do you confirm to delete all Sploggers?', 'wangguard'));
?>
')) {
jQuery('#wangguard_delete_splogguers').val('1');
return true;
}
else
return false;
});
});
</script>
<div id="wangguard-hidden-step-status" style="display: none">
<p><img id="wangguard-progress-wait" style="vertical-align: middle; margin-right: 8px;" src="<?php
echo esc_url(admin_url('images/wpspin_light.gif'));
?>
" alt="..." /></p>
</div>
<?php
}
?>
</div>
<?php
break;
case "3":
if (@$_REQUEST['wangguard_delete_splogguers'] == 1) {
$usersPerStint = 10;
//how many users to check on each iteration
$table_name = $wpdb->base_prefix . "wangguarduserstatus";
$reportedUsers = $wpdb->get_col("select ID from {$table_name} where user_status IN ( 'reported', 'autorep' ) LIMIT 0 , {$usersPerStint}");
$reportedUsersCount = count($reportedUsers);
$reportedUsersTotal = (int) @$_REQUEST['wangguard_splogcnt'];
$reportingUserFrom = (int) @$_REQUEST['wangguard_wiz_from'];
$reportingUserFrom = $reportingUserFrom > $reportedUsersTotal ? $reportedUsersTotal : $reportingUserFrom;
$step3Finished = $reportedUsersCount == 0;
if (!$step3Finished) {
?>
<h3><?php
echo __("Deleting Splogguers from your site...", "wangguard");
?>
</h3>
<p><img id="wangguard-progress-wait" style="vertical-align: middle; margin-right: 8px;" src="<?php
echo esc_url(admin_url('images/wpspin_light.gif'));
?>
" alt="..." /><?php
echo sprintf(__("The WangGuard wizard is deleting %d of %d Splogguers from your site.", "wangguard"), $reportingUserFrom, $reportedUsersTotal);
?>
</p>
<?php
@flush();
?>
<?php
@ob_flush();
?>
<?php
foreach ($reportedUsers as $userid) {
set_time_limit(15);
wangguard_delete_user_and_blogs($userid);
}
?>
<script type="text/javascript">
document.getElementById('wangguardWizardForm').onsubmit='';
jQuery(document).ready(function() {
location.href='admin.php?page=wangguard_wizard&wangguard_step=3&wangguard_delete_splogguers=1&wangguard_splogcnt=<?php
echo $reportedUsersTotal;
?>
&wangguard_wiz_from=<?php
echo $reportingUserFrom + $usersPerStint;
?>
&_wpnonce=<?php
echo wp_create_nonce($wangguard_nonce);
?>
';
});
</script>
<?php
} else {
?>
<h3><?php
echo __("The WangGuard Wizard has finished", "wangguard");
?>
</h3>
<p><?php
echo sprintf(__("%d sploggers users has been deleted from your site.", "wangguard"), $reportedUsersTotal);
?>
</p>
<p><a class="button-primary" href="<?php
echo $urlFunc('admin.php?page=wangguard_users');
?>
"><?php
echo __('Click here to manage your Users', 'wangguard');
?>
</a></p>
<?php
}
} else {
?>
<h3><?php
echo __("The WangGuard Wizard has finished", "wangguard");
?>
</h3>
<p><a class="button-primary" href="<?php
echo $urlFunc('admin.php?page=wangguard_users');
?>
"><?php
echo __('Click here to manage your Users', 'wangguard');
?>
</a></p>
<?php
}
break;
default:
?>
<div id="wangguard-visible-step-status">
<h3><?php
echo __("Welcome to the WangGuard Wizard", "wangguard");
?>
</h3>
<p><?php
echo __("This wizard will perform the following actions on your WordPress installation", "wangguard");
?>
</p>
<ol>
<li><?php
echo __("It will report to WangGuard all users you have flagged as 'spam' on your site.", "wangguard");
?>
</li>
<li><?php
echo __("For the rest of the users, it will check against WangGuard service if any of them was reported as Splogger.", "wangguard");
?>
</li>
<li><?php
echo __("It will let you know how many Sploggers the wizard found (if any) and, optionally, will let you delete your spam users and Sploggers from your site.", "wangguard");
?>
</li>
</ol>
<p><?php
echo sprintf(__("Note: The wizard will NOT verify the users flagged as %s, these are the users for which you've selected the "Not a Splogger" option from the Users admin or flagged as "Not Spam".", "wangguard"), "<span class='wangguard-status-checked'>" . __("Checked (forced)", "wangguard") . "</span>");
?>
</p>
<?php
$valid = wangguard_verify_key($wangguard_api_key);
if ($valid == 'failed' || $valid == 'invalid') {
?>
<p class="wangguard-info wangguard-error" style="margin-right: 20px;"><?php
echo __('Your WangGuard API KEY is invalid.', 'wangguard');
?>
</p>
<?php
} else {
?>
<p><?php
echo __("Click the button below when you're ready to clean your site!.", "wangguard");
?>
</p>
<input type="hidden" name="wangguard_step" value="1" />
<p class="submit"><input type="submit" name="submit" class="button-primary" value="<?php
_e('Start cleaning my site!', 'wangguard');
?>
" /></p>
<?php
}
?>
</div>
<div id="wangguard-hidden-step-status" style="display: none">
<h3><?php
echo __("Reporting spam users to WangGuard...", "wangguard");
?>
</h3>
<?php
$spamUsers = $wpdb->get_col("select ID from {$wpdb->users} where {$sqlSpamWhere}");
$userCount = count($spamUsers);
if ($userCount == 0) {
?>
<p><img id="wangguard-progress-wait" style="vertical-align: middle; margin-right: 8px;" src="<?php
echo esc_url(admin_url('images/wpspin_light.gif'));
?>
" alt="..." /></p>
<?php
} else {
?>
<p><img id="wangguard-progress-wait" style="vertical-align: middle; margin-right: 8px;" src="<?php
echo esc_url(admin_url('images/wpspin_light.gif'));
?>
" alt="..." /><?php
echo sprintf(__("The WangGuard wizard is reporting %d spam users as Sploggers.", "wangguard"), $userCount);
?>
</p>
<?php
}
?>
</div>
<?php
break;
}
?>
</form>
</div>
<?php
}
function wangguard_report_users($wpusersRs, $scope = "email", $deleteUser = true)
{
global $wangguard_api_key;
global $wpdb;
$valid = wangguard_verify_key($wangguard_api_key);
if ($valid == 'failed') {
echo "-2";
die;
} else {
if ($valid == 'invalid') {
echo "-1";
die;
}
}
if (!$wpusersRs) {
return "0";
}
$deleteUser = get_site_option("wangguard-delete-users-on-report") == '1';
$usersFlagged = array();
foreach ($wpusersRs as $spuserID) {
$user_object = new WP_User($spuserID);
if (!wangguard_is_admin($user_object)) {
if (!empty($user_object->user_email)) {
//Get the user's client IP from which he signed up
$table_name = $wpdb->base_prefix . "wangguarduserstatus";
$clientIP = $wpdb->get_var($wpdb->prepare("select user_ip from {$table_name} where ID = %d", $user_object->ID));
$ProxyIP = $wpdb->get_var($wpdb->prepare("select user_proxy_ip from {$table_name} where ID = %d", $user_object->ID));
if ($scope == 'domain') {
$response = wangguard_http_post("wg=<in><apikey>{$wangguard_api_key}</apikey><domain>" . wangguard_extract_domain($user_object->user_email) . "</domain><ip>" . $clientIP . "</ip><proxyip>" . $ProxyIP . "</proxyip></in>", 'add-domain.php');
} elseif ($scope == 'email') {
$response = wangguard_http_post("wg=<in><apikey>{$wangguard_api_key}</apikey><email>" . $user_object->user_email . "</email><ip>" . $clientIP . "</ip><proxyip>" . $ProxyIP . "</proxyip></in>", 'add-email.php');
}
}
if ($deleteUser && current_user_can('delete_users')) {
wangguard_delete_user_and_blogs($spuserID);
} else {
global $wpdb;
$table_name = $wpdb->base_prefix . "wangguarduserstatus";
$recordExists = $wpdb->get_var($wpdb->prepare("select ID from {$table_name} where ID = %d", $spuserID));
if ($recordExists) {
//Update the new status
$table_name = $wpdb->base_prefix . "wangguarduserstatus";
$wpdb->query($wpdb->prepare("update {$table_name} set user_status = 'reported' where ID = '%d'", $spuserID));
} else {
//if for some reason user status record doesn't exists, create it
//Try to get the user's client IP from which he signed up
$table_name = $wpdb->base_prefix . "wangguardsignupsstatus";
$clientIP = $wpdb->get_var($wpdb->prepare("select user_ip from {$table_name} where signup_username = %s", $user_object->user_login));
$clientIP = is_null($clientIP) ? '' : $clientIP;
$ProxyIP = $wpdb->get_var($wpdb->prepare("select user_proxy_ip from {$table_name} where signup_username = %s", $user_object->user_login));
$ProxyIP = is_null($ProxyIP) ? '' : $ProxyIP;
//create the record
$table_name = $wpdb->base_prefix . "wangguarduserstatus";
$wpdb->query($wpdb->prepare("insert into {$table_name}(ID , user_status , user_ip , user_proxy_ip) values (%d , 'reported' , '%s' , '%s')", $spuserID, $clientIP, $ProxyIP));
}
}
$usersFlagged[] = $spuserID;
} else {
//-Admin user-
//do nothing
}
}
if (count($usersFlagged)) {
return implode(",", $usersFlagged);
} else {
return "0";
}
}
