aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-05-19 00:28:33 +0300
committeroffl <offl@users.noreply.github.com>2021-05-19 00:28:33 +0300
commited6b3ee6e0e365c70c9f447d35aa90a3d5bb0e05 (patch)
tree61d14c1ba1e9a9f574cd856fc61502a2c2829776
parent895ec09adfda1741ea8e3cb09a429933923462fa (diff)
DB/GameObject: Remove handmade spawns of Arthas' Tears
Closes #26114
-rw-r--r--sql/updates/world/3.3.5/2021_05_18_01_world_335.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_05_18_01_world_335.sql b/sql/updates/world/3.3.5/2021_05_18_01_world_335.sql
new file mode 100644
index 00000000000..c36949e90bb
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_05_18_01_world_335.sql
@@ -0,0 +1,5 @@
+--
+DELETE FROM `pool_members` WHERE `type` = 1 AND `spawnId` IN (16022,15968);
+DELETE FROM `spawn_group` WHERE `spawnType` = 1 AND `spawnId` IN (16022,15968);
+DELETE FROM `gameobject_addon` WHERE `guid` IN (16022,15968);
+DELETE FROM `gameobject` WHERE `guid` IN (16022,15968) AND `id` = 142141;