diff options
Diffstat (limited to 'sql-files/mob_skill_db2.sql')
-rw-r--r-- | sql-files/mob_skill_db2.sql | 160 |
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 + |