aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDr-J <daniel.jarrott0@gmail.com>2015-02-11 14:17:18 +0000
committerDr-J <daniel.jarrott0@gmail.com>2015-02-11 14:17:18 +0000
commit81dab5bd4d4544386bd05048f92133a61796befb (patch)
tree8e59e72fdf45f37d11f166ab43ba9a8c7e2093bf
parent884bccef5863bee737a3336eff11575ff4765a80 (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.sql4
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;