What's new

Fix for quest item dropping as normal loot 7.0.2

mastermind

Silver Supporter
Senior User
188
2017
13
Location
PA, USA
The Naga in the Zoram Strand drop quest item (Wrathtail Head ID: 5490) without having quest.

QuestID 1008: The Zoram Strand (Alliance)
QuestID 6442: Naga At The Soram Strand (Horde)

Creature_loot_table is correct at -100 'ChanceOrQuestChance'

The following adds entries to condition table.

Code:
-- -------------------------------------------------------------------------------------------------------
-- Repack version:               7.0.2
-- QuestID 1008: The Zoram Strand (Alliance)
-- QuestID 6442: Naga At The Soram Strand (Horde)
-- Fixes issue for quest item dropping even if you do not have the quest.
-- -------------------------------------------------------------------------------------------------------
DELETE FROM `conditions` WHERE `SourceGroup` IN (3711, 3712, 3713, 3715, 3717, 3944) AND `SourceEntry` = 5490 AND `ConditionValue1` IN (6442, 1008);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(1, 3711, 5490, 0, 1, 9, 0, 6442, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3712, 5490, 0, 1, 9, 0, 6442, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3713, 5490, 0, 1, 9, 0, 6442, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3715, 5490, 0, 1, 9, 0, 6442, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3717, 5490, 0, 1, 9, 0, 6442, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3711, 5490, 0, 1, 9, 0, 1008, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3712, 5490, 0, 1, 9, 0, 1008, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3713, 5490, 0, 1, 9, 0, 1008, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3715, 5490, 0, 1, 9, 0, 1008, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 3717, 5490, 0, 1, 9, 0, 1008, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest');


DELETE FROM `conditions` WHERE `SourceGroup` IN (3711, 3712, 3713, 3715, 3717, 3944) AND `SourceEntry` = 5490 AND `ConditionValue1` IN (3711, 3712, 3713, 3715, 3717, 3944);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(1, 3711, 5490, 0, 1, 29, 1, 3711, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3712, 5490, 0, 1, 29, 1, 3712, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3713, 5490, 0, 1, 29, 1, 3713, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3715, 5490, 0, 1, 29, 1, 3715, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3717, 5490, 0, 1, 29, 1, 3717, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 3944, 5490, 0, 1, 29, 1, 3944, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20');
 
Top