Topic: [extension request] mass delete user

Hello in my board, the number of user is very hight, because the user are a spam bot and no real people, now i most delete it, and i need a good exstenzion for mass delete user.
Can help me?

Re: [extension request] mass delete user

you can just delete user directly on DB by sql

Re: [extension request] mass delete user

ok thanks

Re: [extension request] mass delete user

homerzhu wrote:

you can just delete user directly on DB by sql

fantasma wrote:

ok thanks

You shouldn't better to.
DB consistency will be broken then.
SlavoK is writing a reply to you now.

Carpe diem

Re: [extension request] mass delete user

thanks ! Anatoly!!

Re: [extension request] mass delete user

Hi, fantasma! It is difficult to correctly delete users and all their posts via SQL-console because you will need to track many changes in DB.
The way to minimize DB changes is to alter posts` author field to Guest for instead of deleted users.
To do so, for the posts written by the users you've just deleted. Your SQL query will look like:
UPDATE <DB_Prefix>_posts SET poster_id = 1 WHERE ID IN (<list of users id>)

Re: [extension request] mass delete user

Hi Slavok the fake user, fortunately not write any post in my board, because i have active the mail request for activation account.

The problem is that every day 10-15 fake user subscrive to the my forum and now i have lot of fake user in my board. I must delete it in one time, one to time is to hard wink
I think that i can delete it from the db with phpmyadmin, yes?