Tip of the day : How Do I Associate Old Posts with a Deleted User
Original thread (http://www.vbulletin.com/forum/showthread.php?t=239925&goto=newpost) posted on vBulletin.com by : Steve Machol on : Tue, 14 Aug 2007 02:30:28 GMT

How Do I Associate Old Posts with a Deleted User]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


vBulletin-Fans.com hopes you learned something from this great tip and if you also have a great tip you can submit it on vBulletin-Tutorials.com here (http://www.vbulletin-tutorials.com/newthread.php?do=newthread&f=591), or on vBulletin.com here (http://www.vbulletin.com/forum/forumdisplay.php?f=109). Don't forget to subscribe to this forum (http://www.vbulletin-tutorials.com/subscription.php?do=addsubscription&f=591) to get daily tips on how to best secure, optimize, manage and operate your vBulletin powered forum.


Floris & Staff
vBulletin Fans Network
http://www.vBulletin-Tutorials.com/

That's a really usefull query.