diff options
| -rw-r--r-- | sql/updates/world/master/2025_06_01_00_world.sql | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_06_01_00_world.sql b/sql/updates/world/master/2025_06_01_00_world.sql new file mode 100644 index 00000000000..d26c0ee6e6d --- /dev/null +++ b/sql/updates/world/master/2025_06_01_00_world.sql @@ -0,0 +1,35 @@ +-- Using legacy MoP range for Mejis future plan to move MoP guids +SET @OGUID := 400690; + +-- Remove old versions of a few portal gobs (correct entry, incorrect data) +DELETE FROM `gameobject` WHERE `guid` IN (235566, 223196, 237455); + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+25; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 214501, 0, 5145, 5382, '0', 0, 0, -5584.6943359375, 5401.23681640625, -1796.6551513671875, 2.392457962036132812, 0, 0, 0.930665969848632812, 0.365869969129562377, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Abyssal Maw - Difficulty: 0) CreateObject1 +(@OGUID+1, 214517, 643, 5004, 5004, '1,2,8,23,24', 0, 0, -647.28302001953125, 806.74652099609375, 249.3487701416015625, 0, 0, 0, 0, 1, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Throne of the Tides - Difficulty: 0) CreateObject1 +(@OGUID+2, 214612, 1, 440, 2300, '0', 0, 0, -8291.689453125, -4591.2255859375, -228.515213012695312, 1.712306499481201171, 0, 0, 0.755327224731445312, 0.655347824096679687, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Caverns of Time - Difficulty: 0) CreateObject1 +(@OGUID+3, 214517, 940, 5844, 5988, '2', 0, 0, 4927.52978515625, 333.630218505859375, 105.3840713500976562, 4.826143741607666015, 0, 0, -0.66576671600341796, 0.746159970760345458, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: The Crystal Vice - Difficulty: 0) CreateObject1 +(@OGUID+4, 214503, 1, 440, 2300, '0', 0, 0, -8286.2470703125, -4455.61962890625, -208.512664794921875, 3.656076431274414062, 0, 0, -0.96709537506103515, 0.254414081573486328, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Caverns of Time - Difficulty: 0) CreateObject1 +(@OGUID+5, 214501, 938, 5789, 5796, '2,24', 0, 0, 3731.799560546875, -425.93402099609375, 113.7673721313476562, 1.654860377311706542, 0, 0, 0.736194610595703125, 0.676769852638244628, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Entryway of Time - Difficulty: 0) CreateObject1 +(@OGUID+6, 214503, 1, 440, 2300, '0', 0, 0, -8595.0537109375, -3994.935791015625, -205.550567626953125, 4.497562885284423828, 0, 0, -0.77883815765380859, 0.627224922180175781, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Caverns of Time - Difficulty: 0) CreateObject1 +(@OGUID+7, 214516, 939, 5788, 5993, '2', 0, 0, 3247.62060546875, -5006.37353515625, 194.093475341796875, 2.370447635650634765, 0, 0, 0.926583290100097656, 0.376089662313461303, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Courtyard of Lights - Difficulty: 0) CreateObject1 +(@OGUID+8, 214503, 646, 5042, 5303, '0', 0, 0, 1029.13720703125, 618.685791015625, 155.705810546875, 1.775328516960144042, 0, 0, 0.775599479675292968, 0.631225347518920898, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Temple of Earth - Difficulty: 0) CreateObject1 +(@OGUID+9, 214503, 725, 5088, 5088, '1,2,24', 0, 0, 822.98089599609375, 986.263916015625, 318.806427001953125, 0, 0, 0, 0, 1, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: The Stonecore - Difficulty: 0) CreateObject1 +(@OGUID+10, 214517, 530, 3433, 3508, '0', 0, 0, 6851.22216796875, -7998.955078125, 192.361602783203125, 1.565658450126647949, 0, 0, 0.705287933349609375, 0.708920955657958984, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Amani Pass - Difficulty: 0) CreateObject1 +(@OGUID+11, 214517, 568, 3805, 3805, '1,2', 0, 0, 120.6857681274414062, 1780.2899169921875, 43.82334136962890625, 4.701598167419433593, 0, 0, -0.71091175079345703, 0.703281223773956298, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Zul'Aman - Difficulty: 0) CreateObject1 +(@OGUID+12, 214501, 2241, 10833, 13176, '0', 0, 0, -11522.107421875, -2317.23779296875, 608.69842529296875, 0.633985102176666259, 0, 0, 0.311710357666015625, 0.950177192687988281, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: The Vortex Pinnacle - Difficulty: 0) CreateObject1 +(@OGUID+13, 214501, 1, 5034, 5717, '0', 0, 0, -11519.76953125, -2315.382080078125, 608.41595458984375, 0.707777321338653564, 0, 0, 0.346548080444335937, 0.938032209873199462, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Vir'naal River Delta - Difficulty: 0) CreateObject1 +(@OGUID+14, 214501, 657, 5035, 5035, '1,2,8,23,24', 0, 0, -327.982635498046875, 24.9375, 627.73846435546875, 3.925194263458251953, 0, 0, -0.92422294616699218, 0.381853342056274414, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: The Vortex Pinnacle - Difficulty: 0) CreateObject1 +(@OGUID+15, 214503, 2241, 10833, 10882, '0', 0, 0, -10217.646484375, -1838.0677490234375, 20.63434600830078125, 0, 0, 0, 0, 1, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Halls of Origination - Difficulty: 0) CreateObject1 +(@OGUID+16, 214503, 1, 5034, 0, '0', 0, 0, -10217.4912109375, -1838.1666259765625, 20.12780189514160156, 0, 0, 0, 0, 1, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+17, 214517, 644, 4945, 4945, '1,2', 0, 0, -954.05035400390625, 457.196197509765625, 52.04623794555664062, 1.56303417682647705, 0, 0, 0.704357147216796875, 0.709845721721649169, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Halls of Origination - Difficulty: 0) CreateObject1 +(@OGUID+18, 214507, 2241, 10833, 0, '0', 0, 0, -10686.310546875, -1308.8021240234375, 17.68829345703125, 0.23668566346168518, 0, 0, 0.118066787719726562, 0.993005692958831787, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+19, 214507, 1, 5034, 0, '0', 0, 0, -10686.4755859375, -1308.90625, 18.13622665405273437, 0.253729909658432006, 0, 0, 0.126524925231933593, 0.991963446140289306, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+20, 214507, 755, 5396, 5635, '1,2,24', 0, 0, -10688.3095703125, -1309.4600830078125, 17.60331344604492187, 3.399094581604003906, 0, 0, -0.99172306060791015, 0.128395453095436096, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: The Warlord's Garrison - Difficulty: 0) CreateObject1 +(@OGUID+21, 214516, 0, 33, 1740, '0', 0, 0, -11916.25, -1216.4879150390625, 92.28725433349609375, 1.56024169921875, 0, 0, 0.703365325927734375, 0.710828542709350585, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Venture Co. Base Camp - Difficulty: 0) CreateObject1 +(@OGUID+22, 214516, 859, 1977, 1977, '1,2', 0, 0, -11916.232421875, -1220.93408203125, 92.28725433349609375, 4.712449073791503906, 0, 0, -0.70708560943603515, 0.707127928733825683, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Zul'Gurub - Difficulty: 0) CreateObject1 +(@OGUID+23, 214501, 645, 4926, 4926, '1,2,24', 0, 0, 214.7916717529296875, 1140.1492919921875, 206.5569305419921875, 4.672245979309082031, 0, 0, -0.72115612030029296, 0.692772567272186279, 7200, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Blackrock Caverns - Difficulty: 0) CreateObject1 +(@OGUID+24, 214501, 0, 4922, 5462, '0', 0, 0, -4048.010498046875, -3446.210205078125, 283.368743896484375, 3.493097305297851562, 0, 0, -0.98459529876708984, 0.17484883964061737, 120, 255, 1, 61122), -- Instance Portal (Party + Heroic) (Area: Wyrms' Bend - Difficulty: 0) CreateObject1 +(@OGUID+25, 214503, 670, 4950, 4950, '1,2,8,23', 0, 0, -627.81597900390625, -176.515625, 272.126556396484375, 4.976002216339111328, 0, 0, -0.60804176330566406, 0.793905019760131835, 7200, 255, 1, 61122); -- Instance Portal (Party + Heroic) (Area: Grim Batol - Difficulty: 0) CreateObject1 |