Skill is not saving when log out

[Jedzkie 58]

hi all! i tried to make a passive skill and then it worked perfectly, i already learned it, but when i logged out, the skill returns to being unlearned

[Dastgir 1244]

Check skill_tree.conf, if you have proper data there, also check lua side, or maybe check map server for any error about sql.

[PokemonRO 2]

Skills should be stored via sql, make sure you have skill table

 

CREATE TABLE IF NOT EXISTS `skill` (  `char_id` int(11) unsigned NOT NULL DEFAULT '0',  `id` smallint(11) unsigned NOT NULL DEFAULT '0',  `lv` tinyint(4) unsigned NOT NULL DEFAULT '0',  `flag` tinyint(1) unsigned NOT NULL DEFAULT '0',  PRIMARY KEY (`char_id`,`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[Jedzkie 58]

Check skill_tree.conf, if you have proper data there, also check lua side, or maybe check map server for any error about sql.

 

i already checked it, there's no map-server error or any sql errors. btw, i set the skill as quest skill.

 

 

Skills should be stored via sql, make sure you have skill table

 

CREATE TABLE IF NOT EXISTS `skill` (  `char_id` int(11) unsigned NOT NULL DEFAULT '0',  `id` smallint(11) unsigned NOT NULL DEFAULT '0',  `lv` tinyint(4) unsigned NOT NULL DEFAULT '0',  `flag` tinyint(1) unsigned NOT NULL DEFAULT '0',  PRIMARY KEY (`char_id`,`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

i do have skill table in my sql, but still its not saving.

[PokemonRO 2]

if your skill table is empty, your console will have a debug as to why it isn't saving. This is common problem if the field names are mismatching or the column count isn't correct

[Jedzkie 58]

i noticed the id of my skill is in the skill table, but still removes the skill when i logged out.

[Jedzkie 58]

bump? need help

[roygbiv 0]

i have the same issue here, i know this topic is old. but have you fixed this?

[ayre 1]

Does the map server say anything? Did you compile the server to match your EXE's date?

[Jedzkie 58]

i've already fixed this issue, try to put the skill on the last slot of your skill tree.

[roygbiv 0]

thanks. problem solved