Relink Delete User posts to current user, sorta kinda

[Kaith Rustaz]

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]

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