diff options
| -rw-r--r-- | sql/updates/world/2015_07_19_14_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_19_14_world.sql b/sql/updates/world/2015_07_19_14_world.sql new file mode 100644 index 00000000000..d019f8e8a07 --- /dev/null +++ b/sql/updates/world/2015_07_19_14_world.sql @@ -0,0 +1,14 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=4 AND `SourceGroup`=40268 AND `SourceEntry` IN (76135, 76133, 76136, 76134, 76130, 76137, 76138, 76131, 76139, 76140, 76141, 76142); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(4, 40268, 76135, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron green gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76133, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron green gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76136, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron green gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76134, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron green gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76130, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron green gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76137, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron green gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76138, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron blue gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76131, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron blue gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76139, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron blue gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76140, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron blue gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76141, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron blue gems -> has Ancient Pandaren Mining Pick'), +(4, 40268, 76142, 0, 0, 2, 0, 85777, 1, 0, 0, 0, 0, '', ' Ghost Iron blue gems -> has Ancient Pandaren Mining Pick'); |