1. 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

Discussion in 'XenForo Questions and Support' started by talknetwork, Oct 8, 2010.

  1. talknetwork

    talknetwork Member

    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?
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  3. borbole

    borbole Well-Known Member

    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.
     
    talknetwork likes this.
  4. talknetwork

    talknetwork Member

    thanks guys. that will help!
     
  5. Brandon Sheley

    Brandon Sheley Well-Known Member

    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.
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    Brandon Sheley likes this.
  7. Brandon Sheley

    Brandon Sheley Well-Known Member

    Thanks, I didn't fully understand that section but I'm clear now (y)
     

Share This Page