Fyriond

Members
 View profile  See their activity

  • Content count

    83

  • Joined

  • Last visited

Posts posted by Fyriond

  7. Posted 

    --http://www.wowhead.com/npc=90379/withered-exile
DELETE FROM `creature_loot_template` WHERE `entry`=90379;
UPDATE `creature_template` SET `lootid`='90379' WHERE `entry`='90379';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('90379', '136850', '37', '1', '0', '1', '1', ''),
('90379', '129153', '1.2', '1', '0', '1', '1', ''),
('90379', '124117', '0.3', '1', '0', '1', '2', ''),
('90379', '127038', '0.2', '1', '0', '1', '1', ''),
('90379', '129105', '0.14', '1', '0', '1', '1', ''),
('90379', '121014', '0.05', '1', '0', '1', '1', ''),
('90379', '122153', '0.05', '1', '0', '1', '1', ''),
('90379', '121016', '0.02', '1', '0', '1', '1', ''),
('90379', '139521', '0.02', '1', '0', '1', '1', ''),
('90379', '141582', '0.01', '1', '0', '1', '1', ''),
('90379', '141919', '0.01', '1', '0', '1', '1', ''),
('90379', '139522', '0.01', '1', '0', '1', '1', ''),
('90379', '139520', '0.01', '1', '0', '1', '1', ''),
('90379', '132212', '70', '1', '0', '1', '1', ''),
('90379', '132217', '19', '1', '0', '1', '1', ''),
('90379', '124437', '14', '1', '0', '1', '1', ''),
('90379', '132213', '9', '1', '0', '1', '1', ''),
('90379', '138781', '0.5', '1', '0', '1', '1', ''),
('90379', '140226', '0.3', '1', '0', '1', '1', ''),
('90379', '132231', '0.3', '1', '0', '1', '1', ''),
('90379', '140222', '0.2', '1', '0', '1', '1', ''),
('90379', '140221', '0.15', '1', '0', '1', '1', ''),
('90379', '121021', '0.14', '1', '0', '1', '1', ''),
('90379', '121023', '0.13', '1', '0', '1', '1', ''),
('90379', '141285', '0.13', '1', '0', '1', '1', ''),
('90379', '121048', '0.12', '1', '0', '1', '1', ''),
('90379', '121044', '0.1', '1', '0', '1', '1', ''),
('90379', '121027', '0.09', '1', '0', '1', '1', ''),
('90379', '121040', '0.09', '1', '0', '1', '1', ''),
('90379', '121046', '0.09', '1', '0', '1', '1', ''),
('90379', '121017', '0.09', '1', '0', '1', '1', ''),
('90379', '121054', '0.09', '1', '0', '1', '1', ''),
('90379', '121001', '0.08', '1', '0', '1', '1', ''),
('90379', '121007', '0.08', '1', '0', '1', '1', ''),
('90379', '140220', '0.08', '1', '0', '1', '1', ''),
('90379', '121051', '0.08', '1', '0', '1', '1', ''),
('90379', '138782', '0.07', '1', '0', '1', '1', ''),
('90379', '121012', '0.07', '1', '0', '1', '1', ''),
('90379', '140224', '0.07', '1', '0', '1', '1', ''),
('90379', '121043', '0.07', '1', '0', '1', '1', ''),
('90379', '121019', '0.07', '1', '0', '1', '1', ''),
('90379', '121050', '0.07', '1', '0', '1', '1', ''),
('90379', '121045', '0.06', '1', '0', '1', '1', ''),
('90379', '121018', '0.06', '1', '0', '1', '1', ''),
('90379', '121002', '0.06', '1', '0', '1', '1', ''),
('90379', '121003', '0.06', '1', '0', '1', '1', ''),
('90379', '121004', '0.06', '1', '0', '1', '1', ''),
('90379', '121006', '0.06', '1', '0', '1', '1', ''),
('90379', '121053', '0.06', '1', '0', '1', '1', ''),
('90379', '121015', '0.05', '1', '0', '1', '1', ''),
('90379', '140227', '0.05', '1', '0', '1', '1', ''),
('90379', '121041', '0.05', '1', '0', '1', '1', ''),
('90379', '121042', '0.05', '1', '0', '1', '1', ''),
('90379', '121020', '0.05', '1', '0', '1', '1', ''),
('90379', '121024', '0.05', '1', '0', '1', '1', ''),
('90379', '121005', '0.05', '1', '0', '1', '1', ''),
('90379', '121008', '0.05', '1', '0', '1', '1', ''),
('90379', '121052', '0.05', '1', '0', '1', '1', ''),
('90379', '121047', '0.04', '1', '0', '1', '1', ''),
('90379', '140225', '0.04', '1', '0', '1', '1', ''),
('90379', '121055', '0.04', '1', '0', '1', '1', ''),
('90379', '121049', '0.04', '1', '0', '1', '1', ''),
('90379', '142119', '0.01', '1', '0', '1', '1', '');

     

  8. Posted 

    --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', '');

     

  9. Posted · Edited by Fyriond 

    --https://firestorm-servers.com/en/report/see_report/24134
