Trinitycore: DB/Quest: The Ata'mal Terrace
Description: The waypoints looks to be wrong, the mount is missing and inhabittype probably wrong https://woehead.way-of-elendil.fr/?npc=22006
SAI combat script is also missing.
Branch(es): Both
TC rev. hash/commit: rev. 34c3962b09db
Killyana
All 20 comments
This will fix mount, inhabit type and combat scripts (I also added combat scripts for every nearby mob). As for waypoints, I can't sniff from retail, so I can't help with that. Sorry... :(
``sql
-- Shadowlord Deathwail
UPDATEcreature_addonSETmount=20684 WHEREguid`=77084; -- Fix mount
DELETE FROM creature_template_movement WHERE CreatureId=22006; -- Fix inhabit type
INSERT INTO creature_template_movement (CreatureId, Ground, Swim, Flight, Rooted) VALUES
(22006,1,1,2,0);
UPDATE creature_template SET AIName="SmartAI" WHERE entry=22006;
DELETE FROM smart_scripts WHERE entryorguid=22006 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
(22006,0,0,0,6,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Just Died - Say Line 0"),
(22006,0,1,0,0,0,100,0,0,0,3000,5000,11,12471,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowlord Deathwail - In Combat - Cast 'Shadow Bolt'"),
(22006,0,2,0,0,0,100,0,5000,7000,15000,17000,11,15245,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - In Combat - Cast 'Shadow Bolt Volley'"),
(22006,0,3,0,0,0,100,0,9000,12000,18000,24000,11,32709,0,0,0,0,0,5,0,0,0,0,0,0,0,"Shadowlord Deathwail - In Combat - Cast 'Death Coil'"),
(22006,0,4,0,0,0,100,0,14000,17000,22000,28000,11,27641,0,0,0,0,0,5,0,0,0,0,0,0,0,"Shadowlord Deathwail - In Combat - Cast 'Fear'");
DELETE FROM creature_text WHERE CreatureID=22006;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(22006,0,0,"Master... I've failed you...",14,0,100,0,0,0,19820,0,"Shadowlord Deathwail");
-- Shadowmoon Soulstealer
DELETE FROM smart_scripts WHERE entryorguid=22061 AND source_type=0 AND id IN (1,2);
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
(22061,0,1,0,25,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Soulstealer - On Reset - Set Reactstate Passive"),
(22061,0,2,0,4,0,100,0,0,0,0,0,11,38250,0,0,0,0,0,19,22058,0,0,0,0,0,0,"Shadowmoon Soulstealer - On Aggro - Cast 'Heart of Fury Siphon'");
-- Shadowmoon Darkweaver
UPDATE creature_template SET AIName="SmartAI" WHERE entry=22081;
DELETE FROM smart_scripts WHERE entryorguid=22081 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
(22081,0,0,0,0,0,100,0,0,0,3000,5000,11,9613,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmoon Darkweaver - In Combat - Cast 'Shadow Bolt'"),
(22081,0,1,0,9,0,100,0,0,30,15000,18000,11,11962,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmoon Darkweaver - Within 0-30 Range - Cast 'Immolate'"),
(22081,0,2,0,9,0,100,0,0,10,8000,11000,11,35373,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Darkweaver - Within 0-10 Range - Cast 'Shadowfury'");
-- Shadowmoon Chosen
UPDATE creature_template SET AIName="SmartAI" WHERE entry=22084;
DELETE FROM smart_scripts WHERE entryorguid=22084 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
(22084,0,0,0,9,0,100,0,0,5,15000,17000,11,38618,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Chosen - Within 0-5 Range - Cast 'Whirlwind'"),
(22084,0,1,0,0,0,100,0,8000,10000,18000,22000,11,10966,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmoon Chosen - In Combat - Cast 'Uppercut'");
-- Shadowmoon Slayer
UPDATE creature_template SET AIName="SmartAI" WHERE entry=22082;
DELETE FROM smart_scripts WHERE entryorguid=22082 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
(22082,0,0,1,2,0,100,1,0,30,0,0,11,3019,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Slayer - Between 0-30% Health - Cast 'Frenzy'"),
(22082,0,1,0,61,0,100,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Slayer - Between 0-30% Health - Say Line 0"),
(22082,0,2,0,0,0,100,0,5000,7000,12000,15000,11,37577,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmoon Slayer - In Combat - Cast 'Debilitating Strike'");
DELETE FROM creature_text WHERE CreatureID=22082;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(22082,0,0,"%s goes into a frenzy!",16,0,100,0,0,0,2384,0,"Shadowmoon Slayer");
-- Shadowsworn Drakonid
UPDATE creature_template SET AIName="SmartAI" WHERE entry=22072;
DELETE FROM smart_scripts WHERE entryorguid=22072 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
(22072,0,0,0,0,0,100,0,5000,7000,11000,13000,11,15496,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Drakonid - In Combat - Cast 'Cleave'"),
(22072,0,1,0,0,0,100,0,6000,8000,14000,16000,11,17547,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Drakonid - In Combat - Cast 'Mortal Strike'"),
(22072,0,2,0,0,0,100,0,9000,11000,18000,22000,11,16145,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Drakonid - In Combat - Cast 'Sunder Armor'");
-- Shadowmoon Retainer
UPDATE creature_template SET AIName="SmartAI" WHERE entry=22102;
DELETE FROM smart_scripts WHERE entryorguid=22102 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
(22102,0,0,0,0,0,100,0,0,0,2000,4000,11,15547,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmoon Retainer - In Combat - Cast 'Shoot'");
ZenoX92
on 9 Mar 2018
As the waypoints are still not added or changed, this shouldn't be closed.
Kittnz
on 9 Mar 2018
The waypoint looks correct, but there's an event :https://wow.gamepedia.com/Quest:The_Ata%27mal_Terrace for the quest http://www.wowhead.com/quest=10707/the-atamal-terrace https://www.youtube.com/watch?v=HoeSAheA36M
I'm not sure but probably Shadowlord Deathwail must be non-attackable until the three Shadowmoon Soulstealer are dead.
Killyana
on 9 Mar 2018
I came across a small problem - creature_template_movement I do not have a table created. If I create the system when implementing a line:
DELETE FROM `creature_template_movement` WHERE `CreatureId`=22006; -- Fix inhabit type
INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`) VALUES
(22006,1,1,2,0);
it says that implementation is impossible because it is empty.
did anyone meet this?
The others were to be implemented correctly.
try editing has not succeeded.
shamage
on 12 Mar 2018
you need to update your core.
Aokromes
on 12 Mar 2018
Yes, it was added to TDB 4 days ago (2018-03-08 23:13:51 GMT+0100) in Core/Movement: Fixed creature hover
https://github.com/TrinityCore/TrinityCore/pull/20961/files#diff-3bb6433b3e013a0dcc2f5e532eb3a748
ghost
on 12 Mar 2018
Ohh sorry - I did not realize it was TDB 3.3.5 and I used the implementation on TDB 735.00 - the bug is with me :(
TDB 735.00 does not contain a table creature_template_movement or are I again wrong? I'm a little bit miserable - I'm using TDB_735.00_2018_02_19 (master = 7.3.5.26124) and updates to do so today
shamage
on 12 Mar 2018
Please, do not assume that suggested fixes for the 3.3.5 branch are compatible with the master branch.
Any compatible fix posted/committed to the 3.3.5 branch will be cherry-picked if valid.
Do not add stuff without knowing 100% what you are doing.
ghost
on 12 Mar 2018
thanks for the explanation :)
Odoslan茅 z m么jho smartf贸nu Samsung Galaxy.
null
shamage
on 13 Mar 2018
@Killyana, take a look a this. I tried to script the event based on the video. Hope it'll be of your liking. :)
There's an issue with spell "Fel Fireball" (id: 38312) though. The "ball" is supposed to explode once it reaches the ground, but it explodes in the air inmediately after cast. I think this needs C++ scripts, but it doesn't affect the event and quest can be completed perfectly.
``sql
-- Shadowlord Deathwail
DELETE FROMsmart_scriptsWHEREentryorguid=22006 ANDsource_type=0 ANDidIN (5,6,7,8,9,10,11,12,13,14,15,16);
DELETE FROMsmart_scriptsWHEREentryorguid=2200600 ANDsource_type=9;
INSERT INTOsmart_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
(22006,0,5,0,25,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Reset - Set Unit Flags 'Immune To Player' & 'Immune To NPC'"),
(22006,0,6,0,17,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Summoned Unit - Store Targetlist"),
(22006,0,7,0,38,0,100,1,1,1,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 1 1 - Set Event Phase 1 (No Repeat)"),
(22006,0,8,0,38,0,100,1,1,1,0,0,80,2200600,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 1 1 - Run Script"),
(22006,0,9,0,1,1,100,0,5000,5000,5000,5000,11,38312,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - Out of Combat - Cast 'Fel Fireball' (Phase 1,2,3)"),
(22006,0,10,0,38,0,100,0,2,2,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 2 2 - Set Event Phase 2"),
(22006,0,11,0,38,0,100,0,2,2,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 2 2 - Say Line 1"),
(22006,0,12,0,38,0,100,0,2,2,0,0,53,1,22006,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 2 2 - Start Waypoint"),
(22006,0,13,0,40,0,100,0,1,22006,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Say Line 2"),
(22006,0,14,0,40,0,100,0,1,22006,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Remove Unit Flags 'Immune To Player' & 'Immune To NPC'"),
(22006,0,15,0,40,0,100,0,1,22006,0,0,41,0,0,0,0,0,0,19,22058,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Despawn Creature 'Heart of Fury Visual Trigger'"),
(22006,0,16,0,40,0,100,0,1,22006,0,0,41,0,300,0,0,0,0,14,25982,185125,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Despawn Gameobject 'Heart of Fury'"),
(2200600,9,0,0,0,0,100,0,5000,5000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.99,253.727,139.047,2.36666,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,1,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,2,0,0,0,100,0,16000,16000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.99,253.727,139.047,2.36666,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,3,0,0,0,100,0,0,0,0,0,45,1,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,4,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3257.27,258.959,137.076,1.1633,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,5,0,0,0,100,0,0,0,0,0,45,1,3,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,6,0,0,0,100,0,10000,10000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3245.69,346.943,127.465,6.26135,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,7,0,0,0,100,0,0,0,0,0,45,1,4,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,8,0,0,0,100,0,30000,30000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3245.69,346.943,127.465,6.26135,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,9,0,0,0,100,0,0,0,0,0,45,1,5,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data");
DELETE FROM creature_text WHERE CreatureID=22006 AND GroupID IN (1,2);
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(22006,1,0,"You will never get the Heart of Fury! Its power belongs to Illidan!",14,0,100,0,0,0,19744,0,"Shadowlord Deathwail"),
(22006,2,0,"%s retrieves the Heart of Fury.",16,0,100,0,0,0,19830,0,"Shadowlord Deathwail");
DELETE FROM waypoints WHERE entry=22006;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(22006,1,-3249.96,287.168,139.646,"");
-- Shadowmoon Soulstealer
DELETE FROM smart_scripts WHERE entryorguid=22061 AND source_type=0 AND id IN (3,4);
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
(22061,0,3,0,4,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,22006,0,0,0,0,0,0,"Shadowmoon Soulstealer - On Aggro - Set Data 1 1 to Shadowlord Deathwail"),
(22061,0,4,0,6,0,100,0,0,0,0,0,45,2,2,0,0,0,0,19,22006,0,0,0,0,0,0,"Shadowmoon Soulstealer - On Just Died - Set Data 2 2 to Shadowlord Deathwail");
DELETE FROM conditions WHERE SourceTypeOrReferenceId=22 AND SourceEntry=22061;
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(22,5,22061,0,0,29,1,22061,100,0,1,0,0,"","SAI triggers only if all Shadowmoon Soulstealers are dead");
-- Shadowmoon Retainer
DELETE FROM smart_scripts WHERE entryorguid=22102 AND source_type=0 AND id IN (1,2,3,4,5,6,7,8);
DELETE FROM smart_scripts WHERE entryorguid IN (2210200,2210201,2210202,2210203,2210204) AND source_type=9;
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
(22102,0,1,0,17,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Summoned Unit - Store Targetlist"),
(22102,0,2,0,38,0,100,0,1,1,0,0,80,2210200,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,3,0,38,0,100,0,1,2,0,0,80,2210201,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,4,0,38,0,100,0,1,3,0,0,80,2210202,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,5,0,38,0,100,0,1,4,0,0,80,2210203,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,6,0,38,0,100,0,1,5,0,0,80,2210204,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,7,0,38,0,100,0,2,1,0,0,29,0,150,0,0,0,0,23,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Start Follow"),
(22102,0,8,0,38,0,100,0,2,2,0,0,29,0,210,0,0,0,0,23,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Start Follow"),
(2210200,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.73,251.193,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210200,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210200,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3212.19,253.787,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210200,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210200,9,4,0,0,0,100,0,0,0,0,0,53,1,2210200,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210201,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.73,251.193,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210201,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210201,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3212.19,253.787,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210201,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210201,9,4,0,0,0,100,0,0,0,0,0,53,1,2210201,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210202,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3259.99,257.488,137.045,1.23791,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210202,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210202,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3256.09,256.141,137.077,1.23791,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210202,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210202,9,4,0,0,0,100,0,0,0,0,0,53,0,2210202,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210203,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.74,348.919,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210203,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210203,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.61,344.952,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210203,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210203,9,4,0,0,0,100,0,0,0,0,0,53,0,2210203,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210204,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.74,348.919,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210204,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210204,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.61,344.952,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210204,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210204,9,4,0,0,0,100,0,0,0,0,0,53,0,2210204,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint");
DELETE FROM waypoints WHERE entry IN (2210200,2210201,2210202,2210203,2210204);
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(2210200,1,-3243.46,281.49,137.111,""),
(2210200,2,-3241.79,298.108,137.055,""),
(2210200,3,-3258.93,306.993,136.986,""),
(2210200,4,-3269.23,294.214,136.989,""),
(2210200,5,-3265.87,279.522,137.01,""),
(2210200,6,-3243.46,281.49,137.111,""),
(2210200,7,-3220.84,303.139,137.045,""),
(2210201,1,-3243.46,281.49,137.111,""),
(2210201,2,-3241.79,298.108,137.055,""),
(2210201,3,-3258.93,306.993,136.986,""),
(2210201,4,-3269.23,294.214,136.989,""),
(2210201,5,-3263.77,268.623,137.019,""),
(2210201,6,-3254.17,266.099,137.088,""),
(2210201,7,-3248.72,278.363,137.108,""),
(2210202,1,-3243.46,281.49,137.111,""),
(2210202,2,-3228.1,292.874,137.111,""),
(2210203,1,-3240.07,346.884,127.5,""),
(2210203,2,-3230.84,332.969,128.183,""),
(2210203,3,-3230.15,308.479,136.995,""),
(2210203,4,-3243.53,293.283,137.067,""),
(2210203,5,-3243,278.767,137.121,""),
(2210203,6,-3253.34,265.224,137.095,""),
(2210203,7,-3266.03,269.369,137,""),
(2210203,8,-3270.26,295.106,136.985,""),
(2210203,9,-3256.06,301.488,137.038,""),
(2210203,10,-3251.09,292.567,137.079,""),
(2210204,1,-3240.07,346.884,127.5,""),
(2210204,2,-3230.84,332.969,128.183,""),
(2210204,3,-3230.15,308.479,136.995,""),
(2210204,4,-3241.79,298.108,137.055,""),
(2210204,5,-3258.93,306.993,136.986,""),
(2210204,6,-3269.23,294.214,136.989,""),
(2210204,7,-3264.68,284.52,137.014,""),
(2210204,8,-3258.65,285.294,137.031,"");
ZenoX92
on 16 Mar 2018
The spell 38312 summon the npc 22121, it must be done on the current target (the player) than the Effet #2 hit the npc trigger
I will to fix the conditions
Killyana
on 16 Mar 2018
Here the condition:
``sql
DELETE FROMconditionsWHERESourceTypeOrReferenceId=13 ANDSourceEntryIN (38312);
INSERT INTOconditions(SourceTypeOrReferenceId,SourceGroup,SourceEntry,SourceId,ElseGroup,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,ConditionValue3,NegativeCondition,ErrorTextId,ScriptName,Comment`) VALUES
(13,7,38312,0,0,31,0,4,0,0,0,0,'','Fel Fireball');
Killyana
on 16 Mar 2018
22006 is not able to start the waypoint:
SmartAI::StartPath: Creature entry 22006 wanted to start waypoint movement (22006) while in combat, ignoring.
I tried with move to pos but it will resume the waypoint_data once the position reached, in this case we are supposed to use SMART_ACTION_STOP_MOTION but it looks to be broken by recent changes.
Killyana
on 18 Mar 2018
Scripting anything that uses waypoints has become really stressful lately. :P
Let me make some more tests on this...
ZenoX92
on 19 Mar 2018
I updated the script. Test it now @Killyana.
ZenoX92
on 27 Mar 2018
Still the same issue, it must be fixed on core side.
Killyana
on 27 Mar 2018
``` sql
-- Shadowlord Deathwail
UPDATE smart_scripts SET event_phase_mask=4 WHERE entryorguid IN (22006) AND source_type=0 AND id IN (1,2,3,4);
DELETE FROM smart_scripts WHERE entryorguid=22006 AND source_type=0 AND id IN (5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20);
DELETE FROM smart_scripts WHERE entryorguid=2200600 AND source_type=9;
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
(22006,0,5,0,25,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Reset - Set Unit Flags 'Immune To Player' & 'Immune To NPC'"),
(22006,0,6,0,17,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Summoned Unit - Store Targetlist"),
(22006,0,7,0,38,0,100,1,1,1,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 1 1 - Set Event Phase 1 (No Repeat)"),
(22006,0,8,0,38,0,100,1,1,1,0,0,80,2200600,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 1 1 - Run Script"),
(22006,0,9,0,1,1,100,0,5000,5000,5000,5000,11,38312,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - Out of Combat - Cast 'Fel Fireball' (Phase 1)"),
(22006,0,10,0,38,0,100,0,2,2,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 2 2 - Set Event Phase 2"),
(22006,0,11,0,38,0,100,0,2,2,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 2 2 - Say Line 1"),
(22006,0,12,0,38,0,100,0,2,2,0,0,69,25,0,0,0,0,0,8,0,0,0,-3249.96,287.168,139.646,0,"Shadowlord Deathwail - On Data Set 2 2 - Start Waypoint"),
(22006,0,13,0,34,0,100,0,0,25,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Say Line 2"),
(22006,0,14,0,34,0,100,0,0,25,0,0,8,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Set react agressif"),
(22006,0,15,0,34,0,100,0,0,25,0,0,41,0,0,0,0,0,0,19,22058,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Despawn Creature 'Heart of Fury Visual Trigger'"),
(22006,0,16,0,34,0,100,0,0,25,0,0,41,0,300,0,0,0,0,14,25982,185125,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Despawn Gameobject 'Heart of Fury'"),
(22006,0,17,0,34,0,100,0,0,25,0,0,22,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - text over - Set Event Phase 3"),
(22006,0,18,0,34,0,100,0,0,25,0,0,19,33554432,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - text over - Set Event Phase 3"),
(22006,0,19,0,34,0,100,0,0,25,0,0,127,2,1,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 2 2 - Say Line 1"),
(22006,0,20,0,0,1,100,0,5000,5000,5000,5000,11,38312,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - In Combat - Cast 'Fel Fireball' (Phase 1)"),
(2200600,9,0,0,0,0,100,0,0,0,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Remove Unit Flags 'Immune To Player' & 'Immune To NPC'"),
(2200600,9,1,0,0,0,100,0,0,0,0,0,18,33554432,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Remove Unit Flags 'Immune To Player' & 'Immune To NPC'"),
(2200600,9,2,0,0,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set react passif"),
(2200600,9,3,0,0,0,100,0,5000,5000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.99,253.727,139.047,2.36666,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,4,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,5,0,0,0,100,0,16000,16000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.99,253.727,139.047,2.36666,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,6,0,0,0,100,0,0,0,0,0,45,1,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,7,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3257.27,258.959,137.076,1.1633,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,8,0,0,0,100,0,0,0,0,0,45,1,3,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,9,0,0,0,100,0,10000,10000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3245.69,346.943,127.465,6.26135,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,10,0,0,0,100,0,0,0,0,0,45,1,4,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,11,0,0,0,100,0,30000,30000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3245.69,346.943,127.465,6.26135,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,12,0,0,0,100,0,0,0,0,0,45,1,5,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data");
DELETE FROM creature_text WHERE CreatureID=22006 AND GroupID IN (1,2);
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(22006,1,0,"You will never get the Heart of Fury! Its power belongs to Illidan!",14,0,100,0,0,0,19744,0,"Shadowlord Deathwail"),
(22006,2,0,"%s retrieves the Heart of Fury.",16,0,100,0,0,0,19830,0,"Shadowlord Deathwail");
DELETE FROM waypoints WHERE entry=22006;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(22006,1,-3249.96,287.168,139.646,"");
-- Shadowmoon Soulstealer
DELETE FROM smart_scripts WHERE entryorguid=22061 AND source_type=0 AND id IN (3,4);
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
(22061,0,3,0,4,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,22006,0,0,0,0,0,0,"Shadowmoon Soulstealer - On Aggro - Set Data 1 1 to Shadowlord Deathwail"),
(22061,0,4,0,6,0,100,0,0,0,0,0,45,2,2,0,0,0,0,19,22006,0,0,0,0,0,0,"Shadowmoon Soulstealer - On Just Died - Set Data 2 2 to Shadowlord Deathwail");
DELETE FROM conditions WHERE SourceTypeOrReferenceId=22 AND SourceEntry=22061;
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(22,5,22061,0,0,29,1,22061,100,0,1,0,0,"","SAI triggers only if all Shadowmoon Soulstealers are dead");
-- Shadowmoon Retainer
DELETE FROM smart_scripts WHERE entryorguid=22102 AND source_type=0 AND id IN (1,2,3,4,5,6,7,8);
DELETE FROM smart_scripts WHERE entryorguid IN (2210200,2210201,2210202,2210203,2210204) AND source_type=9;
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
(22102,0,1,0,17,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Summoned Unit - Store Targetlist"),
(22102,0,2,0,38,0,100,0,1,1,0,0,80,2210200,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,3,0,38,0,100,0,1,2,0,0,80,2210201,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,4,0,38,0,100,0,1,3,0,0,80,2210202,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,5,0,38,0,100,0,1,4,0,0,80,2210203,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,6,0,38,0,100,0,1,5,0,0,80,2210204,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,7,0,38,0,100,0,2,1,0,0,29,0,150,0,0,0,0,23,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Start Follow"),
(22102,0,8,0,38,0,100,0,2,2,0,0,29,0,210,0,0,0,0,23,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Start Follow"),
(2210200,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.73,251.193,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210200,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210200,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3212.19,253.787,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210200,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210200,9,4,0,0,0,100,0,0,0,0,0,53,1,2210200,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210201,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.73,251.193,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210201,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210201,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3212.19,253.787,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210201,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210201,9,4,0,0,0,100,0,0,0,0,0,53,1,2210201,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210202,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3259.99,257.488,137.045,1.23791,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210202,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210202,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3256.09,256.141,137.077,1.23791,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210202,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210202,9,4,0,0,0,100,0,0,0,0,0,53,0,2210202,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210203,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.74,348.919,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210203,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210203,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.61,344.952,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210203,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210203,9,4,0,0,0,100,0,0,0,0,0,53,0,2210203,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210204,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.74,348.919,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210204,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210204,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.61,344.952,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210204,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210204,9,4,0,0,0,100,0,0,0,0,0,53,0,2210204,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint");
DELETE FROM waypoints WHERE entry IN (2210200,2210201,2210202,2210203,2210204);
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(2210200,1,-3243.46,281.49,137.111,""),
(2210200,2,-3241.79,298.108,137.055,""),
(2210200,3,-3258.93,306.993,136.986,""),
(2210200,4,-3269.23,294.214,136.989,""),
(2210200,5,-3265.87,279.522,137.01,""),
(2210200,6,-3243.46,281.49,137.111,""),
(2210200,7,-3220.84,303.139,137.045,""),
(2210201,1,-3243.46,281.49,137.111,""),
(2210201,2,-3241.79,298.108,137.055,""),
(2210201,3,-3258.93,306.993,136.986,""),
(2210201,4,-3269.23,294.214,136.989,""),
(2210201,5,-3263.77,268.623,137.019,""),
(2210201,6,-3254.17,266.099,137.088,""),
(2210201,7,-3248.72,278.363,137.108,""),
(2210202,1,-3243.46,281.49,137.111,""),
(2210202,2,-3228.1,292.874,137.111,""),
(2210203,1,-3240.07,346.884,127.5,""),
(2210203,2,-3230.84,332.969,128.183,""),
(2210203,3,-3230.15,308.479,136.995,""),
(2210203,4,-3243.53,293.283,137.067,""),
(2210203,5,-3243,278.767,137.121,""),
(2210203,6,-3253.34,265.224,137.095,""),
(2210203,7,-3266.03,269.369,137,""),
(2210203,8,-3270.26,295.106,136.985,""),
(2210203,9,-3256.06,301.488,137.038,""),
(2210203,10,-3251.09,292.567,137.079,""),
(2210204,1,-3240.07,346.884,127.5,""),
(2210204,2,-3230.84,332.969,128.183,""),
(2210204,3,-3230.15,308.479,136.995,""),
(2210204,4,-3241.79,298.108,137.055,""),
(2210204,5,-3258.93,306.993,136.986,""),
(2210204,6,-3269.23,294.214,136.989,""),
(2210204,7,-3264.68,284.52,137.014,""),
(2210204,8,-3258.65,285.294,137.031,"");
DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry IN (38312);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorTextId, ScriptName, Comment) VALUES
(13,7,38312,0,0,31,0,4,0,0,0,0,'','Fel Fireball');
Killyana
on 29 Aug 2018
- Change waypoint_data to waypoints (as the SAI action SMART_ACTION_STOP_MOTION is broken)
- The remaining issue is we cannot reset Shadowlord Deathwail as he's in combat but not engaged, in this case reset() is never called after a combat (same for ooc no repeat)
``` sql
UPDATE creature_template SET AIName="SmartAI" WHERE entry=22121;
UPDATE smart_scripts SET event_phase_mask=4 WHERE entryorguid IN (22006) AND source_type=0 AND id IN (1,2,3,4);
DELETE FROM smart_scripts WHERE entryorguid=22006 AND source_type=0 AND id IN (5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30);
DELETE FROM smart_scripts WHERE entryorguid=22121 AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid=2200600 AND source_type=9;
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
(22006,0,5,0,0,1,100,0,5000,5000,5000,5000,11,38312,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - In Combat - Cast 'Fel Fireball' (Phase 1)"),
(22006,0,6,0,17,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Summoned Unit - Store Targetlist"),
(22006,0,7,8,38,0,100,1,1,1,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 1 1 - Set Event Phase 1 (No Repeat)"),
(22006,0,8,0,61,0,100,0,0,0,0,0,80,2200600,2,1,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 1 1 - Run Script"),
(22006,0,9,0,1,1,100,0,5000,5000,5000,5000,11,38312,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - Out of Combat - Cast 'Fel Fireball' (Phase 1)"),
(22006,0,10,11,38,0,100,0,2,2,300000,300000,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 2 2 - Set Event Phase 2"),
(22006,0,11,12,61,0,100,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 2 2 - Say Line 1"),
(22006,0,12,13,61,0,100,0,0,0,0,0,55,0,0,0,0,0,0,1,0,0,0,0, 0, 0 ,0,"Shadowlord Deathwail - On Data Set 2 2 - Stop WP"),
(22006,0,13,0,61,0,100,0,0,0,0,0,53,0,22006,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Data Set 2 2 - start WP"),
(22006,0,14,15,40,0,100,0,1,22006,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Say Line 2"),
(22006,0,15,16,61,0,100,0,0,0,0,0,8,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Set react agressif"),
(22006,0,16,17,61,0,100,0,0,0,0,0,41,0,300,0,0,0,0,19,22058,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Despawn Creature 'Heart of Fury Visual Trigger'"),
(22006,0,17,18,61,0,100,0,0,0,0,0,41,0,300,0,0,0,0,14,25982,185125,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Despawn Gameobject 'Heart of Fury'"),
(22006,0,18,19,61,0,100,0,0,0,0,0,22,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Set Event Phase 3"),
(22006,0,19,20,61,0,100,0,0,0,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - remove unitflags"),
(22006,0,20,0,61,0,100,0,0,0,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Set fly off"),
(22006,0,21,22,25,0,100,0,0,0,0,0,55,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Reset - Stop WP"),
(22006,0,22,23,61,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Reset - Set unit_flag"),
(22006,0,23,24,61,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Reset - Set Event Phase 0"),
(22006,0,24,25,61,0,100,0,0,0,0,0,133,1,25982,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Reset - Respawn GO"),
(22006,0,25,26,61,0,100,0,0,0,0,0,133,0,77279,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Reset - Respawn npc"),
(22006,0,26,27,61,0,100,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Reset - Turn Fly on"),
(22006,0,27,0,61,0,100,0,0,0,0,0,53,0,2200600,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Reset - Start WP"),
(22006,0,28,0,40,0,100,0,23,2200600,0,0,53,0,2200600,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Waypoint 1 Reached - Start wp"),
(2200600,9,0,0,0,0,100,0,0,0,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Remove Unit Flags 'Immune To Player' & 'Immune To NPC'"),
(2200600,9,1,0,0,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set react passif"),
(2200600,9,2,0,0,0,100,0,5000,5000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.99,253.727,139.047,2.36666,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,3,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,4,0,0,0,100,0,16000,16000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.99,253.727,139.047,2.36666,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,5,0,0,0,100,0,0,0,0,0,45,1,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,6,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3257.27,258.959,137.076,1.1633,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,7,0,0,0,100,0,0,0,0,0,45,1,3,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,8,0,0,0,100,0,10000,10000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3245.69,346.943,127.465,6.26135,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,9,0,0,0,100,0,0,0,0,0,45,1,4,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(2200600,9,10,0,0,0,100,0,30000,30000,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3245.69,346.943,127.465,6.26135,"Shadowlord Deathwail - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2200600,9,11,0,0,0,100,0,0,0,0,0,45,1,5,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowlord Deathwail - On Script - Set Data"),
(22121,0,0,0,54,0,100,0,0,0,0,0,11,38375,0,0,0,0,0,1,0,0,0,0,0,0,0,"Felfire Summoner - Just summoned - Cast Serverside - Summon Fel Fire");
DELETE FROM creature_text WHERE CreatureID=22006 AND GroupID IN (1,2);
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(22006,1,0,"You will never get the Heart of Fury! Its power belongs to Illidan!",14,0,100,0,0,0,19744,0,"Shadowlord Deathwail"),
(22006,2,0,"%s retrieves the Heart of Fury.",16,0,100,0,0,0,19830,0,"Shadowlord Deathwail");
DELETE FROM waypoints WHERE entry=22006;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(22006,1,-3249.96,287.168,139.646,"");
-- Shadowmoon Soulstealer
DELETE FROM smart_scripts WHERE entryorguid=22061 AND source_type=0 AND id IN (3,4);
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
(22061,0,3,0,4,0,100,0,0,0,0,0,45,1,1,0,0,0,0,10,77084,22006,0,0,0,0,0,"Shadowmoon Soulstealer - On Aggro - Set Data 1 1 to Shadowlord Deathwail"),
(22061,0,4,0,6,0,100,0,0,0,0,0,45,2,2,0,0,0,0,10,77084,22006,0,0,0,0,0,"Shadowmoon Soulstealer - On Just Died - Set Data 2 2 to Shadowlord Deathwail");
DELETE FROM conditions WHERE SourceTypeOrReferenceId=22 AND SourceEntry=22061;
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(22,5,22061,0,0,29,1,22061,100,0,1,0,0,"","SAI triggers only if all Shadowmoon Soulstealers are dead");
-- Shadowmoon Retainer
DELETE FROM smart_scripts WHERE entryorguid=22102 AND source_type=0 AND id IN (1,2,3,4,5,6,7,8);
DELETE FROM smart_scripts WHERE entryorguid IN (2210200,2210201,2210202,2210203,2210204) AND source_type=9;
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
(22102,0,1,0,17,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Summoned Unit - Store Targetlist"),
(22102,0,2,0,38,0,100,0,1,1,0,0,80,2210200,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,3,0,38,0,100,0,1,2,0,0,80,2210201,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,4,0,38,0,100,0,1,3,0,0,80,2210202,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,5,0,38,0,100,0,1,4,0,0,80,2210203,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,6,0,38,0,100,0,1,5,0,0,80,2210204,2,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Run Script"),
(22102,0,7,0,38,0,100,0,2,1,0,0,29,0,150,0,0,0,0,23,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Start Follow"),
(22102,0,8,0,38,0,100,0,2,2,0,0,29,0,210,0,0,0,0,23,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Data Set - Start Follow"),
(2210200,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.73,251.193,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210200,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210200,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3212.19,253.787,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210200,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210200,9,4,0,0,0,100,0,0,0,0,0,53,1,2210200,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210201,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3214.73,251.193,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210201,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210201,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3212.19,253.787,139.047,2.36666,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210201,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210201,9,4,0,0,0,100,0,0,0,0,0,53,1,2210201,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210202,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3259.99,257.488,137.045,1.23791,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210202,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210202,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3256.09,256.141,137.077,1.23791,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210202,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210202,9,4,0,0,0,100,0,0,0,0,0,53,0,2210202,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210203,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.74,348.919,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210203,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210203,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.61,344.952,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210203,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210203,9,4,0,0,0,100,0,0,0,0,0,53,0,2210203,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint"),
(2210204,9,0,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.74,348.919,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210204,9,1,0,0,0,100,0,0,0,0,0,45,2,1,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210204,9,2,0,0,0,100,0,0,0,0,0,12,22102,3,180000,0,0,0,8,0,0,0,-3247.61,344.952,127.443,0.0959725,"Shadowmoon Retainer - On Script - Summon Creature 'Shadowmoon Retainer'"),
(2210204,9,3,0,0,0,100,0,0,0,0,0,45,2,2,0,0,0,0,12,1,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Set Data"),
(2210204,9,4,0,0,0,100,0,0,0,0,0,53,0,2210204,0,0,0,2,1,0,0,0,0,0,0,0,"Shadowmoon Retainer - On Script - Start Waypoint");
DELETE FROM waypoints WHERE entry IN (2210200,2210201,2210202,2210203,2210204);
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(2210200,1,-3243.46,281.49,137.111,""),
(2210200,2,-3241.79,298.108,137.055,""),
(2210200,3,-3258.93,306.993,136.986,""),
(2210200,4,-3269.23,294.214,136.989,""),
(2210200,5,-3265.87,279.522,137.01,""),
(2210200,6,-3243.46,281.49,137.111,""),
(2210200,7,-3220.84,303.139,137.045,""),
(2210201,1,-3243.46,281.49,137.111,""),
(2210201,2,-3241.79,298.108,137.055,""),
(2210201,3,-3258.93,306.993,136.986,""),
(2210201,4,-3269.23,294.214,136.989,""),
(2210201,5,-3263.77,268.623,137.019,""),
(2210201,6,-3254.17,266.099,137.088,""),
(2210201,7,-3248.72,278.363,137.108,""),
(2210202,1,-3243.46,281.49,137.111,""),
(2210202,2,-3228.1,292.874,137.111,""),
(2210203,1,-3240.07,346.884,127.5,""),
(2210203,2,-3230.84,332.969,128.183,""),
(2210203,3,-3230.15,308.479,136.995,""),
(2210203,4,-3243.53,293.283,137.067,""),
(2210203,5,-3243,278.767,137.121,""),
(2210203,6,-3253.34,265.224,137.095,""),
(2210203,7,-3266.03,269.369,137,""),
(2210203,8,-3270.26,295.106,136.985,""),
(2210203,9,-3256.06,301.488,137.038,""),
(2210203,10,-3251.09,292.567,137.079,""),
(2210204,1,-3240.07,346.884,127.5,""),
(2210204,2,-3230.84,332.969,128.183,""),
(2210204,3,-3230.15,308.479,136.995,""),
(2210204,4,-3241.79,298.108,137.055,""),
(2210204,5,-3258.93,306.993,136.986,""),
(2210204,6,-3269.23,294.214,136.989,""),
(2210204,7,-3264.68,284.52,137.014,""),
(2210204,8,-3258.65,285.294,137.031,"");
DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry IN (38312);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorTextId, ScriptName, Comment) VALUES
(13,7,38312,0,0,31,0,4,0,0,0,0,'','Fel Fireball');
DELETE FROM waypoint_data WHERE id=770840;
UPDATE creature_addon SET path_id=0 WHERE guid=77084;
UPDATE creature SET MovementType=0 WHERE guid=77084;
DELETE FROM waypoints WHERE entry=2200600;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(2200600, 1, -3225.12, 246.817, 195.679, "Shadowlord Deathwail"),
(2200600, 2, -3240.03, 255.9, 201.579, "Shadowlord Deathwail"),
(2200600, 3, -3257.98, 269.678, 201.579, "Shadowlord Deathwail"),
(2200600, 4, -3274.72, 279.532, 201.579, "Shadowlord Deathwail"),
(2200600, 5, -3285.86, 310.516, 201.579, "Shadowlord Deathwail"),
(2200600, 6, -3275.1, 325.252, 201.579, "Shadowlord Deathwail"),
(2200600, 7, -3254.87, 341.812, 201.579, "Shadowlord Deathwail"),
(2200600, 8, -3227.61, 331.076, 201.579, "Shadowlord Deathwail"),
(2200600, 9, -3218.13, 316.963, 201.579, "Shadowlord Deathwail"),
(2200600, 10, -3217.59, 298.951, 201.579, "Shadowlord Deathwail"),
(2200600, 11, -3217.09, 283.996, 201.579, "Shadowlord Deathwail"),
(2200600, 12, -3207.64, 260.908, 203.19, "Shadowlord Deathwail"),
(2200600, 13, -3212.76, 247.542, 203.19, "Shadowlord Deathwail"),
(2200600, 14, -3220.4, 239.538, 203.19, "Shadowlord Deathwail"),
(2200600, 15, -3252.73, 239.407, 172.163, "Shadowlord Deathwail"),
(2200600, 16, -3266.67, 280.529, 161.968, "Shadowlord Deathwail"),
(2200600, 17, -3237.02, 300.281, 161.968, "Shadowlord Deathwail"),
(2200600, 18, -3205.82, 285.144, 183.413, "Shadowlord Deathwail"),
(2200600, 19, -3205.76, 262.642, 184.707, "Shadowlord Deathwail"),
(2200600, 20, -3213.83, 246.444, 194.429, "Shadowlord Deathwail"),
(2200600, 21, -3225.12, 246.817, 195.679, "Shadowlord Deathwail"),
(2200600, 22, -3240.03, 255.9, 201.579, "Shadowlord Deathwail"),
(2200600, 23, -3257.98, 269.678, 201.579, "Shadowlord Deathwail");
Killyana
on 31 Jan 2020
You missed line 5 on the shadow moon soulstealers they need to channel both in and out of combat
dr-j
on 1 Feb 2020
It's already in the script:
```
"Shadowmoon Soulstealer - On reset - Cast spell Heart of Fury Siphon"
"Shadowmoon Soulstealer - On Aggro - Cast 'Heart of Fury Siphon'"
Killyana
on 1 Feb 2020
Related issues
Amit86
路
58Comments
MrSmite
路
60Comments
Vincent-Michael
路
98Comments
Re3os
路
47Comments
jackpoz
路
56Comments
Most helpful comment
This will fix mount, inhabit type and combat scripts (I also added combat scripts for every nearby mob). As for waypoints, I can't sniff from retail, so I can't help with that. Sorry... :(
``
sql -- Shadowlord Deathwail UPDATEcreature_addonSETmount=20684 WHEREguid`=77084; -- Fix mountDELETE FROM
creature_template_movementWHERECreatureId=22006; -- Fix inhabit typeINSERT INTO
creature_template_movement(CreatureId,Ground,Swim,Flight,Rooted) VALUES(22006,1,1,2,0);
UPDATE
creature_templateSETAIName="SmartAI" WHEREentry=22006;DELETE FROM
smart_scriptsWHEREentryorguid=22006 ANDsource_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(22006,0,0,0,6,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - On Just Died - Say Line 0"),
(22006,0,1,0,0,0,100,0,0,0,3000,5000,11,12471,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowlord Deathwail - In Combat - Cast 'Shadow Bolt'"),
(22006,0,2,0,0,0,100,0,5000,7000,15000,17000,11,15245,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowlord Deathwail - In Combat - Cast 'Shadow Bolt Volley'"),
(22006,0,3,0,0,0,100,0,9000,12000,18000,24000,11,32709,0,0,0,0,0,5,0,0,0,0,0,0,0,"Shadowlord Deathwail - In Combat - Cast 'Death Coil'"),
(22006,0,4,0,0,0,100,0,14000,17000,22000,28000,11,27641,0,0,0,0,0,5,0,0,0,0,0,0,0,"Shadowlord Deathwail - In Combat - Cast 'Fear'");
DELETE FROM
creature_textWHERECreatureID=22006;INSERT INTO
creature_text(CreatureID,GroupID,ID,Text,Type,Language,Probability,Emote,Duration,Sound,BroadcastTextId,TextRange,comment) VALUES(22006,0,0,"Master... I've failed you...",14,0,100,0,0,0,19820,0,"Shadowlord Deathwail");
-- Shadowmoon Soulstealer
DELETE FROM
smart_scriptsWHEREentryorguid=22061 ANDsource_type=0 ANDidIN (1,2);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(22061,0,1,0,25,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Soulstealer - On Reset - Set Reactstate Passive"),
(22061,0,2,0,4,0,100,0,0,0,0,0,11,38250,0,0,0,0,0,19,22058,0,0,0,0,0,0,"Shadowmoon Soulstealer - On Aggro - Cast 'Heart of Fury Siphon'");
-- Shadowmoon Darkweaver
UPDATE
creature_templateSETAIName="SmartAI" WHEREentry=22081;DELETE FROM
smart_scriptsWHEREentryorguid=22081 ANDsource_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(22081,0,0,0,0,0,100,0,0,0,3000,5000,11,9613,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmoon Darkweaver - In Combat - Cast 'Shadow Bolt'"),
(22081,0,1,0,9,0,100,0,0,30,15000,18000,11,11962,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmoon Darkweaver - Within 0-30 Range - Cast 'Immolate'"),
(22081,0,2,0,9,0,100,0,0,10,8000,11000,11,35373,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Darkweaver - Within 0-10 Range - Cast 'Shadowfury'");
-- Shadowmoon Chosen
UPDATE
creature_templateSETAIName="SmartAI" WHEREentry=22084;DELETE FROM
smart_scriptsWHEREentryorguid=22084 ANDsource_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(22084,0,0,0,9,0,100,0,0,5,15000,17000,11,38618,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Chosen - Within 0-5 Range - Cast 'Whirlwind'"),
(22084,0,1,0,0,0,100,0,8000,10000,18000,22000,11,10966,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmoon Chosen - In Combat - Cast 'Uppercut'");
-- Shadowmoon Slayer
UPDATE
creature_templateSETAIName="SmartAI" WHEREentry=22082;DELETE FROM
smart_scriptsWHEREentryorguid=22082 ANDsource_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(22082,0,0,1,2,0,100,1,0,30,0,0,11,3019,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Slayer - Between 0-30% Health - Cast 'Frenzy'"),
(22082,0,1,0,61,0,100,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shadowmoon Slayer - Between 0-30% Health - Say Line 0"),
(22082,0,2,0,0,0,100,0,5000,7000,12000,15000,11,37577,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmoon Slayer - In Combat - Cast 'Debilitating Strike'");
DELETE FROM
creature_textWHERECreatureID=22082;INSERT INTO
creature_text(CreatureID,GroupID,ID,Text,Type,Language,Probability,Emote,Duration,Sound,BroadcastTextId,TextRange,comment) VALUES(22082,0,0,"%s goes into a frenzy!",16,0,100,0,0,0,2384,0,"Shadowmoon Slayer");
-- Shadowsworn Drakonid
UPDATE
creature_templateSETAIName="SmartAI" WHEREentry=22072;DELETE FROM
smart_scriptsWHEREentryorguid=22072 ANDsource_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(22072,0,0,0,0,0,100,0,5000,7000,11000,13000,11,15496,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Drakonid - In Combat - Cast 'Cleave'"),
(22072,0,1,0,0,0,100,0,6000,8000,14000,16000,11,17547,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Drakonid - In Combat - Cast 'Mortal Strike'"),
(22072,0,2,0,0,0,100,0,9000,11000,18000,22000,11,16145,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowsworn Drakonid - In Combat - Cast 'Sunder Armor'");
-- Shadowmoon Retainer
UPDATE
creature_templateSETAIName="SmartAI" WHEREentry=22102;DELETE FROM
smart_scriptsWHEREentryorguid=22102 ANDsource_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(22102,0,0,0,0,0,100,0,0,0,2000,4000,11,15547,64,0,0,0,0,2,0,0,0,0,0,0,0,"Shadowmoon Retainer - In Combat - Cast 'Shoot'");