diff options
5 files changed, 1476 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_10_22_01_world.sql b/sql/updates/world/master/2023_10_22_01_world.sql new file mode 100644 index 00000000000..395fac72dac --- /dev/null +++ b/sql/updates/world/master/2023_10_22_01_world.sql @@ -0,0 +1,607 @@ +-- Sanctum of Domination + +SET @CGUID := 8000000; +SET @OGUID := 8000000; +SET @ATID := 45; +SET @ATSPAWNID := 42; + +-- Instance-related stuff +DELETE FROM `access_requirement` WHERE `mapId`=2450; +INSERT INTO `access_requirement` (`mapId`, `difficulty`, `level_min`, `level_max`, `item`, `item2`, `quest_done_A`, `quest_done_H`, `completed_achievement`, `quest_failed_text`, `comment`) VALUES +(2450, 17, 60, 0, 0, 0, 0, 0, 0, NULL, 'Sanctum of Domination - Looking for Raid Mode'), +(2450, 14, 60, 0, 0, 0, 0, 0, 0, NULL, 'Sanctum of Domination - Normal Mode'), +(2450, 15, 60, 0, 0, 0, 0, 0, 0, NULL, 'Sanctum of Domination - Heroic Mode'), +(2450, 16, 60, 0, 0, 0, 0, 0, 0, NULL, 'Sanctum of Domination - Mythic Mode'); + +DELETE FROM `instance_template` WHERE `map`=2450; +INSERT INTO `instance_template` (`map`, `parent`, `script`) VALUES +(2450, 0, 'instance_sanctum_of_domination'); + +-- Not entirely sure if Testing State is correct. It might refer to Closed instead and Open State could be Week of Release reached. +DELETE FROM `world_state` WHERE `ID` IN (20348, 20346, 20545, 20546, 20547, 20549, 20550, 20551, 20552, 20554, 20555, 20556, 20557, 20558); +INSERT INTO `world_state` (`ID`, `DefaultValue`, `MapIDs`, `AreaIDs`, `ScriptName`, `Comment`) VALUES +(20348, 1, '2450', NULL, '', 'Sanctum of Domination - Sylvanas Windrunner - Encounter phase'), +(20346, 0, '2450', NULL, '', 'Sanctum of Domination - Sylvanas Windrunner - Encounter started'), +(20545, 0, NULL, NULL, '', 'Sanctum of Domination - Normal difficulty - Testing State'), +(20546, 0, NULL, NULL, '', 'Sanctum of Domination - Heroic difficulty - Testing State'), +(20547, 0, NULL, NULL, '', 'Sanctum of Domination - Mythic difficulty - Testing State'), +(20549, 0, NULL, NULL, '', 'Sanctum of Domination - LFR difficulty: The Jailer\'s Vanguard - Testing State'), +(20550, 0, NULL, NULL, '', 'Sanctum of Domination - LFR difficulty: The Dark Bastille - Testing State'), +(20551, 0, NULL, NULL, '', 'Sanctum of Domination - LFR difficulty: Shackles of Fate - Testing State'), +(20552, 0, NULL, NULL, '', 'Sanctum of Domination - LFR difficulty: The Reckoning - Testing State'), +(20554, 1, NULL, NULL, '', 'Sanctum of Domination - Normal and Heroic difficulties - Open State'), +(20555, 1, NULL, NULL, '', 'Sanctum of Domination - Mythic difficulty and LFR difficulty: The Jailer\'s Vanguard - Open State'), +(20556, 1, NULL, NULL, '', 'Sanctum of Domination - LFR difficulty: The Dark Bastille - Open State'), +(20557, 1, NULL, NULL, '', 'Sanctum of Domination - LFR difficulty: Shackles of Fate - Open State'), +(20558, 1, NULL, NULL, '', 'Sanctum of Domination - LFR difficulty: The Reckoning - Open State'); + +-- 180803 - Throne of the Damned (Teleporter from Pinnacle of Domination to Throne of the Damned) +UPDATE `creature_template` SET `faction`=190, `npcflag`=16777216, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67143680, `unit_flags3`=1 WHERE `entry`=180803; + +DELETE FROM `creature_template_addon` WHERE `entry`=180803; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `SheathState`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(180803, 0, 0, 1, 0, 0, 0, 4, 0, '355809'); + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=180803; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(180803, 14, 0, 0, 2104, 8, 1, 1, 204469, 1611661392, 6, 50791), +(180803, 15, 0, 0, 2105, 8, 1, 1, 204469, 1611661392, 6, 50791), +(180803, 16, 0, 0, 2106, 8, 1, 1, 204469, 1611661392, 6, 50791), +(180803, 17, 0, 0, 2107, 8, 1, 1, 204469, 1611661392, 6, 50791); + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=180803; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(180803, 0, 0, 1, 1, 0, 0); + +DELETE FROM `creature` WHERE `guid`=@CGUID+1; +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`, `VerifiedBuild`) VALUES +(@CGUID+1, 180803, 2450, 13561, 13653, '14,15,16', 0, 0, 0, -1, 0, 1, 284.060, -781.086, 4105.022, 3.91, 7200, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, '', 41079); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=180803 AND `spell_id`=358839; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(180803, 358839, 1, 0); + +DELETE FROM `spell_target_position` WHERE `ID`=358839 AND `EffectIndex`=0; +INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES +(358839, 0, 2450, 233.3006, -540.5422, 3707.7519, 41079); + +-- 175732 - Sylvanas Windrunner +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=1000, `unit_flags`=832, `unit_flags3`=0, `speed_walk`=1.60000002384185791, `speed_run`=2, `VehicleId`=7461, `mechanic_immune_mask`=617299839, `ScriptName`='boss_sylvanas_windrunner' WHERE `entry`=175732; + +DELETE FROM `creature_template_addon` WHERE `entry`=175732; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `SheathState`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(175732, 0, 0, 0, 0, 0, 0, 0, 5, ''); + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=175732; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(175732, 14, 3, 3, 2104, 8, 1508.0799560546875, 1, 204623, 2097260, 65664, 50791), +(175732, 15, 3, 3, 2105, 8, 1596.1300048828125, 1, 204624, 2097260, 65664, 50791), +(175732, 16, 3, 3, 2106, 8, 1817.760009765625, 1, 204625, 2097260, 65664, 50791), +(175732, 17, 3, 3, 2107, 8, 1443.760009765625, 1, 204626, 2097260, 65664, 50791); + +DELETE FROM `creature_equip_template` WHERE `CreatureID`=175732; +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`) VALUES +(175732, 1, 185997, 0, 0, 185997, 0, 0, 181374, 0, 41079); + +DELETE FROM `creature_model_info` WHERE `DisplayID`=101311; +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(101311, 1.15358, 4, 0, 50791); + +DELETE FROM `creature` WHERE `guid`=@CGUID+0; +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`, `VerifiedBuild`) VALUES +(@CGUID+0, 175732, 2450, 13561, 13653, '14,15,16,17', 0, 0, 0, -1, 0, 1, 225.432, -843.832, 4105.07, 4.05589, 7200, 0, 0, 33925767, 100, 0, NULL, NULL, NULL, NULL, '', 41079); + +DELETE FROM `creature_text` WHERE `CreatureID`=175732; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `SoundPlayType`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(175732, 0, 0, 'Very well. Death it is!', 14, 0, 100, 0, 0, 181475, 0, 210319, 0, 'Aggro'), +(175732, 1, 0, 'Fall, hero!', 14, 0, 100, 0, 0, 181499, 0, 210320, 0, 'Slay 01'), +(175732, 1, 1, 'Fuel for the Maw!', 14, 0, 100, 0, 0, 181500, 0, 210321, 0, 'Slay 02'), +(175732, 1, 2, 'You always were weak!', 14, 0, 100, 0, 0, 181501, 0, 210322, 0, 'Slay 03'), +(175732, 2, 0, 'The cycle will be broken. At long last, we will have justice.', 14, 0, 100, 0, 0, 181476, 0, 210323, 0, 'Disengage'), +(175732, 3, 0, '|TInterface\\ICONS\\Achievement_Leader_Sylvanas.blp:20|t %s obtains |cFFFF0000|Hspell:347504|h[Windrunner]|h|r!', 41, 0, 100, 0, 0, 0, 0, 0, 0, 'Windrunner announce'), +(175732, 4, 0, 'No mercy!', 14, 0, 100, 0, 0, 181471, 0, 210324, 0, 'Shadow Dagger'), +(175732, 5, 0, 'To the death!', 14, 0, 100, 0, 0, 181473, 0, 210326, 0, 'Desecrating Shot'), +(175732, 6, 0, 'I never miss!', 14, 0, 100, 0, 0, 181474, 0, 210327, 0, 'Wailing Arrow 01'), +(175732, 6, 1, 'I always hit my mark.', 14, 0, 100, 0, 0, 181470, 0, 210339, 0, 'Wailing Arrow 02'), +(175732, 7, 0, '|TInterface\\Icons\\ABILITY_THEBLACKARROW.BLP:20|t %s begins to cast |cFFFF0000|Hspell:347609|h[Wailing Arrow]|h|r!', 41, 0, 100, 0, 0, 0, 0, 0, 0, 'Wailing Arrow announce'), +(175732, 8, 0, '|TInterface\\Icons\\ABILITY_THEBLACKARROW.BLP:20|t You have been targetted by |cFFFF0000|Hspell:347609|h[Wailing Arrow]|h|r!', 41, 0, 100, 0, 0, 0, 0, 0, 5, 'Wailing Arrow target announce'), +(175732, 9, 0, 'The past shackles you!', 14, 0, 100, 0, 0, 181344, 0, 210328, 0, 'Domination Chains'), +(175732, 10, 0, '|TInterface\\Icons\\INV_BELT_44.BLP:20|t %s begins to cast |cFFFF0000|Hspell:349458|h[Domination Chains]|h|r!', 41, 0, 100, 0, 0, 0, 0, 0, 0, 'Domination Chains announce'), +(175732, 11, 0, '|TInterface\\Icons\\Ability_Argus_DeathFog.blp:20|t %s begins to cast |cFFFF0000|Hspell:347704|h[Veil of Darkness]|h|r!', 41, 0, 100, 0, 0, 0, 0, 0, 0, 'Veil of Darkness announce'), +(175732, 12, 0, 'Darkness take you!', 14, 0, 100, 0, 0, 181341, 0, 211262, 0, 'Veil of Darkness 01 (Phase 1)'), +(175732, 13, 0, 'You are unfit to stand against me!', 14, 0, 100, 0, 0, 181345, 0, 210329, 0, 'Begin Intermission'), +(175732, 14, 0, '|TInterface\\ICONS\\SPELL_SHADOW_SOULLEECH_3.BLP:20|t %s begins to cast |cFFFF0000|Hspell:348109|h[Banshee Wail]|h|r!', 41, 0, 100, 0, 0, 0, 0, 0, 0, 'Banshee Wail announce'), +(175732, 15, 0, 'Your lives end here!', 14, 0, 100, 0, 0, 181337, 0, 210402, 0, 'Finish Intermission'), +(175732, 16, 0, '|TInterface\\ICONS\\UI_darkshore_warfront_horde_banshee.BLP:20|t %s begins to cast |cFFFF0000|Hspell:351869|h[Haunting Wave]|h|r!', 41, 0, 100, 0, 0, 0, 0, 0, 0, 'Haunting Wave announce'), +(175732, 17, 0, '|TInterface\\ICONS\\Ability_IronMaidens_ConvulsiveShadows.BLP:20|t %s begins to cast |cFFFF0000|Hspell:355540|h[Ruin]|h|r!', 41, 0, 100, 0, 0, 181479, 0, 0, 0, 'Ruin announce'), +(175732, 18, 0, 'I shattered your throne. Now I\'ll break you!', 14, 0, 100, 0, 0, 181529, 0, 210344, 0, 'Winds of Icecrown 01'), +(175732, 19, 0, 'All hope is lost!', 14, 0, 100, 0, 0, 181340, 0, 210338, 0, 'Veil of Darkness 01 (Phase 2-3)'), +(175732, 19, 1, 'Suffer my wrath!', 14, 0, 100, 0, 0, 181339, 0, 210342, 0, 'Veil of Darkness 02 (Phase 2-3)'), +(175732, 19, 2, 'Nothing escapes my wrath!', 14, 0, 100, 0, 0, 181339, 0, 210336, 0, 'Veil of Darkness 03 (Phase 2-3)'), +(175732, 19, 3, 'Fall into oblivion!', 14, 0, 100, 0, 0, 181347, 0, 211258, 0, 'Veil of Darkness 04 (Phase 2-3)'), +(175732, 20, 0, 'Hear the sound of suffering!', 14, 0, 100, 0, 0, 181338, 0, 211266, 0, 'Banshee Wail and Scream 01'), +(175732, 20, 1, 'Death awaits you!', 14, 0, 100, 0, 0, 181336, 0, 210401, 0, 'Banshee Wail and Scream 02'), +(175732, 21, 0, '|TInterface\\ICONS\\ABILITY_WARLOCK_IMPROVEDSOULLEECH.BLP:20|t %s begins to cast |cFFFF0000|Hspell:353955|h[Banshee Scream]|h|r!', 41, 0, 100, 0, 0, 181336, 0, 0, 0, 'Banshee Scream announce'), +(175732, 22, 0, 'You will pay. All of you will pay!', 14, 0, 100, 0, 0, 181530, 0, 210346, 0, 'Winds of Icecrown 02'), +(175732, 23, 0, 'Death bends to my will!', 14, 0, 100, 0, 0, 181343, 0, 210354, 0, 'Phase 3 Start'), +(175732, 24, 0, 'Heed the call of the Banshee Queen!', 14, 0, 100, 0, 0, 181334, 0, 210349, 0, 'Banshee\'s Fury 01'), +(175732, 24, 1, 'Hear my cry and despair!', 14, 0, 100, 0, 0, 181335, 0, 210350, 0, 'Banshee\'s Fury 02'), +(175732, 25, 0, '|TInterface\\ICONS\\Spell_AnimaMaw_GroundState.blp:20|t %s begins to cast |cFFFF0000|Hspell:354145|h[Raze]|h|r!', 41, 0, 100, 0, 0, 0, 0, 0, 0, 'Raze announce'), +(175732, 26, 0, 'Shadows draw near!', 14, 0, 100, 0, 0, 181354, 0, 210352, 0, 'Black Arrow 01'), +(175732, 26, 1, 'Do you fear the shadows?', 14, 0, 100, 0, 0, 181353, 0, 210351, 0, 'Black Arrow 02'), +(175732, 27, 0, '|TInterface\\Icons\\ABILITY_THEBLACKARROW.BLP:20|t %s begins to cast |cFFFF0000|Hspell:358704|h[Black Arrow]|h|r!', 41, 0, 100, 0, 0, 0, 0, 0, 0, 'Black Arrow announce'), +(175732, 28, 0, '|TInterface\\Icons\\ABILITY_THEBLACKARROW.BLP:20|t You have been targetted by |cFFFF0000|Hspell:358704|h[Black Arrow]|h|r!', 41, 0, 100, 0, 0, 0, 0, 0, 5, 'Black Arrow target announce'), +(175732, 29, 0, 'A new age beckons, but you are unworthy of a place in it!', 14, 0, 100, 0, 0, 181349, 0, 210356, 0, 'RP during Rive 01'), +(175732, 30, 0, 'Zovaal will not be denied!', 14, 0, 100, 0, 0, 181348, 0, 210357, 0, 'RP during Rive 01'); + +DELETE FROM `creature_text_locale` WHERE `CreatureID`=175732; +INSERT INTO `creature_text_locale` (`CreatureID`, `GroupID`, `ID`, `Locale`, `Text`) VALUES +(175732, 3, 0, 'esES', '|TInterface\\ICONS\\Achievement_Leader_Sylvanas.blp:20|t ¡%s obtiene |cFFFF0000|Hspell:347504|h[Brisaveloz]|h|r!'), +(175732, 7, 0, 'esES', '|TInterface\\Icons\\ABILITY_THEBLACKARROW.BLP:20|t ¡%s empieza a lanzar |cFFFF0000|Hspell:347609|h[Flecha lastimera]|h|r!'), +(175732, 8, 0, 'esES', '|TInterface\\Icons\\ABILITY_THEBLACKARROW.BLP:20|t ¡Eres el objetivo de |cFFFF0000|Hspell:347609|h[Flecha lastimera]|h|r!'), +(175732, 10, 0, 'esES', '|TInterface\\Icons\\INV_BELT_44.BLP:20|t ¡%s empieza a lanzar |cFFFF0000|Hspell:349458|h[Cadenas de dominación]|h|r!'), +(175732, 11, 0, 'esES', '|TInterface\\Icons\\Ability_Argus_DeathFog.blp:20|t ¡%s empieza a lanzar |cFFFF0000|Hspell:347704|h[Velo de oscuridad]|h|r!'), +(175732, 14, 0, 'esES', '|TInterface\\ICONS\\SPELL_SHADOW_SOULLEECH_3.BLP:20|t ¡%s empieza a lanzar |cFFFF0000|Hspell:348109|h[Lamento de alma en pena]|h|r!'), +(175732, 16, 0, 'esES', '|TInterface\\ICONS\\UI_darkshore_warfront_horde_banshee.BLP:20|t ¡%s empieza a lanzar |cFFFF0000|Hspell:351869|h[Oleada inquietante]|h|r!'), +(175732, 17, 0, 'esES', '|TInterface\\ICONS\\Ability_IronMaidens_ConvulsiveShadows.BLP:20|t ¡%s empieza a lanzar |cFFFF0000|Hspell:355540|h[Ruina]|h|r!'), +(175732, 21, 0, 'esES', '|TInterface\\ICONS\\ABILITY_WARLOCK_IMPROVEDSOULLEECH.BLP:20|t ¡%s empieza a lanzar |cFFFF0000|Hspell:353955|h[Alarido de alma en pena]|h|r!'), +(175732, 27, 0, 'esES', '|TInterface\\Icons\\ABILITY_THEBLACKARROW.BLP:20|t ¡%s empieza a lanzar |cFFFF0000|Hspell:358704|h[Flecha negra]|h|r!'), +(175732, 28, 0, 'esES', '|TInterface\\Icons\\ABILITY_THEBLACKARROW.BLP:20|t ¡Eres el objetivo de |cFFFF0000|Hspell:358704|h[Flecha negra]|h|r!'); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=175732; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(175732, 46598, 0, 0); + +DELETE FROM `vehicle_template_accessory` WHERE `entry`=175732; +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(175732, 178355, 0, 0, 'Sylvanas Windrunner - Shadowcopy (Riding)', 6, 30000); + +DELETE FROM `creature_summon_groups` WHERE `summonerId`=175732; +INSERT INTO `creature_summon_groups` (`summonerId`, `summonerType`, `groupId`, `entry`, `position_x`, `position_y`, `position_z`, `orientation`, `summonType`, `summonTime`, `Comment`) VALUES +(175732, 0, 0, 176532, 243.661, -804.615, 4105.07, 4.28529, 8, 0, 'Thrall - Sylvanas Windrunner Encounter'), +(175732, 0, 0, 176533, 231.595, -801.5, 4105.07, 5.02181, 8, 0, 'Jaina - Sylvanas Windrunner Encounter'), +(175732, 0, 0, 178081, 239.795, -806.064, 4105.07, 4.77206, 8, 0, 'Bolvar - Sylvanas Windrunner Encounter'); + +-- 176920 - Domination Arrow +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags2`=4194304, `unit_flags3`=1 WHERE `entry`=176920; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=176920; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(176920, 14, 0, 0, 2104, 8, 1.20000004768371582, 1, 204759, 16778272, 144, 50791), +(176920, 15, 0, 0, 2105, 8, 1.35000002384185791, 1, 204760, 16778272, 144, 50791), +(176920, 16, 0, 0, 2106, 8, 2.549999952316284179, 1, 204761, 16778272, 144, 50791), +(176920, 17, 0, 0, 2107, 8, 1.20000004768371582, 1, 204762, 16778272, 144, 50791); + +-- 178355 - Sylvanas Shadowcopy (Riding) +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=35653664, `unit_flags3`=1, `ScriptName`='npc_sylvanas_windrunner_shadowcopy_riding' WHERE `entry`=178355; + +DELETE FROM `creature_template_addon` WHERE `entry`=178355; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `SheathState`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(178355, 0, 0, 1, 0, 0, 0, 0, 3, ''); + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=178355; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(178355, 14, 0, 0, 2104, 8, 1, 1, 201696, 16778240, 16, 50791), +(178355, 15, 0, 0, 2105, 8, 1, 1, 201696, 16778240, 16, 50791), +(178355, 16, 0, 0, 2106, 8, 1, 1, 201696, 16778240, 16, 50791), +(178355, 17, 0, 0, 2107, 8, 1, 1, 201696, 16778240, 16, 50791); + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=178355; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(178355, 1, 0, 1, 0, 0, 0); + +-- 176369 - Sylvanas +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2099200, `unit_flags3`=1 WHERE `entry`=176369; + +UPDATE `creature_template_addon` SET `visibilityDistanceType`=3 WHERE `entry`=176369; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=176369; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(176369, 14, 0, 0, 2104, 8, 1, 1, 199018, 0, 0, 50791), +(176369, 15, 0, 0, 2105, 8, 1, 1, 199018, 0, 0, 50791), +(176369, 16, 0, 0, 2106, 8, 1, 1, 199018, 0, 0, 50791), +(176369, 17, 0, 0, 2107, 8, 1, 1, 199018, 0, 0, 50791); + +-- 178081 - Highlord Bolvar Fordragon +UPDATE `creature_template` SET `faction`=35, `npcflag`=0, `speed_walk`=1.20000004768371582, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=0, `unit_flags3`=65568, `ScriptName`='npc_sylvanas_windrunner_bolvar' WHERE `entry`=178081; + +DELETE FROM `creature_template_addon` WHERE `entry`=178081; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `SheathState`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(178081, 0, 0, 0, 1, 506, 0, 0, 0, 5, ''); + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=178081; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(178081, 14, 0, 0, 837, 8, 100, 1, 201344, 0, 128, 50791), +(178081, 15, 0, 0, 837, 8, 100, 1, 201344, 0, 128, 50791), +(178081, 16, 0, 0, 837, 8, 100, 1, 201344, 0, 128, 50791), +(178081, 17, 0, 0, 837, 8, 100, 1, 201344, 0, 128, 50791); + +DELETE FROM `creature_model_info` WHERE `DisplayID`=101964; +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(101964, 0.441236436367034912, 2.099999904632568359, 0, 50791); + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=178081; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(178081, 1, 0, 0, 0, 0, 0); + +DELETE FROM `creature_text` WHERE `CreatureID`=178081; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `SoundPlayType`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(178081, 0, 0, 'Behind our quarry. Heroes, with me!', 14, 0, 100, 0, 0, 181488, 0, 210387, 0, ''), +(178081, 1, 0, 'By the Light! He\'s expanding the Maw around Oribos!', 14, 0, 100, 0, 0, 181477, 0, 211265, 0, ''), +(178081, 2, 0, 'The Banshee is aiming at our heads!', 14, 0, 100, 0, 0, 181479, 0, 211259, 0, ''), +(178081, 3, 0, 'This power is not yours to command!', 14, 0, 100, 0, 0, 181602, 0, 210390, 0, ''), +(178081, 4, 0, 'Your crusade ends here, Banshee! ', 14, 0, 100, 0, 0, 181523, 0, 211458, 0, ''), +(178081, 5, 0, 'Thrall, scout ahead. Champions, we\'ll assist the admiral!', 14, 0, 100, 0, 0, 181570, 0, 211261, 0, ''), +(178081, 6, 0, 'Thrall won\'t last much longer on his own. We need to reach him!', 14, 0, 100, 0, 0, 181578, 0, 211270, 0, ''), +(178081, 7, 0, 'Sylvanas means to claim our heads! Stop her!', 14, 0, 100, 0, 0, 181480, 0, 211267, 0, ''), +(178081, 8, 0, 'Press the attack! The Jailer must be stopped.', 14, 0, 100, 0, 0, 181478, 0, 211264, 0, ''), +(178081, 9, 0, 'We\'re done with your games, Sylvanas!', 14, 0, 100, 0, 0, 181603, 0, 210391, 0, ''), +(178081, 10, 0, 'This time you\'ll lose, Sylvanas!', 14, 0, 100, 0, 0, 181524, 0, 211459, 0, ''), +(178081, 11, 0, 'No! The Jailer is going to destroy the Arbiter!', 14, 0, 100, 0, 0, 181604, 0, 211464, 0, ''); + +-- 176532 - Thrall +UPDATE `creature_template` SET `faction`=35, `npcflag`=0, `speed_walk`=1.20000004768371582, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=0, `unit_flags3`=65568, `ScriptName`='npc_sylvanas_windrunner_thrall' WHERE `entry`=176532; + +DELETE FROM `creature_template_addon` WHERE `entry`=176532; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `SheathState`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(176532, 0, 0, 0, 1, 505, 0, 0, 0, 5, ''); + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=176532; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(176532, 14, 2, 2, 2104, 8, 100, 1, 199181, 0, 128, 50791), +(176532, 15, 2, 2, 2105, 8, 100, 1, 199181, 0, 128, 50791), +(176532, 16, 2, 2, 2106, 8, 100, 1, 199181, 0, 128, 50791), +(176532, 17, 2, 2, 2107, 8, 100, 1, 199181, 0, 128, 50791); + +DELETE FROM `creature_equip_template` WHERE `CreatureID` = 176532; +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`) VALUES +(176532, 1, 168268, 0, 0, 0, 0, 0, 0, 0, 0); + +DELETE FROM `creature_model_info` WHERE `DisplayID`=101963; +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(101963, 0.665421724319458007, 1, 0, 50791); + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=176532; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(176532, 1, 0, 0, 0, 0, 0); + +DELETE FROM `creature_text` WHERE `CreatureID`=176532; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `SoundPlayType`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(176532, 0, 0, 'Blood and thunder!', 14, 0, 100, 0, 0, 181590, 0, 210382, 0, ''), +(176532, 1, 0, 'I\'ve opened the way! Go! Stop Sylvanas!', 14, 0, 100, 0, 0, 181580, 0, 210371, 0, ''), +(176532, 2, 0, 'Yield, Sylvanas!', 14, 0, 100, 0, 0, 181527, 0, 211453, 0, ''), +(176532, 3, 0, 'With me, champions! Jaina needs our strength!', 14, 0, 100, 0, 0, 181579, 0, 210373, 0, ''), +(176532, 4, 0, 'My defenses falter!', 14, 0, 100, 0, 0, 181577, 0, 210386, 0, ''), +(176532, 5, 0, 'Is there no end to these creatures?!', 14, 0, 100, 0, 0, 181484, 0, 211450, 0, ''), +(176532, 6, 0, 'Their forces are numberless!', 14, 0, 100, 0, 0, 181483, 0, 211449, 0, ''), +(176532, 7, 0, 'I\'m in your debt, Highlord.', 12, 0, 100, 0, 0, 181534, 0, 210383, 0, ''), +(176532, 8, 0, 'Heroes, to me! Let\'s regroup with Jaina!', 14, 0, 100, 0, 0, 181581, 0, 210375, 0, ''), +(176532, 9, 0, 'For Saurfang! For the Horde! ', 14, 0, 100, 0, 0, 181528, 0, 211454, 0, ''), +(176532, 10, 0, 'The Arbiter\'s defenses are weakening! Stop the Jailer while we still can!', 14, 0, 100, 0, 0, 181606, 0, 211463, 0, ''); + +-- 176533 - Lady Jaina Proudmoore +UPDATE `creature_template` SET `faction`=35, `npcflag`=0, `speed_walk`=1.60000002384185791, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=0, `unit_flags3`=65568, `ScriptName`='npc_sylvanas_windrunner_jaina' WHERE `entry`=176533; + +DELETE FROM `creature_template_addon` WHERE `entry`=176533; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `SheathState`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(176533, 0, 0, 0, 1, 654, 0, 0, 0, 5, ''); + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=176533; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(176533, 14, 0, 0, 2104, 8, 100, 1, 199182, 0, 128, 50791), +(176533, 15, 0, 0, 2105, 8, 100, 1, 199182, 0, 128, 50791), +(176533, 16, 0, 0, 2106, 8, 100, 1, 199182, 0, 128, 50791), +(176533, 17, 0, 0, 2107, 8, 100, 1, 199182, 0, 128, 50791); + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=176533; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(176533, 1, 0, 0, 0, 0, 0); + +DELETE FROM `creature_equip_template` WHERE `CreatureID`=176533; +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`) VALUES +(176533, 1, 153575, 0, 0, 0, 0, 0, 0, 0, 0); + +DELETE FROM `creature_model_info` WHERE `DisplayID`=101962; +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(101962, 0.435065627098083496, 0, 0, 50791); + +DELETE FROM `creature_text` WHERE `CreatureID`=176533; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `SoundPlayType`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(176533, 0, 0, 'Something is limiting my magic. Where are we?', 12, 0, 100, 0, 0, 181487, 0, 210368, 0, ''), +(176533, 1, 0, 'Is the Jailer trying to break out of the Maw... or something else?', 12, 0, 100, 0, 0, 181489, 0, 211274, 0, ''), +(176533, 2, 0, 'Heroes! I need aid!', 14, 0, 100, 0, 0, 181569, 0, 210366, 0, ''), +(176533, 3, 0, 'There\'s too many of them!', 14, 0, 100, 0, 0, 181482, 0, 211452, 0, ''), +(176533, 4, 0, 'Thank you, Bolvar.', 12, 0, 100, 0, 0, 181533, 0, 210367, 0, ''), +(176533, 5, 0, 'Quickly, champions! Stop Sylvanas!', 14, 0, 100, 0, 0, 181584, 0, 210358, 0, ''), +(176533, 6, 0, 'Hurry! Thrall needs us!', 14, 0, 100, 0, 0, 181583, 0, 210359, 0, ''), +(176533, 7, 0, 'You don\'t have to do this! Surrender! ', 14, 0, 100, 0, 0, 181526, 0, 211456, 0, ''), +(176533, 8, 0, 'Sylvanas! Give Anduin to me!', 14, 0, 100, 0, 0, 181525, 0, 211455, 0, ''), +(176533, 9, 0, 'We\'re out of time! Oribos is being enveloped by the Maw!', 14, 0, 100, 0, 0, 181490, 0, 211271, 0, ''), +(176533, 10, 0, 'Hold them back a little longer. The portal\'s nearly open!', 14, 0, 100, 0, 0, 181491, 0, 210369, 0, ''), +(176533, 11, 0, 'It\'s done! Hurry! ', 14, 0, 100, 0, 0, 181492, 0, 210370, 0, ''), +(176533, 12, 0, 'He\'s done it. The Arbiter falls...', 14, 0, 100, 0, 0, 181499, 0, 211465, 0, ''); + +-- 177891 - Mawforged Summoner +UPDATE `creature_template` SET `faction`=16, `speed_walk`=1.20000004768371582, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33587200, `unit_flags2`=2099200 WHERE `entry`=177891; + +DELETE FROM `creature_template_addon` WHERE `entry` IN (177891); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(177891, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''); + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=177891; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(177891, 14, 2, 2, 2104, 8, 22.18000030517578125, 1, 203458, 2097224, 128, 50791), +(177891, 15, 2, 2, 2105, 8, 19.28000068664550781, 1, 203459, 2097224, 128, 50791), +(177891, 16, 2, 2, 2106, 8, 16.93000030517578125, 1, 203460, 2097224, 128, 50791), +(177891, 17, 2, 2, 2107, 8, 19.45000076293945312, 1, 203461, 2097224, 128, 50791); + +-- 177154 - Mawsworn Vanguard +UPDATE `creature_template` SET `faction`=16, `speed_walk`=1.20000004768371582, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33587200, `unit_flags2`=2099200 WHERE `entry`=177154; + +DELETE FROM `creature_template_addon` WHERE `entry` IN (177154); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(177154, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, ''); + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=177154; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(177154, 14, 1, 1, 2104, 8, 1.5, 1, 204633, 2097256, 128, 50791), +(177154, 15, 1, 1, 2105, 8, 1.5, 1, 204634, 2097256, 128, 50791), +(177154, 16, 1, 1, 2106, 8, 1.75, 1, 204091, 2097224, 128, 50791), +(177154, 17, 1, 1, 2107, 8, 1.5, 1, 204635, 2097256, 128, 50791); + +-- 177889 - Mawforged Souljudge +UPDATE `creature_template` SET `faction`=16, `speed_walk`=1.20000004768371582, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33587200, `unit_flags2`=2097152 WHERE `entry`=177889; + +UPDATE `creature_template_addon` SET `visibilityDistanceType`=3 WHERE `entry`=177889; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=177889; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(177889, 14, 2, 2, 2104, 8, 23.47999954223632812, 1, 203454, 2097224, 128, 50791), +(177889, 15, 2, 2, 2105, 8, 20.42000007629394531, 1, 203455, 2097224, 128, 50791), +(177889, 16, 2, 2, 2106, 8, 17.87000083923339843, 1, 203456, 2097224, 128, 50791), +(177889, 17, 2, 2, 2107, 8, 20.59000015258789062, 1, 203457, 2097224, 128, 50791); + +-- 178008 - Decrepit Orb +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=35651584, `unit_flags3`=1 WHERE `entry`=178008; + +UPDATE `creature_template_addon` SET `visibilityDistanceType`=3 WHERE `entry`=178008; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=178008; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(178008, 14, 1, 1, 2104, 8, 0.5, 1, 203448, 2097224, 128, 50791), +(178008, 15, 1, 1, 2105, 8, 0.5, 1, 203446, 2097224, 128, 41488), +(178008, 16, 1, 1, 2106, 8, 0.5, 1, 203447, 2097224, 128, 50791), +(178008, 17, 1, 1, 2107, 8, 0.5, 1, 203449, 2097224, 128, 50791); + +-- 177892 - Mawforged Goliath +UPDATE `creature_template` SET `faction`=16, `speed_walk`=6, `speed_run`=2.142857074737548828, `BaseAttackTime`=3000, `unit_flags`=33587200, `unit_flags2`=2099200 WHERE `entry`=177892; + +UPDATE `creature_template_addon` SET `visibilityDistanceType`=3 WHERE `entry`=177892; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=177892; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(177892, 14, 2, 2, 2104, 8, 26.09000015258789062, 1, 203450, 2097224, 128, 41359), +(177892, 15, 2, 2, 2105, 8, 22.69000053405761718, 1, 203451, 2097224, 128, 50791), +(177892, 16, 2, 2, 2106, 8, 18.80999946594238281, 1, 203452, 2097224, 128, 50791), +(177892, 17, 2, 2, 2107, 8, 22.87999916076660156, 1, 203453, 2097224, 128, 50791); + +-- 177787 - Mawsworn Hopebreaker +UPDATE `creature_template` SET `faction`=16, `speed_walk`=1.20000004768371582, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33587200, `unit_flags2`=2099200 WHERE `entry`=177787; + +UPDATE `creature_template_addon` SET `visibilityDistanceType`=3 WHERE `entry`=177787; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=177787; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(177787, 14, 1, 1, 2104, 8, 2, 1, 201046, 2097256, 128, 50791), +(177787, 15, 1, 1, 2105, 8, 2, 1, 201046, 2097256, 128, 50791), +(177787, 16, 1, 1, 2106, 8, 2, 1, 204092, 2097224, 128, 50791), +(177787, 17, 1, 1, 2107, 8, 2, 1, 201046, 2097256, 128, 50791); + +-- 177893 - Mawforged Colossus +UPDATE `creature_template` SET `faction`=16, `speed_walk`=2.799999952316284179, `speed_run`=2, `BaseAttackTime`=2000, `unit_flags`=33587200, `unit_flags2`=2099200 WHERE `entry`=177893; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=177893; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(177893, 16, 2, 2, 2106, 8, 26.87000083923339843, 1, 204640, 2097256, 4224, 50791); + +-- 180623 - Focusing Prism +UPDATE `creature_template` SET `unit_flags3`=16777217 WHERE `entry`=180623; + +UPDATE `creature_template_addon` SET `auras`='358153' WHERE `entry`=180623; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=180623; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(180623, 14, 0, 0, 2104, 8, 1, 1, 204285, 1627390992, 117440534, 50791), +(180623, 15, 0, 0, 2105, 8, 1, 1, 204285, 1627390992, 117440534, 50791), +(180623, 16, 0, 0, 2106, 8, 1, 1, 204285, 1627390992, 117440534, 50791), +(180623, 17, 0, 0, 2107, 8, 1, 1, 204285, 1627390992, 117440534, 50791); + +-- 178072 - Anduin Wrynn +UPDATE `creature_template` SET `faction`=14, `npcflag`=35184372088832, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=71303168, `unit_flags3`=98336, `VehicleId`=584 WHERE `entry`=178072; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=178072; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(178072, 14, 2, 2, 2104, 8, 500, 1, 201335, 4, 128, 50791), +(178072, 15, 2, 2, 2105, 8, 500, 1, 201335, 4, 128, 50791), +(178072, 16, 2, 2, 2106, 8, 500, 1, 201335, 4, 128, 50791), +(178072, 17, 2, 2, 2107, 8, 500, 1, 201335, 4, 128, 50791); + +-- 178082 - The Arbiter +UPDATE `creature_template` SET `faction`=35, `speed_walk`=0.699999988079071044, `speed_run`=0.25, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=71827456, `unit_flags3`=32769 WHERE `entry`=178082; + +UPDATE `creature_template_addon` SET `visibilityDistanceType`=4 WHERE `entry`=178082; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=178082; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(178082, 14, 0, 0, 2104, 8, 500, 1, 201345, 4, 67108992, 50791), +(178082, 15, 0, 0, 2105, 8, 500, 1, 201345, 4, 67108992, 50791), +(178082, 16, 0, 0, 2106, 8, 500, 1, 201345, 4, 67108992, 50791), +(178082, 17, 0, 0, 2107, 8, 500, 1, 201345, 4, 67108992, 50791); + +-- 178079 - The Jailer +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=71303168, `unit_flags3`=32769, `VehicleId`=7513 WHERE `entry`=178079; + +UPDATE `creature_template_addon` SET `visibilityDistanceType`=4 WHERE `entry`=178079; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=178079; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(178079, 14, 3, 3, 2104, 8, 500, 1, 201342, 4, 67108992, 50791), +(178079, 15, 3, 3, 2105, 8, 500, 1, 201342, 4, 67108992, 50791), +(178079, 16, 3, 3, 2106, 8, 500, 1, 201342, 4, 67108992, 50791), +(178079, 17, 3, 3, 2107, 8, 500, 1, 201342, 4, 67108992, 50791); + +-- 179261 - Sylvanas +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=33556512, `unit_flags3`=1, `VehicleId`=7514 WHERE `entry`=179261; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=179261; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(179261, 14, 0, 0, 2104, 8, 1, 1, 202784, 16778240, 16, 50791), +(179261, 15, 0, 0, 2105, 8, 1, 1, 202784, 16778240, 16, 50791), +(179261, 16, 0, 0, 2106, 8, 1, 1, 202784, 16778240, 16, 50791), +(179261, 17, 0, 0, 2107, 8, 1, 1, 202784, 16778240, 16, 50791); + +-- 179787 - Sylvanas +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=33556512, `unit_flags3`=1, `VehicleId`=7535 WHERE `entry`=179787; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=179787; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(179787, 14, 0, 0, 2104, 8, 1, 1, 203323, 16778240, 16, 50791), +(179787, 15, 0, 0, 2105, 8, 1, 1, 203323, 16778240, 16, 50791), +(179787, 16, 0, 0, 2106, 8, 1, 1, 203323, 16778240, 16, 50791), +(179787, 17, 0, 0, 2107, 8, 1, 1, 203323, 16778240, 16, 50791); + +-- 179784 - Sylvanas +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=33556512, `unit_flags3`=1, `VehicleId`=7533 WHERE `entry`=179784; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=179784; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(179784, 14, 0, 0, 2104, 8, 1, 1, 203320, 16778240, 16, 50791), +(179784, 15, 0, 0, 2105, 8, 1, 1, 203320, 16778240, 16, 50791), +(179784, 16, 0, 0, 2106, 8, 1, 1, 203320, 16778240, 16, 50791), +(179784, 17, 0, 0, 2107, 8, 1, 1, 203320, 16778240, 16, 50791); + +-- 179788 - Sylvanas +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=33556512, `unit_flags3`=1, `VehicleId`=7536 WHERE `entry`=179788; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=179788; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(179788, 14, 0, 0, 2104, 8, 1, 1, 203324, 16778240, 16, 50791), +(179788, 15, 0, 0, 2105, 8, 1, 1, 203324, 16778240, 16, 50791), +(179788, 16, 0, 0, 2106, 8, 1, 1, 203324, 16778240, 16, 50791), +(179788, 17, 0, 0, 2107, 8, 1, 1, 203324, 16778240, 16, 50791); + +-- 179262 - Sylvanas +DELETE FROM `creature_template_difficulty` WHERE `Entry`=179262; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(179262, 14, 0, 0, 2104, 8, 1, 1, 202785, 16778240, 16, 50791), +(179262, 15, 0, 0, 2105, 8, 1, 1, 202785, 16778240, 16, 50791), +(179262, 16, 0, 0, 2106, 8, 1, 1, 202785, 16778240, 16, 50791), +(179262, 17, 0, 0, 2107, 8, 1, 1, 202785, 16778240, 16, 50791); + +-- 182021 - Death Gate (Teleporter from The Crucible to Sanctum of Domination's entrance) +UPDATE `creature_template` SET `unit_flags3`=16777216 WHERE `entry`=182021; + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=182021; +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(182021, 14, 0, 0, 2104, 8, 1, 1, 205820, 1610612752, 6, 50791), +(182021, 15, 0, 0, 2105, 8, 1, 1, 205820, 1610612752, 6, 50791), +(182021, 16, 0, 0, 2106, 8, 1, 1, 205820, 1610612752, 6, 50791), +(182021, 17, 0, 0, 2107, 8, 1, 1, 205820, 1610612752, 6, 50791); + +-- 368743 - Torghast Spike +-- 368744 - Torghast Spike +-- 368745 - Torghast Spike +-- 368746 - Torghast Spike +-- 368747 - Torghast Spike +-- 368748 - Torghast Spike +-- 368749 - Torghast Spike +-- 368750 - Torghast Spike +-- 368751 - Torghast Spike +-- 368752 - Torghast Spike +-- 368753 - Torghast Spike +-- 368754 - Torghast Spike +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (368743, 368744, 368745, 368746, 368747, 368748, 368749, 368750, 368751, 368752, 368753, 368754); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `mingold`, `maxgold`, `WorldEffectID`, `AIAnimKitID`) VALUES +(368743, 1375, 0, 0, 0, 0, 0), +(368744, 1375, 0, 0, 0, 0, 0), +(368745, 1375, 0, 0, 0, 0, 0), +(368746, 1375, 0, 0, 0, 0, 0), +(368747, 1375, 0, 0, 0, 0, 0), +(368748, 1375, 0, 0, 0, 0, 0), +(368749, 1375, 0, 0, 0, 0, 0), +(368750, 1375, 0, 0, 0, 0, 0), +(368751, 1375, 0, 0, 0, 0, 0), +(368752, 1375, 0, 0, 0, 0, 0), +(368753, 1375, 0, 0, 0, 0, 0), +(368754, 1375, 0, 0, 0, 0, 0); + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+11; +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, 368743, 2450, 13561, 13653, '14,15,16,17', 0, 0, 305.796173095703125, -801.1678466796875, 4105.228515625, 3.535023689270019531, 0, 0, -0.9807138442993164, 0.19544917345046997, 7200, 255, 1, 41079), +(@OGUID+1, 368744, 2450, 13561, 13653, '14,15,16,17', 0, 0, 289.4208984375, -775.50555419921875, 4105.228515625, 3.957568168640136718, 0, 0, -0.91792106628417968, 0.396763056516647338, 7200, 255, 1, 41079), +(@OGUID+2, 368745, 2450, 13561, 13653, '14,15,16,17', 0, 0, 263.83319091796875, -759.12677001953125, 4105.228515625, 4.214824676513671875, 0, 0, -0.85944366455078125, 0.51123046875, 7200, 255, 1, 41079), +(@OGUID+3, 368746, 2450, 13561, 13653, '14,15,16,17', 0, 0, 206.823974609375, -759.0166015625, 4105.228515625, 5.038183212280273437, 0, 0, -0.58306884765625, 0.812422752380371093, 7200, 255, 1, 41079), +(@OGUID+4, 368747, 2450, 13561, 13653, '14,15,16,17', 0, 0, 181.166412353515625, -776.0484619140625, 4105.228515625, 5.486774444580078125, 0, 0, -0.38776493072509765, 0.921758294105529785, 7200, 255, 1, 41079), +(@OGUID+5, 368748, 2450, 13561, 13653, '14,15,16,17', 0, 0, 164.420166015625, -801.205810546875, 4105.228515625, 5.90371561050415039, 0, 0, -0.1885986328125, 0.98205423355102539, 7200, 255, 1, 41079), +(@OGUID+6, 368749, 2450, 13561, 13653, '14,15,16,17', 0, 0, 164.071502685546875, -858.43328857421875, 4105.228515625, 0.348650813102722167, 0, 0, 0.173443794250488281, 0.984843790531158447, 7200, 255, 1, 41079), +(@OGUID+7, 368750, 2450, 13561, 13653, '14,15,16,17', 0, 0, 181.0986328125, -884.01446533203125, 4105.22900390625, 0.774075925350189208, 0, 0, 0.377447128295898437, 0.926031172275543212, 7200, 255, 1, 41079), +(@OGUID+8, 368751, 2450, 13561, 13653, '14,15,16,17', 0, 0, 206.4611053466796875, -900.602294921875, 4105.22900390625, 1.173270940780639648, 0, 0, 0.553562164306640625, 0.832807838916778564, 7200, 255, 1, 41079), +(@OGUID+9, 368752, 2450, 13561, 13653, '14,15,16,17', 0, 0, 263.236236572265625, -900.9161376953125, 4105.22900390625, 1.914117217063903808, 0, 0, 0.817501068115234375, 0.57592707872390747, 7200, 255, 1, 41079), +(@OGUID+10, 368753, 2450, 13561, 13653, '14,15,16,17', 0, 0, 288.707855224609375, -884.2554931640625, 4105.22900390625, 2.352296829223632812, 0, 0, 0.923131942749023437, 0.384483277797698974, 7200, 255, 1, 41079), +(@OGUID+11, 368754, 2450, 13561, 13653, '14,15,16,17', 0, 0, 305.86798095703125, -858.4576416015625, 4105.22900390625, 2.739951372146606445, 0, 0, 0.979903221130371093, 0.199473500251770019, 7200, 255, 1, 41079); + +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+11; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+0, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+1, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+2, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+3, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+4, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+5, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+6, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+7, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+8, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+9, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+10, 0, 0, 0.000000087422776573, 1, 0, 0), +(@OGUID+11, 0, 0, 0.000000087422776573, 1, 0, 0); + +-- 35 - Sylvanas Windrunner's Position Z Check (Serverside) +DELETE FROM `areatrigger_template` WHERE `Id`=@ATID+0 AND `IsServerSide`=1; +INSERT INTO `areatrigger_template` (`Id`, `IsServerSide`, `Type`, `Flags`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `VerifiedBuild`) VALUES +(@ATID+0, 1, 1, 0, 250, 250, 50, 250, 250, 50, 0, 0, 0); + +DELETE FROM `areatrigger` WHERE `SpawnId` BETWEEN @ATSPAWNID+0 AND @ATSPAWNID+3 AND `IsServerSide`=1; +INSERT INTO `areatrigger` (`SpawnId`, `AreaTriggerId`, `IsServerSide`, `MapId`, `SpawnDifficulties`, `PosX`, `PosY`, `PosZ`, `Orientation`, `PhaseUseFlags`, `PhaseId`, `PhaseGroup`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `ScriptName`, `Comment`) VALUES +(@ATSPAWNID+0, @ATID+0, 1, 2450, '14,15,16,17', 235.217, -830.563, 4074.99, 2.6387, 0, 0, 0, 1, 250, 250, 50, 250, 250, 50, 0, 0, 'at_sylvanas_windrunner_z_check', 'Sanctum of Domination - Pinnacle of Dominance (Z Check)'), +(@ATSPAWNID+1, @ATID+0, 1, 2450, '14,15,16,17', -115.461, -1102.84, 4956.29, 0.7831, 0, 0, 0, 1, 250, 250, 50, 250, 250, 50, 0, 0, 'at_sylvanas_windrunner_z_check', 'Sanctum of Domination - Edge of the Abyss (Z Check)'), +(@ATSPAWNID+2, @ATID+0, 1, 2450, '14,15,16,17', 225.434, -766.006, 4963.74, 3.9239, 0, 0, 0, 1, 250, 250, 50, 250, 250, 50, 0, 0, 'at_sylvanas_windrunner_z_check', 'Sanctum of Domination - Edge of the Abyss (Z Check)'), +(@ATSPAWNID+3, @ATID+0, 1, 2450, '14,15,16,17', -249.124, -1277.07, 5585.18, 5.48411, 0, 0, 0, 1, 250, 250, 50, 250, 250, 50, 0, 0, 'at_sylvanas_windrunner_z_check', 'Sanctum of Domination - The Crucible (Z Check)'); + +-- 36 - Sylvanas Windrunner's Conversation Introduction (Serverside) +DELETE FROM `areatrigger_template` WHERE `Id`=@ATID+1 AND `IsServerSide`=1; +INSERT INTO `areatrigger_template` (`Id`, `IsServerSide`, `Type`, `Flags`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `VerifiedBuild`) VALUES +(@ATID+1, 1, 0, 0, 75, 75, 0, 0, 0, 0, 0, 0, 0); + +DELETE FROM `areatrigger` WHERE `SpawnId`=@ATSPAWNID+4 AND `IsServerSide`=1; +INSERT INTO `areatrigger` (`SpawnId`, `AreaTriggerId`, `IsServerSide`, `MapId`, `SpawnDifficulties`, `PosX`, `PosY`, `PosZ`, `Orientation`, `PhaseUseFlags`, `PhaseId`, `PhaseGroup`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `ScriptName`, `Comment`) VALUES +(@ATSPAWNID+4, @ATID+1, 1, 2450, '14,15,16,17', 234.9542, -829.9804, 4104.986, 0.0, 0, 0, 0, 0, 75, 75, 0, 0, 0, 0, 0, 0, 'at_sylvanas_windrunner_introduction', 'Sanctum of Domination - Pinnacle of Dominance (Conv. Introduction)'); + +-- 17368 - Sylvanas Windrunner's Introduction (Conversation) +DELETE FROM `conversation_template` WHERE `Id`=17368; +INSERT INTO `conversation_template` (`Id`, `FirstLineId`, `TextureKitId`, `ScriptName`, `VerifiedBuild`) VALUES +(17368, 44215, 0, 'conversation_sylvanas_windrunner_introduction', 41079); + +DELETE FROM `conversation_actors` WHERE `ConversationId`=17368; +INSERT INTO `conversation_actors` (`ConversationId`, `ConversationActorId`, `ConversationActorGuid`, `Idx`, `CreatureId`, `CreatureDisplayInfoId`, `VerifiedBuild`) VALUES +(17368, 80339, @CGUID+0, 0, 0, 0, 41079), +(17368, 81173, 0, 1, 0, 0, 50791); + +DELETE FROM `conversation_line_template` WHERE `Id` IN (44219, 44218, 44217, 44216, 44215); +INSERT INTO `conversation_line_template` (`Id`, `UiCameraID`, `ActorIdx`, `Flags`, `VerifiedBuild`) VALUES +(44219, 0, 0, 1, 41079), +(44218, 0, 0, 1, 41079), +(44217, 0, 1, 1, 41079), +(44216, 0, 0, 1, 41079), +(44215, 0, 0, 1, 41079); + +UPDATE `conversation_template` SET `FirstLineID`=44244, `VerifiedBuild`=41359 WHERE `Id`=17375; diff --git a/src/server/scripts/Shadowlands/SanctumOfDomination/boss_sylvanas_windrunner.cpp b/src/server/scripts/Shadowlands/SanctumOfDomination/boss_sylvanas_windrunner.cpp new file mode 100644 index 00000000000..4ed74a7b144 --- /dev/null +++ b/src/server/scripts/Shadowlands/SanctumOfDomination/boss_sylvanas_windrunner.cpp @@ -0,0 +1,489 @@ +/* + * This file is part of the TrinityCore Project. See AUTHORS file for Copyright information + * + * This program is free software; you can redistribute it and/or modify it + * under the terms of the GNU General Public License as published by the + * Free Software Foundation; either version 2 of the License, or (at your + * option) any later version. + * + * This program is distributed in the hope that it will be useful, but WITHOUT + * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or + * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for + * more details. + * + * You should have received a copy of the GNU General Public License along + * with this program. If not, see <http://www.gnu.org/licenses/>. + */ + +#include "AreaTrigger.h" +#include "AreaTriggerAI.h" +#include "Conversation.h" +#include "CreatureAI.h" +#include "CreatureAIImpl.h" +#include "InstanceScript.h" +#include "Map.h" +#include "MotionMaster.h" +#include "Player.h" +#include "ScriptMgr.h" +#include "ScriptedCreature.h" +#include "sanctum_of_domination.h" + +Position const SylvanasIntroPos[4] = +{ + { 231.15799f, -832.816f, 4105.0386f }, + { 242.00348f, -840.51215f, 4105.0386f }, + { 241.23091f, -830.0955f, 4105.0386f }, + { 225.73611f, -844.0746f, 4104.9882f, 1.3613f } +}; + +enum SylvanasSpells +{ + // Stances + SPELL_RANGER_BOW_STANCE = 347560, + SPELL_RANGER_DAGGERS_STANCE = 348010, + + // Miscellanea + SPELL_GENERIC_ANCHOR_HERE = 45313, + SPELL_GENERIC_DUAL_WIELD = 42459, + SPELL_SYLVANAS_DISPLAY_POWER_SUFFERING = 352311, + SPELL_SYLVANAS_ROOT = 347608 +}; + +enum SylvanasPhases +{ + PHASE_ONE = 1, + PHASE_INTERMISSION = 4, + PHASE_TWO = 2, + PHASE_THREE = 3, + PHASE_INTERMISSION_WORLD_STATE = 11 +}; + +enum SylvanasEventGroups +{ + EVENT_GROUP_NORMAL_EVENTS = 1, + EVENT_GROUP_WINDRUNNER_EVENTS = 2 +}; + +enum SylvanasEvents +{ + EVENT_INTRODUCTION = 1, + EVENT_SIZE_MAX = 200 +}; + +enum SylvanasTexts +{ + SAY_ENGAGE = 0, + SAY_SLAY = 1, + SAY_DISENGAGE = 2 +}; + +enum SylvanasConversations +{ + CONVERSATION_SYLVANAS_INTRODUCTION = 17368, + CONVERSATION_SYLVANAS_INTRODUCTION_ACTOR_SYLVANAS_ID = 0, + CONVERSATION_SYLVANAS_INTRODUCTION_ACTOR_BOLVAR_ID = 1 +}; + +enum SylvanasSpawnGroups +{ + SPAWN_GROUP_CHAMPIONS_FIRST_PHASE = 0, + SPAWN_GROUP_CHAMPIONS_THIRD_PHASE, + SPAWN_GROUP_CHAMPIONS_OUTRODUCTION +}; + +enum SylvanasPoints +{ + POINT_INTRODUCTION = 1 +}; + +enum SylvanasSpellVisualKits +{ + SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_01 = 150067, + SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_02 = 150068, + SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_03 = 150069, + SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_04 = 150071, + SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_05 = 150072, + SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_06 = 150070, + SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_07 = 150074, + SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_08 = 150077, + SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_09 = 150076, + SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_10 = 150075, + SPELL_VISUAL_KIT_BOLVAR_INTRODUCTION_TALK_01 = 150073, + + SPELL_VISUAL_KIT_SYLVANAS_TELEPORT = 150078 +}; + +// 178355 - Sylvanas Shadowcopy (Riding) +struct npc_sylvanas_windrunner_shadowcopy_riding : public ScriptedAI +{ + npc_sylvanas_windrunner_shadowcopy_riding(Creature* creature) : ScriptedAI(creature) { } + + void JustAppeared() override + { + me->SetImmuneToAll(true, true); + me->SetUninteractible(true); + me->SetReactState(REACT_PASSIVE); + } +}; + +// 175732 - Sylvanas Windrunner +struct boss_sylvanas_windrunner : public BossAI +{ + boss_sylvanas_windrunner(Creature* creature) : BossAI(creature, DATA_SYLVANAS_WINDRUNNER) { } + + void JustAppeared() override + { + DoCastSelf(SPELL_GENERIC_DUAL_WIELD, true); + DoCastSelf(SPELL_SYLVANAS_DISPLAY_POWER_SUFFERING, true); + + me->SetPower(me->GetPowerType(), 0); + + if (instance->GetData(DATA_SYLVANAS_INTRODUCTION) == DONE) + { + me->RemoveUnitFlag(UNIT_FLAG_NOT_ATTACKABLE_1); + me->SetImmuneToAll(false); + me->SetSpeed(MOVE_RUN, 14.0f); + } + else + { + me->SetUnitFlag(UNIT_FLAG_NOT_ATTACKABLE_1); + me->SetImmuneToAll(true); + me->SetSpeed(MOVE_RUN, 4.0f); + } + } + + void EnterEvadeMode(EvadeReason /*why*/) override + { + Talk(SAY_DISENGAGE); + + _EnterEvadeMode(); + + summons.DespawnAll(); + instance->SendEncounterUnit(ENCOUNTER_FRAME_DISENGAGE, me); + + _DespawnAtEvade(); + } + + void Reset() override + { + _Reset(); + + // Note: every creature involved in the fight adds UNIT_FLAG_PET_IN_COMBAT or UNIT_FLAG_RENAME when engaging, meaning they're most likely summoned by Sylvanas. + me->SummonCreatureGroup(SPAWN_GROUP_CHAMPIONS_FIRST_PHASE); + + instance->DoUpdateWorldState(WORLD_STATE_SYLVANAS_ENCOUNTER_PHASE, PHASE_ONE); + + events.Reset(); + } + + void JustSummoned(Creature* summon) override + { + summons.Summon(summon); + } + + void MovementInform(uint32 type, uint32 id) override + { + if (type != POINT_MOTION_TYPE) + return; + + if (id == POINT_INTRODUCTION) + DoCastSelf(SPELL_GENERIC_ANCHOR_HERE, true); + } + + void KilledUnit(Unit* victim) override + { + if (!victim->IsPlayer()) + return; + + Talk(SAY_SLAY); + } + + void JustEngagedWith(Unit* who) override + { + BossAI::JustEngagedWith(who); + instance->SendEncounterUnit(ENCOUNTER_FRAME_ENGAGE, me); + + Talk(SAY_ENGAGE); + + instance->DoUpdateWorldState(WORLD_STATE_SYLVANAS_ENCOUNTER_PHASE, PHASE_ONE); + + events.SetPhase(PHASE_ONE); + + // Note: Sylvanas uses her root with 2s at the beginning of the encounter, most likely to avoid moving when engaging at stance switch. + DoCastSelf(SPELL_SYLVANAS_ROOT, CastSpellExtraArgs(TRIGGERED_FULL_MASK).AddSpellMod(SPELLVALUE_DURATION, 2000)); + + // Note: we won't allow engaging until Phase 1 PR is merged. + me->Say("Only introduction is implemented so far, evading.", LANG_UNIVERSAL); + EnterEvadeMode(EvadeReason::Other); + } +}; + +// 45 - Sylvanas Windrunner's Position Z Check (Serverside) +struct at_sylvanas_windrunner_z_check : AreaTriggerAI +{ + at_sylvanas_windrunner_z_check(AreaTrigger* areatrigger) : AreaTriggerAI(areatrigger) { } + + void OnUnitEnter(Unit* unit) override + { + if (!unit->IsAlive()) + return; + + if (Player* player = unit->ToPlayer()) + { + if (player->IsGameMaster()) + return; + + if (player->IsAlive()) + player->KillSelf(false); + } + } +}; + +// 46 - Sylvanas Windrunner's Conversation Introduction (Serverside) +struct at_sylvanas_windrunner_introduction : AreaTriggerAI +{ + at_sylvanas_windrunner_introduction(AreaTrigger* areatrigger) : AreaTriggerAI(areatrigger) { } + + void OnUnitEnter(Unit* unit) override + { + InstanceScript* instance = at->GetInstanceScript(); + if (!instance) + return; + + Player* player = unit->ToPlayer(); + if (!player || player->IsGameMaster()) + return; + + if (Creature* sylvanas = instance->GetCreature(DATA_SYLVANAS_WINDRUNNER)) + Conversation::CreateConversation(CONVERSATION_SYLVANAS_INTRODUCTION, sylvanas, sylvanas->GetPosition(), ObjectGuid::Empty); + + at->Remove(); + } +}; + +// 17368 - Sylvanas Windrunner's Introduction (Conversation) +class conversation_sylvanas_windrunner_introduction : public ConversationScript +{ +public: + conversation_sylvanas_windrunner_introduction() : ConversationScript("conversation_sylvanas_windrunner_introduction") { } + + void OnConversationCreate(Conversation* conversation, Unit* creator) override + { + InstanceScript* instance = creator->GetInstanceScript(); + if (!instance) + return; + + Creature* bolvar = instance->GetCreature(DATA_BOLVAR_FORDRAGON_PINNACLE); + if (!bolvar) + return; + + instance->SetData(DATA_SYLVANAS_INTRODUCTION, IN_PROGRESS); + conversation->AddActor(NPC_BOLVAR_FORDRAGON_PINNACLE, CONVERSATION_SYLVANAS_INTRODUCTION_ACTOR_BOLVAR_ID, bolvar->GetGUID()); + + _events.ScheduleEvent(EVENT_INTRODUCTION, 5s + 500ms); + } + + void OnConversationUpdate(Conversation* conversation, uint32 diff) override + { + _events.Update(diff); + + uint32 eventId = _events.ExecuteEvent(); + Creature* sylvanas = nullptr; + Creature* bolvar = nullptr; + + if (eventId) + { + sylvanas = conversation->GetActorCreature(CONVERSATION_SYLVANAS_INTRODUCTION_ACTOR_SYLVANAS_ID); + if (!sylvanas) + return; + + bolvar = conversation->GetActorCreature(CONVERSATION_SYLVANAS_INTRODUCTION_ACTOR_BOLVAR_ID); + if (!bolvar) + return; + } + + switch (eventId) + { + case EVENT_INTRODUCTION: + { + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_01, 0, 0); + sylvanas->SetFacingToObject(bolvar); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 1, 1s + 140ms); + break; + } + + case EVENT_INTRODUCTION + 1: + { + sylvanas->GetMotionMaster()->MovePoint(POINT_INTRODUCTION, SylvanasIntroPos[0], false); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 2, 1s + 500ms); + break; + } + + case EVENT_INTRODUCTION + 2: + { + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_02, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 3, 3s + 360ms); + break; + } + + case EVENT_INTRODUCTION + 3: + { + sylvanas->GetMotionMaster()->MovePoint(POINT_INTRODUCTION, SylvanasIntroPos[1], false); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 4, 469ms); + break; + } + + case EVENT_INTRODUCTION + 4: + { + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_03, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 5, 3s + 500ms); + break; + } + + case EVENT_INTRODUCTION + 5: + { + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_04, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 6, 2s); + break; + } + + case EVENT_INTRODUCTION + 6: + { + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_05, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 7, 5s); + break; + } + + case EVENT_INTRODUCTION + 7: + { + sylvanas->SetFacingToObject(bolvar); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 8, 750ms); + break; + } + + case EVENT_INTRODUCTION + 8: + { + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_06, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 9, 457ms); + break; + } + + case EVENT_INTRODUCTION + 9: + { + sylvanas->GetMotionMaster()->MovePoint(POINT_INTRODUCTION, SylvanasIntroPos[2], false); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 10, 5s + 89ms); + break; + } + + case EVENT_INTRODUCTION + 10: + { + bolvar->SetFacingToObject(sylvanas); + bolvar->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_BOLVAR_INTRODUCTION_TALK_01, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 11, 13s + 567ms); + break; + } + + case EVENT_INTRODUCTION + 11: + { + sylvanas->SetFacingToObject(bolvar); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 12, 484ms); + break; + } + + case EVENT_INTRODUCTION + 12: + { + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_07, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 13, 5s + 516ms); + break; + } + + case EVENT_INTRODUCTION + 13: + { + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_08, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 14, 1s + 516ms); + break; + } + + case EVENT_INTRODUCTION + 14: + { + sylvanas->NearTeleportTo(SylvanasIntroPos[3], false); + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_TELEPORT, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 15, 1s + 265ms); + break; + } + + case EVENT_INTRODUCTION + 15: + { + sylvanas->SetFacingToObject(bolvar); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 16, 969ms); + break; + } + + case EVENT_INTRODUCTION + 16: + { + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_09, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 17, 4s + 766ms); + break; + } + + case EVENT_INTRODUCTION + 17: + { + sylvanas->SendPlaySpellVisualKit(SPELL_VISUAL_KIT_SYLVANAS_INTRODUCTION_TALK_10, 0, 0); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 18, 3s + 250ms); + break; + } + + case EVENT_INTRODUCTION + 18: + { + sylvanas->CastSpell(sylvanas, SPELL_RANGER_BOW_STANCE); + + _events.ScheduleEvent(EVENT_INTRODUCTION + 19, 16ms); + break; + } + + case EVENT_INTRODUCTION + 19: + { + sylvanas->CastSpell(sylvanas, SPELL_GENERIC_ANCHOR_HERE); + + if (InstanceScript* instance = sylvanas->GetInstanceScript()) + instance->SetData(DATA_SYLVANAS_INTRODUCTION, DONE); + break; + } + + default: + break; + } + } + +private: + EventMap _events; +}; + +void AddSC_boss_sylvanas_windrunner() +{ + RegisterSanctumOfDominationCreatureAI(boss_sylvanas_windrunner); + RegisterSanctumOfDominationCreatureAI(npc_sylvanas_windrunner_shadowcopy_riding); + + RegisterAreaTriggerAI(at_sylvanas_windrunner_z_check); + RegisterAreaTriggerAI(at_sylvanas_windrunner_introduction); + + new conversation_sylvanas_windrunner_introduction(); +} diff --git a/src/server/scripts/Shadowlands/SanctumOfDomination/instance_sanctum_of_domination.cpp b/src/server/scripts/Shadowlands/SanctumOfDomination/instance_sanctum_of_domination.cpp new file mode 100644 index 00000000000..dfba70edc87 --- /dev/null +++ b/src/server/scripts/Shadowlands/SanctumOfDomination/instance_sanctum_of_domination.cpp @@ -0,0 +1,254 @@ +/* + * This file is part of the TrinityCore Project. See AUTHORS file for Copyright information + * + * This program is free software; you can redistribute it and/or modify it + * under the terms of the GNU General Public License as published by the + * Free Software Foundation; either version 2 of the License, or (at your + * option) any later version. + * + * This program is distributed in the hope that it will be useful, but WITHOUT + * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or + * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for + * more details. + * + * You should have received a copy of the GNU General Public License along + * with this program. If not, see <http://www.gnu.org/licenses/>. + */ + +#include "Creature.h" +#include "GameObject.h" +#include "InstanceScript.h" +#include "Map.h" +#include "Player.h" +#include "ScriptMgr.h" +#include "sanctum_of_domination.h" + +ObjectData const creatureData[] = +{ + { BOSS_SYLVANAS_WINDRUNNER, DATA_SYLVANAS_WINDRUNNER }, + { NPC_SYLVANAS_SHADOWCOPY_RIDING, DATA_SYLVANAS_SHADOWCOPY_RIDING }, + { NPC_BOLVAR_FORDRAGON_PINNACLE, DATA_BOLVAR_FORDRAGON_PINNACLE }, + { NPC_JAINA_PROUDMOORE_PINNACLE, DATA_JAINA_PROUDMOORE_PINNACLE }, + { NPC_THRALL_PINNACLE, DATA_THRALL_PINNACLE }, + { NPC_THRONE_OF_THE_DAMNED, DATA_THRONE_OF_THE_DAMNED }, + { 0, 0 } // END +}; + +DungeonEncounterData const encounters[] = +{ + { DATA_THE_TARRAGRUE, {{ 2423 }} }, + { DATA_THE_EYE_OF_THE_JAILER, {{ 2433 }} }, + { DATA_THE_NINE, {{ 2429 }} }, + { DATA_REMNANT_OF_NERZHUL, {{ 2432 }} }, + { DATA_SOULRENDER_DORMAZAIN, {{ 2434 }} }, + { DATA_PAINSMITH_RAZNAL, {{ 2430 }} }, + { DATA_GUARDIAN_OF_THE_FIRST_ONES, {{ 2436 }} }, + { DATA_FATESCRIBE_ROHKALO, {{ 2431 }} }, + { DATA_KELTHUZAD, {{ 2422 }} }, + { DATA_SYLVANAS_WINDRUNNER, {{ 2435 }} } +}; + +class instance_sanctum_of_domination : public InstanceMapScript +{ +public: + instance_sanctum_of_domination() : InstanceMapScript(SODScriptName, 2450) { } + + struct instance_sanctum_of_domination_InstanceMapScript : public InstanceScript + { + instance_sanctum_of_domination_InstanceMapScript(InstanceMap* map) : InstanceScript(map) + { + SetHeaders(DataHeader); + SetBossNumber(EncounterCount); + LoadDungeonEncounterData(encounters); + LoadObjectData(creatureData, nullptr); + + SylvanasIntroductionState = NOT_STARTED; + } + + void OnCreatureCreate(Creature* creature) override + { + InstanceScript::OnCreatureCreate(creature); + + switch (creature->GetEntry()) + { + case BOSS_SYLVANAS_WINDRUNNER: + SylvanasGUID = creature->GetGUID(); + break; + + case NPC_SYLVANAS_SHADOWCOPY_RIDING: + SylvanasShadowcopyRidingGUID = creature->GetGUID(); + break; + + case NPC_BOLVAR_FORDRAGON_PINNACLE: + BolvarPinnacleGUID = creature->GetGUID(); + break; + + case NPC_JAINA_PROUDMOORE_PINNACLE: + JainaPinnacleGUID = creature->GetGUID(); + break; + + case NPC_THRALL_PINNACLE: + ThrallPinnacleGUID = creature->GetGUID(); + break; + + case NPC_THRONE_OF_THE_DAMNED: + ThroneOfTheDamnedGUID = creature->GetGUID(); + break; + + default: + break; + } + } + + void OnGameObjectCreate(GameObject* go) override + { + switch (go->GetEntry()) + { + case GAMEOBJECT_TORGHAST_SPIKE_01: + case GAMEOBJECT_TORGHAST_SPIKE_02: + case GAMEOBJECT_TORGHAST_SPIKE_03: + case GAMEOBJECT_TORGHAST_SPIKE_04: + case GAMEOBJECT_TORGHAST_SPIKE_05: + case GAMEOBJECT_TORGHAST_SPIKE_06: + case GAMEOBJECT_TORGHAST_SPIKE_07: + case GAMEOBJECT_TORGHAST_SPIKE_08: + case GAMEOBJECT_TORGHAST_SPIKE_09: + case GAMEOBJECT_TORGHAST_SPIKE_10: + case GAMEOBJECT_TORGHAST_SPIKE_11: + case GAMEOBJECT_TORGHAST_SPIKE_12: + TorghastSpikeGUIDs.push_back(go->GetGUID()); + break; + + default: + break; + } + } + + ObjectGuid GetGuidData(uint32 type) const override + { + switch (type) + { + case DATA_SYLVANAS_WINDRUNNER: + return SylvanasGUID; + case DATA_BOLVAR_FORDRAGON_PINNACLE: + return BolvarPinnacleGUID; + case DATA_JAINA_PROUDMOORE_PINNACLE: + return JainaPinnacleGUID; + case DATA_THRALL_PINNACLE: + return ThrallPinnacleGUID; + case DATA_THRONE_OF_THE_DAMNED: + return ThroneOfTheDamnedGUID; + default: + break; + } + + return ObjectGuid::Empty; + } + + bool SetBossState(uint32 id, EncounterState state) override + { + if (!InstanceScript::SetBossState(id, state)) + return false; + + switch (id) + { + case DATA_SYLVANAS_WINDRUNNER: + { + if (state == NOT_STARTED) + { + DoUpdateWorldState(WORLD_STATE_SYLVANAS_ENCOUNTER_STARTED, 0); + + if (Creature* throneTeleporter = GetCreature(DATA_THRONE_OF_THE_DAMNED)) + throneTeleporter->SetVisible(true); + + for (ObjectGuid const& spikeGUID : TorghastSpikeGUIDs) + if (GameObject* torghastSpike = instance->GetGameObject(spikeGUID)) + torghastSpike->SetSpellVisualId(0); + } + else if (state == IN_PROGRESS) + { + DoUpdateWorldState(WORLD_STATE_SYLVANAS_ENCOUNTER_STARTED, 1); + + if (Creature* throneTeleporter = GetCreature(DATA_THRONE_OF_THE_DAMNED)) + throneTeleporter->SetVisible(false); + } + + break; + } + + default: + break; + } + + return true; + } + + void SetData(uint32 type, uint32 data) override + { + switch (type) + { + case DATA_SYLVANAS_INTRODUCTION: + { + switch (data) + { + case IN_PROGRESS: + SylvanasIntroductionState = IN_PROGRESS; + if (Creature* sylvanas = GetCreature(DATA_SYLVANAS_WINDRUNNER)) + sylvanas->SetHomePosition(SylvanasRespawnPos); + break; + + case DONE: + SylvanasIntroductionState = DONE; + if (Creature* sylvanas = GetCreature(DATA_SYLVANAS_WINDRUNNER)) + { + sylvanas->RemoveUnitFlag(UNIT_FLAG_NOT_ATTACKABLE_1); + sylvanas->SetImmuneToAll(false); + sylvanas->SetSpeed(MOVE_RUN, 14.0f); + } + break; + + default: + break; + } + break; + } + + default: + break; + } + } + + uint32 GetData(uint32 type) const override + { + switch (type) + { + case DATA_SYLVANAS_INTRODUCTION: + return SylvanasIntroductionState; + default: + break; + } + + return 0; + } + + protected: + ObjectGuid SylvanasGUID; + ObjectGuid SylvanasShadowcopyRidingGUID; + ObjectGuid BolvarPinnacleGUID; + ObjectGuid JainaPinnacleGUID; + ObjectGuid ThrallPinnacleGUID; + ObjectGuid ThroneOfTheDamnedGUID; + std::vector<ObjectGuid> TorghastSpikeGUIDs; + uint8 SylvanasIntroductionState; + }; + + InstanceScript* GetInstanceScript(InstanceMap* map) const override + { + return new instance_sanctum_of_domination_InstanceMapScript(map); + } +}; + +void AddSC_instance_sanctum_of_domination() +{ + new instance_sanctum_of_domination(); +} diff --git a/src/server/scripts/Shadowlands/SanctumOfDomination/sanctum_of_domination.h b/src/server/scripts/Shadowlands/SanctumOfDomination/sanctum_of_domination.h new file mode 100644 index 00000000000..498aecfd715 --- /dev/null +++ b/src/server/scripts/Shadowlands/SanctumOfDomination/sanctum_of_domination.h @@ -0,0 +1,117 @@ +/* + * This file is part of the TrinityCore Project. See AUTHORS file for Copyright information + * + * This program is free software; you can redistribute it and/or modify it + * under the terms of the GNU General Public License as published by the + * Free Software Foundation; either version 2 of the License, or (at your + * option) any later version. + * + * This program is distributed in the hope that it will be useful, but WITHOUT + * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or + * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for + * more details. + * + * You should have received a copy of the GNU General Public License along + * with this program. If not, see <http://www.gnu.org/licenses/>. + */ + +#ifndef DEF_SANCTUM_OF_DOMINATION_H_ +#define DEF_SANCTUM_OF_DOMINATION_H_ + +#include "CreatureAIImpl.h" + +#define DataHeader "SanctumOfDomination" +#define SODScriptName "instance_sanctum_of_domination" + +uint32 const EncounterCount = 10; + +Position const SylvanasRespawnPos = { 225.73611f, -844.0746f, 4104.9882f, 1.3613f }; + +enum SanctumOfDominationDataTypes +{ + DATA_THE_TARRAGRUE = 0, + DATA_THE_EYE_OF_THE_JAILER = 1, + DATA_THE_NINE = 2, + DATA_REMNANT_OF_NERZHUL = 3, + DATA_SOULRENDER_DORMAZAIN = 4, + DATA_PAINSMITH_RAZNAL = 5, + DATA_GUARDIAN_OF_THE_FIRST_ONES = 6, + DATA_FATESCRIBE_ROHKALO = 7, + DATA_KELTHUZAD = 8, + DATA_SYLVANAS_WINDRUNNER = 9, + + /* Encounter-related data */ + + /* Sylvanas Windrunner */ + DATA_SYLVANAS_INTRODUCTION, + DATA_SYLVANAS_SHADOWCOPY_RIDING, + DATA_BOLVAR_FORDRAGON_PINNACLE, + DATA_JAINA_PROUDMOORE_PINNACLE, + DATA_THRALL_PINNACLE, + DATA_THRONE_OF_THE_DAMNED +}; + +enum SanctumOfDominationCreatureIds +{ + // Bosses + BOSS_SYLVANAS_WINDRUNNER = 175732, + + /* Encounter-related creatures */ + + /* Sylvanas Windrunner Encounter */ + NPC_SYLVANAS_SHADOWCOPY_RIDING = 178355, + NPC_BOLVAR_FORDRAGON_PINNACLE = 178081, + NPC_JAINA_PROUDMOORE_PINNACLE = 176533, + NPC_THRALL_PINNACLE = 176532, + + NPC_THRONE_OF_THE_DAMNED = 180803 +}; + +enum SanctumOfDominationGameObjectIds +{ + GAMEOBJECT_TORGHAST_SPIKE_01 = 368743, + GAMEOBJECT_TORGHAST_SPIKE_02 = 368744, + GAMEOBJECT_TORGHAST_SPIKE_03 = 368745, + GAMEOBJECT_TORGHAST_SPIKE_04 = 368746, + GAMEOBJECT_TORGHAST_SPIKE_05 = 368747, + GAMEOBJECT_TORGHAST_SPIKE_06 = 368748, + GAMEOBJECT_TORGHAST_SPIKE_07 = 368749, + GAMEOBJECT_TORGHAST_SPIKE_08 = 368750, + GAMEOBJECT_TORGHAST_SPIKE_09 = 368751, + GAMEOBJECT_TORGHAST_SPIKE_10 = 368752, + GAMEOBJECT_TORGHAST_SPIKE_11 = 368753, + GAMEOBJECT_TORGHAST_SPIKE_12 = 368754 +}; + +enum SanctumOfDominationAreas +{ + AREA_PINNACLE_OF_DOMINANCE = 13653, + AREA_EDGE_OF_THE_ABYSS = 13654, + AREA_THE_CRUCIBLE = 13655 +}; + +enum SanctumofDominationWorldStates +{ + WORLD_STATE_SYLVANAS_ENCOUNTER_STARTED = 20346, + WORLD_STATE_SYLVANAS_ENCOUNTER_COMPLETED = 20347, + WORLD_STATE_SYLVANAS_ENCOUNTER_PHASE = 20348, + WORLD_STATE_SYLVANAS_UNK_01 = 21210, // Info: sets to 0 several times on phase 3. + WORLD_STATE_SYLVANAS_UNK_02 = 21166, // Info: sets to 1 when SPELL_FINAL_SCENE is cast on players. + WORLD_STATE_SYLVANAS_UNK_03 = 21120, // Info: sets to 1 when 353687 spell is cast by NPC 179262. + WORLD_STATE_SYLVANAS_ACHIEVEMENT_COMPLETED = 21134, + WORLD_STATE_SYLVANAS_UNK_04 = 20439, // Info: this is always 1 on INIT and the following are 0. + WORLD_STATE_SYLVANAS_UNK_05 = 20440, + WORLD_STATE_SYLVANAS_UNK_06 = 20441, + WORLD_STATE_SYLVANAS_UNK_07 = 20442, + WORLD_STATE_SYLVANAS_UNK_08 = 20443 +}; + +template <class AI, class T> +inline AI* GetSanctumOfDominationAI(T* obj) +{ + return GetInstanceAI<AI>(obj, SODScriptName); +} + +#define RegisterSanctumOfDominationCreatureAI(ai_name) RegisterCreatureAIWithFactory(ai_name, GetSanctumOfDominationAI) + +#endif diff --git a/src/server/scripts/Shadowlands/shadowlands_script_loader.cpp b/src/server/scripts/Shadowlands/shadowlands_script_loader.cpp index c6452c75c37..a21eae2a9f4 100644 --- a/src/server/scripts/Shadowlands/shadowlands_script_loader.cpp +++ b/src/server/scripts/Shadowlands/shadowlands_script_loader.cpp @@ -19,8 +19,17 @@ void AddSC_covenant_spell_scripts(); void AddSC_torghast_spell_scripts(); +void AddSC_boss_sylvanas_windrunner(); +void AddSC_instance_sanctum_of_domination(); + +// The name of this function should match: +// void Add${NameOfDirectory}Scripts() void AddShadowlandsScripts() { AddSC_covenant_spell_scripts(); AddSC_torghast_spell_scripts(); + + // Sanctum of Domination + AddSC_boss_sylvanas_windrunner(); + AddSC_instance_sanctum_of_domination(); } |