mob_skill_db2_re.sql 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165
  1. #
  2. # Table structure for table `mob_skill_db2_re`
  3. #
  4. DROP TABLE IF EXISTS `mob_skill_db2_re`;
  5. CREATE TABLE IF NOT EXISTS `mob_skill_db2_re` (
  6. `MOB_ID` smallint(6) NOT NULL,
  7. `INFO` text NOT NULL,
  8. `STATE` text NOT NULL,
  9. `SKILL_ID` smallint(6) NOT NULL,
  10. `SKILL_LV` tinyint(4) NOT NULL,
  11. `RATE` smallint(4) NOT NULL,
  12. `CASTTIME` mediumint(9) NOT NULL,
  13. `DELAY` int(9) NOT NULL,
  14. `CANCELABLE` text NOT NULL,
  15. `TARGET` text NOT NULL,
  16. `CONDITION` text NOT NULL,
  17. `CONDITION_VALUE` text,
  18. `VAL1` mediumint(9) DEFAULT NULL,
  19. `VAL2` mediumint(9) DEFAULT NULL,
  20. `VAL3` mediumint(9) DEFAULT NULL,
  21. `VAL4` mediumint(9) DEFAULT NULL,
  22. `VAL5` mediumint(9) DEFAULT NULL,
  23. `EMOTION` text,
  24. `CHAT` text
  25. ) ENGINE=MyISAM;
  26. # Custom Mob Skill Database
  27. #
  28. # Structure of Database:
  29. #REPLACE INTO `mob_skill_db2_re` VALUES ( MobID,'Dummy value (info only)','State',SkillID,SkillLv,Rate,CastTime,Delay,'Cancelable','Target','Condition type','Condition value',val1,val2,val3,val4,val5,'Emotion','Chat');
  30. #
  31. # RATE: the chance of the skill being casted when the condition is fulfilled (10000 = 100%).
  32. # DELAY: the time (in milliseconds) before attempting to recast the same skill.
  33. #
  34. # STATE:
  35. # any (except dead) / idle (in standby) / walk (in movement) / dead (on killed) /
  36. # loot /attack / angry (like attack, except player has not attacked mob yet) /
  37. # chase (following target, after being attacked) / follow (following target,
  38. # without being attacked) / anytarget (attack+angry+chase+follow)
  39. #
  40. # TARGET:
  41. # target (current target) / self / friend / master / randomtarget (any enemy within skill's range)
  42. #
  43. # The following are for ground-skills, a random target tile is selected from the specified area:
  44. # around1 (3x3 area around self) / around2 (5x5 area around self) /
  45. # around3 (7x7 area around self) / around4 (9x9 area around self) /
  46. # around5 (3x3 area around target) / around6 (5x5 area around target) /
  47. # around7 (7x7 area around target) / around8 (9x9 area around target) /
  48. # around = around4
  49. #
  50. # CONDITION:
  51. # always Unconditional (no condition value).
  52. # onspawn When mob spawns/respawns (no condition value).
  53. # myhpltmaxrate When mob's HP drops to the specified %.
  54. # myhpinrate When mob's HP is in a certain % range (condition value = lower bound, val1 = upper bound).
  55. # mystatuson If mob has the specified abnormality in status.
  56. # mystatusoff If mob has ended the specified abnormality in status.
  57. # friendhpltmaxrate When mob's friend's HP drops to the specified %.
  58. # friendhpinrate When mob's friend's HP is in a certain % range (condition value = lower bound, val1 = upper bound).
  59. # friendstatuson If friend has the specified abnormality in status.
  60. # friendstatusoff If friend has ended the specified abnormality in status.
  61. # attackpcgt When attack PCs become greater than specified number.
  62. # attackpcge When attack PCs become greater than or equal to the specified number.
  63. # slavelt When number of slaves is less than the original specified number.
  64. # slavele When number of slaves is less than or equal to the original specified number.
  65. # closedattacked When close range melee attacked (no condition value).
  66. # longrangeattacked When long range attacked, ex. bows, guns, ranged skills (no condition value).
  67. # skillused When the specified skill is used on the mob.
  68. # afterskill After mob casts the specified skill.
  69. # casttargeted When a target is in cast range (no condition value).
  70. # rudeattacked When mob is rude attacked (no condition value).
  71. #
  72. # Status abnormalities specified through the statuson/statusoff system:
  73. # anybad (any type of state change) / stone / freeze / stun / sleep /
  74. # poison / curse / silence / confusion / blind / hiding / sight (unhidden)
  75. #
  76. # Note: if a negative MobID is provided, the skill will be treated as 'global':
  77. # -1: added for all boss types.
  78. # -2: added for all normal types.
  79. # -3: added for all mobs.
  80. # rAthena Dev Team
  81. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  82. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@AL_TELEPORT','walk',26,1,500,0,5000,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  83. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@KN_BRANDISHSPEAR','attack',57,10,2000,500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  84. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@MO_BODYRELOCATION','chase',264,1,200,200,1000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  85. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@NPC_ARMORBRAKE','attack',344,10,2000,0,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  86. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@NPC_CALLSLAVE','attack',352,1,10000,0,30000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  87. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@NPC_CALLSLAVE','idle',352,1,10000,0,30000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  88. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@NPC_DARKBREATH','attack',202,5,2000,800,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  89. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@NPC_DARKSTRIKE','chase',340,10,200,0,1000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  90. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@NPC_GUIDEDATTACK','attack',172,5,500,0,20000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  91. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@NPC_POWERUP','attack',349,5,10000,0,30000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,'6',NULL);
  92. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@NPC_SUMMONSLAVE','attack',196,6,10000,700,10000,'no','self','slavele','3',1902,NULL,NULL,NULL,NULL,NULL,NULL);
  93. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@NPC_SUMMONSLAVE','idle',196,6,10000,700,10000,'no','self','slavele','3',1902,NULL,NULL,NULL,NULL,NULL,NULL);
  94. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@WZ_VERMILION','attack',85,10,2000,500,2000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  95. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@WZ_VERMILION','chase',85,10,200,500,2000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  96. #REPLACE INTO `mob_skill_db2_re` VALUES (1900,'Valaris@WZ_VERMILION','chase',85,10,500,500,2000,'no','target','skillused','18',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  97. #REPLACE INTO `mob_skill_db2_re` VALUES (1901,'Valaris\'s Worshipper@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  98. #REPLACE INTO `mob_skill_db2_re` VALUES (1901,'Valaris\'s Worshipper@NPC_CURSEATTACK','attack',181,3,500,800,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  99. #REPLACE INTO `mob_skill_db2_re` VALUES (1901,'Valaris\'s Worshipper@NPC_DARKNESSATTACK','attack',190,2,500,500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL);
  100. #REPLACE INTO `mob_skill_db2_re` VALUES (1901,'Valaris\'s Worshipper@NPC_EMOTION','chase',197,1,20,0,5000,'yes','self','always','0',19,129,NULL,NULL,NULL,NULL,NULL);
  101. #REPLACE INTO `mob_skill_db2_re` VALUES (1901,'Valaris\'s Worshipper@NPC_EMOTION','idle',197,1,200,0,5000,'yes','self','always','0',6,1173,NULL,NULL,NULL,NULL,NULL);
  102. #REPLACE INTO `mob_skill_db2_re` VALUES (1901,'Valaris\'s Worshipper@NPC_EMOTION','walk',197,1,200,0,5000,'yes','self','always','0',2,NULL,NULL,NULL,NULL,NULL,NULL);
  103. #REPLACE INTO `mob_skill_db2_re` VALUES (1901,'Valaris\'s Worshipper@NPC_HALLUCINATION','attack',207,1,500,500,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  104. #REPLACE INTO `mob_skill_db2_re` VALUES (1901,'Valaris\'s Worshipper@NPC_HALLUCINATION','chase',207,1,50,500,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  105. #REPLACE INTO `mob_skill_db2_re` VALUES (1901,'Valaris\'s Worshipper@SA_DISPELL','attack',289,1,0,0,30000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  106. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  107. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@AL_TELEPORT','walk',26,1,500,0,5000,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  108. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@KN_BRANDISHSPEAR','attack',57,10,2000,500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  109. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@MO_BODYRELOCATION','chase',264,1,200,200,1000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  110. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@NPC_ARMORBRAKE','attack',344,10,2000,0,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  111. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@NPC_DARKBREATH','attack',202,5,2000,800,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  112. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@NPC_DARKSTRIKE','chase',340,10,200,0,1000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  113. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@NPC_GUIDEDATTACK','attack',172,5,500,0,20000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  114. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@NPC_POWERUP','attack',349,5,10000,0,30000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,'6',NULL);
  115. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@WZ_VERMILION','attack',85,10,2000,500,2000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  116. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@WZ_VERMILION','chase',85,10,200,500,2000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  117. #REPLACE INTO `mob_skill_db2_re` VALUES (1902,'MC Cameri@WZ_VERMILION','chase',85,10,500,500,2000,'no','target','skillused','18',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  118. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@AC_DOUBLE','attack',46,10,500,1000,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  119. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@AC_SHOWER','attack',47,8,2000,1000,5000,'no','target','attackpcgt','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  120. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@BS_MAXIMIZE','chase',114,5,500,1000,5000,'no','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  121. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@BS_MAXIMIZE','attack',114,5,500,1000,5000,'no','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  122. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@NPC_AGIUP','chase',350,5,2500,0,5000,'no','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  123. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@NPC_POWERUP','attack',349,5,500,0,30000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  124. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@SN_SHARPSHOOTING','attack',382,5,500,1000,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  125. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@HT_SKIDTRAP','idle',115,5,50,0,5000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,'29',NULL);
  126. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@HT_FREEZINGTRAP','idle',120,5,50,0,300000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  127. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@HT_FREEZINGTRAP','idle',121,5,50,0,300000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  128. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@AC_CHARGEARROW','attack',148,1,500,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  129. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@HT_FLASHER','idle',120,5,50,0,300000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  130. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@NPC_SUMMONSLAVE','idle',196,5,10000,2000,120000,'no','self','slavele','1',1659,1660,1661,1662,1663,'0',NULL);
  131. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@NPC_CALLSLAVE','attack',352,1,2000,0,10000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  132. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@NPC_CALLSLAVE','idle',352,1,2000,0,10000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  133. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@NPC_CHANGEWATER','attack',162,1,10000,2000,600000,'no','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  134. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@NPC_CHANGETELEKINESIS','attack',169,1,500,2000,5000,'no','self','myhpltmaxrate','10',NULL,NULL,NULL,NULL,NULL,'7',NULL);
  135. #REPLACE INTO `mob_skill_db2_re` VALUES (1903,'Poki#3@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  136. # Easter Bunny (not in the db?? it's in db2!)
  137. #REPLACE INTO `mob_skill_db2_re` VALUES (1921,'Easter Bunny@NPC_SUMMONSLAVE','attack',196,5,10000,3000,10000,'no','self','slavele','2',1063,NULL,NULL,NULL,NULL,NULL,NULL);
  138. #REPLACE INTO `mob_skill_db2_re` VALUES (1921,'Easter Bunny@NPC_SUMMONSLAVE','idle',196,5,5000,2000,40000,'no','self','always','2',1920,NULL,NULL,NULL,NULL,NULL,NULL);
  139. #Custom Fire Poring. Warning, Colides with META_DENIRO
  140. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@AL_HEAL','idle',28,10,10000,0,2000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,'4',NULL);
  141. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@AL_HEAL','walk',28,10,10000,0,2000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,'4',NULL);
  142. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@AL_TELEPORT','attack',26,1,1000,5000,60000,'no','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  143. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  144. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@NPC_DARKBLESSING','attack',203,1,1000,2000,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'18',NULL);
  145. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@NPC_SUMMONSLAVE','attack',196,16,10000,2000,10000,'no','self','slavele','3',1491,1431,1433,NULL,NULL,'18',NULL);
  146. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@NPC_SUMMONSLAVE','idle',196,16,10000,2000,10000,'no','self','slavele','3',1491,1431,1433,NULL,NULL,'18',NULL);
  147. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@RG_INTIMIDATE','attack',219,5,1000,0,3000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  148. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@RG_STRIPARMOR','attack',217,5,2000,0,3000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  149. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@RG_STRIPHELM','attack',218,5,2000,0,3000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  150. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@RG_STRIPSHIELD','attack',216,5,2000,0,3000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  151. #REPLACE INTO `mob_skill_db2_re` VALUES (1239,'Fire Poring@RG_STRIPWEAPON','attack',215,5,2000,0,3000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  152. #iRO Halloween Event 2009
  153. #REPLACE INTO `mob_skill_db2_re` VALUES (3014,'Halloween Whisper@AS_CLOAKING','idle',135,1,2000,200,5000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  154. #REPLACE INTO `mob_skill_db2_re` VALUES (3014,'Halloween Whisper@AS_CLOAKING','chase',135,1,2000,200,5000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  155. #REPLACE INTO `mob_skill_db2_re` VALUES (3014,'Halloween Whisper@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  156. #REPLACE INTO `mob_skill_db2_re` VALUES (3014,'Halloween Whisper@NPC_EMOTION','chase',197,1,200,0,5000,'yes','self','always','0',19,0x81,NULL,NULL,NULL,NULL,NULL);
  157. # Here you can place your custom mob skills