[3.3.5][6.x] DB/SAI: NPC SAI - Howling Fjord

[Kodekc]

Missing NPC SAI
Entry:
http://www.wowhead.com/npc=23658
http://www.wowhead.com/npc=24250
http://www.wowhead.com/npc=23691
http://www.wowhead.com/npc=23656
http://www.wowhead.com/npc=24872
http://www.wowhead.com/npc=26663
http://www.wowhead.com/npc=24673
http://www.wowhead.com/npc=24677
http://www.wowhead.com/npc=23739
http://www.wowhead.com/npc=23840
http://www.wowhead.com/npc=24540
http://www.wowhead.com/npc=24461
http://www.wowhead.com/npc=23643
http://www.wowhead.com/npc=24026
http://www.wowhead.com/npc=23740
http://www.wowhead.com/npc=23989
http://www.wowhead.com/npc=23990
http://www.wowhead.com/npc=24013
http://www.wowhead.com/npc=23992
http://www.wowhead.com/npc=24014
http://www.wowhead.com/npc=24018
http://www.wowhead.com/npc=24019
http://www.wowhead.com/npc=24316
http://www.wowhead.com/npc=23796
http://www.wowhead.com/npc=24212
http://www.wowhead.com/npc=23655
http://www.wowhead.com/npc=23946
http://www.wowhead.com/npc=23866
http://www.wowhead.com/npc=23794
http://www.wowhead.com/npc=23962
http://www.wowhead.com/npc=23964
http://www.wowhead.com/npc=23779
http://www.wowhead.com/npc=26825
http://www.wowhead.com/npc=26823

Database TDB 335.60

[Treeston]

We'll need more information than that. What do you feel is missing?

For the record:

mysql> select entry,name,ainame,scriptname from creature_template where ainame like "smartai" and entry in (23658,24250,23691,23656,24872,26663,24673,24677,23739,23840,24530,24461,23643,24026,23740,23989,23990,24013,23992,24014,24018,24019,24316,23796,24212,23655,23946,23866,23794,23962,23964,23779,26825,26823);
+-------+---------------------------+---------+------------+
| entry | name                      | ainame  | scriptname |
+-------+---------------------------+---------+------------+
| 23656 | Dragonflayer Rune-Seer    | SmartAI |            |
| 23658 | Dragonflayer Death Weaver | SmartAI |            |
| 23866 | North Fleet Sailor        | SmartAI |            |
| 23989 | Gjalerbron Sleep-Watcher  | SmartAI |            |
| 23990 | Gjalerbron Rune-Caster    | SmartAI |            |
| 24013 | Deathless Watcher         | SmartAI |            |
| 24014 | Necrolord                 | SmartAI |            |
| 24018 | Necro Overlord Mezhen     | SmartAI |            |
| 24530 | Amani Elder Lynx          | SmartAI |            |
+-------+---------------------------+---------+------------+
9 rows in set (0.00 sec)

[Kodekc]

Open the table smart_scripts. No records for these creatures

[Treeston]

The only one for which that is true is 23656 (Dragonflayer Rune-Seer) [rev 1050b68]

