Merging deleted user into another user?

[cLutchh]

Hey, so I have a few deleted user accounts on my forum and I was curious if there was a way to change them to actual accounts via phpMyAdmin. It's pretty annoying when I see their posts and they're set to 'Guest' (a disgruntled admin deleted them a long while ago). Can I change these accounts into an account that registered before they did?

Thanks for the help in advance!

[Paul H.]

I'm not sure there's something built in, but you could run this in phpmyadmin:

PHP Code:

UPDATE mybb_posts SET uid='new uid' WHERE uid= 'old uid' 


PHP Code:

UPDATE mybb_threads SET uid='new uid' WHERE uid= 'old uid' 


No guarantees on it working, though.

[cLutchh]

But if the user is deleted there will not be a uid, right?

[euantor]

Correct. Use the same query as above, but try setting the "old uid" as blank or 0 (I can't remember how MyBB stores them for deleted users/guests).

[Paul H.]

You could do username, I believe that is still in the DB.

[cLutchh]

How should the query look if I want to do it by username?

[cLutchh]

(01-19-2012 01:45 AM)euantor Wrote:  Correct. Use the same query as above, but try setting the "old uid" as blank or 0 (I can't remember how MyBB stores them for deleted users/guests).

Wouldn't this put all deleted users into the same account?

(01-19-2012 02:55 AM)cLutchh Wrote:  How should the query look if I want to do it by username?

Bump. And how would it work if the username is deleted/not actually there?

[cLutchh]

Hm...

[Alan Shepperson]

Run these queries in phpMyAdmin:

PHP Code:

UPDATE `mybb_threads` SET `uid` = 'X' WHERE `username` = 'Y';
UPDATE `mybb_posts` SET `uid` = 'X' WHERE `username` = 'Y'; 


Where X is the new account ID and Y is the old username.

Then go to ACP >> Tools & Maintenance >> Recount & Rebuild and rebuild/recount the first 4 options.

[cLutchh]

Worked like a charm, thank you very much!