XF 1.1 Message Account is At Least

[DRE]

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.

 

[Chris D]

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.

 

[DRE]

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.

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

 

[Chris D]

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

 

[DRE]

 

[Chris D]

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)