-- Set Faction of Hadronox to faction of mobs around him so that other mobs will not aggro and kill him.
UPDATE `creature_template` SET `faction_A`='1814', `faction_H`='1814' WHERE `entry` IN('28921', '31611');

-- Hadronox Normal + Heroic
set @n_id = 28921;
UPDATE `creature_template` SET `lootid` = @n_id WHERE `entry` = @n_id;
DELETE FROM `creature_loot_template` WHERE entry = @n_id;
set @h_id = 31611;
UPDATE `creature_template` SET `lootid` = @h_id WHERE `entry` = @h_id;
DELETE FROM `creature_loot_template` WHERE entry = @h_id;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
(@n_id, 33470,6.9,0,1,7,0,0,0), -- Cloth
(@n_id, 43228,100,0,1,1,1,57940,0), -- stonekeeper shards
(@n_id, 35660,0,1,1,1,0,0,0),
(@n_id, 35659,0,1,1,1,0,0,0),
(@n_id, 35658,0,1,1,1,0,0,0),
# heroic from here
(@h_id, 33470,6.9,0,1,7,0,0,0), -- Cloth
(@h_id, 43228,100,0,1,4,1,57940,0), -- stonekeeper shards
(@h_id, 40752,100,0,1,1,0,0,0), -- emblem
(@h_id, 37230,0,1,1,1,0,0,0),
(@h_id, 37221,0,1,1,1,0,0,0),
(@h_id, 37222,0,1,1,1,0,0,0),
(@h_id, 37220,0,1,1,1,0,0,0);


-- Krik'thir the GateWatcher

set @n_id = 28684;
UPDATE `creature_template` SET `lootid` = @n_id WHERE `entry` = @n_id;
DELETE FROM `creature_loot_template` WHERE entry = @n_id;
set @h_id = (SELECT `heroic_entry` FROM `creature_template` WHERE `entry`=@n_id);
UPDATE `creature_template` SET `lootid` = @h_id WHERE `entry` = @h_id;
DELETE FROM `creature_loot_template` WHERE entry = @h_id;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
(@n_id, 33470,6.9,0,1,7,0,0,0), -- Cloth
(@n_id, 43228,100,0,1,1,1,57940,0), -- stonekeeper shards
(@n_id, 35656,0,1,1,1,0,0,0),
(@n_id, 35655,0,1,1,1,0,0,0),
(@n_id, 35657,0,1,1,1,0,0,0),
##
(@h_id, 33470,6.9,0,1,7,0,0,0), -- Cloth
(@h_id, 43228,100,0,1,4,1,57940,0), -- stonekeeper shards
(@h_id, 40752,100,0,1,1,0,0,0), -- emblem
(@h_id, 37217,0,1,1,1,0,0,0),
(@h_id, 37216,0,1,1,1,0,0,0),
(@h_id, 37219,0,1,1,1,0,0,0),
(@h_id, 37218,0,1,1,1,0,0,0);

-- Anub'arak

set @n_id = 29120;
UPDATE `creature_template` SET `lootid` = @n_id WHERE `entry` = @n_id;
DELETE FROM `creature_loot_template` WHERE entry = @n_id;
set @h_id = (SELECT `heroic_entry` FROM `creature_template` WHERE `entry`=@n_id);
UPDATE `creature_template` SET `lootid` = @h_id WHERE `entry` = @h_id;
DELETE FROM `creature_loot_template` WHERE entry = @h_id;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
(@n_id, 33470,6.9,0,1,7,0,0,0), -- Cloth
(@n_id, 43228,100,0,1,1,1,57940,0), -- stonekeeper shards
(@n_id, 35662,0,1,1,1,0,0,0),
(@n_id, 35663,0,1,1,1,0,0,0),
(@n_id, 35661,0,1,1,1,0,0,0),
(@n_id, 43411,100,0,1,1,9,13167,0), -- quest item
#
(@h_id, 33470,6.9,0,1,7,0,0,0), -- Cloth
(@h_id, 43228,100,0,1,4,1,57940,0), -- stonekeeper shards
(@h_id, 40752,100,0,1,1,0,0,0), -- emblem
(@h_id, 43102,100,0,1,1,0,0,0), -- frozen orb
(@h_id, 43726,100,0,1,1,9,13254,0), -- quest item
(@h_id, 37235,0,1,1,1,0,0,0), -- start blues
(@h_id, 37236,0,1,1,1,0,0,0),
(@h_id, 37237,0,1,1,1,0,0,0),
(@h_id, 37232,0,1,1,1,0,0,0),
(@h_id, 37240,0,2,1,1,0,0,0), -- start purples
(@h_id, 37242,0,2,1,1,0,0,0),
(@h_id, 37238,0,2,1,1,0,0,0),
(@h_id, 37241,0,2,1,1,0,0,0),
(@h_id, 41796,15,0,1,1,0,0,0), -- JC recipe 
(@h_id, 43411,100,0,1,1,9,13167,0); -- quest item