Removing Spam users
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)
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?
Running wordpress 4 and bbpress 2.5.6 (this forum was imported from bbpress standalone, I guess that it was version 1.4)
- You must be logged in to reply to this topic.