aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-10-11 20:42:07 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-09-05 19:35:41 +0200
commit13772e20b6f5fc79128d6013f2a37b6ee1d894b5 (patch)
tree27ffcd42aeb706e63104d464ae3e29c05beb0145 /sql
parent65077985e00a6c14c66fdec97c2db16ba182e760 (diff)
DB/Quest: add vendor conditions for quest items related to A Carver and a Croaker and Parts for the Job.
(cherry picked from commit 10329104be42ded80c5e358a5f0b6e98a68eb897)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2017_09_05_17_world_2016_10_11_03_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_09_05_17_world_2016_10_11_03_world.sql b/sql/updates/world/master/2017_09_05_17_world_2016_10_11_03_world.sql
new file mode 100644
index 00000000000..555b5d3359e
--- /dev/null
+++ b/sql/updates/world/master/2017_09_05_17_world_2016_10_11_03_world.sql
@@ -0,0 +1,5 @@
+--
+DELETE FROM `conditions` WHERE `SourceEntry` IN (35813, 33612) AND `SourceTypeOrReferenceId`=23;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(23, 24539, 35813, 0, 0, 9, 0, 11476, 0, 0, 0, 0, 0, "", "Shiny Knife can be bought only if on quest 'A Carver and a Croaker'"),
+(23, 24291, 33612, 0, 0, 9, 0, 11309, 0, 0, 0, 0, 0, "", "Fresh Pound of Flesh can be bought only if on quest 'Parts for the Job'");