Skill is not saving when log out

[Jedzkie]

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]

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]

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]

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]

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]

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

 

[Jedzkie]

bump? need help

 

[roygbiv]

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

 

[ayre]

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

 

[Jedzkie]

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

 

[roygbiv]

thanks. problem solved