diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2025_05_27_02_world.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_05_27_02_world.sql b/sql/updates/world/master/2025_05_27_02_world.sql new file mode 100644 index 00000000000..38a62092886 --- /dev/null +++ b/sql/updates/world/master/2025_05_27_02_world.sql @@ -0,0 +1,44 @@ +-- Using legacy MoP range for Mejis future plan to move MoP guids +SET @OGUID := 400652; + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+37; +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, 214500, 571, 4395, 4395, '0', 0, 0, 5676.77099609375, 482.338531494140625, 652.27325439453125, 0.90223020315170288, 0, 0, 0.435969352722167968, 0.899961531162261962, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Dalaran - Difficulty: 0) CreateObject1 +(@OGUID+1, 214500, 608, 4415, 4415, '1,2', 0, 0, 1800.2291259765625, 803.6632080078125, 44.36466598510742187, 0, 0, 0, 0, 1, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Violet Hold - Difficulty: 0) CreateObject1 +(@OGUID+2, 214516, 571, 210, 4658, '0', 0, 0, 8564.9638671875, 792.16839599609375, 558.55181884765625, 0, 0, 0, 0, 1, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Argent Tournament Grounds - Difficulty: 0) CreateObject1 +(@OGUID+3, 214500, 650, 4723, 4723, '1,2', 0, 0, 813.1875, 617.9617919921875, 412.360260009765625, 3.132858037948608398, 0, 0, 0.999990463256835937, 0.004367320332676172, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Trial of the Champion - Difficulty: 0) CreateObject1 +(@OGUID+4, 214500, 649, 4722, 4722, '3,4,5,6', 0, 0, 628.77081298828125, 139.44097900390625, 395.179107666015625, 3.195438861846923828, 0, 0, -0.99963760375976562, 0.026919756084680557, 604800, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Trial of the Crusader - Difficulty: 0) CreateObject1 +(@OGUID+5, 214517, 571, 67, 4547, '0', 0, 0, 8921.5947265625, -967.00177001953125, 1039.16259765625, 4.760039806365966796, 0, 0, -0.69006061553955078, 0.723751604557037353, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Halls of Stone - Difficulty: 0) CreateObject1 +(@OGUID+6, 214517, 599, 4264, 4264, '1,2', 0, 0, 1153.232666015625, 818.140625, 195.3502960205078125, 4.708415031433105468, 0, 0, -0.70851039886474609, 0.705700397491455078, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Halls of Stone - Difficulty: 0) CreateObject1 +(@OGUID+7, 214502, 571, 67, 4445, '0', 0, 0, 9189.9677734375, -1391.21875, 1110.215087890625, 2.37534642219543457, 0, 0, 0.927501678466796875, 0.37381899356842041, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Ulduar - Difficulty: 0) CreateObject1 +(@OGUID+8, 214517, 602, 4272, 4272, '1,2,24', 0, 0, 1331.43408203125, 276.255218505859375, 52.81052398681640625, 4.712505817413330078, 0, 0, -0.70706558227539062, 0.70714801549911499, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Halls of Lightning - Difficulty: 0) CreateObject1 +(@OGUID+9, 214503, 571, 66, 66, '0', 0, 0, 6971.3046875, -4401.05224609375, 444.913970947265625, 3.928673505783081054, 0, 0, -0.92355728149414062, 0.383460521697998046, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Zul'Drak - Difficulty: 0) CreateObject1 +(@OGUID+10, 214501, 604, 4416, 4416, '1,2,24', 0, 0, 1899.4879150390625, 658.967041015625, 176.9906768798828125, 4.560480594635009765, 0, 0, -0.75872421264648437, 0.651411950588226318, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Gundrak - Difficulty: 0) CreateObject1 +(@OGUID+11, 214501, 604, 4416, 4416, '1,2,24', 0, 0, 1896.73095703125, 826.1319580078125, 176.6334381103515625, 1.577661633491516113, 0, 0, 0.709529876708984375, 0.704675376415252685, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Gundrak - Difficulty: 0) CreateObject1 +(@OGUID+12, 214501, 604, 4416, 4416, '1,2,24', 0, 0, 1913.5035400390625, 644.94268798828125, 135.141326904296875, 6.256378650665283203, 0, 0, -0.01340293884277343, 0.999910175800323486, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Gundrak - Difficulty: 0) CreateObject1 +(@OGUID+13, 214501, 604, 4416, 4416, '1,2,24', 0, 0, 1981.8385009765625, 842.90802001953125, 135.2064971923828125, 3.168937444686889648, 0, 0, -0.99990653991699218, 0.013671875, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Gundrak - Difficulty: 0) CreateObject1 +(@OGUID+14, 214503, 571, 66, 4375, '0', 0, 0, 6700.95849609375, -4661.88525390625, 444.127410888671875, 0.76585012674331665, 0, 0, 0.373635292053222656, 0.92757570743560791, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Gundrak - Difficulty: 0) CreateObject1 +(@OGUID+15, 214507, 571, 66, 4316, '0', 0, 0, 4774.55126953125, -2021.1007080078125, 230.6461639404296875, 4.716822147369384765, 0, 0, -0.70553779602050781, 0.70867234468460083, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Rageclaw Den - Difficulty: 0) CreateObject1 +(@OGUID+16, 214501, 600, 4196, 4196, '1,2', 0, 0, -518.60589599609375, -479.0850830078125, 10.97215080261230468, 5.371007919311523437, 0, 0, -0.44044017791748046, 0.897781968116760253, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Drak'Tharon Keep - Difficulty: 0) CreateObject1 +(@OGUID+17, 214507, 571, 495, 0, '0', 0, 0, 1233.796875, -4860.28125, 218.2938079833984375, 0.288675248622894287, 0, 0, 0.14383697509765625, 0.989601373672485351, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+18, 214501, 571, 495, 0, '0', 0, 0, 1234.9896240234375, -4860.0537109375, 41.24821090698242187, 3.454191207885742187, 0, 0, -0.98781013488769531, 0.155663534998893737, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+19, 214516, 575, 1196, 1196, '1,2', 0, 0, 589.875, -328.03472900390625, 110.1481170654296875, 3.126213550567626953, 0, 0, 0.999970436096191406, 0.007689460646361112, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Utgarde Pinnacle - Difficulty: 0) CreateObject1 +(@OGUID+20, 214501, 574, 206, 206, '1,2,24', 0, 0, 149.6649322509765625, -87.6336822509765625, 12.55168342590332031, 0.280033588409423828, 0, 0, 0.139559745788574218, 0.990213632583618164, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Utgarde Keep - Difficulty: 0) CreateObject1 +(@OGUID+21, 214516, 571, 65, 0, '0', 0, 0, 3640.241455078125, 2029.015625, 2.593230724334716796, 1.183689117431640625, 0, 0, 0.557892799377441406, 0.829913020133972167, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1 +(@OGUID+22, 214500, 571, 65, 4158, '0', 0, 0, 3670.163330078125, 2174.109375, 36.07420730590820312, 5.46730804443359375, 0, 0, -0.39671802520751953, 0.91794055700302124, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Stars' Rest - Difficulty: 0) CreateObject1 +(@OGUID+23, 214500, 601, 4277, 4405, '1,2,24', 0, 0, 408.196197509765625, 799.328125, 832.26446533203125, 5.260144233703613281, 0, 0, -0.48950386047363281, 0.872001111507415771, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Passage of Lost Fiends - Difficulty: 0) CreateObject1 +(@OGUID+24, 214516, 619, 4494, 4623, '1,2', 0, 0, 334.036468505859375, -1109.638916015625, 69.77443695068359375, 0.642534375190734863, 0, 0, 0.315769195556640625, 0.948836028575897216, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Hall of the Conquered Kings - Difficulty: 0) CreateObject1 +(@OGUID+25, 214516, 619, 4494, 4627, '1,2', 0, 0, 523.37152099609375, -301.123260498046875, 68.3013916015625, 4.633084774017333984, 0, 0, -0.73458194732666015, 0.678519964218139648, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Fallen Temple of Ahn'kahet - Difficulty: Normal) CreateObject1 +(@OGUID+26, 214507, 571, 3537, 4024, '0', 0, 0, 3869.944580078125, 6984.1240234375, 108.6140365600585937, 0.048577312380075454, 0, 0, 0.024286270141601562, 0.999705016613006591, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Coldarra - Difficulty: 0) CreateObject1 +(@OGUID+27, 214507, 571, 3537, 4024, '0', 0, 0, 3900.703125, 6985.35791015625, 69.4878387451171875, 3.172844171524047851, 0, 0, -0.9998779296875, 0.015625, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Coldarra - Difficulty: 0) CreateObject1 +(@OGUID+28, 214507, 576, 4265, 4265, '1,2,24', 0, 0, 145.9954376220703125, -15.9139137268066406, -16.6529922485351562, 1.564889073371887207, 0, 0, 0.705015182495117187, 0.709192216396331787, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Nexus - Difficulty: 0) CreateObject1 +(@OGUID+29, 214501, 571, 210, 4522, '0', 0, 0, 5586.41845703125, 2005.595458984375, 798.041259765625, 0.694440603256225585, 0, 0, 0.340285301208496093, 0.940322279930114746, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Icecrown Citadel - Difficulty: 0) CreateObject1 +(@OGUID+30, 214501, 571, 210, 4522, '0', 0, 0, 5675.2412109375, 1998.107666015625, 798.041259765625, 2.247296094894409179, 0, 0, 0.901683807373046875, 0.432395994663238525, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Icecrown Citadel - Difficulty: 0) CreateObject1 +(@OGUID+31, 214503, 571, 210, 4522, '0', 0, 0, 5627.88525390625, 1963.49658203125, 803.0205078125, 1.486795425415039062, 0, 0, 0.676793098449707031, 0.736173272132873535, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Icecrown Citadel - Difficulty: 0) CreateObject1 +(@OGUID+32, 214501, 632, 4809, 4809, '1,2,24', 0, 0, 4925.3359375, 2170.21875, 638.75244140625, 2.015316009521484375, 0, 0, 0.845583915710449218, 0.53384256362915039, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Forge of Souls - Difficulty: 0) CreateObject1 +(@OGUID+33, 214500, 658, 4813, 4904, '1,2', 0, 0, 424.289947509765625, 212.454864501953125, 529.874267578125, 0, 0, 0, 0, 1, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Dark Approach - Difficulty: 0) CreateObject1 +(@OGUID+34, 214501, 668, 4820, 4820, '1,2', 0, 0, 5231.7021484375, 1924.75, 707.69476318359375, 0.812954843044281005, 0, 0, 0.395376205444335937, 0.918519258499145507, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Halls of Reflection - Difficulty: 0) CreateObject1 +(@OGUID+35, 214500, 1, 440, 2300, '0', 0, 0, -8757.2548828125, -4462.50341796875, -201.095672607421875, 1.456737637519836425, 0, 0, 0.665653228759765625, 0.746261179447174072, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Caverns of Time - Difficulty: 0) CreateObject1 +(@OGUID+36, 214500, 595, 4100, 4100, '1,2', 0, 0, 1427.4566650390625, 564.11114501953125, 37.64373779296875, 5.112773895263671875, 0, 0, -0.55237102508544921, 0.83359837532043457, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Culling of Stratholme - Difficulty: 0) CreateObject1 +(@OGUID+37, 214500, 595, 4100, 4100, '1,2', 0, 0, 2238.314208984375, 1473.84033203125, 132.3636932373046875, 0.477078080177307128, 0, 0, 0.236283302307128906, 0.971684217453002929, 7200, 255, 1, 60822); -- Instance Portal (Party + Heroic) (Area: The Culling of Stratholme - Difficulty: Normal) CreateObject1 |