DB/Creature: Fixed gossip menus for Stormwind guards

Ref #17414

1 files changed, 614 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_29_02_world_stormwind.sql b/sql/updates/world/master/2022_07_29_02_world_stormwind.sql
new file mode 100644
index 00000000000..f20092d2605
--- /dev/null
+++ b/sql/updates/world/master/2022_07_29_02_world_stormwind.sql
@@ -0,0 +1,614 @@
+SET @TGUID := 500000;
+
+-- Stormwind City Guard | Stormwind City Patroller | Stormwind Harbor Guard (Stormwind City)
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry` IN (68, 1976, 29712);
+
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (23813, 23814, 23815, 23816, 23817, 23818, 23819, 24451);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(23813,@TGUID+0,-1),
+(23814,@TGUID+1,-1),
+(23815,@TGUID+2,-1),
+(23816,@TGUID+3,-1),
+(23817,@TGUID+4,-1),
+(23818,@TGUID+5,-1),
+(23819,@TGUID+6,-1),
+(24451,@TGUID+7,-1);
+
+DELETE FROM `npc_text` WHERE `ID` BETWEEN @TGUID+0 AND @TGUID+7;
+INSERT INTO `npc_text` (`ID`, `Probability0`, `BroadcastTextID0`, `VerifiedBuild`) VALUES
+(@TGUID+0,1,169215,-1),
+(@TGUID+1,1,169217,-1),
+(@TGUID+2,1,169220,-1),
+(@TGUID+3,1,169222,-1),
+(@TGUID+4,1,169224,-1),
+(@TGUID+5,1,169238,-1),
+(@TGUID+6,1,169252,-1),
+(@TGUID+7,1,177839,-1);
+
+UPDATE `gossip_menu_option` SET `ActionPoiID`=6765 WHERE `MenuID`=401 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=6762 WHERE `MenuID`=401 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=6764 WHERE `MenuID`=401 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=6759 WHERE `MenuID`=401 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=6760 WHERE `MenuID`=401 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=6767 WHERE `MenuID`=401 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=6761 WHERE `MenuID`=401 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=6766 WHERE `MenuID`=401 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=6758 WHERE `MenuID`=401 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=6763 WHERE `MenuID`=401 AND `OptionID`=9;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=0 WHERE `MenuID`=435 AND `OptionID`=13;
+UPDATE `gossip_menu_option` SET `OptionText`='Ironforge, Eastern Kingdoms', `OptionType`=1, `OptionNpcFlag`=1 WHERE `MenuID`=12243 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionText`='Teldrassil, Kalimdor', `OptionBroadcastTextId`=169216, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=23813, `ActionPoiID`=6014 WHERE `MenuID`=12243 AND `OptionID`=1; -- Blizzard bug: this should use POI 5215
+UPDATE `gossip_menu_option` SET `OptionText`='Exodar, Kalimdor', `OptionBroadcastTextId`=169218, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=23814, `ActionPoiID`=6014 WHERE `MenuID`=12243 AND `OptionID`=2; -- Blizzard bug: this should use POI 5215 and different ActionMenuID
+UPDATE `gossip_menu_option` SET `OptionText`='Hellfire Peninsula, Outland', `OptionBroadcastTextId`=129107, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=23814, `ActionPoiID`=6014 WHERE `MenuID`=12243 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionText`='Borean Tundra, Northrend', `OptionBroadcastTextId`=129110, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=20922, `ActionPoiID`=6014 WHERE `MenuID`=12243 AND `OptionID`=4; -- Blizzard bug: this should use POI 5216
+UPDATE `gossip_menu_option` SET `OptionText`='Dalaran City, Northrend', `OptionBroadcastTextId`=169219, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=23815, `ActionPoiID`=6014 WHERE `MenuID`=12243 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionText`='Areas opened up in the Cataclysm', `OptionBroadcastTextId`=129111, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=20917, `ActionPoiID`=2518 WHERE `MenuID`=12243 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=44627 WHERE `MenuID`=11848 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45382 WHERE `MenuID`=11848 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `VerifiedBuild`=44325 WHERE `MenuID` IN (401, 421, 435, 3127, 11839, 11841, 11843, 11845, 11846, 11848, 12243);
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=11855;
+
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=12243 AND `OptionID` IN (7, 8, 9, 10, 11);
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
+(12243, 7, 0, 'Jade Forest, Pandaria', 129105, 1, 1, 0, 23816, 6014, 0, 0, NULL, 0, 44325),
+(12243, 8, 0, 'Ashran, Draenor', 129160, 1, 1, 0, 23817, 6014, 0, 0, NULL, 0, 44325),
+(12243, 9, 0, 'Azsuna, Broken Isles', 169225, 1, 1, 0, 23818, 6014, 0, 0, NULL, 0, 44325),
+(12243, 10, 0, 'Tiragarde Sound, Kul Tiras', 169242, 1, 1, 0, 23819, 5993, 0, 0, NULL, 0, 44325),
+(12243, 11, 0, 'Caverns of Time, Silithus', 177838, 1, 1, 0, 24451, 6014, 0, 0, NULL, 0, 44325);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12243;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(15,12243,3,0,0,27,0,10,3,0,0,0,0,'','Show gossip option if player is level 10 or higher'),
+(15,12243,4,0,0,27,0,10,3,0,0,0,0,'','Show gossip option if player is level 10 or higher'),
+(15,12243,5,0,0,27,0,10,3,0,0,0,0,'','Show gossip option if player is level 10 or higher'),
+(15,12243,6,0,0,27,0,30,3,0,0,0,0,'','Show gossip option if player is level 30 or higher'),
+(15,12243,7,0,0,27,0,30,3,0,0,0,0,'','Show gossip option if player is level 30 or higher'),
+(15,12243,8,0,0,27,0,40,3,0,0,0,0,'','Show gossip option if player is level 40 or higher'),
+(15,12243,9,0,0,27,0,10,3,0,0,0,0,'','Show gossip option if player is level 10 or higher'),
+(15,12243,10,0,0,27,0,10,3,0,0,0,0,'','Show gossip option if player is level 10 or higher');
+
+DELETE FROM `points_of_interest` WHERE `ID` IN (10013, 10024, 10025, 10029, 10031, 10036, 10039, 10545, 10546, 10547, 10548, 10549, 10550, 10551, 10564, 10565, 10566, 10567, 10568);
+DELETE FROM `points_of_interest` WHERE `ID` IN (5993, 6014, 6758, 6759, 6760, 6761, 6762, 6763, 6764, 6765, 6766, 6767);
+INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `PositionZ`, `Icon`, `Flags`, `Importance`, `Name`, `Unknown905`, `VerifiedBuild`) VALUES
+(5993, -8630.8203125, 1301.8599853515625, 5.536950111389160156, 7, 99, 0, 'Stormwind Ship to Kul Tiras', 0, 44325),
+(6014, -9016.3095703125, 876.2440185546875, 148.6190032958984375, 0, 5511, 0, 'Stormwind Portal Room', 27404, 44325),
+(6758, -8814.8203125, 332.7650146484375, 107.0490036010742187, 7, 99, 0, 'Stormwind Warrior Trainer', 0, 44325),
+(6759, -8800.58984375, 347.5989990234375, 108.8960037231445312, 7, 99, 0, 'Stormwind Paladin Trainer', 63647, 44325),
+(6760, -8804.2197265625, 351.626007080078125, 108.8290023803710937, 7, 99, 0, 'Stormwind Priest Trainer', 63647, 44325),
+(6761, -8816.7900390625, 354.988006591796875, 107.0500030517578125, 7, 99, 0, 'Stormwind Shaman Trainer', 63647, 44325),
+(6762, -8822.76953125, 348.102996826171875, 107.0490036010742187, 7, 99, 0, 'Stormwind Hunter Trainer', 63647, 44325),
+(6763, -8807.849609375, 327.3280029296875, 115.5329971313476562, 7, 99, 0, 'Stormwind Monk Trainer', 63647, 44325),
+(6764, -8801.5400390625, 330.376007080078125, 115.5120010375976562, 7, 99, 0, 'Stormwind Mage Trainer', 63647, 44325),
+(6765, -8791.669921875, 346.462005615234375, 117.6350021362304687, 7, 99, 0, 'Stormwind Druid Trainer', 63647, 44325),
+(6766, -8805.2197265625, 341.1610107421875, 99.38050079345703125, 7, 99, 0, 'Stormwind Warlock Trainer', 63649, 44325),
+(6767, -8814.8203125, 332.7650146484375, 107.0490036010742187, 7, 99, 0, 'Stormwind Rogue Trainer', 63647, 44325);
+
+UPDATE `points_of_interest` SET `PositionZ`=99.569000244140625, `VerifiedBuild`=44325 WHERE `ID`=47;
+UPDATE `points_of_interest` SET `PositionZ`=109.6070022583007812, `VerifiedBuild`=44325 WHERE `ID` IN (67, 2423);
+UPDATE `points_of_interest` SET `PositionZ`=103.7020034790039062, `VerifiedBuild`=44325 WHERE `ID`=68;
+UPDATE `points_of_interest` SET `PositionZ`=-3.94305992126464843, `VerifiedBuild`=44325 WHERE `ID`=72;
+UPDATE `points_of_interest` SET `PositionZ`=95.257598876953125, `VerifiedBuild`=44325 WHERE `ID`=87;
+UPDATE `points_of_interest` SET `PositionZ`=98.61309814453125, `VerifiedBuild`=44325 WHERE `ID`=90;
+UPDATE `points_of_interest` SET `PositionZ`=98.33119964599609375, `VerifiedBuild`=44325 WHERE `ID`=91;
+UPDATE `points_of_interest` SET `PositionZ`=90.941802978515625, `VerifiedBuild`=44325 WHERE `ID`=92;
+UPDATE `points_of_interest` SET `PositionZ`=95.14389801025390625, `VerifiedBuild`=44325 WHERE `ID`=93;
+UPDATE `points_of_interest` SET `PositionZ`=95.481201171875, `VerifiedBuild`=44325 WHERE `ID`=94;
+UPDATE `points_of_interest` SET `PositionZ`=96.3177032470703125, `VerifiedBuild`=44325 WHERE `ID`=95;
+UPDATE `points_of_interest` SET `PositionZ`=96.3379974365234375, `VerifiedBuild`=44325 WHERE `ID`=107;
+UPDATE `points_of_interest` SET `PositionZ`=96.33409881591796875, `VerifiedBuild`=44325 WHERE `ID`=108;
+UPDATE `points_of_interest` SET `PositionZ`=97.996002197265625, `VerifiedBuild`=44325 WHERE `ID`=527;
+UPDATE `points_of_interest` SET `PositionZ`=97.90309906005859375, `VerifiedBuild`=44325 WHERE `ID`=529;
+UPDATE `points_of_interest` SET `PositionZ`=91.79689788818359375, `VerifiedBuild`=44325 WHERE `ID`=532;
+UPDATE `points_of_interest` SET `PositionZ`=95.2595977783203125, `VerifiedBuild`=44325 WHERE `ID`=870;
+UPDATE `points_of_interest` SET `PositionZ`=106.5189971923828125, `VerifiedBuild`=44325 WHERE `ID`=1427;
+UPDATE `points_of_interest` SET `PositionZ`=103.8960037231445312, `VerifiedBuild`=44325 WHERE `ID`=1467;
+UPDATE `points_of_interest` SET `PositionZ`=96.30780029296875, `VerifiedBuild`=44325 WHERE `ID`=2110;
+UPDATE `points_of_interest` SET `PositionZ`=105.09100341796875, `VerifiedBuild`=44325 WHERE `ID`=2202;
+UPDATE `points_of_interest` SET `PositionZ`=99.60980224609375, `VerifiedBuild`=44325 WHERE `ID`=2272;
+UPDATE `points_of_interest` SET `PositionZ`=99.63179779052734375, `VerifiedBuild`=44325 WHERE `ID`=2415;
+UPDATE `points_of_interest` SET `PositionZ`=97.15460205078125, `VerifiedBuild`=44325 WHERE `ID`=2416;
+UPDATE `points_of_interest` SET `PositionZ`=100.8420028686523437, `VerifiedBuild`=44325 WHERE `ID`=2418;
+UPDATE `points_of_interest` SET `PositionZ`=97.77770233154296875, `VerifiedBuild`=44325 WHERE `ID`=2419;
+UPDATE `points_of_interest` SET `PositionZ`=145.1609954833984375, `VerifiedBuild`=44325 WHERE `ID`=2420;
+UPDATE `points_of_interest` SET `PositionZ`=97.64389801025390625, `VerifiedBuild`=44325 WHERE `ID`=2421;
+UPDATE `points_of_interest` SET `PositionZ`=100.81500244140625, `VerifiedBuild`=44325 WHERE `ID`=2422;
+UPDATE `points_of_interest` SET `PositionZ`=155.3470001220703125, `VerifiedBuild`=44325 WHERE `ID`=2424;
+UPDATE `points_of_interest` SET `PositionZ`=100.9290008544921875, `VerifiedBuild`=44325 WHERE `ID`=2425;
+UPDATE `points_of_interest` SET `PositionZ`=107.0490036010742187, `VerifiedBuild`=44325 WHERE `ID`=2426;
+UPDATE `points_of_interest` SET `PositionZ`=103.9199981689453125, `VerifiedBuild`=44325 WHERE `ID`=2427;
+UPDATE `points_of_interest` SET `PositionZ`=118.1060028076171875, `VerifiedBuild`=44325 WHERE `ID`=2518;
+UPDATE `points_of_interest` SET `PositionZ`=98.68521881103515625, `VerifiedBuild`=44325 WHERE `ID`=2714;
+UPDATE `points_of_interest` SET `PositionZ`=120.4723968505859375, `VerifiedBuild`=44325 WHERE `ID`=2887;
+
+DELETE FROM `points_of_interest_locale` WHERE `ID` IN (47, 67, 68, 72, 87, 90, 91, 92, 93, 94, 95, 107, 108, 527, 529, 532, 870, 1427, 1467, 2110, 2202, 2272, 2415, 2416, 2418, 2419, 2420, 2421, 2422, 2423, 2424, 2425, 2426, 2427, 2518, 2714, 2887, 5993, 6014, 6758, 6759, 6760, 6761, 6762, 6763, 6764, 6765, 6766, 6767);
+INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(  47, 'deDE', 'Bank von Sturmwind', 44325),
+(  47, 'esES', 'Banco de Ventormenta', 44325),
+(  47, 'esMX', 'Banco de Ventormenta', 44325),
+(  47, 'frFR', 'Banque de Hurlevent', 44325),
+(  47, 'itIT', 'Banca di Roccavento', 44325),
+(  47, 'koKR', '스톰윈드 은행', 44325),
+(  47, 'ptBR', 'Ventobravo', 44325),
+(  47, 'ruRU', 'Штормград: банк', 44325),
+(  47, 'zhCN', '暴风城银行', 44325),
+(  47, 'zhTW', '暴風城銀行', 44325),
+(  67, 'deDE', 'Flugmeister von Sturmwind', 44325),
+(  67, 'esES', 'Maestro de vuelo de Ventormenta', 44325),
+(  67, 'esMX', 'Maestro de vuelo de Ventormenta', 44325),
+(  67, 'frFR', 'Maître de vol de Hurlevent', 44325),
+(  67, 'itIT', 'Maestro di Volo di Roccavento', 44325),
+(  67, 'koKR', '스톰윈드 비행 조련사', 44325),
+(  67, 'ptBR', 'Mestre de Voo de Ventobravo', 44325),
+(  67, 'ruRU', 'Распорядитель полетов Штормграда', 44325),
+(  67, 'zhCN', '暴风城飞行管理员', 44325),
+(  67, 'zhTW', '暴風城獅鷲獸管理員', 44325),
+(  68, 'deDE', 'Gasthaus von Sturmwind', 44325),
+(  68, 'esES', 'Posada de Ventormenta', 44325),
+(  68, 'esMX', 'Posada de Ventormenta', 44325),
+(  68, 'frFR', 'Auberge de Hurlevent', 44325),
+(  68, 'itIT', 'Locanda di Roccavento', 44325),
+(  68, 'koKR', '스톰윈드 여관', 44325),
+(  68, 'ptBR', 'Estalagem de Ventobravo', 44325),
+(  68, 'ruRU', 'Таверна Штормграда', 44325),
+(  68, 'zhCN', '暴风城旅店', 44325),
+(  68, 'zhTW', '暴風城旅店', 44325),
+(  72, 'deDE', 'Die Löwenruh', 44325),
+(  72, 'esES', 'Reposo del León', 44325),
+(  72, 'esMX', 'El reposo del león', 44325),
+(  72, 'frFR', 'Repos du lion', 44325),
+(  72, 'itIT', 'Riposo del Leone', 44325),
+(  72, 'koKR', '사자의 안식처', 44325),
+(  72, 'ptBR', 'Repouso do Leão', 44325),
+(  72, 'ruRU', 'Покой Льва', 44325),
+(  72, 'zhCN', '雄狮之眠', 44325),
+(  72, 'zhTW', '雄獅陵園', 44325),
+(  87, 'deDE', 'Gildenmeister von Sturmwind', 44325),
+(  87, 'esES', 'Maestro de hermandad de Ventormenta', 44325),
+(  87, 'esMX', 'Maestro de hermandad de Ventormenta', 44325),
+(  87, 'frFR', 'Maître des guildes de Hurlevent', 44325),
+(  87, 'itIT', 'Mastro di Gilda di Roccavento', 44325),
+(  87, 'koKR', '스톰윈드 길드 사무관', 44325),
+(  87, 'ptBR', 'Mestre de Guildas de Ventobravo', 44325),
+(  87, 'ruRU', 'Предводитель гильдии Штормграда', 44325),
+(  87, 'zhCN', '暴风城公会管理员', 44325),
+(  87, 'zhTW', '暴風城公會註冊員', 44325),
+(  90, 'deDE', 'Lederverarbeitung & Kürschnerei von Sturmwind', 44325),
+(  90, 'esES', 'Desuello y peletería de Ventormenta', 44325),
+(  90, 'esMX', 'Desuello y peletería de Ventormenta', 44325),
+(  90, 'frFR', 'Travail du cuir et dépeçage de Hurlevent', 44325),
+(  90, 'itIT', 'Conciatura e Scuoiatura di Roccavento', 44325),
+(  90, 'koKR', '스톰윈드 전문 가죽세공인 및 무두장이', 44325),
+(  90, 'ptBR', 'Esfolamento & Couraria de Ventobravo', 44325),
+(  90, 'ruRU', 'Снятие и выделка шкур Штормграда', 44325),
+(  90, 'zhCN', '暴风城制皮及剥皮训练师', 44325),
+(  90, 'zhTW', '暴風城製皮與剝皮訓練師', 44325),
+(  91, 'deDE', 'Alchemie & Kräuterkunde von Sturmwind', 44325),
+(  91, 'esES', 'Herboristería y alquimia de Ventormenta', 44325),
+(  91, 'esMX', 'Herboristería y alquimia de Ventormenta', 44325),
+(  91, 'frFR', 'Alchimie et herboristerie de Hurlevent', 44325),
+(  91, 'itIT', 'Alchimia ed Erbalismo di Roccavento', 44325),
+(  91, 'koKR', '스톰윈드 전문 연금술사 및 약초채집사', 44325),
+(  91, 'ptBR', 'Herborismo & Alquimia de Ventobravo', 44325),
+(  91, 'ruRU', 'Алхимия и травничество Штормграда', 44325),
+(  91, 'zhCN', '暴风城炼金术及草药训练师', 44325),
+(  91, 'zhTW', '暴風城鍊金術與草藥學訓練師', 44325),
+(  92, 'deDE', 'Schneiderei von Sturmwind', 44325),
+(  92, 'esES', 'Sastrería de Ventormenta', 44325),
+(  92, 'esMX', 'Sastrería de Ventormenta', 44325),
+(  92, 'frFR', 'Couture de Hurlevent', 44325),
+(  92, 'itIT', 'Sartoria di Roccavento', 44325),
+(  92, 'koKR', '스톰윈드 전문 재봉사', 44325),
+(  92, 'ptBR', 'Alfaiataria de Ventobravo', 44325),
+(  92, 'ruRU', 'Портной Штормграда', 44325),
+(  92, 'zhCN', '暴风城裁缝训练师', 44325),
+(  92, 'zhTW', '暴風城裁縫訓練師', 44325),
+(  93, 'deDE', 'Ingenieurskunst von Sturmwind', 44325),
+(  93, 'esES', 'Ingeniería de Ventormenta', 44325),
+(  93, 'esMX', 'Ingeniería de Ventormenta', 44325),
+(  93, 'frFR', 'Ingénierie de Hurlevent', 44325),
+(  93, 'itIT', 'Ingegneria di Roccavento', 44325),
+(  93, 'koKR', '스톰윈드 전문 기계공학자', 44325),
+(  93, 'ptBR', 'Engenharia de Ventobravo', 44325),
+(  93, 'ruRU', 'Инженер Штормграда', 44325),
+(  93, 'zhCN', '暴风城工程训练师', 44325),
+(  93, 'zhTW', '暴風城工程學訓練師', 44325),
+(  94, 'deDE', 'Schmiedekunst von Sturmwind', 44325),
+(  94, 'esES', 'Herrería de Ventormenta', 44325),
+(  94, 'esMX', 'Herrería de Ventormenta', 44325),
+(  94, 'frFR', 'Forgeron de Hurlevent', 44325),
+(  94, 'itIT', 'Forgiatura di Roccavento', 44325),
+(  94, 'koKR', '스톰윈드 전문 대장장이', 44325),
+(  94, 'ptBR', 'Ferraria de Ventobravo', 44325),
+(  94, 'ruRU', 'Кузнец Штормграда', 44325),
+(  94, 'zhCN', '暴风城锻造训练师', 44325),
+(  94, 'zhTW', '暴風城鍛造訓練師', 44325),
+(  95, 'deDE', 'Bergbau von Sturmwind', 44325),
+(  95, 'esES', 'Minería de Ventormenta', 44325),
+(  95, 'esMX', 'Minería de Ventormenta', 44325),
+(  95, 'frFR', 'Minage de Hurlevent', 44325),
+(  95, 'itIT', 'Estrazione di Roccavento', 44325),
+(  95, 'koKR', '스톰윈드 광부조합', 44325),
+(  95, 'ptBR', 'Mineração de Ventobravo', 44325),
+(  95, 'ruRU', 'Горняк Штормграда', 44325),
+(  95, 'zhCN', '暴风城采矿训练师', 44325),
+(  95, 'zhTW', '吉爾曼‧石手', 44325),
+( 107, 'deDE', 'Angeln von Sturmwind', 44325),
+( 107, 'esES', 'Pesca de Ventormenta', 44325),
+( 107, 'esMX', 'Pesca de Ventormenta', 44325),
+( 107, 'frFR', 'Pêche de Hurlevent', 44325),
+( 107, 'itIT', 'Pesca di Roccavento', 44325),
+( 107, 'koKR', '스톰윈드 낚시꾼', 44325),
+( 107, 'ptBR', 'Pesca de Ventobravo', 44325),
+( 107, 'ruRU', 'Рыболов Штормграда', 44325),
+( 107, 'zhCN', '暴风城钓鱼训练师', 44325),
+( 107, 'zhTW', '暴風城釣魚訓練師', 44325),
+( 108, 'deDE', 'Verzauberkunst von Sturmwind', 44325),
+( 108, 'esES', 'Encantamiento de Ventormenta', 44325),
+( 108, 'esMX', 'Encantamiento de Ventormenta', 44325),
+( 108, 'frFR', 'Enchantement de Hurlevent', 44325),
+( 108, 'itIT', 'Incantamento di Roccavento', 44325),
+( 108, 'koKR', '스톰윈드 전문 마법부여사', 44325),
+( 108, 'ptBR', 'Encantamento de Ventobravo', 44325),
+( 108, 'ruRU', 'Чародей Штормграда', 44325),
+( 108, 'zhCN', '暴风城附魔训练师', 44325),
+( 108, 'zhTW', '暴風城附魔訓練師', 44325),
+( 527, 'deDE', 'Auktionshaus von Sturmwind', 44325),
+( 527, 'esES', 'Casa de subastas de Ventormenta', 44325),
+( 527, 'esMX', 'Casa de subastas de Ventormenta', 44325),
+( 527, 'frFR', 'Hôtel des ventes de Hurlevent', 44325),
+( 527, 'itIT', 'Casa d''Aste di Roccavento', 44325),
+( 527, 'koKR', '스톰윈드 경매장', 44325),
+( 527, 'ptBR', 'Casa de Leilões de Ventobravo', 44325),
+( 527, 'ruRU', 'Штормград: аукционный дом', 44325),
+( 527, 'zhCN', '暴风城拍卖行', 44325),
+( 527, 'zhTW', '暴風城拍賣場', 44325),
+( 529, 'deDE', 'Gasthaus von Sturmwind', 44325),
+( 529, 'esES', 'Posada de Ventormenta', 44325),
+( 529, 'esMX', 'Posada de Ventormenta', 44325),
+( 529, 'frFR', 'Auberge de Hurlevent', 44325),
+( 529, 'itIT', 'Locanda di Roccavento', 44325),
+( 529, 'koKR', '스톰윈드 여관', 44325),
+( 529, 'ptBR', 'Estalagem de Ventobravo', 44325),
+( 529, 'ruRU', 'Таверна Штормграда', 44325),
+( 529, 'zhCN', '暴风城旅店', 44325),
+( 529, 'zhTW', '暴風城旅店', 44325),
+( 532, 'deDE', 'Tiefenbahn von Sturmwind', 44325),
+( 532, 'esES', 'Tranvía de Ventormenta', 44325),
+( 532, 'esMX', 'Tranvía de Ventormenta', 44325),
+( 532, 'frFR', 'Tram de Hurlevent', 44325),
+( 532, 'itIT', 'Tram di Roccavento', 44325),
+( 532, 'koKR', '스톰윈드 지하철', 44325),
+( 532, 'ptBR', 'Metrô de Ventobravo', 44325),
+( 532, 'ruRU', 'Метро Штормграда', 44325),
+( 532, 'zhCN', '暴风城矿道地铁', 44325),
+( 532, 'zhTW', '暴風城', 44325),
+( 870, 'deDE', 'Stallmeister von Sturmwind', 44325),
+( 870, 'esES', 'Maestro de establos de Ventormenta', 44325),
+( 870, 'esMX', 'Maestro de establos de Ventormenta', 44325),
+( 870, 'frFR', 'Maître des écuries de Hurlevent', 44325),
+( 870, 'itIT', 'Stalliere di Roccavento', 44325),
+( 870, 'koKR', '스톰윈드 야수 관리인', 44325),
+( 870, 'ptBR', 'Mestre de Estábulo de Ventobravo', 44325),
+( 870, 'ruRU', 'Смотритель стойл Штормграда', 44325),
+( 870, 'zhCN', '暴风城兽栏管理员', 44325),
+( 870, 'zhTW', '暴風城獸欄管理員', 44325),
+(1427, 'deDE', 'Erste Hilfe von Sturmwind', 44325),
+(1427, 'esES', 'Primeros auxilios de Ventormenta', 44325),
+(1427, 'esMX', 'Primeros auxilios de Ventormenta', 44325),
+(1427, 'frFR', 'Secourisme de Hurlevent', 44325),
+(1427, 'itIT', 'Pronto Soccorso di Roccavento', 44325),
+(1427, 'koKR', '스톰윈드 응급치료사', 44325),
+(1427, 'ptBR', 'Primeiros Socorros de Ventobravo', 44325),
+(1427, 'ruRU', 'Первая помощь Штормграда', 44325),
+(1427, 'zhCN', '暴风城急救训练师', 44325),
+(1427, 'zhTW', '暴風城急救訓練師', 44325),
+(1467, 'deDE', 'Halle der Champions von Sturmwind', 44325),
+(1467, 'esES', 'Sala de los Campeones de Ventormenta', 44325),
+(1467, 'esMX', 'Sala de los Campeones de Ventormenta', 44325),
+(1467, 'frFR', 'Hall des Champions de Hurlevent', 44325),
+(1467, 'itIT', 'Sala dei Campioni di Roccavento', 44325),
+(1467, 'koKR', '스톰윈드 용사의 전당', 44325),
+(1467, 'ptBR', 'Salão dos Campeões de Ventobravo', 44325),
+(1467, 'ruRU', 'Зал Защитников Штормграда', 44325),
+(1467, 'zhCN', '暴风城勇士大厅', 44325),
+(1467, 'zhTW', '暴風城勇士大廳', 44325),
+(2110, 'deDE', 'Hafen von Sturmwind', 44325),
+(2110, 'esES', 'Puerto de Ventormenta', 44325),
+(2110, 'esMX', 'Puerto de Ventormenta', 44325),
+(2110, 'frFR', 'Port de Hurlevent', 44325),
+(2110, 'itIT', 'Porto di Roccavento', 44325),
+(2110, 'koKR', '스톰윈드 항구', 44325),
+(2110, 'ptBR', 'Porto de Ventobravo', 44325),
+(2110, 'ruRU', 'Порт Штормграда', 44325),
+(2110, 'zhCN', '暴风城港口', 44325),
+(2110, 'zhTW', '暴風港', 44325),
+(2202, 'deDE', 'Barbier von Sturmwind', 44325),
+(2202, 'esES', 'Peluquería de Ventormenta', 44325),
+(2202, 'esMX', 'Peluquería de Ventormenta', 44325),
+(2202, 'frFR', 'Salon de coiffure de Hurlevent', 44325),
+(2202, 'itIT', 'Barbiere di Roccavento', 44325),
+(2202, 'koKR', '스톰윈드 미용실', 44325),
+(2202, 'ptBR', 'Barbeiro de Ventobravo', 44325),
+(2202, 'ruRU', 'Штормградский парикмахер', 44325),
+(2202, 'zhCN', '暴风城理发店', 44325),
+(2202, 'zhTW', '暴風城美容師', 44325),
+(2272, 'deDE', 'Inschriftenkunde von Sturmwind', 44325),
+(2272, 'esES', 'Inscripción de Ventormenta', 44325),
+(2272, 'esMX', 'Inscripción de Ventormenta', 44325),
+(2272, 'frFR', 'Calligraphie de Hurlevent', 44325),
+(2272, 'itIT', 'Runografia di Roccavento', 44325),
+(2272, 'koKR', '스톰윈드 전문 주문각인사', 44325),
+(2272, 'ptBR', 'Escrivania de Ventobravo', 44325),
+(2272, 'ruRU', 'Начертатель Штормграда', 44325),
+(2272, 'zhCN', '暴风城铭文训练师', 44325),
+(2272, 'zhTW', '暴風城銘文學訓練師', 44325),
+(2415, 'deDE', 'Bank von Sturmwind', 44325),
+(2415, 'esES', 'Banco de Ventormenta', 44325),
+(2415, 'esMX', 'Banco de Ventormenta', 44325),
+(2415, 'frFR', 'Banque de Hurlevent', 44325),
+(2415, 'itIT', 'Banca di Roccavento', 44325),
+(2415, 'koKR', '스톰윈드 은행', 44325),
+(2415, 'ptBR', 'Ventobravo', 44325),
+(2415, 'ruRU', 'Штормград: банк', 44325),
+(2415, 'zhCN', '暴风城银行', 44325),
+(2415, 'zhTW', '暴風城銀行', 44325),
+(2416, 'deDE', 'Auktionshaus von Sturmwind', 44325),
+(2416, 'esES', 'Casa de subastas de Ventormenta', 44325),
+(2416, 'esMX', 'Casa de subastas de Ventormenta', 44325),
+(2416, 'frFR', 'Hôtel des ventes de Hurlevent', 44325),
+(2416, 'itIT', 'Casa d''Aste di Roccavento', 44325),
+(2416, 'koKR', '스톰윈드 경매장', 44325),
+(2416, 'ptBR', 'Casa de Leilões de Ventobravo', 44325),
+(2416, 'ruRU', 'Штормград: аукционный дом', 44325),
+(2416, 'zhCN', '暴风城拍卖行', 44325),
+(2416, 'zhTW', '暴風城拍賣場', 44325),
+(2418, 'deDE', 'Stallmeister von Sturmwind', 44325),
+(2418, 'esES', 'Maestro de establos de Ventormenta', 44325),
+(2418, 'esMX', 'Maestro de establos de Ventormenta', 44325),
+(2418, 'frFR', 'Maître des écuries de Hurlevent', 44325),
+(2418, 'itIT', 'Stalliere di Roccavento', 44325),
+(2418, 'koKR', '스톰윈드 야수 관리인', 44325),
+(2418, 'ptBR', 'Mestre de Estábulo de Ventobravo', 44325),
+(2418, 'ruRU', 'Смотритель стойл Штормграда', 44325),
+(2418, 'zhCN', '暴风城兽栏管理员', 44325),
+(2418, 'zhTW', '暴風城獸欄管理員', 44325),
+(2419, 'deDE', 'Gasthaus von Sturmwind', 44325),
+(2419, 'esES', 'Posada de Ventormenta', 44325),
+(2419, 'esMX', 'Posada de Ventormenta', 44325),
+(2419, 'frFR', 'Auberge de Hurlevent', 44325),
+(2419, 'itIT', 'Locanda di Roccavento', 44325),
+(2419, 'koKR', '스톰윈드 여관', 44325),
+(2419, 'ptBR', 'Estalagem de Ventobravo', 44325),
+(2419, 'ruRU', 'Таверна Штормграда', 44325),
+(2419, 'zhCN', '暴风城旅店', 44325),
+(2419, 'zhTW', '暴風城旅店', 44325),
+(2420, 'deDE', 'Burg Sturmwind', 44325),
+(2420, 'esES', 'Castillo de Ventormenta', 44325),
+(2420, 'esMX', 'Castillo de Ventormenta', 44325),
+(2420, 'frFR', 'Donjon de Hurlevent', 44325),
+(2420, 'itIT', 'Forte di Roccavento', 44325),
+(2420, 'koKR', '스톰윈드 왕궁', 44325),
+(2420, 'ptBR', 'Bastilha Ventobravo', 44325),
+(2420, 'ruRU', 'Крепость Штормграда', 44325),
+(2420, 'zhCN', '暴风要塞', 44325),
+(2420, 'zhTW', '暴風要塞', 44325),
+(2421, 'deDE', 'Verlies von Sturmwind', 44325),
+(2421, 'esES', 'Mazmorras de Ventormenta', 44325),
+(2421, 'esMX', 'Mazmorras de Ventormenta', 44325),
+(2421, 'frFR', 'Prison de Hurlevent', 44325),
+(2421, 'itIT', 'Segrete di Roccavento', 44325),
+(2421, 'koKR', '스톰윈드 지하감옥', 44325),
+(2421, 'ptBR', 'Cárcere de Ventobravo', 44325),
+(2421, 'ruRU', 'Тюрьма Штормграда', 44325),
+(2421, 'zhCN', '暴风城监狱', 44325),
+(2421, 'zhTW', '暴風城監獄', 44325),
+(2422, 'deDE', 'Reitlehrer & Reittiere von Sturmwind', 44325),
+(2422, 'esES', 'Monturas e instructor de montar de Ventormenta', 44325),
+(2422, 'esMX', 'Monturas e instructor de montar de Ventormenta', 44325),
+(2422, 'frFR', 'Instructeur de monte et montures de Hurlevent', 44325),
+(2422, 'itIT', 'Equitazione e Cavalcature di Roccavento', 44325),
+(2422, 'koKR', '스톰윈드 전문 기수와 탈것', 44325),
+(2422, 'ptBR', 'Treinamento de Montaria e Montarias de Ventobravo', 44325),
+(2422, 'ruRU', 'Штормградский наставник верховой ', 44325),
+(2422, 'zhCN', '暴风城骑术训练师及坐骑商人', 44325),
+(2422, 'zhTW', '暴風城騎術訓練師與坐騎', 44325),
+(2423, 'deDE', 'Fluglehrer & Fliegende Reittiere von Sturmwind', 44325),
+(2423, 'esES', 'Monturas e instructor de vuelo de Ventormenta', 44325),
+(2423, 'esMX', 'Monturas e instructor de vuelo de Ventormenta', 44325),
+(2423, 'frFR', 'Maître de vol et montures de Hurlevent', 44325),
+(2423, 'itIT', 'Istruttore di Volo di Roccavento', 44325),
+(2423, 'koKR', '스톰윈드 비행 교관과 탈것', 44325),
+(2423, 'ptBR', 'Treinamento de Voo e Montarias de Ventobravo', 44325),
+(2423, 'ruRU', 'Штормградский летный инструктор и', 44325),
+(2423, 'zhCN', '暴风城飞行训练师及坐骑商人', 44325),
+(2423, 'zhTW', '暴風城飛行訓練師與坐騎', 44325),
+(2424, 'deDE', 'Archäologie von Sturmwind', 44325),
+(2424, 'esES', 'Arqueología de Ventormenta', 44325),
+(2424, 'esMX', 'Arqueología de Ventormenta', 44325),
+(2424, 'frFR', 'Archéologie de Hurlevent', 44325),
+(2424, 'itIT', 'Archeologia di Roccavento', 44325),
+(2424, 'koKR', '스톰윈드 고고학자', 44325),
+(2424, 'ptBR', 'Arqueologia de Ventobravo', 44325),
+(2424, 'ruRU', 'Штормград: археология', 44325),
+(2424, 'zhCN', '暴风城考古学训练师', 44325),
+(2424, 'zhTW', '暴風城考古學', 44325),
+(2425, 'deDE', 'Juwelierskunst von Sturmwind', 44325),
+(2425, 'esES', 'Joyería de Ventormenta', 44325),
+(2425, 'esMX', 'Joyería de Ventormenta', 44325),
+(2425, 'frFR', 'Joaillerie de Hurlevent', 44325),
+(2425, 'itIT', 'Oreficeria di Roccavento', 44325),
+(2425, 'koKR', '스톰윈드 전문 보석세공인', 44325),
+(2425, 'ptBR', 'Joalheria de Ventobravo', 44325),
+(2425, 'ruRU', 'Ювелир Штормграда', 44325),
+(2425, 'zhCN', '暴风城珠宝训练师', 44325),
+(2425, 'zhTW', '暴風城珠寶設計訓練師', 44325),
+(2426, 'deDE', 'Rüstmeister für Tapferkeitspunkte von Sturmwind', 44325),
+(2426, 'esES', 'Intendentes de heroísmo y valor de Ventormenta', 44325),
+(2426, 'esMX', 'Intendentes de heroísmo y valor de Ventormenta', 44325),
+(2426, 'frFR', 'Intendants des emblèmes d’héroïsme et de vaillance de Hurl', 44325),
+(2426, 'itIT', 'Quartiermastro di Eroismo e Valore di Roccavento', 44325),
+(2426, 'koKR', '스톰윈드 무용과 용맹 병참장교', 44325),
+(2426, 'ptBR', 'Intendentes de Heroísmo & Bravura de Ventobravo', 44325),
+(2426, 'ruRU', 'Интенданты героизма и доблести Шт', 44325), -- Интенданты героизма и доблести Штормграда (truncated)
+(2426, 'zhCN', '暴风城英雄及勇气军需官', 44325),
+(2426, 'zhTW', '暴風城英雄與勇氣點數軍需官', 44325),
+(2427, 'deDE', 'Rüstmeister für Eroberungs- & Ehrenpunkte von Sturmwind', 44325),
+(2427, 'esES', 'Intendentes de honor y conquista de Ventormenta', 44325),
+(2427, 'esMX', 'Intendentes de honor y conquista de Ventormenta', 44325),
+(2427, 'frFR', 'Intendants de l''honneur et de conquête de Hurlevent', 44325),
+(2427, 'itIT', 'Quartiermastro dell''Onore e Conquista di Roccavento', 44325),
+(2427, 'koKR', '스톰윈드 명예와 정복 병참장교', 44325),
+(2427, 'ptBR', 'Intendentes de Conquista & Honra de Ventobravo', 44325),
+(2427, 'ruRU', 'Интенданты чести и завоевания Што', 44325), -- Интенданты чести и завоевания Штормграда (truncated)
+(2427, 'zhCN', '暴风城荣誉及征服军需官', 44325),
+(2427, 'zhTW', '暴風城榮譽與征服點數軍需官', 44325),
+(2518, 'deDE', 'Portale von Sturmwind in die Kataklysmusregionen', 44325),
+(2518, 'esES', 'Portales de Cataclysm de Ventormenta', 44325),
+(2518, 'esMX', 'Portales de Cataclysm en Ventormenta', 44325),
+(2518, 'frFR', 'Portails de Hurlevent de Cataclysm', 44325),
+(2518, 'itIT', 'Portali di Roccavento di Cataclysm', 44325),
+(2518, 'koKR', '스톰윈드 대격변 차원문', 44325),
+(2518, 'ptBR', 'Portais de Ventobravo para Cataclysm', 44325),
+(2518, 'ruRU', 'Штормград: порталы Катаклизма', 44325),
+(2518, 'zhCN', '暴风城大灾变传送门', 44325),
+(2518, 'zhTW', '暴風城浩劫與重生傳送門', 44325),
+(2714, 'deDE', 'Die Drei Winde', 44325),
+(2714, 'esES', 'Los Tres Vientos', 44325),
+(2714, 'esMX', 'Los Tres Vientos', 44325),
+(2714, 'frFR', 'Les trois vents', 44325),
+(2714, 'itIT', 'Tre Venti', 44325),
+(2714, 'koKR', '세 바람의 마법상점', 44325),
+(2714, 'ptBR', 'Os Três Ventos', 44325),
+(2714, 'ruRU', 'Три ветра', 44325),
+(2714, 'zhCN', '三缕风', 44325),
+(2714, 'zhTW', '三陣風', 44325),
+(2887, 'deDE', 'Kampfhaustiertrainer von Sturmwind', 44325),
+(2887, 'esES', 'Instructor de mascotas de duelo de Ventormenta', 44325),
+(2887, 'esMX', 'Instructor de mascotas de duelo de Ventormenta', 44325),
+(2887, 'frFR', 'Dresseur de mascottes de combat de Hurlevent', 44325),
+(2887, 'itIT', 'Istruttore di Mascotte di Roccavento', 44325),
+(2887, 'koKR', '스톰윈드 전투 애완동물 조련사', 44325),
+(2887, 'ptBR', 'Ventobravo - Adestramento de Batalha', 44325),
+(2887, 'ruRU', 'Штормградский наставник боевых пи', 44325),
+(2887, 'zhCN', '暴风城战斗宠物训练师', 44325),
+(2887, 'zhTW', '暴風城戰寵訓練師', 44325),
+(5993, 'deDE', 'Sturmwindschiff nach Kul Tiras', 44325),
+(5993, 'esES', 'Barco de Ventormenta a Kul Tiras', 44325),
+(5993, 'esMX', 'Nave de Ventormenta a Kul Tiras', 44325),
+(5993, 'frFR', 'Navire de Hurlevent vers Kul Tiras', 44325),
+(5993, 'itIT', 'Nave di Roccavento per Kul Tiras.', 44325),
+(5993, 'koKR', '쿨 티라스로 가는 스톰윈드 함선', 44325),
+(5993, 'ptBR', 'Navio de Ventobravo para Kul Tiraz', 44325),
+(5993, 'ruRU', 'Штормградский корабль в Кул-Тирас', 44325),
+(5993, 'zhCN', '从暴风城前往库尔提拉斯的船只', 44325),
+(5993, 'zhTW', '往庫爾提拉斯的暴風城船艦', 44325),
+(6014, 'deDE', 'Portalkammer von Sturmwind', 44325),
+(6014, 'esES', 'Sala de portales de Ventormenta', 44325),
+(6014, 'esMX', 'Sala de Portales de Ventormenta', 44325),
+(6014, 'frFR', 'Salle des portails de Hurlevent', 44325),
+(6014, 'itIT', 'Stanza dei Portali di Roccavento', 44325),
+(6014, 'koKR', '스톰윈드 차원문의 방', 44325),
+(6014, 'ptBR', 'Sala do Portal de Ventobravo', 44325),
+(6014, 'ruRU', 'Зал порталов Штормграда', 44325),
+(6014, 'zhCN', '暴风城传送大厅', 44325),
+(6014, 'zhTW', '暴風城傳送室', 44325),
+(6758, 'deDE', 'Kriegerlehrer von Sturmwind', 44325),
+(6758, 'esES', 'Instructor de guerreros de Ventormenta', 44325),
+(6758, 'esMX', 'Instructor de guerreros de Ventormenta', 44325),
+(6758, 'frFR', 'Maître des guerriers de Hurlevent', 44325),
+(6758, 'itIT', 'Istruttore dei Guerrieri di Roccavento', 44325),
+(6758, 'koKR', '스톰윈드 상급 전사', 44325),
+(6758, 'ptBR', 'Treinamento de Guerreiros de Ventobravo', 44325),
+(6758, 'ruRU', 'Штормградский наставник воинов', 44325),
+(6758, 'zhCN', '暴风城战士训练师', 44325),
+(6758, 'zhTW', '暴風城戰士訓練師', 44325),
+(6759, 'deDE', 'Paladinlehrer von Sturmwind', 44325),
+(6759, 'esES', 'Instructor de paladines de Ventormenta', 44325),
+(6759, 'esMX', 'Instructor de paladines de Ventormenta', 44325),
+(6759, 'frFR', 'Maître des paladins de Hurlevent', 44325),
+(6759, 'itIT', 'Istruttore dei Paladini di Roccavento', 44325),
+(6759, 'koKR', '스톰윈드 상급 성기사', 44325),
+(6759, 'ptBR', 'Treinamento de Paladinos de Ventobravo', 44325),
+(6759, 'ruRU', 'Штормградский наставник паладино', 44325), -- Штормградский наставник паладинов (truncated)
+(6759, 'zhCN', '暴风城圣骑士训练师', 44325),
+(6759, 'zhTW', '暴風城聖騎士訓練師', 44325),
+(6760, 'deDE', 'Priesterlehrer von Sturmwind', 44325),
+(6760, 'esES', 'Instructor de sacerdotes de Ventormenta', 44325),
+(6760, 'esMX', 'Instructor de sacerdotes de Ventormenta', 44325),
+(6760, 'frFR', 'Maître des prêtres de Hurlevent', 44325),
+(6760, 'itIT', 'Istruttore dei Sacerdoti di Roccavento', 44325),
+(6760, 'koKR', '스톰윈드 상급 사제', 44325),
+(6760, 'ptBR', 'Treinamento de Sacerdotes de Ventobravo', 44325),
+(6760, 'ruRU', 'Штормградский наставник жрецов', 44325),
+(6760, 'zhCN', '暴风城牧师训练师', 44325),
+(6760, 'zhTW', '暴風城牧師訓練師', 44325),
+(6761, 'deDE', 'Schamanenlehrer von Sturmwind', 44325),
+(6761, 'esES', 'Instructor de chamanes de Ventormenta', 44325),
+(6761, 'esMX', 'Instructor de chamanes de Ventormenta', 44325),
+(6761, 'frFR', 'Maître des chamans de Hurlevent', 44325),
+(6761, 'itIT', 'Istruttore degli Sciamani di Roccavento', 44325),
+(6761, 'koKR', '스톰윈드 상급 주술사', 44325),
+(6761, 'ptBR', 'Treinamento de Xamãs de Ventobravo', 44325),
+(6761, 'ruRU', 'Штормградский наставник шаманов', 44325),
+(6761, 'zhCN', '暴风城萨满祭司训练师', 44325),
+(6761, 'zhTW', '暴風城薩滿訓練師', 44325),
+(6762, 'deDE', 'Jägerlehrer von Sturmwind', 44325),
+(6762, 'esES', 'Instructor de cazadores de Ventormenta', 44325),
+(6762, 'esMX', 'Instructor de cazadores de Ventormenta', 44325),
+(6762, 'frFR', 'Maître des chasseurs de Hurlevent', 44325),
+(6762, 'itIT', 'Istruttore dei Cacciatori di Roccavento', 44325),
+(6762, 'koKR', '스톰윈드 상급 사냥꾼', 44325),
+(6762, 'ptBR', 'Treinamento de Caçadores de Ventobravo', 44325),
+(6762, 'ruRU', 'Штормградский наставник охотнико', 44325), -- Штормградский наставник охотников (truncated)
+(6762, 'zhCN', '暴风城猎人训练师', 44325),
+(6762, 'zhTW', '暴風城獵人訓練師', 44325),
+(6763, 'deDE', 'Mönchslehrer von Sturmwind', 44325),
+(6763, 'esES', 'Instructor de monjes de Ventormenta', 44325),
+(6763, 'esMX', 'Instructor de monjes de Ventormenta', 44325),
+(6763, 'frFR', 'Maître des moines de Hurlevent', 44325),
+(6763, 'itIT', 'Istruttore dei Monaci di Roccavento', 44325),
+(6763, 'koKR', '스톰윈드 상급 수도사', 44325),
+(6763, 'ptBR', 'Treinamento de Monges de Ventobravo', 44325),
+(6763, 'ruRU', 'Штормградский наставник монахов', 44325),
+(6763, 'zhCN', '暴风城武僧训练师', 44325),
+(6763, 'zhTW', '暴風城武僧訓練師', 44325),
+(6764, 'deDE', 'Magierlehrer von Sturmwind', 44325),
+(6764, 'esES', 'Instructor de magos de Ventormenta', 44325),
+(6764, 'esMX', 'Instructor de magos de Ventormenta', 44325),
+(6764, 'frFR', 'Maître des mages de Hurlevent', 44325),
+(6764, 'itIT', 'Istruttore dei Maghi di Roccavento', 44325),
+(6764, 'koKR', '스톰윈드 상급 마법사', 44325),
+(6764, 'ptBR', 'Treinamento de Magos de Ventobravo', 44325),
+(6764, 'ruRU', 'Штормградский наставник магов', 44325),
+(6764, 'zhCN', '暴风城法师训练师', 44325),
+(6764, 'zhTW', '暴風城法師訓練師', 44325),
+(6765, 'deDE', 'Druidenlehrer von Sturmwind', 44325),
+(6765, 'esES', 'Instructor de druidas de Ventormenta', 44325),
+(6765, 'esMX', 'Instructor de druidas de Ventormenta', 44325),
+(6765, 'frFR', 'Maître des druides de Hurlevent', 44325),
+(6765, 'itIT', 'Istruttore dei Druidi di Roccavento', 44325),
+(6765, 'koKR', '스톰윈드 상급 드루이드', 44325),
+(6765, 'ptBR', 'Treinamento de Druidas de Ventobravo', 44325),
+(6765, 'ruRU', 'Штормград: наставник друидов', 44325),
+(6765, 'zhCN', '暴风城德鲁伊训练师', 44325),
+(6765, 'zhTW', '暴風城德魯伊訓練師', 44325),
+(6766, 'deDE', 'Hexenmeisterlehrer von Sturmwind', 44325),
+(6766, 'esES', 'Instructor de brujos de Ventormenta', 44325),
+(6766, 'esMX', 'Instructor de brujos de Ventormenta', 44325),
+(6766, 'frFR', 'Maître des démonistes de Hurlevent', 44325),
+(6766, 'itIT', 'Istruttore degli Stregoni di Roccavento', 44325),
+(6766, 'koKR', '스톰윈드 상급 흑마법사', 44325),
+(6766, 'ptBR', 'Treinamento de Bruxos de Ventobravo', 44325),
+(6766, 'ruRU', 'Штормградский наставник чернокни', 44325), -- Штормградский наставник чернокнижников (truncated)
+(6766, 'zhCN', '暴风城术士训练师', 44325),
+(6766, 'zhTW', '暴風城術士訓練師', 44325),
+(6767, 'deDE', 'Schurkenlehrer von Sturmwind', 44325),
+(6767, 'esES', 'Instructor de pícaros de Ventormenta', 44325),
+(6767, 'esMX', 'Instructor de pícaros de Ventormenta', 44325),
+(6767, 'frFR', 'Maître des voleurs de Hurlevent', 44325),
+(6767, 'itIT', 'Istruttore dei Ladri di Roccavento', 44325),
+(6767, 'koKR', '스톰윈드 상급 도적', 44325),
+(6767, 'ptBR', 'Treinamento de Ladinos de Ventobravo', 44325),
+(6767, 'ruRU', 'Штормградский наставник разбойни', 44325), -- Штормградский наставник разбойников (truncated)
+(6767, 'zhCN', '暴风城潜行者训练师', 44325),
+(6767, 'zhTW', '暴風城盜賊訓練師', 44325);