Staxed Active member Sep 14, 2011 #1 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?
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?
Paul B XenForo moderator Staff member Sep 14, 2011 #2 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. Upvote 0 Downvote
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.
F Floris Guest Sep 14, 2011 #3 phpMyAdmin Code: SELECT * FROM `xf_user` WHERE `xf_user`.`message_count` =0 Would this be the right query Brogan to manually find users with 0 msgs ? Upvote 0 Downvote
phpMyAdmin Code: SELECT * FROM `xf_user` WHERE `xf_user`.`message_count` =0 Would this be the right query Brogan to manually find users with 0 msgs ?
Paul B XenForo moderator Staff member Sep 14, 2011 #4 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 Upvote 0 Downvote
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
Staxed Active member Sep 14, 2011 #5 Brogan said: 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. Click to expand... /runs off to like that thread Upvote 0 Downvote
Brogan said: 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. Click to expand... /runs off to like that thread