[Guide][4.0.02] Class Change by database edition

[Tima]

One way of enabling class change in the server is by direct modification in the database of the game. This was a process used in some servers and it is not too difficult, the problem is that modification on the database with the server on, in special, modification on the avatar information that is online can be lost or corrupted. I never had errors executing the script with the avatar offline. Also, all the information here i discover by testing and changing the database, may someone know something that can contribute to the overall process, and all contribution would be appreciated.

Lets start:
Basic the process of changing the avatar class is separated in 3 steps:

1- Changing the id of class of the avatar and uploading the new Appearance.
2- Removing and adding Information/Spells (like racial) on the avatar.
3- Change the Equipment.

When we just do step 1, The server will remove all the Tree Skills of the avatar, and his build will be reseted. But skills like the racial or Specials skill like the world mystery or Druid teleport for example were not removed, so we need to remove manually. one by one.

Another thing important is the ID of Classes, Skills, that for this script i put all here:

41238=League
41240=Empire
58942=Male Avatar
58943=Female Avatar

411435055=Kanian Druid
411435110=Kanian Mage
411435057=Kanian Paladin
411435053=Kanian Healler
411435087=Kanian Scout
411435013=Kanian Warrior
274401332=Kanian Bard
411435047=Elf Mage
411435008=Elf Summoner
411435018=Elf Paladin
411435043=Elf Healler
237546519=Elf Psy
274401320=Elf Bard
411435071=Gibberling Druid
411435040=Gibberling Psy
411435042=Gibberling Scout
411435089=Gibberling Warrior
237546511=Xadagan Mage
411435021=Xadagan Summoner
411435030=Xadagan Paladin
411435028=Xadagan Healler
411435050=Xadagan Psy
411435051=Xadagan Scout
411435099=Xadagan Warrior
274401304=Xadagan Bard
411435054=Orc Druid
411435056=Orc Paladin
411435088=Orc Scout
411435014=Orc Warrior
274401331=Orc Bard
411435016=Arizen Mage
411435032=Arizen Summoner
411435011=Arizen Healler
411435067=Arizen Psy

And the Binary information for the avatar Aperance[Just one example]:View attachment ari healler.zip

So for Step 1: for example lets change to Arizen Healler.
You can execute the following SQL:

"UPDATE `avatar` SET `race_class_res_id` = '411435028' WHERE `id` = 'ID OF YOUR AVATAR';

This will change the Avatar class res of your avatar, now we need to update the aperance of the avatar: basic we need to update avatar.character_client_info that is a BLOB for one of the bin files that I attached before, if your char is male upload ari_healler_m.bin if female ari_healler_f.bin. This can be achiv in PHP for something like:

$fp      = fopen('ari_healler_m.bin', 'r');
$data = fread($fp, filesize('ari_healler_m.bin'));
$data = addslashes($data);
fclose($fp);
$sql = "UPDATE `avatar` SET `race_class_res_id` = '411435028', character_client_info = '".$data."' WHERE `id` = 'ID OF YOUR AVATAR';";

After this Operation Your char have successfully changed the class.
Now we have to remove the incorrect skills, add the new ones and made other corrections (Like, the druid have a special camp for the PET appearance).

In construction...

 

[witcherivan]

Useful Guide! In total informatively and clearly.

 

[CrazyCamel]

Yea Thank you very much.
there is a stupid way can be made is when the player chaning the class you ban him until class change done.

 

[Milow Druida]

HELLO

but the class exchange item where you are ?

mechanic, item, spell ????

 

[Jinjer LC]

HELLO

but the class exchange item where you are ?

mechanic, item, spell ????

there is no class changer in 4.02 version. There's a core morpher but it doesn't work its not finished
game\data\ItemMall\Services\Avatar\RemortClassExchange.(ItemResource).xdb
however, it is possible to create the item y yourself in the game i ve seen it done