--Loot fix
--http://www.wowhead.com/npc=107657/arcanist-shaliman
-- + 36% chance of 70 order resources
DELETE FROM `creature_loot_template` WHERE `entry`=107657;
UPDATE `creature_template` SET `lootid`='107657' WHERE `entry`='107657';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('107657', '138839', '10', '1', '0', '1', '1', ''),
('107657', '141868', '8', '1', '0', '1', '1', ''),
('107657', '121014', '0.1', '1', '0', '1', '1', ''),
('107657', '132233', '85', '1', '0', '1', '1', ''),
('107657', '132234', '35', '1', '0', '1', '1', ''),
('107657', '132232', '11', '1', '0', '1', '1', ''),
('107657', '138781', '0.6', '1', '0', '1', '1', ''),
('107657', '140221', '0.5', '1', '0', '1', '1', ''),
('107657', '140226', '0.5', '1', '0', '1', '1', ''),
('107657', '140224', '0.4', '1', '0', '1', '1', ''),
('107657', '121024', '0.4', '1', '0', '1', '1', ''),
('107657', '121043', '0.3', '1', '0', '1', '1', ''),
('107657', '121047', '0.3', '1', '0', '1', '1', ''),
('107657', '140222', '0.3', '1', '0', '1', '1', ''),
('107657', '121051', '0.3', '1', '0', '1', '1', ''),
('107657', '121052', '0.3', '1', '0', '1', '1', ''),
('107657', '141285', '0.2', '1', '0', '1', '1', ''),
('107657', '121048', '0.2', '1', '0', '1', '1', ''),
('107657', '121049', '0.2', '1', '0', '1', '1', ''),
('107657', '121027', '0.18', '1', '0', '1', '1', ''),
('107657', '121041', '0.15', '1', '0', '1', '1', ''),
('107657', '121044', '0.15', '1', '0', '1', '1', ''),
('107657', '121008', '0.15', '1', '0', '1', '1', ''),
('107657', '140220', '0.15', '1', '0', '1', '1', ''),
('107657', '121028', '0.15', '1', '0', '1', '1', ''),
('107657', '121018', '0.13', '1', '0', '1', '1', ''),
('107657', '121055', '0.13', '1', '0', '1', '1', ''),
('107657', '140227', '0.13', '1', '0', '1', '1', ''),
('107657', '121040', '0.1', '1', '0', '1', '1', ''),
('107657', '121020', '0.1', '1', '0', '1', '1', ''),
('107657', '121002', '0.1', '1', '0', '1', '1', ''),
('107657', '121004', '0.1', '1', '0', '1', '1', ''),
('107657', '121005', '0.1', '1', '0', '1', '1', ''),
('107657', '121006', '0.1', '1', '0', '1', '1', ''),
('107657', '121012', '0.1', '1', '0', '1', '1', ''),
('107657', '121003', '0.08', '1', '0', '1', '1', ''),
('107657', '121007', '0.08', '1', '0', '1', '1', ''),
('107657', '121019', '0.05', '1', '0', '1', '1', ''),
('107657', '121050', '0.05', '1', '0', '1', '1', ''),
('107657', '121054', '0.05', '1', '0', '1', '1', ''),
('107657', '121001', '0.03', '1', '0', '1', '1', ''),
('107657', '121053', '0.03', '1', '0', '1', '1', '');

     

  10. Posted 

    --http://www.wowhead.com/npc=107136/houndmaster-stroxis
