|
|
Joined: May 1999
Posts: 241
Coder
|
|
Coder
Joined: May 1999
Posts: 241 |
One of the most needed mods for me, is the ability to merge two user accounts, assigning one of them as primary, and deleting the second when the merge process is completed. At one time, there was a hack for this (a couple, actually), but it would be a great thing to get rolled into the 'core' code at some time.
Thanks!
Matt R.
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
Yeah, would be nice in the core. I believe Ian is working on merge script, I've got the basic commands you can use in your control panel's mysql command box tho: Update posts:
UPDATE ubbt_POSTS SET USER_ID = '387' WHERE USER_ID = '9734'
UPDATE ubbt_TOPICS SET USER_ID = '387' WHERE USER_ID = '9734'
UPDATE ubbt_TOPICS SET TOPIC_LAST_POSTER_NAME = 'AllenAyres' WHERE TOPIC_LAST_POSTER_NAME = 'AllenAyres_dup1'
UPDATE ubbt_TOPICS SET TOPIC_LAST_POSTER_ID = '387' WHERE TOPIC_LAST_POSTER_ID = '9734'
Update Post count:
UPDATE ubbt_USER_PROFILE SET USER_TOTAL_POSTS = '24080' WHERE USER_ID = "387"
Update PM's:
UPDATE ubbt_PRIVATE_MESSAGE_POSTS SET USER_ID = '387' WHERE USER_ID = '9734'
UPDATE ubbt_PRIVATE_MESSAGE_TOPICS SET USER_ID = '387' WHERE USER_ID = '9734'
UPDATE ubbt_PRIVATE_MESSAGE_USERS SET USER_ID = '387' WHERE USER_ID = '9734'
If I am going backwards and using the _dup1 acct instead of the more recent acct, I'll use this to update the name after deleting the other acct:
UPDATE ubbt_USERS SET USER_LOGIN_NAME = 'Scream' WHERE USER_ID = '8986'
I believe that covers it, if I've missed something, let me know 
|
|
|
|
|
Joined: May 1999
Posts: 241
Coder
|
|
Coder
Joined: May 1999
Posts: 241 |
Thanks Allen! I'll start cleaning up my site... the fun part, of course, is trying to track down all the duplicate accounts... but that's another story.
|
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
|
Guru
Joined: May 1999
Posts: 3,039 |
There will be a merge tool builtin for the final 7.0 release 
UBB.threads Developer
|
|
|
|
|
Joined: May 1999
Posts: 241
Coder
|
|
Coder
Joined: May 1999
Posts: 241 |
Oh, you cannot imagine how that brightens my day!!! Thank you!!!
|
|
|
|
|
Joined: May 1999
Posts: 241
Coder
|
|
Coder
Joined: May 1999
Posts: 241 |
FYI: I've been testing this on my site and it seems to be working with no issues! The key is identifying the account that the others need to be merged into. Then, transfer any profile values (manually) from the 'old' account into the new one, and when that's done, run the 'Merge User' function, which actually does the merge and blasts (deletes) the 'old' one.
What a time saver! Thanks Rick!
|
|
|
|
|
Joined: Feb 2002
Posts: 2,286
Veteran
|
|
Veteran
Joined: Feb 2002
Posts: 2,286 |
There will be a merge tool builtin for the final 7.0 release Did this make it to the final?
Fans Focus - Focusing on Fans of Sport (Okay - mainly football (the British variety at the moment - but expanding all the time....)
|
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
|
Guru
Joined: May 1999
Posts: 3,039 |
Yep. I had to merge like 300 users when I merged both forums on ubbcentral.
UBB.threads Developer
|
|
|
|
|
Joined: Feb 2002
Posts: 2,286
Veteran
|
|
Veteran
Joined: Feb 2002
Posts: 2,286 |
Thx - wasn't sure if you used a script or a built in part of threads.
Fans Focus - Focusing on Fans of Sport (Okay - mainly football (the British variety at the moment - but expanding all the time....)
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 417
Joined: November 2001
|
|
|
Forums63
Topics37,575
Posts293,930
Members13,823
| |
Most Online6,139
Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
