diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2014-12-28 00:36:01 +0000 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2014-12-28 00:36:01 +0000 |
| commit | d443a768c3a163f22794713dad07dd62358b6ec0 (patch) | |
| tree | 2b8f2b16dc0f96c549d45473fef877f204eba78b | |
| parent | 286fab5bc4d494f0e3c541a18ed12c2b9e0ac612 (diff) | |
DB/Misc: Fix Mog dorg the Wizened quest linking issues
Fix quest chain leading upto bomb them again
There are two versions of Mog'dorg the Wizened of which player should be able to complete either to start quest chain rather than quest chain only continueing if player completed http://www.wowhead.com/quest=10983 and player coming to dead end if http://www.wowhead.com/quest=10989 completed instead.
| -rw-r--r-- | sql/updates/world/2014_12_27_12_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/2014_12_27_12_world.sql b/sql/updates/world/2014_12_27_12_world.sql new file mode 100644 index 00000000000..acc0a8fb619 --- /dev/null +++ b/sql/updates/world/2014_12_27_12_world.sql @@ -0,0 +1,17 @@ +UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id` IN(10995,10996,10997); +UPDATE `quest_template` SET `ExclusiveGroup`=10983 WHERE `Id` IN(10983,10989); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN(19,20) AND `SourceEntry` IN(10995,10996,10997); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 10995, 0, 0, 8, 0, 10989, 0, 0, 0, 0, 0, '', 'Grulloc Has Two Skulls after Mog dorg the Wizened'), +(20, 0, 10995, 0, 0, 8, 0, 10989, 0, 0, 0, 0, 0, '', 'Grulloc Has Two Skulls after Mog dorg the Wizened'), +(19, 0, 10995, 0, 1, 8, 0, 10983, 0, 0, 0, 0, 0, '', 'Grulloc Has Two Skulls after Mog dorg the Wizened'), +(20, 0, 10995, 0, 1, 8, 0, 10983, 0, 0, 0, 0, 0, '', 'Grulloc Has Two Skulls after Mog dorg the Wizened'), +(19, 0, 10996, 0, 0, 8, 0, 10989, 0, 0, 0, 0, 0, '', 'Maggocs Treasure Chest after Mog dorg the Wizened'), +(20, 0, 10996, 0, 0, 8, 0, 10989, 0, 0, 0, 0, 0, '', 'Maggocs Treasure Chest after Mog dorg the Wizened'), +(19, 0, 10996, 0, 1, 8, 0, 10983, 0, 0, 0, 0, 0, '', 'Maggocs Treasure Chest after Mog dorg the Wizened'), +(20, 0, 10996, 0, 1, 8, 0, 10983, 0, 0, 0, 0, 0, '', 'Maggocs Treasure Chest after Mog dorg the Wizened'), +(19, 0, 10997, 0, 0, 8, 0, 10989, 0, 0, 0, 0, 0, '', 'Even Gronn Have Standards after Mog dorg the Wizened'), +(20, 0, 10997, 0, 0, 8, 0, 10989, 0, 0, 0, 0, 0, '', 'Even Gronn Have Standards after Mog dorg the Wizened'), +(19, 0, 10997, 0, 1, 8, 0, 10983, 0, 0, 0, 0, 0, '', 'Even Gronn Have Standards after Mog dorg the Wizened'), +(20, 0, 10997, 0, 1, 8, 0, 10983, 0, 0, 0, 0, 0, '', 'Even Gronn Have Standards after Mog dorg the Wizened'); |