DB/Creature: Fixed gossip menus for Silvermoon guards

Ref #17414

1 files changed, 465 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_08_09_06_world_silvermoon.sql b/sql/updates/world/master/2022_08_09_06_world_silvermoon.sql
new file mode 100644
index 00000000000..52d8bb70bf5
--- /dev/null
+++ b/sql/updates/world/master/2022_08_09_06_world_silvermoon.sql
@@ -0,0 +1,465 @@
+SET @TGUID := 510002;
+
+-- Silvermoon City Guardian (Silvermoon City)
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=16222;
+
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (20966, 20967, 24189);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(20966,@TGUID+0,-1), 
+(20967,@TGUID+1,-1),
+(24189,@TGUID+2,-1);
+
+DELETE FROM `npc_text` WHERE `ID` BETWEEN @TGUID+0 AND @TGUID+2;
+INSERT INTO `npc_text` (`ID`, `Probability0`, `BroadcastTextID0`, `VerifiedBuild`) VALUES
+(@TGUID+0,1,129364,-1),
+(@TGUID+1,1,129371,-1),
+(@TGUID+2,1,50625,-1);
+
+UPDATE `gossip_menu_option` SET `OptionText`='Bank' WHERE `MenuID`=7633 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1734 WHERE `MenuID`=7633 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1733 WHERE `MenuID`=7633 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=15224, `ActionPoiID`=1728 WHERE `MenuID`=7633 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=15226, `ActionPoiID`=1864 WHERE `MenuID`=7633 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1860 WHERE `MenuID`=7633 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1730 WHERE `MenuID`=7668 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1738 WHERE `MenuID`=7668 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1729 WHERE `MenuID`=7639 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1739 WHERE `MenuID`=7639 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1731 WHERE `MenuID`=7649 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1741 WHERE `MenuID`=7649 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1855 WHERE `MenuID`=7649 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1737 WHERE `MenuID`=7649 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1746 WHERE `MenuID`=7649 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1854 WHERE `MenuID`=7649 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=18321, `ActionPoiID`=1736 WHERE `MenuID`=7649 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1744 WHERE `MenuID`=7649 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=2541 WHERE `MenuID`=7649 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=2771 WHERE `MenuID`=7649 AND `OptionID`=9;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1728 WHERE `MenuID`=7845 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1892 WHERE `MenuID`=7845 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=1747 WHERE `MenuID`=7667 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `ActionPoiID`=2519 WHERE `MenuID`=7667 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7656, `ActionPoiID`=1740 WHERE `MenuID`=7667 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=16029, `ActionMenuID`=7860, `ActionPoiID`=1893 WHERE `MenuID`=7667 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7657, `ActionPoiID`=1748 WHERE `MenuID`=7667 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7658, `ActionPoiID`=1743 WHERE `MenuID`=7667 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7659, `ActionPoiID`=1732 WHERE `MenuID`=7667 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7660, `ActionPoiID`=1859 WHERE `MenuID`=7667 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7661, `ActionPoiID`=1856 WHERE `MenuID`=7667 AND `OptionID`=8;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45757, `ActionMenuID`=10022, `ActionPoiID`=2281 WHERE `MenuID`=7667 AND `OptionID`=9;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7662, `ActionPoiID`=1858 WHERE `MenuID`=7667 AND `OptionID`=10;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7663, `ActionPoiID`=1735 WHERE `MenuID`=7667 AND `OptionID`=11;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7664, `ActionPoiID`=1862 WHERE `MenuID`=7667 AND `OptionID`=12;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=7665, `ActionPoiID`=1857 WHERE `MenuID`=7667 AND `OptionID`=13;
+UPDATE `gossip_menu_option` SET `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=7666, `ActionPoiID`=1745 WHERE `MenuID`=7667 AND `OptionID`=14;
+UPDATE `gossip_menu_option` SET `VerifiedBuild`=44730 WHERE `MenuID` IN (7633, 7668, 7639, 7649, 7845, 7667);
+
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=20967 OR (`MenuID`=7633 AND `OptionID`=9);
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
+(7633, 9, 0, 'Other Continents', 129362, 1, 1, 0, 20967, 0, 0, 0, NULL, 0, 44730),
+(20967, 0, 0, 'Undercity or Orgrimmar', 129366, 1, 1, 0, 20966, 2050, 0, 0, NULL, 0, 44730),
+(20967, 1, 0, 'Orgrimmar in Kalimdor', 129178, 1, 1, 0, 24189, 6115, 0, 0, NULL, 0, 44730);
+
+DELETE FROM `points_of_interest` WHERE `ID` BETWEEN 10349 AND 10381;
+DELETE FROM `points_of_interest` WHERE `ID` IN (10494, 10495, 10498, 10499);
+DELETE FROM `points_of_interest` WHERE `ID` IN (1728, 1729, 1730, 1731, 1732, 1733, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1743, 1744, 1745, 1746, 1747, 1748, 1854, 1855, 1856, 1857, 1858, 1859, 1860, 1862, 1864, 1892, 1893, 2050, 2281, 2519, 2541, 2771, 6115);
+INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `PositionZ`, `Icon`, `Flags`, `Importance`, `Name`, `Unknown905`, `VerifiedBuild`) VALUES
+(1728, 9673.150390625, -7370.2998046875, 11.93369960784912109, 7, 99, 0, 'Silvermoon City, Inn', 0, 44730),
+(1729, 9525.0400390625, -7215.39990234375, 16.1240997314453125, 7, 99, 0, 'Silvermoon City, Bank', 0, 44730),
+(1730, 9648.0400390625, -7135.56982421875, 58.82630157470703125, 7, 99, 0, 'Silvermoon City, Auction House', 0, 44730),
+(1731, 9704.171875, -7265.8369140625, 16.12518882751464843, 7, 99, 0, 'Silvermoon City, Druid Trainer', 0, 44730),
+(1732, 9592.150390625, -7343.06982421875, 14.16819953918457031, 7, 99, 0, 'Silvermoon City, First Aid', 0, 44730),
+(1733, 9484.73046875, -7345.10009765625, 16.09090042114257812, 7, 99, 0, 'Silvermoon City, Guild House', 0, 44730),
+(1735, 9489.7802734375, -7430.7001953125, 14.16219997406005859, 7, 99, 0, 'Silvermoon City, Leatherworking', 0, 44730),
+(1736, 9703.69921875, -7269.970703125, 16.19112777709960937, 7, 99, 0, 'Silvermoon City, Shaman Trainer', 0, 44730),
+(1737, 9850.8896484375, -7512.6298828125, 19.71419906616210937, 7, 99, 0, 'Silvermoon City, Paladin Trainer', 0, 44730),
+(1738, 9683.169921875, -7518.93994140625, 15.73530006408691406, 7, 99, 0, 'Silvermoon City, Auction House', 0, 44730),
+(1739, 9792.6796875, -7488.06005859375, 13.5476999282836914, 7, 99, 0, 'Silvermoon City, Bank', 0, 44730),
+(1740, 9841.2197265625, -7367.580078125, 18.60379981994628906, 7, 99, 0, 'Silvermoon City, Blacksmithing', 0, 44730),
+(1741, 9934.2197265625, -7411.7099609375, 12.35809993743896484, 7, 99, 0, 'Silvermoon City, Hunter Trainer', 0, 44730),
+(1743, 9826.919921875, -7323.2998046875, 26.28149986267089843, 7, 99, 0, 'Silvermoon City, Engineering', 0, 44730),
+(1744, 9801.759765625, -7322.77978515625, 14.68610000610351562, 7, 99, 0, 'Silvermoon City, Warlock Trainer', 0, 44730),
+(1745, 9732.4599609375, -7086.60986328125, 3.590500116348266601, 7, 99, 0, 'Silvermoon City, Tailoring', 0, 44730),
+(1746, 9936.98046875, -7058.41015625, 47.715301513671875, 7, 99, 0, 'Silvermoon City, Priest Trainer', 0, 44730),
+(1747, 10007.599609375, -7213.22998046875, 32.07649993896484375, 7, 99, 0, 'Silvermoon City, Alchemy', 0, 44730),
+(1748, 9956.169921875, -7244.75, 32.07649993896484375, 7, 99, 0, 'Silvermoon City, Enchanting', 0, 44730),
+(1854, 9740.58984375, -7370.85009765625, 24.35140037536621093, 7, 99, 0, 'Silvermoon City, Rogue Trainer', 0, 44730),
+(1855, 9998.33984375, -7106.580078125, 47.70489883422851562, 7, 99, 0, 'Silvermoon City, Mage Trainer', 0, 44730),
+(1856, 10000.400390625, -7209.02978515625, 32.0764007568359375, 7, 99, 0, 'Silvermoon City, Herbalism', 0, 44730),
+(1857, 9512.509765625, -7425.990234375, 14.19919967651367187, 7, 99, 0, 'Silvermoon City, Skinning', 0, 44730),
+(1858, 9553.4599609375, -7501.89013671875, 16.25670051574707031, 7, 99, 0, 'Silvermoon City, Jewelcrafting', 0, 44730),
+(1859, 9605, -7328.43994140625, 14.46790027618408203, 7, 99, 0, 'Silvermoon City, Fishing', 0, 44730),
+(1860, 9903.7998046875, -7404.16015625, 13.62839984893798828, 7, 99, 0, 'Silvermoon City, Stable Master', 0, 44730),
+(1862, 9810, -7358.41015625, 20.69339942932128906, 7, 99, 0, 'Silvermoon City, Mining', 0, 44730),
+(1864, 9743.58984375, -7466.39013671875, 13.77989959716796875, 7, 99, 0, 'Silvermoon City, Mailbox', 0, 44730),
+(1892, 9561.1201171875, -7216.60009765625, 16.21220016479492187, 7, 99, 0, 'Silvermoon City, Inn', 0, 44730),
+(1893, 9577.9296875, -7240.72021484375, 27.03109931945800781, 7, 99, 0, 'Silvermoon City, Cooking', 0, 44730),
+(2050, 10039.2001953125, -7000.9501953125, 61.9532012939453125, 7, 99, 0, 'Silvermoon City, Teleporter', 0, 44730),
+(2281, 9956.2900390625, -7238.35009765625, 32.07649993896484375, 7, 99, 0, 'Silvermoon City Inscription', 0, 44730),
+(2519, 9638.3095703125, -7392.759765625, 15.72500038146972656, 7, 99, 0, 'Silvermoon City, Archaeology', 0, 44730),
+(2541, 9849.6796875, -7381.35986328125, 18.61020088195800781, 7, 99, 0, 'Silvermoon City, Warrior Trainer', 0, 44730),
+(2771, 9832.21875, -7405.8662109375, 13.62053966522216796, 7, 99, 0, 'Silvermoon City, Monk Trainer', 0, 44730),
+(6115, 10000.2998046875, -7107.56005859375, 47.7061004638671875, 7, 99, 0, 'Portal to Orgrimmar', 0, 44730);
+
+DELETE FROM `points_of_interest_locale` WHERE `ID` IN (1728, 1729, 1730, 1731, 1732, 1733, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1743, 1744, 1745, 1746, 1747, 1748, 1854, 1855, 1856, 1857, 1858, 1859, 1860, 1862, 1864, 1892, 1893, 2050, 2281, 2519, 2541, 2771, 6115);
+INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+(1728, 'deDE', 'Gasthaus von Silbermond', 44730),
+(1728, 'esES', 'Ciudad de Lunargenta, posada', 44730),
+(1728, 'esMX', 'Ciudad de Lunargenta, posada', 44730),
+(1728, 'frFR', 'Auberge de Lune-d’Argent', 44730),
+(1728, 'itIT', 'Locanda di Lunargenta', 44730),
+(1728, 'koKR', '실버문 여관', 44730),
+(1728, 'ptBR', 'Luaprata, Estalagem', 44730),
+(1728, 'ruRU', 'Луносвет: таверна', 44730),
+(1728, 'zhCN', '银月城旅店', 44730),
+(1728, 'zhTW', '銀月城，旅店', 44730),
+(1729, 'deDE', 'Bank von Silbermond', 44730),
+(1729, 'esES', 'Ciudad de Lunargenta, banco', 44730),
+(1729, 'esMX', 'Ciudad de Lunargenta, banco', 44730),
+(1729, 'frFR', 'Banque de Lune-d’Argent', 44730),
+(1729, 'itIT', 'Banca di Lunargenta', 44730),
+(1729, 'koKR', '실버문 은행', 44730),
+(1729, 'ptBR', 'Luaprata, Banco', 44730),
+(1729, 'ruRU', 'Луносвет: банк', 44730),
+(1729, 'zhCN', '银月城银行', 44730),
+(1729, 'zhTW', '銀月城，銀行', 44730),
+(1730, 'deDE', 'Auktionshaus von Silbermond', 44730),
+(1730, 'esES', 'Ciudad de Lunargenta, casa de subastas', 44730),
+(1730, 'esMX', 'Ciudad de Lunargenta, casa de subastas', 44730),
+(1730, 'frFR', 'Hôtel des ventes de Lune-d’Argent', 44730),
+(1730, 'itIT', 'Casa d''Aste di Lunargenta', 44730),
+(1730, 'koKR', '실버문 경매장', 44730),
+(1730, 'ptBR', 'Luaprata, Casa de Leilões', 44730),
+(1730, 'ruRU', 'Луносвет: аукционный дом', 44730),
+(1730, 'zhCN', '银月城拍卖行', 44730),
+(1730, 'zhTW', '銀月城，拍賣場', 44730),
+(1731, 'deDE', 'Druidenlehrer von Silbermond', 44730),
+(1731, 'esES', 'Ciudad de Lunargenta, instructor de druidas', 44730),
+(1731, 'esMX', 'Ciudad de Lunargenta, instructor de druidas', 44730),
+(1731, 'frFR', 'Maître des druides de Lune-d’Argent', 44730),
+(1731, 'itIT', 'Istruttore dei Druidi di Lunargenta', 44730),
+(1731, 'koKR', '실버문 상급 드루이드', 44730),
+(1731, 'ptBR', 'Luaprata, Treinamento de Druidas', 44730),
+(1731, 'ruRU', 'Луносвет: наставник друидов', 44730),
+(1731, 'zhCN', '银月城德鲁伊训练师', 44730),
+(1731, 'zhTW', '銀月城，德魯伊訓練師', 44730),
+(1732, 'deDE', 'Erste Hilfe von Silbermond', 44730),
+(1732, 'esES', 'Ciudad de Lunargenta, primeros auxilios', 44730),
+(1732, 'esMX', 'Ciudad de Lunargenta, primeros auxilios', 44730),
+(1732, 'frFR', 'Secourisme de Lune-d’Argent', 44730),
+(1732, 'itIT', 'Pronto Soccorso di Lunargenta', 44730),
+(1732, 'koKR', '실버문 응급치료사', 44730),
+(1732, 'ptBR', 'Luaprata, Primeiros Socorros', 44730),
+(1732, 'ruRU', 'Луносвет: первая помощь', 44730),
+(1732, 'zhCN', '银月城急救师', 44730),
+(1732, 'zhTW', '銀月城，急救', 44730),
+(1733, 'deDE', 'Gildenhaus von Silbermond', 44730),
+(1733, 'esES', 'Ciudad de Lunargenta, casa de la Hermandad', 44730),
+(1733, 'esMX', 'Ciudad de Lunargenta, casa de la Hermandad', 44730),
+(1733, 'frFR', 'Maison des guildes de Lune-d’Argent', 44730),
+(1733, 'itIT', 'Mastro di Gilda di Lunargenta', 44730),
+(1733, 'koKR', '실버문 길드 사무관', 44730),
+(1733, 'ptBR', 'Luaprata, Casa de Guildas', 44730),
+(1733, 'ruRU', 'Луносвет: дом гильдий', 44730),
+(1733, 'zhCN', '银月城公会大厅', 44730),
+(1733, 'zhTW', '銀月城，公會', 44730),
+(1735, 'deDE', 'Lederverarbeitung von Silbermond', 44730),
+(1735, 'esES', 'Ciudad de Lunargenta, peletería', 44730),
+(1735, 'esMX', 'Ciudad de Lunargenta, peletería', 44730),
+(1735, 'frFR', 'Artisanat du cuir de Lune-d’Argent', 44730),
+(1735, 'itIT', 'Conciatura di Lunargenta', 44730),
+(1735, 'koKR', '실버문 전문 가죽세공인', 44730),
+(1735, 'ptBR', 'Luaprata, Couraria', 44730),
+(1735, 'ruRU', 'Луносвет: кожевничество', 44730),
+(1735, 'zhCN', '银月城制皮师', 44730),
+(1735, 'zhTW', '銀月城，製皮', 44730),
+(1736, 'deDE', 'Schamanenlehrer von Silbermond', 44730),
+(1736, 'esES', 'Ciudad de Lunargenta, instructor de chamanes', 44730),
+(1736, 'esMX', 'Ciudad de Lunargenta, instructor de chamanes', 44730),
+(1736, 'frFR', 'Maître des chamans de Lune-d’Argent', 44730),
+(1736, 'itIT', 'Istruttore degli Sciamani di Lunargenta', 44730),
+(1736, 'koKR', '실버문 상급 주술사', 44730),
+(1736, 'ptBR', 'Luaprata, Treinamento de Xamãs', 44730),
+(1736, 'ruRU', 'Луносвет: наставник шаманов', 44730),
+(1736, 'zhCN', '银月城萨满祭司训练师', 44730),
+(1736, 'zhTW', '銀月城，薩滿訓練師', 44730),
+(1737, 'deDE', 'Paladinlehrer von Silbermond', 44730),
+(1737, 'esES', 'Ciudad de Lunargenta, instructor de paladines', 44730),
+(1737, 'esMX', 'Ciudad de Lunargenta, instructor de paladines', 44730),
+(1737, 'frFR', 'Maître des paladins de Lune-d’Argent', 44730),
+(1737, 'itIT', 'Istruttore dei Paladini di Lunargenta', 44730),
+(1737, 'koKR', '실버문 상급 성기사', 44730),
+(1737, 'ptBR', 'Luaprata, Treinamento de Paladinos', 44730),
+(1737, 'ruRU', 'Луносвет: наставник паладинов', 44730),
+(1737, 'zhCN', '银月城圣骑士训练师', 44730),
+(1737, 'zhTW', '銀月城，聖騎士訓練師', 44730),
+(1738, 'deDE', 'Auktionshaus von Silbermond', 44730),
+(1738, 'esES', 'Ciudad de Lunargenta, casa de subastas', 44730),
+(1738, 'esMX', 'Ciudad de Lunargenta, casa de subastas', 44730),
+(1738, 'frFR', 'Hôtel des ventes de Lune-d’Argent', 44730),
+(1738, 'itIT', 'Casa d''Aste di Lunargenta', 44730),
+(1738, 'koKR', '실버문 경매장', 44730),
+(1738, 'ptBR', 'Luaprata, Casa de Leilões', 44730),
+(1738, 'ruRU', 'Луносвет: аукционный дом', 44730),
+(1738, 'zhCN', '银月城拍卖行', 44730),
+(1738, 'zhTW', '銀月城，拍賣場', 44730),
+(1739, 'deDE', 'Bank von Silbermond', 44730),
+(1739, 'esES', 'Ciudad de Lunargenta, banco', 44730),
+(1739, 'esMX', 'Ciudad de Lunargenta, banco', 44730),
+(1739, 'frFR', 'Banque de Lune-d’Argent', 44730),
+(1739, 'itIT', 'Banca di Lunargenta', 44730),
+(1739, 'koKR', '실버문 은행', 44730),
+(1739, 'ptBR', 'Luaprata, Banco', 44730),
+(1739, 'ruRU', 'Луносвет: банк', 44730),
+(1739, 'zhCN', '银月城银行', 44730),
+(1739, 'zhTW', '銀月城，銀行', 44730),
+(1740, 'deDE', 'Schmiedekunst von Silbermond', 44730),
+(1740, 'esES', 'Ciudad de Lunargenta, herrería', 44730),
+(1740, 'esMX', 'Ciudad de Lunargenta, herrería', 44730),
+(1740, 'frFR', 'Forge de Lune-d’Argent', 44730),
+(1740, 'itIT', 'Forgiatura di Lunargenta', 44730),
+(1740, 'koKR', '실버문 전문 대장장이', 44730),
+(1740, 'ptBR', 'Luaprata, Ferraria', 44730),
+(1740, 'ruRU', 'Луносвет: кузнечных дел мастера', 44730),
+(1740, 'zhCN', '银月城铁匠', 44730),
+(1740, 'zhTW', '銀月城，鐵匠', 44730),
+(1741, 'deDE', 'Jägerlehrer von Silbermond', 44730),
+(1741, 'esES', 'Ciudad de Lunargenta, instructor de cazadores', 44730),
+(1741, 'esMX', 'Ciudad de Lunargenta, instructor de cazadores', 44730),
+(1741, 'frFR', 'Maître des chasseurs de Lune-d’Argent', 44730),
+(1741, 'itIT', 'Istruttore dei Cacciatori di Lunargenta', 44730),
+(1741, 'koKR', '실버문 상급 사냥꾼', 44730),
+(1741, 'ptBR', 'Luaprata, Treinamento de Caçadores', 44730),
+(1741, 'ruRU', 'Луносвет: наставник охотников', 44730),
+(1741, 'zhCN', '银月城猎人训练师', 44730),
+(1741, 'zhTW', '銀月城，獵人訓練師', 44730),
+(1743, 'deDE', 'Ingenieurskunst von Silbermond', 44730),
+(1743, 'esES', 'Ciudad de Lunargenta, ingeniería', 44730),
+(1743, 'esMX', 'Ciudad de Lunargenta, ingeniería', 44730),
+(1743, 'frFR', 'Ingénierie de Lune-d’Argent', 44730),
+(1743, 'itIT', 'Ingegneria di Lunargenta', 44730),
+(1743, 'koKR', '실버문 전문 기계공학자', 44730),
+(1743, 'ptBR', 'Luaprata, Engenharia', 44730),
+(1743, 'ruRU', 'Луносвет: инженерное дело', 44730),
+(1743, 'zhCN', '银月城技师', 44730),
+(1743, 'zhTW', '銀月城，工程學', 44730),
+(1744, 'deDE', 'Hexenmeisterlehrer von Silbermond', 44730),
+(1744, 'esES', 'Ciudad de Lunargenta, instructor de brujos', 44730),
+(1744, 'esMX', 'Ciudad de Lunargenta, instructor de brujos', 44730),
+(1744, 'frFR', 'Lune-d’Argent, maître des démonistes', 44730),
+(1744, 'itIT', 'Istruttore degli Stregoni di Lunargenta', 44730),
+(1744, 'koKR', '실버문 상급 흑마법사', 44730),
+(1744, 'ptBR', 'Luaprata, Treinamento de Bruxos', 44730),
+(1744, 'ruRU', 'Луносвет: наставник чернокнижнико', 44730),
+(1744, 'zhCN', '银月城术士训练师', 44730),
+(1744, 'zhTW', '銀月城，術士訓練師', 44730),
+(1745, 'deDE', 'Schneiderei von Silbermond', 44730),
+(1745, 'esES', 'Ciudad de Lunargenta, sastrería', 44730),
+(1745, 'esMX', 'Ciudad de Lunargenta, sastrería', 44730),
+(1745, 'frFR', 'Couture de Lune-d’Argent', 44730),
+(1745, 'itIT', 'Sartoria di Lunargenta', 44730),
+(1745, 'koKR', '실버문 전문 재봉사', 44730),
+(1745, 'ptBR', 'Luaprata, Alfaiataria', 44730),
+(1745, 'ruRU', 'Луносветский портной', 44730),
+(1745, 'zhCN', '银月城裁缝', 44730),
+(1745, 'zhTW', '銀月城，裁縫', 44730),
+(1746, 'deDE', 'Priesterlehrer von Silbermond', 44730),
+(1746, 'esES', 'Ciudad de Lunargenta, instructor de sacerdotes', 44730),
+(1746, 'esMX', 'Ciudad de Lunargenta, instructor de sacerdotes', 44730),
+(1746, 'frFR', 'Maître des prêtres de Lune-d’Argent', 44730),
+(1746, 'itIT', 'Istruttore dei Sacerdoti di Lunargenta', 44730),
+(1746, 'koKR', '실버문 상급 사제', 44730),
+(1746, 'ptBR', 'Luaprata, Treinamento de Sacerdotes', 44730),
+(1746, 'ruRU', 'Луносвет: наставник жрецов', 44730),
+(1746, 'zhCN', '银月城牧师训练师', 44730),
+(1746, 'zhTW', '銀月城，牧師訓練師', 44730),
+(1747, 'deDE', 'Alchemie von Silbermond', 44730),
+(1747, 'esES', 'Ciudad de Lunargenta, alquimia', 44730),
+(1747, 'esMX', 'Ciudad de Lunargenta, alquimia', 44730),
+(1747, 'frFR', 'Alchimie de Lune-d’Argent', 44730),
+(1747, 'itIT', 'Alchimia di Lunargenta', 44730),
+(1747, 'koKR', '실버문 전문 연금술사', 44730),
+(1747, 'ptBR', 'Luaprata, Alquimia', 44730),
+(1747, 'ruRU', 'Луносвет: Алхимия', 44730),
+(1747, 'zhCN', '银月城炼金师', 44730),
+(1747, 'zhTW', '銀月城，鍊金術', 44730),
+(1748, 'deDE', 'Verzauberkunst von Silbermond', 44730),
+(1748, 'esES', 'Ciudad de Lunargenta, encantamiento', 44730),
+(1748, 'esMX', 'Ciudad de Lunargenta, encantamiento', 44730),
+(1748, 'frFR', 'Enchantement de Lune-d’Argent', 44730),
+(1748, 'itIT', 'Incantamento di Lunargenta', 44730),
+(1748, 'koKR', '실버문 전문 마법부여사', 44730),
+(1748, 'ptBR', 'Luaprata, Encantamento', 44730),
+(1748, 'ruRU', 'Луносвет: наложение чар', 44730),
+(1748, 'zhCN', '银月城附魔师', 44730),
+(1748, 'zhTW', '銀月城，附魔師', 44730),
+(1854, 'deDE', 'Schurkenlehrer von Silbermond', 44730),
+(1854, 'esES', 'Ciudad de Lunargenta, instructor de pícaros', 44730),
+(1854, 'esMX', 'Ciudad de Lunargenta, instructor de pícaros', 44730),
+(1854, 'frFR', 'Maître des voleurs de Lune-d’Argent', 44730),
+(1854, 'itIT', 'Istruttore dei Ladri di Lunargenta', 44730),
+(1854, 'koKR', '실버문 상급 도적', 44730),
+(1854, 'ptBR', 'Luaprata, Treinamento de Ladinos', 44730),
+(1854, 'ruRU', 'Луносвет: наставник разбойников', 44730),
+(1854, 'zhCN', '银月城潜行者训练师', 44730),
+(1854, 'zhTW', '銀月城，盜賊訓練師', 44730),
+(1855, 'deDE', 'Magierlehrer von Silbermond', 44730),
+(1855, 'esES', 'Ciudad de Lunargenta, instructor de magos', 44730),
+(1855, 'esMX', 'Ciudad de Lunargenta, instructor de magos', 44730),
+(1855, 'frFR', 'Maître des magiciens de Lune-d’Argent', 44730),
+(1855, 'itIT', 'Istruttore dei Maghi di Lunargenta', 44730),
+(1855, 'koKR', '실버문 상급 마법사', 44730),
+(1855, 'ptBR', 'Luaprata, Treinamento de Magos', 44730),
+(1855, 'ruRU', 'Луносвет: наставник магов', 44730),
+(1855, 'zhCN', '银月城法师训练师', 44730),
+(1855, 'zhTW', '銀月城，法師訓練師', 44730),
+(1856, 'deDE', 'Kräuterkunde von Silbermond', 44730),
+(1856, 'esES', 'Ciudad de Lunargenta, herboristería', 44730),
+(1856, 'esMX', 'Ciudad de Lunargenta, herboristería', 44730),
+(1856, 'frFR', 'Herboristerie de Lune-d’Argent', 44730),
+(1856, 'itIT', 'Erbalismo di Lunargenta', 44730),
+(1856, 'koKR', '실버문 전문 약초채집사', 44730),
+(1856, 'ptBR', 'Luaprata, Herborismo', 44730),
+(1856, 'ruRU', 'Луносвет: травничество', 44730),
+(1856, 'zhCN', '银月城草药师', 44730),
+(1856, 'zhTW', '銀月城，草藥學', 44730),
+(1857, 'deDE', 'Kürschnerei von Silbermond', 44730),
+(1857, 'esES', 'Ciudad de Lunargenta, desuello', 44730),
+(1857, 'esMX', 'Ciudad de Lunargenta, desuello', 44730),
+(1857, 'frFR', 'Dépeçage de Lune-d’Argent', 44730),
+(1857, 'itIT', 'Scuoiatura di Lunargenta', 44730),
+(1857, 'koKR', '실버문 전문 무두장이', 44730),
+(1857, 'ptBR', 'Luaprata, Esfolamento', 44730),
+(1857, 'ruRU', 'Луносветский специалист по снятию', 44730),
+(1857, 'zhCN', '银月城剥皮师', 44730),
+(1857, 'zhTW', '銀月城，剝皮', 44730),
+(1858, 'deDE', 'Juwelierskunst von Silbermond', 44730),
+(1858, 'esES', 'Ciudad de Lunargenta, joyería', 44730),
+(1858, 'esMX', 'Ciudad de Lunargenta, joyería', 44730),
+(1858, 'frFR', 'Joaillerie de Lune-d’Argent', 44730),
+(1858, 'itIT', 'Oreficeria di Lunargenta', 44730),
+(1858, 'koKR', '실버문 전문 보석세공인', 44730),
+(1858, 'ptBR', 'Luaprata, Joalheria', 44730),
+(1858, 'ruRU', 'Луносвет: ювелирное дело', 44730),
+(1858, 'zhCN', '银月城珠宝匠', 44730),
+(1858, 'zhTW', '銀月城，珠寶設計', 44730),
+(1859, 'deDE', 'Angeln von Silbermond', 44730),
+(1859, 'esES', 'Ciudad de Lunargenta, pesca', 44730),
+(1859, 'esMX', 'Ciudad de Lunargenta, pesca', 44730),
+(1859, 'frFR', 'Pêche de Lune-d’Argent', 44730),
+(1859, 'itIT', 'Pesca di Lunargenta', 44730),
+(1859, 'koKR', '실버문 낚시꾼', 44730),
+(1859, 'ptBR', 'Luaprata, Pesca', 44730),
+(1859, 'ruRU', 'Луносвет: рыбная ловля', 44730),
+(1859, 'zhCN', '银月城渔夫', 44730),
+(1859, 'zhTW', '銀月城，釣魚', 44730),
+(1860, 'deDE', 'Stallmeister von Silbermond', 44730),
+(1860, 'esES', 'Ciudad de Lunargenta, maestro de establos', 44730),
+(1860, 'esMX', 'Ciudad de Lunargenta, maestro de establos', 44730),
+(1860, 'frFR', 'Maître des écuries de Lune-d’Argent', 44730),
+(1860, 'itIT', 'Stalliere di Lunargenta', 44730),
+(1860, 'koKR', '실버문 야수 관리인', 44730),
+(1860, 'ptBR', 'Luaprata, Mestre de Estábulo', 44730),
+(1860, 'ruRU', 'Луносвет: смотритель стойл', 44730),
+(1860, 'zhCN', '银月城兽栏管理员', 44730),
+(1860, 'zhTW', '銀月城，獸欄管理員', 44730),
+(1862, 'deDE', 'Bergbau von Silbermond', 44730),
+(1862, 'esES', 'Ciudad de Lunargenta, minería', 44730),
+(1862, 'esMX', 'Ciudad de Lunargenta, minería', 44730),
+(1862, 'frFR', 'Minage de Lune-d’Argent', 44730),
+(1862, 'itIT', 'Estrazione di Lunargenta', 44730),
+(1862, 'koKR', '실버문 전문 광부', 44730),
+(1862, 'ptBR', 'Luaprata, Mineração', 44730),
+(1862, 'ruRU', 'Луносвет: горное дело', 44730),
+(1862, 'zhCN', '银月城矿工', 44730),
+(1862, 'zhTW', '銀月城，採礦', 44730),
+(1864, 'deDE', 'Briefkasten von Silbermond', 44730),
+(1864, 'esES', 'Ciudad de Lunargenta, buzón de correo', 44730),
+(1864, 'esMX', 'Ciudad de Lunargenta, buzón de correo', 44730),
+(1864, 'frFR', 'Boîte aux lettres de Lune-d’Argent', 44730),
+(1864, 'itIT', 'Cassetta della Posta di Lunargenta', 44730),
+(1864, 'koKR', '실버문 우체통', 44730),
+(1864, 'ptBR', 'Luaprata, Caixa de Correio', 44730),
+(1864, 'ruRU', 'Луносвет: почта', 44730),
+(1864, 'zhCN', '银月城邮箱', 44730),
+(1864, 'zhTW', '銀月城，郵箱', 44730),
+(1892, 'deDE', 'Gasthaus von Silbermond', 44730),
+(1892, 'esES', 'Ciudad de Lunargenta, posada', 44730),
+(1892, 'esMX', 'Ciudad de Lunargenta, posada', 44730),
+(1892, 'frFR', 'Auberge de Lune-d’Argent', 44730),
+(1892, 'itIT', 'Locanda di Lunargenta', 44730),
+(1892, 'koKR', '실버문 여관', 44730),
+(1892, 'ptBR', 'Luaprata, Estalagem', 44730),
+(1892, 'ruRU', 'Луносвет: таверна', 44730),
+(1892, 'zhCN', '银月城旅店', 44730),
+(1892, 'zhTW', '銀月城，旅店', 44730),
+(1893, 'deDE', 'Kochkunst von Silbermond', 44730),
+(1893, 'esES', 'Ciudad de Lunargenta, cocina', 44730),
+(1893, 'esMX', 'Ciudad de Lunargenta, cocina', 44730),
+(1893, 'frFR', 'Cuisine de Lune-d’Argent', 44730),
+(1893, 'itIT', 'Cucina di Lunargenta', 44730),
+(1893, 'koKR', '실버문 요리사', 44730),
+(1893, 'ptBR', 'Luaprata, Culinária', 44730),
+(1893, 'ruRU', 'Луносвет, кулинария', 44730),
+(1893, 'zhCN', '银月城厨师', 44730),
+(1893, 'zhTW', '銀月城，烹飪', 44730),
+(2050, 'deDE', 'Teleporter von Silbermond', 44730),
+(2050, 'esES', 'Ciudad de Lunargenta, teletransportador', 44730),
+(2050, 'esMX', 'Ciudad de Lunargenta, teletransportador', 44730),
+(2050, 'frFR', 'Téléporteur de Lune-d’Argent', 44730),
+(2050, 'itIT', 'Teletrasporto di Lunargenta', 44730),
+(2050, 'koKR', '실버문 순간이동기', 44730),
+(2050, 'ptBR', 'Luaprata, Teleportador', 44730),
+(2050, 'ruRU', 'Луносвет: телепорт', 44730),
+(2050, 'zhCN', '银月城传送点', 44730),
+(2050, 'zhTW', '銀月城，傳送者', 44730),
+(2281, 'deDE', 'Inschriftenkunde von Silbermond', 44730),
+(2281, 'esES', 'Inscripción de la Ciudad de Lunargenta', 44730),
+(2281, 'esMX', 'Inscripción de la Ciudad de Lunargenta', 44730),
+(2281, 'frFR', 'Calligraphie de Lune-d’Argent', 44730),
+(2281, 'itIT', 'Runografia di Lunargenta', 44730),
+(2281, 'koKR', '실버문 전문 주문각인사', 44730),
+(2281, 'ptBR', 'Escrivania de Luaprata', 44730),
+(2281, 'ruRU', 'Луносветский начертатель', 44730),
+(2281, 'zhCN', '银月城铭文训练师', 44730),
+(2281, 'zhTW', '銀月城銘文坊', 44730),
+(2519, 'deDE', 'Archäologie von Silbermond', 44730),
+(2519, 'esES', 'Arqueología de la Ciudad de Lunargenta', 44730),
+(2519, 'esMX', 'Arqueología de la Ciudad de Lunargenta', 44730),
+(2519, 'frFR', 'Zone archéologique de Lune-d’Argent', 44730),
+(2519, 'itIT', 'Archeologia di Lunargenta', 44730),
+(2519, 'koKR', '실버문 고고학자', 44730),
+(2519, 'ptBR', 'Luaprata, Arqueologia', 44730),
+(2519, 'ruRU', 'Луносвет: археология', 44730),
+(2519, 'zhCN', '银月城考古学训练师', 44730),
+(2519, 'zhTW', '銀月城考古學', 44730),
+(2541, 'deDE', 'Kriegerlehrer von Silbermond', 44730),
+(2541, 'esES', 'Ciudad de Lunargenta, instructor de guerreros', 44730),
+(2541, 'esMX', 'Ciudad de Lunargenta, instructor de guerreros', 44730),
+(2541, 'frFR', 'Lune-d’Argent, maître des guerriers', 44730),
+(2541, 'itIT', 'Istruttore dei Guerrieri di Lunargenta', 44730),
+(2541, 'koKR', '실버문 상급 전사', 44730),
+(2541, 'ptBR', 'Luaprata, Treinamento de Guerreiros', 44730),
+(2541, 'ruRU', 'Луносвет: наставник воинов', 44730),
+(2541, 'zhCN', '银月城术士训练师', 44730),
+(2541, 'zhTW', '銀月城，戰士訓練師', 44730),
+(2771, 'deDE', 'Mönchslehrer von Silbermond', 44730),
+(2771, 'esES', 'Ciudad de Lunargenta, instructor de monjes', 44730),
+(2771, 'esMX', 'Ciudad de Lunargenta, instructor de monjes', 44730),
+(2771, 'frFR', 'Maître des moines de Lune-d’Argent', 44730),
+(2771, 'itIT', 'Istruttore dei Monaci di Lunargenta', 44730),
+(2771, 'koKR', '실버문 상급 수도사', 44730),
+(2771, 'ptBR', 'Luaprata, Treinamento de Monges', 44730),
+(2771, 'ruRU', 'Луносвет: наставник монахов', 44730),
+(2771, 'zhCN', '银月城，武僧训练师', 44730),
+(2771, 'zhTW', '銀月城武僧訓練師', 44730),
+(6115, 'deDE', 'Portal nach Orgrimmar', 44730),
+(6115, 'esES', 'Portal a Orgrimmar', 44730),
+(6115, 'esMX', 'Portal a Orgrimmar', 44730),
+(6115, 'frFR', 'Portail vers Orgrimmar', 44730),
+(6115, 'itIT', 'Portale per Orgrimmar', 44730),
+(6115, 'koKR', '오그리마로 통하는 차원문', 44730),
+(6115, 'ptBR', 'Portal para Orgrimmar', 44730),
+(6115, 'ruRU', 'Портал в Оргриммар', 44730),
+(6115, 'zhCN', '通往奥格瑞玛的传送门', 44730),
+(6115, 'zhTW', '奧格瑪傳送門', 44730);