3ngHmrE5

1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for item_attr
5-- ----------------------------
6DROP TABLE IF EXISTS `item_attr`;
7CREATE TABLE `item_attr` (
8  `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_BONUS','MAGIC_DEF_GRADE_BONUS','CURSE_PCT','MAX_STAMINA','ATT_BONUS_TO_WARRIOR','ATT_BONUS_TO_ASSASSIN','ATT_BONUS_TO_SURA','ATT_BONUS_TO_SHAMAN','ATT_BONUS_TO_MONSTER','ATT_BONUS','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_ATT_BONUS_PER','MELEE_MAGIC_ATT_BONUS_PER','RESIST_ICE','RESIST_EARTH','RESIST_DARK','RESIST_CRITICAL','RESIST_PENETRATE','BLEEDING_REDUCE','BLEEDING_PCT','ATT_BONUS_TO_WOLFMAN','RESIST_WOLFMAN','RESIST_CLAW') NOT NULL DEFAULT 'MAX_HP',
9  `prob` int(11) unsigned NOT NULL DEFAULT '0',
10  `lv1` int(11) unsigned NOT NULL DEFAULT '0',
11  `lv2` int(11) unsigned NOT NULL DEFAULT '0',
12  `lv3` int(11) unsigned NOT NULL DEFAULT '0',
13  `lv4` int(11) unsigned NOT NULL DEFAULT '0',
14  `lv5` int(11) unsigned NOT NULL DEFAULT '0',
15  `weapon` int(11) unsigned NOT NULL DEFAULT '0',
16  `body` int(11) unsigned NOT NULL DEFAULT '0',
17  `wrist` int(11) unsigned NOT NULL DEFAULT '0',
18  `foots` int(11) unsigned NOT NULL DEFAULT '0',
19  `neck` int(11) unsigned NOT NULL DEFAULT '0',
20  `head` int(11) unsigned NOT NULL DEFAULT '0',
21  `shield` int(11) unsigned NOT NULL DEFAULT '0',
22  `ear` int(11) unsigned NOT NULL DEFAULT '0',
23  `costume_body` int(11) unsigned NOT NULL DEFAULT '0',
24  `costume_hair` int(11) unsigned NOT NULL DEFAULT '0',
25  `costume_weapon` int(11) unsigned NOT NULL DEFAULT '0',
26  `talizman` int(11) unsigned NOT NULL DEFAULT '0'
27) ENGINE=MyISAM DEFAULT CHARSET=latin1;
28
29-- ----------------------------
30-- Records of item_attr
31-- ----------------------------
32INSERT INTO `item_attr` VALUES ('MAX_HP', '30', '500', '800', '1000', '1500', '2000', '0', '5', '5', '5', '5', '0', '0', '0', '0', '0', '0', '0');
33INSERT INTO `item_attr` VALUES ('CON', '11', '8', '8', '8', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0');
34INSERT INTO `item_attr` VALUES ('INT', '11', '8', '8', '8', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0');
35INSERT INTO `item_attr` VALUES ('STR', '11', '8', '8', '8', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0');
36INSERT INTO `item_attr` VALUES ('DEX', '11', '8', '8', '8', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0');
37INSERT INTO `item_attr` VALUES ('ATT_SPEED', '8', '5', '5', '5', '6', '8', '0', '0', '0', '5', '0', '5', '0', '0', '0', '0', '0', '0');
38INSERT INTO `item_attr` VALUES ('MOV_SPEED', '18', '10', '10', '12', '15', '20', '0', '0', '0', '5', '0', '0', '0', '5', '0', '0', '0', '0');
39INSERT INTO `item_attr` VALUES ('CAST_SPEED', '8', '10', '10', '12', '15', '20', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
40INSERT INTO `item_attr` VALUES ('HP_REGEN', '60', '15', '12', '10', '20', '30', '0', '0', '0', '0', '5', '5', '0', '0', '0', '0', '0', '0');
41INSERT INTO `item_attr` VALUES ('SP_REGEN', '60', '15', '12', '10', '20', '30', '0', '0', '0', '0', '5', '5', '0', '0', '0', '0', '0', '0');
42INSERT INTO `item_attr` VALUES ('POISON_PCT', '8', '5', '5', '5', '6', '8', '5', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0');
43INSERT INTO `item_attr` VALUES ('STUN_PCT', '18', '5', '5', '5', '6', '8', '5', '0', '0', '5', '5', '0', '0', '0', '0', '0', '0', '0');
44INSERT INTO `item_attr` VALUES ('SLOW_PCT', '35', '5', '5', '5', '6', '8', '5', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0');
45INSERT INTO `item_attr` VALUES ('CRITICAL_PCT', '18', '5', '5', '5', '8', '10', '5', '0', '0', '5', '5', '0', '0', '0', '0', '0', '0', '0');
46INSERT INTO `item_attr` VALUES ('PENETRATE_PCT', '30', '5', '5', '5', '8', '10', '5', '0', '5', '0', '5', '0', '0', '0', '0', '0', '0', '0');
47INSERT INTO `item_attr` VALUES ('ATTBONUS_HUMAN', '20', '5', '5', '5', '8', '10', '5', '0', '5', '0', '0', '5', '5', '5', '0', '0', '0', '0');
48INSERT INTO `item_attr` VALUES ('ATTBONUS_ANIMAL', '35', '8', '10', '12', '15', '20', '5', '0', '5', '0', '0', '5', '5', '5', '0', '0', '0', '0');
49INSERT INTO `item_attr` VALUES ('ATTBONUS_ORC', '35', '8', '10', '12', '15', '20', '5', '0', '5', '0', '0', '5', '5', '5', '0', '0', '0', '0');
50INSERT INTO `item_attr` VALUES ('ATTBONUS_MILGYO', '35', '8', '10', '12', '15', '20', '5', '0', '5', '0', '0', '5', '5', '5', '0', '0', '0', '0');
51INSERT INTO `item_attr` VALUES ('ATTBONUS_UNDEAD', '35', '8', '10', '12', '15', '20', '5', '0', '5', '0', '0', '5', '5', '5', '0', '0', '0', '0');
52INSERT INTO `item_attr` VALUES ('ATTBONUS_DEVIL', '35', '8', '10', '12', '15', '20', '5', '0', '5', '0', '0', '5', '5', '5', '0', '0', '0', '0');
53INSERT INTO `item_attr` VALUES ('STEAL_HP', '50', '5', '5', '5', '8', '10', '0', '5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0');
54INSERT INTO `item_attr` VALUES ('STEAL_SP', '50', '5', '5', '5', '8', '10', '0', '5', '0', '0', '5', '5', '0', '0', '0', '0', '0', '0');
55INSERT INTO `item_attr` VALUES ('MANA_BURN_PCT', '18', '5', '5', '5', '8', '10', '0', '0', '5', '0', '0', '0', '0', '5', '0', '0', '0', '0');
56INSERT INTO `item_attr` VALUES ('BLOCK', '10', '8', '8', '10', '12', '15', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0');
57INSERT INTO `item_attr` VALUES ('DODGE', '10', '8', '8', '10', '12', '15', '0', '0', '0', '5', '0', '5', '0', '0', '0', '0', '0', '0');
58INSERT INTO `item_attr` VALUES ('RESIST_SWORD', '18', '8', '8', '10', '12', '15', '0', '5', '0', '5', '5', '0', '0', '5', '0', '0', '0', '0');
59INSERT INTO `item_attr` VALUES ('RESIST_TWOHAND', '18', '8', '8', '10', '12', '15', '0', '5', '0', '5', '5', '0', '0', '5', '0', '0', '0', '0');
60INSERT INTO `item_attr` VALUES ('RESIST_DAGGER', '18', '8', '8', '10', '12', '15', '0', '5', '0', '5', '5', '0', '0', '5', '0', '0', '0', '0');
61INSERT INTO `item_attr` VALUES ('RESIST_BELL', '18', '8', '8', '10', '12', '15', '0', '5', '0', '5', '5', '0', '0', '5', '0', '0', '0', '0');
62INSERT INTO `item_attr` VALUES ('RESIST_FAN', '18', '8', '8', '10', '12', '15', '0', '5', '0', '5', '5', '0', '0', '5', '0', '0', '0', '0');
63INSERT INTO `item_attr` VALUES ('RESIST_BOW', '18', '8', '8', '10', '12', '15', '0', '5', '0', '5', '5', '0', '0', '5', '0', '0', '0', '0');
64INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '25', '8', '8', '10', '12', '15', '0', '5', '5', '0', '0', '5', '0', '0', '0', '0', '0', '0');
65INSERT INTO `item_attr` VALUES ('REFLECT_MELEE', '18', '5', '5', '5', '8', '10', '0', '5', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0');
66INSERT INTO `item_attr` VALUES ('POISON_REDUCE', '18', '3', '3', '3', '4', '5', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0');
67INSERT INTO `item_attr` VALUES ('EXP_DOUBLE_BONUS', '10', '10', '10', '12', '15', '20', '0', '0', '0', '5', '5', '0', '5', '0', '0', '0', '0', '0');
68INSERT INTO `item_attr` VALUES ('GOLD_DOUBLE_BONUS', '10', '10', '10', '12', '15', '20', '0', '0', '0', '5', '5', '0', '5', '0', '0', '0', '0', '0');
69INSERT INTO `item_attr` VALUES ('ITEM_DROP_BONUS', '7', '4', '6', '8', '10', '10', '0', '0', '5', '0', '0', '0', '0', '5', '0', '0', '0', '0');
70INSERT INTO `item_attr` VALUES ('IMMUNE_STUN', '7', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0');
71INSERT INTO `item_attr` VALUES ('IMMUNE_SLOW', '9', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0');
72INSERT INTO `item_attr` VALUES ('ATT_GRADE_BONUS', '15', '10', '20', '30', '40', '50', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
73INSERT INTO `item_attr` VALUES ('RESIST_FIRE', '18', '8', '8', '10', '12', '15', '0', '5', '5', '0', '0', '5', '0', '0', '0', '0', '0', '0');
74INSERT INTO `item_attr` VALUES ('RESIST_ELEC', '18', '8', '8', '10', '12', '15', '0', '5', '5', '0', '0', '5', '0', '0', '0', '0', '0', '0');
75INSERT INTO `item_attr` VALUES ('RESIST_WIND', '18', '8', '8', '10', '12', '15', '0', '5', '5', '0', '0', '5', '0', '0', '0', '0', '0', '0');
76INSERT INTO `item_attr` VALUES ('RESIST_SWORD', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
77INSERT INTO `item_attr` VALUES ('RESIST_TWOHAND', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
78INSERT INTO `item_attr` VALUES ('RESIST_DAGGER', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
79INSERT INTO `item_attr` VALUES ('RESIST_BELL', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
80INSERT INTO `item_attr` VALUES ('RESIST_FAN', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
81INSERT INTO `item_attr` VALUES ('RESIST_BOW', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
82INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
83INSERT INTO `item_attr` VALUES ('RESIST_FIRE', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
84INSERT INTO `item_attr` VALUES ('RESIST_ELEC', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
85INSERT INTO `item_attr` VALUES ('RESIST_WIND', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
86INSERT INTO `item_attr` VALUES ('POISON_REDUCE', '18', '1', '1', '2', '3', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5');
87SET FOREIGN_KEY_CHECKS=1;