Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2019
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.82 KB | None | 0 0
  1. /*
  2. Navicat MySQL Data Transfer
  3.  
  4. Source Server : INFERNUS TESTE
  5. Source Server Type : MySQL
  6. Source Server Version : 50533
  7. Source Host : 89.42.135.122:3306
  8. Source Schema : player
  9.  
  10. Target Server Type : MySQL
  11. Target Server Version : 50533
  12. File Encoding : 65001
  13.  
  14. Date: 22/09/2019 21:01:08
  15. */
  16.  
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  19.  
  20. -- ----------------------------
  21. -- Table structure for skill_proto
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `skill_proto`;
  24. CREATE TABLE `skill_proto` (
  25. `dwVnum` int(11) NOT NULL DEFAULT 0,
  26. `szName` varbinary(32) NOT NULL DEFAULT '',
  27. `bType` tinyint(4) NOT NULL DEFAULT 0,
  28. `bLevelStep` tinyint(4) NOT NULL DEFAULT 0,
  29. `bMaxLevel` tinyint(4) NOT NULL DEFAULT 0,
  30. `bLevelLimit` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  31. `szPointOn` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
  32. `szPointPoly` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  33. `szSPCostPoly` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  34. `szDurationPoly` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  35. `szDurationSPCostPoly` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  36. `szCooldownPoly` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  37. `szMasterBonusPoly` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  38. `szAttackGradePoly` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  39. `setFlag` set('ATTACK','USE_MELEE_DAMAGE','COMPUTE_ATTGRADE','SELFONLY','USE_MAGIC_DAMAGE','USE_HP_AS_COST','COMPUTE_MAGIC_DAMAGE','SPLASH','GIVE_PENALTY','USE_ARROW_DAMAGE','PENETRATE','IGNORE_TARGET_RATING','ATTACK_SLOW','ATTACK_STUN','HP_ABSORB','SP_ABSORB','ATTACK_FIRE_CONT','REMOVE_BAD_AFFECT','REMOVE_GOOD_AFFECT','CRUSH','ATTACK_POISON','TOGGLE','DISABLE_BY_POINT_UP','CRUSH_LONG') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  40. `setAffectFlag` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD','MUYEONG','REVIVE_INVISIBLE','FIRE','GICHEON','JEUNGRYEOK') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'YMIR',
  41. `szPointOn2` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'NONE',
  42. `szPointPoly2` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  43. `szDurationPoly2` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  44. `setAffectFlag2` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'YMIR',
  45. `szPointOn3` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'NONE',
  46. `szPointPoly3` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  47. `szDurationPoly3` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  48. `szGrandMasterAddSPCostPoly` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  49. `prerequisiteSkillVnum` int(11) NOT NULL DEFAULT 0,
  50. `prerequisiteSkillLevel` int(11) NOT NULL DEFAULT 0,
  51. `eSkillType` enum('NORMAL','MELEE','RANGE','MAGIC') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'NORMAL',
  52. `iMaxHit` tinyint(4) NOT NULL DEFAULT 0,
  53. `szSplashAroundDamageAdjustPoly` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
  54. `dwTargetRange` int(11) NOT NULL DEFAULT 1000,
  55. `dwSplashRange` int(10) UNSIGNED NOT NULL DEFAULT 0,
  56. PRIMARY KEY (`dwVnum`) USING BTREE
  57. ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
  58.  
  59. -- ----------------------------
  60. -- Records of skill_proto
  61. -- ----------------------------
  62. INSERT INTO `skill_proto` VALUES (1, 0xBBEFBFACC2FC, 1, 1, 1, 0, 'HP', '-( 1.1*atk + (0.5*atk + 1.5 * str)*k)', '40+100*k', '', '', '12', '-( 1.1*atk + (0.5*atk + 1.5 * str)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+100*k', 0, 0, 'MELEE', 5, '1', 0, 0);
  63. INSERT INTO `skill_proto` VALUES (2, 0xC6C8B9E6C7B3BFEC, 1, 1, 1, 0, 'HP', '-(3*atk + (0.8*atk + str*5 + dex*3 +con)*k)', '50+130*k', '', '', '15', '-(3*atk + (0.8*atk + str*5 + dex*3 +con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '50+130*k', 0, 0, 'MELEE', 12, '1', 0, 200);
  64. INSERT INTO `skill_proto` VALUES (3, 0xC0FCB1CDC8A5, 1, 1, 1, 0, 'ATT_SPEED', '50*k', '50+140*k', '60+90*k', '', '0', '50*k', '', 'SELFONLY,TOGGLE', 'JEONGWIHON', 'MOV_SPEED', '20*k', '60+90*k', '', '', '', '', '50+140*k', 0, 0, 'NORMAL', 1, '1', 0, 0);
  65. INSERT INTO `skill_proto` VALUES (4, 0xB0CBB0E6, 1, 1, 1, 0, 'ATT_GRADE', '(100 + str + lv * 3)*k', '100+200*k', '60+90*k', '', '0', '(100 + str + lv * 3)*k', '', 'SELFONLY,TOGGLE', 'GEOMGYEONG', 'NONE', '', '', '', '', '', '', '100+200*k', 0, 0, 'NORMAL', 1, '1', 0, 0);
  66. INSERT INTO `skill_proto` VALUES (5, 0xC5BAC8AFB0DD, 1, 1, 1, 0, 'HP', '-(2*atk + (atk + dex*3 + str*7 + con)*k)', '60+120*k', '', '', '12', '-(2*atk + (atk + dex*3 + str*7 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'MOV_SPEED', '150', '3', '', '', '', '', '60+120*k', 0, 0, 'MELEE', 4, '1', 0, 200);
  67. INSERT INTO `skill_proto` VALUES (16, 0xB1E2B0F8C2FC, 1, 1, 1, 0, 'HP', '-(2.3*atk + (4*atk + str*4 + con)*k)', '60+120*k', '', '', '15', '-(2.3*atk + (4*atk + str*4 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '60+120*k', 0, 0, 'MELEE', 4, '1', 0, 100);
  68. INSERT INTO `skill_proto` VALUES (17, 0xB0DDBBEAC5B8BFEC, 1, 1, 1, 0, 'HP', '-(2.3*atk + (3*atk + str*4 + con*3)*k)', '60+150*k', '', '', '15', '-(2.3*atk + (3*atk + str*4 + con*3)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '60+150*k', 0, 0, 'MELEE', 8, '1', 0, 200);
  69. INSERT INTO `skill_proto` VALUES (18, 0xB4EBC1F8B0A2, 1, 1, 1, 0, 'HP', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)', '50+140*k', '', '', '25', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,ATTACK_STUN', '', 'NONE', '100+k*1000/6', '2', '', '', '', '', '50+140*k', 0, 0, 'MELEE', 10, '1', 0, 400);
  70. INSERT INTO `skill_proto` VALUES (19, 0xC3B5B1D9C3DF, 1, 1, 1, 0, 'DEF_GRADE', '(200 + str*0.2 + con*0.5 ) *k', '80+220*k', '60+90*k', '', '63+90*k', '(200 + str*0.2 + con*0.5 ) *k', '', 'SELFONLY', 'CHEONGEUN', 'MOV_SPEED', '-(1+9*k)', '60+90*k', '', '', '', '', '80+220*k', 0, 0, 'NORMAL', 1, '1', 0, 0);
  71. INSERT INTO `skill_proto` VALUES (20, 0xB0CBC7B3, 1, 1, 1, 0, 'HP', '-(2*atk + (atk + dex*3 + str*5 + con)*k)', '40+120*k', '', '', '20', '-(2*atk + (atk + dex*3 + str*5 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '40+120*k', 0, 0, 'MELEE', 10, '0.5', 1200, 200);
  72. INSERT INTO `skill_proto` VALUES (31, 0xBECFBDC0, 2, 1, 1, 0, 'HP', '-(atk + (1.2 * atk + number(500, 700) + dex*4+ str*4 )*k)', '40+160*k', '', '', '15', '-(atk + (1.2 * atk + number(500, 700) + dex*4+ str*4 )*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+160*k', 0, 0, 'MELEE', 6, '0.8', 0, 0);
  73. INSERT INTO `skill_proto` VALUES (32, 0xB1C3BDC5C5BABFB5, 2, 1, 1, 0, 'HP', '-(atk + (1.6* atk + number(200,300) + dex*7 + str*7)*k)', '40+160*k', '', '', '20', '-(atk + (1.6* atk + number(200,300) + dex*7 + str*7)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+160*k', 0, 0, 'MELEE', 6, '0.8', 800, 0);
  74. INSERT INTO `skill_proto` VALUES (33, 0xC2F7B7FBBBEC, 2, 1, 1, 0, 'HP', '-(2*atk + (0.5*atk + dex*9 + str*7)*k)', '50+140*k', '', '', '25', '-(2*atk + (0.5*atk + dex*9 + str*7)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,ATTACK_POISON', '', 'NONE', '40*k', '', '', '', '', '', '50+140*k', 0, 0, 'MELEE', 12, '0.8', 0, 0);
  75. INSERT INTO `skill_proto` VALUES (34, 0xC0BAC7FCB9FD, 2, 1, 1, 0, 'NONE', '', '30+60*k', '15+30*k', '', '60', '', '', 'SELFONLY', 'EUNHYUNG', 'NONE', '', '', '', '', '', '', '30+60*k', 0, 0, 'NORMAL', 1, '1', 0, 0);
  76. INSERT INTO `skill_proto` VALUES (35, 0xBBEAB0F8BAD0, 2, 1, 1, 0, 'HP', '-(lv*2+(atk + str*3 + dex*18)*k)', '40+130*k', '', '', '25', '-(lv*2+(atk + str*3 + dex*18)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,ATTACK_POISON', '', 'NONE', '60*k', '5+25*k', '', '', '', '', '40+130*k', 0, 0, 'MAGIC', 0, '0.5', 800, 200);
  77. INSERT INTO `skill_proto` VALUES (46, 0xBFACBBE7, 2, 1, 1, 0, 'HP', '-(atk + 0.2*atk*floor(2+k*6)+ (0.8*atk+dex*8*ar) *k)', '40+130*k', '', '', '15', '-(atk + 0.2*atk*floor(2+k*6)+ (0.8*atk+dex*8*ar) *k)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+130*k', 0, 0, 'RANGE', 1, '1', 2500, 0);
  78. INSERT INTO `skill_proto` VALUES (47, 0xB0FCB0DDBCFA, 2, 1, 1, 0, 'HP', '-(atk + (1.7*atk + dex*2+ str*2)*k)', '30+130*k', '', '', '12', '-(atk + (1.7*atk + dex*2+ str*2)*k)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '30+130*k', 0, 0, 'RANGE', 8, '1', 2500, 0);
  79. INSERT INTO `skill_proto` VALUES (48, 0xC8ADC1B6C6C4, 2, 1, 1, 0, 'HP', '-(1.5*atk + (2.6*atk + number(100, 300))*k)', '50+130*k', '', '', '25', '-(1.5*atk + (2.6*atk + number(100, 300))*k)', '', 'ATTACK,SPLASH,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '50+130*k', 0, 0, 'RANGE', 12, '0.6', 2500, 300);
  80. INSERT INTO `skill_proto` VALUES (49, 0xB0E6B0F8BCFA, 2, 1, 1, 0, 'MOV_SPEED', '60*k', '30+40*k', '15+30*k', '', '30+30*k', '60*k', '', 'SELFONLY', 'GYEONGGONG', 'NONE', '', '', '', '', '', '', '30+40*k', 0, 0, 'NORMAL', 1, '1', 0, 0);
  81. INSERT INTO `skill_proto` VALUES (50, 0xB5B6B1E2B1C3, 2, 1, 1, 0, 'HP', '-(atk + (1.2*atk + number(100, 200)+dex*6+str*2)*k)', '40+160*k', '', '', '25', '-(atk + (1.2*atk + number(100, 200)+dex*6+str*2)*k)', '', 'ATTACK,SPLASH,USE_ARROW_DAMAGE,CRUSH,ATTACK_POISON', '', 'NONE', '80*k', '15+30*k', '', '', '', '', '40+160*k', 0, 0, 'RANGE', 12, '0.5', 2500, 300);
  82. INSERT INTO `skill_proto` VALUES (61, 0xBCE2B7C9C1F6, 3, 1, 1, 0, 'HP', '-(atk + 2*lv + iq*2 + ( 2*atk + str*4 + iq*14) * k)', '30+140*k', '', '', '10', '-(atk + 2*lv + iq*2 + ( 2*atk + str*4 + iq*14) * k)', '', 'ATTACK,USE_MELEE_DAMAGE,PENETRATE', '', 'NONE', '1+k*9', '', '', '', '', '', '30+140*k', 0, 0, 'MELEE', 4, '1', 0, 0);
  83. INSERT INTO `skill_proto` VALUES (62, 0xBFEBB1C7C6C4, 3, 1, 1, 0, 'HP', '-(1.1 * atk + 2*lv + iq*2+(1.5*atk + str + iq*12) * k)', '50+150*k', '', '', '15', '-(1.1 * atk + 2*lv + iq*2+(1.5*atk + str + iq*12) * k)', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,IGNORE_TARGET_RATING', '', 'NONE', '1+k*9', '', '', '', '', '', '50+150*k', 0, 0, 'MELEE', 12, '1', 0, 500);
  84. INSERT INTO `skill_proto` VALUES (63, 0xB1CDB0CB, 3, 1, 1, 0, 'ATT_GRADE', '(3 * iq + 2 * lv)*k', '20+240*k', '60+90*k', '2+23*k', '0', '(3 * iq + 2 * lv)*k', '', 'SELFONLY,TOGGLE', 'GWIGUM', 'HIT_HP_RECOVER', '10*k', '50+80*k', '', '', '', '', '20+240*k', 0, 0, 'NORMAL', 1, '1', 0, 0);
  85. INSERT INTO `skill_proto` VALUES (64, 0xB0F8C6F7, 3, 1, 1, 0, 'DODGE', '1 + 29 * k', '60+120*k', '60+100*k', '', '100', '1 + 29 * k', '', 'SELFONLY', 'TERROR', 'NONE', '', '', '', '', '', '', '60+120*k', 0, 0, 'NORMAL', 1, '1', 0, 0);
  86. INSERT INTO `skill_proto` VALUES (65, 0xC1D6B8B6B0A9, 3, 1, 1, 0, 'DEF_GRADE', '(iq+30)*k', '70+170*k', '30+120*k', '', '33+140*k', '(iq+30)*k', '', 'SELFONLY', 'JUMAGAP', 'REFLECT_MELEE', '(iq/4+10)*k', '30+120*k', '', '', '', '', '70+170*k', 0, 0, 'NORMAL', 1, '1', 0, 0);
  87. INSERT INTO `skill_proto` VALUES (66, 0xC6C4B9FDBCFA, 3, 1, 1, 0, 'HP', '-(40 +5*lv + 2*iq+(10*iq + 7*mwep + number(50,100) )*ar*k)', '30+120*k', '', '', '12', '-(40 +5*lv + 2*iq+(10*iq + 7*mwep + number(50,100) )*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,REMOVE_GOOD_AFFECT', '', 'NONE', '10+40*k', '7+23*k', '', '', '', '', '30+120*k', 0, 0, 'NORMAL', 5, '0.6', 1800, 200);
  88. INSERT INTO `skill_proto` VALUES (76, 0xB8B6B7C9, 3, 1, 1, 0, 'HP', '-(40 +5*lv + 2*iq +(13*iq + 6*mwep + number(50,100) )*ar*k)', '30+140*k', '', '', '7', '-(40 +5*lv + 2*iq +(13*iq + 6*mwep + number(50,100) )*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+140*k', 0, 0, 'MAGIC', 5, '0.6', 1500, 200);
  89. INSERT INTO `skill_proto` VALUES (77, 0xC8ADBFB0C6F8, 3, 1, 1, 0, 'HP', '-(5*lv + 2*iq+(10*iq + 6*mwep + str*4 + con*2 + number(180,200) )*k)', '60+140*k', '', '', '12', '-(5*lv + 2*iq+(10*iq + 6*mwep + str*4 + con*2 + number(180,200) )*k)', '', 'ATTACK,SELFONLY,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '60+140*k', 0, 0, 'MAGIC', 15, '0.8', 0, 500);
  90. INSERT INTO `skill_proto` VALUES (78, 0xB9ABBFB5C1F8, 3, 1, 1, 0, 'HP', '-(30+ 2*lv + 2*iq+(7*iq + 6*mwep + number(200,500))*ar*k)', '20+30*k', '40+30*k', '5+40*k', '43+30*k', '-(30+ 2*lv + 2*iq+(7*iq + 6*mwep + number(200,500))*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,TOGGLE', '', 'NONE', '', '', '', '', '', '', '20+30*k', 0, 0, 'MAGIC', 1, '1', 800, 0);
  91. INSERT INTO `skill_proto` VALUES (79, 0xC8E6BDC5BCF6C8A3, 3, 1, 1, 0, 'DEF_GRADE', '(0.5*iq+15)*k', '20+30*k', '60+120*k', '5+10*k', '63+120*k', '(0.5*iq+15)*k', '', 'SELFONLY,TOGGLE', 'MANASHIELD', 'MANASHIELD', '100-((iq*0.84)*k)', '60+120*k', '', '', '', '', '20+30*k', 0, 0, 'MAGIC', 1, '0.8', 0, 0);
  92. INSERT INTO `skill_proto` VALUES (80, 0xC5F5BCD3B8B6B7C9, 3, 1, 1, 0, 'HP', '-(40 + 2* lv + 2*iq +(2 * con + 2 * dex + 13*iq + 6*mwep + number(180, 200))*ar*k)', '40+120*k', '', '', '12', '-(40 + 2* lv + 2*iq +(2 * con + 2 * dex + 13*iq + 6*mwep + number(180, 200))*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,ATTACK_SLOW', '', 'NONE', '333+300*k', '10+10*k', '', '', '', '', '40+120*k', 0, 0, 'MAGIC', 9, '0.8', 1200, 400);
  93. INSERT INTO `skill_proto` VALUES (81, 0xB8B6C8AFB0DD, 3, 1, 1, 0, 'HP', '-(120 + 6*lv + (5 * con + 5 * dex + 29*iq + 9*mwep)*ar*k)', '80+220*k', '', '', '24', '-(120 + 6*lv + (5 * con + 5 * dex + 29*iq + 9*mwep)*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '80+220*k', 0, 0, 'MAGIC', 9, '0.4', 1500, 200);
  94. INSERT INTO `skill_proto` VALUES (91, 0xBAF1C6C4BACE, 4, 1, 1, 0, 'HP', '-(70 + 4*lv + (20*iq+5*mwep+50)*ar*k)', '30+160*k', '', '', '7', '-(70 + 4*lv + (20*iq+5*mwep+50)*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+160*k', 0, 0, 'MAGIC', 5, '0.5', 1800, 201);
  95. INSERT INTO `skill_proto` VALUES (92, 0xBFEBC6C4BBEA, 4, 1, 1, 0, 'HP', '-(60 + 5*lv + (18*iq + 6*mwep + 120)*ar*k)', '50+160*k', '', '', '8', '-(60 + 5*lv + (18*iq + 6*mwep + 120)*ar*k)', '', 'ATTACK,ATTACK_FIRE_CONT', '', 'NONE', 'lv+5*iq *k', 'iq*0.2*k', '', '', '', '', '50+160*k', 0, 0, 'MAGIC', 10, '0.8', 0, 0);
  96. INSERT INTO `skill_proto` VALUES (93, 0xC6D0B7E6C6F8, 4, 1, 1, 0, 'HP', '-(70 + 3*lv + (22*iq+13*mwep+100)*ar*k)', '50+160*k', '', '', '20', '-(70 + 3*lv + (22*iq+13*mwep+100)*ar*k)', '', 'ATTACK,SELFONLY,SPLASH,ATTACK_FIRE_CONT', '', 'NONE', 'lv+5*iq *k', 'iq*0.2*k', '', '', '', '', '50+160*k', 0, 0, 'MAGIC', 15, '0.8', 0, 500);
  97. INSERT INTO `skill_proto` VALUES (94, 0xC8A3BDC5, 4, 1, 1, 0, 'RESIST_NORMAL', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '40+160*k', '60+200*k', '', '10', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '', '', 'HOSIN', 'NONE', '', '', '', '', '', '', '40+160*k', 0, 0, 'NORMAL', 1, '1', 800, 0);
  98. INSERT INTO `skill_proto` VALUES (95, 0xB9DDBBE7, 4, 1, 1, 0, 'REFLECT_MELEE', '5+(iq*0.3 + 5)*k', '40+160*k', '60+200*k', '', '10', '5+(iq*0.3 + 5)*k', '', '', 'BOHO', 'NONE', '', '', '', '', '', '', '40+160*k', 0, 0, 'NORMAL', 1, '1', 1000, 0);
  99. INSERT INTO `skill_proto` VALUES (96, 0xB1E2C3B5B4EBB0F8, 4, 1, 1, 0, 'CRITICAL', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '40+160*k', '60+100*k', '', '10', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '', '', 'GICHEON', 'NONE', '', '', '', '', '', '', '40+160*k', 0, 0, 'NORMAL', 1, '1', 1000, 0);
  100. INSERT INTO `skill_proto` VALUES (106, 0xB3FAC0FCB7C9, 4, 1, 1, 0, 'HP', '-(60 + 4*lv + (7*iq+8*mwep+number(iq*5,iq*15))*ar*k)', '30+150*k', '', '', '7', '-(60 + 4*lv + (7*iq+8*mwep+number(iq*5,iq*15))*ar*k)', '', 'ATTACK,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+150*k', 0, 0, 'MAGIC', 5, '0.6', 1800, 200);
  101. INSERT INTO `skill_proto` VALUES (107, 0xBAADB6F4, 4, 1, 1, 0, 'HP', '-(40 + 4*lv + (13*iq+7*mwep+number(iq*5,iq*16))*ar*k)', '50+150*k', '', '', '15', '-(40 + 4*lv + (13*iq+7*mwep+number(iq*5,iq*16))*ar*k)', '', 'ATTACK,SPLASH,ATTACK_STUN', '', 'NONE', '50+1000*k/6', '5', '', '', '', '', '50+150*k', 0, 0, 'MAGIC', 15, '0.8', 1500, 400);
  102. INSERT INTO `skill_proto` VALUES (108, 0xC6F8B7DAB0DD, 4, 1, 1, 0, 'HP', '-(50 + 5*lv + (6*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '40+180*k', '', '', '10', '-(50 + 5*lv + (6*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '', 'ATTACK', '', 'NONE', '', '', '', '', '', '', '40+180*k', 0, 0, 'MAGIC', 7, '0.8', 2500, 0);
  103. INSERT INTO `skill_proto` VALUES (109, 0xC1A4BEF7C0CE, 4, 1, 1, 0, 'HP', '200+4*lv+(10*iq+6*mwep+number(600,800))*k', '40+200*k', '', '', '10', '200+4*lv+(10*iq+6*mwep+number(600,800))*k', '', 'REMOVE_BAD_AFFECT', '', 'NONE', '20+80*k', '0', '', '', '', '', '40+200*k', 0, 0, 'NORMAL', 1, '1', 1000, 0);
  104. INSERT INTO `skill_proto` VALUES (110, 0xC4E8BCD3, 4, 1, 1, 0, 'MOV_SPEED', '5 + 35*k', '60+120*k', '60+100*k', '', '10', '5 + 35*k', '', '', 'KWAESOK', 'CASTING_SPEED', '3+33*k', '60+100*k', '', '', '', '', '60+120*k', 0, 0, 'NORMAL', 1, '1', 1000, 0);
  105. INSERT INTO `skill_proto` VALUES (111, 0xC1F5B7C2BCFA, 4, 1, 1, 0, 'ATT_GRADE', '5+(iq*0.2 +15)*k', '60+120*k', '60+100*k', '', '10', '5+(iq*0.2 +15)*k', '', '', 'JEUNGRYEOK', 'NONE', '', '', '', '', '', '', '60+120*k', 0, 0, 'NORMAL', 1, '1', 1000, 0);
  106. INSERT INTO `skill_proto` VALUES (121, 0xC5EBBCD6B7C2, 0, 1, 40, 0, 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  107. INSERT INTO `skill_proto` VALUES (122, 0xBFACB0E8B1E2, 0, 1, 2, 0, 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  108. INSERT INTO `skill_proto` VALUES (124, 0xC3A4B1A4BCFA, 0, 1, 40, 0, 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  109. INSERT INTO `skill_proto` VALUES (125, 0xBAAFBDC5, 0, 1, 40, 0, 'NONE', '', '', '10+1000*k', '', '', '', '', 'DISABLE_BY_POINT_UP', 'YMIR', 'NONE', '', '', 'YMIR', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 1000, 0);
  110. INSERT INTO `skill_proto` VALUES (126, 0xBDC5BCF6BEEE, 0, 1, 20, 0, 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  111. INSERT INTO `skill_proto` VALUES (127, 0xC3B5C1B6BEEE, 0, 1, 20, 0, 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  112. INSERT INTO `skill_proto` VALUES (128, 0xC1F8B3EBBEEE, 0, 1, 20, 0, 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  113. INSERT INTO `skill_proto` VALUES (129, 0xB5D0B0A9BCFA, 0, 1, 40, 0, 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', 'NONE', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  114. INSERT INTO `skill_proto` VALUES (130, 0xBDC2B8B6, 0, 1, 1, 0, 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  115. INSERT INTO `skill_proto` VALUES (131, 0xB8BBBCD2C8AF, 0, 1, 10, 0, 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  116. INSERT INTO `skill_proto` VALUES (137, 0xB3ADB9AB, 5, 1, 1, 50, 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '5-(4*k)', '', '', 'ATTACK,USE_MELEE_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'MELEE', 10, '1', 300, 0);
  117. INSERT INTO `skill_proto` VALUES (138, 0xB5B9B0DD, 5, 1, 1, 52, 'HP', '-(2.4*(200+1.5*lv)+(3*200*k))', '60+120*k', '', '', '15', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH_LONG', '', 'MOV_SPEED', '50', '5', '', '', '', '', '', 0, 0, 'MELEE', 6, '1', 400, 100);
  118. INSERT INTO `skill_proto` VALUES (139, 0xC5BBC3E2, 5, 1, 1, 55, 'HP', '-(2*(200+1.5*lv)+(3*200*k))', '60+160*k', '', '', '20', '', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'MELEE', 12, '1', 400, 250);
  119. INSERT INTO `skill_proto` VALUES (140, 0xB3ADB9AB28C8B029, 5, 1, 1, 50, 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '10', '', '', 'ATTACK,USE_ARROW_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', 0, 0, '', 5, '1', 2500, 0);
  120. INSERT INTO `skill_proto` VALUES (151, 0xBFEBBEC8, 0, 1, 7, 0, 'NONE', '', '', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  121. INSERT INTO `skill_proto` VALUES (152, 0xBFEBBDC5C0C7C7C7, 0, 1, 7, 0, 'MAX_HP', 'maxhp*0.2*k', '150+150*k', '300', '', '600', '', '', '', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  122. INSERT INTO `skill_proto` VALUES (153, 0xBFEBBDC5C0C7C3E0BAB9, 0, 1, 7, 0, 'MAX_SP', 'maxsp*0.2*k', '150+150*k', '300', '', '600', '', '', '', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  123. INSERT INTO `skill_proto` VALUES (154, 0xBCBAC8D6B0A9, 0, 1, 7, 0, 'DEF_GRADE', 'odef*0.1*k', '150+150*k', '180', '', '480', '', '', '', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  124. INSERT INTO `skill_proto` VALUES (155, 0xB0A1BCD3C8AD, 0, 1, 7, 0, 'MOV_SPEED', '15*k', '150+150*k', '180', '', '480', '', '', '', '', 'ATT_SPEED', '15*k', '180', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  125. INSERT INTO `skill_proto` VALUES (156, 0xBFEBBDC5C0C7BAD0B3EB, 0, 1, 7, 0, 'CRITICAL', '50*k', '150+150*k', '180', '', '480', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  126. INSERT INTO `skill_proto` VALUES (157, 0xC1D6B9AEBCFA, 0, 1, 7, 0, 'CASTING_SPEED', '50*k', '150+150*k', '180', '', '480', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  127. INSERT INTO `skill_proto` VALUES (158, 0xB1E6B5E5C0CCB5BF, 0, 1, 3, 0, 'NONE', '', '', '', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  128. INSERT INTO `skill_proto` VALUES (159, 0xB0F8B0A3C0C7B9AE, 0, 1, 5, 0, 'NONE', '', '', '', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  129. INSERT INTO `skill_proto` VALUES (160, 0xB0A1BCD3C8AD, 0, 1, 5, 0, 'NONE', '3*k', '80-12*k', '300', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  130. INSERT INTO `skill_proto` VALUES (161, 0xB0F8B0A3C0C7B9AE, 0, 1, 2, 0, 'NONE', '', '50', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  131. INSERT INTO `skill_proto` VALUES (162, 0xB0F8B0A3C0CCB5BF, 0, 1, 2, 0, 'NONE', '', '20', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  132. INSERT INTO `skill_proto` VALUES (256, 0x4352555348323030BDBAC5B3, 0, 1, 1, 0, 'HP', '-5*k*atk', '', '', '', '2', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'MELEE', 0, '1', 0, 300);
  133. INSERT INTO `skill_proto` VALUES (257, 0xC0CFB9DDB9FCC0A7333530BDBAC5B3, 0, 1, 1, 0, 'HP', '-5*k*atk', '', '', '', '5', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'MELEE', 0, '1', 0, 525);
  134. INSERT INTO `skill_proto` VALUES (258, 0x4352555348333030BDBAC5B3, 0, 1, 1, 0, 'HP', '-5*k*atk', '', '', '', '7', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'MELEE', 0, '1', 0, 450);
  135. INSERT INTO `skill_proto` VALUES (259, 0xC0CFB9DDB9FCC0A7323030BDBAC5B3, 0, 1, 1, 0, 'HP', '-5*k*atk', '', '', '', '9', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'MELEE', 0, '1', 0, 300);
  136. INSERT INTO `skill_proto` VALUES (260, 0x4355525348343030BDBAC5B3, 0, 1, 1, 0, 'HP', '-5*k*atk', '', '', '', '10', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'MELEE', 0, '1', 0, 600);
  137. INSERT INTO `skill_proto` VALUES (261, 0xB5B6323530BDBAC5B3, 0, 1, 1, 0, 'HP', '-5*k*atk', '', '', '', '9', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,ATTACK_POISON', '', 'NONE', '80', '', '', '', '', '', '', 0, 0, 'MELEE', 0, '1', 0, 375);
  138. INSERT INTO `skill_proto` VALUES (262, 0x534C4F57333030BDBAC5B3, 0, 1, 1, 0, 'HP', '-5*k*atk', '', '', '', '12', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'MOV_SPEED', '-20', '10', '', '', '', '', '', 0, 0, 'MELEE', 0, '1', 0, 450);
  139. INSERT INTO `skill_proto` VALUES (6, 0xB1E2C7F7C3EBB8ED, 1, 1, 1, 0, 'HP', '-( 3*atk + (atk + 1.5 * str)*k)*1.07', '300+150*k', '', '', '60', '-( 3*atk + (atk + 1.5 * str)*k)*1.07', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '300+150*k', 0, 0, 'MELEE', 5, '1', 0, 0);
  140. INSERT INTO `skill_proto` VALUES (21, 0xB3FAB0CBB5B5B7A1, 1, 1, 1, 0, 'HP', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)*1.1', '300+180*k', '', '', '60', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)*1.1', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '300+180*k', 0, 0, 'MELEE', 10, '1', 0, 400);
  141. INSERT INTO `skill_proto` VALUES (36, 0xC8E6BCB6BCF6, 2, 1, 1, 0, 'HP', '-((lv*2+(atk + str*3 + dex*18)*k)*1.1)', '300+180*k', '', '', '60', '-((lv*2+(atk + str*3 + dex*18)*k)*1.1)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '60*k', '5+25*k', '', '', '', '', '300+180*k', 0, 0, 'MELEE', 6, '0.5', 800, 0);
  142. INSERT INTO `skill_proto` VALUES (51, 0xBCB6B1A4C5BA, 2, 1, 1, 0, 'HP', '-((atk + (1.2*atk + number(100, 200)+dex*6+str*2)*k)*1.1)', '200+200*k', '', '', '60', '-((atk + (1.2*atk + number(100, 200)+dex*6+str*2)*k)*1.1)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '80*k', '15+30*k', '', '', '', '', '200+200*k', 0, 0, 'NORMAL', 5, '0.5', 0, 0);
  143. INSERT INTO `skill_proto` VALUES (37, 0x446F7070656C737072756E67, 2, 1, 1, 0, 'HP', '-((lv*2+(atk + str*3 + dex*17)*k)*1.2)', '320+181*k', '', '', '60', '', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'MELEE', 6, '1', 0, 200);
  144. INSERT INTO `skill_proto` VALUES (141, 0xC1F5C7F7, 0, 1, 40, 0, 'NONE', '1333.3*k', '', '', '', '', '', '', NULL, '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  145. INSERT INTO `skill_proto` VALUES (142, 0xC3B6C5EB, 0, 1, 40, 0, 'NONE', '20*k', '', '', '', '', '', '', NULL, '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  146. INSERT INTO `skill_proto` VALUES (7, 0x5765697368656974736B72656973, 1, 1, 1, 0, 'HP', '-( 3*atk + (atk + 1.5 * str)*k)*1.07', '300+150*k', '', '', '60', '-( 3*atk + (atk + 1.5 * str)*k)*1.07', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'MELEE', 5, '1', 0, 0);
  147.  
  148. SET FOREIGN_KEY_CHECKS = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement