merging 2 user accounts?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
deephouse
Registered User
Posts: 93
Joined: Mon Jan 14, 2002 3:08 pm
Contact:

merging 2 user accounts?

Post by deephouse »

is there any way I can merge 2 user accounts into one?

thanks in advance :)
User avatar
Eelke
Registered User
Posts: 2903
Joined: Thu Dec 20, 2001 8:00 am
Location: NL, Bussum
Name: Eelke Blok
Contact:

Post by Eelke »

Not as standard. You could manually (e.g. phpMyAdmin) replace all occurences of one user ID with the other and then delete the account you replaced. Do backup your database before doing that, because these things are extremely easy to screw up :)
User avatar
Mav
Former Team Member
Posts: 2261
Joined: Wed May 15, 2002 9:19 am
Location: England
Contact:

Post by Mav »

way i'd do it...
1)install guest management mod
2)delete old username
- posts from old user will become guest posts, but will retain the old username
3)use guest management mod (lists all guest posts that have a username associated) to assign posts from old user to new user
(will make more sense when/if you install the mod)
User avatar
Eelke
Registered User
Posts: 2903
Joined: Thu Dec 20, 2001 8:00 am
Location: NL, Bussum
Name: Eelke Blok
Contact:

Post by Eelke »

I don't know the mod, but will that be a practical thing to do if a lot of posts are involved?
User avatar
Mav
Former Team Member
Posts: 2261
Joined: Wed May 15, 2002 9:19 am
Location: England
Contact:

Post by Mav »

yup, it groups all the guest posts with a particular name together. so if the old user was called bill and had 345 posts it'd say

Code: Select all

Bill 345 Tue Nov 12, 2002 10:33 am Rename Assign User

values are; username, posts, last post, Rename, Assign User

clicking on asign user brings up a dropdown box with all registered users in, you just select the new user and submit :D

you don't have to do it for every post, one by one.
User avatar
Eelke
Registered User
Posts: 2903
Joined: Thu Dec 20, 2001 8:00 am
Location: NL, Bussum
Name: Eelke Blok
Contact:

Post by Eelke »

OK, that is easier than my solution :)
Locked

Return to “2.0.x Support Forum”