Updated SQL entries for Escha Ru'Aun NMs

x8jason8x · Post by **x8jason8x** » Mon Apr 30, 2018 5:41 pm

So I've done a ton of work in the last couple days in Escha Ruaun. Lot of NMs were not spawning properly, had wrong model id's, mixed up or missing pools, etc. I'm using this zone as a custom area on a 75 cap build, so naturally, I got to work. Naturally, as custom stuff isn't part of DSP, I have only added spawn point, group, and pool entries. Skills, spells, and drops will have to be done by someone else.

I'm using a private repository for my code, and I don't want to build another server just to commit a few SQL entries, so I apologize for that in advance. I added a bunch of missing and/or improperly displayed NMs, and rather than make some poor bastard do all the work I just did again (FYI, Warder of Loyalty and Warder of Love entries are just corrected spawn points, they will need editing in the DB, or deletion and re-insertion), I decided to post it here. Most need spawn point verification for multiple pop points, and varying degrees of work, but this will make them all spawnable, in at least one proper location. WARNING: If you choose to add this before DSP does, it will require manual database editing in groups and pools! Don't do this if you don't know what you're doing!

Enjoy!

In mob_spawn_points:

Code: Select all

INSERT INTO `mob_spawn_points` VALUES (17961347,'Warder_of_Love','Warder of Love',14441,-403.045,-70.803,397.578,123);

INSERT INTO `mob_spawn_points` VALUES (17961376,'Warder_of_Loyalty','Warder of Loyalty',14446,562.202,-70.519,-86.435,246);

INSERT INTO `mob_spawn_points` VALUES (17961378,'Eschan_Porxie','Eschan Porxie',14412,-258.58,-8.5,341.691,53);
INSERT INTO `mob_spawn_points` VALUES (17961380,'Eschan_Porxie','Eschan Porxie',14412,-262.58,-8.5,341.691,53);

INSERT INTO `mob_spawn_points` VALUES (17961381,'Bia','Bia',14634,-291.001,-42.001,-401.001,87);
INSERT INTO `mob_spawn_points` VALUES (17961382,'Bia','Bia',14634,-291.001,-42.001,-401.001,87);
INSERT INTO `mob_spawn_points` VALUES (17961383,'Bia','Bia',14634,-291.001,-42.001,-401.001,87);

INSERT INTO `mob_spawn_points` VALUES (17961384,'Ruea','Ruea',14635,-470.001,-42.001,152.001,139);
INSERT INTO `mob_spawn_points` VALUES (17961385,'Ruea','Ruea',14635,-470.001,-42.001,152.001,139);
INSERT INTO `mob_spawn_points` VALUES (17961386,'Ruea','Ruea',14635,-470.001,-42.001,152.001,139);

INSERT INTO `mob_spawn_points` VALUES (17961388,'Ma','Ma',14448,-471.486,-42.587,153.195,148);
INSERT INTO `mob_spawn_points` VALUES (17961389,'Ma','Ma',14448,-471.486,-42.587,153.195,148);

INSERT INTO `mob_spawn_points` VALUES (17961390,'Khon','Khon',14636,-291.001,-42.001,-401.001,87);
INSERT INTO `mob_spawn_points` VALUES (17961391,'Khon','Khon',14636,-291.001,-42.001,-401.001,87);
INSERT INTO `mob_spawn_points` VALUES (17961392,'Khon','Khon',14636,-291.001,-42.001,-401.001,87);

INSERT INTO `mob_spawn_points` VALUES (17961393,'Met','Met',14637,108.001,-40.001,-432.001,131);
INSERT INTO `mob_spawn_points` VALUES (17961394,'Met','Met',14637,108.001,-40.001,-432.001,131);
INSERT INTO `mob_spawn_points` VALUES (17961395,'Met','Met',14637,108.001,-40.001,-432.001,131);

