From 3a226bb3c047ae5551558853ef0f31582ca044bf Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Wed, 20 Jul 2016 07:22:33 +0200 Subject: MobDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/mob_db_re.sql | 39 ++++++++++++++++++++++++--------------- 1 file changed, 24 insertions(+), 15 deletions(-) diff --git a/sql-files/mob_db_re.sql b/sql-files/mob_db_re.sql index 8bf0e006c..da5786108 100644 --- a/sql-files/mob_db_re.sql +++ b/sql-files/mob_db_re.sql @@ -1411,19 +1411,28 @@ REPLACE INTO `mob_db` VALUES (2409,'DUMMY_50','Lv 50','Lv 50',50,99999999,1,0,0, REPLACE INTO `mob_db` VALUES (2410,'DUMMY_100','Lv 100','Lv 100',100,99999999,1,0,0,0,0,0,90,90,0,0,0,0,0,0,1,1,1,0,20,32768,200,398,199,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); REPLACE INTO `mob_db` VALUES (2411,'DUMMY_150','Lv 150','Lv 150',150,99999999,1,0,0,0,0,0,120,120,0,0,0,0,0,0,1,1,1,0,20,32768,200,398,199,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); REPLACE INTO `mob_db` VALUES (2413,'DUMMY_10_FIRE','Lv 10 (Fire)','Lv 10 (Fire)',10,99999999,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,23,32768,200,398,199,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2464,'MG_ZOMBIE','Zombie','Zombie',17,9340,1,117,87,1,38,50,20,3,15,8,17,0,15,0,10,12,1,1,29,14469,400,2612,912,288,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2465,'MG_WRAITH','Wraith','Wraith',77,23168,1,1190,1191,1,335,396,80,40,62,26,30,55,76,5,10,12,2,1,89,13973,300,1816,576,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2466,'MG_GHOUL','Ghoul','Ghoul',61,12614,1,583,656,1,216,245,78,5,56,12,19,11,27,10,10,12,1,1,49,14469,250,2456,912,504,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2467,'MG_ARCLOUSE','Arclouse','Arclouze',107,14020,1,1844,2607,1,269,309,101,36,60,73,45,35,140,15,10,12,1,4,42,12693,100,960,500,480,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2468,'MG_RAYDRIC','Raydric','Raydric',115,25408,1,20770,2076,1,572,668,89,15,129,87,55,32,76,27,10,12,2,7,47,12437,150,824,780,420,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2469,'MG_RAYDRIC_ARCHER','Raydric Archer','Raydric Archer',82,30370,1,1049,1332,9,377,395,63,40,53,24,40,15,112,30,10,12,1,6,47,8581,200,1152,1152,480,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2470,'MG_KNIGHT_OF_ABYSS','Knight of Abyss','Abysmal Knight',122,332970,1,4779,4013,1,810,1002,102,50,121,55,68,70,97,37,10,12,2,7,87,13973,300,1500,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2471,'MG_KHALITZBURG','Khalitzburg','Khalitzburg',118,109860,1,2862,2147,1,737,833,125,10,121,48,40,31,89,32,10,12,2,1,29,13973,350,1000,1000,396,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2472,'MG_BLOODY_KNIGHT','Bloody Knight','Bloody Knight',116,285000,1,7348,6511,3,942,1065,122,50,132,59,70,57,98,45,10,12,2,0,87,13973,250,828,528,192,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2473,'MG_M_UNDEAD_KNIGHT','Undead Knight','Undead Knight',133,500000,1,4500,3375,2,751,880,122,62,122,87,54,65,103,65,14,16,2,7,80,14261,170,398,384,288,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2474,'MG_F_UNDEAD_KNIGHT','Undead Knight','Undead Knight',133,500000,1,4500,3375,2,751,880,122,62,122,87,54,65,103,65,14,16,2,7,80,14261,170,398,384,288,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2475,'MG_CORRUPTION_ROOT','Root of Corruption','Root of Corruption',136,3190000,1,240120,187920,3,710,1762,213,123,86,89,120,131,101,92,14,14,2,7,62,420,170,2000,2000,480,120060,607,5500,608,3500,732,5500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4603,1); -REPLACE INTO `mob_db` VALUES (2476,'MG_AMDARAIS','Amdarias','Amdarias',143,3283990,1,74288,77950,2,8860,10022,32,66,140,159,30,109,300,90,10,12,2,2,63,14261,200,1152,1152,576,37144,617,5500,617,5000,616,2000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4601,1); +REPLACE INTO `mob_db` VALUES (2464,'MG_ZOMBIE','Corrupted Steward','Corrupted Steward',130,135600,1,13332,15998,1,2364,444,15,15,44,22,77,25,88,22,10,12,1,1,29,14741,400,2612,912,288,0,0,0,0,0,0,0,6609,1000,6610,1000,6608,10,938,1000,727,500,6755,500,0,0,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2465,'MG_WRAITH','Corrupted Monk','Corrupted Monk',133,100168,1,13998,16796,1,999,2787,80,200,16,26,30,115,79,5,10,12,2,1,89,14229,300,1816,576,240,0,0,0,0,0,0,0,731,100,747,500,2206,100,6608,10,6609,1000,6610,1000,6755,500,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2466,'MG_GHOUL','Grand Chamberlain in Pa','Grand Chamberlain in Pa',132,208100,1,14222,17066,1,2965,666,30,30,88,44,88,21,95,44,10,12,1,1,49,14741,250,2456,912,504,0,0,0,0,0,0,0,756,100,2609,100,6608,10,6609,1000,6610,1000,7751,1000,6755,500,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2467,'MG_ARCLOUSE','Maggot','Maggot',133,80811,1,22,26,1,1246,1257,121,36,60,103,45,35,172,15,10,12,0,4,42,12693,100,960,500,480,0,0,0,0,0,0,0,997,100,1096,3000,6608,10,6609,1000,6610,1000,6755,500,0,0,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2468,'MG_RAYDRIC','Corrupted Palace Guard','Corrupted Palace Guard',135,184080,1,16306,6944,2,3167,138,89,15,159,87,66,33,106,27,10,12,1,1,47,12693,150,824,780,420,0,0,0,0,0,0,0,7054,3000,985,50,6608,10,6609,1000,6610,1000,6755,500,2316,200,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2469,'MG_RAYDRIC_ARCHER','Wandering Archer','Wandering Archer',136,144370,1,14248,9378,14,3891,167,63,40,53,24,40,15,156,30,10,12,1,1,47,9109,200,1152,1152,480,0,0,0,0,0,0,0,7054,3000,985,50,6608,10,6609,1000,6610,1000,6755,500,2330,200,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2470,'MG_KNIGHT_OF_ABYSS','Corrupted Abysmal Knigh','Corrupted Abysmal Knigh',142,225789,1,18584,16576,2,3200,22,102,50,121,55,99,70,126,37,10,12,2,1,87,14261,300,1500,500,1000,0,0,0,0,0,0,0,1064,5000,1004,10,6608,50,6609,3000,6610,2000,6755,500,2341,200,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2471,'MG_KHALITZBURG','Suffering Khalitzburg','Suffering Khalitzburg',143,236851,1,17542,14662,2,2800,100,125,10,121,142,55,81,105,32,10,12,2,1,29,14261,350,1000,1000,396,0,0,0,0,0,0,0,985,50,1004,10,6608,50,6609,3000,6610,2000,6755,500,1110,300,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2472,'MG_BLOODY_KNIGHT','Bloody Knight','Bloody Knight',143,246751,1,20448,21882,2,1881,3200,122,300,132,55,89,151,137,45,10,12,2,1,87,14261,250,828,528,192,0,0,0,0,0,0,0,1157,100,1160,100,6608,50,6609,3000,6610,2000,6755,500,7054,500,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2473,'MG_M_UNDEAD_KNIGHT','1st Commander of Destru','1st Commander of Destru',145,950033,1,160018,135184,2,3321,1009,80,150,165,82,110,122,154,52,14,16,1,1,49,14261,170,398,384,288,0,0,0,0,0,0,0,1163,100,1191,10,6608,50,6609,5000,6610,5000,6755,500,1463,200,0,0,0,0,4605,1); +REPLACE INTO `mob_db` VALUES (2474,'MG_F_UNDEAD_KNIGHT','2nd Commander of Destru','2nd Commander of Destru',145,848011,1,159672,120398,2,3090,1488,80,180,155,88,110,135,154,59,14,16,1,1,49,14261,170,398,384,288,0,0,0,0,0,0,0,1145,50,1163,100,6608,50,6609,5000,6610,5000,6755,500,0,0,0,0,0,0,4606,1); +REPLACE INTO `mob_db` VALUES (2475,'MG_CORRUPTION_ROOT','Corrupted Soul','Corrupted Soul',150,1820000,1,2199906,2008478,3,3887,3887,333,333,201,20,90,201,201,20,14,14,2,6,62,14260,170,2000,2000,480,449977,0,0,0,0,0,0,616,5000,617,10000,6607,5000,607,10000,2854,1000,7566,10000,6755,500,0,0,0,0,4603,1); +REPLACE INTO `mob_db` VALUES (2476,'MG_AMDARAIS','Amdarais','Amdarais',150,4290000,1,2291324,2197024,3,5290,3900,30,40,255,39,90,169,166,20,10,12,2,1,89,14261,200,1152,1152,576,472831,0,0,0,0,0,0,616,5000,617,10000,6607,5000,607,10000,1186,1000,1004,10000,0,0,0,0,0,0,4601,1); +REPLACE INTO `mob_db` VALUES (2477,'NG_WANDER_MAN','Nightmare Wander Man','Nightmare Wander Man',151,130682,1,19814,17228,2,2827,218,129,16,208,151,76,39,231,50,12,12,1,6,24,14229,100,672,500,192,0,0,0,0,0,0,0,7005,4850,616,2,13015,5,2270,5,21003,1,984,110,1164,10,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2478,'NG_RIDEWORD','Nightmare Rideword','Nightmare Rideword',146,103220,1,10500,15840,1,2320,166,140,59,131,195,58,66,263,5,12,12,0,0,60,13973,150,864,500,192,0,0,0,0,0,0,0,1097,4850,1568,5,1569,5,1570,5,1571,5,7015,150,18752,1,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2479,'NG_MIMIC','Nightmare Mimic','Nightmare Mimic',143,24958,1,2768,2354,1,1787,159,139,46,145,162,10,49,213,57,10,12,1,0,60,12437,100,972,500,288,0,0,0,0,0,0,0,617,10,603,50,7940,1000,7938,1000,2626,10,757,270,512,22,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2480,'NG_EVIL_DRUID','Nightmare Evil Druid','Nightmare Evil Druid',134,72837,1,6740,5886,1,1409,143,160,41,137,60,48,57,158,28,10,12,2,1,89,13973,300,2276,576,336,0,0,0,0,0,0,0,2217,10,1624,1,2508,10,1557,5,7478,5,509,2000,0,0,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2481,'NG_WRAITH_DEAD','Nightmare Wraith Dead','Nightmare Wraith Dead',110,15579,1,2554,2760,1,761,122,93,56,69,52,47,55,109,28,10,12,2,1,89,13973,175,1816,576,240,0,0,0,0,0,0,0,1059,4400,2206,10,2506,5,716,750,2505,10,732,10,0,0,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2482,'G_MG_KHALITZBURG','Nightmare Khalitzburg','Nightmare Khalitzburg',143,236851,1,13085,10023,1,2800,100,125,10,121,142,55,81,125,32,10,12,2,1,29,13973,350,1000,1000,396,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2483,'NG_BAPHOMET','Nightmare Baphomet','Nightmare Baphomet',154,4008000,1,1308530,1002320,1,2794,1260,379,45,120,125,230,85,186,85,10,12,2,6,67,14261,100,768,768,576,198262,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2484,'G_NG_BAPHOMET_','Nightmare Baphomet Jr.','Nightmare Baphomet Jr.',141,49675,1,13085,10023,1,1302,558,175,62,52,60,90,40,52,25,10,12,0,6,27,13973,100,868,480,120,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2485,'NG_CHIMERA','Nightmare Chimera','Nightmare Chimera',140,528120,1,54260,46980,1,1887,823,159,20,101,76,110,176,182,170,10,12,2,2,63,14229,200,772,672,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); REPLACE INTO `mob_db` VALUES (2549,'GEFFEN_MAGE_1','Ahri','Ahri',90,100000,1,8900,4550,1,329,424,64,38,50,50,50,50,130,50,10,12,1,7,20,13973,200,676,648,432,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); REPLACE INTO `mob_db` VALUES (2550,'GEFFEN_MAGE_2','Dio Anemos','Dio Anemos',95,200000,1,9440,4430,1,478,649,129,18,40,40,50,80,130,60,10,12,1,7,20,13973,200,676,648,432,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); REPLACE INTO `mob_db` VALUES (2551,'GEFFEN_MAGE_3_1','Geffen Shoplifter','Geffen Shoplifter',100,300000,1,9780,3665,1,478,632,93,36,70,70,40,40,140,60,10,12,1,7,20,13973,200,676,648,432,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); @@ -1574,8 +1583,8 @@ REPLACE INTO `mob_db` VALUES (2729,'C1_NOVUS','Swift Novus','Swift Novus',90,333 REPLACE INTO `mob_db` VALUES (2730,'C2_NOVUS','Solid Novus','Solid Novus',90,66700,1,3590,11280,1,573,205,95,48,74,56,57,25,108,45,10,12,0,9,20,14469,110,398,288,360,0,0,0,0,0,0,0,511,3000,7053,135,1036,589,0,0,0,0,0,0,0,0,0,0,0,0,4383,1); REPLACE INTO `mob_db` VALUES (2731,'C3_NOVUS','Novus Ringleader','Novus Ringleader',90,33350,1,3590,11280,1,573,205,95,48,74,56,57,25,108,45,10,12,0,9,20,14469,110,398,288,360,0,0,0,0,0,0,0,511,3000,7053,135,1036,589,0,0,0,0,0,0,0,0,0,0,0,0,4383,1); REPLACE INTO `mob_db` VALUES (2732,'C4_NIGHTMARE_TERROR','Furious Nightmare Terro','Furious Nightmare Terro',107,66445,1,6105,16485,1,1105,440,78,37,118,68,55,63,106,43,10,12,2,6,67,14725,165,1216,816,432,0,0,0,0,0,0,0,7120,4947,2626,1,2608,30,505,50,510,150,695,100,1261,1,0,0,0,0,4166,1); -REPLACE INTO `mob_db` VALUES (2733,'C5_NG_WRAITH_DEAD','Elusive Wraith Dead (Ni','Elusive Wraith Dead (Ni',110,77895,1,6385,20700,1,909,365,93,53,69,52,47,55,109,28,10,12,2,1,89,13973,175,1816,576,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -REPLACE INTO `mob_db` VALUES (2734,'C1_NG_WANDER_MAN','Furious Wanderer (Night','Furious Wanderer (Night',151,653410,1,49535,129210,1,3072,1357,129,16,208,151,76,39,231,50,10,12,1,6,24,14725,100,672,500,192,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2733,'C5_NG_WRAITH_DEAD','Elusive Wraith Dead','Elusive Wraith Dead',110,77895,1,6385,20700,1,909,1274,93,53,69,52,47,55,109,28,10,12,2,1,89,13973,175,1816,576,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); +REPLACE INTO `mob_db` VALUES (2734,'C1_NG_WANDER_MAN','Swift Wanderer','Swift Wanderer',151,653410,1,49535,129210,1,3072,1357,129,16,208,151,76,39,231,50,10,12,1,6,24,14725,100,672,500,192,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); REPLACE INTO `mob_db` VALUES (2735,'C2_NEPENTHES','Solid Nephentes','Solid Nephentes',114,150990,1,8445,16125,7,1016,405,25,5,94,32,41,39,210,59,10,12,1,3,45,132,1000,576,576,504,0,0,0,0,0,0,0,5399,1,1979,1,1926,1,1740,1,6041,3000,993,50,905,9000,0,0,0,0,4470,1); REPLACE INTO `mob_db` VALUES (2736,'C3_NECROMANCER','Necromancer Ringleader','Necromancer Ringleader',133,456520,1,14950,44850,1,1545,652,84,73,108,54,77,116,137,30,10,12,1,1,89,14261,150,1816,1320,420,0,0,0,0,0,0,0,7752,3000,1624,20,932,4500,2532,10,717,100,609,100,7117,1500,0,0,0,0,4440,1); REPLACE INTO `mob_db` VALUES (2737,'C4_MYSTCASE','Furious Myst Case','Furious Myst Case',39,4395,1,720,2430,1,129,32,50,11,26,24,40,35,31,25,10,12,1,0,60,145,400,1248,1248,432,0,0,0,0,0,0,0,530,90,601,10,603,20,539,800,722,150,731,5,529,340,0,0,0,0,4206,1); -- cgit v1.2.3-70-g09d2