Machiavelli

-- 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 + Heroicset @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 GateWatcherset @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'arakset @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