DB/Creature: Add Nexus missing spawns

1 files changed, 37 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_08_03_07_world.sql b/sql/updates/world/3.3.5/2019_08_03_07_world.sql
new file mode 100644
index 00000000000..ad3fe6aa224
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_08_03_07_world.sql
@@ -0,0 +1,37 @@
+-- 
+DELETE FROM `creature` WHERE `id` IN (26800,26802,26805,27949) AND `guid` IN (126664, 126665, 126666, 126667, 126668,  113671, 113689, 113767, 115899, 115900, 115917, 115918, 115933, 115952, 115965, 115970, 116016, 116017, 116018);
+DELETE FROM `creature_addon` WHERE `guid` IN (126664, 126665, 126666, 126667, 126668, 4764);
+DELETE FROM `spawn_group` WHERE `spawnId` IN (126664, 126665, 126666, 126667, 126668) AND `spawnType`=0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(113671, 26800, 576, 4265, 0, 3, 1, 0, 1, 408.0589, 187.066, -34.93626, 5.009095, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26800 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(113689, 26800, 576, 4265, 0, 3, 1, 0, 1, 389.5342, 148.687, -34.9363, 5.916666, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26800 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(113767, 26800, 576, 4265, 0, 3, 1, 0, 1, 404.3392, 181.3861, -34.93626, 5.113815, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26800 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(115899, 26800, 576, 4265, 0, 3, 1, 0, 1, 443.3662, 183.4617, -34.93741, 4.310963, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26800 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(115900, 26800, 576, 4265, 0, 3, 1, 0, 1, 450.2576, 175.4623, -34.93753, 4.118977, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26800 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(115917, 26802, 576, 4265, 0, 3, 1, 0, 1, 389.5952, 167.328, -34.93625, 5.532694, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26802 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(115918, 26802, 576, 4265, 0, 3, 1, 0, 1, 410.0124, 179.3177, -34.93626, 5.026548, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26802 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(115933, 26802, 576, 4265, 0, 3, 1, 0, 1, 442.8123, 176.3978, -34.9374, 4.276057, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26802 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(115952, 26802, 576, 4265, 0, 3, 1, 0, 1, 460.9607, 147.6021, -34.93775, 3.455752, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26802 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(115965, 26802, 576, 4265, 0, 3, 1, 0, 1, 460.8256, 162.6609, -34.93771, 3.769911, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26802 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(115970, 26805, 576, 4265, 0, 3, 1, 0, 1, 395.8999, 169.2197, -34.93626, 5.410521, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26805 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(116016, 26805, 576, 4265, 0, 3, 1, 0, 1, 428.6005, 189.3316, -34.93692, 4.607669, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26805 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(116017, 26805, 576, 4265, 0, 3, 1, 0, 1, 420.7034, 189.5074, -34.93657, 4.782202, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723), -- 26805 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+(116018, 27949, 576, 4265, 0, 1, 1, 0, 1, 424.5469, 185.9617, -34.93673, 4.694936, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11723); -- 27949 (Area: 0 - Difficulty: 0) (Auras: 47543 - 47543)
+
+UPDATE `creature_template_addon` SET `bytes2`=1, `emote`=333, `auras`="47543" WHERE `entry` IN (26798,26796,30397,30398);
+DELETE FROM `creature_template_addon` WHERE `entry` IN (30496,30509,30498,30495,30508,30497,26799,26801,26803,26800,26802,26805,27949,27947);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`, `visibilityDistanceType`) VALUES
+(30496, 0, 0, 0, 1, 333, '47543', 3),
+(30509, 0, 0, 0, 1, 376, '47543', 3),
+(30498, 0, 0, 0, 1, 375, '47543', 3),
+(30495, 0, 0, 0, 1, 333, '47543', 3),
+(30508, 0, 0, 0, 1, 376, '47543', 3),
+(30497, 0, 0, 0, 1, 375, '47543', 3),
+(26799, 0, 0, 0, 1, 333, '47543', 3),
+(26801, 0, 0, 0, 1, 376, '47543', 3),
+(26803, 0, 0, 0, 1, 375, '47543', 3),
+(26800, 0, 0, 0, 1, 333, '47543', 3),
+(26802, 0, 0, 0, 1, 376, '47543', 3),
+(26805, 0, 0, 0, 1, 375, '47543', 3),
+(27949, 0, 0, 0, 1, 333, '47543', 3),
+(27947, 0, 0, 0, 1, 333, '47543', 3);