Jump to content
  • 0

Problem with //RESIST_HEART //RESIST_DARK //RESIST_ICE//


Darknetto

Question

4 answers to this question

Recommended Posts

  • 0

Hey friend :)

 

The structure of the table item_attr with new bonus

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');
  • Love 2
Link to comment
  • 0

 

Hey friend :)

 

The structure of the table item_attr with new bonus

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');

 

Not work...came out + exp (6.0) D: and not came out the new resist ç_ç

Help

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.