DB/Loot: Some ICC loot fixes: Shadowfrost Shard was added to deathbringer and dreamwalker, and set to quest-only drop. loots for blood council and dreamwalker have been increased

Closes #1886

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/world/2012_01_30_04_world_gameobject_loot_template.sql b/sql/updates/world/2012_01_30_04_world_gameobject_loot_template.sql
new file mode 100644
index 00000000000..3ef39fe43d2
--- /dev/null
+++ b/sql/updates/world/2012_01_30_04_world_gameobject_loot_template.sql
@@ -0,0 +1,14 @@
+SET @ITEM :=50274;
+DELETE FROM `gameobject_loot_template` WHERE `entry` IN (28074,28088,28082,28096) AND `item`=@ITEM;
+INSERT INTO `gameobject_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
+(28074,@ITEM,-38,1,0,1,1), -- Deathbringer Cache 25 Normal
+(28088,@ITEM,-68,1,0,1,1), -- Deathbringer Cache 25 Heroic
+(28082,@ITEM,-38,1,0,1,1), -- Cache of the Dreamwalker 25 Normal
+(28096,@ITEM,-68,1,0,1,1); -- Cache of the Dreamwalker 25 Heroic
+-- only drop if someone is on the quest (negative ChanceOrQuestChance) 
+UPDATE `creature_loot_template` SET `ChanceOrQuestChance`= -(ABS(`ChanceOrQuestChance`)) WHERE `item`=50274;
+UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`= -(ABS(`ChanceOrQuestChance`)) WHERE `item`=50274;
+
+-- Dreamwalker and Council should drop 3 items
+UPDATE `gameobject_loot_template` SET `maxcount`=3 WHERE `entry`IN (28052,28082,28064,28096) AND `item`=1;
+UPDATE `creature_loot_template` SET `maxcount`=3 WHERE `entry` IN (37970,38401,38784,38785) AND `item`=1;