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

Mass prune all PMs (queries)

Queries to delete all PMs for all users.

  1. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Jake Bunce submitted a new resource:

    Mass prune all PMs (queries) (version 1.x) - Queries to delete all PMs for all users.

    Read more about this resource...
     
    Puntocom and C++ like this.
  2. Blue

    Blue Well-Known Member

    Any way to do this for particular members only?
     
    Bellinis and Alien like this.
  3. Cal

    Cal Well-Known Member

    Jake...excuse this question....but how do we run these queries? Are we doing this in PHPMYADMIN.....or is there a super secret debug area of Xen I don't know about....or what?
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Yep. The SQL tab in phpmyadmin.
     
    zuardin likes this.
  5. eagle eyes

    eagle eyes Active Member

    Does this work for xenfor 1.2.2
     
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Yes.
     
  7. rightclickfix

    rightclickfix Member

    wow powerful stuff cheers Jake ;) I bookmarked it so I can run it again.
     
  8. Puntocom

    Puntocom Well-Known Member

    Is it safe to run this in XenForo 1.3.2?
     
  9. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Yes.
     
    Puntocom likes this.
  10. Rob

    Rob Well-Known Member

    Hi @Jake B., is there any way this query can be amended to delete convos older than six months?
    I'd like to wrap this all up in a cron to run once a week.
     
    RoldanLT likes this.
  11. Jake B.

    Jake B. Well-Known Member

    Tagged the wrong person :p

    I'll just leave this here for you: @Jake Bunce
     
    ThyPhon likes this.
  12. Rob

    Rob Well-Known Member

    Doh.... my bad, wasn't looking! :)
     
  13. borbole

    borbole Well-Known Member

    Rob likes this.
  14. SnoSheriff

    SnoSheriff Active Member

    I would like to prune PMs for members who have not logged into their account for over 6 months. How can I do this?
     
    rafass likes this.

Share This Page