Mouth Well-known member Sep 16, 2014 #1 Looking at Total Members count in ACP /admin.php it doesn't match with xf_user rows ("select count(*) from xf_user;") and a difference between the two values of 12% Should counts be different? What would cause me to have a difference?
Looking at Total Members count in ACP /admin.php it doesn't match with xf_user rows ("select count(*) from xf_user;") and a difference between the two values of 12% Should counts be different? What would cause me to have a difference?
Chris D XenForo developer Staff member Sep 16, 2014 #2 The count in the Admin CP is the total number of users in xf_user who are of user_state valid and not banned. This is the actual query: Code: SELECT COUNT(*) FROM xf_user WHERE user_state = 'valid' AND is_banned = 0 Upvote 0 Downvote
The count in the Admin CP is the total number of users in xf_user who are of user_state valid and not banned. This is the actual query: Code: SELECT COUNT(*) FROM xf_user WHERE user_state = 'valid' AND is_banned = 0
Mouth Well-known member Sep 16, 2014 #3 Thanks, I see I have a high percentage of users in email_confirm state Upvote 0 Downvote