diff options
| author | Killyana <morphone1@gmail.com> | 2015-11-09 14:32:05 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2015-11-09 14:32:05 +0100 |
| commit | 7f5850d94fb5b9fbc0421d2402860d5a24cac0f0 (patch) | |
| tree | 6e613db30ce667862e0337f618b3b55ba99642a0 | |
| parent | afd69f05b6e687814b7fa2e4407786804fb76b33 (diff) | |
DB/Misc: Add missing gossip option text for Brassbolt Mechawrench and Reginald Arcfire
Replace vendor of the brewfest condition by achievement instead of quest
| -rw-r--r-- | sql/updates/world/2015_11_09_01_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2015_11_09_01_world.sql b/sql/updates/world/2015_11_09_01_world.sql new file mode 100644 index 00000000000..e9360cf8963 --- /dev/null +++ b/sql/updates/world/2015_11_09_01_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; |