The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
combining two user accounts into a single account
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?
|
#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 |
#3
|
|||
|
|||
Quote:
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|