diff options
| -rw-r--r-- | sql/updates/world/master/2025_05_20_05_world.sql | 108 |
1 files changed, 108 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_05_20_05_world.sql b/sql/updates/world/master/2025_05_20_05_world.sql new file mode 100644 index 00000000000..81f5a1ac892 --- /dev/null +++ b/sql/updates/world/master/2025_05_20_05_world.sql @@ -0,0 +1,108 @@ +SET @TELEID = 2189; + +DELETE FROM `game_tele` WHERE `id` BETWEEN @TELEID+0 AND @TELEID+101; +INSERT INTO `game_tele` (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, `name`) VALUES +(@TELEID+0, 2986.92, -2222.02, 5.49599, 3.10833, 2291, "DeOtherSideDungeon"), +(@TELEID+1, -6906.7, 1835.29, 5543.49, 2.11886, 2290, "MistsOfTirnaScitheDungeon"), +(@TELEID+2, -7498.49, -577.237, 5445.99, 3.36327, 2222, "DeOtherSide"), +(@TELEID+3, -6942.51, 1765.04, 5552.02, 1.27523, 2222, "MistsOfTirnaScithe"), +(@TELEID+4, 1989.21, -3207.48, 3261.47, 4.0521, 2289, "PlaguefallDungeon"), +(@TELEID+5, 2102.43, -3099.94, 3265.69, 3.91291, 2222, "Plaguefall"), +(@TELEID+6, 2702.98, -2546.27, 3280.1, 0.00367785, 2293, "TheaterOfPainDungeon"), +(@TELEID+7, 2574.9, -2733.72, 3284.52, 0.634391, 2222, "TheaterOfPain"), +(@TELEID+8, -41.5474, 107.145, 133.646, 3.89279, 2690, "TheUnderkeepDelve"), +(@TELEID+9, -311.854, 232.089, 380.783, 2.97151, 2689, "TakRethanAbyssDelve"), +(@TELEID+10, -474.003, -55.0626, 49.8719, 0.247538, 2688, "TheSpiralWeaveDelve"), +(@TELEID+11, -390.734, 279.962, 205.262, 0.90994, 2660, "AraKaraCityOfEchoesDungeon"), +(@TELEID+12, -1608.71, -811.503, -1246.8, 3.54178, 2669, "CityOfThreadsDungeon"), +(@TELEID+13, -2583.97, -532.749, -1158.38, 5.46555, 2657, "NerubarPalaceRaid"), +(@TELEID+14, 662.599, -634.539, -996.923, 0.155043, 2601, "TheSpiralWeave"), +(@TELEID+15, -1807.67, -1304.32, -1502.53, 3.39402, 2601, "TakRethanAbyss"), +(@TELEID+16, -1617.05, -737.502, -1339.77, 3.78718, 2601, "CityOfThreads"), +(@TELEID+17, -2481.37, -1072.88, -1169.45, 3.91784, 2601, "TheUnderkeep"), +(@TELEID+18, -2158.2, -939.166, -1349.31, 2.78525, 2601, "AraKaraCityOfEchoes"), +(@TELEID+19, -2583.42, -532.959, -1158.38, 2.34021, 2601, "NerubarPalace"), +(@TELEID+20, -765.074, 45.5245, 78.1592, 4.87886, 2679, "MycomancerCavernDelve"), +(@TELEID+21, 3221.01, -1501.98, -23.6355, 4.2832, 2601, "MycomancerCavern"), +(@TELEID+22, -48.5667, -225.448, 319.185, 2.15421, 2685, "SkitteringBreachDelve"), +(@TELEID+23, 1556.16, -1072.37, -178.357, 2.08432, 2601, "SkitteringBreach"), +(@TELEID+24, -508.48, -111.222, 143.378, 2.39442, 2686, "NightfallSanctumDelve"), +(@TELEID+25, 2349.72, 1523.98, -149.483, 2.31774, 2601, "NightfallSanctum"), +(@TELEID+26, -148.614, -1494.59, 609.782, 3.19765, 2687, "ZekvirsLairDelve"), +(@TELEID+27, -1975.49, 153.064, -1157.75, 1.53587, 2601, "ZekvirsLair"), +(@TELEID+28, -131.919, 79.8785, 10.1915, 1.57312, 2682, "TheSinkholeDelve"), +(@TELEID+29, 2010.63, 196.074, -837.276, 3.19347, 2601, "TheSinkhole"), +(@TELEID+30, 3021.39, 994.744, 514.287, 1.67613, 2649, "PrioryOfTheSacredFlameDungeon"), +(@TELEID+31, 2205.3, 971.705, 217.978, 5.47838, 2601, "PrioryOfTheSacredFlame"), +(@TELEID+32, 1396.86, -201.691, 1.18164, 5.50669, 2662, "TheDawnbreakerDungeon"), +(@TELEID+33, 1461.23, -144.147, -57.4601, 3.9442, 2601, "TheDawnbreaker"), +(@TELEID+34, 97.291, 313.461, 198.268, 3.14331, 2683, "TheWaterworksDelve"), +(@TELEID+35, 1517.42, -2685.39, 377.637, 3.89835, 2601, "TheWaterworks"), +(@TELEID+36, 1926.28, -2699.62, 358.626, 3.12416, 2773, "OperationFloodgateDungeon"), +(@TELEID+37, 1928.49, -2689.46, 359.188, 0.791401, 2601, "OperationFloodgate"), +(@TELEID+38, 1860.48, 810.205, 333.288, 3.09551, 2710, "AwakeningTheMachineScenario"), +(@TELEID+39, 1432.73, 403.909, 59.6091, 1.59465, 2739, "TheAwakeningVestibule"), +(@TELEID+40, 1432.37, 352.91, 45.9639, 1.56945, 2739, "AuthorizationCorridor"), +(@TELEID+41, 1432.3, 302.787, 45.8607, 1.56945, 2739, "BulwarkOfAuthorization"), +(@TELEID+42, 1433.31, 222.264, 33.4152, 1.56945, 2739, "ProceduralCorridor"), +(@TELEID+43, 1432.69, 150.954, 25.512, 1.56885, 2739, "ProceduralForum"), +(@TELEID+44, 1433.51, 1.10515, 11.4732, 1.5431, 2739, "AnalysisInterface"), +(@TELEID+45, 1432.46, -201.332, 5.48394, 1.55153, 2739, "AwakeningMachine"), +(@TELEID+46, 1433.28, -265.28, 10.7739, 1.56838, 2739, "HallOfAwakening"), +(@TELEID+47, 2293.41, -2774.74, 415.551, 4.68951, 2601, "AwakeningTheMachine"), +(@TELEID+48, -918.403, -5182.81, -262.008, 3.34824, 2815, "ExcavationSite9Delve"), +(@TELEID+49, 244.018, 71.8625, 90.574, 5.36079, 2651, "DarkflameCleftDungeon"), +(@TELEID+50, 2781.31, -3646.52, 370.941, 5.76287, 2601, "DarkflameCleft"), +(@TELEID+51, -260.6, -112.248, 105.065, 5.47018, 2684, "TheDreadPitDelve"), +(@TELEID+52, 2014.43, -4688.94, 321.237, 5.416, 2601, "TheDreadPit"), +(@TELEID+53, 149.908, -0.422643, 358.076, 3.12747, 2652, "TheStonevaultDungeon"), +(@TELEID+54, 3413.06, -2730.08, 331.54, 6.26861, 2601, "TheStonevault"), +(@TELEID+55, 2567.7, -2868.81, 198.808, 3.04949, 2552, "AzjKahetExit"), +(@TELEID+56, -364.965, -1476.53, -1094.45, 5.51726, 2601, "DornogalExit"), +(@TELEID+57, -438.718, -1369.96, -1096.87, 2.75719, 2601, "TheWeaversLair"), +(@TELEID+58, 2019.68, 960.216, 172.391, 2.45946, 2601, "Mereldar"), +(@TELEID+59, 2282.71, -2759.05, 415.551, 4.70026, 2601, "Gundargaz"), +(@TELEID+60, -183.857, -96.1578, 73.2542, 2.34662, 2680, "EarthcrawlMinesDelve"), +(@TELEID+61, 952.118, -1650.39, 83.1676, 2.46046, 2552, "EarthcrawlMines"), +(@TELEID+62, -502.767, -254.067, 378.806, 1.09936, 2664, "FungalFollyDelve"), +(@TELEID+63, 1398.38, -2787.43, 56.0058, 0.753359, 2552, "FungalFolly"), +(@TELEID+64, -1770.61, -3353.87, 6217.99, 4.44929, 2678, "TheTimeways"), +(@TELEID+65, 570.109, 333.519, -6.26111, 1.5592, 2831, "DemolitionDomeDelve"), +(@TELEID+66, 570.09, 338.978, -6.26208, 1.57598, 2706, "DemolitionDomeScenario"), +(@TELEID+67, 2.70845, -1.85624, 109, 6.27244, 2826, "SidestreetSluiceScenario"), +(@TELEID+68, -23.6143, 694.571, -19.5503, 6.27789, 2706, "SidestreetSluice"), +(@TELEID+69, -5.71967, 527.336, 5.90955, 3.85371, 2769, "LiberationOfUndermineRaid"), +(@TELEID+70, 11.9308, 556.647, 5.94898, 3.94342, 2706, "LiberationOfUndermine"), +(@TELEID+71, -350.201, -42.3952, 152.157, 4.7366, 2681, "KriegvalsRestDelve"), +(@TELEID+72, 2707.38, -3621.94, 196.081, 4.68906, 2552, "KriegvalsRest"), +(@TELEID+73, 2651.34, -4845.59, 99.836, 4.70145, 2661, "CinderbrewMeaderyDungeon"), +(@TELEID+74, 2647.39, -4841.31, 95.5765, 4.69169, 2552, "CinderbrewMeadery"), +(@TELEID+75, 2799.96, -2174.89, 266.837, 1.51845, 2648, "TheRookeryDungeon"), +(@TELEID+76, 2800.1, -2199.89, 266.837, 1.58279, 2552, "TheRookery"), +(@TELEID+77, -878.789, -5187.86, -247.984, 3.71552, 2601, "ExcavationSite9"), +(@TELEID+78, 62.3885, -4201.05, 133.13, 4.89584, 2601, "TheVerdantGutters"), +(@TELEID+79, -203.676, -4837.64, -117.608, 3.30866, 2601, "Gutterville"), +(@TELEID+80, -470.391, -4710.14, -148.782, 5.03926, 2601, "TheWrithingFields"), +(@TELEID+81, 49.1846, -4475.58, -106.857, 0.931573, 2601, "Campalot"), +(@TELEID+82, 312.896, -4904.54, -5.01971, 5.54647, 2601, "UndermineExit"), +(@TELEID+83, 288.436, -4862.7, -9.9514, 1.77713, 2601, "GuttersideRocketDeeps"), +(@TELEID+84, -0.224077, 1061.57, 12.2673, 1.57074, 2706, "UndermineEntrance"), +(@TELEID+85, -0.227084, 1009.16, 11.1187, 1.57074, 2706, "SlamCentralStation"), +(@TELEID+86, -486.915, 181.386, 15.4864, 5.56785, 2706, "TheHeapsTWW"), +(@TELEID+87, -486.915, 181.386, 15.4864, 5.56785, 2706, "TheHeapsUndermine"), +(@TELEID+88, -443.49, 384.938, 17.2773, 3.96966, 2706, "VentureCoPayrollOffice"), +(@TELEID+89, -318.564, 725.677, -17.1347, 1.65375, 2706, "TheVatworks"), +(@TELEID+90, -229.841, 508.752, 3.93749, 0.251818, 2706, "Venturewood"), +(@TELEID+91, -301.71, 338.026, 22.8606, 1.30193, 2706, "VenturePlaza"), +(@TELEID+92, -270.051, -108.555, 9.99063, 0.239901, 2706, "EmeraldHillsGolfCourse"), +(@TELEID+93, 86.6536, 249.112, -15.2689, 1.58963, 2706, "PublicParking"), +(@TELEID+94, 362.725, 164.361, -15.8776, 4.07717, 2706, "BlackwaterMarina"), +(@TELEID+95, 371.798, -41.4664, -8.70995, 2.22751, 2706, "PlunderParty"), +(@TELEID+96, 475.835, 119.522, -1.42893, 6.25443, 2706, "PortAuthority"), +(@TELEID+97, 87.6973, 58.8811, 11.463, 1.57246, 2706, "TheGallagio"), +(@TELEID+98, -3.5704, 529.799, 5.8825, 3.92404, 2706, "TheIncontinentalHotel"), +(@TELEID+99, 552.732, 359.874, 15.8225, 3.09149, 2706, "DemolitionDome"), +(@TELEID+100, 234.339, 744.987, 21.41, 5.97332, 2706, "HovelHill"), +(@TELEID+101, 29.8622, 564.178, 3.47762, 0.823072, 2706, "Undermine"); + +UPDATE `game_tele` SET `position_z` = 60.4562 WHERE `id` = 591; -- Corrected Z-axis for teleport `MaldensOrchard` |