Sign in to follow this  
Followers 0
Fyriond

[Declined]Grelda the Hag

2 posts in this topic

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

 

Share this post


Link to post
Share on other sites

order resources additionally

INSERT INTO `creature_loot_template` VALUES ('95123', '-1220', '51', '1', '0', '70', '70', '0');

 

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0