'Huggalon the Heart Watcher' loot fix

[shadow123]

Apparently there is no post on the forum about this, but http://www.wowhead.com/npc=66900/huggalon-the-heart-watcher should have a 100% chance to drop http://www.wowhead.com/item=90067/b-f-f-necklace .

So i fixed the drop chance.

DELETE FROM `creature_loot_template` WHERE `entry`='66900'
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) 
VALUES('66900' '90067' '100' '1' '0' '1' '1')

 

 

[Florix]

DELETE FROM `creature_loot_template` WHERE `entry`='66900';
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) 
VALUES('66900', '90067', '100', '1', '0', '1', '1');
UPDATE `creature_template` SET `lootid`='66900' WHERE `entry`='66900'; 

Your patch got some errors like missing ; and ,

[shadow123]

Oh yeah, tnx for fixing it.. My mother was yeling at me for some reasson so i was doing it in a hurry

[Florix]

Hum, for some reason ItemBonuses need to be in WoD loot patches. Anyway, acceptet, merged soon on live Realms.