aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2018-02-08 17:31:12 +0100
committerShauren <shauren.trinity@gmail.com>2021-06-19 23:33:24 +0200
commit61b31f657a9931fd953e8ce3bf358314b2d249be (patch)
tree1845727b665519a85204d9e723ed6c0312fb75d2 /sql
parent2bc1f0593b474f7db3ccf8db499c9cc85c87780b (diff)
DB/Quest: Tran'rek (breadcrumb quest)
Closes #21373 (cherry picked from commit c705b02a0cdad40bf796e485d56ce7a5f8891e39)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2021_06_19_09_world_2018_02_08_05_world_335.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_06_19_09_world_2018_02_08_05_world_335.sql b/sql/updates/world/master/2021_06_19_09_world_2018_02_08_05_world_335.sql
new file mode 100644
index 00000000000..07134fb590a
--- /dev/null
+++ b/sql/updates/world/master/2021_06_19_09_world_2018_02_08_05_world_335.sql
@@ -0,0 +1,6 @@
+-- BreadCrumb Quest "Tran'rek"
+UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=2865;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry` IN (2864,2865);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(19,0,2864,0,0,14,0,2865,0,0,0,0,0,"","Quest 'Tran'rek' can only be taken if quest 'Scarab Shells' is not taken"),
+(19,0,2865,0,0,28,0,2864,0,0,1,0,0,"","Quest 'Scarab Shells' can only be taken if quest 'Tran'rek' is not completed");