Osclass Support Forums

Osclass theme support => Beta Osclass Theme => Topic started by: samsosclass on March 18, 2022, 03:25:27 PM

Title: Delete Inactive Users
Post by: samsosclass on March 18, 2022, 03:25:27 PM

Hello,
The osclass website seems to get a lot of spam users but luckily I've had it on verify your account before its active... is there a way i can delete inactive users by bulk? I have about 100k spam users to get rid of. Butler plugin doesn't seem to be doing it for me.

Kind Regards

Title: Re: Delete Inactive Users
Post by: samsosclass on March 18, 2022, 03:39:16 PM

DELETE FROM oc_t_user WHERE b_active = 0;

Run that query and it solves this.

Title: Re: Delete Inactive Users
Post by: cartagena68 on March 19, 2022, 03:29:38 AM

Did you check the butler plugin settings? Because is working fine for me

Title: Re: Delete Inactive Users
Post by: iiui awan on April 16, 2022, 01:21:25 AM

how to run that code where to run that code


DELETE FROM oc_t_user WHERE b_active = 0;

Run that query and it solves this.

Title: Re: Delete Inactive Users
Post by: MB Themes on April 19, 2022, 04:42:00 PM

You should remove account at least few days old.
Maybe you can use oc-admin feature in Tools > Data clean up

Inactive users
Remove users those has registered more than 7 days ago did not activated their account.
Total number of users matching criteria: 55