From 47ba12dba9d355b5a53225830de779a3b0cc5d53 Mon Sep 17 00:00:00 2001 From: Meji Date: Fri, 28 Oct 2022 00:35:08 +0200 Subject: DB/Stormwind: Delete spawns in old Wizards Sanctum Closes #28403 --- sql/updates/world/master/2022_10_28_00_world.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/master/2022_10_28_00_world.sql diff --git a/sql/updates/world/master/2022_10_28_00_world.sql b/sql/updates/world/master/2022_10_28_00_world.sql new file mode 100644 index 00000000000..7190aeb3bb4 --- /dev/null +++ b/sql/updates/world/master/2022_10_28_00_world.sql @@ -0,0 +1,12 @@ +-- Delete spawns from the old Wizard's Sanctum +DELETE FROM creature WHERE guid=313821 AND id=331; +DELETE FROM creature WHERE guid=313822 AND id=2485; +DELETE FROM creature WHERE guid=313823 AND id=5498; +DELETE FROM creature WHERE guid=313832 AND id=5497; +DELETE FROM creature WHERE guid=452762 AND id=89174; + +DELETE FROM gameobject WHERE guid=219959 AND id=197095; +DELETE FROM gameobject WHERE guid=219960 AND id=197094; +DELETE FROM gameobject WHERE guid=219963 AND id=195141; +DELETE FROM gameobject WHERE guid IN (219973,219974,219975,219977) AND id=105174; +DELETE FROM gameobject WHERE guid IN (219976,219978,219979) AND id=105175; -- cgit v1.2.3