- 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.
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');