- 188
- 2017
- 13
- Location
- PA, USA
Item is correct in creature_loot_template table. Adding conditions.
Code:
-- -------------------------------------------------------------------------------------------------------
-- Repack version: 7.0.2
-- ItemID 7128: Uncloven Satyr Hoof - fixes issue for quest item dropping even if you do not have the quest.
-- QuestID 1842: Satyr Hooves (Horde)
-- -------------------------------------------------------------------------------------------------------
DELETE FROM `conditions` WHERE `SourceGroup` IN (3763, 3752, 3754, 3762, 3771, 3755, 3770, 3758, 3767, 3757, 3765, 3759 ) AND `SourceEntry` = 7128 AND `ConditionValue1` = 1842;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(1, 3763, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3752, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3754, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3762, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3771, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3755, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3770, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3758, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3767, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3757, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3765, 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3759 , 7128, 0, 1, 9, 0, 1842, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest');
DELETE FROM `conditions` WHERE `SourceGroup` IN (3763, 3752, 3754, 3762, 3771, 3755, 3770, 3758, 3767, 3757, 3765, 3759) AND `SourceEntry` = 7128 AND `ConditionValue1` IN (3763, 3752, 3754, 3762, 3771, 3755, 3770, 3758, 3767, 3757, 3765, 3759 );
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(1, 3763, 7128, 0, 1, 29, 1, 3763, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3752, 7128, 0, 1, 29, 1, 3752, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3754, 7128, 0, 1, 29, 1, 3754, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3762, 7128, 0, 1, 29, 1, 3762, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3771, 7128, 0, 1, 29, 1, 3771, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3755, 7128, 0, 1, 29, 1, 3755, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3770, 7128, 0, 1, 29, 1, 3770, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3758, 7128, 0, 1, 29, 1, 3758, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3767, 7128, 0, 1, 29, 1, 3767, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3757, 7128, 0, 1, 29, 1, 3757, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3765, 7128, 0, 1, 29, 1, 3765, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3759 , 7128, 0, 1, 29, 1, 3759 , 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20');