[eduardosilva]

Greetings,

I have tons of spam users registered on my forum that never posted anything (I guess that most didn’t even got the password that is sent by mail).

I would like to cleanup my messy list of users, but without risking loosing additional information.

I’ve found this post http://www.blogercise.com/delete-spam-users-from-bbpress-2/

DELETE *
FROM wp_users
WHERE ID NOT IN
(SELECT post_author FROM wp_posts
UNION SELECT user_id FROM wp_comments)

and metadata:

DELETE A FROM wp_usermeta A
LEFT JOIN wp_users ON user_id=ID
WHERE ID is NULL

Just wondering if this select is safe enough to cleanup all users who never started or replied a topic.
Any chances on deleting an active user?

btw:
Running wordpress 4 and bbpress 2.5.6 (this forum was imported from bbpress standalone, I guess that it was version 1.4)

Thanks

[Robkk]

if you want use this plugin and provide use some information on how it does for your installation.

it requires Akismet, and basically it rescans all your topics and replies for spam.

the settings should be in tools > bbpress spam cleaner.

https://github.com/lenrsmith/bbpress-spam-cleaner

another tool that might help is wanguard.

https://wordpress.org/plugins/wangguard/