Thread: Naxxramas Level 80 Loot(10man)

This is for those interesting in correcting the loot table for the 10man Naxxramas bosses in TRM's MaNGOS repack, this SQL has 12/14 bosses, the two I have not done are Gluth and The Four Horsemen. This is my first one, so please give me helpful criticism:P Should be working 100%.

Code:

SQL Download: http://www.mediafire.com/?o200mygmv22

Code:

DELETE FROM `creature_loot_template` WHERE (`entry`=15952);
INSERT INTO `creature_loot_template` VALUES 
(15952, 47241, 68, 0, 1, 1, 0, 0, 0),
(15952, 39229, 20, 0, 1, 1, 0, 0, 0),
(15952, 39230, 20, 0, 1, 1, 0, 0, 0),
(15952, 39233, 19, 0, 1, 1, 0, 0, 0),
(15952, 39225, 19, 0, 1, 1, 0, 0, 0),
(15952, 39224, 19, 0, 1, 1, 0, 0, 0),
(15952, 39226, 19, 0, 1, 1, 0, 0, 0),
(15952, 39232, 19, 0, 1, 1, 0, 0, 0),
(15952, 39231, 19, 0, 1, 1, 0, 0, 0),
(15952, 39228, 19, 0, 1, 1, 0, 0, 0),
(15952, 39221, 19, 0, 1, 1, 0, 0, 0);

/* Noth the Plaguebringer - 15954 */

DELETE FROM `creature_loot_template` WHERE (`entry`=15954);
INSERT INTO `creature_loot_template` VALUES 
(15954, 47247, 77, 0, 1, 1, 0, 0, 0),
(15954, 39241, 20, 0, 1, 1, 0, 0, 0),
(15954, 39240, 20, 0, 1, 1, 0, 0, 0),
(15954, 39234, 20, 0, 1, 1, 0, 0, 0),
(15954, 39242, 20, 0, 1, 1, 0, 0, 0),
(15954, 39237, 20, 0, 1, 1, 0, 0, 0),
(15954, 39235, 19, 0, 1, 1, 0, 0, 0),
(15954, 39239, 19, 0, 1, 1, 0, 0, 0),
(15954, 39243, 19, 0, 1, 1, 0, 0, 0),
(15954, 39244, 19, 0, 1, 1, 0, 0, 0),
(15954, 39236, 19, 0, 1, 1, 0, 0, 0);

/* Heigan the Unclean - 15936 */

DELETE FROM `creature_loot_template` WHERE (`entry`=15936);
INSERT INTO `creature_loot_template` VALUES 
(15936, 47241, 75, 0, 1, 1, 0, 0, 0),
(15936, 39251, 20, 0, 1, 1, 0, 0, 0),
(15936, 39250, 20, 0, 1, 1, 0, 0, 0),
(15936, 39246, 19, 0, 1, 1, 0, 0, 0),
(15936, 39252, 19, 0, 1, 1, 0, 0, 0),
(15936, 39254, 19, 0, 1, 1, 0, 0, 0),
(15936, 39249, 19, 0, 1, 1, 0, 0, 0),
(15936, 39255, 19, 0, 1, 1, 0, 0, 0),
(15936, 39248, 19, 0, 1, 1, 0, 0, 0),
(15936, 39247, 18, 0, 1, 1, 0, 0, 0),
(15936, 39245, 18, 0, 1, 1, 0, 0, 0);

/* Loatheb - 16011 */

DELETE FROM `creature_loot_template` WHERE (`entry`=16011);
INSERT INTO `creature_loot_template` VALUES 
(16011, 47241, 78, 0, 1, 1, 0, 0, 0),
(16011, 40624, 38, 0, 1, 1, 0, 0, 0),
(16011, 40623, 30, 0, 1, 1, 0, 0, 0),
(16011, 40622, 29, 0, 1, 1, 0, 0, 0),
(16011, 39259, 19, 0, 1, 1, 0, 0, 0),
(16011, 39260, 19, 0, 1, 1, 0, 0, 0),
(16011, 39258, 19, 0, 1, 1, 0, 0, 0),
(16011, 39257, 19, 0, 1, 1, 0, 0, 0),
(16011, 39256, 19, 0, 1, 1, 0, 0, 0);

/* Instructor Razuvious - 16061 */

DELETE FROM `creature_loot_template` WHERE (`entry`=16061);
INSERT INTO `creature_loot_template` VALUES 
(16061, 47241, 71, 0, 1, 1, 0, 0, 0),
(16061, 39296, 19, 0, 1, 1, 0, 0, 0),
(16061, 39297, 19, 0, 1, 1, 0, 0, 0),
(16061, 39308, 19, 0, 1, 1, 0, 0, 0),
(16061, 39307, 19, 0, 1, 1, 0, 0, 0),
(16061, 39309, 19, 0, 1, 1, 0, 0, 0),
(16061, 39310, 19, 0, 1, 1, 0, 0, 0),
(16061, 39306, 19, 0, 1, 1, 0, 0, 0),
(16061, 39311, 19, 0, 1, 1, 0, 0, 0),
(16061, 39299, 18, 0, 1, 1, 0, 0, 0),
(16061, 39298, 18, 0, 1, 1, 0, 0, 0);

/* Gothik the Harvester - 16060 */

