bbPress Plugin Browser » Topic: Mass Delete Users

convurg on "Mass Delete Users"

convurg — Thu, 28 Apr 2011 20:12:48 +0000

This plugin is not working for version 1.0.2, is there a fix on the way?

PS Vita Games on "Mass Delete Users"

PS Vita Games — Wed, 16 Mar 2011 11:56:44 +0000

Thanks for the plugin

FakePlasticFish on "Mass Delete Users"

FakePlasticFish — Sat, 03 Apr 2010 02:43:51 +0000

Hi. For some reason, my deleted users keep reappearing. I keep deleting all users that have 0 posts and include .ru in their email address, and all of those exact users keep reappearing on the list. Any suggestions? I just loaded this plugin today, so I assume I have the latest version.

http://fakeplasticfish.com/discuss/

Marius- on "Mass Delete Users"

Marius- — Thu, 05 Nov 2009 19:49:15 +0000

I can confirm this plugin works with 1.02.

thierryyyyyyy on "Mass Delete Users"

thierryyyyyyy — Sat, 25 Apr 2009 09:13:44 +0000

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.

debrobinson on "Mass Delete Users"

debrobinson — Wed, 15 Apr 2009 05:42:02 +0000

Thanks for this fantastic plugin - it was quick and easy to activate and to use - wonderful!

sceno on "Mass Delete Users"

sceno — Fri, 03 Apr 2009 14:58:21 +0000

ah ok will look for your update, cheers!

sceno on "Mass Delete Users"

sceno — Fri, 03 Apr 2009 14:57:25 +0000

hmmm I don't seem to have a "functions.bb-users.php" file or anything similar, apart from "users.php" in "bb-admin"

_ck_ on "Mass Delete Users"

_ck_ — Fri, 03 Apr 2009 14:47:56 +0000

Please upgrade to 0.0.4 when you see it here shortly.

sceno on "Mass Delete Users"

sceno — Fri, 03 Apr 2009 13:51:00 +0000

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

Softland on "Mass Delete Users"

Softland — Fri, 27 Mar 2009 07:31:32 +0000

_ck_ that's excellent, works perfect and was able to remove lots of inactive users. Thank you and get well soon.

wiseacre on "Mass Delete Users"

wiseacre — Thu, 26 Mar 2009 20:44:58 +0000

This plugin is one of my bbpress dreams. Thanks.

_ck_ on "Mass Delete Users"

_ck_ — Thu, 26 Mar 2009 03:31:38 +0000

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.

_ck_ on "Mass Delete Users"

_ck_ — Wed, 25 Mar 2009 14:18:33 +0000

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.

Softland on "Mass Delete Users"

Softland — Wed, 25 Mar 2009 13:35:24 +0000

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.

Rene Clausen Nielsen on "Mass Delete Users"

Rene Clausen Nielsen — Tue, 10 Mar 2009 08:44:51 +0000

That'd be fantastic! Cheers.

_ck_ on "Mass Delete Users"

_ck_ — Mon, 09 Mar 2009 23:25:08 +0000

By next weekend I hope to include a filter for number of posts (ie. users with zero posts)

Rene Clausen Nielsen on "Mass Delete Users"

Rene Clausen Nielsen — Mon, 09 Mar 2009 22:13:11 +0000

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 :)

_ck_ on "Mass Delete Users"

_ck_ — Mon, 09 Mar 2009 18:01:34 +0000

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.

Rene Clausen Nielsen on "Mass Delete Users"

Rene Clausen Nielsen — Mon, 09 Mar 2009 15:50:55 +0000

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 :)