diff options
| author | Wyrserth <wyrserth@protonmail.com> | 2019-07-20 22:43:20 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-16 23:14:03 +0100 |
| commit | a290f49fcebc1c89afd2add289aac41b805f421c (patch) | |
| tree | 4f07d81d9808b2e96af8fce9bf86829175de32b6 | |
| parent | 3e7f31a3a46fb11fc1a028f0927d4e4d2fe2e1e5 (diff) | |
DB/Creature: remove deprecated spawns of NPCs Lady Liadrin, Peacekeeper Jadar and Investigator Asric in Shattrath, and move Arcanist Savan to his correct position in the Scryer's Tier.
(cherry picked from commit 3837440f1fa4c40056760d72639b4e00bb36a639)
| -rw-r--r-- | sql/updates/world/master/2021_12_16_21_world_2019_07_20_05_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_16_21_world_2019_07_20_05_world.sql b/sql/updates/world/master/2021_12_16_21_world_2019_07_20_05_world.sql new file mode 100644 index 00000000000..d6d7ac2fb8f --- /dev/null +++ b/sql/updates/world/master/2021_12_16_21_world_2019_07_20_05_world.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `creature` WHERE `guid`=3413 AND `id`=17076; +DELETE FROM `creature` WHERE `id` IN (23719, 23079); +UPDATE `creature` SET `position_x`=-2139.32, `position_y`=5552.883, `position_z`=50.38232, `orientation`=0.2617994 WHERE `id`=23272; |