Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4

2 files changed, 259 insertions, 0 deletions

diff --git a/sql/updates/world/2014_04_26_02_world_misc.sql b/sql/updates/world/2014_04_26_02_world_misc.sql
new file mode 100644
index 00000000000..c552bdbf8ae
--- /dev/null
+++ b/sql/updates/world/2014_04_26_02_world_misc.sql
@@ -0,0 +1,58 @@
+SET @CGUID := 76265;
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+12;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(@CGUID+0, 29, 607, 3, 193, 841.921, -134.194, 196.838, 6.23082, 7200, 0, 0),
+
+(@CGUID+1, 15214, 607, 3, 193, 1230.2, -67.941, 83.7716, 4.08407, 7200, 0, 0),
+(@CGUID+2, 15214, 607, 3, 193, 1611.57, 73.0032, 8.14356, 2.05949, 7200, 0, 0),
+(@CGUID+3, 15214, 607, 3, 193, 1623.94, -96.5658, 12.5011, 4.4855, 7200, 0, 0),
+
+(@CGUID+4, 22515, 607, 3, 193, 1351.07, -87.6424, 43.4303, 0.191986, 7200, 0, 0),
+(@CGUID+5, 22515, 607, 3, 193, 1357.35, -37.702, 46.4816, 5.3058, 7200, 0, 0),
+(@CGUID+6, 22515, 607, 3, 193, 1363.41, -85.741, 48.9664, 0.593412, 7200, 0, 0),
+(@CGUID+7, 22515, 607, 3, 193, 1364.28, -34.382, 42.9869, 4.7822, 7200, 0, 0),
+
+(@CGUID+8, 23472, 607, 3, 193, 1043.52, -87.8507, 87.197, 2.96706, 7200, 0, 0),
+(@CGUID+9, 23472, 607, 3, 193, 1193.76, 69.9405, 58.1295, 2.49582, 7200, 0, 0),
+(@CGUID+10, 23472, 607, 3, 193, 1227.89, -235.458, 60.1112, 3.40339, 7200, 0, 0),
+(@CGUID+11, 23472, 607, 3, 193, 1389.06, 102.941, 34.5742, 2.16421, 7200, 0, 0),
+(@CGUID+12, 23472, 607, 3, 193, 1441.08, -240.594, 35.3471, 4.03171, 7200, 0, 0);
+
+
+DELETE FROM `creature_text` WHERE `entry` IN (29, 29260, 29262, 22515);
+INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES
+(29, 1, 0, 'Let the battle for the Strand of the Ancients begin!', 41, 0, 100, 0, 0, 0, 'Kanrethad', 28844),
+(29, 2, 0, 'Round 1 - Finished!', 41, 0, 100, 0, 0, 0, 'Kanrethad', 28989),
+
+(29260, 1, 0, 'Sparklight''s vehicle emporium is open for business!', 14, 0, 100, 0, 0, 0, 'Rigger Sparklight', 30230),
+(29262, 1, 0, 'Rigspark''s vehicle shop is open for business!', 14, 0, 100, 0, 0, 0, 'Gorgril Rigspark', 30229),
+
+(22515, 1, 0, 'The Gate of the Blue Sapphire is under attack!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The Gate of the Blue Sapphire is under attack', 29296),
+(22515, 2, 0, 'The Gate of the Green Emerald is under attack!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The Gate of the Green Emerald is under attack', 29297),
+(22515, 3, 0, 'The Gate of the Red Sun is under attack!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The Gate of the Red Sun is under attack', 29298),
+(22515, 4, 0, 'The Gate of the Purple Amethyst is under attack!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The Gate of the Purple Amethyst is under attack', 29299),
+(22515, 5, 0, 'The Gate of the Yellow Moon is under attack!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The Gate of the Yellow Moon is under attack', 29300),
+
+(22515, 6, 0, 'The Gate of the Yellow Moon was destroyed!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The Gate of the Yellow Moon was destroyed', 29304),
+(22515, 7, 0, 'The Gate of the Purple Amethyst was destroyed!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The Gate of the Purple Amethyst was destroyed', 29305),
+(22515, 8, 0, 'The Gate of the Red Sun was destroyed!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The Gate of the Red Sun was destroyed', 29306),
+(22515, 9, 0, 'The Gate of the Green Emerald was destroyed!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The Gate of the Green Emerald was destroyed', 29307),
+(22515, 10, 0, 'The Gate of the Blue Sapphire was destroyed!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The Gate of the Blue Sapphire was destroyed', 29308),
+
+(22515, 11, 0, 'The Eastern Graveyard has been captured by the Alliance!', 41, 0, 100, 0, 0, 8212, 'World Trigger - SOA - The Eastern Graveyard has been captured by the Alliance', 29925),
+(22515, 12, 0, 'The Western Graveyard has been captured by the Alliance!', 41, 0, 100, 0, 0, 8212, 'World Trigger - SOA - The Western Graveyard has been captured by the Alliance', 29926),
+(22515, 13, 0, 'The Southern Graveyard has been captured by the Alliance!', 41, 0, 100, 0, 0, 8212, 'World Trigger - SOA - The Southern Graveyard has been captured by the Alliance', 29927),
+
+(22515, 14, 0, 'The Eastern Graveyard has been captured by the Horde!', 41, 0, 100, 0, 0, 8174, 'World Trigger - SOA - The Eastern Graveyard has been captured by the Horde', 29928),
+(22515, 15, 0, 'The Western Graveyard has been captured by the Horde!', 41, 0, 100, 0, 0, 8174, 'World Trigger - SOA - The Western Graveyard has been captured by the Horde', 29929),
+(22515, 16, 0, 'The Southern Graveyard has been captured by the Horde!', 41, 0, 100, 0, 0, 8174, 'World Trigger - SOA - The Southern Graveyard has been captured by the Horde', 29930),
+
+(22515, 17, 0, 'The relic chamber is under attack!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The relic chamber is under attack', 33072),
+(22515, 18, 0, 'The chamber has been breached! The titan relic is vulnerable!', 41, 0, 100, 0, 0, 0, 'World Trigger - SOA - The chamber has been breached', 33073);
+
+DELETE FROM `spell_area` WHERE `spell` IN (60027, 60028);
+INSERT INTO `spell_area` (`spell`,`area`,`autocast`) VALUES
+(60027, 4384, 1),
+(60028, 4384, 1);
+
+DELETE FROM `trinity_string` WHERE (`entry` BETWEEN 10059 AND 10062) OR (`entry` BETWEEN 10067 and 10073);
diff --git a/sql/updates/world/2014_04_26_03_world_gossip_menu_option.sql b/sql/updates/world/2014_04_26_03_world_gossip_menu_option.sql
new file mode 100644
index 00000000000..dd489bcc8a6
--- /dev/null
+++ b/sql/updates/world/2014_04_26_03_world_gossip_menu_option.sql
@@ -0,0 +1,201 @@
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3370 WHERE `menu_id`=0 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3266 WHERE `menu_id`=0 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2822 WHERE `menu_id`=0 AND `id`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3415 WHERE `menu_id`=0 AND `id`=9;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8912 WHERE `menu_id`=0 AND `id`=12;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3370 WHERE `menu_id`=0 AND `id`=13;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8271 WHERE `menu_id`=0 AND `id`=14;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2591 WHERE `menu_id`=125 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2589 WHERE `menu_id`=126 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=435 AND `id`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=721 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5514 WHERE `menu_id`=721 AND `id`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5515 WHERE `menu_id`=721 AND `id`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=7253 WHERE `menu_id`=721 AND `id`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10359 WHERE `menu_id`=721 AND `id`=8;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5518 WHERE `menu_id`=721 AND `id`=12;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3370 WHERE `menu_id`=922 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2822 WHERE `menu_id`=1293 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3370 WHERE `menu_id`=1293 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=1951 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5514 WHERE `menu_id`=1951 AND `id`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5515 WHERE `menu_id`=1951 AND `id`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5518 WHERE `menu_id`=1951 AND `id`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=7253 WHERE `menu_id`=1951 AND `id`=7;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=9756 WHERE `menu_id`=1951 AND `id`=9;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10359 WHERE `menu_id`=1951 AND `id`=10;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=4972 WHERE `menu_id`=1970 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=2121 AND `id`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5152 WHERE `menu_id`=2177 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5152 WHERE `menu_id`=2178 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5152 WHERE `menu_id`=2179 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=2352 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5758 WHERE `menu_id`=2703 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=6241 WHERE `menu_id`=3049 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=3506 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=3533 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=3580 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=7556 WHERE `menu_id`=4023 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8229 WHERE `menu_id`=4346 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8230 WHERE `menu_id`=4346 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8231 WHERE `menu_id`=4346 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8223 WHERE `menu_id`=4362 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8223 WHERE `menu_id`=4362 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=7556 WHERE `menu_id`=4506 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8298 WHERE `menu_id`=4609 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=7556 WHERE `menu_id`=4648 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8298 WHERE `menu_id`=4655 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=8298 WHERE `menu_id`=4656 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=9332 WHERE `menu_id`=5702 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=13491 WHERE `menu_id`=5750 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10035 WHERE `menu_id`=6182 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10067 WHERE `menu_id`=6207 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10069 WHERE `menu_id`=6207 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10071 WHERE `menu_id`=6207 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10073 WHERE `menu_id`=6207 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=20889 WHERE `menu_id`=6207 AND `id`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=20890 WHERE `menu_id`=6207 AND `id`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=20891 WHERE `menu_id`=6207 AND `id`=6;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=20892 WHERE `menu_id`=6207 AND `id`=7;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10179 WHERE `menu_id`=6230 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12647 WHERE `menu_id`=6321 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12641 WHERE `menu_id`=6321 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12670 WHERE `menu_id`=6322 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12673 WHERE `menu_id`=6322 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12672 WHERE `menu_id`=6322 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12661 WHERE `menu_id`=6341 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10775 WHERE `menu_id`=6582 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10777 WHERE `menu_id`=6582 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12021 WHERE `menu_id`=7096 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12237 WHERE `menu_id`=7208 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12238 WHERE `menu_id`=7208 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12239 WHERE `menu_id`=7208 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12240 WHERE `menu_id`=7208 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=13499 WHERE `menu_id`=7371 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=7633 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=15315 WHERE `menu_id`=7675 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=15323 WHERE `menu_id`=7679 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=7777 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=16928 WHERE `menu_id`=7984 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=16928 WHERE `menu_id`=7985 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=16928 WHERE `menu_id`=7986 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=16928 WHERE `menu_id`=7987 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=16928 WHERE `menu_id`=7988 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=16928 WHERE `menu_id`=7989 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=8129 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=8185 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=19671 WHERE `menu_id`=8304 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=19668 WHERE `menu_id`=8304 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=19669 WHERE `menu_id`=8304 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=19283 WHERE `menu_id`=8306 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=19270 WHERE `menu_id`=8339 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=19268 WHERE `menu_id`=8340 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=19728 WHERE `menu_id`=8454 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=19668 WHERE `menu_id`=8455 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=19669 WHERE `menu_id`=8455 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=20638 WHERE `menu_id`=8616 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=20640 WHERE `menu_id`=8617 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=21627 WHERE `menu_id`=8725 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=22383 WHERE `menu_id`=8775 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=22768 WHERE `menu_id`=8894 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=23789 WHERE `menu_id`=9007 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=23827 WHERE `menu_id`=9015 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=23964 WHERE `menu_id`=9040 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=23964 WHERE `menu_id`=9041 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=23964 WHERE `menu_id`=9042 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=25653 WHERE `menu_id`=9304 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=26120 WHERE `menu_id`=9456 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=26262 WHERE `menu_id`=9484 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=26439 WHERE `menu_id`=9507 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=26443 WHERE `menu_id`=9509 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=26448 WHERE `menu_id`=9510 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=27303 WHERE `menu_id`=9621 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=27463 WHERE `menu_id`=9647 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=27820 WHERE `menu_id`=9683 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=28527 WHERE `menu_id`=9714 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=28607 WHERE `menu_id`=9727 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=28608 WHERE `menu_id`=9727 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=30420 WHERE `menu_id`=9841 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=30429 WHERE `menu_id`=9842 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=30431 WHERE `menu_id`=9843 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=30644 WHERE `menu_id`=9859 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3266 WHERE `menu_id`=9879 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3266 WHERE `menu_id`=9893 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3266 WHERE `menu_id`=9895 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=31058 WHERE `menu_id`=9904 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=31055 WHERE `menu_id`=9904 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=31061 WHERE `menu_id`=9904 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=31296 WHERE `menu_id`=9961 AND `id`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=31296 WHERE `menu_id`=9963 AND `id`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=31296 WHERE `menu_id`=9964 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=31296 WHERE `menu_id`=9968 AND `id`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=31296 WHERE `menu_id`=9980 AND `id`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3266 WHERE `menu_id`=9987 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3266 WHERE `menu_id`=9988 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=31934 WHERE `menu_id`=10036 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=10043 AND `id`=7;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3266 WHERE `menu_id`=10115 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3266 WHERE `menu_id`=10117 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=32458 WHERE `menu_id`=10137 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=10265 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33401 WHERE `menu_id`=10318 AND `id`=7;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=34038 WHERE `menu_id`=10368 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=34039 WHERE `menu_id`=10368 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=34041 WHERE `menu_id`=10368 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=34042 WHERE `menu_id`=10368 AND `id`=3;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=34090 WHERE `menu_id`=10398 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=34092 WHERE `menu_id`=10400 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=34091 WHERE `menu_id`=10402 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5515 WHERE `menu_id`=10769 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10359 WHERE `menu_id`=10769 AND `id`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2870 WHERE `menu_id`=10769 AND `id`=5;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=4895 WHERE `menu_id`=10769 AND `id`=8;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=7253 WHERE `menu_id`=10769 AND `id`=10;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5518 WHERE `menu_id`=10769 AND `id`=11;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=36832 WHERE `menu_id`=10857 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=36824 WHERE `menu_id`=10858 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=40435 WHERE `menu_id`=11345 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=40436 WHERE `menu_id`=11345 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=31296 WHERE `menu_id`=21036 AND `id`=4;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=30181 WHERE `menu_id`=21194 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=2822 WHERE `menu_id`=21195 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3370 WHERE `menu_id`=21195 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=3370 WHERE `menu_id`=21215 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=25042 WHERE `menu_id`=21248 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33039 WHERE `menu_id`=21255 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=33043 WHERE `menu_id`=21256 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12653 WHERE `menu_id`=21262 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12646 WHERE `menu_id`=21263 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12645 WHERE `menu_id`=21263 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12644 WHERE `menu_id`=21263 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12643 WHERE `menu_id`=21264 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12642 WHERE `menu_id`=21264 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12640 WHERE `menu_id`=21264 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12675 WHERE `menu_id`=21265 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12676 WHERE `menu_id`=21265 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12680 WHERE `menu_id`=21266 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12681 WHERE `menu_id`=21266 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12682 WHERE `menu_id`=21266 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12677 WHERE `menu_id`=21267 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12678 WHERE `menu_id`=21267 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12679 WHERE `menu_id`=21267 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12665 WHERE `menu_id`=21268 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12666 WHERE `menu_id`=21268 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12664 WHERE `menu_id`=21268 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12668 WHERE `menu_id`=21269 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12669 WHERE `menu_id`=21269 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12667 WHERE `menu_id`=21269 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12656 WHERE `menu_id`=21270 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=12655 WHERE `menu_id`=21270 AND `id`=2;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=11042 WHERE `menu_id`=21280 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=11054 WHERE `menu_id`=21286 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=15285 WHERE `menu_id`=21291 AND `id`=1;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=15315 WHERE `menu_id`=21295 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=11733 WHERE `menu_id`=21311 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5996 WHERE `menu_id`=21315 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=6245 WHERE `menu_id`=21323 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=6251 WHERE `menu_id`=21326 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=9847 WHERE `menu_id`=21333 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=10011 WHERE `menu_id`=21334 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=4754 WHERE `menu_id`=40060 AND `id`=0;
+UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`=5936 WHERE `menu_id`=55002 AND `id`=1;