Trinitycore: Fix Mogors Self Ress when fought for the ring of blood: the final challenge

Created on 29 Nov 2019 · 19Comments · Source: TrinityCore/TrinityCore

Fix https://www.wowhead.com/npc=18069/mogor so he resurrects when killed first time during https://www.wowhead.com/quest=9977/the-ring-of-blood-the-final-challenge

https://youtu.be/wCjLu8Q1pM0?t=293

This is achieved by him having invincibility HP and not really dying first time he is killed playing dead for a few seconds and then casting the cosmetic self ress spell, get up again and disable hp regen

There will now be 3 event phases on this npc

Phase 1 - First time he enters into combat (Resurrect script will only work when npc hp goes < 1% and is in this phase)
Phase 2 - Second time he enters combat (Credit for killing will only be given when npc dies in this event phase)
Phase 3 - Transition Phase between npc dying first time and resurrecting so on evade events don't trigger when leaving combat as would if evaded before being killed in either phase

~~~sql
UPDATE smart_scripts SET link='16' WHERE entryorguid=18069 AND source_type=0 AND id=11 AND link=0;
DELETE FROM smart_scripts WHERE entryorguid=18069 AND source_type=0 AND id=12 AND link=0;
UPDATE smart_scripts SET target_type='19' WHERE entryorguid=18069 AND source_type=0 AND id=14 AND link=0;
UPDATE smart_scripts SET link='12' WHERE entryorguid=18069 AND source_type=0 AND id=9 AND link=0;

DELETE FROM smart_scripts WHERE entryorguid=18069 AND source_type=0 AND id>15;
DELETE FROM smart_scripts WHERE entryorguid=1806901 AND source_type=9;
UPDATE smart_scripts SET event_type='61', comment='Mogor - On 1% HP or less - Run Script ' WHERE entryorguid=18069 AND source_type=0 AND id=4 AND link=0;
DELETE FROM smart_scripts WHERE entryorguid=18471 AND source_type=0 AND id=31;

DELETE FROM waypoints WHERE entry=1806900 AND pointid=1;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, orientation, point_comment) VALUES
(1806900, 1, -714.823, 7931.65, 58.8672, 0, 'Mogor (Path 2)');
~~~

Now I may need a little help with this since im not sure if I made any previous changes to script for this npc which have not been commited to tc so wondering if someone could test this as sq may need modifying and not all the updates maybe needed

Comp-Database Feedback-PatchFix Sub-Quests

Source

dr-j

👍2

Most helpful comment

oh https://github.com/TrinityCore/TrinityCore/issues/19875

dr-j on 29 Nov 2019

😄1 👍1

All 19 comments

oh https://github.com/TrinityCore/TrinityCore/issues/19875

dr-j on 29 Nov 2019

😄1 👍1