INSERT INTO `mob_spawn_points` VALUES (17961397,'Khun','Khun',14449,-291.033,-42.587,-400.476,207);
INSERT INTO `mob_spawn_points` VALUES (17961398,'Khun','Khun',14449,-291.033,-42.587,-400.476,207);

INSERT INTO `mob_spawn_points` VALUES (17961399,'Wasserspeier','Wasserspeier',14638,-471.58,-42.587,153.2,148);
INSERT INTO `mob_spawn_points` VALUES (17961400,'Wasserspeier','Wasserspeier',14638,-471.58,-42.587,153.2,148);
INSERT INTO `mob_spawn_points` VALUES (17961401,'Wasserspeier','Wasserspeier',14638,-471.58,-42.587,153.2,148);

INSERT INTO `mob_spawn_points` VALUES (17961403,'Emputa','Emputa',14450,571.479,-69.203,-185.686,83);
INSERT INTO `mob_spawn_points` VALUES (17961404,'Emputa','Emputa',14450,571.479,-69.203,-185.686,83);

INSERT INTO `mob_spawn_points` VALUES (17961406,'Peirithoos','Peirithoos',14451,-571.348,-69.204,-185.561,226);
INSERT INTO `mob_spawn_points` VALUES (17961407,'Peirithoos','Peirithoos',14451,-571.348,-69.204,-185.561,226);

INSERT INTO `mob_spawn_points` VALUES (17961409,'Asida','Asida',14452,466.955,-42.772,140.305,101);
INSERT INTO `mob_spawn_points` VALUES (17961410,'Asida','Asida',14452,466.955,-42.772,140.305,101);

INSERT INTO `mob_spawn_points` VALUES (17961411,'Tenodera','Tenodera',14639,-471.58,-42.587,153.2,148);
INSERT INTO `mob_spawn_points` VALUES (17961412,'Tenodera','Tenodera',14639,-471.58,-42.587,153.2,148);
INSERT INTO `mob_spawn_points` VALUES (17961413,'Tenodera','Tenodera',14639,-471.58,-42.587,153.2,148);

INSERT INTO `mob_spawn_points` VALUES (17961416,'Sava_Savanovic','Sava Savanovic',14453,-471.486,-42.587,153.195,27);

INSERT INTO `mob_spawn_points` VALUES (17961418,'Palila','Palila',14455,115.485,-40.5,-438.714,150);
INSERT INTO `mob_spawn_points` VALUES (17961419,'Palila','Palila',14455,115.485,-40.5,-438.714,150);

INSERT INTO `mob_spawn_points` VALUES (17961426,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961427,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961428,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961429,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961430,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961431,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961432,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961433,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961434,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961435,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961436,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);
INSERT INTO `mob_spawn_points` VALUES (17961437,'Palilas_Vulture','Palila s Vulture',14456,1,1,1,1);

INSERT INTO `mob_spawn_points` VALUES (17961440,'Hanbi','Hanbi',14457,-470.984,-42.587,151.889,252);

INSERT INTO `mob_spawn_points` VALUES (17961448,'Hanbis_Demon','Hanbi s Demon',14458,-469.984,-42.587,151.889,152);
INSERT INTO `mob_spawn_points` VALUES (17961449,'Hanbis_Demon','Hanbi s Demon',14458,-471.388,-42.605,151.689,190);
INSERT INTO `mob_spawn_points` VALUES (17961450,'Hanbis_Demon','Hanbi s Demon',14458,-289.669,-42.587,-398.429,28);
INSERT INTO `mob_spawn_points` VALUES (17961451,'Hanbis_Demon','Hanbi s Demon',14458,-469.984,-42.587,151.889,152);
INSERT INTO `mob_spawn_points` VALUES (17961452,'Hanbis_Demon','Hanbi s Demon',14458,-471.984,-42.587,151.889,152);

INSERT INTO `mob_spawn_points` VALUES (17961454,'Yilan','Yilan',14459,107.019,-40.605,-432.584,0);

