[FIXED][quest][13110][The Restless Dead]

[n0Lan]

The Restless Dead

В куеста се иска да убиеш 10 Reanimated crusader или forgoteen Depths Underking и след като си го убил,да му пуснеш куест айтъма Holy Water.
Проблема,е че не отчита,а пуска някакъв спирит.
До колкото виждам в Github,не дава  кредит.

[untaught]

Т'ва за 20 път няма да го оправям. 

Код: [Маркирай кода]

UPDATE `quest_template` SET `RequiredSpellCast1`=0 WHERE `Id`=13110;

[admin]

При мен имам това:

Код: [Маркирай кода]

-- Fix [Q]{A/H} The Restless Dead - ID: 13110
-- Reanimated Crusader SAI
SET @Reanimated_Crusader := 31043;
SET @Credit := 30546;
SET @HolyWater := 57806;
-- Replace required npcorgameobject, because there was wrong unusused creature /not credit, since the spell that must hit the requirednpc has 31043 as set and not 30546, also the npc name has "unused" stated/.
UPDATE `quest_template` SET `RequiredNpcOrGo1`=@Reanimated_Crusader WHERE `Id`=13110;
-- Аdd SAI for Reanimated Crusader
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@Reanimated_Crusader;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@Reanimated_Crusader;
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
(@Reanimated_Crusader,0,0,0,25,0,100,0,0,0,0,0,19,33554432,0,0,0,0,0,1,0,0,0,0,0,0,0,'Reanimated Crusader - On spawn/respawn - Remove flag unselectable'),
(@Reanimated_Crusader,0,1,0,8,0,100,0,@HolyWater,0,0,0,18,33554432,0,0,0,0,0,1,0,0,0,0,0,0,0,'Reanimated Crusader - On hit by spell Holy Water - Set field flag unselectable /to prevent more uses of the spell - acts as condition/'),
(@Reanimated_Crusader,0,2,0,0,0,100,0,1000,5000,6500,12000,11,32674,0,0,0,0,0,2,0,0,0,0,0,0,0,'Reanimated Crusader - IC - Cast Avenger"s Shield'),
(@Reanimated_Crusader,0,3,0,0,0,100,0,5000,10000,8500,20000,11,58154,0,0,0,0,0,2,0,0,0,0,0,0,0,'Reanimated Crusader - IC - Hammer of Injustice'),
(@Reanimated_Crusader,0,4,0,2,0,100,0,10,90,7000,15000,11,58153,0,0,0,0,0,1,0,0,0,0,0,0,0,'Reanimated Crusader - On health percentage - Cast Unholy Light on self after Hammer of Injustice'),
(@Reanimated_Crusader,0,5,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,'Reanimated Crusader - On friendly HP deficit - Cast Unholy Light on allies');
-- end

Не е сложено понеже го нямаше в списъка който ми даде след разчистването.

[untaught]

Сложи само горното. Това го няма защото е прието официално, но не са изчистили полето, което е в горната заявка.

[admin]

За тестване.