Previous Thread
Next Thread
Print Thread
Rate Thread
#311534 09/18/2006 6:56 PM
Joined: May 1999
Posts: 241
Coder
Coder
Offline
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.


--------------------
Matt Reinfeldt
http://www.mattreinfeldt.com/
Sponsored Links
MattyJ #311539 09/19/2006 5:25 PM
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:
PHP Code

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:
PHP Code

UPDATE ubbt_USER_PROFILE SET USER_TOTAL_POSTS
= '24080' WHERE USER_ID = "387"



Update PM's:
PHP Code

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:
PHP Code

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 smile


- Allen wavey
- What Drives You?
AllenAyres #311543 09/20/2006 8:06 AM
Joined: May 1999
Posts: 241
Coder
Coder
Offline
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. smile



--------------------
Matt Reinfeldt
http://www.mattreinfeldt.com/
MattyJ #311563 09/25/2006 3:49 PM
Joined: May 1999
Posts: 3,039
Guru
Guru
Offline
Joined: May 1999
Posts: 3,039
There will be a merge tool builtin for the final 7.0 release wink


UBB.threads Developer
Rick #311564 09/25/2006 4:21 PM
Joined: May 1999
Posts: 241
Coder
Coder
Offline
Joined: May 1999
Posts: 241
Oh, you cannot imagine how that brightens my day!!! smile

Thank you!!!


--------------------
Matt Reinfeldt
http://www.mattreinfeldt.com/
Sponsored Links
MattyJ #311605 10/03/2006 8:12 AM
Joined: May 1999
Posts: 241
Coder
Coder
Offline
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!


--------------------
Matt Reinfeldt
http://www.mattreinfeldt.com/
Rick #311616 10/07/2006 5:20 AM
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
Originally Posted by Rick
There will be a merge tool builtin for the final 7.0 release wink


Did this make it to the final?


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Ian_W #311618 10/07/2006 10:58 AM
Joined: May 1999
Posts: 3,039
Guru
Guru
Offline
Joined: May 1999
Posts: 3,039
Yep. I had to merge like 300 users when I merged both forums on ubbcentral.


UBB.threads Developer
Rick #311627 10/08/2006 7:14 AM
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 wink at the moment - but expanding all the time....)

Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
JAISP
JAISP
PA
Posts: 449
Joined: February 2008
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)