From e1d442cf7d9cf02358802feb893aab862285ef90 Mon Sep 17 00:00:00 2001 From: Killyana Date: Mon, 9 Nov 2015 14:49:15 +0100 Subject: DB/Misc: Add missing gossip option text for Brassbolt Mechawrench and Reginald Arcfire Replace vendor of the brewfest condition by achievement instead of quest --- sql/updates/world/2015_11_09_00_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2015_11_09_00_world.sql (limited to 'sql') 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; -- cgit v1.2.3