Trinitycore: DB/Quest: Field Duty

[Killyana]

Description: The event is not scripted for both alliance an horde quests
https://wow.gamepedia.com/Field_Duty_(Horde)
https://wow.gamepedia.com/Field_Duty_(Alliance)
https://woehead.way-of-elendil.fr/?quest=8731
https://woehead.way-of-elendil.fr/?quest=8507

Steps to reproduce the problem:

1. In the current revision you can just use the item and talk to the npc to complete the quest

Branch(es): 3.3.5

TC rev. hash/commit: rev. c52eb49f7160

[illfated]

Good point, I have not seen those elite level 60 mobs before, never checked out those quests on retail. Thank you for the links to the wow.gamepedia.com pages, those mobs are big "bugs". 😄

[ZenoX92]

Here is the fix for the Horde quest. I will work later on the Alliance one.
``sql -- Quest "Field Duty" (Horde) -- Krug Skullsplit UPDATEcreature_templateSETAIName="SmartAI" WHEREentry=15612; DELETE FROMsmart_scriptsWHEREentryorguid=15612 ANDsource_type=0; DELETE FROMsmart_scriptsWHEREentryorguidIN (1561200,1561201) 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
(15612,0,0,0,11,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Krug Skullsplit - On Respawn - Set Active On"),
(15612,0,1,0,11,0,100,0,0,0,0,0,81,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Krug Skullsplit - On Respawn - Set Npc Flag 'Gossip'"),
(15612,0,2,0,62,0,100,0,6687,0,0,0,12,15620,6,120000,0,0,0,8,0,0,0,-7765,536,-43.4281,0,"Krug Skullsplit - On Gossip Option Selected - Summon 'Hive'Regal Hunter-Killer'"),
(15612,0,3,0,38,0,100,0,1,1,0,0,80,1561200,0,0,0,0,0,1,0,0,0,0,0,0,0,"Krug Skullsplit - On Data 1 Set - Run Script"),
(15612,0,4,0,38,0,100,0,2,2,0,0,80,1561201,0,0,0,0,0,1,0,0,0,0,0,0,0,"Krug Skullsplit - On Data 2 Set - Run Script"),
(15612,0,5,0,4,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Krug Skullsplit - On Aggro - Say Line 2"),
(15612,0,6,0,0,0,100,0,5000,7000,12000,16000,11,16856,0,0,0,0,0,2,0,0,0,0,0,0,0,"Krug Skullsplit - In Combat - Cast 'Mortal Strike'"),
(15612,0,7,0,0,0,100,0,8000,12000,18000,22000,11,15548,0,0,0,0,0,1,0,0,0,0,0,0,0,"Krug Skullsplit - In Combat - Cast 'Thunderclap'"),
(1561200,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Krug Skullsplit - On Script - Say Line 0"),
(1561200,9,1,0,0,0,100,0,4000,4000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Krug Skullsplit - On Script - Say Line 1"),
(1561200,9,2,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,15613,0,0,0,0,0,0,"Krug Skullsplit - On Script - Set Data to Merok Longstride"),
(1561200,9,3,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,15615,0,0,0,0,0,0,"Krug Skullsplit - On Script - Set Data to Shadow Priestess Shai"),
(1561201,9,0,0,0,0,100,0,0,0,0,0,81,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Krug Skullsplit - On Script - Set Npc Flag 'Questgiver'"),
(1561201,9,1,0,0,0,100,0,120000,120000,0,0,81,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Krug Skullsplit - On Script - Set Npc Flag 'Gossip'");

DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup=6687;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=22 AND SourceEntry=15612;
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(15,6687,0,0,0,9,0,8731,0,0,0,0,0,"","Show gossip option if quest 'Field Duty' is taken"),
(22,3,15612,0,0,29,1,15620,900,0,1,0,0,"","SAI triggers only if Hive'Regal Hunter-Killer is not already spawned");

DELETE FROM creature_text WHERE CreatureID=15612;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(15612,0,0,"The enemy is upon us, stand ready!",14,0,100,22,0,0,11286,0,"Krug Skullsplit"),
(15612,1,0,"Merok! Shai! To my side!",14,0,100,5,0,0,11287,0,"Krug Skullsplit"),
(15612,2,0,"For the Horde!",14,0,100,0,0,0,11288,0,"Krug Skullsplit");

DELETE FROM gossip_menu_option WHERE MenuID IN (6687);
INSERT INTO gossip_menu_option (MenuID, OptionID, OptionIcon, OptionText, OptionBroadcastTextID, OptionType, OptionNpcFlag, ActionMenuID, ActionPoiID, BoxCoded, BoxMoney, BoxText, BoxBroadcastTextID, VerifiedBuild) VALUES
(6687,0,0,"Reporting for duty, sir.",11274,1,1,6688,0,0,0,"",0,0);

DELETE FROM gossip_menu WHERE MenuID IN (6688);
INSERT INTO gossip_menu (MenuID, TextID, VerifiedBuild) VALUES
(6688,8060,0);

UPDATE npc_text SET text0_0="You're just in time, $c. Do you feel the ground shaking beneath you?$B$BSomething approaches from the hive. Take a place near the grunts, $n. I'm counting on you!", text0_1="" WHERE ID=8060;

-- Hive'Regal Hunter-Killer
UPDATE creature_template SET AIName="SmartAI" WHERE entry=15620;
DELETE FROM smart_scripts WHERE entryorguid=15620 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
(15620,0,0,0,54,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hive'Regal Hunter-Killer - Just Summoned - Set Active On"),
(15620,0,1,0,54,0,100,0,0,0,0,0,53,0,15620,0,0,0,2,1,0,0,0,0,0,0,0,"Hive'Regal Hunter-Killer - Just Summoned - Start Waypoint"),
(15620,0,2,0,40,0,100,0,11,15620,0,0,45,1,1,0,0,0,0,19,15612,0,0,0,0,0,0,"Hive'Regal Hunter-Killer - On Waypoint 11 Reached - Set Data 1 to Krug Skullsplit"),
(15620,0,3,0,0,0,100,0,15000,20000,25000,30000,11,25821,0,0,0,0,0,21,40,0,0,0,0,0,0,"Hive'Regal Hunter-Killer - In Combat - Cast 'Charge'"),
(15620,0,4,0,0,0,100,0,7000,10000,16000,19000,11,15588,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hive'Regal Hunter-Killer - In Combat - Cast 'Thunderclap'"),
(15620,0,5,0,0,0,100,0,5000,7000,5000,12000,11,15284,0,0,0,0,0,2,0,0,0,0,0,0,0,"Hive'Regal Hunter-Killer - In Combat - Cast 'Cleave'"),
(15620,0,6,0,0,0,100,0,10000,15000,35000,40000,11,25815,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hive'Regal Hunter-Killer - In Combat - Cast 'Frightening Shriek'"),
(15620,0,7,0,6,0,100,0,0,0,0,0,45,2,2,0,0,0,0,19,15612,0,0,0,0,0,0,"Hive'Regal Hunter-Killer - On Just Died - Set Data 2 to Krug Skullsplit");

DELETE FROM waypoints WHERE entry=15620;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z) VALUES
(15620, 1, -7769.14, 549.365, -44.1111),
(15620, 2, -7762.88, 564.709, -45.9125),
(15620, 3, -7749.28, 589.14, -47.1617),
(15620, 4, -7748.5, 622.853, -45.2946),
(15620, 5, -7730.37, 643.343, -46.7866),
(15620, 6, -7694.24, 660.321, -51.0377),
(15620, 7, -7674.25, 671.264, -50.4592),
(15620, 8, -7655.01, 671.601, -47.9161),
(15620, 9, -7634.07, 672.497, -47.8617),
(15620, 10, -7603.06, 667.321, -48.6429),
(15620, 11, -7571.59, 665.263, -48.3899),
(15620, 12, -7562.58, 687.328, -49.9864),
(15620, 13, -7559.18, 689.958, -40.8654),
(15620, 14, -7555.3, 692.953, -30.7562),
(15620, 15, -7548.27, 697.037, -25.6632),
(15620, 16, -7547.07, 706.949, -17.7001),
(15620, 17, -7549.78, 711.901, -16.4527);

-- Merok Longstride
UPDATE creature_template SET AIName="SmartAI" WHERE entry=15613;
DELETE FROM smart_scripts WHERE entryorguid=15613 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
(15613,0,0,0,0,0,100,0,3000,6000,13000,16000,11,15616,0,0,0,0,0,2,0,0,0,0,0,0,0,"Merok Longstride - In Combat - Cast 'Flame Shock'"),
(15613,0,1,0,23,0,100,0,15507,0,3000,5000,11,15507,0,0,0,0,0,1,0,0,0,0,0,0,0,"Merok Longstride - In Combat - Cast 'Lightning Shield'"),
(15613,0,2,0,14,0,100,0,4000,40,15000,20000,11,15982,0,0,0,0,0,7,0,0,0,0,0,0,0,"Merok Longstride - Friendly At 4000 Health - Cast 'Healing Wave'"),
(15613,0,3,0,38,0,100,0,1,1,0,0,69,0,0,0,0,0,0,8,0,0,0,-7542.45,720.155,-15.6801,0,"Merok Longstride - On Data Set - Move to Position");

-- Shadow Priestess Shai
UPDATE creature_template SET AIName="SmartAI" WHERE entry=15615;
DELETE FROM smart_scripts WHERE entryorguid=15615 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
(15615,0,0,0,0,0,100,0,3000,5000,12000,16000,11,17194,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shadow Priestess Shai - In Combat - Cast 'Mind Blast'"),
(15615,0,1,0,0,0,100,0,6000,8000,22000,26000,11,17146,0,0,0,0,0,5,0,0,0,0,0,0,0,"Shadow Priestess Shai - In Combat - Cast 'Shadow Word: Pain'"),
(15615,0,2,0,14,0,100,0,4000,40,15000,20000,11,17138,0,0,0,0,0,7,0,0,0,0,0,0,0,"Shadow Priestess Shai - Friendly At 4000 Health - Cast 'Flash Heal'"),
(15615,0,3,0,38,0,100,0,1,1,0,0,69,0,0,0,0,0,0,8,0,0,0,-7553.46,720.924,-16.715,0,"Shadow Priestess Shai - On Data Set - Move to Position");

[ZenoX92]

And here is the fix for the Alliance quest.
``sql -- Janela Stouthammer UPDATEcreature_templateSETAIName="SmartAI" WHEREentry=15443; DELETE FROMsmart_scriptsWHEREentryorguid=15443 ANDsource_type=0; DELETE FROMsmart_scriptsWHEREentryorguidIN (1544300,1544301) 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
(15443,0,0,0,11,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Janela Stouthammer - On Respawn - Set Active On"),
(15443,0,1,0,62,0,100,0,6623,0,0,0,80,1544300,0,0,0,0,0,1,0,0,0,0,0,0,0,"Janela Stouthammer - On Gossip Option Selected - Run Script"),
(15443,0,2,0,0,0,100,0,5000,7000,12000,16000,11,14518,0,0,0,0,0,2,0,0,0,0,0,0,0,"Janela Stouthammer - In Combat - Cast 'Crusader Strike'"),
(15443,0,3,0,14,0,100,0,4000,40,15000,20000,11,25263,0,0,0,0,0,7,0,0,0,0,0,0,0,"Janela Stouthammer - Friendly At 4000 Health - Cast 'Holy Light'"),
(1544300,9,0,0,0,0,100,0,0,0,0,0,12,15449,6,120000,0,0,0,8,0,0,0,-7355.47,1660.02,-33.1674,5.4105,"Janela Stouthammer - On Script - Summon 'Hive'Zora Abomination'"),
(1544300,9,1,0,0,0,100,0,20000,20000,0,0,12,15440,6,60000,0,0,0,8,0,0,0,-7168.18,1380.71,2.91784,1.09484,"Janela Stouthammer - On Script - Summon 'Captain Blackanvil'"),
(1544300,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,10,42910,15441,0,0,0,0,0,"Janela Stouthammer - On Script - Say Line 0 (Ironforge Brigade Rifleman)"),
(1544300,9,3,0,0,0,100,0,6000,6000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Janela Stouthammer - On Script - Say Line 0"),
(1544300,9,4,0,0,0,100,0,4000,4000,0,0,1,1,0,0,0,0,0,10,42910,15441,0,0,0,0,0,"Janela Stouthammer - On Script - Say Line 1 (Ironforge Brigade Rifleman)"),
(1544300,9,5,0,0,0,100,0,3000,3000,0,0,45,1,1,0,0,0,0,10,42910,15441,0,0,0,0,0,"Janela Stouthammer - On Script - Set Data to Ironforge Brigade Rifleman");

DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup=6623;
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(15,6623,0,0,0,9,0,8507,0,0,0,0,0,"","Show gossip option if quest 'Field Duty' is taken"),
(15,6623,0,0,0,29,1,15449,900,0,1,0,0,"","SAI triggers only if Hive'Zora Abomination is not already spawned"),
(15,6623,0,0,0,29,1,15440,900,0,1,0,0,"","SAI triggers only if Captain Blackanvil is not already spawned");

DELETE FROM gossip_menu_option WHERE MenuID IN (6623);
INSERT INTO gossip_menu_option (MenuID, OptionID, OptionIcon, OptionText, OptionBroadcastTextID, OptionType, OptionNpcFlag, ActionMenuID, ActionPoiID, BoxCoded, BoxMoney, BoxText, BoxBroadcastTextID, VerifiedBuild) VALUES
(6623,0,0,"I'm here to aid the Captain.",11006,1,1,6624,0,0,0,"",0,0);

DELETE FROM gossip_menu WHERE MenuID IN (6624);
INSERT INTO gossip_menu (MenuID, TextID, VerifiedBuild) VALUES
(6624,7875,0);

-- Hive'Zora Abomination
UPDATE creature_template SET AIName="SmartAI" WHERE entry=15449;
DELETE FROM smart_scripts WHERE entryorguid=15449 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
(15449,0,0,0,54,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hive'Zora Abomination - Just Summoned - Set Active On"),
(15449,0,1,0,54,0,100,0,0,0,0,0,53,0,15449,0,0,0,2,1,0,0,0,0,0,0,0,"Hive'Zora Abomination - Just Summoned - Start Waypoint"),
(15449,0,2,0,0,0,100,0,8000,12000,16000,24000,11,25189,0,0,0,0,0,6,0,0,0,0,0,0,0,"Hive'Zora Abomination - In Combat - Cast 'Enveloping Winds'"),
(15449,0,3,0,0,0,100,0,9000,13000,15000,25000,11,25198,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hive'Zora Abomination - In Combat - Cast 'Poison Cloud'"),
(15449,0,4,0,0,0,100,0,5000,7000,13000,17000,11,25262,0,0,0,0,0,5,0,0,0,0,0,0,0,"Hive'Zora Abomination - In Combat - Cast 'Abomination Spit'"),
(15449,0,5,0,0,0,100,0,10000,15000,35000,40000,11,25260,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hive'Zora Abomination - In Combat - Cast 'Wings of Despair'"),
(15449,0,6,0,40,0,100,0,6,15449,0,0,45,2,2,0,0,0,0,19,15440,0,0,0,0,0,0,"Hive'Zora Abomination - On Waypoint 6 Reached - Set Data 2 to Captain Blackanvil"),
(15449,0,7,0,6,0,100,0,0,0,0,0,45,3,3,0,0,0,0,19,15440,0,0,0,0,0,0,"Hive'Zora Abomination - On Just Died - Set Data 3 to Captain Blackanvil");

DELETE FROM waypoints WHERE entry=15449;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z) VALUES
(15449, 1, -7327.58, 1626.2, -30.2021),
(15449, 2, -7280.14, 1586.27, -29.5117),
(15449, 3, -7254.51, 1552.92, -15.7705),
(15449, 4, -7241.55, 1498.67, -5.84411),
(15449, 5, -7212.22, 1452.28, -2.78192),
(15449, 6, -7205.93, 1433.55, 4.94912),
(15449, 7, -7203.28, 1417.93, 5.47492),
(15449, 8, -7181.79, 1397.39, 2.85378);

-- Ironforge Brigade Rifleman
DELETE FROM smart_scripts WHERE entryorguid=-42910 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
(-42910,0,0,0,0,0,100,0,0,0,2000,4000,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Ironforge Brigade Rifleman - In Combat - Cast 'Shoot'"),
(-42910,0,1,0,38,0,100,0,1,1,0,0,53,1,15441,0,0,0,2,1,0,0,0,0,0,0,0,"Ironforge Brigade Rifleman - On Data Set - Start Waypoint"),
(-42910,0,2,0,40,0,100,0,1,15441,0,0,54,7000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Brigade Rifleman - On Waypoint 1 Reached - Pause Waypoint"),
(-42910,0,3,0,40,0,100,0,1,15441,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,4.24021,"Ironforge Brigade Rifleman - On Waypoint 1 Reached - Set Orientation"),
(-42910,0,4,0,40,0,100,0,1,15441,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Brigade Rifleman - On Waypoint 1 Reached - Say Line 2"),
(-42910,0,5,0,40,0,100,0,1,15441,0,0,45,1,1,0,0,0,0,19,15440,0,0,0,0,0,0,"Ironforge Brigade Rifleman - On Waypoint 1 Reached - Set Data 1 to Captain Blackanvil"),
(-42910,0,6,0,40,0,100,0,1,15441,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.23402,"Ironforge Brigade Rifleman - On Waypoint 2 Reached - Set Orientation");

DELETE FROM waypoints WHERE entry=15441;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z) VALUES
(15441, 1, -7167.08, 1382.81, 2.9195),
(15441, 2, -7178.14, 1390.42, 2.9267);

-- Captain Blackanvil
DELETE FROM creature WHERE guid=150185; -- Captain Blackanvil only spawns during the event

UPDATE creature_template SET npcflag=2, AIName="SmartAI" WHERE entry=15440;
DELETE FROM smart_scripts WHERE entryorguid=15440 AND source_type=0;
DELETE FROM smart_scripts WHERE entryorguid IN (1544000,1544001,1544002) 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
(15440,0,0,0,54,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - Just Summoned - Set Active On"),
(15440,0,1,0,54,0,100,0,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - Just Summoned - Remove Npc Flag 'Questgiver'"),
(15440,0,2,0,38,0,100,0,1,1,0,0,80,1544000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - On Data 1 Set - Run Script"),
(15440,0,3,0,38,0,100,0,2,2,0,0,80,1544001,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - On Data 2 Set - Run Script"),
(15440,0,4,0,38,0,100,0,3,3,0,0,80,1544002,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - On Data 3 Set - Run Script"),
(1544000,9,0,0,0,0,100,0,7000,7000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - On Script - Say Line 0"),
(1544000,9,1,0,0,0,100,0,4000,4000,0,0,53,0,15440,0,0,0,2,1,0,0,0,0,0,0,0,"Captain Blackanvil - On Script - Start Waypoint"),
(1544000,9,2,0,0,0,100,0,1000,1000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - On Script - Say Line 1"),
(1544001,9,0,0,0,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - On Script - Say Line 2"),
(1544001,9,1,0,0,0,100,0,4000,4000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - On Script - Say Line 3"),
(1544002,9,0,0,0,0,100,0,0,0,0,0,82,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - On Script - Add Npc Flag 'Questgiver'"),
(1544002,9,1,0,0,0,100,0,120000,120000,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Captain Blackanvil - On Script - Despawn");

DELETE FROM waypoints WHERE entry=15440;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z) VALUES
(15440, 1, -7169.92, 1384.67, 2.91995),
(15440, 2, -7177.31, 1393.31, 2.60589);

-- Texts
DELETE FROM creature_text WHERE CreatureID IN (15443, 15441, 15440);
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(15441,0,0,"Something big's coming out from the hive, ma'am. Headed straight for us.",12,0,100,0,0,0,10973,0,"Ironforge Brigade Rifleman"),
(15441,1,0,"Yes, Ma'am!",12,0,100,66,0,0,10975,0,"Ironforge Brigade Rifleman"),
(15441,2,0,"Captain! Lieutenant Stouthammer requests your presence! The enemy is approaching, sir!",12,0,100,66,0,0,10976,0,"Ironforge Brigade Rifleman"),
(15443,0,0,"Soldier, call Captain Blackanvil at once!",12,0,100,25,0,0,10974,0,"Janela Stouthammer"),
(15440,0,0,"Aye, lads! Things are about to get quite ugly.",14,0,100,5,0,0,10967,0,"Captain Blackanvil"),
(15440,1,0,"Looks like it's going to be one of those days.",14,0,100,0,0,0,10968,0,"Captain Blackanvil"),
(15440,2,0,"I should've grabbed a bigger sword.",14,0,100,0,0,0,10969,0,"Captain Blackanvil"),
(15440,3,0,"Footmen, make a line!",14,0,100,25,0,0,10970,0,"Captain Blackanvil");

-- Arcanist Nozzlespring
UPDATE creature_template SET AIName="SmartAI" WHERE entry=15444;
DELETE FROM smart_scripts WHERE entryorguid=15444 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
(15444,0,0,0,0,0,100,0,0,0,3000,5000,11,13375,64,0,0,0,0,2,0,0,0,0,0,0,0,"Arcanist Nozzlespring - In Combat - Cast 'Fireball'"),
(15444,0,1,0,0,0,100,0,6000,9000,14000,20000,11,15790,64,0,0,0,0,2,0,0,0,0,0,0,0,"Arcanist Nozzlespring - In Combat - Cast 'Arcane Missiles'");

[ZenoX92]

I must say that I'm probably missing some minor stuff here, since I couldn't find much info about this event. So, maybe we should wait to sniff more data from WoW Classic? What do you think, @Killyana?

[Killyana]

If this quests works correctly with this scripts, we can push, and leave it open with the tag priority cosmetic.

[ZenoX92]

That sounds good. :)