aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPolarCookie <PolarCookie@users.noreply.github.com>2018-12-08 11:10:56 +0100
committerKillyana <morphone1@gmail.com>2018-12-08 11:10:56 +0100
commit97a6b6dd64a9ab4c67bfeb0f2b21d2e3d97ae91a (patch)
tree40d2e496ac2f48c9319bd45b2a8a8e7215063a44
parent63d082557ed3cdf348d1e5a63a758ad517f759dc (diff)
DB/Quest: Gurf's Dignity
Closes #22796
-rw-r--r--sql/updates/world/3.3.5/2018_12_08_42_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_12_08_42_world.sql b/sql/updates/world/3.3.5/2018_12_08_42_world.sql
new file mode 100644
index 00000000000..adc94583e0b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_12_08_42_world.sql
@@ -0,0 +1,7 @@
+--
+UPDATE `quest_template_addon` SET `PrevQuestID` = 0 WHERE `ID` = 9564;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup` = 17475 AND `SourceEntry`=23850;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(1, 17475, 23850, 0, 0, 8, 0, 9562, 0, 0, 0, 0, 0, "", 'Item "Gurf\'s Dignity" can be looted if quest "Murlocs... Why Here? Why Now?" is rewarded'),
+(1, 17475, 23850, 0, 1, 9, 0, 9562, 0, 0, 0, 0, 0, "", 'Item "Gurf\'s Dignity" can be looted if quest "Murlocs... Why Here? Why Now?" is taken');
+(1, 17475, 23850, 0, 2, 28, 0, 9562, 0, 0, 0, 0, 0, "", 'Item "Gurf\'s Dignity" can be looted if quest "Murlocs... Why Here? Why Now?" is completed');