Thanks @Mike. Is there another way to do this? I need to give one specific user (who is actually a bot) an ability to delete his own messages on a regular basis. Right now he is only able to soft-delete them, and the deleted posts are littering the forum and accumulating fast.
Is there perhaps a clever way to promote him to moderator so he can hard-delete his own posts but not have any other moderator privileges, like deleting other people's posts?
This bot posts 6 times a day (by design), so manually cleaning up after him is not an option. Can anyone help with the MySQL query to clean up what's already there and can be run once in a while? Something that would satisfy both option 1 and 2 above:
Hard-delete all soft-deleted posts by a specific user posted in a specific thread