The Arcive of vBulletin Modifications Site.

kjetterman · #1 05-10-2010, 03:09 PM

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 · #2 05-11-2010, 09:43 AM

from phpmyadmin
select forum database
SQL query

Code:

DELETE FROM `post` WHERE `post`.`userid` = 0;

Code:

DELETE FROM `thread` WHERE `thread`.`postuserid` = 0;

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