diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2017-06-01 00:06:42 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-06-01 00:06:42 +0200 |
| commit | f6b0f58760f420260760b1efa454ebc30fda81aa (patch) | |
| tree | 0b122f04430a02b7d9f95fe12bad3cfd6a64ab0e | |
| parent | 5236e6ee22cb3efec138552d9a1a174a748ffb5a (diff) | |
DB/Gameobject: Spawn some missing portals
By ArcaneFox
Updates #19155
Closes #12746
| -rw-r--r-- | sql/updates/world/master/2017_06_01_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_06_01_00_world.sql b/sql/updates/world/master/2017_06_01_00_world.sql new file mode 100644 index 00000000000..e6c495949c8 --- /dev/null +++ b/sql/updates/world/master/2017_06_01_00_world.sql @@ -0,0 +1,9 @@ +-- Cataclysm spawns +SET @C_OGUID:=200624; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @C_OGUID+0 AND @C_OGUID+3; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@C_OGUID+0, 207692, 0, 0, 0, 1, 169, 0, -8212.33, 399.0208, 117.273, 1.649333, 0, 0, 0.7343216, 0.6788017, 120, 255, 1, 23420), -- Portal to Hyjal (Area: Stormwind City) +(@C_OGUID+1, 207693, 0, 0, 0, 1, 169, 0, -8223.319, 451.1823, 117.4883, 3.141593, 0, 0, -1, 0, 120, 255, 1, 23420), -- Portal to Deepholm (Area: Stormwind City) +(@C_OGUID+2, 207695, 0, 0, 0, 1, 169, 0, -8233.281, 415.5955, 117.4477, 3.839726,-0.02000666, 0.01454353,-0.9395018, 0.3416499, 120, 255, 1, 23420), -- Portal to Uldum (Area: Stormwind City) +(@C_OGUID+3, 207694, 0, 0, 0, 1, 169, 0, -8186.149, 413.7292, 116.7497, 2.722713, 0, 0, 0.9781475, 0.2079121, 120, 255, 1, 23420); -- Portal to Twilight Highlands (Area: The Eastern Earthshrine) |