From 29d4b613f03f124615d85f0a9b3057f2c2256fe9 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Sun, 6 Feb 2011 12:44:48 +0100 Subject: DB/Loot: Fragment of the Nightmare's Corruption drops with a 100% chance as of patch 3.0.2 --- sql/updates/world/2011_02_06_1_world_creature_loot.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2011_02_06_1_world_creature_loot.sql (limited to 'sql') diff --git a/sql/updates/world/2011_02_06_1_world_creature_loot.sql b/sql/updates/world/2011_02_06_1_world_creature_loot.sql new file mode 100644 index 00000000000..295bb76a261 --- /dev/null +++ b/sql/updates/world/2011_02_06_1_world_creature_loot.sql @@ -0,0 +1,2 @@ +-- Fragment of the Nightmare's Corruption drops 100% as of patch 3.0.2 +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `item` IN (21146,21147,21148,21149); -- cgit v1.2.3