diff options
| author | Aokromes <jipr@hotmail.com> | 2014-01-27 06:05:54 +0100 |
|---|---|---|
| committer | Aokromes <jipr@hotmail.com> | 2014-01-27 06:05:54 +0100 |
| commit | 9d108dedd6fbe359cfb7c41a6e1080e0122fe8c3 (patch) | |
| tree | ee61cbc78aa07205aa69adae9a30d7e27230d41c | |
| parent | c38b9743ae09c0b71963d50a1823861af15e7546 (diff) | |
DB/Quest: Treats for Great-father Winter
By dr-j, closes #11320
| -rw-r--r-- | sql/updates/world/2014_01_27_03_world_quest.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/2014_01_27_03_world_quest.sql b/sql/updates/world/2014_01_27_03_world_quest.sql new file mode 100644 index 00000000000..b431d304bb2 --- /dev/null +++ b/sql/updates/world/2014_01_27_03_world_quest.sql @@ -0,0 +1,23 @@ +-- Fix taking of 6962/7025 Treats for Great-father Winter +-- Horde +UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=6962; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) and `SourceEntry`IN(6962); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(20, 0, 6962, 0, 0, 8, 0, 7021, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(19, 0, 6962, 0, 0, 8, 0, 7021, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(20, 0, 6962, 0, 1, 8, 0, 7024, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(19, 0, 6962, 0, 1, 8, 0, 7024, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(20, 0, 6962, 0, 2, 8, 0, 6961, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(19, 0, 6962, 0, 2, 8, 0, 6961, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'); + +-- Alliance +UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=7025; +UPDATE `creature_queststarter` SET `id`='13433' WHERE `id`='13429' and`quest`='7022'; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) and `SourceEntry`IN(7025); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(20, 0, 7025, 0, 0, 8, 0, 7022, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(19, 0, 7025, 0, 0, 8, 0, 7022, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(20, 0, 7025, 0, 1, 8, 0, 7023, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'), +(19, 0, 7025, 0, 1, 8, 0, 7023, 0, 0, 0, 0, 0, '', 'Treats for Great-father Winter once Great-father Winter is Here! Has been completed'); |