Merging User Accounts...

[interrealm]

Has anyone wrote anything that will merge 2 accounts into 1? I have merged a few boards into 1 and doing such... have numerous duplicate accounts... and would like to merge them.. example being.. User Alpha has UserALpha1 (id 5) and UserAlpha2 (id59). I'd like to be able to go thru and remap all posts from id59 to id 5. Is there an easy way to do this?

[Xenon]

you have just to run a query: [sql]UPDATE post SET userid=5 WHERE userid=59[/sql]

after merging accounts you have to update counters from within your ACP to get the right post ammount for users again and threadstarters correcting...

[interrealm]

that the only table that needs updated? There are alot of other tables linked to the Userid.. wasn't sure..

[Brad]

it only update post, evrything else like pms, post count, and feilds are noy merged.

[Xenon]

ok ok for PMs:

[sql]UPDATE privatemessage SET fromuserid=5 WHERE fromuserid=59[/sql]
[sql]UPDATE privatemessage SET touserid=5 WHERE touserid=59[/sql]

@Anime: postcount is merged after he has used the update counter functions.
The profilefields cannot be merged one version would overwrite the other

[nightrider72]

Actually a more complete set of updates is the following:

UPDATE post SET username='newusername', userid=newuserid WHERE userid=olduserid;
UPDATE thread SET postusername='newusername',postuserid=newuserid WHERE postuserid=olduserid;
UPDATE privatemessage SET fromuserid=newuserid WHERE fromuserid=olduserid;
UPDATE privatemessage SET touserid=newuserid WHERE touserid=olduserid;
UPDATE attachment SET userid=newuserid WHERE userid=olduserid;
UPDATE calendar_events SET userid=newuserid WHERE userid=olduserid;
UPDATE pollvote SET userid=newuserid WHERE userid=olduserid;
UPDATE subscribeforum SET userid=newuserid WHERE userid=olduserid;
UPDATE subscribethread SET userid=newuserid WHERE userid=olduserid;
UPDATE threadrate SET userid=newuserid WHERE userid=olduserid;

All userid & username related tables should be listed above. The ones that don't appear are taken care when updating the counters using the /admin/ interface.

Below a query to find out duplicate users or users with same username (this situation can happen after having imported a forum into an existing VB forum)

SELECT A.userid, A.usergroupid, A.username, A.email, A.usertitle
FROM user A, user B
WHERE A.username = B.username
and A.userid <> B.userid
ORDER BY A.username, A.email

- Adriano

[Xenon]

thanks

nightrider72, can you please go to this page and enter your email address, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.