INSERT INTO `mob_spawn_points` VALUES (17961458,'Yilans_Dragon','Yilan s Dragon',14460,100.572,-40.405,-438.149,204);
INSERT INTO `mob_spawn_points` VALUES (17961459,'Yilans_Dragon','Yilan s Dragon',14460,100.128,-40.31,-436.81,218);

INSERT INTO `mob_spawn_points` VALUES (17961463,'Amymone','Amymone',14461,-557.82,-69.215,-183.23,228);
INSERT INTO `mob_spawn_points` VALUES (17961464,'Amymone','Amymone',14461,-557.82,-69.215,-183.23,228);

INSERT INTO `mob_spawn_points` VALUES (17961468,'Amymones_Peapuk','Amymone s Peapuk',14462,-556.054,-68.519,-193.255,248);
INSERT INTO `mob_spawn_points` VALUES (17961469,'Amymones_Peapuk','Amymone s Peapuk',14462,-562.898,-69.12,-188.1,149);
INSERT INTO `mob_spawn_points` VALUES (17961470,'Amymones_Peapuk','Amymone s Peapuk',14462,-477.543,-42.492,156.237,103); 
INSERT INTO `mob_spawn_points` VALUES (17961471,'Amymones_Peapuk','Amymone s Peapuk',14462,-556.054,-68.519,-193.255,248);
INSERT INTO `mob_spawn_points` VALUES (17961472,'Amymones_Peapuk','Amymone s Peapuk',14462,-562.898,-69.12,-188.1,149);
INSERT INTO `mob_spawn_points` VALUES (17961473,'Amymones_Peapuk','Amymone s Peapuk',14462,-477.543,-42.492,156.237,103);

INSERT INTO `mob_spawn_points` VALUES (17961475,'Naphula','Naphula',14463,105.213,-40.778,-425.65,212);

INSERT INTO `mob_spawn_points` VALUES (17961481,'Naphulas_Corpselight','Naphula s Corpselight',14464,105.657,-40.605,-435.171,187);
INSERT INTO `mob_spawn_points` VALUES (17961482,'Naphulas_Corpselight','Naphula s Corpselight',14464,106.237,-40.605,-433.855,140);

INSERT INTO `mob_spawn_points` VALUES (17961484,'Kammavaca','Kammavaca',14413,-471.58,-42.587,153.2,1);
INSERT INTO `mob_spawn_points` VALUES (17961485,'Kammavaca','Kammavaca',14413,-471.58,-42.587,153.2,1);

INSERT INTO `mob_spawn_points` VALUES (17961490,'Kammavacas_Limule','Kammavaca s Limule',14465,288.033,-42.587,-401.155,224);
INSERT INTO `mob_spawn_points` VALUES (17961491,'Kammavacas_Clionid','Kammavaca s Clionid',14466,289.093,-42.758,-401.085,255);
INSERT INTO `mob_spawn_points` VALUES (17961492,'Kammavacas_Murex','Kammavaca s Murex',14467,291.089,-42.587,-400.022,52);
INSERT INTO `mob_spawn_points` VALUES (17961493,'Kammavacas_Amoeban','Kammavaca s Amoeban',14468,288.993,-42.587,-401.339,13);
INSERT INTO `mob_spawn_points` VALUES (17961494,'Kammavacas_Limule','Kammavaca s Limule',14465,288.033,-42.587,-401.155,224);
INSERT INTO `mob_spawn_points` VALUES (17961495,'Kammavacas_Clionid','Kammavaca s Clionid',14466,289.093,-42.758,-401.085,255);
INSERT INTO `mob_spawn_points` VALUES (17961496,'Kammavacas_Murex','Kammavaca s Murex',14467,291.089,-42.587,-400.022,52);
INSERT INTO `mob_spawn_points` VALUES (17961497,'Kammavacas_Amoeban','Kammavaca s Amoeban',14468,288.993,-42.587,-401.339,13);

INSERT INTO `mob_spawn_points` VALUES (17961499,'Pakecet','Pakecet',14469,-474.976,-42.587,154.81,185);
INSERT INTO `mob_spawn_points` VALUES (17961500,'Pakecet','Pakecet',14469,-474.976,-42.587,154.81,185);

