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

Search for users with 0 posts in admin panel?

Discussion in 'XenForo Questions and Support' started by Staxed, Sep 14, 2011.

  1. Staxed

    Staxed Active Member

    Is it possible to find users with 0 posts via the search for users function? All I see is "users with at least x posts". I want "users with less than x posts"...from what I can see, I can't find users that haven't posted at all...am I missing it?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    It's not possible to search for users with 0 posts or less than x posts.

    I have suggested it though quite a while ago.
    Staxed likes this.
  3. Floris

    Floris Guest

    SELECT * 
    FROM  `xf_user` 
    WHERE  `xf_user`.`message_count` =0
    Would this be the right query Brogan to manually find users with 0 msgs ?
    Staxed likes this.
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Looks good to me Floris :)

    You could also omit the 'xf_user'. from the last line like so:

    SELECT *
    FROM xf_user
    WHERE message_count = 0
  5. Staxed

    Staxed Active Member

    /runs off to like that thread

Share This Page