BuddyDev

Search

BuddyPress Deactivate Account Plugin: in which DB-table is the information store

Tagged: ,

  • Participant
    Level: Initiated
    Posts: 2
    Miriam on November 16, 2018 at 1:07 pm #18784

    Hi all,

    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

  • Keymaster
    (BuddyDev Team)
    Posts: 24623
    Brajesh Singh on November 16, 2018 at 1:43 pm #18785

    Hi Miriam,
    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.

    Regards
    Brajesh

You must be logged in to reply to this topic.

This topic is: not resolved