INSERT INTO `mob_spawn_points` VALUES (17961511,'Pakecets_Pugil','Pakecet s Pugil',14470,-462.703,-42.796,145.808,49);
INSERT INTO `mob_spawn_points` VALUES (17961512,'Pakecets_Pugil','Pakecet s Pugil',14470,-460.66,-42.297,144.852,68);
INSERT INTO `mob_spawn_points` VALUES (17961513,'Pakecets_Pugil','Pakecet s Pugil',14470,-478.945,-42.053,157.525,229);
INSERT INTO `mob_spawn_points` VALUES (17961514,'Pakecets_Pugil','Pakecet s Pugil',14470,-478.272,-42.108,156.431,217);
INSERT INTO `mob_spawn_points` VALUES (17961515,'Pakecets_Pugil','Pakecet s Pugil',14470,-460.944,-42.492,146.149,64);
INSERT INTO `mob_spawn_points` VALUES (17961516,'Pakecets_Pugil','Pakecet s Pugil',14470,-479.076,-42.004,160.238,4);
INSERT INTO `mob_spawn_points` VALUES (17961517,'Pakecets_Pugil','Pakecet s Pugil',14470,-462.302,-42.788,146.409,53);
INSERT INTO `mob_spawn_points` VALUES (17961518,'Pakecets_Pugil','Pakecet s Pugil',14470,-479.026,-42.003,160.323,5);
INSERT INTO `mob_spawn_points` VALUES (17961519,'Pakecets_Pugil','Pakecet s Pugil',14470,-468.712,-42.595,152.557,178);
INSERT INTO `mob_spawn_points` VALUES (17961520,'Pakecets_Pugil','Pakecet s Pugil',14470,-468.561,-42.639,153.745,165);
INSERT INTO `mob_spawn_points` VALUES (17961521,'Pakecets_Pugil','Pakecet s Pugil',14470,-462.703,-42.796,145.808,49);
INSERT INTO `mob_spawn_points` VALUES (17961522,'Pakecets_Pugil','Pakecet s Pugil',14470,-460.66,-42.297,144.852,68);
INSERT INTO `mob_spawn_points` VALUES (17961523,'Pakecets_Pugil','Pakecet s Pugil',14470,-478.945,-42.053,157.525,229);
INSERT INTO `mob_spawn_points` VALUES (17961524,'Pakecets_Pugil','Pakecet s Pugil',14470,-478.272,-42.108,156.431,217);
INSERT INTO `mob_spawn_points` VALUES (17961525,'Pakecets_Pugil','Pakecet s Pugil',14470,-460.944,-42.492,146.149,64);
INSERT INTO `mob_spawn_points` VALUES (17961526,'Pakecets_Pugil','Pakecet s Pugil',14470,-479.076,-42.004,160.238,4);
INSERT INTO `mob_spawn_points` VALUES (17961527,'Pakecets_Pugil','Pakecet s Pugil',14470,-462.302,-42.788,146.409,53);
INSERT INTO `mob_spawn_points` VALUES (17961528,'Pakecets_Pugil','Pakecet s Pugil',14470,-479.026,-42.003,160.323,5);
INSERT INTO `mob_spawn_points` VALUES (17961529,'Pakecets_Pugil','Pakecet s Pugil',14470,-468.712,-42.595,152.557,178);
INSERT INTO `mob_spawn_points` VALUES (17961530,'Pakecets_Pugil','Pakecet s Pugil',14470,-468.561,-42.639,153.745,165);

INSERT INTO `mob_spawn_points` VALUES (17961531,'Duke_Vepar','Duke Vepar',14644,108.001,-40.001,-432.001,131);
INSERT INTO `mob_spawn_points` VALUES (17961532,'Duke_Vepar','Duke Vepar',14644,108.001,-40.001,-432.001,131);
INSERT INTO `mob_spawn_points` VALUES (17961533,'Duke_Vepar','Duke Vepar',14644,108.001,-40.001,-432.001,131);

