reinstate a self deleted admin?

[Medtech]

I have an admin that removed himself when he was upset over a user. he then requested to be put back the way he was. all his posts are still in the forum. his user status in the previous posts is guest. i attempt to view profile on him in the old posts, i get the message "This user has not registered and therefore does not have a profile to view.". I recreated his user the same way it was and same permissions. i ran counters in maintinance also. cannot get the userid to merge with the previous posts. any ideas other than an older backup?

[BSMedia]

If the posts say "Guest" chances are good he'll never be able to be reassociated with those posts anyway.

I'd tell him to not act like a 4 year old, and he wouldn't have that problem :P

[Marco van Herwaarden]

You can use the following query (make backup first):

UPDATE post
SET userid = NEW_USERID_OF_USER
WHERE userid = 0
AND username = 'OLD_USERNAME';

[Medtech]

Thanks!!, will try it tonite