[MoP]Ahune - The Frost Lord

[Misahky]

Bugtracker Link: https://firestorm-servers.com/us/report/see_report/12667

wowhead link: http://www.wowhead.com/npc=25740/ahune

Correction: Added Loot

 

--Ahune http://www.wowhead.com/npc=25740/ahune
DELETE FROM `creature_loot_template` WHERE `entry`=25740;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(25740, 35557, 27, 0, 0, 1, 2),
(25740, 35723, 19, 0, 0, 1, 1),
(25740, 35498, 3, 0, 0, 1, 1),
(25740, 95425, 2, 0, 0, 1, 1),
(25740, 95427, 2, 0, 0, 1, 1),
(25740, 95428, 2, 0, 0, 1, 1),
(25740, 95429, 2, 0, 0, 1, 1),
(25740, 95430, 2, 0, 0, 1, 1),
(25740, 35720, 2, 0, 0, 1, 6);

 

[Enrico]

I hope this work  

[Hypnos]

A little advices:

1- update the lootid in creature_template for being sure that the npc will have loot, if its 0 the loot wont work.

2- lootmode =1 always,for the moment.

3- For commenting a line use 2x lines + 1x backspace or it wont count as a comment and the patch will give error when adding it to the db.

The correct patch would look so:

-- Ahune http://www.wowhead.com/npc=25740/ahune
UPDATE `creature_template` SET `lootid`=25740 WHERE `entry`=25740;
DELETE FROM `creature_loot_template` WHERE `entry`=25740;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(25740, 35557, 27, 1, 0, 1, 2),
(25740, 35723, 19, 1, 0, 1, 1),
(25740, 35498, 3, 1, 0, 1, 1),
(25740, 95425, 2, 1, 0, 1, 1),
(25740, 95427, 2, 1, 0, 1, 1),
(25740, 95428, 2, 1, 0, 1, 1),
(25740, 95429, 2, 1, 0, 1, 1),
(25740, 95430, 2, 1, 0, 1, 1),
(25740, 35720, 2, 1, 0, 1, 6);

Accepted. We will see what I can do, if Core devs can add it before of the event finish...

Thx.