From 01e5a5b4e799dc5448dd25ea663288bb3caf8593 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 25 Aug 2016 12:07:52 +0100 Subject: 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 --- sql/updates/world/3.3.5/2016_08_25_10_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_08_25_10_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_08_25_10_world.sql b/sql/updates/world/3.3.5/2016_08_25_10_world.sql new file mode 100644 index 00000000000..05c9a250a2d --- /dev/null +++ b/sql/updates/world/3.3.5/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'); -- cgit v1.2.3