10.1 Bug on a reward item (with instructions profession)

[Titesusy]

Tested with my instruction character from the Alliance, at Stormwind (Draenei priest), i got a message in worldserver console trying to open the container (which is a reward from a quest launched by a craftable item)

ERROR Table 'item_loot_template' loot id #62062 used but it doesn't have records.

What it should do to work : https://www.wowhead.com/item=62062
The conainers (62062) should contains 180261 coppers ( = 18 golds + 2 silvers + 61 coppers)

 

[Titesusy]

A way to fix. We need to reach 18 golds, but i had some difficulties to give back some golds, so let's try another way (giving back some consumable to get those) : an idea submitted by [MENTION=12024]Mr. Satan[/MENTION]
(to see the conversation : https://www.emucoach.com/showthread.php/5881-Gold-Who-was-talking-about-gold )

So, to reach the 18 golds as rewards, let's take the 33447 and 33448 items. They are resold 60 silvers each, so let's reward 15 of each (15 * 60silver = 9 golds, so 9*2 = 18 golds)

DELETE FROM item_loot_template WHERE (entry = '62062');
INSERT INTO `item_loot_template` (entry, item, ChanceOrQuestChance, mincountOrRef, maxcount) VALUES
('62062','33447','100','15','15'), ('62062','33448','100','15','15');

Tested and working!

 

[ExO]

Executed the query