From 90f2c474adb17545829f32c055bebe700295ca6e Mon Sep 17 00:00:00 2001 From: Serpaa Date: Sat, 21 Oct 2017 12:48:17 +0200 Subject: DB/Misc: Tirisfal Glades creature Closes #20666 --- sql/updates/world/3.3.5/2017_10_21_05_world_335.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_10_21_05_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_10_21_05_world_335.sql b/sql/updates/world/3.3.5/2017_10_21_05_world_335.sql new file mode 100644 index 00000000000..9fe6590dcea --- /dev/null +++ b/sql/updates/world/3.3.5/2017_10_21_05_world_335.sql @@ -0,0 +1,8 @@ +-- +-- Fix random movement of Lost Souls +UPDATE `creature` SET `spawndist`=6, `MovementType`=1 WHERE `guid` IN (44863, 44864); +-- Correct waypoints of Nissa Agamand +UPDATE `waypoint_data` SET `orientation`=0.7703, `delay`=45000 WHERE `id`=449900 AND `point`=1; +UPDATE `waypoint_data` SET `orientation`=1.3075, `delay`=25000 WHERE `id`=449900 AND `point`=14; +-- Reposition broken Scarlet Warrior +UPDATE `creature` SET `position_z`=37.2094 WHERE `guid`=38336; -- cgit v1.2.3