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

email and delete zero post users

Discussion in 'XenForo Questions and Support' started by swatme, Mar 19, 2011.

  1. swatme

    swatme Well-Known Member


    i have members who have zero posts.
    i want them to be emailed informing about their account to post at least once
    where can i do that? mass email doesnt show members with zero post

    also i want to delete members with zero post, where can i do that?

  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. swatme

    swatme Well-Known Member

    oh hopefully its available on next update
  4. Brogan

    Brogan XenForo Moderator Staff Member

    With 0 likes, I doubt it.

    The number of first post likes doesn't necessarily determine whether a feature will be implemented or not, but it does give the developers an idea of which are the most desired.
  5. borbole

    borbole Well-Known Member

    You can do a round about way to get the emails of users with 0 post count and then mass email them from your email address. You can do that by running this query at your phpmyadmin:

    SELECT email FROM `xf_user` WHERE message_count = 0;
    Whereas to delete users with 0 posts, run this other query, but backup your users table first.

    DELETE FROM `xf_user` WHERE message_count = 0;
    And adjust the db prefix to your own if you are not using xf_ as your db prefix.
  6. estranged

    estranged Well-Known Member

    What if I want to delete 0 post users who have not visited for a year?
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    There is no user pruning feature. You would have to delete them individually through the Admin CP. And again there is no search criteria you can use in the Admin CP.

    It's not recommended that you delete user records directly from the database. That ignores associated records in other tables.

    So basically there is no good way to proceed with deleting 0 posters. This will likely be addressed in a future version.

Share This Page