yagokurt 84 Posted May 30, 2014 Share Posted May 30, 2014 (edited) Hi guys, i was testing my new server file and when i was testing the energy system, i try put 2000 HP in a body and then i just notice i get "EXP 10%" and i alrdy checked my item_attr table and havent the bonus and checking on db the item have the bonus number 66 (MALL_EXPBONUS) then isnt a bad translation. Any1 have any idea what i can do to fix it? i'm using the official table from this topic. http://metin2dev.org/board/topic/174-metin2-db-tables/ Inventory: DB: Edited August 15, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Denis 1474 Posted May 30, 2014 Share Posted May 30, 2014 The id of the HP bonus is 1 Link to comment Share on other sites More sharing options...
yagokurt 84 Posted May 31, 2014 Author Share Posted May 31, 2014 The id of the HP bonus is 1 My problem isnt that, is i'm getting EXP on armor and i havent it added on my ITEM_ATTR table. Link to comment Share on other sites More sharing options...
Night 366 Posted May 31, 2014 Share Posted May 31, 2014 Shogun didnt make any error on the bonus attr table and i test it my self so you might have : 1-error on your db 2-you did it but forgot or someone else 3-you have a translate error on the client side Link to comment Share on other sites More sharing options...
yagokurt 84 Posted June 3, 2014 Author Share Posted June 3, 2014 Shogun didnt make any error on the bonus attr table and i test it my self so you might have : 1-error on your db 2-you did it but forgot or someone else 3-you have a translate error on the client side 1: This is the DB structure havent the mallexp SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `item_attr` -- ---------------------------- DROP TABLE IF EXISTS `item_attr`; CREATE TABLE `item_attr` ( `apply` enum('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_SPEED','MOV_SPEED','CAST_SPEED','HP_REGEN','SP_REGEN','POISON_PCT','STUN_PCT','SLOW_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','ATTBONUS_ANIMAL','ATTBONUS_ORC','ATTBONUS_MILGYO','ATTBONUS_UNDEAD','ATTBONUS_DEVIL','STEAL_HP','STEAL_SP','MANA_BURN_PCT','DAMAGE_SP_RECOVER','BLOCK','DODGE','RESIST_SWORD','RESIST_TWOHAND','RESIST_DAGGER','RESIST_BELL','RESIST_FAN','RESIST_BOW','RESIST_FIRE','RESIST_ELEC','RESIST_MAGIC','RESIST_WIND','REFLECT_MELEE','REFLECT_CURSE','POISON_REDUCE','KILL_SP_RECOVER','EXP_DOUBLE_BONUS','GOLD_DOUBLE_BONUS','ITEM_DROP_BONUS','POTION_BONUS','KILL_HP_RECOVER','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL','SKILL','BOW_DISTANCE','ATT_GRADE_BONUS','DEF_GRADE_BONUS','MAGIC_ATT_GRADE','MAGIC_DEF_GRADE','CURSE_PCT','MAX_STAMINA','ATT_BONUS_TO_WARRIOR','ATT_BONUS_TO_ASSASSIN','ATT_BONUS_TO_SURA','ATT_BONUS_TO_SHAMAN','NORMAL_HIT_DEFEND_BONUS','SKILL_DEFEND_BONUS','NOUSE1','RESIST_ICE','RESIST_EARTH','RESIST_DARK','NOUSE6','NOUSE7','NOUSE8','NOUSE9','NOUSE10','NOUSE11','NOUSE12','NOUSE13','NOUSE14','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN') NOT NULL DEFAULT 'MAX_HP', `prob` varchar(100) NOT NULL DEFAULT '', `lv1` varchar(100) NOT NULL DEFAULT '', `lv2` varchar(100) NOT NULL DEFAULT '', `lv3` varchar(100) NOT NULL DEFAULT '', `lv4` varchar(100) NOT NULL DEFAULT '', `lv5` varchar(100) NOT NULL DEFAULT '', `weapon` varchar(100) NOT NULL DEFAULT '', `body` varchar(100) NOT NULL DEFAULT '', `wrist` varchar(100) NOT NULL DEFAULT '', `foots` varchar(100) NOT NULL DEFAULT '', `neck` varchar(100) NOT NULL DEFAULT '', `head` varchar(100) NOT NULL DEFAULT '', `shield` varchar(100) NOT NULL DEFAULT '', `ear` varchar(100) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of item_attr -- ---------------------------- INSERT INTO `item_attr` VALUES ('MAX_HP', '35', '500', '500', '1000', '1500', '2000', '0', '5', '5', '5', '5', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('MAX_SP', '35', '10', '20', '30', '50', '80', '0', '0', '5', '5', '5', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('CON', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('INT', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('STR', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('DEX', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('ATT_SPEED', '8', '1', '2', '3', '5', '8', '0', '0', '0', '5', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('MOV_SPEED', '18', '2', '4', '6', '10', '20', '0', '0', '0', '5', '0', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('CAST_SPEED', '8', '2', '4', '6', '10', '20', '5', '5', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('HP_REGEN', '60', '4', '8', '12', '20', '30', '0', '0', '0', '0', '5', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('SP_REGEN', '60', '4', '8', '12', '20', '30', '0', '0', '0', '0', '5', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('POISON_PCT', '8', '1', '2', '3', '5', '8', '5', '0', '0', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('STUN_PCT', '18', '1', '2', '3', '5', '8', '5', '0', '0', '5', '5', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('SLOW_PCT', '35', '1', '2', '3', '5', '8', '5', '0', '0', '5', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('CRITICAL_PCT', '18', '1', '2', '3', '5', '10', '5', '0', '0', '5', '5', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('PENETRATE_PCT', '30', '1', '2', '3', '5', '10', '5', '0', '5', '0', '5', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('ATTBONUS_HUMAN', '15', '1', '2', '3', '5', '10', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('ATTBONUS_ANIMAL', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('ATTBONUS_ORC', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('ATTBONUS_MILGYO', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('ATTBONUS_UNDEAD', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('ATTBONUS_DEVIL', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('STEAL_HP', '50', '1', '2', '3', '5', '10', '0', '5', '5', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('STEAL_SP', '50', '1', '2', '3', '5', '10', '0', '5', '0', '0', '5', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('MANA_BURN_PCT', '18', '1', '2', '3', '5', '10', '0', '0', '5', '0', '0', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('BLOCK', '10', '2', '4', '6', '10', '15', '0', '0', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('DODGE', '10', '2', '4', '6', '10', '15', '0', '0', '0', '5', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_SWORD', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_TWOHAND', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_DAGGER', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_BELL', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_FAN', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_BOW', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_FIRE', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_ELEC', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '25', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_WIND', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('REFLECT_MELEE', '18', '1', '2', '3', '6', '10', '0', '5', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('POISON_REDUCE', '18', '1', '2', '3', '4', '5', '0', '0', '0', '0', '0', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('EXP_DOUBLE_BONUS', '10', '2', '4', '6', '8', '20', '0', '0', '0', '5', '5', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('GOLD_DOUBLE_BONUS', '10', '2', '4', '6', '8', '20', '0', '0', '0', '5', '5', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('ITEM_DROP_BONUS', '7', '2', '4', '6', '8', '20', '0', '0', '5', '0', '0', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('IMMUNE_STUN', '3', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0'); INSERT INTO `item_attr` VALUES ('IMMUNE_SLOW', '3', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0'); INSERT INTO `item_attr` VALUES ('ATT_GRADE_BONUS', '9', '5', '10', '15', '30', '50', '0', '5', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_DARK', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_ICE', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_EARTH', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); 2: Maybe where? 3: Isnt a translate error like u can see on the item table the bonus number is 66 and if u check this is EXP from mall. Link to comment Share on other sites More sharing options...
yagokurt 84 Posted June 19, 2014 Author Share Posted June 19, 2014 Up Link to comment Share on other sites More sharing options...
Solution yagokurt 84 Posted June 20, 2014 Author Solution Share Posted June 20, 2014 I found the problem. The problem was on ITEM_ATTR table. Idk why but this table have a "RESIST_DARK" "RESIST_ICE" and "RESIST_EARTH". But checking on wiki from DE, IT, UK this bonus isnt enable on officla and when one of this bonus come it come with wrong name. But if i edit then in a item manual witht the right number like 89 for dark, 88 for earth and 87 for ice they come right. Then i just disable this bonus on item_attr. Alrdy can close. Link to comment Share on other sites More sharing options...
Premium Galet 510 Posted June 21, 2014 Premium Share Posted June 21, 2014 I found the problem. The problem was on ITEM_ATTR table. Idk why but this table have a "RESIST_DARK" "RESIST_ICE" and "RESIST_EARTH". But checking on wiki from DE, IT, UK this bonus isnt enable on officla and when one of this bonus come it come with wrong name. But if i edit then in a item manual witht the right number like 89 for dark, 88 for earth and 87 for ice they come right. Then i just disable this bonus on item_attr. Alrdy can close. Why you doesn't use questlib.lua of these bonus ? I think they work then. Link to comment Share on other sites More sharing options...
Active Member ATAG 310 Posted July 9, 2014 Active Member Share Posted July 9, 2014 The indexes (SELECT apply+0) in item_attr are wrong. Fix (got directly from mainline's length.h): ALTER TABLE `item_attr` CHANGE `apply` `apply` ENUM('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_SPEED','MOV_SPEED','CAST_SPEED','HP_REGEN','SP_REGEN','POISON_PCT','STUN_PCT','SLOW_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','ATTBONUS_ANIMAL','ATTBONUS_ORC','ATTBONUS_MILGYO','ATTBONUS_UNDEAD','ATTBONUS_DEVIL','STEAL_HP','STEAL_SP','MANA_BURN_PCT','DAMAGE_SP_RECOVER','BLOCK','DODGE','RESIST_SWORD','RESIST_TWOHAND','RESIST_DAGGER','RESIST_BELL','RESIST_FAN','RESIST_BOW','RESIST_FIRE','RESIST_ELEC','RESIST_MAGIC','RESIST_WIND','REFLECT_MELEE','REFLECT_CURSE','POISON_REDUCE','KILL_SP_RECOVER','EXP_DOUBLE_BONUS','GOLD_DOUBLE_BONUS','ITEM_DROP_BONUS','POTION_BONUS','KILL_HP_RECOVER','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL','SKILL','BOW_DISTANCE','ATT_GRADE_BONUS','DEF_GRADE_BONUS','MAGIC_ATT_GRADE','MAGIC_DEF_GRADE','CURSE_PCT','MAX_STAMINA','ATTBONUS_WARRIOR','ATTBONUS_ASSASSIN','ATTBONUS_SURA','ATTBONUS_SHAMAN','ATTBONUS_MONSTER','MALL_ATTBONUS','MALL_DEFBONUS','MALL_EXPBONUS','MALL_ITEMBONUS','MALL_GOLDBONUS','MAX_HP_PCT','MAX_SP_PCT','SKILL_DAMAGE_BONUS','NORMAL_HIT_DAMAGE_BONUS','SKILL_DEFEND_BONUS','NORMAL_HIT_DEFEND_BONUS','PC_BANG_EXP_BONUS','PC_BANG_DROP_BONUS','EXTRACT_HP_PCT','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN','ENERGY','DEF_GRADE','COSTUME_ATTR_BONUS','MAGIC_ATTBONUS_PER','MELEE_MAGIC_ATTBONUS_PER','RESIST_ICE','RESIST_EARTH','RESIST_DARK','ANTI_CRITICAL_PCT','ANTI_PENETRATE_PCT') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'MAX_HP'; 2 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now