diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2023-06-11 11:05:13 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-06-11 11:05:13 +0200 |
| commit | 9c3ffd4778eac89817df1766824751d597f71732 (patch) | |
| tree | 3ed61321bb00448800516cf81522930f31b00b96 /sql | |
| parent | 1248efda221006b4c154f1edbd0619e2e4aac69a (diff) | |
DB/Gameobject: Add two missing mailbox in Moonglade Nighthaven
closes #28991 by CraftedRO
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2023_06_11_05_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2023_06_11_05_world.sql b/sql/updates/world/3.3.5/2023_06_11_05_world.sql new file mode 100644 index 00000000000..b305f47a2f4 --- /dev/null +++ b/sql/updates/world/3.3.5/2023_06_11_05_world.sql @@ -0,0 +1,5 @@ +-- Add two missing mailbox in Moonglade Nighthaven +DELETE FROM `gameobject` WHERE `guid` IN (100507, 100508); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(100507, 195218, 1, 0, 0, 1, 1, 8008.7421875, -2668.053955078125, 512.06414794921875, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 0), +(100508, 195219, 1, 0, 0, 1, 1, 7867.26904296875, -2575.546875, 486.91259765625, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 0); |