I have discussed this before and thought it was solved but it isn't. So either WpForo updates changed something or the solution was not properly addressed.
I have created a users' role with no permission whatsoever, and all my fake users are moved under this role. Plus, my Guests are set to view statistics but NOT members.
So why is it that non-logged in people can see the total number of such hidden users?
The number of users doesn't check hidden users. You can not reduce that number by putting some users to some usergroup. The users should be inactive to be hidden. The inactive users are the users who have not confirmed their registration by clicking the URL sent to their email.
There is no other ways to remove users from the members count. The members count shows the number of members, it doesn't matter what usergroup they have and who can see them.
sorry, just one last help... I'm trying to simulate this query to change users from active to inactive, but it fails:
UPDATE wp_wpforo_profiles SET status='active' WHERE status='inactive';
Can you please tell me the correct query?
...silly me 🤣 it was the other way around, as you confirmed! Thank you!