Associating Old Posts With A Deleted User
 

http://www.vbulletin.com/forum/showthread.php?t=239925

=========

I saw the above thread. I have a deleted user that still has many different posts on our board. I would like to create that user again and associate any old posts of hers with her account.

The aforementioned thread says to:

Quote:
If you acccidentally delete a user but not their posts, you can register a new account for that user, then run this query to associate the old posts with the new account:

UPDATE post SET userid='xxx' WHERE username='Old Name';

....with 'xxx' being the userid of the new account.

Then update the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters
What does it mean to run the query to associate the old posts with the new account? How do I go about doing that?

CUrrently the deleted posts says the name of Guest