DB/Dungeons: Add instance portals for TBC dungeons (#30986)

1 files changed, 43 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_05_26_00_world.sql b/sql/updates/world/master/2025_05_26_00_world.sql
new file mode 100644
index 00000000000..2f8e8defa82
--- /dev/null
+++ b/sql/updates/world/master/2025_05_26_00_world.sql
@@ -0,0 +1,43 @@
+-- Using legacy MoP range for Mejis future plan to move MoP guids
+SET @OGUID := 400610;
+
+-- remove old portals that no longer exist in gameobject_template table
+DELETE FROM `gameobject` WHERE `guid` IN (235180, 235181, 235182, 235183);
+
+-- GameObject
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+33;
+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, 214507, 530, 3519, 3697, '0', 0, 0, -3074.029541015625, 4943.09619140625, -101.047622680664062, 3.150753736495971679, 0, 0, -0.99998950958251953, 0.004580484237521886, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Bone Wastes - Difficulty: 0) CreateObject1
+(@OGUID+1, 214507, 557, 3792, 3792, '1,2,24', 0, 0, 6.456772327423095703, 0.988310277462005615, -0.95433086156845092, 3.12987375259399414, 0, 0, 0.999982833862304687, 0.005859375, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Mana-Tombs - Difficulty: 0) CreateObject1
+(@OGUID+2, 214507, 530, 3519, 3893, '0', 0, 0, -3362.05029296875, 5230.822265625, -101.047866821289062, 4.7205352783203125, 0, 0, -0.70422077178955078, 0.709981083869934082, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Ring of Observance - Difficulty: 0) CreateObject1
+(@OGUID+3, 214507, 558, 3790, 3790, '1,2', 0, 0, -28.731790542602539, 0.089345842599868774, -0.12056674063205718, 6.255642414093017578, 0, 0, -0.01377105712890625, 0.999905169010162353, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Auchenai Crypts - Difficulty: 0) CreateObject1
+(@OGUID+4, 214507, 530, 3519, 3893, '0', 0, 0, -3361.838623046875, 4655.19189453125, -101.047836303710937, 1.571184158325195312, 0, 0, 0.707243919372558593, 0.706969618797302246, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Ring of Observance - Difficulty: 0) CreateObject1
+(@OGUID+5, 214507, 556, 3791, 3791, '1,2', 0, 0, -8.35030555725097656, -0.02197784930467605, 0.007470993790775537, 0, 0, 0, 0, 1, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Sethekk Halls - Difficulty: 0) CreateObject1
+(@OGUID+6, 214507, 530, 3519, 3893, '0', 0, 0, -3649.88720703125, 4942.9677734375, -101.047660827636718, 0.00437355414032936, 0, 0, 0.002186775207519531, 0.999997615814208984, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Ring of Observance - Difficulty: 0) CreateObject1
+(@OGUID+7, 214507, 555, 3789, 3789, '1,2', 0, 0, 7.509288311004638671, -0.1719885915517807, -1.12793421745300292, 3.136808395385742187, 0, 0, 0.999997138977050781, 0.002392079913988709, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Shadow Labyrinth - Difficulty: 0) CreateObject1
+(@OGUID+8, 214500, 530, 3483, 3671, '0', 0, 0, -305.55902099609375, 3167.439208984375, 30.22185897827148437, 5.30146646499633789, 0, 0, -0.47138404846191406, 0.881928086280822753, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Broken Hill - Difficulty: 0) CreateObject1
+(@OGUID+9, 211498, 542, 3713, 3713, '1,2,24', 0, 0, -0.55665802955627441, 25.56830787658691406, -44.7974739074707031, 4.324618339538574218, 0, 0, -0.83009815216064453, 0.55761730670928955, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Blood Furnace - Difficulty: 0) CreateObject1
+(@OGUID+10, 211498, 530, 3483, 3671, '0', 0, 0, -364.529510498046875, 3082.154541015625, -14.7270402908325195, 5.034906387329101562, 0, 0, -0.58439922332763671, 0.8114662766456604, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Broken Hill - Difficulty: 0) CreateObject1
+(@OGUID+11, 211498, 540, 3714, 3714, '1,2,24', 0, 0, -42.0560531616210937, -26.7724895477294921, -13.5153408050537109, 1.469792723655700683, 0, 0, 0.670510292053222656, 0.741900265216827392, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Shattered Halls - Difficulty: 0) CreateObject1
+(@OGUID+12, 211498, 530, 3483, 3671, '0', 0, 0, -310.361114501953125, 3087.479248046875, -3.94746994972229003, 4.630026817321777343, 0, 0, -0.73561859130859375, 0.677395939826965332, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Broken Hill - Difficulty: 0) CreateObject1
+(@OGUID+13, 214500, 543, 3562, 3562, '1,2', 0, 0, -1357.279541015625, 1636.73095703125, 67.63977813720703125, 1.047613859176635742, 0, 0, 0.500180244445800781, 0.865921318531036376, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Hellfire Ramparts - Difficulty: 0) CreateObject1
+(@OGUID+14, 214503, 530, 3521, 3653, '0', 0, 0, 740.59893798828125, 7014.125, -72.7797470092773437, 3.181524276733398437, 0, 0, -0.99980068206787109, 0.019964374601840972, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Serpent Lake - Difficulty: 0) CreateObject1
+(@OGUID+15, 214503, 547, 3717, 3717, '1,2,19', 0, 0, 119.788726806640625, -137.357940673828125, -0.75188785791397094, 1.430738449096679687, 0, 0, 0.655896186828613281, 0.754851102828979492, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Slave Pens - Difficulty: 0) CreateObject1
+(@OGUID+16, 214501, 530, 3521, 3653, '0', 0, 0, 818.2257080078125, 6947.74853515625, -80.6343154907226562, 4.725949287414550781, 0, 0, -0.70229625701904296, 0.711884796619415283, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Serpent Lake - Difficulty: 0) CreateObject1
+(@OGUID+17, 214501, 545, 3715, 3715, '1,2', 0, 0, -23.972970962524414, 5.32714700698852539, -3.87541794776916503, 0.051612861454486846, 0, 0, 0.025803565979003906, 0.999667048454284667, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Steamvault - Difficulty: 0) CreateObject1
+(@OGUID+18, 214500, 530, 3521, 3653, '0', 0, 0, 780.11285400390625, 6745.7587890625, -73.4665069580078125, 1.585187077522277832, 0, 0, 0.712176322937011718, 0.702000617980957031, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Serpent Lake - Difficulty: 0) CreateObject1
+(@OGUID+19, 214500, 546, 3716, 3716, '1,2,24', 0, 0, 4.613999366760253906, -12.3221111297607421, -3.214005708694458, 5.228888988494873046, 0, 0, -0.50307083129882812, 0.864245176315307617, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Underbog - Difficulty: 0) CreateObject1
+(@OGUID+20, 214500, 530, 3523, 3731, '0', 0, 0, 2861.28466796875, 1544.8541259765625, 251.5551300048828125, 0.74720776081085205, 0, 0, 0.364973068237304687, 0.931018054485321044, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Tempest Rift - Difficulty: 0) CreateObject1
+(@OGUID+21, 214500, 554, 3849, 3849, '1,2', 0, 0, 76.48331451416015625, 149.8849029541015625, 25.58076667785644531, 6.266685009002685546, 0, 0, -0.00825023651123046, 0.999965965747833251, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Mechanar - Difficulty: 0) CreateObject1
+(@OGUID+22, 214500, 554, 3849, 3849, '1,2', 0, 0, -38.3058662414550781, 0.16399809718132019, -2.12954640388488769, 0, 0, 0, 0, 1, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Mechanar - Difficulty: 0) CreateObject1
+(@OGUID+23, 214500, 530, 3523, 3842, '0', 0, 0, 3312.87939453125, 1329.907958984375, 504.9810791015625, 1.944811820983886718, 0, 0, 0.826243400573730468, 0.563313245773315429, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Tempest Keep - Difficulty: 0) CreateObject1
+(@OGUID+24, 214501, 552, 3848, 3848, '1,2', 0, 0, -4.00553226470947265, 0.205660983920097351, -0.20550832152366638, 0, 0, 0, 0, 1, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Arcatraz - Difficulty: 0) CreateObject1
+(@OGUID+25, 214500, 530, 3523, 3842, '0', 0, 0, 3415.413330078125, 1481.875, 182.196563720703125, 2.493591785430908203, 0, 0, 0.947969436645507812, 0.318361341953277587, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Tempest Keep - Difficulty: 0) CreateObject1
+(@OGUID+26, 214500, 553, 3847, 3847, '1,2,24', 0, 0, 47.64510726928710937, -35.7330741882324218, -1.09696054458618164, 2.358325958251953125, 0, 0, 0.924286842346191406, 0.3816986083984375, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Botanica - Difficulty: 0) CreateObject1
+(@OGUID+27, 214500, 553, 3847, 3847, '1,2,24', 0, 0, 161.7444915771484375, 391.58758544921875, -36.1445846557617187, 3.191311597824096679, 0, 0, -0.99969100952148437, 0.024856824427843093, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Botanica - Difficulty: Normal) CreateObject1
+(@OGUID+28, 214502, 1, 440, 2300, '0', 0, 0, -8334.7548828125, -4056.623291015625, -207.775665283203125, 3.828966140747070312, 0, 0, -0.94151878356933593, 0.336960494518280029, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Caverns of Time - Difficulty: 0) CreateObject1
+(@OGUID+29, 214502, 560, 2367, 2367, '1,2', 0, 0, 2762.708251953125, 1294.982666015625, 13.77184963226318359, 2.794015407562255859, 0, 0, 0.984936714172363281, 0.172915175557136535, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Old Hillsbrad Foothills - Difficulty: 0) CreateObject1
+(@OGUID+30, 214502, 1, 440, 2300, '0', 0, 0, -8770.576171875, -4170.328125, -212.538055419921875, 4.971632957458496093, 0, 0, -0.60977458953857421, 0.792574882507324218, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: Caverns of Time - Difficulty: 0) CreateObject1
+(@OGUID+31, 214502, 269, 2366, 2366, '1,2', 0, 0, -1493.234375, 7028.02001953125, 29.22995758056640625, 1.380305171012878417, 0, 0, 0.636654853820800781, 0.771148860454559326, 7200, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: The Black Morass - Difficulty: 0) CreateObject1
+(@OGUID+32, 214501, 530, 4080, 0, '0', 0, 0, 12882.4931640625, -7341.705078125, 65.53025054931640625, 1.09095311164855957, 0, 0, 0.518825531005859375, 0.854880154132843017, 120, 255, 1, 60822), -- Instance Portal (Party + Heroic) (Area: 0 - Difficulty: 0) CreateObject1
+(@OGUID+33, 214501, 585, 4131, 4131, '1,2,24', 0, 0, -5.75173616409301757, 0.276041656732559204, -0.23753274977207183, 0, 0, 0, 0, 1, 7200, 255, 1, 60822); -- Instance Portal (Party + Heroic) (Area: Magisters' Terrace - Difficulty: 0) CreateObject1