DB/Creature: Fixed gossip menus for Dolanaar guards

Ref #17414

1 files changed, 124 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_29_05_world_dolanaar.sql b/sql/updates/world/master/2022_07_29_05_world_dolanaar.sql
new file mode 100644
index 00000000000..c8ce7258665
--- /dev/null
+++ b/sql/updates/world/master/2022_07_29_05_world_dolanaar.sql
@@ -0,0 +1,124 @@
+-- Teldrassil Sentinel (Dolanaar)
+DELETE FROM `gossip_menu` WHERE `MenuID`=12632;
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(12632, 17759, -1);
+
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=7066 WHERE `MenuID`=3580 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=7075, `ActionPoiID`=698 WHERE `MenuID`=3580 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=8508, `ActionPoiID`=871 WHERE `MenuID`=3580 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=7078 WHERE `MenuID`=3580 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=7095, `ActionPoiID`=3057 WHERE `MenuID`=3580 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=5330 WHERE `MenuID`=3580 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2914, `ActionPoiID`=697 WHERE `MenuID`=3564 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2924, `ActionPoiID`=693 WHERE `MenuID`=3564 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2902, `ActionPoiID`=2630 WHERE `MenuID`=3564 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2918, `ActionPoiID`=690 WHERE `MenuID`=3564 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2906, `ActionPoiID`=692 WHERE `MenuID`=3564 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2910, `ActionPoiID`=691 WHERE `MenuID`=3564 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `VerifiedBuild`=44325 WHERE `MenuID` IN (3564, 3580);
+
+DELETE FROM `points_of_interest` WHERE `ID` IN (10111, 10112, 10113, 10114, 10115, 10116, 10117, 10578, 10579);
+DELETE FROM `points_of_interest` WHERE `ID` IN (690, 691, 692, 693, 697, 698, 871, 2630, 3057);
+INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `PositionZ`, `Icon`, `Flags`, `Importance`, `Name`, `Unknown905`, `VerifiedBuild`) VALUES
+(690, 9906.16015625, 986.635986328125, 1313.8299560546875, 7, 99, 0, 'Laurna Morninglight', 0, 44325),
+(691, 9821.9697265625, 950.61602783203125, 1308.77001953125, 7, 99, 0, 'Kyra Windblade', 0, 44325),
+(692, 9789.01953125, 942.864990234375, 1308.780029296875, 7, 99, 0, 'Jannok Breezesong', 0, 44325),
+(693, 9815.1201171875, 926.28302001953125, 1307.93994140625, 7, 99, 0, 'Dazalar', 0, 44325),
+(697, 9741.580078125, 963.70501708984375, 1293.6400146484375, 7, 99, 0, 'Kal', 0, 44325),
+(698, 9821.490234375, 960.13800048828125, 1308.800048828125, 7, 99, 0, 'Dolanaar Inn', 0, 44325),
+(871, 9808.3701171875, 931.10601806640625, 1307.6800537109375, 7, 99, 0, 'Seriadne', 0, 44325),
+(2630, 9835.0537109375, 956.36285400390625, 1308.774658203125, 7, 99, 0, 'Irriende', 0, 44325),
+(3057, 9803.2001953125, 945.72222900390625, 1308.77197265625, 7, 99, 0, 'Iranis Shadebloom', 0, 44325);
+
+DELETE FROM `points_of_interest_locale` WHERE `ID` IN (690, 691, 692, 693, 697, 698, 871, 2630, 3057);
+INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+( 690, 'deDE', 'Laurna Morgenglanz', 44325),
+( 690, 'esES', 'Laurna Luzdelalba', 44325),
+( 690, 'esMX', 'Laurna Luzdelalba', 44325),
+( 690, 'frFR', 'Laurna Clairematin', 44325),
+( 690, 'itIT', 'Laurna Veraluce', 44325),
+( 690, 'koKR', '라우르나 모닝라이트', 44325),
+( 690, 'ptBR', 'Laurna Luzalbor', 44325),
+( 690, 'ruRU', 'Лорна Утренний Свет', 44325),
+( 690, 'zhCN', '劳尔娜·晨光', 44325),
+( 690, 'zhTW', '勞爾娜‧晨光', 44325),
+( 691, 'deDE', 'Kyra Windklinge', 44325),
+( 691, 'esES', 'Kyra Espada del Viento', 44325),
+( 691, 'esMX', 'Kyra Espada del Viento', 44325),
+( 691, 'frFR', 'Kyra Lamevent', 44325),
+( 691, 'itIT', 'Kyra Lamasvelta', 44325),
+( 691, 'koKR', '키라 윈드블레이드', 44325),
+( 691, 'ptBR', 'Kyra Laminéola', 44325),
+( 691, 'ruRU', 'Кайра Ветрорез', 44325),
+( 691, 'zhCN', '凯拉·风刃', 44325),
+( 691, 'zhTW', '凱拉‧風刃', 44325),
+( 692, 'deDE', 'Jannok Windsang', 44325),
+( 692, 'esES', 'Jannok Brisón', 44325),
+( 692, 'esMX', 'Jannok Brisón', 44325),
+( 692, 'frFR', 'Jannok Chantebrise', 44325),
+( 692, 'itIT', 'Jannok Cantabrezza', 44325),
+( 692, 'koKR', '잔노크 브리즈송', 44325),
+( 692, 'ptBR', 'Jannok Brisacanto', 44325),
+( 692, 'ruRU', 'Джаннок Поющий Ветерок', 44325),
+( 692, 'zhCN', '詹诺克·柔歌', 44325),
+( 692, 'zhTW', '詹諾克‧柔歌', 44325),
+( 693, 'deDE', 'Dazalar', 44325),
+( 693, 'esES', 'Dazalar', 44325),
+( 693, 'esMX', 'Dazalar', 44325),
+( 693, 'frFR', 'Dazalar', 44325),
+( 693, 'itIT', 'Dazalar', 44325),
+( 693, 'koKR', '다잘라', 44325),
+( 693, 'ptBR', 'Dazalar', 44325),
+( 693, 'ruRU', 'Дазалар', 44325),
+( 693, 'zhCN', '达扎拉', 44325),
+( 693, 'zhTW', '達札拉', 44325),
+( 697, 'deDE', 'Kal', 44325),
+( 697, 'esES', 'Kal', 44325),
+( 697, 'esMX', 'Kal', 44325),
+( 697, 'frFR', 'Kal', 44325),
+( 697, 'itIT', 'Kal', 44325),
+( 697, 'koKR', '칼', 44325),
+( 697, 'ptBR', 'Kal', 44325),
+( 697, 'ruRU', 'Каль', 44325),
+( 697, 'zhCN', '卡尔', 44325),
+( 697, 'zhTW', '卡爾', 44325),
+( 698, 'deDE', 'Gasthaus von Dolanaar', 44325),
+( 698, 'esES', 'Posada de Dolanaar', 44325),
+( 698, 'esMX', 'Posada de Dolanaar', 44325),
+( 698, 'frFR', 'Auberge de Dolanaar', 44325),
+( 698, 'itIT', 'Locanda di Dolanaar', 44325),
+( 698, 'koKR', '돌라나르 여관', 44325),
+( 698, 'ptBR', 'Estalagem de Dolanaar', 44325),
+( 698, 'ruRU', 'Таверна Доланаара', 44325),
+( 698, 'zhCN', '多兰纳尔旅店', 44325),
+( 698, 'zhTW', '多蘭納爾旅店', 44325),
+( 871, 'deDE', 'Seriadne', 44325),
+( 871, 'esES', 'Seriadne', 44325),
+( 871, 'esMX', 'Seriadne', 44325),
+( 871, 'frFR', 'Seriadne', 44325),
+( 871, 'itIT', 'Seriadne', 44325),
+( 871, 'koKR', '세리아드네', 44325),
+( 871, 'ptBR', 'Seriadne', 44325),
+( 871, 'ruRU', 'Сериадна', 44325),
+( 871, 'zhCN', '瑟里亚迪', 44325),
+( 871, 'zhTW', '瑟里亞迪', 44325),
+(2630, 'deDE', 'Irriende', 44325),
+(2630, 'esES', 'Irriende', 44325),
+(2630, 'esMX', 'Irriende', 44325),
+(2630, 'frFR', 'Irriende', 44325),
+(2630, 'itIT', 'Irriende', 44325),
+(2630, 'koKR', '이리엔드', 44325),
+(2630, 'ptBR', 'Irriende', 44325),
+(2630, 'ruRU', 'Ирринде', 44325),
+(2630, 'zhCN', '艾莉恩蒂', 44325),
+(2630, 'zhTW', '伊莉恩德', 44325),
+(3057, 'deDE', 'Iranis Schattenblüte', 44325),
+(3057, 'esES', 'Iranis Sombraflor', 44325),
+(3057, 'esMX', 'Iranis Sombraflor', 44325),
+(3057, 'frFR', 'Iranis Ombrefleur', 44325),
+(3057, 'itIT', 'Iranis Sbocciaombre', 44325),
+(3057, 'koKR', '이라니스 셰이드블룸', 44325),
+(3057, 'ptBR', 'Iranis Brotossombra', 44325),
+(3057, 'ruRU', 'Иранис Темный Цветок', 44325),
+(3057, 'zhCN', '伊兰尼斯·影花', 44325),
+(3057, 'zhTW', '伊蘭尼斯‧影綻', 44325);