{NPC} Precious

[durrrr]

Hello,
I have encountered a problem while playing in "Icecrown Citadle" zone.

How to reproduce the bug:

1. Kill "Precious"
2. Try to loot / skin it

What should happen, what happens instead:
You should kill "Precious" (on both sides) and have loots and the ability to do "skinning" on him (notice the spell info) instead, you have no loots and the ability to skin the NPC.

Some links:
http://old.wowhead.com/npc=37217 --> The NPC (Old Wowhead)
http://old.wowhead.com/zone=4812 --> The zone (Old Wowhead)
http://www.wowwiki.com/Icecrown_Citadel --> The zone (Wowwiki)

I'm running Unix on hash: bf7a32b , TDB 335.11.46+
Addons: AH bot and WG.

Regards,
durrrr

[durrrr]

"Stinky"
http://old.wowhead.com/npc=37025

Same issue.

[ZxBiohazardZx]

both have been included on the normal ICC trash loots i did, i will check on it...

http://old.wowhead.com/npc=37025#drops

rare chance on world drops, borean leather is NOT supposed to be there, its a mining error that should be in skinning afaik

[durrrr]

Maybe you are right about the borean. I wont argue with that.
But this is not the issue.
The issue is there is no loots and they are not possible to skin.

[ZxBiohazardZx]

the fact that there is no loot then is correct, if the world-drops (<5%) dont drop then the looting table is empty, resulting in no loot. the fact taht you cannot skin is then maybe related to the fact that the creature did not drop an item?

[ZxBiohazardZx]

SELECT entry,lootid FROM `creature_template` WHERE `entry` IN (37217,38103);
returns
37217   37217
38103   38103

SELECT * FROM `creature_loot_template` WHERE `entry` IN (37217,38103);
37217   1   100 1   0   -35069  2
37217   52019   30  1   0   1   1
38103   45912   0,1 1   0   1   1

this means that 25 man is indeed a bit off, but 10 man loot should be fine
(30% chance on Precious' Ribbon)
(100% chance on something from the trashloots) (grey/white/green/blue/purple)

the 25 man version only drops the damned Book of Glyph Mastery, might update that one in a moment

[ZxBiohazardZx]

SELECT * FROM `creature_loot_template` WHERE `entry` IN (37025,38064);
37025   1   100 1   0   -35069  2 (100% chance on the reference)
38064   45912   0,1 1   0   1   1 (Book Glyph of Mastery)

Stinky ^^