INSERT INTO `mob_spawn_points` VALUES (17961534,'Duke_Vepars_Gnat','Duke Vepar s Gnat',14645,108.001,-40.001,-432.001,131);
INSERT INTO `mob_spawn_points` VALUES (17961535,'Duke_Vepars_Gnat','Duke Vepar s Gnat',14645,108.001,-40.001,-432.001,131); 
INSERT INTO `mob_spawn_points` VALUES (17961536,'Duke_Vepars_Gnat','Duke Vepar s Gnat',14645,108.001,-40.001,-432.001,131);

INSERT INTO `mob_spawn_points` VALUES (17961537,'Virava','Vir ava',14640,470.001,-42.001,153.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961538,'Virava','Vir ava',14640,470.001,-42.001,153.001,245); 
INSERT INTO `mob_spawn_points` VALUES (17961539,'Virava','Vir ava',14640,470.001,-42.001,153.001,245);

INSERT INTO `mob_spawn_points` VALUES (17961540,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,152.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961541,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,151.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961542,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,150.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961543,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,153.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961544,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,154.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961545,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,155.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961546,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,154.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961547,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,152.001,245); 
INSERT INTO `mob_spawn_points` VALUES (17961548,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,151.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961549,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,150.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961550,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,153.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961551,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,154.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961552,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,155.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961553,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,154.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961554,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,152.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961555,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,151.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961556,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,150.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961557,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,153.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961558,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,154.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961559,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,155.001,245);
INSERT INTO `mob_spawn_points` VALUES (17961560,'Viravas_Rafflesia','Vir ava s Rafflesia',14641,470.001,-42.001,154.001,245);

INSERT INTO `mob_spawn_points` VALUES (17961562,'Byakko','Byakko',14471,105.699,-40.5,-442.299,55);
INSERT INTO `mob_spawn_points` VALUES (17961563,'Byakko','Byakko',14471,105.699,-40.5,-442.299,55);

INSERT INTO `mob_spawn_points` VALUES (17961564,'Genbu','Genbu',14633,105.597,-40.605,-432.655,191);
INSERT INTO `mob_spawn_points` VALUES (17961565,'Genbu','Genbu',14633,105.597,-40.605,-432.655,191);
INSERT INTO `mob_spawn_points` VALUES (17961566,'Genbu','Genbu',14633,105.597,-40.605,-432.655,191);

INSERT INTO `mob_spawn_points` VALUES (17961568,'Seiryu','Seiryu',14472,95.754,-40.5,-440.72,155);
INSERT INTO `mob_spawn_points` VALUES (17961569,'Seiryu','Seiryu',14472,95.754,-40.5,-440.72,155);

INSERT INTO `mob_spawn_points` VALUES (17961571,'Suzaku','Suzaku',14473,110.702,-40.778,-428.654,113);
INSERT INTO `mob_spawn_points` VALUES (17961572,'Suzaku','Suzaku',14473,110.702,-40.778,-428.654,113);

INSERT INTO `mob_spawn_points` VALUES (17961574,'Kirin','Kirin',14632,104.915,-40.605,-435.12,182);
INSERT INTO `mob_spawn_points` VALUES (17961575,'Kirin','Kirin',14632,104.915,-40.605,-435.12,182);

INSERT INTO `mob_spawn_points` VALUES (17961576,'Kirins_Avatar','Kirin s Avatar',14643,104.915,-40.605,-435.12,182);
INSERT INTO `mob_spawn_points` VALUES (17961577,'Kirins_Avatar','Kirin s Avatar',14643,104.915,-40.605,-435.12,182);
INSERT INTO `mob_spawn_points` VALUES (17961578,'Kirins_Avatar','Kirin s Avatar',14643,104.915,-40.605,-435.12,182);

