Fyriond

Members
 View profile  See their activity

  • Content count

    83

  • Joined

  • Last visited

Posts posted by Fyriond

  1. Posted 

    --http://www.wowhead.com/npc=95123/grelda-the-hag
-- need to add trigger for +70 Order resources (1220) 51%
DELETE FROM `creature_loot_template` WHERE `entry`=95123;
UPDATE `creature_template` SET `lootid`='95123' WHERE `entry`='95123';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('95123', '130122', '52', '1', '0', '1', '1', ''),
('95123', '136785', '43', '1', '0', '1', '1', ''),
('95123', '138839', '14', '1', '0', '1', '1', ''),
('95123', '121215', '0.4', '1', '0', '1', '1', ''),
('95123', '141290', '0.4', '1', '0', '1', '1', ''),
('95123', '121205', '0.3', '1', '0', '1', '1', ''),
('95123', '121210', '0.3', '1', '0', '1', '1', ''),
('95123', '121184', '0.3', '1', '0', '1', '1', ''),
('95123', '121212', '0.2', '1', '0', '1', '1', ''),
('95123', '121181', '0.2', '1', '0', '1', '1', ''),
('95123', '121208', '0.15', '1', '0', '1', '1', ''),
('95123', '121211', '0.15', '1', '0', '1', '1', ''),
('95123', '121179', '0.15', '1', '0', '1', '1', ''),
('95123', '121189', '0.15', '1', '0', '1', '1', ''),
('95123', '121192', '0.15', '1', '0', '1', '1', ''),
('95123', '139526', '0.15', '1', '0', '1', '1', ''),
('95123', '121169', '0.1', '1', '0', '1', '1', ''),
('95123', '121173', '0.1', '1', '0', '1', '1', ''),
('95123', '121177', '0.1', '1', '0', '1', '1', ''),
('95123', '121214', '0.05', '1', '0', '1', '1', ''),
('95123', '121219', '0.05', '1', '0', '1', '1', ''),
('95123', '121166', '0.05', '1', '0', '1', '1', ''),
('95123', '124437', '15', '1', '0', '1', '3', ''),
('95123', '121332', '0.6', '1', '0', '1', '1', ''),
('95123', '121342', '0.6', '1', '0', '1', '1', ''),
('95123', '140222', '0.5', '1', '0', '1', '1', ''),
('95123', '121335', '0.5', '1', '0', '1', '1', ''),
('95123', '121358', '0.5', '1', '0', '1', '1', ''),
('95123', '138781', '0.4', '1', '0', '1', '1', ''),
('95123', '121350', '0.4', '1', '0', '1', '1', ''),
('95123', '121371', '0.4', '1', '0', '1', '1', ''),
('95123', '121334', '0.3', '1', '0', '1', '1', ''),
('95123', '121357', '0.3', '1', '0', '1', '1', ''),
('95123', '121347', '0.3', '1', '0', '1', '1', ''),
('95123', '121365', '0.3', '1', '0', '1', '1', ''),
('95123', '121337', '0.2', '1', '0', '1', '1', ''),
('95123', '121356', '0.2', '1', '0', '1', '1', ''),
('95123', '121351', '0.2', '1', '0', '1', '1', ''),
('95123', '121343', '0.2', '1', '0', '1', '1', ''),
('95123', '140224', '0.15', '1', '0', '1', '1', ''),
('95123', '140226', '0.15', '1', '0', '1', '1', ''),
('95123', '121405', '0.15', '1', '0', '1', '1', ''),
('95123', '121336', '0.15', '1', '0', '1', '1', ''),
('95123', '121361', '0.15', '1', '0', '1', '1', ''),
('95123', '121368', '0.15', '1', '0', '1', '1', ''),
('95123', '121363', '0.15', '1', '0', '1', '1', ''),
('95123', '121370', '0.15', '1', '0', '1', '1', ''),
('95123', '121346', '0.15', '1', '0', '1', '1', ''),
('95123', '121359', '0.15', '1', '0', '1', '1', ''),
('95123', '121362', '0.15', '1', '0', '1', '1', ''),
('95123', '121349', '0.15', '1', '0', '1', '1', ''),
('95123', '121366', '0.1', '1', '0', '1', '1', ''),
('95123', '121354', '0.1', '1', '0', '1', '1', ''),
('95123', '121339', '0.05', '1', '0', '1', '1', ''),
('95123', '121344', '0.03', '1', '0', '1', '1', ''),
('95123', '121369', '0.03', '1', '0', '1', '1', '');

     

  2. Posted 

    --http://www.wowhead.com/npc=97517/dreadbog
