[Declined]Perrexx

[Fyriond]

--http://www.wowhead.com/npc=95318/perrexx
-- need to add trigger for +70 Order resources (1220) 29%
DELETE FROM `creature_loot_template` WHERE `entry`=95318;
UPDATE `creature_template` SET `lootid`='95318' WHERE `entry`='95318';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('95318', '138839', '7', '1', '0', '1', '1', ''),
('95318', '130137', '5', '1', '0', '1', '1', ''),
('95318', '124118', '3', '1', '0', '1', '2', ''),
('95318', '138817', '0.6', '1', '0', '1', '1', ''),
('95318', '137677', '0.6', '1', '0', '1', '1', ''),
('95318', '121206', '0.4', '1', '0', '1', '1', ''),
('95318', '121213', '0.3', '1', '0', '1', '1', ''),
('95318', '121209', '0.3', '1', '0', '1', '1', ''),
('95318', '121186', '0.3', '1', '0', '1', '1', ''),
('95318', '138991', '0.3', '1', '0', '1', '1', ''),
('95318', '121217', '0.19', '1', '0', '1', '1', ''),
('95318', '121218', '0.19', '1', '0', '1', '1', ''),
('95318', '121212', '0.19', '1', '0', '1', '1', ''),
('95318', '121168', '0.16', '1', '0', '1', '1', ''),
('95318', '121214', '0.13', '1', '0', '1', '1', ''),
('95318', '121208', '0.13', '1', '0', '1', '1', ''),
('95318', '121211', '0.13', '1', '0', '1', '1', ''),
('95318', '121170', '0.13', '1', '0', '1', '1', ''),
('95318', '121180', '0.13', '1', '0', '1', '1', ''),
('95318', '121179', '0.13', '1', '0', '1', '1', ''),
('95318', '121177', '0.13', '1', '0', '1', '1', ''),
('95318', '121205', '0.1', '1', '0', '1', '1', ''),
('95318', '121210', '0.1', '1', '0', '1', '1', ''),
('95318', '121171', '0.1', '1', '0', '1', '1', ''),
('95318', '121188', '0.1', '1', '0', '1', '1', ''),
('95318', '121193', '0.1', '1', '0', '1', '1', ''),
('95318', '121215', '0.06', '1', '0', '1', '1', ''),
('95318', '141290', '0.06', '1', '0', '1', '1', ''),
('95318', '121167', '0.06', '1', '0', '1', '1', ''),
('95318', '121187', '0.06', '1', '0', '1', '1', ''),
('95318', '121207', '0.03', '1', '0', '1', '1', ''),
('95318', '121166', '0.03', '1', '0', '1', '1', ''),
('95318', '121172', '0.03', '1', '0', '1', '1', ''),
('95318', '121182', '0.03', '1', '0', '1', '1', ''),
('95318', '121185', '0.03', '1', '0', '1', '1', ''),
('95318', '121192', '0.03', '1', '0', '1', '1', ''),
('95318', '127925', '0.03', '1', '0', '1', '1', ''),
('95318', '132204', '81', '1', '0', '1', '1', ''),
('95318', '132231', '41', '1', '0', '1', '1', ''),
('95318', '132199', '26', '1', '0', '1', '1', ''),
('95318', '124437', '10', '1', '0', '1', '3', ''),
('95318', '132200', '5', '1', '0', '1', '1', ''),
('95318', '132197', '4', '1', '0', '1', '1', ''),
('95318', '138781', '0.7', '1', '0', '1', '1', ''),
('95318', '140222', '0.5', '1', '0', '1', '1', ''),
('95318', '140226', '0.5', '1', '0', '1', '1', ''),
('95318', '140224', '0.3', '1', '0', '1', '1', ''),
('95318', '124439', '0.3', '1', '0', '1', '4', ''),
('95318', '124438', '0.19', '1', '0', '3', '4', ''),
('95318', '141291', '0.13', '1', '0', '1', '1', ''),
('95318', '138782', '0.1', '1', '0', '1', '1', ''),
('95318', '132185', '0.6', '1', '0', '1', '1', ''),
('95318', '140221', '0.3', '1', '0', '1', '1', ''),
('95318', '140225', '0.3', '1', '0', '1', '1', ''),
('95318', '140220', '0.3', '1', '0', '1', '1', ''),
('95318', '142119', '0.3', '1', '0', '1', '1', '');

 

[Fyriond]

order resources additionally

INSERT INTO `creature_loot_template` VALUES ('95318', '-1220', '29', '1', '0', '70', '70', '0');