INSERT INTO `mob_spawn_points` VALUES (17961580,'Kouryu','Kouryu',14454,104.915,-40.605,-435.119,0);
INSERT INTO `mob_spawn_points` VALUES (17961581,'Kouryu','Kouryu',14454,104.915,-40.605,-435.119,0);

INSERT INTO `mob_spawn_points` VALUES (17961582,'Byakko','Byakko',14471,105.699,-40.5,-442.299,55);
INSERT INTO `mob_spawn_points` VALUES (17961583,'Byakko','Byakko',14471,105.699,-40.5,-442.299,55);
INSERT INTO `mob_spawn_points` VALUES (17961584,'Byakko','Byakko',14471,105.699,-40.5,-442.299,55);

INSERT INTO `mob_spawn_points` VALUES (17961586,'Genbu','Genbu',14633,105.597,-40.605,-432.655,191);
INSERT INTO `mob_spawn_points` VALUES (17961587,'Genbu','Genbu',14633,105.597,-40.605,-432.655,191);

INSERT INTO `mob_spawn_points` VALUES (17961589,'Seiryu','Seiryu',14472,105.294,-40.605,-432.621,128);
INSERT INTO `mob_spawn_points` VALUES (17961590,'Seiryu','Seiryu',14472,105.294,-40.605,-432.621,128);

INSERT INTO `mob_spawn_points` VALUES (17961592,'Suzaku','Suzaku',14473,104.862,-40.605,-433.781,201);
INSERT INTO `mob_spawn_points` VALUES (17961593,'Suzaku','Suzaku',14473,104.862,-40.605,-433.781,201);

INSERT INTO `mob_spawn_points` VALUES (17961595,'ArkAngelHM','Ark Angel HM',14474,-568.685,-69.204,-185.461,23);
INSERT INTO `mob_spawn_points` VALUES (17961596,'ArkAngelHM','Ark Angel HM',14474,-568.685,-69.204,-185.461,23);

INSERT INTO `mob_spawn_points` VALUES (17961598,'ArkAngelTT','Ark Angel TT',14475,-286.290,-42.492,-394.342,87);
INSERT INTO `mob_spawn_points` VALUES (17961599,'ArkAngelTT','Ark Angel TT',14475,-286.290,-42.492,-394.342,87);

INSERT INTO `mob_spawn_points` VALUES (17961601,'ArkAngelMR','Ark Angel MR',14476,-568.174,-69.204,-187.354,77);
INSERT INTO `mob_spawn_points` VALUES (17961602,'ArkAngelMR','Ark Angel MR',14476,-568.174,-69.204,-187.354,77);

INSERT INTO `mob_spawn_points` VALUES (17961603,'ArkAngels_Gnat','Ark Angel s Gnat',14642,-568.174,-69.204,-187.354,77);
INSERT INTO `mob_spawn_points` VALUES (17961604,'ArkAngels_Gnat','Ark Angel s Gnat',14642,-568.174,-69.204,-187.354,77);
INSERT INTO `mob_spawn_points` VALUES (17961605,'ArkAngels_Gnat','Ark Angel s Gnat',14642,-568.174,-69.204,-187.354,77);

INSERT INTO `mob_spawn_points` VALUES (17961607,'ArkAngels_Karakul','Ark Angel s Karakul',14477,-566.94,-69.12,-187.949,92);
INSERT INTO `mob_spawn_points` VALUES (17961608,'ArkAngels_Karakul','Ark Angel s Karakul',14477,-566.94,-69.12,-187.949,92);

INSERT INTO `mob_spawn_points` VALUES (17961610,'ArkAngelEV','Ark Angel EV',14478,-570.592,-69.204,-184.69,113);
INSERT INTO `mob_spawn_points` VALUES (17961611,'ArkAngelEV','Ark Angel EV',14478,-570.592,-69.204,-184.69,113);

INSERT INTO `mob_spawn_points` VALUES (17961613,'ArkAngelGK','Ark Angel GK',14479,-471.485,-42.587,153.19,38);
INSERT INTO `mob_spawn_points` VALUES (17961614,'ArkAngelGK','Ark Angel GK',14479,-471.485,-42.587,153.19,38);

