- 188
- 2017
- 13
- Location
- PA, USA
Code:
-- -------------------------------------------------------------------------------------------------------
-- Repack version: 8.0
-- ItemID: 1019 Linen Scrap
-- QuestID: 83 Fine Linen Goods - fixes issue for quest item dropping even if you do not have the quest.
-- NPCID: 474 Rogue Wizard
-- NPCID: 583 Ambusher
-- NPCID: 6866 Bodyguard
-- NPCID: 116 Bandit
-- NPCID: 6927 Dockworker
-- NPCID: 880 Erlan Drudgemoor
-- NPCID: 881 Surena Caledon
-- NPCID: 6846 Dockmaster
-- NPCID: 473 Morgan the Collector
-- NPCID: 13159 James Clark
-- -------------------------------------------------------------------------------------------------------
delete from `creature_loot_template` where `entry` = 13159 AND `item` = 1019;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values
(13159, 1019, -8, 1, 0, 1, 1);
DELETE FROM `conditions` WHERE `SourceGroup` IN (474, 583, 6866, 116, 6927, 880, 881, 6846, 473, 13159) AND `SourceEntry` = 1019 AND `ConditionValue1` = 83;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(1, 474, 1019, 0, 1, 9, 0, 83, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 583, 1019, 0, 1, 9, 0, 83, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 6866, 1019, 0, 1, 9, 0, 83, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 116, 1019, 0, 1, 9, 0, 83, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 6927, 1019, 0, 1, 9, 0, 83, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 880, 1019, 0, 1, 9, 0, 83, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 881, 1019, 0, 1, 9, 0, 83, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 6846, 1019, 0, 1, 9, 0, 83, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 473, 1019, 0, 1, 9, 0, 83, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest'),
(1, 13159, 1019, 0, 1, 9, 0, 83, 0, 0, 0, 0, 0, '', 'Creature Loot, only drop if player has quest');
DELETE FROM `conditions` WHERE `SourceGroup` = 474 AND `SourceEntry` = 1019 AND `ConditionValue1` = 474;
DELETE FROM `conditions` WHERE `SourceGroup` = 583 AND `SourceEntry` = 1019 AND `ConditionValue1` = 583;
DELETE FROM `conditions` WHERE `SourceGroup` = 6866 AND `SourceEntry` = 1019 AND `ConditionValue1` = 6866;
DELETE FROM `conditions` WHERE `SourceGroup` = 116 AND `SourceEntry` = 1019 AND `ConditionValue1` = 116;
DELETE FROM `conditions` WHERE `SourceGroup` = 6927 AND `SourceEntry` = 1019 AND `ConditionValue1` = 6927;
DELETE FROM `conditions` WHERE `SourceGroup` = 880 AND `SourceEntry` = 1019 AND `ConditionValue1` = 880;
DELETE FROM `conditions` WHERE `SourceGroup` = 881 AND `SourceEntry` = 1019 AND `ConditionValue1` = 881;
DELETE FROM `conditions` WHERE `SourceGroup` = 6846 AND `SourceEntry` = 1019 AND `ConditionValue1` = 6846;
DELETE FROM `conditions` WHERE `SourceGroup` = 473 AND `SourceEntry` = 1019 AND `ConditionValue1` = 473;
DELETE FROM `conditions` WHERE `SourceGroup` = 13159 AND `SourceEntry` = 1019 AND `ConditionValue1` = 13159;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(1, 474, 1019, 0, 1, 29, 1, 474, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 583, 1019, 0, 1, 29, 1, 583, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 6866, 1019, 0, 1, 29, 1, 6866, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 116, 1019, 0, 1, 29, 1, 116, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 6927, 1019, 0, 1, 29, 1, 6927, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 880, 1019, 0, 1, 29, 1, 880, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 881, 1019, 0, 1, 29, 1, 881, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 6846, 1019, 0, 1, 29, 1, 6846, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 473, 1019, 0, 1, 29, 1, 473, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20'),
(1, 13159, 1019, 0, 1, 29, 1, 13159, 20, 0, 0, 0, 0, '', 'Creature Loot, only happen if creature distance is 20');
