DB/Creature: Fixed gossip menus for Kharanos guards

Ref #17414

1 files changed, 146 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_29_03_world_kharanos.sql b/sql/updates/world/master/2022_07_29_03_world_kharanos.sql
new file mode 100644
index 00000000000..a3d637b8f84
--- /dev/null
+++ b/sql/updates/world/master/2022_07_29_03_world_kharanos.sql
@@ -0,0 +1,146 @@
+-- Ironforge Mountaineer | Mounted Ironforge Mountaineer (Kharanos)
+UPDATE `creature_template` SET `gossip_menu_id`=3533, `minlevel`=30, `maxlevel`=30 WHERE `entry` IN (727, 12996);
+
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3426 WHERE `MenuID`=3533 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=5081 WHERE `MenuID`=3533 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=5090, `ActionPoiID`=671 WHERE `MenuID`=3533 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=8508, `ActionPoiID`=868 WHERE `MenuID`=3533 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3429 WHERE `MenuID`=3533 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3430, `ActionPoiID`=3054 WHERE `MenuID`=3533 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2924, `ActionPoiID`=674 WHERE `MenuID`=3545 AND `OptionID`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2902, `ActionPoiID`=664 WHERE `MenuID`=3545 AND `OptionID`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2922, `ActionPoiID`=665 WHERE `MenuID`=3545 AND `OptionID`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2918, `ActionPoiID`=666 WHERE `MenuID`=3545 AND `OptionID`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2906, `ActionPoiID`=669 WHERE `MenuID`=3545 AND `OptionID`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=3450, `ActionPoiID`=2553 WHERE `MenuID`=3545 AND `OptionID`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2926, `ActionPoiID`=677 WHERE `MenuID`=3545 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2910, `ActionPoiID`=667 WHERE `MenuID`=3545 AND `OptionID`=7;
+UPDATE `gossip_menu_option` SET `VerifiedBuild`=44325 WHERE `MenuID` IN (3533, 3545);
+
+DELETE FROM `points_of_interest` WHERE `ID` IN (10076, 10077, 10078, 10079, 10080, 10081, 10082, 10083, 10084, 10580, 10581);
+DELETE FROM `points_of_interest` WHERE `ID` IN (664, 665, 666, 667, 669, 671, 674, 677, 868, 2553, 3054);
+INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `PositionZ`, `Icon`, `Flags`, `Importance`, `Name`, `Unknown905`, `VerifiedBuild`) VALUES
+(664, -5587.3701171875, -539.0369873046875, 403.540008544921875, 7, 99, 0, 'Magis Sparkmantle', 0, 44325),
+(665, -5584.68994140625, -542.49200439453125, 403.540985107421875, 7, 99, 0, 'Azar Stronghammer', 0, 44325),
+(666, -5589.18994140625, -530.28802490234375, 399.652008056640625, 7, 99, 0, 'Maxan Anvol', 0, 44325),
+(667, -5605.009765625, -530.14501953125, 399.656005859375, 7, 99, 0, 'Granis Swiftaxe', 0, 44325),
+(669, -5604.47998046875, -540.0889892578125, 399.09600830078125, 7, 99, 0, 'Hogral Bakkan', 0, 44325),
+(671, -5584.10986328125, -510.86199951171875, 404.373992919921875, 7, 99, 0, 'Thunderbrew Distillery', 0, 44325),
+(674, -5618.72998046875, -453.720001220703125, 407.61199951171875, 7, 99, 0, 'Grif Wildheart', 0, 44325),
+(677, -5639.5, -528.5009765625, 404.238006591796875, 7, 99, 0, 'Gimrizz Shadowcog', 0, 44325),
+(868, -5606.169921875, -513.00799560546875, 402.204986572265625, 7, 99, 0, 'Shelby Stoneflint', 0, 44325),
+(2553, -5581.78662109375, -535.55902099609375, 403.54107666015625, 7, 99, 0, 'Halbin Frosthammer', 0, 44325),
+(3054, -5637.16845703125, -497.8038330078125, 396.6693115234375, 7, 99, 0, 'Wembil Taskwidget', 0, 44325);
+
+DELETE FROM `points_of_interest_locale` WHERE `ID` IN (664, 665, 666, 667, 669, 671, 674, 677, 868, 2553, 3054);
+INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`, `VerifiedBuild`) VALUES
+( 664, 'deDE', 'Magis Funkelmantel', 44325),
+( 664, 'esES', 'Magis Chispamanto', 44325),
+( 664, 'esMX', 'Magis Chispamanto', 44325),
+( 664, 'frFR', 'Magis Mantincelle', 44325),
+( 664, 'itIT', 'Magis Frizzamanto', 44325),
+( 664, 'koKR', '마지스 스파크맨틀', 44325),
+( 664, 'ptBR', 'Magis Fagulhamanto', 44325),
+( 664, 'ruRU', 'Магис Искроплащ', 44325),
+( 664, 'zhCN', '玛济斯·石衣', 44325),
+( 664, 'zhTW', '瑪濟斯‧石衣', 44325),
+( 665, 'deDE', 'Azar Hammerkraft', 44325),
+( 665, 'esES', 'Azar Martillopujante', 44325),
+( 665, 'esMX', 'Azar Martillopujante', 44325),
+( 665, 'frFR', 'Azar Fortmartel', 44325),
+( 665, 'itIT', 'Azar Martelduro', 44325),
+( 665, 'koKR', '아자르 스트롱해머', 44325),
+( 665, 'ptBR', 'Avar Marroforte', 44325),
+( 665, 'ruRU', 'Азар Мощный Молот', 44325),
+( 665, 'zhCN', '阿扎尔·战锤', 44325),
+( 665, 'zhTW', '阿札爾‧戰錘', 44325),
+( 666, 'deDE', 'Maxan Anvol', 44325),
+( 666, 'esES', 'Maxan Anvol', 44325),
+( 666, 'esMX', 'Maxan Anvol', 44325),
+( 666, 'frFR', 'Maxan Anvol', 44325),
+( 666, 'itIT', 'Maxan Anvol', 44325),
+( 666, 'koKR', '막산 앤볼', 44325),
+( 666, 'ptBR', 'Maxan Begurno', 44325),
+( 666, 'ruRU', 'Максан Анвол', 44325),
+( 666, 'zhCN', '马克萨恩·安沃尔', 44325),
+( 666, 'zhTW', '馬克薩恩‧安沃爾', 44325),
+( 667, 'deDE', 'Granis Flinkaxt', 44325),
+( 667, 'esES', 'Granis Hachaveloz', 44325),
+( 667, 'esMX', 'Granis Hachaveloz', 44325),
+( 667, 'frFR', 'Granis Vivehache', 44325),
+( 667, 'itIT', 'Granis Ascialesta', 44325),
+( 667, 'koKR', '그라니스 스위프트액스', 44325),
+( 667, 'ptBR', 'Granis Celeraxa', 44325),
+( 667, 'ruRU', 'Гранис Свист Топора', 44325),
+( 667, 'zhCN', '格兰尼斯·快斧', 44325),
+( 667, 'zhTW', '格蘭尼斯‧快斧', 44325),
+( 669, 'deDE', 'Hogral Bakkan', 44325),
+( 669, 'esES', 'Hogral Bakkan', 44325),
+( 669, 'esMX', 'Hogral Bakkan', 44325),
+( 669, 'frFR', 'Hogral Bakkan', 44325),
+( 669, 'itIT', 'Hogral Bakkan', 44325),
+( 669, 'koKR', '호그럴 바칸', 44325),
+( 669, 'ptBR', 'Hogral Bakkan', 44325),
+( 669, 'ruRU', 'Хограл Баккан', 44325),
+( 669, 'zhCN', '霍格拉尔·巴坎', 44325),
+( 669, 'zhTW', '霍格拉爾‧巴坎', 44325),
+( 671, 'deDE', 'Brauerei Donnerbräu', 44325),
+( 671, 'esES', 'Destilería Cebatruenos', 44325),
+( 671, 'esMX', 'Destilería Cebatruenos', 44325),
+( 671, 'frFR', 'Distillerie Tonnebière', 44325),
+( 671, 'itIT', 'Distilleria Birratuono', 44325),
+( 671, 'koKR', '썬더브루 양조장', 44325),
+( 671, 'ptBR', 'Destilaria Cervaforte', 44325),
+( 671, 'ruRU', 'Таверна "Громоварка"', 44325),
+( 671, 'zhCN', '雷酒酿制厂', 44325),
+( 671, 'zhTW', '雷酒釀酒廠', 44325),
+( 674, 'deDE', 'Grif Wildherz', 44325),
+( 674, 'esES', 'Grif Corazón Salvaje', 44325),
+( 674, 'esMX', 'Grif Corazón Salvaje', 44325),
+( 674, 'frFR', 'Grif Cœur-Sauvage', 44325),
+( 674, 'itIT', 'Grif Cuoreselvaggio', 44325),
+( 674, 'koKR', '그리프 와일드하트', 44325),
+( 674, 'ptBR', 'Grif Selvacuore', 44325),
+( 674, 'ruRU', 'Гриф Дикое Сердце', 44325),
+( 674, 'zhCN', '格瑞夫', 44325),
+( 674, 'zhTW', '格瑞夫', 44325),
+( 677, 'deDE', 'Gimrizz Schattenrad', 44325),
+( 677, 'esES', 'Gimrizz Molaro', 44325),
+( 677, 'esMX', 'Gimrizz Molaro', 44325),
+( 677, 'frFR', 'Gimrizz Sombrouage', 44325),
+( 677, 'itIT', 'Gimrizz Vitenera', 44325),
+( 677, 'koKR', '김리즈 섀도코그', 44325),
+( 677, 'ptBR', 'Gimrizz Umbrenagem', 44325),
+( 677, 'ruRU', 'Гимризз Сглазверг', 44325),
+( 677, 'zhCN', '吉姆瑞兹·黑轮', 44325),
+( 677, 'zhTW', '吉姆瑞茲‧影輪', 44325),
+( 868, 'deDE', 'Shelby Steinsplint', 44325),
+( 868, 'esES', 'Shelby Petrepiedra', 44325),
+( 868, 'esMX', 'Shelby Petrepiedra', 44325),
+( 868, 'frFR', 'Shelby Pierre-à-feu', 44325),
+( 868, 'itIT', 'Shelby Selcepietra', 44325),
+( 868, 'koKR', '셸비 스톤플린트', 44325),
+( 868, 'ptBR', 'Shelby Pedrerneira', 44325),
+( 868, 'ruRU', 'Шелби Щебенка', 44325),
+( 868, 'zhCN', '谢尔比·石火', 44325),
+( 868, 'zhTW', '謝爾比‧石火', 44325),
+(2553, 'deDE', 'Halbin Frosthammer', 44325),
+(2553, 'esES', 'Halbin Martilloescarcha', 44325),
+(2553, 'esMX', 'Halbin Martilloescarcha', 44325),
+(2553, 'frFR', 'Halbin Martel-de-Givre', 44325),
+(2553, 'itIT', 'Halbin Gelmartello', 44325),
+(2553, 'koKR', '할빈 프로스트해머', 44325),
+(2553, 'ptBR', 'Halbin Marrãogélido', 44325),
+(2553, 'ruRU', 'Халбин Молот Стужи', 44325),
+(2553, 'zhCN', '哈鲁宾·霜锤', 44325),
+(2553, 'zhTW', '赫爾賓‧霜錘', 44325),
+(3054, 'deDE', 'Willman Wendematz', 44325),
+(3054, 'esES', 'Wembil Trastarea', 44325),
+(3054, 'esMX', 'Wembil Trastarea', 44325),
+(3054, 'frFR', 'Wembil Marcherouage', 44325),
+(3054, 'itIT', 'Wembil Granlavoro', 44325),
+(3054, 'koKR', '웸빌 태스크위젯', 44325),
+(3054, 'ptBR', 'Pepe Tralhatreco', 44325),
+(3054, 'ruRU', 'Вембил Озаданч', 44325),
+(3054, 'zhCN', '温比尔·任务栏', 44325),
+(3054, 'zhTW', '溫比爾‧工械', 44325);