1 Topic by Brick

  • Registered: 2002-10-07
  • Posts: 60

Topic: Merging accounts possible?

I was wondering if you techs out there had a procedure or script or tool of some sort that can be used to merge profiles.

I was hoping to get things like my name and posts and inbox, etc, transferred over to this account. Yeah, I'm obviously doing it for the earlier registration date, but I think that's fair. It WAS me, after all.

Off the top of my head I would assume that it would only take a minute or two of writing a few relatively simple sql commands, unless I misunderstand the structure of the site entirely, which is why I ask, expecting that it isn't a gigantic favor. If it is, then no big deal, I understand.

comes in a variety of colors and materials

2 Reply by Dany

  • Dany
  • By your powers combined...
  • Offline
  • Registered: 2003-07-17
  • Posts: 4,625

Re: Merging accounts possible?

[strike]Why not just change the name of the Killgore account?[/strike]

Nevermind, misunderstood. It might be possible, but certainly not something I'm capable of!

  • Registered: 2006-03-17
  • Posts: 449

Re: Merging accounts possible?

We can certainly tie e.g. threads and forums to another account easily, but there are various data that overlap (such as your profile), and we also have quite a lot of data in many different tables tied to users. Each will require separate SQL, which is a lot of work for something that doesn't really achieve anything.

Will look into it and get back to you.

Vanity is a horrible thing.. My original account goes back to 2004 (16:09 Apr 09, 2004 to be exact), you don't see me moaning wink

Update: Short answer: No. Too much work.

http://card.mygamercard.net/sig/prencher.png
<Bill_> it really, really hurts to say this
<Bill_> really
<Bill_> but prencher, you were right

Thomas's Website

4 Reply by v3x

  • v3x
  • Member
  • Offline
  • Registered: 2004-11-21
  • Posts: 291

Re: Merging accounts possible?

Why not just ask them nicely to change the name and/or just the registration date of the Killgore account...?

v3x's Website

5 Reply by Dany

  • Dany
  • By your powers combined...
  • Offline
  • Registered: 2003-07-17
  • Posts: 4,625

Re: Merging accounts possible?

Originally posted by: v3x
Why not just ask them nicely to change the name and/or just the registration date of the Killgore account...?

I'm reasonably certain changing the registration date of the original account could make some things go angry.

6 Reply by darin

  • Registered: 2002-03-22
  • Posts: 4,666

Re: Merging accounts possible?

How about just increasing the post count of the Brick account?

http://imagegen.last.fm/Awesome35/recenttracks/ddarin.gif

7 Reply by Dany

  • Dany
  • By your powers combined...
  • Offline
  • Registered: 2003-07-17
  • Posts: 4,625

Re: Merging accounts possible?

Originally posted by: darin
How about just increasing the post count of the Brick account?

Superficially, I'm pretty sure this is possible!

  • Registered: 2004-02-07
  • Posts: 2,769

Re: Merging accounts possible?

Thanks for looking into it.. I dont want to give the impression that this is a super duper big deal for me.. was mostly hoping that a process was already in place. I admit it's purely a vanity thing. =P

So if it is a simple matter to change the name of an account, and its a simple matter to change the post count, would it be possible to change the name Brick -> Killgore9998 (or just Killgore if that would cause a uniqueness issue) and change the post count of Brick to match? Its alright if nothing gets transferred over, I guess.

Is changing the name something that I can do myself? I didnt see the option anywhere.

Well knows he who uses to consider, that our faith and knowledge thrives by exercise, as well as our limbs and complexion. Truth is compared in Scripture to a streaming fountain; if her waters flow not in a perpetual progression, they sicken into a muddy pool of conformity and tradition. A man may be a heretic in the truth; and if he believe things only because his pastor says so, or the Assembly so determines, without knowing other reason, though his belief be true, yet the very truth he holds becomes his heresy.
  • Registered: 2006-03-17
  • Posts: 449

Re: Merging accounts possible?

No. We can change your name but that's it.

Changing anything else like that might have unseen consequences down the line due to data inconsistencies, and we're simply not willing to do stuff like that. We might add a feature to do this in the future, but it's not just a sql statements.

http://card.mygamercard.net/sig/prencher.png
<Bill_> it really, really hurts to say this
<Bill_> really
<Bill_> but prencher, you were right

Thomas's Website