CODEWITHSUNDEEP
mysqlsqlphpbbphpbb3
user324747
user324747

Reputation: 273

phpbb 3 SQL delete user and all posts

I want to mass remove spam users from my forum's database.

If I have the UID of their account, what would be a good SQL query that I could script to delete that user and all their posts like the option in the ACP. SSH is much easier for me to login.

Upvotes: 0

Views: 1595

Answers (1)

Eeji
Eeji

Reputation: 1648

Deleting users directly from the database is asking for trouble as it will leave all sorts of remnants in tables other than the user table.

Your best bet if you know user names/id's is to use the 'Prune users' function in the ACP under the 'Users and groups' tab.

Upvotes: 1

Related Questions