• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

How do I prune profile posts

cmeinck

Well-known member
#1
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

Well-known member
#2
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:

Code:
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.