DB/Misc: Add missing gossip option text for Brassbolt Mechawrench and Reginald Arcfire

Replace vendor of the brewfest condition by achievement instead of quest

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/updates/world/2015_11_09_00_world.sql b/sql/updates/world/2015_11_09_00_world.sql
new file mode 100644
index 00000000000..e9360cf8963
--- /dev/null
+++ b/sql/updates/world/2015_11_09_00_world.sql
@@ -0,0 +1,5 @@
+-- 
+UPDATE `gossip_menu_option` SET `option_text`="What's on the auction house today?", `OptionBroadcastTextID`=35877 WHERE `menu_id`=10656 AND id=0;
+
+UPDATE `conditions` SET `ConditionTypeOrReference`=17, `ConditionValue1`=2796, `comment`="Only allow players who have the achievement Brew of the Month to access vendor" WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9549 AND `ElseGroup`=0;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9549 AND `ElseGroup`=2;