diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2015-03-02 11:37:56 +0000 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2015-03-02 11:37:56 +0000 |
| commit | fa7663a9bcde44e3b9f7525a896d6f8c8d07f507 (patch) | |
| tree | 8a1741a74c3c9e6d8dd6cb9ce69052c9da79f498 | |
| parent | 8e6cada6d4141478ac0d08817c53cfafd7ce01b3 (diff) | |
DB/Conditions: Fix Taking of Mind Tricks for Alliance Players
Fix taking of http://www.wowhead.com/quest=13308/mind-tricks for alliance players previously this has previous quest set to Orgrims Hammer resulting in that quest was only available to horde players even though this quest should be available to both factions as long as Orgrims Hammer or The skybreaker is taken.
| -rw-r--r-- | sql/updates/world/2015_03_02_00_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_02_00_world.sql b/sql/updates/world/2015_03_02_00_world.sql new file mode 100644 index 00000000000..a76b40e2212 --- /dev/null +++ b/sql/updates/world/2015_03_02_00_world.sql @@ -0,0 +1,15 @@ +UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=13308; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN(19,20) AND `SourceEntry`=13308; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 13308, 0, 0, 8, 0, 13224, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires Orgrims Hammer Rewarded or'), +(20, 0, 13308, 0, 0, 8, 0, 13224, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires Orgrims Hammer Rewarded or'), +(19, 0, 13308, 0, 1, 9, 0, 13224, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires Orgrims Hammer Taken or'), +(20, 0, 13308, 0, 1, 9, 0, 13224, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires Orgrims Hammer Taken or'), +(19, 0, 13308, 0, 2, 28, 0, 13224, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires Orgrims Hammer Complete or'), +(20, 0, 13308, 0, 2, 28, 0, 13224, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires Orgrims Hammer Complete or'), +(19, 0, 13308, 0, 3, 8, 0, 13225, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires The Skybreaker Rewarded or'), +(20, 0, 13308, 0, 3, 8, 0, 13225, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires The Skybreaker Rewarded or'), +(19, 0, 13308, 0, 4, 9, 0, 13225, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires The Skybreaker Taken or'), +(20, 0, 13308, 0, 4, 9, 0, 13225, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires The Skybreaker Taken or'), +(19, 0, 13308, 0, 5, 28, 0, 13225, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires The Skybreaker Complete or'), +(20, 0, 13308, 0, 5, 28, 0, 13225, 0, 0, 0, 0, 0, '', 'Mind Tricks Requires The Skybreaker Complete or'); |