[FIX] Quest #14077: The Light's Mercy (Smart Script) #9364

Closed
DDuarte opened this Issue Mar 6, 2013 · 1 comment

3 participants

@DDuarte
TrinityCore member

By @gaut, in https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha/issues/197

This SQL script gives credit for the correct quest when the item is used on the NPC. This allows the players to complete the quest.

It also removes the NPC so the item cannot be used twice on the same NPC.

The visual effect of the spell from the item already triggered and it seems okay on the screen but I don’t have the retail version so I don’t know if it’s perfectly Blizzlike. Maybe there’s more visual to add in the script.

Please test it and let me know if it works for you.

-- Fix quest 14077: The Light's Mercy
SET @SPELL := 66390; 
SET @NPC := 34852; 
SET @NPC_REWARD := 34852; 
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` = @NPC; 
DELETE FROM `smart_scripts` WHERE `entryorguid` = @NPC AND `source_type`=0; 
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, 
`event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, 
`action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(@NPC,0,0,1,8,0,100,0x01,@SPELL,0,0,0,33,@NPC_REWARD,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Slain Tualiq Villager - On spell hit - Give kill credit for quest 14077'),
(@NPC,0,1,0,61,0,100,1,0,0,0,0,41,2000,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Slain Tualiq Villager - Despawn after 2 seconds'); 
@ZxBiohazardZx ZxBiohazardZx was assigned Mar 7, 2013
@ZxBiohazardZx ZxBiohazardZx added a commit that closed this issue Mar 23, 2013
gaut DB/SAI: add SAI for The Light's Mercy
Closes #9364
3a5ed66
@DarkBrain2580

The buff now works, the people are also counted. But I can not leave because the quest told me that is the prayer book is missing although I have it in my inventory.

@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014
gaut DB/SAI: add SAI for The Light's Mercy
Closes #9364
cf12c87
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment