diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2024-06-27 20:08:47 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-06-27 20:08:47 +0200 |
| commit | 81c247f0cfa13cb975a65da0a86e030503a08d2b (patch) | |
| tree | bb120f39723256c1148c91e724c909eb603aa8d6 | |
| parent | c5a9ab65af58c8642f914c31f327f09ca3a0ce0c (diff) | |
DB/Misc: Fix Maraudon graveyard
closes #30056 by CraftedRO
| -rw-r--r-- | sql/updates/world/3.3.5/2024_06_27_02_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_06_27_02_world.sql b/sql/updates/world/3.3.5/2024_06_27_02_world.sql new file mode 100644 index 00000000000..df2c01f0db0 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_06_27_02_world.sql @@ -0,0 +1,10 @@ +-- Desolace, Sar'theris Strand GY +DELETE FROM `graveyard_zone` WHERE `ID` = 1422 AND `GhostZone` = 2100; +INSERT INTO `graveyard_zone` (`ID`, `GhostZone`, `Faction`, `Comment`) VALUES +(1422,2100,0,"Desolace, Sar'theris Strand GY"); + +-- Also delete most likely wrong linked GY +DELETE FROM `graveyard_zone` WHERE `ID`=31 AND `GhostZone`=2100; + +-- Ghost Walker Post Spirit Healer Update +UPDATE `creature` SET `position_x`=-1432.9971923828125, `position_y`=1973.572265625, `position_z`=86.70270538330078125, `orientation`=3.246312379837036132, `spawntimesecs`=120, `VerifiedBuild`=55141 WHERE `guid`=40568 AND `id`=6491; |