DB/Mulgore: Some updates to Camp Narache

+ Added Path for Brave Windfeather
+ Added sparring data
+ Adjust combat SAI for Fledgling Brave
+ handle feign death for Fledgling Brave

1 files changed, 116 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_10_20_00_world.sql b/sql/updates/world/master/2024_10_20_00_world.sql
new file mode 100644
index 00000000000..bedd21a143c
--- /dev/null
+++ b/sql/updates/world/master/2024_10_20_00_world.sql
@@ -0,0 +1,116 @@
+-- Creature Addon
+DELETE FROM `creature_addon` WHERE `guid` IN (295421, 295409, 295408, 295406, 295397, 295391, 295393, 295490, 295504, 295523, 295535, 295536, 295553, 295552, 295551, 295572, 295603, 295567, 295580, 295586, 295343, 295594, 295619, 295658, 295653, 295700, 295690, 295718, 295746, 295757, 295723, 295415, 295707, 295710, 295756, 295740, 295743, 295795, 295794, 295806, 295813, 295686, 295372, 295763, 295426, 295540);
+INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(295421, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295409, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295408, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295406, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295397, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295391, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295393, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295490, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295504, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295523, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295535, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295536, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295553, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295552, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295551, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295572, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295603, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295567, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295580, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295586, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295343, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295594, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295619, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295658, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295653, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295700, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295690, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295718, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295746, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295757, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295723, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295415, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295707, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295710, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295756, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295740, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295743, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295795, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295794, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295806, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295813, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295686, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295372, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295763, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295426, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'), -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+(295540, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '69316 29266'); -- Fledgling Brave - 69316 - Immolation, 29266 - Permanent Feign Death
+
+-- Scripts
+DELETE FROM `spell_script_names` WHERE `spell_id` = 29266;
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(29266, 'spell_gen_feign_death_all_flags_uninteractible');
+
+-- Update wander_distance
+UPDATE `creature` SET `wander_distance` = 8, `MovementType` = 1 WHERE `guid` IN (296026, 295992, 295977);
+
+-- Sparring
+DELETE FROM `creature_template_sparring` WHERE `Entry` IN (36942, 36943);
+INSERT INTO `creature_template_sparring` (`Entry`, `NoNPCDamageBelowHealthPct`) VALUES
+(36942, 85),
+(36943, 85);
+
+-- Fledgling Brave smart ai
+SET @ENTRY := 36942;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES
+(@ENTRY, 0, 0, 0, 0, 0, 100, 0, 1000, 3000, 1000, 3000, 0, 11, 81502, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Every 1 - 3 seconds (IC) - Self: Cast spell  81502 on Victim', ''),
+(@ENTRY, 0, 1, 0, 0, 0, 100, 0, 8000, 8000, 8000, 8000, 0, 11, 81500, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Every 8 seconds (IC) - Self: Cast spell  81500 on Self', '');
+
+-- Path for Brave Windfeather
+SET @MOVERGUID := 296017;
+SET @ENTRY := 3209;
+SET @PATHOFFSET := 0;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x0, NULL, 'Brave Windfeather - Cosmetic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -2992.68, -392.806, 48.94047, NULL, 0),
+(@PATH, 1, -2979.69, -376.811, 51.352432, NULL, 0),
+(@PATH, 2, -2966.47, -362.797, 53.963196, NULL, 0),
+(@PATH, 3, -2949.51, -348.207, 56.46379, NULL, 0),
+(@PATH, 4, -2938.28, -335.476, 57.90662, NULL, 0),
+(@PATH, 5, -2932.27, -318.439, 58.546825, NULL, 0),
+(@PATH, 6, -2930.68, -302.472, 58.83542, NULL, 0),
+(@PATH, 7, -2930.8, -289.241, 59.08094, NULL, 0),
+(@PATH, 8, -2931.23, -273.128, 58.9249, NULL, 0),
+(@PATH, 9, -2932.56, -261.01, 58.89294, NULL, 0),
+(@PATH, 10, -2931.39, -252.705, 59.441887, NULL, 0),
+(@PATH, 11, -2934.2969, -247.45508, 59.838745, NULL, 0),
+(@PATH, 12, -2931.3906, -252.70508, 59.446278, NULL, 0),
+(@PATH, 13, -2932.56, -261.01, 58.89294, NULL, 0),
+(@PATH, 14, -2931.23, -273.128, 58.9249, NULL, 0),
+(@PATH, 15, -2930.8, -289.241, 59.08094, NULL, 0),
+(@PATH, 16, -2930.68, -302.472, 58.83542, NULL, 0),
+(@PATH, 17, -2932.27, -318.439, 58.546825, NULL, 0),
+(@PATH, 18, -2938.28, -335.476, 57.90662, NULL, 0),
+(@PATH, 19, -2949.51, -348.207, 56.46379, NULL, 0),
+(@PATH, 20, -2966.47, -362.797, 53.963196, NULL, 0),
+(@PATH, 21, -2979.69, -376.811, 51.352432, NULL, 0),
+(@PATH, 22, -2992.68, -392.806, 48.94047, NULL, 0),
+(@PATH, 23, -2996.55, -412.488, 47.979652, NULL, 0),
+(@PATH, 24, -3000.19, -438.071, 45.826733, NULL, 0),
+(@PATH, 25, -3000.51, -446.528, 45.45365, NULL, 0),
+(@PATH, 26, -3000.19, -438.071, 45.826733, NULL, 0),
+(@PATH, 27, -2996.55, -412.488, 47.979652, NULL, 0);
+
+UPDATE `creature` SET `position_x`=-2992.68, `position_y`=-392.806, `position_z`=48.94047, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);