DELETE FROM `creature_loot_template` WHERE (`entry`=16060);
INSERT INTO `creature_loot_template` VALUES 
(16060, 47241, 83, 0, 1, 1, 0, 0, 0),
(16060, 39345, 20, 0, 1, 1, 0, 0, 0),
(16060, 39391, 20, 0, 1, 1, 0, 0, 0),
(16060, 39369, 20, 0, 1, 1, 0, 0, 0),
(16060, 39392, 20, 0, 1, 1, 0, 0, 0),
(16060, 39390, 19, 0, 1, 1, 0, 0, 0),
(16060, 39389, 19, 0, 1, 1, 0, 0, 0),
(16060, 39344, 19, 0, 1, 1, 0, 0, 0),
(16060, 39379, 19, 0, 1, 1, 0, 0, 0),
(16060, 39388, 19, 0, 1, 1, 0, 0, 0),
(16060, 39386, 19, 0, 1, 1, 0, 0, 0);

/* The Four Horsemen */

/* Patchwerk - 16028 */

DELETE FROM `creature_loot_template` WHERE (`entry`=16028);
INSERT INTO `creature_loot_template` VALUES 
(16028, 39261, 23, 0, 1, 1, 0, 0, 0),
(16028, 39262, 24, 0, 1, 1, 0, 0, 0),
(16028, 39267, 24, 0, 1, 1, 0, 0, 0),
(16028, 39270, 24, 0, 1, 1, 0, 0, 0),
(16028, 39271, 20, 0, 1, 1, 0, 0, 0),
(16028, 39272, 20, 0, 1, 1, 0, 0, 0),
(16028, 39273, 19, 0, 1, 1, 0, 0, 0),
(16028, 39274, 20, 0, 1, 1, 0, 0, 0),
(16028, 39275, 19, 0, 1, 1, 0, 0, 0),
(16028, 47241, 73, 0, 1, 1, 0, 0, 0);

/* Grobbulus - 15931 */

DELETE FROM `creature_loot_template` WHERE (`entry`=15931);
INSERT INTO `creature_loot_template` VALUES 
(15931, 47241, 73, 0, 1, 1, 0, 0, 0),
(15931, 39279, 19, 0, 1, 1, 0, 0, 0),
(15931, 39282, 19, 0, 1, 1, 0, 0, 0),
(15931, 39285, 19, 0, 1, 1, 0, 0, 0),
(15931, 39281, 19, 0, 1, 1, 0, 0, 0),
(15931, 39280, 19, 0, 1, 1, 0, 0, 0),
(15931, 39283, 19, 0, 1, 1, 0, 0, 0),
(15931, 39278, 18, 0, 1, 1, 0, 0, 0),
(15931, 39284, 18, 0, 1, 1, 0, 0, 0),
(15931, 39277, 18, 0, 1, 1, 0, 0, 0),
(15931, 39276, 18, 0, 1, 1, 0, 0, 0);

/* Gluth - 15932 */


/* Thaddius - 15928 */

DELETE FROM `creature_loot_template` WHERE (`entry`=15928);
INSERT INTO `creature_loot_template` VALUES 
(15928, 47241, 75, 0, 1, 1, 0, 0, 0),
(15928, 40621, 37, 0, 1, 1, 0, 0, 0),
(15928, 40620, 28, 0, 1, 1, 0, 0, 0),
(15928, 40619, 27, 0, 1, 1, 0, 0, 0),
(15928, 39294, 18, 0, 1, 1, 0, 0, 0),
(15928, 39293, 18, 0, 1, 1, 0, 0, 0),
(15928, 39295, 18, 0, 1, 1, 0, 0, 0),
(15928, 39291, 18, 0, 1, 1, 0, 0, 0),
(15928, 39292, 17, 0, 1, 1, 0, 0, 0);

/* Sapphiron - 15989 */

DELETE FROM `creature_loot_template` WHERE (`entry`=15989);
INSERT INTO `creature_loot_template` VALUES 
(15989, 44569, 92, 0, 1, 1, 0, 0, 0),
(15989, 47241, 65, 0, 1, 1, 0, 0, 0),
(15989, 38407, 19, 0, 1, 1, 0, 0, 0),
(15989, 39398, 19, 0, 1, 1, 0, 0, 0),
(15989, 39401, 19, 0, 1, 1, 0, 0, 0),
(15989, 39408, 19, 0, 1, 1, 0, 0, 0),
(15989, 39415, 19, 0, 1, 1, 0, 0, 0),
(15989, 39399, 18, 0, 1, 1, 0, 0, 0),
(15989, 39403, 18, 0, 1, 1, 0, 0, 0),
(15989, 39405, 18, 0, 1, 1, 0, 0, 0),
(15989, 39409, 18, 0, 1, 1, 0, 0, 0),
(15989, 39404, 17, 0, 1, 1, 0, 0, 0);

/* Kel'Thuzad - 15990 */

DELETE FROM `creature_loot_template` WHERE (`entry`=15990);
INSERT INTO `creature_loot_template` VALUES 
(15990, 47241, 71, 0, 2, 2, 0, 0, 0),
(15990, 40618, 39, 0, 1, 1, 0, 0, 0),
(15990, 40616, 28, 0, 1, 1, 0, 0, 0),
(15990, 40617, 28, 0, 1, 1, 0, 0, 0),
(15990, 39425, 19, 0, 1, 1, 0, 0, 0),
(15990, 39421, 19, 0, 1, 1, 0, 0, 0),
(15990, 39416, 19, 0, 1, 1, 0, 0, 0),
(15990, 39419, 19, 0, 1, 1, 0, 0, 0),
(15990, 39422, 19, 0, 1, 1, 0, 0, 0),
(15990, 39424, 19, 0, 1, 1, 0, 0, 0),
(15990, 39426, 19, 0, 1, 1, 0, 0, 0),
(15990, 39420, 18, 0, 1, 1, 0, 0, 0),
(15990, 39417, 18, 0, 1, 1, 0, 0, 0),
(15990, 39423, 18, 0, 1, 1, 0, 0, 0);