Cunoo 210 Posted November 12, 2018 Share Posted November 12, 2018 Hi guys, I have one little problem.. I edit my tables in mysql, just I delete bonuses what I dont want in game.. Problem is if I add or change bonuses in item (71084, 71085), dont working set table and I have enable all bonuses in items.. Here my table: SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for item_attr -- ---------------------------- DROP TABLE IF EXISTS `item_attr`; CREATE TABLE `item_attr` ( `apply` enum('MAX_HP','CON','INT','STR','DEX','ATT_SPEED','CAST_SPEED','HP_REGEN','POISON_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','STEAL_HP','BLOCK','DODGE','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN','RESIST_MAGIC','REFLECT_MELEE','MAGIC_ATT_GRADE','ATT_GRADE_BONUS','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL') NOT NULL DEFAULT 'MAX_HP', `prob` varchar(100) NOT NULL DEFAULT '', `value` 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 '', `belt` varchar(100) NOT NULL, PRIMARY KEY (`apply`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of item_attr -- ---------------------------- INSERT INTO `item_attr` VALUES ('MAX_HP', '35', '3000', '0', '1', '1', '1', '1', '1', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('CON', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('INT', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('STR', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('DEX', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('ATT_SPEED', '8', '10', '0', '0', '0', '1', '0', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('CAST_SPEED', '8', '30', '1', '1', '1', '0', '0', '1', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('HP_REGEN', '65', '50', '0', '0', '1', '0', '1', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('POISON_PCT', '8', '10', '1', '0', '0', '0', '0', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('CRITICAL_PCT', '18', '15', '1', '0', '0', '1', '1', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('PENETRATE_PCT', '30', '15', '1', '0', '1', '0', '1', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('ATTBONUS_HUMAN', '10', '20', '1', '0', '1', '0', '0', '1', '1', '1', '0'); INSERT INTO `item_attr` VALUES ('STEAL_HP', '50', '20', '0', '1', '1', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('BLOCK', '10', '15', '0', '0', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `item_attr` VALUES ('DODGE', '10', '15', '0', '0', '0', '1', '0', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_WARRIOR', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_ASSASSIN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_SURA', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_SHAMAN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '25', '20', '0', '1', '1', '0', '0', '1', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('REFLECT_MELEE', '18', '30', '0', '1', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('MAGIC_ATT_GRADE', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('ATT_GRADE_BONUS', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('IMMUNE_STUN', '3', '100', '0', '0', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `item_attr` VALUES ('IMMUNE_SLOW', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('IMMUNE_FALL', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1'); Anyone know, where is problem? Edit: I mean problem is I delete defence (sword, dagger, bla bla...) and repair with resist (sura, war, bla bla) how I can fixed this but I dont want classic resist in 1/5 bonus.. Link to comment Share on other sites More sharing options...
xUniverse 18 Posted November 12, 2018 Share Posted November 12, 2018 Do you try without deleting the defenses (sword, dagger, etc) but setting the prob as 0? (I know that it isn't a solution, but it's a way to avoid the problem and it works fine for me) 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','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','BLEEDING_REDUCE','BLEEDING_PCT','ATTBONUS_WOLFMAN','RESIST_WOLFMAN','RESIST_CLAW','ANTI_RESIST_MAGIC') NOT NULL DEFAULT 'MAX_HP', `prob` varchar(100) NOT NULL DEFAULT '', `value` 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 '', `belt` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`apply`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of item_attr -- ---------------------------- INSERT INTO `item_attr` VALUES ('MAX_HP', '35', '3000', '0', '1', '1', '1', '1', '1', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('CON', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('INT', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('STR', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('DEX', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('ATT_SPEED', '8', '10', '0', '0', '0', '1', '0', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('CAST_SPEED', '8', '30', '1', '1', '1', '0', '0', '1', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('HP_REGEN', '65', '50', '0', '0', '1', '0', '1', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('POISON_PCT', '8', '10', '1', '0', '0', '0', '0', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('CRITICAL_PCT', '18', '15', '1', '0', '0', '1', '1', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('PENETRATE_PCT', '30', '15', '1', '0', '1', '0', '1', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('ATTBONUS_HUMAN', '10', '20', '1', '0', '1', '0', '0', '1', '1', '1', '0'); INSERT INTO `item_attr` VALUES ('STEAL_HP', '50', '20', '0', '1', '1', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('BLOCK', '10', '15', '0', '0', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `item_attr` VALUES ('DODGE', '10', '15', '0', '0', '0', '1', '0', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_WARRIOR', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_ASSASSIN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_SURA', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_SHAMAN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '25', '20', '0', '1', '1', '0', '0', '1', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('REFLECT_MELEE', '18', '30', '0', '1', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('RESIST_SWORD', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_TWOHAND', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_DAGGER', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_BELL', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_FAN', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('MAGIC_ATT_GRADE', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('ATT_GRADE_BONUS', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('IMMUNE_STUN', '3', '100', '0', '0', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `item_attr` VALUES ('IMMUNE_SLOW', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('IMMUNE_FALL', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1'); Link to comment Share on other sites More sharing options...
Cunoo 210 Posted November 14, 2018 Author Share Posted November 14, 2018 On 11/13/2018 at 12:26 AM, xUniverse said: Do you try without deleting the defenses (sword, dagger, etc) but setting the prob as 0? (I know that it isn't a solution, but it's a way to avoid the problem and it works fine for me) 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','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','BLEEDING_REDUCE','BLEEDING_PCT','ATTBONUS_WOLFMAN','RESIST_WOLFMAN','RESIST_CLAW','ANTI_RESIST_MAGIC') NOT NULL DEFAULT 'MAX_HP', `prob` varchar(100) NOT NULL DEFAULT '', `value` 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 '', `belt` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`apply`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of item_attr -- ---------------------------- INSERT INTO `item_attr` VALUES ('MAX_HP', '35', '3000', '0', '1', '1', '1', '1', '1', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('CON', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('INT', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('STR', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('DEX', '11', '15', '1', '0', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('ATT_SPEED', '8', '10', '0', '0', '0', '1', '0', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('CAST_SPEED', '8', '30', '1', '1', '1', '0', '0', '1', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('HP_REGEN', '65', '50', '0', '0', '1', '0', '1', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('POISON_PCT', '8', '10', '1', '0', '0', '0', '0', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('CRITICAL_PCT', '18', '15', '1', '0', '0', '1', '1', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('PENETRATE_PCT', '30', '15', '1', '0', '1', '0', '1', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('ATTBONUS_HUMAN', '10', '20', '1', '0', '1', '0', '0', '1', '1', '1', '0'); INSERT INTO `item_attr` VALUES ('STEAL_HP', '50', '20', '0', '1', '1', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('BLOCK', '10', '15', '0', '0', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `item_attr` VALUES ('DODGE', '10', '15', '0', '0', '0', '1', '0', '1', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_WARRIOR', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_ASSASSIN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_SURA', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_SHAMAN', '18', '20', '0', '1', '0', '1', '1', '0', '0', '1', '1'); INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '25', '20', '0', '1', '1', '0', '0', '1', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('REFLECT_MELEE', '18', '30', '0', '1', '0', '0', '0', '0', '1', '0', '1'); INSERT INTO `item_attr` VALUES ('RESIST_SWORD', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_TWOHAND', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_DAGGER', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_BELL', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_FAN', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('MAGIC_ATT_GRADE', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('ATT_GRADE_BONUS', '9', '150', '0', '1', '0', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('IMMUNE_STUN', '3', '100', '0', '0', '0', '0', '0', '0', '1', '0', '0'); INSERT INTO `item_attr` VALUES ('IMMUNE_SLOW', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1'); INSERT INTO `item_attr` VALUES ('IMMUNE_FALL', '3', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1'); Thanks, but I know it this.. I need know where is in source table with bonuses/structure table for fix this by myself.. Link to comment Share on other sites More sharing options...
Honorable Member xP3NG3Rx 19754 Posted November 14, 2018 Honorable Member Share Posted November 14, 2018 First of all what you want to fix? If you don't want to set for example MAX_HP in armors just set the value of the body column to 0 at the MAX_HP row. Link to comment Share on other sites More sharing options...
Cunoo 210 Posted November 14, 2018 Author Share Posted November 14, 2018 (edited) 47 minutes ago, xP3NG3Rx said: First of all what you want to fix? If you don't want to set for example MAX_HP in armors just set the value of the body column to 0 at the MAX_HP row. Look in my post table.. And now look screenshot.. I dont have problem with 1/0 (enable/disable) I have problem if is not my table original and I want change bonuses.. Spoiler https://metin2.download/picture/GIJ1rKas4zgBxa131bZmQ1hn22NKVe5p/.png screenshot: 20% stun, 20% mystic, 20% orc, 20% human, 30% undead, just I dont have set this in my table.. Edited September 11, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
flexio 83 Posted November 14, 2018 Share Posted November 14, 2018 `apply` enum('MAX_HP','CON','INT','STR','DEX','ATT_SPEED','CAST_SPEED','HP_REGEN','POISON_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','STEAL_HP','BLOCK','DODGE','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN','RESIST_MAGIC','REFLECT_MELEE','MAGIC_ATT_GRADE','ATT_GRADE_BONUS','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL') NOT NULL DEFAULT 'MAX_HP', apply value may be different from index in core. find enum EApplyTypes in common/length.h and compare index with item_attr apply EDIT: (slovakia lang) Z apply nic nemazej, názvy představují čísla a ty musí být přesně podle jádra. Například "ATTBONUS_ANIMAL" je číslo 18 v jádru, takže musí být i číslo 18 v item_attr. Link to comment Share on other sites More sharing options...
Cunoo 210 Posted November 14, 2018 Author Share Posted November 14, 2018 11 minutes ago, flexio said: `apply` enum('MAX_HP','CON','INT','STR','DEX','ATT_SPEED','CAST_SPEED','HP_REGEN','POISON_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','STEAL_HP','BLOCK','DODGE','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN','RESIST_MAGIC','REFLECT_MELEE','MAGIC_ATT_GRADE','ATT_GRADE_BONUS','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL') NOT NULL DEFAULT 'MAX_HP', apply value may be different from index in core. find enum EApplyTypes in common/length.h and compare index with item_attr apply Yeeeeeeeeeeeeeeees this is what I want find!! Thank you so much. Link to comment Share on other sites More sharing options...
Honorable Member xP3NG3Rx 19754 Posted November 14, 2018 Honorable Member Share Posted November 14, 2018 Now I can see, your english is terrible sorry, I didn't understand what was your problem just after the 3rd read. And actually you removed the bonuses from the enum of apply in the database, what is non-sense to me why. You have to keep up to date the apply enum in the database with the applies in the source. Link to comment Share on other sites More sharing options...
Cunoo 210 Posted November 14, 2018 Author Share Posted November 14, 2018 (edited) 3 hours ago, xP3NG3Rx said: Now I can see, your english is terrible sorry, I didn't understand what was your problem just after the 3rd read. And actually you removed the bonuses from the enum of apply in the database, what is non-sense to me why. You have to keep up to date the apply enum in the database with the applies in the source. Yes it is... I know.. And thank you, for informations. Solved! Thanks all for help. Spoiler https://metin2.download/picture/GIJ1rKas4zgBxa131bZmQ1hn22NKVe5p/.png Edited September 11, 2022 by Metin2 Dev Core X - External 2 Internal 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