diff options
| author | PolarCookie <PolarCookie@users.noreply.github.com> | 2018-12-08 11:10:56 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-11-16 16:11:17 +0100 |
| commit | 1c02f00210130be0df75ccf60aa20b2e78ee297e (patch) | |
| tree | de619f4faf3fad43caadff9fd24a3b46101e46e1 | |
| parent | b32c8829eb3438039ff122b6134bae50167b5697 (diff) | |
DB/Quest: Gurf's Dignity
Closes #22796
(cherry picked from commit 97a6b6dd64a9ab4c67bfeb0f2b21d2e3d97ae91a)
| -rw-r--r-- | sql/updates/world/master/2021_11_16_29_world_2018_12_08_42_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_16_29_world_2018_12_08_42_world.sql b/sql/updates/world/master/2021_11_16_29_world_2018_12_08_42_world.sql new file mode 100644 index 00000000000..7319f0b8839 --- /dev/null +++ b/sql/updates/world/master/2021_11_16_29_world_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'); |