aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormeji46 <meji46@users.noreply.github.com>2021-10-09 17:48:41 +0300
committeroffl <offl@users.noreply.github.com>2021-10-09 17:48:41 +0300
commit58de22cbe62f70375af8a4ac8280c6cbc23367b2 (patch)
tree5f0758209aa463c4f130086f0b999d293ffea71d
parent708db54673d381dcf03500d3cd4b544a62682b68 (diff)
DB/Misc: Corrections to Stormwind graveyards
Closes #27032 Credit for research - ratkosrb
-rw-r--r--sql/updates/world/3.3.5/2021_10_09_00_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_10_09_00_world.sql b/sql/updates/world/3.3.5/2021_10_09_00_world.sql
new file mode 100644
index 00000000000..052636740a8
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_10_09_00_world.sql
@@ -0,0 +1,4 @@
+-- Stormwind graveyard for the Alliance
+UPDATE `graveyard_zone` SET `ID`=106, `Comment`='Elwynn Forest, Goldshire - Stormwind' WHERE `ID`=107 AND `GhostZone`=1519;
+-- Champions' Hall is no longer a separate zone
+DELETE FROM `graveyard_zone` WHERE `ID`=107 AND `GhostZone`=2918;