DB/Creature: Fixed gossip menus for Exodar guards

Ref #17414

1 files changed, 435 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_29_08_world_exodar.sql b/sql/updates/world/master/2022_07_29_08_world_exodar.sql
new file mode 100644
index 00000000000..4b818b17049
--- /dev/null
+++ b/sql/updates/world/master/2022_07_29_08_world_exodar.sql
@@ -0,0 +1,435 @@
+SET @TGUID := 510000;
+
+-- Exodar Peacekeeper | Shield of Velen | Vigilant Defender (Exodar)
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=16733;
+UPDATE `creature_template` SET `gossip_menu_id`=7777, `minlevel`=60, `maxlevel`=60, `unit_flags3`=8388608 WHERE `entry`=20674;
+UPDATE `creature_template` SET `gossip_menu_id`=7777, `minlevel`=60, `maxlevel`=60, `faction`=1639, `npcflag`=1, `BaseAttackTime`=1500, `unit_flags`=32768, `unit_flags2`=2048, `unit_flags3`=8388608 WHERE `entry`=176650;
+
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (12334, 13869, 20969, 20971, 20972);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(12334,17331,-1),
+(13869,20039,-1),
+(20969,17793,-1),
+(20971,@TGUID+0,-1),
+(20972,@TGUID+1,-1);
+
+DELETE FROM `npc_text` WHERE `ID` BETWEEN @TGUID+0 AND @TGUID+1;
+INSERT INTO `npc_text` (`ID`, `Probability0`, `BroadcastTextID0`, `VerifiedBuild`) VALUES
+(@TGUID+0,1,129378,-1),
+(@TGUID+1,1,129396,-1);
+
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=5316, `ActionPoiID`=1868 WHERE `MenuID`=7777 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1866 WHERE `MenuID`=7777 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=5330, `ActionPoiID`=1865 WHERE `MenuID`=7777 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1881 WHERE `MenuID`=7777 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1869 WHERE `MenuID`=7777 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=2026 WHERE `MenuID`=7777 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=8508, `ActionPoiID`=1890 WHERE `MenuID`=7777 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7786, `ActionPoiID`=1880 WHERE `MenuID`=7777 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2868, `ActionMenuID`=7787, `ActionPoiID`=0 WHERE `MenuID`=7777 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2869, `ActionMenuID`=7788 WHERE `MenuID`=7777 AND `OptionID`=9;
+UPDATE `gossip_menu_option` SET `OptionText`='Other Continents', `OptionBroadcastTextId`=5914, `ActionMenuID`=20971 WHERE `MenuID`=7777 AND `OptionID`=10;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2914, `ActionPoiID`=1891 WHERE `MenuID`=7787 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2924, `ActionPoiID`=1887 WHERE `MenuID`=7787 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2902, `ActionPoiID`=1876 WHERE `MenuID`=7787 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2922, `ActionPoiID`=1877 WHERE `MenuID`=7787 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2918, `ActionPoiID`=1875 WHERE `MenuID`=7787 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3450, `ActionPoiID`=1872 WHERE `MenuID`=7787 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2910, `ActionPoiID`=1889 WHERE `MenuID`=7787 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2952, `ActionPoiID`=1879 WHERE `MenuID`=7788 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=44649, `ActionMenuID`=12334, `ActionPoiID`=2537 WHERE `MenuID`=7788 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2942, `ActionMenuID`=7797, `ActionPoiID`=1886 WHERE `MenuID`=7788 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3006, `ActionMenuID`=7798, `ActionPoiID`=1871 WHERE `MenuID`=7788 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2943, `ActionMenuID`=7799, `ActionPoiID`=1867 WHERE `MenuID`=7788 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2949, `ActionMenuID`=7800, `ActionPoiID`=1874 WHERE `MenuID`=7788 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3005, `ActionMenuID`=7801, `ActionPoiID`=1873 WHERE `MenuID`=7788 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2950, `ActionMenuID`=7802, `ActionPoiID`=1878 WHERE `MenuID`=7788 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=31542, `ActionMenuID`=10016, `ActionPoiID`=2275 WHERE `MenuID`=7788 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=15267, `ActionMenuID`=7803, `ActionPoiID`=1870 WHERE `MenuID`=7788 AND `OptionID`=9;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2947, `ActionMenuID`=7804, `ActionPoiID`=1884 WHERE `MenuID`=7788 AND `OptionID`=10;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2944, `ActionMenuID`=7805, `ActionPoiID`=1885 WHERE `MenuID`=7788 AND `OptionID`=11;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2948, `ActionMenuID`=7806, `ActionPoiID`=1883 WHERE `MenuID`=7788 AND `OptionID`=12;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2951, `ActionMenuID`=7807, `ActionPoiID`=1882 WHERE `MenuID`=7788 AND `OptionID`=13;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2945, `OptionType`=1, `OptionNpcFlag`=1, `ActionPoiID`=2052, `ActionMenuID`=8399 WHERE `MenuID`=7788 AND `OptionID`=14;
+UPDATE `gossip_menu_option` SET `VerifiedBuild`=44325 WHERE `MenuID` IN (7777, 7787, 7788);
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=7786;
+
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=7777 AND `OptionID`=11;
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=7787 AND `OptionID`=7;
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=20971 AND `OptionID`=1;
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
+(7777, 11, 0, 'Outside to Azuremyst Isle', 129395, 1, 1, 0, 20972, 5243, 0, 0, NULL, 0, 44325),
+(7787, 7, 0, 'Monk', 61793, 1, 1, 0, 13869, 2772, 0, 0, NULL, 0, 44325),
+(20971, 1, 0, 'Stormwind City in the Eastern Kingdoms', 129225, 1, 1, 0, 20969, 6114, 0, 0, NULL, 0, 44325);
+
+DELETE FROM `points_of_interest` WHERE `ID` BETWEEN 10190 AND 10218;
+DELETE FROM `points_of_interest` WHERE `ID` IN (10263, 10264);
+DELETE FROM `points_of_interest` WHERE `ID` IN (1865, 1866, 1867, 1868, 1869, 1870, 1871, 1872, 1873, 1874, 1875, 1876, 1877, 1878, 1879, 1880, 1881, 1882, 1883, 1884, 1885, 1886, 1887, 1889, 1890, 1891, 2026, 2052, 2275, 2537, 2772, 5243, 6114);
+INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `PositionZ`, `Icon`, `Flags`, `Importance`, `Name`, `Unknown905`, `VerifiedBuild`) VALUES
+(1865, -3865.607666015625, -11640.78125, -137.653472900390625, 7, 99, 0, 'Exodar, Hippogryph Master', 0, 44325),
+(1866, -3918.909912109375, -11550.099609375, -150.15899658203125, 7, 99, 0, 'Exodar, Bank', 0, 44325),
+(1867, -4259.47021484375, -11643.7998046875, -140.376007080078125, 7, 99, 0, 'Exodar, Engineering', 0, 44325),
+(1868, -4020.989990234375, -11733.5, -151.832000732421875, 7, 99, 0, 'Exodar, Auctioneer', 0, 44325),
+(1869, -3761.469970703125, -11696.2001953125, -109.706001281738281, 7, 99, 0, 'Exodar, Inn', 0, 44325),
+(1870, -3785.75, -11544, -138.729995727539062, 7, 99, 0, 'Exodar, Jewelcrafting', 0, 44325),
+(1871, -3885.77001953125, -11492.400390625, -136.15899658203125, 7, 99, 0, 'Exodar, Enchanting', 0, 44325),
+(1872, -3848.489990234375, -11392.7001953125, -107.78900146484375, 7, 99, 0, 'Exodar, Shaman Trainer', 0, 44325),
+(1873, -3726.260009765625, -11387.099609375, -138.707000732421875, 7, 99, 0, 'Exodar, Fishing', 0, 44325),
+(1874, -3766.02001953125, -11477.7001953125, -138.73199462890625, 7, 99, 0, 'Exodar, First Aid', 0, 44325),
+(1875, -3975.489990234375, -11486.099609375, -137.248001098632812, 7, 99, 0, 'Exodar, Priest Trainers', 0, 44325),
+(1876, -4048.610107421875, -11559.900390625, -139.253997802734375, 7, 99, 0, 'Exodar, Mage Trainers', 0, 44325),
+(1877, -4178.41015625, -11477, -130.884002685546875, 7, 99, 0, 'Exodar, Paladin Trainers', 0, 44325),
+(1878, -4050.219970703125, -11360, -140.501998901367187, 7, 99, 0, 'Exodar, Herbalism', 0, 44325),
+(1879, -4043.389892578125, -11364.7998046875, -140.501007080078125, 7, 99, 0, 'Exodar, Alchemy', 0, 44325),
+(1880, -4000.5400390625, -11372.099609375, -124.702003479003906, 7, 99, 0, 'Exodar, Battlemasters', 0, 44325),
+(1881, -4099.7998046875, -11630, -138.76300048828125, 7, 99, 0, 'Exodar, Guild Master', 0, 44325),
+(1882, -4092.56005859375, -11743.7998046875, -139.145004272460937, 7, 99, 0, 'Exodar, Tailoring', 0, 44325),
+(1883, -4137.330078125, -11761.7998046875, -135.828994750976562, 7, 99, 0, 'Exodar, Skinning', 0, 44325),
+(1884, -4138.509765625, -11768.5, -135.828994750976562, 7, 99, 0, 'Exodar, Leatherworking', 0, 44325),
+(1885, -4223.68017578125, -11694.7001953125, -142.337997436523437, 7, 99, 0, 'Exodar, Mining', 0, 44325),
+(1886, -4241.27001953125, -11713.5, -142.298004150390625, 7, 99, 0, 'Exodar, Blacksmithing', 0, 44325),
+(1887, -4239.43017578125, -11558.2001953125, -124.777000427246093, 7, 99, 0, 'Exodar, Hunter Trainers', 0, 44325),
+(1889, -4194.43994140625, -11649.099609375, -98.43890380859375, 7, 99, 0, 'Exodar, Warrior Trainers', 0, 44325),
+(1890, -3792.050048828125, -11703.7001953125, -108.532997131347656, 7, 99, 0, 'Exodar, Stable Master', 0, 44325),
+(1891, -4272.52978515625, -11495.5, 9.426659584045410156, 7, 99, 0, 'Exodar, Druid Trainer', 0, 44325),
+(2026, -3913.489990234375, -11607.599609375, -138.343994140625, 7, 99, 0, 'Exodar, Mailbox', 0, 44325),
+(2052, -3798.6201171875, -11654.5, -106.150001525878906, 7, 99, 0, 'Exodar, Cooking', 0, 44325),
+(2275, -3887.389892578125, -11485, -136.154006958007812, 7, 99, 0, 'Exodar, Inscription', 0, 44325),
+(2537, -4077.320068359375, -11421.900390625, -141.457000732421875, 7, 99, 0, 'Exodar, Archaeology', 0, 44325),
+(2772, -4189.17041015625, -11644.0537109375, -99.625518798828125, 7, 99, 0, 'Exodar, Monk Trainers', 0, 44325),
+(5243, -3866.580078125, -11736.599609375, -107.258003234863281, 7, 99, 0, 'Exodar, Exit to Azuremyst Isle', 0, 44325),
+(6114, -4050.6201171875, -11577.400390625, -138.55499267578125, 7, 99, 0, 'Portal to Stormwind City', 0, 44325);
+
+
+DELETE FROM `points_of_interest_locale` WHERE `ID` IN (1865, 1866, 1867, 1868, 1869, 1870, 1871, 1872, 1873, 1874, 1875, 1876, 1877, 1878, 1879, 1880, 1881, 1882, 1883, 1884, 1885, 1886, 1887, 1889, 1890, 1891, 2026, 2052, 2275, 2537, 2772, 5243, 6114);
+INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(1865, 'deDE', 'Hippogryphenmeister der Exodar', 44325),
+(1865, 'esES', 'El Exodar, maestro de hipogrifos', 44325),
+(1865, 'esMX', 'El Exodar, maestro de hipogrifos', 44325),
+(1865, 'frFR', 'Maître des hippogriffes de l''Exodar', 44325),
+(1865, 'itIT', 'Maestro degli Ippogrifi di Exodar', 44325),
+(1865, 'koKR', '엑소다르 히포그리프 조련사', 44325),
+(1865, 'ptBR', 'Exodar, Mestre de Hipogrifos', 44325),
+(1865, 'ruRU', 'Экзодаркий укротитель гиппогрифо', 44325), -- Экзодаркий укротитель гиппогрифов (truncated)
+(1865, 'zhCN', '埃索达角鹰兽管理员', 44325),
+(1865, 'zhTW', '艾克索達，角鷹獸管理員', 44325),
+(1866, 'deDE', 'Bank der Exodar', 44325),
+(1866, 'esES', 'El Exodar, banco', 44325),
+(1866, 'esMX', 'El Exodar, banco', 44325),
+(1866, 'frFR', 'Banque de l''Exodar', 44325),
+(1866, 'itIT', 'Banca di Exodar', 44325),
+(1866, 'koKR', '엑소다르 은행', 44325),
+(1866, 'ptBR', 'Exodar, Banco', 44325),
+(1866, 'ruRU', 'Экзодар: банк', 44325),
+(1866, 'zhCN', '埃索达银行', 44325),
+(1866, 'zhTW', '艾克索達，銀行', 44325),
+(1867, 'deDE', 'Ingenieurskunst der Exodar', 44325),
+(1867, 'esES', 'El Exodar, ingeniería', 44325),
+(1867, 'esMX', 'El Exodar, ingeniería', 44325),
+(1867, 'frFR', 'Ingénierie de l''Exodar', 44325),
+(1867, 'itIT', 'Ingegneria di Exodar', 44325),
+(1867, 'koKR', '엑소다르 전문 기계공학자', 44325),
+(1867, 'ptBR', 'Exodar, Engenharia', 44325),
+(1867, 'ruRU', 'Экзодар: инженерное дело', 44325),
+(1867, 'zhCN', '埃索达技师', 44325),
+(1867, 'zhTW', '艾克索達，工程學', 44325),
+(1868, 'deDE', 'Auktionator der Exodar', 44325),
+(1868, 'esES', 'El Exodar, subastador', 44325),
+(1868, 'esMX', 'El Exodar, subastador', 44325),
+(1868, 'frFR', 'Commissaire-priseur de l''Exodar', 44325),
+(1868, 'itIT', 'Casa d''Aste di Exodar', 44325),
+(1868, 'koKR', '엑소다르 경매인', 44325),
+(1868, 'ptBR', 'Exodar, Leiloeiro', 44325),
+(1868, 'ruRU', 'Экзодар: аукционер', 44325),
+(1868, 'zhCN', '埃索达拍卖行', 44325),
+(1868, 'zhTW', '艾克索達，拍賣師', 44325),
+(1869, 'deDE', 'Gasthaus der Exodar', 44325),
+(1869, 'esES', 'El Exodar, posada', 44325),
+(1869, 'esMX', 'El Exodar, posada', 44325),
+(1869, 'frFR', 'Auberge de l''Exodar', 44325),
+(1869, 'itIT', 'Locanda di Exodar', 44325),
+(1869, 'koKR', '엑소다르 여관', 44325),
+(1869, 'ptBR', 'Exodar, Estalagem', 44325),
+(1869, 'ruRU', 'Таверна Экзодара', 44325),
+(1869, 'zhCN', '埃索达旅店', 44325),
+(1869, 'zhTW', '艾克索達，旅店', 44325),
+(1870, 'deDE', 'Juwelierskunst der Exodar', 44325),
+(1870, 'esES', 'El Exodar, joyería', 44325),
+(1870, 'esMX', 'El Exodar, joyería', 44325),
+(1870, 'frFR', 'Joaillerie de l''Exodar', 44325),
+(1870, 'itIT', 'Oreficeria di Exodar', 44325),
+(1870, 'koKR', '엑소다르 전문 보석세공인', 44325),
+(1870, 'ptBR', 'Exodar, Joalheria', 44325),
+(1870, 'ruRU', 'Экзодар: ювелиры', 44325),
+(1870, 'zhCN', '埃索达珠宝训练师', 44325),
+(1870, 'zhTW', '艾克索達，珠寶設計', 44325),
+(1871, 'deDE', 'Verzauberkunst der Exodar', 44325),
+(1871, 'esES', 'El Exodar, encantamiento', 44325),
+(1871, 'esMX', 'El Exodar, encantamiento', 44325),
+(1871, 'frFR', 'Enchantement de l''Exodar', 44325),
+(1871, 'itIT', 'Incantamento di Exodar', 44325),
+(1871, 'koKR', '엑소다르 전문 마법부여사', 44325),
+(1871, 'ptBR', 'Exodar, Encantamento', 44325),
+(1871, 'ruRU', 'Экзодар: зачаровыватели', 44325),
+(1871, 'zhCN', '埃索达附魔训练师', 44325),
+(1871, 'zhTW', '艾克索達，附魔', 44325),
+(1872, 'deDE', 'Schamanenlehrer der Exodar', 44325),
+(1872, 'esES', 'El Exodar, instructor de chamanes', 44325),
+(1872, 'esMX', 'El Exodar, instructor de chamanes', 44325),
+(1872, 'frFR', 'Maître des chamans de l''Exodar', 44325),
+(1872, 'itIT', 'Istruttore degli Sciamani di Exodar', 44325),
+(1872, 'koKR', '엑소다르 상급 주술사', 44325),
+(1872, 'ptBR', 'Exodar, Treinamento de Xamãs', 44325),
+(1872, 'ruRU', 'Экзодар: наставник шаманов', 44325),
+(1872, 'zhCN', '埃索达萨满祭司训练师', 44325),
+(1872, 'zhTW', '艾克索達，薩滿訓練師', 44325),
+(1873, 'deDE', 'Angellehrer der Exodar', 44325),
+(1873, 'esES', 'El Exodar, pesca', 44325),
+(1873, 'esMX', 'El Exodar, pesca', 44325),
+(1873, 'frFR', 'Pêche de l''Exodar', 44325),
+(1873, 'itIT', 'Pesca di Exodar', 44325),
+(1873, 'koKR', '엑소다르 낚시꾼', 44325),
+(1873, 'ptBR', 'Exodar, Pesca', 44325),
+(1873, 'ruRU', 'Экзодар: учитель рыбной ловли', 44325),
+(1873, 'zhCN', '埃索达钓鱼训练师', 44325),
+(1873, 'zhTW', '艾克索達，釣魚', 44325),
+(1874, 'deDE', 'Erste Hilfe der Exodar', 44325),
+(1874, 'esES', 'El Exodar, primeros auxilios', 44325),
+(1874, 'esMX', 'El Exodar, primeros auxilios', 44325),
+(1874, 'frFR', 'Secourisme de l''Exodar', 44325),
+(1874, 'itIT', 'Pronto Soccorso di Exodar', 44325),
+(1874, 'koKR', '엑소다르 응급치료사', 44325),
+(1874, 'ptBR', 'Exodar, Primeiros Socorros', 44325),
+(1874, 'ruRU', 'Экзодар: учитель первой помощи', 44325),
+(1874, 'zhCN', '埃索达急救训练师', 44325),
+(1874, 'zhTW', '艾克索達，急救訓練師', 44325),
+(1875, 'deDE', 'Priesterlehrer der Exodar', 44325),
+(1875, 'esES', 'El Exodar, instructores de sacerdotes', 44325),
+(1875, 'esMX', 'El Exodar, instructores de sacerdotes', 44325),
+(1875, 'frFR', 'Maître des prêtres de l''Exodar', 44325),
+(1875, 'itIT', 'Istruttore dei Sacerdoti di Exodar', 44325),
+(1875, 'koKR', '엑소다르 상급 사제', 44325),
+(1875, 'ptBR', 'Exodar, Treinamento de Sacerdotes', 44325),
+(1875, 'ruRU', 'Экзодар: наставники жрецов', 44325),
+(1875, 'zhCN', '埃索达牧师训练师', 44325),
+(1875, 'zhTW', '艾克索達，牧師訓練師', 44325),
+(1876, 'deDE', 'Magierlehrer der Exodar', 44325),
+(1876, 'esES', 'El Exodar, instructores de magos', 44325),
+(1876, 'esMX', 'El Exodar, instructores de magos', 44325),
+(1876, 'frFR', 'Maître des mages de l''Exodar', 44325),
+(1876, 'itIT', 'Istruttore dei Maghi di Exodar', 44325),
+(1876, 'koKR', '엑소다르 상급 마법사', 44325),
+(1876, 'ptBR', 'Exodar, Treinamento de Magos', 44325),
+(1876, 'ruRU', 'Экзодар: наставники магов', 44325),
+(1876, 'zhCN', '埃索达法师训练师', 44325),
+(1876, 'zhTW', '艾克索達，法師訓練師', 44325),
+(1877, 'deDE', 'Paladinlehrer der Exodar', 44325),
+(1877, 'esES', 'El Exodar, instructores de paladines', 44325),
+(1877, 'esMX', 'El Exodar, instructores de paladines', 44325),
+(1877, 'frFR', 'Maître des paladins de l''Exodar', 44325),
+(1877, 'itIT', 'Istruttore dei Paladini di Exodar', 44325),
+(1877, 'koKR', '엑소다르 상급 성기사', 44325),
+(1877, 'ptBR', 'Exodar, Treinamento de Paladinos', 44325),
+(1877, 'ruRU', 'Экзодар: наставники паладинов', 44325),
+(1877, 'zhCN', '埃索达圣骑士训练师', 44325),
+(1877, 'zhTW', '艾克索達，聖騎士訓練師', 44325),
+(1878, 'deDE', 'Kräuterkundelehrer der Exodar', 44325),
+(1878, 'esES', 'El Exodar, herboristería', 44325),
+(1878, 'esMX', 'El Exodar, herboristería', 44325),
+(1878, 'frFR', 'Herboristerie de l''Exodar', 44325),
+(1878, 'itIT', 'Erbalismo di Exodar', 44325),
+(1878, 'koKR', '엑소다르 전문 약초채집사', 44325),
+(1878, 'ptBR', 'Exodar, Herborismo', 44325),
+(1878, 'ruRU', 'Экзодар: учитель травничества', 44325),
+(1878, 'zhCN', '埃索达草药学训练师', 44325),
+(1878, 'zhTW', '艾克索達，草藥學', 44325),
+(1879, 'deDE', 'Alchemielehrer der Exodar', 44325),
+(1879, 'esES', 'El Exodar, alquimia', 44325),
+(1879, 'esMX', 'El Exodar, alquimia', 44325),
+(1879, 'frFR', 'Alchimie de l''Exodar', 44325),
+(1879, 'itIT', 'Alchimia di Exodar', 44325),
+(1879, 'koKR', '엑소다르 전문 연금술사', 44325),
+(1879, 'ptBR', 'Exodar, Alquimia', 44325),
+(1879, 'ruRU', 'Алхимик Экзодара', 44325),
+(1879, 'zhCN', '埃索达炼金训练师', 44325),
+(1879, 'zhTW', '艾克索達，鍊金術', 44325),
+(1880, 'deDE', 'Kampfmeister der Exodar', 44325),
+(1880, 'esES', 'El Exodar, maestros de batalla', 44325),
+(1880, 'esMX', 'El Exodar, maestros de batalla', 44325),
+(1880, 'frFR', 'Maîtres de guerre de l''Exodar', 44325),
+(1880, 'itIT', 'Maestri di Guerra di Exodar', 44325),
+(1880, 'koKR', '엑소다르 전투모병관', 44325),
+(1880, 'ptBR', 'Exodar, Mestres de Batalha', 44325),
+(1880, 'ruRU', 'Экзодар: военачальники', 44325),
+(1880, 'zhCN', '埃索达军官', 44325),
+(1880, 'zhTW', '艾克索達，戰場軍官', 44325),
+(1881, 'deDE', 'Gildenmeister der Exodar', 44325),
+(1881, 'esES', 'El Exodar, maestro de hermandad', 44325),
+(1881, 'esMX', 'El Exodar, maestro de hermandad', 44325),
+(1881, 'frFR', 'Maître des guildes de l''Exodar', 44325),
+(1881, 'itIT', 'Mastro di Gilda di Exodar', 44325),
+(1881, 'koKR', '엑소다르 길드 사무관', 44325),
+(1881, 'ptBR', 'Exodar, Mestre de Guildas', 44325),
+(1881, 'ruRU', 'Экзодар: регистрация гильдий', 44325),
+(1881, 'zhCN', '埃索达公会管理员', 44325),
+(1881, 'zhTW', '艾克索達，公會註冊員', 44325),
+(1882, 'deDE', 'Schneiderei der Exodar', 44325),
+(1882, 'esES', 'El Exodar, sastrería', 44325),
+(1882, 'esMX', 'El Exodar, sastrería', 44325),
+(1882, 'frFR', 'Couture de l''Exodar', 44325),
+(1882, 'itIT', 'Sartoria di Exodar', 44325),
+(1882, 'koKR', '엑소다르 전문 재봉사', 44325),
+(1882, 'ptBR', 'Exodar, Alfaiataria', 44325),
+(1882, 'ruRU', 'Экзодар: портные', 44325),
+(1882, 'zhCN', '埃索达裁缝训练师', 44325),
+(1882, 'zhTW', '艾克索達，裁縫', 44325),
+(1883, 'deDE', 'Kürschnerlehrer der Exodar', 44325),
+(1883, 'esES', 'El Exodar, desuello', 44325),
+(1883, 'esMX', 'El Exodar, desuello', 44325),
+(1883, 'frFR', 'Dépeçage de l''Exodar', 44325),
+(1883, 'itIT', 'Scuoiatura di Exodar', 44325),
+(1883, 'koKR', '엑소다르 전문 무두장이', 44325),
+(1883, 'ptBR', 'Exodar, Esfolamento', 44325),
+(1883, 'ruRU', 'Экзодарский учитель снятия шкур', 44325),
+(1883, 'zhCN', '埃索达剥皮训练师', 44325),
+(1883, 'zhTW', '艾克索達，剝皮', 44325),
+(1884, 'deDE', 'Lederverarbeitung der Exodar', 44325),
+(1884, 'esES', 'El Exodar, peletería', 44325),
+(1884, 'esMX', 'El Exodar, peletería', 44325),
+(1884, 'frFR', 'Artisanat du cuir de l''Exodar', 44325),
+(1884, 'itIT', 'Conciatura di Exodar', 44325),
+(1884, 'koKR', '엑소다르 전문 가죽세공인', 44325),
+(1884, 'ptBR', 'Exodar, Couraria', 44325),
+(1884, 'ruRU', 'Экзодар: кожевничество', 44325),
+(1884, 'zhCN', '埃索达制皮师', 44325),
+(1884, 'zhTW', '艾克索達，製皮師', 44325),
+(1885, 'deDE', 'Bergbaulehrer der Exodar', 44325),
+(1885, 'esES', 'El Exodar, minería', 44325),
+(1885, 'esMX', 'El Exodar, minería', 44325),
+(1885, 'frFR', 'Minage de l''Exodar', 44325),
+(1885, 'itIT', 'Estrazione di Exodar', 44325),
+(1885, 'koKR', '엑소다르 전문 광부', 44325),
+(1885, 'ptBR', 'Exodar, Mineração', 44325),
+(1885, 'ruRU', 'Экзодар: мастера горного дела', 44325),
+(1885, 'zhCN', '埃索达采矿训练师', 44325),
+(1885, 'zhTW', '艾克索達，採礦', 44325),
+(1886, 'deDE', 'Schmiedekunstlehrer der Exodar', 44325),
+(1886, 'esES', 'El Exodar, herrería', 44325),
+(1886, 'esMX', 'El Exodar, herrería', 44325),
+(1886, 'frFR', 'Forge de l''Exodar', 44325),
+(1886, 'itIT', 'Forgiatura di Exodar', 44325),
+(1886, 'koKR', '엑소다르 전문 대장장이', 44325),
+(1886, 'ptBR', 'Exodar, Ferraria', 44325),
+(1886, 'ruRU', 'Экзодар: мастера кузнечного дела', 44325),
+(1886, 'zhCN', '埃索达锻造训练师', 44325),
+(1886, 'zhTW', '艾克索達，鍛造', 44325),
+(1887, 'deDE', 'Jägerlehrer der Exodar', 44325),
+(1887, 'esES', 'El Exodar, instructores de cazadores', 44325),
+(1887, 'esMX', 'El Exodar, instructores de cazadores', 44325),
+(1887, 'frFR', 'Maître des chasseurs de l''Exodar', 44325),
+(1887, 'itIT', 'Istruttore dei Cacciatori di Exodar', 44325),
+(1887, 'koKR', '엑소다르 상급 사냥꾼', 44325),
+(1887, 'ptBR', 'Exodar, Treinamento de Caçadores', 44325),
+(1887, 'ruRU', 'Экзодар: наставники охотников', 44325),
+(1887, 'zhCN', '埃索达猎人训练师', 44325),
+(1887, 'zhTW', '艾克索達，獵人訓練師', 44325),
+(1889, 'deDE', 'Kriegerlehrer der Exodar', 44325),
+(1889, 'esES', 'El Exodar, instructores de guerreros', 44325),
+(1889, 'esMX', 'El Exodar, instructores de guerreros', 44325),
+(1889, 'frFR', 'Maître des guerriers de l''Exodar', 44325),
+(1889, 'itIT', 'Istruttore dei Guerrieri di Exodar', 44325),
+(1889, 'koKR', '엑소다르 상급 전사', 44325),
+(1889, 'ptBR', 'Exodar, Treinamento de Guerreiros', 44325),
+(1889, 'ruRU', 'Экзодар: наставники воинов', 44325),
+(1889, 'zhCN', '埃索达战士训练师', 44325),
+(1889, 'zhTW', '艾克索達，戰士訓練師', 44325),
+(1890, 'deDE', 'Stallmeister der Exodar', 44325),
+(1890, 'esES', 'El Exodar, maestro de establos', 44325),
+(1890, 'esMX', 'El Exodar, maestro de establos', 44325),
+(1890, 'frFR', 'Maître des écuries de l''Exodar', 44325),
+(1890, 'itIT', 'Stalliere di Exodar', 44325),
+(1890, 'koKR', '엑소다르 야수 관리인', 44325),
+(1890, 'ptBR', 'Exodar, Mestre de Estábulo', 44325),
+(1890, 'ruRU', 'Экзодар: смотритель стойл', 44325),
+(1890, 'zhCN', '埃索达兽栏管理员', 44325),
+(1890, 'zhTW', '艾克索達，獸欄管理員', 44325),
+(1891, 'deDE', 'Druidenlehrer der Exodar', 44325),
+(1891, 'esES', 'El Exodar, instructor de druidas', 44325),
+(1891, 'esMX', 'El Exodar, instructor de druidas', 44325),
+(1891, 'frFR', 'Maître des druides de l''Exodar', 44325),
+(1891, 'itIT', 'Istruttore dei Druidi di Exodar', 44325),
+(1891, 'koKR', '엑소다르 상급 드루이드', 44325),
+(1891, 'ptBR', 'Exodar, Treinamento de Druidas', 44325),
+(1891, 'ruRU', 'Экзодар: наставник друидов', 44325),
+(1891, 'zhCN', '埃索达德鲁伊训练师', 44325),
+(1891, 'zhTW', '艾克索達，德魯伊訓練師', 44325),
+(2026, 'deDE', 'Briefkasten der Exodar', 44325),
+(2026, 'esES', 'El Exodar, buzón de correo', 44325),
+(2026, 'esMX', 'El Exodar, buzón de correo', 44325),
+(2026, 'frFR', 'Boîte aux lettres de l''Exodar', 44325),
+(2026, 'itIT', 'Cassetta della Posta di Exodar', 44325),
+(2026, 'koKR', '엑소다르 우체통', 44325),
+(2026, 'ptBR', 'Exodar, Caixa de Correio', 44325),
+(2026, 'ruRU', 'Экзодар: почта', 44325),
+(2026, 'zhCN', '埃索达邮箱', 44325),
+(2026, 'zhTW', '艾克索達，郵箱', 44325),
+(2052, 'deDE', 'Kochlehrer der Exodar', 44325),
+(2052, 'esES', 'El Exodar, cocina', 44325),
+(2052, 'esMX', 'El Exodar, cocina', 44325),
+(2052, 'frFR', 'Cuisinier de l''Exodar', 44325),
+(2052, 'itIT', 'Cucina di Exodar', 44325),
+(2052, 'koKR', '엑소다르 요리사', 44325),
+(2052, 'ptBR', 'Exodar, Culinária', 44325),
+(2052, 'ruRU', 'Экзодар: повар', 44325),
+(2052, 'zhCN', '埃索达烹饪训练师', 44325),
+(2052, 'zhTW', '艾克索達，烹飪', 44325),
+(2275, 'deDE', 'Inschriftenkundelehrer der Exodar', 44325),
+(2275, 'esES', 'El Exodar, inscripción', 44325),
+(2275, 'esMX', 'El Exodar, inscripción', 44325),
+(2275, 'frFR', 'Calligraphie de l''Exodar', 44325),
+(2275, 'itIT', 'Runografia di Exodar', 44325),
+(2275, 'koKR', '엑소다르 전문 주문각인사', 44325),
+(2275, 'ptBR', 'Exodar, Escrivania', 44325),
+(2275, 'ruRU', 'Экзодарский начертатель', 44325),
+(2275, 'zhCN', '埃索达铭文训练师', 44325),
+(2275, 'zhTW', '艾克索達，銘文學', 44325),
+(2537, 'deDE', 'Archäologie der Exodar', 44325),
+(2537, 'esES', 'El Exodar, arqueología', 44325),
+(2537, 'esMX', 'El Exodar, arqueología', 44325),
+(2537, 'frFR', 'Archéologie de l''Exodar', 44325),
+(2537, 'itIT', 'Archeologia di Exodar', 44325),
+(2537, 'koKR', '엑소다르 고고학자', 44325),
+(2537, 'ptBR', 'Exodar, Arqueologia', 44325),
+(2537, 'ruRU', 'Экзодар: археология', 44325),
+(2537, 'zhCN', '埃索达考古学训练师', 44325),
+(2537, 'zhTW', '艾克索達，考古學', 44325),
+(2772, 'deDE', 'Mönchslehrer der Exodar', 44325),
+(2772, 'esES', 'El Exodar, instructores de monjes', 44325),
+(2772, 'esMX', 'El Exodar, instructores de monjes', 44325),
+(2772, 'frFR', 'Maître des moines de l''Exodar', 44325),
+(2772, 'itIT', 'Istruttore dei Monaci di Exodar', 44325),
+(2772, 'koKR', '엑소다르 상급 수도사', 44325),
+(2772, 'ptBR', 'Exodar, Treinamento de Monges', 44325),
+(2772, 'ruRU', 'Экзодар: наставники монахов', 44325),
+(2772, 'zhCN', '埃索达，武僧训练师', 44325),
+(2772, 'zhTW', '艾克索達武僧訓練師', 44325),
+(5243, 'deDE', 'Ausgang der Exodar zur Azurmythosinsel', 44325),
+(5243, 'esES', 'El Exodar, salida a la Isla Bruma Azur', 44325),
+(5243, 'esMX', 'Salida de Exodar a Isla Bruma Azur', 44325),
+(5243, 'frFR', 'Sortie vers l’île de Brume-Azur de l’Exodar', 44325),
+(5243, 'itIT', 'Uscita di Exodar per l''Isola Brumazzurra', 44325),
+(5243, 'koKR', '엑소다르 - 하늘안개 섬으로 가는 출구', 44325),
+(5243, 'ptBR', 'Exodar, Saída para Ilha Névoa Lazúli', 44325),
+(5243, 'ruRU', 'Экзодар, выход на остров Лазурной ', 44325), -- Экзодар, выход на остров Лазурной Дымки (truncated)
+(5243, 'zhCN', '埃索达通往秘蓝岛的出口', 44325),
+(5243, 'zhTW', '艾克索達，藍謎島出口', 44325),
+(6114, 'deDE', 'Portal nach Sturmwind', 44325),
+(6114, 'esES', 'Portal a la Ciudad de Ventormenta', 44325),
+(6114, 'esMX', 'Portal a Ciudad de Ventormenta', 44325),
+(6114, 'frFR', 'Portail vers Hurlevent', 44325),
+(6114, 'itIT', 'Portale per Roccavento', 44325),
+(6114, 'koKR', '스톰윈드로 통하는 차원문', 44325),
+(6114, 'ptBR', 'Portal para Ventobravo', 44325),
+(6114, 'ruRU', 'Портал в Штормград', 44325),
+(6114, 'zhCN', '通往暴风城的传送门', 44325),
+(6114, 'zhTW', '暴風城傳送門', 44325);