The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Need to delete posts by a former member who was deleted
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! |
#2
|
|||
|
|||
from phpmyadmin
select forum database SQL query Code:
DELETE FROM `post` WHERE `post`.`userid` = 0; Code:
DELETE FROM `thread` WHERE `thread`.`postuserid` = 0; |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|