From 8167e9e9a82f186347ad1c1d8686e0aa98f24362 Mon Sep 17 00:00:00 2001 From: Killyana Date: Mon, 4 Jul 2016 02:51:12 +0200 Subject: DB/Quest: Add vendor conditions for quest items related to "The Party Never Ends" and "Dry Times" By SnapperRy Closes #17490 (cherry picked from commit 0566bba3356470d0564e39ee971b1a53c50351a4) --- .../world/master/2017_02_04_21_world_2016_07_04_09_world.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/master/2017_02_04_21_world_2016_07_04_09_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2017_02_04_21_world_2016_07_04_09_world.sql b/sql/updates/world/master/2017_02_04_21_world_2016_07_04_09_world.sql new file mode 100644 index 00000000000..29cb4809078 --- /dev/null +++ b/sql/updates/world/master/2017_02_04_21_world_2016_07_04_09_world.sql @@ -0,0 +1,12 @@ +-- +DELETE FROM `conditions` WHERE `SourceEntry` IN (22777, 22776, 22775) AND `SourceTypeOrReferenceId`=23; +INSERT INTO `conditions` VALUES +(23, 16444, 22777, 0, 0, 9, 0, 9067, 0, 0, 0, 0, 0, "", "Bundle of Fireworks can be bought only if on quest 'The Party Never Ends'"), +(23, 16443, 22776, 0, 0, 9, 0, 9067, 0, 0, 0, 0, 0, "", "Springpaw Appetizers can be bought only if on quest 'The Party Never Ends'"), +(23, 16442, 22775, 0, 0, 9, 0, 9067, 0, 0, 0, 0, 0, "", "Suntouched Special Reserve can be bought only if on quest 'The Party Never Ends'"); + +DELETE FROM `conditions` WHERE `SourceEntry` IN (1939, 1941, 1942) AND `SourceTypeOrReferenceId`=23; +INSERT INTO `conditions` VALUES +(23, 465, 1939, 0, 0, 9, 0, 116, 0, 0, 0, 0, 0, "", "Skin of Sweet Rum can be bought only if on quest 'Dry Times'"), +(23, 277, 1941, 0, 0, 9, 0, 116, 0, 0, 0, 0, 0, "", "Cask of Merlot can be bought only if on quest 'Dry Times'"), +(23, 274, 1942, 0, 0, 9, 0, 116, 0, 0, 0, 0, 0, "", "Bottle of Moonshine can be bought only if on quest 'Dry Times'"); -- cgit v1.2.3