aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2024-09-29 11:20:28 +0200
committerGitHub <noreply@github.com>2024-09-29 11:20:28 +0200
commitc5663d554eb015e4f50d6e8f823781b09ff8a4c8 (patch)
tree992a5c8eccd1f5904861f7840bd150bbbd9290b7
parentb18ba61140cbb2c26eb5d006826eb61097f44726 (diff)
DB/Misc: Fix Alliance GY when dying in Thunder Bluff
closes #30272 by CraftedRO
-rw-r--r--sql/updates/world/3.3.5/2024_09_29_00_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_09_29_00_world.sql b/sql/updates/world/3.3.5/2024_09_29_00_world.sql
new file mode 100644
index 00000000000..b293fc29fea
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_09_29_00_world.sql
@@ -0,0 +1,6 @@
+-- Deletes Ratchet as Ally GY when dying in Thunder Bluff
+DELETE FROM `graveyard_zone` WHERE `ID`= 249 AND `GhostZone`= 1638;
+-- Adds Bloodhoof Village as Ally GY when dying in Thunder Bluff
+DELETE FROM `graveyard_zone` WHERE `ID`= 89 AND `GhostZone`= 1638;
+INSERT INTO `graveyard_zone` (`ID`, `GhostZone`, `Faction`, `Comment`) VALUES
+(89, 1638, 469, 'Mulgore, Bloodhoof Village GY - Mulgore');