summaryrefslogblamecommitdiff
path: root/sql-files/mob_skill_db2.sql
blob: cf270f8b39fcd3d73062196d0f8fa3bbf26977ba (plain) (tree)
1
2
3
4
5
6
7
8
9
10


                                            
 
                                     
                              



                                  
                                 













                                   

                
                             
   
                          
                                                                                                                                                                                                                                   































































































































                                                                                                                                                                              
 
--
-- 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