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?
- fantasma
- Senior Member
- Offline
Re: [extension request] mass delete user
you can just delete user directly on DB by sql
- fantasma
- Senior Member
- Offline
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
- fantasma
- Senior Member
- Offline
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>)
- fantasma
- Senior Member
- Offline
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 
I think that i can delete it from the db with phpmyadmin, yes?