RG Live WotLK 3.3.5a

Das Pet sollte alle 5min tief Luft holen und ne Rauchwolke abgeben ;)

-- 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;

und eigentlich sollte es auf Kopfhöhe fliegen, aber da hab ich keine Ahnung ob das creatureTemplate schon HoverHeight unterstützt^^