prefix;
$result = "";
if (isset($_POST['info_update'])) {
// start processing
?>get_results("
SELECT {$tp}users.ID, {$tp}users.user_login
FROM {$tp}users
LEFT JOIN {$tp}posts ON {$tp}users.ID = {$tp}posts.post_author
LEFT JOIN {$tp}comments ON {$tp}users.ID = {$tp}comments.user_id
LEFT JOIN {$tp}usermeta ON {$tp}users.ID = {$tp}usermeta.user_id
WHERE {$tp}posts.post_author is NULL
AND {$tp}comments.user_id is NULL
AND {$tp}usermeta.meta_key = 'wp_capabilities'
{$skip_check}
");
foreach ($userlist as $u) {
wp_delete_user($u->ID);
}
$result = 'Users deleted: ' . count($userlist);
} else {
$result = 'No option selected!';
}
// end processing
} ?>
';
}
?>