`mysql> select * from smart_scripts where entryorguid in (23656,23658,23866,23989,23990,24013,24014,24018,24530);
+-------------+-------------+----+------+------------+------------------+--------------+-------------+--------------+--------------+--------------+--------------+-------------+---------------+---------------+---------------+---------------+---------------+---------------+-------------+---------------+---------------+---------------+----------+----------+----------+----------+---------------------------------------------------------------------------------------------+
| entryorguid | source_type | id | link | event_type | event_phase_mask | event_chance | event_flags | event_param1 | event_param2 | event_param3 | event_param4 | action_type | action_param1 | action_param2 | action_param3 | action_param4 | action_param5 | action_param6 | target_type | target_param1 | target_param2 | target_param3 | target_x | target_y | target_z | target_o | comment                                                                                     |
+-------------+-------------+----+------+------------+------------------+--------------+-------------+--------------+--------------+--------------+--------------+-------------+---------------+---------------+---------------+---------------+---------------+---------------+-------------+---------------+---------------+---------------+----------+----------+----------+----------+---------------------------------------------------------------------------------------------+
|       23658 |           0 |  0 |    0 |          1 |                0 |          100 |           0 |         1000 |         1000 |         1000 |         1000 |          11 |         43159 |             0 |             0 |             0 |             0 |             0 |          19 |         24158 |            30 |             0 |        0 |        0 |        0 |        0 | Dragonflayer Death Weaver - Out of Combat - Cast 'Soul Infusion'                            |
|       23866 |           0 |  0 |    0 |          1 |                0 |          100 |           0 |        10000 |        10000 |        10000 |        10000 |          49 |             0 |             0 |             0 |             0 |             0 |             0 |          19 |         23865 |            10 |             0 |        0 |        0 |        0 |        0 | North Fleet Sailor - Out of Combat - Start Attacking                                        |
|       23989 |           0 |  0 |    0 |          4 |                0 |           50 |           1 |            0 |            0 |            0 |            0 |           1 |             0 |             0 |             0 |             0 |             0 |             0 |           1 |             0 |             0 |             0 |        0 |        0 |        0 |        0 | Gjalerbron Sleep-Watcher - On Agro - Say                                                    |
|       23990 |           0 |  0 |    0 |          4 |                0 |           50 |           1 |            0 |            0 |            0 |            0 |           1 |             0 |             0 |             0 |             0 |             0 |             0 |           1 |             0 |             0 |             0 |        0 |        0 |        0 |        0 | Gjalerbron Rune-Caster - On Agro - Say                                                      |
|       24013 |           0 |  0 |    0 |         25 |                0 |          100 |           0 |            0 |            0 |            0 |            0 |          90 |             9 |             0 |             0 |             0 |             0 |             0 |           1 |             0 |             0 |             0 |        0 |        0 |        0 |        0 | Deathless Watcher - On Reset - Set Flag Standstate Submerged                                |
|       24013 |           0 |  1 |    0 |          4 |                0 |          100 |           0 |            0 |            0 |            0 |            0 |          91 |             9 |             0 |             0 |             0 |             0 |             0 |           1 |             0 |             0 |             0 |        0 |        0 |        0 |        0 | Deathless Watcher - On Aggro - Remove Flag Standstate Submerged                             |
|       24014 |           0 |  0 |    0 |          4 |                0 |           50 |           1 |            0 |            0 |            0 |            0 |           1 |             0 |             0 |             0 |             0 |             0 |             0 |           1 |             0 |             0 |             0 |        0 |        0 |        0 |        0 | Necrolord - On Agro - Say                                                                   |
|       24018 |           0 |  0 |    0 |          1 |                0 |          100 |           1 |         1000 |         1000 |         1000 |         1000 |          11 |         43151 |             2 |             0 |             0 |             0 |             0 |          11 |         24021 |            30 |             0 |        0 |        0 |        0 |        0 | Necro Overlord Mezhen - Out of Combat - Cast 'Necrolord: Purple Beam' (Phase 1) (No Repeat) |
|       24530 |           0 |  0 |    0 |          2 |                0 |          100 |           2 |            0 |           30 |        90000 |        90000 |          11 |         34970 |             0 |             0 |             0 |             0 |             0 |           1 |             0 |             0 |             0 |        0 |        0 |        0 |        0 | Amani Elder Lynx - Between 0-30% Health - Cast 'Frenzy'                                     |
|       24530 |           0 |  1 |    0 |          2 |                0 |          100 |           2 |            0 |           30 |        90000 |        90000 |           1 |             0 |             0 |             0 |             0 |             0 |             0 |           1 |             0 |             0 |             0 |        0 |        0 |        0 |        0 | Amani Elder Lynx - Between 0-30% Health - Say Line 0                                        |
|       24530 |           0 |  2 |    0 |          0 |                0 |          100 |           2 |        12000 |        12000 |        20000 |        25000 |          11 |         43357 |             0 |             0 |             0 |             0 |             0 |           2 |             0 |             0 |             0 |        0 |        0 |        0 |        0 | Amani Elder Lynx - In Combat - Cast 'Feral Swipe'                                           |
|       24530 |           0 |  3 |    0 |          0 |                0 |          100 |           2 |         1500 |         1500 |         9000 |        13000 |          11 |         43356 |             0 |             0 |             0 |             0 |             0 |           2 |             0 |             0 |             0 |        0 |        0 |        0 |        0 | Amani Elder Lynx - In Combat - Cast 'Pounce'                                                |
+-------------+-------------+----+------+------------+------------------+--------------+-------------+--------------+--------------+--------------+--------------+-------------+---------------+---------------+---------------+---------------+---------------+---------------+-------------+---------------+---------------+---------------+----------+----------+----------+----------+---------------------------------------------------------------------------------------------+
12 rows in set (0.01 sec)

[Kodekc]

Look at wowhead, what sort of abilities on creatures, and what in the table

[Kodekc]

SELECT * FROM smart_scripts WHERE entryorguid IN (23658, 24250, 23691, 23656, 24872, 26663, 24673, 24677, 23739, 23840, 24540, 24461, 23643, 24026, 23740, 23989, 23990, 24013, 23992, 24014, 24018, 24019, 24316, 23796, 24212, 23655, 23946, 23866, 23794, 23866, 23794, 23962, 23964, 23779, 26825, 26823);

36 NPC in the query. 24530 is not true. Changed to 24540

[dr-j]

wowhead is not always a reliable source for abillities used by creatures as it is known there have been incorrect spells listed as abilities on wowhead.

Some npcs have extra abilities listed which actually are not used by that npc or in some cases according to wowhead npc has no abilities which is not the case.

[Rushor]

so @Kodekc:which npcs need an sai?

[Kodekc]

Everyone needs SAI, they are just dummies for whipping

[Rushor]

kay then, @Kodekc: do you already scripted them? :)

[Kodekc]

@Rushor No, I didn't do. Maybe later

[CraftedRO]

Only those ones are missing from the above list , the others does have SAI probably only need few updates just , @offl can you check and correct timers :D ?

-- Dragonflayer Rune-Seer
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 23656;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 23656);
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
(23656, 0, 0, 0, 0, 0, 100, 0, 2000, 12000, 13000, 23000, 0, 11, 48262, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Dragonflayer Rune-Seer - In Combat - Cast 'Rune of Asvior'"),
(23656, 0, 1, 0, 14, 0, 100, 0, 1000, 2000, 15000, 18000, 0, 11, 48264, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, "Dragonflayer Rune-Seer - Friendly Missing Health - Cast 'Rune of Ubbi'");

-- Blood Shade
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 24872;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 24872);
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
(24872, 0, 0, 0, 0, 0, 100, 0, 2000, 5000, 14000, 18000, 0, 11, 49843, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Blood Shade - In Combat - Cast 'Vexed Blood of the Ancestors'");

-- Winterskorn Hunter
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 26663;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 26663);
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
(26663, 0, 0, 0, 0, 0, 100, 0, 4000, 6000, 8000, 12000, 0, 11, 18651, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Winterskorn Hunter - In Combat - Cast 'Multi-Shot'"),
(26663, 0, 1, 0, 0, 0, 100, 0, 6000, 8000, 12000, 19000, 0, 11, 36828, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Winterskorn Hunter - In Combat - Cast 'Rapid Fire'"),
(26663, 0, 2, 0, 0, 0, 100, 0, 2000, 3000, 2300, 3900, 0, 11, 15547, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Winterskorn Hunter - In Combat - Cast 'Shoot'");

-- Valgarde Defender
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 23739;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 23739);
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
(23739, 0, 0, 0, 0, 0, 100, 0, 3000, 10000, 9000, 15000, 0, 11, 12170, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Valgarde Defender - In Combat - Cast 'Revenge'"),
(23739, 0, 1, 0, 0, 0, 100, 0, 2000, 3000, 2300, 3900, 0, 11, 42476, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Valgarde Defender - In Combat - Cast 'Shoot'");

-- Westguard Crossbowman npc=23840
-- Seems like this one doesn't have any spells in any database I searched for.

-- Necrotech
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 24540;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 24540);
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
(24540, 0, 0, 0, 0, 0, 100, 0, 3000, 7000, 14000, 20000, 0, 11, 18267, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Necrotech - In Combat - Cast 'Curse of Weakness'"),
(24540, 0, 1, 0, 0, 0, 100, 0, 6000, 8000, 12000, 19000, 0, 11, 17173, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Necrotech - In Combat - Cast 'Drain Life'"),
(24540, 0, 2, 0, 0, 0, 100, 0, 8000, 14000, 13000, 20000, 0, 11, 43871, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Necrotech - In Combat - Cast 'Mind Control'"),
(24540, 0, 3, 0, 0, 0, 100, 0, 2000, 3000, 11000, 16000, 0, 11, 9613, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Necrotech - In Combat - Cast 'Shadow Bolt'");

-- Chillmere Oracle
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 24461;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 24461);
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
(24461, 0, 0, 0, 0, 0, 100, 0, 7000, 10000, 12000, 14000, 0, 11, 11831, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Chillmere Oracle - In Combat - Cast 'Frost Nova'"),
(24461, 0, 1, 0, 0, 0, 100, 0, 15000, 20000, 20000, 25000, 0, 11, 49935, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Chillmere Oracle - In Combat - Cast 'Hex of the Murloc'"),
(24461, 0, 2, 0, 0, 0, 100, 0, 4000, 6000, 8000, 10000, 0, 11, 49906, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Chillmere Oracle - In Combat - Cast 'Ice Lance'");

-- Unstable Mur'ghoul
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 23643;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 23643);
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
(23643, 0, 0, 0, 0, 0, 100, 0, 7000, 10000, 12000, 14000, 0, 11, 49948, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Unstable Mur'ghoul - In Combat - Cast 'Unstable Explosion'");

-- Putrid Wight
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 23992;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 23992);
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
(23992, 0, 0, 0, 0, 0, 100, 0, 7000, 10000, 12000, 14000, 0, 11, 43506, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Putrid Wight - In Combat - Cast 'Plague Blight'"),
(23992, 0, 1, 0, 0, 0, 100, 0, 4000, 7000, 10000, 15000, 0, 11, 8078, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Putrid Wight - In Combat - Cast 'Thunderclap'");

-- Glacion
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 24019;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 24019);
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
(24019, 0, 0, 0, 0, 0, 100, 0, 5000, 10000, 5000, 10000, 0, 11, 43562, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Glacion - In Combat - Cast 'Frost Breath'"),
(24019, 0, 1, 0, 0, 0, 100, 0, 5000, 15000, 5000, 15000, 0, 11, 11264, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Glacion - In Combat - Cast 'Ice Blast'");

-- Iron Rune Binder
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 23796;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 23796);
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
(23796, 0, 0, 0, 0, 0, 100, 0, 5000, 7000, 15000, 20000, 0, 11, 43270, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Iron Rune Binder - In Combat - Cast 'Bind Stone Giant'"),
(23796, 0, 1, 0, 0, 0, 100, 0, 6000, 11000, 19000, 24000, 0, 11, 15039, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Iron Rune Binder - In Combat - Cast 'Flame Shock'"),
(23796, 0, 2, 0, 0, 0, 100, 0, 8000, 14000, 13000, 16000, 0, 11, 48599, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Iron Rune Binder - In Combat - Cast 'Rune of Binding'");

-- Iron Rune Guardian
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 24212;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 24212);
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
(24212, 0, 0, 0, 0, 0, 100, 0, 5000, 7000, 15000, 20000, 0, 11, 49643, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Iron Rune Guardian - In Combat - Cast 'Guardian Rune'"),
(24212, 0, 1, 0, 0, 0, 100, 0, 8000, 14000, 13000, 16000, 0, 11, 49644, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Iron Rune Guardian - In Combat - Cast 'Guardian Strike'");

-- Winterskorn Bonegrinder
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 23655;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 23655);
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
(23655, 0, 0, 0, 0, 0, 100, 0, 7000, 10000, 12000, 14000, 0, 11, 43951, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Winterskorn Bonegrinder - In Combat - Cast 'Bonegrinder'");

-- Captain Olster
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 23962;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 23962);
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
(23962, 0, 0, 0, 0, 0, 100, 0, 6000, 10000, 18000, 20000, 0, 11, 32588, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Captain Olster - In Combat - Cast 'Concussion Blow'"),
(23962, 0, 1, 0, 0, 0, 100, 0, 10000, 10000, 15000, 15000, 0, 11, 27577, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Captain Olster - In Combat - Cast 'Intercept'"),
(23962, 0, 2, 0, 0, 0, 100, 0, 4000, 7000, 7000, 9000, 0, 11, 16856, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Captain Olster - In Combat - Cast 'Mortal Strike'");

-- Vengeance Landing Deathguard
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 23779;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 23779);
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
(23779, 0, 0, 0, 0, 0, 100, 0, 4000, 8000, 12000, 15000, 0, 11, 19643, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Vengeance Landing Deathguard - In Combat - Cast 'Mortal Strike'"),
(23779, 0, 1, 0, 0, 0, 100, 0, 6000, 10000, 18000, 20000, 0, 11, 15618, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Vengeance Landing Deathguard - In Combat - Cast 'Snap Kick'");

-- Howling Wolvar Shaman
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 26825;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 26825);
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
(26825, 0, 0, 0, 0, 0, 100, 0, 2000, 6000, 9000, 12000, 0, 11, 13281, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Howling Wolvar Shaman - In Combat - Cast 'Earth Shock'"),
(26825, 0, 1, 0, 0, 0, 100, 0, 7000, 9000, 18000, 20000, 0, 11, 15786, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Howling Wolvar Shaman - In Combat - Cast 'Earthbind Totem'"),
(26825, 0, 2, 0, 0, 0, 100, 0, 3000, 4000, 7000, 9000, 0, 11, 26098, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Howling Wolvar Shaman - In Combat - Cast 'Lightning Bolt'");

-- Howling Wolvar Trainer
UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 26823;
DELETE FROM `smart_scripts` WHERE (`source_type` = 0 AND `entryorguid` = 26823);
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
(26823, 0, 0, 0, 0, 0, 100, 0, 3000, 7000, 14000, 20000, 0, 11, 31290, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Howling Wolvar Trainer - In Combat - Cast 'Net'"),
(26823, 0, 1, 0, 13, 0, 100, 0, 4000, 8000, 12000, 19000, 0, 11, 12555, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Howling Wolvar Trainer - On Target Casting Spell - Cast 'Pummel'"),
(26823, 0, 2, 0, 0, 0, 100, 0, 8000, 14000, 13000, 20000, 0, 11, 50054, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Howling Wolvar Trainer - In Combat - Cast 'Quick Feet'"),
(26823, 0, 3, 0, 0, 0, 100, 0, 2000, 3000, 11000, 16000, 0, 11, 49453, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, "Howling Wolvar Trainer - In Combat - Cast 'Wolvar Net'");

[offl]

Yep

[github-actions]

c386da6