Quest: Ending Their World (9759) #21586

dewmguy · 2018-03-11T07:56:18Z

Description:
http://www.wowhead.com/quest=9759/ending-their-world

Current behaviour:

~~Quest is missing some details and scripted elements, and is not completed after killing Sironas.~~
Demolitionist Legoso walks at an annoyingly slow pace.
Demolitionist Legoso doesn't always agro nearby creatures.
The written portion of the script doesn't properly convert $n into your name.
After the first cluster of bombs goes off, there are no fire effects on the lower half of the Vector Coil.
~~There are no electric-style effects coming from the tips of the giant crystals, down into Sironas' hands.~~
~~Sironas isn't in a pose, holding her hands up in the air collecting the energy. She's just standing around.~~
~~When you defeat Sironas the quest is not completed.~~

Expected behaviour:
https://www.youtube.com/watch?v=4IhYoGu3LZU
super shitty quality but old and looks reliable.

Branch(es): 3.3.5

TC rev. hash/commit: 078b621

TDB version: 335.64

Operating system: Windows 10

The text was updated successfully, but these errors were encountered:

Killyana · 2018-03-11T12:10:44Z

Please update your core and test again, the issue related to spells cannot be casted could be the reason off all that.

dewmguy · 2018-03-13T08:35:22Z

You're half-right. A lot of stuff worked correctly.

Still broken stuff:

Demolitionist Legoso walks at an annoyingly slow pace and he doesn't always agro nearby creatures. (Specifically, he ignores non blood-elf creatures, as well as an NPC named Fenissa the Assassin.) https://streamable.com/7dbf4
The written portion of the script doesn't properly convert $n into the player name.
After the first cluster of bombs goes off, there are no fire effects on the lower half of the Vector Coil.

offl · 2020-06-20T22:53:28Z

The only fix I have, heh. WIP.

He now uses hacky waypoint pause for 5min because of Core/SAI: SMART_ACTION_WP_PAUSE with value 0 should pause waypoint permanently #24759. So yeah, waypoint pauses ticks in combat. And if he will be in combat for too long, some weird things will happen. But the real problem is with the last pause. He is supposed to call action list after reaching home and if Sironas was killed. But without waypoint pause with timers it will not work and I don't know if Core/SAI: SMART_ACTION_WP_PAUSE with value 0 should pause waypoint permanently #24759 will fix it.
Right now he uses event type 2 to cast the spell only on self. Is he really supposed to cast the heal on his escort?
He will not cast his healing spell anymore on himself and player regardless of event type (14 or 74).
Core/SAI: SMART_EVENT_FRIENDLY_HEALTH_PCT is broken #20536 can help him to cast the spell on himself but probably not on player. Maybe Core/SAI: SMART_EVENT_FRIENDLY_HEALTH_PCT is broken #20536 can be updated to include players in search with additional param (1 - only friends, 2 - friends and self, 3 self and players for escort quests. Or something like that). And 3 (self and players) must work with new target type because assumedly he must cast the healing spell only on himself or invoker party.
The gameobjects are now spawned always and because of this the second time they will appear respawned. I assume I can make a spawn group and despawn it on escort start.
He already respawns Sironas on escort start.

I guess these are the only things that are broken now.
All other things are fixed or updated. Lots of minor changes added.

--
SET @OGUID := 92308; -- Need 50

-- Source: Current CPP, CMaNGOS, https://www.youtube.com/watch?v=EJWnyEpUTms
-- Sironas SAI 
SET @ID := 17678;
UPDATE `creature` SET `modelid` = 29354 WHERE `id` = @ID;
UPDATE `creature_template` SET `AIName` = "SmartAI", `ScriptName` = "" WHERE `entry` = @ID;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID 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
(@ID,0,0,0,0,0,100,0,5000,5000,20000,25000,11,8282,0,0,0,0,0,2,0,0,0,0,0,0,0,"Sironas - In Combat - Cast 'Curse of Blood'"),
(@ID,0,1,0,0,0,100,0,15000,15000,10000,12000,11,10966,0,0,0,0,0,2,0,0,0,0,0,0,0,"Sironas - In Combat - Cast 'Uppercut'"),
(@ID,0,2,0,0,0,100,0,10000,10000,15000,20000,11,12742,0,0,0,0,0,2,0,0,0,0,0,0,0,"Sironas - In Combat - Cast 'Immolate'"),
-- Start attack player, not Legoso
(@ID,0,3,0,38,0,100,0,0,1,0,0,49,0,0,0,0,0,0,12,1,0,0,0,0,0,0,"Sironas - On Data Set 0 1 - Start Attacking Stored Target 1"),
(@ID,0,4,0,6,0,100,0,0,0,0,0,45,0,1,0,0,0,0,19,17982,0,0,0,0,0,0,"Sironas - On Death - Set Data 0 1 (Demolitionist Legoso)");

