- 188
- 2017
- 13
- Location
- PA, USA
This was noted in the bug section Quest 12176 - A minor substitution by sputnik1
The SQL was posted there to adjust the drop chance. Adding it here so the SQL fixes are in one location.
The SQL was posted there to adjust the drop chance. Adding it here so the SQL fixes are in one location.
Code:
-- -------------------------------------------------------------------------------------------------------
-- 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