summaryrefslogtreecommitdiff
path: root/sql-files/mob_skill_db2.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/mob_skill_db2.sql')
-rw-r--r--sql-files/mob_skill_db2.sql160
1 files changed, 160 insertions, 0 deletions
diff --git a/sql-files/mob_skill_db2.sql b/sql-files/mob_skill_db2.sql
new file mode 100644
index 00000000..cf270f8b
--- /dev/null
+++ b/sql-files/mob_skill_db2.sql
@@ -0,0 +1,160 @@
+--
+-- Table structure for table `mob_skill_db2`
+--
+
+DROP TABLE IF EXISTS `mob_skill_db2`;
+CREATE TABLE `mob_skill_db2` (
+ `MOB_ID` SMALLINT(6) NOT NULL,
+ `INFO` TEXT NOT NULL,
+ `STATE` TEXT NOT NULL,
+ `SKILL_ID` SMALLINT(6) NOT NULL,
+ `SKILL_LV` TINYINT(4) NOT NULL,
+ `RATE` SMALLINT(4) NOT NULL,
+ `CASTTIME` MEDIUMINT(9) NOT NULL,
+ `DELAY` INT(9) NOT NULL,
+ `CANCELABLE` TEXT NOT NULL,
+ `TARGET` TEXT NOT NULL,
+ `CONDITION` TEXT NOT NULL,
+ `CONDITION_VALUE` TEXT,
+ `VAL1` MEDIUMINT(9) DEFAULT NULL,
+ `VAL2` MEDIUMINT(9) DEFAULT NULL,
+ `VAL3` MEDIUMINT(9) DEFAULT NULL,
+ `VAL4` MEDIUMINT(9) DEFAULT NULL,
+ `VAL5` MEDIUMINT(9) DEFAULT NULL,
+ `EMOTION` TEXT,
+ `CHAT` TEXT
+) ENGINE=MyISAM;
+
+-- Custom Mob Skill Database
+--
+-- Structure of Database:
+-- INSERT INTO `mob_skill_db2` (`MOB_ID`, `INFO`, `STATE`, `SKILL_ID`, `SKILL_LV`, `RATE`, `CASTTIME`, `DELAY`, `CANCELABLE`, `TARGET`, `CONDITION`, `CONDITION_VALUE`, `VAL1`, `VAL2`, `VAL3`, `VAL4`, `VAL5`, `EMOTION`, `CHAT`);
+--
+-- RATE: the chance of the skill being casted when the condition is fulfilled (10000 = 100%).
+-- DELAY: the time (in milliseconds) before attempting to recast the same skill.
+--
+-- STATE:
+-- any (except dead) / idle (in standby) / walk (in movement) / dead (on killed) /
+-- loot /attack / angry (like attack, except player has not attacked mob yet) /
+-- chase (following target, after being attacked) / follow (following target,
+-- without being attacked) / anytarget (attack+angry+chase+follow)
+--
+-- TARGET:
+-- target (current target) / self / friend / master / randomtarget (any enemy within skill's range)
+--
+-- The following are for ground-skills, a random target tile is selected from the specified area:
+-- around1 (3x3 area around self) / around2 (5x5 area around self) /
+-- around3 (7x7 area around self) / around4 (9x9 area around self) /
+-- around5 (3x3 area around target) / around6 (5x5 area around target) /
+-- around7 (7x7 area around target) / around8 (9x9 area around target) /
+-- around = around4
+--
+-- CONDITION:
+-- always Unconditional (no condition value).
+-- onspawn When mob spawns/respawns (no condition value).
+-- myhpltmaxrate When mob's HP drops to the specified %.
+-- myhpinrate When mob's HP is in a certain % range (condition value = lower bound, val1 = upper bound).
+-- mystatuson If mob has the specified abnormality in status.
+-- mystatusoff If mob has ended the specified abnormality in status.
+-- friendhpltmaxrate When mob's friend's HP drops to the specified %.
+-- friendhpinrate When mob's friend's HP is in a certain % range (condition value = lower bound, val1 = upper bound).
+-- friendstatuson If friend has the specified abnormality in status.
+-- friendstatusoff If friend has ended the specified abnormality in status.
+-- attackpcgt When attack PCs become greater than specified number.
+-- attackpcge When attack PCs become greater than or equal to the specified number.
+-- slavelt When number of slaves is less than the original specified number.
+-- slavele When number of slaves is less than or equal to the original specified number.
+-- closedattacked When close range melee attacked (no condition value).
+-- longrangeattacked When long range attacked, ex. bows, guns, ranged skills (no condition value).
+-- skillused When the specified skill is used on the mob.
+-- afterskill After mob casts the specified skill.
+-- casttargeted When a target is in cast range (no condition value).
+-- rudeattacked When mob is rude attacked (no condition value).
+--
+-- Status abnormalities specified through the statuson/statusoff system:
+-- anybad (any type of state change) / stone / freeze / stun / sleep /
+-- poison / curse / silence / confusion / blind / hiding / sight (unhidden)
+--
+-- Note: if a negative MobID is provided, the skill will be treated as 'global':
+-- -1: added for all boss types.
+-- -2: added for all normal types.
+-- -4: added for all mobs.
+-- rAthena Dev Team
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@AL_TELEPORT','walk',26,1,500,0,5000,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@KN_BRANDISHSPEAR','attack',57,10,2000,500,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@MO_BODYRELOCATION','chase',264,1,200,200,1000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@NPC_ARMORBRAKE','attack',344,10,2000,0,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@NPC_CALLSLAVE','attack',352,1,10000,0,30000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@NPC_CALLSLAVE','idle',352,1,10000,0,30000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@NPC_DARKBREATH','attack',202,5,2000,800,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@NPC_DARKSTRIKE','chase',340,10,200,0,1000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@NPC_GUIDEDATTACK','attack',172,5,500,0,20000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@NPC_POWERUP','attack',349,5,10000,0,30000,'yes','self','myhpltmaxrate',30,NULL,NULL,NULL,NULL,NULL,6,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@NPC_SUMMONSLAVE','attack',196,6,10000,700,10000,'no','self','slavele',3,1902,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@NPC_SUMMONSLAVE','idle',196,6,10000,700,10000,'no','self','slavele',3,1902,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@WZ_VERMILION','attack',85,10,2000,500,2000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@WZ_VERMILION','chase',85,10,200,500,2000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1900,'Valaris@WZ_VERMILION','chase',85,10,500,500,2000,'no','target','skillused',18,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1901,'Valaris\'s Worshipper@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1901,'Valaris\'s Worshipper@NPC_CURSEATTACK','attack',181,3,500,800,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1901,'Valaris\'s Worshipper@NPC_DARKNESSATTACK','attack',190,2,500,500,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,6,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1901,'Valaris\'s Worshipper@NPC_EMOTION','chase',197,1,20,0,5000,'yes','self','always',0,19,129,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1901,'Valaris\'s Worshipper@NPC_EMOTION','idle',197,1,200,0,5000,'yes','self','always',0,6,1173,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1901,'Valaris\'s Worshipper@NPC_EMOTION','walk',197,1,200,0,5000,'yes','self','always',0,2,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1901,'Valaris\'s Worshipper@NPC_HALLUCINATION','attack',207,1,500,500,5000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1901,'Valaris\'s Worshipper@NPC_HALLUCINATION','chase',207,1,50,500,5000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1901,'Valaris\'s Worshipper@SA_DISPELL','attack',289,1,0,0,30000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@AL_TELEPORT','walk',26,1,500,0,5000,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@KN_BRANDISHSPEAR','attack',57,10,2000,500,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@MO_BODYRELOCATION','chase',264,1,200,200,1000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@NPC_ARMORBRAKE','attack',344,10,2000,0,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@NPC_DARKBREATH','attack',202,5,2000,800,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@NPC_DARKSTRIKE','chase',340,10,200,0,1000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@NPC_GUIDEDATTACK','attack',172,5,500,0,20000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@NPC_POWERUP','attack',349,5,10000,0,30000,'yes','self','myhpltmaxrate',30,NULL,NULL,NULL,NULL,NULL,6,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@WZ_VERMILION','attack',85,10,2000,500,2000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@WZ_VERMILION','chase',85,10,200,500,2000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1902,'MC Cameri@WZ_VERMILION','chase',85,10,500,500,2000,'no','target','skillused',18,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@AC_DOUBLE','attack',46,10,500,1000,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@AC_SHOWER','attack',47,8,2000,1000,5000,'no','target','attackpcgt',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@BS_MAXIMIZE','chase',114,5,500,1000,5000,'no','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@BS_MAXIMIZE','attack',114,5,500,1000,5000,'no','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@NPC_AGIUP','chase',350,5,2500,0,5000,'no','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@NPC_POWERUP','attack',349,5,500,0,30000,'yes','self','myhpltmaxrate',30,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@SN_SHARPSHOOTING','attack',382,5,500,1000,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@HT_SKIDTRAP','idle',115,5,50,0,5000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,29,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@HT_FREEZINGTRAP','idle',120,5,50,0,300000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@HT_FREEZINGTRAP','idle',121,5,50,0,300000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@AC_CHARGEARROW','attack',148,1,500,0,5000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@HT_FLASHER','idle',120,5,50,0,300000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@NPC_SUMMONSLAVE','idle',196,5,10000,2000,120000,'no','self','slavele',1,1659,1660,1661,1662,1663,0,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@NPC_CALLSLAVE','attack',352,1,2000,0,10000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@NPC_CALLSLAVE','idle',352,1,2000,0,10000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@NPC_CHANGEWATER','attack',162,1,10000,2000,600000,'no','self','myhpltmaxrate',30,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@NPC_CHANGETELEKINESIS','attack',169,1,500,2000,5000,'no','self','myhpltmaxrate',10,NULL,NULL,NULL,NULL,NULL,7,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1903,'Poki#3@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- Easter Bunny (not in the db?? it's in db2!)
+-- REPLACE INTO `mob_skill_db` VALUES (1921,'Easter Bunny@NPC_SUMMONSLAVE','attack',196,5,10000,3000,10000,'no','self','slavele',2,1063,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1921,'Easter Bunny@NPC_SUMMONSLAVE','idle',196,5,5000,2000,40000,'no','self','always',2,1920,NULL,NULL,NULL,NULL,NULL,NULL);
+-- Custom Fire Poring. Warning, Colides with META_DENIRO
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@AL_HEAL','idle',28,10,10000,0,2000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,4,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@AL_HEAL','walk',28,10,10000,0,2000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,4,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@AL_TELEPORT','attack',26,1,1000,5000,60000,'no','self','myhpltmaxrate',30,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@NPC_DARKBLESSING','attack',203,1,1000,2000,5000,'no','target','always',0,NULL,NULL,NULL,NULL,NULL,18,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@NPC_SUMMONSLAVE','attack',196,16,10000,2000,10000,'no','self','slavele',3,1491,1431,1433,NULL,NULL,18,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@NPC_SUMMONSLAVE','idle',196,16,10000,2000,10000,'no','self','slavele',3,1491,1431,1433,NULL,NULL,18,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@RG_INTIMIDATE','attack',219,5,1000,0,3000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@RG_STRIPARMOR','attack',217,5,2000,0,3000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@RG_STRIPHELM','attack',218,5,2000,0,3000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@RG_STRIPSHIELD','attack',216,5,2000,0,3000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (1239,'Fire Poring@RG_STRIPWEAPON','attack',215,5,2000,0,3000,'yes','target','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- iRO Halloween Event 2009
+-- REPLACE INTO `mob_skill_db` VALUES (3014,'Halloween Whisper@AS_CLOAKING','idle',135,1,2000,200,5000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (3014,'Halloween Whisper@AS_CLOAKING','chase',135,1,2000,200,5000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (3014,'Halloween Whisper@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+-- REPLACE INTO `mob_skill_db` VALUES (3014,'Halloween Whisper@NPC_EMOTION','chase',197,1,200,0,5000,'yes','self','always',0,19,0x81,NULL,NULL,NULL,NULL,NULL);
+-- Here you can place your custom mob skills
+
generated by cgit v1.2.3-60-g2f50 (git 2.42.0) at 2024-07-29 21:51:08 +0000