merging 2 character databases

[darkstalker]

Is that possible? one thing would be reallocating guids, that could be solved with adding a constant value to one of them, but what about player names, guild names? players can be force-renamed but don't know about guilds.

[Schmoozerd]

also can be renamed - you just need to use macros to detect these conflicts

I think the most annyoing will be the item guids.

[False.Genesis]

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.

[emsy]

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.

[Alex]

It's better to use SOAP pdump functionality, it guarantees everything will be stored/loaded according to the current version needs.

[emsy]

It's better to use SOAP pdump functionality, it guarantees everything will be stored/loaded according to the current version needs.

i'm not sure it preserves guilds, arena teams and guild banks

[VladimirMangos]

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.

[emsy]

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