Moving a character from an account to another one

[Nagad 2]

Can someone explain to me how to do that please?

[Winterfox 83]

@@Nagad

 

I looked up what i could find that needs to be changed to transfer a character from one acc to another. I didn't test it there may be bugs due that i forgot some table or something. You will have to test that out.

Also be aware that you can't transfer bank or storage things. So if a player transfers, he has to give his char zeny or items he wants to transfer before doing so.

 

Here is the sql:

UPDATE `char` SET `account_id` = NEW_ACCOUNTID WHERE `account_id` = OLD_ACCOUNTID AND `char_id` = CHARID;UPDATE `friends` SET `friend_account` = NEW_ACCOUNTID WHERE `friend_account` = OLD_ACCOUNTID AND `friend_id` = CHARID;UPDATE `guild_member` SET `account_id` = NEW_ACCOUNTID WHERE `account_id` = OLD_ACCOUNTID AND `char_id` = CHARID;UPDATE `party` SET `leader_id` = NEW_ACCOUNTID WHERE `leader_id` = OLD_ACCOUNTID AND `leader_char` = CHARID;

Edited July 12, 2015 by Winterfox