Of course there is option to delete all given user posts:
According to phpBB database schema (http://wiki.phpbb.com/display/DEV/Tables
), I wrote this little SQL statement:
- Code: Select all
DELETE u, t, p, a FROM phpbb_users AS u INNER JOIN phpbb_topics AS t ON u.user_id=t.topic_poster INNER JOIN phpbb_posts AS p ON u.user_id=p.poster_id INNER JOIN phpbb_acl_users AS a ON u.user_id = a.user_id
(change 6 to spammer user_id)
This code will delete given user, all posts and topics he created.
Also, it's deleting user entry in phpbb_acl_user
table ("Permission roles and/or individual permissions assigned to users
It is not needed to delete user, his posts and topics, but deleted user entry in this table will be never used, so it will be good to remove it too.
Warning: Unknown: failed to open stream: No such file or directory in Unknown on line 0