aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZxBiohazardZx <zxbiohazardzx@gmail.com>2011-02-06 12:44:48 +0100
committerZxBiohazardZx <zxbiohazardzx@gmail.com>2011-02-06 12:44:48 +0100
commit29d4b613f03f124615d85f0a9b3057f2c2256fe9 (patch)
tree446b56a48e0a4842ef187a5c0e5478515f9abcca
parent1d36febab2d5dfcb0264b32f71d2f51694bc25c7 (diff)
DB/Loot: Fragment of the Nightmare's Corruption drops with a 100% chance as of patch 3.0.2
-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);