[Declined]Azsuna Lion Seal

[Fyriond]

--http://www.wowhead.com/npc=89013/azsuna-lion-seal
-- + 3% chance of 70 order resources
DELETE FROM `creature_loot_template` WHERE `entry`=89013;
UPDATE `creature_template` SET `lootid`='89013' WHERE `entry`='89013';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('89013', '134807', '0.7', '1', '0', '1', '1', ''),
('89013', '129080', '0.5', '1', '0', '1', '1', ''),
('89013', '129067', '01.7', '1', '0', '1', '1', ''),
('89013', '121016', '0.14', '1', '0', '1', '1', ''),
('89013', '121014', '0.03', '1', '0', '1', '1', ''),
('89013', '139522', '0.01', '1', '0', '1', '1', ''),
('89013', '139521', '0.01', '1', '0', '1', '1', ''),
('89013', '132184', '86', '1', '0', '1', '1', ''),
('89013', '132183', '34', '1', '0', '1', '1', ''),
('89013', '124439', '16', '1', '0', '1', '8', ''),
('89013', '132182', '7', '1', '0', '1', '1', ''),
('89013', '138781', '1', '1', '0', '1', '1', ''),
('89013', '121015', '0.4', '1', '0', '1', '1', ''),
('89013', '121040', '0.4', '1', '0', '1', '1', ''),
('89013', '140226', '0.4', '1', '0', '1', '1', ''),
('89013', '121053', '0.4', '1', '0', '1', '1', ''),
('89013', '121012', '0.3', '1', '0', '1', '1', ''),
('89013', '141285', '0.3', '1', '0', '1', '1', ''),
('89013', '121004', '0.3', '1', '0', '1', '1', ''),
('89013', '121005', '0.3', '1', '0', '1', '1', ''),
('89013', '121050', '0.3', '1', '0', '1', '1', ''),
('89013', '121043', '0.2', '1', '0', '1', '1', ''),
('89013', '121017', '0.2', '1', '0', '1', '1', ''),
('89013', '121049', '0.2', '1', '0', '1', '1', ''),
('89013', '121055', '0.2', '1', '0', '1', '1', ''),
('89013', '140224', '0.18', '1', '0', '1', '1', ''),
('89013', '121041', '0.18', '1', '0', '1', '1', ''),
('89013', '121048', '0.18', '1', '0', '1', '1', ''),
('89013', '121045', '0.17', '1', '0', '1', '1', ''),
('89013', '140222', '0.17', '1', '0', '1', '1', ''),
('89013', '121006', '0.17', '1', '0', '1', '1', ''),
('89013', '140220', '0.17', '1', '0', '1', '1', ''),
('89013', '121052', '0.17', '1', '0', '1', '1', ''),
('89013', '121007', '0.13', '1', '0', '1', '1', ''),
('89013', '121054', '0.13', '1', '0', '1', '1', ''),
('89013', '121058', '0.11', '1', '0', '1', '1', ''),
('89013', '121047', '0.11', '1', '0', '1', '1', ''),
('89013', '121020', '0.11', '1', '0', '1', '1', ''),
('89013', '121008', '0.1', '1', '0', '1', '1', ''),
('89013', '121051', '0.1', '1', '0', '1', '1', ''),
('89013', '121019', '0.09', '1', '0', '1', '1', ''),
('89013', '121024', '0.09', '1', '0', '1', '1', ''),
('89013', '132223', '0.09', '1', '0', '1', '1', ''),
('89013', '132218', '0.09', '1', '0', '1', '1', ''),
('89013', '140221', '0.06', '1', '0', '1', '1', ''),
('89013', '140227', '0.04', '1', '0', '1', '1', ''),
('89013', '121046', '0.04', '1', '0', '1', '1', ''),
('89013', '121042', '0.03', '1', '0', '1', '1', ''),
('89013', '140225', '0.03', '1', '0', '1', '1', ''),
('89013', '121044', '0.01', '1', '0', '1', '1', ''),
('89013', '121001', '0.01', '1', '0', '1', '1', ''),
('89013', '121003', '0.01', '1', '0', '1', '1', ''),
('89013', '132200', '0.01', '1', '0', '1', '1', ''),
('89013', '132216', '0.01', '1', '0', '1', '1', '');

 

[Fyriond]

order resources additionally

INSERT INTO `creature_loot_template` VALUES ('89013', '-1220', '3', '1', '0', '70', '70', '0');