[Declined]Seersei

[Fyriond]

--http://www.wowhead.com/npc=92180/seersei
-- need to add trigger for +70 Order resources (1220) 62%
DELETE FROM `creature_loot_template` WHERE `entry`=92180;
UPDATE `creature_template` SET `lootid`='92180' WHERE `entry`='92180';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('92180', '130171', '62', '1', '0', '1', '1', ''),
('92180', '138839', '12', '1', '0', '1', '1', ''),
('92180', '121170', '0.6', '1', '0', '1', '1', ''),
('92180', '121173', '0.5', '1', '0', '1', '1', ''),
('92180', '121219', '0.4', '1', '0', '1', '1', ''),
('92180', '141290', '0.4', '1', '0', '1', '1', ''),
('92180', '121166', '0.4', '1', '0', '1', '1', ''),
('92180', '121179', '0.4', '1', '0', '1', '1', ''),
('92180', '121189', '0.4', '1', '0', '1', '1', ''),
('92180', '139527', '0.4', '1', '0', '1', '1', ''),
('92180', '139526', '0.4', '1', '0', '1', '1', ''),
('92180', '121218', '0.3', '1', '0', '1', '1', ''),
('92180', '121220', '0.3', '1', '0', '1', '1', ''),
('92180', '121214', '0.2', '1', '0', '1', '1', ''),
('92180', '121217', '0.2', '1', '0', '1', '1', ''),
('92180', '121205', '0.2', '1', '0', '1', '1', ''),
('92180', '121211', '0.2', '1', '0', '1', '1', ''),
('92180', '121212', '0.2', '1', '0', '1', '1', ''),
('92180', '121076', '0.2', '1', '0', '1', '1', ''),
('92180', '121172', '0.2', '1', '0', '1', '1', ''),
('92180', '121181', '0.2', '1', '0', '1', '1', ''),
('92180', '121186', '0.2', '1', '0', '1', '1', ''),
('92180', '121183', '0.14', '1', '0', '1', '1', ''),
('92180', '121188', '0.14', '1', '0', '1', '1', ''),
('92180', '121213', '0.07', '1', '0', '1', '1', ''),
('92180', '121167', '0.07', '1', '0', '1', '1', ''),
('92180', '121182', '0.07', '1', '0', '1', '1', ''),
('92180', '121184', '0.07', '1', '0', '1', '1', ''),
('92180', '121208', '0.04', '1', '0', '1', '1', ''),
('92180', '124437', '30', '1', '0', '1', '3', ''),
('92180', '138781', '1.3', '1', '0', '1', '1', ''),
('92180', '121371', '1.2', '1', '0', '1', '1', ''),
('92180', '140226', '1', '1', '0', '1', '1', ''),
('92180', '121332', '0.9', '1', '0', '1', '1', ''),
('92180', '140222', '0.8', '1', '0', '1', '1', ''),
('92180', '121357', '0.8', '1', '0', '1', '1', ''),
('92180', '121346', '0.8', '1', '0', '1', '1', ''),
('92180', '121339', '0.6', '1', '0', '1', '1', ''),
('92180', '121361', '0.6', '1', '0', '1', '1', ''),
('92180', '121356', '0.6', '1', '0', '1', '1', ''),
('92180', '121365', '0.6', '1', '0', '1', '1', ''),
('92180', '140224', '0.5', '1', '0', '1', '1', ''),
('92180', '121335', '0.5', '1', '0', '1', '1', ''),
('92180', '121351', '0.5', '1', '0', '1', '1', ''),
('92180', '121337', '0.4', '1', '0', '1', '1', ''),
('92180', '121333', '0.4', '1', '0', '1', '1', ''),
('92180', '121394', '0.4', '1', '0', '1', '1', ''),
('92180', '121347', '0.4', '1', '0', '1', '1', ''),
('92180', '121358', '0.4', '1', '0', '1', '1', ''),
('92180', '121372', '0.4', '1', '0', '1', '1', ''),
('92180', '121368', '0.4', '1', '0', '1', '1', ''),
('92180', '121360', '0.4', '1', '0', '1', '1', ''),
('92180', '121353', '0.4', '1', '0', '1', '1', ''),
('92180', '121370', '0.4', '1', '0', '1', '1', ''),
('92180', '121349', '0.4', '1', '0', '1', '1', ''),
('92180', '121350', '0.3', '1', '0', '1', '1', ''),
('92180', '121343', '0.3', '1', '0', '1', '1', ''),
('92180', '121362', '0.3', '1', '0', '1', '1', ''),
('92180', '140227', '0.2', '1', '0', '1', '1', ''),
('92180', '121334', '0.2', '1', '0', '1', '1', ''),
('92180', '121342', '0.2', '1', '0', '1', '1', ''),
('92180', '121344', '0.2', '1', '0', '1', '1', ''),
('92180', '121409', '0.2', '1', '0', '1', '1', ''),
('92180', '121363', '0.2', '1', '0', '1', '1', ''),
('92180', '121345', '0.2', '1', '0', '1', '1', ''),
('92180', '121359', '0.2', '1', '0', '1', '1', ''),
('92180', '121336', '0.14', '1', '0', '1', '1', ''),
('92180', '121354', '0.14', '1', '0', '1', '1', ''),
('92180', '121373', '0.14', '1', '0', '1', '1', ''),
('92180', '132186', '0.07', '1', '0', '1', '1', ''),
('92180', '121340', '0.07', '1', '0', '1', '1', ''),
('92180', '121348', '0.07', '1', '0', '1', '1', ''),
('92180', '121369', '0.07', '1', '0', '1', '1', ''),
('92180', '140220', '0.04', '1', '0', '1', '1', ''),
('92180', '121366', '0.04', '1', '0', '1', '1', ''),
('92180', '121367', '0.04', '1', '0', '1', '1', '');

 

[Fyriond]

order resources additionally

INSERT INTO `creature_loot_template` VALUES ('92180', '-1220', '62', '1', '0', '70', '70', '0');