DB/Creature: Add missing spawns on Magisters Terrace

1 files changed, 37 insertions, 0 deletions

diff --git a/sql/updates/world/master/2019_02_20_00_world.sql b/sql/updates/world/master/2019_02_20_00_world.sql
new file mode 100644
index 00000000000..dd96469c960
--- /dev/null
+++ b/sql/updates/world/master/2019_02_20_00_world.sql
@@ -0,0 +1,37 @@
+SET @CGUID := 259501;
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+20;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 55014, 585, 4131, 0, "1,2", 169, 0, 0, 0, 46.6875, -8.72743, -2.745695, 0.4537856, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Marksman (Area: 0 - Difficulty: 0) (Auras: 58506 - Stealth)
+(@CGUID+1, 55012, 585, 4131, 0, "1,2", 169, 0, 0, 0, 13.47049, 6.173611, -2.709095, 4.694936, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Warrior (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+2, 55012, 585, 4131, 0, "1,2", 169, 0, 0, 0, 0.2725694, -5.894097, -2.72833, 1.623156, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Warrior (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+3, 55013, 585, 4131, 0, "1,2", 169, 0, 0, 0, 43.15278, -5.890625, -2.740964, 0.2792527, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Marksman (Area: 0 - Difficulty: 0) (Auras: 58506 - Stealth)
+(@CGUID+4, 55011, 585, 4131, 0, "1,2", 169, 0, 0, 0, 50.57986, -2.822917, -2.732662, 6.213372, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Warrior (Area: 0 - Difficulty: 0) (Auras: 58506 - Stealth)
+(@CGUID+5, 55014, 585, 4131, 0, "1,2", 169, 0, 0, 0, 46.77951, 8.99132, -2.738889, 5.72468, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Marksman (Area: 0 - Difficulty: 0) (Auras: 58506 - Stealth)
+(@CGUID+6, 55013, 585, 4131, 0, "1,2", 169, 0, 0, 0, 42.99479, 6.149306, -2.729624, 5.951573, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Marksman (Area: 0 - Difficulty: 0) (Auras: 58506 - Stealth)
+(@CGUID+7, 55011, 585, 4131, 0, "1,2", 169, 0, 0, 0, 0.08506945, 6.458333, -2.715962, 4.660029, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Warrior (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+8, 55012, 585, 4131, 0, "1,2", 169, 0, 0, 0, 50.30729, 3.039931, -2.726843, 0.03490658, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Warrior (Area: 0 - Difficulty: 0) (Auras: 58506 - Stealth)
+(@CGUID+9, 55014, 585, 4131, 0, "1,2", 169, 0, 0, 0, 14.04688, -5.9375, -2.72026, 1.58825, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Marksman (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+10, 55011, 585, 4131, 0, "1,2", 169, 0, 0, 0, 5.130208, -5.951389, -2.725587, 1.658063, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Warrior (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+11, 55013, 585, 4131, 0, "1,2", 169, 0, 0, 0, 9.677083, -5.901042, -2.722767, 1.58825, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Marksman (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+12, 55011, 585, 4131, 0, "1,2", 169, 0, 0, 0, 9.067708, 6.24132, -2.711256, 4.642576, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Warrior (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+13, 55018, 585, 4131, 0, "1,2", 169, 0, 0, 0, 22.20313, 0.3125, -2.734227, 4.794769, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Sentry (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(@CGUID+14, 55013, 585, 4131, 0, "1,2", 169, 0, 0, 0, 4.619792, 6.265625, -2.713269, 4.747295, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- Shattered Sun Marksman (Area: 0 - Difficulty: 0) (Auras: )
+(@CGUID+15, 55007, 585, 4131, 0, "1,2", 169, 0, 0, 0, 17.20486, 0.001736111, -2.712097, 3.106686, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595); -- Exarch Larethor (Area: 0 - Difficulty: 0)
+
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+15;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(@CGUID+0, 0, 0, 0, 2, 0, '58506'), -- Shattered Sun Marksman - 58506 - Stealth
+(@CGUID+1, 0, 0, 0, 1, 0, ''), -- Shattered Sun Warrior
+(@CGUID+2, 0, 0, 0, 1, 0, ''), -- Shattered Sun Warrior
+(@CGUID+3, 0, 0, 0, 2, 0, '58506'), -- Shattered Sun Marksman - 58506 - Stealth
+(@CGUID+4, 0, 0, 0, 1, 0, '58506'), -- Shattered Sun Warrior - 58506 - Stealth
+(@CGUID+5, 0, 0, 0, 2, 0, '58506'), -- Shattered Sun Marksman - 58506 - Stealth
+(@CGUID+6, 0, 0, 0, 2, 0, '58506'), -- Shattered Sun Marksman - 58506 - Stealth
+(@CGUID+7, 0, 0, 0, 1, 0, ''), -- Shattered Sun Warrior
+(@CGUID+8, 0, 0, 0, 1, 0, '58506'), -- Shattered Sun Warrior - 58506 - Stealth
+(@CGUID+9, 0, 0, 0, 2, 0, ''), -- Shattered Sun Marksman
+(@CGUID+10, 0, 0, 0, 1, 0, ''), -- Shattered Sun Warrior
+(@CGUID+11, 0, 0, 0, 2, 0, ''), -- Shattered Sun Marksman
+(@CGUID+12, 0, 0, 0, 1, 0, ''), -- Shattered Sun Warrior
+(@CGUID+14, 0, 0, 0, 2, 0, ''), -- Shattered Sun Marksman
+(@CGUID+15, 0, 0, 0, 1, 0, ''); -- Exarch Larethor