Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Shortie on February 28, 2009, 05:19:48 PM

Title: Merge two Users
Post by: Shortie on February 28, 2009, 05:19:48 PM
Hi All

Hope this is the right place to post this

I have searched through the community and cannot find an answer - so here goes

I am running SMF RC1

and the merge should combine all posts and PM




How can I merge two users into one

e.g.

Username = fred
Email = [email protected]
user ID = 10

and

Username = John
Email = [email protected]
User ID = 25

Both users are administrator if this helps

Thanks for any response

Shortie
Title: Re: Merge two Users
Post by: N3RVE on March 02, 2009, 02:52:42 PM
See the Forum maintenance section of the Admin CP, you'd find the link to merge posts :)

-[n3rve]
Title: Re: Merge two Users
Post by: Shortie on March 02, 2009, 04:42:29 PM
Cool found that

But I would also like to do the PM's as well

Cheers

Shortie
Title: Re: Merge two Users
Post by: N3RVE on March 03, 2009, 03:30:22 AM
You would have to run an SQL query on the database to re-associate their PMs, I'd try this on a test install and post the query you should run.

-[n3rve]