Nice. Indirectly solving an old issue (which was closed based on invalid core rev. hash.
Good job (both with the SQL & finding the old issue.). 👍

illfated on 29 Nov 2019

but actionlist 1806900 now does not get triggered at all?

Rushor on 5 Dec 2019

well as said I may have made changes which have not been commited to tc but that action list is run at sai event id 11 as linked event to id 10 on reached wp4

ID 4 runs second timed action list when in phase 1

this what I have
~~~
entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,event_param5,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_param4,target_x,target_y,target_z,target_o,comment
18069,0,0,0,0,0,100,0,1000,1000,3500,3500,0,11,16033,0,0,0,0,0,2,0,0,0,0,0,0,0,0,Mogor - In Combat - Cast 'Chain Lightning' (No Repeat)
18069,0,1,0,2,0,100,1,0,60,0,0,0,11,15982,1,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - Between 0-60% Health - Cast 'Healing Wave' (No Repeat)
18069,0,2,0,2,0,100,1,0,30,0,0,0,11,28747,1,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - Between 0-30% Health - Cast 'Frenzy' (No Repeat)
18069,0,3,0,2,0,100,1,0,30,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,Mogor - Between 0-30% Health - Say Line 0 (No Repeat)
18069,0,4,0,61,0,100,513,0,0,0,0,0,80,1806901,2,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On 1% HP or less - Run Script
18069,0,5,0,38,0,100,0,12,12,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On Data Set 12 12 - Say Line 1 (No Repeat)
18069,0,6,0,38,0,100,0,13,13,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On Data Set 13 13 - Say Line 2 (No Repeat)
18069,0,7,0,38,0,100,0,14,14,0,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On Data Set 14 14 - Say Line 6 (No Repeat)
18069,0,8,9,38,0,100,512,1,1,0,0,0,53,0,18069,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On Data Set 1 1 - Start Waypoint
18069,0,9,12,61,0,100,512,0,0,0,0,0,1,3,0,0,0,0,0,7,0,0,0,0,0,0,0,0,Mogor - On Data Set 1 1 - Say Line 3
18069,0,10,11,40,0,100,512,3,18069,0,0,0,45,1,6,2,0,0,0,19,18471,0,0,0,0,0,0,0,Mogor - On Waypoint 4 Reached - Pause Waypoint
18069,0,11,16,61,0,100,512,0,0,0,0,0,80,1806900,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On Waypoint 4 Reached - Run Script
18069,0,12,0,61,0,100,512,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On Agro - Set Phase 1
18069,0,13,14,6,0,100,513,0,0,0,0,0,15,9977,0,0,0,0,0,16,0,0,0,0,0,0,0,0,Mogor - On Just Died - Quest Credit 'The Ring of Blood: The Final Challenge'
18069,0,14,0,61,0,100,512,0,0,0,0,0,45,15,15,0,0,0,0,19,18471,0,0,0,0,0,0,0,Mogor - Linked with Previous Event - Say Data
18069,0,15,0,0,0,100,0,1000,3000,60000,65000,0,11,18975,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - In Combat - Cast Ice Totem
18069,0,16,0,61,0,100,512,0,0,0,0,0,42,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On Waypoint 4 Reached - Set Invincibility HP On
18069,0,17,18,2,1,100,513,0,1,0,0,0,18,536870912,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On 1% HP or less - Set Unit Flags
18069,0,18,19,61,1,100,513,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On 1% HP or less - Set Unit Flags
18069,0,19,20,61,1,100,513,0,0,0,0,0,95,32,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On 1% HP or less - Set Dyamic Flags
18069,0,20,4,61,1,100,513,0,0,0,0,0,90,7,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On 1% HP or less - Set Bytes 1
18069,0,21,22,7,3,100,513,0,0,0,0,0,2,35,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On Evade (Phase 1) - Set Faction
18069,0,22,0,61,3,100,513,0,0,0,0,0,53,1,1806900,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On Evade (Phase 1) - Start WP (Path 2)
18069,0,23,24,40,0,100,513,1,1806900,0,0,0,101,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,Mogor - On Reached WP1 (Path 2) - Set Home Position
18069,0,24,25,61,0,100,513,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,4.3693,Mogor - On Reached WP1 (Path 2) - Set Orientation
18069,0,25,0,61,0,100,512,0,0,0,0,0,45,16,16,0,0,0,0,19,18471,0,0,0,0,0,0,0,Mogor - On Reached WP1 (Path 2) - Say Data

dr-j on 5 Dec 2019

This is the actual SAI, also don't forget a running action list cannot be override by an other unless the new one has action_param3=1
``` sql
entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, event_param5, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o, comment
18069, 0, 0, 0, 0, 0, 100, 0, 1000, 1000, 3500, 3500, 0, 11, 16033, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - In Combat - Cast 'Chain Lightning' (No Repeat)
18069, 0, 1, 0, 0, 0, 100, 0, 4000, 4000, 11000, 13000, 0, 11, 39529, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - In Combat - Cast 'Flame Shock' (No Repeat)
18069, 0, 2, 0, 2, 0, 100, 1, 0, 60, 0, 0, 0, 11, 15982, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - Between 0-60% Health - Cast 'Healing Wave' (No Repeat)
18069, 0, 3, 0, 2, 0, 100, 1, 0, 30, 0, 0, 0, 11, 28747, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - Between 0-30% Health - Cast 'Frenzy' (No Repeat)
18069, 0, 4, 0, 2, 0, 100, 1, 0, 30, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - Between 0-30% Health - Say Line 0 (No Repeat)
18069, 0, 5, 0, 6, 0, 100, 513, 0, 0, 0, 0, 0, 80, 1806901, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Just Died - Run Script (No Repeat)
18069, 0, 6, 0, 38, 0, 100, 0, 12, 12, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Data Set 12 12 - Say Line 1 (No Repeat)
18069, 0, 7, 0, 38, 0, 100, 0, 13, 13, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Data Set 13 13 - Say Line 2 (No Repeat)
18069, 0, 8, 0, 38, 0, 100, 0, 14, 14, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Data Set 14 14 - Say Line 6 (No Repeat)
18069, 0, 9, 0, 38, 0, 100, 512, 1, 1, 0, 0, 0, 53, 0, 18069, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Data Set 1 1 - Start Waypoint
18069, 0, 10, 0, 40, 0, 100, 512, 3, 18069, 0, 0, 0, 45, 1, 6, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, 0, Mogor - On Data Set 1 1 - Say Line 3
18069, 0, 11, 12, 40, 0, 100, 512, 4, 18069, 0, 0, 0, 54, 100000, 0, 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Waypoint 4 Reached - Pause Waypoint
18069, 0, 12, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 80, 1806900, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Waypoint 4 Reached - Run Script
18069, 0, 13, 0, 21, 0, 100, 512, 0, 0, 0, 0, 0, 2, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Reached Home - Set Faction 35
18069, 0, 14, 15, 6, 0, 100, 513, 0, 0, 0, 0, 0, 15, 9977, 0, 0, 0, 0, 0, 27, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Just Died - Quest Credit 'The Ring of Blood: The Final Challenge'
18069, 0, 15, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 45, 15, 15, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, 0, Mogor - Linked with Previous Event - Say Data
1806900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Script - Say Line 4
1806900, 9, 1, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Script - Set Faction 14
1806900, 9, 2, 0, 0, 0, 100, 0, 9, 9, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Script - Set Reactstate Aggressive
1806901, 9, 0, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 11, 32343, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Script - Cast 'Revive Self'
1806901, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 133, 0, 48191, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Script - Respawn Self
1806901, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, Mogor - On Script - Say Line 5
1806901, 9, 3, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 35, 0, 0, 0, 0, 0, 0, 0, Mogor - On Script - Start Attacking

Killyana on 5 Dec 2019

Ok looks like I had previously made some updates to this script which I forgot about its been a while and cant remember why was changed but looks like parts got screwed over by updates as ids did not match ie why had bad targets and an unneeded data set which was trying to set data 1 6 which I presume that was meant to be say but some update screwed it up

Anway this is complete
~~~sql
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=18069;
DELETE FROM smart_scripts WHERE source_type=9 AND entryorguidIN(1606900,1806901);
DELETE FROM smart_scripts WHERE entryorguid=18471 AND source_type=0 AND id=31;

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, event_param5, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o, comment) VALUES
(18471, 0, 31, 22, 38, 0, 100, 512, 16, 16, 0, 0, 0, 81, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Gurgthock - On Data Set - Set NPC Flag'),
(18069, 0, 0, 0, 0, 0, 100, 0, 1000, 1000, 3500, 3500, 0, 11, 16033, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - In Combat - Cast \'Chain Lightning\' (No Repeat)'),
(18069, 0, 1, 0, 2, 0, 100, 1, 0, 60, 0, 0, 0, 11, 15982, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - Between 0-60% Health - Cast \'Healing Wave\' (No Repeat)'),
(18069, 0, 2, 0, 2, 0, 100, 1, 0, 30, 0, 0, 0, 11, 28747, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - Between 0-30% Health - Cast \'Frenzy\' (No Repeat)'),
(18069, 0, 3, 0, 2, 0, 100, 1, 0, 30, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - Between 0-30% Health - Say Line 0 (No Repeat)'),
(18069, 0, 4, 0, 61, 0, 100, 513, 0, 0, 0, 0, 0, 80, 1806901, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On 1% HP or less (Phase 1) - Run Script '),
(18069, 0, 5, 0, 38, 0, 100, 0, 12, 12, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 12 12 - Say Line 1 (No Repeat)'),
(18069, 0, 6, 0, 38, 0, 100, 0, 13, 13, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 13 13 - Say Line 2 (No Repeat)'),
(18069, 0, 7, 0, 38, 0, 100, 0, 14, 14, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 14 14 - Say Line 6 (No Repeat)'),
(18069, 0, 8, 9, 38, 0, 100, 512, 1, 1, 0, 0, 0, 53, 0, 18069, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 1 1 - Start Waypoint'),
(18069, 0, 9, 11, 61, 0, 100, 512, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 1 1 - Say Line 3'),
(18069, 0, 10, 15, 40, 0, 100, 512, 4, 18069, 0, 0, 0, 80, 1806900, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Waypoint 4 Reached - Run Script'),
(18069, 0, 11, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Agro - Set Phase 1'),
(18069, 0, 12, 13, 6, 2, 100, 513, 0, 0, 0, 0, 0, 15, 9977, 0, 0, 0, 0, 0, 27, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Just Died - Quest Credit \'The Ring of Blood: The Final Challenge\''),
(18069, 0, 13, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 45, 15, 15, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, 0, 'Mogor - Linked with Previous Event - Say Data'),
(18069, 0, 14, 0, 0, 0, 100, 0, 1000, 3000, 60000, 65000, 0, 11, 18975, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - In Combat - Cast Ice Totem'),
(18069, 0, 15, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 42, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Waypoint 4 Reached - Set Invincibility HP On'),
(18069, 0, 16, 17, 2, 1, 100, 513, 0, 1, 0, 0, 0, 18, 536870912, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On 1% HP or less - Set Unit Flags'),
(18069, 0, 17, 18, 61, 1, 100, 513, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On 1% HP or less (Phase 1) - Set Unit Flags'),
(18069, 0, 18, 19, 61, 1, 100, 513, 0, 0, 0, 0, 0, 95, 32, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On 1% HP or less (Phase 1) - Set Dyamic Flags'),
(18069, 0, 19, 4, 61, 1, 100, 513, 0, 0, 0, 0, 0, 90, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On 1% HP or less (Phase 1) - Set Bytes 1'),
(18069, 0, 20, 21, 7, 3, 100, 513, 0, 0, 0, 0, 0, 2, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Evade (Phase 1 & 2) - Set Faction'),
(18069, 0, 21, 0, 61, 3, 100, 513, 0, 0, 0, 0, 0, 53, 1, 1806900, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Evade (Phase 1 & 2) - Start WP (Path 2)'),
(18069, 0, 22, 23, 40, 0, 100, 513, 1, 1806900, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Reached WP1 (Path 2) - Set Home Position'),
(18069, 0, 23, 24, 61, 0, 100, 513, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 4.3693, 'Mogor - On Reached WP1 (Path 2) - Set Orientation'),
(18069, 0, 24, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 45, 16, 16, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Reached WP1 (Path 2) - Say Data'),
(18069, 0, 25, 0, 7, 0, 100, 512, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 19, 12141, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Evade (All Phases) - Despawn Ice Totem'),
(1806900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Say Line 4'),
(1806900, 9, 1, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Faction 14'),
(1806900, 9, 2, 0, 0, 0, 100, 0, 9, 9, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Reactstate Aggressive'),
(1806901, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Home Position'),
(1806901, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Phase 3'),
(1806901, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 11, 32343, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Cast \'Revive Self\''),
(1806901, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 91, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Bytes 1'),
(1806901, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 96, 32, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Dyanmic Flags'),
(1806901, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 19, 536870912, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Unit Flags'),
(1806901, 9, 6, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Say Line 5'),
(1806901, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Turn Invinvibility HP OFF'),
(1806901, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Phase 2'),
(1806901, 9, 9, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Unit Flags'),
(1806901, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 35, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Start Attacking');

dr-j on 5 Dec 2019

and should not be issues with timed action lists first is run on reached wp and has 5 seconds duration the second does not run until end of first phase and that one has 7.5 seconds duration

dr-j on 5 Dec 2019

DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`IN(1806900,1806901);

better :D

Rushor on 5 Dec 2019

and maybe: try adding despawn of the summoned totem on evade of boss

Rushor on 5 Dec 2019

added and corrected comments about phases

dr-j on 5 Dec 2019

In the actual script we have:
18069, 0, 10, 0, 40, 0, 100, 512, 3, 18069, 0, 0, 0, 45, 1, 6, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, 0, Mogor - On Data Set 1 1 - Say Line 3

18471, 0, 29, 0, 38, 0, 100, 0, 1, 6, 0, 0, 0, 1, 13, 2000, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, Gurgthock - On Data Set 1 13 - Say Line 13

When Mogor reach wp 3 it set data 1,6 to Gurgthock and that will trigger Say Line 13
In the rewrite text 13 is never used

Added: https://github.com/TrinityCore/TrinityCore/commit/c907ab4381088939b001ae5e0d275cfb923849de

Killyana on 6 Dec 2019

I made some changes to fix DB errors and adapt the SAI to current data.
``sql DELETE FROMsmart_scriptsWHEREsource_type=0 ANDentryorguid=18069; DELETE FROMsmart_scriptsWHEREsource_type=9 ANDentryorguidIN(1806900,1806901); DELETE FROMsmart_scriptsWHEREentryorguid=18471 ANDsource_type=0 ANDidIN (30,31); DELETE FROMsmart_scriptsWHEREentryorguidIN (18400) ANDsource_type=0 ANDid=2; 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,event_param5,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_param4,target_x,target_y,target_z,target_o,comment`) VALUES
(18471, 0, 30, 20, 52, 0, 100, 0, 13, 18471, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 19, 18069, 0, 0, 0, 0, 0, 0, 0, "Gurgthock - On text over - Say Line 3"),
(18471, 0, 31, 22, 38, 0, 100, 512, 16, 16, 0, 0, 0, 81, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Gurgthock - On Data Set - Set NPC Flag'),
(18069, 0, 0, 0, 0, 0, 100, 0, 1000, 1000, 3500, 3500, 0, 11, 16033, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - In Combat - Cast \'Chain Lightning\' (No Repeat)'),
(18069, 0, 1, 0, 2, 0, 100, 1, 0, 60, 0, 0, 0, 11, 15982, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - Between 0-60% Health - Cast \'Healing Wave\' (No Repeat)'),
(18069, 0, 2, 0, 2, 0, 100, 1, 0, 30, 0, 0, 0, 11, 28747, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - Between 0-30% Health - Cast \'Frenzy\' (No Repeat)'),
(18069, 0, 3, 0, 2, 0, 100, 1, 0, 30, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - Between 0-30% Health - Say Line 0 (No Repeat)'),
(18069, 0, 4, 0, 61, 0, 100, 513, 0, 0, 0, 0, 0, 80, 1806901, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On 1% HP or less (Phase 1) - Run Script '),
(18069, 0, 5, 0, 38, 0, 100, 0, 12, 12, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 12 12 - Say Line 1 (No Repeat)'),
(18069, 0, 6, 0, 38, 0, 100, 0, 13, 13, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 13 13 - Say Line 2 (No Repeat)'),
(18069, 0, 7, 0, 38, 0, 100, 0, 14, 14, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 14 14 - Say Line 6 (No Repeat)'),
(18069, 0, 8, 9, 38, 0, 100, 512, 1, 1, 0, 0, 0, 53, 0, 18069, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 1 1 - Start Waypoint'),
(18069, 0, 9, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 1 1 - Set event phase 1'),
(18069, 0, 10, 15, 40, 0, 100, 512, 4, 18069, 0, 0, 0, 80, 1806900, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Waypoint 4 Reached - Run Script'),
(18069, 0, 12, 13, 6, 2, 100, 513, 0, 0, 0, 0, 0, 15, 9977, 0, 0, 0, 0, 0, 27, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Just Died - Quest Credit \'The Ring of Blood: The Final Challenge\''),
(18069, 0, 13, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 45, 15, 15, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, 0, 'Mogor - Linked with Previous Event - Say Data'),
(18069, 0, 14, 0, 0, 0, 100, 0, 1000, 3000, 60000, 65000, 0, 11, 18975, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - In Combat - Cast Ice Totem'),
(18069, 0, 15, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 42, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Waypoint 4 Reached - Set Invincibility HP On'),
(18069, 0, 16, 17, 2, 1, 100, 513, 0, 1, 0, 0, 0, 18, 536870912, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On 1% HP or less - Set Unit Flags'),
(18069, 0, 17, 18, 61, 1, 100, 513, 0, 0, 0, 0, 0, 18, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On 1% HP or less (Phase 1) - Set Unit Flags'),
(18069, 0, 18, 19, 61, 1, 100, 513, 0, 0, 0, 0, 0, 95, 32, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On 1% HP or less (Phase 1) - Set Dyamic Flags'),
(18069, 0, 19, 4, 61, 1, 100, 513, 0, 0, 0, 0, 0, 90, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On 1% HP or less (Phase 1) - Set Bytes 1'),
(18069, 0, 20, 21, 7, 3, 100, 0, 0, 0, 0, 0, 0, 2, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Evade (Phase 1 & 2) - Set Faction'),
(18069, 0, 21, 0, 61, 3, 100, 0, 0, 0, 0, 0, 0, 53, 1, 1806900, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Evade (Phase 1 & 2) - Start WP (Path 2)'),
(18069, 0, 22, 23, 40, 0, 100, 0, 1, 1806900, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Reached WP1 (Path 2) - Set Home Position'),
(18069, 0, 23, 24, 61, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 4.3693, 'Mogor - On Reached WP1 (Path 2) - Set Orientation'),
(18069, 0, 24, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 45, 16, 16, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Reached WP1 (Path 2) - Say Data'),
(18069, 0, 25, 0, 7, 0, 100, 512, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 19, 12141, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Evade (All Phases) - Despawn Ice Totem'),
(18069, 0, 26, 0, 40, 0, 100, 512, 3, 18069, 0, 0, 0, 45, 1, 6, 0, 0, 0, 0, 19, 18471, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Data Set 1 1 - Say Line 3'),
(18069, 0, 27, 0, 0, 0, 100, 0, 4000, 4000, 11000, 13000, 0, 11, 39529, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - In Combat - Cast Flame Shock'),
(1806900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Say Line 4'),
(1806900, 9, 1, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Faction 14'),
(1806900, 9, 2, 0, 0, 0, 100, 0, 9, 9, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Reactstate Aggressive'),
(1806901, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Home Position'),
(1806901, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Phase 3'),
(1806901, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 11, 32343, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Cast \'Revive Self\''),
(1806901, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 91, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Bytes 1'),
(1806901, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 96, 32, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Dyanmic Flags'),
(1806901, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 19, 536870912, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Unit Flags'),
(1806901, 9, 6, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Say Line 5'),
(1806901, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Turn Invinvibility HP OFF'),
(1806901, 9, 8, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Phase 2'),
(1806901, 9, 9, 0, 0, 0, 100, 0, 500, 500, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Set Unit Flags'),
(1806901, 9, 10, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 35, 0, 0, 0, 0, 0, 0, 0, 'Mogor - On Script - Start Attacking');

DELETE FROM waypoints WHERE entry=1806900 AND pointid=1;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(1806900, 1, -714.823, 7931.65, 58.8672, 'Mogor (Path 2)');

Killyana on 6 Dec 2019

That line 31 on gurgthock and the associated data set on evade (in phase 1 & 2) was to reset npc flags on gurgthock without triggering text so quests can be taken again straight away

dr-j on 6 Dec 2019

Updated.

Killyana on 6 Dec 2019

Isn't better to despawn Mogor on evade or reset it completely to his spawn position, this will avoid having a different quest starting when Mogor is in the arena (after an evade)

Killyana on 6 Dec 2019

I have to set home position when he pretends to die to stop corpse moving slightly after he dies. When leaves combat causes evade that’s why have to set home position

dr-j on 6 Dec 2019

Actually it works fine, but only the "first time" the second time he will not set faction to 35 and return to spawn position, the third time it will, and the fourth time not, ect...

Killyana on 6 Dec 2019

Probably because of event flags on those events (non repeatable)

dr-j on 6 Dec 2019

Yes it's, I removed the non repeatable flag, every thing look fine for me.

Killyana on 7 Dec 2019

👍1

Was this page helpful?

0 / 5 - 0 ratings