-- need to add trigger for +70 Order resources (1220) 38%
DELETE FROM `creature_loot_template` WHERE `entry`=97517;
UPDATE `creature_template` SET `lootid`='97517' WHERE `entry`='97517';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('97517', '130125', '38', '1', '0', '1', '1', ''),
('97517', '138839', '8', '1', '0', '1', '1', ''),
('97517', '121166', '0.3', '1', '0', '1', '1', ''),
('97517', '121220', '0.2', '1', '0', '1', '1', ''),
('97517', '121206', '0.2', '1', '0', '1', '1', ''),
('97517', '121177', '0.2', '1', '0', '1', '1', ''),
('97517', '121168', '0.12', '1', '0', '1', '1', ''),
('97517', '121185', '0.12', '1', '0', '1', '1', ''),
('97517', '121186', '0.12', '1', '0', '1', '1', ''),
('97517', '121215', '0.04', '1', '0', '1', '1', ''),
('97517', '121210', '0.04', '1', '0', '1', '1', ''),
('97517', '121212', '0.02', '1', '0', '1', '1', ''),
('97517', '132204', '74', '1', '0', '1', '1', ''),
('97517', '132223', '22', '1', '0', '1', '1', ''),
('97517', '132184', '12', '1', '0', '1', '1', ''),
('97517', '132219', '4', '1', '0', '1', '1', ''),
('97517', '132183', '3', '1', '0', '1', '1', ''),
('97517', '132231', '3', '1', '0', '1', '1', ''),
('97517', '132190', '0.8', '1', '0', '1', '1', ''),
('97517', '138781', '0.4', '1', '0', '1', '1', ''),
('97517', '140222', '0.4', '1', '0', '1', '1', ''),
('97517', '124439', '0.4', '1', '0', '1', '3', ''),
('97517', '140226', '0.2', '1', '0', '1', '1', ''),
('97517', '140227', '0.16', '1', '0', '1', '1', ''),
('97517', '140224', '0.16', '1', '0', '1', '1', ''),
('97517', '140220', '0.16', '1', '0', '1', '1', ''),
('97517', '140225', '0.14', '1', '0', '1', '1', ''),
('97517', '132193', '0.12', '1', '0', '1', '1', ''),
('97517', '138782', '0.04', '1', '0', '1', '1', ''),
('97517', '132186', '0.02', '1', '0', '1', '1', '');

     

  3. Posted 

    --http://www.wowhead.com/npc=92965/darkshade
-- need to add trigger for +70 Order resources (1220) 100%
DELETE FROM `creature_loot_template` WHERE `entry`=92965;
UPDATE `creature_template` SET `lootid`='92965' WHERE `entry`='92965';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('92965', '130166', '98', '1', '0', '1', '1', ''),
('92965', '138839', '26', '1', '0', '1', '1', ''),
('92965', '121207', '0.4', '1', '0', '1', '1', ''),
('92965', '121183', '0.4', '1', '0', '1', '1', ''),
('92965', '121189', '0.4', '1', '0', '1', '1', ''),
('92965', '132231', '18', '1', '0', '1', '1', ''),
('92965', '132233', '11', '1', '0', '1', '1', ''),
('92965', '132183', '7', '1', '0', '1', '1', ''),
('92965', '132234', '4', '1', '0', '1', '1', ''),
('92965', '124439', '3', '1', '0', '1', '1', ''),
('92965', '124438', '2', '1', '0', '1', '1', ''),
('92965', '132229', '1', '1', '0', '1', '1', ''),
('92965', '140226', '0.14', '1', '0', '1', '1', '');

     

  4. Posted 

    --http://www.wowhead.com/npc=110562/bahagar
-- need to add trigger for + 70 Order resources (1220) 34%
DELETE FROM `creature_loot_template` WHERE `entry`=110562;
UPDATE `creature_template` SET `lootid`='110562' WHERE `entry`='110562';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`)
VALUES
('110562', '124117', '76', '1', '0', '1', '2', ''),
('110562', '127037', '14', '1', '0', '1', '1', ''),
('110562', '130135', '13', '1', '0', '1', '1', ''),
('110562', '138839', '7', '1', '0', '1', '1', ''),
('110562', '121170', '0.3', '1', '0', '1', '1', ''),
('110562', '121192', '0.3', '1', '0', '1', '1', ''),
('110562', '121193', '0.2', '1', '0', '1', '1', ''),
('110562', '121168', '0.18', '1', '0', '1', '1', ''),
('110562', '121185', '0.18', '1', '0', '1', '1', ''),
('110562', '134343', '0.15', '1', '0', '1', '1', ''),
('110562', '121214', '0.13', '1', '0', '1', '1', ''),
('110562', '121217', '0.13', '1', '0', '1', '1', ''),
('110562', '121220', '0.13', '1', '0', '1', '1', ''),
('110562', '136755', '0.09', '1', '0', '1', '1', ''),
('110562', '121169', '0.09', '1', '0', '1', '1', ''),
('110562', '121182', '0.09', '1', '0', '1', '1', ''),
('110562', '121177', '0.09', '1', '0', '1', '1', ''),
('110562', '139526', '0.09', '1', '0', '1', '1', ''),
('110562', '121166', '0.04', '1', '0', '1', '1', ''),
('110562', '134305', '0.04', '1', '0', '1', '1', ''),
('110562', '121211', '0.02', '1', '0', '1', '1', ''),
('110562', '121187', '0.02', '1', '0', '1', '1', ''),
('110562', '132231', '75', '1', '0', '1', '1', ''),
('110562', '132183', '21', '1', '0', '1', '1', ''),
('110562', '124438', '8', '1', '0', '1', '1', ''),
('110562', '124439', '7', '1', '0', '1', '1', ''),
('110562', '132185', '3', '1', '0', '1', '1', ''),
('110562', '140222', '0.5', '1', '0', '1', '1', ''),
('110562', '140226', '0.4', '1', '0', '1', '1', ''),
('110562', '140224', '0.3', '1', '0', '1', '1', ''),
('110562', '132186', '0.2', '1', '0', '1', '1', ''),
('110562', '138782', '0.13', '1', '0', '1', '1', ''),
('110562', '140225', '0.13', '1', '0', '1', '1', ''),
('110562', '121370', '0.13', '1', '0', '1', '1', ''),
('110562', '138781', '0.09', '1', '0', '1', '1', ''),
('110562', '141291', '0.09', '1', '0', '1', '1', ''),
('110562', '121354', '0.09', '1', '0', '1', '1', ''),
('110562', '140227', '0.04', '1', '0', '1', '1', ''),
('110562', '121372', '0.04', '1', '0', '1', '1', '');