-- + 43% chance of 70 order resources
DELETE FROM `creature_loot_template` WHERE `entry`=107136;
UPDATE `creature_template` SET `lootid`='107136' WHERE `entry`='107136';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('107136', '138839', '9', '1', '0', '1', '1', ''),
('107136', '141873', '8', '1', '0', '1', '1', ''),
('107136', '138991', '1', '1', '0', '1', '1', ''),
('107136', '137677', '0.6', '1', '0', '1', '1', ''),
('107136', '121017', '0.4', '1', '0', '1', '1', ''),
('107136', '121012', '0.3', '1', '0', '1', '1', ''),
('107136', '121049', '0.3', '1', '0', '1', '1', ''),
('107136', '121050', '0.3', '1', '0', '1', '1', ''),
('107136', '121055', '0.3', '1', '0', '1', '1', ''),
('107136', '121041', '0.2', '1', '0', '1', '1', ''),
('107136', '121018', '0.2', '1', '0', '1', '1', ''),
('107136', '121052', '0.2', '1', '0', '1', '1', ''),
('107136', '138817', '0.2', '1', '0', '1', '1', ''),
('107136', '121046', '0.17', '1', '0', '1', '1', ''),
('107136', '121020', '0.17', '1', '0', '1', '1', ''),
('107136', '121008', '0.17', '1', '0', '1', '1', ''),
('107136', '121019', '0.11', '1', '0', '1', '1', ''),
('107136', '121006', '0.11', '1', '0', '1', '1', ''),
('107136', '132749', '0.11', '1', '0', '1', '1', ''),
('107136', '121016', '0.06', '1', '0', '1', '1', ''),
('107136', '121043', '0.06', '1', '0', '1', '1', ''),
('107136', '121044', '0.06', '1', '0', '1', '1', ''),
('107136', '121045', '0.06', '1', '0', '1', '1', ''),
('107136', '121002', '0.06', '1', '0', '1', '1', ''),
('107136', '121007', '0.06', '1', '0', '1', '1', ''),
('107136', '121023', '0.03', '1', '0', '1', '1', '');

     

  11. Posted 

    --http://www.wowhead.com/npc=107327/bilebrain
-- + 90% chance of 70 order resources
DELETE FROM `creature_loot_template` WHERE `entry`=107327;
UPDATE `creature_template` SET `lootid`='107327' WHERE `entry`='107327';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('107327', '129079', '29', '1', '0', '1', '1', ''),
('107327', '138839', '28', '1', '0', '1', '1', ''),
('107327', '138991', '2', '1', '0', '1', '1', ''),
('107327', '137677', '1.2', '1', '0', '1', '1', ''),
('107327', '121043', '0.8', '1', '0', '1', '1', ''),
('107327', '121047', '0.6', '1', '0', '1', '1', ''),
('107327', '121023', '0.5', '1', '0', '1', '1', ''),
('107327', '121055', '0.5', '1', '0', '1', '1', ''),
('107327', '121046', '0.3', '1', '0', '1', '1', ''),
('107327', '121052', '0.3', '1', '0', '1', '1', ''),
('107327', '121014', '0.15', '1', '0', '1', '1', ''),
('107327', '138817', '0.15', '1', '0', '1', '1', ''),
('107327', '132749', '0.15', '1', '0', '1', '1', ''),
('107327', '121003', '0.08', '1', '0', '1', '1', ''),
('107327', '121050', '0.08', '1', '0', '1', '1', ''),
('107327', '137623', '0.08', '1', '0', '1', '1', '');

     

  12. Posted 

    --http://www.wowhead.com/npc=107113/vorthax
