aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRushor <PBienati@web.de>2016-02-06 18:25:40 +0100
committerShauren <shauren.trinity@gmail.com>2016-04-02 19:34:36 +0200
commite9bc7a112163c5d0fd36e6e41211a7f942c4f4a5 (patch)
tree945b510477796e27beefdd095e97c370f1d8426b
parentc3a2cbc8447e07d741c4b47682d722091e05bf5e (diff)
DB/Quest: Warsong Recruitment Officer - Acceptcondition
* by @OScriptTC * closes #16485 (cherry picked from commit 4833c472fa60916117a7bb327c2bedd87c6c574e)
-rw-r--r--sql/updates/world/2016_04_02_24_world_2016_02_06_03_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_02_24_world_2016_02_06_03_world.sql b/sql/updates/world/2016_04_02_24_world_2016_02_06_03_world.sql
new file mode 100644
index 00000000000..85f8d3c6ae7
--- /dev/null
+++ b/sql/updates/world/2016_04_02_24_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");