Onyxian Whelpling Emotes

gistfile1.sql

-- link breath and self-stun
DELETE FROM spell_linked_spell WHERE spell_trigger = -69006;
INSERT INTO spell_linked_spell (spell_trigger, spell_effect, type, comment) VALUES (-69006, 69004, 0, 'Onyxian Whelpling - Emote');
-- periodic trigger-aura to creature
DELETE FROM creature_template_addon WHERE entry = 36607;
INSERT INTO creature_template_addon (entry, auras) VALUES (36607, '69005');
-- emote text
DELETE FROM creature_text WHERE entry = 36607;
INSERT INTO creature_text (entry, text, type, probability, comment) VALUES (36607, '%s takes a deep breath!', 16, 100, 'Onyxian Whelpling - Deep Breath');
-- create AI
DELETE FROM smart_scripts WHERE entryorguid = 36607 AND source_type = 0;
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, 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) VALUES 
(36607, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 'Onyxian Whelpling - on summon follow owner'),
(36607, 0, 1, 0, 8, 0, 100, 0, 69006, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Onyxian Whelpling - on stun self do emote');
-- link AI
UPDATE creature_template SET AIName = 'SmartAI' WHERE entry = 36607;