DB/GameTele: Add teleport destinations to Kul Tiras and Zandalar

Closes #23926

1 files changed, 99 insertions, 0 deletions

diff --git a/sql/updates/world/master/2019_11_18_00_world.sql b/sql/updates/world/master/2019_11_18_00_world.sql
new file mode 100644
index 00000000000..88892e551cc
--- /dev/null
+++ b/sql/updates/world/master/2019_11_18_00_world.sql
@@ -0,0 +1,99 @@
+DELETE FROM `game_tele` WHERE `id` BETWEEN 1584 AND 1678;
+INSERT INTO `game_tele` (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, `name`) VALUES 
+(1584,  4067.27, -2387.29,  94.7891, 1.55312, 1265, 'TheDarkPortalWoDIntro'),
+(1585, -849.908,  4461.17,  735.661, 4.04535, 1220, 'DalaranLegion'),
+(1586, -2969.05,  8761.87, -133.601, 2.29119, 1669, 'AntoranWastes'),
+(1587,  2866.45, -4567.44,  291.949, 0.09268, 1712, 'LegionAntorus'),
+(1588,  3094.91,  1062.63,  242.580, 4.91188, 1107, 'HallWarlock'),
+(1589,  1561.02,  1399.94,  237.108, 1.69284, 1519, 'HallDemon'),
+(1590,  1126.24,  1069.48,  3.55888, 6.11568, 1469, 'HallShaman'),
+(1591,  4113.75,  7459.81,  48.2315, 0.90767, 1220, 'HallDruid'),
+(1592,  4529.88,  5246.98,  862.193, 3.05573, 1220, 'HallHunter'),
+(1593,  2373.48, -5356.95,  52.5833, 2.45032,    0, 'HallPaladin'),
+(1594, -927.239,  4501.06,  700.750, 3.98971, 1220, 'HallRogue'),
+(1595, -1502.45,  1060.68,  260.416, 4.14701, 1220, 'HallDK'),
+(1596,  1028.47,  7225.17,  100.181, 1.53734, 1479, 'HallWarrior'),
+(1597,  885.306,  3605.37,  192.230, 6.26366, 1514, 'HallMonk'),
+(1598, -844.000,  4759.00,  918.000, 0.58600, 1513, 'HallMage'),
+(1599,  3811.66,  6344.61,  185.366, 0.90025, 1220, 'Darkheart'),
+(1600,  288.381,  3352.23,  145.444, 2.35153, 1220, 'NightborneSpawn'),
+(1601,  2121.00,  3318.00,  54.7061, 0.08726, 1865, 'VoidElfSpawn'),
+(1602,  458.823,  1449.61,  757.573, 0.46642, 1860, 'LightForgeSpawn'),
+(1603,  3476.55,  7644.04, -9.69075, 3.32378, 1501, 'BlackRookHoldDungeon'),
+(1604, -3914.34,  4540.62,  86.5838, 5.77318, 1456, 'EyeOfAzsharaDungeon'),
+(1605,  3801.21,  529.078,  603.332, 3.13103, 1477, 'HallsOfValorDungeon'),
+(1606,  3498.26,  4806.19,  590.072, 3.09508, 1516, 'TheArcwayDungeon'),
+(1607,  3247.98,  1828.70,  236.767, 3.17381, 1466, 'DarkheartThicketDungeon'),
+
+(1608,  744.752, -279.092,  51.4723, 5.03383, 1643, 'Boralus'),
+(1609, -604.097, -346.101,  158.319, 6.20878, 1643, 'TiragardeSoundSouth'),
+(1610,  803.021,  1055.27,  82.9621, 0.75812, 1643, 'TiragardeSoundNorth'),
+(1611,  803.021,  1055.27,  82.9621, 0.75812, 1643, 'Norwingtonestate'),
+(1612,  1194.16,  14.1010,  31.8158, 6.08705, 1643, 'Hatherford'),
+(1613,  1117.42, -616.504,  28.6896, 1.60791, 1643, 'Tradewindsmarket'),
+(1614, -78.5352, -1045.81,  81.1101, 1.54351, 1643, 'Bridgeport'),
+(1615, -900.847, -644.461,  117.909, 5.69906, 1643, 'Kenningslodge'),
+(1616, -1867.57, -630.503,  69.2350, 6.27240, 1643, 'Freehold'),
+(1617,  15.8090, -2630.14,  21.7049, 5.35348, 1643, 'Toldagor'),
+(1618,  843.727,  1889.46,  1.80116, 1.48775, 1643, 'Anglepointwharf'),
+(1619,  1628.21,  1979.77,  287.126, 4.03716, 1643, 'Waningglacier'),
+(1620, -634.310,  3140.37,  323.537, 4.79820, 1643, 'Drustvar'),
+(1621, -634.310,  3140.37,  323.537, 4.79820, 1643, 'AromsStand'),
+(1622, -1506.48,  3738.69,  5.19285, 0.89398, 1643, 'FalconHurst'),
+(1623, -894.820,  3894.99,  46.6605, 5.79488, 1643, 'CrimsonForest'),
+(1624,  235.226,  3639.17,  144.125, 5.61188, 1643, 'Corlain'),
+(1625,  732.936,  3951.12,  103.689, 3.51487, 1643, 'WhiteGroveChapel'),
+(1626,  781.619,  3372.67,  232.653, 3.04754, 1643, 'WaycrestManor'),
+(1627, -1393.93,  1869.16,  165.127, 5.93701, 1643, 'Golkoval'),
+(1628, -1037.11,  1288.53,  6.45362, 0.49027, 1643, 'FletchersHollow'),
+(1629, -907.231,  901.773,  137.704, 3.69470, 1643, 'Vigilhill'),
+(1630, -633.812,  1886.54,  108.488, 3.11272, 1643, 'BarrowknollCemetery'),
+(1631, -76.5705,  2142.74,  46.0968, 4.77541, 1643, 'Fallhaven'),
+(1632,  151.653,  1631.31,  1.86995, 0.07873, 1643, 'CarversHarbor'),
+(1633,  3320.00,  1436.64,  42.8554, 6.27945, 1643, 'Fortdaelin'),
+(1634,  2992.30,  913.202,  14.6972, 4.13925, 1643, 'Deadwash'),
+(1635,  2382.24,  810.858,  187.912, 0.09051, 1643, 'BriarbackKraul'),
+(1636,  2507.29, -19.8540,  54.8577, 0.06694, 1643, 'Brennadam'),
+(1637,  2507.29, -19.8540,  54.8577, 0.06694, 1643, 'StormSongValley'),
+(1638,  2944.04, -552.242,  35.3453, 0.23580, 1643, 'MarinersStrand'),
+(1639,  3627.15, -123.231,  103.417, 0.19653, 1643, 'SageHold'),
+(1640,  3913.98,  484.440,  116.258, 2.94150, 1643, 'WarfangHold'),
+(1641,  4155.56, -1102.78,  158.203, 4.84216, 1643, 'ShrineOfTheStorm'),
+
+(1642,  1401.12,  3454.52,  304.343, 6.13001, 1642, 'Voldun'),
+(1643,  1401.12,  3454.52,  304.343, 6.13001, 1642, 'Atulaman'),
+(1644,  248.175,  3065.86,  190.847, 3.13764, 1642, 'TempleOfAkunda'),
+(1645,  630.240,  4398.85,  10.4407, 5.47578, 1642, 'PortOfZemlan'),
+(1646,  630.240,  4398.85,  10.4407, 5.47578, 1642, 'Zemlan'),
+(1647,  1950.08,  4774.83,  94.2362, 4.70609, 1642, 'TerraceOfTheDevoted'),
+(1648,  2839.28,  4186.72,  9.82509, 4.71394, 1642, 'ShatterStoneHarbor'),
+(1649,  2062.77,  2835.96,  50.0255, 4.93385, 1642, 'VulperaHideaway'),
+(1650,  3161.08,  3151.26,  121.588, 3.15884, 1642, 'Slitheringgulch'),
+(1651,  3360.42,  2492.46,  43.0992, 5.45221, 1642, 'TortakaRefuge'),
+(1652,  2570.42,  1367.40,  19.7588, 3.16277, 1642, 'TheNecropolis'),
+(1653,  2590.94,  477.193,  7.83524, 5.48754, 1642, 'TorgasRest'),
+(1654,  2454.33, -321.230,  58.3264, 2.36165, 1642, 'Nazwatha'),
+(1655,  1623.26, -772.918,  3.03343, 1.73726, 1642, 'KragwasBurrow'),
+(1656,  1396.03,  721.395, -3.03710, 0.99113, 1642, 'Nazmir'),
+(1657,  1396.03,  721.395, -3.03710, 0.99113, 1642, 'HeartOfDarkness'),
+(1658,  1620.67,  1369.17,  20.9743, 3.16905, 1642, 'TerraceOfSorrow'),
+(1659,  1742.18,  2241.74,  71.1635, 3.89240, 1642, 'Shoaljaitarpits'),
+(1660,  770.899,  1378.48,  19.5498, 6.25409, 1642, 'ZuljanRuins'),
+(1661,  45.5614,  1820.03,  354.431, 4.33223, 1642, 'GardenOfTheLoa'),
+(1662, -805.100,  1962.61,  720.338, 2.10169, 1642, 'Ataldazar'),
+(1663, -2597.48,  2051.26,  40.2295, 3.11879, 1642, 'Xibala'),
+(1664, -1064.70,  804.266,  500.265, 6.27136, 1642, 'Dazaralor'),
+(1665, -251.441,  188.628,  220.887, 0.26070, 1642, 'Talgurub'),
+(1666,  370.382,  83.4939,  236.697, 0.32353, 1642, 'NesingwaryStrek'),
+(1667,  465.986, -803.327,  21.1768, 1.43801, 1642, 'Zebahari'),
+(1668, -836.323, -1176.19,  0.83125, 0.99582, 1642, 'Atalgral'),
+(1669, -1580.37, -1198.01,  1.72586, 3.93243, 1642, 'TalanjisRebuke'),
+(1670, -477.316,  576.838,  220.353, 3.15488, 1642, 'Zuldazar'),
+(1671,  625.044,  1253.41,  99.8346, 6.27532, 1841, 'TheUnderrot'),
+(1672, -848.182,  2073.24,  725.145, 1.51788, 1763, 'AtaldazarDungeon'),
+(1673, -1583.32, -1005.08,  73.8218, 2.46825, 1754, 'FreeHoldDungeon'),
+(1674,  4167.20, -1238.53,  186.894, 4.73095, 1864, 'ShrineOfTheStormDungeon'),
+(1675,  3192.07,  3150.86,  121.327, 0.01091, 1877, 'TempleOfSethralissDungeon'),
+(1676,  3169.07,  3151.21,  121.542, 6.28316, 1642, 'TempleOfSethraliss'),
+(1677,  86.4305, -2928.49,  1.71303, 1.32861, 1771, 'TolDagorDungeon'),
+(1678, -624.060, -259.431,  236.030, 0.00859, 1862, 'WaycrestManorDungeon');