[Completed][Complete] Some missing auras

[CODE]-- SAI for Beryl Hound
SET @ENTRY := 25355;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,50637,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Beryl Hound - On spawn - Cast Mana Break on self’);

– SAI for Tundra Penguin
SET @ENTRY := 28440;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,51583,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Tundra Penguin - On spawn - Cast [DND] Creature Random Size (0 - 50) on self’);

– SAI for Spearfang Worg
SET @ENTRY := 24677;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,44366,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Spearfang Worg - On spawn - Cast Howling Fjord - Quest - Predator Dummy Periodic on self’);

– SAI for Scourging Crystal
SET @ENTRY := 24464;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,43874,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Scourging Crystal - On spawn - Cast Scourge Mur’‘gul Camp: Force Shield Arcane Purple x3 on self’);

– SAI for Moa’ki Bottom Thresher
SET @ENTRY := 26511;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,8876,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Moa’‘ki Bottom Thresher - On spawn - Cast Thrash on self’);

– SAI for Tuskarr Turtle Rider
SET @ENTRY := 29953;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,55587,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Tuskarr Turtle Rider - On spawn - Cast Tuskarr Turtle Rider CustomSpell01 on self’);

– SAI for Snowfall Glade Reaver
SET @ENTRY := 26197;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,15088,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Snowfall Glade Reaver - On spawn - Cast Flurry on self’);

– SAI for Conquest Hold Berserker
SET @ENTRY := 27500;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY; – Remove EAI
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,15088,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Conquest Hold Berserker - On spawn - Cast Flurry on self’),
(@ENTRY,0,1,0,0,0,100,0,1000,3000,12000,20000,11,31403,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Conquest Hold Berserker - Combat - Cast Battle Shout on self’);

– SAI for Indu’le Fisherman
SET @ENTRY := 26343;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,32423,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Indu’‘le Fisherman - On spawn - Cast Blue Radiation on self’);

– SAI for Vengeful Taunka Spirit
SET @ENTRY := 25668;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,46695,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Vengeful Taunka Spirit - On spawn - Cast Soul Separation on self’);

– SAI for Steam Frog
SET @ENTRY := 25679;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,36151,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Steam Frog - On spawn - Cast Cosmetic: Steam Aura on self’);

– SAI for Steam Rager
SET @ENTRY := 24601;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY; – Remove EAI
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,36151,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Steam Rager - On spawn - Cast Cosmetic: Steam Aura on self’),
(@ENTRY,0,1,0,0,0,100,0,4000,8000,11000,14000,11,50375,1,0,0,0,0,2,0,0,0,0,0,0,0, ‘Steam Rager - Combat - Cast Steam Blast on victom’);

– SAI for Big Electromental Flavor
SET @ENTRY := 21757;
UPDATE creature_template SET ScriptName=‘’,AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY; – Remove EAI
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,37248,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Big Electromental Flavor - On spawn - Cast Power Converters: Electromental Visual on self’);
[/sql]
[/CODE]