-- Demolitionist Legoso SAI
SET @ID := 17982;
UPDATE `creature_template` SET `AIName` = "SmartAI", `ScriptName` = "" WHERE `entry` = @ID;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID 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
-- Do not reset combat things for escort creatures
(@ID,0,0,0,0,0,100,256,1000,1000,10000,15000,11,8056,0,0,0,0,0,2,0,0,0,0,0,0,0,"Demolitionist Legoso - In Combat - Cast 'Frost Shock' (No Reset)"),
(@ID,0,1,0,0,0,100,256,20000,20000,110000,130000,11,31633,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - In Combat - Cast 'Strength of Earth Totem' (No Reset)"),
(@ID,0,2,0,0,0,100,256,15000,15000,110000,130000,11,38116,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - In Combat - Cast 'Searing Totem' (No Reset)"),
(@ID,0,3,0,2,0,100,256,0,85,5000,5000,11,8004,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - Between 0-85% Health - Cast 'Lesser Healing Wave' (No Reset)"),
(@ID,0,4,0,19,0,100,0,9759,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Quest 'Ending Their World' Taken - Run Script"),
(@ID,0,5,0,40,0,100,0,1,0,0,0,80,@ID*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Waypoint 1 Reached - Run Script"),
(@ID,0,6,0,40,0,100,0,21,0,0,0,80,@ID*100+2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Waypoint 21 Reached - Run Script"),
(@ID,0,7,0,40,0,100,0,22,0,0,0,80,@ID*100+3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Waypoint 22 Reached - Run Script"),
(@ID,0,8,0,40,0,100,0,24,0,0,0,80,@ID*100+4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Waypoint 24 Reached - Run Script"),
(@ID,0,9,0,40,0,100,0,33,0,0,0,80,@ID*100+5,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Waypoint 33 Reached - Run Script"),
(@ID,0,10,0,40,0,100,0,35,0,0,0,80,@ID*100+6,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Waypoint 35 Reached - Run Script"),
(@ID,0,11,0,40,0,100,0,39,0,0,0,80,@ID*100+7,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Waypoint 39 Reached - Run Script"),
(@ID,0,12,0,40,0,100,0,40,0,0,0,80,@ID*100+8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Waypoint 40 Reached - Run Script"),
(@ID,0,13,0,40,0,100,0,41,0,0,0,80,@ID*100+9,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Waypoint 41 Reached - Run Script"),
(@ID,0,14,0,38,0,100,0,0,1,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Data Set 0 1 - Resume Waypoint"),
(@ID,0,15,0,6,0,100,0,0,0,0,0,6,9759,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Death - Fail Quest 'Ending Their World'");

-- Actionlist SAI
DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN @ID*100+0 AND @ID*100+9 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
(@ID*100+0,9,0,0,0,0,100,0,0,0,0,0,64,1,0,0,0,0,0,16,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Store Targetlist"),
(@ID*100+0,9,1,0,0,0,100,0,0,0,0,0,83,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Remove NPC Flags Gossip & Questgiver"),
-- Pretty sure it's not correct faction
(@ID*100+0,9,2,0,0,0,100,0,0,0,0,0,2,250,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Faction 250"),
(@ID*100+0,9,3,0,0,0,100,0,0,0,0,0,133,0,63402,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Respawn Creature 'Sironas'"),
(@ID*100+0,9,4,0,0,0,100,0,0,0,0,0,53,1,17982,0,0,0,2,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Start Waypoint"),

(@ID*100+1,9,0,0,0,0,100,0,0,0,0,0,54,2500,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Pause Waypoint"),
(@ID*100+1,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Orientation Stored Target 1"),
(@ID*100+1,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 0"),

(@ID*100+2,9,0,0,0,0,100,0,0,0,0,0,54,8000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Pause Waypoint"),
(@ID*100+2,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,1.46,"Demolitionist Legoso - On Script - Set Orientation"),
(@ID*100+2,9,2,0,0,0,100,0,2000,2000,0,0,1,1,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 1"),
(@ID*100+2,9,3,0,0,0,100,0,6000,6000,0,0,1,2,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 2"),

(@ID*100+3,9,0,0,0,0,100,0,0,0,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Pause Waypoint"),
(@ID*100+3,9,1,0,0,0,100,0,0,0,0,0,8,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Reactstate Defensive"),
(@ID*100+3,9,2,0,0,0,100,0,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Flag Standstate Kneel"),
(@ID*100+3,9,3,0,0,0,100,0,11000,11000,0,0,1,3,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 3"),
(@ID*100+3,9,4,0,0,0,100,0,1000,1000,0,0,17,69,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Emote State 69"),
(@ID*100+3,9,5,0,0,0,100,0,16000,16000,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Remove Flag Standstate Kneel"),
(@ID*100+3,9,6,0,0,0,100,0,0,0,0,0,17,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Emote State 0"),
(@ID*100+3,9,7,0,0,0,100,0,1000,1000,0,0,1,4,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 4"),
(@ID*100+3,9,8,0,0,0,100,0,0,0,0,0,8,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Reactstate Aggressive"),
(@ID*100+3,9,9,0,0,0,100,0,0,0,0,0,70,300,0,0,0,0,0,15,182088,30,0,0,0,0,0,"Demolitionist Legoso - On Script - Respawn Gameobject 'Draenei Explosives'"),
(@ID*100+3,9,10,0,0,0,100,0,0,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Resume Waypoint"),

(@ID*100+4,9,0,0,0,0,100,0,0,0,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Pause Waypoint"),
(@ID*100+4,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,1.05,"Demolitionist Legoso - On Script - Set Orientation"),
(@ID*100+4,9,2,0,0,0,100,0,1000,1000,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 5"),
(@ID*100+4,9,3,0,0,0,100,0,1000,1000,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 6"),
(@ID*100+4,9,4,0,0,0,100,0,1000,1000,0,0,1,7,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 7"),
(@ID*100+4,9,5,0,0,0,100,0,1000,1000,0,0,9,0,0,0,0,0,0,15,182088,70,0,0,0,0,0,"Demolitionist Legoso - On Script - Activate Gameobject 'Draenei Explosives'"),
(@ID*100+4,9,6,0,0,0,100,0,1000,1000,0,0,5,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Play Emote 4"),
(@ID*100+4,9,7,0,0,0,100,0,2000,2000,0,0,1,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 8"),
(@ID*100+4,9,8,0,0,0,100,0,2000,2000,0,0,70,600,0,0,0,0,0,15,182089,70,0,0,0,0,0,"Demolitionist Legoso - On Script - Respawn Gameobject 'Vector Coil Fire (S)'"),
(@ID*100+4,9,9,0,0,0,100,0,0,0,0,0,70,600,0,0,0,0,0,15,182090,70,0,0,0,0,0,"Demolitionist Legoso - On Script - Respawn Gameobject 'Vector Coil Fire (L)'"),
(@ID*100+4,9,10,0,0,0,100,0,2000,2000,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.272,"Demolitionist Legoso - On Script - Set Orientation"),
(@ID*100+4,9,11,0,0,0,100,0,1000,1000,0,0,5,25,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Play Emote 25"),
(@ID*100+4,9,12,0,0,0,100,0,2000,2000,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Resume Waypoint"),

(@ID*100+5,9,0,0,0,0,100,0,0,0,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Pause Waypoint"),
(@ID*100+5,9,1,0,0,0,100,0,0,0,0,0,86,31612,0,19,17678,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Cross Cast 'Sironas Channeling' (Sironas)"),
(@ID*100+5,9,2,0,0,0,100,0,0,0,0,0,86,31611,0,11,17979,150,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Cross Cast 'Bloodmyst Tesla' (Bloodmyst Tesla Coil)"),
(@ID*100+5,9,3,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,19,17678,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Orientation Closest Creature 'Sironas'"),
(@ID*100+5,9,4,0,0,0,100,0,1000,1000,0,0,1,9,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 9"),
(@ID*100+5,9,5,0,0,0,100,0,4000,4000,0,0,1,10,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 10"),
(@ID*100+5,9,6,0,0,0,100,0,4000,4000,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Resume Waypoint"),

(@ID*100+6,9,0,0,0,0,100,0,0,0,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Pause Waypoint"),
(@ID*100+6,9,1,0,0,0,100,0,0,0,0,0,1,11,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 11"),
(@ID*100+6,9,2,0,0,0,100,0,4000,4000,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Orientation Stored Target 1"),
(@ID*100+6,9,3,0,0,0,100,0,0,0,0,0,1,12,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 12"),
(@ID*100+6,9,4,0,0,0,100,0,7000,7000,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Resume Waypoint"),

(@ID*100+7,9,0,0,0,0,100,0,0,0,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Pause Waypoint"),
(@ID*100+7,9,1,0,0,0,100,0,0,0,0,0,8,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Reactstate Defensive"),
(@ID*100+7,9,2,0,0,0,100,0,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Flag Standstate Kneel"),
(@ID*100+7,9,3,0,0,0,100,0,11000,11000,0,0,1,13,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 13"),
(@ID*100+7,9,4,0,0,0,100,0,17000,17000,0,0,1,14,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 14"),
(@ID*100+7,9,5,0,0,0,100,0,4000,4000,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Remove Flag Standstate Kneel"),
(@ID*100+7,9,6,0,0,0,100,0,0,0,0,0,70,300,0,0,0,0,0,15,182091,30,0,0,0,0,0,"Demolitionist Legoso - On Script - Respawn Gameobject 'Draenei Explosives'"),
(@ID*100+7,9,7,0,0,0,100,0,0,0,0,0,8,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Reactstate Aggressive"),
(@ID*100+7,9,8,0,0,0,100,0,0,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Resume Waypoint"),

(@ID*100+8,9,0,0,0,0,100,0,0,0,0,0,54,300000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Pause Waypoint"),
(@ID*100+8,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,5.7,"Demolitionist Legoso - On Script - Set Orientation"),
(@ID*100+8,9,2,0,0,0,100,0,1000,1000,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 5"),
(@ID*100+8,9,3,0,0,0,100,0,1000,1000,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 6"),
(@ID*100+8,9,4,0,0,0,100,0,1000,1000,0,0,1,7,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 7"),
(@ID*100+8,9,5,0,0,0,100,0,1000,1000,0,0,9,9,0,0,0,0,0,15,182091,70,0,0,0,0,0,"Demolitionist Legoso - On Script - Activate Gameobject 'Draenei Explosives'"),
(@ID*100+8,9,6,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,19,17678,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Orientation Closest Creature 'Sironas'"),
(@ID*100+8,9,7,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,19,17678,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 0 (Sironas)"),
(@ID*100+8,9,8,0,0,0,100,0,0,0,0,0,92,0,0,0,0,0,0,19,17678,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Interrupt Spell (Sironas)"),
(@ID*100+8,9,9,0,0,0,100,0,0,0,0,0,92,0,0,0,0,0,0,11,17979,150,0,0,0,0,0,"Demolitionist Legoso - On Script - Interrupt Spell (Bloodmyst Tesla Coil)"),
(@ID*100+8,9,10,0,0,0,100,0,0,0,0,0,100,1,0,0,0,0,0,19,17678,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Send Target 1 (Sironas)"),
(@ID*100+8,9,11,0,0,0,100,0,1000,1000,0,0,1,15,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 15"),
-- Sniffed
(@ID*100+8,9,12,0,0,0,100,0,1000,1000,0,0,86,29050,0,19,17678,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Cross Cast 'Grow' (Sironas)"),
(@ID*100+8,9,13,0,0,0,100,0,0,0,0,0,86,29050,0,19,17678,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Cross Cast 'Grow' (Sironas)"),
(@ID*100+8,9,14,0,0,0,100,0,0,0,0,0,70,600,0,0,0,0,0,15,182089,70,0,0,0,0,0,"Demolitionist Legoso - On Script - Respawn Gameobject 'Vector Coil Fire (S)'"),
(@ID*100+8,9,15,0,0,0,100,0,0,0,0,0,70,600,0,0,0,0,0,15,182090,70,0,0,0,0,0,"Demolitionist Legoso - On Script - Respawn Gameobject 'Vector Coil Fire (L)'"),
(@ID*100+8,9,16,0,0,0,100,0,2000,2000,0,0,19,768,0,0,0,0,0,19,17678,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Remove Flags Immune To Players & Immune To NPC's"),
(@ID*100+8,9,17,0,0,0,100,0,0,0,0,0,45,0,1,0,0,0,0,19,17678,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Data 0 1 (Sironas)"),
(@ID*100+8,9,18,0,0,0,100,0,1000,1000,0,0,17,333,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Emote State 333"),

(@ID*100+9,9,0,0,0,0,100,0,0,0,0,0,17,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Set Emote State 0"),
(@ID*100+9,9,1,0,0,0,100,0,3000,3000,0,0,1,16,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 16"),
(@ID*100+9,9,2,0,0,0,100,0,5000,5000,0,0,5,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Play Emote 4"),
(@ID*100+9,9,3,0,0,0,100,0,0,0,0,0,15,9759,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Quest Credit 'Ending Their World'"),
(@ID*100+9,9,4,0,0,0,100,0,4000,4000,0,0,1,17,0,0,0,0,0,12,1,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Say Line 17"),
(@ID*100+9,9,5,0,0,0,100,0,5000,5000,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Demolitionist Legoso - On Script - Despawn (0)");

UPDATE `creature_text` SET `comment` = "Demolitionist Legoso" WHERE `CreatureID` = @ID;
DELETE FROM `creature_text` WHERE `CreatureID` = @ID AND `GroupID` BETWEEN 15 AND 20;
INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`Comment`) VALUES
(@ID,15,0,"Holy mother of O'ros!",12,7,100,5,0,0,14663,0,"Demolitionist Legoso"),
(@ID,16,0,"I... I can't believe it's over. You did it! You've destroyed the blood elves and their leader!",12,7,100,1,0,0,14664,0,"Demolitionist Legoso"),
(@ID,17,0,"Get back to Blood Watch. I'll see you there...",12,7,100,1,0,0,14665,0,"Demolitionist Legoso");

-- Handled in script
UPDATE `creature_text` SET `Emote` = 0 WHERE `CreatureID` = @ID AND `GroupID` = 3;

DELETE FROM `script_waypoint` WHERE `entry` = 17982;
DELETE FROM `waypoints` WHERE `entry` = 17982;
INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
(17982,1,-1773.64,-11073.9,76.8923,"Demolitionist Legoso"),
(17982,2,-1784.13,-11051.1,77.2078,"Demolitionist Legoso"),
(17982,3,-1793.02,-11047.5,77.1118,"Demolitionist Legoso"),
(17982,4,-1792.87,-11036.8,76.2142,"Demolitionist Legoso"),
(17982,5,-1804.07,-11023.6,69.8951,"Demolitionist Legoso"),
(17982,6,-1826.2,-11003.5,67.3465,"Demolitionist Legoso"),
(17982,7,-1855,-10992.3,64.5101,"Demolitionist Legoso"),
(17982,8,-1888.95,-10966.4,61.1596,"Demolitionist Legoso"),
(17982,9,-1913.87,-10935.6,61.4501,"Demolitionist Legoso"),
(17982,10,-1927.65,-10907.8,62.7226,"Demolitionist Legoso"),
(17982,11,-1932.9,-10868.6,66.2437,"Demolitionist Legoso"),
(17982,12,-1940.75,-10853.8,69.1475,"Demolitionist Legoso"),
(17982,13,-1934.66,-10821.3,80.0018,"Demolitionist Legoso"),
(17982,14,-1940.5,-10807.7,84.7886,"Demolitionist Legoso"),
(17982,15,-1966.12,-10791.9,88.6942,"Demolitionist Legoso"),
(17982,16,-1977.82,-10778.2,89.1746,"Demolitionist Legoso"),
(17982,17,-1980.04,-10757.3,91.1206,"Demolitionist Legoso"),
(17982,18,-1959.13,-10739.6,98.335,"Demolitionist Legoso"),
(17982,19,-1947.52,-10721.8,108.46,"Demolitionist Legoso"),
(17982,20,-1947.04,-10711.1,111.313,"Demolitionist Legoso"),
(17982,21,-1953.05,-10682.2,110.582,"Demolitionist Legoso"),
(17982,22,-1955.97,-10659.1,111.04,"Demolitionist Legoso"),
(17982,23,-1967.13,-10677.3,111.37,"Demolitionist Legoso"),
(17982,24,-1987.29,-10701.7,116.038,"Demolitionist Legoso"),
(17982,25,-2008.1,-10664.8,120.99,"Demolitionist Legoso"),
(17982,26,-2021.77,-10648.8,129.903,"Demolitionist Legoso"),
(17982,27,-2022.39,-10647.7,130.624,"Demolitionist Legoso"),
(17982,28,-2039.34,-10632.7,143,"Demolitionist Legoso"),
(17982,29,-2041.41,-10624.6,145.187,"Demolitionist Legoso"),
(17982,30,-2036.49,-10617.1,146.52,"Demolitionist Legoso"),
(17982,31,-2026.12,-10606.9,150.263,"Demolitionist Legoso"), 
(17982,32,-1993,-10613.7,161.852,"Demolitionist Legoso"),
(17982,33,-1970.41,-10616.8,163.838,"Demolitionist Legoso"),
(17982,34,-1953.78,-10590.9,170.538,"Demolitionist Legoso"),
(17982,35,-1942.51,-10577.7,175.276,"Demolitionist Legoso"),
(17982,36,-1937.517090,-10575.675781,176.253082,"Demolitionist Legoso"),
(17982,37,-1926.401733,-10577.000977,177.240952,"Demolitionist Legoso"),
(17982,38,-1920.892212,-10575.630859,177.493637,"Demolitionist Legoso"),
(17982,39,-1915.430664,-10581.253906,178.08140,"Demolitionist Legoso"),
(17982,40,-1951.17,-10555,177.33,"Demolitionist Legoso"),
(17982,41,-1951.17,-10555,177.33,"Demolitionist Legoso"); -- -1946.9,-10557.8,177.7

DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+00 AND @OGUID+49;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(@OGUID+00,182088,530,1,1,-1954.112,-10653.75,110.2100,1.658062,0,0,0.737277,0.6755905,-300,100,1),
(@OGUID+01,182088,530,1,1,-1955.339,-10654.12,110.5499,5.061456,0,0,-0.573576,0.8191524,-300,100,1),
(@OGUID+02,182088,530,1,1,-1956.608,-10654.40,110.9519,2.879789,0,0,0.9914446,0.1305283,-300,100,1),
(@OGUID+03,182088,530,1,1,-1956.081,-10655.89,110.8260,1.640607,0,0,0.7313528,0.6819993,-300,100,1),
(@OGUID+04,182088,530,1,1,-1954.590,-10655.84,110.4045,2.740162,0,0,0.9799242,0.1993704,-300,100,1),

(@OGUID+05,182089,530,1,1,-1950.958,-10653.90,131.4468,3.961899,0,0,-0.9170599,0.3987495,-600,100,1),
(@OGUID+06,182089,530,1,1,-1951.899,-10652.74,111.1061,2.181660,0,0,0.8870106,0.4617491,-600,100,1),
(@OGUID+07,182089,530,1,1,-1951.811,-10655.09,118.3840,0.2443456,0,0,0.1218691,0.9925462,-600,100,1),
(@OGUID+08,182089,530,1,1,-1952.615,-10657.60,124.4878,1.780234,0,0,0.7771454,0.6293211,-600,100,1),
(@OGUID+09,182089,530,1,1,-1943.769,-10651.64,126.5673,1.483528,0,0,0.6755896,0.7372779,-600,100,1),
(@OGUID+10,182089,530,1,1,-1943.539,-10656.17,116.0825,0.1919852,0,0,0.09584522,0.9953963,-600,100,1),
(@OGUID+11,182089,530,1,1,-1949.927,-10650.49,138.9217,1.274088,0,0,0.5948219,0.8038574,-600,100,1),
(@OGUID+12,182089,530,1,1,-1943.670,-10652.68,144.1570,4.886924,0,0,-0.642787,0.766045,-600,100,1),
(@OGUID+13,182089,530,1,1,-1940.965,-10661.87,140.1596,4.136433,0,0,-0.8788166,0.4771597,-600,100,1),
(@OGUID+14,182089,530,1,1,-1934.876,-10666.56,137.6288,4.974190,0,0,-0.6087608,0.7933538,-600,100,1),
(@OGUID+15,182089,530,1,1,-1911.578,-10584.62,180.2037,4.555311,0,0,-0.7604055,0.6494485,-600,100,1),
(@OGUID+16,182089,530,1,1,-1908.222,-10581.13,181.2174,0.907570,0,0,0.4383707,0.8987942,-600,100,1),
(@OGUID+17,182089,530,1,1,-1913.968,-10593.82,184.8842,3.909541,0,0,-0.9271832,0.3746083,-600,100,1),
(@OGUID+18,182089,530,1,1,-1899.361,-10583.72,190.8016,0.261798,0,0,0.1305256,0.9914449,-600,100,1),
(@OGUID+19,182089,530,1,1,-1914.107,-10593.02,179.2118,0.593410,0,0,0.2923708,0.956305,-600,100,1),
(@OGUID+20,182089,530,1,1,-1912.097,-10599.92,211.5631,3.281239,0,0,-0.9975634,0.06976615,-600,100,1),
(@OGUID+21,182089,530,1,1,-1914.138,-10591.11,192.8860,4.363324,0,0,-0.8191519,0.5735767,-600,100,1),
(@OGUID+22,182089,530,1,1,-1889.362,-10571.98,179.5392,5.393069,0,0,-0.4305105,0.9025856,-600,100,1),
(@OGUID+23,182089,530,1,1,-1887.081,-10536.76,178.8841,3.420850,0,0,-0.9902678,0.1391754,-600,100,1),
(@OGUID+24,182089,530,1,1,-1901.158,-10596.18,206.6687,5.340709,0,0,-0.4539900,0.8910068,-600,100,1),

(@OGUID+25,182090,530,1,1,-1916.393,-10679.92,144.6123,1.727875,0,0,0.7604055,0.6494485,-600,100,1),
(@OGUID+26,182090,530,1,1,-1908.393,-10677.59,144.2352,5.707228,0,0,-0.2840147,0.9588199,-600,100,1),
(@OGUID+27,182090,530,1,1,-1934.610,-10670.40,143.0830,4.555311,0,0,-0.7604055,0.6494485,-600,100,1),
(@OGUID+28,182090,530,1,1,-1927.865,-10671.92,134.7358,2.548179,0,0,0.9563046,0.2923723,-600,100,1),
(@OGUID+29,182090,530,1,1,-1934.524,-10668.89,130.3370,1.692969,0,0,0.7489557,0.6626201,-600,100,1),
(@OGUID+30,182090,530,1,1,-1958.800,-10653.84,111.7486,5.864307,0,0,-0.2079115,0.9781476,-600,100,1),
(@OGUID+31,182090,530,1,1,-1960.864,-10657.38,122.3760,2.146753,0,0,0.8788166,0.4771597,-600,100,1),
(@OGUID+32,182090,530,1,1,-1939.568,-10663.65,153.4156,1.710422,0,0,0.7547092,0.6560594,-600,100,1),
(@OGUID+33,182090,530,1,1,-1958.072,-10659.34,146.4452,1.815142,0,0,0.7880106,0.6156617,-600,100,1),
(@OGUID+34,182090,530,1,1,-1948.237,-10655.24,110.4299,4.555311,0,0,-0.7604055,0.6494485,-600,100,1),
(@OGUID+35,182090,530,1,1,-1911.359,-10580.58,178.9996,4.206246,0,0,-0.8616285,0.5075394,-600,100,1),
(@OGUID+36,182090,530,1,1,-1904.622,-10587.45,192.4867,3.124123,0,0,0.9999619,0.008734641,-600,100,1),
(@OGUID+37,182090,530,1,1,-1923.830,-10598.51,188.1161,3.612838,0,0,-0.9723692,0.2334484,-600,100,1),
(@OGUID+38,182090,530,1,1,-1905.410,-10604.16,223.4696,3.996807,0,0,-0.9099607,0.4146944,-600,100,1),
(@OGUID+39,182090,530,1,1,-1903.758,-10593.91,200.8576,1.640607,0,0,0.7313528,0.6819993,-600,100,1),
(@OGUID+40,182090,530,1,1,-1874.945,-10597.42,220.3495,5.235988,0,0,-0.5,0.8660254,-600,100,1),
(@OGUID+41,182090,530,1,1,-1869.706,-10580.35,185.9308,1.186823,0,0,0.5591927,0.8290377,-600,100,1),
(@OGUID+42,182090,530,1,1,-1884.538,-10534.48,192.8828,3.385940,0,0,-0.9925461,0.12187,-600,100,1),
(@OGUID+43,182090,530,1,1,-1919.978,-10615.05,225.3603,4.782203,0,0,-0.6819983,0.7313538,-600,100,1),
(@OGUID+44,182090,530,1,1,-1932.259,-10613.42,192.5991,3.560473,0,0,-0.9781475,0.2079121,-600,100,1),

(@OGUID+45,182091,530,1,1,-1913.208,-10583.15,178.6601,3.961899,0,0,-0.9170599,0.3987495,-300,100,1),
(@OGUID+46,182091,530,1,1,-1914.451,-10584.71,178.7834,6.195920,0,0,-0.04361916,0.9990482,-300,100,1),
(@OGUID+47,182091,530,1,1,-1914.493,-10583.18,178.3964,5.044002,0,0,-0.5807028,0.8141156,-300,100,1),
(@OGUID+48,182091,530,1,1,-1913.126,-10584.52,179.1008,2.548179,0,0,0.9563046,0.2923723,-300,100,1),
(@OGUID+49,182091,530,1,1,-1912.281,-10582.00,178.7522,5.305802,0,0,-0.469471,0.8829479,-300,100,1);

Rothend · 2020-06-21T05:28:45Z

About number 2, it's not uncommon for some escort NPCs to heal the player that's escorting them, if ther lore class allows it (shaman/druid/paladin/priest). One example is Kayra Longmane.

From this comment, this one should at least heal himself.

…9554) Updates #21586

Killyana added Sub-Quests Comp-C++Script Branch-3.3.5a Feedback-WaitingResponse labels Mar 11, 2018

Aokromes removed the Feedback-WaitingResponse label Apr 4, 2018

Killyana added the Feedback-FixOutdatedMissingWIP label Jun 20, 2020

Rothend mentioned this issue Jun 23, 2020

Core/SAI: do not allow the waypoint pause timer to update while in combat #24877

Merged

2 tasks

Faq mentioned this issue Aug 23, 2020

Core/SAI: Implement SMART_TARGET_ACTION_INVOKER in SMART_EVENT_FRIENDLY_HEALTH_PCT #25318

Merged

3 tasks

ghost mentioned this issue Jan 3, 2024

Scripts/Bloodmyst isle: add missing Legoso Talk to $n pointer #29554

Merged

2 tasks

Shauren pushed a commit that referenced this issue Jan 4, 2024

Scripts/Bloodmyst Isle: Add missing Legoso Talk target (fixes $n) (#2…

0c1e5fe

…9554) Updates #21586

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Quest: Ending Their World (9759) #21586

Quest: Ending Their World (9759) #21586

dewmguy commented Mar 11, 2018 •

edited

Killyana commented Mar 11, 2018

dewmguy commented Mar 13, 2018 •

edited

offl commented Jun 20, 2020

Rothend commented Jun 21, 2020 •

edited

Quest: Ending Their World (9759) #21586

Quest: Ending Their World (9759) #21586

Comments

dewmguy commented Mar 11, 2018 • edited

Killyana commented Mar 11, 2018

dewmguy commented Mar 13, 2018 • edited

offl commented Jun 20, 2020

Rothend commented Jun 21, 2020 • edited

dewmguy commented Mar 11, 2018 •

edited

dewmguy commented Mar 13, 2018 •

edited

Rothend commented Jun 21, 2020 •

edited