-- + 34% chance of 70 order resources
DELETE FROM `creature_loot_template` WHERE `entry`=107113;
UPDATE `creature_template` SET `lootid`='107113' WHERE `entry`='107113';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('107113', '138839', '9', '1', '0', '1', '1', ''),
('107113', '141875', '7', '1', '0', '1', '1', ''),
('107113', '137677', '1.3', '1', '0', '1', '1', ''),
('107113', '138991', '0.6', '1', '0', '1', '1', ''),
('107113', '138817', '0.3', '1', '0', '1', '1', ''),
('107113', '121046', '0.2', '1', '0', '1', '1', ''),
('107113', '121053', '0.2', '1', '0', '1', '1', ''),
('107113', '121002', '0.18', '1', '0', '1', '1', ''),
('107113', '121016', '0.14', '1', '0', '1', '1', ''),
('107113', '121014', '0.14', '1', '0', '1', '1', ''),
('107113', '121003', '0.14', '1', '0', '1', '1', ''),
('107113', '121048', '0.14', '1', '0', '1', '1', ''),
('107113', '121049', '0.14', '1', '0', '1', '1', ''),
('107113', '137626', '0.14', '1', '0', '1', '1', ''),
('107113', '139520', '0.14', '1', '0', '1', '1', ''),
('107113', '121043', '0.09', '1', '0', '1', '1', ''),
('107113', '121028', '0.05', '1', '0', '1', '1', ''),
('107113', '121042', '0.05', '1', '0', '1', '1', '');

     

  13. Posted 

    --http://www.wowhead.com/npc=90505/syphonus
-- + 25% chance of 70 order resources
DELETE FROM `creature_loot_template` WHERE `entry`=90505;
UPDATE `creature_template` SET `lootid`='90505' WHERE `entry`='90505';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('90505', '129064', '7', '1', '0', '1', '1', ''),
('90505', '138839', '6', '1', '0', '1', '1', ''),
('90505', '121040', '0.2', '1', '0', '1', '1', ''),
('90505', '121046', '0.17', '1', '0', '1', '1', ''),
('90505', '121049', '0.17', '1', '0', '1', '1', ''),
('90505', '121015', '0.1', '1', '0', '1', '1', ''),
('90505', '121041', '0.1', '1', '0', '1', '1', ''),
('90505', '121043', '0.1', '1', '0', '1', '1', ''),
('90505', '121020', '0.1', '1', '0', '1', '1', ''),
('90505', '121021', '0.1', '1', '0', '1', '1', ''),
('90505', '121001', '0.1', '1', '0', '1', '1', ''),
('90505', '121053', '0.1', '1', '0', '1', '1', ''),
('90505', '121016', '0.07', '1', '0', '1', '1', ''),
('90505', '121003', '0.07', '1', '0', '1', '1', ''),
('90505', '121044', '0.02', '1', '0', '1', '1', '');

     

  14. Posted 

    --http://www.wowhead.com/npc=97504/wraithtalon
