reinstate a self deleted admin?
 

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?

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

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

[sql]UPDATE post
SET userid = NEW_USERID_OF_USER
WHERE userid = 0
AND username = 'OLD_USERNAME';[/sql]

Thanks!!, will try it tonite