Need to delete posts by a former member who was deleted

[kjetterman]

Hello,

I accidentally deleted a member without deleting her posts first. Now her posts are still on the forum with her name and the title "guest". I can't delete her posts in the admin panel because she is not a member.

How would I do this using an SQL query? Thanks for your help! :)

[Alaaalol]

from phpmyadmin
select forum database
SQL query
DELETE FROM `post` WHERE `post`.`userid` = 0;
DELETE FROM `thread` WHERE `thread`.`postuserid` = 0;

http://www.traidnt.net/vb/showthread.php?t=1367137