[Declined]Thondrax

[Fyriond]

--http://www.wowhead.com/npc=93205/thondrax
-- need to add trigger for +70 Order resources (1220) 27%
DELETE FROM `creature_loot_template` WHERE `entry`=93205;
UPDATE `creature_template` SET `lootid`='93205' WHERE `entry`='93205';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('93205', '138839', '6', '1', '0', '1', '1', ''),
('93205', '130121', '5', '1', '0', '1', '1', ''),
('93205', '137677', '0.4', '1', '0', '1', '1', ''),
('93205', '121217', '0.3', '1', '0', '1', '1', ''),
('93205', '121170', '0.3', '1', '0', '1', '1', ''),
('93205', '121189', '0.3', '1', '0', '1', '1', ''),
('93205', '121177', '0.3', '1', '0', '1', '1', ''),
('93205', '121207', '0.2', '1', '0', '1', '1', ''),
('93205', '121169', '0.2', '1', '0', '1', '1', ''),
('93205', '127925', '0.2', '1', '0', '1', '1', ''),
('93205', '141290', '0.19', '1', '0', '1', '1', ''),
('93205', '138991', '0.19', '1', '0', '1', '1', ''),
('93205', '121182', '0.14', '1', '0', '1', '1', ''),
('93205', '121213', '0.11', '1', '0', '1', '1', ''),
('93205', '121211', '0.11', '1', '0', '1', '1', ''),
('93205', '121184', '0.11', '1', '0', '1', '1', ''),
('93205', '121220', '0.08', '1', '0', '1', '1', ''),
('93205', '121168', '0.08', '1', '0', '1', '1', ''),
('93205', '121171', '0.08', '1', '0', '1', '1', ''),
('93205', '121180', '0.08', '1', '0', '1', '1', ''),
('93205', '121186', '0.08', '1', '0', '1', '1', ''),
('93205', '121188', '0.08', '1', '0', '1', '1', ''),
('93205', '138817', '0.08', '1', '0', '1', '1', ''),
('93205', '121216', '0.05', '1', '0', '1', '1', ''),
('93205', '121192', '0.05', '1', '0', '1', '1', ''),
('93205', '139526', '0.05', '1', '0', '1', '1', ''),
('93205', '121214', '0.03', '1', '0', '1', '1', ''),
('93205', '121219', '0.03', '1', '0', '1', '1', ''),
('93205', '121219', '0.03', '1', '0', '1', '1', ''),
('93205', '121205', '0.03', '1', '0', '1', '1', ''),
('93205', '121210', '0.03', '1', '0', '1', '1', ''),
('93205', '121212', '0.03', '1', '0', '1', '1', ''),
('93205', '121166', '0.03', '1', '0', '1', '1', ''),
('93205', '121172', '0.03', '1', '0', '1', '1', ''),
('93205', '121181', '0.03', '1', '0', '1', '1', ''),
('93205', '121183', '0.03', '1', '0', '1', '1', ''),
('93205', '121187', '0.03', '1', '0', '1', '1', ''),
('93205', '121193', '0.03', '1', '0', '1', '1', ''),
('93205', '132204', '78', '1', '0', '1', '1', ''),
('93205', '132199', '22', '1', '0', '1', '1', ''),
('93205', '132184', '12', '1', '0', '1', '1', ''),
('93205', '124437', '11', '1', '0', '1', '3', ''),
('93205', '132200', '4', '1', '0', '1', '1', ''),
('93205', '132223', '4', '1', '0', '1', '1', ''),
('93205', '132183', '3', '1', '0', '1', '1', ''),
('93205', '132190', '0.6', '1', '0', '1', '1', ''),
('93205', '138781', '0.5', '1', '0', '1', '1', ''),
('93205', '132219', '0.5', '1', '0', '1', '1', ''),
('93205', '140222', '0.4', '1', '0', '1', '1', ''),
('93205', '140226', '0.3', '1', '0', '1', '1', ''),
('93205', '140224', '0.14', '1', '0', '1', '1', ''),
('93205', '140225', '0.11', '1', '0', '1', '1', ''),
('93205', '140221', '0.05', '1', '0', '1', '1', ''),
('93205', '142119', '0.03', '1', '0', '1', '1', '');

 

[Fyriond]

order resources additionally

INSERT INTO `creature_loot_template` VALUES ('93205', '-1220', '27', '1', '0', '70', '70', '0');