How do I prune profile posts

[cmeinck]

I'm working hard to remove any sort of spam from my forums. I've restricted view user access to registered only. Still, I'd like to clean up some assorted profiles that I've found left from vBulletin.

Is there a way to delete profile posts from users with 'x' number of posts?

 

[borbole]

I'm working hard to remove any sort of spam from my forums. I've restricted view user access to registered only. Still, I'd like to clean up some assorted profiles that I've found left from vBulletin.

Is there a way to delete profile posts from users with 'x' number of posts?

Run this query:

UPDATE `xf_profile_post`
LEFT JOIN `xf_user`
ON
(xf_user.user_id = xf_profile_post.user_id)
SET xf_profile_post.message = '' WHERE xf_user.message_count < x;

Replace x with the number of posts and if you are using a different prefix for your db tables other than xf_, replace it at the query above.

 

[cmeinck]

Thanks so much. Your queries have been a huge help.

 

[borbole]

Thanks so much. Your queries have been a huge help.

Glad to have been of help