aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDr-J <daniel.jarrott0@gmail.com>2016-08-25 12:07:52 +0100
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-18 16:53:29 +0100
commit5aa7e2a133858aab06f8d42d44a07074520b1ec8 (patch)
tree5d57e3599563ed937dbbed0181c5c06ecd08ea1f
parent2a105e5c9f44717d2829fb1e179c301c24a7bb21 (diff)
DB/Quest: The Journey Has Just Begun
http://www.wowhead.com/quest=7493/the-journey-has-just-begun should become available when either level 60 or 80 version of Onyxias head quest is turned not only the level 60 version (cherry picked from commit 01e5a5b4e799dc5448dd25ea663288bb3caf8593)
-rw-r--r--sql/updates/world/master/2017_02_18_29_world_2016_08_25_10_world.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_18_29_world_2016_08_25_10_world.sql b/sql/updates/world/master/2017_02_18_29_world_2016_08_25_10_world.sql
new file mode 100644
index 00000000000..05c9a250a2d
--- /dev/null
+++ b/sql/updates/world/master/2017_02_18_29_world_2016_08_25_10_world.sql
@@ -0,0 +1,13 @@
+UPDATE `creature_template` SET `lootid`=0 WHERE `entry`=10698;
+UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`IN(7493,7497);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN(19,20) AND `SourceEntry` IN(7493,7497);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(20, 0, 7493, 0, 0, 8, 0, 7491, 0, 0, 0, 0, 0, '', 'Show quest The Journey Has Just Begun if quest For All To See is rewarded or '),
+(19, 0, 7493, 0, 0, 8, 0, 7491, 0, 0, 0, 0, 0, '', 'Show quest The Journey Has Just Begun if quest For All To See is rewarded or '),
+(20, 0, 7493, 0, 1, 8, 0, 24429, 0, 0, 0, 0, 0, '', 'Show quest The Journey Has Just Begun if quest A Most Puzzling Circumstance is rewarded'),
+(19, 0, 7493, 0, 1, 8, 0, 24429, 0, 0, 0, 0, 0, '', 'Show quest The Journey Has Just Begun if quest A Most Puzzling Circumstance is rewarded'),
+(20, 0, 7497, 0, 0, 8, 0, 7496, 0, 0, 0, 0, 0, '', 'Show quest The Journey Has Just Begun if quest Celebrating Good Times is rewarded or '),
+(19, 0, 7497, 0, 0, 8, 0, 7496, 0, 0, 0, 0, 0, '', 'Show quest The Journey Has Just Begun if quest Celebrating Good Times rewarded or '),
+(20, 0, 7497, 0, 1, 8, 0, 24428, 0, 0, 0, 0, 0, '', 'Show quest The Journey Has Just Begun if quest A Most Puzzling Circumstance is rewarded'),
+(19, 0, 7497, 0, 1, 8, 0, 24428, 0, 0, 0, 0, 0, '', 'Show quest The Journey Has Just Begun if quest A Most Puzzling Circumstance is rewarded');