From a290f49fcebc1c89afd2add289aac41b805f421c Mon Sep 17 00:00:00 2001 From: Wyrserth Date: Sat, 20 Jul 2019 22:43:20 +0200 Subject: 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) --- sql/updates/world/master/2021_12_16_21_world_2019_07_20_05_world.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/master/2021_12_16_21_world_2019_07_20_05_world.sql (limited to 'sql') 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; -- cgit v1.2.3