diff options
| -rw-r--r-- | sql/updates/world/master/2022_08_09_00_world.sql | 235 |
1 files changed, 235 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_08_09_00_world.sql b/sql/updates/world/master/2022_08_09_00_world.sql new file mode 100644 index 00000000000..702a194101f --- /dev/null +++ b/sql/updates/world/master/2022_08_09_00_world.sql @@ -0,0 +1,235 @@ +-- +SET @VANILLA_NPCTEXTID := 500013; +SET @CATA_NPCTEXTID := 530000; +SET @MOP_NPCTEXTID := 540000; +SET @WOD_NPCTEXTID := 550030; +SET @LEGION_NPCTEXTID := 560000; +SET @BFA_NPCTEXTID := 570000; +SET @SL_NPCTEXTID := 580001; + + +DELETE FROM `npc_text` WHERE `ID`=@VANILLA_NPCTEXTID+0; +DELETE FROM `npc_text` WHERE `ID`=@CATA_NPCTEXTID+0; +DELETE FROM `npc_text` WHERE `ID` BETWEEN @MOP_NPCTEXTID+0 AND @MOP_NPCTEXTID+8; +DELETE FROM `npc_text` WHERE `ID`=@WOD_NPCTEXTID+0; +DELETE FROM `npc_text` WHERE `ID` BETWEEN @LEGION_NPCTEXTID+0 AND @LEGION_NPCTEXTID+1; +DELETE FROM `npc_text` WHERE `ID`=@BFA_NPCTEXTID+0; +DELETE FROM `npc_text` WHERE `ID`=@SL_NPCTEXTID+0; +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(@VANILLA_NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 179497, 0, 0, 0, 0, 0, 0, 0, 44730), -- 3391 (Gazlowe) +(@CATA_NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 45398, 0, 0, 0, 0, 0, 0, 0, 44325), -- 45139 (Zirazi the Star-Gazer) +(@MOP_NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 65055, 0, 0, 0, 0, 0, 0, 0, 44730), -- 64561 (Jong Ming-Yiu) +(@MOP_NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 71226, 0, 0, 0, 0, 0, 0, 0, 44730), -- 68984 (Ruben Holen) +(@MOP_NPCTEXTID+2, 1, 0, 0, 0, 0, 0, 0, 0, 58439, 0, 0, 0, 0, 0, 0, 0, 44730), -- 59403 (Whetstone) +(@MOP_NPCTEXTID+3, 1, 0, 0, 0, 0, 0, 0, 0, 59460, 0, 0, 0, 0, 0, 0, 0, 44730), -- 59959 (Mokimo the Strong) +(@MOP_NPCTEXTID+4, 1, 0, 0, 0, 0, 0, 0, 0, 64160, 0, 0, 0, 0, 0, 0, 0, 44730), -- 64291 (Poolwarden Abusshi) +(@MOP_NPCTEXTID+5, 1, 0, 0, 0, 0, 0, 0, 0, 72897, 0, 0, 0, 0, 0, 0, 0, 44730), -- 70398 (Ben of the Booming Voice) +(@MOP_NPCTEXTID+6, 1, 0, 0, 0, 0, 0, 0, 0, 66069, 0, 0, 0, 0, 0, 0, 0, 44730), -- 65121 (Clean Pelt) +(@MOP_NPCTEXTID+7, 1, 0, 0, 0, 0, 0, 0, 0, 72898, 0, 0, 0, 0, 0, 0, 0, 44730), -- 70398 (Ben of the Booming Voice) +(@WOD_NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 89363, 0, 0, 0, 0, 0, 0, 0, 44730), -- 87062 (Royce Bigbeard) +(@LEGION_NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 147241, 0, 0, 0, 0, 0, 0, 0, 44325), -- 133185 (Wildswalker Nightborne) +(@LEGION_NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 98316, 0, 0, 0, 0, 0, 0, 0, 44325), -- 96470 (Jana Winterhoof) +(@BFA_NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 172274, 0, 0, 0, 0, 0, 0, 0, 44730), -- 151955 (Tempra) +(@SL_NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 187306, 0, 0, 0, 0, 0, 0, 0, 44325); -- 168626 (Feenix Arcshine) + +-- delete old gossips +DELETE FROM `gossip_menu` WHERE (`MenuID`=5854 AND `TextID`=9685) OR (`MenuID`=5665 AND `TextID`=9557) OR (`MenuID`=11821 AND `TextID`=44520) OR (`MenuID`=14181 AND `TextID`=43832) OR (`MenuID`=2748 AND `TextID`=5745) OR (`MenuID`=1017 AND `TextID`=3955) OR (`MenuID`=4325 AND `TextID`=8114) OR (`MenuID`=13014 AND `TextID`=20131) OR (`MenuID`=7690 AND `TextID`=15411) OR (`MenuID`=7815 AND `TextID`=20985) OR (`MenuID`=12642 AND `TextID`=30864) OR (`MenuID`=7691 AND `TextID`=15413) OR (`MenuID`=18702 AND `TextID`=98316) OR (`MenuID`=4128 AND `TextID`=7743) OR (`MenuID`=4119 AND `TextID`=7704) OR (`MenuID`=4165 AND `TextID`=7912) OR (`MenuID`=4158 AND `TextID`=7883) OR (`MenuID`=4207 AND `TextID`=8009) OR (`MenuID`=4351 AND `TextID`=8168) OR (`MenuID`=4266 AND `TextID`=8074) OR (`MenuID`=4242 AND `TextID`=8046) OR (`MenuID`=721 AND `TextID`=3425) OR (`MenuID`=10566 AND `TextID`=35040) OR (`MenuID`=14207 AND `TextID` IN (7660,5006)) OR (`MenuID`=21342 AND `TextID`=7660) OR (`MenuID`=13895 AND `TextID`=61023) OR (`MenuID`=5856 AND `TextID`=9701) OR (`MenuID`=13985 AND `TextID`=7163) OR (`MenuID`=13988 AND `TextID`=2527) OR (`MenuID`=14202 AND `TextID`=8297) OR (`MenuID`=13987 AND `TextID`=2527) OR (`MenuID`=4825 AND `TextID`=8453) OR (`MenuID`=13984 AND `TextID`=7163) OR (`MenuID`=8124 AND `TextID`=18192) OR (`MenuID`=11180 AND `TextID`=39239) OR (`MenuID`=1469 AND `TextID`=4557) OR (`MenuID`=4746 AND `TextID`=8344) OR (`MenuID`=4152 AND `TextID`=7861) OR (`MenuID`=2242 AND `TextID`=5274) OR (`MenuID`=11160 AND `TextID`=39180) OR (`MenuID`=11066 AND `TextID`=38521) OR (`MenuID`=11731 AND `TextID`=43486) OR (`MenuID`=18866 AND `TextID`=100030) OR (`MenuID`=1965 AND `TextID`=4958) OR (`MenuID`=18692 AND `TextID`=98275) OR (`MenuID`=4164 AND `TextID`=7907) OR (`MenuID`=4133 AND `TextID`=7769) OR (`MenuID`=1581 AND `TextID`=2827) OR (`MenuID`=11284 AND `TextID`=39743) OR (`MenuID`=11353 AND `TextID`=40265) OR (`MenuID`=11364 AND `TextID`=40330) OR (`MenuID`=11374 AND `TextID`=40383) OR (`MenuID`=12842 AND `TextID`=51906) OR (`MenuID`=10362 AND `TextID`=45085) OR (`MenuID`=12846 AND `TextID`=51958) OR (`MenuID`=8782 AND `TextID`=22164) OR (`MenuID`=4004 AND `TextID`=8428) OR (`MenuID`=4355 AND `TextID`=8195) OR (`MenuID`=8826 AND `TextID`=22392) OR (`MenuID`=12848 AND `TextID`=51960) OR (`MenuID`=12850 AND `TextID`=51966) OR (`MenuID`=8762 AND `TextID`=22053) OR (`MenuID`=2465 AND `TextID`=5505) OR (`MenuID`=12844 AND `TextID`=51948) OR (`MenuID`=12843 AND `TextID`=51946) OR (`MenuID`=12517 AND `TextID`=7493) OR (`MenuID`=1162 AND `TextID`=4226) OR (`MenuID`=1161 AND `TextID`=4225) OR (`MenuID`=14123 AND `TextID`=7638) OR (`MenuID`=5382 AND `TextID`=8974) OR (`MenuID`=12847 AND `TextID`=51959) OR (`MenuID`=12852 AND `TextID`=51969) OR (`MenuID`=541 AND `TextID`=3161) OR (`MenuID`=4211 AND `TextID`=8029) OR (`MenuID`=10341 AND `TextID`=33572) OR (`MenuID`=4301 AND `TextID`=8098) OR (`MenuID`=14991 AND `TextID`=64116) OR (`MenuID`=8519 AND `TextID`=20133) OR (`MenuID`=4138 AND `TextID`=7805) OR (`MenuID`=12725 AND `TextID`=50840) OR (`MenuID`=10482 AND `TextID`=34469) OR (`MenuID`=12726 AND `TextID`=50850) OR (`MenuID`=8521 AND `TextID`=20135) OR (`MenuID`=14255 AND `TextID`=8303) OR (`MenuID`=4302 AND `TextID`=8099) OR (`MenuID`=4174 AND `TextID`=7954) OR (`MenuID`=4156 AND `TextID`=7877) OR (`MenuID`=15733 AND `TextID`=74285) OR (`MenuID`=3580 AND `TextID`=7065) OR (`MenuID`=5855 AND `TextID`=9701) OR (`MenuID`=9821 AND `TextID`=30361) OR (`MenuID`=4783 AND `TextID`=8407) OR (`MenuID`=11778 AND `TextID`=44301) OR (`MenuID`=2021 AND `TextID`=4989) OR (`MenuID`=14028 AND `TextID`=7477) OR (`MenuID`=12180 AND `TextID`=47105) OR (`MenuID`=6944 AND `TextID`=10753) OR (`MenuID`=2350 AND `TextID`=5471) OR (`MenuID`=2351 AND `TextID`=5353) OR (`MenuID`=2352 AND `TextID`=5325) OR (`MenuID`=2349 AND `TextID`=5369) OR (`MenuID`=12323 AND `TextID`=47996) OR (`MenuID`=12778 AND `TextID`=51341) OR (`MenuID`=5853 AND `TextID`=9685) OR (`MenuID`=2345 AND `TextID`=5357) OR (`MenuID`=4241 AND `TextID`=8041) OR (`MenuID`=4204 AND `TextID`=7994) OR (`MenuID`=4181 AND `TextID`=7955) OR (`MenuID`=4269 AND `TextID`=8083) OR (`MenuID`=4349 AND `TextID`=8157) OR (`MenuID`=4125 AND `TextID`=7728) OR (`MenuID`=4131 AND `TextID`=7759) OR (`MenuID`=4114 AND `TextID`=7689) OR (`MenuID`=4163 AND `TextID`=7902) OR (`MenuID`=4155 AND `TextID`=7874) OR (`MenuID`=698 AND `TextID`=3396) OR (`MenuID`=8517 AND `TextID`=20131) OR (`MenuID`=14041 AND `TextID`=7642) OR (`MenuID`=14047 AND `TextID`=7477) OR (`MenuID`=14048 AND `TextID`=7477) OR (`MenuID`=14042 AND `TextID`=7477) OR (`MenuID`=3185 AND `TextID`=6482) OR (`MenuID`=4303 AND `TextID`=8100) OR (`MenuID`=7470 AND `TextID`=14359) OR (`MenuID`=4243 AND `TextID`=8051) OR (`MenuID`=345 AND `TextID`=2826) OR (`MenuID`=12091 AND `TextID`=46228) OR (`MenuID`=11885 AND `TextID`=10753) OR (`MenuID`=11714 AND `TextID`=43282) OR (`MenuID`=9338 AND `TextID`=25748) OR (`MenuID`=8991 AND `TextID`=23685) OR (`MenuID`=9985 AND `TextID`=31357) OR (`MenuID`=10116 AND `TextID`=32323) OR (`MenuID`=9780 AND `TextID`=29493) OR (`MenuID`=9879 AND `TextID`=30864) OR (`MenuID`=8803 AND `TextID`=22299) OR (`MenuID`=8808 AND `TextID`=22307) OR (`MenuID`=15135 AND `TextID`=22302) OR (`MenuID`=9894 AND `TextID`=30958) OR (`MenuID`=9618 AND `TextID`=27293) OR (`MenuID`=8802 AND `TextID`=22295) OR (`MenuID`=8966 AND `TextID`=23488) OR (`MenuID`=9892 AND `TextID`=30951) OR (`MenuID`=10114 AND `TextID`=32320) OR (`MenuID`=9986 AND `TextID`=31358) OR (`MenuID`=9223 AND `TextID`=25264) OR (`MenuID`=9218 AND `TextID`=25240) OR (`MenuID`=9246 AND `TextID`=25309) OR (`MenuID`=9245 AND `TextID`=25308) OR (`MenuID`=9683 AND `TextID`=27818) OR (`MenuID`=9929 AND `TextID`=31228) OR (`MenuID`=9920 AND `TextID`=31205) OR (`MenuID`=10214 AND `TextID`=33042) OR (`MenuID`=9919 AND `TextID`=31204) OR (`MenuID`=10723 AND `TextID`=36197) OR (`MenuID`=8254 AND `TextID`=18823) OR (`MenuID`=7817 AND `TextID`=15847) OR (`MenuID`=8554 AND `TextID`=20398) OR (`MenuID`=8539 AND `TextID`=20263) OR (`MenuID`=8538 AND `TextID`=20260) OR (`MenuID`=7328 AND `TextID`=13142) OR (`MenuID`=7351 AND `TextID`=13394) OR (`MenuID`=7448 AND `TextID`=14257) OR (`MenuID`=7892 AND `TextID`=16140) OR (`MenuID`=7352 AND `TextID`=17523) OR (`MenuID`=7820 AND `TextID`=15847) OR (`MenuID`=7826 AND `TextID`=13144) OR (`MenuID`=7818 AND `TextID`=15847) OR (`MenuID`=7810 AND `TextID`=15847) OR (`MenuID`=8002 AND `TextID`=17083) OR (`MenuID`=7879 AND `TextID`=15847) OR (`MenuID`=7301 AND `TextID`=12749) OR (`MenuID`=7320 AND `TextID`=12805) OR (`MenuID`=8646 AND `TextID`=20985) OR (`MenuID`=7842 AND `TextID`=15957) OR (`MenuID`=7884 AND `TextID`=16122) OR (`MenuID`=7396 AND `TextID`=13663) OR (`MenuID`=7391 AND `TextID`=13651) OR (`MenuID`=7390 AND `TextID`=13650) OR (`MenuID`=7393 AND `TextID`=13653) OR (`MenuID`=7392 AND `TextID`=13652) OR (`MenuID`=7883 AND `TextID`=16121) OR (`MenuID`=7360 AND `TextID`=13468) OR (`MenuID`=7948 AND `TextID`=16966) OR (`MenuID`=7343 AND `TextID`=13308) OR (`MenuID`=7512 AND `TextID`=14545) OR (`MenuID`=8622 AND `TextID`=20697) OR (`MenuID`=9113 AND `TextID`=2826) OR (`MenuID`=8392 AND `TextID`=19563) OR (`MenuID`=8387 AND `TextID`=19465) OR (`MenuID`=7973 AND `TextID`=16654) OR (`MenuID`=19873 AND `TextID`=29522) OR (`MenuID`=18713 AND `TextID`=27198) OR (`MenuID`=18475 AND `TextID`=26697) OR (`MenuID`=19876 AND `TextID`=29526) OR (`MenuID`=14310 AND `TextID`=63548) OR (`MenuID`=14630 AND `TextID`=66100) OR (`MenuID`=13649 AND `TextID`=59460) OR (`MenuID`=10188 AND `TextID` IN (32780,32778)) OR (`MenuID`=14409 AND `TextID`=64163) OR (`MenuID`=14582 AND `TextID`=65274) OR (`MenuID`=15967 AND `TextID`=76659) OR (`MenuID`=16509 AND `TextID`=82867) OR (`MenuID`=14615 AND `TextID`=65827) OR (`MenuID`=15690 AND `TextID`=73921) OR (`MenuID`=15107 AND `TextID`=62763) OR (`MenuID`=15152 AND `TextID`=2974) OR (`MenuID`=10656 AND `TextID`=66772) OR (`MenuID`=15718 AND `TextID`=74212) OR (`MenuID`=14803 AND `TextID`=66780) OR (`MenuID`=14802 AND `TextID`=66779) OR (`MenuID`=10183 AND `TextID`=32780) OR (`MenuID`=14680 AND `TextID`=16967) OR (`MenuID`=15952 AND `TextID`=76559) OR (`MenuID`=14558 AND `TextID`=64856) OR (`MenuID`=14566 AND `TextID`=64979) OR (`MenuID`=15956 AND `TextID`=76583) OR (`MenuID`=14818 AND `TextID`=66857) OR (`MenuID`=14829 AND `TextID`=64992) OR (`MenuID`=14825 AND `TextID`=64990) OR (`MenuID`=14808 AND `TextID`=66823) OR (`MenuID`=14810 AND `TextID`=66824) OR (`MenuID`=14826 AND `TextID`=66936) OR (`MenuID`=14830 AND `TextID`=64989) OR (`MenuID`=14828 AND `TextID`=64987) OR (`MenuID`=14827 AND `TextID`=64988) OR (`MenuID`=15579 AND `TextID` IN (72887,72888)) OR (`MenuID`=15589 AND `TextID`=72898) OR (`MenuID`=15588 AND `TextID`=72897) OR (`MenuID`=13609 AND `TextID`=59160) OR (`MenuID`=14584 AND `TextID`=65285) OR (`MenuID`=14583 AND `TextID`=65284) OR (`MenuID`=14581 AND `TextID`=63984) OR (`MenuID`=13642 AND `TextID`=59333) OR (`MenuID`=14407 AND `TextID`=64160) OR (`MenuID`=13608 AND `TextID`=59146) OR (`MenuID`=13470 AND `TextID`=57697) OR (`MenuID`=14422 AND `TextID`=65283) OR (`MenuID`=14585 AND `TextID`=65915) OR (`MenuID`=14379 AND `TextID`=65915) OR (`MenuID`=13584 AND `TextID`=58782) OR (`MenuID`=13343 AND `TextID`=56284) OR (`MenuID`=14795 AND `TextID`=66728) OR (`MenuID`=14324 AND `TextID`=63643) OR (`MenuID`=14323 AND `TextID`=63636) OR (`MenuID`=13420 AND `TextID`=57208) OR (`MenuID`=13421 AND `TextID`=57209) OR (`MenuID`=13423 AND `TextID`=57219) OR (`MenuID`=14641 AND `TextID`=66244) OR (`MenuID`=15365 AND `TextID`=70839) OR (`MenuID`=21666 AND `TextID`=137599) OR (`MenuID`=14627 AND `TextID`=66069) OR (`MenuID`=13555 AND `TextID`=58439) OR (`MenuID`=13554 AND `TextID`=58438) OR (`MenuID`=14605 AND `TextID`=65568) OR (`MenuID`=14528 AND `TextID`=64775) OR (`MenuID`=14800 AND `TextID`=66759) OR (`MenuID`=10182 AND `TextID`=32779) OR (`MenuID`=14635 AND `TextID`=66191) OR (`MenuID`=13291 AND `TextID`=55736) OR (`MenuID`=14626 AND `TextID`=66059) OR (`MenuID`=14628 AND `TextID`=66072) OR (`MenuID`=13296 AND `TextID` IN (63490,63489,63486,63483)) OR (`MenuID`=13283 AND `TextID`=55708) OR (`MenuID`=13782 AND `TextID`=60914) OR (`MenuID`=13284 AND `TextID`=55711) OR (`MenuID`=13282 AND `TextID`=55707) OR (`MenuID`=13530 AND `TextID`=58126) OR (`MenuID`=13547 AND `TextID`=58389) OR (`MenuID`=14624 AND `TextID`=66030) OR (`MenuID`=14629 AND `TextID`=66087) OR (`MenuID`=13288 AND `TextID`=55732) OR (`MenuID`=14625 AND `TextID`=66055) OR (`MenuID`=15100 AND `TextID`=68315) OR (`MenuID`=15098 AND `TextID`=68312) OR (`MenuID`=15099 AND `TextID`=68314) OR (`MenuID`=8522 AND `TextID`=9701) OR (`MenuID`=14919 AND `TextID`=67156) OR (`MenuID`=14918 AND `TextID`=67154) OR (`MenuID`=14933 AND `TextID`=67214) OR (`MenuID`=14920 AND `TextID` IN (67158,67157)) OR (`MenuID`=16723 AND `TextID`=84755) OR (`MenuID`=18346 AND `TextID`=94176) OR (`MenuID`=4824 AND `TextID` IN (8448,8447)) OR (`MenuID`=4827 AND `TextID`=8457) OR (`MenuID`=9578 AND `TextID`=26990) OR (`MenuID`=11614 AND `TextID`=42230) OR (`MenuID`=13800 AND `TextID`=61023) OR (`MenuID`=12104 AND `TextID`=46358) OR (`MenuID`=12346 AND `TextID`=48099) OR (`MenuID`=12347 AND `TextID`=48100) OR (`MenuID`=12107 AND `TextID`=46376) OR (`MenuID`=24054 AND `TextID`=172274) OR (`MenuID`=17277 AND `TextID`=90386) OR (`MenuID`=17245 AND `TextID`=90186) OR (`MenuID`=17049 AND `TextID`=88160) OR (`MenuID`=17334 AND `TextID`=91453) OR (`MenuID`=17156 AND `TextID`=89247) OR (`MenuID`=17048 AND `TextID`=88159) OR (`MenuID`=17047 AND `TextID`=88158) OR (`MenuID`=17126 AND `TextID`=88880) OR (`MenuID`=17157 AND `TextID`=89248) OR (`MenuID`=17268 AND `TextID`=90340) OR (`MenuID`=17131 AND `TextID`=88930) OR (`MenuID`=17130 AND `TextID`=88925) OR (`MenuID`=17312 AND `TextID`=90961) OR (`MenuID`=17044 AND `TextID`=88048) OR (`MenuID`=18324 AND `TextID`=96939) OR (`MenuID`=17046 AND `TextID`=88125) OR (`MenuID`=17183 AND `TextID`=89366) OR (`MenuID`=21043 AND `TextID`=130509) OR (`MenuID`=17182 AND `TextID`=89365) OR (`MenuID`=17148 AND `TextID`=89198) OR (`MenuID`=17294 AND `TextID`=90706) OR (`MenuID`=17152 AND `TextID`=89238) OR (`MenuID`=17181 AND `TextID`=89364) OR (`MenuID`=17180 AND `TextID`=89363) OR (`MenuID`=17153 AND `TextID`=89239) OR (`MenuID`=17179 AND `TextID`=89362) OR (`MenuID`=17178 AND `TextID`=89361) OR (`MenuID`=17032 AND `TextID`=87652) OR (`MenuID`=6024 AND `TextID`=9869) OR (`MenuID`=25426 AND `TextID`=194996) OR (`MenuID`=12040 AND `TextID`=45705) OR (`MenuID`=22124 AND `TextID` IN (51896,18046)) OR (`MenuID`=12106 AND `TextID`=46375) OR (`MenuID`=13949 AND `TextID`=17800) OR (`MenuID`=23508 AND `TextID`=36437) OR (`MenuID`=13096 AND `TextID`=18390) OR (`MenuID`=13947 AND `TextID`=5715) OR (`MenuID`=13946 AND `TextID`=5002) OR (`MenuID`=12510 AND `TextID`=17596) OR (`MenuID`=11721 AND `TextID`=16405) OR (`MenuID`=11723 AND `TextID`=16408) OR (`MenuID`=13955 AND `TextID`=5002) OR (`MenuID`=12108 AND `TextID`=17000) OR (`MenuID`=12226 AND `TextID`=17169) OR (`MenuID`=11587 AND `TextID`=16181) OR (`MenuID`=12391 AND `TextID`=17418) OR (`MenuID`=18704 AND `TextID`=27189) OR (`MenuID`=12887 AND `TextID`=6961) OR (`MenuID`=14265 AND `TextID`=15461) OR (`MenuID`=14189 AND `TextID`=15461) OR (`MenuID`=14206 AND `TextID` IN (5716,8293)) OR (`MenuID`=18868 AND `TextID`=27481) OR (`MenuID`=14250 AND `TextID`=20019) OR (`MenuID`=13967 AND `TextID`=563) OR (`MenuID`=13970 AND `TextID`=4984) OR (`MenuID`=13966 AND `TextID`=5720) OR (`MenuID`=13969 AND `TextID`=4796) OR (`MenuID`=13968 AND `TextID`=4439) OR (`MenuID`=11156 AND `TextID`=15526) OR (`MenuID`=12101 AND `TextID`=16989) OR (`MenuID`=23507 AND `TextID`=7778) OR (`MenuID`=12250 AND `TextID` IN (17211,47569)) OR (`MenuID`=12249 AND `TextID` IN (17210,47564)) OR (`MenuID`=8380 AND `TextID` IN (10455,19432)) OR (`MenuID`=17076 AND `TextID`=25090) OR (`MenuID`=17086 AND `TextID`=25100) OR (`MenuID`=17018 AND `TextID`=24826) OR (`MenuID`=17313 AND `TextID`=25685) OR (`MenuID`=17232 AND `TextID`=25478) OR (`MenuID`=17237 AND `TextID`=25511) OR (`MenuID`=17132 AND `TextID`=25180) OR (`MenuID`=22167 AND `TextID`=33967) OR (`MenuID`=13047 AND `TextID`=18322) OR (`MenuID`=26693 AND `TextID`=42426) OR (`MenuID`=26846 AND `TextID`=42723) OR (`MenuID`=23896 AND `TextID`=37462) OR (`MenuID`=21961 AND `TextID`=33608) OR (`MenuID`=21959 AND `TextID`=33599) OR (`MenuID`=22069 AND `TextID`=33798) OR (`MenuID`=21956 AND `TextID`=33604) OR (`MenuID`=23995 AND `TextID`=37601) OR (`MenuID`=23391 AND `TextID`=10651) OR (`MenuID`=24070 AND `TextID`=37720) OR (`MenuID`=24069 AND `TextID`=37719) OR (`MenuID`=22632 AND `TextID`=34834) OR (`MenuID`=23828 AND `TextID`=37351) OR (`MenuID`=22797 AND `TextID`=35291) OR (`MenuID`=23256 AND `TextID`=36028) OR (`MenuID`=22171 AND `TextID`=33973) OR (`MenuID`=22169 AND `TextID`=33971) OR (`MenuID`=26192 AND `TextID`=41572) OR (`MenuID`=22180 AND `TextID`=33981) OR (`MenuID`=22176 AND `TextID`=33978) OR (`MenuID`=22173 AND `TextID`=33975) OR (`MenuID`=22172 AND `TextID`=33974) OR (`MenuID`=6800 AND `TextID`=11411) OR (`MenuID`=3901 AND `TextID`=7448) OR (`MenuID`=3062 AND `TextID`=6267) OR (`MenuID`=14032 AND `TextID`=7161) OR (`MenuID`=14008 AND `TextID`=7660) OR (`MenuID`=14203 AND `TextID`=44538) OR (`MenuID`=10181 AND `TextID`=32778) OR (`MenuID`=16168 AND `TextID`=78604) OR (`MenuID`=12670 AND `TextID`=25292) OR (`MenuID`=4142 AND `TextID`=7819) OR (`MenuID`=2746 AND `TextID`=5739) OR (`MenuID`=4842 AND `TextID`=8467) OR (`MenuID`=10735 AND `TextID`=36253) OR (`MenuID`=14987 AND `TextID`=67516) OR (`MenuID`=10778 AND `TextID`=36332) OR (`MenuID`=10715 AND `TextID`=36164) OR (`MenuID`=5481 AND `TextID`=9013) OR (`MenuID`=4162 AND `TextID`=7899) OR (`MenuID`=4066 AND `TextID`=7607) OR (`MenuID`=4025 AND `TextID`=7559) OR (`MenuID`=4244 AND `TextID`=8055) OR (`MenuID`=14124 AND `TextID`=8293) OR (`MenuID`=4270 AND `TextID`=8086) OR (`MenuID`=14180 AND `TextID`=43834) OR (`MenuID`=14259 AND `TextID`=7161) OR (`MenuID`=2783 AND `TextID`=5801) OR (`MenuID`=4324 AND `TextID`=8112) OR (`MenuID`=4341 AND `TextID`=8120) OR (`MenuID`=14226 AND `TextID`=7476) OR (`MenuID`=24575 AND `TextID`=179497) OR (`MenuID`=4140 AND `TextID`=7813) OR (`MenuID`=1465 AND `TextID`=4550) OR (`MenuID`=10556 AND `TextID`=35011) OR (`MenuID`=349 AND `TextID`=2828) OR (`MenuID`=11004 AND `TextID`=38248) OR (`MenuID`=10936 AND `TextID`=37463) OR (`MenuID`=4350 AND `TextID`=8162) OR (`MenuID`=4006 AND `TextID`=8416) OR (`MenuID`=3646 AND `TextID`=7170) OR (`MenuID`=3331 AND `TextID`=6718) OR (`MenuID`=4185 AND `TextID`=7967) OR (`MenuID`=13997 AND `TextID`=7648) OR (`MenuID`=7455 AND `TextID`=14288) OR (`MenuID`=7459 AND `TextID`=14302) OR (`MenuID`=14153 AND `TextID`=12467) OR (`MenuID`=7463 AND `TextID`=14324) OR (`MenuID`=7531 AND `TextID`=14622) OR (`MenuID`=7833 AND `TextID`=15935) OR (`MenuID`=7489 AND `TextID`=14422) OR (`MenuID`=7517 AND `TextID`=14563) OR (`MenuID`=7465 AND `TextID`=14326) OR (`MenuID`=7832 AND `TextID`=15933) OR (`MenuID`=7452 AND `TextID`=14268) OR (`MenuID`=7460 AND `TextID`=14303) OR (`MenuID`=14145 AND `TextID`=12461) OR (`MenuID`=8243 AND `TextID`=18780) OR (`MenuID`=7430 AND `TextID` IN (14158,14124)) OR (`MenuID`=7429 AND `TextID` IN (14156,14125)) OR (`MenuID`=7434 AND `TextID` IN (14164,14125)) OR (`MenuID`=7433 AND `TextID` IN (14163,14123)) OR (`MenuID`=7431 AND `TextID`=14160) OR (`MenuID`=7432 AND `TextID`=14162) OR (`MenuID`=8129 AND `TextID`=18274) OR (`MenuID`=25356 AND `TextID` IN (193630,40155)) OR (`MenuID`=14149 AND `TextID`=12463) OR (`MenuID`=14157 AND `TextID`=13452) OR (`MenuID`=7383 AND `TextID`=13577) OR (`MenuID`=7384 AND `TextID`=13592) OR (`MenuID`=7380 AND `TextID`=13565) OR (`MenuID`=7426 AND `TextID`=14092) OR (`MenuID`=7400 AND `TextID`=13729) OR (`MenuID`=7398 AND `TextID`=13706) OR (`MenuID`=7399 AND `TextID`=13709) OR (`MenuID`=7388 AND `TextID`=13641) OR (`MenuID`=7389 AND `TextID`=13644) OR (`MenuID`=7361 AND `TextID`=13471) OR (`MenuID`=8399 AND `TextID`=19588) OR (`MenuID`=7788 AND `TextID`=15860) OR (`MenuID`=7777 AND `TextID`=15856) OR (`MenuID`=7859 AND `TextID`=16025) OR (`MenuID`=7858 AND `TextID`=16027) OR (`MenuID`=8866 AND `TextID`=20132) OR (`MenuID`=8382 AND `TextID`=19435) OR (`MenuID`=8381 AND `TextID`=19434) OR (`MenuID`=9832 AND `TextID`=30353) OR (`MenuID`=8867 AND `TextID`=20131) OR (`MenuID`=8868 AND `TextID`=20133) OR (`MenuID`=7797 AND `TextID`=15818) OR (`MenuID`=7414 AND `TextID`=14007) OR (`MenuID`=8863 AND `TextID`=20130) OR (`MenuID`=7796 AND `TextID`=15813) OR (`MenuID`=1871 AND `TextID`=4788) OR (`MenuID`=1942 AND `TextID`=4858) OR (`MenuID`=1951 AND `TextID`=4857) OR (`MenuID`=24056 AND `TextID` IN (172337,172335,37697)) OR (`MenuID`=12443 AND `TextID`=48813) OR (`MenuID`=4143 AND `TextID`=7820) OR (`MenuID`=4148 AND `TextID`=7841) OR (`MenuID`=980 AND `TextID`=3901) OR (`MenuID`=4151 AND `TextID`=7856) OR (`MenuID`=12803 AND `TextID`=51566) OR (`MenuID`=4747 AND `TextID`=8346) OR (`MenuID`=14217 AND `TextID`=7163) OR (`MenuID`=22787 AND `TextID`=2528) OR (`MenuID`=10630 AND `TextID`=35457) OR (`MenuID`=26685 AND `TextID`=206707) OR (`MenuID`=12760 AND `TextID`=51238) OR (`MenuID`=12410 AND `TextID`=48457) OR (`MenuID`=14139 AND `TextID`=14765) OR (`MenuID`=7359 AND `TextID`=13466) OR (`MenuID`=12308 AND `TextID`=47945) OR (`MenuID`=1624 AND `TextID` IN (4623,4622)) OR (`MenuID`=22117 AND `TextID` IN (146449,146448)) OR (`MenuID`=22125 AND `TextID` IN (32778,14126)) OR (`MenuID`=22121 AND `TextID` IN (146522,33885)) OR (`MenuID`=22114 AND `TextID` IN (146431,33862)) OR (`MenuID`=22190 AND `TextID`=147237) OR (`MenuID`=12439 AND `TextID`=48762) OR (`MenuID`=12085 AND `TextID`=46140) OR (`MenuID`=22192 AND `TextID`=147241) OR (`MenuID`=12084 AND `TextID`=46135) OR (`MenuID`=11972 AND `TextID`=45398) OR (`MenuID`=11919 AND `TextID`=45200) OR (`MenuID`=3161 AND `TextID`=8414) OR (`MenuID`=25721 AND `TextID` IN (197623,40637)) OR (`MenuID`=11726 AND `TextID`=43426) OR (`MenuID`=4741 AND `TextID`=8334) OR (`MenuID`=15500 AND `TextID`=71584) OR (`MenuID`=3187 AND `TextID`=6489) OR (`MenuID`=2747 AND `TextID`=5742) OR (`MenuID`=1012 AND `TextID`=3945) OR (`MenuID`=2782 AND `TextID`=5796) OR (`MenuID`=25355 AND `TextID` IN (187268,40154,39570)) OR (`MenuID`=25114 AND `TextID`=187306) OR (`MenuID`=25354 AND `TextID` IN (193634,40153)) OR (`MenuID`=25348 AND `TextID` IN (193629,40147)) OR (`MenuID`=25346 AND `TextID` IN (193627,40145)) OR (`MenuID`=25345 AND `TextID` IN (193626,40144)) OR (`MenuID`=25353 AND `TextID` IN (193633,40152)) OR (`MenuID`=25350 AND `TextID` IN (193632,40148)) OR (`MenuID`=25347 AND `TextID` IN (193628,40146)) OR (`MenuID`=25357 AND `TextID` IN (193641,40156,39570)) OR (`MenuID`=3701 AND `TextID`=7228) OR (`MenuID`=12235 AND `TextID`=47380) OR (`MenuID`=12056 AND `TextID`=45865) OR (`MenuID`=12125 AND `TextID`=46529) OR (`MenuID`=344 AND `TextID`=2825) OR (`MenuID`=14134 AND `TextID` IN (7660,5006)) OR (`MenuID`=12759 AND `TextID`=51215) OR (`MenuID`=4347 AND `TextID`=8147) OR (`MenuID`=4265 AND `TextID`=8071) OR (`MenuID`=4183 AND `TextID`=7961) OR (`MenuID`=4209 AND `TextID`=8019) OR (`MenuID`=2189 AND `TextID`=5182) OR (`MenuID`=4118 AND `TextID`=7701) OR (`MenuID`=4126 AND `TextID`=7733) OR (`MenuID`=4168 AND `TextID`=7927) OR (`MenuID`=4159 AND `TextID`=7886) OR (`MenuID`=6229 AND `TextID`=10174) OR (`MenuID`=11637 AND `TextID`=42455) OR (`MenuID`=6942 AND `TextID`=11714) OR (`MenuID`=7256 AND `TextID`=12438) OR (`MenuID`=7311 AND `TextID`=12789) OR (`MenuID`=7244 AND `TextID`=12400) OR (`MenuID`=7346 AND `TextID` IN (13339,13348,13350,13349)) OR (`MenuID`=7524 AND `TextID` IN (14594,16035,16037,16036)) OR (`MenuID`=7117 AND `TextID`=12002) OR (`MenuID`=7116 AND `TextID`=11989) OR (`MenuID`=8185 AND `TextID`=18549) OR (`MenuID`=7324 AND `TextID`=12842) OR (`MenuID`=7313 AND `TextID`=12793) OR (`MenuID`=14140 AND `TextID`=14766) OR (`MenuID`=14137 AND `TextID`=14773) OR (`MenuID`=14199 AND `TextID`=44400) OR (`MenuID`=14144 AND `TextID`=14768) OR (`MenuID`=6940 AND `TextID`=11701) OR (`MenuID`=8376 AND `TextID`=19425) OR (`MenuID`=14136 AND `TextID`=14772) OR (`MenuID`=14142 AND `TextID`=14763) OR (`MenuID`=12186 AND `TextID`=47129) OR (`MenuID`=12199 AND `TextID`=47141) OR (`MenuID`=12198 AND `TextID`=47140) OR (`MenuID`=12197 AND `TextID`=47139) OR (`MenuID`=12196 AND `TextID`=47138) OR (`MenuID`=12195 AND `TextID`=47137) OR (`MenuID`=12193 AND `TextID`=47136) OR (`MenuID`=12192 AND `TextID`=47134) OR (`MenuID`=12191 AND `TextID`=47133) OR (`MenuID`=12185 AND `TextID`=47108) OR (`MenuID`=12190 AND `TextID`=47132) OR (`MenuID`=12189 AND `TextID`=47131) OR (`MenuID`=12188 AND `TextID`=47130) OR (`MenuID`=6620 AND `TextID`=11003) OR (`MenuID`=7141 AND `TextID`=12061) OR (`MenuID`=8098 AND `TextID`=18925) OR (`MenuID`=12520 AND `TextID`=49766) OR (`MenuID`=7148 AND `TextID`=12083) OR (`MenuID`=8658 AND `TextID`=21278) OR (`MenuID`=8829 AND `TextID`=22513) OR (`MenuID`=7288 AND `TextID`=12528) OR (`MenuID`=8732 AND `TextID`=21691) OR (`MenuID`=8379 AND `TextID`=19431) OR (`MenuID`=7828 AND `TextID`=15904) OR (`MenuID`=7243 AND `TextID`=12395) OR (`MenuID`=7494 AND `TextID`=14435) OR (`MenuID`=8733 AND `TextID`=21722) OR (`MenuID`=8731 AND `TextID`=21686) OR (`MenuID`=8828 AND `TextID`=22512) OR (`MenuID`=6649 AND `TextID`=14765) OR (`MenuID`=16503 AND `TextID`=23967) OR (`MenuID`=26430 AND `TextID`=41918) OR (`MenuID`=19686 AND `TextID`=29171) OR (`MenuID`=19685 AND `TextID`=29170) OR (`MenuID`=19684 AND `TextID`=29169) OR (`MenuID`=15719 AND `TextID`=74212) OR (`MenuID`=14833 AND `TextID`=64856) OR (`MenuID`=15153 AND `TextID`=4857) OR (`MenuID`=14571 AND `TextID`=65055) OR (`MenuID`=15382 AND `TextID`=71226) OR (`MenuID`=15108 AND `TextID`=62764) OR (`MenuID`=14278 AND `TextID`=62617) OR (`MenuID`=9868 AND `TextID`=16967) OR (`MenuID`=14529 AND `TextID`=64778) OR (`MenuID`=14996 AND `TextID`=67604) OR (`MenuID`=24301 AND `TextID`=38114) OR (`MenuID`=24007 AND `TextID`=37614) OR (`MenuID`=24016 AND `TextID`=37618) OR (`MenuID`=23950 AND `TextID`=37545) OR (`MenuID`=24278 AND `TextID`=38060) OR (`MenuID`=24280 AND `TextID`=38074) OR (`MenuID`=24276 AND `TextID`=38058) OR (`MenuID`=24225 AND `TextID`=38053) OR (`MenuID`=24224 AND `TextID`=37933) OR (`MenuID`=24124 AND `TextID`=37792) OR (`MenuID`=24305 AND `TextID`=38121) OR (`MenuID`=24306 AND `TextID`=38122) OR (`MenuID`=24307 AND `TextID`=38123) OR (`MenuID`=23850 AND `TextID`=37391) OR (`MenuID`=21949 AND `TextID`=33580) OR (`MenuID`=23473 AND `TextID`=36413) OR (`MenuID`=23967 AND `TextID`=37562) OR (`MenuID`=21896 AND `TextID`=33467) OR (`MenuID`=14160 AND `TextID`=10040) OR (`MenuID`=25369 AND `TextID`=40006) OR (`MenuID`=646 AND `TextID`=1208) OR (`MenuID`=25100 AND `TextID`=39560) OR (`MenuID`=25112 AND `TextID`=39579) OR (`MenuID`=16074 AND `TextID`=23165) OR (`MenuID`=16065 AND `TextID`=2594) OR (`MenuID`=26191 AND `TextID`=41571); + +DELETE FROM `gossip_menu` WHERE (`MenuID`=24575 AND `TextID`=@VANILLA_NPCTEXTID+0); +DELETE FROM `gossip_menu` WHERE (`MenuID`=11972 AND `TextID`=@CATA_NPCTEXTID+0); +DELETE FROM `gossip_menu` WHERE (`MenuID`=15588 AND `TextID`=@MOP_NPCTEXTID+5) OR (`MenuID`=14627 AND `TextID`=@MOP_NPCTEXTID+6) OR (`MenuID`=15589 AND `TextID`=@MOP_NPCTEXTID+7) OR (`MenuID`=14407 AND `TextID`=@MOP_NPCTEXTID+4) OR (`MenuID`=13649 AND `TextID`=@MOP_NPCTEXTID+3) OR (`MenuID`=13555 AND `TextID`=@MOP_NPCTEXTID+2) OR (`MenuID`=15382 AND `TextID`=@MOP_NPCTEXTID+1) OR (`MenuID`=14571 AND `TextID`=@MOP_NPCTEXTID+0); +DELETE FROM `gossip_menu` WHERE (`MenuID`=17180 AND `TextID`=@WOD_NPCTEXTID+0); +DELETE FROM `gossip_menu` WHERE (`MenuID`=22192 AND `TextID`=@LEGION_NPCTEXTID+0) OR (`MenuID`=18702 AND `TextID`=@LEGION_NPCTEXTID+1); +DELETE FROM `gossip_menu` WHERE (`MenuID`=24054 AND `TextID`=@BFA_NPCTEXTID+0); +DELETE FROM `gossip_menu` WHERE (`MenuID`=25114 AND `TextID`=@SL_NPCTEXTID+0); + +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(24575, @VANILLA_NPCTEXTID+0, 44730), -- 3391 (Gazlowe) +(11972, @CATA_NPCTEXTID+0, 44730), -- 45139 (Zirazi the Star-Gazer) +(14571, @MOP_NPCTEXTID+0, 44730), -- 64561 (Jong Ming-Yiu) +(15382, @MOP_NPCTEXTID+1, 44730), -- 68984 (Ruben Holen) +(13555, @MOP_NPCTEXTID+2, 44730), -- 59403 (Whetstone) +(13649, @MOP_NPCTEXTID+3, 44730), -- 59959 (Mokimo the Strong) +(14407, @MOP_NPCTEXTID+4, 44730), -- 64291 (Poolwarden Abusshi) +(15588, @MOP_NPCTEXTID+5, 44730), -- 70398 (Ben of the Booming Voice) +(14627, @MOP_NPCTEXTID+6, 44730), -- 65121 (Clean Pelt) +(15589, @MOP_NPCTEXTID+7, 44730), -- 70398 (Ben of the Booming Voice) +(17180, @WOD_NPCTEXTID+0, 44730), -- 87062 (Royce Bigbeard) +(22192, @LEGION_NPCTEXTID+0, 44730), -- 133185 (Wildswalker Nightborne) +(18702, @LEGION_NPCTEXTID+1, 44730), -- 96470 (Jana Winterhoof) +(24054, @BFA_NPCTEXTID+0, 44730), -- 151955 (Tempra) +(25114, @SL_NPCTEXTID+0, 44730); -- 168626 (Feenix Arcshine) + +DELETE FROM `gossip_menu` WHERE (`TextID`=33967 AND `MenuID`=22167) OR (`TextID`=42723 AND `MenuID`=26846) OR (`TextID`=37462 AND `MenuID`=23896) OR (`TextID`=33608 AND `MenuID`=21961) OR (`TextID`=33599 AND `MenuID`=21959) OR (`TextID`=33798 AND `MenuID`=22069) OR (`TextID`=33604 AND `MenuID`=21956) OR (`TextID`=37601 AND `MenuID`=23995) OR (`TextID`=10651 AND `MenuID`=23391) OR (`TextID`=37720 AND `MenuID`=24070) OR (`TextID`=37719 AND `MenuID`=24069) OR (`TextID`=34834 AND `MenuID`=22632) OR (`TextID`=37351 AND `MenuID`=23828) OR (`TextID`=17800 AND `MenuID`=13949) OR (`TextID`=36437 AND `MenuID`=23508) OR (`TextID`=18390 AND `MenuID`=13096) OR (`TextID`=5715 AND `MenuID`=13947) OR (`TextID`=5002 AND `MenuID` IN (13946,13955)) OR (`TextID`=17596 AND `MenuID`=12510) OR (`TextID`=16405 AND `MenuID`=11721) OR (`TextID`=16408 AND `MenuID`=11723) OR (`TextID`=17000 AND `MenuID`=12108) OR (`TextID`=17169 AND `MenuID`=12226) OR (`TextID`=16181 AND `MenuID`=11587) OR (`TextID`=17418 AND `MenuID`=12391) OR (`TextID`=27189 AND `MenuID`=18704) OR (`TextID`=6961 AND `MenuID`=12887) OR (`TextID`=15461 AND `MenuID` IN (14265,14189)) OR (`TextID`=5716 AND `MenuID` IN (14206,14124)) OR (`TextID`=5006 AND `MenuID` IN (14207,14134,21342)) OR (`TextID`=27481 AND `MenuID`=18868) OR (`TextID`=20019 AND `MenuID`=14250) OR (`TextID`=563 AND `MenuID`=13967) OR (`TextID`=4984 AND `MenuID`=13970) OR (`TextID`=5720 AND `MenuID` IN (13966,14202)) OR (`TextID`=4796 AND `MenuID`=13969) OR (`TextID`=4439 AND `MenuID` IN (13968,14217,13985,13984)) OR (`TextID`=15526 AND `MenuID`=11156) OR (`TextID`=16989 AND `MenuID`=12101) OR (`TextID`=7778 AND `MenuID`=23507) OR (`TextID`=17211 AND `MenuID`=12250) OR (`TextID`=17210 AND `MenuID`=12249) OR (`TextID`=10455 AND `MenuID`=8380) OR (`TextID`=23967 AND `MenuID`=16503) OR (`TextID`=25090 AND `MenuID`=17076) OR (`TextID`=25100 AND `MenuID`=17086) OR (`TextID`=24826 AND `MenuID`=17018) OR (`TextID`=25685 AND `MenuID`=17313) OR (`TextID`=25478 AND `MenuID`=17232) OR (`TextID`=25511 AND `MenuID`=17237) OR (`TextID`=25180 AND `MenuID`=17132) OR (`TextID`=38121 AND `MenuID`=24305) OR (`TextID`=38122 AND `MenuID`=24306) OR (`TextID`=38123 AND `MenuID`=24307) OR (`TextID`=37391 AND `MenuID`=23850) OR (`TextID`=33580 AND `MenuID`=21949) OR (`TextID`=22576 AND `MenuID`=15719) OR (`TextID`=20579 AND `MenuID`=14833) OR (`TextID`=14126 AND `MenuID` IN (10188,22125)) OR (`TextID`=2593 AND `MenuID`=15153) OR (`TextID`=21614 AND `MenuID`=15108) OR (`TextID`=9850 AND `MenuID` IN (9868,14680)) OR (`TextID`=14125 AND `MenuID`=10188) OR (`TextID`=18785 AND `MenuID`=13282) OR (`TextID`=20690 AND `MenuID`=14629) OR (`TextID`=21107 AND `MenuID`=14933) OR (`TextID`=4440 AND `MenuID` IN (14032,14259)) OR (`TextID`=16579 AND `MenuID`=14203) OR (`TextID`=5135 AND `MenuID`=4142) OR (`TextID`=16491 AND `MenuID`=14180) OR (`TextID`=5129 AND `MenuID`=4140) OR (`TextID`=15197 AND `MenuID`=10936) OR (`TextID`=4998 AND `MenuID`=13997) OR (`TextID`=27475 AND `MenuID`=18866) OR (`TextID`=4794 AND `MenuID` IN (14028,14047,14048,14042)) OR (`TextID`=5393 AND `MenuID`=4241) OR (`TextID`=10650 AND `MenuID` IN (8517,13014)) OR (`TextID`=4993 AND `MenuID`=14041) OR (`TextID`=40347 AND `MenuID`=25426) OR (`TextID`=16870 AND `MenuID`=12040) OR (`TextID`=18046 AND `MenuID`=22124) OR (`TextID`=37697 AND `MenuID`=24056) OR (`TextID`=42407 AND `MenuID`=26685) OR (`TextID`=33868 AND `MenuID`=22117) OR (`TextID`=33885 AND `MenuID`=22121) OR (`TextID`=33862 AND `MenuID`=22114) OR (`TextID`=33998 AND `MenuID`=22190) OR (`TextID`=40637 AND `MenuID`=25721) OR (`TextID`=39570 AND `MenuID` IN (25355,25357)) OR (`TextID`=40153 AND `MenuID`=25354) OR (`TextID`=40147 AND `MenuID`=25348) OR (`TextID`=40145 AND `MenuID`=25346) OR (`TextID`=40144 AND `MenuID`=25345) OR (`TextID`=40152 AND `MenuID`=25353) OR (`TextID`=40148 AND `MenuID`=25350) OR (`TextID`=40155 AND `MenuID`=25356) OR (`TextID`=40146 AND `MenuID`=25347) OR (`TextID`=40156 AND `MenuID`=25357) OR (`TextID`=17181 AND `MenuID`=12235) OR (`TextID`=8379 AND `MenuID`=7117) OR (`TextID`=8375 AND `MenuID`=7116) OR (`TextID`=16489 AND `MenuID`=14181) OR (`TextID`=562 AND `MenuID` IN (13988,13987)) OR (`TextID`=29522 AND `MenuID`=19873) OR (`TextID`=27198 AND `MenuID`=18713) OR (`TextID`=26697 AND `MenuID`=18475) OR (`TextID`=29526 AND `MenuID`=19876) OR (`TextID`=18322 AND `MenuID`=13047) OR (`TextID`=33973 AND `MenuID`=22171) OR (`TextID`=33971 AND `MenuID`=22169) OR (`TextID`=41572 AND `MenuID`=26192) OR (`TextID`=33981 AND `MenuID`=22180) OR (`TextID`=33978 AND `MenuID`=22176) OR (`TextID`=33975 AND `MenuID`=22173) OR (`TextID`=33974 AND `MenuID`=22172) OR (`TextID`=35291 AND `MenuID`=22797) OR (`TextID`=36028 AND `MenuID`=23256) OR (`TextID`=17349 AND `MenuID`=12346) OR (`TextID`=17350 AND `MenuID`=12347) OR (`TextID`=16998 AND `MenuID`=12107) OR (`TextID`=10652 AND `MenuID`=8868) OR (`TextID`=42426 AND `MenuID`=26693) OR (`TextID`=38114 AND `MenuID`=24301) OR (`TextID`=37614 AND `MenuID`=24007) OR (`TextID`=37618 AND `MenuID`=24016) OR (`TextID`=37545 AND `MenuID`=23950) OR (`TextID`=38060 AND `MenuID`=24278) OR (`TextID`=38074 AND `MenuID`=24280) OR (`TextID`=38058 AND `MenuID`=24276) OR (`TextID`=38053 AND `MenuID`=24225) OR (`TextID`=37933 AND `MenuID`=24224) OR (`TextID`=37792 AND `MenuID`=24124) OR (`TextID`=41918 AND `MenuID`=26430) OR (`TextID`=29171 AND `MenuID`=19686) OR (`TextID`=29170 AND `MenuID`=19685) OR (`TextID`=29169 AND `MenuID`=19684) OR (`TextID`=36413 AND `MenuID`=23473) OR (`TextID`=37562 AND `MenuID`=23967) OR (`TextID`=33467 AND `MenuID`=21896) OR (`TextID`=10040 AND `MenuID`=14160) OR (`TextID`=40006 AND `MenuID`=25369) OR (`TextID`=1208 AND `MenuID`=646) OR (`TextID`=40154 AND `MenuID`=25355) OR (`TextID`=39560 AND `MenuID`=25100) OR (`TextID`=39579 AND `MenuID`=25112) OR (`TextID`=23165 AND `MenuID`=16074) OR (`TextID`=2594 AND `MenuID`=16065) OR (`TextID`=41571 AND `MenuID`=26191); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(22167, 33967, 40906), -- 133489 (Ormhun Stonehammer) +(26846, 42723, 38134), -- 177208 (Eppu) +(23896, 37462, 38134), -- 130901 (Chronicler Grazzul) +(21961, 33608, 38134), -- 131506 (Tahku Swampstrider) +(21959, 33599, 38134), -- 131503 (Scout Jumju) +(22069, 33798, 38134), -- 132643 (Fors Aitken) +(21956, 33604, 38134), -- 131502 (Mixin' Mojo Kojo) +(23995, 37601, 38134), -- 122695 (Seshuli) +(23391, 10651, 38134), -- 122702 (Enchantress Quinni) +(24070, 37720, 38134), -- 122700 (Pin'jin the Patient) +(24069, 37719, 38134), -- 122698 (Xanjo) +(22632, 34834, 38134), -- 122703 (Clever Kumali) +(23828, 37351, 38134), -- 131840 (Shuga Blastcaps) +(13949, 17800, 42010), -- 1228 (Magis Sparkmantle) +(23508, 36437, 42010), -- 145462 (Brann Bronzebeard) +(13096, 18390, 42010), -- 54345 (Darkmoon Faire Greeter) +(13947, 5715, 40966), -- 988 (Kartosh) +(13946, 5002, 40966), -- 987 (Ogromm) +(12510, 17596, 40966), -- 49636 (Arcanist Arman) +(11721, 16405, 40966), -- 43098 (Chabal) +(11723, 16408, 40966), -- 43095 (Sassy Hardwrench) +(13955, 5002, 40966), -- 1404 (Kragg) +(12108, 17000, 40966), -- 46236 (High Examiner Tae'thelan Bloodwatcher) +(12226, 17169, 40966), -- 46660 (Aidan Summerwind) +(11587, 16181, 40966), -- 42130 (Gor'mul) +(12391, 17418, 40966), -- 48129 (Helcular) +(18704, 27189, 40966), -- 96368 (Emmara Marie) +(12887, 6961, 40966), -- 4573 (Armand Cromwell) +(14265, 15461, 40966), -- 50609 (Nathanos Blightcaller) +(14189, 15461, 40966), -- 39116 (Apolos) +(14206, 5716, 40966), -- 52319 (Mala Skywatcher) +(14207, 5006, 40966), -- 52317 (Mahala Cloudsong) +(18868, 27481, 40966), -- 97766 (Francis Serbacon) +(14250, 20019, 40966), -- 62393 (Ao Jian) +(13967, 563, 40966), -- 2128 (Cain Firesong) +(13970, 4984, 40966), -- 2131 (Austil de Mon) +(13966, 5720, 40966), -- 2127 (Rupert Boch) +(13969, 4796, 40966), -- 2130 (Marion Call) +(13968, 4439, 40966), -- 2129 (Dark Cleric Beryl) +(11156, 15526, 40966), -- 39117 (Shadow Priestess Malia) +(12101, 16989, 40966), -- 46271 (Provisioner Elda) +(23507, 7778, 40966), -- 44036 (Skymaster Brightdawn) +(12250, 17211, 40966), -- 47361 (Doranir) +(12249, 17210, 40966), -- 47362 (Aelnara) +(8380, 10455, 40966), -- 19775 (Kalinda) +(16503, 23967, 40906), -- 79892 (Mak'jin) +(17076, 25090, 40906), -- 86014 (Murg Stonecrack) +(17086, 25100, 40906), -- 86033 (Reena Cogscrap) +(17018, 24826, 40906), -- 86012 (Han Leaprocket) +(17313, 25685, 40906), -- 88161 (Challenger Sunforge) +(17232, 25478, 40906), -- 86006 (Anthony Allain) +(17237, 25511, 40906), -- 87548 (Kaevan Highwit) +(17132, 25180, 40906), -- 86318 (Zarjhin) +(24305, 38121, 40906), -- 154321 (Jada) +(24306, 38122, 40906), -- 154393 (Narv) +(24307, 38123, 40906), -- 154408 (Rolm) +(23850, 37391, 40906), -- 150318 (Veriss) +(21949, 33580, 40906), -- 131397 (Miju) +(15719, 22576, 44730), -- 66998 (Jinho the Wind Breaker) +(14833, 20579, 44730), -- 64127 (Frances Lin) +(10188, 14126, 44730), -- 64041 (Mifan) +(15153, 2593, 44730), -- 64107 (Sadi) +(15108, 21614, 44730), -- 64582 (Gentle San) +(9868, 9850, 44730), -- 62874 (Kali the Night Watcher) +(10188, 14125, 44730), -- 64605 (Tan Shin Tiao) +(14680, 9850, 44730), -- 64149 (Matron Vi Vinh) +(13282, 18785, 44730), -- 56705 (Singegruff) +(14629, 20690, 44730), -- 65127 (Lai the Spellpaw) +(14933, 21107, 44730), -- 65923 (Ju Applebloom) +(14032, 4440, 44730), -- 3706 (Tai'jin) +(14203, 16579, 44730), -- 44380 (Jabul) +(4142, 5135, 44730), -- 11025 (Mukdrak) +(14124, 5716, 44730), -- 8142 (Jannos Lighthoof) +(14180, 16491, 44730), -- 50035 (Sunwalker Lonaki) +(14259, 4440, 44730), -- 50031 (Zumolo) +(4140, 5129, 44730), -- 3494 (Tinkerwiz) +(10936, 15197, 44730), -- 37679 (Warlord Bloodhilt) +(13997, 4998, 44730), -- 3065 (Yaw Sharpmane) +(18866, 27475, 44730), -- 98222 (Ryno Bloomfield) +(14028, 4794, 44730), -- 3599 (Jannok Breezesong) +(4241, 5393, 44730), -- 4212 (Telonis) +(8517, 10650, 44730), -- 52636 (Tana Lentner) +(14041, 4993, 44730), -- 4146 (Jocaste) +(14047, 4794, 44730), -- 4214 (Erion Shadewhisper) +(14048, 4794, 44730), -- 4215 (Anishar) +(14042, 4794, 44730), -- 4163 (Syurna) +(25426, 40347, 44325), -- 167032 (Chromie) +(12040, 16870, 44325), -- 45563 (Tinza Silvermug) +(22124, 18046, 44325), -- 133261 (Feng Su) +(24056, 37697, 44325), -- 144317 (Mag'har Blademaster) +(14217, 4439, 44325), -- 45339 (Dark Cleric Cecille) +(26685, 42407, 44325), -- 175135 (Rokhan) +(22117, 33868, 44325), -- 133127 (Thaluriel) +(22125, 14126, 44325), -- 133239 (Leyweaver Aurielle) +(22121, 33885, 44325), -- 133114 (Uros Hardhoof) +(22114, 33862, 44325), -- 133104 (Grove Cultivator Kados) +(22190, 33998, 44325), -- 133185 (Wildswalker Nightborne) +(25721, 40637, 44325), -- 168540 (Rohaka Tuskmaul) +(25355, 39570, 44325), -- 168626 (Feenix Arcshine) +(25354, 40153, 44325), -- 168619 (Huinli Wingpaw) +(25348, 40147, 44325), -- 168598 (Thega Graveblade) +(25346, 40145, 44325), -- 168623 (Kazak Darkscream) +(25345, 40144, 44325), -- 168596 (Gormok Ogrefist) +(25353, 40152, 44325), -- 168597 (Avaros Dawnglaive) +(25350, 40148, 44325), -- 168621 (Martin Goodchilde) +(25356, 40155, 44325), -- 168551 (Tamanji) +(25347, 40146, 44325), -- 168628 (Hretar Riverspeaker) +(25357, 40156, 44325), -- 168553 (Telotha Pinegrove) +(12235, 17181, 44325), -- 47253 (Rundok) +(14134, 5006, 44325), -- 13417 (Sagorne Creststrider) +(7117, 8379, 44325), -- 16147 (Elisara Sunstriker) +(7116, 8375, 44325), -- 16144 (Lord Saltheril) +(14181, 16489, 44325), -- 43870 (Seer Beryl) +(13014, 10650, 44325), -- 52651 (Engineer Palehoof) +(21342, 5006, 44325), -- 51639 (Kador Cloudsong) +(13985, 4439, 44325), -- 3045 (Malakai Cross) +(13988, 562, 44325), -- 3048 (Ursyn Ghull) +(14202, 5720, 44325), -- 43883 (Jensen Thomasson) +(13987, 562, 44325), -- 3047 (Archmage Shymm) +(13984, 4439, 44325), -- 3044 (Miles Welsh) +(19873, 29522, 40906), -- 108825 (Conjurer Margoss) +(18713, 27198, 40906), -- 92265 (Urael) +(18475, 26697, 40906), -- 92264 (Felsmith Nal'ryssa) +(19876, 29526, 40906), -- 108925 (Lord Adder) +(13047, 18322, 40906), -- 27344 (Adeline Chambers) +(22171, 33973, 38134), -- 133363 (Aevedos) +(22169, 33971, 38134), -- 133396 (Jandros Terres) +(26192, 41572, 38134), -- 172572 (Celeste Periwinkle) +(22180, 33981, 38134), -- 133394 (Elestrae Dawnshard) +(22176, 33978, 38134), -- 133322 (Elya) +(22173, 33975, 38134), -- 133326 (Artificer Farud) +(22172, 33974, 38134), -- 133332 (Statiks Quikfuse) +(22797, 35291, 38134), -- 136061 (Camilla Darksky) +(23256, 36028, 38134), -- 136106 (Jane Hudson) +(12346, 17349, 44730), -- 46274 (Gaffer Coilspring) +(12347, 17350, 44730), -- 47250 (Carvo Blastbolt) +(12107, 16998, 44730), -- 45966 (Nevin Twistwrench) +(8868, 10652, 44730), -- 16729 (Refik) +(26693, 42426, 40906), -- 162666 (Pathscribe Roh-Avonavi) +(24301, 38114, 40906), -- 151462 (Danielle Anglers) +(24007, 37614, 40906), -- 151462 (Danielle Anglers) +(24016, 37618, 40906), -- 151462 (Danielle Anglers) +(23950, 37545, 40906), -- 150631 (Pristy Quickcharge) +(24278, 38060, 40906), -- 150631 (Pristy Quickcharge) +(24280, 38074, 40906), -- 150631 (Pristy Quickcharge) +(24276, 38058, 40906), -- 150631 (Pristy Quickcharge) +(24225, 38053, 40906), -- 150631 (Pristy Quickcharge) +(24224, 37933, 40906), -- 150630 (Flip Quickcharge) +(24124, 37792, 40906), -- 152506 (Captain Krooz) +(26430, 41918, 38134), -- 173819 (Reckful) +(19686, 29171, 38134), -- 107196 (Bishop Arthur) +(19685, 29170, 38134), -- 107196 (Bishop Arthur) +(19684, 29169, 38134), -- 107196 (Bishop Arthur) +(23473, 36413, 38134), -- 112958 (Soulare of Andorhal) +(23967, 37562, 38134), -- 151287 (Telonis) +(21896, 33467, 38134), -- 16908 (Arielle Snapflash) +(14160, 10040, 38134), -- 20407 (Farseer Umbrua) +(25369, 40006, 38134), -- 165505 (Loretta Banks) +(646, 1208, 38134), -- 5482 (Stephen Ryback) +(25355, 40154, 38134), -- 164955 (Frazzle Frostfingers) +(25100, 39560, 38134), -- 163007 (Curly) +(25112, 39579, 38134), -- 168553 (Telotha Pinegrove) +(25357, 39570, 38134), -- 168553 (Telotha Pinegrove) +(16074, 23165, 38134), -- 74228 (Darkspear Headhunter) +(16065, 2594, 38134), -- 74228 (Darkspear Headhunter) +(26191, 41571, 38134); -- 172558 (Eyla Pathleader) + +UPDATE `gossip_menu` SET `VerifiedBuild`=40906 WHERE (`TextID`=10653 AND `MenuID`=10361) OR (`TextID`=9546 AND `MenuID` IN (7818,7816,8434)) OR (`TextID`=10846 AND `MenuID`=8646) OR (`TextID`=33584 AND `MenuID`=21951) OR (`TextID`=16706 AND `MenuID`=10350) OR (`TextID`=13845 AND `MenuID`=9990) OR (`TextID`=5674 AND `MenuID`=4463) OR (`TextID`=9384 AND `MenuID`=10351) OR (`TextID`=13581 AND `MenuID`=9831) OR (`TextID`=13702 AND `MenuID`=9879) OR (`TextID`=13449 AND `MenuID`=9772); +UPDATE `gossip_menu` SET `VerifiedBuild`=42010 WHERE (`MenuID`=7691 AND `TextID`=9385) OR (`MenuID`=7815 AND `TextID`=10846) OR (`MenuID`=7690 AND `TextID`=9384) OR (`MenuID`=11821 AND `TextID`=16573) OR (`MenuID`=5665 AND `TextID`=6961) OR (`MenuID`=12180 AND `TextID`=17125) OR (`MenuID`=4783 AND `TextID`=5839); +UPDATE `gossip_menu` SET `VerifiedBuild`=44325 WHERE (`TextID`=7176 AND `MenuID`=6024) OR (`TextID`=16997 AND `MenuID`=12106) OR (`TextID`=5551 AND `MenuID`=4351) OR (`TextID`=2518 AND `MenuID`=1871) OR (`TextID`=2594 AND `MenuID`=1942) OR (`TextID`=2593 AND `MenuID`=1951) OR (`TextID`=26402 AND `MenuID`=18346) OR (`TextID`=17499 AND `MenuID`=12443) OR (`TextID`=20326 AND `MenuID`=14991) OR (`TextID`=5136 AND `MenuID`=4143) OR (`TextID`=5157 AND `MenuID`=4148) OR (`TextID`=1571 AND `MenuID`=980) OR (`TextID`=5172 AND `MenuID`=4151) OR (`TextID`=17999 AND `MenuID`=12803) OR (`TextID`=5799 AND `MenuID`=4747) OR (`TextID`=9384 AND `MenuID`=7690) OR (`TextID`=563 AND `MenuID`=22787) OR (`TextID`=14723 AND `MenuID`=10630) OR (`TextID`=17946 AND `MenuID`=12760) OR (`TextID`=17445 AND `MenuID`=12410) OR (`TextID`=9186 AND `MenuID` IN (14139,6649)) OR (`TextID`=8790 AND `MenuID`=7359) OR (`TextID`=17302 AND `MenuID`=12308) OR (`TextID`=13583 AND `MenuID`=9832) OR (`TextID`=2278 AND `MenuID`=1624) OR (`TextID`=13584 AND `MenuID`=9821) OR (`TextID`=17494 AND `MenuID`=12439) OR (`TextID`=16965 AND `MenuID`=12085) OR (`TextID`=16961 AND `MenuID`=12084) OR (`TextID`=16734 AND `MenuID`=11919) OR (`TextID`=9385 AND `MenuID`=7691) OR (`TextID`=5839 AND `MenuID`=4783) OR (`TextID`=5841 AND `MenuID`=3161) OR (`TextID`=16413 AND `MenuID`=11726) OR (`TextID`=5793 AND `MenuID`=4741) OR (`TextID`=22257 AND `MenuID`=15500) OR (`TextID`=10846 AND `MenuID` IN (7815,8646)) OR (`TextID`=13702 AND `MenuID`=12642) OR (`TextID`=3954 AND `MenuID`=3187) OR (`TextID`=3412 AND `MenuID`=2747) OR (`TextID`=1606 AND `MenuID`=1012) OR (`TextID`=3466 AND `MenuID`=2782) OR (`TextID`=4513 AND `MenuID`=3701) OR (`TextID`=12549 AND `MenuID`=12670) OR (`TextID`=16901 AND `MenuID`=12056) OR (`TextID`=10654 AND `MenuID`=8521) OR (`TextID`=17031 AND `MenuID`=12125) OR (`TextID`=822 AND `MenuID`=344) OR (`TextID`=17941 AND `MenuID`=12759) OR (`TextID`=5530 AND `MenuID`=4347) OR (`TextID`=5425 AND `MenuID`=4265) OR (`TextID`=5279 AND `MenuID`=4183) OR (`TextID`=5350 AND `MenuID`=4209) OR (`TextID`=2822 AND `MenuID`=2189) OR (`TextID`=5037 AND `MenuID`=4118) OR (`TextID`=5069 AND `MenuID`=4126) OR (`TextID`=5238 AND `MenuID`=4168) OR (`TextID`=5199 AND `MenuID`=4159) OR (`TextID`=7403 AND `MenuID`=6229) OR (`TextID`=16258 AND `MenuID`=11637) OR (`TextID`=8232 AND `MenuID`=6942) OR (`TextID`=8576 AND `MenuID`=7256) OR (`TextID`=8679 AND `MenuID`=7311) OR (`TextID`=8552 AND `MenuID`=7244) OR (`TextID`=8759 AND `MenuID`=7346) OR (`TextID`=9124 AND `MenuID`=7524) OR (`TextID`=10180 AND `MenuID`=8185) OR (`TextID`=14126 AND `MenuID`=10181) OR (`TextID`=8699 AND `MenuID`=7324) OR (`TextID`=8682 AND `MenuID`=7313) OR (`TextID`=9187 AND `MenuID`=14140) OR (`TextID`=9193 AND `MenuID`=14137) OR (`TextID`=16540 AND `MenuID`=14199) OR (`TextID`=9189 AND `MenuID`=14144) OR (`TextID`=8229 AND `MenuID`=6940) OR (`TextID`=10451 AND `MenuID`=8376) OR (`TextID`=9192 AND `MenuID`=14136) OR (`TextID`=9185 AND `MenuID`=14142) OR (`TextID`=7028 AND `MenuID`=5856) OR (`TextID`=17127 AND `MenuID`=12186) OR (`TextID`=17125 AND `MenuID`=12180) OR (`TextID`=17138 AND `MenuID`=12199) OR (`TextID`=17137 AND `MenuID`=12198) OR (`TextID`=17136 AND `MenuID`=12197) OR (`TextID`=17135 AND `MenuID`=12196) OR (`TextID`=17134 AND `MenuID`=12195) OR (`TextID`=17133 AND `MenuID`=12193) OR (`TextID`=17132 AND `MenuID`=12192) OR (`TextID`=17131 AND `MenuID`=12191) OR (`TextID`=17126 AND `MenuID`=12185) OR (`TextID`=17130 AND `MenuID`=12190) OR (`TextID`=17129 AND `MenuID`=12189) OR (`TextID`=17128 AND `MenuID`=12188) OR (`TextID`=7015 AND `MenuID`=5854) OR (`TextID`=7872 AND `MenuID`=6620) OR (`TextID`=8403 AND `MenuID`=7141) OR (`TextID`=10305 AND `MenuID`=8098) OR (`TextID`=17608 AND `MenuID`=12520) OR (`TextID`=8412 AND `MenuID`=7148) OR (`TextID`=10886 AND `MenuID`=8658) OR (`TextID`=11459 AND `MenuID`=8829) OR (`TextID`=8618 AND `MenuID`=7288) OR (`TextID`=6961 AND `MenuID`=5665) OR (`TextID`=11049 AND `MenuID`=8732) OR (`TextID`=9599 AND `MenuID`=7842) OR (`TextID`=10454 AND `MenuID`=8379) OR (`TextID`=9577 AND `MenuID`=7828) OR (`TextID`=8549 AND `MenuID`=7243) OR (`TextID`=16573 AND `MenuID`=11821) OR (`TextID`=19889 AND `MenuID`=13895) OR (`TextID`=9084 AND `MenuID`=7494) OR (`TextID`=11055 AND `MenuID`=8733) OR (`TextID`=11045 AND `MenuID`=8731) OR (`TextID`=11458 AND `MenuID`=8828) OR (`TextID`=5880 AND `MenuID`=4824) OR (`TextID`=3415 AND `MenuID`=2748) OR (`TextID`=1615 AND `MenuID`=1017) OR (`TextID`=5497 AND `MenuID`=4325) OR (`TextID`=5079 AND `MenuID`=4128) OR (`TextID`=5040 AND `MenuID`=4119) OR (`TextID`=5223 AND `MenuID`=4165) OR (`TextID`=5196 AND `MenuID`=4158) OR (`TextID`=5340 AND `MenuID`=4207) OR (`TextID`=5428 AND `MenuID`=4266) OR (`TextID`=5398 AND `MenuID`=4242) OR (`TextID`=1272 AND `MenuID`=721) OR (`TextID`=14622 AND `MenuID`=10566) OR (`TextID`=5881 AND `MenuID`=4825) OR (`TextID`=24306 AND `MenuID`=16723) OR (`TextID`=5886 AND `MenuID`=4827) OR (`TextID`=12926 AND `MenuID`=9578) OR (`TextID`=10275 AND `MenuID`=8254) OR (`TextID`=9546 AND `MenuID` IN (7817,7820,7818,7810,7879)) OR (`TextID`=10707 AND `MenuID`=8554) OR (`TextID`=10683 AND `MenuID`=8539) OR (`TextID`=10682 AND `MenuID`=8538) OR (`TextID`=8712 AND `MenuID`=7328) OR (`TextID`=8771 AND `MenuID`=7351) OR (`TextID`=9021 AND `MenuID`=7448) OR (`TextID`=9656 AND `MenuID`=7892) OR (`TextID`=9944 AND `MenuID`=7352) OR (`TextID`=9575 AND `MenuID`=7826) OR (`TextID`=9868 AND `MenuID`=8002) OR (`TextID`=8658 AND `MenuID`=7301) OR (`TextID`=8688 AND `MenuID`=7320) OR (`TextID`=7778 AND `MenuID`=6944) OR (`TextID`=9647 AND `MenuID`=7884) OR (`TextID`=8858 AND `MenuID`=7396) OR (`TextID`=8852 AND `MenuID`=7391) OR (`TextID`=8851 AND `MenuID`=7390) OR (`TextID`=8854 AND `MenuID`=7393) OR (`TextID`=8853 AND `MenuID`=7392) OR (`TextID`=9646 AND `MenuID`=7883) OR (`TextID`=8792 AND `MenuID`=7360) OR (`TextID`=9051 AND `MenuID`=7948) OR (`TextID`=8754 AND `MenuID`=7343) OR (`TextID`=9109 AND `MenuID`=7512) OR (`TextID`=10808 AND `MenuID`=8622) OR (`TextID`=823 AND `MenuID`=9113) OR (`TextID`=10491 AND `MenuID`=8392) OR (`TextID`=10468 AND `MenuID`=8387) OR (`TextID`=9805 AND `MenuID`=7973); +UPDATE `gossip_menu` SET `VerifiedBuild`=44730 WHERE (`TextID`=16705 AND `MenuID`=10362) OR (`TextID`=20589 AND `MenuID`=14566) OR (`TextID`=16573 AND `MenuID`=11821) OR (`TextID`=20124 AND `MenuID`=14278) OR (`TextID`=20540 AND `MenuID`=14529) OR (`TextID`=21205 AND `MenuID`=14996) OR (`TextID`=20203 AND `MenuID`=14310) OR (`TextID`=20691 AND `MenuID`=14630) OR (`TextID`=20335 AND `MenuID`=14409) OR (`TextID`=20619 AND `MenuID`=14582) OR (`TextID`=22992 AND `MenuID`=15967) OR (`TextID`=23979 AND `MenuID`=16509) OR (`TextID`=20676 AND `MenuID`=14615) OR (`TextID`=22539 AND `MenuID`=15690) OR (`TextID`=21614 AND `MenuID`=15107) OR (`TextID`=933 AND `MenuID`=15152) OR (`TextID`=20943 AND `MenuID`=10656) OR (`TextID`=22576 AND `MenuID`=15718) OR (`TextID`=20948 AND `MenuID`=14803) OR (`TextID`=20947 AND `MenuID`=14802) OR (`TextID`=14125 AND `MenuID`=10183) OR (`TextID`=22968 AND `MenuID`=15952) OR (`TextID`=20579 AND `MenuID`=14558) OR (`TextID`=22974 AND `MenuID`=15956) OR (`TextID`=20970 AND `MenuID`=14818) OR (`TextID`=20989 AND `MenuID`=14829) OR (`TextID`=20985 AND `MenuID`=14825) OR (`TextID`=20957 AND `MenuID`=14808) OR (`TextID`=20960 AND `MenuID`=14810) OR (`TextID`=20986 AND `MenuID`=14826) OR (`TextID`=20990 AND `MenuID`=14830) OR (`TextID`=20988 AND `MenuID`=14828) OR (`TextID`=20987 AND `MenuID`=14827) OR (`TextID`=22376 AND `MenuID`=15579) OR (`TextID`=19526 AND `MenuID`=13609) OR (`TextID`=20622 AND `MenuID`=14584) OR (`TextID`=20621 AND `MenuID`=14583) OR (`TextID`=20618 AND `MenuID`=14581) OR (`TextID`=19562 AND `MenuID`=13642) OR (`TextID`=19513 AND `MenuID`=13608) OR (`TextID`=19179 AND `MenuID`=13470) OR (`TextID`=20620 AND `MenuID`=14422) OR (`TextID`=20624 AND `MenuID` IN (14585,14379)) OR (`TextID`=19406 AND `MenuID`=13584) OR (`TextID`=18900 AND `MenuID`=13343) OR (`TextID`=20932 AND `MenuID`=14795) OR (`TextID`=20227 AND `MenuID`=14324) OR (`TextID`=20224 AND `MenuID`=14323) OR (`TextID`=19074 AND `MenuID`=13420) OR (`TextID`=19075 AND `MenuID`=13421) OR (`TextID`=19078 AND `MenuID`=13423) OR (`TextID`=20703 AND `MenuID`=14641) OR (`TextID`=22050 AND `MenuID`=15365) OR (`TextID`=32996 AND `MenuID`=21666) OR (`TextID`=19342 AND `MenuID`=13554) OR (`TextID`=20663 AND `MenuID`=14605) OR (`TextID`=20538 AND `MenuID`=14528) OR (`TextID`=20941 AND `MenuID`=14800) OR (`TextID`=14127 AND `MenuID`=10182) OR (`TextID`=20696 AND `MenuID`=14635) OR (`TextID`=18794 AND `MenuID`=13291) OR (`TextID`=20687 AND `MenuID`=14626) OR (`TextID`=20689 AND `MenuID`=14628) OR (`TextID`=20183 AND `MenuID`=13296) OR (`TextID`=18786 AND `MenuID`=13283) OR (`TextID`=19863 AND `MenuID`=13782) OR (`TextID`=18787 AND `MenuID`=13284) OR (`TextID`=19277 AND `MenuID`=13530) OR (`TextID`=19332 AND `MenuID`=13547) OR (`TextID`=20685 AND `MenuID`=14624) OR (`TextID`=18792 AND `MenuID`=13288) OR (`TextID`=20686 AND `MenuID`=14625) OR (`TextID`=21501 AND `MenuID`=15100) OR (`TextID`=21499 AND `MenuID`=15098) OR (`TextID`=21500 AND `MenuID`=15099) OR (`TextID`=7028 AND `MenuID` IN (8522,5856,5855)) OR (`TextID`=21090 AND `MenuID`=14919) OR (`TextID`=21089 AND `MenuID`=14918) OR (`TextID`=21091 AND `MenuID`=14920) OR (`TextID`=25570 AND `MenuID`=17277) OR (`TextID`=25519 AND `MenuID`=17245) OR (`TextID`=24983 AND `MenuID`=17049) OR (`TextID`=25786 AND `MenuID`=17334) OR (`TextID`=25248 AND `MenuID`=17156) OR (`TextID`=24982 AND `MenuID`=17048) OR (`TextID`=24981 AND `MenuID`=17047) OR (`TextID`=25172 AND `MenuID`=17126) OR (`TextID`=25249 AND `MenuID`=17157) OR (`TextID`=25555 AND `MenuID`=17268) OR (`TextID`=25178 AND `MenuID`=17131) OR (`TextID`=25176 AND `MenuID`=17130) OR (`TextID`=25685 AND `MenuID`=17312) OR (`TextID`=24955 AND `MenuID`=17044) OR (`TextID`=26967 AND `MenuID`=18324) OR (`TextID`=24975 AND `MenuID`=17046) OR (`TextID`=5879 AND `MenuID`=4824) OR (`TextID`=25277 AND `MenuID`=17183) OR (`TextID`=31799 AND `MenuID`=21043) OR (`TextID`=25276 AND `MenuID`=17182) OR (`TextID`=25236 AND `MenuID`=17148) OR (`TextID`=25635 AND `MenuID`=17294) OR (`TextID`=25243 AND `MenuID`=17152) OR (`TextID`=25275 AND `MenuID`=17181) OR (`TextID`=25244 AND `MenuID`=17153) OR (`TextID`=25273 AND `MenuID`=17179) OR (`TextID`=25272 AND `MenuID`=17178) OR (`TextID`=24851 AND `MenuID`=17032) OR (`TextID`=6961 AND `MenuID`=5665) OR (`TextID`=8123 AND `MenuID`=6800) OR (`TextID`=4753 AND `MenuID`=3901) OR (`TextID`=3794 AND `MenuID`=3062) OR (`TextID`=5006 AND `MenuID`=14008) OR (`TextID`=20326 AND `MenuID`=14991) OR (`TextID`=14126 AND `MenuID`=10181) OR (`TextID`=550001 AND `MenuID`=16168) OR (`TextID`=7778 AND `MenuID` IN (6944,11885)) OR (`TextID`=12549 AND `MenuID`=12670) OR (`TextID`=3409 AND `MenuID`=2746) OR (`TextID`=5335 AND `MenuID`=4842) OR (`TextID`=14897 AND `MenuID`=10735) OR (`TextID`=21185 AND `MenuID`=14987) OR (`TextID`=14942 AND `MenuID`=10778) OR (`TextID`=14873 AND `MenuID`=10715) OR (`TextID`=13584 AND `MenuID`=9821) OR (`TextID`=6533 AND `MenuID`=5481) OR (`TextID`=5212 AND `MenuID`=4162) OR (`TextID`=4959 AND `MenuID`=4066) OR (`TextID`=4891 AND `MenuID`=4025) OR (`TextID`=5407 AND `MenuID`=4244) OR (`TextID`=9385 AND `MenuID`=7691) OR (`TextID`=5440 AND `MenuID`=4270) OR (`TextID`=3471 AND `MenuID`=2783) OR (`TextID`=5496 AND `MenuID`=4324) OR (`TextID`=5515 AND `MenuID`=4341) OR (`TextID`=4793 AND `MenuID`=14226) OR (`TextID`=2133 AND `MenuID`=1465) OR (`TextID`=14612 AND `MenuID`=10556) OR (`TextID`=825 AND `MenuID`=349) OR (`TextID`=15302 AND `MenuID`=11004) OR (`TextID`=5545 AND `MenuID`=4350) OR (`TextID`=5843 AND `MenuID`=4006) OR (`TextID`=4443 AND `MenuID`=3646) OR (`TextID`=4072 AND `MenuID`=3331) OR (`TextID`=17125 AND `MenuID`=12180) OR (`TextID`=5285 AND `MenuID`=4185) OR (`TextID`=7015 AND `MenuID` IN (5854,5853)) OR (`TextID`=5839 AND `MenuID`=4783) OR (`TextID`=10062 AND `MenuID`=8124) OR (`TextID`=15561 AND `MenuID`=11180) OR (`TextID`=2138 AND `MenuID`=1469) OR (`TextID`=5798 AND `MenuID`=4746) OR (`TextID`=5177 AND `MenuID`=4152) OR (`TextID`=2954 AND `MenuID`=2242) OR (`TextID`=15532 AND `MenuID`=11160) OR (`TextID`=15385 AND `MenuID`=11066) OR (`TextID`=16424 AND `MenuID`=11731) OR (`TextID`=2639 AND `MenuID`=1965) OR (`TextID`=27173 AND `MenuID`=18692) OR (`TextID`=5218 AND `MenuID`=4164) OR (`TextID`=5104 AND `MenuID`=4133) OR (`TextID`=824 AND `MenuID`=1581) OR (`TextID`=15719 AND `MenuID`=11284) OR (`TextID`=15821 AND `MenuID`=11353) OR (`TextID`=15838 AND `MenuID`=11364) OR (`TextID`=15845 AND `MenuID`=11374) OR (`TextID`=18050 AND `MenuID`=12842) OR (`TextID`=18070 AND `MenuID`=12846) OR (`TextID`=11224 AND `MenuID`=8782) OR (`TextID`=5855 AND `MenuID`=4004) OR (`TextID`=5571 AND `MenuID`=4355) OR (`TextID`=11376 AND `MenuID`=8826) OR (`TextID`=18072 AND `MenuID`=12848) OR (`TextID`=18074 AND `MenuID`=12850) OR (`TextID`=11136 AND `MenuID`=8762) OR (`TextID`=3157 AND `MenuID`=2465) OR (`TextID`=18064 AND `MenuID`=12844) OR (`TextID`=18063 AND `MenuID`=12843) OR (`TextID`=4837 AND `MenuID`=12517) OR (`TextID`=1794 AND `MenuID`=1162) OR (`TextID`=1793 AND `MenuID`=1161) OR (`TextID`=4991 AND `MenuID`=14123) OR (`TextID`=6415 AND `MenuID`=5382) OR (`TextID`=18071 AND `MenuID`=12847) OR (`TextID`=18076 AND `MenuID`=12852) OR (`TextID`=1058 AND `MenuID`=541) OR (`TextID`=5360 AND `MenuID`=4211) OR (`TextID`=14351 AND `MenuID`=10341) OR (`TextID`=5473 AND `MenuID`=4301) OR (`TextID`=9384 AND `MenuID`=7690) OR (`TextID`=10652 AND `MenuID`=8519) OR (`TextID`=5121 AND `MenuID`=4138) OR (`TextID`=17859 AND `MenuID`=12725) OR (`TextID`=14508 AND `MenuID`=10482) OR (`TextID`=17861 AND `MenuID`=12726) OR (`TextID`=10654 AND `MenuID`=8521) OR (`TextID`=5725 AND `MenuID`=14255) OR (`TextID`=5474 AND `MenuID`=4302) OR (`TextID`=5265 AND `MenuID`=4174) OR (`TextID`=5190 AND `MenuID`=4156) OR (`TextID`=22593 AND `MenuID`=15733) OR (`TextID`=4316 AND `MenuID`=3580) OR (`TextID`=16510 AND `MenuID`=11778) OR (`TextID`=2676 AND `MenuID`=2021) OR (`TextID`=3039 AND `MenuID`=2350) OR (`TextID`=3034 AND `MenuID`=2351) OR (`TextID`=3016 AND `MenuID`=2352) OR (`TextID`=3038 AND `MenuID`=2349) OR (`TextID`=17318 AND `MenuID`=12323) OR (`TextID`=17967 AND `MenuID`=12778) OR (`TextID`=3036 AND `MenuID`=2345) OR (`TextID`=5325 AND `MenuID`=4204) OR (`TextID`=5273 AND `MenuID`=4181) OR (`TextID`=5437 AND `MenuID`=4269) OR (`TextID`=5540 AND `MenuID`=4349) OR (`TextID`=5064 AND `MenuID`=4125) OR (`TextID`=5094 AND `MenuID`=4131) OR (`TextID`=5025 AND `MenuID`=4114) OR (`TextID`=5213 AND `MenuID`=4163) OR (`TextID`=5187 AND `MenuID`=4155) OR (`TextID`=10846 AND `MenuID`=7815) OR (`TextID`=1249 AND `MenuID`=698) OR (`TextID`=3942 AND `MenuID`=3185) OR (`TextID`=5475 AND `MenuID`=4303) OR (`TextID`=9053 AND `MenuID`=7470) OR (`TextID`=5403 AND `MenuID`=4243) OR (`TextID`=823 AND `MenuID`=345) OR (`TextID`=16975 AND `MenuID`=12091) OR (`TextID`=16393 AND `MenuID`=11714) OR (`TextID`=12638 AND `MenuID`=9338) OR (`TextID`=12144 AND `MenuID`=8991) OR (`TextID`=13839 AND `MenuID`=9985) OR (`TextID`=14042 AND `MenuID`=10116) OR (`TextID`=13458 AND `MenuID`=9780) OR (`TextID`=13702 AND `MenuID`=9879) OR (`TextID`=11287 AND `MenuID`=8803) OR (`TextID`=11297 AND `MenuID`=8808) OR (`TextID`=11291 AND `MenuID`=15135) OR (`TextID`=13737 AND `MenuID`=9894) OR (`TextID`=13004 AND `MenuID`=9618) OR (`TextID`=11285 AND `MenuID`=8802) OR (`TextID`=12097 AND `MenuID`=8966) OR (`TextID`=13734 AND `MenuID`=9892) OR (`TextID`=14040 AND `MenuID`=10114) OR (`TextID`=13840 AND `MenuID`=9986) OR (`TextID`=12534 AND `MenuID`=9223) OR (`TextID`=12529 AND `MenuID`=9218) OR (`TextID`=12554 AND `MenuID`=9246) OR (`TextID`=12553 AND `MenuID`=9245) OR (`TextID`=13132 AND `MenuID`=9683) OR (`TextID`=13804 AND `MenuID`=9929) OR (`TextID`=13794 AND `MenuID`=9920) OR (`TextID`=14197 AND `MenuID`=10214) OR (`TextID`=13793 AND `MenuID`=9919) OR (`TextID`=14882 AND `MenuID`=10723) OR (`TextID`=16215 AND `MenuID`=11614) OR (`TextID`=19889 AND `MenuID`=13800) OR (`TextID`=16995 AND `MenuID`=12104) OR (`TextID`=9029 AND `MenuID`=7455) OR (`TextID`=9034 AND `MenuID`=7459) OR (`TextID`=8592 AND `MenuID`=14153) OR (`TextID`=9042 AND `MenuID`=7463) OR (`TextID`=9134 AND `MenuID`=7531) OR (`TextID`=9586 AND `MenuID`=7833) OR (`TextID`=9077 AND `MenuID`=7489) OR (`TextID`=9117 AND `MenuID`=7517) OR (`TextID`=9044 AND `MenuID`=7465) OR (`TextID`=9584 AND `MenuID`=7832) OR (`TextID`=9025 AND `MenuID`=7452) OR (`TextID`=9036 AND `MenuID`=7460) OR (`TextID`=8586 AND `MenuID`=14145) OR (`TextID`=10258 AND `MenuID`=8243) OR (`TextID`=8992 AND `MenuID`=7430) OR (`TextID`=8991 AND `MenuID`=7429) OR (`TextID`=8997 AND `MenuID`=7434) OR (`TextID`=8996 AND `MenuID`=7433) OR (`TextID`=8993 AND `MenuID`=7431) OR (`TextID`=8994 AND `MenuID`=7432) OR (`TextID`=10066 AND `MenuID`=8129) OR (`TextID`=8588 AND `MenuID`=14149) OR (`TextID`=8785 AND `MenuID`=14157) OR (`TextID`=8840 AND `MenuID`=7383) OR (`TextID`=8844 AND `MenuID`=7384) OR (`TextID`=8835 AND `MenuID`=7380) OR (`TextID`=8978 AND `MenuID`=7426) OR (`TextID`=8867 AND `MenuID`=7400) OR (`TextID`=8861 AND `MenuID`=7398) OR (`TextID`=8864 AND `MenuID`=7399) OR (`TextID`=8849 AND `MenuID`=7388) OR (`TextID`=8850 AND `MenuID`=7389) OR (`TextID`=8793 AND `MenuID`=7361) OR (`TextID`=8983 AND `MenuID` IN (7433,7434,7429,7430)) OR (`TextID`=10501 AND `MenuID`=8399) OR (`TextID`=9555 AND `MenuID`=7788) OR (`TextID`=9551 AND `MenuID`=7777) OR (`TextID`=9622 AND `MenuID`=7859) OR (`TextID`=9623 AND `MenuID`=7858) OR (`TextID`=10651 AND `MenuID`=8866) OR (`TextID`=10458 AND `MenuID`=8382) OR (`TextID`=10457 AND `MenuID`=8381) OR (`TextID`=13583 AND `MenuID`=9832) OR (`TextID`=10650 AND `MenuID`=8867) OR (`TextID`=9599 AND `MenuID`=7842) OR (`TextID`=9532 AND `MenuID`=7797) OR (`TextID`=8953 AND `MenuID`=7414) OR (`TextID`=10649 AND `MenuID`=8863) OR (`TextID`=9527 AND `MenuID`=7796); |