DB/Spawns: add "The Relentless" Ship and Crewmembers

+ Waypoints for Armorer Kautzman and Captain Hicks
Closes #28359

1 files changed, 131 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_10_11_03_world.sql b/sql/updates/world/master/2022_10_11_03_world.sql
new file mode 100644
index 00000000000..82e1d7fda4f
--- /dev/null
+++ b/sql/updates/world/master/2022_10_11_03_world.sql
@@ -0,0 +1,131 @@
+-- The Relentless Transport to Boralus Harbor
+SET @CGUID := 850613; -- 15 required
+SET @OGUID := 501787; -- 24 required
+
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+14;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 143100, 2074, 0, 0, 0, 0, 0, 0, 0, -28.3567485809326171, -6.96379470825195312, 11.39751148223876953, 3.810218572616577148, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+1, 143103, 2074, 0, 0, 0, 0, 0, 0, 0, -21.0138702392578125, 8.72396087646484375, 10.40711116790771484, 2.34253692626953125, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+2, 143108, 2074, 0, 0, 0, 0, 0, 0, 0, -23.9956436157226562, 0.300490498542785644, 11.05834388732910156, 3.085541248321533203, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+3, 143111, 2074, 0, 0, 0, 0, 0, 0, 1, -2.68590092658996582, -7.10210514068603515, 6.180718898773193359, 0.609188377857208251, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+4, 143105, 2074, 0, 0, 0, 0, 0, 0, 1, 0.821236491203308105, 11.1654510498046875, 6.191501617431640625, 2.058152437210083007, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+5, 143106, 2074, 0, 0, 0, 0, 0, 0, 0, -12.2801513671875, 4.378171443939208984, 10.91152667999267578, 0, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+6, 143112, 2074, 0, 0, 0, 0, 0, 0, 1, -11.3444223403930664, 0.03439076617360115, 5.056095600128173828, 0.030206184834241867, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+7, 143101, 2074, 0, 0, 0, 0, 0, 0, 0, 10.55232429504394531, -2.31570172309875488, 6.187692642211914062, 3.111004590988159179, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+8, 143114, 2074, 0, 0, 0, 0, 0, 0, 0, 14.22231864929199218, 1.976284503936767578, 6.220947265625, 0, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+9, 143109, 2074, 0, 0, 0, 0, 0, 0, 1, 36.24853515625, 8.35302734375, 13.11811256408691406, 1.560265898704528808, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+10, 143110, 2074, 0, 0, 0, 0, 0, 0, 0, 33.16179275512695312, -2.73902463912963867, 6.512768268585205078, 2.287539005279541015, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+11, 143098, 2074, 0, 0, 0, 0, 0, 0, 1, 33.82763671875, 9.7607421875, 19.44762039184570312, 1.595258712768554687, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+12, 143104, 2074, 0, 0, 0, 0, 0, 0, 0, 27.82045555114746093, -4.94907808303833007, 12.92650318145751953, 1.191629528999328613, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745),
+(@CGUID+13, 143116, 2074, 0, 0, 0, 0, 0, 0, 1, 30.45102310180664062, 5.035210609436035156, 13.05871200561523437, 3.173145532608032226, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745), 
+(@CGUID+14, 143107, 2074, 0, 0, 0, 0, 0, 0, 0, 38.45831298828125, -0.120262011885643, 20.56958389282226562, 3.051386356353759765, 120, 0, 0, 22895, 0, 0, 0, 0, 0, 45745);
+
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+14;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`MountCreatureID`,`bytes1`,`bytes2`,`emote`,`aiAnimKit`,`movementAnimKit`,`meleeAnimKit`,`visibilityDistanceType`,`auras`) VALUES
+(@CGUID+0,0,0,0,0,1,0,0,0,0,0,'271087'),
+(@CGUID+1,0,0,0,0,1,69,0,0,0,0,''),
+(@CGUID+2,0,0,0,0,1,720,0,0,0,0,''),
+(@CGUID+3,0,0,0,0,1,0,16421,0,0,0,''),
+(@CGUID+4,0,0,0,0,0,714,0,0,0,0,''),
+(@CGUID+5,0,0,0,0,1,757,0,0,0,0,''),
+(@CGUID+6,0,0,0,0,0,714,0,0,0,0,''),
+(@CGUID+7,0,0,0,0,1,720,0,0,0,0,''),
+(@CGUID+8,0,0,0,0,1,0,0,0,0,0,''),
+(@CGUID+9,0,0,0,0,0,0,0,0,0,0,''),
+(@CGUID+10,0,0,0,0,0,0,0,0,0,0,'244868'),
+(@CGUID+11,0,0,0,0,0,0,0,0,0,0,'273268'),
+(@CGUID+12,0,0,0,0,0,0,0,0,0,0,'244868'),
+(@CGUID+13,0,0,0,0,0,714,0,0,0,0,''),
+(@CGUID+14,0,0,0,0,1,0,16390,0,0,0,'');
+
+-- Pathing for Armorer Kautzman Entry: 143109
+SET @NPC := @CGUID+9;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `wander_distance`=0,`MovementType`=2,`position_x`=36.200806,`position_y`=3.8103027,`position_z`=13.118113 WHERE `guid`=@NPC;
+UPDATE `creature_addon` SET `path_id`=@PATH WHERE `guid`=@NPC;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,36.200806,3.8103027,13.118113,NULL,0,0,0,100,0),
+(@PATH,2,36.190796,-1.6036987,13.118113,NULL,4000,0,0,100,0),
+(@PATH,3,36.20056,3.8101807,13.118113,NULL,0,0,0,100,0),
+(@PATH,4,36.24887,8.355347,13.118113,NULL,4000,0,0,100,0);
+
+-- Pathing for Captain Hicks Entry: 143098
+SET @NPC := @CGUID+11;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `wander_distance`=0,`MovementType`=2,`position_x`=33.959473,`position_y`=0.50927734,`position_z`=19.182081 WHERE `guid`=@NPC;
+UPDATE `creature_addon` SET `path_id`=@PATH WHERE `guid`=@NPC;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,33.959473,0.50927734,19.182081,NULL,0,0,0,100,0),
+(@PATH,2,33.777832,-4.916992,19.2878,NULL,4000,0,0,100,0),
+(@PATH,3,33.958984,0.50878906,19.182055,NULL,0,0,0,100,0),
+(@PATH,4,33.918457,6.048828,19.427113,NULL,0,0,0,100,0),
+(@PATH,5,33.827637,9.76123,19.447624,NULL,4000,0,0,100,0),
+(@PATH,6,33.918457,6.048828,19.427113,NULL,0,0,0,100,0);
+
+DELETE FROM `npc_vendor` WHERE `entry` IN (143109,143114);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(143109, 1, 180733, 0, 0, 1, 0, 0, 45745),
+(143109, 2, 183952, 0, 0, 1, 0, 0, 45745),
+(143109, 3, 163569, 0, 0, 1, 0, 0, 45745),
+(143109, 4, 160502, 0, 0, 1, 0, 0, 45745),
+(143109, 5, 6219, 0, 0, 1, 0, 0, 45745),
+(143109, 6, 2901, 0, 0, 1, 0, 0, 45745),
+(143109, 7, 5956, 0, 0, 1, 0, 0, 45745),
+(143109, 8, 2880, 0, 0, 1, 0, 0, 45745),
+(143109, 9, 3466, 0, 0, 1, 0, 0, 45745),
+(143109, 10, 160298, 0, 0, 1, 0, 0, 45745),
+(143109, 11, 18567, 0, 0, 1, 0, 0, 45745),
+(143109, 12, 3857, 0, 0, 1, 0, 0, 45745),
+(143109, 13, 163203, 0, 6426, 1, 0, 0, 45745),
+(143114, 1, 39354, 0, 0, 1, 0, 0, 45745),
+(143114, 2, 3371, 0, 0, 1, 0, 0, 45745),
+(143114, 3, 38682, 0, 0, 1, 0, 0, 45745),
+(143114, 4, 4470, 0, 0, 1, 0, 0, 45745),
+(143114, 5, 90146, 0, 0, 1, 0, 0, 45745),
+(143114, 6, 138293, 0, 0, 1, 0, 0, 45745),
+(143114, 7, 2901, 0, 0, 1, 0, 0, 45745),
+(143114, 8, 7005, 0, 0, 1, 0, 0, 45745),
+(143114, 9, 85663, 0, 0, 1, 0, 0, 45745),
+(143114, 10, 6256, 0, 0, 1, 0, 0, 45745),
+(143114, 11, 6217, 0, 0, 1, 0, 0, 45745),
+(143114, 12, 5956, 0, 0, 1, 0, 0, 45745),
+(143114, 13, 20815, 0, 0, 1, 0, 0, 45745),
+(143114, 14, 39505, 0, 0, 1, 0, 0, 45745),
+(143114, 15, 64670, 0, 0, 1, 0, 0, 45745);
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+23;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 290974, 2074, 0, 0, 0, 0, 0, -28.189798355102539, 6.735843181610107421, 11.2927865982055664, 4.791468143463134765, -0.05071926116943359, 0.034044265747070312, -0.67775344848632812, 0.732747375965118408, 120, 255, 1, 45745),
+(@OGUID+1, 279586, 2074, 0, 0, 0, 0, 0, -11.0326004028320312, -10.3330135345458984, 6.11485147476196289, 0.022991687059402465, 0, 0, 0.011495590209960937, 0.999933898448944091, 120, 255, 1, 45745),
+(@OGUID+2, 281638, 2074, 0, 0, 0, 0, 0, -5.70251417160034179, -11.6356134414672851, 6.087447166442871093, 5.334826469421386718, 0, 0, -0.45660877227783203, 0.8896675705909729, 120, 255, 1, 45745),
+(@OGUID+3, 290974, 2074, 0, 0, 0, 0, 0, 3.855296611785888671, -2.92783737182617187, 6.698000907897949218, 5.513477802276611328, -0.66702175140380859, 0.268473625183105468, -0.26242828369140625, 0.64353346824645996, 120, 255, 1, 45745),
+(@OGUID+4, 290974, 2074, 0, 0, 0, 0, 0, 2.983249902725219726, -2.99649357795715332, 6.101009368896484375, 5.085351467132568359, 0, 0, -0.56374835968017578, 0.825946629047393798, 120, 255, 1, 45745),
+(@OGUID+5, 293759, 2074, 0, 0, 0, 0, 0, 9.391781806945800781, 4.77878570556640625, 6.098782539367675781, 0.020655045285820961, 0, 0, 0.010327339172363281, 0.999946653842926025, 120, 255, 1, 45745),
+(@OGUID+6, 290974, 2074, 0, 0, 0, 0, 0, 12.95518970489501953, 4.09367227554321289, 12.38430690765380859, 5.880401134490966796, -0.68075418472290039, 0.099394798278808593, -0.1810007095336914, 0.702803790569305419, 120, 255, 1, 45745),
+(@OGUID+7, 290974, 2074, 0, 0, 0, 0, 0, 12.22782611846923828, 5.520253658294677734, 11.77816200256347656, 3.730464458465576171, 0.042165756225585937, -0.03092002868652343, -0.95603752136230468, 0.288545101881027221, 120, 255, 1, 45745),
+(@OGUID+8, 297570, 2074, 0, 0, 0, 0, 0, 17.65191268920898437, -5.5069427490234375, 6.182915687561035156, 6.047565937042236328, 0, 0, -0.11753749847412109, 0.993068456649780273, 120, 255, 1, 45745),
+(@OGUID+9, 297571, 2074, 0, 0, 0, 0, 0, 17.83073043823242187, -7.42013740539550781, 6.184665203094482421, 0.663221180438995361, 0, 0, 0.325566291809082031, 0.945519208908081054, 120, 255, 1, 45745),
+(@OGUID+10, 290974, 2074, 0, 0, 0, 0, 0, 11.93265533447265625, 4.030199050903320312, 11.7833261489868164, 4.748131752014160156, 0.020870208740234375, -0.04834461212158203, -0.69268321990966796, 0.719317197799682617, 120, 255, 1, 45745),
+(@OGUID+11, 297568, 2074, 0, 0, 0, 0, 0, 24.44184303283691406, -7.41666650772094726, 6.293860435485839843, 1.239181041717529296, 0, 0, 0.580701828002929687, 0.814116358757019042, 120, 255, 1, 45745),
+(@OGUID+12, 297569, 2074, 0, 0, 0, 0, 0, 26.290802001953125, -4.99999952316284179, 6.324167728424072265, 4.057891845703125, 0, 0, -0.89687252044677734, 0.442289173603057861, 120, 255, 1, 45745),
+(@OGUID+13, 297572, 2074, 0, 0, 0, 0, 0, 19.69184303283691406, -7.2256927490234375, 6.224917888641357421, 2.434734821319580078, 0, 0, 0.938191413879394531, 0.346116840839385986, 120, 255, 1, 45745),
+(@OGUID+14, 297573, 2074, 0, 0, 0, 0, 0, 26.42448043823242187, -6.89236164093017578, 6.325334548950195312, 2.434734821319580078, 0, 0, 0.938191413879394531, 0.346116840839385986, 120, 255, 1, 45745),
+(@OGUID+15, 297574, 2074, 0, 0, 0, 0, 0, 26.90191459655761718, 8.975694656372070312, 6.335384845733642578, 4.127703666687011718, 0, 0, -0.8808908462524414, 0.473319470882415771, 120, 255, 1, 45745),
+(@OGUID+16, 293775, 2074, 0, 0, 0, 0, 0, 28.55030632019042968, -9.65917110443115234, 12.8957672119140625, 1.535974383354187011, 0, 0, 0.694688796997070312, 0.719310402870178222, 120, 255, 1, 45745),
+(@OGUID+17, 297565, 2074, 0, 0, 0, 0, 0, 24.80295753479003906, 8.652777671813964843, 6.296417236328125, 5.925393581390380859, 0, 0, -0.17794322967529296, 0.984040737152099609, 120, 255, 1, 45745),
+(@OGUID+18, 297566, 2074, 0, 0, 0, 0, 0, 26.81163787841796875, 6.826388835906982421, 6.332414627075195312, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 45745),
+(@OGUID+19, 297567, 2074, 0, 0, 0, 0, 0, 24.91233253479003906, 6.583333969116210937, 6.301306724548339843, 0.811578273773193359, 0, 0, 0.394743919372558593, 0.918791174888610839, 120, 255, 1, 45745),
+(@OGUID+20, 293759, 2074, 0, 0, 0, 0, 0, 29.88576316833496093, -10.9288759231567382, 12.95425128936767578, 1.569266915321350097, 0, 0, 0.70656585693359375, 0.707647323608398437, 120, 255, 1, 45745),
+(@OGUID+21, 297562, 2074, 0, 0, 0, 0, 0, 39.26128387451171875, 1.47569429874420166, 13.0307769775390625, 5.785771369934082031, 0, 0, -0.24615097045898437, 0.969231486320495605, 120, 255, 1, 45745),
+(@OGUID+22, 297563, 2074, 0, 0, 0, 0, 0, 39.54948043823242187, -0.97569453716278076, 13.0307769775390625, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 120, 255, 1, 45745),
+(@OGUID+23, 297564, 2074, 0, 0, 0, 0, 0, 42.76128387451171875, -0.07638958096504211, 13.03080463409423828, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 45745);
+
+DELETE FROM `transports` WHERE `guid` IN (2,31);
+INSERT INTO `transports` (`guid`,`entry`,`name`,`phaseUseFlags`,`phaseid`,`phasegroup`,`ScriptName`) VALUES
+(31,294556,'Stormwind Harbor and Boralus Harbor ("Ship (The Relentless)")',0,0,0,'');
+
+DELETE FROM `gameobject_template_addon` WHERE `entry`=294556;
+INSERT INTO `gameobject_template_addon` (`entry`,`faction`,`flags`,`mingold`,`maxgold`,`artkit0`,`artkit1`,`artkit2`,`artkit3`,`artkit4`,`WorldEffectID`,`AIAnimKitID`) VALUES
+(294556,0,1048616,0,0,0,0,0,0,0,0,0);