-- need to add trigger for +70 Order resources (1220) 75%
DELETE FROM `creature_loot_template` WHERE `entry`=97504;
UPDATE `creature_template` SET `lootid`='97504' WHERE `entry`='97504';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('97504', '124120', '69', '1', '0', '2', '4', ''),
('97504', '130116', '24', '1', '0', '1', '1', ''),
('97504', '138839', '21', '1', '0', '1', '1', ''),
('97504', '121187', '0.9', '1', '0', '1', '1', ''),
('97504', '121168', '0.2', '1', '0', '1', '1', ''),
('97504', '121169', '0.2', '1', '0', '1', '1', ''),
('97504', '121171', '0.2', '1', '0', '1', '1', ''),
('97504', '121182', '0.2', '1', '0', '1', '1', ''),
('97504', '121184', '0.2', '1', '0', '1', '1', ''),
('97504', '121189', '0.2', '1', '0', '1', '1', ''),
('97504', '121216', '0.16', '1', '0', '1', '1', ''),
('97504', '121209', '0.16', '1', '0', '1', '1', ''),
('97504', '121170', '0.08', '1', '0', '1', '1', ''),
('97504', '121177', '0.04', '1', '0', '1', '1', ''),
('97504', '132231', '79', '1', '0', '1', '1', ''),
('97504', '132183', '16', '1', '0', '1', '1', ''),
('97504', '124438', '6', '1', '0', '1', '4', ''),
('97504', '132204', '6', '1', '0', '1', '1', ''),
('97504', '132185', '4', '1', '0', '1', '1', ''),
('97504', '132223', '0.4', '1', '0', '1', '1', ''),
('97504', '138781', '0.2', '1', '0', '1', '1', ''),
('97504', '140224', '0.2', '1', '0', '1', '1', ''),
('97504', '140222', '0.2', '1', '0', '1', '1', ''),
('97504', '132184', '0.2', '1', '0', '1', '1', ''),
('97504', '121393', '0.2', '1', '0', '1', '1', ''),
('97504', '121355', '0.2', '1', '0', '1', '1', ''),
('97504', '140227', '0.08', '1', '0', '1', '1', ''),
('97504', '140221', '0.08', '1', '0', '1', '1', ''),
('97504', '140226', '0.08', '1', '0', '1', '1', ''),
('97504', '140220', '0.08', '1', '0', '1', '1', ''),
('97504', '121363', '0.08', '1', '0', '1', '1', ''),
('97504', '121346', '0.08', '1', '0', '1', '1', '');

     

  15. Posted 

    --http://www.wowhead.com/npc=109708/undergrell-ringleader
-- need to add trigger for +70 Order resources (1220) 96%
DELETE FROM `creature_loot_template` WHERE `entry`=109708;
UPDATE `creature_template` SET `lootid`='109708' WHERE `entry`='109708';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('109708', '130133', '97', '1', '0', '1', '1', ''),
('109708', '138839', '24', '1', '0', '1', '1', ''),
('109708', '124118', '9', '1', '0', '1', '2', ''),
('109708', '121180', '2', '1', '0', '1', '1', ''),
('109708', '121206', '1.6', '1', '0', '1', '1', ''),
('109708', '121209', '1.6', '1', '0', '1', '1', ''),
('109708', '121168', '1', '1', '0', '1', '1', ''),
('109708', '121184', '1', '1', '0', '1', '1', ''),
('109708', '121216', '0.7', '1', '0', '1', '1', ''),
('109708', '121177', '0.7', '1', '0', '1', '1', ''),
('109708', '121166', '0.3', '1', '0', '1', '1', ''),
('109708', '138817', '0.3', '1', '0', '1', '1', ''),
('109708', '137677', '0.3', '1', '0', '1', '1', ''),
('109708', '136709', '0.16', '1', '0', '1', '1', ''),
('109708', '132204', '98', '1', '0', '1', '1', ''),
('109708', '132223', '25', '1', '0', '1', '1', ''),
('109708', '132199', '24', '1', '0', '1', '1', ''),
('109708', '132231', '17', '1', '0', '1', '1', ''),
('109708', '132219', '5', '1', '0', '1', '1', ''),
('109708', '124439', '4', '1', '0', '3', '4', ''),
('109708', '132218', '3', '1', '0', '1', '1', ''),
('109708', '132183', '1.1', '1', '0', '1', '1', ''),
('109708', '124438', '1', '1', '0', '4', '4', ''),
('109708', '132185', '1', '1', '0', '1', '1', ''),
('109708', '142119', '0.3', '1', '0', '1', '1', '');

     

  16. Posted 

    --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', '');

     

  17. Posted 

    --http://www.wowhead.com/npc=93654/skulvrax
