diff options
| author | Killyana <morphone1@gmail.com> | 2017-11-24 14:56:24 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-02-15 19:13:25 +0100 |
| commit | c14cb276e6ed280362bcefcce15dde84912b4bf9 (patch) | |
| tree | 55293364422f307cd593a08154f1c02a660e34af | |
| parent | 7835c5ff97c7c1c58e4d94d2af98f709c43aa9fd (diff) | |
DB/Misc: Death knights area rework part5
Original work done by Grz3s on Cmangos
(cherry picked from commit b70a923714d8a6afc7850010404c8ed3f238803f)
| -rw-r--r-- | sql/updates/world/master/2021_02_08_07_world_2017_11_24_00_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_02_08_07_world_2017_11_24_00_world.sql b/sql/updates/world/master/2021_02_08_07_world_2017_11_24_00_world.sql new file mode 100644 index 00000000000..92e682bbc9f --- /dev/null +++ b/sql/updates/world/master/2021_02_08_07_world_2017_11_24_00_world.sql @@ -0,0 +1,18 @@ +-- +-- Phase: 128 (master: PhsaeId: 176) +-- Duplicates Removed +DELETE FROM `creature` WHERE `guid` IN (130365,130370,130364,130374,130372,130377,130367,130375,130366,130361,130371); +DELETE FROM `creature_addon` WHERE `guid` IN (130365,130370,130364,130374,130372,130377,130367,130375,130366,130361,130371); + +UPDATE `creature` SET `PhaseId` = 176, `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 130400; +UPDATE `creature` SET `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 130401; +UPDATE `creature` SET `spawndist` = 20, `MovementType` = 1 WHERE `id` = 29189; +UPDATE `creature` SET `PhaseId` = 176 WHERE `guid` IN (130387,130419); +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE `guid` IN (130368,130369); + +-- Howling Geist +UPDATE `creature` SET `position_x` = 2597.903076, `position_y` = -5549.420410, `position_z` = 159.772934, `spawndist` = 20, `MovementType` = 1 WHERE `guid` = 130387; +UPDATE `creature` SET `position_x` = 2622.867432, `position_y` = -5481.481934, `position_z` = 156.948212, `spawndist` = 20, `MovementType` = 1 WHERE `guid` = 130386; +UPDATE `creature` SET `position_x` = 2659.806885, `position_y` = -5537.375000, `position_z` = 163.303589, `spawndist` = 20, `MovementType` = 1 WHERE `guid` = 130385; +UPDATE `creature` SET `position_x` = 2697.650391, `position_y` = -5469.664063, `position_z` = 156.943970, `spawndist` = 20, `MovementType` = 1 WHERE `guid` = 130383; +UPDATE `creature` SET `position_x` = 2735.920410, `position_y` = -5363.948730, `position_z` = 157.715302, `spawndist` = 20, `MovementType` = 1 WHERE `guid` = 130381; |