So one of my admin accidently deleted a few members...

[MGM]

Now all of their posts are marked as guest posts and their accounts have lost everything. I don't really care about lost PM's, rep comments, etc. But I was wondering if there was a way to merge those posts back into their accounts...

The guest posts still have their names there, they just aren't pointing to the person's account. Each of these deleted members has thousands of posts so it would take a lot of my time to merge each individual post. Is there any quick way I can do this?

MGM out

[Steve Machol]

The accounts are gone. What you would need to do is registered new account for these users, then you can run this query to assign those posts back to their appropriate users:

UPDATE post SET userid='xxx' WHERE username='User Name';

...with 'xxx' being the new userid nu,ber for the member in question and 'User Name' being the username on the old posts.

Repeat that for every user, then rebuild the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

[MGM]

Perfect, I'll try this tonight. The members in question have already re-registered and we set their post counts manually to be whatever they were beforehand. Should I reset this to 0?

EDIT: Seems to have worked, thanks a lot Steve

MGM out