Version: 0.0.5
Last Updated: 2009-8-18
Requires bbPress Version: 0.8.2 or higher
Compatible up to: 0.9
Allows administrators to find and delete many users in bulk at once. Users are physically deleted from the bbPress / WordPress database based on a variety of attributes. Backup and undelete feature coming eventually.
USERS ARE DELETED PERMANENTLY - BE CAREFUL, BACKUP DATABASE FIRST
I have quite a few spam users (4,000+) from back before Human Test made it's way into the world. Mass Delete Users will be of great use to me. Do you have any plans of implementing the ability to check the users against http://www.stopforumspam.com/ or any other database of that sort?
In that case I'll surely wait :)
That's a good idea but might be awhile before I implement it.
It's also technically possible to re-check against akismet.
By the way, the plugin currently does a seperate db call for every delete (and then for meta) though the api as I have not written the routines yet to more efficiently delete with a single query so keep that in mind as you might get a nastygram from your host - don't try to delete all 4000 at once, do it in pages.
You might be able to find a pattern in email addresses to search by.
For example, while the ".ru" TLD is legit, many times bots use it.
So if you have an english site, and 1000 .ru registration with zero posts - there's something to delete.
Yeah, I know. A simple search for ".ru" gave me 445 users with zero posts. But of course, that's still 3,500 to go :)
By next weekend I hope to include a filter for number of posts (ie. users with zero posts)
That'd be fantastic! Cheers.
Hi _ck_, any update on this plugin comming soon? I'm asking as the filter for counting posts would be a great way to delete inactive users. thanks.
I haven't been feeling so great lately so I have not done much work on my plugins but I will try to look at this again this weekend.
Good news, I suddenly realized I can take a shortcut for now and instead of giving a pulldown to specify number of posts I can just give a toggle for "No Posts" which is a far easier mysql query.
So in 0.0.3 you can now turn on a filter with a checkbox to only show users without any posts.
It also checks for comments if you have WP integrated.
This plugin is one of my bbpress dreams. Thanks.
_ck_ that's excellent, works perfect and was able to remove lots of inactive users. Thank you and get well soon.
Hi,
I have a problem - when I click on the delete button the users don't delete...
Im using the latest version of the plugin and bbpress
Please upgrade to 0.0.4 when you see it here shortly.
hmmm I don't seem to have a "functions.bb-users.php" file or anything similar, apart from "users.php" in "bb-admin"
ah ok will look for your update, cheers!
Thanks for this fantastic plugin - it was quick and easy to activate and to use - wonderful!
This plugins does not avoid suppression of members which have subscribed for wordpress (when it is integrated, of course).
and also for guys "just inscribe since less than X days"
I used this MySQL query :
DELETE FROM wp_users WHERE ID IN (
SELECT ID
FROM (
SELECT u.ID, COUNT(p.post_id) nb_posts
FROM wp_users u LEFT JOIN bb_posts p ON poster_id = u.ID
WHERE DATEDIFF(now(),user_registered) > 93
AND NOT EXISTS ( SELECT * FROM wp_usermeta m
WHERE m.user_id=u.ID AND m.meta_key LIKE "wp_capabilities")
GROUP BY u.ID
ORDER BY nb_posts
) a
WHERE a.nb_posts=0
)This delete members which are not wordpress member (so only bb_press member)
and 93 days old (about 3 month)
could you add the filter "avoid wordpress users"
and the "registered date before ..." ?
Thank you _CK_ , bbPress would be poor without you.
I can confirm this plugin works with 1.02.
You must log in to post.