PDA

View Full Version : Relink Delete User posts to current user, sorta kinda



Kaith Rustaz
Mon 9th Jun '08, 6:57pm
I'm looking for a way to re-connect posts and threads made by a deleted user with a currently active user.

I'm assuming it can be done through 1-2 SQL querries, but don't know the syntax.

Thanks!

Steve Machol
Tue 10th Jun '08, 12:38pm
UPDATE post SET userid='xxx' WHRE username='Old Name'

...with 'xxx' being the new userid number and 'Old Name' being the username on those posts.

Then rebuild the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters