Trinitycore: [3.3.5a] [FIX/Quest] Preparations for War

[Hitox]

You cant ride on Skybreaker Cloudbuster.
But now you can select the gosip only when you have the quest completed.

-- [WIP] Preparations for War by Hitox [A/H]

-- Sky-Reaver Klum

-- Fix gosip option 
DELETE FROM `gossip_menu_option` WHERE `menu_id`='10026';
INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES
(10026,1,0,'Take me to the ship.',1,1,0,0,0,0,'');

-- Cast ship
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (31085,31085*100);
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
(31085,0,0,1,62,0,100,0,10026,1,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sky-Reaver Klum - On Gossip Select - Set phase 1'),
(31085,0,1,0,61,1,100,0,0,0,0,0,80,31085*100,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sky-Reaver Klum - Linked with event 0 - Run Script"),
(31085*100,9,0,0,0,1,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Sky-Reaver Klum - On Script - Close Gossip"),
(31085*100,9,1,0,0,1,100,0,0,0,0,0,11,58352,0,0,0,0,0,7,0,0,0,0,0,0,0,"Sky-Reaver Klum - On Script - Cast 58352");

-- Officer Van Rossem

-- Cast ship
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (31081,31081*100);
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
(31081,0,0,1,62,0,100,0,10025,1,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sky-Reaver Klum - On Gossip Select - Set phase 1'),
(31081,0,1,0,61,1,100,0,0,0,0,0,80,31081*100,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sky-Reaver Klum - Linked with event 0 - Run Script"),
(31081*100,9,0,0,0,1,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Sky-Reaver Klum - On Script - Close Gossip"),
(31081*100,9,1,0,0,1,100,0,0,0,0,0,11,58349,0,0,0,0,0,7,0,0,0,0,0,0,0,"Sky-Reaver Klum - On Script - Cast 58349");

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (10026,10025);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(15,10026,1,0,0,28,0,13419,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player has taken quest Preparations for War'), -- Horde
(15,10025,1,0,0,28,0,13418,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player has taken quest Preparations for War'); -- Allianz

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[nerv234]

And you think the cast of spell is enough? You need to script a vehicle.

[Vincent-Michael]

vehicle id is wrong

[Vincent-Michael]

[3] UpdateType: CreateObject1
[3] GUID: Full: 0xF550007779336A0D Type: Vehicle Entry: 30585 Low: 3369485
[3] Object Type: Unit (3)
[3] Update Flags: Living, StationaryObject, Vehicle (224)
[3] Movement Flags: Forward, DisableGravity, CanFly, SplineEnabled (150995969)
[3] Extra Movement Flags: PreventStrafe, PreventJumping (3)
[3] Time: -415719636
[3] Position: X: 5876.621 Y: 559.5497 Z: 690.8501 O: 0.9010474
[3] Fall Time: 0
[3] Walk Speed: 30
[3] Run Speed: 30
[3] RunBack Speed: 4.5
[3] Swim Speed: 4.722222
[3] SwimBack Speed: 2.5
[3] Turn Speed: 19.6
[3] Fly Speed: 4.5
[3] FlyBack Speed: 1.047
[3] Pitch Speed: 1.047
[3] Spline Flags: Flying (8192)
[3] Spline Time: 3644
[3] Spline Full Time: 57318
[3] Spline Unk Int32 1: 143014605
[3] Spline Duration Multiplier: 1
[3] Spline Unit Interval: 1
[3] Spline Unk Float 2: 0
[3] Spline Height Time: 0
[3] [0] Spline Waypoint: X: 5837.79 Y: 477.5764 Z: 658.5851
[3] [1] Spline Waypoint: X: 5837.367 Y: 478.4823 Z: 658.5851
[3] [2] Spline Waypoint: X: 5836.953 Y: 475.4076 Z: 660.1669
[3] [3] Spline Waypoint: X: 5835.361 Y: 490.0929 Z: 669.2502
[3] [4] Spline Waypoint: X: 5845.597 Y: 505.7655 Z: 677.8998
[3] [5] Spline Waypoint: X: 5865.832 Y: 544.756 Z: 689.6674
[3] [6] Spline Waypoint: X: 5897.429 Y: 586.1177 Z: 689.6674
[3] [7] Spline Waypoint: X: 5936.385 Y: 642.625 Z: 682.4179
[3] [8] Spline Waypoint: X: 5954.68 Y: 688.5653 Z: 678.1407
[3] [9] Spline Waypoint: X: 5987.017 Y: 725.1281 Z: 673.5298
[3] [10] Spline Waypoint: X: 6055.089 Y: 766.5753 Z: 663.0575
[3] [11] Spline Waypoint: X: 6077.21 Y: 796.1387 Z: 663.0575
[3] [12] Spline Waypoint: X: 6089.871 Y: 824.1841 Z: 663.0575
[3] [13] Spline Waypoint: X: 6133.36 Y: 911.2333 Z: 642.3085
[3] [14] Spline Waypoint: X: 6187.39 Y: 959.5966 Z: 625.03
[3] [15] Spline Waypoint: X: 6346.116 Y: 1060.051 Z: 631.3358
[3] [16] Spline Waypoint: X: 6466.611 Y: 1107.176 Z: 640.8912
[3] [17] Spline Waypoint: X: 6626.671 Y: 1136.814 Z: 639.6691
[3] [18] Spline Waypoint: X: 6733.844 Y: 1153.338 Z: 637.0303
[3] [19] Spline Waypoint: X: 6835.574 Y: 1203.639 Z: 642.9744
[3] [20] Spline Waypoint: X: 6981.921 Y: 1218.922 Z: 646.2798
[3] [21] Spline Waypoint: X: 7059.858 Y: 1220.732 Z: 663.0575
[3] [22] Spline Waypoint: X: 7204.823 Y: 1261.922 Z: 719.5843
[3] [23] Spline Waypoint: X: 7204.823 Y: 1261.922 Z: 719.5843
[3] Spline Mode: CatmullRom (1)
[3] Spline Endpoint: X: 7204.823 Y: 1261.922 Z: 719.5843
[3] Vehicle ID: 248
[3] Vehicle Orientation: 0.4375756
[3] OBJECT_FIELD_GUID: 2033412621/5.822326E+34
[3] 1: -179306377/-2.636736E+32
[3] OBJECT_FIELD_TYPE: 9/1.261169E-44
[3] OBJECT_FIELD_ENTRY: 30585/4.285871E-41
[3] OBJECT_FIELD_SCALE_X: 1065353216/1
[3] UNIT_FIELD_CREATEDBY: 50205390/3.733274E-37
[3] 17: 41943040/1.880791E-37
[3] UNIT_FIELD_BYTES_0: 16908544/2.387795E-38
[3] UNIT_FIELD_HEALTH: 12175/1.706081E-41
[3] UNIT_FIELD_POWER3: 100/1.401298E-43
[3] UNIT_FIELD_POWER4: 100/1.401298E-43
[3] UNIT_FIELD_POWER5: 1000000/1.401298E-39
[3] UNIT_FIELD_MAXHEALTH: 12175/1.706081E-41
[3] UNIT_FIELD_MAXPOWER3: 100/1.401298E-43
[3] UNIT_FIELD_MAXPOWER4: 100/1.401298E-43
[3] UNIT_FIELD_MAXPOWER5: 1000000/1.401298E-39
[3] UNIT_FIELD_LEVEL: 79/1.107026E-43
[3] UNIT_FIELD_FACTIONTEMPLATE: 2/2.802597E-45
[3] UNIT_FIELD_FLAGS: 8/1.121039E-44
[3] UNIT_FIELD_FLAGS_2: 2048/2.869859E-42
[3] UNIT_FIELD_BASEATTACKTIME: 2000/2.802597E-42
[3] UNIT_FIELD_UNK63: 2000/2.802597E-42
[3] UNIT_FIELD_BOUNDINGRADIUS: 1065353216/1
[3] UNIT_FIELD_DISPLAYID: 22720/3.18375E-41
[3] UNIT_FIELD_NATIVEDISPLAYID: 22720/3.18375E-41
[3] UNIT_MOD_CAST_SPEED: 1065353216/1
[3] UNIT_CREATED_BY_SPELL: 57418/8.045976E-41
[3] UNIT_FIELD_BYTES_2: 2305/3.229993E-42
[3] UNIT_FIELD_HOVERHEIGHT: 1065353216/1

[Hitox]

thanks @Vincent-Michael

[Hitox]

So what is wrong in this script?

I need the waypoints for entry 30470

-- [WIP] Preparations for War by Hitox [A/H]

-- Sky-Reaver Klum
-- Fix gosip option 
DELETE FROM `gossip_menu_option` WHERE `menu_id`='10026';
INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES
(10026,1,0,'Take me to the ship.',1,1,0,0,0,0,'');

-- Cast ship
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (31085,31085*100);
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
(31085,0,0,1,62,0,100,0,10026,1,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sky-Reaver Klum - On Gossip Select - Set phase 1'),
(31085,0,1,0,61,1,100,0,0,0,0,0,80,31085*100,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sky-Reaver Klum - Linked with event 0 - Run Script"),
(31085*100,9,0,0,0,1,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Sky-Reaver Klum - On Script - Close Gossip"),
(31085*100,9,1,0,0,1,100,0,0,0,0,0,11,58352,0,0,0,0,0,7,0,0,0,0,0,0,0,"Sky-Reaver Klum - On Script - Cast 58352");

-- Officer Van Rossem

-- Cast ship
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (31081,31081*100);
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
(31081,0,0,1,62,0,100,0,10025,1,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sky-Reaver Klum - On Gossip Select - Set phase 1'),
(31081,0,1,0,61,1,100,0,0,0,0,0,80,31081*100,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sky-Reaver Klum - Linked with event 0 - Run Script"),
(31081*100,9,0,0,0,1,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Sky-Reaver Klum - On Script - Close Gossip"),
(31081*100,9,1,0,0,1,100,0,0,0,0,0,11,58349,0,0,0,0,0,7,0,0,0,0,0,0,0,"Sky-Reaver Klum - On Script - Cast 58349");

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (10026,10025);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(15,10026,1,0,0,28,0,13419,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player has taken quest Preparations for War'), -- Horde
(15,10025,1,0,0,28,0,13418,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player has taken quest Preparations for War'); -- Allianz

-- summon npc [A] and [H]
SET @ENTRY_MOUNT_H := 30585;
SET @ENTRY_MOUNT_A := 30470;

UPDATE `creature_template` SET `VehicleId`=224, `Health_mod`=2.344, `minlevel`=79, `maxlevel`=79, `unit_flags`=8, `InhabitType`=4 WHERE  `entry` IN (@ENTRY_MOUNT_H,@ENTRY_MOUNT_A);

DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY_MOUNT_H,@ENTRY_MOUNT_H*100,@ENTRY_MOUNT_A,@ENTRY_MOUNT_A*100);
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
(@ENTRY_MOUNT_H, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, @ENTRY_MOUNT_H*100, 0, 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On summon - run script - ship'),
(@ENTRY_MOUNT_H*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 53, 1, @ENTRY_MOUNT_H, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 'Start wp - ship'),
(@ENTRY_MOUNT_H, 0, 2, 3, 58, 0, 100, 0, 47, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'on wp end - despawn - ship'),

(@ENTRY_MOUNT_A, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, @ENTRY_MOUNT_A*100, 0, 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On summon - run script - ship'),
(@ENTRY_MOUNT_A*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 53, 1, @ENTRY_MOUNT_A, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 'Start wp - ship'),
(@ENTRY_MOUNT_A, 0, 2, 3, 58, 0, 100, 0, 47, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'on wp end - despawn - ship');

-- Waypoints
DELETE FROM `waypoints` WHERE `entry` IN(@ENTRY_MOUNT_H,@ENTRY_MOUNT_A);
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`)
VALUES
(@ENTRY_MOUNT_H, 1, 5837.79, 477.5764, 658.5851, 'ship'),
(@ENTRY_MOUNT_H, 2, 5837.367, 478.4823, 658.5851, 'ship'),
(@ENTRY_MOUNT_H, 3, 5836.953, 475.4076, 660.1669, 'ship'),
(@ENTRY_MOUNT_H, 4, 5835.361, 490.0929, 669.2502, 'ship'),
(@ENTRY_MOUNT_H, 5, 5845.597, 505.7655, 677.8998, 'ship'),
(@ENTRY_MOUNT_H, 6, 5865.832, 544.756, 689.6674, 'ship'),
(@ENTRY_MOUNT_H, 7, 5897.429, 586.1177, 689.6674, 'ship'),
(@ENTRY_MOUNT_H, 8, 5936.385, 642.625, 682.4179, 'ship'),
(@ENTRY_MOUNT_H, 9, 5954.68, 688.5653, 678.1407, 'ship'),
(@ENTRY_MOUNT_H, 10, 5987.017, 725.1281, 673.5298, 'ship'),
(@ENTRY_MOUNT_H, 11, 6055.089, 766.5753, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 12, 6077.21, 796.1387, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 13, 6089.871, 824.1841, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 14, 6133.36, 911.2333, 642.3085, 'ship'),
(@ENTRY_MOUNT_H, 15, 6187.39, 959.5966, 625.03, 'ship'),
(@ENTRY_MOUNT_H, 16, 6346.116, 1060.051, 631.3358, 'ship'),
(@ENTRY_MOUNT_H, 17, 6466.611, 1107.176, 640.8912, 'ship'),
(@ENTRY_MOUNT_H, 18, 6626.671, 1136.814, 639.6691, 'ship'),
(@ENTRY_MOUNT_H, 19, 6733.844, 1153.338, 637.0303, 'ship'),
(@ENTRY_MOUNT_H, 20, 6835.574, 1203.639, 642.9744, 'ship'),
(@ENTRY_MOUNT_H, 21, 6981.921, 1218.922, 646.2798, 'ship'),
(@ENTRY_MOUNT_H, 22, 7059.858, 1220.732, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 23, 7204.823, 1261.922, 719.5843, 'ship'),

/*(@ENTRY_MOUNT_A, 1, 5837.79, 477.5764, 658.5851, 'ship'),
(@ENTRY_MOUNT_A, 2, 5837.367, 478.4823, 658.5851, 'ship'),
(@ENTRY_MOUNT_A, 3, 5836.953, 475.4076, 660.1669, 'ship'),
(@ENTRY_MOUNT_A, 4, 5835.361, 490.0929, 669.2502, 'ship'),
(@ENTRY_MOUNT_A, 5, 5845.597, 505.7655, 677.8998, 'ship'),
(@ENTRY_MOUNT_A, 6, 5865.832, 544.756, 689.6674, 'ship'),
(@ENTRY_MOUNT_A, 7, 5897.429, 586.1177, 689.6674, 'ship'),
(@ENTRY_MOUNT_A, 8, 5936.385, 642.625, 682.4179, 'ship'),
(@ENTRY_MOUNT_A, 9, 5954.68, 688.5653, 678.1407, 'ship'),
(@ENTRY_MOUNT_A, 10, 5987.017, 725.1281, 673.5298, 'ship'),
(@ENTRY_MOUNT_A, 11, 6055.089, 766.5753, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 12, 6077.21, 796.1387, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 13, 6089.871, 824.1841, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 14, 6133.36, 911.2333, 642.3085, 'ship'),
(@ENTRY_MOUNT_A, 15, 6187.39, 959.5966, 625.03, 'ship'),
(@ENTRY_MOUNT_A, 16, 6346.116, 1060.051, 631.3358, 'ship'),
(@ENTRY_MOUNT_A, 17, 6466.611, 1107.176, 640.8912, 'ship'),
(@ENTRY_MOUNT_A, 18, 6626.671, 1136.814, 639.6691, 'ship'),
(@ENTRY_MOUNT_A, 19, 6733.844, 1153.338, 637.0303, 'ship'),
(@ENTRY_MOUNT_A, 20, 6835.574, 1203.639, 642.9744, 'ship'),
(@ENTRY_MOUNT_A, 21, 6981.921, 1218.922, 646.2798, 'ship'),
(@ENTRY_MOUNT_A, 22, 7059.858, 1220.732, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 23, 7204.823, 1261.922, 719.5843, 'ship');*/

[nerv234]

It is more like helicopter than ship, btw. your script is wrong in the begining, the helicopter should transport you to flying ship so you need to controll position of Skybreaker/Orgrim's Hammer in Icecrown.

[Hitox]

yes, but how can i controll the position?

[Aokromes]

Anything here can be pushed?

[nerv234]

Nothing, there should be cpp script for that quest.

[Rushor]

is there actually any possibility to check the current position of the transport, if the player takes the quest and let the vehicle fly to the checked transport-position?

[Killyana]

I cannot find a solution to get a target position on the ship.

-- Preparations for War

SET @ENTRY_MOUNT_H := 30585;
SET @ENTRY_MOUNT_A := 30470;
SET @Klum:= 31085;
SET @Rossem:=31081;

UPDATE `creature_template` SET `npcflag`= 16777216, `HealthModifier`=2.344, `minlevel`=79, `maxlevel`=79, `InhabitType`=4, `AIName`='SmartAI' WHERE  `entry` IN (@ENTRY_MOUNT_H);
UPDATE `creature_template` SET `npcflag`= 16777216, `HealthModifier`=2.344, `minlevel`=79, `maxlevel`=79, `InhabitType`=4, `AIName`='SmartAI' WHERE  `entry` IN (@ENTRY_MOUNT_A);
UPDATE `creature_template` set `AIName`='SmartAI' where entry in (@Klum, @Rossem);

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` in (@ENTRY_MOUNT_H, @ENTRY_MOUNT_A);
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
(@ENTRY_MOUNT_H, 46598, 1, 0),
(@ENTRY_MOUNT_A, 46598, 1, 0);

DELETE FROM `gossip_menu_option` WHERE `menu_id` in (10026,10025);
INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`, `OptionBroadcastTextID`) VALUES
(10026,1,0,'Take me to the ship.',1,1,0,0,0,0,'',31625),
(10026,0,0,'Take me to the ship.',1,1,0,0,0,0,'',31625),
(10025,1,0,'Take me to the ship.',1,1,0,0,0,0,'',31625),
(10025,0,0,'Take me to the ship.',1,1,0,0,0,0,'',31625);

DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY_MOUNT_H;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
(@ENTRY_MOUNT_H, 0, 0, 33554432, 0, 0, '55971');

DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY_MOUNT_A ;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
(@ENTRY_MOUNT_A, 0, 0, 33554432, 0, 0, '55971');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (10026,10025);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(15,10026,1,0,0,28,0,13419,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player has taken quest Preparations for War'), -- Horde
(15,10025,1,0,0,28,0,13418,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player has taken quest Preparations for War'), -- Allianz
(15,10026,0,0,0,8,0,13419,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player finish the quest Preparations for War'), -- Horde
(15,10025,0,0,0,8,0,13418,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player finish the quest Preparations for War'); -- Allianz

DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_H AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_H*100 AND `source_type` = 9;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_A AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_A*100 AND `source_type` = 9;

DELETE FROM `smart_scripts` WHERE `entryorguid` = @Klum AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @Klum*100 AND `source_type` = 9;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @Klum*100+1 AND `source_type` = 9;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @Rossem AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @Rossem*100 AND `source_type` = 9;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @Rossem*100+1 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
(@Klum,0,0,0,62,0,100,0,10026,1,0,0,80,@Klum*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sky-Reaver Klum - On gossip select - Action list'),
(@Klum*100,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action listt - Close Gossip'),
(@Klum*100,9,1,0,0,0,100,0,0,0,0,0,11,58352,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action list - Cast 58352'),

(@Klum,0,1,0,62,0,100,0,10026,0,0,0,80,@Klum*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sky-Reaver Klum - On gossip select - Action list'),
(@Klum*100+1,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action listt - Close Gossip'),
(@Klum*100+1,9,1,0,0,0,100,0,0,0,0,0,11,58352,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action list - Cast 58352'),

(@Rossem,0,0,0,62,0,100,0,10025,1,0,0,80,@Rossem*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Officer Van Rossem - On gossip select - Action list'),
(@Rossem*100,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action listt - Close Gossip'),
(@Rossem*100,9,1,0,0,0,100,0,0,0,0,0,11,58349,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action list - Cast 58349'),

(@Rossem,0,1,0,62,0,100,0,10025,0,0,0,80,@Rossem*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Officer Van Rossem - On gossip select - Action list'),
(@Rossem*100+1,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action listt - Close Gossip'),
(@Rossem*100+1,9,1,0,0,0,100,0,0,0,0,0,11,58349,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action list - Cast 58349'),

(@ENTRY_MOUNT_H, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, @ENTRY_MOUNT_H*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - On summon - Action List'),
(@ENTRY_MOUNT_H*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - Action List - Set Fly ON'),
(@ENTRY_MOUNT_H*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 46598, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - Action List - InvokerCast'),
(@ENTRY_MOUNT_H*100, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 53, 1, @ENTRY_MOUNT_H, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - Action List - Start wp'),
(@ENTRY_MOUNT_H, 0, 1, 0, 40, 0, 100, 0, 23, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 10, 9963, 32301, 0, 0, 0, 0, 0, 'HordeV - on wp end - Go To Pos'), -- non fonctionnel
-- to be continued: despawn when position reached

(@ENTRY_MOUNT_A, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, @ENTRY_MOUNT_A*100, 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'AllyV - On summon - Action List'),
(@ENTRY_MOUNT_A*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'AllyV - Action List - Set Fly ON'),
(@ENTRY_MOUNT_A*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 46598, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'AllyV - Action List - InvokerCast'),
(@ENTRY_MOUNT_A*100, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 53, 1, @ENTRY_MOUNT_A, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'AllyV - Action List - Start wp'),
(@ENTRY_MOUNT_A, 0, 1, 0, 40, 0, 100, 0, 23, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 10, 9985, 30352, 0, 0, 0, 0, 0, 'AllyV - on wp end - Go To Pos'); -- non fonctionnel
-- to be continued: despawn when position reached

-- Waypoints
DELETE FROM `waypoints` WHERE `entry` IN(@ENTRY_MOUNT_H,@ENTRY_MOUNT_A);
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
(@ENTRY_MOUNT_H, 1, 5837.79, 477.5764, 658.5851, 'ship'),
(@ENTRY_MOUNT_H, 2, 5837.367, 478.4823, 658.5851, 'ship'),
(@ENTRY_MOUNT_H, 3, 5836.953, 475.4076, 660.1669, 'ship'),
(@ENTRY_MOUNT_H, 4, 5835.361, 490.0929, 669.2502, 'ship'),
(@ENTRY_MOUNT_H, 5, 5845.597, 505.7655, 677.8998, 'ship'),
(@ENTRY_MOUNT_H, 6, 5865.832, 544.756, 689.6674, 'ship'),
(@ENTRY_MOUNT_H, 7, 5897.429, 586.1177, 689.6674, 'ship'),
(@ENTRY_MOUNT_H, 8, 5936.385, 642.625, 682.4179, 'ship'),
(@ENTRY_MOUNT_H, 9, 5954.68, 688.5653, 678.1407, 'ship'),
(@ENTRY_MOUNT_H, 10, 5987.017, 725.1281, 673.5298, 'ship'),
(@ENTRY_MOUNT_H, 11, 6055.089, 766.5753, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 12, 6077.21, 796.1387, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 13, 6089.871, 824.1841, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 14, 6133.36, 911.2333, 642.3085, 'ship'),
(@ENTRY_MOUNT_H, 15, 6187.39, 959.5966, 625.03, 'ship'),
(@ENTRY_MOUNT_H, 16, 6346.116, 1060.051, 631.3358, 'ship'),
(@ENTRY_MOUNT_H, 17, 6466.611, 1107.176, 640.8912, 'ship'),
(@ENTRY_MOUNT_H, 18, 6626.671, 1136.814, 639.6691, 'ship'),
(@ENTRY_MOUNT_H, 19, 6733.844, 1153.338, 637.0303, 'ship'),
(@ENTRY_MOUNT_H, 20, 6835.574, 1203.639, 642.9744, 'ship'),
(@ENTRY_MOUNT_H, 21, 6981.921, 1218.922, 646.2798, 'ship'),
(@ENTRY_MOUNT_H, 22, 7059.858, 1220.732, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 23, 7204.823, 1261.922, 719.5843, 'ship'),

(@ENTRY_MOUNT_A, 1, 5837.79, 477.5764, 658.5851, 'ship'),
(@ENTRY_MOUNT_A, 2, 5837.367, 478.4823, 658.5851, 'ship'),
(@ENTRY_MOUNT_A, 3, 5836.953, 475.4076, 660.1669, 'ship'),
(@ENTRY_MOUNT_A, 4, 5835.361, 490.0929, 669.2502, 'ship'),
(@ENTRY_MOUNT_A, 5, 5845.597, 505.7655, 677.8998, 'ship'),
(@ENTRY_MOUNT_A, 6, 5865.832, 544.756, 689.6674, 'ship'),
(@ENTRY_MOUNT_A, 7, 5897.429, 586.1177, 689.6674, 'ship'),
(@ENTRY_MOUNT_A, 8, 5936.385, 642.625, 682.4179, 'ship'),
(@ENTRY_MOUNT_A, 9, 5954.68, 688.5653, 678.1407, 'ship'),
(@ENTRY_MOUNT_A, 10, 5987.017, 725.1281, 673.5298, 'ship'),
(@ENTRY_MOUNT_A, 11, 6055.089, 766.5753, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 12, 6077.21, 796.1387, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 13, 6089.871, 824.1841, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 14, 6133.36, 911.2333, 642.3085, 'ship'),
(@ENTRY_MOUNT_A, 15, 6187.39, 959.5966, 625.03, 'ship'),
(@ENTRY_MOUNT_A, 16, 6346.116, 1060.051, 631.3358, 'ship'),
(@ENTRY_MOUNT_A, 17, 6466.611, 1107.176, 640.8912, 'ship'),
(@ENTRY_MOUNT_A, 18, 6626.671, 1136.814, 639.6691, 'ship'),
(@ENTRY_MOUNT_A, 19, 6733.844, 1153.338, 637.0303, 'ship'),
(@ENTRY_MOUNT_A, 20, 6835.574, 1203.639, 642.9744, 'ship'),
(@ENTRY_MOUNT_A, 21, 6981.921, 1218.922, 646.2798, 'ship'),
(@ENTRY_MOUNT_A, 22, 7059.858, 1220.732, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 23, 7204.823, 1261.922, 719.5843, 'ship');

[britus]

Hi, every body! I'm playing around the SAI and I think the core need some actions which dynamicly update spell_targets. I found following spells:
57554 To Icecrown Airship - Teleport to Airship (A) Force Player to Cast
56917 To Icecrown Airship - Teleport to Airship (A) -> require TARGET_DEST_NEARBY_ENTRY
and
57556 To Icecrown Airship - Teleport to Airship (H) Force Player to Cast
57417 To Icecrown Airship - Teleport to Airship (H) -> require TARGET_DEST_NEARBY_ENTRY

I think, the NPC 30352 (Skybreaker Marine) locate at gun ship alliance should have a SAI which update the target location for Alliance spells above dynamicly and also the NPC 32301 Warbringer Davos Rioht sould the same thing for the Horde spells - like SMART_ACTION_UPDATE_SPELL_LOCATION which can be called only from action list by event EVENT_UPDATE or EVENT_UPDATE_OOC. So the script above may shorten to a simple teleport or if possible to implement a full mechanic to move to a NPC position which is dynamicly updated by itself(?)

[britus]

Found target NPC for flight/teleport:
Alliance: 30559 Icecrown Flight to Airship Bunny (A) Teleport Target
Horde: 30589 Icecrown Flight to Airship Bunny (H) Teleport Target

[britus]

Agian ... I found two taxi path IDs 328 Icecrown Air Ship (A) and 329 Icecrown Air Ship (H), I think this may the solution. The Quest giver activate the taxi path for the play and than the paly should move to the tax like other taxis.

[Killyana]

The problem in this case is npcs on the ships don't give the correct position, select any of them and .gps, after that . go "coords" you will be teleported in another position not on the ship, same thing with .go crea guid (if you repeat this, you will see the position is updated continually but not with the correct position of the npc)

[Rushor]

is it possible that changing the inhabittype of the targetnpcs to 4 will help here?

i remember some vehiclecreatures which had the same problem

[Killyana]

Tested with a target with inhabittype 4 but the issue is the same.

[ghost]

If its creature, try to add him unit flag disable pathfinding

[Killyana]

Which unit_flag?

[Rushor]

CREATURE_FLAG_EXTRA_IGNORE_PATHFINDING = 0x20000000 // creature ignore pathfinding

flagextra

[ghost]

You could use that aura ID - 56852 To Icecrown - Airship (A) - Aura - Approach on your vehicle and put it on transport path and when spell finds correct target(bunnies on transport iirc), vehicle should follow that target.

edit: You can extract transport paths from taxipathnodes :>

[Killyana]

This cannot be done, teleportation to a transport is not implemented, and already tried to follow a npc on the ship but it doesn't work correctly.

[Tyrelis]

Anys news on this quests?

[quilumipe]

2019 and it's still bug, AzerothCore has this quest fixed,

[Exitare]

Then fix it, instead of complaining.

[illfated]

@quilumipe : If you have tested the AzerothCore version, maybe you could test their source and see if you can find out how it is done and if it is not too hacky to use here in the TrinityCore source.

[Rushor]

@quilumipe azerothcore is trinitycore but with older version from like 2014.

here is the fix https://github.com/azerothcore/azerothcore-wotlk/blob/master/src/server/scripts/Northrend/zone_crystalsong_forest.cpp#L31

but it requires porting a motionmaster system

[Rushor]

here we go https://github.com/Rushor/TrinityCore/commit/a41ea7d64647e93366a284e34f23099582628a72

problem is, that the vehicle drops the player BEHIND the transport and NOT above the transport. Always here:

[LKArthas]

I cannot find a solution to get a target position on the ship.

-- Preparations for War

SET @ENTRY_MOUNT_H := 30585;
SET @ENTRY_MOUNT_A := 30470;
SET @Klum:= 31085;
SET @Rossem:=31081;

UPDATE `creature_template` SET `npcflag`= 16777216, `HealthModifier`=2.344, `minlevel`=79, `maxlevel`=79, `InhabitType`=4, `AIName`='SmartAI' WHERE  `entry` IN (@ENTRY_MOUNT_H);
UPDATE `creature_template` SET `npcflag`= 16777216, `HealthModifier`=2.344, `minlevel`=79, `maxlevel`=79, `InhabitType`=4, `AIName`='SmartAI' WHERE  `entry` IN (@ENTRY_MOUNT_A);
UPDATE `creature_template` set `AIName`='SmartAI' where entry in (@Klum, @Rossem);

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` in (@ENTRY_MOUNT_H, @ENTRY_MOUNT_A);
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
(@ENTRY_MOUNT_H, 46598, 1, 0),
(@ENTRY_MOUNT_A, 46598, 1, 0);

DELETE FROM `gossip_menu_option` WHERE `menu_id` in (10026,10025);
INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`, `OptionBroadcastTextID`) VALUES
(10026,1,0,'Take me to the ship.',1,1,0,0,0,0,'',31625),
(10026,0,0,'Take me to the ship.',1,1,0,0,0,0,'',31625),
(10025,1,0,'Take me to the ship.',1,1,0,0,0,0,'',31625),
(10025,0,0,'Take me to the ship.',1,1,0,0,0,0,'',31625);

DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY_MOUNT_H;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
(@ENTRY_MOUNT_H, 0, 0, 33554432, 0, 0, '55971');

DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY_MOUNT_A ;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
(@ENTRY_MOUNT_A, 0, 0, 33554432, 0, 0, '55971');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (10026,10025);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(15,10026,1,0,0,28,0,13419,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player has taken quest Preparations for War'), -- Horde
(15,10025,1,0,0,28,0,13418,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player has taken quest Preparations for War'), -- Allianz
(15,10026,0,0,0,8,0,13419,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player finish the quest Preparations for War'), -- Horde
(15,10025,0,0,0,8,0,13418,0,0,0,0,0,'','Sky-Reaver Klum - Show gossip option only if player finish the quest Preparations for War'); -- Allianz

DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_H AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_H*100 AND `source_type` = 9;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_A AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @ENTRY_MOUNT_A*100 AND `source_type` = 9;

DELETE FROM `smart_scripts` WHERE `entryorguid` = @Klum AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @Klum*100 AND `source_type` = 9;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @Klum*100+1 AND `source_type` = 9;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @Rossem AND `source_type` = 0;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @Rossem*100 AND `source_type` = 9;
DELETE FROM `smart_scripts` WHERE `entryorguid` = @Rossem*100+1 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
(@Klum,0,0,0,62,0,100,0,10026,1,0,0,80,@Klum*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sky-Reaver Klum - On gossip select - Action list'),
(@Klum*100,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action listt - Close Gossip'),
(@Klum*100,9,1,0,0,0,100,0,0,0,0,0,11,58352,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action list - Cast 58352'),

(@Klum,0,1,0,62,0,100,0,10026,0,0,0,80,@Klum*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Sky-Reaver Klum - On gossip select - Action list'),
(@Klum*100+1,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action listt - Close Gossip'),
(@Klum*100+1,9,1,0,0,0,100,0,0,0,0,0,11,58352,0,0,0,0,0,7,0,0,0,0,0,0,0,'Sky-Reaver Klum - Action list - Cast 58352'),

(@Rossem,0,0,0,62,0,100,0,10025,1,0,0,80,@Rossem*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Officer Van Rossem - On gossip select - Action list'),
(@Rossem*100,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action listt - Close Gossip'),
(@Rossem*100,9,1,0,0,0,100,0,0,0,0,0,11,58349,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action list - Cast 58349'),

(@Rossem,0,1,0,62,0,100,0,10025,0,0,0,80,@Rossem*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Officer Van Rossem - On gossip select - Action list'),
(@Rossem*100+1,9,0,0,0,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action listt - Close Gossip'),
(@Rossem*100+1,9,1,0,0,0,100,0,0,0,0,0,11,58349,0,0,0,0,0,7,0,0,0,0,0,0,0,'Officer Van Rossem - Action list - Cast 58349'),

(@ENTRY_MOUNT_H, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, @ENTRY_MOUNT_H*100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - On summon - Action List'),
(@ENTRY_MOUNT_H*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - Action List - Set Fly ON'),
(@ENTRY_MOUNT_H*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 46598, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - Action List - InvokerCast'),
(@ENTRY_MOUNT_H*100, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 53, 1, @ENTRY_MOUNT_H, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'HordeV - Action List - Start wp'),
(@ENTRY_MOUNT_H, 0, 1, 0, 40, 0, 100, 0, 23, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 10, 9963, 32301, 0, 0, 0, 0, 0, 'HordeV - on wp end - Go To Pos'), -- non fonctionnel
-- to be continued: despawn when position reached

(@ENTRY_MOUNT_A, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, @ENTRY_MOUNT_A*100, 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'AllyV - On summon - Action List'),
(@ENTRY_MOUNT_A*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'AllyV - Action List - Set Fly ON'),
(@ENTRY_MOUNT_A*100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 46598, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'AllyV - Action List - InvokerCast'),
(@ENTRY_MOUNT_A*100, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 53, 1, @ENTRY_MOUNT_A, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'AllyV - Action List - Start wp'),
(@ENTRY_MOUNT_A, 0, 1, 0, 40, 0, 100, 0, 23, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 10, 9985, 30352, 0, 0, 0, 0, 0, 'AllyV - on wp end - Go To Pos'); -- non fonctionnel
-- to be continued: despawn when position reached

-- Waypoints
DELETE FROM `waypoints` WHERE `entry` IN(@ENTRY_MOUNT_H,@ENTRY_MOUNT_A);
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
(@ENTRY_MOUNT_H, 1, 5837.79, 477.5764, 658.5851, 'ship'),
(@ENTRY_MOUNT_H, 2, 5837.367, 478.4823, 658.5851, 'ship'),
(@ENTRY_MOUNT_H, 3, 5836.953, 475.4076, 660.1669, 'ship'),
(@ENTRY_MOUNT_H, 4, 5835.361, 490.0929, 669.2502, 'ship'),
(@ENTRY_MOUNT_H, 5, 5845.597, 505.7655, 677.8998, 'ship'),
(@ENTRY_MOUNT_H, 6, 5865.832, 544.756, 689.6674, 'ship'),
(@ENTRY_MOUNT_H, 7, 5897.429, 586.1177, 689.6674, 'ship'),
(@ENTRY_MOUNT_H, 8, 5936.385, 642.625, 682.4179, 'ship'),
(@ENTRY_MOUNT_H, 9, 5954.68, 688.5653, 678.1407, 'ship'),
(@ENTRY_MOUNT_H, 10, 5987.017, 725.1281, 673.5298, 'ship'),
(@ENTRY_MOUNT_H, 11, 6055.089, 766.5753, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 12, 6077.21, 796.1387, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 13, 6089.871, 824.1841, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 14, 6133.36, 911.2333, 642.3085, 'ship'),
(@ENTRY_MOUNT_H, 15, 6187.39, 959.5966, 625.03, 'ship'),
(@ENTRY_MOUNT_H, 16, 6346.116, 1060.051, 631.3358, 'ship'),
(@ENTRY_MOUNT_H, 17, 6466.611, 1107.176, 640.8912, 'ship'),
(@ENTRY_MOUNT_H, 18, 6626.671, 1136.814, 639.6691, 'ship'),
(@ENTRY_MOUNT_H, 19, 6733.844, 1153.338, 637.0303, 'ship'),
(@ENTRY_MOUNT_H, 20, 6835.574, 1203.639, 642.9744, 'ship'),
(@ENTRY_MOUNT_H, 21, 6981.921, 1218.922, 646.2798, 'ship'),
(@ENTRY_MOUNT_H, 22, 7059.858, 1220.732, 663.0575, 'ship'),
(@ENTRY_MOUNT_H, 23, 7204.823, 1261.922, 719.5843, 'ship'),

(@ENTRY_MOUNT_A, 1, 5837.79, 477.5764, 658.5851, 'ship'),
(@ENTRY_MOUNT_A, 2, 5837.367, 478.4823, 658.5851, 'ship'),
(@ENTRY_MOUNT_A, 3, 5836.953, 475.4076, 660.1669, 'ship'),
(@ENTRY_MOUNT_A, 4, 5835.361, 490.0929, 669.2502, 'ship'),
(@ENTRY_MOUNT_A, 5, 5845.597, 505.7655, 677.8998, 'ship'),
(@ENTRY_MOUNT_A, 6, 5865.832, 544.756, 689.6674, 'ship'),
(@ENTRY_MOUNT_A, 7, 5897.429, 586.1177, 689.6674, 'ship'),
(@ENTRY_MOUNT_A, 8, 5936.385, 642.625, 682.4179, 'ship'),
(@ENTRY_MOUNT_A, 9, 5954.68, 688.5653, 678.1407, 'ship'),
(@ENTRY_MOUNT_A, 10, 5987.017, 725.1281, 673.5298, 'ship'),
(@ENTRY_MOUNT_A, 11, 6055.089, 766.5753, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 12, 6077.21, 796.1387, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 13, 6089.871, 824.1841, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 14, 6133.36, 911.2333, 642.3085, 'ship'),
(@ENTRY_MOUNT_A, 15, 6187.39, 959.5966, 625.03, 'ship'),
(@ENTRY_MOUNT_A, 16, 6346.116, 1060.051, 631.3358, 'ship'),
(@ENTRY_MOUNT_A, 17, 6466.611, 1107.176, 640.8912, 'ship'),
(@ENTRY_MOUNT_A, 18, 6626.671, 1136.814, 639.6691, 'ship'),
(@ENTRY_MOUNT_A, 19, 6733.844, 1153.338, 637.0303, 'ship'),
(@ENTRY_MOUNT_A, 20, 6835.574, 1203.639, 642.9744, 'ship'),
(@ENTRY_MOUNT_A, 21, 6981.921, 1218.922, 646.2798, 'ship'),
(@ENTRY_MOUNT_A, 22, 7059.858, 1220.732, 663.0575, 'ship'),
(@ENTRY_MOUNT_A, 23, 7204.823, 1261.922, 719.5843, 'ship');

At WP End add an Action 29 targeting the Gunships Bunny GUID
then on follow completed, Eject, works for me ;)
Move to GUID only gets current position of the bunny NPC so as long the transport is moving it won't go to the desired position all the time, Follow is best for this case :)

[Killyana]

We must fix this issue before scripting the quest: https://github.com/TrinityCore/TrinityCore/issues/16071

[Rushor]

can you share your script @LKArthas - you can get me in discord aswell Rushor#5576 <3

[Rushor]

@LKArthas when i add that kind of action the creature just follow 50 yards behind the transport forever - never going to the actualy position of it

[Killyana]

Because the transport position is not synchronized with the server.

[illfated]

Because the transport position is not synchronized with the server.

Could that be part of the reason why the minimap shows the gunship pointing backwards (180° from the movement direction)?

[Rushor]

could be - where is the part for the server/transport synch?

[Rushor]

Edit. Tested https://github.com/Rushor/TrinityCore/commit/a41ea7d64647e93366a284e34f23099582628a72 again on current rev and it worked. Has someone changed transport scripts somewhere?

[illfated]

Edit. Tested Rushor@a41ea7d again on current rev and it worked. Has someone changed transport scripts somewhere?

I have not checked, but it sure feels like it could be something like that, or possibly orientation changes (I don't know yet).

[Killyana]

@Rushor the horde version works? the vehicle can find the transport?

[Rushor]

yes it always found the transport with my fix and player landed on the ship. i was suprised aswell since in 01.2020 it was bugged and now it worked :o

[Rushor]

But the scripts is different it works like that:

1) do pathing till icecrown
2) follow the whole path from the transport (looks weird but it is blizzlike)
3) once vehicle is flying over a trigger from the transport, vehicle will despawn and player lands on ship

[Killyana]

Pr it in this case.

[LordMagnum]

There are two stops on fly, i think for dynamic path find.

• First from dala quest giver to the wall
• from the wall to the waypoints from the ship
• last when ship come on range, calc the "landing"
  https://www.youtube.com/watch?v=DKoY6pz6-88
  https://www.youtube.com/watch?v=1cv9XnzxsQ0