-- Daegarn SAI
SET @ENTRY := 24151;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,0,1,0,100,0,40000,40000,40000,40000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Daegarn - Out of Combat - talk");

-- Texts for Daegarn
SET @ENTRY := 24151;
DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(@ENTRY,0,0,"What did you do with the people of this village!?",12,7,100,5,0,0,"Daegarn"),
(@ENTRY,0,1,"What do you want with me?",12,7,100,5,0,0,"Daegarn"),
(@ENTRY,0,2,"Release me, cowards! I'll show you what a dwarf is made of!",12,7,100,5,0,0,"Daegarn");

-- Dragonflayer Berserker SAI
SET @ENTRY := 24216;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY;
INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@ENTRY,0,0,0,1,27, '');
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,0,1,0,100,0,6000,7000,6000,7000,10,53,60,113,388,397,0,1,0,0,0,0,0,0,0,"Dragonflayer Berserker - Out of Combat - Play Random Emote"),
(@ENTRY,0,1,0,1,0,100,0,5000,15000,30000,40000,11,43291,0,0,0,0,0,11,24221,40,0,0,0,0,0,"Dragonflayer Berserker - Out of Combat - Cast Throw Bottle"),
(@ENTRY,0,2,0,1,0,100,0,14000,26000,14000,26000,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Berserker - Out of Combat - talk"),
(@ENTRY,0,3,0,4,0,80,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Berserker - Aggro - talk");

-- Texts for Dragonflayer Berserker
SET @ENTRY := 24216;
DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(@ENTRY,0,0,"Beg for your life...",12,0,100,0,0,0,"Dragonflayer Berserker"),
(@ENTRY,0,1,"Suffer, insect!",12,0,100,0,0,0,"Dragonflayer Berserker"),
(@ENTRY,0,2,"Your end draws closer!",12,0,100,0,0,0,"Dragonflayer Berserker"),
(@ENTRY,0,3,"My life for Ymiron!",12,0,100,0,0,0,"Dragonflayer Berserker"),
(@ENTRY,0,4,"For Ymiron!",12,0,100,0,0,0,"Dragonflayer Berserker"),
(@ENTRY,0,5,"YAAARRRGH!",12,0,100,0,0,0,"Dragonflayer Berserker"),
(@ENTRY,1,0,"Take me! I am ready to die!",12,0,100,0,0,0,"Dragonflayer Berserker"),
(@ENTRY,1,1,"We battle for the glory of Ymiron! We die in the name of the Lich King!",12,0,100,0,0,0,"Dragonflayer Berserker"),
(@ENTRY,1,2,"Drink in their misery, brother!",12,0,100,0,0,0,"Dragonflayer Berserker"),
(@ENTRY,1,3,"Stand and be judged!",12,0,100,0,0,0,"Dragonflayer Berserker"),
(@ENTRY,1,4,"May you die in the Lich King''s favor!",12,0,100,0,0,0,"Dragonflayer Berserker");

-- Dragonflayer Soulreaver SAI
SET @ENTRY := 24249;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY;
INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@ENTRY,0,0,0,1,0, '43170 43395');
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,0,0,0,80,0,9000,9000,6000,7000,11,43512,0,0,0,0,0,2,0,0,0,0,0,0,0,"Dragonflayer Soulreaver - Combat - Cast Spell Mind Flay"),
(@ENTRY,0,1,0,0,0,100,0,8000,8000,30000,30000,11,11639,0,0,0,0,0,2,0,0,0,0,0,0,0,"Dragonflayer Soulreaver - Combat - Cast Spell Shadow Word: Pain"),
(@ENTRY,0,2,0,4,0,80,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Soulreaver - Aggro - talk");

SET @ENTRY := -113439;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,0,0,0,100,0,5000,8000,15000,22000,11,43512,0,0,0,0,0,2,0,0,0,0,0,0,0,"Dragonflayer Soulreaver - Combat - Cast Spell Mind Flay"),
(@ENTRY,0,1,0,0,0,100,0,4000,7000,24000,28000,11,11639,0,0,0,0,0,2,0,0,0,0,0,0,0,"Dragonflayer Soulreaver - Combat - Cast Spell Shadow Word: Pain"),
(@ENTRY,0,2,0,1,0,100,0,13000,16000,13000,16000,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Soulreaver - Out of Combat - talk"),
(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Soulreaver - Reset - Set bytes_1 value 8"),
(@ENTRY,0,4,0,4,0,100,0,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Soulreaver - Aggro - Remove bytes_1 value 8"),
(@ENTRY,0,5,0,4,0,80,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Soulreaver - Aggro - talk");

-- Texts for Dragonflayer Soulreaver
SET @ENTRY := 24249;
DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(@ENTRY,0,0,"Beg for your life...",12,0,100,0,0,0,"Dragonflayer Soulreaver"),
(@ENTRY,0,1,"Suffer, insect!",12,0,100,0,0,0,"Dragonflayer Soulreaver"),
(@ENTRY,0,2,"Your end draws closer!",12,0,100,0,0,0,"Dragonflayer Soulreaver"),
(@ENTRY,0,3,"My life for Ymiron!",12,0,100,0,0,0,"Dragonflayer Soulreaver"),
(@ENTRY,0,4,"For Ymiron!",12,0,100,0,0,0,"Dragonflayer Soulreaver"),
(@ENTRY,0,5,"YAAARRRGH!",12,0,100,0,0,0,"Dragonflayer Soulreaver"),
(@ENTRY,1,0,"I sacrifice this human in the name of our dark master!",12,0,100,53,0,0,"Dragonflayer Soulreaver"),
(@ENTRY,1,1,"I am ready to die!",12,0,100,53,0,0,"Dragonflayer Soulreaver"),
(@ENTRY,1,2,"Take me, val'kyr! I am ready to be judged!",12,0,100,53,0,0,"Dragonflayer Soulreaver");

-- Dragonflayer Fleshripper SAI
SET @ENTRY := 24250;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,0,0,0,100,0,5000,7000,25000,35000,11,11977,0,0,0,0,0,2,0,0,0,0,0,0,0,"Dragonflayer Fleshripper - Combat - Cast Spell Rend"),
(@ENTRY,0,1,0,0,0,100,0,20000,25000,30000,40000,11,35948,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Fleshripper - Combat - Cast Spell Bloodthirst"),
(@ENTRY,0,2,0,4,0,80,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonflayer Fleshripper - Aggro - talk");

-- Texts for Dragonflayer Fleshripper
SET @ENTRY := 24250;
DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(@ENTRY,0,0,"Beg for your life...",12,0,100,0,0,0,"Dragonflayer Fleshripper"),
(@ENTRY,0,1,"Suffer, insect!",12,0,100,0,0,0,"Dragonflayer Fleshripper"),
(@ENTRY,0,2,"Your end draws closer!",12,0,100,0,0,0,"Dragonflayer Fleshripper"),
(@ENTRY,0,3,"My life for Ymiron!",12,0,100,0,0,0,"Dragonflayer Fleshripper"),
(@ENTRY,0,4,"For Ymiron!",12,0,100,0,0,0,"Dragonflayer Fleshripper"),
(@ENTRY,0,5,"YAAARRRGH!",12,0,100,0,0,0,"Dragonflayer Fleshripper"),
(@ENTRY,1,0,"The interlopers will be stopped, my lord.",12,0,100,0,0,0,"Dragonflayer Fleshripper"),
(@ENTRY,2,0,"One among us will ascend on this day.",12,0,100,0,0,0,"Dragonflayer Fleshripper"),
(@ENTRY,2,1,"My life for the Dread King!",12,0,100,0,0,0,"Dragonflayer Fleshripper");

DELETE FROM `creature_addon` WHERE `guid` BETWEEN 155488 AND 155499;
DELETE FROM `creature_addon` WHERE `guid`= 104386;
DELETE FROM `creature` WHERE `id` IN (24177,24250,24158,24226,24253,24255,24270);
UPDATE `creature` SET `modelid`=0, `curhealth`=1 WHERE `id` IN (24216,24249,24250);
UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (24221,24258,24260);