combining two user accounts into a single account

[engquist]

I'd like to take two seperate user accounts in my VB 2.3.0 forum and combine them into one. How can I do this completely where all post counts are reflected correctly and all forums show all the posts as being made by only one of the two accounts?

[Stu]

I did something like this on a test board,
I ran queries on the Database to change the 'username' and the 'userid' within the 'Post' table
I'm sure this was all I did, but to be sure I would advise you to try this on a test board first, or wait for a more experienced member to offer a solution

UPDATE post SET userid=newid WHERE userid=oldid

UPDATE post SET username='newname' WHERE username='oldname'

then updated the counters from adminCP

Depending on what degree it may be necessary to run these too..

UPDATE thread SET postuserid=newid WHERE postuserid=oldid
UPDATE privatemessage SET fromuserid=newid WHERE fromuserid=oldid
UPDATE privatemessage SET userid=newid WHERE fromuserid=oldid AND folderid='-1'
UPDATE subscribethread SET userid=newid WHERE userid=oldid
UPDATE subscribeforum SET userid=newid WHERE userid=oldid
UPDATE pollvote SET userid=newid WHERE userid=oldid
UPDATE calendar_events SET userid=newid WHERE userid=oldid

[esquared]

06-11-03 at 08:01 PM Stu said this in Post #2
I did something like this on a test board,
I ran queries on the Database to change the 'username' and the 'userid' within the 'Post' table
I'm sure this was all I did, but to be sure I would advise you to try this on a test board first, or wait for a more experienced member to offer a solution

UPDATE post SET userid=newid WHERE userid=oldid

UPDATE post SET username='newname' WHERE username='oldname'

then updated the counters from adminCP

Depending on what degree it may be necessary to run these too..

UPDATE thread SET postuserid=newid WHERE postuserid=oldid
UPDATE privatemessage SET fromuserid=newid WHERE fromuserid=oldid
UPDATE privatemessage SET userid=newid WHERE fromuserid=oldid AND folderid='-1'
UPDATE subscribethread SET userid=newid WHERE userid=oldid
UPDATE subscribeforum SET userid=newid WHERE userid=oldid
UPDATE pollvote SET userid=newid WHERE userid=oldid
UPDATE calendar_events SET userid=newid WHERE userid=oldid

Does this work?