diff options
| author | Serpaa <Serpaa@users.noreply.github.com> | 2017-10-21 12:48:17 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-10-21 12:48:17 +0200 |
| commit | 90f2c474adb17545829f32c055bebe700295ca6e (patch) | |
| tree | cb840b27a023dfb8832bd18b5d15aa9c4c385b64 | |
| parent | 39e1a73e2552afd0c9af359220c164869d75349c (diff) | |
DB/Misc: Tirisfal Glades creature
Closes #20666
| -rw-r--r-- | sql/updates/world/3.3.5/2017_10_21_05_world_335.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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; |