Nirjonadda Well-known member Mar 27, 2017 #1 We have 16865 user in database and it's show only 16296 in forum home page sidebar FORUM STATISTICS. Please let me know that what happened?
We have 16865 user in database and it's show only 16296 in forum home page sidebar FORUM STATISTICS. Please let me know that what happened?
Chris D XenForo developer Staff member Mar 27, 2017 #2 The count on the forum list sidebar will only include valid members who are not banned. Upvote 0 Downvote
P Paul B XenForo moderator Staff member Mar 27, 2017 #3 Banned and unconfirmed users are not counted. Upvote 0 Downvote
Nirjonadda Well-known member Mar 27, 2017 #4 Chris D said: The count on the forum list sidebar will only include valid members who are not banned. Click to expand... I have show 16653 users not banned, So why not count 16653 users? Upvote 0 Downvote
Chris D said: The count on the forum list sidebar will only include valid members who are not banned. Click to expand... I have show 16653 users not banned, So why not count 16653 users?
Nirjonadda Well-known member Mar 27, 2017 #5 Brogan said: Banned and unconfirmed users are not counted. Click to expand... Only have 212 banned user and no unconfirmed user. Upvote 0 Downvote
Brogan said: Banned and unconfirmed users are not counted. Click to expand... Only have 212 banned user and no unconfirmed user.
Chris D XenForo developer Staff member Mar 27, 2017 #6 What is the result of this query: Code: SELECT COUNT(*) FROM xf_user WHERE user_state = 'valid' AND is_banned = 0 Upvote 0 Downvote
What is the result of this query: Code: SELECT COUNT(*) FROM xf_user WHERE user_state = 'valid' AND is_banned = 0