DB/Creature: Warsong Raider & Cosmetic Trigger - Phase 3 - LAB

1 files changed, 32 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_12_09_00_world.sql b/sql/updates/world/3.3.5/2019_12_09_00_world.sql
new file mode 100644
index 00000000000..d89d2379106
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_12_09_00_world.sql
@@ -0,0 +1,32 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (120429, 120430, 120431, 120432, 120496, 120516, 120517, 120524, 120525, 120527, 120528, 120529, 120530, 120531, 120532, 120535, 120536, 120537, 120538, 120539, 120540, 120541, 120542);
+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
+(120429, 31435, 571, 0, 0, 1, 8, 0, 1, 5879.417, 2100.573, 509.0201, 3.560472, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0)
+(120430, 31435, 571, 0, 0, 1, 8, 0, 1, 5891.056, 2021.512, 512.9142, 2.565634, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0)
+(120431, 31435, 571, 0, 0, 1, 8, 0, 1, 5893.938, 2024.526, 513.2369, 2.600541, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0)
+(120432, 31435, 571, 0, 0, 1, 8, 0, 1, 5885.642, 1991.998, 514.4342, 2.80998, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0)
+(120496, 31435, 571, 0, 0, 1, 8, 0, 1, 5848.652, 2096.577, 503.949, 3.368485, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(120516, 31435, 571, 0, 0, 1, 8, 0, 1, 5863.017, 2051.382, 504.0689, 2.80998, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(120517, 31435, 571, 0, 0, 1, 8, 0, 1, 5863.935, 2122.72, 507.8875, 3.630285, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(120524, 31435, 571, 0, 0, 1, 8, 0, 1, 5848.652, 2096.577, 503.949, 3.368485, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(120525, 31435, 571, 0, 0, 1, 8, 0, 1, 5705.1, 2164.94, 506.448, 5.14872, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(120527, 31435, 571, 0, 0, 1, 8, 0, 1, 5744.73, 2172.21, 505.841, 3.46446, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(120528, 31435, 571, 0, 0, 1, 8, 0, 1, 5788.44, 2198.33, 513.466, 4.15388, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(120529, 31435, 571, 0, 0, 1, 8, 0, 1, 5780.13, 2200.04, 513.765, 4.45059, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31435 (Area: -1 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(120530, 31646, 571, 0, 0, 1, 8, 0, 0, 5818.827, 2034.414, 503.4009, 0.9773844, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344)
+(120531, 31646, 571, 0, 0, 1, 8, 0, 0, 5815.766, 2043.798, 503.3762, 4.153883, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344)
+(120532, 31646, 571, 0, 0, 1, 8, 0, 0, 5788.609, 1993.956, 435.3794, 3.612832, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344)
+(120535, 31646, 571, 0, 0, 1, 8, 0, 0, 5784.868, 2020.841, 491.8832, 0.4363323, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344)
+(120536, 31646, 571, 0, 0, 1, 8, 0, 0, 5763.881, 2043.713, 493.9036, 3.106686, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344)
+(120537, 31646, 571, 0, 0, 1, 8, 0, 0, 5764.212, 2045.802, 501.5097, 5.166174, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344)
+(120538, 31646, 571, 0, 0, 1, 8, 0, 0, 5767.917, 2058.603, 475.9332, 4.433136, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0) (Auras: 42344 - 42344)
+(120539, 31646, 571, 0, 0, 1, 8, 0, 0, 5703.195, 1997.119, 120.5905, 3.665191, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0)
+(120540, 31646, 571, 0, 0, 1, 8, 0, 0, 5685.622, 2088.298, 279.9338, 3.804818, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0)
+(120541, 31646, 571, 0, 0, 1, 8, 0, 0, 5680.397, 2073.604, -20.91908, 1.48353, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007), -- 31646 (Area: -1 - Difficulty: 0)
+(120542, 31646, 571, 0, 0, 1, 8, 0, 0, 5688.017, 2092.321, 455.6302, 2.460914, 120, 0, 0, 0, 0, 0, 0, 0, 0, 14007); -- 31646 (Area: -1 - Difficulty: 0)
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (31435);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(31435, 0, 0, 0, 1, 425, ''); -- 31435
+
+UPDATE `creature` SET `position_x`=5907.302, `position_y`=1998.576, `position_z`=517.1657, `orientation`=2.792527 WHERE `id`=31440;