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

Delete all of members posts

#1
How do i delete all of a users posts. I can do it inline but if there are a bunch of pages how can I delete the posts without doing it page by page?
 

borbole

Well-known member
#3
How do i delete all of a users posts. I can do it inline but if there are a bunch of pages how can I delete the posts without doing it page by page?
You can also try to delete them with a query like this which should be run in the SQL box at your phpmyadmin.

Code:
DELETE FROM xf_post WHERE user_id = x AND position !=1;
This query will delete all the posts of an user of your choise minus the first post in their thread where that user is the thread starter. If you want to delete that as well then omit the AND position !=1 from the query.

3 things to note. First make a thorough backup of the post table before you run the query. 2) Replace x with the actual id of the user whose posts you want to delete. 3) If your db tables use a custom prefix then you should use that instead of the xenforo''s default prefix (xf_ ) . Hope it helps.
 

Brandon Sheley

Well-known member
#5
How do you delete a user when the "spam" link doesn't show on the profile popup?
It seems to show if the user is new but once they've had a few likes or post, it doesn't show.