• 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?

Staxed

Active member
#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?
 

Brogan

XenForo moderator
Staff member
#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.
 
F

Floris

Guest
#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 ?
 

Brogan

XenForo moderator
Staff member
#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