INSERT INTO `mob_spawn_points` VALUES (17961616,'ArkAngels_Wyvern','Ark Angel s Wyvern',14480,-471.173,-42.587,153.321,65);
INSERT INTO `mob_spawn_points` VALUES (17961617,'ArkAngels_Wyvern','Ark Angel s Wyvern',14480,-471.173,-42.587,153.321,65);

INSERT INTO `mob_spawn_points` VALUES (17961620,'Warder_of_Courage','Warder of Courage',14481,-425.652,-40.5,-6.164,0);

INSERT INTO `mob_spawn_points` VALUES (17961630,'Warders_Wynav','Warder s Wynav',14482,-425.544,-40.207,-8.638,201); 
INSERT INTO `mob_spawn_points` VALUES (17961631,'Warders_Wynav','Warder s Wynav',14482,-426.762,-40.173,-7.998,240);
INSERT INTO `mob_spawn_points` VALUES (17961632,'Warders_Wynav','Warder s Wynav',14482,-423.847,-40.206,-8.418,146);
INSERT INTO `mob_spawn_points` VALUES (17961633,'Warders_Wynav','Warder s Wynav',14482,-424.674,-40.197,-8.801,113);
INSERT INTO `mob_spawn_points` VALUES (17961634,'Warders_Wynav','Warder s Wynav',14482,-426.004,-40.5,-6.016,51);
INSERT INTO `mob_spawn_points` VALUES (17961635,'Warders_Wynav','Warder s Wynav',14482,-423.984,-40.189,-7.428,89);
INSERT INTO `mob_spawn_points` VALUES (17961636,'Warders_Wynav','Warder s Wynav',14482,106.556,-40.605,-430.541,51);
INSERT INTO `mob_spawn_points` VALUES (17961637,'Warders_Wynav','Warder s Wynav',14482,108.72,-40.605,-431.119,85);
INSERT INTO `mob_spawn_points` VALUES (17961638,'Warders_Wynav','Warder s Wynav',14482,108.012,-40.605,-429.579,70);

In group table, 14454 is corrected for Kouryu, and 14471 for Byakko. The rest can be directly inserted.
In mob_groups:

Code: Select all

INSERT INTO `mob_groups` VALUES (14454,5694,289,0,128,0,0,99999,125,125,0);

INSERT INTO `mob_groups` VALUES (14471,5690,289,0,128,0,0,99999,125,125,0);

INSERT INTO `mob_groups` VALUES (14632,5693,289,0,128,0,0,0,124,124,0);
INSERT INTO `mob_groups` VALUES (14633,5695,289,0,128,0,0,0,124,124,0);
INSERT INTO `mob_groups` VALUES (14634,5842,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14635,5843,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14636,5844,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14637,5845,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14638,5846,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14639,5847,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14640,5848,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14641,5849,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14642,5850,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14643,5851,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14644,5852,289,0,128,0,0,0,121,121,0);
INSERT INTO `mob_groups` VALUES (14645,5853,289,0,128,0,0,0,121,121,0);

and finally, Vir'ava needs the correct model ID, I couldn't find it, but she's borrowing Morta's skin for now. The spaced entries will need DB editing. The second insert block is new, and can be directly added.
In mob_pools:

Code: Select all

INSERT INTO `mob_pools` VALUES (5633,'Kammavaca','Kammavaca',53,0x0000140800000000000000000000000000000000,20,20,11,240,100,0,1,0,1,2,0,0,7,135,0,0,0,1,0,0);

INSERT INTO `mob_pools` VALUES (5666,'Warder_of_Loyalty','Warder_of_Loyalty',138,0x00006D0400000000000000000000000000000000,1,1,3,240,100,0,1,1,0,2,0,0,7,133,0,0,0,1,0,137);

