diff options
Diffstat (limited to 'sql-files')
-rw-r--r-- | sql-files/item_db.sql | 2 | ||||
-rw-r--r-- | sql-files/item_db_re.sql | 2 | ||||
-rw-r--r-- | sql-files/logs.sql | 2 | ||||
-rw-r--r-- | sql-files/main.sql | 1 | ||||
-rw-r--r-- | sql-files/mob_skill_db.sql | 18 | ||||
-rw-r--r-- | sql-files/mob_skill_db_re.sql | 102 | ||||
-rw-r--r-- | sql-files/upgrades/2016-03-10--22-18.sql | 22 | ||||
-rw-r--r-- | sql-files/upgrades/index.txt | 1 | ||||
-rw-r--r-- | sql-files/upgrades/rAthena-logs-upgrade.sql | 2 |
9 files changed, 88 insertions, 64 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index 4d5649b67..f7abfd9db 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -2532,7 +2532,7 @@ REPLACE INTO `item_db` VALUES ('5361','Gang_Scarf','Gangster Scarf','5','20','10 REPLACE INTO `item_db` VALUES ('5362','Ninja_Scroll','Ninja Scroll','5','20','10','200','0','0','0','0','0','0xFFFFFFFFFFFFFFFF','63','2','1','0','60',NULL,'0','370','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','bonus bMatkRate,1;','',''); REPLACE INTO `item_db` VALUES ('5363','Helm_Of_Abyss','Helm Of Abyss','5','20','10','1000','0','0','2','0','1','0x654E2','63','2','256','0','70',NULL,'1','371','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubRace,RC_DemiPlayer,-10; bonus2 bSubRace,RC_Boss,10;','',''); REPLACE INTO `item_db` VALUES ('5364','Dark_Snake_Lord_Hat','Evil Snake Lord Hat','5','20','10','500','0','0','2','0','1','0xFFFFFFFFFFFFFFFF','63','2','256','0','60',NULL,'1','372','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bInt,1; bonus bAgi,2;','',''); -REPLACE INTO `item_db` VALUES ('5365','Fried_Egg','Magnolia Hat','5','20','10','100','0','0','3','0','1','0xFFFFFFFFFFFFFFFF','63','2','256','0','1',NULL,'0','373','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bResEff,Eff_Stun,500; skill HT_FLASHER,1;','',''); +REPLACE INTO `item_db` VALUES ('5365','Fried_Egg','Magnolia Hat','5','20','10','100','0','0','3','0','1','0xFFFFFFFFFFFFFFFF','63','2','256','0','1',NULL,'0','373','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk, 5; bonus5 bAutoSpellWhenHit, BS_GREED, 1, 10, BF_SHORT, 0;','',''); REPLACE INTO `item_db` VALUES ('5366','Hat_0f_King','Love Dad Bandana','5','20','10','200','0','0','3','0','0','0xFFFFFFFFFFFFFFFF','63','2','256','0','0',NULL,'1','374','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,5;','',''); REPLACE INTO `item_db` VALUES ('5367','Hyegun_Hat','Hyegun Hat','5','20','10','100','0','0','5','0','1','0xFFFFFFFFFFFFFFFF','63','2','769','0','10',NULL,'0','375','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus2 bSubRace,RC_Demon,10;','',''); REPLACE INTO `item_db` VALUES ('5368','White_Wing','White Wing','5','20','10','100','0','0','2','0','0','0xFFFFFFFFFFFFFFFF','63','2','256','0','0',NULL,'1','38','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddMonsterDropItem,12280,300;','',''); diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index bcd6e4d71..7d0f42257 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -3435,7 +3435,7 @@ REPLACE INTO `item_db` VALUES ('5361','Gang_Scarf','Gangster Scarf','5','20','10 REPLACE INTO `item_db` VALUES ('5362','Ninja_Scroll','Ninja Scroll','5','20','10','200','0','0','0','0','0','0xFFFFFFFFFFFFFFFF','63','2','1','0','0',NULL,'0','370','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableHelm,0; bonus bMatkRate,1;','',''); REPLACE INTO `item_db` VALUES ('5363','Helm_Of_Abyss','Abysmal Knight Helm','5','20','10','1000','0','0','9','0','1','0x654E2','63','2','256','0','70',NULL,'1','371','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubRace,RC_DemiPlayer,-10; bonus2 bSubRace,RC_Boss,10;','',''); REPLACE INTO `item_db` VALUES ('5364','Dark_Snake_Lord_Hat','Evil Snake Lord Hat','5','20','10','500','0','0','4','0','1','0xFFFFFFFFFFFFFFFF','63','2','256','0','150',NULL,'1','372','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bInt,1; bonus bAgi,2; bonus2 bAddMonsterDropItem,12582,30;','',''); -REPLACE INTO `item_db` VALUES ('5365','Fried_Egg','Mangolia Hat','5','20','10','100','0','0','2','0','1','0xFFFFFFFFFFFFFFFF','63','2','256','0','0',NULL,'0','373','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bResEff,Eff_Stun,500; skill HT_FLASHER,1;','',''); +REPLACE INTO `item_db` VALUES ('5365','Fried_Egg','Mangolia Hat','5','20','10','100','0','0','2','0','1','0xFFFFFFFFFFFFFFFF','63','2','256','0','0',NULL,'0','373','0','0','0','0','1',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk, 5; bonus5 bAutoSpellWhenHit, BS_GREED, 1, 10, BF_SHORT, 0;','',''); REPLACE INTO `item_db` VALUES ('5366','Hat_0f_King','Love Dad Bandana','5','20','10','200','0','0','5','0','0','0xFFFFFFFFFFFFFFFF','63','2','256','0','0',NULL,'1','374','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,5;','',''); REPLACE INTO `item_db` VALUES ('5367','Hyegun_Hat','Yao Jun Hat','5','20','10','100','0','0','5','0','1','0xFFFFFFFFFFFFFFFF','63','2','769','0','10',NULL,'0','375','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus2 bAddRaceTolerance,RC_Demon,10;','',''); REPLACE INTO `item_db` VALUES ('5368','White_Wing','White Wing','5','20','10','100','0','0','4','0','0','0xFFFFFFFFFFFFFFFF','63','2','256','0','0',NULL,'1','38','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddMonsterDropItem,12280,300;','',''); diff --git a/sql-files/logs.sql b/sql-files/logs.sql index 0c97fdecf..ab722a2fe 100644 --- a/sql-files/logs.sql +++ b/sql-files/logs.sql @@ -144,7 +144,7 @@ CREATE TABLE IF NOT EXISTS `picklog` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `char_id` INT(11) NOT NULL DEFAULT '0', - `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U') NOT NULL DEFAULT 'P', + `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','K','Y','Z','W','Q','J','H','@','0','1','2') NOT NULL DEFAULT 'P', `nameid` INT(11) NOT NULL DEFAULT '0', `amount` INT(11) NOT NULL DEFAULT '1', `refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', diff --git a/sql-files/main.sql b/sql-files/main.sql index 1ed751d15..e2717cdc5 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -824,6 +824,7 @@ INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1436360978); -- 2015-07-0 INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1440688342); -- 2015-08-27--20-42.sql INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1450241859); -- 2015-12-16--12-57.sql INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1450367880); -- 2015-12-17--15-58.sql +INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1457638175); -- 2016-03-10--22-18.sql -- -- Table structure for table `storage` diff --git a/sql-files/mob_skill_db.sql b/sql-files/mob_skill_db.sql index 6cf4860f7..7d27cfb87 100644 --- a/sql-files/mob_skill_db.sql +++ b/sql-files/mob_skill_db.sql @@ -315,7 +315,7 @@ REPLACE INTO `mob_skill_db` VALUES (1069,'Swordfish@WZ_WATERBALL','chase',86,3,5 REPLACE INTO `mob_skill_db` VALUES (1069,'Swordfish@NPC_WATERATTACK','angry',184,1,2000,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1069,'Swordfish@WZ_WATERBALL','angry',86,3,500,1500,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1069,'Swordfish@WZ_WATERBALL','follow',86,3,500,1500,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1070,'Kukre@NPC_EMOTION','loot',197,1,2000,0,5000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1070,'Kukre@NPC_EMOTION','loot',197,1,2000,0,5000,'yes','self','always','0',0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1070,'Kukre@NPC_WATERATTACK','attack',184,1,2000,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1071,'Pirate Skeleton@SM_BASH','attack',5,5,500,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,'27',NULL); REPLACE INTO `mob_skill_db` VALUES (1071,'Pirate Skeleton@SM_BASH','angry',5,5,500,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,'27',NULL); @@ -829,7 +829,7 @@ REPLACE INTO `mob_skill_db` VALUES (1161,'Plankton@NPC_WATERATTACK','attack',184 REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@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 (1163,'Raydric@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 (1163,'Raydric@NPC_DARKNESSATTACK','attack',190,3,500,500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL); -REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always','0',0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@SM_MAGNUM','attack',7,9,500,500,5000,'no','self','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@CR_AUTOGUARD','chase',249,2,2000,0,300000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@CR_AUTOGUARD','attack',249,2,500,0,300000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -1125,7 +1125,7 @@ REPLACE INTO `mob_skill_db` VALUES (1254,'Raggler@NPC_EMOTION','idle',197,1,2000 REPLACE INTO `mob_skill_db` VALUES (1254,'Raggler@NPC_WINDATTACK','attack',187,1,2000,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1255,'Neraid@NPC_GROUNDATTACK','attack',185,3,500,500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1255,'Neraid@NPC_EMOTION','chase',197,1,200,0,5000,'yes','self','always','0',19,0x81,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1255,'Neraid@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',NULL,0x3695,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1255,'Neraid@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',0,0x3695,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1256,'Pest@AS_CLOAKING','attack',135,1,2000,200,5000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1256,'Pest@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 (1256,'Pest@AS_CLOAKING','chase',135,1,2000,200,5000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -3272,33 +3272,33 @@ REPLACE INTO `mob_skill_db` VALUES (1675,'Venatu@NPC_GUIDEDATTACK','attack',172, REPLACE INTO `mob_skill_db` VALUES (1675,'Venatu@NPC_STUNATTACK','attack',179,2,500,1500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'11',NULL); REPLACE INTO `mob_skill_db` VALUES (1675,'Venatu@NPC_FIREATTACK','attack',186,3,500,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1675,'Venatu@NPC_EMOTION','chase',197,1,100,0,5000,'yes','self','always','0',7,0x81,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1675,'Venatu@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',NULL,0x3095,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1675,'Venatu@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',0,0x3095,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1676,'Venatu@NPC_SLEEPATTACK','attack',182,3,500,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1676,'Venatu@NPC_GUIDEDATTACK','attack',172,3,500,1000,20000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1676,'Venatu@NPC_STUNATTACK','attack',179,2,500,1500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'11',NULL); REPLACE INTO `mob_skill_db` VALUES (1676,'Venatu@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 (1676,'Venatu@NPC_EMOTION','chase',197,1,100,0,5000,'yes','self','always','0',7,0x81,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1676,'Venatu@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',NULL,0x3095,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1676,'Venatu@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',0,0x3095,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1677,'Venatu@NPC_BLINDATTACK','attack',177,3,500,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1677,'Venatu@NPC_GUIDEDATTACK','attack',172,3,500,1000,20000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1677,'Venatu@NPC_STUNATTACK','attack',179,2,500,1500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'11',NULL); REPLACE INTO `mob_skill_db` VALUES (1677,'Venatu@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 (1677,'Venatu@NPC_WINDATTACK','attack',187,3,500,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1677,'Venatu@NPC_EMOTION','chase',197,1,100,0,5000,'yes','self','always','0',7,0x81,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1677,'Venatu@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',NULL,0x3095,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1677,'Venatu@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',0,0x3095,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1678,'Venatu@NPC_RANDOMATTACK','attack',183,3,500,500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1678,'Venatu@NPC_GUIDEDATTACK','attack',172,3,500,1000,20000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1678,'Venatu@NPC_STUNATTACK','attack',179,2,500,1500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'11',NULL); REPLACE INTO `mob_skill_db` VALUES (1678,'Venatu@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 (1678,'Venatu@NPC_GROUNDATTACK','attack',185,3,500,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1678,'Venatu@NPC_EMOTION','chase',197,1,100,0,5000,'yes','self','always','0',7,0x81,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1678,'Venatu@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',NULL,0x3095,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1678,'Venatu@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',0,0x3095,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1679,'Venatu@NPC_GUIDEDATTACK','attack',172,3,500,1000,20000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1679,'Venatu@NPC_STUNATTACK','attack',179,2,500,1500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'11',NULL); REPLACE INTO `mob_skill_db` VALUES (1679,'Venatu@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 (1679,'Venatu@NPC_WATERATTACK','attack',184,3,500,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1679,'Venatu@NPC_EMOTION','chase',197,1,100,0,5000,'yes','self','always','0',7,0x81,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1679,'Venatu@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',NULL,0x3095,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1679,'Venatu@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always','0',0,0x3095,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1680,'Hill Wind@NPC_WINDATTACK','chase',187,3,500,500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1680,'Hill Wind@NPC_WINDATTACK','attack',187,3,500,500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1680,'Hill Wind@MG_THUNDERSTORM','attack',21,5,2000,1500,5000,'no','target','attackpcge','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -5093,7 +5093,7 @@ REPLACE INTO `mob_skill_db` VALUES (1979,'Zukadam@NPC_SUMMONSLAVE','idle',196,2, REPLACE INTO `mob_skill_db` VALUES (1981,'Safeguard Chief@SM_BASH','attack',5,10,500,1000,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1981,'Safeguard Chief@SM_BASH','chase',5,10,500,1000,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1981,'Safeguard Chief@NPC_DARKNESSATTACK','attack',190,3,500,500,5000,'no','target','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL); -REPLACE INTO `mob_skill_db` VALUES (1981,'Safeguard Chief@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1981,'Safeguard Chief@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always','0',0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1981,'Safeguard Chief@SM_MAGNUM','attack',7,7,500,500,5000,'no','self','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1981,'Safeguard Chief@CR_AUTOGUARD','chase',249,5,500,0,300000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1981,'Safeguard Chief@NPC_PULSESTRIKE','chase',661,2,2000,0,10000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); diff --git a/sql-files/mob_skill_db_re.sql b/sql-files/mob_skill_db_re.sql index ab29139f3..9d60c4e2b 100644 --- a/sql-files/mob_skill_db_re.sql +++ b/sql-files/mob_skill_db_re.sql @@ -322,7 +322,7 @@ REPLACE INTO `mob_skill_db` VALUES (1069,'Swordfish@WZ_WATERBALL','angry',86,3,5 REPLACE INTO `mob_skill_db` VALUES (1069,'Swordfish@WZ_WATERBALL','attack',86,3,500,1500,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1069,'Swordfish@WZ_WATERBALL','follow',86,3,500,1500,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1069,'Swordfish@WZ_WATERBALL','chase',86,3,500,1500,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1070,'Kukre@NPC_EMOTION','loot',197,1,2000,0,5000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1070,'Kukre@NPC_EMOTION','loot',197,1,2000,0,5000,'yes','self','always',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1070,'Kukre@NPC_WATERATTACK','attack',184,2,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1071,'Pirate Skeleton@NPC_BLEEDING','attack',660,1,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'32',NULL); REPLACE INTO `mob_skill_db` VALUES (1071,'Pirate Skeleton@NPC_UNDEADATTACK','attack',347,1,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -849,7 +849,7 @@ REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@BS_MAXIMIZE','chase',114,5,500 REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@CR_AUTOGUARD','attack',249,2,500,0,300000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@CR_AUTOGUARD','chase',249,2,2000,0,300000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@NPC_DARKNESSATTACK','attack',190,3,500,500,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); -REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1163,'Raydric@SM_MAGNUM','attack',7,9,500,500,5000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1164,'Requiem@NPC_DARKNESSATTACK','attack',190,2,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1164,'Requiem@NPC_EMOTION','walk',197,1,200,0,5000,'yes','self','always',NULL,19,NULL,NULL,NULL,NULL,NULL,NULL); @@ -1160,7 +1160,7 @@ REPLACE INTO `mob_skill_db` VALUES (1254,'Raggler@NPC_EMOTION','idle',197,1,2000 REPLACE INTO `mob_skill_db` VALUES (1254,'Raggler@NPC_WINDATTACK','attack',187,3,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1255,'Nereid@NPC_BLOODDRAIN','attack',199,1,500,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL); REPLACE INTO `mob_skill_db` VALUES (1255,'Nereid@NPC_EMOTION','chase',197,1,200,0,5000,'yes','self','always',NULL,19,0x0081,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1255,'Nereid@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always',NULL,NULL,0x3695,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1255,'Nereid@NPC_EMOTION','idle',197,1,2000,0,5000,'yes','self','always',NULL,0,0x3695,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1255,'Nereid@NPC_GROUNDATTACK','attack',185,3,500,500,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1256,'Pest@AS_CLOAKING','attack',135,1,2000,200,5000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1256,'Pest@AS_CLOAKING','idle',135,1,2000,200,5000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -2458,7 +2458,7 @@ REPLACE INTO `mob_skill_db` VALUES (1505,'Loli Ruri@AL_TELEPORT','walk',26,1,500 REPLACE INTO `mob_skill_db` VALUES (1505,'Loli Ruri@NPC_DARKSTRIKE','chase',340,5,500,700,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1505,'Loli Ruri@NPC_DARKSTRIKE','attack',340,5,500,700,5000,'no','target','myhpltmaxrate','50',NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (1505,'Loli Ruri@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,3,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1505,'Loli Ruri@NPC_SUMMONSLAVE','idle',196,1,500,2000,60000,'no','self','slavele','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1505,'Loli Ruri@NPC_SUMMONSLAVE','idle',196,1,500,2000,60000,'no','self','slavele','0',0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1505,'Loli Ruri@PR_LEXDIVINA','attack',76,10,500,1000,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL); REPLACE INTO `mob_skill_db` VALUES (1505,'Loli Ruri@PR_LEXDIVINA','chase',76,10,500,1000,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL); REPLACE INTO `mob_skill_db` VALUES (1505,'Loli Ruri@SA_REVERSEORCISH','attack',294,1,50,0,30000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'18',NULL); @@ -2491,16 +2491,16 @@ REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_BLOODDRAIN','idle',199,1,2 REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_BLOODDRAIN','idle',199,1,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'29',NULL); REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_CRITICALWOUND','attack',673,2,500,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_DARKBLESSING','attack',203,1,5000,0,2000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','attack',209,5,5000,0,10000,'yes','self','casttargeted',NULL,NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','casttargeted',NULL,NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','attack',209,5,5000,0,10000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','28',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','18',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','21',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','79',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','83',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','89',NULL,NULL,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','longrangeattacked','0',1474,1477,1438,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','casttargeted','0',1474,1477,1438,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','attack',209,5,5000,0,10000,'no','self','longrangeattacked','0',1474,1477,1438,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','attack',209,5,5000,0,10000,'no','self','casttargeted','0',1474,1477,1438,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','18',1474,1477,1438,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','89',1474,1477,1438,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','21',1474,1477,1438,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','28',1474,1477,1438,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','79',1474,1477,1438,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','83',1474,1477,1438,NULL,NULL,'9',NULL); REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@WZ_FIREPILLAR','attack',80,10,5000,0,2000,'yes','around2','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@WZ_FIREPILLAR','idle',80,10,10000,0,2000,'yes','around2','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1511,'Amon Ra@WZ_FIREPILLAR','idle',80,10,10000,0,2000,'yes','around2','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -2538,9 +2538,9 @@ REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@HP_ASSUMPTIO','idle',361,5, REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@HP_ASSUMPTIO','chase',361,5,10000,500,100000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@NPC_INVISIBLE','chase',353,1,2000,1000,30000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,'29',NULL); REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@NPC_STOP','attack',342,1,2000,500,15000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); -REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@NPC_SUMMONSLAVE','attack',196,1,10000,0,5000,'yes','self','slavele','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@NPC_SUMMONSLAVE','idle',196,1,10000,0,5000,'yes','self','slavele','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@NPC_SUMMONSLAVE','chase',196,1,10000,0,5000,'yes','self','slavele','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@NPC_SUMMONSLAVE','attack',196,1,10000,0,5000,'yes','self','slavele','1',0,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@NPC_SUMMONSLAVE','idle',196,1,10000,0,5000,'yes','self','slavele','1',0,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@NPC_SUMMONSLAVE','chase',196,1,10000,0,5000,'yes','self','slavele','1',0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@NPC_WIDESLEEP','chase',668,5,10000,700,25000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@NPC_WIDESLEEP','attack',668,5,10000,700,25000,'yes','self','myhpltmaxrate','80',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1518,'White Lady@PR_SANCTUARY','attack',70,10,2000,0,10000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,'18',NULL); @@ -2991,7 +2991,7 @@ REPLACE INTO `mob_skill_db` VALUES (1646,'Lord Knight Seyren@NPC_FIREATTACK','at REPLACE INTO `mob_skill_db` VALUES (1646,'Lord Knight Seyren@NPC_POWERUP','attack',349,5,2000,0,100000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1646,'Lord Knight Seyren@NPC_POWERUP','attack',349,5,2000,0,25000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1646,'Lord Knight Seyren@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1646,'Lord Knight Seyren@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1646,'Lord Knight Seyren@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',1641,1642,1643,1644,1645,'0',NULL); REPLACE INTO `mob_skill_db` VALUES (1646,'Lord Knight Seyren@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',1641,1642,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1646,'Lord Knight Seyren@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',1641,1642,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1646,'Lord Knight Seyren@SM_BASH','attack',5,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -3024,7 +3024,7 @@ REPLACE INTO `mob_skill_db` VALUES (1647,'Assassin Cross Eremes@NPC_INVISIBLE',' REPLACE INTO `mob_skill_db` VALUES (1647,'Assassin Cross Eremes@NPC_INVISIBLE','idle',353,1,2000,0,30000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1647,'Assassin Cross Eremes@NPC_POISONATTACK','attack',188,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1647,'Assassin Cross Eremes@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1647,'Assassin Cross Eremes@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1647,'Assassin Cross Eremes@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',1640,1642,1643,1644,1645,'0',NULL); REPLACE INTO `mob_skill_db` VALUES (1647,'Assassin Cross Eremes@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',1640,1642,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1647,'Assassin Cross Eremes@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',1640,1642,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1647,'Assassin Cross Eremes@TF_POISON','attack',52,10,1000,0,10000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -3048,7 +3048,7 @@ REPLACE INTO `mob_skill_db` VALUES (1648,'MasterSmith Howard@NPC_POWERUP','attac REPLACE INTO `mob_skill_db` VALUES (1648,'MasterSmith Howard@NPC_POWERUP','attack',349,5,2000,0,25000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1648,'MasterSmith Howard@NPC_SHIELDBRAKE','attack',346,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'19',NULL); REPLACE INTO `mob_skill_db` VALUES (1648,'MasterSmith Howard@NPC_SPLASHATTACK','attack',174,1,1000,0,0,'yes','target','attackpcge','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1648,'MasterSmith Howard@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1648,'MasterSmith Howard@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',1640,1641,1643,1644,1645,'0',NULL); REPLACE INTO `mob_skill_db` VALUES (1648,'MasterSmith Howard@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',1640,1641,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1648,'MasterSmith Howard@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',1640,1641,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1648,'MasterSmith Howard@NPC_WATERATTACK','attack',184,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -3082,7 +3082,7 @@ REPLACE INTO `mob_skill_db` VALUES (1649,'High Priest Margaretha@NPC_CHANGEWATER REPLACE INTO `mob_skill_db` VALUES (1649,'High Priest Margaretha@NPC_CRITICALSLASH','attack',170,1,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1649,'High Priest Margaretha@NPC_HOLYATTACK','attack',189,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1649,'High Priest Margaretha@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1649,'High Priest Margaretha@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1649,'High Priest Margaretha@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',1640,1641,1642,1644,1645,'0',NULL); REPLACE INTO `mob_skill_db` VALUES (1649,'High Priest Margaretha@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',1640,1641,1642,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1649,'High Priest Margaretha@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',1640,1641,1642,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1649,'High Priest Margaretha@PR_LEXAETERNA','attack',78,1,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'29',NULL); @@ -3114,7 +3114,7 @@ REPLACE INTO `mob_skill_db` VALUES (1650,'Sniper Cecil@NPC_CRITICALSLASH','attac REPLACE INTO `mob_skill_db` VALUES (1650,'Sniper Cecil@NPC_POWERUP','attack',349,5,2000,0,100000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1650,'Sniper Cecil@NPC_POWERUP','attack',349,5,2000,0,25000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1650,'Sniper Cecil@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (1650,'Sniper Cecil@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1650,'Sniper Cecil@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',1640,1641,1642,1643,1645,'0',NULL); REPLACE INTO `mob_skill_db` VALUES (1650,'Sniper Cecil@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',1640,1641,1642,1643,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1650,'Sniper Cecil@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',1640,1641,1642,1643,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1650,'Sniper Cecil@NPC_WINDATTACK','attack',187,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -3130,7 +3130,7 @@ REPLACE INTO `mob_skill_db` VALUES (1651,'High Wizard Kathryne@NPC_CALLSLAVE','a REPLACE INTO `mob_skill_db` VALUES (1651,'High Wizard Kathryne@NPC_CALLSLAVE','idle',352,1,10000,0,10000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1651,'High Wizard Kathryne@NPC_CHANGEHOLY','attack',167,1,10000,500,6000000,'no','self','myhpltmaxrate','40',NULL,NULL,NULL,NULL,NULL,'9',NULL); REPLACE INTO `mob_skill_db` VALUES (1651,'High Wizard Kathryne@NPC_CHANGETELEKINESIS','attack',169,1,10000,500,6000000,'no','self','myhpltmaxrate','10',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (1651,'High Wizard Kathryne@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1651,'High Wizard Kathryne@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',1640,1641,1642,1643,1644,'0',NULL); REPLACE INTO `mob_skill_db` VALUES (1651,'High Wizard Kathryne@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',1640,1641,1642,1643,1644,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1651,'High Wizard Kathryne@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',1640,1641,1642,1643,1644,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1651,'High Wizard Kathryne@WZ_FIREPILLAR','attack',80,10,2000,200,0,'yes','around2','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -5132,7 +5132,7 @@ REPLACE INTO `mob_skill_db` VALUES (1979,'Zakudam@NPC_PIERCINGATT','attack',158, REPLACE INTO `mob_skill_db` VALUES (1979,'Zakudam@NPC_RANDOMATTACK','attack',183,5,1000,500,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1981,'Orc Elite Guard@CR_AUTOGUARD','chase',249,5,500,0,300000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1981,'Orc Elite Guard@NPC_DARKNESSATTACK','attack',190,3,500,500,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); -REPLACE INTO `mob_skill_db` VALUES (1981,'Orc Elite Guard@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (1981,'Orc Elite Guard@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1981,'Orc Elite Guard@NPC_PULSESTRIKE','attack',661,2,500,0,10000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1981,'Orc Elite Guard@NPC_PULSESTRIKE','chase',661,2,2000,0,10000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (1981,'Orc Elite Guard@SM_BASH','attack',5,10,500,1000,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -5967,7 +5967,7 @@ REPLACE INTO `mob_skill_db` VALUES (2111,'MasterSmith Howard@NPC_POWERUP','attac REPLACE INTO `mob_skill_db` VALUES (2111,'MasterSmith Howard@NPC_POWERUP','attack',349,5,2000,0,25000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2111,'MasterSmith Howard@NPC_SHIELDBRAKE','attack',346,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'19',NULL); REPLACE INTO `mob_skill_db` VALUES (2111,'MasterSmith Howard@NPC_SPLASHATTACK','attack',174,1,1000,0,0,'yes','target','attackpcge','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2111,'MasterSmith Howard@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2111,'MasterSmith Howard@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',1640,1641,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2111,'MasterSmith Howard@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'yes','self','slavele','3',1640,1641,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2111,'MasterSmith Howard@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'yes','self','slavele','3',1640,1641,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2111,'MasterSmith Howard@NPC_WATERATTACK','attack',184,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -5989,7 +5989,7 @@ REPLACE INTO `mob_skill_db` VALUES (2112,'Lord Knight Seyren@NPC_FIREATTACK','at REPLACE INTO `mob_skill_db` VALUES (2112,'Lord Knight Seyren@NPC_POWERUP','attack',349,5,2000,0,100000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2112,'Lord Knight Seyren@NPC_POWERUP','attack',349,5,2000,0,25000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2112,'Lord Knight Seyren@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2112,'Lord Knight Seyren@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2112,'Lord Knight Seyren@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',1641,1642,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2112,'Lord Knight Seyren@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'yes','self','slavele','3',1641,1642,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2112,'Lord Knight Seyren@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'yes','self','slavele','3',1641,1642,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2112,'Lord Knight Seyren@SM_BASH','attack',5,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -6022,7 +6022,7 @@ REPLACE INTO `mob_skill_db` VALUES (2113,'Assassin Cross Eremes@NPC_INVISIBLE',' REPLACE INTO `mob_skill_db` VALUES (2113,'Assassin Cross Eremes@NPC_INVISIBLE','idle',353,1,2000,0,30000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2113,'Assassin Cross Eremes@NPC_POISONATTACK','attack',188,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2113,'Assassin Cross Eremes@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2113,'Assassin Cross Eremes@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2113,'Assassin Cross Eremes@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',1640,1642,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2113,'Assassin Cross Eremes@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'yes','self','slavele','3',1640,1642,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2113,'Assassin Cross Eremes@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'yes','self','slavele','3',1640,1642,1643,1644,1645,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2113,'Assassin Cross Eremes@TF_POISON','attack',52,10,1000,0,10000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -6602,7 +6602,7 @@ REPLACE INTO `mob_skill_db` VALUES (2178,'Deepsea Shellfish@MG_LIGHTNINGBOLT','c REPLACE INTO `mob_skill_db` VALUES (2178,'Deepsea Shellfish@NPC_STUNATTACK','attack',179,3,500,1000,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (2178,'Deepsea Shellfish@NPC_WATERATTACK','attack',184,1,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2178,'Deepsea Shellfish@WZ_WATERBALL','attack',86,4,500,1500,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2179,'Ancient Kukre@NPC_EMOTION','loot',197,1,2000,0,5000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2179,'Ancient Kukre@NPC_EMOTION','loot',197,1,2000,0,5000,'yes','self','always',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2179,'Ancient Kukre@NPC_WATERATTACK','attack',184,1,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2179,'Ancient Kukre@ST_FULLSTRIP','attack',476,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (2179,'Ancient Kukre@WZ_WATERBALL','attack',86,4,500,1500,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -6848,7 +6848,7 @@ REPLACE INTO `mob_skill_db` VALUES (2194,'Giant Octopus@WZ_FROSTNOVA','attack',8 REPLACE INTO `mob_skill_db` VALUES (2194,'Giant Octopus@WZ_FROSTNOVA','chase',88,10,3000,1000,10000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2194,'Giant Octopus@WZ_WATERBALL','attack',86,10,10000,500,25000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL); REPLACE INTO `mob_skill_db` VALUES (2194,'Giant Octopus@WZ_WATERBALL','chase',86,10,10000,500,25000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL); -REPLACE INTO `mob_skill_db` VALUES (2195,'Ancient Kukre@NPC_EMOTION','loot',197,1,2000,0,5000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2195,'Ancient Kukre@NPC_EMOTION','loot',197,1,2000,0,5000,'yes','self','always',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2195,'Ancient Kukre@NPC_WATERATTACK','attack',184,1,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2195,'Ancient Kukre@ST_FULLSTRIP','attack',476,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (2195,'Ancient Kukre@WZ_WATERBALL','attack',86,4,500,1500,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -6944,7 +6944,7 @@ REPLACE INTO `mob_skill_db` VALUES (2208,'Wild Rider@NPC_AGIUP','chase',350,1,10 REPLACE INTO `mob_skill_db` VALUES (2208,'Wild Rider@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,27,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2208,'Wild Rider@WZ_WATERBALL','attack',86,4,500,1500,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2220,'Messenger of Devil@AL_TELEPORT','attack',26,1,1000,0,5000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2220,'Messenger of Devil@NPC_EMOTION','idle',197,1,2000,0,,'yes','self','always',NULL,29,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2220,'Messenger of Devil@NPC_EMOTION','idle',197,1,2000,0,0,'yes','self','always',NULL,29,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2221,'Randel@AL_HEAL','attack',28,4,3000,0,2000,'yes','friend','friendhpltmaxrate','99',NULL,NULL,NULL,NULL,NULL,'5',NULL); REPLACE INTO `mob_skill_db` VALUES (2221,'Randel@AL_HEAL','idle',28,4,3000,0,2000,'yes','friend','friendhpltmaxrate','99',NULL,NULL,NULL,NULL,NULL,'5',NULL); REPLACE INTO `mob_skill_db` VALUES (2221,'Randel@AL_HEAL','chase',28,4,3000,0,2000,'yes','friend','friendhpltmaxrate','99',NULL,NULL,NULL,NULL,NULL,'5',NULL); @@ -7229,7 +7229,7 @@ REPLACE INTO `mob_skill_db` VALUES (2235,'Randel@NPC_HOLYATTACK','attack',189,5, REPLACE INTO `mob_skill_db` VALUES (2235,'Randel@NPC_POWERUP','attack',349,5,2000,0,100000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2235,'Randel@NPC_POWERUP','attack',349,5,2000,0,25000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2235,'Randel@NPC_STUNATTACK','attack',179,5,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2235,'Randel@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2235,'Randel@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',2229,2230,2231,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2235,'Randel@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',2229,2230,2231,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2235,'Randel@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',2229,2230,2231,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2235,'Randel@PA_PRESSURE','attack',367,5,500,0,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -7256,7 +7256,7 @@ REPLACE INTO `mob_skill_db` VALUES (2236,'Flamel@NPC_CHANGETELEKINESIS','attack' REPLACE INTO `mob_skill_db` VALUES (2236,'Flamel@NPC_CRITICALSLASH','attack',170,1,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2236,'Flamel@NPC_FIREATTACK','attack',186,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2236,'Flamel@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2236,'Flamel@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2236,'Flamel@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',2228,2230,2231,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2236,'Flamel@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',2228,2230,2231,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2236,'Flamel@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',2228,2230,2231,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2237,'Celia@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -7287,7 +7287,7 @@ REPLACE INTO `mob_skill_db` VALUES (2237,'Celia@NPC_CHANGEHOLY','attack',167,1,1 REPLACE INTO `mob_skill_db` VALUES (2237,'Celia@NPC_CHANGETELEKINESIS','attack',169,1,10000,500,6000000,'no','self','myhpltmaxrate','10',NULL,NULL,NULL,NULL,NULL,'9',NULL); REPLACE INTO `mob_skill_db` VALUES (2237,'Celia@NPC_MENTALBREAKER','attack',159,5,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'7',NULL); REPLACE INTO `mob_skill_db` VALUES (2237,'Celia@NPC_MENTALBREAKER','chase',159,5,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'7',NULL); -REPLACE INTO `mob_skill_db` VALUES (2237,'Celia@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2237,'Celia@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',2228,2229,2231,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2237,'Celia@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',2228,2229,2231,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2237,'Celia@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',2228,2229,2231,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2237,'Celia@NPC_WIDESOULDRAIN','attack',680,5,1000,500,5000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,'42',NULL); @@ -7326,7 +7326,7 @@ REPLACE INTO `mob_skill_db` VALUES (2238,'Chen@NPC_HOLYATTACK','attack',189,10,1 REPLACE INTO `mob_skill_db` VALUES (2238,'Chen@NPC_POWERUP','attack',349,1,2000,0,100000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2238,'Chen@NPC_POWERUP','attack',349,1,2000,0,25000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2238,'Chen@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2238,'Chen@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2238,'Chen@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',2228,2229,2230,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2238,'Chen@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',2228,2229,2230,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2238,'Chen@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',2228,2229,2230,2232,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2239,'Gertie@AL_TELEPORT','idle',26,1,10000,0,0,'yes','self','rudeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -7348,7 +7348,7 @@ REPLACE INTO `mob_skill_db` VALUES (2239,'Gertie@NPC_POISON','attack',176,5,1000 REPLACE INTO `mob_skill_db` VALUES (2239,'Gertie@NPC_POISONATTACK','attack',188,10,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2239,'Gertie@NPC_SHIELDBRAKE','attack',346,5,500,0,20000,'yes','target','myhpltmaxrate','70',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2239,'Gertie@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2239,'Gertie@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2239,'Gertie@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',2228,2229,2230,2231,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2239,'Gertie@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',2228,2229,2230,2231,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2239,'Gertie@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',2228,2229,2230,2231,2233,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2239,'Gertie@NPC_WEAPONBRAKER','attack',343,1,500,0,30000,'yes','target','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -7373,7 +7373,7 @@ REPLACE INTO `mob_skill_db` VALUES (2240,'Alphoccio@NPC_PULSESTRIKE','attack',66 REPLACE INTO `mob_skill_db` VALUES (2240,'Alphoccio@NPC_SLOWCAST','attack',672,1,2000,800,30000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL); REPLACE INTO `mob_skill_db` VALUES (2240,'Alphoccio@NPC_SLOWCAST','chase',672,1,2000,300,30000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL); REPLACE INTO `mob_skill_db` VALUES (2240,'Alphoccio@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2240,'Alphoccio@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2240,'Alphoccio@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',2228,2229,2230,2231,2232,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2240,'Alphoccio@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',2228,2229,2230,2231,2232,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2240,'Alphoccio@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',2228,2229,2230,2231,2232,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2240,'Alphoccio@NPC_WINDATTACK','attack',187,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -7388,7 +7388,7 @@ REPLACE INTO `mob_skill_db` VALUES (2241,'Trentini@NPC_PULSESTRIKE','attack',661 REPLACE INTO `mob_skill_db` VALUES (2241,'Trentini@NPC_SLOWCAST','attack',672,1,2000,800,30000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL); REPLACE INTO `mob_skill_db` VALUES (2241,'Trentini@NPC_SLOWCAST','chase',672,1,2000,300,30000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL); REPLACE INTO `mob_skill_db` VALUES (2241,'Trentini@NPC_STUNATTACK','attack',179,5,1000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2241,'Trentini@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2241,'Trentini@NPC_SUMMONMONSTER','attack',209,5,10000,700,60000000,'yes','self','myhpltmaxrate','30',2228,2229,2230,2231,2232,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2241,'Trentini@NPC_SUMMONSLAVE','attack',196,5,10000,700,10000,'no','self','slavele','3',2228,2229,2230,2231,2232,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2241,'Trentini@NPC_SUMMONSLAVE','idle',196,5,10000,700,10000,'no','self','slavele','3',2228,2229,2230,2231,2232,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2241,'Trentini@NPC_UGLYDANCE','attack',2541,5,1000,1000,70000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -7826,16 +7826,16 @@ REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_BLOODDRAIN','i REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_BLOODDRAIN','idle',199,1,2000,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'29',NULL); REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_CRITICALWOUND','attack',673,2,500,0,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_DARKBLESSING','attack',203,1,5000,0,2000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','attack',209,5,5000,0,10000,'yes','self','casttargeted',NULL,NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','casttargeted',NULL,NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','attack',209,5,5000,0,10000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','28',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','18',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','21',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','79',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','83',NULL,NULL,NULL,NULL,NULL,'9',NULL); -REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'yes','self','skillused','89',NULL,NULL,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','longrangeattacked','0',2359,2357,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','casttargeted','0',2359,2357,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','attack',209,5,5000,0,10000,'no','self','longrangeattacked','0',2359,2357,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','attack',209,5,5000,0,10000,'no','self','casttargeted','0',2359,2357,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','18',2359,2357,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','89',2359,2357,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','21',2359,2357,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','28',2359,2357,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','79',2359,2357,NULL,NULL,NULL,'9',NULL); +REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@NPC_SUMMONMONSTER','idle',209,5,5000,0,10000,'no','self','skillused','83',2359,2357,NULL,NULL,NULL,'9',NULL); REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@WZ_FIREPILLAR','attack',80,10,5000,0,2000,'yes','around2','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@WZ_FIREPILLAR','idle',80,10,10000,0,2000,'yes','around2','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2362,'Amon Ra (Nightmare)@WZ_FIREPILLAR','idle',80,10,10000,0,2000,'yes','around2','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -7913,7 +7913,7 @@ REPLACE INTO `mob_skill_db` VALUES (2468,'Raydric@BS_MAXIMIZE','attack',114,5,50 REPLACE INTO `mob_skill_db` VALUES (2468,'Raydric@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 (2468,'Raydric@CR_AUTOGUARD','attack',249,2,500,0,300000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2468,'Raydric@CR_AUTOGUARD','chase',249,2,2000,0,300000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2468,'Raydric@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2468,'Raydric@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always','0',0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2468,'Raydric@SM_MAGNUM','attack',7,9,500,500,5000,'no','self','always','0',NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (2469,'Raydric Archer@AC_CHARGEARROW','attack',148,1,500,0,5000,'yes','target','always','0',NULL,NULL,NULL,NULL,NULL,'9',NULL); REPLACE INTO `mob_skill_db` VALUES (2469,'Raydric Archer@CR_AUTOGUARD','attack',249,2,500,0,300000,'yes','self','always','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); @@ -8420,14 +8420,14 @@ REPLACE INTO `mob_skill_db` VALUES (2690,'Swift Raydric@BS_MAXIMIZE','chase',114 REPLACE INTO `mob_skill_db` VALUES (2690,'Swift Raydric@CR_AUTOGUARD','attack',249,2,500,0,300000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2690,'Swift Raydric@CR_AUTOGUARD','chase',249,2,2000,0,300000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2690,'Swift Raydric@NPC_DARKNESSATTACK','attack',190,3,500,500,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); -REPLACE INTO `mob_skill_db` VALUES (2690,'Swift Raydric@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2690,'Swift Raydric@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2690,'Swift Raydric@SM_MAGNUM','attack',7,9,500,500,5000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (2691,'Solid Raydric@BS_MAXIMIZE','attack',114,5,500,1000,5000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2691,'Solid Raydric@BS_MAXIMIZE','chase',114,5,500,1000,5000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2691,'Solid Raydric@CR_AUTOGUARD','attack',249,2,500,0,300000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2691,'Solid Raydric@CR_AUTOGUARD','chase',249,2,2000,0,300000,'yes','self','longrangeattacked',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2691,'Solid Raydric@NPC_DARKNESSATTACK','attack',190,3,500,500,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); -REPLACE INTO `mob_skill_db` VALUES (2691,'Solid Raydric@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2691,'Solid Raydric@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2691,'Solid Raydric@SM_MAGNUM','attack',7,9,500,500,5000,'no','self','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (2692,'Laurell Weinder Ringleader@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 (2692,'Laurell Weinder Ringleader@MG_FIREWALL','chase',18,5,500,500,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL); @@ -8959,7 +8959,7 @@ REPLACE INTO `mob_skill_db` VALUES (2774,'Swift Loli Ruri@AL_HEAL','attack',28,5 REPLACE INTO `mob_skill_db` VALUES (2774,'Swift Loli Ruri@NPC_DARKSTRIKE','chase',340,5,500,700,5000,'no','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (2774,'Swift Loli Ruri@NPC_DARKSTRIKE','attack',340,5,500,700,5000,'no','target','myhpltmaxrate','50',NULL,NULL,NULL,NULL,NULL,'6',NULL); REPLACE INTO `mob_skill_db` VALUES (2774,'Swift Loli Ruri@NPC_EMOTION','chase',197,1,2000,0,5000,'yes','self','always',NULL,3,NULL,NULL,NULL,NULL,NULL,NULL); -REPLACE INTO `mob_skill_db` VALUES (2774,'Swift Loli Ruri@NPC_SUMMONSLAVE','idle',196,1,500,2000,60000,'no','self','slavele','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL); +REPLACE INTO `mob_skill_db` VALUES (2774,'Swift Loli Ruri@NPC_SUMMONSLAVE','idle',196,1,500,2000,60000,'no','self','slavele','0',0,NULL,NULL,NULL,NULL,NULL,NULL); REPLACE INTO `mob_skill_db` VALUES (2774,'Swift Loli Ruri@PR_LEXDIVINA','attack',76,10,500,1000,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL); REPLACE INTO `mob_skill_db` VALUES (2774,'Swift Loli Ruri@PR_LEXDIVINA','chase',76,10,500,1000,5000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL); REPLACE INTO `mob_skill_db` VALUES (2774,'Swift Loli Ruri@SA_REVERSEORCISH','attack',294,1,50,0,30000,'yes','target','always',NULL,NULL,NULL,NULL,NULL,NULL,'18',NULL); diff --git a/sql-files/upgrades/2016-03-10--22-18.sql b/sql-files/upgrades/2016-03-10--22-18.sql new file mode 100644 index 000000000..80266bcca --- /dev/null +++ b/sql-files/upgrades/2016-03-10--22-18.sql @@ -0,0 +1,22 @@ +#1457638175 + +-- This file is part of Hercules. +-- http://herc.ws - http://github.com/HerculesWS/Hercules +-- +-- Copyright (C) 2015-2016 Hercules Dev Team +-- +-- Hercules is free software: you can redistribute it and/or modify +-- it under the terms of the GNU General Public License as published by +-- the Free Software Foundation, either version 3 of the License, or +-- (at your option) any later version. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program. If not, see <http://www.gnu.org/licenses/>. + +ALTER TABLE `picklog` MODIFY `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','K','Y','Z','W','Q','J','H','@','0','1','2') NOT NULL default 'P'; +INSERT INTO `sql_updates` (`timestamp`) VALUES (1457638175) diff --git a/sql-files/upgrades/index.txt b/sql-files/upgrades/index.txt index e73a8659d..6e81bd199 100644 --- a/sql-files/upgrades/index.txt +++ b/sql-files/upgrades/index.txt @@ -29,3 +29,4 @@ 2015-07-08--13-08.sql 2015-08-27--20-42.sql 2015-12-17--15-58.sql +2016-03-10--22-18.sql diff --git a/sql-files/upgrades/rAthena-logs-upgrade.sql b/sql-files/upgrades/rAthena-logs-upgrade.sql index b0faed244..5e9dbf60c 100644 --- a/sql-files/upgrades/rAthena-logs-upgrade.sql +++ b/sql-files/upgrades/rAthena-logs-upgrade.sql @@ -34,7 +34,7 @@ DROP TABLE IF EXISTS `cashlog`; ALTER TABLE `mvplog` MODIFY `prize` INT(11) NOT NULL DEFAULT '0'; -- Upgrades to table `picklog` -ALTER TABLE `picklog` MODIFY `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U') NOT NULL default 'P'; +ALTER TABLE `picklog` MODIFY `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','K','Y','Z','W','Q','J','H','@','0','1','2') NOT NULL default 'P'; ALTER TABLE `picklog` MODIFY `nameid` INT(11) NOT NULL DEFAULT '0'; ALTER TABLE `picklog` MODIFY `card0` INT(11) NOT NULL DEFAULT '0'; ALTER TABLE `picklog` MODIFY `card1` INT(11) NOT NULL DEFAULT '0'; |