TrinityCore/TrinityCore — Issue #4940: [Fix] Shadowfrost Shard drop percentage
Author: Exodius
Created: 2012-01-24 13:25:19+00:00
State: open

Currently, Shadowfrost Shards have bigger chance to drop on Normal than on Heroic ICC25. It should be other way around. It should have lower chance to drop on Normal but higher to drop on Heroic.
This fixes the issue.

```SQL
-- Correct drop percentage for Shadowfrost Shards in Icecrown Citadel Normal and Heroic
SET @ITEM := 50274; -- Shadowfrost Shard
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=38 WHERE `entry` IN
(38297,37959,37506,38550,38785,38436,38267,39168) and`item`=@ITEM;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=68 WHERE `entry` IN
(37957,37504,38106,38390,38431,38586,38401,38434,38265,39166) and`item`=@ITEM;