DB/Creature: Fixed gossip menus for Razor Hill guards

Ref #17414

1 files changed, 256 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_29_10_world_razor_hill.sql b/sql/updates/world/master/2022_07_29_10_world_razor_hill.sql
new file mode 100644
index 00000000000..241bc3af6db
--- /dev/null
+++ b/sql/updates/world/master/2022_07_29_10_world_razor_hill.sql
@@ -0,0 +1,256 @@
+SET @TGUID := 550000;
+
+-- Razor Hill Grunt | Darkspear Guardian | Thunder Bluff Protector (Razor Hill)
+UPDATE `creature_template` SET `gossip_menu_id`=3285, `minlevel`=60, `maxlevel`=60 WHERE `entry`=75685;
+UPDATE `creature_template` SET `gossip_menu_id`=16168, `minlevel`=60, `maxlevel`=60, `unit_flags3`=8388608 WHERE `entry`=75686;
+UPDATE `creature_template` SET `gossip_menu_id`=16167, `minlevel`=60, `maxlevel`=60, `unit_flags3`=8388608 WHERE `entry`=75687;
+
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (13006, 15732);
+DELETE FROM `gossip_menu` WHERE `MenuID` BETWEEN 16167 AND 16196;
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(13006,18277,-1),
+(15732,22592,-1),
+(16167,@TGUID+0,-1),
+(16168,@TGUID+1,-1),
+(16169,@TGUID+2,-1),
+(16170,@TGUID+3,-1),
+(16171,@TGUID+4,-1),
+(16172,@TGUID+5,-1),
+(16173,@TGUID+6,-1),
+(16174,@TGUID+7,-1),
+(16175,@TGUID+8,-1),
+(16176,@TGUID+9,-1),
+(16177,@TGUID+10,-1),
+(16178,@TGUID+11,-1),
+(16179,@TGUID+12,-1),
+(16180,@TGUID+13,-1),
+(16181,@TGUID+14,-1),
+(16182,@TGUID+15,-1),
+(16183,@TGUID+16,-1),
+(16184,@TGUID+17,-1),
+(16185,@TGUID+18,-1),
+(16186,@TGUID+19,-1),
+(16187,@TGUID+20,-1),
+(16188,@TGUID+21,-1),
+(16189,@TGUID+22,-1),
+(16190,@TGUID+23,-1),
+(16191,@TGUID+24,-1),
+(16192,@TGUID+25,-1),
+(16193,@TGUID+26,-1),
+(16194,@TGUID+27,-1),
+(16195,@TGUID+28,-1),
+(16196,@TGUID+29,-1);
+
+UPDATE `npc_text` SET `Probability0`=0, `Probability1`=0, `Probability2`=1, `BroadcastTextID2`=50552 WHERE `ID`=4014;
+UPDATE `npc_text` SET `Probability0`=0, `Probability1`=0 WHERE `ID`=4033;
+
+DELETE FROM `npc_text` WHERE `ID` IN (18277, 22592);
+DELETE FROM `npc_text` WHERE `ID` BETWEEN @TGUID+0 AND @TGUID+29;
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `BroadcastTextID0`,  `BroadcastTextID1`, `VerifiedBuild`) VALUES
+(18277,1,0,53015,0,-1),
+(22592,1,0,74284,0,-1),
+(@TGUID+0,1,0,78627,0,-1),
+(@TGUID+1,1,0,78604,0,-1),
+(@TGUID+2,1,0.1,78587,78588,-1),
+(@TGUID+3,1,0,78589,0,-1),
+(@TGUID+4,1,0,78590,0,-1),
+(@TGUID+5,1,0,78591,0,-1),
+(@TGUID+6,1,0,78593,0,-1),
+(@TGUID+7,1,0,78594,0,-1),
+(@TGUID+8,1,0,78595,0,-1),
+(@TGUID+9,1,0,78596,0,-1),
+(@TGUID+10,1,0.1,78597,78610,-1),
+(@TGUID+11,1,0,78598,0,-1),
+(@TGUID+12,1,0,78599,0,-1),
+(@TGUID+13,1,0,78601,0,-1),
+(@TGUID+14,1,0,78602,0,-1),
+(@TGUID+15,1,0,78592,0,-1),
+(@TGUID+16,1,0,78613,0,-1),
+(@TGUID+17,1,0,78618,0,-1),
+(@TGUID+18,1,0,78619,0,-1),
+(@TGUID+19,1,0,78615,0,-1),
+(@TGUID+20,1,0,78620,0,-1),
+(@TGUID+21,1,0,78616,0,-1),
+(@TGUID+22,1,0,78621,0,-1),
+(@TGUID+23,1,0,78622,0,-1),
+(@TGUID+24,1,0,78628,0,-1),
+(@TGUID+25,1,0,78623,0,-1),
+(@TGUID+26,1,0,78624,0,-1),
+(@TGUID+27,1,0,78617,0,-1),
+(@TGUID+28,1,0,78625,0,-1),
+(@TGUID+29,1,0,78626,0,-1);
+
+UPDATE `gossip_menu_option` SET `OptionText`='Bank', `OptionBroadcastTextId`=3426, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=3280 WHERE `MenuID`=3285 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionText`='Flight Master', `OptionBroadcastTextId`=2863, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=3281 WHERE `MenuID`=3285 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionText`='Inn', `OptionBroadcastTextId`=5513, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=3282, `ActionPoiID`=587 WHERE `MenuID`=3285 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `OptionText`='Stable Master', `OptionBroadcastTextId`=8508, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=4901, `ActionPoiID`=847 WHERE `MenuID`=3285 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionText`='Class Trainer', `OptionBroadcastTextId`=2868, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=3283 WHERE `MenuID`=3285 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `OptionText`='Profession Trainer', `OptionBroadcastTextId`=2869, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=15732, `ActionPoiID`=3056 WHERE `MenuID`=3285 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2914, `ActionMenuID`=13006, `ActionPoiID`=2709 WHERE `MenuID`=3283 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2924, `ActionMenuID`=3261, `ActionPoiID`=588 WHERE `MenuID`=3283 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2902, `ActionMenuID`=3262, `ActionPoiID`=589 WHERE `MenuID`=3283 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2918, `ActionMenuID`=3263, `ActionPoiID`=590 WHERE `MenuID`=3283 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2906, `ActionMenuID`=3264, `ActionPoiID`=591 WHERE `MenuID`=3283 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3450, `ActionMenuID`=3265, `ActionPoiID`=592 WHERE `MenuID`=3283 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2926, `ActionMenuID`=3266, `ActionPoiID`=594 WHERE `MenuID`=3283 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2910, `OptionType`=1, `OptionNpcFlag`=1, `ActionMenuID`=3267, `ActionPoiID`=593 WHERE `MenuID`=3283 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `VerifiedBuild`=44325 WHERE `MenuID` IN (3285, 3283);
+
+DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (16167, 16168, 16182, 16184);
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
+(16168, 0, 0, 'Bank', 3426, 1, 1, 0, 16169, 0, 0, 0, NULL, 0, 44325),
+(16168, 1, 0, 'Flight Master', 2863, 1, 1, 0, 16170, 0, 0, 0, NULL, 0, 44325),
+(16168, 2, 0, 'Inn', 5513, 1, 1, 0, 16171, 587, 0, 0, NULL, 0, 44325),
+(16168, 3, 0, 'Stable Master', 8508, 1, 1, 0, 16172, 847, 0, 0, NULL, 0, 44325),
+(16168, 4, 0, 'Class Trainer', 2868, 1, 1, 0, 16182, 0, 0, 0, NULL, 0, 44325),
+(16168, 5, 0, 'Profession Trainer', 2869, 1, 1, 0, 16181, 3056, 0, 0, NULL, 0, 44325),
+(16182, 0, 0, 'Druid', 2914, 1, 1, 0, 16173, 2709, 0, 0, NULL, 0, 44325),
+(16182, 1, 0, 'Hunter', 2924, 1, 1, 0, 16174, 588, 0, 0, NULL, 0, 44325),
+(16182, 2, 0, 'Mage', 2902, 1, 1, 0, 16175, 589, 0, 0, NULL, 0, 44325),
+(16182, 3, 0, 'Priest', 2918, 1, 1, 0, 16176, 590, 0, 0, NULL, 0, 44325),
+(16182, 4, 0, 'Rogue', 2906, 1, 1, 0, 16177, 591, 0, 0, NULL, 0, 44325),
+(16182, 5, 0, 'Shaman', 3450, 1, 1, 0, 16178, 592, 0, 0, NULL, 0, 44325),
+(16182, 6, 0, 'Warlock', 2926, 1, 1, 0, 16179, 594, 0, 0, NULL, 0, 44325),
+(16182, 7, 0, 'Warrior', 2910, 1, 1, 0, 16180, 593, 0, 0, NULL, 0, 44325),
+(16167, 0, 0, 'Bank', 3426, 1, 1, 0, 16183, 0, 0, 0, NULL, 0, 44325),
+(16167, 1, 0, 'Flight Master', 2863, 1, 1, 0, 16186, 0, 0, 0, NULL, 0, 44325),
+(16167, 2, 0, 'Inn', 5513, 1, 1, 0, 16188, 587, 0, 0, NULL, 0, 44325),
+(16167, 3, 0, 'Stable Master', 8508, 1, 1, 0, 16194, 847, 0, 0, NULL, 0, 44325),
+(16167, 4, 0, 'Class Trainer', 2868, 1, 1, 0, 16184, 0, 0, 0, NULL, 0, 44325),
+(16167, 5, 0, 'Profession Trainer', 2869, 1, 1, 0, 16191, 3056, 0, 0, NULL, 0, 44325),
+(16184, 0, 0, 'Druid', 2914, 1, 1, 0, 16185, 2709, 0, 0, NULL, 0, 44325),
+(16184, 1, 0, 'Hunter', 2924, 1, 1, 0, 16187, 588, 0, 0, NULL, 0, 44325),
+(16184, 2, 0, 'Mage', 2902, 1, 1, 0, 16189, 589, 0, 0, NULL, 0, 44325),
+(16184, 3, 0, 'Priest', 2918, 1, 1, 0, 16190, 590, 0, 0, NULL, 0, 44325),
+(16184, 4, 0, 'Rogue', 2906, 1, 1, 0, 16192, 591, 0, 0, NULL, 0, 44325),
+(16184, 5, 0, 'Shaman', 3450, 1, 1, 0, 16193, 592, 0, 0, NULL, 0, 44325),
+(16184, 6, 0, 'Warlock', 2926, 1, 1, 0, 16195, 594, 0, 0, NULL, 0, 44325),
+(16184, 7, 0, 'Warrior', 2910, 1, 1, 0, 16196, 593, 0, 0, NULL, 0, 44325);
+
+DELETE FROM `points_of_interest` WHERE `ID` IN (10403, 10404, 10405, 10406, 10407, 10408, 10409, 10410, 10411);
+DELETE FROM `points_of_interest` WHERE `ID` IN (587, 588, 589, 590, 591, 592, 593, 594, 847, 2709, 3056);
+INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `PositionZ`, `Icon`, `Flags`, `Importance`, `Name`, `Unknown905`, `VerifiedBuild`) VALUES
+(587, 338.709014892578125, -4688.8701171875, 16.45779991149902343, 7, 99, 0, 'Razor Hill Inn', 0, 44325),
+(588, 276.066986083984375, -4706.72998046875, 11.62489986419677734, 7, 99, 0, 'Thotar', 0, 44325),
+(589, -839.33001708984375, -4935.60986328125, 20.98990058898925781, 7, 99, 0, 'Un''Thuwa', 0, 44325), -- Blizzard bug: coords not updated to Cataclysm and later exps
+(590, 296.225006103515625, -4828.10986328125, 10.5233001708984375, 7, 99, 0, 'Tai''jin', 0, 44325),
+(591, 265.7650146484375, -4709.009765625, 17.48859977722167968, 7, 99, 0, 'Kaplak', 0, 44325),
+(592, 307.7969970703125, -4836.97021484375, 10.52400016784667968, 7, 99, 0, 'Swart', 0, 44325),
+(593, 312.308013916015625, -4824.66015625, 9.579600334167480468, 7, 99, 0, 'Tarshaw Jaggedscar', 0, 44325),
+(594, 355.8800048828125, -4836.4599609375, 10.9805002212524414, 7, 99, 0, 'Dhugru Gorelust', 0, 44325),
+(847, 330.31298828125, -4710.669921875, 14.63449954986572265, 7, 99, 0, 'Shoja''my', 0, 44325),
+(2709, 342.086822509765625, -4771.29150390625, 12.6344146728515625, 7, 99, 0, 'Jabul', 0, 44325),
+(3056, 329.02777099609375, -4762.330078125, 12.54999637603759765, 7, 99, 0, 'Runda', 0, 44325);
+
+DELETE FROM `points_of_interest_locale` WHERE `ID` IN (587, 588, 589, 590, 591, 592, 593, 594, 847, 2709, 3056);
+INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+( 587, 'deDE', 'Gasthaus von Klingenhügel', 44325),
+( 587, 'esES', 'Posada de Cerrotajo', 44325),
+( 587, 'esMX', 'Posada de Cerrotajo', 44325),
+( 587, 'frFR', 'Auberge de Tranchecolline', 44325),
+( 587, 'itIT', 'Locanda di Tranciacolle', 44325),
+( 587, 'koKR', '칼바위 언덕 여관', 44325),
+( 587, 'ptBR', 'Estalagem de Monte Navalha', 44325),
+( 587, 'ruRU', 'Таверна Колючего Холма', 44325),
+( 587, 'zhCN', '剃刀岭旅店', 44325),
+( 587, 'zhTW', '剃刀嶺旅店', 44325),
+( 588, 'deDE', 'Thotar', 44325),
+( 588, 'esES', 'Thotar', 44325),
+( 588, 'esMX', 'Thotar', 44325),
+( 588, 'frFR', 'Thotar', 44325),
+( 588, 'itIT', 'Thotar', 44325),
+( 588, 'koKR', '소타르', 44325),
+( 588, 'ptBR', 'Thotar', 44325),
+( 588, 'ruRU', 'Тотар', 44325),
+( 588, 'zhCN', '索塔尔', 44325),
+( 588, 'zhTW', '索塔爾', 44325),
+( 589, 'deDE', 'Un''Thuwa', 44325),
+( 589, 'esES', 'Un''Thuwa', 44325),
+( 589, 'esMX', 'Un''Thuwa', 44325),
+( 589, 'frFR', 'Un''Thuwa', 44325),
+( 589, 'itIT', 'Un''thuwa', 44325),
+( 589, 'koKR', '운투와', 44325),
+( 589, 'ptBR', 'Un''Thuwa', 44325),
+( 589, 'ruRU', 'Ун''Тува', 44325),
+( 589, 'zhCN', '安苏瓦', 44325),
+( 589, 'zhTW', '安蘇瓦', 44325),
+( 590, 'deDE', 'Tai''jin', 44325),
+( 590, 'esES', 'Tai''jin', 44325),
+( 590, 'esMX', 'Tai''jin', 44325),
+( 590, 'frFR', 'Tai''jin', 44325),
+( 590, 'itIT', 'Tai''jin', 44325),
+( 590, 'koKR', '타이진', 44325),
+( 590, 'ptBR', 'Tai''jin', 44325),
+( 590, 'ruRU', 'Тай''джин', 44325),
+( 590, 'zhCN', '泰金', 44325),
+( 590, 'zhTW', '泰金', 44325),
+( 591, 'deDE', 'Kaplak', 44325),
+( 591, 'esES', 'Kaplak', 44325),
+( 591, 'esMX', 'Kaplak', 44325),
+( 591, 'frFR', 'Kaplak', 44325),
+( 591, 'itIT', 'Kaplak', 44325),
+( 591, 'koKR', '카플라크', 44325),
+( 591, 'ptBR', 'Kaplak', 44325),
+( 591, 'ruRU', 'Каплак', 44325),
+( 591, 'zhCN', '卡普拉克', 44325),
+( 591, 'zhTW', '卡普拉克', 44325),
+( 592, 'deDE', 'Swart', 44325),
+( 592, 'esES', 'Swart', 44325),
+( 592, 'esMX', 'Swart', 44325),
+( 592, 'frFR', 'Swart', 44325),
+( 592, 'itIT', 'Swart', 44325),
+( 592, 'koKR', '스워트', 44325),
+( 592, 'ptBR', 'Swart', 44325),
+( 592, 'ruRU', 'Злобр', 44325),
+( 592, 'zhCN', '斯瓦特', 44325),
+( 592, 'zhTW', '斯瓦特', 44325),
+( 593, 'deDE', 'Tarshaw Raunarbe', 44325),
+( 593, 'esES', 'Tarshaw Marcauna', 44325),
+( 593, 'esMX', 'Tarshaw Marcauna', 44325),
+( 593, 'frFR', 'Tarshaw Salbalafre', 44325),
+( 593, 'itIT', 'Tarshaw Frangitaglio', 44325),
+( 593, 'koKR', '타쇼 재기드스카', 44325),
+( 593, 'ptBR', 'Tarshaw Zigatriz', 44325),
+( 593, 'ruRU', 'Таршо Рваный Шрам', 44325),
+( 593, 'zhCN', '塔绍尔·锯痕', 44325),
+( 593, 'zhTW', '塔紹爾‧鋸痕', 44325),
+( 594, 'deDE', 'Dhugru Blutgier', 44325),
+( 594, 'esES', 'Dhugru Ansiagore', 44325),
+( 594, 'esMX', 'Dhugru Ansiagore', 44325),
+( 594, 'frFR', 'Dhugru Soif-de-carnage', 44325),
+( 594, 'itIT', 'Dhugru Bramasangue', 44325),
+( 594, 'koKR', '두그루 고어러스트', 44325),
+( 594, 'ptBR', 'Dhugru Gostassangue', 44325),
+( 594, 'ruRU', 'Дхугру Кровожадный', 44325),
+( 594, 'zhCN', '杜格鲁·血怒', 44325),
+( 594, 'zhTW', '杜格魯‧血怒', 44325),
+( 847, 'deDE', 'Shoja''my', 44325),
+( 847, 'esES', 'Shoja''my', 44325),
+( 847, 'esMX', 'Shoja''my', 44325),
+( 847, 'frFR', 'Shoja''my', 44325),
+( 847, 'itIT', 'Shoja''my', 44325),
+( 847, 'koKR', '쇼자미', 44325),
+( 847, 'ptBR', 'Shoja''my', 44325),
+( 847, 'ruRU', 'Шоя''май', 44325),
+( 847, 'zhCN', '苏亚米', 44325),
+( 847, 'zhTW', '蘇亞米', 44325),
+(2709, 'deDE', 'Jabul', 44325),
+(2709, 'esES', 'Jabul', 44325),
+(2709, 'esMX', 'Jabul', 44325),
+(2709, 'frFR', 'Jabul', 44325),
+(2709, 'itIT', 'Jabul', 44325),
+(2709, 'koKR', '자불', 44325),
+(2709, 'ptBR', 'Jabul', 44325),
+(2709, 'ruRU', 'Жабул', 44325),
+(2709, 'zhCN', '贾布', 44325),
+(2709, 'zhTW', '賈布爾', 44325),
+(3056, 'deDE', 'Runda', 44325),
+(3056, 'esES', 'Runda', 44325),
+(3056, 'esMX', 'Runda', 44325),
+(3056, 'frFR', 'Runda', 44325),
+(3056, 'itIT', 'Runda', 44325),
+(3056, 'koKR', '룬다', 44325),
+(3056, 'ptBR', 'Runda', 44325),
+(3056, 'ruRU', 'Рунда', 44325),
+(3056, 'zhCN', '伦达', 44325),
+(3056, 'zhTW', '倫妲', 44325);