DB/Text/Gossip: Add more gossips and npc_text

1 files changed, 365 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_09_26_00_world.sql b/sql/updates/world/master/2018_09_26_00_world.sql
new file mode 100644
index 00000000000..3cdcfd3bd55
--- /dev/null
+++ b/sql/updates/world/master/2018_09_26_00_world.sql
@@ -0,0 +1,365 @@
+-- 
+DELETE FROM `gossip_menu` WHERE (`MenuId`=11379 AND `TextId`=15849) OR (`MenuId`=11552 AND `TextId`=16124) OR (`MenuId`=11551 AND `TextId`=16123) OR (`MenuId`=11380 AND `TextId`=15850) OR (`MenuId`=11401 AND `TextId`=15881) OR (`MenuId`=11356 AND `TextId`=15827) OR (`MenuId`=11319 AND `TextId`=15774) OR (`MenuId`=11306 AND `TextId`=15760) OR (`MenuId`=11328 AND `TextId`=15785) OR (`MenuId`=11316 AND `TextId`=15784) OR (`MenuId`=11325 AND `TextId`=15781) OR (`MenuId`=11324 AND `TextId`=15780) OR (`MenuId`=11322 AND `TextId`=15778) OR (`MenuId`=11316 AND `TextId`=15772) OR (`MenuId`=11550 AND `TextId`=16121) OR (`MenuId`=11321 AND `TextId`=15777) OR (`MenuId`=11320 AND `TextId`=15776) OR (`MenuId`=11494 AND `TextId`=16038) OR (`MenuId`=12168 AND `TextId`=17108) OR (`MenuId`=11496 AND `TextId`=16040) OR (`MenuId`=11888 AND `TextId`=16670) OR (`MenuId`=11546 AND `TextId`=16117) OR (`MenuId`=11454 AND `TextId`=15971) OR (`MenuId`=11464 AND `TextId`=15989) OR (`MenuId`=11463 AND `TextId`=15988) OR (`MenuId`=11462 AND `TextId`=15987) OR (`MenuId`=11461 AND `TextId`=15982) OR (`MenuId`=11470 AND `TextId`=15998) OR (`MenuId`=11549 AND `TextId`=16120) OR (`MenuId`=11548 AND `TextId`=16119) OR (`MenuId`=11547 AND `TextId`=16118) OR (`MenuId`=12597 AND `TextId`=17731) OR (`MenuId`=11495 AND `TextId`=16039) OR (`MenuId`=12167 AND `TextId`=17107) OR (`MenuId`=11280 AND `TextId`=15715) OR (`MenuId`=11530 AND `TextId`=16095) OR (`MenuId`=11447 AND `TextId`=15952) OR (`MenuId`=11297 AND `TextId`=15742) OR (`MenuId`=11292 AND `TextId`=15733) OR (`MenuId`=11289 AND `TextId`=15741) OR (`MenuId`=11289 AND `TextId`=15725) OR (`MenuId`=11296 AND `TextId`=15740) OR (`MenuId`=11281 AND `TextId`=15711) OR (`MenuId`=11543 AND `TextId`=16114) OR (`MenuId`=11542 AND `TextId`=16113) OR (`MenuId`=11282 AND `TextId`=15711) OR (`MenuId`=11279 AND `TextId`=15711) OR (`MenuId`=11280 AND `TextId`=15712) OR (`MenuId`=11541 AND `TextId`=16112) OR (`MenuId`=11226 AND `TextId`=15634) OR (`MenuId`=11226 AND `TextId`=15633) OR (`MenuId`=11451 AND `TextId`=15965) OR (`MenuId`=11493 AND `TextId`=16037) OR (`MenuId`=12613 AND `TextId`=17711) OR (`MenuId`=11441 AND `TextId`=15937) OR (`MenuId`=11440 AND `TextId`=15935) OR (`MenuId`=15066 AND `TextId`=21296) OR (`MenuId`=11437 AND `TextId`=15933) OR (`MenuId`=12711 AND `TextId`=17842) OR (`MenuId`=11756 AND `TextId`=16469) OR (`MenuId`=12223 AND `TextId`=17165) OR (`MenuId`=12222 AND `TextId`=17164) OR (`MenuId`=12221 AND `TextId`=17163) OR (`MenuId`=12220 AND `TextId`=17161) OR (`MenuId`=12219 AND `TextId`=17160) OR (`MenuId`=12218 AND `TextId`=17159) OR (`MenuId`=12217 AND `TextId`=17158) OR (`MenuId`=12216 AND `TextId`=17157) OR (`MenuId`=12215 AND `TextId`=17156) OR (`MenuId`=12214 AND `TextId`=17155) OR (`MenuId`=12267 AND `TextId`=17229) OR (`MenuId`=12212 AND `TextId`=17152) OR (`MenuId`=12210 AND `TextId`=17150) OR (`MenuId`=12211 AND `TextId`=17148) OR (`MenuId`=12283 AND `TextId`=17251) OR (`MenuId`=12213 AND `TextId`=17153) OR (`MenuId`=12224 AND `TextId`=17167) OR (`MenuId`=12269 AND `TextId`=17232) OR (`MenuId`=12311 AND `TextId`=17306) OR (`MenuId`=12561 AND `TextId`=17638) OR (`MenuId`=12640 AND `TextId`=17775) OR (`MenuId`=12578 AND `TextId`=17686) OR (`MenuId`=12145 AND `TextId`=17068) OR (`MenuId`=12396 AND `TextId`=17423) OR (`MenuId`=12408 AND `TextId`=17442) OR (`MenuId`=12411 AND `TextId`=17450) OR (`MenuId`=12363 AND `TextId`=17024) OR (`MenuId`=12388 AND `TextId`=17410) OR (`MenuId`=12170 AND `TextId`=17111) OR (`MenuId`=12390 AND `TextId`=17417) OR (`MenuId`=12169 AND `TextId`=17110) OR (`MenuId`=12037 AND `TextId`=16968) OR (`MenuId`=12058 AND `TextId`=16920) OR (`MenuId`=11967 AND `TextId`=16786) OR (`MenuId`=11929 AND `TextId`=16745) OR (`MenuId`=12356 AND `TextId`=17361) OR (`MenuId`=12357 AND `TextId`=17362) OR (`MenuId`=15068 AND `TextId`=21298) OR (`MenuId`=12361 AND `TextId`=17365) OR (`MenuId`=12360 AND `TextId`=17366) OR (`MenuId`=12239 AND `TextId`=17193) OR (`MenuId`=12359 AND `TextId`=17364) OR (`MenuId`=12358 AND `TextId`=17363) OR (`MenuId`=12174 AND `TextId`=17119) OR (`MenuId`=12123 AND `TextId`=17029) OR (`MenuId`=12763 AND `TextId`=17946) OR (`MenuId`=12883 AND `TextId`=18113) OR (`MenuId`=12985 AND `TextId`=18261) OR (`MenuId`=13002 AND `TextId`=18276) OR (`MenuId`=12799 AND `TextId`=17993) OR (`MenuId`=12902 AND `TextId`=18144) OR (`MenuId`=12976 AND `TextId`=18251) OR (`MenuId`=12975 AND `TextId`=18250) OR (`MenuId`=12974 AND `TextId`=18249) OR (`MenuId`=12791 AND `TextId`=17977) OR (`MenuId`=12790 AND `TextId`=17976) OR (`MenuId`=12899 AND `TextId`=18141) OR (`MenuId`=12970 AND `TextId`=18243) OR (`MenuId`=12900 AND `TextId`=18142) OR (`MenuId`=12822 AND `TextId`=18025) OR (`MenuId`=12983 AND `TextId`=18258) OR (`MenuId`=12914 AND `TextId`=18156) OR (`MenuId`=12911 AND `TextId`=18153) OR (`MenuId`=12990 AND `TextId`=18266) OR (`MenuId`=12988 AND `TextId`=18264) OR (`MenuId`=12989 AND `TextId`=18265) OR (`MenuId`=12986 AND `TextId`=18262) OR (`MenuId`=12987 AND `TextId`=18263) OR (`MenuId`=12991 AND `TextId`=18268) OR (`MenuId`=11434 AND `TextId`=15931) OR (`MenuId`=11443 AND `TextId`=15942) OR (`MenuId`=11382 AND `TextId`=15852) OR (`MenuId`=11420 AND `TextId`=15901) OR (`MenuId`=11216 AND `TextId`=15622) OR (`MenuId`=11401 AND `TextId`=16076) OR (`MenuId`=11528 AND `TextId`=16090) OR (`MenuId`=11524 AND `TextId`=16078) OR (`MenuId`=11526 AND `TextId`=16085) OR (`MenuId`=11533 AND `TextId`=16100) OR (`MenuId`=12829 AND `TextId`=18032) OR (`MenuId`=12911 AND `TextId`=18152) OR (`MenuId`=12828 AND `TextId`=18031) OR (`MenuId`=12827 AND `TextId`=18030) OR (`MenuId`=12826 AND `TextId`=18029) OR (`MenuId`=12762 AND `TextId`=17948) OR (`MenuId`=12922 AND `TextId`=18165) OR (`MenuId`=12965 AND `TextId`=18238) OR (`MenuId`=12967 AND `TextId`=18241) OR (`MenuId`=12912 AND `TextId`=18154) OR (`MenuId`=12923 AND `TextId`=18167) OR (`MenuId`=11432 AND `TextId`=15922) OR (`MenuId`=12911 AND `TextId`=18150) OR (`MenuId`=12984 AND `TextId`=18259) OR (`MenuId`=12973 AND `TextId`=18248) OR (`MenuId`=12972 AND `TextId`=18247) OR (`MenuId`=12969 AND `TextId`=18242) OR (`MenuId`=12916 AND `TextId`=18158) OR (`MenuId`=12913 AND `TextId`=18155);
+INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES
+(11379, 15849, 26972), -- 39858 (Archdruid Hamuul Runetotem)
+(11552, 16124, 26972), -- 39858 (Archdruid Hamuul Runetotem)
+(11551, 16123, 26972), -- 39858 (Archdruid Hamuul Runetotem)
+(11380, 15850, 26972), -- 40331 (Rayne Feathersong)
+(11401, 15881, 26972), -- 40341 (Tortolla)
+(11356, 15827, 26972), -- 39932 (Keeper Taldros)
+(11319, 15774, 26972), -- 39928 (Matoclaw)
+(11306, 15760, 26972), -- 39927 (Laina Nightsky)
+(11328, 15785, 26972), -- 40093 (Subjugated Inferno Lord)
+(11316, 15784, 26972), -- 39933 (Tyrus Blackhorn)
+(11325, 15781, 26972), -- 39933 (Tyrus Blackhorn)
+(11324, 15780, 26972), -- 39933 (Tyrus Blackhorn)
+(11322, 15778, 26972), -- 39933 (Tyrus Blackhorn)
+(11316, 15772, 26972), -- 39933 (Tyrus Blackhorn)
+(11550, 16121, 26972), -- 39928 (Matoclaw)
+(11321, 15777, 26972), -- 39928 (Matoclaw)
+(11320, 15776, 26972), -- 39928 (Matoclaw)
+(11494, 16038, 26972), -- 47002 (Vision of Ysera)
+(12168, 17108, 26972), -- 47002 (Vision of Ysera)
+(11496, 16040, 26972), -- 47002 (Vision of Ysera)
+(11888, 16670, 26972), -- 41308 (Aviana)
+(11546, 16117, 26972), -- 41005 (Choluna)
+(11454, 15971, 26972), -- 41006 (Thisalee Crow)
+(11464, 15989, 26972), -- 41112 (Marion Wormwing)
+(11463, 15988, 26972), -- 41112 (Marion Wormwing)
+(11462, 15987, 26972), -- 41112 (Marion Wormwing)
+(11461, 15982, 26972), -- 41112 (Marion Wormwing)
+(11470, 15998, 26972), -- 40997 (Skylord Omnuron)
+(11549, 16120, 26972), -- 41005 (Choluna)
+(11548, 16119, 26972), -- 41005 (Choluna)
+(11547, 16118, 26972), -- 41005 (Choluna)
+(12597, 17731, 26972), -- 41003 (Morthis Whisperwing)
+(11495, 16039, 26972), -- 46987 (Vision of Ysera)
+(12167, 17107, 26972), -- 46987 (Vision of Ysera)
+(11280, 15715, 26972), -- 39434 (Rio Duran)
+(11530, 16095, 26972), -- 39433 (Ian Duran)
+(11447, 15952, 26972), -- 40834 (Jordan Olafson)
+(11297, 15742, 26972), -- 39435 (Royce Duskwhisper)
+(11292, 15733, 26972), -- 39797 (Kristoff Manheim)
+(11289, 15741, 26972), -- 39640 (Kristoff Manheim)
+(11289, 15725, 26972), -- 39640 (Kristoff Manheim)
+(11296, 15740, 26972), -- 39640 (Kristoff Manheim)
+(11281, 15711, 26972), -- 39644 (Twilight Servitor)
+(11543, 16114, 26972), -- 39433 (Ian Duran)
+(11542, 16113, 26972), -- 39433 (Ian Duran)
+(11282, 15711, 26972), -- 39644 (Twilight Servitor)
+(11279, 15711, 26972), -- 39644 (Twilight Servitor)
+(11280, 15712, 26972), -- 39434 (Rio Duran)
+(11541, 16112, 26972), -- 39432 (Takrik Ragehowl)
+(11226, 15634, 26972), -- 39427 (Jadi Falaryn)
+(11226, 15633, 26972), -- 39427 (Jadi Falaryn)
+(11451, 15965, 26972), -- 40289 (Ysera)
+(11493, 16037, 26972), -- 40289 (Ysera)
+(12613, 17711, 26972), -- 40139 (Captain Saynna Stormrunner)
+(11441, 15937, 26972), -- 39869 (Windspeaker Tamila)
+(11440, 15935, 26972), -- 39857 (Malfurion Stormrage)
+(15066, 21296, 26899), -- Brok
+(11437, 15933, 26899), -- 40843 (Sebelia)
+(12711, 17842, 26899), -- 208184
+(11756, 16469, 25928), -- 204450
+(12223, 17165, 26972), -- 47189 (Aspiring Starlet)
+(12222, 17164, 26972), -- 47189 (Aspiring Starlet)
+(12221, 17163, 26972), -- 47189 (Aspiring Starlet)
+(12220, 17161, 26972), -- 47189 (Aspiring Starlet)
+(12219, 17160, 26972), -- 47187 (Budding Artist)
+(12218, 17159, 26972), -- 47187 (Budding Artist)
+(12217, 17158, 26972), -- 47187 (Budding Artist)
+(12216, 17157, 26972), -- 47185 (Refined Gentleman)
+(12215, 17156, 26972), -- 47185 (Refined Gentleman)
+(12214, 17155, 26972), -- 47185 (Refined Gentleman)
+(12267, 17229, 26972), -- 47461 (Prolific Writer)
+(12212, 17152, 26972), -- 47176 (Ambassador Laurent)
+(12210, 17150, 26972), -- 47176 (Ambassador Laurent)
+(12211, 17148, 26972), -- 47176 (Ambassador Laurent)
+(12283, 17251, 26972), -- 47514 (Pretentious Businessman)
+(12213, 17153, 26972), -- 47159 (Commander Schnottz)
+(12224, 17167, 26972), -- 47193 (Schnottz's Bodyguard)
+(12269, 17232, 26972), -- 47472 (Privileged Socialite)
+(12311, 17306, 26972), -- 47698 (Menacing Emissary)
+(12561, 17638, 26972), -- 50038 (Captain Hadan)
+(12640, 17775, 26972), -- 48564 (King Phaoris)
+(12578, 17686, 26972), -- 46750 (Fusion Core)
+(12145, 17068, 26972), -- 206293
+(12396, 17423, 26972), -- 46134 (High Commander Kamses)
+(12408, 17442, 26972), -- 48237 (Salhet)
+(12411, 17450, 26972), -- 46135 (High Priest Amet)
+(12363, 17024, 26972), -- 47959 (Prince Nadun)
+(12388, 17410, 26972), -- 48082 (Harrison Jones)
+(12170, 17111, 26972), -- 46978 (Harrison Jones)
+(12390, 17417, 26972), -- 45772 (General Ammantep)
+(12169, 17110, 26972), -- 47005 (Adarrah)
+(12037, 16968, 26972), -- 45296 (Harrison Jones)
+(12058, 16920, 26972), -- 45874 (Schnottz Scout)
+(11967, 16786, 26972), -- 45180 (Harrison Jones)
+(11929, 16745, 26972), -- 44860 (Harrison Jones)
+(12356, 17361, 26972), -- 46603 (Nomarch Teneth)
+(12357, 17362, 26972), -- 46603 (Nomarch Teneth)
+(15068, 21298, 26972), -- Obalis
+(12361, 17365, 26972), -- 47930 (Asaq)
+(12360, 17366, 26972), -- 47930 (Asaq)
+(12239, 17193, 26972), -- 47318 (Mack)
+(12359, 17364, 26972), -- 47715 (Sun Priest Asaris)
+(12358, 17363, 26972), -- 47715 (Sun Priest Asaris)
+(12174, 17119, 26972), -- 46872 (Prince Nadun)
+(12123, 17029, 26972), -- 46520 (Budd)
+(12763, 17946, 26972), -- 52408 (Coridormi)
+(12883, 18113, 26972), -- 53524 (Cyclonas)
+(12985, 18261, 26972), -- 54312 (Aggra)
+(13002, 18276, 26972), -- 52135 (Malfurion Stormrage)
+(12799, 17993, 26972), -- 52135 (Malfurion Stormrage)
+(12902, 18144, 26972), -- 52135 (Malfurion Stormrage)
+(12976, 18251, 26972), -- 52134 (Commander Jarod Shadowsong)
+(12975, 18250, 26972), -- 52134 (Commander Jarod Shadowsong)
+(12974, 18249, 26972), -- 52134 (Commander Jarod Shadowsong)
+(12791, 17977, 26972), -- 52467 (Rayne Feathersong)
+(12790, 17976, 26972), -- 52824 (General Taldris Moonfall)
+(12899, 18141, 26972), -- 53080 (Captain Irontree)
+(12970, 18243, 26972), -- 52825 (Theresa Barkskin)
+(12900, 18142, 26972), -- 52476 (Keeper Krothis)
+(12822, 18025, 26972), -- 52489 (Avrilla)
+(12983, 18258, 26972), -- 52824 (General Taldris Moonfall)
+(12914, 18156, 26972), -- 52986 (Dorda'en Nightweaver)
+(12911, 18153, 26972), -- 52669 (Matoclaw)
+(12990, 18266, 26972), -- 54314 (Alysra)
+(12988, 18264, 26972), -- 52798 (Kalecgos)
+(12989, 18265, 26972), -- 52799 (Alexstrasza)
+(12986, 18262, 26972), -- 52793 (Ysera)
+(12987, 18263, 26972), -- 52797 (Nozdormu)
+(12991, 18268, 26972), -- 54313 (Thrall)
+(11434, 15931, 26972), -- 41631 (Cenarius)
+(11443, 15942, 26972), -- 39413 (Instructor Mylva)
+(11382, 15852, 26972), -- 40409 (Gromm'ko)
+(11420, 15901, 26972), -- 40489 (Karr'gonn)
+(11216, 15622, 26972), -- 39442 (Condenna the Pitiless)
+(11401, 16076, 26972), -- 41504 (Tortolla)
+(11528, 16090, 26972), -- 41498 (Garunda Mountainpeak)
+(11524, 16078, 26972), -- 41499 (Lost Warden)
+(11526, 16085, 26972), -- 41492 (Captain Irontree)
+(11533, 16100, 26972), -- 41507 (Niden)
+(12829, 18032, 26972), -- 52845 (Malfurion Stormrage)
+(12911, 18152, 26972), -- 52669 (Matoclaw)
+(12828, 18031, 26972), -- 53014 (Leyara)
+(12827, 18030, 26972), -- 53014 (Leyara)
+(12826, 18029, 26972), -- 53014 (Leyara)
+(12762, 17948, 26972), -- 52425 (Tooga)
+(12922, 18165, 26972), -- 52898 (Avrilla)
+(12965, 18238, 26972), -- 52903 (Tholo Whitehoof)
+(12967, 18241, 26972), -- 52904 (Anren Shadowseeker)
+(12912, 18154, 26972), -- 52671 (Mylune)
+(12923, 18167, 26972), -- 52900 (Keeper Taldros)
+(11432, 15922, 26972), -- 40757 (Numa Skyclaw)
+(12911, 18150, 26972), -- 52669 (Matoclaw)
+(12984, 18259, 26972), -- 52669 (Matoclaw)
+(12973, 18248, 26972), -- 52669 (Matoclaw)
+(12972, 18247, 26972), -- 52669 (Matoclaw)
+(12969, 18242, 26972), -- 52901 (Morthis Whisperwing)
+(12916, 18158, 26972), -- 52897 (Choluna)
+(12913, 18155, 26972); -- 52899 (Rayne Feathersong)
+
+DELETE FROM `gossip_menu_option` WHERE (`MenuId`=12168 AND `OptionIndex`=3) OR (`MenuId`=12168 AND `OptionIndex`=1) OR (`MenuId`=12711 AND `OptionIndex`=0) OR (`MenuId`=9763 AND `OptionIndex`=0) OR (`MenuId`=12759 AND `OptionIndex`=0) OR (`MenuId`=12037 AND `OptionIndex`=0) OR (`MenuId`=11967 AND `OptionIndex`=0) OR (`MenuId`=12763 AND `OptionIndex`=1) OR (`MenuId`=12990 AND `OptionIndex`=0) OR (`MenuId`=10417 AND `OptionIndex`=1) OR (`MenuId`=9900 AND `OptionIndex`=1) OR (`MenuId`=10202 AND `OptionIndex`=0) OR (`MenuId`=9838 AND `OptionIndex`=1) OR (`MenuId`=9838 AND `OptionIndex`=0) OR (`MenuId`=10201 AND `OptionIndex`=0) OR (`MenuId`=9733 AND `OptionIndex`=0) OR (`MenuId`=9873 AND `OptionIndex`=9) OR (`MenuId`=8833 AND `OptionIndex`=0) OR (`MenuId`=8806 AND `OptionIndex`=0) OR (`MenuId`=9299 AND `OptionIndex`=0) OR (`MenuId`=9498 AND `OptionIndex`=0) OR (`MenuId`=9628 AND `OptionIndex`=0) OR (`MenuId`=9476 AND `OptionIndex`=0) OR (`MenuId`=9245 AND `OptionIndex`=0);
+INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `VerifiedBuild`) VALUES
+(12168, 3, 0, 'Is there something I can do at the Sanctuary of Malorne?', 41324, 26972),
+(12168, 1, 0, 'What is happening at the Grove of Aessina?', 41322, 26972),
+(12711, 0, 0, 'Honor the Earthen Ring bonfire!', 50762, 26899),
+(9763, 0, 5, 'Make this inn your home.', 2822, 26822),
+(12759, 0, 1, 'Show me what you have for sale.', 29959, 25881), -- OptionBroadcastTextID: 20225 - 20232 - 21280 - 21294 - 29959
+(12037, 0, 0, 'What can I do to help?', 58813, 26972), -- OptionBroadcastTextID: 45678 - 58813 - 83851
+(11967, 0, 0, 'I\'m ready, Doctor Jones!', 45392, 26972),
+(12763, 1, 0, 'I am ready to meet Nozdormu at the End Time.', 56606, 26972), -- OptionBroadcastTextID: 56606 - 56607
+(12990, 0, 0, 'You turned Fandral Staghelm over to the Twilight\'s Hammer. Why have you betrayed the dragonflights?', 52961, 26972),
+(10417, 1, 1, 'I want to browse your goods.', 3370, 26899),
+(9900, 1, 0, 'If it please you, King Jokkum, may I know what has become of Krolmir?', 30982, 26822),
+(10202, 0, 5, 'Make this inn your home.', 2822, 26822),
+(9838, 1, 7, 'How do I form a guild?', 3413, 26822),
+(9838, 0, 8, 'I want to create a guild crest.', 3415, 26822),
+(10201, 0, 5, 'Make this inn your home.', 2822, 26822),
+(9733, 0, 5, 'Make this inn your home.', 2822, 26822),
+(9873, 9, 1, 'May I browse your ancient gem recipes?', 36327, 26822),
+(8833, 0, 5, 'Make this inn your home.', 2822, 26755),
+(8806, 0, 5, 'Make this inn your home.', 2822, 26365),
+(9299, 0, 5, 'Make this inn your home.', 2822, 26822),
+(9498, 0, 5, 'Make this inn your home.', 2822, 26365),
+(9628, 0, 5, 'Make this inn your home.', 2822, 26365),
+(9476, 0, 5, 'Make this inn your home.', 2822, 26365),
+(9245, 0, 5, 'Make this inn your home.', 2822, 26365);
+
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=41699, `VerifiedBuild`=26972 WHERE (`MenuId`=11551 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=40019, `VerifiedBuild`=26972 WHERE (`MenuId`=11324 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=40015, `VerifiedBuild`=26972 WHERE (`MenuId`=11324 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=46530, `VerifiedBuild`=26899 WHERE (`MenuId`=12129 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='Let me browse your goods.', `VerifiedBuild`=26822 WHERE (`MenuId`=9763 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionText`='Wait, back up. What was that last thing you said?', `OptionBroadcastTextId`=24901 WHERE (`MenuId`=9182 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=47280, `VerifiedBuild`=26972 WHERE (`MenuId`=12222 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=47278, `VerifiedBuild`=26972 WHERE (`MenuId`=12221 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=47276, `VerifiedBuild`=26972 WHERE (`MenuId`=12220 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=47271, `VerifiedBuild`=26972 WHERE (`MenuId`=12218 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=47268, `VerifiedBuild`=26972 WHERE (`MenuId`=12217 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=47260, `VerifiedBuild`=26972 WHERE (`MenuId`=12215 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=47258, `VerifiedBuild`=26972 WHERE (`MenuId`=12214 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=47243, `VerifiedBuild`=26972 WHERE (`MenuId`=12210 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=47237, `VerifiedBuild`=26972 WHERE (`MenuId`=12211 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=50035, `VerifiedBuild`=26972 WHERE (`MenuId`=12578 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=46515, `VerifiedBuild`=26972 WHERE (`MenuId`=12121 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=48441, `VerifiedBuild`=26972 WHERE (`MenuId`=12408 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=46107, `VerifiedBuild`=26972 WHERE (`MenuId`=12058 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=45915, `VerifiedBuild`=26972 WHERE (`MenuId`=12058 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=48144, `VerifiedBuild`=26972 WHERE (`MenuId`=12356 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=48150, `VerifiedBuild`=26972 WHERE (`MenuId`=12361 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=48147, `VerifiedBuild`=26972 WHERE (`MenuId`=12358 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=52127, `VerifiedBuild`=26972 WHERE (`MenuId`=12883 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=52999, `VerifiedBuild`=26972 WHERE (`MenuId`=12799 AND `OptionIndex`=4);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=52357, `VerifiedBuild`=26972 WHERE (`MenuId`=12799 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=52936, `VerifiedBuild`=26972 WHERE (`MenuId`=12975 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=52935, `VerifiedBuild`=26972 WHERE (`MenuId`=12974 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=52950, `VerifiedBuild`=26972 WHERE (`MenuId`=12790 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=52373, `VerifiedBuild`=26972 WHERE (`MenuId`=12914 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=52955, `VerifiedBuild`=26972 WHERE (`MenuId`=12985 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`='Tauren archdruid? Do you mean Hamuul?', `OptionBroadcastTextId`=51768, `VerifiedBuild`=26972 WHERE (`MenuId`=12828 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=51765, `VerifiedBuild`=26972 WHERE (`MenuId`=12827 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=51763, `VerifiedBuild`=26972 WHERE (`MenuId`=12826 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`='I wish to return to Archdruid Lilliandra. Can you send me back to her?', `VerifiedBuild`=26899 WHERE (`MenuId`=10215 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionText`='It\'s a pleasure to meet you as well, Archdruid. I am on a task from Tirion and time is short. Might I trouble you for a portal to Moonglade?', `VerifiedBuild`=26899 WHERE (`MenuId`=9991 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`='I am ready to be shown the fate of Krolmir.', `VerifiedBuild`=26822 WHERE (`MenuId`=9899 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`='I\'ll go get some help. Hang in there.', `VerifiedBuild`=26822 WHERE (`MenuId`=9843 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`='I\'m sorry that I didn\'t get here sooner. What happened?', `VerifiedBuild`=26822 WHERE (`MenuId`=9842 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`='Are you okay? I\'ve come to take you back to Frosthold if you can stand.', `VerifiedBuild`=26822 WHERE (`MenuId`=9841 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`='I\'m ready - lets get you out of here.', `VerifiedBuild`=26822 WHERE (`MenuId`=9859 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='Let me browse your goods.', `VerifiedBuild`=26822 WHERE (`MenuId`=10202 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='Let me browse your goods.', `VerifiedBuild`=26822 WHERE (`MenuId`=10201 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='Let me browse your goods.', `VerifiedBuild`=26822 WHERE (`MenuId`=9733 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionText`='Justice Quartermasters', `OptionBroadcastTextId`=32704, `VerifiedBuild`=26822 WHERE (`MenuId`=10173 AND `OptionIndex`=6);
+UPDATE `gossip_menu_option` SET `OptionText`='Jewelry', `OptionBroadcastTextId`=32713, `VerifiedBuild`=26822 WHERE (`MenuId`=10173 AND `OptionIndex`=5);
+UPDATE `gossip_menu_option` SET `OptionText`='General Goods', `VerifiedBuild`=26822 WHERE (`MenuId`=10173 AND `OptionIndex`=4);
+UPDATE `gossip_menu_option` SET `OptionText`='Fruit', `OptionBroadcastTextId`=32706, `VerifiedBuild`=26822 WHERE (`MenuId`=10173 AND `OptionIndex`=3);
+UPDATE `gossip_menu_option` SET `OptionText`='Flowers', `OptionBroadcastTextId`=32705, `VerifiedBuild`=26822 WHERE (`MenuId`=10173 AND `OptionIndex`=2);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32134, `VerifiedBuild`=26822 WHERE (`MenuId`=10073 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32133, `VerifiedBuild`=26822 WHERE (`MenuId`=10073 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32153, `VerifiedBuild`=26822 WHERE (`MenuId`=10082 AND `OptionIndex`=4);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32154, `VerifiedBuild`=26822 WHERE (`MenuId`=10082 AND `OptionIndex`=3);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32176, `VerifiedBuild`=26822 WHERE (`MenuId`=10043 AND `OptionIndex`=12);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=32180, `VerifiedBuild`=26822 WHERE (`MenuId`=10043 AND `OptionIndex`=10);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=33141, `VerifiedBuild`=26822 WHERE (`MenuId`=10043 AND `OptionIndex`=8);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='What do you have to eat, Celeste?', `OptionBroadcastTextId`=22465, `VerifiedBuild`=26755 WHERE (`MenuId`=8833 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='I wish to browse your wares, Hazel.', `OptionBroadcastTextId`=22305, `VerifiedBuild`=26365 WHERE (`MenuId`=8806 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='I wish to buy from you.', `VerifiedBuild`=26822 WHERE (`MenuId`=9299 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionText`='Greer, I need a gryphon to ride and some bombs to drop on New Agamand!', `OptionBroadcastTextId`=23112, `VerifiedBuild`=26822 WHERE (`MenuId`=9546 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2822, `VerifiedBuild`=26822 WHERE (`MenuId`=9478 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionText`='Orik, I need another murkweed elixir.', `VerifiedBuild`=26365 WHERE (`MenuId`=9542 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='I would like to browse your goods, Illusia.', `OptionBroadcastTextId`=26387, `VerifiedBuild`=26365 WHERE (`MenuId`=9498 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='Let me browse your goods.', `VerifiedBuild`=26365 WHERE (`MenuId`=9628 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='I want to browse your goods.', `OptionBroadcastTextId`=3370, `VerifiedBuild`=26365 WHERE (`MenuId`=9476 AND `OptionIndex`=1);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2822, `VerifiedBuild`=26365 WHERE (`MenuId`=9478 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=2822, `VerifiedBuild`=26365 WHERE (`MenuId`=9427 AND `OptionIndex`=0);
+UPDATE `gossip_menu_option` SET `OptionIcon`=1, `OptionText`='Let me browse your goods.', `VerifiedBuild`=26365 WHERE (`MenuId`=9245 AND `OptionIndex`=1);
+
+DELETE FROM `gossip_menu_option_action` WHERE (`MenuId`=11551 AND `OptionIndex`=0) OR (`MenuId`=11379 AND `OptionIndex`=0) OR (`MenuId`=11324 AND `OptionIndex`=0) OR (`MenuId`=11322 AND `OptionIndex`=0) OR (`MenuId`=11316 AND `OptionIndex`=0) OR (`MenuId`=11326 AND `OptionIndex`=0) OR (`MenuId`=11322 AND `OptionIndex`=2) OR (`MenuId`=11324 AND `OptionIndex`=1) OR (`MenuId`=11322 AND `OptionIndex`=1) OR (`MenuId`=11319 AND `OptionIndex`=1) OR (`MenuId`=11320 AND `OptionIndex`=0) OR (`MenuId`=11319 AND `OptionIndex`=0) OR (`MenuId`=12168 AND `OptionIndex`=1) OR (`MenuId`=12168 AND `OptionIndex`=3) OR (`MenuId`=11494 AND `OptionIndex`=2) OR (`MenuId`=11496 AND `OptionIndex`=1) OR (`MenuId`=11463 AND `OptionIndex`=0) OR (`MenuId`=11462 AND `OptionIndex`=0) OR (`MenuId`=11461 AND `OptionIndex`=1) OR (`MenuId`=11461 AND `OptionIndex`=0) OR (`MenuId`=11548 AND `OptionIndex`=0) OR (`MenuId`=11547 AND `OptionIndex`=0) OR (`MenuId`=11546 AND `OptionIndex`=0) OR (`MenuId`=11495 AND `OptionIndex`=2) OR (`MenuId`=11496 AND `OptionIndex`=2) OR (`MenuId`=11494 AND `OptionIndex`=1) OR (`MenuId`=11495 AND `OptionIndex`=1) OR (`MenuId`=12167 AND `OptionIndex`=1) OR (`MenuId`=11289 AND `OptionIndex`=2) OR (`MenuId`=11542 AND `OptionIndex`=0) OR (`MenuId`=11530 AND `OptionIndex`=0) OR (`MenuId`=11493 AND `OptionIndex`=2) OR (`MenuId`=11496 AND `OptionIndex`=0) OR (`MenuId`=11494 AND `OptionIndex`=0) OR (`MenuId`=11493 AND `OptionIndex`=1) OR (`MenuId`=11493 AND `OptionIndex`=0) OR (`MenuId`=11451 AND `OptionIndex`=0) OR (`MenuId`=11451 AND `OptionIndex`=3) OR (`MenuId`=11451 AND `OptionIndex`=2) OR (`MenuId`=11451 AND `OptionIndex`=1) OR (`MenuId`=12222 AND `OptionIndex`=0) OR (`MenuId`=12221 AND `OptionIndex`=0) OR (`MenuId`=12220 AND `OptionIndex`=0) OR (`MenuId`=12218 AND `OptionIndex`=0) OR (`MenuId`=12217 AND `OptionIndex`=0) OR (`MenuId`=12215 AND `OptionIndex`=0) OR (`MenuId`=12214 AND `OptionIndex`=0) OR (`MenuId`=12210 AND `OptionIndex`=0) OR (`MenuId`=12211 AND `OptionIndex`=0) OR (`MenuId`=12356 AND `OptionIndex`=0) OR (`MenuId`=12361 AND `OptionIndex`=0) OR (`MenuId`=12358 AND `OptionIndex`=0) OR (`MenuId`=12799 AND `OptionIndex`=4) OR (`MenuId`=12799 AND `OptionIndex`=0) OR (`MenuId`=12975 AND `OptionIndex`=0) OR (`MenuId`=12974 AND `OptionIndex`=0) OR (`MenuId`=12790 AND `OptionIndex`=0) OR (`MenuId`=12827 AND `OptionIndex`=0) OR (`MenuId`=12826 AND `OptionIndex`=0) OR (`MenuId`=12973 AND `OptionIndex`=0) OR (`MenuId`=12972 AND `OptionIndex`=0) OR (`MenuId`=12911 AND `OptionIndex`=0) OR (`MenuId`=9900 AND `OptionIndex`=1) OR (`MenuId`=9182 AND `OptionIndex`=0);
+INSERT INTO `gossip_menu_option_action` (`MenuId`, `OptionIndex`, `ActionMenuId`, `ActionPoiId`) VALUES
+(11551, 0, 11552, 0),
+(11379, 0, 11551, 0),
+(11324, 0, 11325, 0),
+(11322, 0, 11324, 0),
+(11316, 0, 11322, 0),
+(11322, 2, 11326, 0),
+(11324, 1, 11326, 0),
+(11322, 1, 11325, 0),
+(11319, 1, 11550, 0),
+(11320, 0, 11321, 0),
+(11319, 0, 11320, 0),
+(12168, 1, 11494, 0),
+(12168, 3, 11496, 0),
+(11494, 2, 11496, 0),
+(11496, 1, 11494, 0),
+(11463, 0, 11464, 0),
+(11462, 0, 11463, 0),
+(11461, 1, 11462, 0),
+(11461, 0, 11461, 0),
+(11548, 0, 11549, 0),
+(11547, 0, 11548, 0),
+(11546, 0, 11547, 0),
+(11495, 2, 11496, 0),
+(11496, 2, 11495, 0),
+(11494, 1, 11495, 0),
+(11495, 1, 11494, 0),
+(12167, 1, 11494, 0),
+(11289, 2, 11296, 0),
+(11542, 0, 11543, 0),
+(11530, 0, 11542, 0),
+(11493, 2, 11496, 0),
+(11496, 0, 11493, 0),
+(11494, 0, 11493, 0),
+(11493, 1, 11495, 0),
+(11493, 0, 11494, 0),
+(11451, 0, 11493, 0),
+(11451, 3, 11496, 0),
+(11451, 2, 11495, 0),
+(11451, 1, 11494, 0),
+(12222, 0, 12223, 0),
+(12221, 0, 12222, 0),
+(12220, 0, 12221, 0),
+(12218, 0, 12219, 0),
+(12217, 0, 12218, 0),
+(12215, 0, 12216, 0),
+(12214, 0, 12215, 0),
+(12210, 0, 12212, 0),
+(12211, 0, 12210, 0),
+(12356, 0, 12357, 0),
+(12361, 0, 12360, 0),
+(12358, 0, 12359, 0),
+(12799, 4, 13002, 0),
+(12799, 0, 12902, 0),
+(12975, 0, 12976, 0),
+(12974, 0, 12975, 0),
+(12790, 0, 12983, 0),
+(12827, 0, 12828, 0),
+(12826, 0, 12827, 0),
+(12973, 0, 12984, 0),
+(12972, 0, 12973, 0),
+(12911, 0, 12972, 0),
+(9900, 1, 9899, 0),
+(9182, 0, 9181, 0);
+
+DELETE FROM `gossip_menu_option_trainer` WHERE (`MenuId`=8519 AND `OptionIndex`=0);
+INSERT INTO `gossip_menu_option_trainer` (`MenuId`, `OptionIndex`, `TrainerId`) VALUES
+(8519, 0, 163);
+
+DELETE FROM `npc_text` WHERE `ID` IN (28951 /*28951*/, 27472 /*27472*/, 12568 /*12568*/, 18049 /*18049*/, 18144 /*18144*/, 18266 /*18266*/, 18263 /*18263*/, 18262 /*18262*/, 18265 /*18265*/, 18264 /*18264*/, 18031 /*18031*/, 18030 /*18030*/, 18029 /*18029*/, 17948 /*17948*/, 18241 /*18241*/, 18242 /*18242*/, 18165 /*18165*/, 18158 /*18158*/, 18155 /*18155*/, 27081 /*27081*/, 13944 /*13944*/, 26320 /*26320*/, 31474 /*31474*/);
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(28951, 1, 0, 0, 0, 0, 0, 0, 0, 109365, 0, 0, 0, 0, 0, 0, 0, 26899), -- 28951
+(27472, 1, 0, 0, 0, 0, 0, 0, 0, 100025, 0, 0, 0, 0, 0, 0, 0, 26822), -- 27472
+(12568, 1, 0, 0, 0, 0, 0, 0, 0, 25370, 0, 0, 0, 0, 0, 0, 0, 26365), -- 12568
+(18049, 1, 0, 0, 0, 0, 0, 0, 0, 51905, 0, 0, 0, 0, 0, 0, 0, 25996), -- 18049
+(18144, 1, 0, 0, 0, 0, 0, 0, 0, 52359, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18144
+(18266, 1, 0, 0, 0, 0, 0, 0, 0, 52960, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18266
+(18263, 1, 0, 0, 0, 0, 0, 0, 0, 52957, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18263
+(18262, 1, 0, 0, 0, 0, 0, 0, 0, 52956, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18262
+(18265, 1, 0, 0, 0, 0, 0, 0, 0, 52959, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18265
+(18264, 1, 0, 0, 0, 0, 0, 0, 0, 52958, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18264
+(18031, 1, 0, 0, 0, 0, 0, 0, 0, 51767, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18031
+(18030, 1, 0, 0, 0, 0, 0, 0, 0, 51764, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18030
+(18029, 1, 0, 0, 0, 0, 0, 0, 0, 51762, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18029
+(17948, 1, 1, 1, 1, 0, 0, 0, 0, 51254, 51255, 51256, 51257, 0, 0, 0, 0, 26972), -- 17948
+(18241, 1, 0, 0, 0, 0, 0, 0, 0, 52894, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18241
+(18242, 1, 0, 0, 0, 0, 0, 0, 0, 52912, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18242
+(18165, 1, 1, 2, 1, 0, 0, 0, 0, 51731, 52342, 52400, 52401, 0, 0, 0, 0, 26972), -- 18165
+(18158, 1, 0, 0, 0, 0, 0, 0, 0, 52376, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18158
+(18155, 1, 0, 0, 0, 0, 0, 0, 0, 52371, 0, 0, 0, 0, 0, 0, 0, 26972), -- 18155
+(27081, 1, 0, 0, 0, 0, 0, 0, 0, 97413, 0, 0, 0, 0, 0, 0, 0, 26899), -- 27081
+(13944, 1, 0, 0, 0, 0, 0, 0, 0, 32011, 0, 0, 0, 0, 0, 0, 0, 26822), -- 13944
+(26320, 1, 0, 0, 0, 0, 0, 0, 0, 93742, 0, 0, 0, 0, 0, 0, 0, 26822), -- 26320
+(31474, 1, 0, 0, 0, 0, 0, 0, 0, 129051, 0, 0, 0, 0, 0, 0, 0, 26365); -- 31474
+
+UPDATE `npc_text` SET `BroadcastTextId0`=50088, `VerifiedBuild`=26972 WHERE `ID`=17711; -- 17711
+UPDATE `npc_text` SET `BroadcastTextId3`=28710, `VerifiedBuild`=26822 WHERE `ID`=13326; -- 13326
+UPDATE `npc_text` SET `BroadcastTextId0`=52055, `VerifiedBuild`=25996 WHERE `ID`=18092; -- 18092
+UPDATE `npc_text` SET `BroadcastTextId0`=46526, `VerifiedBuild`=26972 WHERE `ID`=17029; -- 17029
+UPDATE `npc_text` SET `BroadcastTextId0`=31742, `VerifiedBuild`=26822 WHERE `ID`=13918; -- 13918
+UPDATE `npc_text` SET `BroadcastTextId0`=31370, `VerifiedBuild`=26822 WHERE `ID`=13845; -- 13845
+UPDATE `npc_text` SET `BroadcastTextId0`=23850, `VerifiedBuild`=26755 WHERE `ID`=12185; -- 12185
+UPDATE `npc_text` SET `BroadcastTextId0`=53140, `VerifiedBuild`=26365 WHERE `ID`=18320; -- 18320
+UPDATE `npc_text` SET `BroadcastTextId3`=25647, `VerifiedBuild`=26822 WHERE `ID`=12617; -- 12617
+UPDATE `npc_text` SET `BroadcastTextId0`=23157, `VerifiedBuild`=26822 WHERE `ID`=11912; -- 11912
+UPDATE `npc_text` SET `BroadcastTextId0`=53142, `VerifiedBuild`=26365 WHERE `ID`=18321; -- 18321