I just want to deactivate a lot of users of my social community. In order not to have to do this manually per user, I would like to do this by SQL statement in the database. Therefore I would like to know exactly where in the database the information is stored, whether a user is deactivated.
Thanks and greetings
Thank you for using the plugin.
The account status is stored in user meta table( yourdatbasaprefix_usermeta).
For each user, you can set the account status deactivated by adding a meta ‘_is_account_inactive’ and setting its value as numeric 1.
To make a user active again, you can delete the meta with the key ‘_is_account_inactive’ for that user.
You must be logged in to reply to this topic.