Quest item dropping as normal loot v7.0.2

[mastermind]

This item is correct in the creature_loot_template so adding entries to the condition table.

Addresses one item and three quests.

-- -------------------------------------------------------------------------------------------------------
-- Repack version:               7.0.2
-- ItemID 5481: Satyr Horns  - fixes issue for quest item dropping even if you do not have the quest.
-- QuestID 6441: Satyr Horns (Horde)
-- QuestID 1032: Satyr Slaying! (Think this one is obsolete but added just in case)
-- QuestID 26469: Satyr Slaying! (Alliance)
-- -------------------------------------------------------------------------------------------------------

DELETE FROM `conditions` WHERE `SourceGroup` IN (3752, 3763, 3765, 3767, 3770, 3771, 3898, 3899, 3900, 4619, 3762, 10647, 3754, 3755, 3757, 3758, 3759) AND `SourceEntry` = 5481 AND `ConditionValue1` IN (6441, 1032, 26469);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(1, 3752, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3763, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3765, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3767, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3770, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3771, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3898, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3899, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3900, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 4619, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3762, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 10647, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3754, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3755, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3757, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3758, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3759, 5481, 0, 1, 9, 0, 6441, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3752, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3763, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3765, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3767, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3770, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3771, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3898, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3899, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3900, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 4619, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3762, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 10647, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3754, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3755, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3757, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3758, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3759, 5481, 0, 1, 9, 0, 1032, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3752, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3763, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3765, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3767, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3770, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3771, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3898, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3899, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3900, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 4619, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3762, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 10647, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3754, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3755, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3757, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3758, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3759, 5481, 0, 1, 9, 0, 26469, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest');

DELETE FROM `conditions` WHERE `SourceGroup` IN (3752, 3763, 3765, 3767, 3770, 3771, 3898, 3899, 3900, 4619, 3762, 10647, 3754, 3755, 3757, 3758, 3759) AND `SourceEntry` = 5481 AND `ConditionValue1` IN (3752, 3763, 3765, 3767, 3770, 3771, 3898, 3899, 3900, 4619, 3762, 10647, 3754, 3755, 3757, 3758, 3759);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(1, 3752, 5481, 0, 1, 29, 1, 3752, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3763, 5481, 0, 1, 29, 1, 3763, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3765, 5481, 0, 1, 29, 1, 3765, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3767, 5481, 0, 1, 29, 1, 3767, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3770, 5481, 0, 1, 29, 1, 3770, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3771, 5481, 0, 1, 29, 1, 3771, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3898, 5481, 0, 1, 29, 1, 3898, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3899, 5481, 0, 1, 29, 1, 3899, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3900, 5481, 0, 1, 29, 1, 3900, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 4619, 5481, 0, 1, 29, 1, 4619, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3762, 5481, 0, 1, 29, 1, 3762, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 10647, 5481, 0, 1, 29, 1, 10647, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3754, 5481, 0, 1, 29, 1, 3754, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3755, 5481, 0, 1, 29, 1, 3755, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3757, 5481, 0, 1, 29, 1, 3757, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3758, 5481, 0, 1, 29, 1, 3758, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3759, 5481, 0, 1, 29, 1, 3759, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20');