[Quest] [11607] The Lost Spirits

[peycho]

TrinityCore rev. 4f5f148
TDB 335.11.46+

Quest: The Lost Spirits - http://www.wowhead.com/quest=11607
Quest item: Core of Malice - http://www.wowhead.com/?item=34711

When you use the quest item, you don't get credit and you don't free Kaskala Craftsman / Kaskala Shaman

I sow one closed report of that quest, but still don't working.

[Yoni140]

Confirmed on 9c417ff

[nelegalno]

#590

[gecko32]

This Fixes the Quest

-- Update Event Type From On Summon(11) to Reset(25)
UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=25321 AND `source_type`=0 AND `id`=0;
UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=25322 AND `source_type`=0 AND `id`=0;
-- Update Core of Malice drop rate
UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `entry`=25355 AND `item`=34711;

Not part of quest but found This

-- Remove item Tuskarr Ritual Object from Beryl Hounds
DELETE FROM `creature_loot_template` WHERE `entry`=25355 AND `item`=34713;

[nelegalno]

Fix works

P.S. Shouldn't we also remove Tuskarr Ritual Object from Beryl Reclaimer by the same logic:

-- Remove item Tuskarr Ritual Object from Beryl Reclaimer
DELETE FROM `creature_loot_template` WHERE `entry`=25449 AND `item`=34713;