Quest Fix Seared Scourge

TrinityCore Development TrinityCore Code Discussion
1

http://www.wowhead.com/quest=12029

[CODE]-- Die angesenkte Geißel Q 12029
SET @SPELL := 47207;
SET @NPCBunny := 26612; – from Q Template Bunny Credit
SET @Bunny := XXXXX; – need ca. 10-15

UPDATE creature_template SET unit_flags=33554432, AIName='SmartAI', flags_extra=128 WHERE entry`[email protected];

– spawn Trigger bunnys
DELETE FROM creature WHERE id[email protected] and map=571;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES
(@Bunny, @NPCBunny, 571, 1, 1, 0, 0, 4453.59, -2009.3, 162.206, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@Bunny+1, @NPCBunny, 571, 1, 1, 0, 0, 4501.58, -1973.11, 160.82, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@Bunny+2, @NPCBunny, 571, 1, 1, 0, 0, 4507.10, -1981.28, 160.82, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@Bunny+3, @NPCBunny, 571, 1, 1, 0, 0, 4511.18, -1972.13, 160.946, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@Bunny+4, @NPCBunny, 571, 1, 1, 0, 0, 4529.18, -1987.26, 160.82, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@Bunny+5, @NPCBunny, 571, 1, 1, 0, 0, 4536.03, -1985.47, 160.88, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@Bunny+6, @NPCBunny, 571, 1, 1, 0, 0, 4543.25, -1870.18, 164.702, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@Bunny+7, @NPCBunny, 571, 1, 1, 0, 0, 4532.87, -1949.43, 160.82, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@Bunny+8, @NPCBunny, 571, 1, 1, 0, 0, 4542.17, -1943.22, 160.82, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@Bunny+9, @NPCBunny, 571, 1, 1, 0, 0, 4550.78, -1939.26, 160.82, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@Bunny+10, @NPCBunny, 571, 1, 1, 0, 0, 4557.94, -1925.988, 160.82, 3.15533, 300, 0, 0, 42, 0, 0, 0, 0, 0);

– Kill Credit Ankokeln
DELETE FROM smart_scripts WHERE entryorguid[email protected] 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
(@NPCBunny,0,0,1,8,0,100,0,@SPELL,0,0,0,33,@NPCBunny,0,0,0,0,0,7,0,0,0,0.0,0.0,0.0,0.0,“Kill Credit Ankokeln”),
(@NPCBunny,0,1,0,61,0,100,1,0,0,0,0,41,1000,0,0,0,0,0,1,0,0,0,0.0,0.0,0.0,0.0,“Credit Q and despawn”);
[/sql][/CODE]

Somebody could give me a hint why the credits weren´t count ? TY /emoticons/default_smile.png

2

Already tried to fix this quest but failed as well. Related to the spell. =/

[CODE]-- Famished Scourge Troll SAI
SET @ENTRY := 26570;
SET @SPELL_BURNINATE_EFFECT := 47207;
SET @SPELL_QUEST_CREDIT := 47208;
SET @SPELL_FLAMES := 39199;
UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry[email protected];
DELETE FROM smart_scripts WHERE entryorguid IN (@ENTRY,@ENTRY100);
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
(@ENTRY,0,0,0,8,1,100,0,@SPELL_BURNINATE_EFFECT,0,0,0,80,@ENTRY100,0,0,0,0,0,1,0,0,0,0,0,0,0,“Famished Scourge Troll - On Spellhit - Run Script”),
(@ENTRY100,9,0,0,0,0,100,0,1000,1000,0,0,11,@SPELL_QUEST_CREDIT,0,0,0,0,0,7,0,0,0,0,0,0,0,“Famished Scourge Troll - Script - Cast Burninate Kill Credit”),
(@ENTRY100,9,1,0,0,0,100,0,1000,1000,0,0,11,@SPELL_FLAMES,0,0,0,0,0,1,0,0,0,0,0,0,0,“Famished Scourge Troll - Script - Cast Flames”);[/sql]
(tried it like two months ago)

[/CODE]