Trinitycore: DB/Quest: Hard to Swallow

[citizenwow]

Description:

In quest https://www.wowhead.com/quest=12049/ When use Potent Explosive Charges (https://www.wowhead.com/item=36732/) when applied to the Hulking Jormungar (https://www.wowhead.com/npc=26293/) nothing happens (don't count)

Branch(es): 3.3.5

TC rev. hash/commit:

TrinityCore rev. c79571a 2019-11-03 17:00:24 +0100

Operating system: CentOS 7

[dr-j]

well if you look at the timed action list it runs on hp falling below 80% it says text then theres a five second delay before it sets phase to allow the spellhit to run the second timed action list don't know if this is correct since this is not my work but worked that out when if you throw the explosive as soon as text appears nothing happens then throw again and it triggers this is because theres a 5 second delay in timed action list in between the say and setting phase 1.
The spellhit event will only work in phase 1

[citizenwow]

idk, it's anyway don't work. I'm recheck a few times.

[dr-j]

~~~sql
DELETE FROM smart_scripts WHERE entryorguid=26293 AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguidIN(2629300,2629301) 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, 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
(26293, 0, 0, 0, 0, 3, 100, 0, 1500, 2000, 7000, 10000, 0, 11, 50293, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - In Combat - Cast 'Corrosive Poison' (Phase 1 & 2)'),
(26293, 0, 1, 0, 4, 0, 100, 0, 0, 0, 0, 9, 0, 22, 1, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - On Agro -Set Phase 1'),
(26293, 0, 2, 3, 2, 0, 100, 0, 0, 80, 10000, 10000, 0, 1, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - On Health at or below 80% HP (Phase 1) - Say'),
(26293, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - IC (Phase 1) - Set Phase 2'),
(26293, 0, 4, 0, 0, 2, 100, 0, 5000, 5000, 5000, 5000, 0, 22, 1, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - IC (Phase 2) - Set Phase 1'),
(26293, 0, 5, 0, 8, 2, 100, 512, 47305, 0, 0, 0, 0, 80, 2629300, 2, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - On Spellhit 'Potent Explosive Charge' (Phase 2) - Run Script (No Repeat)'),
(2629300, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - On Script - Set Phase 0'),
(2629300, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 11, 47309, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - On Script - Cast 'Quest - Jormungar Explosion Summon Object'),
(2629300, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 47324, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - On Script - Cast Quest - Jormungar Explosion Summon Object'),
(2629300, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 47325, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - On Script - Cast Quest - Jormungar Explosion Summon Object'),
(2629300, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 11, 47311, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - On Script - Cast Quest - Jormungar Explosion Summon Object'),
(2629300, 9, 6, 0, 0, 0, 100, 0, 10, 10, 0, 0, 0, 11, 47306, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Hulking Jormungar - On Script - Cast Potent Explosive Charge');

[illfated]

Nice progress. Thank you, @dr-j 👍

[Kitzunu]

Works great :)

[illfated]

Anything left to do before committing the SQL from dr-j ?

[Kitzunu]

From what I could tell comparing the video to the ingame it looked flawless.

[Killyana]

I will check it later.