Fyriond

Members
  • Content count

    83
  • Joined

  • Last visited

Posts posted by Fyriond


  1. Title: Efflorescence Mushroom Fix
    Bugtracker Link:


    Patch Content:

    NPC-ID http://www.wowhead.com/npc=47649/

    https://trinitycore.atlassian.net/wiki/display/tc/creature_template

    https://trinitycore.atlassian.net/wiki/display/tc/creature_template#creature_template-unit_flags

    Flags used: UNIT_FLAG_PVP_ATTACKABLE (8); UNIT_FLAG_IMMUNE_TO_NPC (512) = 520


     

    Level Fix:
    
    UPDATE `creature_template` SET `minlevel`='110' AND `maxlevel`='110' WHERE `entry`='47649';


     

    Attackeable fix
    
    UPDATE `creature_template` SET `unit_flags`='520' WHERE `entry`='47649';
         
         


  2. --http://www.wowhead.com/npc=14772/east-frostwolf-warmaster
    --http://www.wowhead.com/npc=14776/tower-point-warmaster
    --http://www.wowhead.com/npc=14777/west-frostwolf-warmaster
    --http://www.wowhead.com/npc=11946/drekthar
    --http://www.wowhead.com/npc=14773/iceblood-warmaster
    --http://www.wowhead.com/npc=12122/duros
    --http://www.wowhead.com/npc=12121/drakan
    --http://www.wowhead.com/npc=11947/captain-galvangar
    
    UPDATE `creature_template` SET spell1='8599', spell2='13736', spell3='15589', spell4='40504' WHERE entry='14772';
    UPDATE `creature_template` SET spell1='8599', spell2='13736', spell3='15589', spell4='40504' WHERE entry='14776';
    UPDATE `creature_template` SET spell1='8599', spell2='13736', spell3='15589', spell4='40504' WHERE entry='14777';
    UPDATE `creature_template` SET spell1='8269', spell2='13736', spell3='15589', spell4='19128' WHERE entry='11946';
    UPDATE `creature_template` SET spell1='8599', spell2='13736', spell3='15589', spell4='40504' WHERE entry='14773';
    UPDATE `creature_template` SET spell1='8599', spell2='223971' WHERE entry='12122';
    UPDATE `creature_template` SET spell1='8599', spell2='223971' WHERE entry='12121';
    UPDATE `creature_template` SET spell1='13736', spell2='15284', spell3='15589', spell4='16856' WHERE entry='11947';

     


  3. --http://www.wowhead.com/npc=108133/blacksail-salvor
    
    DELETE FROM `creature_loot_template` WHERE entry='108133';
    INSERT INTO `creature_loot_template` VALUES ('108133', '121001', '0', '0.24', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121002', '0', '0.41', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121004', '0', '0.03', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121005', '0', '0.69', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121006', '0', '0.1', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121008', '0', '0.28', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121012', '0', '0.38', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121015', '0', '0.17', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121016', '0', '0.69', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121017', '0', '0.41', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121018', '0', '0.21', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121019', '0', '0.07', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121020', '0', '0.21', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121021', '0', '0.31', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121023', '0', '0.52', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121024', '0', '0.65', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121027', '0', '0.58', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121028', '0', '0.72', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121040', '0', '0.34', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121041', '0', '0.21', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121042', '0', '0.17', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121043', '0', '0.76', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121044', '0', '0.03', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121045', '0', '0.21', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121046', '0', '0.28', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121047', '0', '0.03', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121048', '0', '0.1', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121049', '0', '0.72', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121050', '0', '0.24', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121051', '0', '0.31', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121052', '0', '0.28', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121053', '0', '0.1', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121054', '0', '0.48', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121055', '0', '0.62', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121333', '0', '1.03', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121334', '0', '0.93', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121335', '0', '1.14', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121336', '0', '0.31', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121337', '0', '0.62', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121338', '0', '0.14', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121340', '0', '0.28', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121341', '0', '0.38', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121342', '0', '0.52', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121343', '0', '0.31', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121344', '0', '0.48', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121345', '0', '0.69', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121346', '0', '1.07', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121347', '0', '1.41', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121348', '0', '1.07', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121349', '0', '0.28', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121350', '0', '0.89', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121352', '0', '0.69', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121353', '0', '0.72', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121354', '0', '0.58', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121355', '0', '0.17', '1', '0', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121356', '0', '0.48', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121357', '0', '0.93', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121359', '0', '0.07', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121360', '0', '0.69', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121361', '0', '1', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121363', '0', '0.96', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121365', '0', '1', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121368', '0', '1.07', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121369', '0', '0.52', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121371', '0', '0.89', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121372', '0', '0.14', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121373', '0', '0.65', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121385', '0', '0.21', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121396', '0', '0.03', '0' ,'1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121400', '0', '0.24', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121401', '0', '0.03', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121406', '0', '0.03', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121407', '0', '0.07', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '121414', '0', '0.45', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '124437', '0', '63.5', '0', '1', '0', '1', '3', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '129081', '0', '0.41', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '132184', '0', '4.06', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '132190', '0', '0.24', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '132223', '0', '0.24', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '138781', '0', '2.55', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '138782', '0', '0.34', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '139520', '0', '0.03', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '139521', '0', '0.07', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '139522', '0', '0.45', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '140220', '0', '0.65', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '140221', '0', '0.89', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '140222', '0', '1', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '140224', '0', '0.1', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '140225', '0', '0.41', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '140226', '0', '1.48', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '140227', '0', '0.07', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '141031', '0', '0.55', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('108133', '141285', '0', '0.65', '0', '1', '0', '1', '1', '');
    UPDATE `creature_template` SET lootid='108133' WHERE entry='108133';

     


  4. --http://www.wowhead.com/npc=107105/broodmother-lizax
    
    DELETE FROM `creature_loot_template` WHERE entry='107105';
    INSERT INTO `creature_loot_template` VALUES ('107105', '121002', '0', '0.74', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '121003', '0', '0.74', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '121014', '0', '0.74', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '121021', '0', '0.49', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '121041', '0', '0.25', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '121042', '0', '1.23', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '121044', '0', '1.23', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '121045', '0', '0.25', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '121050', '0', '1.23',  '0','1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '124437', '0', '10.78', '0', '1', '0', '1', '3', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '127925', '0', '0.74', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '132183', '0', '5.15', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '132184', '0', '39.09', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '132199', '0', '36.64', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '132200', '0', '28.8', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '132204', '0', '30.76', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '137335', '0', '23.04', '0', '1', '0', '2', '3', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '137626', '0', '0.74', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '137677', '0', '1.35', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '138817', '0', '0.74', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '138839', '0', '21.69', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '138991', '0', '0.25', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '140222', '0', '0.49', '0', '1', '0', '1', '1', '');
    INSERT INTO `creature_loot_template` VALUES ('107105', '141869', '0', '30.64', '0', '1', '0', '1', '1', '');
    UPDATE `creature_template` SET lootid='107105' WHERE entry='107105';

     


  5. --http://www.wowhead.com/npc=109504/ragemaw
    DELETE FROM `creature_loot_template` WHERE entry='109504';
    INSERT INTO `creature_loot_template` VALUES ('109504', '121003', '0', '0.08', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '121005', '0', '0.08', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '121020', '0', '0.08', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '121041', '0', '0.08', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '121046', '0', '0.79', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '129075', '0', '93.21', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '132197', '0', '7.73', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '132199', '0', '14.29', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '132204', '0', '3.24', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '132231', '0', '79.32', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '137677', '0', '1.89', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '138839', '0', '21.78', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '138991', '0', '0.39', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '140220', '0', '0.08', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '140224', '0', '0.47', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('109504', '141285', '0', '0.16', '0', '1', '0', '1', '1', '');
    UPDATE `creature_template` SET lootid='109504' WHERE entry='109504';

     


  6. --The creature is regulary released by a ingame-event, which isn't scripted yet. Infernal Lord is nevertheless attackable.
    --http://www.wowhead.com/npc=90803/infernal-lord
    DELETE FROM `creature_loot_template` WHERE entry='90803';
    INSERT INTO `creature_loot_template` VALUES ('90803', '121001', '0', '0.21', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121006', '0', '0.28', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121008', '0', '0.07', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121015', '0', '0.07', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121017', '0', '0.21', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121019', '0', '0.03', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121020', '0', '0.21', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121024', '0', '0.03', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121041', '0', '0.24', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121042', '0', '0.07', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121043', '0', '0.28', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121044', '0', '0.21', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121046', '0', '0.63', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121052', '0', '0.35', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '121054', '0', '0.24', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '127925', '0', '0.21', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '129083', '0', '8.96', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '132197', '0', '0.07', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '132199', '0', '17.92', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '132200', '0', '0.21', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '132204', '0', '78.84', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '132218', '0', '3.31', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '137677', '0', '0.56', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '138781', '0', '0.31', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '138817', '0', '0.24', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '138839', '0', '9.34', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '138991', '0', '0.03', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '139520', '0', '0.03', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '140220', '0', '0.21', '0', '1', '0', '1', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '140221', '0', '0.14', '0', '1', '0', '0', '1', ''),
    INSERT INTO `creature_loot_template` VALUES ('90803', '140226', '0', '0.14', '0', '1', '0', '0', '1', '');
    UPDATE `creature_template` SET lootid='90803' WHERE entry='90803';
    UPDATE `creature_template` SET `unitflags`='1' WHERE `entry`='90803';

     


  7. http://www.wowhead.com/npc=108255/coura-mistress-of-arcana
    DELETE FROM `creature_loot_template` WHERE `entry`=108255;
    UPDATE `creature_template` SET `lootid`='108255' WHERE `entry`='108255';
    INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
    VALUES
    ('108255', '141877', '81', '1', '0', '1', '1', ''),
    ('108255', '138839', '20', '1', '0', '1', '1', ''),
    ('108255', '138007', '0.4', '1', '0', '1', '1', ''),
    ('108255', '139520', '0.09', '1', '0', '1', '1', ''),
    ('108255', '-1220', '83', '1', '0', '70', '70', ''),
    ('108255', '132234', '79', '1', '0', '1', '1', ''),
    ('108255', '132233', '39', '1', '0', '1', '1', ''),
    ('108255', '132212', '17', '1', '0', '1', '1', ''),
    ('108255', '132232', '15', '1', '0', '1', '1', ''),
    ('108255', '132217', '6', '1', '0', '1', '1', ''),
    ('108255', '132213', '', '1', '0', '1', '1', ''),
    ('108255', '121048', '1.9', '1', '0', '1', '1', ''),
    ('108255', '121055', '1.3', '1', '0', '1', '1', ''),
    ('108255', '121047', '1.3', '1', '0', '1', '1', ''),
    ('108255', '140222', '0.9', '1', '0', '1', '1', ''),
    ('108255', '121049', '0.9', '1', '0', '1', '1', ''),
    ('108255', '121050', '0.9', '1', '0', '1', '1', ''),
    ('108255', '121019', '0.9', '1', '0', '1', '1', ''),
    ('108255', '121023', '0.8', '1', '0', '1', '1', ''),
    ('108255', '138781', '0.7', '1', '0', '1', '1', ''),
    ('108255', '121027', '0.6', '1', '0', '1', '1', ''),
    ('108255', '121054', '0.6', '1', '0', '1', '1', ''),
    ('108255', '121043', '0.6', '1', '0', '1', '1', ''),
    ('108255', '121053', '0.5', '1', '0', '1', '1', ''),
    ('108255', '121021', '0.4', '1', '0', '1', '1', ''),
    ('108255', '121040', '0.3', '1', '0', '1', '1', ''),
    ('108255', '121017', '0.09', '1', '0', '1', '1', ''),
    ('108255', '140226', '0.09', '1', '0', '1', '1', ''),
    ('108255', '121004', '0.09', '1', '0', '1', '1', ''),
    ('108255', '121052', '0.09', '1', '0', '1', '1', '');