MMOCoin

Likes Likes:  0
Results 1 to 9 of 9

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    First Sergeant
    ZomgEary's Avatar
    Join Date
    Jan 2010
    Location
    Houston, TX
    Posts
    182
    Post Thanks / Like
    Rep Power
    18
    Reputation
    83

    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:
    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 10:44 AM. Reason: Changed description



  2. Related Threads - Scroll Down after related threads if you are only interested to view replies for above post/thread

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •