aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2011_02_06_1_world_creature_loot.sql2
1 files changed, 2 insertions, 0 deletions
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);