diff options
| author | Jeremy <Golrag@users.noreply.github.com> | 2024-09-14 13:01:54 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-09-14 13:01:54 +0200 |
| commit | c499110a0d09364fa62a1f67db17032aea9c77e6 (patch) | |
| tree | 25dbe1cd4312e64e6f455ff9d05bec363f30ab3e | |
| parent | 4a574c0ce1149825c0fba77b0bea60608cbc470f (diff) | |
Scripts/Battlegrounds: Implement Silvershard mines (#30120)
7 files changed, 1658 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_09_14_00_world.sql b/sql/updates/world/master/2024_09_14_00_world.sql new file mode 100644 index 00000000000..fb71f7cdb6e --- /dev/null +++ b/sql/updates/world/master/2024_09_14_00_world.sql @@ -0,0 +1,614 @@ +SET @CGUID := 4000138; +SET @OGUID := 4000060; + +DELETE FROM `battleground_template` WHERE `ID`=708; +INSERT INTO `battleground_template` (`ID`, `AllianceStartLoc`, `HordeStartLoc`, `Weight`, `Comment`) VALUES +(708, 4062, 4061, 1, 'Silvershard Mines'); + +DELETE FROM `battleground_scripts` WHERE `MapId`=727; +INSERT INTO `battleground_scripts` (`MapId`, `BattlemasterListId`, `ScriptName`) VALUES +(727, 0, 'battleground_silvershard_mines'); + +DELETE FROM `serverside_spell` WHERE `Id` IN (128648, 128702, 128703, 128704, 128705, 128706, 128720, 128668, 128669, 128670, 128672, 128673, 128674); +DELETE FROM `serverside_spell_effect` WHERE `SpellId` IN (128648, 128702, 128703, 128704, 128705, 128706, 128720, 128668, 128669, 128670, 128672, 128673, 128674); +INSERT INTO `serverside_spell` (`Id`, `DifficultyID`, `CategoryId`, `Dispel`, `Mechanic`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `AttributesEx8`, `AttributesEx9`, `AttributesEx10`, `AttributesEx11`, `AttributesEx12`, `AttributesEx13`, `AttributesEx14`, `Stances`, `StancesNot`, `Targets`, `TargetCreatureType`, `RequiresSpellFocus`, `FacingCasterFlags`, `CasterAuraState`, `TargetAuraState`, `ExcludeCasterAuraState`, `ExcludeTargetAuraState`, `CasterAuraSpell`, `TargetAuraSpell`, `ExcludeCasterAuraSpell`, `ExcludeTargetAuraSpell`, `CasterAuraType`, `TargetAuraType`, `ExcludeCasterAuraType`, `ExcludeTargetAuraType`, `CastingTimeIndex`, `RecoveryTime`, `CategoryRecoveryTime`, `StartRecoveryCategory`, `StartRecoveryTime`, `InterruptFlags`, `AuraInterruptFlags1`, `AuraInterruptFlags2`, `ChannelInterruptFlags1`, `ChannelInterruptFlags2`, `ProcFlags`, `ProcFlags2`, `ProcChance`, `ProcCharges`, `ProcCooldown`, `ProcBasePPM`, `MaxLevel`, `BaseLevel`, `SpellLevel`, `DurationIndex`, `RangeIndex`, `Speed`, `LaunchDelay`, `StackAmount`, `EquippedItemClass`, `EquippedItemSubClassMask`, `EquippedItemInventoryTypeMask`, `ContentTuningId`, `SpellName`, `ConeAngle`, `ConeWidth`, `MaxTargetLevel`, `MaxAffectedTargets`, `SpellFamilyName`, `SpellFamilyFlags1`, `SpellFamilyFlags2`, `SpellFamilyFlags3`, `SpellFamilyFlags4`, `DmgClass`, `PreventionType`, `AreaGroupId`, `SchoolMask`, `ChargeCategoryId`) VALUES +(128648, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0x1A0000, 0x400, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 5, 0, 0, 0, -1, 0, 0, 0, 'Defending Cart Aura', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128668, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Long Rider Achievement East (Horde)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128669, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Long Rider Achievement North (Horde)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128670, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Long Rider Achievement South (Horde)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128672, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Long Rider Achievement East (Alliance)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128673, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Long Rider Achievement North (Alliance)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128674, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Long Rider Achievement South (Alliance)', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128702, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Mine Cart Courier East->South', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128703, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Mine Cart Courier East->North', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128704, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Mine Cart Courier South', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128705, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Mine Cart Courier North->East', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128706, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'Mine Cart Courier North->West', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), +(128720, 0, 0, 0, 0, 134217856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 21, 34, 0, 0, 0, -1, 0, 0, 0, 'End of the Line Achievement Check', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); + +INSERT INTO `serverside_spell_effect` (`SpellID`, `EffectIndex`, `DifficultyID`, `Effect`, `EffectAura`, `EffectAmplitude`, `EffectAttributes`, `EffectAuraPeriod`, `EffectBonusCoefficient`, `EffectChainAmplitude`, `EffectChainTargets`, `EffectItemType`, `EffectMechanic`, `EffectPointsPerResource`, `EffectPosFacing`, `EffectRealPointsPerLevel`, `EffectTriggerSpell`, `BonusCoefficientFromAP`, `PvpMultiplier`, `Coefficient`, `Variance`, `ResourceCoefficient`, `GroupSizeBasePointsCoefficient`, `EffectBasePoints`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectSpellClassMask1`, `EffectSpellClassMask2`, `EffectSpellClassMask3`, `EffectSpellClassMask4`, `ImplicitTarget1`, `ImplicitTarget2`) VALUES +(128648, 0, 0, 6, 226, 0, 0, 1000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, 23, 0, 0, 0, 0, 30, 0), +(128668, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128669, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128670, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128672, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128673, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128674, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128702, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128703, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128704, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128705, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128706, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0), +(128720, 0, 0, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 1, 0); + +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_bg_silvershard_mines_cart_cap', 'spell_bg_silvershard_mines_capturing', 'spell_bg_silvershard_mines_capturing_switch_track', 'spell_bg_defending_cart_aura'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(115904, 'spell_bg_silvershard_mines_cart_cap'), +(124491, 'spell_bg_silvershard_mines_capturing'), +(97372, 'spell_bg_silvershard_mines_capturing_switch_track'), +(128648, 'spell_bg_defending_cart_aura'); + +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (7779, 7780, 7781, 7782); +INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES +(7782, 'at_battleground_buffs'), +(7779, 'at_battleground_buffs'), +(7781, 'at_battleground_buffs'), +(7780, 'at_battleground_buffs'); + +DELETE FROM `graveyard_zone` WHERE `ID` IN (4061, 4062); +INSERT INTO `graveyard_zone` (`ID`, `GhostZone`, `Comment`) VALUES +(4062, 6126, 'Silvershard Mines - Alliance'), +(4061, 6126, 'Silvershard Mines - Horde'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 27 AND `SourceEntry` IN (4061, 4062); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceEntry`, `SourceGroup`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `NegativeCondition`, `Comment`) VALUES +(27, 4062, 6126, 0, 6, 469, 0, 0, 'Graveyard - Silvershard Mines - Alliance Base - Team Alliance'), +(27, 4061, 6126, 0, 6, 67, 0, 0, 'Graveyard - Silvershard Mines - Horde Base - Team Horde'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=97372 AND `ConditionTypeOrReference`=31 AND `ConditionValue2`=60283; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 97372, 0, 0, 31, 0, 3, 60283, 0, 0, 0, 0, '', 'Spell 97372 only targets creature with entry 60283'); + +DELETE FROM `world_state` WHERE `ID` IN (6467, 6468, 6438, 6437, 6439, 6440, 6879, 6880, 6881, 6882, 17378); +INSERT INTO `world_state` (`ID`, `DefaultValue`, `MapIDs`, `Comment`) VALUES +(6467, 2, '727', 'Silvershard Mines - Eastern Track Switch State'), +(6468, 1, '727', 'Silvershard Mines - Northern Track Switch State'), +(6438, 0, '727', 'Silvershard Mines - Horde Score'), +(6437, 0, '727', 'Silvershard Mines - Alliance Score'), +(6439, 0, '727', 'Silvershard Mines - East Cart Under Alliance Control'), +(6440, 0, '727', 'Silvershard Mines - East Cart Under Horde Control'), +(6879, 0, '727', 'Silvershard Mines - North Cart Under Horde Control'), +(6880, 0, '727', 'Silvershard Mines - North Cart Under Alliance Control'), +(6882, 0, '727', 'Silvershard Mines - South Cart Under Horde Control'), +(6881, 0, '727', 'Silvershard Mines - South Cart Under Alliance Control'), +(17378, 1500, '727', 'Silvershard Mines - Max score'); + +UPDATE `gameobject_template` SET `Data2`=9601, `Data3`=9603, `Data8`=31167, `Data9`=31166, `Data12`=2, `Data13`=9605, `Data14`=1, `Data15`=1, `Data16`=50, `Data17`=50, `Data18`=1, `Data20`=50, `Data22`=10, `Data25`=15, `Data26`=1, `VerifiedBuild`=55664 WHERE `entry`=213794; -- Mine Cart Control Point North +UPDATE `gameobject_template` SET `Data8`=32909, `Data9`=32910, `Data10`=32912, `Data11`=32912, `Data12`=2, `Data13`=6877, `Data14`=1, `Data15`=1, `Data16`=50, `Data17`=50, `Data18`=1, `Data20`=50, `Data22`=10, `Data25`=15, `Data26`=1, `VerifiedBuild`=55664 WHERE `entry`=213766; -- Mine Cart Control Point East +UPDATE `gameobject_template` SET `Data2`=9602, `Data3`=9604, `Data8`=32937, `Data9`=32938, `Data10`=32951, `Data11`=32951, `Data12`=2, `Data13`=9606, `Data14`=1, `Data15`=1, `Data16`=50, `Data17`=50, `Data18`=1, `Data20`=50, `Data22`=10, `Data25`=15, `Data26`=1, `VerifiedBuild`=55664 WHERE `entry`=213796; -- Mine Cart Control Point South +UPDATE `gameobject_template_addon` SET `faction`=1375, `flags`=32 WHERE `entry` IN (212942, 212940, 212941, 212939); -- Gate +UPDATE `gameobject_template_addon` SET `faction`=114, `flags`=32 WHERE `entry`=212082; -- Diamond Depot +UPDATE `gameobject_template_addon` SET `faction`=114, `flags`=32 WHERE `entry`=212083; -- Troll Depot +UPDATE `gameobject_template_addon` SET `faction`=114, `flags`=32 WHERE `entry`=212080; -- Waterfall Depot +UPDATE `gameobject_template_addon` SET `faction`=114, `flags`=32 WHERE `entry`=212081; -- Lava Depot + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+29; +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, 212939, 727, 6126, 6126, '0', '0', 0, 853.1630859375, 158.904693603515625, 328.08172607421875, 6.251653671264648437, 0.042779445648193359, -0.02950668334960937, -0.014495849609375, 0.998543500900268554, 7200, 255, 1, 55461), -- Gate (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+1, 212941, 727, 6126, 6126, '0', '0', 0, 635.25537109375, 208.1811981201171875, 327.966217041015625, 3.498660087585449218, -0.03747749328613281, -0.02367496490478515, -0.98301601409912109, 0.178085654973983764, 7200, 255, 1, 55461), -- Gate (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+2, 212940, 727, 6126, 6126, '0', '0', 0, 830.2012939453125, 144.680389404296875, 329.08978271484375, 0.111990571022033691, -0.02431344985961914, 0.022320747375488281, 0.056479454040527343, 0.997858047485351562, 7200, 255, 1, 55461), -- Gate (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+3, 212942, 727, 6126, 6126, '0', '0', 0, 652.85565185546875, 227.672607421875, 329.00390625, 3.524521350860595703, 0.03816843032836914, 0.047303199768066406, -0.97956275939941406, 0.191735118627548217, 7200, 255, 1, 55461), -- Gate (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+4, 212305, 727, 6126, 6126, '0', '0', 0, 867.98297119140625, 131.5071258544921875, 328.98211669921875, 5.964090347290039062, -0.01038980484008789, -0.00468635559082031, -0.1589202880859375, 0.987225651741027832, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+5, 212304, 727, 6126, 6126, '0', '0', 0, 866.41827392578125, 136.7794952392578125, 328.95977783203125, 4.503678321838378906, 0.000069618225097656, -0.00759792327880859, -0.77687644958496093, 0.629607200622558593, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+6, 212307, 727, 6126, 6126, '0', '0', 0, 614.81585693359375, 231.1639862060546875, 328.99249267578125, 1.236014962196350097, -0.00774526596069335, 0.02101898193359375, 0.579163551330566406, 0.814903557300567626, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+7, 212306, 727, 6126, 6126, '0', '0', 0, 866.22216796875, 134.3291168212890625, 328.9862060546875, 1.940872073173522949, -0.00730180740356445, 0.002100944519042968, 0.825118064880371093, 0.564909219741821289, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+8, 212309, 727, 6126, 6126, '0', '0', 0, 613.97894287109375, 224.162689208984375, 328.97802734375, 2.758805274963378906, 0.006997108459472656, -0.0029611587524414, 0.981709480285644531, 0.190233334898948669, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+9, 212308, 727, 6126, 6126, '0', '0', 0, 617.40960693359375, 231.253021240234375, 328.97515869140625, 2.719236373901367187, -0.01607561111450195, 0.004109382629394531, 0.977647781372070312, 0.209593698382377624, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+10, 179905, 727, 6126, 6126, '0', '0', 0, 810.4930419921875, 36.31076431274414062, 368.24847412109375, 6.067836284637451171, 0, 0, -0.10746669769287109, 0.994208693504333496, 90, 255, 1, 55461), -- Berserk Buff (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+11, 212311, 727, 6126, 6126, '0', '0', 0, 615.1827392578125, 240.83795166015625, 328.96124267578125, 4.911244392395019531, -0.01196098327636718, 0.000443458557128906, -0.63343238830566406, 0.773705482482910156, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+12, 179904, 727, 6126, 6126, '0', '0', 0, 538.51043701171875, 396.930572509765625, 345.73956298828125, 4.059507369995117187, 0, 0, -0.896514892578125, 0.443013608455657958, 90, 255, 1, 55461), -- Food Buff (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+13, 212310, 727, 6126, 6126, '0', '0', 0, 613.2872314453125, 226.6121368408203125, 329.00750732421875, 4.76936960220336914, -0.00124883651733398, 0.007494926452636718, -0.68663692474365234, 0.72696077823638916, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+14, 179907, 727, 6126, 6126, '0', '0', 0, 789.89581298828125, 282.763885498046875, 355.06646728515625, 0.881992816925048828, 0, 0, 0.426840782165527343, 0.904326796531677246, 90, 255, 1, 55461), -- Berserk Buff (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+15, 212313, 727, 6126, 6126, '0', '0', 0, 615.861083984375, 224.8324432373046875, 328.95977783203125, 1.650866150856018066, 0.007508754730224609, 0.001162528991699218, 0.734839439392089843, 0.678198516368865966, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+16, 179906, 727, 6126, 6126, '0', '0', 0, 614.13543701171875, 120.0972213745117187, 294.65618896484375, 4.409838676452636718, 0, 0, -0.80559158325195312, 0.592471241950988769, 90, 255, 1, 55461), -- Food Buff (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+17, 212312, 727, 6126, 6126, '0', '0', 0, 615.8372802734375, 233.672607421875, 328.973297119140625, 4.907505989074707031, 0.007056713104248046, -0.00879669189453125, -0.63480949401855468, 0.772586405277252197, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+18, 212315, 727, 6126, 6126, '0', '0', 0, 615.35125732421875, 227.237213134765625, 328.986175537109375, 5.371253013610839843, 0.001028060913085937, 0.007528305053710937, -0.44030189514160156, 0.897817671298980712, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+19, 212314, 727, 6126, 6126, '0', '0', 0, 612.85968017578125, 229.4408721923828125, 328.98211669921875, 3.111219644546508789, 0.006133079528808593, -0.00960731506347656, 0.999818801879882812, 0.015244622714817523, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+20, 212081, 727, 6126, 6126, '0', '0', 0, 615.50994873046875, 79.418121337890625, 298.286712646484375, 1.654057860374450683, -0.03407955169677734, -0.02646541595458984, 0.735444068908691406, 0.67621016502380371, 7200, 255, 1, 55461), -- Lava Depot (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+21, 212080, 727, 6126, 6126, '0', '0', 0, 564.8048095703125, 337.08734130859375, 347.142730712890625, 1.571253895759582519, 0.011277198791503906, 0.006951332092285156, 0.707234382629394531, 0.706855058670043945, 7200, 255, 1, 55461), -- Waterfall Depot (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+22, 212083, 727, 6126, 6126, '0', '0', 0, 777.7376708984375, 502.31109619140625, 359.453704833984375, 0.719447970390319824, -0.01845312118530273, -0.01729774475097656, 0.351691246032714843, 0.935774266719818115, 7200, 255, 1, 55461), -- Troll Depot (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+23, 212082, 727, 6126, 6126, '0', '0', 0, 896.7935791015625, 25.2902679443359375, 364.14306640625, 3.539994239807128906, -0.00981664657592773, 0.03659820556640625, -0.9795389175415039, 0.197655469179153442, 7200, 255, 1, 55461), -- Diamond Depot (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+24, 212299, 727, 6126, 6126, '0', '0', 0, 863.1053466796875, 131.065765380859375, 328.97515869140625, 5.572046756744384765, 0.006380558013916015, 0.015316963195800781, -0.34808635711669921, 0.937315583229064941, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+25, 212298, 727, 6126, 6126, '0', '0', 0, 865.6170654296875, 130.4124755859375, 328.992523193359375, 4.088826179504394531, 0.021915435791015625, 0.004639625549316406, -0.88975906372070312, 0.455880433320999145, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+26, 212301, 727, 6126, 6126, '0', '0', 0, 868.378662109375, 134.34051513671875, 329.007537841796875, 1.338990211486816406, -0.00759649276733398, -0.00015735626220703, 0.620594024658203125, 0.784095227718353271, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+27, 212300, 727, 6126, 6126, '0', '0', 0, 868.4132080078125, 136.8855133056640625, 328.97802734375, 5.611620426177978515, -0.0039372444152832, -0.00649833679199218, -0.32950973510742187, 0.944121599197387695, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+28, 212303, 727, 6126, 6126, '0', '0', 0, 863.923583984375, 128.2986297607421875, 328.973297119140625, 1.477124452590942382, 0.009720802307128906, 0.005717277526855468, 0.673201560974121093, 0.73937302827835083, 7200, 255, 1, 55461), -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@OGUID+29, 212302, 727, 6126, 6126, '0', '0', 0, 862.1124267578125, 122.314422607421875, 328.96124267578125, 1.480865240097045898, -0.00216007232666015, -0.01177215576171875, 0.674508094787597656, 0.738170385360717773, 7200, 255, 1, 55461); -- Chair (Area: Silvershard Mines - Difficulty: 0) CreateObject1 + +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+29; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+0, 0, 0, 1, -0.00000004371138828, 0, 0), -- Gate +(@OGUID+1, 0, 0, 1, -0.00000004371138828, 0, 0), -- Gate +(@OGUID+2, 0, 0, 1, -0.00000004371138828, 0, 0), -- Gate +(@OGUID+3, 0, 0, 1, -0.00000004371138828, 0, 0), -- Gate +(@OGUID+4, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+5, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+6, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+7, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+8, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+9, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+11, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+13, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+15, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+17, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+18, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+19, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+20, 0, 0, 1, -0.00000004371138828, 0, 0), -- Lava Depot +(@OGUID+21, 0, 0, 1, -0.00000004371138828, 0, 0), -- Waterfall Depot +(@OGUID+22, 0, 0, 1, -0.00000004371138828, 0, 0), -- Troll Depot +(@OGUID+23, 0, 0, 1, -0.00000004371138828, 0, 0), -- Diamond Depot +(@OGUID+24, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+25, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+26, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+27, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+28, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair +(@OGUID+29, 0, 0, 1, -0.00000004371138828, 0, 0); -- Chair + +UPDATE `gameobject_template` SET `StringId` = 'bg_silvershard_mine_depot' WHERE `entry` IN (212080, 212081, 212082, 212083); + +UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368, `VerifiedBuild`=55461 WHERE (`Entry`=60380 AND `DifficultyID`=0); -- 60380 (Mine Cart) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368, `VerifiedBuild`=55461 WHERE (`Entry`=60378 AND `DifficultyID`=0); -- 60378 (Mine Cart) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=805306368, `VerifiedBuild`=55461 WHERE (`Entry`=60379 AND `DifficultyID`=0); -- 60379 (Mine Cart) - CanSwim, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536871168, `VerifiedBuild`=55461 WHERE (`Entry`=60145 AND `DifficultyID`=0); -- 60145 (Points Trigger) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=55461 WHERE (`Entry`=60140 AND `DifficultyID`=0); -- 60140 (Mine Cart) - CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=536870912, `VerifiedBuild`=55461 WHERE (`Entry`=60283 AND `DifficultyID`=0); -- 60283 (Track Switch) - Floating + +UPDATE `creature_template` SET `speed_walk`=5.599999904632568359, `speed_run`=2, `unit_flags2`=0, `ScriptName`='npc_bg_silvershard_mines_mine_cart_cosmetic' WHERE `entry` IN (60380, 60378, 60379); -- Mine Cart +UPDATE `creature_template` SET `unit_flags2`=67108864, `unit_flags3`=16777217, `ScriptName` = 'npc_bg_silvershard_mines_mine_cart' WHERE `entry`=60140; -- Mine Cart +UPDATE `creature_template` SET `unit_flags`=0x300, `unit_flags2`=0x4000800, `unit_flags3`=0x1000000 WHERE `entry`=60283; -- Track Switch + +DELETE FROM `creature_template_addon` WHERE `entry` IN (62671, 62672); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(62671, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '122297'), -- 62671 (BANANAS) - Hold Barrel +(62672, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '122236'); -- 62672 (Harrison Jones) - Read Scroll + +DELETE FROM `vehicle_template_accessory` WHERE (`seat_id`=0 AND `entry` IN (60380,60378)); +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(60380, 62671, 0, 0, 'Mine Cart - BANANAS', 7, 0), -- Mine Cart - BANANAS +(60378, 62672, 0, 0, 'Mine Cart - Harrison Jones', 7, 0); -- Mine Cart - Harrison Jones + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (60283, 60380, 60378); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(60283, 124491, 0x01, 0), -- Track Switch +(60380, 46598, 0, 0), -- Track Switch +(60378, 46598, 0, 0); -- Track Switch + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+8; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curHealthPct`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 14848, 727, 6126, 6126, '0', '0', 0, 0, 2, 906.5225830078125, 7.706597328186035156, 361.860107421875, 2.000355720520019531, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55461), -- Herald (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@CGUID+1, 14848, 727, 6126, 6126, '0', '0', 0, 0, 2, 593.90972900390625, 83.7725677490234375, 295.45196533203125, 0.001752360025420784, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55461), -- Herald (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@CGUID+2, 60145, 727, 6126, 6126, '0', '0', 0, 0, 0, 747.77606201171875, 195.439239501953125, 319.901123046875, 0, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55461), -- Points Trigger (Area: Silvershard Mines - Difficulty: 0) CreateObject1 (Auras: ) +(@CGUID+3, 14848, 727, 6126, 6126, '0', '0', 0, 0, 2, 760.64239501953125, 517.38714599609375, 357.34368896484375, 5.480351924896240234, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55461), -- Herald (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@CGUID+4, 14848, 727, 6126, 6126, '0', '0', 0, 0, 2, 545.951416015625, 328.916656494140625, 347.15789794921875, 0.214559689164161682, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55461), -- Herald (Area: Silvershard Mines - Difficulty: 0) CreateObject1 +(@CGUID+5, 60283, 727, 6126, 6126, '0', '0', 0, 0, 0, 715.64239501953125, 100.1649322509765625, 320.284454345703125, 4.592556476593017578, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55461), -- Track Switch (Area: Silvershard Mines - Difficulty: 0) CreateObject1 (Auras: 120228 - Track Switch Visual (Opened)) +(@CGUID+6, 60283, 727, 6126, 6126, '0', '0', 0, 0, 0, 845.55731201171875, 307.552093505859375, 347.03790283203125, 0.622477710247039794, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55461), -- Track Switch (Area: Silvershard Mines - Difficulty: 0) CreateObject1 (Auras: 120228 - Track Switch Visual (Opened)) +(@CGUID+7, 13117, 727, 6126, 6126, '0', '0', 0, 0, 1, 626.8836669921875, 231.08160400390625, 329.073974609375, 5.553977012634277343, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55461), -- Horde Spirit Guide (Area: Silvershard Mines - Difficulty: 0) CreateObject1 (Auras: 9036 - Ghost, 9617 - Ghost Visual) +(@CGUID+8, 13116, 727, 6126, 6126, '0', '0', 0, 0, 1, 854.2100830078125, 132.920135498046875, 329.073974609375, 2.267521858215332031, 7200, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 55461); -- Alliance Spirit Guide (Area: Silvershard Mines - Difficulty: 0) CreateObject1 (Auras: 9036 - Ghost, 9617 - Ghost Visual) + +UPDATE `creature` SET `StringId` = 'bg_silvershard_mines_track_switch_east' WHERE `guid` = @CGUID+5; +UPDATE `creature` SET `StringId` = 'bg_silvershard_mines_track_switch_north' WHERE `guid` = @CGUID+6; + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+8; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, '120228'), -- Track Switch - 120228 - Track Switch Visual (Opened) +(@CGUID+6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, ''); -- Track Switch + +DELETE FROM `creature_text` WHERE `CreatureID`=60140; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(60140, 1, 1, 'A %s has arrived from the center depot.', 41, 0, 100, 0, 0, 0, 60444, 3, 'Mine Cart'), +(60140, 2, 1, 'The Alliance has captured a Mine Cart!', 37, 0, 100, 0, 0, 0, 59689, 3, 'Mine Cart'), +(60140, 3, 1, 'The Horde has captured a Mine Cart!', 38, 0, 100, 0, 0, 0, 59690, 3, 'Mine Cart'); + +SET @PATH := 60140 * 100 + 0; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - South'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +-- (@PATH, -1, 741.8247, 200.5139, 319.5634, NULL, 0), -- Might be Spawn Position +(@PATH, 0, 738.9358, 204.10417, 319.60315, NULL, 0), +(@PATH, 1, 736.0469, 207.69444, 319.6429, NULL, 0), +(@PATH, 2, 732.5243, 213.625, 320.1088, NULL, 0), +(@PATH, 3, 730.5608, 219.11632, 320.54398, NULL, 0), +(@PATH, 4, 728.0052, 231.57639, 321.03696, NULL, 0), +(@PATH, 5, 725.6285, 236.94444, 321.03174, NULL, 0), +(@PATH, 6, 722.8368, 241.67708, 320.7483, NULL, 0), +(@PATH, 7, 720.7118, 244.52083, 321.24887, NULL, 0), +(@PATH, 8, 715.6458, 251.42361, 321.13367, NULL, 0), +(@PATH, 9, 710.8594, 261.08682, 320.8995, NULL, 0), +(@PATH, 10, 707.2899, 270.05383, 320.63297, NULL, 0), +(@PATH, 11, 703.6528, 278.1771, 320.5885, NULL, 0), +(@PATH, 12, 696.5243, 290.17883, 320.65274, NULL, 0), +(@PATH, 13, 686.26044, 301.60416, 321.03854, NULL, 0), +(@PATH, 14, 667.94965, 317.13715, 323.14688, NULL, 0), +(@PATH, 15, 660.3976, 323.90625, 324.70975, NULL, 0), +(@PATH, 16, 651.4028, 331.2066, 327.37286, NULL, 0), +(@PATH, 17, 638.68054, 342.33853, 332.27582, NULL, 0), +(@PATH, 18, 633.8316, 345.2587, 334.5666, NULL, 0), +(@PATH, 19, 626.21704, 345.49133, 337.44138, NULL, 0), +(@PATH, 20, 616.74133, 343.22397, 340.5497, NULL, 0), +(@PATH, 21, 601.7222, 340.30728, 344.57382, NULL, 0), +(@PATH, 22, 592.059, 339.27432, 346.0716, NULL, 0), +(@PATH, 23, 585.47394, 337.6736, 346.30173, NULL, 0); + +SET @PATH := 60140 * 100 + 1; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - South - End'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 563.509, 337.615, 347.005, NULL, 0); + +SET @PATH := 60140 * 100 + 2; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - North'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 759.32465, 198.3316, 319.53058, NULL, 0), +(@PATH, 1, 762.0156, 199.5382, 319.5831, NULL, 0), +(@PATH, 2, 765.59375, 202.52951, 319.96033, NULL, 0), +(@PATH, 3, 770.78644, 210.38194, 321.3461, NULL, 0), +(@PATH, 4, 776.9566, 222.91667, 323.30746, NULL, 0), +(@PATH, 5, 780.19617, 232.62154, 324.97916, NULL, 0), +(@PATH, 6, 783.5833, 241.64583, 327.92972, NULL, 0), +(@PATH, 7, 787.6268, 249.40105, 330.78836, NULL, 0), +(@PATH, 8, 794.5851, 259.57986, 336.81503, NULL, 0), +(@PATH, 9, 803.3455, 269.59027, 341.3372, NULL, 0), +(@PATH, 10, 816.42706, 282.56424, 344.84903, NULL, 0), +(@PATH, 11, 823.8924, 289.4271, 345.9665, NULL, 0), +(@PATH, 12, 830.2726, 294.85764, 346.55655, NULL, 0), +(@PATH, 13, 835.59204, 300.4184, 346.95596, NULL, 0); + +SET @PATH := 60140 * 100 + 3; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - North - East'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 838.25696, 302.21875, 347.33386, NULL, 0), +(@PATH, 1, 843.25696, 303.46875, 347.33386, NULL, 0), +(@PATH, 2, 848.25696, 303.71875, 347.33386, NULL, 0), +(@PATH, 3, 854.00696, 303.21875, 347.33386, NULL, 0), +(@PATH, 4, 860.00696, 301.46875, 347.58386, NULL, 0), +(@PATH, 5, 863.50696, 299.96875, 347.58386, NULL, 0), +(@PATH, 6, 867.25696, 297.46875, 347.58386, NULL, 0), +(@PATH, 7, 877.25696, 287.71875, 347.58386, NULL, 0), +(@PATH, 8, 881.75696, 279.21875, 347.33386, NULL, 0), +(@PATH, 9, 885.75696, 270.46875, 346.83386, NULL, 0), +(@PATH, 10, 889.25696, 261.21875, 346.33386, NULL, 0), +(@PATH, 11, 893.50696, 248.71875, 346.08386, NULL, 0), +(@PATH, 12, 894.75696, 241.71875, 346.58386, NULL, 0), +(@PATH, 13, 897.75696, 226.46875, 350.08386, NULL, 0), +(@PATH, 14, 904.25696, 210.46875, 354.83386, NULL, 0), +(@PATH, 15, 911.50696, 178.46875, 363.83386, NULL, 0), +(@PATH, 16, 912.50696, 168.21875, 366.58386, NULL, 0), +(@PATH, 17, 912.00696, 163.21875, 366.83386, NULL, 0), +(@PATH, 18, 909.00696, 153.46875, 366.83386, NULL, 0), +(@PATH, 19, 907.00696, 149.71875, 366.83386, NULL, 0), +(@PATH, 20, 898.25696, 138.71875, 366.83386, NULL, 0), +(@PATH, 21, 888.25696, 126.21875, 366.58386, NULL, 0), +(@PATH, 22, 885.50696, 120.46875, 366.33386, NULL, 0), +(@PATH, 23, 882.75696, 109.21875, 365.83386, NULL, 0), +(@PATH, 24, 882.25696, 104.71875, 365.58386, NULL, 0), +(@PATH, 25, 883.75696, 97.21875, 365.33386, NULL, 0), +(@PATH, 26, 889.00696, 89.46875, 365.08386, NULL, 0), +(@PATH, 27, 891.00696, 82.46875, 365.08386, NULL, 0), +(@PATH, 28, 891.00696, 76.46875, 364.83386, NULL, 0), +(@PATH, 29, 890.25696, 70.96875, 365.08386, NULL, 0), +(@PATH, 30, 890.75696, 62.96875, 364.83386, NULL, 0), +(@PATH, 31, 891.75696, 56.21875, 364.58386, NULL, 0), +(@PATH, 32, 893.9219, 45.519096, 363.71173, NULL, 0); + +SET @PATH := 60140 * 100 + 4; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - North - East - End'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 893.2969, 41.380196, 363.83173, NULL, 0), +(@PATH, 1, 893.2969, 37.880196, 364.08173, NULL, 0), +(@PATH, 2, 893.2969, 35.130196, 364.08173, NULL, 0), +(@PATH, 3, 893.5469, 33.130196, 364.08173, NULL, 0), +(@PATH, 4, 895.2969, 29.380196, 364.08173, NULL, 0), +(@PATH, 5, 897.1719, 25.24132, 363.95175, NULL, 0); + +SET @PATH := 60140 * 100 + 5; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - North - West'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 837.74133, 303.2179, 347.39374, NULL, 0), +(@PATH, 1, 840.74133, 307.4679, 347.39374, NULL, 0), +(@PATH, 2, 844.74133, 314.2179, 347.39374, NULL, 0), +(@PATH, 3, 847.99133, 321.7179, 347.64374, NULL, 0), +(@PATH, 4, 848.74133, 326.9679, 347.39374, NULL, 0), +(@PATH, 5, 846.99133, 342.7179, 347.39374, NULL, 0), +(@PATH, 6, 843.49133, 350.9679, 347.64374, NULL, 0), +(@PATH, 7, 831.99133, 372.4679, 347.39374, NULL, 0), +(@PATH, 8, 822.49133, 397.4679, 347.14374, NULL, 0), +(@PATH, 9, 818.74133, 406.9679, 348.14374, NULL, 0), +(@PATH, 10, 817.99133, 410.4679, 348.89374, NULL, 0), +(@PATH, 11, 816.74133, 419.2179, 350.64374, NULL, 0), +(@PATH, 12, 817.24133, 422.7179, 351.39374, NULL, 0), +(@PATH, 13, 815.99133, 429.2179, 353.39374, NULL, 0), +(@PATH, 14, 814.24133, 434.7179, 355.14374, NULL, 0), +(@PATH, 15, 810.99133, 442.2179, 357.14374, NULL, 0), +(@PATH, 16, 807.49133, 457.7179, 358.89374, NULL, 0), +(@PATH, 17, 806.74133, 466.4679, 359.14374, NULL, 0), +(@PATH, 18, 803.99133, 472.9679, 359.39374, NULL, 0), +(@PATH, 19, 800.99133, 476.9679, 359.64374, NULL, 0), +(@PATH, 20, 793.74133, 485.2179, 359.64374, NULL, 0), +(@PATH, 21, 791.3906, 487.51736, 359.3315, NULL, 0); + +SET @PATH := 60140 * 100 + 6; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - North - West - End'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 778.271, 502.75, 359.293, NULL, 0); + +SET @PATH := 60140 * 100 + 7; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - East'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 744.5174, 183.19792, 319.54395, NULL, 0), +(@PATH, 1, 742.8542, 178.96355, 319.60175, NULL, 0), +(@PATH, 2, 739.8906, 171.5191, 319.36505, NULL, 0), +(@PATH, 3, 735.5955, 163.54341, 319.2191, NULL, 0), +(@PATH, 4, 730.4774, 155.19444, 319.13043, NULL, 0), +(@PATH, 5, 728.85767, 152.40625, 319.62506, NULL, 0), +(@PATH, 6, 723.92365, 143.10417, 319.6667, NULL, 0), +(@PATH, 7, 719.36456, 131.09375, 319.55307, NULL, 0), +(@PATH, 8, 717.6007, 122.72222, 320.09778, NULL, 0), +(@PATH, 9, 716.9514, 113.51736, 320.84427, NULL, 0); + +SET @PATH := 60140 * 100 + 8; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - East - South'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 715.82294, 109.03732, 321.0153, NULL, 0), +(@PATH, 1, 713.32294, 104.28732, 320.2653, NULL, 0), +(@PATH, 2, 706.82294, 99.28732, 319.0153, NULL, 0), +(@PATH, 3, 701.82294, 97.28732, 317.7653, NULL, 0), +(@PATH, 4, 695.07294, 96.53732, 316.2653, NULL, 0), +(@PATH, 5, 686.57294, 95.53732, 314.5153, NULL, 0), +(@PATH, 6, 680.32294, 94.53732, 312.7653, NULL, 0), +(@PATH, 7, 670.32294, 90.03732, 309.5153, NULL, 0), +(@PATH, 8, 663.82294, 86.53732, 307.0153, NULL, 0), +(@PATH, 9, 660.32294, 84.53732, 305.7653, NULL, 0), +(@PATH, 10, 647.32294, 82.03732, 302.0153, NULL, 0), +(@PATH, 11, 638.57294, 81.53732, 299.5153, NULL, 0), +(@PATH, 12, 634.69446, 81.05729, 298.6863, NULL, 0); + +SET @PATH := 60140 * 100 + 9; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - East - South - End'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 615.415, 79.6458, 298.101, NULL, 0); + +SET @PATH := 60140 * 100 + 10; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - East - North'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 716.97485, 108.50173, 321.13733, NULL, 0), +(@PATH, 1, 719.97485, 101.50173, 321.38733, NULL, 0), +(@PATH, 2, 724.47485, 98.25173, 322.13733, NULL, 0), +(@PATH, 3, 732.72485, 94.75173, 323.88733, NULL, 0), +(@PATH, 4, 737.72485, 93.75173, 325.88733, NULL, 0), +(@PATH, 5, 744.47485, 92.25173, 328.13733, NULL, 0), +(@PATH, 6, 758.72485, 89.25173, 332.88733, NULL, 0), +(@PATH, 7, 767.22485, 86.00173, 336.13733, NULL, 0), +(@PATH, 8, 774.22485, 82.25173, 339.38733, NULL, 0), +(@PATH, 9, 784.22485, 79.50173, 342.88733, NULL, 0), +(@PATH, 10, 793.72485, 78.25173, 346.13733, NULL, 0), +(@PATH, 11, 798.22485, 77.25173, 348.13733, NULL, 0), +(@PATH, 12, 803.97485, 74.75173, 349.88733, NULL, 0), +(@PATH, 13, 807.72485, 72.25173, 351.13733, NULL, 0), +(@PATH, 14, 813.47485, 67.75173, 352.88733, NULL, 0), +(@PATH, 15, 819.97485, 64.00173, 354.88733, NULL, 0), +(@PATH, 16, 823.97485, 63.00173, 355.88733, NULL, 0), +(@PATH, 17, 829.72485, 63.00173, 357.13733, NULL, 0), +(@PATH, 18, 833.47485, 64.25173, 357.88733, NULL, 0), +(@PATH, 19, 842.22485, 70.50173, 359.88733, NULL, 0), +(@PATH, 20, 850.47485, 71.50173, 361.38733, NULL, 0), +(@PATH, 21, 859.47485, 69.00173, 362.88733, NULL, 0), +(@PATH, 22, 865.47485, 65.25173, 363.88733, NULL, 0), +(@PATH, 23, 873.47485, 58.00173, 364.63733, NULL, 0), +(@PATH, 24, 879.72485, 51.75173, 364.63733, NULL, 0), +(@PATH, 25, 885.4983, 42.98611, 363.93036, NULL, 0); + +SET @PATH := 60140 * 100 + 11; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart - East - North - End'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 887.8976, 40.052082, 363.96014, NULL, 0), +(@PATH, 1, 890.1476, 37.052082, 363.96014, NULL, 0), +(@PATH, 2, 891.8976, 34.802082, 364.21014, NULL, 0), +(@PATH, 3, 893.1476, 33.302082, 364.21014, NULL, 0), +(@PATH, 4, 895.1476, 29.302082, 364.21014, NULL, 0), +(@PATH, 5, 896.7969, 25.618055, 363.98996, null, 0); + +SET @PATH := 60379 * 100 + 0; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart (Cosmetic) - 1'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 735.7135, 293.2292, 398.70938, NULL, 0), +(@PATH, 1, 731.86456, 290.72745, 398.5858, NULL, 0), +(@PATH, 2, 728.0156, 288.2257, 398.4622, NULL, 0), +(@PATH, 3, 714.0347, 274.5382, 395.02786, NULL, 0), +(@PATH, 4, 706.36804, 263.4514, 393.16946, NULL, 0), +(@PATH, 5, 698.7674, 246.16145, 391.61017, NULL, 0), +(@PATH, 6, 693.3455, 230.83333, 391.1844, NULL, 0), +(@PATH, 7, 692.309, 213.23611, 390.35565, NULL, 0), +(@PATH, 8, 697.783, 197.06598, 388.44452, NULL, 0), +(@PATH, 9, 705.8802, 185.94618, 386.44757, NULL, 0), +(@PATH, 10, 722.11804, 176.19966, 380.83176, NULL, 0), +(@PATH, 11, 738.55035, 174.20486, 376.92075, NULL, 0), +(@PATH, 12, 745.15454, 174.79341, 375.73212, NULL, 0), +(@PATH, 13, 756.8698, 178.67014, 373.56097, NULL, 0), +(@PATH, 14, 760.05206, 180.32812, 373.28217, NULL, 0), +(@PATH, 15, 771.40106, 190.80035, 374.18176, NULL, 0), +(@PATH, 16, 778.2118, 199.4948, 375.7447, NULL, 0), +(@PATH, 17, 786.6476, 217.34201, 379.0099, NULL, 0), +(@PATH, 18, 790.3073, 228.7257, 379.14127, NULL, 0), +(@PATH, 19, 792.0139, 239.59029, 376.86124, NULL, 0), +(@PATH, 20, 793.3733, 245.70139, 374.7973, NULL, 0), +(@PATH, 21, 797.2743, 254.91145, 371.12878, NULL, 0), +(@PATH, 22, 800.6684, 260.34723, 368.272, NULL, 0), +(@PATH, 23, 804.48267, 263.93924, 368.13562, NULL, 0), +(@PATH, 24, 815.56946, 272.24652, 368.79605, NULL, 0), +(@PATH, 25, 823.11456, 280.97745, 370.88733, NULL, 0), +(@PATH, 26, 834.38715, 294.5087, 373.0812, NULL, 0), +(@PATH, 27, 848.27954, 307.47397, 374.22733, NULL, 0), +(@PATH, 28, 860.3802, 320.32465, 375.4498, NULL, 0), +(@PATH, 29, 871.44446, 333.64236, 376.49252, NULL, 0), +(@PATH, 30, 875.5174, 338.5434, 376.8501, NULL, 0), +(@PATH, 31, 880.76044, 342.86285, 378.05972, NULL, 0), +(@PATH, 32, 889.17365, 348.11978, 380.0994, NULL, 0), +(@PATH, 33, 893.8594, 350.12152, 381.12195, NULL, 0), +(@PATH, 34, 899.5382, 350.87326, 382.26337, NULL, 0), +(@PATH, 35, 913.4601, 352.25696, 383.08, NULL, 0), +(@PATH, 36, 928.8368, 353.97916, 383.14316, NULL, 0), +(@PATH, 37, 933.809, 354.85416, 383.23328, NULL, 0), +(@PATH, 38, 947.9757, 361.87674, 384.30017, NULL, 0), +(@PATH, 39, 957.875, 368.30728, 384.98563, NULL, 0), +(@PATH, 40, 965.8108, 372.96353, 384.33072, NULL, 0), +(@PATH, 41, 987.5052, 379.3889, 383.41644, NULL, 0), +(@PATH, 42, 1004.0208, 381.5, 383.40344, NULL, 0), +(@PATH, 43, 1013.2708, 380.30557, 382.4711, NULL, 0), +(@PATH, 44, 1026.6077, 375.3021, 380.2595, NULL, 0), +(@PATH, 45, 1032.1163, 371.1632, 379.65323, NULL, 0), +(@PATH, 46, 1037.3195, 367.58682, 379.32047, NULL, 0), +(@PATH, 47, 1041.4375, 363.4514, 379.4645, NULL, 0), +(@PATH, 48, 1048.9202, 355.4479, 379.80124, NULL, 0), +(@PATH, 49, 1053.4896, 347.11978, 379.97577, NULL, 0), +(@PATH, 50, 1058.8125, 334.93402, 380.25137, NULL, 0), +(@PATH, 51, 1064.6041, 316.09897, 380.37222, NULL, 0), +(@PATH, 52, 1063.8524, 306.75522, 379.75546, NULL, 0), +(@PATH, 53, 1062.0416, 300.1337, 378.58887, NULL, 0), +(@PATH, 54, 1059.6476, 296.14932, 377.7218, NULL, 0), +(@PATH, 55, 1045.026, 275.39758, 375.382, NULL, 0); + +SET @PATH := 60379 * 100 + 1; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart (Cosmetic) - 2'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 580.17706, 305.46524, 395.6946, NULL, 0), +(@PATH, 1, 583.8715, 304.40103, 396.251, NULL, 0), +(@PATH, 2, 587.566, 303.33682, 396.8074, NULL, 0), +(@PATH, 3, 601.57465, 312.1771, 396.0683, NULL, 0), +(@PATH, 4, 618.4549, 316.8611, 394.96066, NULL, 0), +(@PATH, 5, 635.9514, 318.70486, 394.21738, NULL, 0), +(@PATH, 6, 648.25867, 318.11807, 393.31815, NULL, 0), +(@PATH, 7, 658.309, 312.55557, 390.93103, NULL, 0), +(@PATH, 8, 661.7483, 310.2396, 389.92807, NULL, 0), +(@PATH, 9, 669.8281, 299.9809, 388.26355, NULL, 0), +(@PATH, 10, 673.09375, 296.39932, 387.64984, NULL, 0), +(@PATH, 11, 678.57294, 290.21875, 386.97983, NULL, 0), +(@PATH, 12, 682.033, 286.47397, 386.33453, NULL, 0), +(@PATH, 13, 690.8507, 270.93228, 384.19302, NULL, 0), +(@PATH, 14, 702.21356, 258.717, 380.11124, NULL, 0), +(@PATH, 15, 708.0972, 255.76042, 378.24768, NULL, 0), +(@PATH, 16, 721.75, 251.1875, 374.3099, NULL, 0), +(@PATH, 17, 738.5972, 251.07986, 371.8639, NULL, 0), +(@PATH, 18, 754.90625, 252.67535, 370.3364, NULL, 0), +(@PATH, 19, 773.30206, 255.25, 369.9608, NULL, 0), +(@PATH, 20, 784.9809, 256.5521, 369.80273, NULL, 0), +(@PATH, 21, 799.65454, 261.37848, 368.89142, NULL, 0), +(@PATH, 22, 815.2309, 272.30902, 368.7668, NULL, 0), +(@PATH, 23, 823.17706, 280.9045, 370.88882, NULL, 0), +(@PATH, 24, 833.94446, 294.62674, 373.07675, NULL, 0), +(@PATH, 25, 848.4583, 307.42014, 374.23453, NULL, 0), +(@PATH, 26, 860.01044, 320.06076, 375.40463, NULL, 0), +(@PATH, 27, 874.8958, 338.64758, 376.81577, NULL, 0), +(@PATH, 28, 889.1285, 348.17883, 380.09464, NULL, 0), +(@PATH, 29, 893.93054, 349.85416, 381.11908, NULL, 0), +(@PATH, 30, 899.82465, 350.94965, 382.29288, NULL, 0), +(@PATH, 31, 913.46356, 352.2014, 383.08054, NULL, 0), +(@PATH, 32, 929.11115, 353.93402, 383.16205, NULL, 0), +(@PATH, 33, 933.67365, 354.78125, 383.21063, NULL, 0), +(@PATH, 34, 947.7917, 361.9566, 384.28598, NULL, 0), +(@PATH, 35, 957.55206, 368.69965, 385.0245, NULL, 0), +(@PATH, 36, 965.9583, 373.408, 384.33798, NULL, 0), +(@PATH, 37, 976.3715, 377.1059, 383.54767, NULL, 0), +(@PATH, 38, 996.7101, 381.62326, 383.80093, NULL, 0); + +SET @PATH := 60379 * 100 + 2; +DELETE FROM `waypoint_path` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0x2, 'Battleground Silvershard Mines - Mine Cart (Cosmetic) - 3'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` = @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1117.7551, 285.7205, 389.8406, NULL, 0), +(@PATH, 1, 1112.283, 287.04688, 390.49927, NULL, 0), +(@PATH, 2, 1106.8108, 288.37326, 391.15793, NULL, 0), +(@PATH, 3, 1085.8785, 293.11807, 392.2367, NULL, 0), +(@PATH, 4, 1069.0625, 297.52603, 391.34763, NULL, 0), +(@PATH, 5, 1048.908, 294.625, 390.70905, NULL, 0), +(@PATH, 6, 1032.3317, 289.79514, 389.98892, NULL, 0), +(@PATH, 7, 1020.8004, 285.28995, 389.7066, NULL, 0), +(@PATH, 8, 1012.1007, 281.94446, 389.90375, NULL, 0), +(@PATH, 9, 1000.3351, 271.69965, 392.6553, NULL, 0), +(@PATH, 10, 994.21356, 263.77777, 394.44055, NULL, 0), +(@PATH, 11, 975.9774, 236.66667, 395.3355, NULL, 0), +(@PATH, 12, 955.8941, 207.41493, 393.21887, NULL, 0), +(@PATH, 13, 948.24304, 192.37326, 396.24258, NULL, 0), +(@PATH, 14, 944.36285, 182.16145, 398.97665, NULL, 0), +(@PATH, 15, 941.1302, 176.33507, 400.0023, NULL, 0), +(@PATH, 16, 938.5278, 173.0868, 400.44632, NULL, 0), +(@PATH, 17, 934.0434, 168.74132, 400.6807, NULL, 0), +(@PATH, 18, 929.7205, 164.76562, 400.79932, NULL, 0), +(@PATH, 19, 906.75867, 146.71875, 402.70294, NULL, 0), +(@PATH, 20, 903.158, 142.79688, 403.11172, NULL, 0), +(@PATH, 21, 897.2917, 133.44618, 403.73123, NULL, 0), +(@PATH, 22, 891.4618, 122.44618, 403.4227, NULL, 0), +(@PATH, 23, 887.09375, 109.50521, 404.85757, NULL, 0), +(@PATH, 24, 878.2118, 96.80729, 407.5734, NULL, 0), +(@PATH, 25, 871.0018, 88.90972, 408.27496, NULL, 0), +(@PATH, 26, 860.5382, 77.55903, 407.2642, NULL, 0), +(@PATH, 27, 853.0347, 71.40104, 405.6935, NULL, 0), +(@PATH, 28, 830.0677, 57.95139, 400.13443, NULL, 0), +(@PATH, 29, 822.6893, 56.282986, 399.9273, NULL, 0), +(@PATH, 30, 813.30554, 56.605904, 400.81268, NULL, 0); diff --git a/src/server/game/Battlegrounds/Battleground.cpp b/src/server/game/Battlegrounds/Battleground.cpp index 237c283f8c6..f9b2944fd7d 100644 --- a/src/server/game/Battlegrounds/Battleground.cpp +++ b/src/server/game/Battlegrounds/Battleground.cpp @@ -1380,6 +1380,7 @@ void Battleground::HandleKillPlayer(Player* victim, Player* killer) UpdatePlayerScore(killer, SCORE_HONORABLE_KILLS, 1); UpdatePlayerScore(killer, SCORE_KILLING_BLOWS, 1); + killer->UpdateCriteria(CriteriaType::KillPlayer, 1, 0, 0, victim); for (BattlegroundPlayerMap::const_iterator itr = m_Players.begin(); itr != m_Players.end(); ++itr) { @@ -1388,7 +1389,10 @@ void Battleground::HandleKillPlayer(Player* victim, Player* killer) continue; if (itr->second.Team == killerTeam && creditedPlayer->IsAtGroupRewardDistance(victim)) + { UpdatePlayerScore(creditedPlayer, SCORE_HONORABLE_KILLS, 1); + creditedPlayer->UpdateCriteria(CriteriaType::KillPlayer, 1, 0, 0, victim); + } } } diff --git a/src/server/game/Entities/GameObject/GameObject.cpp b/src/server/game/Entities/GameObject/GameObject.cpp index 2600a5fbdf9..eb48c74b1fa 100644 --- a/src/server/game/Entities/GameObject/GameObject.cpp +++ b/src/server/game/Entities/GameObject/GameObject.cpp @@ -4495,6 +4495,18 @@ void GameObject::HandleCustomTypeCommand(GameObjectTypeBase::CustomCommand const command.Execute(*m_goTypeImpl); } +TeamId GameObject::GetControllingTeam() const +{ + if (GetGoType() != GAMEOBJECT_TYPE_CONTROL_ZONE) + return TEAM_NEUTRAL; + + GameObjectType::ControlZone const* controlZone = dynamic_cast<GameObjectType::ControlZone const*>(m_goTypeImpl.get()); + if (!controlZone) + return TEAM_NEUTRAL; + + return controlZone->GetControllingTeam(); +} + void GameObject::CreateModel() { m_model = GameObjectModel::Create(std::make_unique<GameObjectModelOwnerImpl>(this), sWorld->GetDataPath()); diff --git a/src/server/game/Entities/GameObject/GameObject.h b/src/server/game/Entities/GameObject/GameObject.h index 160b768544b..381317169db 100644 --- a/src/server/game/Entities/GameObject/GameObject.h +++ b/src/server/game/Entities/GameObject/GameObject.h @@ -453,6 +453,8 @@ class TC_GAME_API GameObject : public WorldObject, public GridObject<GameObject> UF::UpdateField<UF::GameObjectData, 0, TYPEID_GAMEOBJECT> m_gameObjectData; + TeamId GetControllingTeam() const; + protected: void CreateModel(); void UpdateModel(); // updates model in case displayId were changed diff --git a/src/server/scripts/Battlegrounds/SilvershardMines/battleground_silvershard_mines.cpp b/src/server/scripts/Battlegrounds/SilvershardMines/battleground_silvershard_mines.cpp new file mode 100644 index 00000000000..30721e47425 --- /dev/null +++ b/src/server/scripts/Battlegrounds/SilvershardMines/battleground_silvershard_mines.cpp @@ -0,0 +1,949 @@ +/* + * 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 "Battleground.h" +#include "BattlegroundScore.h" +#include "BattlegroundScript.h" +#include "Containers.h" +#include "GameObject.h" +#include "GameTime.h" +#include "Map.h" +#include "MotionMaster.h" +#include "ObjectAccessor.h" +#include "Player.h" +#include "ScriptedCreature.h" +#include "ScriptMgr.h" +#include "SpellAuras.h" +#include "SpellScript.h" +#include "TaskScheduler.h" +#include "TemporarySummon.h" + +namespace SilvershardMines +{ + namespace Actions + { + static constexpr uint32 MineCartCaptured = 1; + static constexpr uint32 TrackChanged = 2; + static constexpr uint32 MineCartControlChanged = 3; + static constexpr uint32 MineCartCapturedPlayer = 4; + } + + namespace BroadcastTexts + { + static constexpr uint32 AllianceControlsMineCart = 60441; + static constexpr uint32 HordeControlsMineCart = 60442; + + static constexpr uint32 EasternCrossroadsChangedTracks = 60030; + static constexpr uint32 NorthernCrossroadsChangedTracks = 60032; + } + + namespace Creatures + { + static constexpr uint32 MineCart = 60140; + + static constexpr uint32 MineCartCosmetic1 = 60379; + static constexpr uint32 MineCartCosmetic2 = 60378; + static constexpr uint32 MineCartCosmetic3 = 60380; + + static constexpr std::array<std::pair<uint32, double>, 3> CosmeticCarts = + {{ + { MineCartCosmetic1, 1.0 }, + { MineCartCosmetic2, 0.05 }, + { MineCartCosmetic3, 0.05 } + }}; + } + + namespace CreatureTexts::MineCart + { + static constexpr uint32 Spawned = 1; + static constexpr uint32 CapturedByAlliance = 2; + static constexpr uint32 CapturedByHorde = 3; + } + + namespace Events + { + static constexpr uint32 ProgressEventHordeEast = 32909; + static constexpr uint32 ProgressEventAllianceEast = 32910; + static constexpr uint32 ProgressEventNeutralEast = 32912; + + static constexpr uint32 ProgressEventHordeNorth = 31167; + static constexpr uint32 ProgressEventAllianceNorth = 31166; + + static constexpr uint32 ProgressEventHordeSouth = 32937; + static constexpr uint32 ProgressEventAllianceSouth = 32938; + static constexpr uint32 ProgressEventNeutralSouth = 32951; + } + + namespace GameObjects + { + static constexpr uint32 Gate1 = 212939; + static constexpr uint32 Gate2 = 212940; + static constexpr uint32 Gate3 = 212941; + static constexpr uint32 Gate4 = 212942; + + } + + namespace Maps + { + static constexpr uint32 BattlegroundMap = 727; + } + + namespace PathIds + { + static constexpr uint32 South = Creatures::MineCart * 100 + 0; + static constexpr uint32 SouthEnd = Creatures::MineCart * 100 + 1; + + static constexpr uint32 North = Creatures::MineCart * 100 + 2; + static constexpr uint32 NorthEast = Creatures::MineCart * 100 + 3; + static constexpr uint32 NorthEastEnd = Creatures::MineCart * 100 + 4; + static constexpr uint32 NorthWest = Creatures::MineCart * 100 + 5; + static constexpr uint32 NorthWestEnd = Creatures::MineCart * 100 + 6; + + static constexpr uint32 East = Creatures::MineCart * 100 + 7; + static constexpr uint32 EastSouth = Creatures::MineCart * 100 + 8; + static constexpr uint32 EastSouthEnd = Creatures::MineCart * 100 + 9; + static constexpr uint32 EastNorth = Creatures::MineCart * 100 + 10; + static constexpr uint32 EastNorthEnd = Creatures::MineCart * 100 + 11; + + static constexpr uint32 CosmeticCart1 = Creatures::MineCartCosmetic1 * 100 + 0; + static constexpr uint32 CosmeticCart2 = Creatures::MineCartCosmetic1 * 100 + 1; + static constexpr uint32 CosmeticCart3 = Creatures::MineCartCosmetic1 * 100 + 2; + } + + namespace PvpStats + { + static constexpr uint32 CartsCaptured = 428; + } + + namespace Score + { + static constexpr uint32 Max = 1500; + static constexpr uint32 Capture = 150; + } + + namespace SpawnPositions + { + static constexpr Position MineCartSouth = { 739.29517f, 203.76389f, 319.54398f, 2.261440753936767578f }; + static constexpr Position MineCartEast = { 744.5174f, 183.19792f, 319.54395f, 4.338116168975830078f }; + static constexpr Position MineCartNorth = { 759.32465f, 198.3316f, 319.53058f, 0.421508282423019409f }; + + static constexpr std::array<std::pair<uint32, Position>, 3> CosmeticCartsSpawnPositions = + { { + { PathIds::CosmeticCart1, { 735.7135f, 293.2292f, 398.70938f } }, + { PathIds::CosmeticCart2, { 580.17706f, 305.46524f, 395.6946f } }, + { PathIds::CosmeticCart3, { 1117.7551f, 285.7205f, 389.8406f } } + }}; + } + + namespace Spells + { + static constexpr uint32 ControlVisualNeutral = 118001; + static constexpr uint32 ControlVisualHorde = 116085; + static constexpr uint32 ControlVisualAlliance = 116086; + + static constexpr uint32 CartControlCapturePointUnitEast = 125620; + static constexpr uint32 CartControlCapturePointUnitNorth = 125695; + static constexpr uint32 CartControlCapturePointUnitSouth = 125696; + + static constexpr uint32 DefendingCartAura = 128646; // triggers 128648 + + static constexpr uint32 CartCap = 115904; + + static constexpr uint32 Capturing = 124492; + + static constexpr uint32 TrackSwitchVisualOpened = 120228; + static constexpr uint32 TrackSwitchVisualClosed = 120229; + + // Achievements + + // Mine Cart Courier + // Capture a mine cart using each of the 5 sets of tracks in a single match + static constexpr uint32 MineCartCourierEastSouth = 128702; + static constexpr uint32 MineCartCourierEastNorth = 128703; + static constexpr uint32 MineCartCourierNorthWest = 128706; + static constexpr uint32 MineCartCourierNorthEast = 128705; + static constexpr uint32 MineCartCourierSouth = 128704; + + // End of the Line + // Seize control of a mine that is controlled by the opposing team within 20yards of the depot, and then capture it + static constexpr uint32 EndOfTheLineAchievementCheck = 128720; + + // The Long Riders + // Escort a mine from its spawn to a depot and capture it without losing control + static constexpr uint32 LongRiderAchievementEastAlliance = 128672; + static constexpr uint32 LongRiderAchievementEastHorde = 128668; + static constexpr uint32 LongRiderAchievementNorthAlliance = 128673; + static constexpr uint32 LongRiderAchievementNorthHorde = 128669; + static constexpr uint32 LongRiderAchievementSouthAlliance = 128674; + static constexpr uint32 LongRiderAchievementSouthHorde = 128670; + + // Five for Five + // Capture five mine carts in a single Silvershard Mines battle without dying + static constexpr uint32 ThreeForThreeComplete = 128650; + } + + namespace StringIds + { + static constexpr std::string_view MineDepot = "bg_silvershard_mine_depot"; + static constexpr std::string_view TrackSwitchEast = "bg_silvershard_mines_track_switch_east"; + static constexpr std::string_view TrackSwitchNorth = "bg_silvershard_mines_track_switch_north"; + } + + namespace WorldStates + { + static constexpr int32 EasternCrossroadsTrackSwitchState = 6467; // 1 (closed) or 2 (open) + static constexpr int32 NorthernCrossroadsTrackSwitchState = 6468; // 1 (closed) or 2 (open) + + static constexpr int32 AllianceTeamScore = 6437; + static constexpr int32 HordeTeamScore = 6438; + + static constexpr int32 HordeControlsSouthCart = 6882; + static constexpr int32 AllianceControlsSouthCart = 6881; + + static constexpr int32 HordeControlsNorthCart = 6879; + static constexpr int32 AllianceControlsNorthCart = 6880; + + static constexpr int32 HordeControlsEastCart = 6440; + static constexpr int32 AllianceControlsEastCart = 6439; + + static constexpr std::array<int32, 3> AllianceControlWorldStates = { AllianceControlsSouthCart, AllianceControlsNorthCart, AllianceControlsEastCart }; + static constexpr std::array<int32, 3> HordeControlWorldStates = { HordeControlsSouthCart, HordeControlsNorthCart, HordeControlsEastCart }; + + // My Diamonds and Your Rust + // Win a Silvershard Mines battle without letting the enemy team capture a mine cart + // WSE: 12385, "(WorldState(6954) + WorldState(6955)) == 1") + // values might be swapped, they are not send to client + static constexpr int32 AllianceCapturedMineCart = 6954; + static constexpr int32 HordeCapturedMineCart = 6955; + } + + enum class TrackSwitchState : uint32 + { + Closed = 1, + Open + }; +} + +struct battleground_silvershard_mines final : BattlegroundScript +{ + explicit battleground_silvershard_mines(BattlegroundMap* map) : BattlegroundScript(map) { } + + void OnInit() override + { + // setup spawning of cosmetic carts + _scheduler.Schedule(5s, [&](TaskContext context) + { + for (auto const& [pathId, spawnPosition] : SilvershardMines::SpawnPositions::CosmeticCartsSpawnPositions) + { + auto const& [entry, weight] = *Trinity::Containers::SelectRandomWeightedContainerElement(SilvershardMines::Creatures::CosmeticCarts, [](std::pair<uint32, double> const& pair) + { + return pair.second; + }); + + if (Creature* creature = battlegroundMap->SummonCreature(entry, spawnPosition)) + creature->GetMotionMaster()->MovePath(pathId, false); + } + + context.Repeat(); + }); + } + + void OnUpdate(uint32 diff) override + { + BattlegroundScript::OnUpdate(diff); + _scheduler.Update(diff); + } + + void OnPrepareStage2() override + { + BattlegroundScript::OnPrepareStage2(); + SpawnSouthernMineCart(); + SpawnNorthernMineCart(); + } + + void OnStart() override + { + BattlegroundScript::OnStart(); + for (ObjectGuid door : _doors) + { + if (GameObject* gameObject = battlegroundMap->GetGameObject(door)) + { + gameObject->UseDoorOrButton(); + gameObject->DespawnOrUnsummon(3s); + } + } + + SpawnEasternMineCart(); + _scheduler.Schedule(2s, [&](TaskContext context) + { + uint32 const underAllianceControl = std::ranges::count_if(SilvershardMines::WorldStates::AllianceControlWorldStates, [&](int32 worldState) + { + return battlegroundMap->GetWorldStateValue(worldState) == 1; + }); + + uint32 const underHordeControl = std::ranges::count_if(SilvershardMines::WorldStates::HordeControlWorldStates, [&](int32 worldState) + { + return battlegroundMap->GetWorldStateValue(worldState) == 1; + }); + + uint32 const hordeScoreToAdd = std::min<uint32>(SilvershardMines::Score::Max - battleground->GetTeamScore(TEAM_HORDE), underHordeControl); + uint32 const allianceScoreToAdd = std::min<uint32>(SilvershardMines::Score::Max - battleground->GetTeamScore(TEAM_ALLIANCE), underAllianceControl); + + battleground->AddPoint(HORDE, hordeScoreToAdd); + battleground->AddPoint(ALLIANCE, allianceScoreToAdd); + + SendTeamScores(); + if (!CheckWinner()) + context.Repeat(); + }); + } + + void ProcessEvent(WorldObject* obj, uint32 eventId, WorldObject* invoker) override + { + BattlegroundScript::ProcessEvent(obj, eventId, invoker); + + switch (eventId) + { + case SilvershardMines::Events::ProgressEventHordeSouth: + case SilvershardMines::Events::ProgressEventHordeEast: + case SilvershardMines::Events::ProgressEventHordeNorth: + HandleProgressEvent(WorldObject::ToGameObject(invoker), HORDE, CHAT_MSG_BG_SYSTEM_HORDE, SilvershardMines::BroadcastTexts::HordeControlsMineCart, SilvershardMines::Spells::ControlVisualHorde); + break; + case SilvershardMines::Events::ProgressEventAllianceSouth: + case SilvershardMines::Events::ProgressEventAllianceEast: + case SilvershardMines::Events::ProgressEventAllianceNorth: + HandleProgressEvent(WorldObject::ToGameObject(invoker), ALLIANCE, CHAT_MSG_BG_SYSTEM_ALLIANCE, SilvershardMines::BroadcastTexts::AllianceControlsMineCart, SilvershardMines::Spells::ControlVisualAlliance); + break; + case SilvershardMines::Events::ProgressEventNeutralEast: + case SilvershardMines::Events::ProgressEventNeutralSouth: + HandleProgressEvent(WorldObject::ToGameObject(invoker), TEAM_OTHER); + break; + default: + break; + } + } + + void DoAction(uint32 actionId, WorldObject* source, WorldObject* target) override + { + BattlegroundScript::DoAction(actionId, source, target); + + switch (actionId) + { + case SilvershardMines::Actions::MineCartCaptured: + OnMineCartCaptured(Object::ToCreature(source)); + break; + case SilvershardMines::Actions::TrackChanged: + OnTrackSwitched(Object::ToPlayer(source), Object::ToCreature(target)); + break; + case SilvershardMines::Actions::MineCartCapturedPlayer: + OnPlayerCapturedMineCart(Object::ToPlayer(target)); + break; + default: + break; + } + } + + void OnGameObjectCreate(GameObject* gameobject) override + { + BattlegroundScript::OnGameObjectCreate(gameobject); + + switch (gameobject->GetEntry()) + { + case SilvershardMines::GameObjects::Gate1: + case SilvershardMines::GameObjects::Gate2: + case SilvershardMines::GameObjects::Gate3: + case SilvershardMines::GameObjects::Gate4: + _doors.push_back(gameobject->GetGUID()); + break; + default: + break; + } + } + + void OnCreatureCreate(Creature* creature) override + { + BattlegroundScript::OnCreatureCreate(creature); + + if (creature->GetEntry() == SilvershardMines::Creatures::MineCart && battleground->GetStatus() == STATUS_IN_PROGRESS) + creature->AI()->Talk(SilvershardMines::CreatureTexts::MineCart::Spawned); + } + + void HandleProgressEvent(GameObject const* controlZone, Team team, ChatMsg msgType = CHAT_MSG_ADDON, uint32 broadcastTextId = 0, uint32 visualSpellId = 0) const + { + if (!controlZone) + return; + + Creature* mineCart = Object::ToCreature(controlZone->GetOwner()); + if (!mineCart) + return; + + mineCart->RemoveAurasDueToSpell(SilvershardMines::Spells::ControlVisualNeutral); + mineCart->RemoveAurasDueToSpell(SilvershardMines::Spells::ControlVisualHorde); + mineCart->RemoveAurasDueToSpell(SilvershardMines::Spells::ControlVisualAlliance); + mineCart->CastSpell(mineCart, visualSpellId, true); + UpdateCartWorldStates(controlZone); + + if (team == TEAM_OTHER) + return; + + battleground->SendBroadcastText(broadcastTextId, msgType, controlZone); + mineCart->AI()->DoAction(SilvershardMines::Actions::MineCartControlChanged); + + for (ObjectGuid const& guid : *controlZone->GetInsidePlayers()) + if (Player* player = ObjectAccessor::FindPlayer(guid)) + if (player->GetBGTeam() == team) + battleground->UpdatePvpStat(player, SilvershardMines::PvpStats::CartsCaptured, 1); + } + + void SpawnSouthernMineCart() const + { + if (TempSummon* creature = battlegroundMap->SummonCreature(SilvershardMines::Creatures::MineCart, SilvershardMines::SpawnPositions::MineCartSouth)) + { + creature->GetMotionMaster()->MovePath(SilvershardMines::PathIds::South, false); + creature->CastSpell(creature, SilvershardMines::Spells::CartControlCapturePointUnitSouth, true); + } + } + + void SpawnEasternMineCart() const + { + if (TempSummon* creature = battlegroundMap->SummonCreature(SilvershardMines::Creatures::MineCart, SilvershardMines::SpawnPositions::MineCartEast)) + { + creature->GetMotionMaster()->MovePath(SilvershardMines::PathIds::East, false); + creature->CastSpell(creature, SilvershardMines::Spells::CartControlCapturePointUnitEast, true); + } + } + + void SpawnNorthernMineCart() const + { + if (TempSummon* creature = battlegroundMap->SummonCreature(SilvershardMines::Creatures::MineCart, SilvershardMines::SpawnPositions::MineCartNorth)) + { + creature->GetMotionMaster()->MovePath(SilvershardMines::PathIds::North, false); + creature->CastSpell(creature, SilvershardMines::Spells::CartControlCapturePointUnitNorth, true); + } + } + + void UpdateCartWorldStates(GameObject const* controlZone) const + { + if (!controlZone) + return; + + TeamId const controllingTeam = controlZone->GetControllingTeam(); + Creature const* creature = Object::ToCreature(controlZone->GetOwner()); + + if (creature->HasAura(SilvershardMines::Spells::CartControlCapturePointUnitEast)) + { + UpdateWorldState(SilvershardMines::WorldStates::AllianceControlsEastCart, controllingTeam == TEAM_ALLIANCE); + UpdateWorldState(SilvershardMines::WorldStates::HordeControlsEastCart, controllingTeam == TEAM_HORDE); + } + else if (creature->HasAura(SilvershardMines::Spells::CartControlCapturePointUnitNorth)) + { + UpdateWorldState(SilvershardMines::WorldStates::AllianceControlsNorthCart, controllingTeam == TEAM_ALLIANCE); + UpdateWorldState(SilvershardMines::WorldStates::HordeControlsNorthCart, controllingTeam == TEAM_HORDE); + } + else if (creature->HasAura(SilvershardMines::Spells::CartControlCapturePointUnitSouth)) + { + UpdateWorldState(SilvershardMines::WorldStates::AllianceControlsSouthCart, controllingTeam == TEAM_ALLIANCE); + UpdateWorldState(SilvershardMines::WorldStates::HordeControlsSouthCart, controllingTeam == TEAM_HORDE); + } + } + + void SendTeamScores() const + { + UpdateWorldState(SilvershardMines::WorldStates::HordeTeamScore, battleground->GetTeamScore(TEAM_HORDE)); + UpdateWorldState(SilvershardMines::WorldStates::AllianceTeamScore, battleground->GetTeamScore(TEAM_ALLIANCE)); + } + + void OnMineCartCaptured(Creature const* mineCart) + { + if (!mineCart) + return; + + GameObject* controlZone = nullptr; + if (mineCart->HasAura(SilvershardMines::Spells::CartControlCapturePointUnitEast)) + { + controlZone = mineCart->GetGameObject(SilvershardMines::Spells::CartControlCapturePointUnitEast); + battleground->UpdateWorldState(SilvershardMines::WorldStates::AllianceControlsEastCart, 0); + battleground->UpdateWorldState(SilvershardMines::WorldStates::HordeControlsEastCart, 0); + + _scheduler.Schedule(5s, [&](TaskContext const&) + { + SpawnEasternMineCart(); + }); + } + else if (mineCart->HasAura(SilvershardMines::Spells::CartControlCapturePointUnitNorth)) + { + controlZone = mineCart->GetGameObject(SilvershardMines::Spells::CartControlCapturePointUnitNorth); + battleground->UpdateWorldState(SilvershardMines::WorldStates::AllianceControlsNorthCart, 0); + battleground->UpdateWorldState(SilvershardMines::WorldStates::HordeControlsNorthCart, 0); + + _scheduler.Schedule(5s, [&](TaskContext const&) + { + SpawnNorthernMineCart(); + }); + } + else if (mineCart->HasAura(SilvershardMines::Spells::CartControlCapturePointUnitSouth)) + { + controlZone = mineCart->GetGameObject(SilvershardMines::Spells::CartControlCapturePointUnitSouth); + battleground->UpdateWorldState(SilvershardMines::WorldStates::AllianceControlsSouthCart, 0); + battleground->UpdateWorldState(SilvershardMines::WorldStates::HordeControlsSouthCart, 0); + + _scheduler.Schedule(5s, [&](TaskContext const&) + { + SpawnSouthernMineCart(); + }); + } + + if (!controlZone || controlZone->GetControllingTeam() == TEAM_NEUTRAL) + return; + + uint32 const scoreToAdd = std::min<uint32>(SilvershardMines::Score::Max - battleground->GetTeamScore(controlZone->GetControllingTeam()), SilvershardMines::Score::Capture); + if (controlZone->GetControllingTeam() == TEAM_HORDE) + { + mineCart->AI()->Talk(SilvershardMines::CreatureTexts::MineCart::CapturedByHorde); + if (battleground->GetStatus() != STATUS_WAIT_LEAVE) + { + battleground->AddPoint(HORDE, scoreToAdd); + UpdateWorldState(SilvershardMines::WorldStates::HordeCapturedMineCart, 1, true); + CheckWinner(); + } + } + else if (controlZone->GetControllingTeam() == TEAM_ALLIANCE) + { + mineCart->AI()->Talk(SilvershardMines::CreatureTexts::MineCart::CapturedByAlliance); + if (battleground->GetStatus() != STATUS_WAIT_LEAVE) + { + battleground->AddPoint(ALLIANCE, scoreToAdd); + UpdateWorldState(SilvershardMines::WorldStates::AllianceCapturedMineCart, 1, true); + CheckWinner(); + } + } + } + + void OnPlayerCapturedMineCart(Player* player) + { + if (!player) + return; + + if (_capturedMineCartsByPlayer.contains(player->GetGUID())) + _capturedMineCartsByPlayer[player->GetGUID()] = _capturedMineCartsByPlayer[player->GetGUID()] + 1; + else + _capturedMineCartsByPlayer[player->GetGUID()] = 1; + + BattlegroundScore const* score = battleground->GetBattlegroundScore(player); + if (!score) + return; + + if (score->GetDeaths() && _capturedMineCartsByPlayer[player->GetGUID()] >= 5) + player->CastSpell(player, SilvershardMines::Spells::ThreeForThreeComplete, true); + } + + void OnTrackSwitched(Player const* invoker, Creature* trackSwitch) const + { + if (!invoker || !trackSwitch) + return; + + int32 worldStateId = 0; + int32 broadcastTextId = 0; + if (trackSwitch->HasStringId(SilvershardMines::StringIds::TrackSwitchEast)) + { + worldStateId = SilvershardMines::WorldStates::EasternCrossroadsTrackSwitchState; + broadcastTextId = SilvershardMines::BroadcastTexts::EasternCrossroadsChangedTracks; + } + else if (trackSwitch->HasStringId(SilvershardMines::StringIds::TrackSwitchNorth)) + { + worldStateId = SilvershardMines::WorldStates::NorthernCrossroadsTrackSwitchState; + broadcastTextId = SilvershardMines::BroadcastTexts::NorthernCrossroadsChangedTracks; + } + + if (!worldStateId) + return; + + uint32 const currentState = trackSwitch->GetMap()->GetWorldStateValue(worldStateId); + if (currentState == AsUnderlyingType(SilvershardMines::TrackSwitchState::Closed)) + { + trackSwitch->GetMap()->SetWorldStateValue(worldStateId, AsUnderlyingType(SilvershardMines::TrackSwitchState::Open), false); + trackSwitch->RemoveAurasDueToSpell(SilvershardMines::Spells::TrackSwitchVisualClosed); + trackSwitch->CastSpell(trackSwitch, SilvershardMines::Spells::TrackSwitchVisualOpened, true); + } + else if (currentState == AsUnderlyingType(SilvershardMines::TrackSwitchState::Open)) + { + trackSwitch->GetMap()->SetWorldStateValue(worldStateId, AsUnderlyingType(SilvershardMines::TrackSwitchState::Closed), false); + trackSwitch->RemoveAurasDueToSpell(SilvershardMines::Spells::TrackSwitchVisualOpened); + trackSwitch->CastSpell(trackSwitch, SilvershardMines::Spells::TrackSwitchVisualClosed, true); + } + + if (broadcastTextId) + battleground->SendBroadcastText(broadcastTextId, CHAT_MSG_BG_SYSTEM_NEUTRAL, invoker); + } + + bool CheckWinner() const + { + if (battleground->GetStatus() != STATUS_IN_PROGRESS) + return true; + + uint32 const hordeScore = battleground->GetTeamScore(TEAM_HORDE); + uint32 const allianceScore = battleground->GetTeamScore(TEAM_ALLIANCE); + if (hordeScore >= SilvershardMines::Score::Max || allianceScore >= SilvershardMines::Score::Max) + { + SendTeamScores(); + + if (hordeScore >= SilvershardMines::Score::Max && allianceScore >= SilvershardMines::Score::Max) + { + battleground->EndBattleground(TEAM_OTHER); + return true; + } + + if (hordeScore >= SilvershardMines::Score::Max) + { + battleground->EndBattleground(HORDE); + return true; + } + + if (allianceScore >= SilvershardMines::Score::Max) + { + battleground->EndBattleground(ALLIANCE); + return true; + } + } + + return false; + } +private: + TaskScheduler _scheduler; + GuidVector _doors; + std::unordered_map<ObjectGuid, uint16> _capturedMineCartsByPlayer; +}; + +// 60140 - Mine Cart +class npc_bg_silvershard_mines_mine_cart final : public ScriptedAI +{ +public: + explicit npc_bg_silvershard_mines_mine_cart(Creature* creature) : ScriptedAI(creature), _endOfTheLineTeam(TEAM_NEUTRAL), _theLongRidersSpawnTime(GameTime::GetGameTime()) { } + + void UpdateAI(uint32 diff) override + { + _scheduler.Update(diff); + } + + void JustAppeared() override + { + DoCastSelf(SilvershardMines::Spells::ControlVisualNeutral, true); + DoCastSelf(SilvershardMines::Spells::DefendingCartAura, true); + + // give a bit of grace time for The Long Rider achievement (guessed behaviour) + _scheduler.Schedule(2s, [&](TaskContext context) + { + _theLongRidersSpawnTime = GameTime::GetGameTime(); + + // initialize the long riders eligible players + DoForPlayersInControlZone([&](GameObject const* controlZone, Player const* player) + { + if (controlZone->GetControllingTeam() == GetTeamIdForTeam(player->GetBGTeam())) + _theLongRidersPlayers.insert(player->GetGUID()); + }); + + // each second, check if eligible players are still inside + context.Schedule(1s, [&](TaskContext context2) + { + if (GameObject const* controlZone = GetControlZone()) + { + GuidUnorderedSet currentPlayers = *controlZone->GetInsidePlayers(); + GuidSet theLongRidersPlayers; + std::ranges::set_intersection(_theLongRidersPlayers, currentPlayers, std::inserter(theLongRidersPlayers, theLongRidersPlayers.begin())); + _theLongRidersPlayers = std::move(theLongRidersPlayers); + } + + context2.Repeat(); + }); + }); + } + + void WaypointPathEnded(uint32 /*nodeId*/, uint32 pathId) override + { + switch (pathId) + { + case SilvershardMines::PathIds::South: + me->GetMotionMaster()->MovePath(SilvershardMines::PathIds::SouthEnd, false); + break; + case SilvershardMines::PathIds::North: + if (me->GetMap()->GetWorldStateValue(SilvershardMines::WorldStates::NorthernCrossroadsTrackSwitchState) == 1) + me->GetMotionMaster()->MovePath(SilvershardMines::PathIds::NorthWest, false); + else if (me->GetMap()->GetWorldStateValue(SilvershardMines::WorldStates::NorthernCrossroadsTrackSwitchState) == 2) + me->GetMotionMaster()->MovePath(SilvershardMines::PathIds::NorthEast, false); + break; + case SilvershardMines::PathIds::NorthEast: + me->GetMotionMaster()->MovePath(SilvershardMines::PathIds::NorthEastEnd, false); + break; + case SilvershardMines::PathIds::NorthWest: + me->GetMotionMaster()->MovePath(SilvershardMines::PathIds::NorthWestEnd, false); + break; + case SilvershardMines::PathIds::East: + if (me->GetMap()->GetWorldStateValue(SilvershardMines::WorldStates::EasternCrossroadsTrackSwitchState) == 1) + me->GetMotionMaster()->MovePath(SilvershardMines::PathIds::EastNorth, false); + else if (me->GetMap()->GetWorldStateValue(SilvershardMines::WorldStates::EasternCrossroadsTrackSwitchState) == 2) + me->GetMotionMaster()->MovePath(SilvershardMines::PathIds::EastSouth, false); + break; + case SilvershardMines::PathIds::EastSouth: + me->GetMotionMaster()->MovePath(SilvershardMines::PathIds::EastSouthEnd, false); + break; + case SilvershardMines::PathIds::EastNorth: + me->GetMotionMaster()->MovePath(SilvershardMines::PathIds::EastNorthEnd, false); + break; + case SilvershardMines::PathIds::SouthEnd: + case SilvershardMines::PathIds::NorthEastEnd: + case SilvershardMines::PathIds::EastSouthEnd: + case SilvershardMines::PathIds::EastNorthEnd: + case SilvershardMines::PathIds::NorthWestEnd: + HandleCapture(pathId); + break; + default: + break; + } + } + + void DoForPlayersInControlZone(std::function<void(GameObject const*, Player*)> const& fn) const + { + if (GameObject const* controlZone = GetControlZone()) + for (ObjectGuid const& playerGuid : *controlZone->GetInsidePlayers()) + if (Player* player = ObjectAccessor::FindPlayer(playerGuid)) + fn(controlZone, player); + } + + void HandleCapture(uint32 pathId) const + { + if (uint32 const mineCartCourierSpell = GetMineCartCourierSpell(pathId)) + { + DoForPlayersInControlZone([&](GameObject const* controlZone, Player* player) + { + if (GetTeamIdForTeam(player->GetBGTeam()) == controlZone->GetControllingTeam()) + { + player->CastSpell(player, mineCartCourierSpell, true); + if (controlZone->GetControllingTeam() == _endOfTheLineTeam) + player->CastSpell(player, SilvershardMines::Spells::EndOfTheLineAchievementCheck, true); + } + }); + } + + if (_endOfTheLineTeam != TEAM_NEUTRAL) + { + DoForPlayersInControlZone([&](GameObject const* controlZone, Player* player) + { + if (GetTeamIdForTeam(player->GetBGTeam()) == controlZone->GetControllingTeam() && controlZone->GetControllingTeam() == _endOfTheLineTeam) + player->CastSpell(player, SilvershardMines::Spells::EndOfTheLineAchievementCheck, true); + }); + } + + if (uint32 const longRiderSpell = GetTheLongRiderAchievementSpell(pathId)) + { + time_t controlAuraApplyTime = GameTime::GetGameTime(); + + if (Aura const* aura = me->GetAura(SilvershardMines::Spells::ControlVisualHorde)) + controlAuraApplyTime = aura->GetApplyTime(); + else if (Aura const* aura = me->GetAura(SilvershardMines::Spells::ControlVisualAlliance)) + controlAuraApplyTime = aura->GetApplyTime(); + + if (controlAuraApplyTime <= _theLongRidersSpawnTime) + for (ObjectGuid const& playerGuid : _theLongRidersPlayers) + if (Player* player = ObjectAccessor::FindPlayer(playerGuid)) + player->CastSpell(player, longRiderSpell, true); + } + + DoForPlayersInControlZone([&](GameObject const* controlZone, Player* player) + { + if (GetTeamIdForTeam(player->GetBGTeam()) != controlZone->GetControllingTeam()) + return; + + if (ZoneScript* zs = me->GetZoneScript()) + zs->DoAction(SilvershardMines::Actions::MineCartCapturedPlayer, me, player); + }); + + me->CastSpell(me, SilvershardMines::Spells::CartCap, true); + } + + static uint32 GetMineCartCourierSpell(uint32 pathId) + { + switch (pathId) + { + case SilvershardMines::PathIds::SouthEnd: + return SilvershardMines::Spells::MineCartCourierSouth; + case SilvershardMines::PathIds::NorthEastEnd: + return SilvershardMines::Spells::MineCartCourierNorthEast; + case SilvershardMines::PathIds::EastSouthEnd: + return SilvershardMines::Spells::MineCartCourierEastSouth; + case SilvershardMines::PathIds::EastNorthEnd: + return SilvershardMines::Spells::MineCartCourierEastNorth; + case SilvershardMines::PathIds::NorthWestEnd: + return SilvershardMines::Spells::MineCartCourierNorthWest; + default: + return 0; + } + } + + uint32 GetTheLongRiderAchievementSpell(uint32 pathId) const + { + TeamId controllingTeam = TEAM_NEUTRAL; + if (GameObject const* controlZone = GetControlZone()) + controllingTeam = controlZone->GetControllingTeam(); + + if (controllingTeam == TEAM_NEUTRAL) + return 0; + + switch (pathId) + { + case SilvershardMines::PathIds::SouthEnd: + return controllingTeam == TEAM_ALLIANCE ? SilvershardMines::Spells::LongRiderAchievementSouthAlliance : SilvershardMines::Spells::LongRiderAchievementSouthHorde; + case SilvershardMines::PathIds::EastSouthEnd: + case SilvershardMines::PathIds::EastNorthEnd: + return controllingTeam == TEAM_ALLIANCE ? SilvershardMines::Spells::LongRiderAchievementEastAlliance : SilvershardMines::Spells::LongRiderAchievementEastHorde; + case SilvershardMines::PathIds::NorthWestEnd: + case SilvershardMines::PathIds::NorthEastEnd: + return controllingTeam == TEAM_ALLIANCE ? SilvershardMines::Spells::LongRiderAchievementNorthAlliance : SilvershardMines::Spells::LongRiderAchievementNorthHorde; + default: + return 0; + } + } + + void DoAction(int32 actionId) override + { + if (actionId != SilvershardMines::Actions::MineCartControlChanged) + return; + + if (me->FindNearestGameObjectWithOptions(20.0f, { .StringId = SilvershardMines::StringIds::MineDepot })) + if (GameObject const* controlZone = GetControlZone()) + _endOfTheLineTeam = controlZone->GetControllingTeam(); + } + + GameObject* GetControlZone() const + { + if (me->HasAura(SilvershardMines::Spells::CartControlCapturePointUnitEast)) + return me->GetGameObject(SilvershardMines::Spells::CartControlCapturePointUnitEast); + + if (me->HasAura(SilvershardMines::Spells::CartControlCapturePointUnitNorth)) + return me->GetGameObject(SilvershardMines::Spells::CartControlCapturePointUnitNorth); + + if (me->HasAura(SilvershardMines::Spells::CartControlCapturePointUnitSouth)) + return me->GetGameObject(SilvershardMines::Spells::CartControlCapturePointUnitSouth); + + return nullptr; + } + +private: + TaskScheduler _scheduler; + TeamId _endOfTheLineTeam; + GuidSet _theLongRidersPlayers; + time_t _theLongRidersSpawnTime; +}; + +// 115904 - Cart Cap +class spell_bg_silvershard_mines_cart_cap final : public SpellScript +{ + void HandleScript(SpellEffIndex /*effIndex*/) const + { + Creature* hitCreature = GetHitCreature(); + if (!hitCreature) + return; + + if (ZoneScript* zoneScript = hitCreature->GetZoneScript()) + zoneScript->DoAction(SilvershardMines::Actions::MineCartCaptured, hitCreature, hitCreature); + + if (GameObject* depot = hitCreature->FindNearestGameObjectWithOptions(15.0f, { .StringId = SilvershardMines::StringIds::MineDepot })) + depot->ActivateObject(GameObjectActions::Open, 0, hitCreature); + + hitCreature->DespawnOrUnsummon(); + } + + void Register() override + { + OnEffectHitTarget += SpellEffectFn(spell_bg_silvershard_mines_cart_cap::HandleScript, EFFECT_0, SPELL_EFFECT_SCRIPT_EFFECT); + } +}; + +// 124491 - capturing +class spell_bg_silvershard_mines_capturing final : public SpellScript +{ + bool Validate(SpellInfo const* /*spellInfo*/) override + { + return ValidateSpellInfo({ SilvershardMines::Spells::Capturing }); + } + + void HandleScript(SpellEffIndex /*effIndex*/) const + { + if (Player* player = GetHitPlayer()) + player->CastSpell(player, SilvershardMines::Spells::Capturing); + } + + void Register() override + { + OnEffectHitTarget += SpellEffectFn(spell_bg_silvershard_mines_capturing::HandleScript, EFFECT_0, SPELL_EFFECT_SCRIPT_EFFECT); + } +}; + +// 97372 - Capturing +class spell_bg_silvershard_mines_capturing_switch_track final : public SpellScript +{ + bool Validate(SpellInfo const* /*spellInfo*/) override + { + return ValidateSpellInfo({ SilvershardMines::Spells::TrackSwitchVisualClosed, SilvershardMines::Spells::TrackSwitchVisualOpened }); + } + + void HandleScript(SpellEffIndex /*effIndex*/) const + { + Creature* hitCreature = GetHitCreature(); + if (!hitCreature) + return; + + if (ZoneScript* zoneScript = hitCreature->GetZoneScript()) + zoneScript->DoAction(SilvershardMines::Actions::TrackChanged, GetCaster(), hitCreature); + } + + void Register() override + { + OnEffectHitTarget += SpellEffectFn(spell_bg_silvershard_mines_capturing_switch_track::HandleScript, EFFECT_0, SPELL_EFFECT_DUMMY); + } +}; + +// 60379, 60378, 60380 - Mine Cart +class npc_bg_silvershard_mines_mine_cart_cosmetic final : public ScriptedAI +{ +public: + explicit npc_bg_silvershard_mines_mine_cart_cosmetic(Creature* creature) : ScriptedAI(creature) { } + + void WaypointPathEnded(uint32 /*nodeId*/, uint32 pathId) override + { + switch (pathId) + { + case SilvershardMines::PathIds::CosmeticCart1: + case SilvershardMines::PathIds::CosmeticCart2: + case SilvershardMines::PathIds::CosmeticCart3: + me->DespawnOrUnsummon(500ms); + break; + default: + break; + } + } +}; + +void AddSC_battleground_silvershard_mines() +{ + RegisterBattlegroundMapScript(battleground_silvershard_mines, SilvershardMines::Maps::BattlegroundMap); + + RegisterSpellScript(spell_bg_silvershard_mines_cart_cap); + RegisterSpellScript(spell_bg_silvershard_mines_capturing); + RegisterSpellScript(spell_bg_silvershard_mines_capturing_switch_track); + RegisterCreatureAI(npc_bg_silvershard_mines_mine_cart); + RegisterCreatureAI(npc_bg_silvershard_mines_mine_cart_cosmetic); +} diff --git a/src/server/scripts/Battlegrounds/battlegrounds_script_loader.cpp b/src/server/scripts/Battlegrounds/battlegrounds_script_loader.cpp index de4ac895142..0cd020cf041 100644 --- a/src/server/scripts/Battlegrounds/battlegrounds_script_loader.cpp +++ b/src/server/scripts/Battlegrounds/battlegrounds_script_loader.cpp @@ -55,6 +55,8 @@ void AddSC_battleground_battle_for_gilneas(); void AddSC_battleground_seething_shore(); +void AddSC_battleground_silvershard_mines(); + // The name of this function should match: // void Add${NameOfDirectory}Scripts() void AddBattlegroundsScripts() @@ -96,4 +98,6 @@ void AddBattlegroundsScripts() AddSC_battleground_battle_for_gilneas(); AddSC_battleground_seething_shore(); + + AddSC_battleground_silvershard_mines(); } diff --git a/src/server/scripts/Spells/spell_generic.cpp b/src/server/scripts/Spells/spell_generic.cpp index bcd57762c3d..851836d472b 100644 --- a/src/server/scripts/Spells/spell_generic.cpp +++ b/src/server/scripts/Spells/spell_generic.cpp @@ -5379,6 +5379,78 @@ private: uint64 _health; }; +// 128648 - Defending Cart Aura +class spell_bg_defending_cart_aura final : public SpellScript +{ + void FilterTargets(std::list<WorldObject*>& targets) const + { + if (targets.empty()) + return; + + if (GameObject const* controlZone = GetControlZone()) + { + targets.remove_if([&](WorldObject* obj) + { + if (Player const* player = obj->ToPlayer()) + return GetTeamIdForTeam(player->GetBGTeam()) != controlZone->GetControllingTeam(); + + return true; + }); + } + } + + GameObject const* GetControlZone() const + { + if (Unit const* caster = GetCaster()) + { + Unit::AuraEffectList const& auraEffects = caster->GetAuraEffectsByType(SPELL_AURA_ACT_AS_CONTROL_ZONE); + for (AuraEffect const* auraEffect : auraEffects) + if (GameObject const* gameobject = caster->GetGameObject(auraEffect->GetSpellInfo()->Id)) + return gameobject; + } + + return nullptr; + } + + void Register() override + { + OnObjectAreaTargetSelect += SpellObjectAreaTargetSelectFn(spell_bg_defending_cart_aura::FilterTargets, EFFECT_0, TARGET_UNIT_SRC_AREA_ALLY); + } +}; + +// 128648 - Defending Cart Aura +class spell_bg_defending_cart_aura_AuraScript final : public AuraScript +{ + void OnPeriodic(AuraEffect const* /*aurEff*/) const + { + Unit const* caster = GetCaster(); + if (!caster) + return; + + if (GameObject const* controlZone = GetControlZone()) + if (!controlZone->GetInsidePlayers()->contains(GetTarget()->GetGUID())) + GetTarget()->RemoveAurasDueToSpell(GetSpellInfo()->Id, caster->GetGUID()); + } + + GameObject const* GetControlZone() const + { + if (Unit const* caster = GetCaster()) + { + Unit::AuraEffectList const& auraEffects = caster->GetAuraEffectsByType(SPELL_AURA_ACT_AS_CONTROL_ZONE); + for (AuraEffect const* auraEffect : auraEffects) + if (GameObject const* gameobject = caster->GetGameObject(auraEffect->GetSpellInfo()->Id)) + return gameobject; + } + + return nullptr; + } + + void Register() override + { + OnEffectPeriodic += AuraEffectPeriodicFn(spell_bg_defending_cart_aura_AuraScript::OnPeriodic, EFFECT_0, SPELL_AURA_PERIODIC_DUMMY); + } +}; + void AddSC_generic_spell_scripts() { RegisterSpellScript(spell_gen_absorb0_hitlimit1); @@ -5559,4 +5631,5 @@ void AddSC_generic_spell_scripts() RegisterSpellScriptWithArgs(spell_gen_set_health, "spell_gen_set_health_1", 1); RegisterSpellScriptWithArgs(spell_gen_set_health, "spell_gen_set_health_100", 100); RegisterSpellScriptWithArgs(spell_gen_set_health, "spell_gen_set_health_500", 500); + RegisterSpellAndAuraScriptPair(spell_bg_defending_cart_aura, spell_bg_defending_cart_aura_AuraScript); } |