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

XF 1.1 Message Account is At Least

Discussion in 'XenForo Questions and Support' started by DRE, Jun 23, 2012.

  1. DRE

    DRE Well-Known Member

    In User Search you are able to look for posters whose message account is at least... and then you enter in a number.

    Alright maybe I'm having a brain fart because this doesn't make any sense.

    If I choose 0 it shows everyone, if I choose 1, it shows everyone. If I choose 2, it shows everyone.

    Shouldn't the results show people who have no posts if you pick zero? Why then does it show everyone?

    Shouldn't it show posters who have at least 1 post if you choose 1? Then it would only show posters who have over 1 post.

    What about 2? It should only show posters with at least two posts right?

    What's wrong with my user search? It's useless.
  2. Chris D

    Chris D XenForo Developer Staff Member

    If I have 1000 posts, I have at least 2 posts.

    If the wording was "message count is at most 2 posts" then it would show users with 0, 1 or 2 posts.
  3. DRE

    DRE Well-Known Member

    I need to find members that have 1 post or less, that can't be done in that box apparently. It's useless.
  4. Chris D

    Chris D XenForo Developer Staff Member

    Yeah you'd need a SQL query or add-on for that.
  5. DRE

    DRE Well-Known Member

  6. Chris D

    Chris D XenForo Developer Staff Member

    Do you know how to run a query in PHP My Admin?

    The query you need to run is this:

    SELECT * FROM `xf_user` WHERE `message_count` <= 1

    (Select all records from the xf_user table where the message count is less than or equal to 1)
    8thos, Jake Bunce and 0xym0r0n like this.

Share This Page