Bladespear Ogres are not linked to any combat AI

These worked some time ago, beforfe we had Eluna and before SD2 had been pulled into the core. Can't we go back and get the SD2 script form that older version?

Presumably so, but it shouldn't take much to implement it in the creature_ai_scripts table, which it looks like they meant to have done, just forgot.

I've located another NPC (Weegli Blastfuse - Zul'Farrak) who has lost his combat AI, but I'll put him in a new thread because it looks like the instance event he is part of may not be fully scripted.

Find the old scripts and PR to the scripts folder, they will be compiled accordingly automatically. Where are these ogres found btw?

Location of ogres: Bladespire Hold, Blades Edge Mountains.

As far as I can see this has never been handled by SD2, even original SD2 does not have the said mobs implemented :)

Then perhaps it was handled internally? These worked at some point.

Not through SD2 or the core :) Last option is then DB scripts

It's easy, EventAI - creature_ai_scripts ... blah blah blah

Hmm, me thinks me need sleep :rolleyes: ;) :D

xXx
-------------------------------------------------------------------------------------------------------

[B]Bladespire Shaman[/B]: Entry: 19998
[url]http://www.wowhead.com/npc=19998/bladespire-shaman#abilities[/url]
-- enable script
[COLOR="#0000FF"]UPDATE creature_template SET AIName='EventAI' WHERE Entry='19998';[/COLOR]
-- add new script(s)
[COLOR="#0000FF"]DELETE FROM creature_ai_scripts WHERE creature_id = 19998;[/COLOR]
[COLOR="#0000FF"]INSERT INTO creature_ai_scripts (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('1999801', '19998', '1', '0', '100', '1', '500', '800', '600000', '600000', '11', '35240', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Shamen - Cast Bloodmaul Intoxication');[/COLOR]
[COLOR="#0000FF"]INSERT INTO creature_ai_scripts (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('1999802', '19998', '0', '0', '100', '1', '4000', '8000', '30000', '45000', '11', '32062', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Shamen - Cast Fire Nova Totem');[/COLOR]
[COLOR="#0000FF"]INSERT INTO creature_ai_scripts (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('1999804', '19998', '9', '13', '100', '1', '0', '40', '2400', '3800', '11', '26098', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Shamen - Cast Lightning Bolt (Phase 1)');[/COLOR]
[COLOR="#0000FF"]INSERT INTO creature_ai_scripts (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('1999805', '19998', '1', '0', '100', '1', '1000', '1000', '600000', '600000', '11', '12550', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Shamen - Cast Lightning Shield on Aggro');[/COLOR]

[B]Bladespire Cook[/B]: Entry: 20334
[url]http://www.wowhead.com/npc=20334#abilities[/url]
[COLOR="#0000FF"]-- enable script
UPDATE creature_template SET AIName='EventAI' WHERE Entry='20334';[/COLOR]
-- add new script(s)
[COLOR="#0000FF"]DELETE FROM creature_ai_scripts WHERE creature_id = 20334;[/COLOR]
[COLOR="#0000FF"]INSERT INTO creature_ai_scripts (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('2033401', '20334', '1', '0', '100', '1', '500', '800', '600000', '600000', '11', '35240', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Cook - Cast Bloodmaul Intoxication');[/COLOR]
[COLOR="#0000FF"]INSERT INTO creature_ai_scripts (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('2033402', '20334', '0', '0', '100', '1', '2100', '6100', '14100', '20100', '11', '37597', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Cook - Cast Meat Slap');[/COLOR]
[COLOR="#0000FF"]INSERT INTO `mangosOne`.`creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('2033403', '20334', '0', '0', '100', '1', '1000', '5000', '40000', '45000', '11', '37596', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Cook - Cast Tenderize');[/COLOR]

[B]Bladespire Champion: [/B]Entry: 21296
[url]http://www.wowhead.com/npc=21296#abilities[/url]
-- enable script
[COLOR="#0000FF"]UPDATE creature_template SET AIName='EventAI' WHERE Entry='21296';[/COLOR]
-- add new script(s)
[COLOR="#0000FF"]DELETE FROM creature_ai_scripts WHERE creature_id = 21296;[/COLOR]
[COLOR="#0000FF"]INSERT INTO creature_ai_scripts (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('2129601', '21296', '1', '0', '100', '1', '500', '800', '600000', '600000', '11', '35240', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Champion - Cast Bloodmaul Intoxication');[/COLOR]
[COLOR="#0000FF"]INSERT INTO creature_ai_scripts (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('2129602', '21296', '4', '0', '15', '0', '0', '0', '0', '0', '11', '37777', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Champion - Cast Mighty Charge');[/COLOR]
[COLOR="#0000FF"]INSERT INTO creature_ai_scripts (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('2129603', '21296', '9', '0', '100', '1', '0', '8', '16000', '21000', '11', '8078', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Champion - Cast Thunderclap');[/COLOR]

[B]Bladespire Sober Defender[/B]: Entry: 21975
[url]http://www.wowhead.com/npc=21975#abilities[/url]
-- enable script
[COLOR="#0000FF"]UPDATE creature_template SET AIName='EventAI' WHERE Entry='21975';[/COLOR]
-- add new script(s)
[COLOR="#0000FF"]DELETE FROM creature_ai_scripts WHERE creature_id = 21975;[/COLOR]
[COLOR="#0000FF"]INSERT INTO creature_ai_scripts (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('2197501', '21975', '9', '0', '100', '1', '0', '5', '8000', '12000', '11', '15496', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Bladespire Sober Defender - Cast Cleave');[/COLOR]

[B][COLOR="#008000"]All tested and working[/COLOR][/B] :D

[B][SIZE=3][COLOR="#008000"]Pull Request has been made that includes these fixes:[/COLOR][/SIZE][/B]

[url]https://github.com/mangosone/database/pull/9[/url]

Hmm, I'd better check to see if this needs to be applied to Two!

All okay on Two :)