diff options
| -rw-r--r-- | sql/updates/world/2014_09_08_00_world_conditions.sql | 76 |
1 files changed, 76 insertions, 0 deletions
diff --git a/sql/updates/world/2014_09_08_00_world_conditions.sql b/sql/updates/world/2014_09_08_00_world_conditions.sql new file mode 100644 index 00000000000..492d6b5a981 --- /dev/null +++ b/sql/updates/world/2014_09_08_00_world_conditions.sql @@ -0,0 +1,76 @@ +UPDATE `quest_template` SET `PrevQuestId`=13794 WHERE `Id` IN(13861,13862); -- Battle before the Citadel (Non DK) requires Eadric the Pure complete +UPDATE `quest_template` SET `PrevQuestId`=13795 WHERE `Id` IN(13863,13864); -- Battle before the Citadel (DK) requires The Scourgebane complete +UPDATE `quest_template` SET `PrevQuestId`=13794 WHERE `Id` IN(13790,13811); -- Among the Champions (Non DK) requires Eadric the Pure complete +UPDATE `quest_template` SET `PrevQuestId`=13795 WHERE `Id` IN(13793,13814); -- Among the Champtions (DK) requires The Scourgebane complete +UPDATE `quest_template` SET `PrevQuestId`=13794 WHERE `Id` IN(13789,13810); -- Taking Battle To The Enemy (Non DK) requires Eadric the Pure complete +UPDATE `quest_template` SET `PrevQuestId`=13795 WHERE `Id` IN(13791,13813); -- Taking Battle To The Enemy (DK) requires The Scourgebane complete +UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id` IN(13682,13809); -- Clear prev quest from Threat from above as this needs more than one quest complete to become available so will be dealt with by conditions instead +UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id` IN(13788,13812); -- Clear prev quest from Threat from above as this needs more than one quest complete to become available so will be dealt with by conditions instead +UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=13664; -- Clear prev quest for the Black Knight's Fall as this quest had multiple requirements and will be dealt with by conditions instead + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN(19,20) AND `SourceId` IN(13794,13795,13682,13809,13788,13812,13664); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 13794, 0, 0, 8, 0, 13737, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(20, 0, 13794, 0, 0, 8, 0, 13737, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(19, 0, 13794, 0, 1, 8, 0, 13738, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(20, 0, 13794, 0, 1, 8, 0, 13738, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(19, 0, 13794, 0, 2, 8, 0, 13736, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(20, 0, 13794, 0, 2, 8, 0, 13736, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(19, 0, 13794, 0, 3, 8, 0, 13739, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(20, 0, 13794, 0, 3, 8, 0, 13739, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(19, 0, 13794, 0, 4, 8, 0, 13740, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(20, 0, 13794, 0, 4, 8, 0, 13740, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(19, 0, 13794, 0, 5, 8, 0, 13735, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(20, 0, 13794, 0, 5, 8, 0, 13735, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(19, 0, 13794, 0, 6, 8, 0, 13732, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(20, 0, 13794, 0, 6, 8, 0, 13732, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(19, 0, 13794, 0, 7, 8, 0, 13733, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(20, 0, 13794, 0, 7, 8, 0, 13733, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(19, 0, 13794, 0, 8, 8, 0, 13734, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(20, 0, 13794, 0, 8, 8, 0, 13734, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(19, 0, 13794, 0, 9, 8, 0, 13702, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(20, 0, 13794, 0, 9, 8, 0, 13702, 0, 0, 0, 0, 0, '', 'Eadric the Pure requires A Champion Rises'), +(19, 0, 13795, 0, 0, 8, 0, 13737, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(20, 0, 13795, 0, 0, 8, 0, 13737, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(19, 0, 13795, 0, 1, 8, 0, 13738, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(20, 0, 13795, 0, 1, 8, 0, 13738, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(19, 0, 13795, 0, 2, 8, 0, 13736, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(20, 0, 13795, 0, 2, 8, 0, 13736, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(19, 0, 13795, 0, 3, 8, 0, 13739, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(20, 0, 13795, 0, 3, 8, 0, 13739, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(19, 0, 13795, 0, 4, 8, 0, 13740, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(20, 0, 13795, 0, 4, 8, 0, 13740, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(19, 0, 13795, 0, 5, 8, 0, 13735, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(20, 0, 13795, 0, 5, 8, 0, 13735, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(19, 0, 13795, 0, 6, 8, 0, 13732, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(20, 0, 13795, 0, 6, 8, 0, 13732, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(19, 0, 13795, 0, 7, 8, 0, 13733, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(20, 0, 13795, 0, 7, 8, 0, 13733, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(19, 0, 13795, 0, 8, 8, 0, 13734, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(20, 0, 13795, 0, 8, 8, 0, 13734, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(19, 0, 13795, 0, 9, 8, 0, 13702, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(20, 0, 13795, 0, 9, 8, 0, 13702, 0, 0, 0, 0, 0, '', 'The Scourgebane requires A Champion Rises'), +(19, 0, 13682, 0, 0, 8, 0, 13794, 0, 0, 0, 0, 0, '', 'Threat from Above requires Eadric the Pure rewarded'), +(20, 0, 13682, 0, 0, 8, 0, 13794, 0, 0, 0, 0, 0, '', 'Threat from Above requires Eadric the Pure rewarded'), +(19, 0, 13682, 0, 0, 8, 0, 13664, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Black Knights Fall rewarded'), +(20, 0, 13682, 0, 0, 8, 0, 13664, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Black Knights Fall rewarded'), +(19, 0, 13809, 0, 0, 8, 0, 13794, 0, 0, 0, 0, 0, '', 'Threat from Above requires Eadric the Pure rewarded'), +(20, 0, 13809, 0, 0, 8, 0, 13794, 0, 0, 0, 0, 0, '', 'Threat from Above requires Eadric the Pure rewarded'), +(19, 0, 13809, 0, 0, 8, 0, 13664, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Black Knights Fall rewarded'), +(20, 0, 13809, 0, 0, 8, 0, 13664, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Black Knights Fall rewarded'), +(19, 0, 13788, 0, 0, 8, 0, 13795, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Scourgebane rewarded'), +(20, 0, 13788, 0, 0, 8, 0, 13795, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Scourgebane rewarded'), +(19, 0, 13788, 0, 0, 8, 0, 13664, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Black Knights Fall rewarded'), +(20, 0, 13788, 0, 0, 8, 0, 13664, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Black Knights Fall rewarded'), +(19, 0, 13812, 0, 0, 8, 0, 13795, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Scourgebane rewarded'), +(20, 0, 13812, 0, 0, 8, 0, 13795, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Scourgebane rewarded'), +(19, 0, 13812, 0, 0, 8, 0, 13664, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Black Knights Fall rewarded'), +(20, 0, 13812, 0, 0, 8, 0, 13664, 0, 0, 0, 0, 0, '', 'Threat from Above requires The Black Knights Fall rewarded'), +(19, 0, 13664, 0, 0, 8, 0, 13794, 0, 0, 0, 0, 0, '', 'The Black Knights fall requires Eadric the Pure rewarded'), +(20, 0, 13664, 0, 0, 8, 0, 13794, 0, 0, 0, 0, 0, '', 'The Black Knights fall requires Eadric the Pure rewarded'), +(19, 0, 13664, 0, 0, 8, 0, 13663, 0, 0, 0, 0, 0, '', 'The Black Knights fall requires The Black Knights Orders rewarded'), +(20, 0, 13664, 0, 0, 8, 0, 13663, 0, 0, 0, 0, 0, '', 'The Black Knights fall requires The Black Knights Orders rewarded'), +(19, 0, 13664, 0, 1, 8, 0, 13795, 0, 0, 0, 0, 0, '', 'The Black Knights fall requires The Scourgebane rewarded'), +(20, 0, 13664, 0, 1, 8, 0, 13795, 0, 0, 0, 0, 0, '', 'The Black Knights fall requires The Scourgebane rewarded'), +(19, 0, 13664, 0, 1, 8, 0, 13663, 0, 0, 0, 0, 0, '', 'The Black Knights fall requires The Black Knights Orders rewarded'), +(20, 0, 13664, 0, 1, 8, 0, 13663, 0, 0, 0, 0, 0, '', 'The Black Knights fall requires The Black Knights Orders rewarded'); |