-- need to add trigger for +70 Order resources (1220) 40%
DELETE FROM `creature_loot_template` WHERE `entry`=93654;
UPDATE `creature_template` SET `lootid`='93654' WHERE `entry`='93654';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('93654', '130115', '10', '1', '0', '1', '1', ''),
('93654', '138839', '10', '1', '0', '1', '1', ''),
('93654', '121219', '0.7', '1', '0', '1', '1', ''),
('93654', '121166', '0.4', '1', '0', '1', '1', ''),
('93654', '121169', '0.3', '1', '0', '1', '1', ''),
('93654', '121181', '0.3', '1', '0', '1', '1', ''),
('93654', '121177', '0.3', '1', '0', '1', '1', ''),
('93654', '137677', '0.3', '1', '0', '1', '1', ''),
('93654', '138991', '0.2', '1', '0', '1', '1', ''),
('93654', '138817', '0.17', '1', '0', '1', '1', ''),
('93654', '121215', '0.13', '1', '0', '1', '1', ''),
('93654', '121173', '0.13', '1', '0', '1', '1', ''),
('93654', '121182', '0.13', '1', '0', '1', '1', ''),
('93654', '121186', '0.13', '1', '0', '1', '1', ''),
('93654', '121189', '0.13', '1', '0', '1', '1', ''),
('93654', '139526', '0.13', '1', '0', '1', '1', ''),
('93654', '121213', '0.09', '1', '0', '1', '1', ''),
('93654', '121188', '0.09', '1', '0', '1', '1', ''),
('93654', '139528', '0.09', '1', '0', '1', '1', ''),
('93654', '121207', '0.04', '1', '0', '1', '1', ''),
('93654', '121187', '0.04', '1', '0', '1', '1', ''),
('93654', '121217', '0.02', '1', '0', '1', '1', ''),
('93654', '121208', '0.02', '1', '0', '1', '1', ''),
('93654', '132204', '71', '1', '0', '1', '1', ''),
('93654', '132199', '25', '1', '0', '1', '1', ''),
('93654', '124437', '12', '1', '0', '1', '3', ''),
('93654', '132200', '3', '1', '0', '1', '1', ''),
('93654', '138781', '0.3', '1', '0', '1', '1', ''),
('93654', '141291', '0.13', '1', '0', '1', '1', ''),
('93654', '124439', '0.13', '1', '0', '4', '4', ''),
('93654', '140224', '0.09', '1', '0', '1', '1', ''),
('93654', '140226', '0.09', '1', '0', '1', '1', ''),
('93654', '140220', '0.09', '1', '0', '1', '1', ''),
('93654', '140227', '0.04', '1', '0', '1', '1', ''),
('93654', '140222', '0.04', '1', '0', '1', '1', '');

     

  18. Posted 

    --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', '');

     

  19. Posted 

    --http://www.wowhead.com/npc=94485/pollous-the-fetid
-- need to add trigger for +70 Order resources (1220) 87%
DELETE FROM `creature_loot_template` WHERE `entry`=94485;
UPDATE `creature_template` SET `lootid`='94485' WHERE `entry`='94485';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('94485', '130168', '87', '1', '0', '1', '1', ''),
('94485', '138839', '20', '1', '0', '1', '1', ''),
('94485', '121216', '0.4', '1', '0', '1', '1', ''),
('94485', '121219', '0.4', '1', '0', '1', '1', ''),
('94485', '121168', '0.4', '1', '0', '1', '1', ''),
('94485', '121188', '0.4', '1', '0', '1', '1', ''),
('94485', '121215', '0.13', '1', '0', '1', '1', ''),
('94485', '121205', '0.13', '1', '0', '1', '1', ''),
('94485', '132212', '78', '1', '0', '1', '1', ''),
('94485', '132223', '19', '1', '0', '1', '1', ''),
('94485', '132184', '15', '1', '0', '1', '1', ''),
('94485', '132204', '8', '1', '0', '1', '1', ''),
('94485', '132218', '5', '1', '0', '1', '1', ''),
('94485', '132183', '4', '1', '0', '1', '1', ''),
('94485', '138781', '0.8', '1', '0', '1', '1', ''),
('94485', '132190', '0.7', '1', '0', '1', '1', ''),
('94485', '140226', '0.4', '1', '0', '1', '1', ''),
('94485', '132219', '0.13', '1', '0', '1', '1', '');

     

  20. Posted 

    --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', '');

     

  21. Posted 

    --http://www.wowhead.com/npc=95221/mad-henryk
