Quest 12176 - A minor substitution

[sputnik1]

No drops of Grizzly Hide from the bears (doesn't even show when you mouse over that it is possible), despite showing the right location on map.

 

[mastermind]

I see the item is in the creature_loot_template for two creatures the the chances are 12% and 1%. This is on the VIP version 7.0.2. Not sure about prior versions.

Grizzly Bear = 12%
Ursus Mauler = 1%

"entry"	"item"	"ChanceOrQuestChance"	"lootmode"	"groupid"	"mincountOrRef"	"maxcount"
"26644"	"37020"	"-1"	"1"	"0"	"1"	"1"
"27131"	"37020"	"-12"	"1"	"0"	"1"	"1"

 

[ExO]

Seems like too low drop chance. Will check some databases to see what it should be.

About it not showing as quest loot - for those who wish to learn:

In creature_template there is a field called questitem1, questitem2 etc. In here we simply add the quest item, and delete cache and it will display

 

[mastermind]

wowhead list 14% from Grizzly Bear (27131) and 1% from Ursus Mauler (26644)

wowdb list 20% from the Grizzly Bear (27131)

wow-freakz list 100% from both Grizzly Bear (27131) and Ursus Mauler (26644)

Not sure which is correct. I agree the first two sites seem a bit low.

 

[ExO]

I usually use:
http://cata-shoot.tauri.hu/?npc=27131

It shows 20% here on both of the npcs. (So it has wrong percentages atm)

 

[mastermind]

20% sound more realistic that 12% or 1%.
The following will set the quest item's drop chance to %20 on both NPCs.

-- -------------------------------------------------------------------------------------------------------
-- Repack version:               7.0.2
-- QuestID 12176: A minor substitution  - adjusts drop chance for quest item.
-- -------------------------------------------------------------------------------------------------------
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -20 WHERE `entry` IN (26644, 27131) AND `item` = 37020

 

[ExO]

Fixed by Mastermind:
http://www.emucoach.com/showthread.php?3036-Adjust-quest-item-drop-chance-QuestID-12176-v7-0-2

Moving to fixed ^^