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

XF 1.5 Trying to mass prune old accounts with zero posts

Discussion in 'XenForo Questions and Support' started by OperaManiac, Mar 25, 2016.

Tags:
  1. OperaManiac

    OperaManiac Well-Known Member

    I just wanted to make sure if these options are correct!

    chrome_2016-03-26_01-33-38.png

    I have replaced -1 with 0 in the second field of message count and entered a time period till one year ago. I wanted to confirm because the number I am getting through this search is pretty large. It is probably accurate as I suppose a large number of accounts are created by spammers and bots which never are confirmed or used or are marked as spam.

    I would take a backup of the database of course before running the pruning command.

    PS: XenForo should provide a better date picker. I imagine browsers now provide a native date picker using HTML5 tags (Looks like Firefox does not support them right now?). Right now I cannot change the year from the popup calendar so to go back to 2003, I have to press the back button insane number of times. I assume entering the value manually in these fields in proper format would work as well?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    You can paste a date into the field, which is what I do.
     
    OperaManiac likes this.
  3. OperaManiac

    OperaManiac Well-Known Member

    cool. so the values are correct? to show all members with zero posts and who have not logged-in in the last 12 months?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Yes, it looks fine.
     
    OperaManiac likes this.
  5. wang

    wang Well-Known Member

    I wanted to add that you might want to consider backuping up the database first, before you perform that action. Because it can not be undone.
     
    OperaManiac likes this.
  6. Brogan

    Brogan XenForo Moderator Staff Member

     
    OperaManiac likes this.
  7. wang

    wang Well-Known Member

    I missed that part about the backup in the Original Post.
     
  8. OperaManiac

    OperaManiac Well-Known Member

    Yup. I have a cronjob on the VPS that backs up the database on S3 every six hours. So I would have enough copies to revert back to in addition to the manual backup.

    Though, any side effect of this command are unlikely to become apparent immediately! For example, it might annoy people who created account to track threads but they never posted any content. Hopefully the one year delay should exclude such accounts.
     

Share This Page