Undeleting posts on vBulletin

UPDATE post SET visible = 1 WHERE visible = 2 AND userid = XXX;

Replace XXX with UserID.