- 188
- 2017
- 13
- Location
- PA, USA
Set the item chance to a negative (quest drop) value. Most entries where already negative except the ones below. May or may not need condition table entries.
Code:
-- --------------------------------------------------------------------------------------------------------------------
-- Repack version: 7.0.2
-- ItemID: 6443 Deviate Hide - fixes issue for quest item dropping even if you do not have the quest.
-- QuestID 26872: Deviate Hides
-- --------------------------------------------------------------------------------------------------------------------
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -8.67 WHERE `entry` = 5762 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -4.91 WHERE `entry` = 5756 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -5.2 WHERE `entry` = 5056 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -13.22 WHERE `entry` = 5761 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -32.08 WHERE `entry` = 8886 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -24.21 WHERE `entry` = 5755 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -18.53 WHERE `entry` = 5048 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -1.71 WHERE `entry` = 3633 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -3.81 WHERE `entry` = 3654 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -3.55 WHERE `entry` = 3674 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -2 WHERE `entry` = 5775 AND `item` = 6443;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -2.34 WHERE `entry` = 5912 AND `item` = 6443;