diff options
| -rw-r--r-- | sql/updates/world/master/2024_01_26_00_world.sql | 557 | ||||
| -rw-r--r-- | src/server/scripts/ExilesReach/zone_exiles_reach.cpp | 530 |
2 files changed, 1087 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_01_26_00_world.sql b/sql/updates/world/master/2024_01_26_00_world.sql new file mode 100644 index 00000000000..e6a5aee6a20 --- /dev/null +++ b/sql/updates/world/master/2024_01_26_00_world.sql @@ -0,0 +1,557 @@ +-- Set by TC Devs +-- Fourteen new creature spawns +SET @GUID := 8000021; + +-- Add missing Scout-o-Matic 5000 and Choppy Booster Mk. 5 spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @GUID AND @GUID+13; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `ScriptName`, `StringId`, `VerifiedBuild`) VALUES +(@GUID,156518,2175,10424,10588,'0',0,13766,0,-1,0,0,107.87153,-2414.177,95.44844,0,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'','scout_o_matic',52649), +(@GUID+1,167027,2175,10424,10588,'0',0,15319,0,-1,0,0,107.87153,-2414.177,95.44844,0,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'','choppy_booster',52649), +(@GUID+2,156799,2175,10424,10529,'0',0,13784,0,-1,0,0,230.82812,-2297.0747,83.816696,1.35622859,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'',NULL,52649), -- Henry Garrick +(@GUID+3,167126,2175,10424,10529,'0',0,15327,0,-1,0,0,230.82812,-2297.0747,83.816696,1.35622859,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'',NULL,52649), -- Shuja Grimaxe +(@GUID+4,154300,2175,10424,10588,'0',0,13785,0,-1,0,0,95.635414,-2418.3716,91.11979,6.28133726,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'',NULL,52649), -- Bjorn Stouthands +(@GUID+5,156800,2175,10424,10588,'0',0,13785,0,-1,0,0,93.15278,-2417.3733,91.79341,6.0155663,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'',NULL,52649), -- Quartermaster Richter +(@GUID+6,156801,2175,10424,10588,'0',0,13785,0,-1,0,0,95.94097,-2421.5105,91.0058,0.80344587,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'',NULL,52649), -- Private Cole +(@GUID+7,156803,2175,10424,10588,'0',0,13785,0,-1,0,0,95.66493,-2423.9133,91.00101,0.4256764,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'',NULL,52649), -- Alaria +(@GUID+8,156804,2175,10424,10588,'0',0,13785,0,-1,0,0,100.55903,-2424.5972,90.237305,1.5070167,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'',NULL,52649), -- Kee-La +(@GUID+9,167909,2175,10424,10588,'0',0,15553,0,-1,0,0,95.66493,-2423.9133,90.917786,0.425676465,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'','wonsa_darkmaul_plains',52649), -- Won'sa +(@GUID+10,167910,2175,10424,10588,'0',0,15553,0,-1,0,0,100.55903,-2424.5972,90.15397,1.507016778,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'','bo_darkmaul_plains',52649), -- Bo +(@GUID+11,167911,2175,10424,10588,'0',0,15553,0,-1,0,0,95.635414,-2418.3716,91.03652,6.28133726,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'','lana_darkmaul_plains',52649), -- Lana Jordan +(@GUID+12,167912,2175,10424,10588,'0',0,15553,0,-1,0,0,93.15278,-2417.3733,91.710266,6.0155663,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'','jinhake_darkmaul_plains',52649), -- Provisoner Jin'hake +(@GUID+13,167913,2175,10424,10588,'0',0,15553,0,-1,0,0,95.94097,-2421.5105,90.92242,0.8034459,7200,0,0,1,0,0,NULL,NULL,NULL,NULL,'','throg_darkmaul_plains',52649); -- Grunt Throg + +UPDATE `creature` SET `StringId`= "lindie_springstock_plains" WHERE `guid`=8000019; +UPDATE `creature` SET `StringId`= "cork_fizzlepop_plains" WHERE `guid`=8000016; + +UPDATE `creature_template` SET `npcflag`=16777216 WHERE entry IN (156518,167027); +UPDATE `creature_template` SET `VehicleId`=6843, `ScriptName`="npc_scoutomatic_5000" WHERE `entry`=156526; +UPDATE `creature_template` SET `VehicleId`=6843, `ScriptName`="npc_choppy_booster" WHERE `entry`=167905; +UPDATE `creature_template` SET `ScriptName`="npc_lindie_springstock_plains" WHERE `entry`=149899; +UPDATE `creature_template` SET `ScriptName`="npc_cork_fizzlepop_plains" WHERE `entry`=167019; +UPDATE `creature_template` SET `ScriptName`="npc_horde_crew_plains" WHERE `entry` IN (167909,167910,167911,167912,167913); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (156799,167126); +INSERT INTO `creature_template_addon` (`entry`,`visibilityDistanceType`,`auras`) VALUES +(156799,3, '305513 325408'), -- Henry Garrick +(167126,3, '305513 325408'); -- Shuja Grimaxe + +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (156518,167027,156799,167126,156526,167905); +INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`,`Chase`,`Random`,`InteractionPauseTimer`) VALUES +(156518,0,0,1,0,0,0,0), -- Scout-o-Matic 5000 +(167027,0,0,1,0,0,0,0), -- Choppy Booster Mk. 5 +(156799,0,0,1,0,0,0,0), -- Henry Garrick +(167126,0,0,1,0,0,0,0), -- Shuja Grimaxe +(156526,0,0,1,0,0,0,0), -- Scout-o-Matic 5000 +(167905,0,0,1,0,0,0,0); -- Choppy Booster Mk. 5 + +-- Quest data +DELETE FROM `creature_queststarter` WHERE `id`=149899 AND `quest`=55193; +DELETE FROM `creature_queststarter` WHERE `id`=167019 AND `quest`=59940; +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(149899, 55193, 52649), -- The Scout-o-Matic 5000 accept from Lindie Springstock +(167019, 59940, 52649); -- The Choppy Booster Mk. 5 accept from Cork Fizzlepop + +DELETE FROM `creature_questender` WHERE `id`=149899 AND `quest`=55193; +DELETE FROM `creature_questender` WHERE `id`=167019 AND `quest`=59940; +INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES +(149899, 55193, 52649), -- The Scout-o-Matic 5000 turn in to Lindie Springstock +(167019, 59940, 52649); -- The Choppy Booster Mk. 5 turn in to Cork Fizzlepop + +-- Condition for source Quest available condition type Quest rewarded +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceGroup`=0 AND `SourceEntry` IN (55193,59940) AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 55193, 0, 0, 8, 0, 55186, 0, 0, 0, 0, 0, '', 'AND0 Quest The Scout-o-Matic 5000 available if quest Down with the Quilboar has been rewarded Alliance.'), +(19, 0, 55193, 0, 0, 8, 0, 55184, 0, 0, 0, 0, 0, '', 'AND0 Quest The Scout-o-Matic 5000 available if quest Forbidden Quilboar Necromancy has been rewarded Alliance.'), +(19, 0, 59940, 0, 0, 8, 0, 59938, 0, 0, 0, 0, 0, '', 'AND0 Quest The Choppy Booster Mk. 5 available if quest Down with the Quilboar has been rewarded Horde.'), +(19, 0, 59940, 0, 0, 8, 0, 59939, 0, 0, 0, 0, 0, '', 'AND0 Quest The Choppy Booster Mk. 5 available if quest Forbidden Quilboar Necromancy has been rewarded Horde.'); + +DELETE FROM `quest_template_addon` WHERE `ID` IN (55193,59940); +INSERT INTO `quest_template_addon` (`ID`,`AllowableClasses`,`PrevQuestID`,`NextQuestID`,`ScriptName`) VALUES +(55193,0,0,0,'quest_scout_o_matic_5000'), -- Alliance +(59940,0,0,0,'quest_choppy_booster_mk5'); -- Horde + +-- Conversation data for create Scout-O-Matic 5000 +DELETE FROM `conversation_actors` WHERE `ConversationId` IN (12078); +INSERT INTO `conversation_actors` (`ConversationId`,`ConversationActorId`,`ConversationActorGuid`,`Idx`,`CreatureId`,`CreatureDisplayInfoId`,`NoActorObject`,`ActivePlayerObject`,`VerifiedBuild`) VALUES +(12078,71345,0,0,0,0,0,0,52649), -- Lindie Springstock +(12078,71344,0,1,0,0,0,0,52649); -- Scout-O-Matic 5000 + +DELETE FROM `conversation_line_template` WHERE `Id` IN (29391,31498,29394,29392,29395,29393); +INSERT INTO `conversation_line_template` (`Id`,`UiCameraID`,`ActorIdx`,`Flags`,`VerifiedBuild`) VALUES +(29391,0,0,0,52649), +(31498,0,0,1,52649), +(29394,0,1,1,52649), +(29392,0,0,0,52649), +(29395,0,1,1,52649), +(29393,0,0,1,52649); + +DELETE FROM `conversation_template` WHERE `Id` IN (12078); +INSERT INTO `conversation_template` (`Id`,`FirstLineId`,`TextureKitId`,`ScriptName`,`VerifiedBuild`) VALUES +(12078,29391,0,'',52649); + +-- Conversation data for create Choppy Booster MK 5 +DELETE FROM `conversation_actors` WHERE `ConversationId` IN (14516); +INSERT INTO `conversation_actors` (`ConversationId`,`ConversationActorId`,`ConversationActorGuid`,`Idx`,`CreatureId`,`CreatureDisplayInfoId`,`NoActorObject`,`ActivePlayerObject`,`VerifiedBuild`) VALUES +(14516,76337,0,0,0,0,0,0,52649), -- Cork Fizzlepop +(14516,71344,0,1,0,0,0,0,52649); -- Choppy Booster MK 5 + +DELETE FROM `conversation_line_template` WHERE `Id` IN (36351,36352,36353,36354,36355,36356); +INSERT INTO `conversation_line_template` (`Id`,`UiCameraID`,`ActorIdx`,`Flags`,`VerifiedBuild`) VALUES +(36351,0,0,0,52649), +(36352,0,0,1,52649), +(36353,0,1,1,52649), +(36354,0,0,0,52649), +(36355,0,1,1,52649), +(36356,0,0,1,52649); + +DELETE FROM `conversation_template` WHERE `Id` IN (14516); +INSERT INTO `conversation_template` (`Id`,`FirstLineId`,`TextureKitId`,`ScriptName`,`VerifiedBuild`) VALUES +(14516,36351,0,'',52649); + +-- Conversation data for ride Scout-O-Matic 5000 +DELETE FROM `conversation_actors` WHERE `ConversationId` IN (12083,12084); +INSERT INTO `conversation_actors` (`ConversationId`,`ConversationActorId`,`ConversationActorGuid`,`Idx`,`CreatureId`,`CreatureDisplayInfoId`,`NoActorObject`,`ActivePlayerObject`,`VerifiedBuild`) VALUES +(12083,71350,0,0,149899,91998,0,0,52649), -- Lindie Springstock +(12083,71352,0,1,156280,92690,0,0,52649), -- Captain Garrick +(12084,71350,0,0,149899,91998,0,0,52649), -- Lindie Springstock +(12084,71352,0,1,156280,92690,0,0,52649); -- Captain Garrick + +DELETE FROM `conversation_line_template` WHERE `Id` IN (29419,31507,29421,29422,29420,34207,29425,29424,29426); +INSERT INTO `conversation_line_template` (`Id`,`UiCameraID`,`ActorIdx`,`Flags`,`VerifiedBuild`) VALUES +(29419,94,0,0,52649), +(31507,85,1,0,52649), +(29421,94,0,0,52649), +(29422,94,0,0,52649), +(29420,85,1,0,52649), +(34207,95,0,0,52649), +(29425,84,1,0,52649), +(29424,95,0,0,52649), +(29426,84,1,0,52649); + +DELETE FROM `conversation_template` WHERE `Id` IN (12083,12084); +INSERT INTO `conversation_template` (`Id`,`FirstLineId`,`TextureKitId`,`ScriptName`,`VerifiedBuild`) VALUES +(12083,29419,0,'',52649), +(12084,34207,0,'',52649); + +-- Conversation data for ride The Choppy Booster Mk. 5 +DELETE FROM `conversation_actors` WHERE `ConversationId` IN (14517,14520); +INSERT INTO `conversation_actors` (`ConversationId`,`ConversationActorId`,`ConversationActorGuid`,`Idx`,`CreatureId`,`CreatureDisplayInfoId`,`NoActorObject`,`ActivePlayerObject`,`VerifiedBuild`) VALUES +(14517,76341,0,0,167019,96314,0,0,52649), -- Cork Fizzlepop +(14517,76340,0,1,167021,91669,0,0,52649), -- Warlord Grimaxe +(14520,76341,0,0,167019,96314,0,0,52649), -- Cork Fizzlepop +(14520,76340,0,1,167021,91669,0,0,52649); -- Warlord Grimaxe + +DELETE FROM `conversation_line_template` WHERE `Id` IN (36357,36358,36359,36360,36361,36369,36370,36371,36372); +INSERT INTO `conversation_line_template` (`Id`,`UiCameraID`,`ActorIdx`,`Flags`,`VerifiedBuild`) VALUES +(36357,114,0,0,52649), +(36358,89,1,0,52649), +(36359,114,0,0,52649), +(36360,114,0,0,52649), +(36361,89,1,0,52649), +(36369,115,0,0,52649), +(36370,88,1,0,52649), +(36371,115,0,0,52649), +(36372,88,1,0,52649); + +DELETE FROM `conversation_template` WHERE `Id` IN (14517,14520); +INSERT INTO `conversation_template` (`Id`,`FirstLineId`,`TextureKitId`,`ScriptName`,`VerifiedBuild`) VALUES +(14517,36357,0,'',52649), +(14520,36369,0,'',52649); + +-- Phase Area +DELETE FROM `phase_area` WHERE `AreaId`=10424 AND `PhaseId` IN (13784,15327); +DELETE FROM `phase_area` WHERE `AreaId`=10588 AND `PhaseId` IN (13766,15319,13785,15553); +INSERT INTO `phase_area` (`AreaId`,`PhaseId`,`Comment`) VALUES +(10588,13766, 'Cosmetic - NPE - See The Scout-o-Matic 5000 at Plains'), +(10588,15319, 'Cosmetic - NPE - See The Choppy Booster Mk. 5 at Plains'), +(10424,13784, 'Cosmetic - NPE - See Henry Garrick at Ogre Ruins'), +(10424,15327, 'Cosmetic - NPE - See Shuja Grimaxe at Ogre Ruins'), +(10588,13785, 'Cosmetic - NPE - See Alliance crew at Darkmaul Plains'), +(10588,15553, 'Cosmetic - NPE - See Horde crew at Darkmaul Plains'); + +-- Phase Names +DELETE FROM `phase_name` WHERE `ID` IN (13766,15319,13784,15327,13785,15553); +INSERT INTO `phase_name` (`ID`,`Name`) VALUES +(13766,'Cosmetic - NPE - See The Scout-o-Matic 5000 at Plains'), +(15319,'Cosmetic - NPE - See The Choppy Booster Mk. 5 at Plains'), +(13784,'Cosmetic - NPE - See Henry Garrick at Ogre Ruins'), +(15327,'Cosmetic - NPE - See Shuja Grimaxe at Ogre Ruins'), +(13785,'Cosmetic - NPE - See Alliance crew at Darkmaul Plains'), +(15553,'Cosmetic - NPE - See Horde crew at Darkmaul Plains'); + +-- NPE missing from these names +UPDATE `phase_name` SET `Name`='Cosmetic - NPE - See Lindie Springstock at Darkmaul Plains' WHERE `ID`=13776; +UPDATE `phase_name` SET `Name`='Cosmetic - NPE - See Captian Garrick at Darkmaul Plains' WHERE `ID`=13779; +UPDATE `phase_name` SET `Name`='Cosmetic - NPE - See Austin Huxworth at Darkmaul Plains' WHERE `ID`=13780; +UPDATE `phase_name` SET `Name`='Cosmetic - NPE - See bound Lightspawn' WHERE `ID`=13878; + +-- Phase Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup` IN (13784,15327) AND `SourceEntry`=10424; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup` IN (13766,15319,13785,15553) AND `SourceEntry`=10588; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(26,13766,10588, 0, 0, 47, 0, 55193, 74, 0, 0, 0, 0, '', 'See The Scout-o-Matic 5000 at Plains if quest The Scout-o-Matic 5000 is inprogress | completed | rewarded Alliance.'), +(26,13766,10588, 0, 0, 1, 0, 305522, 0, 0, 1, 0, 0, '', 'See The Scout-o-Matic 5000 at Plains if player doses not have aura 305522.'), +(26,15319,10588, 0, 0, 47, 0, 59940, 74, 0, 0, 0, 0, '', 'See The Choppy Booster Mk. 5 at Plains if quest The Choppy Booster Mk. 5 is inprogress | completed | rewarded Horde.'), +(26,15319,10588, 0, 0, 1, 0, 326625, 0, 0, 1, 0, 0, '', 'See The Choppy Booster Mk. 5 at Plains if player doses not have aura 326625.'), +(26,13784,10424, 0, 0, 47, 0, 55186, 64, 0, 0, 0, 0, '', 'AND0 See Henry Garrick at Ogre Ruins if quest Down with the Quilboar has been rewarded Alliance.'), +(26,13784,10424, 0, 0, 47, 0, 55184, 64, 0, 0, 0, 0, '', 'AND0 See Henry Garrick at Ogre Ruins if quest Forbidden Quilboar Necromancy has been rewarded Alliance.'), +(26,15327,10424, 0, 0, 47, 0, 59938, 64, 0, 0, 0, 0, '', 'AND0 See Shuja Grimaxe at Ogre Ruins if quest Down with the Quilboar has been rewarded Horde.'), +(26,15327,10424, 0, 0, 47, 0, 59939, 64, 0, 0, 0, 0, '', 'AND0 See Shuja Grimaxe at Ogre Ruins if quest Forbidden Quilboar Necromancy has been rewarded Horde.'), +(26,13785,10588, 0, 0, 47, 0, 55193, 66, 0, 0, 0, 0, '', 'See Alliance Crew at Plains if quest The Scout-o-Matic 5000 is completed | rewarded Alliance.'), +(26,15553,10588, 0, 0, 47, 0, 59940, 66, 0, 0, 0, 0, '', 'See Horde Crew at Plains if quest The Choppy Booster Mk. 5 is completed | rewarded Alliance.'); + +-- Add Scenes for Darkmaul Ruins Ritual +DELETE FROM `scene_template` WHERE `SceneId` IN (2418,2496); +INSERT INTO `scene_template` (`SceneId`,`Flags`,`ScriptPackageID`,`Encrypted`,`ScriptName`) VALUES +(2418,16,2932,0,''), +(2496,16,2932,0,''); + +-- Spell Trigger +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (-321342,-326626); +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(-321342,321340,0,'Removing aura Gor''groth Scene (DNT) cast Scout-o-Matic Ping (DNT) on player'), +(-326626,321340,0,'Removing aura Gor''groth Scene (DNT) cast Scout-o-Matic Ping (DNT) on player'); + +-- Spell Click +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (156518,167027); +INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`,`user_type`) VALUES +(156518,305522,1,0), +(167027,326625,1,0); + +-- Condition for Spell click event condition type Queststate +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup` IN (156518,167027) AND `SourceEntry` IN (305522,326625) AND `SourceId`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(18, 156518, 305522, 0, 0, 47, 0, 55193, 8, 0, 0, 0, 0, '', 'Spellclick unit Scout-o-Matic 5000 will cast spell Riding Scout O Matic 500 (DNT) on player if quest The Scout-o-Matic 5000 queststate is INCOMPLETE'), +(18, 167027, 326625, 0, 0, 47, 0, 59940, 8, 0, 0, 0, 0, '', 'Spellclick unit Choppy Booster Mk. 5 will cast spell Riding Choppy Booster Mk 5 (DNT) on player if quest The Choppy Booster Mk. 5 queststate is INCOMPLETE'); + +-- Spell Target Position +DELETE FROM `spell_target_position` WHERE `ID` IN (305523,326624); +INSERT INTO `spell_target_position` (`ID`,`EffectIndex`,`MapID`,`PositionX`,`PositionY`,`PositionZ`,`VerifiedBuild`) VALUES +(305523,0,2175,107.87153,-2414.177,95.44844,52649), +(326624,0,2175,107.87153,-2414.177,95.44844,52649); + +-- Pathing for Won'sa Entry: 167909 +SET @PATH := 16790900; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`,`MoveType`,`Flags`,`Comment`) VALUES +(@PATH,1,0,'Won\'sa - Path to Plains'); +DELETE FROM `waypoint_path_node` WHERE `PathId` IN (@PATH); +INSERT INTO `waypoint_path_node` (`PathId`,`NodeId`,`PositionX`,`PositionY`,`PositionZ`,`Orientation`,`Delay`) VALUES +(@PATH, 1,35.23047,-2496.2656,76.15068,NULL,0), +(@PATH, 2,36.51172,-2494.7305,76.37278,NULL,0), +(@PATH, 3,37.79297,-2493.1953,76.59488,NULL,0), +(@PATH, 4,38.433594,-2492.4277,76.78395,NULL,0), +(@PATH, 5,40.35547,-2490.125,77.10432,NULL,0), +(@PATH, 6,42.277344,-2487.8223,77.31794,NULL,0), +(@PATH, 7,43.558594,-2486.287,77.5466,NULL,0), +(@PATH, 8,44.839844,-2484.752,77.794556,NULL,0), +(@PATH, 9,46.121094,-2483.2168,78.26145,NULL,0), +(@PATH,10,47.402344,-2481.6816,78.461975,NULL,0), +(@PATH,11,48.04297,-2480.914,78.67813,NULL,0), +(@PATH,12,48.683594,-2480.1465,78.93847,NULL,0), +(@PATH,13,49.964844,-2478.6113,79.17999,NULL,0), +(@PATH,14,51.246094,-2477.0762,79.53442,NULL,0), +(@PATH,15,52.527344,-2475.541,80.06633,NULL,0), +(@PATH,16,53.16797,-2474.7734,80.69311,NULL,0), +(@PATH,17,54.44922,-2473.2383,81.2072,NULL,0), +(@PATH,18,55.089844,-2472.4707,81.69563,NULL,0), +(@PATH,19,55.73047,-2471.7031,82.06888,NULL,0), +(@PATH,20,57.01172,-2470.168,82.387405,NULL,0), +(@PATH,21,57.652344,-2469.4004,82.68654,NULL,0), +(@PATH,22,58.29297,-2468.6328,83.10086,NULL,0), +(@PATH,23,59.57422,-2467.0977,83.603035,NULL,0), +(@PATH,24,60.214844,-2466.33,84.053795,NULL,0), +(@PATH,25,60.85547,-2465.5625,84.65018,NULL,0), +(@PATH,26,62.13672,-2464.0273,85.29573,NULL,0), +(@PATH,27,62.777344,-2463.2598,85.93452,NULL,0), +(@PATH,28,63.41797,-2462.4922,86.4528,NULL,0), +(@PATH,29,64.69922,-2460.957,87.04939,NULL,0), +(@PATH,30,65.33984,-2460.1895,87.599045,NULL,0), +(@PATH,31,66.62109,-2458.6543,88.118324,NULL,0), +(@PATH,32,67.90234,-2457.1191,89.04315,NULL,0), +(@PATH,33,69.18359,-2455.584,89.405785,NULL,0), +(@PATH,34,70.46484,-2454.0488,89.93396,NULL,0), +(@PATH,35,77.51172,-2445.6055,90.18301,NULL,0), +(@PATH,36,78.79297,-2444.0703,90.518875,NULL,0), +(@PATH,37,80.07422,-2442.5352,91.14112,NULL,0), +(@PATH,38,81.99609,-2440.2324,91.35193,NULL,0), +(@PATH,39,85.19922,-2436.3945,91.73271,NULL,0), +(@PATH,40,85.83984,-2435.627,91.5237,NULL,0), +(@PATH,41,87.12109,-2434.0918,91.76771,NULL,0), +(@PATH,42,89.68359,-2431.0215,91.5747,NULL,0), +(@PATH,43,90.96484,-2429.4863,91.38042,NULL,0), +(@PATH,44,91.60547,-2428.7188,91.606064,NULL,0), +(@PATH,45,92.24609,-2427.9512,91.42322,NULL,0), +(@PATH,46,92.88672,-2427.1836,91.12659,NULL,0), +(@PATH,47,93.52734,-2426.416,91.31877,NULL,0), +(@PATH,48,94.80859,-2424.8809,91.00764,NULL,0), +(@PATH,49,95.66493,-2423.9133,90.917786,0.425676465,0); + +-- Pathing for Bo Entry: 167910 +SET @PATH := 16791000; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`,`MoveType`,`Flags`,`Comment`) VALUES +(@PATH,1,0,'Bo - Path to Plains'); +DELETE FROM `waypoint_path_node` WHERE `PathId` IN (@PATH); +INSERT INTO `waypoint_path_node` (`PathId`,`NodeId`,`PositionX`,`PositionY`,`PositionZ`,`Orientation`,`Delay`) VALUES +(@PATH, 1,41.779297,-2500.7227,75.59662,NULL,0), +(@PATH, 2,43.001953,-2499.1406,75.91208,NULL,0), +(@PATH, 3,44.22461,-2497.5586,76.22754,NULL,0), +(@PATH, 4,44.835938,-2496.7676,76.65566,NULL,0), +(@PATH, 5,46.058594,-2495.1855,76.908516,NULL,0), +(@PATH, 6,48.503906,-2492.0215,77.146484,NULL,0), +(@PATH, 7,49.726562,-2490.4395,77.35141,NULL,0), +(@PATH, 8,51.560547,-2488.0664,77.719536,NULL,0), +(@PATH, 9,52.171875,-2487.2754,78.03224,NULL,0), +(@PATH,10,53.39453,-2485.6934,78.31598,NULL,0), +(@PATH,11,54.617188,-2484.1113,78.76373,NULL,0), +(@PATH,12,55.228516,-2483.3203,78.98927,NULL,0), +(@PATH,13,56.45117,-2481.7383,79.24119,NULL,0), +(@PATH,14,57.0625,-2480.9473,79.43339,NULL,0), +(@PATH,15,57.67383,-2480.1562,79.81413,NULL,0), +(@PATH,16,58.896484,-2478.5742,80.22633,NULL,0), +(@PATH,17,59.507812,-2477.7832,80.67,NULL,0), +(@PATH,18,60.11914,-2476.9922,80.88286,NULL,0), +(@PATH,19,61.341797,-2475.4102,81.354126,NULL,0), +(@PATH,20,62.564453,-2473.8281,82.34989,NULL,0), +(@PATH,21,63.78711,-2472.246,82.874084,NULL,0), +(@PATH,22,64.39844,-2471.455,83.129196,NULL,0), +(@PATH,23,65.009766,-2470.664,83.683914,NULL,0), +(@PATH,24,66.23242,-2469.082,84.25187,NULL,0), +(@PATH,25,66.84375,-2468.291,84.807526,NULL,0), +(@PATH,26,68.06641,-2466.709,85.36737,NULL,0), +(@PATH,27,68.677734,-2465.918,85.62689,NULL,0), +(@PATH,28,69.90039,-2464.336,86.55142,NULL,0), +(@PATH,29,71.12305,-2462.754,87.0177,NULL,0), +(@PATH,30,72.3457,-2461.1719,87.5264,NULL,0), +(@PATH,31,72.95703,-2460.3809,87.86322,NULL,0), +(@PATH,32,74.17969,-2458.7988,88.16536,NULL,0), +(@PATH,33,75.40234,-2457.2168,88.643425,NULL,0), +(@PATH,34,76.625,-2455.6348,88.90225,NULL,0), +(@PATH,35,77.23633,-2454.8438,89.07985,NULL,0), +(@PATH,36,79.07031,-2452.4707,89.28867,NULL,0), +(@PATH,37,80.29297,-2450.8887,89.4955,NULL,0), +(@PATH,38,82.12695,-2448.5156,89.74487,NULL,0), +(@PATH,39,84.572266,-2445.3516,89.9191,NULL,0), +(@PATH,40,86.40625,-2442.9785,90.08759,NULL,0), +(@PATH,41,88.240234,-2440.6055,90.378685,NULL,0), +(@PATH,42,90.07422,-2438.2324,90.20039,NULL,0), +(@PATH,43,91.9082,-2435.8594,89.99468,NULL,0), +(@PATH,44,93.13086,-2434.2773,90.21448,NULL,0), +(@PATH,45,96.79883,-2429.5312,90.40429,NULL,0), +(@PATH,46,99.85547,-2425.5762,90.226105,NULL,0), +(@PATH,47,100.55903,-2424.5972,90.15397,1.507016778,0); + +-- Pathing for Lana Jordan Entry: 167911 +SET @PATH := 16791100; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`,`MoveType`,`Flags`,`Comment`) VALUES +(@PATH,1,0,'Lana Jordan - Path to Plains'); +DELETE FROM `waypoint_path_node` WHERE `PathId` IN (@PATH); +INSERT INTO `waypoint_path_node` (`PathId`,`NodeId`,`PositionX`,`PositionY`,`PositionZ`,`Orientation`,`Delay`) VALUES +(@PATH, 1,38.05078,-2497.0703,76.19637,NULL,0), +(@PATH, 2,39.820312,-2494.6504,76.445015,NULL,0), +(@PATH, 3,41.589844,-2492.2305,76.69366,NULL,0), +(@PATH, 4,42.76953,-2490.6172,76.949234,NULL,0), +(@PATH, 5,44.539062,-2488.1973,77.241356,NULL,0), +(@PATH, 6,46.308594,-2485.7773,77.63696,NULL,0), +(@PATH, 7,46.898438,-2484.9707,77.92958,NULL,0), +(@PATH, 8,47.48828,-2484.164,78.1297,NULL,0), +(@PATH, 9,48.66797,-2482.5508,78.352875,NULL,0), +(@PATH,10,49.257812,-2481.7441,78.56903,NULL,0), +(@PATH,11,49.847656,-2480.9375,78.73949,NULL,0), +(@PATH,12,50.4375,-2480.1309,78.98866,NULL,0), +(@PATH,13,51.617188,-2478.5176,79.211685,NULL,0), +(@PATH,14,52.20703,-2477.711,79.42844,NULL,0), +(@PATH,15,53.38672,-2476.0977,79.96034,NULL,0), +(@PATH,16,53.976562,-2475.291,80.25719,NULL,0), +(@PATH,17,55.15625,-2473.6777,81.2072,NULL,0), +(@PATH,18,55.746094,-2472.871,81.598434,NULL,0), +(@PATH,19,56.92578,-2471.2578,81.95367,NULL,0), +(@PATH,20,57.515625,-2470.4512,82.2722,NULL,0), +(@PATH,21,58.10547,-2469.6445,82.68654,NULL,0), +(@PATH,22,59.285156,-2468.0312,83.1065,NULL,0), +(@PATH,23,61.054688,-2465.6113,84.65018,NULL,0), +(@PATH,24,62.234375,-2463.998,85.29573,NULL,0), +(@PATH,25,62.82422,-2463.1914,85.93452,NULL,0), +(@PATH,26,63.414062,-2462.3848,86.4528,NULL,0), +(@PATH,27,64.59375,-2460.7715,87.04939,NULL,0), +(@PATH,28,65.77344,-2459.1582,88.118324,NULL,0), +(@PATH,29,66.953125,-2457.545,88.5997,NULL,0), +(@PATH,30,68.13281,-2455.9316,89.44768,NULL,0), +(@PATH,31,68.72266,-2455.125,89.7714,NULL,0), +(@PATH,32,70.49219,-2452.705,89.98274,NULL,0), +(@PATH,33,75.80078,-2445.4453,90.17747,NULL,0), +(@PATH,34,76.390625,-2444.6387,90.49428,NULL,0), +(@PATH,35,77.57031,-2443.0254,90.830154,NULL,0), +(@PATH,36,78.75,-2441.412,91.52435,NULL,0), +(@PATH,37,80.51953,-2438.9922,91.74478,NULL,0), +(@PATH,38,81.109375,-2438.1855,91.999,NULL,0), +(@PATH,39,84.05859,-2434.1523,92.25275,NULL,0), +(@PATH,40,86.41797,-2430.9258,92.49652,NULL,0), +(@PATH,41,87.59766,-2429.3125,92.31051,NULL,0), +(@PATH,42,88.1875,-2428.5059,92.53616,NULL,0), +(@PATH,43,91.13672,-2424.4727,92.159485,NULL,0), +(@PATH,44,91.72656,-2423.666,91.92435,NULL,0), +(@PATH,45,92.90625,-2422.0527,91.66114,NULL,0), +(@PATH,46,94.08594,-2420.4395,91.40442,NULL,0), +(@PATH,47,95.265625,-2418.8262,91.13356,NULL,0), +(@PATH,48,95.635414,-2418.3716,91.03652,6.28133726,0); + +-- Pathing for Provisoner Jin'hake Entry: 167912 +SET @PATH := 16791200; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`,`MoveType`,`Flags`,`Comment`) VALUES +(@PATH,1,0,'Provisoner Jin\'hake - Path to Plains'); +DELETE FROM `waypoint_path_node` WHERE `PathId` IN (@PATH); +INSERT INTO `waypoint_path_node` (`PathId`,`NodeId`,`PositionX`,`PositionY`,`PositionZ`,`Orientation`,`Delay`) VALUES +(@PATH, 1,31.38208,-2501.5894,75.11702,NULL,0), +(@PATH, 2,32.4635,-2499.91,75.31692,NULL,0), +(@PATH, 3,33.54492,-2498.2305,75.516815,NULL,0), +(@PATH, 4,34.085938,-2497.3906,75.71699,NULL,0), +(@PATH, 5,34.935547,-2496.7168,75.95317,NULL,0), +(@PATH, 6,36.53711,-2495.5176,76.18371,NULL,0), +(@PATH, 7,38.13867,-2494.3184,76.40581,NULL,0), +(@PATH, 8,38.939453,-2493.7188,76.58211,NULL,0), +(@PATH, 9,41.666016,-2491.666,76.69366,NULL,0), +(@PATH,10,43.08008,-2490.252,76.949234,NULL,0), +(@PATH,11,45.20117,-2488.1309,77.20306,NULL,0), +(@PATH,12,45.908203,-2487.4238,77.41345,NULL,0), +(@PATH,13,47.322266,-2486.0098,77.70607,NULL,0), +(@PATH,14,48.029297,-2485.3027,77.975296,NULL,0), +(@PATH,15,49.44336,-2483.8887,78.221115,NULL,0), +(@PATH,16,50,-2483.334,78.221115,NULL,0), +(@PATH,17,51.414062,-2481.92,78.74388,NULL,0), +(@PATH,18,52.121094,-2481.213,78.991806,NULL,0), +(@PATH,19,53.535156,-2479.7988,79.22111,NULL,0), +(@PATH,20,54.242188,-2479.0918,79.49854,NULL,0), +(@PATH,21,55.65625,-2477.6777,79.82413,NULL,0), +(@PATH,22,56.36328,-2476.9707,80.204185,NULL,0), +(@PATH,23,57.777344,-2475.5566,80.638725,NULL,0), +(@PATH,24,58.333984,-2475,80.86495,NULL,0), +(@PATH,25,59.041016,-2474.293,81.08916,NULL,0), +(@PATH,26,60.45508,-2472.879,82.05353,NULL,0), +(@PATH,27,61.86914,-2471.4648,82.58329,NULL,0), +(@PATH,28,62.57617,-2470.7578,83.13916,NULL,0), +(@PATH,29,63.990234,-2469.3438,83.72113,NULL,0), +(@PATH,30,64.697266,-2468.6367,84.28909,NULL,0), +(@PATH,31,66.11133,-2467.2227,84.84305,NULL,0), +(@PATH,32,66.666016,-2466.666,84.84305,NULL,0), +(@PATH,33,67.06641,-2465.75,85.36263,NULL,0), +(@PATH,34,67.4668,-2464.834,85.627464,NULL,0), +(@PATH,35,67.86719,-2463.918,86.11268,NULL,0), +(@PATH,36,68.26758,-2463.002,86.35456,NULL,0), +(@PATH,37,68.66797,-2462.086,86.65648,NULL,0), +(@PATH,38,69.06836,-2461.17,87.215866,NULL,0), +(@PATH,39,69.46875,-2460.254,87.47066,NULL,0), +(@PATH,40,69.86914,-2459.338,87.81572,NULL,0), +(@PATH,41,70.66992,-2457.5059,88.30741,NULL,0), +(@PATH,42,71.07031,-2456.5898,88.635284,NULL,0), +(@PATH,43,71.87109,-2454.7578,89.55542,NULL,0), +(@PATH,44,72.671875,-2452.9258,89.77253,NULL,0), +(@PATH,45,73.958984,-2450,89.75393,NULL,0), +(@PATH,46,75,-2448.959,89.80968,NULL,0), +(@PATH,47,76.48828,-2446.3516,89.99064,NULL,0), +(@PATH,48,76.984375,-2445.4824,90.18024,NULL,0), +(@PATH,49,77.97656,-2443.7441,90.830154,NULL,0), +(@PATH,50,78.96875,-2442.0059,91.18507,NULL,0), +(@PATH,51,79.166016,-2441.666,91.18507,NULL,0), +(@PATH,52,79.61328,-2440.7715,91.40416,NULL,0), +(@PATH,53,80.06055,-2439.877,91.661514,NULL,0), +(@PATH,54,80.95508,-2438.088,91.999,NULL,0), +(@PATH,55,81.84961,-2436.2988,92.20172,NULL,0), +(@PATH,56,83.19141,-2433.6152,92.40908,NULL,0), +(@PATH,57,83.333984,-2433.334,92.25275,NULL,0), +(@PATH,58,83.85742,-2432.4824,92.437325,NULL,0), +(@PATH,59,84.9043,-2430.7793,92.647026,NULL,0), +(@PATH,60,85.95117,-2429.0762,92.839554,NULL,0), +(@PATH,61,88.56836,-2424.8184,92.57365,NULL,0), +(@PATH,62,89.615234,-2423.1152,92.37451,NULL,0), +(@PATH,63,90.66211,-2421.412,92.17143,NULL,0), +(@PATH,64,91.708984,-2419.709,91.95537,NULL,0), +(@PATH,65,92.75586,-2418.0059,91.739525,NULL,0), +(@PATH,66,93.15278,-2417.3733,91.710266,6.0155663,0); + +-- Pathing for Grunt Throg Entry: 167913 +SET @PATH := 16791300; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`,`MoveType`,`Flags`,`Comment`) VALUES +(@PATH,1,0,'Grunt Throg - Path to Plains'); +DELETE FROM `waypoint_path_node` WHERE `PathId` IN (@PATH); +INSERT INTO `waypoint_path_node` (`PathId`,`NodeId`,`PositionX`,`PositionY`,`PositionZ`,`Orientation`,`Delay`) VALUES +(@PATH, 1,35.570312,-2499.2188,75.41057,NULL,0), +(@PATH, 2,36.183594,-2498.4297,75.61734,NULL,0), +(@PATH, 3,36.796875,-2497.6406,75.82411,NULL,0), +(@PATH, 4,37.410156,-2496.8516,76.0252,NULL,0), +(@PATH, 5,38.63672,-2495.2734,76.268715,NULL,0), +(@PATH, 6,39.86328,-2493.6953,76.55202,NULL,0), +(@PATH, 7,41.703125,-2491.3281,76.82607,NULL,0), +(@PATH, 8,43.54297,-2488.961,77.11319,NULL,0), +(@PATH, 9,44.76953,-2487.3828,77.38583,NULL,0), +(@PATH,10,45.996094,-2485.8047,77.63696,NULL,0), +(@PATH,11,46.609375,-2485.0156,77.86047,NULL,0), +(@PATH,12,47.222656,-2484.2266,78.1297,NULL,0), +(@PATH,13,48.44922,-2482.6484,78.352875,NULL,0), +(@PATH,14,49.0625,-2481.8594,78.56903,NULL,0), +(@PATH,15,49.67578,-2481.0703,78.73949,NULL,0), +(@PATH,16,50.902344,-2479.4922,78.98866,NULL,0), +(@PATH,17,52.128906,-2477.914,79.42844,NULL,0), +(@PATH,18,53.35547,-2476.336,79.96034,NULL,0), +(@PATH,19,53.96875,-2475.5469,80.25719,NULL,0), +(@PATH,20,54.58203,-2474.7578,80.718765,NULL,0), +(@PATH,21,55.808594,-2473.1797,81.10999,NULL,0), +(@PATH,22,56.421875,-2472.3906,81.48323,NULL,0), +(@PATH,23,57.035156,-2471.6016,81.95367,NULL,0), +(@PATH,24,57.648438,-2470.8125,82.2722,NULL,0), +(@PATH,25,58.875,-2469.2344,82.69217,NULL,0), +(@PATH,26,59.48828,-2468.4453,83.215675,NULL,0), +(@PATH,27,60.101562,-2467.6562,83.603035,NULL,0), +(@PATH,28,61.328125,-2466.0781,84.136,NULL,0), +(@PATH,29,61.941406,-2465.289,84.756966,NULL,0), +(@PATH,30,62.554688,-2464.5,85.39575,NULL,0), +(@PATH,31,63.78125,-2462.9219,85.94004,NULL,0), +(@PATH,32,65.00781,-2461.3438,87.04939,NULL,0), +(@PATH,33,66.234375,-2459.7656,87.56868,NULL,0), +(@PATH,34,67.46094,-2458.1875,88.5997,NULL,0), +(@PATH,35,68.6875,-2456.6094,89.04315,NULL,0), +(@PATH,36,69.91406,-2455.0312,89.687614,NULL,0), +(@PATH,37,71.75391,-2452.664,89.85864,NULL,0), +(@PATH,38,77.27344,-2445.5625,90.18301,NULL,0), +(@PATH,39,77.88672,-2444.7734,90.497055,NULL,0), +(@PATH,40,79.11328,-2443.1953,90.851974,NULL,0), +(@PATH,41,79.72656,-2442.4062,91.14112,NULL,0), +(@PATH,42,81.56641,-2440.039,91.35193,NULL,0), +(@PATH,43,82.17969,-2439.25,91.56758,NULL,0), +(@PATH,44,85.24609,-2435.3047,91.91708,NULL,0), +(@PATH,45,90.765625,-2428.2031,91.606064,NULL,0), +(@PATH,46,91.37891,-2427.414,91.79823,NULL,0), +(@PATH,47,91.99219,-2426.625,91.61539,NULL,0), +(@PATH,48,92.60547,-2425.836,91.80756,NULL,0), +(@PATH,49,93.21875,-2425.0469,91.50333,NULL,0), +(@PATH,50,93.83203,-2424.2578,91.31187,NULL,0), +(@PATH,51,95.05859,-2422.6797,91.06852,NULL,0), +(@PATH,52,95.94097,-2421.5105,90.92242,0.8034459,0); + +-- Pathing for Scout-o-Matic 5000 Entry: 156526 +-- Pathing for Choppy Booster Mk. 5 Entry: 167905 +SET @PATH := 15652600; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`,`MoveType`,`Flags`,`Comment`) VALUES +(@PATH,0,0,'Exile\'s Reach - Copter ride to Ogre Ruins'); +DELETE FROM `waypoint_path_node` WHERE `PathId` IN (@PATH); +INSERT INTO `waypoint_path_node` (`PathId`,`NodeId`,`PositionX`,`PositionY`,`PositionZ`,`Orientation`,`Delay`) VALUES +(@PATH,1,115.21007,-2420.2239,135.10031,NULL,0), +(@PATH,2,156.11806,-2398.1390,138.27547,NULL,0), +(@PATH,3,182.06944,-2381.7917,138.27547,NULL,0), +(@PATH,4,211.51910,-2379.6284,138.27547,NULL,0); + +-- Pathing for Scout-o-Matic 5000 Entry: 156526 +-- Pathing for Choppy Booster Mk. 5 Entry: 167905 +SET @PATH := 15652601; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`,`MoveType`,`Flags`,`Comment`) VALUES +(@PATH,0,0,'Exile\'s Reach - Copter ride from Ogre Ruins'); +DELETE FROM `waypoint_path_node` WHERE `PathId` IN (@PATH); +INSERT INTO `waypoint_path_node` (`PathId`,`NodeId`,`PositionX`,`PositionY`,`PositionZ`,`Orientation`,`Delay`) VALUES +(@PATH,1,174.54167,-2386.8213,124.66746,NULL,0), +(@PATH,2,107.87153,-2414.177,95.68774,NULL,0); diff --git a/src/server/scripts/ExilesReach/zone_exiles_reach.cpp b/src/server/scripts/ExilesReach/zone_exiles_reach.cpp index a414344dec1..31218890e8c 100644 --- a/src/server/scripts/ExilesReach/zone_exiles_reach.cpp +++ b/src/server/scripts/ExilesReach/zone_exiles_reach.cpp @@ -4808,6 +4808,528 @@ class spell_quilboar_sleep_dnt : public AuraScript } }; +// ************************************************************** +// * Scripting in this section occurs after reaching The Plains * +// ************************************************************** + +enum LindieSpringStockData +{ + CONVERSATION_RESIZE_COPTER_ALLIANCE = 12078, + CONVERSATION_RESIZE_COPTER_HORDE = 14516, + + CONVERSATION_ACTOR_GOBLIN_ALLIANCE = 71345, + CONVERSATION_ACTOR_GOBLIN_HORDE = 76337, + CONVERSATION_ACTOR_COPTER = 71344, + + EVENT_CONVERSATION = 1, + EVENT_RESIZE_COPTER_1 = 2, + EVENT_RESIZE_COPTER_2 = 3, + EVENT_RESIZE_COPTER_3 = 4, + EVENT_RESIZE_COPTER_4 = 5, + EVENT_RESIZE_COPTER_5 = 6, + EVENT_RESIZE_COPTER_6 = 7, + + NPC_LINDIE_SPRINGSTOCK_PLAINS = 149899, + + QUEST_THE_SCOUT_O_MATIC_5000 = 55193, + QUEST_THE_CHOPPY_BOOSTER_MK5 = 59940, + + SPELL_RE_SIZING = 313269, + SPELL_GROW_ONE = 129310, + SPELL_GROW_TWO = 94214, + SPELL_GROW_THREE = 111701 +}; + +Position const MiniChopperJumpPosition = { 107.979f, -2414.13f, 95.6243f }; + +// 149899 - Lindie Springstock +// 167019 - Cork Fizzlepop +struct npc_gnome_goblin_plains_make_copter_private : public ScriptedAI +{ + npc_gnome_goblin_plains_make_copter_private(Creature* creature) : ScriptedAI(creature), _conversationId(0), _conversationActorId(0), _timer(0ms) { } + + void JustAppeared() override + { + if (me->GetEntry() == NPC_LINDIE_SPRINGSTOCK_PLAINS) + { + _conversationId = CONVERSATION_RESIZE_COPTER_ALLIANCE; + _conversationActorId = CONVERSATION_ACTOR_GOBLIN_ALLIANCE; + _timer = 1350ms; + } + else + { + _conversationId = CONVERSATION_RESIZE_COPTER_HORDE; + _conversationActorId = CONVERSATION_ACTOR_GOBLIN_HORDE; + _timer = 750ms; + } + + _events.ScheduleEvent(EVENT_CONVERSATION, 1s); + } + + void UpdateAI(uint32 diff) override + { + _events.Update(diff); + + while (uint32 eventId = _events.ExecuteEvent()) + { + switch (eventId) + { + case EVENT_CONVERSATION: + { + if (Player* player = ObjectAccessor::GetPlayer(*me, me->GetPrivateObjectOwner())) + { + Conversation* conversation = Conversation::CreateConversation(_conversationId, player, *player, player->GetGUID(), nullptr, false); + if (!conversation) + break; + + conversation->AddActor(_conversationActorId, 0, me->GetGUID()); + conversation->AddActor(CONVERSATION_ACTOR_COPTER, 1, _copterGUID); + conversation->Start(); + } + + if (Creature* copter = ObjectAccessor::GetCreature(*me, _copterGUID)) + copter->GetMotionMaster()->MoveJump(MiniChopperJumpPosition, 19.29f, 6.99f); + + _events.ScheduleEvent(EVENT_RESIZE_COPTER_1, 6s); + break; + } + case EVENT_RESIZE_COPTER_1: + { + if (Creature* copter = ObjectAccessor::GetCreature(*me, _copterGUID)) + { + me->SetFacingTo(0.488383f); + me->CastSpell(copter, SPELL_RE_SIZING); + copter->CastSpell(copter, SPELL_GROW_ONE); + } + _events.ScheduleEvent(EVENT_RESIZE_COPTER_2, 2s); + break; + } + case EVENT_RESIZE_COPTER_2: + { + if (Creature* copter = ObjectAccessor::GetCreature(*me, _copterGUID)) + copter->RemoveAura(SPELL_GROW_ONE); + + _events.ScheduleEvent(EVENT_RESIZE_COPTER_3, _timer); + break; + } + case EVENT_RESIZE_COPTER_3: + { + if (Creature* copter = ObjectAccessor::GetCreature(*me, _copterGUID)) + copter->CastSpell(copter, SPELL_GROW_TWO); + + _events.ScheduleEvent(EVENT_RESIZE_COPTER_4, _timer); + break; + } + case EVENT_RESIZE_COPTER_4: + { + if (Creature* copter = ObjectAccessor::GetCreature(*me, _copterGUID)) + copter->RemoveAura(SPELL_GROW_TWO); + + _events.ScheduleEvent(EVENT_RESIZE_COPTER_5, _timer); + break; + } + case EVENT_RESIZE_COPTER_5: + { + if (Creature* copter = ObjectAccessor::GetCreature(*me, _copterGUID)) + copter->CastSpell(copter, SPELL_GROW_THREE); + + me->CastStop(SPELL_RE_SIZING); + me->SetFacingTo(4.50382f); + me->DespawnOrUnsummon(27s); + _events.ScheduleEvent(EVENT_RESIZE_COPTER_6, _timer); + break; + } + case EVENT_RESIZE_COPTER_6: + { + if (Creature* copter = ObjectAccessor::GetCreature(*me, _copterGUID)) + { + copter->RemoveAura(SPELL_GROW_THREE); + copter->DespawnOrUnsummon(2s); + } + break; + } + default: + break; + } + } + } + +public: + void SetCopterGUID(ObjectGuid copterGUID) + { + _copterGUID = copterGUID; + } + +private: + EventMap _events; + ObjectGuid _copterGUID; + uint32 _conversationId; + uint32 _conversationActorId; + Milliseconds _timer; +}; + +CreatureAI* LindieSpringstockSelector(Creature* creature) +{ + if (creature->IsPrivateObject()) + { + if (Player* privateObjectOwner = ObjectAccessor::GetPlayer(*creature, creature->GetPrivateObjectOwner())) + { + if (privateObjectOwner->GetQuestStatus(QUEST_THE_SCOUT_O_MATIC_5000) == QUEST_STATUS_INCOMPLETE) + return new npc_gnome_goblin_plains_make_copter_private(creature); + } + } + return new NullCreatureAI(creature); +}; + +CreatureAI* CorkFizzlepopSelector(Creature* creature) +{ + if (creature->IsPrivateObject()) + { + if (Player* privateObjectOwner = ObjectAccessor::GetPlayer(*creature, creature->GetPrivateObjectOwner())) + { + if (privateObjectOwner->GetQuestStatus(QUEST_THE_CHOPPY_BOOSTER_MK5) == QUEST_STATUS_INCOMPLETE) + return new npc_gnome_goblin_plains_make_copter_private(creature); + } + } + return new NullCreatureAI(creature); +}; + +enum CopterRideData +{ + CONVERSATION_RIDE_TO_OGRE_RUINS_ALLIANCE = 12083, + CONVERSATION_RIDE_FROM_OGRE_RUINS_ALLIANCE = 12084, + CONVERSATION_RIDE_TO_OGRE_RUINS_HORDE = 14517, + CONVERSATION_RIDE_FROM_OGRE_RUINS_HORDE = 14520, + + EVENT_START_SCOUT_OGRE_RUINS = 1, + EVENT_RETURN_FROM_OGRE_RUINS = 2, + EVENT_TRIGGER_CREW_MOVE = 3, + + NPC_SCOUT_O_MATIC_5000 = 156518, + NPC_CHOPPY_BOOSTER_MK5 = 167027, + + PATH_COPTER_TO_RUINS = 15652600, + PATH_COPTER_FROM_RUINS = 15652601, + PATH_WONSA_PLAINS = 16790900, + PATH_BO_PLAINS = 16791000, + PATH_LANA_PLAINS = 16791100, + PATH_JINHAKE_PLAINS = 16791200, + PATH_THROG_PLAINS = 16791300, + + SPELL_SCENE_OGRE_RUINS_ALLIANCE = 321342, + SPELL_SCENE_OGRE_RUINS_HORDE = 326626, + SPELL_ROPED_DNT = 303067, + SPELL_SCOUT_O_MATIC_PING_DNT = 321340, + SCOUT_O_MATIC_DESUMMON = 305548 +}; + +// 156526 - Scout-o-Matic 5000 +struct npc_scoutomatic_5000 : public ScriptedAI +{ + npc_scoutomatic_5000(Creature* creature) : ScriptedAI(creature) { } + + void IsSummonedBy(WorldObject* summoner) override + { + if (Player* player = summoner->ToPlayer()) + player->CastSpell(player, SPELL_UPDATE_PHASE_SHIFT); + } + + void PassengerBoarded(Unit* passenger, int8 /*seatId*/, bool apply) override + { + if (apply && passenger->IsPlayer()) + { + me->CastSpell(passenger, SPELL_ROPED_DNT); + _events.ScheduleEvent(EVENT_START_SCOUT_OGRE_RUINS, 2s); + } + } + + void WaypointPathEnded(uint32 /*nodeId*/, uint32 pathId) override + { + Player* player = ObjectAccessor::GetPlayer(*me, me->GetOwnerGUID()); + if (!player) + return; + + if (pathId == PATH_COPTER_TO_RUINS) + { + player->CastSpell(player, SPELL_SCENE_OGRE_RUINS_ALLIANCE); + } + else + { + player->CastSpell(player, SCOUT_O_MATIC_DESUMMON, CastSpellExtraArgs(TRIGGERED_IGNORE_CASTER_MOUNTED_OR_ON_VEHICLE)); + player->CastSpell(player, SPELL_UPDATE_PHASE_SHIFT); + } + } + + void SpellHit(WorldObject* caster, SpellInfo const* spellInfo) override + { + if (spellInfo->Id == SPELL_SCOUT_O_MATIC_PING_DNT) + { + if (Player* player = caster->ToPlayer()) + player->KilledMonsterCredit(NPC_SCOUT_O_MATIC_5000); + + _events.ScheduleEvent(EVENT_RETURN_FROM_OGRE_RUINS, 1s); + } + } + + void UpdateAI(uint32 diff) override + { + _events.Update(diff); + + while (uint32 eventId = _events.ExecuteEvent()) + { + switch (eventId) + { + case EVENT_START_SCOUT_OGRE_RUINS: + { + if (Player* player = ObjectAccessor::GetPlayer(*me, me->GetOwnerGUID())) + { + me->SetSpeed(MOVE_WALK, 5.5f); + me->GetMotionMaster()->MovePath(PATH_COPTER_TO_RUINS, false); + Conversation::CreateConversation(CONVERSATION_RIDE_TO_OGRE_RUINS_ALLIANCE, player, *player, player->GetGUID(), nullptr); + } + break; + } + case EVENT_RETURN_FROM_OGRE_RUINS: + { + if (Player* player = ObjectAccessor::GetPlayer(*me, me->GetOwnerGUID())) + { + me->SetSpeed(MOVE_WALK, 5.0f); + me->GetMotionMaster()->MovePath(PATH_COPTER_FROM_RUINS, false); + Conversation::CreateConversation(CONVERSATION_RIDE_FROM_OGRE_RUINS_ALLIANCE, player, *player, player->GetGUID(), nullptr); + } + break; + } + default: + break; + } + } + } + +private: + EventMap _events; +}; + +Position const HordeCrewPersonalSpawnLocation[] = +{ + { 50.920593f, -2477.466f, 79.444374f, 0.8753076f }, + { 60.51328f, -2476.4822f, 81.034775f, 0.9128374f }, + { 53.08128f, -2476.5154f, 79.822624f, 0.9394135f }, + { 53.281864f, -2480.052f, 79.18003f, 0.78539818f }, + { 53.936935f, -2475.588f, 80.24179f, 0.91009599f } +}; + +// 167905 - Choppy Booster Mk. 5 +struct npc_choppy_booster_scout : public ScriptedAI +{ + npc_choppy_booster_scout(Creature* creature) : ScriptedAI(creature) { } + + void IsSummonedBy(WorldObject* summoner) override + { + if (Player* player = summoner->ToPlayer()) + player->CastSpell(player, SPELL_UPDATE_PHASE_SHIFT); + } + + void PassengerBoarded(Unit* passenger, int8 /*seatId*/, bool apply) override + { + if (apply && passenger->IsPlayer()) + { + me->CastSpell(passenger, SPELL_ROPED_DNT); + _events.ScheduleEvent(EVENT_START_SCOUT_OGRE_RUINS, 2s); + } + } + + void WaypointPathEnded(uint32 /*nodeId*/, uint32 pathId) override + { + Player* player = ObjectAccessor::GetPlayer(*me, me->GetOwnerGUID()); + if (!player) + return; + + if (pathId == PATH_COPTER_TO_RUINS) + { + player->CastSpell(player, SPELL_SCENE_OGRE_RUINS_HORDE); + } + else + { + player->CastSpell(player, SCOUT_O_MATIC_DESUMMON, CastSpellExtraArgs(TRIGGERED_IGNORE_CASTER_MOUNTED_OR_ON_VEHICLE)); + player->CastSpell(player, SPELL_UPDATE_PHASE_SHIFT); + } + } + + void SpellHit(WorldObject* caster, SpellInfo const* spellInfo) override + { + if (spellInfo->Id == SPELL_SCOUT_O_MATIC_PING_DNT) + { + if (Player* player = caster->ToPlayer()) + player->KilledMonsterCredit(NPC_CHOPPY_BOOSTER_MK5); + + _events.ScheduleEvent(EVENT_RETURN_FROM_OGRE_RUINS, 1s); + } + return; + } + + void UpdateAI(uint32 diff) override + { + _events.Update(diff); + + while (uint32 eventId = _events.ExecuteEvent()) + { + switch (eventId) + { + case EVENT_START_SCOUT_OGRE_RUINS: + { + if (Player* player = ObjectAccessor::GetPlayer(*me, me->GetOwnerGUID())) + { + me->SetSpeed(MOVE_WALK, 6.0f); + me->GetMotionMaster()->MovePath(PATH_COPTER_TO_RUINS, false); + Conversation::CreateConversation(CONVERSATION_RIDE_TO_OGRE_RUINS_HORDE, player, *player, player->GetGUID(), nullptr); + } + break; + } + case EVENT_RETURN_FROM_OGRE_RUINS: + { + if (Player* player = ObjectAccessor::GetPlayer(*me, me->GetOwnerGUID())) + { + me->SetSpeed(MOVE_WALK, 4.5f); + me->GetMotionMaster()->MovePath(PATH_COPTER_FROM_RUINS, false); + Conversation::CreateConversation(CONVERSATION_RIDE_FROM_OGRE_RUINS_HORDE, player, *player, player->GetGUID(), nullptr); + _events.ScheduleEvent(EVENT_TRIGGER_CREW_MOVE, 11s); + } + break; + } + case EVENT_TRIGGER_CREW_MOVE: + if (Player* player = ObjectAccessor::GetPlayer(*me, me->GetOwnerGUID())) + { + if (Creature* wonsa = FindCreatureIgnorePhase(player, "wonsa_darkmaul_plains")) + if (Creature* wonsaClone = wonsa->SummonPersonalClone(HordeCrewPersonalSpawnLocation[0], TEMPSUMMON_MANUAL_DESPAWN, 0s, 0, 0, player)) + wonsaClone->GetMotionMaster()->MovePath(PATH_WONSA_PLAINS, false); + + if (Creature* bo = FindCreatureIgnorePhase(player, "bo_darkmaul_plains")) + if (Creature* boClone = bo->SummonPersonalClone(HordeCrewPersonalSpawnLocation[1], TEMPSUMMON_MANUAL_DESPAWN, 0s, 0, 0, player)) + boClone->GetMotionMaster()->MovePath(PATH_BO_PLAINS, false); + + if (Creature* lana = FindCreatureIgnorePhase(player, "lana_darkmaul_plains")) + if (Creature* lanaClone = lana->SummonPersonalClone(HordeCrewPersonalSpawnLocation[2], TEMPSUMMON_MANUAL_DESPAWN, 0s, 0, 0, player)) + lanaClone->GetMotionMaster()->MovePath(PATH_LANA_PLAINS, false); + + if (Creature* jinhake = FindCreatureIgnorePhase(player, "jinhake_darkmaul_plains")) + if (Creature* jinhakeClone = jinhake->SummonPersonalClone(HordeCrewPersonalSpawnLocation[3], TEMPSUMMON_MANUAL_DESPAWN, 0s, 0, 0, player)) + jinhakeClone->GetMotionMaster()->MovePath(PATH_JINHAKE_PLAINS, false); + + if (Creature* throg = FindCreatureIgnorePhase(player, "throg_darkmaul_plains")) + if (Creature* throgClone = throg->SummonPersonalClone(HordeCrewPersonalSpawnLocation[4], TEMPSUMMON_MANUAL_DESPAWN, 0s, 0, 0, player)) + throgClone->GetMotionMaster()->MovePath(PATH_THROG_PLAINS, false); + } + break; + default: + break; + } + } + } + +private: + EventMap _events; +}; + +CreatureAI* ChoppyBoosterSelector(Creature* creature) +{ + if (Player* player = ObjectAccessor::GetPlayer(*creature, creature->GetOwnerGUID())) + { + if (player->GetQuestStatus(QUEST_THE_CHOPPY_BOOSTER_MK5) == QUEST_STATUS_INCOMPLETE) + return new npc_choppy_booster_scout(creature); + } + return new NullCreatureAI(creature); +}; + +// 167909 - Won'sa +// 167910 - Bo +// 167911 - Lana Jordan +// 167912 - Provisoner Jin'hake +// 167913 - Grunt Throg +struct npc_horde_crew_plains_private : public ScriptedAI +{ + npc_horde_crew_plains_private(Creature* creature) : ScriptedAI(creature) { } + + void WaypointPathEnded(uint32 /*nodeId*/, uint32 /*pathId*/) override + { + me->DespawnOrUnsummon(); + } +}; + +CreatureAI* HordeCrewPlainsSelector(Creature* creature) +{ + if (creature->IsPrivateObject()) + return new npc_horde_crew_plains_private(creature); + + return new NullCreatureAI(creature); +}; + +Position const CopterCloneSpawnPosition = { 100.583f, -2417.87f, 90.268f, 0.0f }; + +// Quest 55193 - The Scout-o-Matic 5000 "Alliance" +// Quest 59940 - The Choppy Booster Mk. 5 "Horde" +class quest_scout_chopper : public QuestScript +{ +public: + quest_scout_chopper(char const* script) : QuestScript(script) { } + + void HandleQuestStatusChange(Player* player, QuestStatus newStatus, std::string_view goblinString, std::string_view copterString) + { + switch (newStatus) + { + case QUEST_STATUS_INCOMPLETE: + { + Creature* goblin = FindCreatureIgnorePhase(player, goblinString, 10.0f); + Creature* copter = FindCreatureIgnorePhase(player, copterString, 10.0f); + if (!goblin || !copter) + return; + + Creature* goblinPersonal = goblin->SummonPersonalClone(goblin->GetPosition(), TEMPSUMMON_MANUAL_DESPAWN, 0s, 0, 0, player); + Creature* copterPersonal = copter->SummonPersonalClone(CopterCloneSpawnPosition, TEMPSUMMON_MANUAL_DESPAWN, 0s, 0, 0, player); + if (!goblinPersonal || !copterPersonal) + return; + + copterPersonal->SetObjectScale(0.2f); + copterPersonal->RemoveNpcFlag(UNIT_NPC_FLAG_SPELLCLICK); + + if (npc_gnome_goblin_plains_make_copter_private* personalAI = CAST_AI(npc_gnome_goblin_plains_make_copter_private, goblinPersonal->AI())) + personalAI->SetCopterGUID(copterPersonal->GetGUID()); + + player->CastSpell(player, SPELL_UPDATE_PHASE_SHIFT); + break; + } + case QUEST_STATUS_NONE: + player->CastSpell(player, SPELL_UPDATE_PHASE_SHIFT); + break; + default: + break; + } + } +}; + +// 55193 - The Scout-o-Matic 5000 "Alliance" +class quest_scout_o_matic_5000 : public quest_scout_chopper +{ +public: + quest_scout_o_matic_5000() : quest_scout_chopper("quest_scout_o_matic_5000") { } + + void OnQuestStatusChange(Player* player, Quest const* /*quest*/, QuestStatus /*oldStatus*/, QuestStatus newStatus) override + { + HandleQuestStatusChange(player, newStatus, "lindie_springstock_plains", "scout_o_matic"); + } +}; + +// 59940 - The Choppy Booster Mk. 5 "Horde" +class quest_choppy_booster_mk5 : public quest_scout_chopper +{ +public: + quest_choppy_booster_mk5() : quest_scout_chopper("quest_choppy_booster_mk5") { } + + void OnQuestStatusChange(Player* player, Quest const* /*quest*/, QuestStatus /*oldStatus*/, QuestStatus newStatus) override + { + HandleQuestStatusChange(player, newStatus, "cork_fizzlepop_plains", "choppy_booster"); + } +}; + void AddSC_zone_exiles_reach() { // Ship @@ -4896,4 +5418,12 @@ void AddSC_zone_exiles_reach() RegisterCreatureAI(npc_ogre_overseer); RegisterAreaTriggerAI(at_briarpatch_to_plains); RegisterSpellScript(spell_quilboar_sleep_dnt); + // Plains + new quest_scout_o_matic_5000(); + new quest_choppy_booster_mk5(); + new FactoryCreatureScript<CreatureAI, &LindieSpringstockSelector>("npc_lindie_springstock_plains"); + new FactoryCreatureScript<CreatureAI, &CorkFizzlepopSelector>("npc_cork_fizzlepop_plains"); + RegisterCreatureAI(npc_scoutomatic_5000); + new FactoryCreatureScript<CreatureAI, &ChoppyBoosterSelector>("npc_choppy_booster"); + new FactoryCreatureScript<CreatureAI, &HordeCrewPlainsSelector>("npc_horde_crew_plains"); }; |