INSERT INTO `mob_pools` VALUES (5692,'Suzaku-Escha','Suzaku-Escha',280,0x0000510100000000000000000000000000000000,5,5,7,240,125,0,1,1,0,2,0,32,7,135,0,0,27,1,0,280);

INSERT INTO `mob_pools` VALUES (5693,'Kirin-Escha','Kirin-Escha',281,0x0000930100000000000000000000000000000000,15,15,3,360,125,0,1,1,0,2,1,32,7,135,0,0,23,1,0,281);

INSERT INTO `mob_pools` VALUES (5694,'Kouryu','Kouryu',392,0x0000600200000000000000000000000000000000,15,15,3,240,125,1048,1,1,0,2,0,32,7,135,0,0,0,1,0,259);


INSERT INTO `mob_pools` VALUES (5842,'Bia','Bia',450,0x00000F0800000000000000000000000000000000,1,1,5,240,100,0,1,1,0,2,0,0,7,133,1,0,0,1,0,450);
INSERT INTO `mob_pools` VALUES (5843,'Ruea','Ruea',450,0x00000E0800000000000000000000000000000000,1,1,5,240,100,0,1,1,0,2,0,0,7,133,1,0,0,1,0,450);
INSERT INTO `mob_pools` VALUES (5844,'Khon','Khon',450,0x00000F0800000000000000000000000000000000,1,1,5,240,100,0,1,1,0,2,0,0,7,133,1,0,0,1,0,450);
INSERT INTO `mob_pools` VALUES (5845,'Met','Met',450,0x00002D0800000000000000000000000000000000,1,1,5,240,100,0,1,1,0,2,0,0,7,133,1,0,0,1,0,450);
INSERT INTO `mob_pools` VALUES (5846,'Wasserspeier','Wasserspeier',118,0x0000630800000000000000000000000000000000,4,5,3,240,100,0,1,0,0,2,0,0,0,135,0,0,0,1,0,925);
INSERT INTO `mob_pools` VALUES (5847,'Tenodera','Tenodera',340,0x000012084761756E616200000000000000000000,4,4,12,240,100,0,1,0,0,2,0,0,7,671,8,0,2,1,0,340);
INSERT INTO `mob_pools` VALUES (5848,'Virava','Virava',453,0x00002B0800000000000000000000000000000000,6,6,2,240,100,0,1,1,1,2,0,0,7,135,0,0,0,1,0,453);
INSERT INTO `mob_pools` VALUES (5849,'Viravas_Rafflesia','Viravas_Rafflesia',207,0x0000E80700000000000000000000000000000000,9,9,7,240,100,0,1,0,0,0,0,0,1,129,0,0,0,1,0,207);
INSERT INTO `mob_pools` VALUES (5850,'ArkAngels_Gnat','ArkAngels_Gnat',131,0x0000DD0700000000000000000000000000000000,6,6,3,240,100,0,0,0,0,0,0,0,1,129,0,0,0,1,0,131);
INSERT INTO `mob_pools` VALUES (5851,'EschaKirin_s_Avatar','EschaKirin_s_Avatar',34,0x00001B0300000000000000000000000000000000,4,4,7,240,100,0,0,0,1,8,0,0,7,155,0,0,0,1,0,34);
INSERT INTO `mob_pools` VALUES (5852,'Duke_Vepar','Duke_Vepar',435,0x0000040200000000000000000000000000000000,2,2,3,240,100,0,1,0,0,0,0,0,7,135,0,0,0,1,0,61);
INSERT INTO `mob_pools` VALUES (5853,'Duke_Vepars_Gnat','Duke_Vepars_Gnat',131,0x0000E20700000000000000000000000000000000,2,2,2,120,100,0,1,0,0,1,0,0,559,131,0,0,0,1,0,131);

Now if someone could tell me how to make summoning magic work in the Escha areas...... lol

Deprecated Darkstar fourms

Go to LandSandBoat

Updated SQL entries for Escha Ru'Aun NMs

Updated SQL entries for Escha Ru'Aun NMs