
Results 1 to 9 of 9
Thread: Naxxramas Level 80 Loot(10man)
Threaded View
-
04-02-10, 12:54 PM #1
Naxxramas Level 80 Loot(10man) - TRMs MaNGOS
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);
Last edited by ZomgEary; 17-02-10 at 09:44 AM. Reason: Changed description