[quest] Scourge Tactics

[kirkita]

tdb:36

-- set smartai to Webbed Crusader UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=30273; -- clenup DELETE FROM `smart_scripts` WHERE `entryorguid`=30273 AND (`id`=0 OR `id`=1); -- summon Freed Crusader INSERT INTO `smart_scripts` VALUES (30273,0,0,0,6,0,100,0,0,0,0,0,12,30274,1,3000,0,0,0,1,0,0,0,0,0,0,0,'spawn Freed Crusader'); -- give credit for Scourge Tactics INSERT INTO `smart_scripts` VALUES (30273,0,1,0,6,0,100,0,0,0,0,0,33,30274,0,0,0,0,0,6,0,0,0,0,0,0,0,'Credit - q13008'); [/sql]

[unholy]

@kirkita

ups :S wrong section sorry :S

Wheres the proper TDB format? What core and database?

Here is what it should look like…

-- quest 13008 Scourge Tactics
-- issue: killing Webbed Crusaders does not spawn Freed Crusaders, and gives no credit.
SET @ENTRY := 30273;
-- set smartai to Webbed Crusader
UPDATE `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY;
-- clenup
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY;
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,6,0,100,0,0,0,0,0,12,30274,1,3000,0,0,0,1,0,0,0,0,0,0,0,'spawn Freed Crusader'), -- on death summon Freed Crusader
(@ENTRY,0,1,0,6,0,100,0,0,0,0,0,33,30274,0,0,0,0,0,6,0,0,0,0,0,0,0,'Credit - q13008'); -- give credit for Scourge Tactics
[/sql]


issues not addressed to make this a complete fix.

1. the webbed crusaders do not attack you and they do not move to you on retail, (i just started the quest with my lvl 80 warlock with nothing better to do).

2. when you attack the web, either a Freed Crusader appears or a Forgotten Depths Ambusher or both or nothing.

3. when a Freed Crusader appears, he places Blessing of Might and then heals you.

4. Freed Crusader has text dialogue.

5. when spider appears, there is a kick back explosion.

[Tome]

Working on this for a few weeks now, but to no avail, can’t set an OR operator to spawn different mobs (even tried multiple eventphase setting). I’ll try and update a little more if i have it working soon. (also, don’t have sniffs so some spells used by them are missing)

[unholy]

@Tome

Working on this for a few weeks now, but to no avail, can’t set an OR operator to spawn different mobs (even tried multiple eventphase setting). I’ll try and update a little more if i have it working soon. (also, don’t have sniffs so some spells used by them are missing)

i have tried with SAI also, there seems to be a spawning problem in that area (it is in phase 2), but that should not cause an issue. my script has them dieing and now and then spawn a spider, but no freed crusader nor credit. (thats when i set it aside and move on to something else till i have a brain storm). good luck on your end.

[Svannon]

Would either of you mind showing what part you have working? I’ve been trying as well and am not even getting that far.

[Tassader]

@Svannon

Would either of you mind showing what part you have working? I’ve been trying as well and am not even getting that far.

I can give you my EventAI that I use

UPDATE creature_template SET AIName=‘EventAI’ WHERE entry=‘30273’;
DELETE FROM creature_ai_scripts WHERE creature_id=30273;
INSERT INTO creature_ai_scripts (id,creature_id,event_type,event_inverse_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action1_type,action1_param1,action1_param2,action1_param3,action2_type,action2_param1,action2_param2,action2_param3,action3_type,action3_param1,action3_param2,action3_param3,comment) VALUES
(3027351,30273,6,0,40,0,0,0,0,0, 12,30204,6,180000, 0,0,0,0, 0,0,0,0, ‘Webbed Crusader - summon Forgotten Depths Ambusher on death’),
(3027352,30273,6,0,70,0,0,0,0,0, 11,56516,0,5, 33,30274,6,0, 0,0,0,0, ‘Webbed Crusader - summon Freed Crusader + credit q13008 on death’);

-- EAI pro Webbed Crusader

not sure if it will help you. It somehow works, but the random actions are not mutually exclusive, so it is possible that nothing happens at all or both crusader and ambusher spawn.

It probably could be done this way: on spawn switch to random phase and than in each phase define different event on death. (if you switch phase on death you loose action invoker)

Would be nice if SAI allowed grouping of events in order to make them mutually exclusive. /emoticons/default_smile.png

[Svannon]

Well After some Digging and Some Pure Trail and Error

Updated Jan 20

[SPOILER]-- Webed Crusader (Crusader Verion)
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry=30273;
DELETE FROM smart_scripts WHERE entryorguid=30273;
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
(30273,0,0,0,6,0,100,0,0,0,0,0,85,56515,0x02,0,0,0,0,7,0,0,0,0,0,0,0, ‘Cast Summon Freed Crusader on Death’),
(30273,0,1,0,6,0,100,0,0,0,0,0,33,30274,0,0,0,0,0,7,0,0,0,0,0,0,0, ‘Cast Summon Freed Crusader Quest Credit’);
DELETE FROM spell_scripts WHERE id=56515;
INSERT INTO spell_scripts (id,effIndex,delay,command,datalong,datalong2,dataint,x,y,z,o) VALUES
(56515,0,0,15,56516,2,0,0,0,0,0);
– Webed Crusader (Ambusher Version)
UPDATE creature_template SET AIName= ‘SmartAI’, minlevel=1, maxlevel=1 WHERE entry=30268;
DELETE FROM smart_scripts WHERE entryorguid=30268;
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
(30268,0,0,0,6,0,100,0,0,0,0,0,12,30204,1,30000,0,0,0,1,0,0,0,0,0,0,0, ‘Summon Forgotten Depths Ambusher’);
– Freeed Crusader
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry=30274;
DELETE FROM smart_scripts WHERE entryorguid=30274;
DELETE FROM smart_scripts WHERE entryorguid=3027400;
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
(30274,0,0,0,54,0,100,0,0,0,0,0,80,3027400,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Freed Crusader Start Script on Spawn’),
(3027400,9,0,0,0,0,100,0,0,0,0,0,11,58054,0,0,0,0,0,7,0,0,0,0,0,0,0, ‘Freed Crusader Blessing of Kings’),
(3027400,9,1,0,0,0,100,0,2000,2000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Freed Crusader Speach’),
(3027400,9,2,0,0,0,100,0,0,0,0,0,11,58053,0,0,0,0,0,7,0,0,0,0,0,0,0, ‘Freed Crusader Holy Light’),
– (3027400,9,3,0,0,0,100,0,0,0,0,0,66,3,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Freed Crusader Turn South’), – Core Crash
(3027400,9,4,0,0,0,100,0,4000,4000,0,0,46,20,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Freed Crusader Run 20 yards’),
(3027400,9,5,0,0,0,100,0,0,0,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Freed Crusader Despawn’);
DELETE FROM creature_text WHERE entry=30274;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(30274,0,0, ‘Thank you and farewell, friend. I must return to the Argent Vanguard.’,0,0,100,0,0,0, ‘Freed Crusader Speach’);
– Forgotten Depths Ambusher
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry=30204;
DELETE FROM smart_scripts WHERE entryorguid=30204;
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
(30204,0,0,0,54,0,100,0,0,0,0,0,11,56418,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Forgotten Depths Ambusher - Emerge From Snow’);
– Spawns for Ambusher Verion
SET @GUID :=xxxxxx;
DELETE FROM creature WHERE id=30268;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType, npcflag, unit_flags, dynamicflags) VALUES
(@GUID+0,30268,571,1,2,0,0,6244.78,190.194,383.08,1.50098,0,0,0,0,0,0,0,0,0,0),
(@GUID+1,30268,571,1,2,0,0,6249.75,126.806,382.534,2.47837,0,0,0,0,0,0,0,0,0,0),
(@GUID+2,30268,571,1,2,0,0,6277.33,155.167,383.491,0.43643,0,0,0,0,0,0,0,0,0,0),
(@GUID+3,30268,571,1,2,0,0,6303.7,193.736,387.669,-1.17247,0,0,0,0,0,0,0,0,0,0),
(@GUID+4,30268,571,1,2,0,0,6321.27,152.463,387.239,4.10152,0,0,0,0,0,0,0,0,0,0),
(@GUID+5,30268,571,1,2,0,0,6333.02,57.5423,389.173,4.62512,0,0,0,0,0,0,0,0,0,0),
(@GUID+6,30268,571,1,2,0,0,6335.22,110.147,391.309,6.05629,0,0,0,0,0,0,0,0,0,0),
(@GUID+7,30268,571,1,2,0,0,6339.98,186.907,389.644,-2.29057,0,0,0,0,0,0,0,0,0,0),
(@GUID+8,30268,571,1,2,0,0,6347.77,225.483,393.712,-1.99599,0,0,0,0,0,0,0,0,0,0),
(@GUID+9,30268,571,1,2,0,0,6363.71,126.463,391.424,3.89208,0,0,0,0,0,0,0,0,0,0),
(@GUID+10,30268,571,1,2,0,0,6389.44,226.344,395.383,6.16101,0,0,0,0,0,0,0,0,0,0),
(@GUID+11,30268,571,1,2,0,0,6405.67,158.456,394.692,0.85521,0,0,0,0,0,0,0,0,0,0),
(@GUID+12,30268,571,1,2,0,0,6421.84,258.293,397.279,-2.2004,0,0,0,0,0,0,0,0,0,0),
(@GUID+13,30268,571,1,2,0,0,6434.63,198.273,396.762,5.93412,0,0,0,0,0,0,0,0,0,0);
– Pool creature
SET @Pool=xxxxxx;
DELETE FROM pool_creature WHERE pool_entry BETWEEN @Pool+0 AND @Pool+13;
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(207266,@Pool+0,0, ‘Webbed Crusader Spawn 1’),
(@GUID+0,@Pool+0,0, ‘Webbed Crusader Spawn 1’),
(207267,@Pool+1,0, ‘Webbed Crusader Spawn 2’),
(@GUID+1,@Pool+1,0, ‘Webbed Crusader Spawn 2’),
(207268,@Pool+2,0, ‘Webbed Crusader Spawn 3’),
(@GUID+2,@Pool+2,0, ‘Webbed Crusader Spawn 3’),
(207269,@Pool+3,0, ‘Webbed Crusader Spawn 4’),
(@GUID+3,@Pool+3,0, ‘Webbed Crusader Spawn 4’),
(207270,@Pool+4,0, ‘Webbed Crusader Spawn 5’),
(@GUID+4,@Pool+4,0, ‘Webbed Crusader Spawn 5’),
(207271,@Pool+5,0, ‘Webbed Crusader Spawn 6’),
(@GUID+5,@Pool+5,0, ‘Webbed Crusader Spawn 6’),
(207272,@Pool+6,0, ‘Webbed Crusader Spawn 7’),
(@GUID+6,@Pool+6,0, ‘Webbed Crusader Spawn 7’),
(207273,@Pool+7,0, ‘Webbed Crusader Spawn 8’),
(@GUID+7,@Pool+7,0, ‘Webbed Crusader Spawn 8’),
(207274,@Pool+8,0, ‘Webbed Crusader Spawn 9’),
(@GUID+8,@Pool+8,0, ‘Webbed Crusader Spawn 9’),
(207275,@Pool+9,0, ‘Webbed Crusader Spawn 10’),
(@GUID+9,@Pool+9,0, ‘Webbed Crusader Spawn 10’),
(207276,@Pool+10,0, ‘Webbed Crusader Spawn 11’),
(@GUID+10,@Pool+10,0, ‘Webbed Crusader Spawn 11’),
(207277,@Pool+11,0, ‘Webbed Crusader Spawn 12’),
(@GUID+11,@Pool+11,0, ‘Webbed Crusader Spawn 12’),
(207278,@Pool+12,0, ‘Webbed Crusader Spawn 13’),
(@GUID+12,@Pool+12,0, ‘Webbed Crusader Spawn 13’),
(207279,@Pool+13,0, ‘Webbed Crusader Spawn 14’),
(@GUID+13,@Pool+13,0, ‘Webbed Crusader Spawn 14’);
– Pools
DELETE FROM pool_template WHERE entry BETWEEN @Pool+0 AND @Pool+13;
INSERT INTO pool_template (entry,max_limit,description) VALUES
(@Pool+0,1, ‘Webbed Crusader Spawn 1’),
(@Pool+1,1, ‘Webbed Crusader Spawn 2’),
(@Pool+2,1, ‘Webbed Crusader Spawn 3’),
(@Pool+3,1, ‘Webbed Crusader Spawn 4’),
(@Pool+4,1, ‘Webbed Crusader Spawn 5’),
(@Pool+5,1, ‘Webbed Crusader Spawn 6’),
(@Pool+6,1, ‘Webbed Crusader Spawn 7’),
(@Pool+7,1, ‘Webbed Crusader Spawn 8’),
(@Pool+8,1, ‘Webbed Crusader Spawn 9’),
(@Pool+9,1, ‘Webbed Crusader Spawn 10’),
(@Pool+10,1, ‘Webbed Crusader Spawn 11’),
(@Pool+11,1, ‘Webbed Crusader Spawn 12’),
(@Pool+12,1, ‘Webbed Crusader Spawn 13’),
(@Pool+13,1, ‘Webbed Crusader Spawn 14’);

-- Quest: Scourge Tactics (13008)

[/SPOILER]

[Tassader]

@Svannon

Well After some Digging and Some Pure Trail and Error

Knowen Issues:

1. Ambushers are Not Scripted to Cast there “Opening” Move

2. Freed Crusaders Don’t Cast Their Blessings or Heal (Despawn Works)

Ive Included What i Tried to Do for the Freed Crusaders, but the only working Part is the Despawn. If Someone Can Improve on this please do.

WOW nice

2. I think it could be done using script for spell Summon Freed Crusader - Spell - World of Warcraft to make target cast 56516 at original caster. The summoned crusader could then refer to player by SMART_TARGET_OWNER_OR_SUMMONER or maybe SMART_TARGET_ACTION_INVOKER in event SMART_EVENT_JUST_SUMMONED

[ZxBiohazardZx]

from what i recall they dont “just despawn” but they do a heartstone-like emote and despawn, could be my imagination though

[unholy]

@ZxBiohazardZx

from what i recall they dont “just despawn” but they do a heartstone-like emote and despawn, could be my imagination though

just did the quests there and after they spawn, you get credit, on spawn they hit you with the blessing of kings… (doesnt matter your class, we all got same buff), they have text saying thanks and that they have to go, then they cast a heal on you (weather you need it or not), then they run off toward the vanguard and despawn at like 20 yds out.

[Svannon]

@unholy

just did the quests there and after they spawn, you get credit, on spawn they hit you with the blessing of kings… (doesnt matter your class, we all got same buff), they have text saying thanks and that they have to go, then they cast a heal on you (weather you need it or not), then they run off toward the vanguard and despawn at like 20 yds out.

thanks, thats the details i didnt know about.

[unholy]

@Svannon

thanks, thats the details i didnt know about.

i thought i got more screen shots, but i didnt, i did catch one with text… there could have been more, but if there was, i should have caught it, so maybe they only did one text and maybe the random just rolled that way.

http://img203.images…usadertext.jpg/

also be aware… even though this is cata content… nothing was changed in outland and northrend… azeroth took the major change.

[Svannon]

Post 10 Updated. I think everything is working proper.

[ZxBiohazardZx]

i actually might have this shit in a sniff, lemmy look it up, i sniffed it for another quest, but i included all the prequests in it as well if i recall correctly, crosses fingers

[unholy]

sniff or not… he got it almost 100% (the freed crusaders do just as you have but they should go towards the argeant vanguard) right now they head the opposite way…

bar that little issue i like it and everything is working for me on this fix.

[Svannon]

Well the turn facing crashes the server at the moment, hence why its commented out.

Am not sure if moving to an arbitrary point would do what your refering to about their movment or not.

[unholy]

@Svannon

Well the turn facing crashes the server at the moment, hence why its commented out.

Am not sure if moving to an arbitrary point would do what your refering to about their movment or not.

something i would try but npc pathfinding is not functional and that would be to simply place 1 waypoint there near the bridge at entrance and just have npc go to it and of course he will despawn way before reaching it anyways. that at least will look a whole lot better and realistic.

then again, at least its fixed and if somone who hasnt been on retail to see it, they would never know of the little issue so as far as i see it, this fix is at least 98% bl with its limitations. i have surely seen some interesting glitches and bugs on retail even now in cata.

good job. fix #10 is good to go!

[unholy]

svannon, i added this and it looks really sweet.

CODE,

– create path point location to send Freed Crusaders to
DELETE FROM waypoints WHERE entry=30274;
INSERT INTO waypoints (entry,pointid,position_x,position_y,position_z,point_comment) VALUES
(30274,1,6296.25,92.9397,390.701, ‘send Freed Crusader here’);[/sql]

we have smart action to send to pos (which doesnt seem to work - sends npc off to different zone )

we have set orientation (which core doesnt want to use)

so i add 1 wp at the bridge and when they head to that point… everything looks as close to blizz as it can get now.

here is a video of this quest working on my test server with my addition to it.

http://www.yourfilel…php?fid=602031

[/CODE]

[Svannon]

ok, will Touch up the formating and post on the trac.

[Svannon]

@Svannon

ok, will Touch up the formating and post on the trac.

Now Posted on Tracker.

http://www.trinitycore.org/t/trinitycore/ticket/340