aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-10-11 20:42:07 +0200
committerGitHub <noreply@github.com>2016-10-11 20:42:07 +0200
commit10329104be42ded80c5e358a5f0b6e98a68eb897 (patch)
treed8e2f27c58a14bfc347d8ee9d7fdbbc07dbd22d3
parent387b18775d6f7b7d6e8cf669d36328867e5f39d5 (diff)
DB/Quest: add vendor conditions for quest items related to A Carver and a Croaker and Parts for the Job.
-rw-r--r--sql/updates/world/3.3.5/2016_10_11_03_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_10_11_03_world.sql b/sql/updates/world/3.3.5/2016_10_11_03_world.sql
new file mode 100644
index 00000000000..555b5d3359e
--- /dev/null
+++ b/sql/updates/world/3.3.5/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'");