DB/Creature: Alliance Brigadier General & Horde Warbringer waypoints in Wintergrasp Forteresse

1 files changed, 18 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_12_09_03_world.sql b/sql/updates/world/3.3.5/2019_12_09_03_world.sql
new file mode 100644
index 00000000000..d0d7a3b5b26
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_12_09_03_world.sql
@@ -0,0 +1,18 @@
+-- 
+UPDATE `creature` SET `MovementType`=2, `spawndist`=0 WHERE `guid` IN (12548, 131839);
+UPDATE `creature_addon` SET `path_id`=125480 WHERE `guid`IN (12548, 131839);
+
+DELETE FROM `waypoint_data` WHERE `id` IN (125480);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(125480, 1, 5466.9599, 2847.219, 418.6759, 1.600639, 0, 0, 0, 100, 0),
+(125480, 2, 5462.2539, 2859.512, 418.6759, 2.103294, 0, 0, 0, 100, 0),
+(125480, 3, 5449.2954, 2867.745, 418.6759, 3.010430, 0, 0, 0, 100, 0),
+(125480, 4, 5428.8813, 2867.707, 418.6759, 3.308881, 0, 0, 0, 100, 0),
+(125480, 5, 5416.9375, 2857.756, 418.6759, 4.058936, 0, 0, 0, 100, 0),
+(125480, 6, 5412.1484, 2842.477, 418.6759, 4.600855, 0, 0, 0, 100, 0),
+(125480, 7, 5414.3408, 2828.859, 418.6759, 5.146702, 0, 0, 0, 100, 0),
+(125480, 8, 5424.5141, 2815.667, 418.6759, 5.743592, 0, 0, 0, 100, 0),
+(125480, 9, 5439.1206, 2812.936, 418.6759, 6.195192, 0, 0, 0, 100, 0),
+(125480, 10, 5455.7231, 2816.125, 418.6759, 0.442150, 0, 0, 0, 100, 0),
+(125480, 11, 5466.2690, 2825.763, 418.6759, 1.467095, 0, 0, 0, 100, 0),
+(125480, 12, 5467.5898, 2841.060, 418.7579, 1.396260, 0, 0, 0, 100, 0);