-- need to add trigger for +70 Order resources (1220) 98%
DELETE FROM `creature_loot_template` WHERE `entry`=95221;
UPDATE `creature_template` SET `lootid`='95221' WHERE `entry`='95221';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('95221', '130214', '99', '1', '0', '1', '1', ''),
('95221', '138839', '21', '1', '0', '1', '1', ''),
('95221', '141290', '1', '1', '0', '1', '1', ''),
('95221', '121166', '1', '1', '0', '1', '1', ''),
('95221', '121212', '0.6', '1', '0', '1', '1', ''),
('95221', '141031', '0.6', '1', '0', '1', '1', ''),
('95221', '121185', '0.19', '1', '0', '1', '1', ''),
('95221', '124437', '16', '1', '0', '1', '1', ''),
('95221', '132231', '4', '1', '0', '1', '1', ''),
('95221', '121343', '1.3', '1', '0', '1', '1', ''),
('95221', '140224', '1', '1', '0', '1', '1', ''),
('95221', '124439', '0.6', '1', '0', '1', '1', ''),
('95221', '121340', '0.6', '1', '0', '1', '1', ''),
('95221', '121336', '0.6', '1', '0', '1', '1', ''),
('95221', '121366', '0.6', '1', '0', '1', '1', ''),
('95221', '121362', '0.6', '1', '0', '1', '1', ''),
('95221', '121355', '0.6', '1', '0', '1', '1', ''),
('95221', '140222', '0.4', '1', '0', '1', '1', ''),
('95221', '140226', '0.4', '1', '0', '1', '1', ''),
('95221', '138781', '0.19', '1', '0', '1', '1', ''),
('95221', '121333', '0.19', '1', '0', '1', '1', ''),
('95221', '121342', '0.19', '1', '0', '1', '1', ''),
('95221', '132193', '0.19', '1', '0', '1', '1', ''),
('95221', '121393', '0.1', '1', '0', '1', '1', ''),
('95221', '121346', '0.1', '1', '0', '1', '1', '');

     

  22. Posted 

    --http://www.wowhead.com/npc=98241/lyrath-moonfeather
-- need to add trigger for +70 Order resources (1220) 92%
DELETE FROM `creature_loot_template` WHERE `entry`=98241;
UPDATE `creature_template` SET `lootid`='98241' WHERE `entry`='98241';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('98241', '138839', '24', '1', '0', '1', '1', ''),
('98241', '130118', '20', '1', '0', '1', '1', ''),
('98241', '121215', '1.2', '1', '0', '1', '1', ''),
('98241', '121207', '0.5', '1', '0', '1', '1', ''),
('98241', '121181', '0.3', '1', '0', '1', '1', ''),
('98241', '139526', '0.16', '1', '0', '1', '1', ''),
('98241', '132193', '78', '1', '0', '1', '1', ''),
('98241', '132192', '25', '1', '0', '1', '1', ''),
('98241', '132204', '8', '1', '0', '1', '1', ''),
('98241', '132227', '3', '1', '0', '1', '1', ''),
('98241', '132219', '2', '1', '0', '1', '1', ''),
('98241', '132223', '1.8', '1', '0', '1', '1', ''),
('98241', '140225', '0.3', '1', '0', '1', '1', ''),

     

  23. Posted 

    --http://www.wowhead.com/npc=94414/kiranys-duskwhisper
