diff options
author | Andrei Karas <akaras@inbox.ru> | 2016-02-05 00:19:58 +0300 |
---|---|---|
committer | Andrei Karas <akaras@inbox.ru> | 2016-02-05 00:19:58 +0300 |
commit | 88a6bbe81cdac8392af63d9732b582fa02b04261 (patch) | |
tree | b3ff5d684c24990a1540bee398b59656c066089c /sql-files/mob_skill_db2.sql | |
parent | a59d2cf735c961d86050ae51d345a5a81cfeb77c (diff) | |
parent | dcc9ee43a4b33ace1501864415f5a856b18f8201 (diff) | |
download | hercules-88a6bbe81cdac8392af63d9732b582fa02b04261.tar.gz hercules-88a6bbe81cdac8392af63d9732b582fa02b04261.tar.bz2 hercules-88a6bbe81cdac8392af63d9732b582fa02b04261.tar.xz hercules-88a6bbe81cdac8392af63d9732b582fa02b04261.zip |
Merge pull request #993 from HerculesWS/mobdb2sql
Mob DB support for the db2sql plugin
Diffstat (limited to 'sql-files/mob_skill_db2.sql')
-rw-r--r-- | sql-files/mob_skill_db2.sql | 136 |
1 files changed, 1 insertions, 135 deletions
diff --git a/sql-files/mob_skill_db2.sql b/sql-files/mob_skill_db2.sql index cf270f8b3..c3e48d47b 100644 --- a/sql-files/mob_skill_db2.sql +++ b/sql-files/mob_skill_db2.sql @@ -3,7 +3,7 @@ -- DROP TABLE IF EXISTS `mob_skill_db2`; -CREATE TABLE `mob_skill_db2` ( +CREATE TABLE IF NOT EXISTS `mob_skill_db2` ( `MOB_ID` SMALLINT(6) NOT NULL, `INFO` TEXT NOT NULL, `STATE` TEXT NOT NULL, @@ -24,137 +24,3 @@ CREATE TABLE `mob_skill_db2` ( `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 - |