diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2015-02-11 14:17:18 +0000 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2015-02-11 14:17:18 +0000 |
| commit | 81dab5bd4d4544386bd05048f92133a61796befb (patch) | |
| tree | 8e59e72fdf45f37d11f166ab43ba9a8c7e2093bf | |
| parent | 884bccef5863bee737a3336eff11575ff4765a80 (diff) | |
DB/Misc: Sealed Vial of Poison
Add condition to bag of fishing treasures to prevent Vialed Seal of Poison from dropping if player has already completed the quest it starts since it this item which was responsible for the bag bugging out and remaining in inventory but unclickable after player removed all visible items.
Also slight update for Mission Plague This as with previous update was failing to display gossip menu options and was just behaving as flight master.
| -rw-r--r-- | sql/updates/world/2015_02_11_05_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2015_02_11_05_world.sql b/sql/updates/world/2015_02_11_05_world.sql new file mode 100644 index 00000000000..3f0d52d3054 --- /dev/null +++ b/sql/updates/world/2015_02_11_05_world.sql @@ -0,0 +1,4 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=10 AND `SourceGroup`=10016 AND `SourceEntry`=46004; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(10, 10016, 46004, 0, 0, 8, 0, 13845, 0, 0, 1, 0, 0, '', 'Sealed vial of poison only drops if player is not rewarded for quest sealed vial of poison'); +UPDATE `gossip_menu_option` SET `npc_option_npcflag`=1 WHERE `menu_id`=9546 AND `id`=1; |
