Originally posted by [b]RedXIII[/b]
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=1787
When a bard/dancer character with skillpoints in queue uses the changesex command skillpoints are set to 0 on reconnection.
Scenario:
Gypsy applies skillpoints to gypsy skills
Gypsy changes sex, job changed to Clown
Clown logs in with awarded skillpoints from gypsy->clown conversion
Clown changes sex without applying skill points to Clown-specific skills
Gypsy logs in with 0 skill points.
This error only occurs when a bard/dancer has no skill points applied to their specific class' skills.
Code that causes the error is as follows:
SQL
UPDATE `char` SET `skill_point` = `skill_point` + ( SELECT SUM( lv )
FROM `skill` WHERE `char_id` = '150000' AND `id` >= '315' AND `id` <= '330' AND `lv` > '0' )
WHERE `char_id` = '150000';
@Line:1833 in char.c from 0x2723 from login-server.