DELETE FROM `creature_loot_template` WHERE `entry`=94414;
UPDATE `creature_template` SET `lootid`='94414' WHERE `entry`='94414';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('94414', '141876', '34', '1', '0', '1', '1', ''),
('94414', '138839', '8', '1', '0', '1', '1', ''),
('94414', '121182', '0.8', '1', '0', '1', '1', ''),
('94414', '121166', '0.4', '1', '0', '1', '1', ''),
('94414', '121177', '0.4', '1', '0', '1', '1', ''),
('94414', '139528', '0.4', '1', '0', '1', '1', ''),
('94414', '121213', '0.13', '1', '0', '1', '1', ''),
('94414', '121217', '0.13', '1', '0', '1', '1', ''),
('94414', '121206', '0.13', '1', '0', '1', '1', ''),
('94414', '121169', '0.13', '1', '0', '1', '1', ''),
('94414', '121170', '0.13', '1', '0', '1', '1', ''),
('94414', '121183', '0.13', '1', '0', '1', '1', ''),
('94414', '121184', '0.13', '1', '0', '1', '1', ''),
('94414', '132233', '78', '1', '0', '1', '1', ''),
('94414', '132234', '20', '1', '0', '1', '1', ''),
('94414', '124437', '11', '1', '0', '1', '3', ''),
('94414', '132232', '6', '1', '0', '1', '1', ''),
('94414', '132231', '4', '1', '0', '1', '1', ''),
('94414', '138781', '0.8', '1', '0', '1', '1', ''),
('94414', '124438', '0.5', '1', '0', '2', '4', ''),
('94414', '132229', '0.5', '1', '0', '1', '1', ''),
('94414', '140226', '0.4', '1', '0', '1', '1', '');

     

  24. Posted 

    --http://www.wowhead.com/npc=93686/jinikki-the-puncturer
DELETE FROM `creature_loot_template` WHERE `entry`=93686;
UPDATE `creature_template` SET `lootid`='93686' WHERE `entry`='93686';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('93686', '121214', '0.5', '1', '0', '1', '1', ''),
('93686', '121215', '0.5', '1', '0', '1', '1', ''),
('93686', '121216', '0.5', '1', '0', '1', '1', ''),
('93686', '121169', '0.5', '1', '0', '1', '1', ''),
('93686', '121220', '0.5', '1', '0', '1', '1', ''),
('93686', '132204', '84', '1', '0', '1', '1', ''),
('93686', '132223', '24', '1', '0', '1', '1', ''),
('93686', '138781', '0.6', '1', '0', '1', '1', ''),
('93686', '140220', '0.5', '1', '0', '1', '1', ''),
('93686', '141291', '0.16', '1', '0', '1', '1', ''),
('93686', '132219', '0.16', '1', '0', '1', '1', '');

     

  25. Posted 

    --http://www.wowhead.com/npc=93030/ironbranch
--no herbalism_loot included
DELETE FROM `creature_loot_template` WHERE `entry`=93030;
UPDATE `creature_template` SET `lootid`='93030' WHERE `entry`='93030';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('93030', '121177', '0.9', '1', '0', '1', '1', ''),
('93030', '121217', '0.7', '1', '0', '1', '1', ''),
('93030', '121213', '0.4', '1', '0', '1', '1', ''),
('93030', '121218', '0.4', '1', '0', '1', '1', ''),
('93030', '121209', '0.4', '1', '0', '1', '1', ''),
('93030', '138817', '0.4', '1', '0', '1', '1', ''),
('93030', '121208', '0.3', '1', '0', '1', '1', ''),
('93030', '121210', '0.13', '1', '0', '1', '1', ''),
('93030', '121214', '0.07', '1', '0', '1', '1', ''),
('93030', '132204', '83', '1', '0', '1', '1', ''),
('93030', '132223', '29', '1', '0', '1', '1', ''),
('93030', '132219', '6', '1', '0', '1', '1', ''),
('93030', '132199', '5', '1', '0', '1', '1', ''),
('93030', '124437', '3', '1', '0', '1', '3', ''),
('93030', '121340', '0.7', '1', '0', '1', '1', ''),
('93030', '138781', '0.4', '1', '0', '1', '1', ''),
('93030', '121365', '0.4', '1', '0', '1', '1', ''),
('93030', '121336', '0.3', '1', '0', '1', '1', ''),
('93030', '121341', '0.13', '1', '0', '1', '1', ''),
('93030', '121370', '0.13', '1', '0', '1', '1', '');