DB/Creature: Fixed gossip menus for Thunder Bluff guards

Ref #17414

1 files changed, 359 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_29_12_world_thunderbluff.sql b/sql/updates/world/master/2022_07_29_12_world_thunderbluff.sql
new file mode 100644
index 00000000000..f1ed54b792f
--- /dev/null
+++ b/sql/updates/world/master/2022_07_29_12_world_thunderbluff.sql
@@ -0,0 +1,359 @@
+-- Bluffwatcher (Thunder Bluff)
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `npcflag`=1 WHERE `entry`=3084;
+
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (12327, 12328, 12329, 12780, 12781, 13867, 24189);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(12327,17323,-1),
+(12328,17324,-1),
+(12329,17325,-1),
+(12780,17969,-1),
+(12781,17970,-1),
+(13867,20037,-1),
+(24189,17793,-1);
+
+DELETE FROM `npc_text` WHERE `ID` IN (17325, 17969, 17970, 20037);
+INSERT INTO `npc_text` (`ID`, `Probability0`, `BroadcastTextID0`, `VerifiedBuild`) VALUES
+(17325,1,48027,-1),
+(17969,1,51353,-1),
+(17970,1,51354,-1),
+(20037,1,61845,-1);
+
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=5316, `ActionPoiID`=1692 WHERE `MenuID`=721 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=168 WHERE `MenuID`=721 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3429 WHERE `MenuID`=721 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=158 WHERE `MenuID`=721 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=367 WHERE `MenuID`=721 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=368 WHERE `MenuID`=721 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2869 WHERE `MenuID`=721 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=8508, `ActionPoiID`=850 WHERE `MenuID`=721 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3427, `ActionPoiID`=167 WHERE `MenuID`=721 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `OptionText`='Other Continents', `OptionBroadcastTextId`=5914, `ActionMenuID`=24189, `ActionPoiID`=0 WHERE `MenuID`=721 AND `OptionID`=9; -- Blizzard bug
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2914, `ActionPoiID`=150 WHERE `MenuID`=740 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2924, `ActionPoiID`=149 WHERE `MenuID`=740 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2902, `ActionPoiID`=161 WHERE `MenuID`=740 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2922, `ActionPoiID`=2533 WHERE `MenuID`=740 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2918, `ActionPoiID`=150 WHERE `MenuID`=740 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3450, `ActionPoiID`=148 WHERE `MenuID`=740 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2910, `ActionPoiID`=149 WHERE `MenuID`=740 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=2770 WHERE `MenuID`=740 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2952, `ActionPoiID`=152 WHERE `MenuID`=751 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=2534 WHERE `MenuID`=751 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2942, `ActionPoiID`=155 WHERE `MenuID`=751 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2945, `ActionPoiID`=187 WHERE `MenuID`=751 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3006, `ActionPoiID`=153 WHERE `MenuID`=751 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2943, `ActionPoiID`=2657 WHERE `MenuID`=751 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2949, `ActionPoiID`=162 WHERE `MenuID`=751 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3005, `ActionPoiID`=160 WHERE `MenuID`=751 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2950, `ActionPoiID`=151 WHERE `MenuID`=751 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=31542, `ActionPoiID`=2280 WHERE `MenuID`=751 AND `OptionID`=9;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=15267, `ActionPoiID`=2658 WHERE `MenuID`=751 AND `OptionID`=10;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2947, `ActionPoiID`=154 WHERE `MenuID`=751 AND `OptionID`=11;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2944, `ActionPoiID`=157 WHERE `MenuID`=751 AND `OptionID`=12;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2948, `ActionPoiID`=567 WHERE `MenuID`=751 AND `OptionID`=13;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2951, `ActionPoiID`=154 WHERE `MenuID`=751 AND `OptionID`=14;
+UPDATE `gossip_menu_option` SET `VerifiedBuild`=44325 WHERE `MenuID` IN (721, 740, 751);
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=740 AND `OptionID`=4;
+
+DELETE FROM `points_of_interest` WHERE `ID` IN (10275, 10276, 10277, 10278, 10279, 10280, 10282, 10285, 10286, 10287, 10288, 10289, 10290, 10291, 10292, 10293, 10294, 10295, 10296, 10297, 10298, 10299, 10500, 10501, 10502, 10503, 10600);
+DELETE FROM `points_of_interest` WHERE `ID` IN (148, 149, 150, 151, 152, 153, 154, 155, 157, 158, 160, 161, 162, 167, 168, 187, 367, 368, 567, 850, 1692, 2280, 2533, 2534, 2657, 2658, 2770);
+INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `PositionZ`, `Icon`, `Flags`, `Importance`, `Name`, `Unknown905`, `VerifiedBuild`) VALUES
+(148, -989.541015625, 278.25299072265625, 134.964996337890625, 7, 99, 0, 'Hall of Spirits', 0, 44325),
+(149, -1416.3299560546875, -114.285003662109375, 158.93499755859375, 7, 99, 0, 'Hunter''s Hall', 0, 44325),
+(150, -1057.3499755859375, -261.014007568359375, 159.029998779296875, 7, 99, 0, 'Hall of Elders', 0, 44325),
+(151, -1137.7099609375, -1.51698005199432373, 143.438995361328125, 7, 99, 0, 'Holistic Herbalism', 0, 44325),
+(152, -1085.5699462890625, 27.29310035705566406, 140.587005615234375, 7, 99, 0, 'Bena''s Alchemy', 0, 44325),
+(153, -1116.56005859375, 45.63370132446289062, 140.85400390625, 7, 99, 0, 'Dawnstrider Enchanters', 0, 44325),
+(154, -1156.22998046875, 66.86640167236328125, 145.39300537109375, 7, 99, 0, 'Thunder Bluff Armorers', 0, 44325),
+(155, -1239.75, 104.88800048828125, 129.0959930419921875, 7, 99, 0, 'Karn''s Smithy', 0, 44325),
+(157, -1249.1700439453125, 155.0279998779296875, 132.373992919921875, 7, 99, 0, 'Stonehoof Geology', 0, 44325),
+(158, -1296.5, 127.5790023803710937, 131.4579925537109375, 7, 99, 0, 'Thunder Bluff Civic Information', 0, 44325),
+(160, -1169.3599853515625, -68.8779983520507812, 162.18499755859375, 7, 99, 0, 'Mountaintop Bait & Tackle', 0, 44325),
+(161, -1061.2099609375, 195.5050048828125, 107.6129989624023437, 7, 99, 0, 'Pools of Vision', 0, 44325),
+(162, -996.58599853515625, 200.503997802734375, 136.53399658203125, 7, 99, 0, 'Spiritual Healing', 0, 44325),
+(167, -1196.43994140625, 28.26539993286132812, 128.3990020751953125, 7, 99, 0, 'Wind Rider Roost', 0, 44325),
+(168, -1257.800048828125, 24.14310073852539062, 127.7180023193359375, 7, 99, 0, 'Thunder Bluff Bank', 0, 44325),
+(187, -1214.5, -21.2327003479003906, 165.3699951171875, 7, 99, 0, 'Aska''s Kitchen', 0, 44325),
+(367, -1296.0699462890625, 39.70750045776367187, 128.1790008544921875, 7, 99, 0, 'Thunder Bluff Inn', 0, 44325),
+(368, -1263.5999755859375, 44.36009979248046875, 127.7549972534179687, 7, 99, 0, 'Thunder Bluff Mailbox', 0, 44325),
+(567, -1148.5699462890625, 51.18420028686523437, 144.7910003662109375, 7, 99, 0, 'Mooranta', 0, 44325),
+(850, -1270.199951171875, 48.8459014892578125, 128.63800048828125, 7, 99, 0, 'Bulrug', 0, 44325),
+(1692, -1198.3199462890625, 102.0540008544921875, 134.7769927978515625, 7, 99, 0, 'Thunder Bluff Auction House', 0, 44325),
+(2280, -999.3809814453125, 213.66400146484375, 105.9550018310546875, 7, 99, 0, 'Thunder Bluff Inscription', 0, 44325),
+(2533, -1404.260009765625, -130.934005737304687, 160.095001220703125, 7, 99, 0, 'Sunwalker Lodge', 0, 44325),
+(2534, -1045.52001953125, -266.558990478515625, 159.03900146484375, 7, 99, 0, 'Thunder Bluff Archaeology', 0, 44325),
+(2657, -1266.2552490234375, 139.4322967529296875, 132.5059814453125, 7, 99, 0, 'Thunder Bluff Engineering', 0, 44325),
+(2658, -1224.126708984375, 150.967010498046875, 133.1556854248046875, 7, 99, 0, 'Thunder Bluff Jewelcrafting', 0, 44325),
+(2770, -976.62847900390625, 285.09375, 137.5902557373046875, 7, 99, 0, 'Thunder Bluff Monk Trainer', 0, 44325);
+
+DELETE FROM `points_of_interest_locale` WHERE `ID` IN (148, 149, 150, 151, 152, 153, 154, 155, 157, 158, 160, 161, 162, 167, 168, 187, 367, 368, 567, 850, 1692, 2280, 2533, 2534, 2657, 2658, 2770);
+INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+( 148, 'deDE', 'Halle der Geister', 44325),
+( 148, 'esES', 'Sala de los Espíritus', 44325),
+( 148, 'esMX', 'Sala de los Espíritus', 44325),
+( 148, 'frFR', 'Hall des Esprits', 44325),
+( 148, 'itIT', 'Sala degli Spiriti', 44325),
+( 148, 'koKR', '정기의 전당', 44325),
+( 148, 'ptBR', 'Salão dos Espíritos', 44325),
+( 148, 'ruRU', 'Зал Духов', 44325),
+( 148, 'zhCN', '灵魂大厅', 44325),
+( 148, 'zhTW', '靈魂大廳', 44325),
+( 149, 'deDE', 'Jägerhalle', 44325),
+( 149, 'esES', 'Recinto de los Cazadores', 44325),
+( 149, 'esMX', 'Recinto de los Cazadores', 44325),
+( 149, 'frFR', 'Hall du Chasseur', 44325),
+( 149, 'itIT', 'Sala del Cacciatore', 44325),
+( 149, 'koKR', '사냥꾼의 전당', 44325),
+( 149, 'ptBR', 'Salão dos Caçadores', 44325),
+( 149, 'ruRU', 'Зал Охотников', 44325),
+( 149, 'zhCN', '猎手大厅', 44325),
+( 149, 'zhTW', '獵人大廳', 44325),
+( 150, 'deDE', 'Halle der Ältesten', 44325),
+( 150, 'esES', 'Sala de los Ancestros', 44325),
+( 150, 'esMX', 'Sala de los Ancestros', 44325),
+( 150, 'frFR', 'Hall des Anciens', 44325),
+( 150, 'itIT', 'Sala degli Anziani', 44325),
+( 150, 'koKR', '장로의 전당', 44325),
+( 150, 'ptBR', 'Salão dos Anciãos', 44325),
+( 150, 'ruRU', 'Зал Старейшин', 44325),
+( 150, 'zhCN', '长者大厅', 44325),
+( 150, 'zhTW', '長者大廳', 44325),
+( 151, 'deDE', 'Ganzheitliche Kräuterkunde', 44325),
+( 151, 'esES', 'Herboristería Holística', 44325),
+( 151, 'esMX', 'Herboristería Holística', 44325),
+( 151, 'frFR', 'Herboristerie holistique', 44325),
+( 151, 'itIT', 'Erbalismo Olistico', 44325),
+( 151, 'koKR', '조화의 약초상점', 44325),
+( 151, 'ptBR', 'Herborismo Holístico', 44325),
+( 151, 'ruRU', 'Общее травничество', 44325),
+( 151, 'zhCN', '绿色草药', 44325),
+( 151, 'zhTW', '綠色草藥', 44325),
+( 152, 'deDE', 'Benas Alchemie', 44325),
+( 152, 'esES', 'La Alquimia de Bena', 44325),
+( 152, 'esMX', 'La Alquimia de Bena', 44325),
+( 152, 'frFR', 'Alchimie de Bena', 44325),
+( 152, 'itIT', 'Alchimie da Bena', 44325),
+( 152, 'koKR', '베나의 연금술점', 44325),
+( 152, 'ptBR', 'Alquimia de Bena', 44325),
+( 152, 'ruRU', 'Лаборатория Бены', 44325),
+( 152, 'zhCN', '本娜的炼金店', 44325),
+( 152, 'zhTW', '貝娜的鍊金店', 44325),
+( 153, 'deDE', 'Morgenwandlers Verzauberungen', 44325),
+( 153, 'esES', 'Encantadores Caminalba', 44325),
+( 153, 'esMX', 'Encantadores Caminalba', 44325),
+( 153, 'frFR', 'Enchanteurs Aube-Glorieuse', 44325),
+( 153, 'itIT', 'Incantamenti Alba Lunga', 44325),
+( 153, 'koKR', '돈스트라이더의 마법부여점', 44325),
+( 153, 'ptBR', 'Encantadores Albatrilha', 44325),
+( 153, 'ruRU', 'Чародеи Рассветных Странников', 44325),
+( 153, 'zhCN', '附魔店', 44325),
+( 153, 'zhTW', '晨行者附魔商店', 44325),
+( 154, 'deDE', 'Rüstungsschmiede von Donnerfels', 44325),
+( 154, 'esES', 'Armeros de Cima del Trueno', 44325),
+( 154, 'esMX', 'Armeros de Cima del Trueno', 44325),
+( 154, 'frFR', 'Armuriers des Pitons-du-Tonnerre', 44325),
+( 154, 'itIT', 'Armature di Picco del Tuono', 44325),
+( 154, 'koKR', '썬더 블러프 갑옷 상점', 44325),
+( 154, 'ptBR', 'Armoreiros do Penhasco do Trovão', 44325),
+( 154, 'ruRU', 'Громовой Утес: оружейники', 44325),
+( 154, 'zhCN', '雷霆崖防具店', 44325),
+( 154, 'zhTW', '雷霆崖防具店', 44325),
+( 155, 'deDE', 'Karns Schmiede', 44325),
+( 155, 'esES', 'Herrería de Karn', 44325),
+( 155, 'esMX', 'Herrería de Karn', 44325),
+( 155, 'frFR', 'Forge de Karn', 44325),
+( 155, 'itIT', 'Forgia di Karn', 44325),
+( 155, 'koKR', '카른 대장간', 44325),
+( 155, 'ptBR', 'Ferreiro de Karn', 44325),
+( 155, 'ruRU', 'Кузня Карна', 44325),
+( 155, 'zhCN', '卡恩铁匠铺', 44325),
+( 155, 'zhTW', '卡恩鐵匠鋪', 44325),
+( 157, 'deDE', 'Steinhufgeologie', 44325),
+( 157, 'esES', 'Geólogos Pezuña Pétrea', 44325),
+( 157, 'esMX', 'Geólogos Pezuña Pétrea', 44325),
+( 157, 'frFR', 'Géologie de Sabot-de-Pierre', 44325),
+( 157, 'itIT', 'Geologia da Zoccolo Granitico', 44325),
+( 157, 'koKR', '스톤후프 지질연구소', 44325),
+( 157, 'ptBR', 'Geologia de Casco de Pedra', 44325),
+( 157, 'ruRU', 'Лавка геолога', 44325),
+( 157, 'zhCN', '石蹄地质学会', 44325),
+( 157, 'zhTW', '石蹄地質學會', 44325),
+( 158, 'deDE', 'Informationen der Stadtverwaltung von Donnerfels', 44325),
+( 158, 'esES', 'Información al Ciudadano de Cima del Trueno', 44325),
+( 158, 'esMX', 'Información al Ciudadano de Cima del Trueno', 44325),
+( 158, 'frFR', 'Information civique des Pitons-du-Tonnerre', 44325),
+( 158, 'itIT', 'Centro d''Accoglienza di Picco del Tuono', 44325),
+( 158, 'koKR', '썬더 블러프 길드 사무소', 44325),
+( 158, 'ptBR', 'Informações Cívicas do Penhasco do Trovão', 44325),
+( 158, 'ruRU', 'Громовой Утес: городская информац', 44325), -- Громовой Утес: городская информац� (truncated)
+( 158, 'zhCN', '雷霆崖咨询处', 44325),
+( 158, 'zhTW', '雷霆崖諮詢處', 44325),
+( 160, 'deDE', 'Gipfelbergs Köder und Ausrüstung', 44325),
+( 160, 'esES', 'Anzuelos y Aparejos La Cumbre', 44325),
+( 160, 'esMX', 'Anzuelos y Aparejos La Cumbre', 44325),
+( 160, 'frFR', 'Appâts et équipement du sommet', 44325),
+( 160, 'itIT', 'Paradiso del Pescatore', 44325),
+( 160, 'koKR', '산꼭대기 낚시용품점', 44325),
+( 160, 'ptBR', 'Iscas e Apetrechos do Pináculo', 44325),
+( 160, 'ruRU', 'Снасти и наживка с горных вершин', 44325),
+( 160, 'zhCN', '山顶渔具店', 44325),
+( 160, 'zhTW', '山頂漁具店', 44325),
+( 161, 'deDE', 'Teiche der Visionen', 44325),
+( 161, 'esES', 'Pozas de las Visiones', 44325),
+( 161, 'esMX', 'Pozas de las Visiones', 44325),
+( 161, 'frFR', 'Bassins de la Vision', 44325),
+( 161, 'itIT', 'Pozze delle Visioni', 44325),
+( 161, 'koKR', '예언의 웅덩이', 44325),
+( 161, 'ptBR', 'Poços das Visões', 44325),
+( 161, 'ruRU', 'Пруды Видений', 44325),
+( 161, 'zhCN', '预见之池', 44325),
+( 161, 'zhTW', '預見之池', 44325),
+( 162, 'deDE', 'Spirituelle Heilung', 44325),
+( 162, 'esES', 'Curación Espiritual', 44325),
+( 162, 'esMX', 'Curación Espiritual', 44325),
+( 162, 'frFR', 'Soins spirituels', 44325),
+( 162, 'itIT', 'Guarigione Spirituale', 44325),
+( 162, 'koKR', '정기의 치료소', 44325),
+( 162, 'ptBR', 'Cura Espiritual', 44325),
+( 162, 'ruRU', 'Духовное исцеление', 44325),
+( 162, 'zhCN', '精神治疗', 44325),
+( 162, 'zhTW', '精神治療', 44325),
+( 167, 'deDE', 'Windreiterhorst', 44325),
+( 167, 'esES', 'Nidal de los Jinetes del Viento', 44325),
+( 167, 'esMX', 'Nidal de los Jinetes del Viento', 44325),
+( 167, 'frFR', 'Perchoir des coursiers du vent', 44325),
+( 167, 'itIT', 'Voliera delle Viverne dei Venti', 44325),
+( 167, 'koKR', '와이번 횃대', 44325),
+( 167, 'ptBR', 'Poleiro da Mantícora', 44325),
+( 167, 'ruRU', 'Гнездо ветрокрылов', 44325),
+( 167, 'zhCN', '双足飞龙栖木', 44325),
+( 167, 'zhTW', '蠍尾獅棲息處', 44325),
+( 168, 'deDE', 'Bank von Donnerfels', 44325),
+( 168, 'esES', 'Banco de Cima del Trueno', 44325),
+( 168, 'esMX', 'Banco de Cima del Trueno', 44325),
+( 168, 'frFR', 'Banque des Pitons-du-Tonnerre', 44325),
+( 168, 'itIT', 'Banca di Picco del Tuono', 44325),
+( 168, 'koKR', '썬더 블러프 은행', 44325),
+( 168, 'ptBR', 'Banco do Penhasco do Trovão', 44325),
+( 168, 'ruRU', 'Громовой Утес: банк', 44325),
+( 168, 'zhCN', '雷霆崖银行', 44325),
+( 168, 'zhTW', '雷霆崖銀行', 44325),
+( 187, 'deDE', 'Askas Küche', 44325),
+( 187, 'esES', 'La Cocina de Aska', 44325),
+( 187, 'esMX', 'La Cocina de Aska', 44325),
+( 187, 'frFR', 'Cuisine d’Aska', 44325),
+( 187, 'itIT', 'Cucina di Aska', 44325),
+( 187, 'koKR', '아스카의 주방', 44325),
+( 187, 'ptBR', 'Cozinha de Aska', 44325),
+( 187, 'ruRU', 'Кухня Аски', 44325),
+( 187, 'zhCN', '阿丝卡的厨房', 44325),
+( 187, 'zhTW', '阿絲卡的廚房', 44325),
+( 367, 'deDE', 'Gasthaus von Donnerfels', 44325),
+( 367, 'esES', 'Posada de Cima del Trueno', 44325),
+( 367, 'esMX', 'Posada de Cima del Trueno', 44325),
+( 367, 'frFR', 'Auberge des Pitons-du-Tonnerre', 44325),
+( 367, 'itIT', 'Locanda di Picco del Tuono', 44325),
+( 367, 'koKR', '썬더 블러프 여관', 44325),
+( 367, 'ptBR', 'Estalagem do Penhasco do Trovão', 44325),
+( 367, 'ruRU', 'Таверна Громового Утеса', 44325),
+( 367, 'zhCN', '雷霆崖旅店', 44325),
+( 367, 'zhTW', '雷霆崖旅店', 44325),
+( 368, 'deDE', 'Briefkasten von Donnerfels', 44325),
+( 368, 'esES', 'Buzón de Cima del Trueno', 44325),
+( 368, 'esMX', 'Buzón de Cima del Trueno', 44325),
+( 368, 'frFR', 'Boîte aux lettres des Pitons-du-Tonnerre', 44325),
+( 368, 'itIT', 'Cassetta della Posta di Picco del Tuono', 44325),
+( 368, 'koKR', '썬더 블러프 우체통', 44325),
+( 368, 'ptBR', 'Caixa de Correio do Penhasco do Trovão', 44325),
+( 368, 'ruRU', 'Громовой Утес: почта', 44325),
+( 368, 'zhCN', '雷霆崖邮箱', 44325),
+( 368, 'zhTW', '雷霆崖郵箱', 44325),
+( 567, 'deDE', 'Mooranta', 44325),
+( 567, 'esES', 'Mooranta', 44325),
+( 567, 'esMX', 'Mooranta', 44325),
+( 567, 'frFR', 'Mooranta', 44325),
+( 567, 'itIT', 'Mooranta', 44325),
+( 567, 'koKR', '무란타', 44325),
+( 567, 'ptBR', 'Mooranta', 44325),
+( 567, 'ruRU', 'Муранта', 44325),
+( 567, 'zhCN', '莫兰塔', 44325),
+( 567, 'zhTW', '莫蘭塔', 44325),
+( 850, 'deDE', 'Bulrug', 44325),
+( 850, 'esES', 'Bulrug', 44325),
+( 850, 'esMX', 'Bulrug', 44325),
+( 850, 'frFR', 'Bulrug', 44325),
+( 850, 'itIT', 'Bulrug', 44325),
+( 850, 'koKR', '불루그', 44325),
+( 850, 'ptBR', 'Bulrug', 44325),
+( 850, 'ruRU', 'Балруг', 44325),
+( 850, 'zhCN', '布尔鲁格', 44325),
+( 850, 'zhTW', '布林魯格', 44325),
+(1692, 'deDE', 'Auktionshaus von Donnerfels', 44325),
+(1692, 'esES', 'Casa de subastas de Cima del Trueno', 44325),
+(1692, 'esMX', 'Casa de subastas de Cima del Trueno', 44325),
+(1692, 'frFR', 'Hôtel des ventes des Pitons-du-Tonnerre', 44325),
+(1692, 'itIT', 'Casa d''Aste di Picco del Tuono', 44325),
+(1692, 'koKR', '썬더 블러프 경매장', 44325),
+(1692, 'ptBR', 'Casa de Leilões do Penhasco do Trovão', 44325),
+(1692, 'ruRU', 'Громовой Утес: аукционный дом', 44325),
+(1692, 'zhCN', '雷霆崖拍卖行', 44325),
+(1692, 'zhTW', '雷霆崖拍賣場', 44325),
+(2280, 'deDE', 'Inschriftenkunde von Donnerfels', 44325),
+(2280, 'esES', 'Inscripción de Cima del Trueno', 44325),
+(2280, 'esMX', 'Inscripción de Cima del Trueno', 44325),
+(2280, 'frFR', 'Calligraphie des Pitons-du-Tonnerre', 44325),
+(2280, 'itIT', 'Runografia di Picco del Tuono', 44325),
+(2280, 'koKR', '썬더 블러프 전문 주문각인사', 44325),
+(2280, 'ptBR', 'Escrivania do Penhasco do Trovão', 44325),
+(2280, 'ruRU', 'Начертатель Громового Утеса', 44325),
+(2280, 'zhCN', '雷霆崖铭文训练师', 44325),
+(2280, 'zhTW', '雷霆崖銘文坊', 44325),
+(2533, 'deDE', 'Jagdhütte der Sonnenläufer', 44325),
+(2533, 'esES', 'Refugio del Caminasol', 44325),
+(2533, 'esMX', 'Refugio del Caminasol', 44325),
+(2533, 'frFR', 'Pavillon du marche-soleil', 44325),
+(2533, 'itIT', 'Rifugio dei Campioni del Sole', 44325),
+(2533, 'koKR', '태양길잡이 오두막', 44325),
+(2533, 'ptBR', 'Chalé do Andarilho do Sol', 44325),
+(2533, 'ruRU', 'Приют Служителей Солнца', 44325),
+(2533, 'zhCN', '烈日行者居所', 44325),
+(2533, 'zhTW', '日行者小屋', 44325),
+(2534, 'deDE', 'Archäologie von Donnerfels', 44325),
+(2534, 'esES', 'Arqueología de Cima del Trueno', 44325),
+(2534, 'esMX', 'Arqueología de Cima del Trueno', 44325),
+(2534, 'frFR', 'Archéologie des Pitons-du-Tonnerre', 44325),
+(2534, 'itIT', 'Archeologia di Picco del Tuono', 44325),
+(2534, 'koKR', '썬더 블러프 고고학자', 44325),
+(2534, 'ptBR', 'Arqueologia do Penhasco do Trovão', 44325),
+(2534, 'ruRU', 'Громовой Утес: археология', 44325),
+(2534, 'zhCN', '雷霆崖考古学训练师', 44325),
+(2534, 'zhTW', '雷霆崖考古學', 44325),
+(2657, 'deDE', 'Ingenieurskunst von Donnerfels', 44325),
+(2657, 'esES', 'Ingeniería de Cima del Trueno', 44325),
+(2657, 'esMX', 'Ingeniería de Cima del Trueno', 44325),
+(2657, 'frFR', 'Ingénierie des Pitons-du-Tonnerre', 44325),
+(2657, 'itIT', 'Ingegneria di Picco del Tuono', 44325),
+(2657, 'koKR', '썬더 블러프 전문 기계공학자', 44325),
+(2657, 'ptBR', 'Engenharia do Penhasco do Trovão', 44325),
+(2657, 'ruRU', 'Громовой Утес: инженерное дело', 44325),
+(2657, 'zhCN', '雷霆崖工程学训练师', 44325),
+(2657, 'zhTW', '雷霆崖工程學訓練師', 44325),
+(2658, 'deDE', 'Juwelierskunst von Donnerfels', 44325),
+(2658, 'esES', 'Joyería de Cima del Trueno', 44325),
+(2658, 'esMX', 'Joyería de Cima del Trueno', 44325),
+(2658, 'frFR', 'Joaillerie des Pitons-du-Tonnerre', 44325),
+(2658, 'itIT', 'Oreficeria di Picco del Tuono', 44325),
+(2658, 'koKR', '썬더 블러프 전문 보석세공인', 44325),
+(2658, 'ptBR', 'Joalheria do Penhasco do Trovão', 44325),
+(2658, 'ruRU', 'Громовой Утес: ювелирное дело', 44325),
+(2658, 'zhCN', '雷霆崖珠宝加工', 44325),
+(2658, 'zhTW', '雷霆崖珠寶設計訓練師', 44325),
+(2770, 'deDE', 'Mönchslehrer von Donnerfels', 44325),
+(2770, 'esES', 'Instructor de monjes de Cima del Trueno', 44325),
+(2770, 'esMX', 'Instructor de monjes de Cima del Trueno', 44325),
+(2770, 'frFR', 'Maître des moines des Pitons-du-Tonnerre', 44325),
+(2770, 'itIT', 'Istruttore dei Monaci di Picco del Tuono', 44325),
+(2770, 'koKR', '썬더블러프 상급 수도사', 44325),
+(2770, 'ptBR', 'Penhasco do Trovão Treinamento de Monges', 44325),
+(2770, 'ruRU', 'Громовой Утес: наставник монахов', 44325),
+(2770, 'zhCN', '雷霆崖武僧训练师', 44325),
+(2770, 'zhTW', '雷霆崖武僧訓練師', 44325);