aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRushor <PBienati@web.de>2016-02-06 18:25:40 +0100
committerRushor <PBienati@web.de>2016-02-06 18:25:40 +0100
commit4833c472fa60916117a7bb327c2bedd87c6c574e (patch)
treef5e33ba6fb0acc92dbfbcbf93f5684b0dcdf92e3
parentc560cb0a0c8caa9c4337b1269039764207383f5d (diff)
DB/Quest: Warsong Recruitment Officer - Acceptcondition
* by @OScriptTC * closes #16485
-rw-r--r--sql/updates/world/2016_02_06_03_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2016_02_06_03_world.sql b/sql/updates/world/2016_02_06_03_world.sql
new file mode 100644
index 00000000000..85f8d3c6ae7
--- /dev/null
+++ b/sql/updates/world/2016_02_06_03_world.sql
@@ -0,0 +1,6 @@
+--
+-- Warsong Recruitment Officer gives dublicate quest
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND (`SourceEntry`=11586 OR `SourceEntry`=11585);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES
+(19, 11586, 14, 10172, "Accept quest 11586 - Quest 10172 needs to be incomplete"),
+(19, 11585, 8, 10172, "Accept quest 11585 - Quest 10172 needs to be rewarded");