diff options
author | funjoker <funjoker@users.noreply.github.com> | 2018-10-17 19:53:19 +0200 |
---|---|---|
committer | Killyana <morphone1@gmail.com> | 2018-10-17 19:53:19 +0200 |
commit | 31a2a394c72121989bb82d06308ec75ae5c4e267 (patch) | |
tree | ba8b707d03a1f403021c0f5377d032db4850689a /sql | |
parent | 27510aa299112233c1018e80132cc44a16828c8d (diff) |
DB: Update gossip_menu, gossip_menu_option and gossip_menu_option_action
Closes #22625
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/master/2018_10_17_00_world.sql | 1213 |
1 files changed, 1213 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_10_17_00_world.sql b/sql/updates/world/master/2018_10_17_00_world.sql new file mode 100644 index 00000000000..60ca97e4a29 --- /dev/null +++ b/sql/updates/world/master/2018_10_17_00_world.sql @@ -0,0 +1,1213 @@ +-- +DELETE FROM `gossip_menu` WHERE (`MenuId`=19769 AND `TextId`=29281) OR (`MenuId`=20403 AND `TextId`=29878) OR (`MenuId`=20001 AND `TextId`=30284) OR (`MenuId`=20000 AND `TextId`=29825) OR (`MenuId`=19904 AND `TextId`=29577) OR (`MenuId`=19263 AND `TextId`=28313) OR (`MenuId`=19240 AND `TextId`=28245) OR (`MenuId`=19237 AND `TextId`=28243) OR (`MenuId`=20284 AND `TextId`=30317) OR (`MenuId`=20328 AND `TextId`=30405) OR (`MenuId`=19979 AND `TextId`=29641) OR (`MenuId`=19982 AND `TextId`=29641) OR (`MenuId`=20187 AND `TextId`=30053) OR (`MenuId`=20644 AND `TextId`=27259) OR (`MenuId`=20576 AND `TextId`=30843) OR (`MenuId`=20576 AND `TextId`=30837) OR (`MenuId`=20549 AND `TextId`=30775) OR (`MenuId`=20560 AND `TextId`=30817) OR (`MenuId`=20643 AND `TextId`=30960) OR (`MenuId`=20641 AND `TextId`=30952) OR (`MenuId`=20620 AND `TextId`=30921) OR (`MenuId`=20618 AND `TextId`=30920) OR (`MenuId`=20617 AND `TextId`=30919) OR (`MenuId`=20639 AND `TextId`=30945) OR (`MenuId`=20638 AND `TextId`=30942) OR (`MenuId`=20635 AND `TextId`=30937) OR (`MenuId`=20619 AND `TextId`=30922) OR (`MenuId`=20591 AND `TextId`=30866) OR (`MenuId`=20378 AND `TextId`=30471) OR (`MenuId`=21755 AND `TextId`=33194) OR (`MenuId`=20738 AND `TextId`=31130) OR (`MenuId`=19722 AND `TextId`=29253) OR (`MenuId`=19764 AND `TextId`=29265) OR (`MenuId`=19760 AND `TextId`=29235) OR (`MenuId`=19761 AND `TextId`=29218) OR (`MenuId`=19750 AND `TextId`=29230) OR (`MenuId`=19751 AND `TextId`=29218) OR (`MenuId`=19740 AND `TextId`=29222) OR (`MenuId`=19741 AND `TextId`=29218) OR (`MenuId`=19758 AND `TextId`=29234) OR (`MenuId`=19759 AND `TextId`=29218) OR (`MenuId`=19579 AND `TextId`=28972) OR (`MenuId`=19515 AND `TextId`=28836) OR (`MenuId`=20166 AND `TextId`=29996) OR (`MenuId`=19198 AND `TextId`=28134) OR (`MenuId`=18851 AND `TextId`=27457) OR (`MenuId`=18849 AND `TextId`=27457) OR (`MenuId`=18848 AND `TextId`=27457) OR (`MenuId`=20496 AND `TextId`=30685) OR (`MenuId`=20506 AND `TextId`=14013) OR (`MenuId`=21664 AND `TextId`=32983) OR (`MenuId`=20086 AND `TextId`=29838) OR (`MenuId`=18705 AND `TextId`=14126) OR (`MenuId`=20578 AND `TextId`=30840) OR (`MenuId`=19241 AND `TextId`=28275) OR (`MenuId`=18897 AND `TextId`=27543) OR (`MenuId`=18896 AND `TextId`=27542) OR (`MenuId`=18895 AND `TextId`=27541) OR (`MenuId`=20739 AND `TextId`=31134) OR (`MenuId`=20314 AND `TextId`=30392) OR (`MenuId`=18893 AND `TextId`=27539) OR (`MenuId`=18892 AND `TextId`=27538) OR (`MenuId`=18981 AND `TextId`=27714) OR (`MenuId`=18979 AND `TextId`=27712) OR (`MenuId`=18970 AND `TextId`=27700) OR (`MenuId`=19010 AND `TextId`=27761) OR (`MenuId`=19011 AND `TextId`=27762) OR (`MenuId`=19009 AND `TextId`=27760) OR (`MenuId`=19106 AND `TextId`=27950) OR (`MenuId`=19180 AND `TextId`=28112) OR (`MenuId`=19067 AND `TextId`=27872) OR (`MenuId`=19060 AND `TextId`=27854) OR (`MenuId`=18811 AND `TextId`=27386) OR (`MenuId`=18777 AND `TextId`=27317) OR (`MenuId`=20320 AND `TextId`=30399) OR (`MenuId`=18433 AND `TextId`=26585) OR (`MenuId`=18463 AND `TextId`=26678) OR (`MenuId`=10184 AND `TextId`=14125) OR (`MenuId`=18933 AND `TextId`=27614) OR (`MenuId`=20997 AND `TextId`=31673) OR (`MenuId`=21415 AND `TextId`=31758) OR (`MenuId`=19295 AND `TextId`=28377) OR (`MenuId`=19297 AND `TextId`=28380) OR (`MenuId`=20155 AND `TextId`=29973) OR (`MenuId`=19057 AND `TextId`=27865) OR (`MenuId`=19055 AND `TextId`=27864) OR (`MenuId`=19058 AND `TextId`=27866) OR (`MenuId`=18927 AND `TextId`=27003) OR (`MenuId`=20307 AND `TextId`=30384) OR (`MenuId`=18985 AND `TextId`=27718) OR (`MenuId`=18984 AND `TextId`=27717) OR (`MenuId`=21257 AND `TextId`=27784) OR (`MenuId`=19114 AND `TextId`=27965) OR (`MenuId`=19114 AND `TextId`=27963) OR (`MenuId`=18750 AND `TextId`=27261) OR (`MenuId`=18768 AND `TextId`=27291) OR (`MenuId`=20316 AND `TextId`=30394) OR (`MenuId`=19888 AND `TextId`=29558) OR (`MenuId`=19889 AND `TextId`=29559) OR (`MenuId`=19776 AND `TextId`=29292) OR (`MenuId`=20432 AND `TextId`=29279) OR (`MenuId`=19934 AND `TextId`=29624) OR (`MenuId`=19703 AND `TextId`=29280) OR (`MenuId`=19604 AND `TextId`=29024) OR (`MenuId`=19605 AND `TextId`=29030) OR (`MenuId`=19603 AND `TextId`=29029) OR (`MenuId`=19576 AND `TextId`=28965) OR (`MenuId`=19587 AND `TextId`=28999) OR (`MenuId`=19576 AND `TextId`=28998) OR (`MenuId`=19660 AND `TextId`=29121) OR (`MenuId`=19703 AND `TextId`=29207) OR (`MenuId`=20432 AND `TextId`=28453) OR (`MenuId`=19709 AND `TextId`=29211) OR (`MenuId`=19709 AND `TextId`=29214) OR (`MenuId`=19792 AND `TextId`=6995) OR (`MenuId`=19797 AND `TextId`=29338) OR (`MenuId`=19796 AND `TextId`=29337) OR (`MenuId`=19850 AND `TextId`=29478) OR (`MenuId`=20432 AND `TextId`=29295) OR (`MenuId`=20431 AND `TextId`=30576) OR (`MenuId`=20362 AND `TextId`=30456) OR (`MenuId`=19772 AND `TextId`=29284) OR (`MenuId`=19912 AND `TextId`=29585) OR (`MenuId`=19910 AND `TextId`=28740) OR (`MenuId`=19716 AND `TextId`=29242) OR (`MenuId`=19321 AND `TextId`=28452) OR (`MenuId`=20432 AND `TextId`=28452) OR (`MenuId`=19321 AND `TextId`=28453) OR (`MenuId`=19321 AND `TextId`=28451) OR (`MenuId`=19323 AND `TextId`=28455) OR (`MenuId`=19322 AND `TextId`=28454) OR (`MenuId`=18512 AND `TextId`=26761) OR (`MenuId`=20215 AND `TextId`=30340) OR (`MenuId`=19476 AND `TextId`=28758) OR (`MenuId`=20679 AND `TextId`=14162) OR (`MenuId`=21490 AND `TextId`=32738) OR (`MenuId`=18380 AND `TextId`=14712) OR (`MenuId`=18736 AND `TextId`=27231) OR (`MenuId`=18735 AND `TextId`=27230) OR (`MenuId`=18728 AND `TextId`=27209) OR (`MenuId`=18918 AND `TextId`=27584) OR (`MenuId`=18917 AND `TextId`=27583) OR (`MenuId`=20157 AND `TextId`=29982) OR (`MenuId`=18809 AND `TextId`=27374) OR (`MenuId`=20489 AND `TextId`=30675) OR (`MenuId`=20442 AND `TextId`=30589) OR (`MenuId`=19470 AND `TextId`=28751) OR (`MenuId`=21018 AND `TextId`=31718) OR (`MenuId`=19094 AND `TextId`=27918) OR (`MenuId`=20253 AND `TextId`=30254) OR (`MenuId`=20252 AND `TextId`=30253) OR (`MenuId`=20251 AND `TextId`=30252) OR (`MenuId`=20250 AND `TextId`=30251) OR (`MenuId`=20858 AND `TextId`=31348) OR (`MenuId`=21017 AND `TextId`=31715) OR (`MenuId`=20815 AND `TextId`=31242) OR (`MenuId`=18961 AND `TextId`=27676) OR (`MenuId`=19540 AND `TextId`=28878) OR (`MenuId`=19853 AND `TextId`=29485) OR (`MenuId`=18905 AND `TextId`=24747) OR (`MenuId`=18906 AND `TextId`=24751) OR (`MenuId`=20709 AND `TextId`=31088) OR (`MenuId`=20450 AND `TextId`=30604) OR (`MenuId`=20452 AND `TextId`=30607) OR (`MenuId`=20436 AND `TextId`=30580) OR (`MenuId`=20449 AND `TextId`=30602) OR (`MenuId`=20397 AND `TextId`=30503) OR (`MenuId`=18068 AND `TextId`=26032) OR (`MenuId`=20367 AND `TextId`=26920) OR (`MenuId`=19810 AND `TextId`=29373) OR (`MenuId`=19134 AND `TextId`=28003) OR (`MenuId`=19249 AND `TextId`=28266) OR (`MenuId`=19250 AND `TextId`=28267) OR (`MenuId`=19251 AND `TextId`=28268) OR (`MenuId`=19252 AND `TextId`=28269) OR (`MenuId`=19245 AND `TextId`=28262) OR (`MenuId`=19246 AND `TextId`=28263) OR (`MenuId`=19247 AND `TextId`=28264) OR (`MenuId`=19248 AND `TextId`=28265) OR (`MenuId`=19075 AND `TextId`=27884) OR (`MenuId`=19194 AND `TextId`=28127) OR (`MenuId`=19068 AND `TextId`=27871) OR (`MenuId`=19870 AND `TextId`=29515) OR (`MenuId`=20710 AND `TextId`=31089) OR (`MenuId`=21062 AND `TextId`=31837) OR (`MenuId`=21005 AND `TextId`=31696) OR (`MenuId`=21060 AND `TextId`=31835) OR (`MenuId`=20974 AND `TextId`=31599) OR (`MenuId`=18502 AND `TextId`=26746) OR (`MenuId`=19238 AND `TextId`=28244) OR (`MenuId`=20417 AND `TextId`=30524) OR (`MenuId`=18973 AND `TextId`=27706) OR (`MenuId`=18987 AND `TextId`=27720) OR (`MenuId`=19318 AND `TextId`=28438) OR (`MenuId`=19024 AND `TextId`=27781) OR (`MenuId`=19318 AND `TextId`=28437) OR (`MenuId`=19899 AND `TextId`=29571) OR (`MenuId`=20212 AND `TextId`=30122) OR (`MenuId`=20196 AND `TextId`=30083) OR (`MenuId`=20197 AND `TextId`=30084) OR (`MenuId`=20198 AND `TextId`=30085) OR (`MenuId`=19933 AND `TextId`=29623) OR (`MenuId`=20327 AND `TextId`=30413) OR (`MenuId`=20324 AND `TextId`=30411) OR (`MenuId`=20372 AND `TextId`=30465) OR (`MenuId`=18748 AND `TextId`=27379) OR (`MenuId`=20229 AND `TextId`=30211) OR (`MenuId`=20376 AND `TextId`=28901) OR (`MenuId`=20228 AND `TextId`=30210) OR (`MenuId`=20119 AND `TextId`=29909) OR (`MenuId`=20391 AND `TextId`=30491) OR (`MenuId`=20111 AND `TextId`=29891) OR (`MenuId`=20110 AND `TextId`=29890) OR (`MenuId`=20112 AND `TextId`=29892) OR (`MenuId`=19696 AND `TextId`=30287) OR (`MenuId`=20286 AND `TextId`=30330) OR (`MenuId`=20390 AND `TextId`=30490) OR (`MenuId`=19706 AND `TextId`=29209) OR (`MenuId`=19704 AND `TextId`=29210) OR (`MenuId`=19705 AND `TextId`=29208) OR (`MenuId`=18531 AND `TextId`=28849) OR (`MenuId`=19696 AND `TextId`=29256) OR (`MenuId`=19696 AND `TextId`=29191) OR (`MenuId`=20193 AND `TextId`=30060) OR (`MenuId`=19907 AND `TextId`=29581) OR (`MenuId`=19908 AND `TextId`=29580) OR (`MenuId`=19905 AND `TextId`=29579) OR (`MenuId`=19906 AND `TextId`=29578) OR (`MenuId`=19902 AND `TextId`=29575) OR (`MenuId`=19893 AND `TextId`=29574) OR (`MenuId`=20268 AND `TextId`=30272) OR (`MenuId`=19895 AND `TextId`=29564) OR (`MenuId`=19885 AND `TextId`=29551) OR (`MenuId`=20121 AND `TextId`=29914) OR (`MenuId`=20121 AND `TextId`=29913) OR (`MenuId`=19524 AND `TextId`=28946) OR (`MenuId`=19571 AND `TextId`=28946) OR (`MenuId`=19524 AND `TextId`=28851) OR (`MenuId`=19475 AND `TextId`=29059) OR (`MenuId`=19573 AND `TextId`=28948) OR (`MenuId`=19475 AND `TextId`=28757) OR (`MenuId`=19807 AND `TextId`=29370) OR (`MenuId`=20234 AND `TextId`=28740) OR (`MenuId`=19718 AND `TextId`=29245) OR (`MenuId`=19718 AND `TextId`=29246) OR (`MenuId`=19152 AND `TextId`=29548) OR (`MenuId`=19152 AND `TextId`=28057) OR (`MenuId`=19152 AND `TextId`=28054) OR (`MenuId`=19041 AND `TextId`=27815) OR (`MenuId`=20507 AND `TextId`=30713) OR (`MenuId`=19392 AND `TextId`=28576) OR (`MenuId`=18482 AND `TextId`=26705) OR (`MenuId`=19267 AND `TextId`=28329) OR (`MenuId`=19264 AND `TextId`=28323) OR (`MenuId`=20636 AND `TextId`=30941) OR (`MenuId`=19211 AND `TextId`=27868) OR (`MenuId`=19042 AND `TextId`=27820) OR (`MenuId`=20318 AND `TextId`=30397) OR (`MenuId`=19692 AND `TextId`=29185) OR (`MenuId`=19692 AND `TextId`=29184) OR (`MenuId`=19832 AND `TextId`=29442) OR (`MenuId`=19831 AND `TextId`=29441) OR (`MenuId`=19830 AND `TextId`=29440) OR (`MenuId`=19829 AND `TextId`=29439) OR (`MenuId`=19783 AND `TextId`=29308) OR (`MenuId`=20589 AND `TextId`=30862) OR (`MenuId`=19360 AND `TextId`=28527) OR (`MenuId`=19980 AND `TextId`=29641) OR (`MenuId`=20271 AND `TextId`=30283) OR (`MenuId`=20491 AND `TextId`=30677) OR (`MenuId`=20490 AND `TextId`=30676) OR (`MenuId`=19301 AND `TextId`=28399) OR (`MenuId`=20728 AND `TextId`=11093) OR (`MenuId`=19286 AND `TextId`=28360) OR (`MenuId`=20603 AND `TextId`=30895) OR (`MenuId`=18966 AND `TextId`=27693) OR (`MenuId`=18967 AND `TextId`=27692) OR (`MenuId`=18958 AND `TextId`=27672) OR (`MenuId`=18959 AND `TextId`=27673) OR (`MenuId`=20399 AND `TextId`=30507) OR (`MenuId`=20406 AND `TextId`=30510) OR (`MenuId`=20543 AND `TextId`=30757) OR (`MenuId`=20673 AND `TextId`=31003) OR (`MenuId`=19554 AND `TextId`=28901) OR (`MenuId`=19506 AND `TextId`=28819) OR (`MenuId`=19892 AND `TextId`=29562) OR (`MenuId`=18755 AND `TextId`=27277) OR (`MenuId`=18977 AND `TextId`=27710) OR (`MenuId`=20118 AND `TextId`=29907) OR (`MenuId`=17415 AND `TextId`=25870) OR (`MenuId`=20285 AND `TextId`=30323) OR (`MenuId`=18207 AND `TextId`=26154) OR (`MenuId`=18054 AND `TextId`=25989) OR (`MenuId`=18446 AND `TextId`=26628) OR (`MenuId`=20211 AND `TextId`=30121) OR (`MenuId`=20266 AND `TextId`=30270) OR (`MenuId`=20267 AND `TextId`=30271) OR (`MenuId`=20493 AND `TextId`=30679) OR (`MenuId`=20492 AND `TextId`=30678) OR (`MenuId`=20092 AND `TextId`=29850) OR (`MenuId`=20091 AND `TextId`=29845) OR (`MenuId`=19275 AND `TextId`=28337) OR (`MenuId`=19719 AND `TextId`=29247) OR (`MenuId`=18391 AND `TextId`=26503) OR (`MenuId`=18233 AND `TextId`=26196) OR (`MenuId`=18391 AND `TextId`=26502) OR (`MenuId`=18634 AND `TextId`=27062) OR (`MenuId`=18515 AND `TextId`=26766) OR (`MenuId`=18513 AND `TextId`=26764) OR (`MenuId`=18522 AND `TextId`=26778) OR (`MenuId`=18514 AND `TextId`=26765) OR (`MenuId`=19355 AND `TextId`=28508) OR (`MenuId`=20077 AND `TextId`=29821) OR (`MenuId`=18238 AND `TextId`=26214) OR (`MenuId`=19919 AND `TextId`=25909) OR (`MenuId`=17439 AND `TextId`=25908) OR (`MenuId`=19512 AND `TextId`=25898) OR (`MenuId`=18182 AND `TextId`=26110) OR (`MenuId`=18180 AND `TextId`=25179) OR (`MenuId`=18178 AND `TextId`=25529) OR (`MenuId`=18177 AND `TextId`=25530) OR (`MenuId`=18176 AND `TextId`=25531) OR (`MenuId`=18175 AND `TextId`=25533) OR (`MenuId`=18174 AND `TextId`=25868) OR (`MenuId`=18173 AND `TextId`=25869) OR (`MenuId`=18066 AND `TextId`=26006) OR (`MenuId`=19040 AND `TextId`=27813) OR (`MenuId`=19607 AND `TextId`=29034) OR (`MenuId`=18840 AND `TextId`=27443) OR (`MenuId`=19648 AND `TextId`=29102) OR (`MenuId`=19923 AND `TextId`=29600) OR (`MenuId`=17377 AND `TextId`=25830) OR (`MenuId`=18836 AND `TextId`=27440) OR (`MenuId`=20063 AND `TextId`=29793) OR (`MenuId`=19978 AND `TextId`=29641) OR (`MenuId`=19945 AND `TextId`=29641) OR (`MenuId`=19991 AND `TextId`=29641) OR (`MenuId`=19990 AND `TextId`=29641) OR (`MenuId`=19944 AND `TextId`=29641) OR (`MenuId`=21059 AND `TextId`=31834) OR (`MenuId`=21602 AND `TextId`=33005) OR (`MenuId`=21208 AND `TextId`=32179) OR (`MenuId`=21380 AND `TextId`=32555) OR (`MenuId`=21163 AND `TextId`=32104) OR (`MenuId`=21067 AND `TextId`=31842) OR (`MenuId`=21695 AND `TextId`=33057) OR (`MenuId`=20745 AND `TextId`=31148) OR (`MenuId`=20905 AND `TextId`=31437) OR (`MenuId`=20903 AND `TextId`=31435) OR (`MenuId`=20902 AND `TextId`=31434) OR (`MenuId`=20906 AND `TextId`=31438) OR (`MenuId`=20907 AND `TextId`=31439) OR (`MenuId`=20900 AND `TextId`=31431) OR (`MenuId`=20563 AND `TextId`=30822) OR (`MenuId`=20886 AND `TextId`=31402) OR (`MenuId`=20591 AND `TextId`=31078) OR (`MenuId`=20555 AND `TextId`=30811) OR (`MenuId`=20696 AND `TextId`=31047) OR (`MenuId`=20684 AND `TextId`=31026) OR (`MenuId`=20714 AND `TextId`=31093) OR (`MenuId`=20695 AND `TextId`=31046) OR (`MenuId`=20715 AND `TextId`=31095) OR (`MenuId`=20716 AND `TextId`=31094) OR (`MenuId`=20695 AND `TextId`=31092) OR (`MenuId`=20689 AND `TextId`=31031) OR (`MenuId`=20688 AND `TextId`=31030) OR (`MenuId`=20687 AND `TextId`=31029) OR (`MenuId`=20686 AND `TextId`=31028) OR (`MenuId`=20685 AND `TextId`=31027) OR (`MenuId`=20556 AND `TextId`=30812) OR (`MenuId`=20544 AND `TextId`=30761) OR (`MenuId`=20545 AND `TextId`=30764) OR (`MenuId`=20681 AND `TextId`=31023) OR (`MenuId`=20601 AND `TextId`=30891) OR (`MenuId`=20601 AND `TextId`=30890) OR (`MenuId`=20601 AND `TextId`=30883) OR (`MenuId`=20601 AND `TextId`=30882) OR (`MenuId`=20591 AND `TextId`=30867) OR (`MenuId`=20651 AND `TextId`=30966) OR (`MenuId`=20637 AND `TextId`=30939) OR (`MenuId`=20608 AND `TextId`=30906) OR (`MenuId`=22142 AND `TextId`=31631) OR (`MenuId`=21478 AND `TextId`=32721) OR (`MenuId`=21075 AND `TextId`=31923) OR (`MenuId`=21058 AND `TextId`=31832) OR (`MenuId`=21352 AND `TextId`=32453) OR (`MenuId`=21730 AND `TextId`=32238) OR (`MenuId`=21144 AND `TextId`=32063) OR (`MenuId`=21144 AND `TextId`=32064) OR (`MenuId`=21334 AND `TextId`=32431) OR (`MenuId`=21333 AND `TextId`=32430) OR (`MenuId`=21333 AND `TextId`=32429) OR (`MenuId`=21323 AND `TextId`=32400) OR (`MenuId`=21315 AND `TextId`=32383) OR (`MenuId`=21312 AND `TextId`=32380) OR (`MenuId`=21238 AND `TextId`=32321) OR (`MenuId`=21253 AND `TextId`=32255) OR (`MenuId`=21291 AND `TextId`=32256) OR (`MenuId`=21247 AND `TextId`=32247) OR (`MenuId`=21242 AND `TextId`=32235) OR (`MenuId`=21243 AND `TextId`=32236) OR (`MenuId`=21244 AND `TextId`=32237) OR (`MenuId`=21748 AND `TextId`=33170) OR (`MenuId`=21238 AND `TextId`=32231) OR (`MenuId`=21241 AND `TextId`=32234) OR (`MenuId`=21240 AND `TextId`=32233) OR (`MenuId`=21239 AND `TextId`=32232) OR (`MenuId`=21253 AND `TextId`=32313) OR (`MenuId`=21749 AND `TextId`=33171) OR (`MenuId`=21737 AND `TextId`=33168) OR (`MenuId`=21709 AND `TextId`=31640) OR (`MenuId`=20985 AND `TextId`=31694) OR (`MenuId`=21208 AND `TextId`=33055) OR (`MenuId`=21709 AND `TextId`=33056) OR (`MenuId`=21519 AND `TextId`=32798) OR (`MenuId`=21505 AND `TextId`=32772) OR (`MenuId`=21506 AND `TextId`=32773) OR (`MenuId`=21513 AND `TextId`=32787) OR (`MenuId`=21509 AND `TextId`=32778) OR (`MenuId`=19911 AND `TextId`=29584) OR (`MenuId`=19896 AND `TextId`=29566) OR (`MenuId`=19867 AND `TextId`=29508) OR (`MenuId`=19864 AND `TextId`=29503) OR (`MenuId`=19860 AND `TextId`=29502) OR (`MenuId`=19859 AND `TextId`=29495) OR (`MenuId`=19769 AND `TextId`=29480) OR (`MenuId`=21580 AND `TextId`=32926) OR (`MenuId`=21336 AND `TextId`=32436) OR (`MenuId`=21208 AND `TextId`=32946) OR (`MenuId`=21697 AND `TextId`=33066) OR (`MenuId`=21702 AND `TextId`=33063) OR (`MenuId`=21698 AND `TextId`=33061) OR (`MenuId`=21701 AND `TextId`=33062) OR (`MenuId`=21700 AND `TextId`=33064) OR (`MenuId`=21245 AND `TextId`=32239) OR (`MenuId`=21326 AND `TextId`=32748) OR (`MenuId`=21199 AND `TextId`=32160) OR (`MenuId`=21198 AND `TextId`=32158) OR (`MenuId`=21197 AND `TextId`=32156) OR (`MenuId`=21326 AND `TextId`=32405) OR (`MenuId`=21464 AND `TextId`=32692) OR (`MenuId`=21457 AND `TextId`=32673) OR (`MenuId`=21456 AND `TextId`=32672) OR (`MenuId`=21454 AND `TextId`=32670) OR (`MenuId`=21694 AND `TextId`=33043) OR (`MenuId`=21692 AND `TextId`=33045) OR (`MenuId`=21463 AND `TextId`=32691) OR (`MenuId`=21462 AND `TextId`=9849) OR (`MenuId`=21540 AND `TextId`=32832) OR (`MenuId`=21455 AND `TextId`=32671) OR (`MenuId`=21451 AND `TextId`=32658) OR (`MenuId`=21245 AND `TextId`=32238) OR (`MenuId`=21004 AND `TextId`=31695) OR (`MenuId`=21049 AND `TextId`=31811) OR (`MenuId`=21350 AND `TextId`=32451) OR (`MenuId`=20978 AND `TextId`=31631) OR (`MenuId`=21423 AND `TextId`=32623) OR (`MenuId`=21668 AND `TextId`=32944) OR (`MenuId`=21013 AND `TextId`=31708) OR (`MenuId`=21072 AND `TextId`=31906) OR (`MenuId`=20895 AND `TextId`=31423) OR (`MenuId`=20895 AND `TextId`=31424) OR (`MenuId`=20821 AND `TextId`=31261) OR (`MenuId`=20819 AND `TextId`=31254) OR (`MenuId`=20678 AND `TextId`=31017) OR (`MenuId`=20814 AND `TextId`=31243) OR (`MenuId`=20677 AND `TextId`=31015) OR (`MenuId`=20746 AND `TextId`=31149) OR (`MenuId`=20732 AND `TextId`=31122) OR (`MenuId`=20989 AND `TextId`=31662) OR (`MenuId`=20866 AND `TextId`=31359) OR (`MenuId`=20867 AND `TextId`=31358) OR (`MenuId`=20864 AND `TextId`=31357) OR (`MenuId`=20865 AND `TextId`=31356) OR (`MenuId`=20861 AND `TextId`=31354) OR (`MenuId`=20863 AND `TextId`=31353) OR (`MenuId`=20568 AND `TextId`=30827) OR (`MenuId`=20825 AND `TextId`=31268) OR (`MenuId`=20816 AND `TextId`=31244) OR (`MenuId`=20730 AND `TextId`=31510) OR (`MenuId`=20924 AND `TextId`=31511) OR (`MenuId`=20827 AND `TextId`=31270) OR (`MenuId`=20898 AND `TextId`=31427) OR (`MenuId`=21063 AND `TextId`=31838) OR (`MenuId`=21064 AND `TextId`=31839) OR (`MenuId`=21065 AND `TextId`=31840) OR (`MenuId`=20957 AND `TextId`=31568) OR (`MenuId`=21066 AND `TextId`=31841) OR (`MenuId`=19472 AND `TextId`=28753) OR (`MenuId`=19473 AND `TextId`=28754) OR (`MenuId`=19103 AND `TextId`=27939) OR (`MenuId`=19138 AND `TextId`=28006) OR (`MenuId`=18807 AND `TextId`=27368) OR (`MenuId`=18778 AND `TextId`=27321) OR (`MenuId`=20498 AND `TextId`=30687) OR (`MenuId`=20501 AND `TextId`=30690) OR (`MenuId`=20500 AND `TextId`=30689) OR (`MenuId`=20499 AND `TextId`=30688) OR (`MenuId`=19313 AND `TextId`=28424) OR (`MenuId`=20269 AND `TextId`=30275) OR (`MenuId`=12618 AND `TextId`=17749) OR (`MenuId`=19883 AND `TextId`=29547) OR (`MenuId`=18656 AND `TextId`=27092) OR (`MenuId`=20539 AND `TextId`=30748) OR (`MenuId`=18841 AND `TextId`=27444) OR (`MenuId`=19484 AND `TextId`=28788) OR (`MenuId`=19073 AND `TextId`=27881) OR (`MenuId`=18575 AND `TextId`=26917) OR (`MenuId`=18576 AND `TextId`=26916) OR (`MenuId`=18574 AND `TextId`=26915) OR (`MenuId`=18430 AND `TextId`=26576) OR (`MenuId`=19440 AND `TextId`=28691) OR (`MenuId`=19951 AND `TextId`=29659) OR (`MenuId`=19474 AND `TextId`=28697) OR (`MenuId`=19405 AND `TextId`=28623) OR (`MenuId`=19405 AND `TextId`=28616) OR (`MenuId`=19865 AND `TextId`=29504) OR (`MenuId`=19869 AND `TextId`=29512) OR (`MenuId`=20273 AND `TextId`=11714) OR (`MenuId`=18315 AND `TextId`=26334) OR (`MenuId`=19123 AND `TextId`=27989) OR (`MenuId`=18248 AND `TextId`=27013) OR (`MenuId`=18247 AND `TextId`=26233) OR (`MenuId`=18248 AND `TextId`=26234) OR (`MenuId`=18480 AND `TextId`=26707) OR (`MenuId`=18457 AND `TextId`=26706) OR (`MenuId`=18480 AND `TextId`=26703) OR (`MenuId`=18454 AND `TextId`=26654) OR (`MenuId`=19166 AND `TextId`=28084) OR (`MenuId`=18507 AND `TextId`=26752) OR (`MenuId`=19971 AND `TextId`=29696) OR (`MenuId`=20363 AND `TextId`=30457); +INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES +(19769, 29281, 27980), -- 107351 (Archmage Khadgar) +(20403, 29878, 27980), -- Researcher Tulius +(20001, 30284, 27980), -- 106433 (Grand Conjurer Mimic) +(20000, 29825, 27980), -- Archmage Omniara +(19904, 29577, 27980), -- 108515 (Archmage Melis) +(19263, 28313, 27980), -- 102689 (Shardmaster Ufrogg) +(19240, 28245, 27980), -- Bitestone Rockbeater +(19237, 28243, 27980), -- 102366 (Barbrul the Brewbrul) +(20284, 30317, 27980), -- 89398 (Allari the Souleater) +(20328, 30405, 27980), -- 110427 (Minuette) +(19979, 29641, 27980), -- 251725 +(19982, 29641, 27980), -- 251728 +(20187, 30053, 27980), -- First Arcanist Thalyssra +(20644, 27259, 27980), -- First Arcanist Thalyssra +(20576, 30843, 27980), -- 115557 (First Arcanist Thalyssra) +(20576, 30837, 27980), -- 115557 (First Arcanist Thalyssra) +(20549, 30775, 27980), -- 115247 (Ly'leth Lunastre) +(20560, 30817, 27980), -- 115376 (Maribeth) +(20643, 30960, 27980), -- 116085 (Arluelle) +(20641, 30952, 27980), -- 114983 (Thorvos) +(20620, 30921, 27980), -- 116001 (Eneas) +(20618, 30920, 27980), -- 115991 (Emille) +(20617, 30919, 27980), -- 115992 (Brigitte) +(20639, 30945, 27980), -- 114978 (Master Devlyn) +(20638, 30942, 27980), -- 114985 (Scarleth) +(20635, 30937, 27980), -- 114983 (Thorvos) +(20619, 30922, 27980), -- 116001 (Eneas) +(20591, 30866, 27980), -- Chief Telemancer Oculeth +(20378, 30471, 27980), -- 113425 (Rovendros) +(21755, 33194, 27980), -- Tyrande Whisperwind +(20738, 31130, 27980), -- 113617 (Dusk Lily Agent) +(19722, 29253, 27980), -- 106468 (Ly'leth Lunastre) +(19764, 29265, 27980), -- 112697 (Suspicious Noble) +(19760, 29235, 27980), -- 107486 (Chatty Rumormonger) +(19761, 29218, 27980), -- 107486 (Chatty Rumormonger) +(19750, 29230, 27980), -- 107486 (Chatty Rumormonger) +(19751, 29218, 27980), -- 107486 (Chatty Rumormonger) +(19740, 29222, 27980), -- 107486 (Chatty Rumormonger) +(19741, 29218, 27980), -- 107486 (Chatty Rumormonger) +(19758, 29234, 27980), -- 107486 (Chatty Rumormonger) +(19759, 29218, 27980), -- 107486 (Chatty Rumormonger) +(19579, 28972, 27980), -- 106112 (Wounded Nightborne Civilian) +(19515, 28836, 27980), -- 105729 (Signal Lantern) +(20166, 29996, 27980), -- 95676 (Odyn) +(19198, 28134, 27980), -- 95676 (Odyn) +(18851, 27457, 27980), -- 97081 (King Bjorn) +(18849, 27457, 27980), -- 97083 (King Ranulf) +(18848, 27457, 27980), -- 97084 (King Tor) +(20496, 30685, 27980), -- 96786 (Archmage Celindra) +(20506, 14013, 27980), -- 96838 (Kitz Proudbreeze) +(21664, 32983, 27980), -- 110624 (Edirah) +(20086, 29838, 27980), -- 110624 (Edirah) +(18705, 14126, 27980), -- 93542 (Tanithria) +(20578, 30840, 27980), -- 90418 (Archmage Modera) +(19241, 28275, 27980), -- 101846 (Nomi) +(18897, 27543, 27980), -- 98609 (Scout Proudhill) +(18896, 27542, 27980), -- 98607 (Scout Brownmane) +(18895, 27541, 27980), -- 98610 (Scout Cloudeye) +(20739, 31134, 27980), -- 117226 (Maximillian of Northshire) +(20314, 30392, 27980), -- 108559 (Chaff Prepfoot) +(18893, 27539, 27980), -- 98507 (Trand Prepfoot) +(18892, 27538, 27980), -- 98507 (Trand Prepfoot) +(18981, 27714, 27980), -- 98541 (Wu'de Prepfoot) +(18979, 27712, 27980), -- 98540 (Lisy Prepfoot) +(18970, 27700, 27980), -- 98508 (Darsa Prepfoot) +(19010, 27761, 27980), -- 98510 (Amben Prepfoot) +(19011, 27762, 27980), -- 98543 (Tye Prepfoot) +(19009, 27760, 27980), -- 98509 (Sana Prepfoot) +(19106, 27950, 27980), -- 99746 (Trytooth Hardchisel) +(19180, 28112, 27980), -- 94097 (Bluewax Ratcatcher) +(19067, 27872, 27980), -- 100430 (Bluewax Cavewhisker) +(19060, 27854, 27980), -- 93846 (Mayla Highmountain) +(18811, 27386, 27980), -- 114677 (Patri Burkhorn) +(18777, 27317, 27980), -- 97301 (Navarrogg) +(20320, 30399, 27980), -- 108554 (Burnedhoof the Retired) +(18433, 26585, 27980), -- 92242 (Barm Stonebreaker) +(18463, 26678, 27980), -- 93691 (Ronos Ironhorn) +(10184, 14125, 27980), -- 92243 (Muirn Ironhorn) +(18933, 27614, 27980), -- Bredda Tenderhide +(20997, 31673, 27980), -- 120457 (Akule Riverhorn) +(21415, 31758, 27980), -- 120457 (Akule Riverhorn) +(19295, 28377, 27980), -- 97925 (Aviana) +(19297, 28380, 27980), -- 97925 (Aviana) +(20155, 29973, 27980), -- 103082 (Fledgling Druid) +(19057, 27865, 27980), -- 100357 (Mycah Stonehoof) +(19055, 27864, 27980), -- 100352 (Kura Stonehoof) +(19058, 27866, 27980), -- 100358 (Oro Junior) +(18927, 27003, 27980), -- 94434 (Addie Fizzlebog) +(20307, 30384, 27980), -- 99207 (Margul) +(18985, 27718, 27980), -- 99669 (Bogrogg the Stonescreamer) +(18984, 27717, 27980), -- 99671 (Obrul the Thug) +(21257, 27784, 27980), -- 99624 (Navarrogg) +(19114, 27965, 27980), -- 95799 (Damrul the Stronk) +(19114, 27963, 27980), -- 95799 (Damrul the Stronk) +(18750, 27261, 27980), -- 97846 (Apprentice Rosalyn) +(18768, 27291, 27980), -- 97846 (Apprentice Rosalyn) +(20316, 30394, 27980), -- Kola Watermane +(19888, 29558, 27843), -- Ravandwyr +(19889, 29559, 27843), -- Esara Verrinde +(19776, 29292, 27843), -- 102700 (Meryl Felstorm) +(20432, 29279, 27843), -- 102700 (Meryl Felstorm) +(19934, 29624, 27843), -- 109307 (Ari) +(19703, 29280, 27843), -- 106530 (Ravandwyr) +(19604, 29024, 27843), -- 106656 (Seeker of Wisdom) +(19605, 29030, 27843), -- 106656 (Seeker of Wisdom) +(19603, 29029, 27843), -- 106656 (Seeker of Wisdom) +(19576, 28965, 27843), -- 106514 (Empyrean Disciple) +(19587, 28999, 27843), -- 106356 (Empyrean Conjuror) +(19576, 28998, 27843), -- 106356 (Empyrean Conjuror) +(19660, 29121, 27843), -- 106516 (Empyrean Astrologer) +(19703, 29207, 27843), -- 106530 (Ravandwyr) +(20432, 28453, 27843), -- 102700 (Meryl Felstorm) +(19709, 29211, 27843), -- 107277 (Blinks) +(19709, 29214, 27843), -- 107277 (Blinks) +(19792, 6995, 27843), -- 107716 (Daio the Decrepit) +(19797, 29338, 27843), -- 107716 (Daio the Decrepit) +(19796, 29337, 27843), -- 107716 (Daio the Decrepit) +(19850, 29478, 27843), -- Merina +(20432, 29295, 27843), -- 102700 (Meryl Felstorm) +(20431, 30576, 27843), -- 102700 (Meryl Felstorm) +(20362, 30456, 27843), -- 112440 (Jackson Watkins) +(19772, 29284, 27843), -- 107482 (Archmage Vargoth) +(19912, 29585, 27843), -- Archmage Modera +(19910, 28740, 27843), -- Archmage Kalec +(19716, 29242, 27843), -- 107452 (Old Fillmaff) +(19321, 28452, 27843), -- 102700 (Meryl Felstorm) +(20432, 28452, 27843), -- 102700 (Meryl Felstorm) +(19321, 28453, 27843), -- 102700 (Meryl Felstorm) +(19321, 28451, 27843), -- 102700 (Meryl Felstorm) +(19323, 28455, 27843), -- 102700 (Meryl Felstorm) +(19322, 28454, 27843), -- 102700 (Meryl Felstorm) +(18512, 26761, 27843), -- 94197 (Violet Hold Guard) +(20215, 30340, 27843), -- 111243 (Archmage Lan'dalock) +(19476, 28758, 27843), -- 96782 (Lucian Trias) +(20679, 14162, 27843), -- 96806 (Amisi Azuregaze) +(21490, 32738, 27843), -- 125261 (Bran Buckbeard) +(18380, 14712, 27843), -- 92456 (Linzy Blackbolt) +(18736, 27231, 27843), -- 92456 (Linzy Blackbolt) +(18735, 27230, 27843), -- 92456 (Linzy Blackbolt) +(18728, 27209, 27843), -- 92457 (Patricia Egan) +(18918, 27584, 27843), -- 98931 (Thanid Glowergold) +(18917, 27583, 27843), -- 93523 (Namha Moonwater) +(20157, 29982, 27843), -- 93528 (Angelique Butler) +(18809, 27374, 27843), -- 97718 (Vanessa Sellers) +(20489, 30675, 27843), -- 113873 (Archivist Elysiana) +(20442, 30589, 27843), -- 32725 (Warmage Silva) +(19470, 28751, 27843), -- 105332 (Desmond Gravesorrow) +(21018, 31718, 27843), -- 119484 (Captain Roberts) +(19094, 27918, 27843), -- 97005 (Debbi Moore) +(20253, 30254, 27843), -- 99349 (Robert "Chance" Llore) +(20252, 30253, 27843), -- 99349 (Robert "Chance" Llore) +(20251, 30252, 27843), -- 99349 (Robert "Chance" Llore) +(20250, 30251, 27843), -- 99349 (Robert "Chance" Llore) +(20858, 31348, 27843), -- 119226 (Danath Trollbane) +(21017, 31715, 27843), -- The Great Akazamzarak +(20815, 31242, 27843), -- 97331 (Icks) +(18961, 27676, 27843), -- 96979 (Bragund Brightlink) +(19540, 28878, 27843), -- 97004 ("Red" Jack Findle) +(19853, 29485, 27843), -- 108628 (Armond Thaco) +(18905, 24747, 27843), -- 98725 (Lio the Lioness) +(18906, 24751, 27843), -- 98725 (Lio the Lioness) +(20709, 31088, 27843), -- 96843 (Darthalia Ebonscorch) +(20450, 30604, 27843), -- 113929 (Kerta the Bold) +(20452, 30607, 27843), -- 113934 (Windle Sparkshine) +(20436, 30580, 27843), -- 98897 (Josie Birch) +(20449, 30602, 27843), -- 113928 (Didi the Wrench) +(20397, 30503, 27843), -- 113564 (Dubin Clay) +(18068, 26032, 27843), -- 95791 (Falara Nightsong) +(20367, 26920, 27843), -- 113404 (Illidari Darkdealer) +(19810, 29373, 27843), -- 113392 (Illidari Enforcer) +(19134, 28003, 27843), -- 100675 (Jace Darkweaver) +(19249, 28266, 27843), -- 100460 (Prophet Velen) +(19250, 28267, 27843), -- 100454 (Muradin Bronzebeard) +(19251, 28268, 27843), -- Moira Thaurissan +(19252, 28269, 27843), -- 100456 (Falstad Wildhammer) +(19245, 28262, 27843), -- 100472 (Aysa Cloudsinger) +(19246, 28263, 27843), -- 100471 (Gelbin Mekkatorque) +(19247, 28264, 27843), -- Malfurion Stormrage +(19248, 28265, 27843), -- 100458 (Tyrande Whisperwind) +(19075, 27884, 27843), -- 100429 (Anduin Wrynn) +(19194, 28127, 27843), -- 100395 (Genn Greymane) +(19068, 27871, 27843), -- 100395 (Genn Greymane) +(19870, 29515, 27843), -- 108920 (Captain Angelica) +(20710, 31089, 27980), -- 116302 (Archmage Khadgar) +(21062, 31837, 27980), -- 116576 (Maiev Shadowsong) +(21005, 31696, 27980), -- 120183 (Commander Chambers) +(21060, 31835, 27980), -- Illidan Stormrage +(20974, 31599, 27980), -- 120215 (Archmage Khadgar) +(18502, 26746, 27980), -- 93967 (Lyndras) +(19238, 28244, 27980), -- 102388 (Toryl) +(20417, 30524, 27980), -- 113680 (Naga Armaments) +(18973, 27706, 27980), -- 99563 (Fjolrik) +(18987, 27720, 27980), -- 99564 (Stokalfr) +(19318, 28438, 27980), -- 99544 (Brandolf) +(19024, 27781, 27980), -- 99559 (Jarl Throndyr) +(19318, 28437, 27980), -- 99544 (Brandolf) +(19899, 29571, 27980), -- Millhouse Manastorm +(20212, 30122, 27980), -- 110698 (Arluelle) +(20196, 30083, 27980), -- 112146 (First Arcanist Thalyssra) +(20197, 30084, 27980), -- 112145 (Arcanist Valtrois) +(20198, 30085, 27980), -- 112147 (Chief Telemancer Oculeth) +(19933, 29623, 27980), -- 109442 (Ciele) +(20327, 30413, 27980), -- 112555 (Flameweaver Ovin) +(20324, 30411, 27980), -- 112547 (Tempomancer Virinya) +(20372, 30465, 27980), -- 103131 (Keelay Moongrow) +(18748, 27379, 27980), -- 97140 (First Arcanist Thalyssra) +(20229, 30211, 27980), -- 101848 (Absolon) +(20376, 28901, 27980), -- 111903 (Lunastre Attendant) +(20228, 30210, 27980), -- 108870 (Sylverin) +(20119, 29909, 27980), -- Ly'leth Lunastre +(20391, 30491, 27980), -- 113516 (Dasdonia) +(20111, 29891, 27980), -- 110874 (Distraught Noble) +(20110, 29890, 27980), -- 110876 (Disgruntled Servant) +(20112, 29892, 27980), -- 110875 (Shamed Noble) +(19696, 30287, 27980), -- 107253 (Arluin) +(20286, 30330, 27980), -- 110654 (Frightened Laborer) +(20390, 30490, 27980), -- 113514 (Joshen Lafave) +(19706, 29209, 27980), -- 107350 (Cyrille) +(19704, 29210, 27980), -- 107348 (Sylessa) +(19705, 29208, 27980), -- 107349 (Lorin) +(18531, 28849, 27980), -- 93979 (Leyweaver Jorjana) +(19696, 29256, 27980), -- 107253 (Arluin) +(19696, 29191, 27980), -- 107253 (Arluin) +(20193, 30060, 27980), -- Margaux +(19907, 29581, 27980), -- 109223 (Margaux) +(19908, 29580, 27980), -- 109223 (Margaux) +(19905, 29579, 27980), -- 109223 (Margaux) +(19906, 29578, 27980), -- 109223 (Margaux) +(19902, 29575, 27980), -- 109223 (Margaux) +(19893, 29574, 27980), -- 109223 (Margaux) +(20268, 30272, 27980), -- Margaux +(19895, 29564, 27980), -- Margaux +(19885, 29551, 27980), -- Ly'leth Lunastre +(20121, 29914, 27980), -- 100775 (Lilryia Dawnwind) +(20121, 29913, 27980), -- 100775 (Lilryia Dawnwind) +(19524, 28946, 27980), -- 104544 (Naltethis) +(19571, 28946, 27980), -- 104544 (Naltethis) +(19524, 28851, 27980), -- 104544 (Naltethis) +(19475, 29059, 27980), -- 104369 (Mornath) +(19573, 28948, 27980), -- 104369 (Mornath) +(19475, 28757, 27980), -- 104369 (Mornath) +(19807, 29370, 27980), -- 107757 (Gnome Mage) +(20234, 28740, 27980), -- Image of Kalec +(19718, 29245, 27980), -- 111553 (Kalecgos) +(19718, 29246, 27980), -- 107465 (Kalecgos) +(19152, 29548, 27980), -- 100858 (Kyrtos) +(19152, 28057, 27980), -- 101076 (Kyrtos) +(19152, 28054, 27980), -- 101076 (Kyrtos) +(19041, 27815, 27980), -- 98969 (Stalriss Dawnrunner) +(20507, 30713, 27980); -- 114797 (Angus Stormbrew) + +INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES +(19392, 28576, 27980), -- 103852 (Brambley Morrison) +(18482, 26705, 27980), -- 242411 +(19267, 28329, 27980), -- 99890 (Lyana Darksorrow) +(19264, 28323, 27980), -- 99514 (Lyana Darksorrow) +(20636, 30941, 27980), -- Sentinel Moonshade +(19211, 27868, 27980), -- 100192 (Astoril) +(19042, 27820, 27980), -- 100192 (Astoril) +(20318, 30397, 27980), -- 111513 (Leyweaver Ke'lorin) +(19692, 29185, 27980), -- 107225 (Deline) +(19692, 29184, 27980), -- 107225 (Deline) +(19832, 29442, 27980), -- 108344 (Donatien) +(19831, 29441, 27980), -- 108345 (Clotaire) +(19830, 29440, 27980), -- 108347 (Ambrena) +(19829, 29439, 27980), -- 108346 (Lunette) +(19783, 29308, 27980), -- Ly'leth Lunastre +(20589, 30862, 27980), -- Kirin Tor Peacekeeper +(19360, 28527, 27980), -- 103807 (Daelar Swiftmeadow) +(19980, 29641, 27980), -- 251726 +(20271, 30283, 27980), -- 98720 (Ske'rit) +(20491, 30677, 27980), -- 110915 (Archmage Kesalon) +(20490, 30676, 27980), -- 110915 (Archmage Kesalon) +(19301, 28399, 27980), -- 103155 (Arcanist Valtrois) +(20728, 11093, 27980), -- 101766 (Thalrenus Rivertree) +(19286, 28360, 27980), -- 101765 (Syrana Starweaver) +(20603, 30895, 27980), -- 103055 (Kir'altius) +(18966, 27693, 27980), -- 99575 (Thaedris Feathersong) +(18967, 27692, 27980), -- 99575 (Thaedris Feathersong) +(18958, 27672, 27980), -- 99093 (Thaedris Feathersong) +(18959, 27673, 27980), -- 99093 (Thaedris Feathersong) +(20399, 30507, 27980), -- 113577 (Spirit Font) +(20406, 30510, 27980), -- 113606 (Ley Ward) +(20543, 30757, 27980), -- Tyrande Whisperwind +(20673, 31003, 27980), -- 115498 (Lothrius Mooncaller) +(19554, 28901, 27980), -- 105835 (Lunastre Attendant) +(19506, 28819, 27980), -- 105351 (Masqued Reveler) +(19892, 29562, 27980), -- 109227 (Meliah Grayfeather) +(18755, 27277, 27980), -- 97215 (Beastmaster Pao'lek) +(18977, 27710, 27843), -- 93620 (Cedonu) +(20118, 29907, 27843), -- 110974 (Adept Yad M'Sivart) +(17415, 25870, 27843), -- 93326 (Archmage Khadgar) +(20285, 30323, 27843), -- 103591 (Kor'vas Bloodthorn) +(18207, 26154, 27843), -- 90474 (Demon Hunter) +(18054, 25989, 27843), -- 89362 (Kayn Sunfury) +(18446, 26628, 27843), -- 93337 (Archmage Khadgar) +(20211, 30121, 27980), -- 112133 (Elyssa the Flower) +(20266, 30270, 27980), -- 112620 (Ron Greybeard) +(20267, 30271, 27980), -- 112620 (Ron Greybeard) +(20493, 30679, 27980), -- 110916 (Arcanist Halice) +(20492, 30678, 27980), -- 110916 (Arcanist Halice) +(20092, 29850, 27980), -- 106611 (Vadrak) +(20091, 29845, 27980), -- 106611 (Vadrak) +(19275, 28337, 27980), -- 102843 (Aegira) +(19719, 29247, 27980), -- 107460 (Archmage Landon) +(18391, 26503, 27980), -- Sky Admiral Rogers +(18233, 26196, 27980), -- 90783 (Mishka) +(18391, 26502, 27980), -- Sky Admiral Rogers +(18634, 27062, 27980), -- 95889 (Commander Lorna Crowley) +(18515, 26766, 27980), -- 93960 (Commander Lorna Crowley) +(18513, 26764, 27980), -- Sky Admiral Rogers +(18522, 26778, 27980), -- 92931 (Mishka) +(18514, 26765, 27980), -- 93959 (Genn Greymane) +(19355, 28508, 27980), -- 96644 (Sky Admiral Rogers) +(20077, 29821, 27843), -- 110472 (King Mrgl-Mrgl) +(18238, 26214, 27843), -- 91061 (Cellarman Voodani) +(19919, 25909, 27843), -- 109334 (Okuna Longtusk) +(17439, 25908, 27843), -- 89051 (Okuna Longtusk) +(19512, 25898, 27843), -- 89048 (Sternfathom) +(18182, 26110, 27843), -- 90086 (Ooka Dooker) +(18180, 25179, 27843), -- 90086 (Ooka Dooker) +(18178, 25529, 27843), -- 90086 (Ooka Dooker) +(18177, 25530, 27843), -- 90086 (Ooka Dooker) +(18176, 25531, 27843), -- 90086 (Ooka Dooker) +(18175, 25533, 27843), -- 90086 (Ooka Dooker) +(18174, 25868, 27843), -- 90086 (Ooka Dooker) +(18173, 25869, 27843), -- 90086 (Ooka Dooker) +(18066, 26006, 27843), -- 90086 (Ooka Dooker) +(19040, 27813, 27843), -- 98964 (Celea) +(19607, 29034, 27843), -- 105039 (Examiner Andoren Dawnrise) +(18840, 27443, 27843), -- 97734 (Zaria Shadowheart) +(19648, 29102, 27843), -- 107244 (Tehd Shoemaker) +(19923, 29600, 27843), -- 88097 (Golk the Rumble) +(17377, 25830, 27843), -- 88115 (Prince Farondis) +(18836, 27440, 27843), -- 97736 (Baric Stormrunner) +(20063, 29793, 27980), -- Chief Telemancer Oculeth +(19978, 29641, 27980), -- 251724 +(19945, 29641, 27980), -- 251666 +(19991, 29641, 27980), -- 251743 +(19990, 29641, 27980), -- 251742 +(19944, 29641, 27980), -- 251665 +(21059, 31834, 27980), -- 121589 (Thaumaturge Vashreen) +(21602, 33005, 27980), -- 121589 (Thaumaturge Vashreen) +(21208, 32179, 27980), -- Grand Artificer Romuul +(21380, 32555, 27980), -- 268767 +(21163, 32104, 27980), -- 122950 (Codebreaker Brae) +(21067, 31842, 27980), -- 120898 (Warmage Kath'leen) +(21695, 33057, 27980), -- 120898 (Warmage Kath'leen) +(20745, 31148, 27980), -- Aethas Sunreaver +(20905, 31437, 27980), -- 117331 (Aethas Sunreaver) +(20903, 31435, 27980), -- 117331 (Aethas Sunreaver) +(20902, 31434, 27980), -- 117331 (Aethas Sunreaver) +(20906, 31438, 27980), -- 116321 (Arcanist Ryanna) +(20907, 31439, 27980), -- 121357 (Arcanist Ryanna) +(20900, 31431, 27980), -- 109307 (Ari) +(20563, 30822, 27980), -- 109307 (Ari) +(20886, 31402, 27980), -- 119676 (Lasan Skyhorn) +(20591, 31078, 27980), -- Chief Telemancer Oculeth +(20555, 30811, 27980), -- Arcanist Valtrois +(20696, 31047, 27980), -- 115625 (Vanthir) +(20684, 31026, 27980), -- 116506 (Image of Ly'leth Lunastre) +(20714, 31093, 27980), -- First Arcanist Thalyssra +(20695, 31046, 27980), -- Archmage Khadgar +(20715, 31095, 27980), -- Chief Telemancer Oculeth +(20716, 31094, 27980), -- Arcanist Valtrois +(20695, 31092, 27980), -- Archmage Khadgar +(20689, 31031, 27980), -- 116506 (Image of Ly'leth Lunastre) +(20688, 31030, 27980), -- 116506 (Image of Ly'leth Lunastre) +(20687, 31029, 27980), -- 116506 (Image of Ly'leth Lunastre) +(20686, 31028, 27980), -- 116506 (Image of Ly'leth Lunastre) +(20685, 31027, 27980), -- 116506 (Image of Ly'leth Lunastre) +(20556, 30812, 27980), -- 115382 (Felu'delan) +(20544, 30761, 27980), -- Vereesa Windrunner +(20545, 30764, 27980), -- Lady Liadrin +(20681, 31023, 27980), -- Arluelle +(20601, 30891, 27980), -- Arcanist Valtrois +(20601, 30890, 27980), -- Arcanist Valtrois +(20601, 30883, 27980), -- Arcanist Valtrois +(20601, 30882, 27980), -- Arcanist Valtrois +(20591, 30867, 27980), -- Chief Telemancer Oculeth +(20651, 30966, 27980), -- Arcanist Valtrois +(20637, 30939, 27980), -- Magus Sendath +(20608, 30906, 27980), -- Archmage Khadgar +(22142, 31631, 27980), -- Prophet Velen +(21478, 32721, 27980), -- 121230 (Alleria Windrunner) +(21075, 31923, 27980), -- 121518 (Arkhaan) +(21058, 31832, 27980), -- 121518 (Arkhaan) +(21352, 32453, 27980), -- 125351 (Khaela) +(21730, 32238, 27980), -- High Exarch Turalyon +(21144, 32063, 27980), -- 121230 (Alleria Windrunner) +(21144, 32064, 27980), -- 121230 (Alleria Windrunner) +(21334, 32431, 27980), -- Prophet Velen +(21333, 32430, 27980), -- Prophet Velen +(21333, 32429, 27980), -- Prophet Velen +(21323, 32400, 27980), -- 123671 (Blademaster Telaamon) +(21315, 32383, 27980), -- 123669 (Grand Vindicator Sorvos) +(21312, 32380, 27980), -- 123670 (Baraat the Longshot) +(21238, 32321, 27980), -- 123413 (Archmage Y'mera) +(21253, 32255, 27980), -- 124070 (Vigilant Quoram) +(21291, 32256, 27980), -- 124077 (Gatekeeper's Image) +(21247, 32247, 27980), -- 124077 (Gatekeeper's Image) +(21242, 32235, 27980), -- 123521 (Grand Vizier Jarasum) +(21243, 32236, 27980), -- 123522 (High Wakener Aargon) +(21244, 32237, 27980), -- 123520 (Arc-Consul Velara) +(21748, 33170, 27980), -- 123471 (Augari Novitiate) +(21238, 32231, 27980), -- 123413 (Archmage Y'mera) +(21241, 32234, 27980), -- 123413 (Archmage Y'mera) +(21240, 32233, 27980), -- 123413 (Archmage Y'mera) +(21239, 32232, 27980), -- 123413 (Archmage Y'mera) +(21253, 32313, 27980), -- 124070 (Vigilant Quoram) +(21749, 33171, 27980), -- 123505 (Augari Summoner) +(21737, 33168, 27980), -- 128192 (Forgotten Crystal Tender) +(21709, 31640, 27980), -- Prophet Velen +(20985, 31694, 27980), -- Prophet Velen +(21208, 33055, 27980), -- Grand Artificer Romuul +(21709, 33056, 27980), -- Prophet Velen +(21519, 32798, 27980), -- 127178 (Lightforged Warframe) +(21505, 32772, 27980), -- 127033 (Alleria Windrunner) +(21506, 32773, 27980), -- 127033 (Alleria Windrunner) +(21513, 32787, 27980), -- 127151 (Toraan the Revered) +(21509, 32778, 27980), -- 127120 (Vindicator Jaelaana) +(19911, 29584, 27980), -- Archmage Vargoth +(19896, 29566, 27980), -- Meryl Felstorm +(19867, 29508, 27980), -- 108793 (Human Archmage) +(19864, 29503, 27980), -- 108672 (Archmage Vargoth) +(19860, 29502, 27980), -- 108672 (Archmage Vargoth) +(19859, 29495, 27980), -- 108672 (Archmage Vargoth) +(19769, 29480, 27980), -- 107351 (Archmage Khadgar) +(21580, 32926, 27980), -- 126160 (Lead Rider Jerek) +(21336, 32436, 27980), -- 125247 (Archivist Ionaa) +(21208, 32946, 27980), -- Grand Artificer Romuul +(21697, 33066, 27980), -- High Exarch Turalyon +(21702, 33063, 27980), -- Alleria Windrunner +(21698, 33061, 27980), -- Vereesa Windrunner +(21701, 33062, 27980), -- Arator the Redeemer +(21700, 33064, 27980), -- Grand Artificer Romuul +(21245, 32239, 27980), -- High Exarch Turalyon +(21326, 32748, 27980), -- High Exarch Turalyon +(21199, 32160, 27980), -- 121517 (Baraat the Longshot) +(21198, 32158, 27980), -- 121578 (Archmage Y'mera) +(21197, 32156, 27980), -- 121520 (Grand Lector Enaara) +(21326, 32405, 27980), -- High Exarch Turalyon +(21464, 32692, 27980), -- 126390 (Thelbus Wimblenod) +(21457, 32673, 27980), -- 126390 (Thelbus Wimblenod) +(21456, 32672, 27980), -- 126390 (Thelbus Wimblenod) +(21454, 32670, 27980), -- 126390 (Thelbus Wimblenod) +(21694, 33043, 27980), -- 128243 (Aethas Sunreaver) +(21692, 33045, 27980), -- 128245 (Archmage Khadgar) +(21463, 32691, 27980), -- 123395 (High Priestess Ishanah) +(21462, 9849, 27980), -- 123395 (High Priestess Ishanah) +(21540, 32832, 27980), -- 127518 (Adjutant Vortus) +(21455, 32671, 27980), -- 126389 (Artificer Shela'na) +(21451, 32658, 27980), -- 126389 (Artificer Shela'na) +(21245, 32238, 27980), -- High Exarch Turalyon +(21004, 31695, 27980), -- High Exarch Turalyon +(21049, 31811, 27980), -- High Exarch Turalyon +(21350, 32451, 27980), -- 125346 (Alchemist Funen) +(20978, 31631, 27980), -- Prophet Velen +(21423, 32623, 27980), -- 125525 (Durael) +(21668, 32944, 27980), -- 121589 (Thaumaturge Vashreen) +(21013, 31708, 27980), -- Prophet Velen +(21072, 31906, 27980), -- 121754 (Vereesa Windrunner) +(20895, 31423, 27980), -- Magni Bronzebeard +(20895, 31424, 27980), -- Magni Bronzebeard +(20821, 31261, 27980), -- 118450 (Fhambar) +(20819, 31254, 27980), -- Ritssyn Flamescowl +(20678, 31017, 27980), -- 96806 (Amisi Azuregaze) +(20814, 31243, 27980), -- 97331 (Icks) +(20677, 31015, 27980), -- 92195 (Professor Pallin) +(20746, 31149, 27980), -- 116568 (Sigryn) +(20732, 31122, 27980), -- Priestess Halla +(20989, 31662, 27980), -- 116568 (Sigryn) +(20866, 31359, 27980), -- Yngvild the Watcher +(20867, 31358, 27980), -- Yngvild the Watcher +(20864, 31357, 27980), -- Priestess Bryna +(20865, 31356, 27980), -- Priestess Bryna +(20861, 31354, 27980), -- 119230 (Huntsman Slodi) +(20863, 31353, 27980), -- 119230 (Huntsman Slodi) +(20568, 30827, 27980), -- Archmage Modera +(20825, 31268, 27980), -- Sissix +(20816, 31244, 27980), -- 118265 (Uncrowned Saboteur) +(20730, 31510, 27980), -- 117134 (Tehd Shoemaker) +(20924, 31511, 27980), -- 117135 (Marius Felbane) +(20827, 31270, 27980), -- Nameless Mystic +(20898, 31427, 27980), -- 119886 (Excavator Karla) +(21063, 31838, 27980), -- 115373 (Anketh) +(21064, 31839, 27980), -- 115349 (Amalia Jones) +(21065, 31840, 27980), -- 120316 (Matt DeVine) +(20957, 31568, 27980), -- 120221 (Eliezer Hammerbeard) +(21066, 31841, 27980), -- 120414 (Captain Ruysantos) +(19472, 28753, 27980), -- 105333 (Val'zuun) +(19473, 28754, 27980), -- 105333 (Val'zuun) +(19103, 27939, 27980), -- 100671 (Harold Winston) +(19138, 28006, 27980), -- 101492 (Ms. Xiulan) +(18807, 27368, 27980), -- 97361 (Oxana Demonslay) +(18778, 27321, 27980), -- 97359 (Raethan) +(20498, 30687, 27980), -- 114719 (Trader Caelen) +(20501, 30690, 27980), -- 114719 (Trader Caelen) +(20500, 30689, 27980), -- 114719 (Trader Caelen) +(20499, 30688, 27980), -- 114719 (Trader Caelen) +(19313, 28424, 27980), -- Fargo Flintlocke +(20269, 30275, 27980); -- 98112 (Steward Dayton) + +INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES +(12618, 17749, 27980), -- 97979 (Vethir) +(19883, 29547, 27980), -- 109083 (Houndmaster Payne) +(18656, 27092, 27980), -- 94346 (Ensign Ward) +(20539, 30748, 27980), -- 92539 (Havi) +(18841, 27444, 27980), -- 97748 (Nicholo Swiftfuse) +(19484, 28788, 27980), -- Trapper Jarrun +(19073, 27881, 27843), -- 243227 +(18575, 26917, 27843), -- 94976 (Cassiel Nightthorn) +(18576, 26916, 27843), -- 94975 (Asha Ravensong) +(18574, 26915, 27843), -- 94974 (Sirius Ebonwing) +(18430, 26576, 27843), -- 93029 (Arduen Soulblade) +(19440, 28691, 27843), -- 104824 (Ernest Carlisle) +(19951, 29659, 27843), -- 94594 (Theo the Huntsman) +(19474, 28697, 27843), -- Tyrande Whisperwind +(19405, 28623, 27843), -- Tyrande Whisperwind +(19405, 28616, 27843), -- Tyrande Whisperwind +(19865, 29504, 27843), -- 108304 (Guviena Bladesong) +(19869, 29512, 27843), -- 108642 (Keeper Remulos) +(20273, 11714, 27843), -- 109304 (Khardon Timberdawn) +(18315, 26334, 27843), -- 91389 (Mender Aelar) +(19123, 27989, 27843), -- 100884 (Lasune Starblade) +(18248, 27013, 27843), -- 73426 (Rylissa Bearsong) +(18247, 26233, 27843), -- 73427 (Tenno Thornpaw) +(18248, 26234, 27843), -- 73426 (Rylissa Bearsong) +(18480, 26707, 27843), -- 93890 (Elder Sookh) +(18457, 26706, 27843), -- 93581 (Littlefur) +(18480, 26703, 27843), -- 93890 (Elder Sookh) +(18454, 26654, 27843), -- 93512 (Azalea) +(19166, 28084, 27843), -- 101435 (Nymia Shadesong) +(18507, 26752, 27843), -- 94179 (Aranelle) +(19971, 29696, 27843), -- 109738 (Fleuris Asterleaf) +(20363, 30457, 27843); -- 113394 (Phil Greenoak) + +DELETE FROM `gossip_menu_option_action` WHERE (`MenuId`=20644 AND `OptionIndex`=1) OR (`MenuId`=20620 AND `OptionIndex`=0) OR (`MenuId`=19761 AND `OptionIndex`=0) OR (`MenuId`=19751 AND `OptionIndex`=0) OR (`MenuId`=19741 AND `OptionIndex`=0) OR (`MenuId`=19759 AND `OptionIndex`=0) OR (`MenuId`=20506 AND `OptionIndex`=12) OR (`MenuId`=20086 AND `OptionIndex`=1) OR (`MenuId`=18892 AND `OptionIndex`=0) OR (`MenuId`=19000 AND `OptionIndex`=0) OR (`MenuId`=18997 AND `OptionIndex`=0) OR (`MenuId`=18995 AND `OptionIndex`=0) OR (`MenuId`=20997 AND `OptionIndex`=1) OR (`MenuId`=19295 AND `OptionIndex`=1) OR (`MenuId`=18750 AND `OptionIndex`=0) OR (`MenuId`=20432 AND `OptionIndex`=4) OR (`MenuId`=19603 AND `OptionIndex`=0) OR (`MenuId`=19604 AND `OptionIndex`=0) OR (`MenuId`=19576 AND `OptionIndex`=0) OR (`MenuId`=19796 AND `OptionIndex`=0) OR (`MenuId`=19792 AND `OptionIndex`=0) OR (`MenuId`=20432 AND `OptionIndex`=0) OR (`MenuId`=19321 AND `OptionIndex`=2) OR (`MenuId`=19321 AND `OptionIndex`=1) OR (`MenuId`=18735 AND `OptionIndex`=1) OR (`MenuId`=18380 AND `OptionIndex`=1) OR (`MenuId`=19513 AND `OptionIndex`=0) OR (`MenuId`=20252 AND `OptionIndex`=0) OR (`MenuId`=20251 AND `OptionIndex`=0) OR (`MenuId`=20250 AND `OptionIndex`=0) OR (`MenuId`=18906 AND `OptionIndex`=0) OR (`MenuId`=18905 AND `OptionIndex`=2) OR (`MenuId`=20521 AND `OptionIndex`=14) OR (`MenuId`=20506 AND `OptionIndex`=13) OR (`MenuId`=20521 AND `OptionIndex`=11) OR (`MenuId`=20521 AND `OptionIndex`=10) OR (`MenuId`=20521 AND `OptionIndex`=8) OR (`MenuId`=20521 AND `OptionIndex`=7) OR (`MenuId`=20521 AND `OptionIndex`=5) OR (`MenuId`=20521 AND `OptionIndex`=4) OR (`MenuId`=20521 AND `OptionIndex`=3) OR (`MenuId`=20521 AND `OptionIndex`=2) OR (`MenuId`=20521 AND `OptionIndex`=1) OR (`MenuId`=20522 AND `OptionIndex`=14) OR (`MenuId`=20522 AND `OptionIndex`=13) OR (`MenuId`=20522 AND `OptionIndex`=12) OR (`MenuId`=20522 AND `OptionIndex`=11) OR (`MenuId`=20522 AND `OptionIndex`=10) OR (`MenuId`=20522 AND `OptionIndex`=9) OR (`MenuId`=20522 AND `OptionIndex`=8) OR (`MenuId`=20522 AND `OptionIndex`=7) OR (`MenuId`=20522 AND `OptionIndex`=6) OR (`MenuId`=20522 AND `OptionIndex`=5) OR (`MenuId`=20522 AND `OptionIndex`=4) OR (`MenuId`=20525 AND `OptionIndex`=1) OR (`MenuId`=20522 AND `OptionIndex`=3) OR (`MenuId`=20525 AND `OptionIndex`=0) OR (`MenuId`=20522 AND `OptionIndex`=2) OR (`MenuId`=20522 AND `OptionIndex`=1) OR (`MenuId`=20522 AND `OptionIndex`=0) OR (`MenuId`=20506 AND `OptionIndex`=11) OR (`MenuId`=20515 AND `OptionIndex`=10) OR (`MenuId`=20506 AND `OptionIndex`=10) OR (`MenuId`=20515 AND `OptionIndex`=9) OR (`MenuId`=20515 AND `OptionIndex`=8) OR (`MenuId`=20515 AND `OptionIndex`=7) OR (`MenuId`=20515 AND `OptionIndex`=6) OR (`MenuId`=20515 AND `OptionIndex`=5) OR (`MenuId`=20518 AND `OptionIndex`=2) OR (`MenuId`=20515 AND `OptionIndex`=4) OR (`MenuId`=20518 AND `OptionIndex`=1) OR (`MenuId`=20518 AND `OptionIndex`=0) OR (`MenuId`=20515 AND `OptionIndex`=3) OR (`MenuId`=20515 AND `OptionIndex`=2) OR (`MenuId`=20515 AND `OptionIndex`=1) OR (`MenuId`=20515 AND `OptionIndex`=0) OR (`MenuId`=20513 AND `OptionIndex`=2) OR (`MenuId`=20506 AND `OptionIndex`=9) OR (`MenuId`=20509 AND `OptionIndex`=1) OR (`MenuId`=20513 AND `OptionIndex`=1) OR (`MenuId`=20509 AND `OptionIndex`=0) OR (`MenuId`=20512 AND `OptionIndex`=1) OR (`MenuId`=20513 AND `OptionIndex`=0) OR (`MenuId`=20512 AND `OptionIndex`=0) OR (`MenuId`=20506 AND `OptionIndex`=7) OR (`MenuId`=20506 AND `OptionIndex`=6) OR (`MenuId`=20506 AND `OptionIndex`=5) OR (`MenuId`=20506 AND `OptionIndex`=3) OR (`MenuId`=20506 AND `OptionIndex`=2) OR (`MenuId`=20506 AND `OptionIndex`=1) OR (`MenuId`=20508 AND `OptionIndex`=2) OR (`MenuId`=20506 AND `OptionIndex`=0) OR (`MenuId`=20508 AND `OptionIndex`=1) OR (`MenuId`=20508 AND `OptionIndex`=0) OR (`MenuId`=19068 AND `OptionIndex`=0) OR (`MenuId`=18748 AND `OptionIndex`=3) OR (`MenuId`=19908 AND `OptionIndex`=0) OR (`MenuId`=19906 AND `OptionIndex`=0) OR (`MenuId`=19893 AND `OptionIndex`=0) OR (`MenuId`=19895 AND `OptionIndex`=0) OR (`MenuId`=19524 AND `OptionIndex`=0) OR (`MenuId`=19475 AND `OptionIndex`=0) OR (`MenuId`=19211 AND `OptionIndex`=0) OR (`MenuId`=19042 AND `OptionIndex`=1) OR (`MenuId`=20490 AND `OptionIndex`=0) OR (`MenuId`=18967 AND `OptionIndex`=0) OR (`MenuId`=18958 AND `OptionIndex`=0) OR (`MenuId`=19566 AND `OptionIndex`=0) OR (`MenuId`=19432 AND `OptionIndex`=0) OR (`MenuId`=19808 AND `OptionIndex`=0) OR (`MenuId`=20267 AND `OptionIndex`=0) OR (`MenuId`=20266 AND `OptionIndex`=0) OR (`MenuId`=20492 AND `OptionIndex`=0) OR (`MenuId`=20091 AND `OptionIndex`=0) OR (`MenuId`=18351 AND `OptionIndex`=0) OR (`MenuId`=18352 AND `OptionIndex`=0) OR (`MenuId`=18350 AND `OptionIndex`=0) OR (`MenuId`=18351 AND `OptionIndex`=1) OR (`MenuId`=18349 AND `OptionIndex`=0) OR (`MenuId`=18350 AND `OptionIndex`=1) OR (`MenuId`=18348 AND `OptionIndex`=0) OR (`MenuId`=18180 AND `OptionIndex`=0) OR (`MenuId`=18178 AND `OptionIndex`=0) OR (`MenuId`=18177 AND `OptionIndex`=0) OR (`MenuId`=18176 AND `OptionIndex`=0) OR (`MenuId`=18175 AND `OptionIndex`=0) OR (`MenuId`=18174 AND `OptionIndex`=0) OR (`MenuId`=18173 AND `OptionIndex`=0) OR (`MenuId`=18066 AND `OptionIndex`=0) OR (`MenuId`=17264 AND `OptionIndex`=0) OR (`MenuId`=19916 AND `OptionIndex`=0) OR (`MenuId`=19915 AND `OptionIndex`=0) OR (`MenuId`=19926 AND `OptionIndex`=0) OR (`MenuId`=18255 AND `OptionIndex`=0) OR (`MenuId`=18254 AND `OptionIndex`=0) OR (`MenuId`=17377 AND `OptionIndex`=2) OR (`MenuId`=21067 AND `OptionIndex`=1) OR (`MenuId`=20745 AND `OptionIndex`=2) OR (`MenuId`=20903 AND `OptionIndex`=0) OR (`MenuId`=20902 AND `OptionIndex`=0) OR (`MenuId`=20745 AND `OptionIndex`=1) OR (`MenuId`=20906 AND `OptionIndex`=0) OR (`MenuId`=20563 AND `OptionIndex`=0) OR (`MenuId`=19934 AND `OptionIndex`=0) OR (`MenuId`=20689 AND `OptionIndex`=0) OR (`MenuId`=20684 AND `OptionIndex`=4) OR (`MenuId`=20688 AND `OptionIndex`=0) OR (`MenuId`=20684 AND `OptionIndex`=3) OR (`MenuId`=20687 AND `OptionIndex`=0) OR (`MenuId`=20684 AND `OptionIndex`=2) OR (`MenuId`=20686 AND `OptionIndex`=0) OR (`MenuId`=20684 AND `OptionIndex`=1) OR (`MenuId`=20685 AND `OptionIndex`=0) OR (`MenuId`=20684 AND `OptionIndex`=0) OR (`MenuId`=21058 AND `OptionIndex`=0) OR (`MenuId`=21241 AND `OptionIndex`=0) OR (`MenuId`=21238 AND `OptionIndex`=2) OR (`MenuId`=21240 AND `OptionIndex`=0) OR (`MenuId`=21238 AND `OptionIndex`=1) OR (`MenuId`=21239 AND `OptionIndex`=0) OR (`MenuId`=21238 AND `OptionIndex`=0) OR (`MenuId`=21505 AND `OptionIndex`=0) OR (`MenuId`=19860 AND `OptionIndex`=0) OR (`MenuId`=19859 AND `OptionIndex`=0) OR (`MenuId`=21457 AND `OptionIndex`=0) OR (`MenuId`=21456 AND `OptionIndex`=0) OR (`MenuId`=21454 AND `OptionIndex`=0) OR (`MenuId`=21462 AND `OptionIndex`=1) OR (`MenuId`=21451 AND `OptionIndex`=0) OR (`MenuId`=20679 AND `OptionIndex`=3) OR (`MenuId`=20815 AND `OptionIndex`=2) OR (`MenuId`=18598 AND `OptionIndex`=4) OR (`MenuId`=20867 AND `OptionIndex`=0) OR (`MenuId`=20865 AND `OptionIndex`=0) OR (`MenuId`=20863 AND `OptionIndex`=0) OR (`MenuId`=19473 AND `OptionIndex`=0) OR (`MenuId`=19472 AND `OptionIndex`=2) OR (`MenuId`=20500 AND `OptionIndex`=0) OR (`MenuId`=20499 AND `OptionIndex`=0) OR (`MenuId`=20498 AND `OptionIndex`=0) OR (`MenuId`=20117 AND `OptionIndex`=0) OR (`MenuId`=10181 AND `OptionIndex`=0) OR (`MenuId`=18571 AND `OptionIndex`=0) OR (`MenuId`=18570 AND `OptionIndex`=0) OR (`MenuId`=18569 AND `OptionIndex`=0) OR (`MenuId`=18414 AND `OptionIndex`=0) OR (`MenuId`=18407 AND `OptionIndex`=0) OR (`MenuId`=18680 AND `OptionIndex`=0) OR (`MenuId`=18679 AND `OptionIndex`=0) OR (`MenuId`=18555 AND `OptionIndex`=0) OR (`MenuId`=19434 AND `OptionIndex`=0) OR (`MenuId`=19340 AND `OptionIndex`=1); +INSERT INTO `gossip_menu_option_action` (`MenuId`, `OptionIndex`, `ActionMenuId`, `ActionPoiId`) VALUES +(20644, 1, 20187, 0), +(20620, 0, 20619, 0), +(19761, 0, 19760, 0), +(19751, 0, 19750, 0), +(19741, 0, 19740, 0), +(19759, 0, 19758, 0), +(20506, 12, 20522, 0), +(20086, 1, 21664, 0), +(18892, 0, 18893, 0), +(19000, 0, 19107, 0), +(18997, 0, 19104, 0), +(18995, 0, 19106, 0), +(20997, 1, 21415, 0), +(19295, 1, 19297, 0), +(18750, 0, 18768, 0), +(20432, 4, 19776, 0), +(19603, 0, 19605, 0), +(19604, 0, 19603, 0), +(19576, 0, 19587, 0), +(19796, 0, 19797, 0), +(19792, 0, 19796, 0), +(20432, 0, 20431, 0), +(19321, 2, 19323, 0), +(19321, 1, 19322, 0), +(18735, 1, 18736, 0), +(18380, 1, 18735, 0), +(19513, 0, 19514, 0), +(20252, 0, 20253, 0), +(20251, 0, 20252, 0), +(20250, 0, 20251, 0), +(18906, 0, 18905, 0), +(18905, 2, 18906, 0), +(20521, 14, 10148, 5158), +(20506, 13, 20521, 0), +(20521, 11, 10153, 5159), +(20521, 10, 10152, 5161), +(20521, 8, 10154, 5157), +(20521, 7, 10155, 5160), +(20521, 5, 10169, 5148), +(20521, 4, 10157, 5159), +(20521, 3, 20527, 5156), +(20521, 2, 10159, 5155), +(20521, 1, 10167, 5154), +(20522, 14, 10063, 5145), +(20522, 13, 10064, 5149), +(20522, 12, 20526, 5152), +(20522, 11, 10064, 5146), +(20522, 10, 10066, 5148), +(20522, 9, 10067, 5151), +(20522, 8, 10068, 5150), +(20522, 7, 10069, 5153), +(20522, 6, 10070, 5144), +(20522, 5, 10071, 5147), +(20522, 4, 10072, 5143), +(20525, 1, 20511, 5127), +(20522, 3, 20525, 0), +(20525, 0, 20510, 5126), +(20522, 2, 10076, 5142), +(20522, 1, 20523, 5141), +(20522, 0, 10077, 5140), +(20506, 11, 10083, 5134), +(20515, 10, 10046, 5135), +(20506, 10, 20515, 0), +(20515, 9, 10047, 5136), +(20515, 8, 20519, 5137), +(20515, 7, 10049, 5138), +(20515, 6, 20514, 5129), +(20515, 5, 10062, 5139), +(20518, 2, 10050, 5120), +(20515, 4, 20518, 0), +(20518, 1, 10044, 5119), +(20518, 0, 10045, 5118), +(20515, 3, 10051, 5133), +(20515, 2, 10052, 5132), +(20515, 1, 20517, 5131), +(20515, 0, 20516, 5130), +(20513, 2, 20514, 5129), +(20506, 9, 20513, 0), +(20509, 1, 10088, 5121), +(20513, 1, 20509, 0), +(20509, 0, 10087, 5122), +(20512, 1, 20511, 5127), +(20513, 0, 20512, 5128), +(20512, 0, 20510, 5126), +(20506, 7, 20512, 5128), +(20506, 6, 10095, 5125), +(20506, 5, 10086, 5124), +(20506, 3, 10085, 5123), +(20506, 2, 20509, 0), +(20506, 1, 20709, 5163), +(20508, 2, 10050, 5120), +(20506, 0, 20508, 0), +(20508, 1, 10044, 5119), +(20508, 0, 10045, 5118), +(19068, 0, 19194, 0), +(18748, 3, 20187, 0), +(19908, 0, 19907, 0), +(19906, 0, 19905, 0), +(19893, 0, 19902, 0), +(19895, 0, 20268, 0), +(19524, 0, 19571, 0), +(19475, 0, 19573, 0), +(19211, 0, 19042, 0), +(19042, 1, 19211, 0), +(20490, 0, 20491, 0), +(18967, 0, 18966, 0), +(18958, 0, 18959, 0), +(19566, 0, 19567, 0), +(19432, 0, 19431, 0), +(19808, 0, 19809, 0), +(20267, 0, 20266, 0), +(20266, 0, 20267, 0), +(20492, 0, 20493, 0), +(20091, 0, 20092, 0), +(18351, 0, 18352, 0), +(18352, 0, 18351, 0), +(18350, 0, 18351, 0), +(18351, 1, 18350, 0), +(18349, 0, 18350, 0), +(18350, 1, 18349, 0), +(18348, 0, 18349, 0), +(18180, 0, 18182, 0), +(18178, 0, 18180, 0), +(18177, 0, 18178, 0), +(18176, 0, 18177, 0), +(18175, 0, 18176, 0), +(18174, 0, 18175, 0), +(18173, 0, 18174, 0), +(18066, 0, 18173, 0), +(17264, 0, 18066, 0), +(19916, 0, 19917, 0), +(19915, 0, 19916, 0), +(19926, 0, 19927, 0), +(18255, 0, 17377, 0), +(18254, 0, 18255, 0), +(17377, 2, 18254, 0), +(21067, 1, 21695, 0), +(20745, 2, 20905, 0), +(20903, 0, 20745, 0), +(20902, 0, 20903, 0), +(20745, 1, 20902, 0), +(20906, 0, 20907, 0), +(20563, 0, 20900, 0), +(19934, 0, 20563, 0), +(20689, 0, 20684, 0), +(20684, 4, 20689, 0), +(20688, 0, 20684, 0), +(20684, 3, 20688, 0), +(20687, 0, 20684, 0), +(20684, 2, 20687, 0), +(20686, 0, 20684, 0), +(20684, 1, 20686, 0), +(20685, 0, 20684, 0), +(20684, 0, 20685, 0), +(21058, 0, 21075, 0), +(21241, 0, 21238, 0), +(21238, 2, 21241, 0), +(21240, 0, 21238, 0), +(21238, 1, 21240, 0), +(21239, 0, 21238, 0), +(21238, 0, 21239, 0), +(21505, 0, 21506, 0), +(19860, 0, 19864, 0), +(19859, 0, 19860, 0), +(21457, 0, 21464, 0), +(21456, 0, 21457, 0), +(21454, 0, 21456, 0), +(21462, 1, 21463, 0), +(21451, 0, 21455, 0), +(20679, 3, 20678, 0), +(20815, 2, 20814, 0), +(18598, 4, 20677, 0), +(20867, 0, 20866, 0), +(20865, 0, 20864, 0), +(20863, 0, 20861, 0), +(19473, 0, 19472, 0), +(19472, 2, 19473, 0), +(20500, 0, 20501, 0), +(20499, 0, 20500, 0), +(20498, 0, 20499, 0), +(20117, 0, 20116, 0), +(10181, 0, 18827, 0), +(18571, 0, 18414, 0), +(18570, 0, 18571, 0), +(18569, 0, 18570, 0), +(18414, 0, 18569, 0), +(18407, 0, 18636, 0), +(18680, 0, 18679, 0), +(18679, 0, 18680, 0), +(18555, 0, 18633, 0), +(19434, 0, 19340, 0), +(19340, 1, 19434, 0); + +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=2422 WHERE (`MenuId`=11848 AND `OptionIndex`=4); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=2427 WHERE (`MenuId`=11848 AND `OptionIndex`=3); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=2426 WHERE (`MenuId`=11848 AND `OptionIndex`=2); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=2423 WHERE (`MenuId`=11848 AND `OptionIndex`=1); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=870 WHERE (`MenuId`=11846 AND `OptionIndex`=1); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=2418 WHERE (`MenuId`=11846 AND `OptionIndex`=0); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=92 WHERE (`MenuId`=421 AND `OptionIndex`=16); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=90 WHERE (`MenuId`=421 AND `OptionIndex`=15); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=2422 WHERE (`MenuId`=421 AND `OptionIndex`=14); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=95 WHERE (`MenuId`=421 AND `OptionIndex`=13); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=90 WHERE (`MenuId`=421 AND `OptionIndex`=12); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=2425 WHERE (`MenuId`=421 AND `OptionIndex`=11); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=2272 WHERE (`MenuId`=421 AND `OptionIndex`=10); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=2272 WHERE (`MenuId`=421 AND `OptionIndex`=10); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=2423 WHERE (`MenuId`=421 AND `OptionIndex`=8); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=107 WHERE (`MenuId`=421 AND `OptionIndex`=7); +UPDATE `gossip_menu_option_action` SET `ActionPoiId`=1427 WHERE (`MenuId`=421 AND `OptionIndex`=6); +UPDATE `gossip_menu_option_action` SET `ActionMenuId`=21602 WHERE (`MenuId`=21059 AND `OptionIndex`=2); +UPDATE `gossip_menu_option_action` SET `ActionMenuId`=21602 WHERE (`MenuId`=21059 AND `OptionIndex`=2); +UPDATE `gossip_menu_option_action` SET `ActionMenuId`=21668 WHERE (`MenuId`=21059 AND `OptionIndex`=1); + +DELETE FROM `gossip_menu_option` WHERE (`MenuId`=20403 AND `OptionIndex`=0) OR (`MenuId`=20001 AND `OptionIndex`=1) OR (`MenuId`=20000 AND `OptionIndex`=0) OR (`MenuId`=19263 AND `OptionIndex`=0) OR (`MenuId`=19237 AND `OptionIndex`=0) OR (`MenuId`=20524 AND `OptionIndex`=0) OR (`MenuId`=20328 AND `OptionIndex`=0) OR (`MenuId`=19979 AND `OptionIndex`=0) OR (`MenuId`=19982 AND `OptionIndex`=0) OR (`MenuId`=20187 AND `OptionIndex`=9) OR (`MenuId`=20187 AND `OptionIndex`=6) OR (`MenuId`=20187 AND `OptionIndex`=4) OR (`MenuId`=20187 AND `OptionIndex`=2) OR (`MenuId`=20187 AND `OptionIndex`=0) OR (`MenuId`=20644 AND `OptionIndex`=4) OR (`MenuId`=20644 AND `OptionIndex`=3) OR (`MenuId`=20644 AND `OptionIndex`=2) OR (`MenuId`=20644 AND `OptionIndex`=1) OR (`MenuId`=20576 AND `OptionIndex`=0) OR (`MenuId`=20643 AND `OptionIndex`=0) OR (`MenuId`=20620 AND `OptionIndex`=1) OR (`MenuId`=20618 AND `OptionIndex`=0) OR (`MenuId`=20617 AND `OptionIndex`=0) OR (`MenuId`=20638 AND `OptionIndex`=0) OR (`MenuId`=20635 AND `OptionIndex`=0) OR (`MenuId`=20620 AND `OptionIndex`=0) OR (`MenuId`=20591 AND `OptionIndex`=3) OR (`MenuId`=20591 AND `OptionIndex`=2) OR (`MenuId`=20378 AND `OptionIndex`=0) OR (`MenuId`=20738 AND `OptionIndex`=0) OR (`MenuId`=19764 AND `OptionIndex`=0) OR (`MenuId`=19761 AND `OptionIndex`=0) OR (`MenuId`=19751 AND `OptionIndex`=0) OR (`MenuId`=19741 AND `OptionIndex`=0) OR (`MenuId`=19759 AND `OptionIndex`=0) OR (`MenuId`=19722 AND `OptionIndex`=0) OR (`MenuId`=19579 AND `OptionIndex`=1) OR (`MenuId`=19515 AND `OptionIndex`=0) OR (`MenuId`=20166 AND `OptionIndex`=1) OR (`MenuId`=19198 AND `OptionIndex`=0) OR (`MenuId`=18851 AND `OptionIndex`=0) OR (`MenuId`=18849 AND `OptionIndex`=0) OR (`MenuId`=18848 AND `OptionIndex`=0) OR (`MenuId`=19341 AND `OptionIndex`=0) OR (`MenuId`=20496 AND `OptionIndex`=0) OR (`MenuId`=20506 AND `OptionIndex`=1) OR (`MenuId`=20086 AND `OptionIndex`=1) OR (`MenuId`=18705 AND `OptionIndex`=0) OR (`MenuId`=19241 AND `OptionIndex`=14) OR (`MenuId`=19241 AND `OptionIndex`=3) OR (`MenuId`=19241 AND `OptionIndex`=1) OR (`MenuId`=19241 AND `OptionIndex`=0) OR (`MenuId`=19241 AND `OptionIndex`=12) OR (`MenuId`=20001 AND `OptionIndex`=0) OR (`MenuId`=20314 AND `OptionIndex`=1) OR (`MenuId`=20314 AND `OptionIndex`=0) OR (`MenuId`=18893 AND `OptionIndex`=0) OR (`MenuId`=18892 AND `OptionIndex`=0) OR (`MenuId`=18811 AND `OptionIndex`=1) OR (`MenuId`=18811 AND `OptionIndex`=0) OR (`MenuId`=20320 AND `OptionIndex`=1) OR (`MenuId`=20320 AND `OptionIndex`=0) OR (`MenuId`=18463 AND `OptionIndex`=1) OR (`MenuId`=10184 AND `OptionIndex`=0) OR (`MenuId`=18933 AND `OptionIndex`=0) OR (`MenuId`=20997 AND `OptionIndex`=2) OR (`MenuId`=20997 AND `OptionIndex`=1) OR (`MenuId`=19295 AND `OptionIndex`=1) OR (`MenuId`=19295 AND `OptionIndex`=0) OR (`MenuId`=20307 AND `OptionIndex`=1) OR (`MenuId`=20307 AND `OptionIndex`=0) OR (`MenuId`=18985 AND `OptionIndex`=0) OR (`MenuId`=18750 AND `OptionIndex`=0) OR (`MenuId`=19601 AND `OptionIndex`=2) OR (`MenuId`=20432 AND `OptionIndex`=4) OR (`MenuId`=19604 AND `OptionIndex`=0) OR (`MenuId`=19603 AND `OptionIndex`=0) OR (`MenuId`=19576 AND `OptionIndex`=0) OR (`MenuId`=19709 AND `OptionIndex`=0) OR (`MenuId`=18723 AND `OptionIndex`=3) OR (`MenuId`=19797 AND `OptionIndex`=0) OR (`MenuId`=19796 AND `OptionIndex`=0) OR (`MenuId`=19792 AND `OptionIndex`=0) OR (`MenuId`=19850 AND `OptionIndex`=0) OR (`MenuId`=19778 AND `OptionIndex`=0) OR (`MenuId`=20431 AND `OptionIndex`=0) OR (`MenuId`=20432 AND `OptionIndex`=0) OR (`MenuId`=20432 AND `OptionIndex`=6) OR (`MenuId`=20362 AND `OptionIndex`=0) OR (`MenuId`=20000 AND `OptionIndex`=2) OR (`MenuId`=20432 AND `OptionIndex`=5) OR (`MenuId`=19321 AND `OptionIndex`=2) OR (`MenuId`=19321 AND `OptionIndex`=1) OR (`MenuId`=19476 AND `OptionIndex`=2) OR (`MenuId`=20679 AND `OptionIndex`=1) OR (`MenuId`=20679 AND `OptionIndex`=0) OR (`MenuId`=18380 AND `OptionIndex`=1) OR (`MenuId`=18380 AND `OptionIndex`=0) OR (`MenuId`=18735 AND `OptionIndex`=1) OR (`MenuId`=18735 AND `OptionIndex`=0) OR (`MenuId`=18728 AND `OptionIndex`=1) OR (`MenuId`=18728 AND `OptionIndex`=0) OR (`MenuId`=18918 AND `OptionIndex`=0) OR (`MenuId`=18917 AND `OptionIndex`=0) OR (`MenuId`=20157 AND `OptionIndex`=0) OR (`MenuId`=20489 AND `OptionIndex`=1) OR (`MenuId`=21018 AND `OptionIndex`=0) OR (`MenuId`=19094 AND `OptionIndex`=1) OR (`MenuId`=20252 AND `OptionIndex`=0) OR (`MenuId`=20251 AND `OptionIndex`=0) OR (`MenuId`=20250 AND `OptionIndex`=0) OR (`MenuId`=21017 AND `OptionIndex`=0) OR (`MenuId`=11383 AND `OptionIndex`=0) OR (`MenuId`=20815 AND `OptionIndex`=0) OR (`MenuId`=18961 AND `OptionIndex`=0) OR (`MenuId`=19540 AND `OptionIndex`=2) OR (`MenuId`=18905 AND `OptionIndex`=3) OR (`MenuId`=18905 AND `OptionIndex`=2) OR (`MenuId`=18905 AND `OptionIndex`=0) OR (`MenuId`=18906 AND `OptionIndex`=0) OR (`MenuId`=20367 AND `OptionIndex`=0) OR (`MenuId`=19134 AND `OptionIndex`=0) OR (`MenuId`=19075 AND `OptionIndex`=0) OR (`MenuId`=19068 AND `OptionIndex`=0) OR (`MenuId`=19870 AND `OptionIndex`=0) OR (`MenuId`=20974 AND `OptionIndex`=1) OR (`MenuId`=20974 AND `OptionIndex`=0) OR (`MenuId`=18500 AND `OptionIndex`=1) OR (`MenuId`=19238 AND `OptionIndex`=0) OR (`MenuId`=20417 AND `OptionIndex`=0) OR (`MenuId`=18973 AND `OptionIndex`=0) OR (`MenuId`=18987 AND `OptionIndex`=0) OR (`MenuId`=20212 AND `OptionIndex`=0) OR (`MenuId`=19301 AND `OptionIndex`=8) OR (`MenuId`=20196 AND `OptionIndex`=0) OR (`MenuId`=20197 AND `OptionIndex`=0) OR (`MenuId`=20198 AND `OptionIndex`=0) OR (`MenuId`=18748 AND `OptionIndex`=4) OR (`MenuId`=18748 AND `OptionIndex`=3) OR (`MenuId`=19960 AND `OptionIndex`=1) OR (`MenuId`=19929 AND `OptionIndex`=0) OR (`MenuId`=19933 AND `OptionIndex`=0) OR (`MenuId`=20327 AND `OptionIndex`=0) OR (`MenuId`=20324 AND `OptionIndex`=0) OR (`MenuId`=20372 AND `OptionIndex`=0) OR (`MenuId`=19301 AND `OptionIndex`=0) OR (`MenuId`=19301 AND `OptionIndex`=6) OR (`MenuId`=20376 AND `OptionIndex`=0) OR (`MenuId`=20187 AND `OptionIndex`=7) OR (`MenuId`=20187 AND `OptionIndex`=5) OR (`MenuId`=20119 AND `OptionIndex`=0) OR (`MenuId`=20391 AND `OptionIndex`=0) OR (`MenuId`=20111 AND `OptionIndex`=0) OR (`MenuId`=20110 AND `OptionIndex`=0) OR (`MenuId`=20112 AND `OptionIndex`=0) OR (`MenuId`=19696 AND `OptionIndex`=4) OR (`MenuId`=19696 AND `OptionIndex`=3) OR (`MenuId`=20390 AND `OptionIndex`=0) OR (`MenuId`=19706 AND `OptionIndex`=0) OR (`MenuId`=19704 AND `OptionIndex`=0) OR (`MenuId`=19705 AND `OptionIndex`=0) OR (`MenuId`=18531 AND `OptionIndex`=0) OR (`MenuId`=19696 AND `OptionIndex`=2) OR (`MenuId`=19696 AND `OptionIndex`=1) OR (`MenuId`=19696 AND `OptionIndex`=0) OR (`MenuId`=20193 AND `OptionIndex`=0) OR (`MenuId`=19907 AND `OptionIndex`=0) OR (`MenuId`=19908 AND `OptionIndex`=0) OR (`MenuId`=19905 AND `OptionIndex`=0) OR (`MenuId`=19906 AND `OptionIndex`=0) OR (`MenuId`=19902 AND `OptionIndex`=0) OR (`MenuId`=19893 AND `OptionIndex`=0) OR (`MenuId`=19895 AND `OptionIndex`=0) OR (`MenuId`=19885 AND `OptionIndex`=0) OR (`MenuId`=19519 AND `OptionIndex`=0) OR (`MenuId`=19524 AND `OptionIndex`=0) OR (`MenuId`=19573 AND `OptionIndex`=0) OR (`MenuId`=19475 AND `OptionIndex`=0) OR (`MenuId`=19718 AND `OptionIndex`=0) OR (`MenuId`=19152 AND `OptionIndex`=1) OR (`MenuId`=19152 AND `OptionIndex`=0) OR (`MenuId`=19041 AND `OptionIndex`=0) OR (`MenuId`=19392 AND `OptionIndex`=0) OR (`MenuId`=19042 AND `OptionIndex`=1) OR (`MenuId`=19211 AND `OptionIndex`=0) OR (`MenuId`=19042 AND `OptionIndex`=0) OR (`MenuId`=19301 AND `OptionIndex`=5) OR (`MenuId`=19301 AND `OptionIndex`=4) OR (`MenuId`=20318 AND `OptionIndex`=0) OR (`MenuId`=18748 AND `OptionIndex`=1) OR (`MenuId`=19692 AND `OptionIndex`=0) OR (`MenuId`=19692 AND `OptionIndex`=1) OR (`MenuId`=19832 AND `OptionIndex`=0) OR (`MenuId`=19831 AND `OptionIndex`=0) OR (`MenuId`=19830 AND `OptionIndex`=0) OR (`MenuId`=19829 AND `OptionIndex`=0) OR (`MenuId`=19783 AND `OptionIndex`=0) OR (`MenuId`=19360 AND `OptionIndex`=0) OR (`MenuId`=19980 AND `OptionIndex`=0) OR (`MenuId`=20491 AND `OptionIndex`=0) OR (`MenuId`=20490 AND `OptionIndex`=0) OR (`MenuId`=20728 AND `OptionIndex`=0) OR (`MenuId`=20603 AND `OptionIndex`=0) OR (`MenuId`=18966 AND `OptionIndex`=0) OR (`MenuId`=18967 AND `OptionIndex`=0) OR (`MenuId`=18959 AND `OptionIndex`=0) OR (`MenuId`=18958 AND `OptionIndex`=0) OR (`MenuId`=20399 AND `OptionIndex`=0) OR (`MenuId`=20406 AND `OptionIndex`=0) OR (`MenuId`=19506 AND `OptionIndex`=0) OR (`MenuId`=19554 AND `OptionIndex`=0) OR (`MenuId`=18755 AND `OptionIndex`=0) OR (`MenuId`=20118 AND `OptionIndex`=0) OR (`MenuId`=17085 AND `OptionIndex`=0) OR (`MenuId`=20211 AND `OptionIndex`=1) OR (`MenuId`=20211 AND `OptionIndex`=0) OR (`MenuId`=20266 AND `OptionIndex`=1) OR (`MenuId`=20266 AND `OptionIndex`=0) OR (`MenuId`=20267 AND `OptionIndex`=0) OR (`MenuId`=20493 AND `OptionIndex`=0) OR (`MenuId`=20492 AND `OptionIndex`=0) OR (`MenuId`=20091 AND `OptionIndex`=0) OR (`MenuId`=18634 AND `OptionIndex`=0) OR (`MenuId`=20077 AND `OptionIndex`=0) OR (`MenuId`=18182 AND `OptionIndex`=2) OR (`MenuId`=18182 AND `OptionIndex`=0) OR (`MenuId`=18180 AND `OptionIndex`=2) OR (`MenuId`=18180 AND `OptionIndex`=0) OR (`MenuId`=18178 AND `OptionIndex`=2) OR (`MenuId`=18178 AND `OptionIndex`=0) OR (`MenuId`=18177 AND `OptionIndex`=2) OR (`MenuId`=18177 AND `OptionIndex`=0) OR (`MenuId`=18176 AND `OptionIndex`=2) OR (`MenuId`=18176 AND `OptionIndex`=0) OR (`MenuId`=18175 AND `OptionIndex`=2) OR (`MenuId`=18175 AND `OptionIndex`=0) OR (`MenuId`=18174 AND `OptionIndex`=2) OR (`MenuId`=18174 AND `OptionIndex`=0) OR (`MenuId`=18173 AND `OptionIndex`=2) OR (`MenuId`=18173 AND `OptionIndex`=0) OR (`MenuId`=18066 AND `OptionIndex`=2) OR (`MenuId`=18066 AND `OptionIndex`=0) OR (`MenuId`=19040 AND `OptionIndex`=0) OR (`MenuId`=8434 AND `OptionIndex`=0) OR (`MenuId`=19682 AND `OptionIndex`=0) OR (`MenuId`=20063 AND `OptionIndex`=0) OR (`MenuId`=19978 AND `OptionIndex`=0) OR (`MenuId`=19945 AND `OptionIndex`=0) OR (`MenuId`=19991 AND `OptionIndex`=0) OR (`MenuId`=19990 AND `OptionIndex`=0) OR (`MenuId`=19944 AND `OptionIndex`=0) OR (`MenuId`=21059 AND `OptionIndex`=0) OR (`MenuId`=21208 AND `OptionIndex`=0) OR (`MenuId`=21380 AND `OptionIndex`=4) OR (`MenuId`=21380 AND `OptionIndex`=3) OR (`MenuId`=21380 AND `OptionIndex`=2) OR (`MenuId`=21208 AND `OptionIndex`=1) OR (`MenuId`=21163 AND `OptionIndex`=0) OR (`MenuId`=21067 AND `OptionIndex`=1) OR (`MenuId`=21067 AND `OptionIndex`=0) OR (`MenuId`=20745 AND `OptionIndex`=2) OR (`MenuId`=20745 AND `OptionIndex`=1) OR (`MenuId`=20745 AND `OptionIndex`=0) OR (`MenuId`=20903 AND `OptionIndex`=0) OR (`MenuId`=20902 AND `OptionIndex`=0) OR (`MenuId`=20906 AND `OptionIndex`=0) OR (`MenuId`=20563 AND `OptionIndex`=0) OR (`MenuId`=19934 AND `OptionIndex`=0) OR (`MenuId`=20886 AND `OptionIndex`=0) OR (`MenuId`=20591 AND `OptionIndex`=0) OR (`MenuId`=20376 AND `OptionIndex`=1) OR (`MenuId`=20684 AND `OptionIndex`=4) OR (`MenuId`=20684 AND `OptionIndex`=3) OR (`MenuId`=20684 AND `OptionIndex`=2) OR (`MenuId`=20684 AND `OptionIndex`=1) OR (`MenuId`=20684 AND `OptionIndex`=0) OR (`MenuId`=20695 AND `OptionIndex`=3) OR (`MenuId`=20695 AND `OptionIndex`=0) OR (`MenuId`=20689 AND `OptionIndex`=0) OR (`MenuId`=20688 AND `OptionIndex`=0) OR (`MenuId`=20687 AND `OptionIndex`=0) OR (`MenuId`=20686 AND `OptionIndex`=0) OR (`MenuId`=20685 AND `OptionIndex`=0) OR (`MenuId`=20556 AND `OptionIndex`=1) OR (`MenuId`=20556 AND `OptionIndex`=0) OR (`MenuId`=20544 AND `OptionIndex`=0) OR (`MenuId`=20543 AND `OptionIndex`=0) OR (`MenuId`=20545 AND `OptionIndex`=0) OR (`MenuId`=20601 AND `OptionIndex`=2) OR (`MenuId`=20601 AND `OptionIndex`=1) OR (`MenuId`=20601 AND `OptionIndex`=0) OR (`MenuId`=20591 AND `OptionIndex`=1) OR (`MenuId`=20651 AND `OptionIndex`=8) OR (`MenuId`=21380 AND `OptionIndex`=1) OR (`MenuId`=21075 AND `OptionIndex`=0) OR (`MenuId`=21058 AND `OptionIndex`=0) OR (`MenuId`=21144 AND `OptionIndex`=0) OR (`MenuId`=21291 AND `OptionIndex`=0) OR (`MenuId`=21247 AND `OptionIndex`=0) OR (`MenuId`=21242 AND `OptionIndex`=0) OR (`MenuId`=21244 AND `OptionIndex`=0) OR (`MenuId`=21243 AND `OptionIndex`=0) OR (`MenuId`=21238 AND `OptionIndex`=2) OR (`MenuId`=21238 AND `OptionIndex`=1) OR (`MenuId`=21238 AND `OptionIndex`=0) OR (`MenuId`=21241 AND `OptionIndex`=0) OR (`MenuId`=21240 AND `OptionIndex`=0) OR (`MenuId`=21239 AND `OptionIndex`=0) OR (`MenuId`=20985 AND `OptionIndex`=0) OR (`MenuId`=21208 AND `OptionIndex`=3) OR (`MenuId`=21709 AND `OptionIndex`=0) OR (`MenuId`=21380 AND `OptionIndex`=0) OR (`MenuId`=21519 AND `OptionIndex`=0) OR (`MenuId`=21505 AND `OptionIndex`=0) OR (`MenuId`=21513 AND `OptionIndex`=0) OR (`MenuId`=21509 AND `OptionIndex`=0) OR (`MenuId`=19896 AND `OptionIndex`=1) OR (`MenuId`=19867 AND `OptionIndex`=0) OR (`MenuId`=19864 AND `OptionIndex`=0) OR (`MenuId`=19860 AND `OptionIndex`=0) OR (`MenuId`=19859 AND `OptionIndex`=0) OR (`MenuId`=19769 AND `OptionIndex`=0) OR (`MenuId`=21580 AND `OptionIndex`=2) OR (`MenuId`=21580 AND `OptionIndex`=1) OR (`MenuId`=21336 AND `OptionIndex`=0) OR (`MenuId`=21208 AND `OptionIndex`=2) OR (`MenuId`=21245 AND `OptionIndex`=0) OR (`MenuId`=21326 AND `OptionIndex`=1) OR (`MenuId`=21457 AND `OptionIndex`=0) OR (`MenuId`=21456 AND `OptionIndex`=0) OR (`MenuId`=21454 AND `OptionIndex`=0) OR (`MenuId`=21462 AND `OptionIndex`=2) OR (`MenuId`=21462 AND `OptionIndex`=1) OR (`MenuId`=21462 AND `OptionIndex`=0) OR (`MenuId`=21451 AND `OptionIndex`=0) OR (`MenuId`=21004 AND `OptionIndex`=0) OR (`MenuId`=21049 AND `OptionIndex`=0) OR (`MenuId`=21423 AND `OptionIndex`=0) OR (`MenuId`=21013 AND `OptionIndex`=0) OR (`MenuId`=21072 AND `OptionIndex`=0) OR (`MenuId`=20895 AND `OptionIndex`=0) OR (`MenuId`=20821 AND `OptionIndex`=0) OR (`MenuId`=20819 AND `OptionIndex`=0) OR (`MenuId`=20679 AND `OptionIndex`=3) OR (`MenuId`=20815 AND `OptionIndex`=2) OR (`MenuId`=18598 AND `OptionIndex`=4) OR (`MenuId`=20746 AND `OptionIndex`=0) OR (`MenuId`=20732 AND `OptionIndex`=0) OR (`MenuId`=20989 AND `OptionIndex`=0) OR (`MenuId`=20867 AND `OptionIndex`=0) OR (`MenuId`=20865 AND `OptionIndex`=0) OR (`MenuId`=20863 AND `OptionIndex`=0) OR (`MenuId`=21063 AND `OptionIndex`=0) OR (`MenuId`=21064 AND `OptionIndex`=1) OR (`MenuId`=21064 AND `OptionIndex`=0) OR (`MenuId`=21065 AND `OptionIndex`=0) OR (`MenuId`=19472 AND `OptionIndex`=2) OR (`MenuId`=19473 AND `OptionIndex`=0) OR (`MenuId`=18807 AND `OptionIndex`=0) OR (`MenuId`=18778 AND `OptionIndex`=5) OR (`MenuId`=18778 AND `OptionIndex`=4) OR (`MenuId`=18778 AND `OptionIndex`=0) OR (`MenuId`=19241 AND `OptionIndex`=2) OR (`MenuId`=20498 AND `OptionIndex`=0) OR (`MenuId`=20500 AND `OptionIndex`=0) OR (`MenuId`=20499 AND `OptionIndex`=0) OR (`MenuId`=20269 AND `OptionIndex`=1) OR (`MenuId`=20269 AND `OptionIndex`=0) OR (`MenuId`=18656 AND `OptionIndex`=0) OR (`MenuId`=20539 AND `OptionIndex`=1) OR (`MenuId`=19484 AND `OptionIndex`=0) OR (`MenuId`=19073 AND `OptionIndex`=0) OR (`MenuId`=18575 AND `OptionIndex`=0) OR (`MenuId`=18576 AND `OptionIndex`=0) OR (`MenuId`=18574 AND `OptionIndex`=0) OR (`MenuId`=19405 AND `OptionIndex`=0) OR (`MenuId`=19869 AND `OptionIndex`=0) OR (`MenuId`=20273 AND `OptionIndex`=0); +INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `VerifiedBuild`) VALUES +(20403, 0, 28, 'I can help you procure some valuable items.', 122136, 27980), -- OptionBroadcastTextID: 119001 - 122136 +(20001, 1, 28, 'I would like to requisition a Squad of Conjurors.', 121579, 27980), +(20000, 0, 28, 'Its... Elementary...', 117229, 27980), +(19263, 0, 0, 'Give me the crystal.', 105073, 27980), +(19237, 0, 0, 'Drog me, brul.', 104610, 27980), +(20524, 0, 0, 'I would like to witness the fall of Illidan Stormrage at the Black Temple again, Xe\'ra.', 123324, 27980), +(20328, 0, 28, 'Place work order for Champion armaments.', 122137, 27980), +(19979, 0, 0, '|c999900005 Withered:|r Bring the chest back to Thalyssra.', 115557, 27980), +(19982, 0, 0, '|c999900005 Withered:|r Bring the chest back to Thalyssra.', 115557, 27980), +(20187, 9, 0, 'Twenty withered.\n|cFFFF0000(Costs 2000 Ancient Mana |TINTERFACE\\ICONS\\INV_Misc_ancient_mana.blp:16|t)|r', 0, 27980), +(20187, 6, 0, 'Fifteen withered.\n(Costs 1300 Ancient Mana |TINTERFACE\\ICONS\\INV_Misc_ancient_mana.blp:16|t)', 0, 27980), +(20187, 4, 0, 'Twelve withered.\n(Costs 900 Ancient Mana |TINTERFACE\\ICONS\\INV_Misc_ancient_mana.blp:16|t)', 0, 27980), +(20187, 2, 0, 'Ten withered.\n(Costs 650 Ancient Mana |TINTERFACE\\ICONS\\INV_Misc_ancient_mana.blp:16|t)', 0, 27980), +(20187, 0, 0, 'Eight withered.\n(Costs 400 Ancient Mana |TINTERFACE\\ICONS\\INV_Misc_ancient_mana.blp:16|t)', 0, 27980), +(20644, 4, 5, 'I wish to bind my hearthstone here.', 122363, 27980), +(20644, 3, 1, 'I wish to trade.', 125204, 27980), -- OptionBroadcastTextID: 122362 - 125204 +(20644, 2, 0, '<Gain Ward of the First Arcanist for 50 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t Ancient Mana.>', 121814, 27980), +(20644, 1, 0, 'I\'ve come to help the withered with their combat training.', 120520, 27980), +(20576, 0, 0, 'I am ready, Thalyssra.', 124117, 27980), +(20643, 0, 0, 'Right this way, Arluelle.', 124832, 27980), +(20620, 1, 0, 'Eneas, you need to go now.', 124740, 27980), +(20618, 0, 0, 'Your father will help you get to safety. Go downstairs now!', 124730, 27980), +(20617, 0, 0, 'Your father is waiting for you downstairs- hurry!', 124728, 27980), +(20638, 0, 0, 'It looks like you have things handled, Scarleth. You and your girls should leave while you have a chance.', 124773, 27980), +(20635, 0, 0, 'I will protect you both. Let\'s go!', 124765, 27980), +(20620, 0, 0, 'You need to get out of here. It isn\'t safe!', 124738, 27980), +(20591, 3, 1, 'Can you repair my equipment?', 118613, 27980), +(20591, 2, 0, '<Gain Warpwalking for 10 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t Ancient Mana.>', 121607, 27980), +(20378, 0, 1, 'Let me browse your goods.', 8097, 27980), -- OptionBroadcastTextID: 2823 - 7509 - 8097 +(20738, 0, 0, 'Yes, take me back.', 125885, 27980), +(19764, 0, 0, 'Don\'t be coy. I know you\'re here to spy for the Grand Magistrix.', 111873, 27980), +(19761, 0, 0, 'Go on...', 127631, 27980), -- OptionBroadcastTextID: 111872 - 127631 +(19751, 0, 0, 'Go on...', 127631, 27980), -- OptionBroadcastTextID: 111872 - 127631 +(19741, 0, 0, 'Go on...', 127631, 27980), -- OptionBroadcastTextID: 111872 - 127631 +(19759, 0, 0, 'Go on...', 127631, 27980), -- OptionBroadcastTextID: 111872 - 127631 +(19722, 0, 0, 'Go ahead. I\'m ready for my disguise.', 111838, 27980), +(19579, 1, 0, 'While not the best solution, your Tailoring allows you to wrap up these wounds and at least stabilize this civilian.', 109457, 27980), +(19515, 0, 0, 'Send a signal to Ly\'leth Lunastre.', 108581, 27980), +(20166, 1, 0, 'I am ready to leave now.', 125916, 27980), +(19198, 0, 0, 'We are ready to challenge you Odyn!', 104099, 27980), +(18851, 0, 0, 'I challenge you, Bjorn.', 99981, 27980), +(18849, 0, 0, 'I challenge you, Ranulf.', 99979, 27980), +(18848, 0, 0, 'I challenge you, Tor.', 99978, 27980), +(19341, 0, 0, 'Are you ready for your lessons?', 106314, 27980), +(20496, 0, 3, 'Please teach me.', 8442, 27980), +(20506, 1, 0, 'Transmogrification', 56155, 27980), +(20086, 1, 0, 'Why can\'t I research Artifact Knowledge?', 130505, 27980), +(18705, 0, 3, 'Train me.', 3266, 27980), +(19241, 14, 1, 'What recipes do you sell?', 35243, 27980), +(19241, 3, 28, 'Research recipes using Fatty Bearsteaks.', 104710, 27980), +(19241, 1, 28, 'Research recipes using Wildfowl Eggs.', 104708, 27980), +(19241, 0, 28, 'Research recipes using Lean Shanks.', 104684, 27980), +(19241, 12, 28, 'Research recipes using Silver Mackerel.', 104858, 27980), +(20001, 0, 28, 'I would like to requisition a Squad of Apprentices.', 121578, 27980), +(20314, 1, 1, 'Show me your wares.', 90189, 27980), -- OptionBroadcastTextID: 58437 - 90189 +(20314, 0, 5, 'Make this inn your home.', 2822, 27980), +(18893, 0, 0, '...Okay?', 100307, 27980), +(18892, 0, 0, '...Deathwing? You mean the Burning Legion?', 100301, 27980), +(18811, 1, 1, 'Let me browse your goods.', 8097, 27980), -- OptionBroadcastTextID: 2823 - 7509 - 8097 +(18811, 0, 5, 'Make this inn your home.', 2822, 27980), +(20320, 1, 1, 'Show me your wares.', 90189, 27980), -- OptionBroadcastTextID: 58437 - 90189 +(20320, 0, 5, 'Make this inn your home.', 2822, 27980), +(18463, 1, 3, 'Train me in Mining.', 47116, 27980), +(10184, 0, 3, 'Train me.', 3266, 27980), +(18933, 0, 0, 'Let\'s do battle!', 75024, 27980), +(20997, 2, 1, 'Do you have something for sale?', 130333, 27980), +(20997, 1, 0, 'How can I help?', 127776, 27980), -- OptionBroadcastTextID: 2466 - 6664 - 32320 - 62066 - 118964 - 121136 - 130195 - 128593 - 127776 +(19295, 1, 0, 'How do I complete your test?', 105561, 27980), +(19295, 0, 0, 'I would like to attempt the flying challenge, please grant me your blessing.', 105556, 27980), +(20307, 1, 1, 'Show me your wares.', 90189, 27980), -- OptionBroadcastTextID: 58437 - 90189 +(20307, 0, 5, 'Make this inn your home.', 2822, 27980), +(18985, 0, 0, 'I wish to journey to Stonedark Grotto.', 101377, 27980), +(18750, 0, 0, 'What are soul chambers?', 98982, 27980), +(19601, 2, 1, 'Let me browse your goods.', 8097, 27843), -- OptionBroadcastTextID: 2823 - 7509 - 8097 +(20432, 4, 0, 'Can you tell me more about Arrexis?', 112314, 27843), +(19604, 0, 0, 'Why are you interested in the Empyrean Society?', 110247, 27843), +(19603, 0, 0, 'What do you know about their activities?', 110254, 27843), +(19576, 0, 0, 'I brought you a Pearl of Arcane Wisdom. What is it you do here, exactly?', 109732, 27843), +(19709, 0, 0, 'I seek the wisdom of the council.', 111669, 27843), +(18723, 3, 0, 'Meryl Felstorm says you have a ride for me to Faronaar.', 112817, 27843), +(19797, 0, 0, 'I will face your demons, warlock.', 112635, 27843), +(19796, 0, 0, 'I have the aid of Meryl Felstorm and the spirit of Alodi, and we know what we face this time.', 112633, 27843), +(19792, 0, 0, 'I have come to ask you about Arrexis and his ritual. I must face Balaadur and I need to get his attention.', 112631, 27843), +(19850, 0, 0, 'Who are you? Yes, I am looking to recreate Arrexis\'s ritual.', 114298, 27843), +(19778, 0, 0, 'I would like access to the personal vault of Alodi, Archmage of Dalaran.', 112368, 27843), +(20431, 0, 0, 'Okay.', 111465, 27843), -- OptionBroadcastTextID: 107618 - 111465 +(20432, 0, 0, '<Inform Meryl of the information you uncovered.>', 112316, 27843), +(20432, 6, 0, 'I\'ve changed my mind. Let me pick a different artifact.', 103823, 27843), -- OptionBroadcastTextID: 103322 - 103823 +(20362, 0, 1, 'Let\'s see what you have.', 122309, 27843), -- OptionBroadcastTextID: 11820 - 17411 - 92547 - 122256 - 122264 - 122277 - 122283 - 122291 - 122296 - 122299 - 122301 - 122309 +(20000, 2, 28, 'Its... Elementary...', 117229, 27843), +(20432, 5, 0, 'I\'ve changed my mind. Let me pick a different artifact.', 103823, 27843), -- OptionBroadcastTextID: 103322 - 103823 +(19321, 2, 0, 'Wait, who are you again?', 128607, 27843), -- OptionBroadcastTextID: 106049 - 128607 +(19321, 1, 0, 'What is the Forge of the Guardian?', 106048, 27843), +(19476, 2, 1, 'Show me your latest wares.', 108118, 27843), +(20679, 1, 1, 'Let me browse your goods.', 8097, 27843), -- OptionBroadcastTextID: 2823 - 7509 - 8097 +(20679, 0, 5, 'Make this inn your home.', 2822, 27843), +(18380, 1, 0, 'Hello again, Linzy. What\'s new with you?', 98720, 27843), +(18380, 0, 3, 'I would like to train.', 8221, 27843), -- OptionBroadcastTextID: 2548 - 5597 - 7563 - 8221 +(18735, 1, 0, 'Sounds like an exciting life!', 98724, 27843), +(18735, 0, 3, 'I would like to train.', 8221, 27843), -- OptionBroadcastTextID: 2548 - 5597 - 7563 - 8221 +(18728, 1, 0, 'How have you fared since Northrend?', 98729, 27843), +(18728, 0, 1, 'I\'d like to buy from you.', 98649, 27843), +(18918, 0, 3, 'Train me.', 3266, 27843), +(18917, 0, 3, 'Train me.', 3266, 27843), +(20157, 0, 1, 'I\'d like to buy from you.', 98649, 27843), +(20489, 1, 0, 'I want to experience the return of Magni Bronzebeard and Khadgar\'s adventures in Karazhan.', 123228, 27843), +(21018, 0, 1, 'I would like to look at your wares.', 130123, 27843), +(19094, 1, 1, 'I would like to buy from you.', 14967, 27843), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(20252, 0, 0, 'Need any help?', 121432, 27843), +(20251, 0, 0, 'And who\'s this little fellow?', 121425, 27843), +(20250, 0, 0, 'What are you up to?', 121423, 27843), +(21017, 0, 0, 'Could you be quiet?', 130126, 27843), +(11383, 0, 20, 'Queue for the Coren Direbrew battle.', 40422, 27843), +(20815, 0, 1, 'Let me browse your goods.', 8097, 27843), -- OptionBroadcastTextID: 2823 - 7509 - 8097 +(18961, 0, 1, 'I wish to browse your goods.', 96697, 27843), -- OptionBroadcastTextID: 15931 - 96697 +(19540, 2, 1, 'Show me what you have available.', 108794, 27843), +(18905, 3, 1, 'Any pet stuff for sale?', 87415, 27843), +(18905, 2, 0, 'Why are you called the Lioness?', 87407, 27843), +(18905, 0, 0, 'I\'d like to heal and revive my battle pets.', 64115, 27843), +(18906, 0, 0, 'Nevermind!', 87414, 27843), +(20367, 0, 1, 'I wish to browse your goods.', 96697, 27843), -- OptionBroadcastTextID: 15931 - 96697 +(19134, 0, 0, 'Show me the proof.', 103351, 27843), -- OptionBroadcastTextID: 103146 - 103351 +(19075, 0, 0, 'I come bearing a letter from your father.', 102376, 27843), +(19068, 0, 0, 'Why not deliver the letter yourself, Lord Greymane?', 102170, 27843), +(19870, 0, 0, 'I am ready to face the Legion.', 114581, 27843), +(20974, 1, 0, 'I\'ve heard this tale before... <Skip the scenario and begin your journey on Broken Shore.>', 136606, 27980), +(20974, 0, 0, 'I am ready to launch the assault.', 129426, 27980), +(18500, 1, 0, 'I need somebody summoned up to Dalaran. Can you help me?', 95691, 27980), +(19238, 0, 0, 'What\'s going on here, Toryl?', 104639, 27980), +(20417, 0, 0, '<Imbue one of the tridents with 25 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:15|t Ancient Mana.>', 122513, 27980), +(18973, 0, 0, 'Try to rouse the vrykul.', 101337, 27980), +(18987, 0, 0, 'I am no naga, Stokalfr! I come on behalf of Brandolf!', 101383, 27980), +(20212, 0, 0, 'Arluin is not coming, I\'m afraid. He died to ensure we could bring this to you. <Offer Arcan\'dor Fruit.>', 120809, 27980), +(19301, 8, 0, '<Gain Leyline Mastery for 10 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t Ancient Mana.>', 121650, 27980), +(20196, 0, 0, '<Offer Fruit of the Arcan\'dor.>', 120732, 27980), +(20197, 0, 0, '<Offer Fruit of the Arcan\'dor.>', 120732, 27980), +(20198, 0, 0, '<Offer Fruit of the Arcan\'dor.>', 120732, 27980), +(18748, 4, 0, '<Gain Ward of the First Arcanist for 50 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t Ancient Mana.>', 121814, 27980), +(18748, 3, 0, 'I\'ve come to help the withered with their combat training.', 120520, 27980), +(19960, 1, 0, '<Gain Warpwalking for 10 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t Ancient Mana.>', 121607, 27980), +(19929, 0, 0, 'I\'ve brought you some arcwine... drink up!', 115294, 27980), +(19933, 0, 0, 'I will take your Arcwine and share it with the needy.', 115399, 27980), +(20327, 0, 0, '<Feed Flameweaver Ovin 25 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:15|t Ancient Mana.>', 122177, 27980), +(20324, 0, 0, '<Feed Tempomancer Virinya 25 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:15|t Ancient Mana.>', 122172, 27980), +(20372, 0, 1, 'Let me see what you have for sale.', 51295, 27980), +(19301, 0, 0, 'All conduits are active. Can you amplify the feed?', 119710, 27980), +(19301, 6, 0, '<Gain Leyline Mastery for 30 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t Ancient Mana.>', 121648, 27980), +(20376, 0, 1, 'I would like to buy from you.', 14967, 27980), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(20187, 7, 0, 'Fifteen withered.\n|cFFFF0000(Costs 1300 Ancient Mana |TINTERFACE\\ICONS\\INV_Misc_ancient_mana.blp:16|t)|r', 0, 27980), +(20187, 5, 0, 'Twelve withered.\n|cFFFF0000(Costs 900 Ancient Mana |TINTERFACE\\ICONS\\INV_Misc_ancient_mana.blp:16|t)|r', 0, 27980), +(20119, 0, 0, 'I am ready to face Coryn.', 119387, 27980), +(20391, 0, 1, 'I\'d like to see what goods you have for sale.', 68295, 27980), +(20111, 0, 0, 'There is talk in the streets that they found a silver crescent near his corpse- is that true?', 119175, 27980), +(20110, 0, 0, 'I heard that Coryn Stelleris has begun to purchase the remaining Duskmere attendants - is that true?', 119173, 27980), +(20112, 0, 0, 'I overheard a rather crude joke at poor Ruven\'s expense while visiting the Stelleris family. I can\'t imagine you would want to hear it...', 119174, 27980), +(19696, 4, 0, 'Offer: 1200x |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t|Hcurrency:1155|h|cFFFFFFFF Ancient Mana|h|r', 121778, 27980), +(19696, 3, 0, 'We need your help \'persuading\' some noble houses to support Ly\'leth\'s bid for advisor. Are you in?', 119241, 27980), +(20390, 0, 1, 'Let me browse your goods.', 8097, 27980), -- OptionBroadcastTextID: 2823 - 7509 - 8097 +(19706, 0, 0, 'The owl hoots at dusk.', 111641, 27980), +(19704, 0, 0, 'The cruel caskmaster has breathed his last.', 111639, 27980), +(19705, 0, 0, 'The saber prowls the plaza.', 111640, 27980), +(18531, 0, 1, 'I would like to buy from you.', 14967, 27980), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(19696, 2, 0, 'Offer: 800x |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t|Hcurrency:1155|h|cFFFFFFFF Ancient Mana|h|r', 115303, 27980), +(19696, 1, 0, 'Vanthir and I need your help to avenge-', 112482, 27980), +(19696, 0, 0, '<Show Arluin your Sigil.>', 111853, 27980), +(20193, 0, 0, 'Yes, I am ready to help make arcwine.', 114922, 27980), +(19907, 0, 0, 'I am ready.', 134034, 27980), -- OptionBroadcastTextID: 35320 - 35539 - 39152 - 52091 - 52966 - 68157 - 72264 - 98694 - 101165 - 102817 - 104314 - 105294 - 105455 - 105611 - 106714 - 107434 - 108067 - 110410 - 114311 - 115011 - 120845 - 120867 - 120960 - 122483 - 130536 - 129525 - 130105 - 132934 - 134034 +(19908, 0, 0, 'Hope is not lost. We are making progress every day.', 115000, 27980), +(19905, 0, 0, 'Thank you! I am ready to move on now.', 115006, 27980), +(19906, 0, 0, 'Thalyssra said you had a unique way of dealing with insects. What is it?', 114999, 27980), +(19902, 0, 0, 'After you, Margaux.', 115004, 27980), +(19893, 0, 0, 'She is surviving, but not easily.', 114998, 27980), +(19895, 0, 0, '<Show your Sigil.>', 114966, 27980), -- OptionBroadcastTextID: 111841 - 114966 +(19885, 0, 0, 'Thalyssra said you would be able to help me infiltrate the Twilight Vineyards.', 121276, 27980), +(19519, 0, 0, 'I wanted to speak with you about a gem design.', 108606, 27980), +(19524, 0, 0, 'Lespin wants his brooch back.', 108640, 27980), +(19573, 0, 0, 'He insists that you return it, and that I may use force if necessary.', 109288, 27980), +(19475, 0, 0, 'Lespin wants his sculpture back.', 108113, 27980), +(19718, 0, 0, 'I\'m ready. Let\'s go!', 132063, 27980), -- OptionBroadcastTextID: 45852 - 47369 - 50940 - 111807 - 132063 +(19152, 1, 0, 'I am ready to begin the ritual.', 103586, 27980), -- OptionBroadcastTextID: 60578 - 103586 +(19152, 0, 0, 'I am ready to begin the ritual.', 103586, 27980), -- OptionBroadcastTextID: 60578 - 103586 +(19041, 0, 1, 'I would like to buy from you.', 14967, 27980), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(19392, 0, 0, 'Lead the way. I\'ll be right behind you.', 106702, 27980), +(19042, 1, 0, 'Why put yourself at risk to help them?', 104220, 27980), +(19211, 0, 0, 'Very well.', 128544, 27980), -- OptionBroadcastTextID: 18047 - 53933 - 53936 - 80374 - 82319 - 90890 - 103121 - 111532 - 111654 - 114217 - 128544 +(19042, 0, 0, '\"We shall drink of the Well again.\"', 101823, 27980), +(19301, 5, 0, '<Gain Leyline Mastery for 40 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t Ancient Mana.>', 121647, 27980), +(19301, 4, 0, '<Gain Leyline Mastery for 50 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t Ancient Mana.>', 121646, 27980), +(20318, 0, 0, '<Feed Leyweaver Ke\'lorin 25 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:15|t Ancient Mana.>', 122110, 27980), +(18748, 1, 0, '<Offer the Gift-Wrapped Arcwine Bottle.>', 115438, 27980), +(19692, 0, 0, 'I found a cask of wine!', 111355, 27980), +(19692, 1, 0, '<Show your Sigil.>', 114966, 27980), -- OptionBroadcastTextID: 111841 - 114966 +(19832, 0, 0, '<Offer Mana Wine.>', 112433, 27980), +(19831, 0, 0, '<Offer Mana Wine.>', 112433, 27980), +(19830, 0, 0, '<Offer Mana Wine.>', 112433, 27980), +(19829, 0, 0, '<Offer Mana Wine.>', 112433, 27980), +(19783, 0, 0, 'You wished to speak to me?', 112392, 27980), +(19360, 0, 0, 'Very well.', 128544, 27980), -- OptionBroadcastTextID: 18047 - 53933 - 53936 - 80374 - 82319 - 90890 - 103121 - 111532 - 111654 - 114217 - 128544 +(19980, 0, 0, '|c999900005 Withered:|r Bring the chest back to Thalyssra.', 115557, 27980), +(20491, 0, 0, 'Okay.', 111465, 27980), -- OptionBroadcastTextID: 107618 - 111465 +(20490, 0, 0, 'Um, what?', 123230, 27980), +(20728, 0, 0, 'I am ready.', 134034, 27980), -- OptionBroadcastTextID: 35320 - 35539 - 39152 - 52091 - 52966 - 68157 - 72264 - 98694 - 101165 - 102817 - 104314 - 105294 - 105455 - 105611 - 106714 - 107434 - 108067 - 110410 - 114311 - 115011 - 120845 - 120867 - 120960 - 122483 - 130536 - 129525 - 130105 - 132934 - 134034 +(20603, 0, 0, 'I seek the guidance of the Moon Guard.', 124579, 27980), +(18966, 0, 0, 'What will you do now?', 103139, 27980), +(18967, 0, 0, 'We may have a way to stave off the hunger - long enough to find a cure. Let us help.', 101204, 27980), +(18959, 0, 0, 'Very well.', 128544, 27980), -- OptionBroadcastTextID: 18047 - 53933 - 53936 - 80374 - 82319 - 90890 - 103121 - 111532 - 111654 - 114217 - 128544 +(18958, 0, 0, 'There is another way, Thaedris. We have a refuge not far from here. Thalyssra is there.', 101033, 27980), +(20399, 0, 0, '<Provide an offering of 20 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:15|t Ancient Mana.>', 122432, 27980), +(20406, 0, 0, '<Use 25 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:15|t Ancient Mana to extract a portion of the ley energy.>', 122448, 27980), +(19506, 0, 0, 'What if we tried not watching the world burn? Just for once, to see if we like it.', 108396, 27980), +(19554, 0, 0, '<Take a drink.>', 108946, 27980), +(18755, 0, 0, 'Let\'s do this.', 98940, 27980), -- OptionBroadcastTextID: 30898 - 51981 - 62609 - 98940 +(20118, 0, 1, 'Ravis, let\'s see what you have.', 119371, 27843), +(17085, 0, 0, 'I\'m ready. Let\'s get down to Azsuna, Khadgar.', 106208, 27843), +(20211, 1, 0, '<Insult>', 120835, 27980), +(20211, 0, 0, '<Raise mug>', 120834, 27980), +(20266, 1, 0, '<Insult>', 120835, 27980), +(20266, 0, 0, 'Why the boat?', 121488, 27980), +(20267, 0, 0, 'I want to ask something else.', 121489, 27980), -- OptionBroadcastTextID: 61781 - 121489 +(20493, 0, 0, 'Okay.', 111465, 27980), -- OptionBroadcastTextID: 107618 - 111465 +(20492, 0, 0, 'Um, what?', 123230, 27980), +(20091, 0, 0, 'What is going on here?', 118737, 27980), -- OptionBroadcastTextID: 39332 - 65946 - 118737 +(18634, 0, 5, 'Bind at this location.', 42778, 27980), +(20077, 0, 0, 'Take all of the Timeworn Artifacts I have on me!', 117143, 27843), +(18182, 2, 0, 'Ooka, may I please have some of your delicious Fighter Chow? I hear it\'s the best.', 92236, 27843), +(18182, 0, 0, 'Blikkety slickety ook. This mank jeeked on my dook. Face! Now hand over the Fighter Chow!', 88933, 27843), +(18180, 2, 0, 'Ooka, may I please have some of your delicious Fighter Chow? I hear it\'s the best.', 92236, 27843), +(18180, 0, 0, 'You can mank my dook, Ooka. I\'m taking the chow and there\'s nothing you can ookin do about it, wicket licker.', 92417, 27843), +(18178, 2, 0, 'Ooka, may I please have some of your delicious Fighter Chow? I hear it\'s the best.', 92236, 27843), +(18178, 0, 0, 'You\'ve got quite the mouth on you, Ooka. Maybe I should stuff it full of your blookin mank chow.', 91448, 27843), +(18177, 2, 0, 'Ooka, may I please have some of your delicious Fighter Chow? I hear it\'s the best.', 92236, 27843), +(18177, 0, 0, 'Slicky slapper! That\'s right, I said it. Slicky slapper.', 91591, 27843), +(18176, 2, 0, 'Ooka, may I please have some of your delicious Fighter Chow? I hear it\'s the best.', 92236, 27843), +(18176, 0, 0, 'You know what, Ooka? You have a dook for a head!', 91597, 27843), +(18175, 2, 0, 'Ooka, may I please have some of your delicious Fighter Chow? I hear it\'s the best.', 92236, 27843), +(18175, 0, 0, 'Ookin\' wikket! Walk away, just like your brother.', 91799, 27843), +(18174, 2, 0, 'Ooka, may I please have some of your delicious Fighter Chow? I hear it\'s the best.', 92236, 27843), +(18174, 0, 0, 'Your mom.', 90224, 27843), +(18173, 2, 0, 'Ooka, may I please have some of your delicious Fighter Chow? I hear it\'s the best.', 92236, 27843), +(18173, 0, 0, 'Hey, Ooka, your ooker is showing. That\'s unsavory and not the least bit sanitary.', 90223, 27843), +(18066, 2, 0, 'Ooka, may I please have some of your delicious Fighter Chow? I hear it\'s the best.', 92236, 27843), +(18066, 0, 0, 'I said, when I beat your brother black and blue, he dooked his pants and jumped away. Now give me the chow!', 90222, 27843), +(19040, 0, 3, 'Train me in Leatherworking.', 47115, 27843), +(8434, 0, 3, 'I would like to train.', 8221, 27843), -- OptionBroadcastTextID: 2548 - 5597 - 7563 - 8221 +(19682, 0, 1, 'I would like to buy from you.', 14967, 27843), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(20063, 0, 0, 'Send me back home, Oculeth.', 116408, 27980), +(19978, 0, 0, '|c999900005 Withered:|r Bring the chest back to Thalyssra.', 115557, 27980), +(19945, 0, 0, '|c999900005 Withered:|r Bring the chest back to Thalyssra.', 115557, 27980), +(19991, 0, 0, '|c9999000010 Withered:|r Bring the chest back to Thalyssra.', 115558, 27980), +(19990, 0, 0, '|c9999000010 Withered:|r Bring the chest back to Thalyssra.', 115558, 27980); + +INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `VerifiedBuild`) VALUES +(19944, 0, 0, '|c999900005 Withered:|r Bring the chest back to Thalyssra.', 115557, 27980), +(21059, 0, 1, 'I would like to buy from you.', 14967, 27980), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(21208, 0, 0, 'Take me to the surface.', 136137, 27980), +(21380, 4, 0, '<View the Breaking of the Pantheon.>', 137566, 27980), +(21380, 3, 0, '<View Aggramar\'s Rise.>', 137565, 27980), +(21380, 2, 0, '<Place your hand on the stone.>', 135022, 27980), +(21208, 1, 0, 'I am ready to go to the Arcatraz.', 132551, 27980), +(21163, 0, 0, '<Pick up the code book.>', 132080, 27980), +(21067, 1, 0, 'Where did Thaumaturge Vashreen go with the Relinquished items?', 137937, 27980), +(21067, 0, 1, 'I would like to buy from you.', 14967, 27980), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(20745, 2, 0, 'Tell me more about Arcanist Ryanna.', 128650, 27980), +(20745, 1, 0, 'How did the Legion gain access to Dalaran\'s weapons?', 128616, 27980), +(20745, 0, 0, 'I\'m ready to go. Summon a portal, please.', 127341, 27980), +(20903, 0, 0, 'I will not let that happen.', 128872, 27980), +(20902, 0, 0, 'Go on.', 128619, 27980), -- OptionBroadcastTextID: 24899 - 83453 - 128619 +(20906, 0, 0, 'How did you meet Aethas?', 128680, 27980), +(20563, 0, 0, 'Where would I find such a thing?', 128459, 27980), +(19934, 0, 0, 'Can you think of a way to safely use the Nightborne Soulstone?', 123927, 27980), +(20886, 0, 0, 'For the honor of Highmountain. I am ready! [Queue for Scenario]', 128150, 27980), +(20591, 0, 0, 'I am ready to enter the Sanctum.', 125396, 27980), +(20376, 1, 0, '<Take a drink.>', 108946, 27980), +(20684, 4, 0, '<Listen to fifth message.>', 125250, 27980), +(20684, 3, 0, '<Listen to fourth message.>', 125249, 27980), +(20684, 2, 0, '<Listen to third message.>', 125248, 27980), +(20684, 1, 0, '<Listen to second message.>', 125247, 27980), +(20684, 0, 0, '<Listen to first message.>', 125246, 27980), +(20695, 3, 0, 'What happened here?', 107100, 27980), -- OptionBroadcastTextID: 38328 - 90273 - 92991 - 105842 - 107100 +(20695, 0, 0, 'I\'m ready for the siege.', 125348, 27980), +(20689, 0, 0, '<Dismiss the message.>', 125259, 27980), +(20688, 0, 0, '<Dismiss the message.>', 125259, 27980), +(20687, 0, 0, '<Dismiss the message.>', 125259, 27980), +(20686, 0, 0, '<Dismiss the message.>', 125259, 27980), +(20685, 0, 0, '<Dismiss the message.>', 125259, 27980), +(20556, 1, 5, 'Make this inn your home.', 2822, 27980), +(20556, 0, 1, 'Show me your wares.', 90189, 27980), -- OptionBroadcastTextID: 58437 - 90189 +(20544, 0, 0, 'Plans from Thalyssra.', 123554, 27980), +(20543, 0, 0, 'Plans from Thalyssra.', 123554, 27980), +(20545, 0, 0, 'Plans from Thalyssra.', 123554, 27980), +(20601, 2, 0, 'I am ready, Valtrois.', 124421, 27980), +(20601, 1, 0, 'I am ready, Valtrois.', 124421, 27980), +(20601, 0, 0, 'I am ready, Valtrois.', 124421, 27980), +(20591, 1, 0, 'Let\'s go!', 124289, 27980), -- OptionBroadcastTextID: 21649 - 21972 - 35236 - 46550 - 46871 - 48123 - 54247 - 62691 - 64683 - 65207 - 72418 - 96106 - 104049 - 106939 - 108053 - 124289 +(20651, 8, 0, '<Gain Leyline Mastery for 10 |TINTERFACE\\ICONS\\INV_MISC_ANCIENT_MANA.BLP:20|t Ancient Mana.>', 121650, 27980), +(21380, 1, 0, '<Place your hand on the stone.>', 135022, 27980), +(21075, 0, 0, 'Alleria and I will protect you.', 130908, 27980), +(21058, 0, 0, 'We should keep going.', 130600, 27980), +(21144, 0, 0, 'Show me.', 134028, 27980), -- OptionBroadcastTextID: 131762 - 134028 +(21291, 0, 0, 'Is the trial complete?', 133017, 27980), +(21247, 0, 0, 'I am ready.', 134034, 27980), -- OptionBroadcastTextID: 35320 - 35539 - 39152 - 52091 - 52966 - 68157 - 72264 - 98694 - 101165 - 102817 - 104314 - 105294 - 105455 - 105611 - 106714 - 107434 - 108067 - 110410 - 114311 - 115011 - 120845 - 120867 - 120960 - 122483 - 130536 - 129525 - 130105 - 132934 - 134034 +(21242, 0, 0, 'I challenge you to a duel.', 132865, 27980), +(21244, 0, 0, 'I challenge you to a duel.', 132865, 27980), +(21243, 0, 0, 'I challenge you to a duel.', 132865, 27980), +(21238, 2, 0, 'Tell me about High Wakener Aargon.', 132858, 27980), +(21238, 1, 0, 'Tell me about Arc-Consul Velara.', 132859, 27980), +(21238, 0, 0, 'Tell me about Grand Vizier Jarasum.', 132857, 27980), +(21241, 0, 0, 'Tell me about the others.', 132861, 27980), +(21240, 0, 0, 'Tell me about the others.', 132861, 27980), +(21239, 0, 0, 'Tell me about the others.', 132861, 27980), +(20985, 0, 0, 'Shall we continue?', 129694, 27980), +(21208, 3, 0, 'I am ready, Romuul.', 137844, 27980), +(21709, 0, 0, 'What happened here, Prophet?', 137935, 27980), +(21380, 0, 0, '<Place your hand on the stone.>', 135022, 27980), +(21519, 0, 0, 'Begin attack run on Antorus.', 136891, 27980), +(21505, 0, 0, 'What information have you been able to gather, Alleria?', 136785, 27980), +(21513, 0, 1, 'I want to browse your goods.', 3370, 27980), +(21509, 0, 1, 'I want to browse your goods.', 3370, 27980), +(19896, 1, 0, 'Can you tell me more about Arrexis?', 112314, 27980), +(19867, 0, 0, 'I\'m ready.', 130808, 27980), -- OptionBroadcastTextID: 27602 - 28039 - 75831 - 96430 - 106086 - 109483 - 114517 - 118751 - 121757 - 122010 - 125992 - 124171 - 137729 - 137286 - 130808 +(19864, 0, 0, 'That is quite a story. Let\'s go.', 114491, 27980), +(19860, 0, 0, 'I see. Is Kathra\'natir behind the attack on Meryl?', 114431, 27980), +(19859, 0, 0, 'You have much to explain. Why have you betrayed us?', 114428, 27980), +(19769, 0, 0, 'I am ready.', 134034, 27980), -- OptionBroadcastTextID: 35320 - 35539 - 39152 - 52091 - 52966 - 68157 - 72264 - 98694 - 101165 - 102817 - 104314 - 105294 - 105455 - 105611 - 106714 - 107434 - 108067 - 110410 - 114311 - 115011 - 120845 - 120867 - 120960 - 122483 - 130536 - 129525 - 130105 - 132934 - 134034 +(21580, 2, 0, 'I\'d like to heal and revive my battle pets.', 64115, 27980), +(21580, 1, 1, 'I\'m looking for a lost companion.', 56613, 27980), +(21336, 0, 0, '<View Light\'s Judgment.>', 0, 27980), +(21208, 2, 0, 'Fire!', 137474, 27980), -- OptionBroadcastTextID: 17911 - 22314 - 22452 - 22483 - 33526 - 36091 - 46130 - 63397 - 66786 - 69027 - 78134 - 81265 - 137474 +(21245, 0, 0, 'Let us begin, Turalyon.', 132875, 27980), +(21326, 1, 0, 'Let\'s go!', 124289, 27980), -- OptionBroadcastTextID: 21649 - 21972 - 35236 - 46550 - 46871 - 48123 - 54247 - 62691 - 64683 - 65207 - 72418 - 96106 - 104049 - 106939 - 108053 - 124289 +(21457, 0, 0, 'But you\'re sitting down.', 136391, 27980), +(21456, 0, 0, 'Interesting... And why aren\'t you wearing any shoes?', 136303, 27980), +(21454, 0, 0, 'What is that portal doing here?', 136301, 27980), +(21462, 2, 1, 'Let me browse your goods.', 8097, 27980), -- OptionBroadcastTextID: 2823 - 7509 - 8097 +(21462, 1, 0, 'It is good to see you, Ishanah. How are you?', 136389, 27980), +(21462, 0, 5, 'Make this inn your home.', 2822, 27980), +(21451, 0, 0, 'What is that behind you?', 136302, 27980), +(21004, 0, 0, 'I am ready to fight by your side.', 129988, 27980), +(21049, 0, 0, 'I am ready, High Exarch.', 130541, 27980), +(21423, 0, 1, 'I need repairs, Durael.', 136412, 27980), +(21013, 0, 0, 'I am ready.', 134034, 27980), -- OptionBroadcastTextID: 35320 - 35539 - 39152 - 52091 - 52966 - 68157 - 72264 - 98694 - 101165 - 102817 - 104314 - 105294 - 105455 - 105611 - 106714 - 107434 - 108067 - 110410 - 114311 - 115011 - 120845 - 120867 - 120960 - 122483 - 130536 - 129525 - 130105 - 132934 - 134034 +(21072, 0, 0, 'I\'m ready.', 130808, 27980), -- OptionBroadcastTextID: 27602 - 28039 - 75831 - 96430 - 106086 - 109483 - 114517 - 118751 - 121757 - 122010 - 125992 - 124171 - 137729 - 137286 - 130808 +(20895, 0, 0, 'Let us hear what she has to say, Magni.', 128392, 27980), +(20821, 0, 0, 'Go find Levia, Fhambar!', 126801, 27980), +(20819, 0, 0, 'The runes are activated. Stabilize the portal.', 126752, 27980), +(20679, 3, 0, 'Do you know where I can find Levia Laurence?', 125159, 27980), -- OptionBroadcastTextID: 125165 - 125159 +(20815, 2, 0, 'Do you know where I can find Levia Laurence?', 125159, 27980), -- OptionBroadcastTextID: 125165 - 125159 +(18598, 4, 0, 'Do you know where I can find Levia Laurence?', 125159, 27980), -- OptionBroadcastTextID: 125165 - 125159 +(20746, 0, 0, 'I\'m ready.', 130808, 27980), -- OptionBroadcastTextID: 27602 - 28039 - 75831 - 96430 - 106086 - 109483 - 114517 - 118751 - 121757 - 122010 - 125992 - 124171 - 137729 - 137286 - 130808 +(20732, 0, 0, 'This vrykul is the heir to the God-King. She seeks an audience with Eyir.', 125802, 27980), +(20989, 0, 0, 'I\'m ready.', 130808, 27980), -- OptionBroadcastTextID: 27602 - 28039 - 75831 - 96430 - 106086 - 109483 - 114517 - 118751 - 121757 - 122010 - 125992 - 124171 - 137729 - 137286 - 130808 +(20867, 0, 0, 'Have any vrykul passed through here that struck you as odd?', 127719, 27980), +(20865, 0, 0, 'Slodi mentioned you could help find the vrykul mentioned in these scrolls.', 127716, 27980), +(20863, 0, 0, 'I am searching for the vrykul mentioned in these scrolls.', 127711, 27980), +(21063, 0, 1, 'I would like to buy from you.', 14967, 27980), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(21064, 1, 1, 'Let me browse your goods.', 8097, 27980), -- OptionBroadcastTextID: 2823 - 7509 - 8097 +(21064, 0, 5, 'Make this inn your home.', 2822, 27980), +(21065, 0, 1, 'I would like to buy from you.', 14967, 27980), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(19472, 2, 0, 'What are you exactly?', 108092, 27980), +(19473, 0, 0, 'Let\'s get back to the matter at hand.', 108101, 27980), +(18807, 0, 1, 'I would like to buy from you.', 14967, 27980), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(18778, 5, 0, 'I want to hire a personal bodyguard.', 105615, 27980), +(18778, 4, 0, 'Raethan, call back your guards.\n\n[Cost: 50 |TInterface\\Icons\\achievement_reputation_kirintor_offensive.blp:12|t Sightless Eyes]', 0, 27980), +(18778, 0, 1, 'I would like to buy from you.', 14967, 27980), -- OptionBroadcastTextID: 2583 - 6399 - 7142 - 9992 - 14967 +(19241, 2, 28, 'Research recipes using Big Gamy Ribs.', 104709, 27980), +(20498, 0, 0, 'How do I get Obliterum?', 123249, 27980), +(20500, 0, 0, 'What happened to your donkey?', 123251, 27980), +(20499, 0, 0, 'What can I do with Obliterum?', 123250, 27980), +(20269, 1, 1, 'Let me browse your goods.', 8097, 27980), -- OptionBroadcastTextID: 2823 - 7509 - 8097 +(20269, 0, 5, 'Make this inn your home.', 2822, 27980), +(18656, 0, 0, 'Take me to Greywatch.', 97469, 27980), +(20539, 1, 0, 'Helya can corrupt the Stormforged!', 123455, 27980), +(19484, 0, 0, 'Let\'s do battle!', 75024, 27980), +(19073, 0, 0, 'Leave the Darkpens.', 102275, 27843), +(18575, 0, 0, 'Be at peace.', 133586, 27843), -- OptionBroadcastTextID: 55100 - 96672 - 130606 - 133586 +(18576, 0, 0, 'Arduen sent me. You\'re free.', 96673, 27843), +(18574, 0, 0, 'Excuse me...', 96670, 27843), +(19405, 0, 0, 'Yes, Tyrande.', 107098, 27843), +(19869, 0, 0, 'Free Remulos from captivity.', 114547, 27843), +(20273, 0, 5, 'Make this inn your home.', 2822, 27843); + +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=122365, `VerifiedBuild`=27980 WHERE (`MenuId`=19929 AND `OptionIndex`=1); +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=122405, `VerifiedBuild`=27980 WHERE (`MenuId`=20393 AND `OptionIndex`=0); +UPDATE `gossip_menu_option` SET `OptionBroadcastTextId`=111319, `VerifiedBuild`=27980 WHERE (`MenuId`=19687 AND `OptionIndex`=0); +UPDATE `gossip_menu_option` SET `OptionText`='I am ready.', `VerifiedBuild`=27980 WHERE (`MenuId`=21334 AND `OptionIndex`=0); +UPDATE `gossip_menu_option` SET `OptionText`='Show me.', `VerifiedBuild`=27980 WHERE (`MenuId`=21333 AND `OptionIndex`=0); +UPDATE `gossip_menu_option` SET `OptionText`='<Relay Fareeya\'s orders.>', `OptionBroadcastTextId`=133783, `VerifiedBuild`=27980 WHERE (`MenuId`=21323 AND `OptionIndex`=0); +UPDATE `gossip_menu_option` SET `OptionText`='<Relay Fareeya\'s orders.>', `OptionBroadcastTextId`=133783, `VerifiedBuild`=27980 WHERE (`MenuId`=21315 AND `OptionIndex`=0); +UPDATE `gossip_menu_option` SET `OptionText`='<Relay Fareeya\'s orders.>', `OptionBroadcastTextId`=133783, `VerifiedBuild`=27980 WHERE (`MenuId`=21312 AND `OptionIndex`=0); +UPDATE `gossip_menu_option` SET `OptionText`='I seek the Sigil of Awakening.', `OptionBroadcastTextId`=133323, `VerifiedBuild`=27980 WHERE (`MenuId`=21253 AND `OptionIndex`=0); +UPDATE `gossip_menu_option` SET `OptionText`='Do you know anyone by the name \"Locus-Walker\"?', `OptionBroadcastTextId`=137644, `VerifiedBuild`=27980 WHERE (`MenuId`=21059 AND `OptionIndex`=2); +UPDATE `gossip_menu_option` SET `OptionText`='Why is an ethereal traveling on a ship full of draenei?', `OptionBroadcastTextId`=137468, `VerifiedBuild`=27980 WHERE (`MenuId`=21059 AND `OptionIndex`=1); +UPDATE `gossip_menu_option` SET `OptionText`='I am ready, Ysera. Let us find Malfurion!', `OptionBroadcastTextId`=94718, `VerifiedBuild`=27843 WHERE (`MenuId`=18402 AND `OptionIndex`=0); +UPDATE `gossip_menu_option` SET `OptionText`='I am ready, Ysera. Let us find Malfurion!', `OptionBroadcastTextId`=94718, `VerifiedBuild`=27843 WHERE (`MenuId`=18402 AND `OptionIndex`=0); + +DELETE FROM `points_of_interest` WHERE `ID` IN (5158, 5159, 5161, 5157, 5160, 5148, 5156, 5155, 5154, 5145, 5149, 5152, 5146, 5151, 5150, 5153, 5144, 5147, 5143, 5127, 5126, 5142, 5141, 5140, 5134, 5135, 5136, 5137, 5138, 5129, 5139, 5120, 5119, 5118, 5133, 5132, 5131, 5130, 5121, 5122, 5128, 5125, 5124, 5123, 5163, 2422, 2427, 2426, 2423, 870, 2418, 92, 90, 95, 2425, 2272, 107, 1427); +INSERT INTO `points_of_interest` (`ID`, `PositionX`, `PositionY`, `Icon`, `Flags`, `Importance`, `Name`, `VerifiedBuild`) VALUES +(5158, -766.544, 4437.56, 7, 99, 0, 'Dalaran Wine & Cheese', 27843), +(5159, -963.592, 4446.6, 7, 99, 0, 'Dalaran General & Trade Store', 27843), +(5161, -833.303, 4521.92, 7, 99, 0, 'Dalaran Toy Store', 27843), +(5157, -742.708, 4457.46, 7, 99, 0, 'Dalaran Pie, Pastry & Cake', 27843), +(5160, -804.129, 4396.54, 7, 99, 0, 'Dalaran Pet Store', 27843), +(5148, -776.011, 4551.83, 7, 99, 0, 'Dalaran Jewelcrafting Trainer', 27843), +(5156, -894.998, 4518.57, 7, 99, 0, 'Dalaran Fruit Vendor', 27843), +(5155, -875.958, 4405.39, 7, 99, 0, 'Dalaran Flowers', 27843), +(5154, -882.788, 4561.56, 7, 99, 0, 'Dalaran Cloth Armor & Clothing', 27843), +(5145, -766.168, 4571.07, 7, 99, 0, 'Dalaran Tailoring Trainer', 27843), +(5149, -740.656, 4577.12, 7, 99, 0, 'Dalaran Skinning Trainer', 27843), +(5152, -726.794, 4492.37, 7, 99, 0, 'Dalaran Mining Trainer', 27843), +(5146, -746.967, 4576.03, 7, 99, 0, 'Dalaran Leatherworking Trainer', 27843), +(5151, -790.066, 4528.33, 7, 99, 0, 'Dalaran Inscription Trainer', 27843), +(5150, -776.78, 4516.06, 7, 99, 0, 'Dalaran Herbalism Trainer', 27843), +(5153, -942.72, 4441.12, 7, 99, 0, 'Dalaran Fishing Fountain', 27843), +(5144, -785.047, 4568.06, 7, 99, 0, 'Dalaran First Aid Trainer', 27843), +(5147, -732.245, 4556.21, 7, 99, 0, 'Dalaran Engineering Trainer', 27843), +(5143, -812.439, 4550.02, 7, 99, 0, 'Dalaran Enchanting Trainer', 27843), +(5127, -765.314, 4355.56, 7, 99, 0, 'Dalaran Horde Inn', 27843), +(5126, -914.578, 4503.72, 7, 99, 0, 'Dalaran Alliance Inn', 27843), +(5142, -738.522, 4503.31, 7, 99, 0, 'Dalaran Blacksmithing Trainer', 27843), +(5141, -732.314, 4538.22, 7, 99, 0, 'Dalaran Archaeology Trainer', 27843), +(5140, -756.123, 4534.01, 7, 99, 0, 'Dalaran Alchemy Trainer', 27843), +(5134, -804.887, 4397.25, 7, 99, 0, 'Dalaran Stable Master', 27843), +(5135, -798.463, 4591.27, 7, 99, 0, 'Dalaran Cemetary', 27843), +(5136, -922.62, 4469.25, 7, 99, 0, 'Dalaran Eventide', 27843), +(5137, -844.073, 4467.51, 7, 99, 0, 'Dalaran Chamber of the Guardian', 27843), +(5138, -700.869, 4495.23, 7, 99, 0, 'Dalaran Antonidas Memorial', 27843), +(5129, -816.763, 4328.3, 7, 99, 0, 'Dalaran Krasus\' Landing', 27843), +(5139, -749.283, 4549.84, 7, 99, 0, 'Dalaran Trade District', 27843), +(5120, -762.45, 4479.03, 7, 99, 0, 'Dalaran Well', 27843), +(5119, -833.072, 4588.64, 7, 99, 0, 'Dalaran Western Sewer Entrance', 27843), +(5118, -845.716, 4381.57, 7, 99, 0, 'Dalaran Eastern Sewer Entrance', 27843), +(5133, -954.938, 4331.64, 7, 99, 0, 'Dalaran Violet Hold', 27843), +(5132, -853.274, 4608.85, 7, 99, 0, 'Dalaran Violet Citadel', 27843), +(5131, -793.467, 4424.45, 7, 99, 0, 'Dalaran Windrunner\'s Sanctuary', 27843), +(5130, -889.082, 4542.02, 7, 99, 0, 'Dalaran Greyfang\'s Enclave', 27843), +(5121, -990.566, 4507.78, 7, 99, 0, 'Dalaran Southern Bank', 27843), +(5122, -700.628, 4448.49, 7, 99, 0, 'Dalaran Northern Bank', 27843), +(5128, -797.128, 4475.5, 7, 99, 0, 'Dalaran Inn', 27843), +(5125, -895.272, 4445.07, 7, 99, 0, 'Dalaran Visitor Center', 27843), +(5124, -862.466, 4297.66, 7, 99, 0, 'Dalaran Flight Master', 27843), +(5123, -762.153, 4451.98, 7, 99, 0, 'Dalaran Barber', 27843), +(5163, -807.9045, 4549.413, 7, 99, 0, 'Dalaran Transmogrifier', 27843), +(2422, -8780.08, 378.651, 7, 99, 0, 'Stormwind Riding Trainer & Mounts', 27843), +(2427, -8767.48, 408.564, 7, 99, 0, 'Stormwind Honor & Conquest Quartermasters', 27843), +(2426, -8804.8, 348.023, 7, 99, 0, 'Stormwind Heroism & Valor Quartermasters', 27843), +(2423, -8849.51, 500.269, 7, 99, 0, 'Stormwind Flying Trainer & Mounts', 27843), +(870, -8432.87, 555.121, 7, 99, 0, 'Stormwind Stable Master', 27843), +(2418, -8775.39, 371.104, 7, 99, 0, 'Stormwind Stable Master', 27843), +(92, -8941.56, 783.764, 7, 99, 0, 'Stormwind Tailoring', 27843), +(90, -8717.89, 464.542, 7, 99, 0, 'Stormwind Leatherworking & Skinning', 27843), +(95, -8431.96, 687.125, 7, 99, 0, 'Stormwind Mining', 27843), +(2425, -8709.56, 621.618, 7, 99, 0, 'Stormwind Jewelcrafting', 27843), +(2272, -8850.78, 856.596, 7, 99, 0, 'Stormwind Inscription', 27843), +(107, -8801.98, 770.842, 7, 99, 0, 'Stormwind Fishing', 27843), +(1427, -8521.81, 816.241, 7, 99, 0, 'Stormwind First Aid', 27843); |