ItemID: 773 Gold Dust drops without having quest v8.0

[mastermind]

-- -------------------------------------------------------------------------------------------------------
-- Repack version:               8.0
-- ItemID: 773 Gold Dust
-- QuestID: 47 Gold Dust Exchange - fixes issue for quest item dropping even if you do not have the quest.
-- NPCID: 475 Kobold Tunneler
-- NPCID: 40  Kobold Miner
-- NPCID: 327 Goldtooth
-- NPCID: 476   Kobold Geomancer
-- -------------------------------------------------------------------------------------------------------
DELETE FROM `conditions` WHERE `SourceGroup` IN (475, 40, 327, 476) AND `SourceEntry` = 773 AND `ConditionValue1` = 47;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(1, 475, 773, 0, 1, 9, 0, 47, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 40, 773, 0, 1, 9, 0, 47, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 327, 773, 0, 1, 9, 0, 47, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 476, 773, 0, 1, 9, 0, 47, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest');

DELETE FROM `conditions` WHERE `SourceGroup` = 475 AND `SourceEntry` = 773 AND `ConditionValue1` = 475;
DELETE FROM `conditions` WHERE `SourceGroup` = 40 AND `SourceEntry` = 773 AND `ConditionValue1` = 40;
DELETE FROM `conditions` WHERE `SourceGroup` = 327 AND `SourceEntry` = 773 AND `ConditionValue1` = 327;
DELETE FROM `conditions` WHERE `SourceGroup` = 476 AND `SourceEntry` = 773 AND `ConditionValue1` = 476;

INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(1, 475, 773, 0, 1, 29, 1, 475, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 40, 773, 0, 1, 29, 1, 40, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 327, 773, 0, 1, 29, 1, 327, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 476, 773, 0, 1, 29, 1, 476, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20');

 

[eyerobot]

I did wonder about this when i was working on that area. Thank you.

 

[ExO]

Executed thanks