Delete Threads of deleted user?

[Delfi_r.]

I have a problem that's caused by some troll user. The solution should be to delete all posts by this user. The problem is that it has been deleted to, and I don't know if it's possible to delete all posts of deleted users.

I haven't found a solution for deleting posts and ask pardon if really exists and I haven't found it

 

[Max Taxable]

If you don't have any other posts by regular unregistered guests that you want to keep, then run this query in ACP>Maintenance>Execute SQL Query and it will take care of it.

DELETE FROM post WHERE userid = 0;

 

[Delfi_r.]

We have managed to delete the deleted user messages by PHPMyAdmin. Thanks for the advice. We have used the username in the query.