diff options
| author | DDuarte <dnpd.dd@gmail.com> | 2015-07-19 04:10:47 +0100 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2015-07-19 04:11:08 +0100 |
| commit | 727de0ef8df1f2421134a846af623d701dd58efa (patch) | |
| tree | 16d18ef408990858ea73b7ee4d9a105c80f930f6 | |
| parent | 5705555f1f9a259f2d4d52980ccb68d1b909b7a2 (diff) | |
DB/Loot: Add conditions to gem drops of Ghost Iron
Addition to d284b5d4376e58de66526c65fd0d9272cd884d9c
| -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'); |