Jump to content

merging 2 character databases


darkstalker

Recommended Posts

had the same problem 2 years ago.

back then, i wrote a PHP script that dumped every character to a pdump, and then loaded all back in the new DB, but flagged for rename. those that were conflicting were changed by the script, like, append an underscore to the name or so. Had to be renamed anyways.

Back then the whole thing worked via telnet/RA & PHP sockets,which was highly unreliable for that purpose (it lost about 20-30 chars, possibly more; i had to fix them manually), but now with SOAP that should work pretty well.

Link to comment
Share on other sites

We've done 3 full scale server merges so far. Managing guids as as u said, adding max(guid) of one server's database to all guids of other server database and its references for all guid types (char, acc, guild, item, etc.). To avoid guid gaps, we were thinking to sort out all guids form 1 to n, but for shortage of time and lot of problems with it we didn't do it in the end,

Account, character and guild names we managed by prepending/appending some temporary string to the colliding name which was younger than the other one (lvl 80 vs lvl 1, or by /played, whichever u prefer) Flagging it for a rename in case of character (at_login |= 1), and publishing a list of changed account names on forum (there wasn't more than 50 of them, while merging over 20k characters).

It was all done with PHP script, which i can share for inspiration, but it's kinda outdated.

Link to comment
Share on other sites

  • 1 month later...

In theory this possible do in same way but for this need implement muti-characters pdump generation but code will near to similar from existed.

Other way: save guild/etc data with leader? But this will allow cloning guild banks in result if leader chnaged in time 2 pdump generations

Also problem with duplicated guild names: in different character no way ask client for ask character rename guild.

Link to comment
Share on other sites

In theory this possible do in same way but for this need implement muti-characters pdump generation but code will near to similar from existed.

Other way: save guild/etc data with leader? But this will allow cloning guild banks in result if leader chnaged in time 2 pdump generations

Also problem with duplicated guild names: in different character no way ask client for ask character rename guild.

yes, you have to deal with it manually so or so

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use