[Warlords of Draenor]: Guardian of the Deep Skinning loot

[Tavari]

Title: Guardian of the Deep Skinning loot
Bugtracker Link:

https://firestorm-servers.com/us/report/see_report/32763

Patch Content:

http://www.wowhead.com/npc=74508/guardian-of-the-deep

DELETE FROM `skinning_loot_template` WHERE `entry`='74508';
INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `maxcount`, `itembonus`) VALUES
('74508', '4235', '56', '1', '0', '1', '1',''),
('74508', '4234', '54', '1', '0', '2', '3',''),
('74508', '2318', '27', '1', '0', '1', '2',''),
('74508', '2319', '7', '1', '0', '1', '2',''),
('74508', '783', '1.8', '1', '0', '1', '1',''),
('74508', '2934', '0.9', '1', '0', '1', '2','');
UPDATE `creature_template` SET `skinloot`='74508' WHERE `entry`='74508';

 

[Mikrole]

groupid and mincountOrRef is missing, also itemBonuses is wrong spelled.

Corrected:
 

DELETE FROM `skinning_loot_template` WHERE `entry`='74508';
INSERT INTO `skinning_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itemBonuses`) VALUES
('74508', '4235', '56', '1', '0', '1', '1',''),
('74508', '4234', '54', '1', '0', '2', '3',''),
('74508', '2318', '27', '1', '0', '1', '2',''),
('74508', '2319', '7', '1', '0', '1', '2',''),
('74508', '783', '1.8', '1', '0', '1', '1',''),
('74508', '2934', '0.9', '1', '0', '1', '2','');
UPDATE `creature_template` SET `skinloot`='74508' WHERE `entry`='74508';

Patch Accepted, merged soon on live realm. Thank you.