fix(DB/SAI): 'The Raven Stones' Cenarion Sparrowhawk will guide players (#22966)

Co-authored-by: dr-j <dr-j@users.noreply.github.com>
Co-authored-by: Gultask <sagemochi@hotmail.com>

1 files changed, 98 insertions, 0 deletions

diff --git a/data/sql/updates/pending_db_world/rev_1758216295011879710.sql b/data/sql/updates/pending_db_world/rev_1758216295011879710.sql
new file mode 100644
index 0000000000..bc3f2a4b74
--- /dev/null
+++ b/data/sql/updates/pending_db_world/rev_1758216295011879710.sql
@@ -0,0 +1,98 @@
+--
+UPDATE `spell_dbc` SET
+    `Attributes`=384,
+    `CastingTimeIndex`=1,
+    `DurationIndex`=3,
+    `RangeIndex`=7,
+    `EquippedItemClass`=-1,
+    `SchoolMask`=1,
+    `Effect_1`=76,
+    `ImplicitTargetA_1`=18,
+    `EffectMiscValue_1`=185541
+WHERE `Id`=39797;
+
+DELETE FROM `gameobject` WHERE `id`=185541;
+
+UPDATE `creature_template` SET `AIName`='SmartAI', `unit_flags`=768 WHERE  `entry`=22972;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=22972 AND `source_type`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2297200,2297201,2297202) AND `source_type`=9;
+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`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(22972, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 0, 80, 2297200, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - On Just Summoned - Action list'),
+(22972, 0, 1, 0, 54, 0, 100, 0, 0, 0, 0, 0, 0, 80, 2297201, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - On Just Summoned - Action list'),
+(2297200, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Say text'),
+(2297200, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 89, 15, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Random Move'),
+(2297200, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Say text'),
+(2297200, 9, 3, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Say text'),
+(2297200, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 30, 30, 90, 0, 'Cenarion Sparrowhawk - Action list - Move Offset'),
+(2297200, 9, 5, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Despawn'),
+(2297201, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Say text'),
+(2297201, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 69, 1, 0, 0, 0, 0, 0, 19, 22986, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Random Move'),
+(2297201, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Say text'),
+(22972, 0, 2, 0, 34, 0, 100, 0, 8, 1, 0, 0, 0, 80, 2297202, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - On Movement Inform - Action list'),
+(2297202, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Say text'),
+(2297202, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 11, 39797, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Cast Summon Raven Stone'),
+(2297202, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 19, 22986, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Despawn'),
+(2297202, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 114, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 30, 30, 90, 0, 'Cenarion Sparrowhawk - Action list - Move Offset'),
+(2297202, 9, 4, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Sparrowhawk - Action list - Despawn');
+
+DELETE FROM `creature_text` WHERE `CreatureID`=22972;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(22972, 0, 0, "%s looks at you for a moment, then motions for you to follow.", 16, 0, 100, 0, 0, 0, 20689, 0, 'Cenarion Sparrowhawk'),
+(22972, 1, 0, '%s surveys the ground for buried raven stones.', 16, 0, 100, 0, 0, 0, 20675, 0, 'Cenarion Sparrowhawk'),
+(22972, 2, 0, '%s locates a buried raven stone.', 16, 0, 100, 0, 0, 0, 20676, 0, 'Cenarion Sparrowhawk'),
+(22972, 3, 0, "%s doesn't seem to have had any luck finding raven stones nearby.", 16, 0, 100, 0, 0, 0, 21065, 0, 'Cenarion Sparrowhawk');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22  AND `SourceEntry`=22972 AND `SourceId`=0;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(22, 1, 22972, 0, 0, 29, 1, 22986, 40, 0, 1, 0, 0, '', 'Only run SAI if No Invis Rune Stone within 40 yards'),
+(22, 2, 22972, 0, 0, 29, 1, 22986, 40, 0, 0, 0, 0, '', 'Only run SAI if Invis Rune Stone within 40 yards');
+
+SET @CGUID := 132442;
+-- Replace ALL with sniffed spawns
+DELETE FROM `creature` WHERE `id1`=22986;
+INSERT INTO `creature` (`guid`, `id1`, `id2`, `id3`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES
+(@CGUID+0 , 22986, 0, 0, 530, 3519, 3978, 1, 1, 0, -4180.95, 3124.89, 321.461, 6.14356, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+1 , 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4116.41, 3212.79, 299.878, 5.55015, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+2 , 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4088.1, 3247.53, 298.661, 0.191986, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+3 , 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4189.13, 3257.78, 292.119, 4.34587, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+4 , 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4056.92, 3349.51, 285.699, 3.80482, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+5 , 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4085.99, 3318.13, 288.276, 6.21337, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+6 , 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4135.11, 3297.11, 291.408, 5.34071, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+7 , 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4195.95, 3307.84, 284.269, 1.65806, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+8 , 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4145.48, 3366.98, 286.727, 2.46091, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+9 , 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4114.75, 3445.96, 291.581, 2.32129, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+10, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4045.76, 3442.87, 277.701, 0.872665, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+11, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4059.89, 3511.65, 284.039, 2.25147, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+12, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4108.45, 3544.02, 296.909, 2.56563, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+13, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4035.31, 3604.09, 289.025, 2.35619, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+14, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4047.76, 3670.26, 306.392, 2.87979, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+15, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -3944.93, 3664.09, 287.99, 1.78024, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+16, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -4015.38, 3703.51, 296.596, 2.3911, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+17, 22986, 0, 0, 530, 3519, 3974, 1, 1, 0, -3904.37, 3726.72, 295.336, 2.37365, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+18, 22986, 0, 0, 530, 3519, 3974, 1, 1, 0, -3928.23, 3804, 296.871, 4.31096, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+19, 22986, 0, 0, 530, 3519, 3974, 1, 1, 0, -3868.97, 3813.03, 293.218, 2.60054, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+20, 22986, 0, 0, 530, 3519, 3974, 1, 1, 0, -3833.35, 3733.27, 285.779, 4.57276, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+21, 22986, 0, 0, 530, 3519, 3974, 1, 1, 0, -3758.84, 3732.39, 276.927, 0.575959, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+22, 22986, 0, 0, 530, 3519, 3974, 1, 1, 0, -3709.53, 3744.04, 277.156, 5.09636, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+23, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -3687.76, 3677.07, 276.01, 4.31096, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+24, 22986, 0, 0, 530, 3519, 3680, 1, 1, 0, -3591.33, 3724.59, 286.079, 6.26573, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+25, 22986, 0, 0, 530, 3519, 3680, 1, 1, 0, -3585.6, 3606.65, 283.146, 4.7473, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+26, 22986, 0, 0, 530, 3519, 3680, 1, 1, 0, -3466.94, 3487.49, 286.668, 3.24631, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+27, 22986, 0, 0, 530, 3519, 3973, 1, 1, 0, -3518.43, 3586.55, 278.603, 0.488692, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+28, 22986, 0, 0, 530, 3519, 3978, 1, 1, 0, -4066.59, 3066.77, 318.167, 5.46288, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+29, 22986, 0, 0, 530, 3519, 3978, 1, 1, 0, -4002.09, 3002.9, 361.925, 2.21657, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+30, 22986, 0, 0, 530, 3519, 3977, 1, 1, 0, -3919.28, 3054.06, 359.032, 3.14159, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+31, 22986, 0, 0, 530, 3519, 3977, 1, 1, 0, -3868.7, 3107.64, 333.52, 4.39823, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+32, 22986, 0, 0, 530, 3519, 3977, 1, 1, 0, -3897.7, 3145.86, 326.602, 1.36136, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+33, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -3889.21, 3200.03, 313.549, 4.85202, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+34, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -3862.66, 3234.81, 307.935, 4.32842, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+35, 22986, 0, 0, 530, 3519, 3976, 1, 1, 0, -3777.56, 3341.35, 276.612, 2.56563, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+36, 22986, 0, 0, 530, 3519, 3975, 1, 1, 0, -3651.93, 3446.62, 279.142, 3.42085, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+37, 22986, 0, 0, 530, 3519, 3975, 1, 1, 0, -3690.24, 3390.89, 282.282, 1.23918, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+38, 22986, 0, 0, 530, 3519, 3975, 1, 1, 0, -3621.2, 3498.29, 277.993, 4.50295, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+39, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -3623.24, 3372.64, 294.953, 2.33874, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+40, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -3651.9, 3308.47, 285.5, 4.24115, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+41, 22986, 0, 0, 530, 3519, 3679, 1, 1, 0, -3716.68, 3343.7, 287.338, 3.89208, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+42, 22986, 0, 0, 530, 3519, 3680, 1, 1, 0, -3642.5, 3189.22, 314.679, 5.07891, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+43, 22986, 0, 0, 530, 3519, 3976, 1, 1, 0, -4015.76, 3328.22, 285.747, 3.82227, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745),
+(@CGUID+44, 22986, 0, 0, 530, 3519, 3978, 1, 1, 0, -4259.69, 2987.85, 312.869, 2.05949, 120, 0, 0, 1604, 852, 0, 0, 0, 0, '', 45745);