From 727de0ef8df1f2421134a846af623d701dd58efa Mon Sep 17 00:00:00 2001 From: DDuarte Date: Sun, 19 Jul 2015 04:10:47 +0100 Subject: DB/Loot: Add conditions to gem drops of Ghost Iron Addition to d284b5d4376e58de66526c65fd0d9272cd884d9c --- sql/updates/world/2015_07_19_14_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/2015_07_19_14_world.sql (limited to 'sql') 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'); -- cgit v1.2.3