Trinitycore: DB/Misc: Borean Tundra

[STARRHELD]

Description: Missing SAI for abilites and texts around the zone.

Current behaviour: Loads of creatures in Borean Tundra got SAI missing for abilities and also their texts

Expected behaviour: SAI with abilites for creatures and appropriate texts

Branch(es): 3.3.5

TC rev. hash/commit: 1750ca501f7a

TDB version: 335.63

Operating system: Linux

[STARRHELD]

List of creatures missing their ablities

• [x] Unliving Swine is missing the spell Swine Flu.
• [x] En'kilah Necrolord is missing the spells Bone Armor and Sharpened Bone.
• [x] Bane is missing the spell Fool's Bane.
• [x] Kvaldir Mist Lord is missing the spell Wave Crash - Kvaldir is also missing some creature_text.
• [x] Kvaldir Mistweaver is missing the spell Call of the Mist.
• [x] Warsong Battleguard is missing the spells Dual Wield and Enrage between 0-25% health.
• [x] Kel'Thuzad is missing the spell Soul Flay.
• [x] Injured Warsong Shaman is missing the spells Earth Shock and Chain Lightning.
• [x] Injured Warsong Mage is missing the spells Arcane Explosion, Pyroblast and Blizzard.
• [x] Injured Warsong Warrior is missing the spells Warlord's Bulwark, Cleave and Heroic Strike.
• [x] Injured Warsong Engineer is missing the spells Tune Up!, Goblin Dragon Gun and Super Shrink Ray.
• [x] Rockfang is missing the spells Animal Blood on died and Chilling Howl.
• [x] Den Vermin is missing the spell Thrash.
• [x] Gammothra the Tormentor is missing the spells Magnataur Charge and Tusk Strike.
• [x] Ragnar Drakkarlund is missing the spell Whirlwind.
• [x] Leviroth is missing the spell Mortal Strike.
• [x] Crypt Crawler is missing the spell Crypt Scarabs.
• [x] Rocknar is missing the spells Harden Skin and Ice Spike - Rocknar is also missing some creature_text.
• [x] Lurid and High Deathpriest Isidorus are missing some of their creature_text, Lurid will no longer attack the Defenders.
• [x] Ziggurat Defender is missing the spell Thrash Kick.
• [x] Fleeing Cultist is missing some creature_text on spawn.
• [x] Thassarian is missing some creature_text every 5 minutes.
• [x] Bloodspore Harvester, Bloodspore Roaster and Bloodspore Firestarter are missing their creature_text.
• [x] Bloodspore Moth got the wrong InhabitType.
• [x] Bloodspore Harvester, Bloodspore Roaster and Bloodspore Firestarter are now removed, moved and separated to their correct locations.

[STARRHELD]

Fix:

-- Unliving Swine SAI
SET @ENTRY := 25600;
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,2000,5000,8000,12000,11,50303,0,0,0,0,0,2,0,0,0,0,0,0,0,"Unliving Swine - In Combat - Cast 'Swine Flu'");

-- En'kilah Necrolord SAI
SET @ENTRY := 25609;
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,0,0,30000,30000,11,50324,0,0,0,0,0,1,0,0,0,0,0,0,0,"En'kilah Necrolord - In Combat - Cast 'Bone Armor'"),
(@ENTRY,0,1,0,0,0,100,0,2000,5000,6000,9000,11,50323,0,0,0,0,0,2,0,0,0,0,0,0,0,"En'kilah Necrolord - In Combat - Cast 'Sharpened Bone'");

-- Bane SAI
SET @ENTRY := 25655;
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,2000,5000,15000,20000,11,50332,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bane - In Combat - Cast 'Fool's Bane'");

-- Kvaldir Mist Lord
DELETE FROM `creature_text` WHERE `CreatureID` = 25496 AND `groupid` = 0; 
INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(25496,0,0,' Become ashes in the mist!',12,0,100,0,4000,0,24719,0,'Kvaldir Mist Lord'),
(25496,0,1,' The subjugation of these people has only just begun... so much time for fun and games.',12,0,100,0,4000,0,24718,0,'Kvaldir Mist Lord'),
(25496,0,2,' Burn, land dweller! BURN!',12,0,100,0,4000,0,24717,0,'Kvaldir Mist Lord');

-- Kvaldir Mist Lord SAI
SET @ENTRY := 25496;
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,0,0,12000,15000,11,49922,0,0,0,0,0,2,0,0,0,0,0,0,0,"Kvaldir Mist Lord - In Combat - Cast 'Wave Crash'");

-- Kvaldir Mistweaver SAI
SET @ENTRY := 25479;
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,2000,3000,11000,14000,11,49816,0,0,0,0,0,2,0,0,0,0,0,0,0,"Kvaldir Mistweaver - In Combat - Cast 'Mist of Strangulation'"),
(@ENTRY,0,1,0,25,0,100,0,0,0,0,0,11,45658,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kvaldir Mistweaver - On Reset - Cast 'Call of the Mist'");

-- Warsong Battleguard SAI
SET @ENTRY := 25242;
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,25,0,100,0,0,0,0,0,11,42459,0,0,0,0,0,1,0,0,0,0,0,0,0,"Warsong Battleguard - On Reset - Cast 'Dual Wield'"),
(@ENTRY,0,1,0,2,0,100,0,0,25,2,2,11,8599,0,0,0,0,0,1,0,0,0,0,0,0,0,"Warsong Battleguard - Between 0-25% Health - Cast 'Enrage'");

-- Kel'Thuzad SAI
SET @ENTRY := 25465;
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,1,1,0,100,0,3000,6000,27000,29000,11,50312,32,0,0,0,0,1,0,0,0,0,0,0,0,"Kel'Thuzad - Out of Combat - Cast 'Unholy Frenzy'"),
(@ENTRY,0,1,0,61,0,100,0,0,0,0,0,4,8818,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kel'Thuzad - Out of Combat - Play Sound 8818"),
(@ENTRY,0,2,0,1,0,100,0,0,0,2000,10000,11,50319,0,0,0,0,0,21,70,0,0,0,0,0,0,"Kel'Thuzad - Out of Combat - Cast 'Soul Flay'"),
(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kel'Thuzad - On Reset - Set Active On");

-- Injured Warsong Shaman SAI
SET @ENTRY := 27108;
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,1,8,0,100,1,47962,0,0,0,85,47967,1,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Shaman - On Spell hit - Cast Killcredit on Invoker"),
(@ENTRY,0,1,0,61,0,100,513,47962,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Injured Warsong Shaman - On Spell hit - Despawn after 1sec"),
(@ENTRY,0,2,0,0,0,100,0,0,2000,6000,14000,11,25025,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Shaman - In Combat - Cast 'Earth Shock'"),
(@ENTRY,0,3,0,0,0,100,0,3000,5000,8000,12000,11,16033,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Shaman - In Combat - Cast 'Chain Lightning'");

-- Injured Warsong Mage SAI
SET @ENTRY := 27107;
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,1,8,0,100,1,47962,0,0,0,85,47967,1,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Mage - On Spell hit - Cast Killcredit on Invoker"),
(@ENTRY,0,1,0,61,0,100,513,47962,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Injured Warsong Mage - On Spell hit - Despawn after 1sec"),
(@ENTRY,0,2,0,0,0,100,0,0,2000,1000,7000,11,34933,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Mage - In Combat - Cast 'Arcane Explosion'"),
(@ENTRY,0,3,0,0,0,100,0,3000,7000,10000,30000,11,17274,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Mage - In Combat - Cast 'Pyroblast'"),
(@ENTRY,0,4,0,0,0,100,0,8000,12000,20000,30000,11,46195,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Mage - In Combat - Cast 'Blizzard'");

-- Injured Warsong Warrior SAI
SET @ENTRY := 27106;
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,2,8,0,100,1,47962,0,0,0,85,47967,1,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Warrior - On Spellhit 'Rescue Injured Soldier' - Invoker Cast 'Soldier Rescued' (No Repeat)"),
(@ENTRY,0,1,0,61,0,100,513,47962,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Injured Warsong Warrior - On Spellhit 'Rescue Injured Soldier' - Despawn Instant (No Repeat)"),
(@ENTRY,0,2,1,61,0,100,0,47962,0,0,0,85,47975,0,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Warrior - On Spellhit 'Rescue Injured Soldier' - Invoker Cast 'Warlord's Bulwark' (No Repeat)"),
(@ENTRY,0,3,0,0,0,100,0,0,3000,7000,14000,11,39047,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Warrior - In Combat - Cast 'Cleave'"),
(@ENTRY,0,4,0,0,0,100,0,3000,6000,7000,14000,11,45026,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Warrior - In Combat - Cast 'Heroic Strike'");

-- Injured Warsong Engineer SAI
SET @ENTRY := 27110;
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,2,8,0,100,1,47962,0,0,0,85,47967,1,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Engineer - On Spellhit 'Rescue Injured Soldier' - Invoker Cast 'Soldier Rescued' (No Repeat)"),
(@ENTRY,0,1,0,61,0,100,513,47962,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Injured Warsong Engineer - On Spellhit 'Rescue Injured Soldier' - Despawn Instant (No Repeat)"),
(@ENTRY,0,2,1,61,0,100,0,47962,0,0,0,85,47969,0,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Engineer - On Spellhit 'Rescue Injured Soldier' - Invoker Cast 'Tune Up!' (No Repeat)"),
(@ENTRY,0,3,0,0,0,100,0,0,3000,7000,14000,11,44273,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Engineer - In Combat - Cast 'Goblin Dragon Gun'"),
(@ENTRY,0,4,0,0,0,100,0,4000,7000,12000,15000,11,22742,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Engineer - In Combat - Cast 'Super Shrink Ray'");

-- Rockfang SAI
SET @ENTRY := 25774;
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,6,0,100,0,0,0,0,0,11,46221,0,0,0,0,0,7,0,0,0,0,0,0,0,"Rockfang - On Just Died - Cast 'Animal Blood'"),
(@ENTRY,0,1,0,0,0,100,0,3000,5000,6000,9000,11,32918,0,0,0,0,0,2,0,0,0,0,0,0,0,"Rockfang - In Combat - Cast 'Chilling Howl'");

-- Den Vermin SAI
SET @ENTRY := 24567;
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,1000,6000,3000,8000,11,3391,0,0,0,0,0,1,0,0,0,0,0,0,0,"Den Vermin - In Combat - Cast 'Thrash'");

-- Gammothra the Tormentor SAI
SET @ENTRY := 25789;
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,8,0,100,512,46012,0,0,0,36,25790,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gammothra the Tormentor - On Spellhit 'Bloodspore Poison' - Update Template To 'Weakened Gammothra'"),
(@ENTRY,0,1,0,0,0,100,0,0,1000,10000,12000,11,50413,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gammothra the Tormentor - In Combat - Cast 'Magnataur Charge'"),
(@ENTRY,0,2,0,0,0,100,0,3000,5000,6000,10000,11,50410,0,0,0,0,0,2,0,0,0,0,0,0,0,"Gammothra the Tormentor - In Combat - Cast 'Tusk Strike'");

-- Ragnar Drakkarlund SAI
SET @ENTRY := 26451;
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,3000,5000,8000,10000,11,41056,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ragnar Drakkarlund - In Combat - Cast 'Whirlwind'");

-- Leviroth SAI
SET @ENTRY := 26452;
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,6,8,0,100,512,49882,0,0,0,19,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leviroth - On Spellhit 'Leviroth Self-Impale' - Remove Flags Immune To Players & Immune To NPC's"),
(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,18,768,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leviroth - On Reset - Set Flags Immune To Players & Immune To NPC's"),
(@ENTRY,0,4,0,25,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leviroth - On Reset - Set Active On"),
(@ENTRY,0,5,0,0,0,100,0,0,4000,8000,11000,11,19643,0,0,0,0,0,2,0,0,0,0,0,0,0,"Leviroth - In Combat - Cast 'Mortal Strike'"),
(@ENTRY,0,6,7,61,0,100,0,49882,0,0,0,11,46767,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leviroth - On Spellhit 'Leviroth Self-Impale' - Cast 'Cosmetic - Underwater Blood'"),
(@ENTRY,0,7,0,8,0,100,0,49882,0,0,0,49,0,0,0,0,0,0,17,0,30,0,0,0,0,0,"Leviroth - On Spellhit 'Leviroth Self-Impale' - Start Attacking");

-- Crypt Crawler SAI
SET @ENTRY := 25227;
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,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crypt Crawler - In Combat - Disable Combat Movement"),
(@ENTRY,0,1,0,0,0,100,0,0,0,6000,8000,11,31600,0,0,0,0,0,2,0,0,0,0,0,0,0,"Crypt Crawler - In Combat - Cast 'Crypt Scarabs'"),
(@ENTRY,0,2,0,9,0,100,0,2,30,2000,3000,11,31600,0,0,0,0,0,2,0,0,0,0,0,0,0,"Crypt Crawler - Within 2-30 Range - Cast 'Crypt Scarabs'");

DELETE FROM `creature_text` WHERE `CreatureID` = 25514; -- Rocknar
INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(25514,0,0,' Frozen and destroyed. This is all your fleshy corpse is good for.',12,0,100,0,0,0,24727,0,'Rocknar'),
(25514,0,1,' You are not welcome here. Die!',12,0,100,0,0,0,24728,0,'Rocknar'),
(25514,0,2,' Your presence unbalances the land. You must be removed!',12,0,100,0,0,0,24729,0,'Rocknar');

-- Rocknar SAI
SET @ENTRY := 25514;
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,1,25,0,100,0,0,0,0,0,11,42617,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - On Reset - Cast 'Vertex Color Lt. Blue'"),
(@ENTRY,0,1,0,21,0,100,1,0,0,0,0,11,45776,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - On Reached Home - Cast 'Ice Block' (No Repeat)"),
(@ENTRY,0,2,3,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - On Aggro - Say Line 0"),
(@ENTRY,0,3,0,61,0,100,0,0,0,0,0,28,45776,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - On Aggro - Remove Aura 'Ice Block'"),
(@ENTRY,0,4,0,0,0,100,0,0,3000,8000,10000,11,50094,0,0,0,0,0,2,0,0,0,0,0,0,0,"Rocknar - In Combat - Cast 'Ice Spike'"),
(@ENTRY,0,5,0,11,0,100,1,0,0,0,0,11,45776,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - On Respawn - Cast 'Ice Block' (No Repeat)"),
(@ENTRY,0,6,0,0,0,100,0,4000,7000,14000,16000,11,22693,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - In Combat - Cast 'Harden Skin'");

DELETE FROM `creature_text` WHERE `CreatureID` = 26185; -- Lurid
INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(26185,0,0,' You worship death, little man?  Death is here!',12,0,100,35,0,0,25347,0,'Lurid'),
(26185,0,1,' Master... you want... I kill puny priest?  Make painful, yes?',12,0,100,35,0,0,25345,0,'Lurid'),
(26185,0,2,' Yes, weakling... beg Lurid for life!',12,0,100,35,0,0,25346,0,'Lurid'),
(26185,1,0,' You Arthas lapdog?  You die!',12,0,100,0,0,0,25835,0,'Lurid'),
(26185,1,1,' Time to kill!',12,0,100,0,0,0,17565,0,'Lurid'),
(26185,1,2,' Lurid could get used... to working with you.',12,0,100,0,0,0,25837,0,'Lurid'),
(26185,1,3,' It\'s about time!  Lurid was getting bored.',12,0,100,0,0,0,25834,0,'Lurid'),
(26185,1,4,' This not... end well for you!',12,0,100,0,0,0,25836,0,'Lurid');

-- Lurid SAI
SET @ENTRY := 26185;
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,300000,300000,300000,300000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lurid - Out of Combat - Say Line 0"),
(@ENTRY,0,1,0,25,0,100,0,0,0,0,0,8,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lurid - On Reset - Set Reactstate Defensive"),
(@ENTRY,0,2,0,4,0,100,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lurid - On Aggro - Say Line 1");

-- High Deathpriest Isidorus texts
DELETE FROM `creature_text` WHERE `CreatureID` = 26171;
INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(26171,0,0,' Please... all our orders come from Naxxanar... me and my men are kept in the dark!',12,0,100,0,0,0,25353,0,'High Deathpriest Isidorus'),
(26171,0,1,' Mercy!  You were once with us!  DO you not remember?',12,0,100,0,0,0,25355,0,'High Deathpriest Isidorus'),
(26171,0,2,' I beg you, death knight!  Keep your minion away from me!  I\'ll do anything!',12,0,100,0,0,0,25354,0,'High Deathpriest Isidorus');

-- High Deathpriest Isidorus SAI
SET @ENTRY := 26171;
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,305000,305000,300000,300000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"High Deathpriest Isidorus - Out of Combat - Say Line 0");

-- Ziggurat Defender SAI
SET @ENTRY := 26202;
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,3000,5000,1000,5000,11,50306,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ziggurat Defender - In Combat - Cast 'Thrash Kick'");

-- spell condition for 'Borean Tundra - Quest - Thassarian Flay'
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND  `SourceGroup`=1 AND `SourceEntry`=46685;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES 
(13, 1, 46685, 0, 0, 31, 0, 3, 26173, 0, 0, 0, 0, '', "Spell 'Thassarian Flay' only targets NPC Tanathal");

-- Fleeing Cultist texts
DELETE FROM `creature_text` WHERE `CreatureID` = 26189; 
INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(26189,0,0,' The ziggurat\'s lost!  Flee to the temple!',12,0,100,0,0,0,25350,0,'Fleeing Cultist'),
(26189,0,1,' The death knight... he\'s mad!',12,0,100,0,0,0,25349,0,'Fleeing Cultist'),
(26189,0,2,' Arthas save us - we\'re doomed!',12,0,100,0,0,0,25348,0,'Fleeing Cultist');

-- Fleeing Cultist SAI
SET @ENTRY := 26189;
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,11,0,33,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Fleeing Cultist - On Respawn - Say Line 0");

DELETE FROM `creature_text` WHERE `CreatureID` = 26170 AND `groupid` = 7; -- Thassarian
INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(26170,7,0,' Speak, Lich!  Undeath won\'t save you from what I\'ll put you through!',12,0,100,0,4000,0,25321,0,'Thassarian');

-- Thassarian SAI
SET @GUID := -101136;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=26170;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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
(@GUID,0,0,0,1,0,100,0,150000,150000,300000,300000,1,7,0,0,0,0,0,1,0,0,0,0,0,0,0,"Thassarian - Out of Combat - Say Line 7"),
(@GUID,0,1,0,25,0,100,0,0,0,0,0,11,46685,0,0,0,0,0,19,26173,20,0,0,0,0,0,"Thassarian - On Reset - Cast 'Borean Tundra - Quest - Thassarian Flay'");

DELETE FROM `creature_text` WHERE `CreatureID` = 25467 AND `groupid` = 0; 
INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(25467,0,0,' No hurt the lifegiver!',12,0,100,0,4000,0,24689,0,'Bloodspore Harvester'),
(25467,0,1,' Protect lifegiver!',12,0,100,0,4000,0,24691,0,'Bloodspore Harvester'),
(25467,0,2,' No touch spores!',12,0,100,0,4000,0,24690,0,'Bloodspore Harvester');

-- Bloodspore Harvester SAI
SET @ENTRY := 25467;
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,25,0,100,0,0,0,0,0,11,45987,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bloodspore Harvester - On Reset - Cast 'Bloodspore Malaise'"),
(@ENTRY,0,1,0,0,0,100,0,3000,6000,10000,13000,11,50380,0,0,0,0,0,2,0,0,0,0,0,0,0,"Bloodspore Harvester - In Combat - Cast 'Bloodspore Haze'"),
(@ENTRY,0,2,0,4,0,33,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bloodspore Harvester - On Aggro - Say Line 0");

DELETE FROM `creature_text` WHERE `CreatureID` = 25468 AND `groupid` = 0; 
INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(25468,0,0,' No hurt the lifegiver!',12,0,100,0,4000,0,24689,0,'Bloodspore Roaster'),
(25468,0,1,' Protect lifegiver!',12,0,100,0,4000,0,24691,0,'Bloodspore Roaster'),
(25468,0,2,' No touch spores!',12,0,100,0,4000,0,24690,0,'Bloodspore Roaster');

-- Bloodspore Roaster SAI
SET @ENTRY := 25468;
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,1000,6000,10000,15000,11,45986,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bloodspore Roaster - Out of Combat - Cast 'Spore Roast'"),
(@ENTRY,0,1,0,0,0,100,0,1000,4000,13000,15000,11,50402,0,0,0,0,0,2,0,0,0,0,0,0,0,"Bloodspore Roaster - In Combat - Cast 'Roast'"),
(@ENTRY,0,2,0,4,0,33,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bloodspore Roaster - On Aggro - Say Line 0");

DELETE FROM `creature_text` WHERE `CreatureID` = 25470 AND `groupid` = 0; 
INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(25470,0,0,' No hurt the lifegiver!',12,0,100,0,4000,0,24689,0,'Bloodspore Firestarter'),
(25470,0,1,' Protect lifegiver!',12,0,100,0,4000,0,24691,0,'Bloodspore Firestarter'),
(25470,0,2,' No touch spores!',12,0,100,0,4000,0,24690,0,'Bloodspore Firestarter'),
(25470,1,3,' Protect lifegiver!',14,0,100,0,4000,0,24691,0,'Bloodspore Firestarter');

-- Bloodspore Firestarter SAI
SET @ENTRY := 25470;
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,1000,1000,600000,600000,11,45985,1,0,0,0,0,1,0,0,0,0,0,0,0,"Bloodspore Firestarter - Out of Combat - Cast 'Flaming Touch'"),
(@ENTRY,0,1,0,0,0,100,0,0,0,3800,6200,11,20793,0,0,0,0,0,2,0,0,0,0,0,0,0,"Bloodspore Firestarter - In Combat - Cast 'Fireball'"),
(@ENTRY,0,2,0,4,0,33,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bloodspore Firestarter - On Aggro - Say Line 0"),
(@ENTRY,0,3,0,1,0,33,0,1000,300000,300000,600000,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bloodspore Firestarter - Out of Combat - Say Line 1");

-- Bloodspore Moth
UPDATE `creature_template` SET `InhabitType` = 4 WHERE `entry` = 25464;

-- Bloodmage Laurith SAI
SET @ENTRY := 25381;
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,25,0,100,0,0,0,0,0,8,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bloodmage Laurith - On Reset - Set Reactstate Defensive");

-- Primal Mighthorn SAI
SET @ENTRY := 25380;
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,19,0,100,0,11721,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Primal Mighthorn - On Quest Accept (Gammothra the Tormentor) - Say Line 1"),
(@ENTRY,0,1,0,25,0,100,0,0,0,0,0,8,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Primal Mighthorn - On Reset - Set Reactstate Defensive");

-- Bloodspore Firestarter
UPDATE `creature` SET `position_x`= 2560.157, `position_y`= 5832.141, `position_z`= 141.855 WHERE `guid`= 107529;

-- Primal Mighthorn, Bloodmage Laurith
UPDATE `creature` SET `orientation`= 0.3736162 WHERE `guid`= 132640;
UPDATE `creature` SET `orientation`= 2.397409 WHERE `guid`= 132641;
DELETE FROM `creature_formations` WHERE `leaderGUID`= 132640;
INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES
(132640, 132640, 0, 0, 2, 0, 0),
(132640, 132641, 0, 0, 2, 0, 0);

-- Bloodspore Moth, Bloodspore Harvester, Bloodspore Firestarter
DELETE FROM `creature` WHERE `guid` IN (132708, 107116, 107253, 107560);
DELETE FROM `creature_addon` WHERE `guid` IN (132708,107116,107253,107560);

-- Den Vermin
UPDATE `creature` SET `spawntimesecs`= 300, `spawndist`= 5, `MovementType`= 1 WHERE `guid` IN (133116,133117,133118,133121);
UPDATE `creature` SET `position_x`= 2649.587, `position_y`= 5904.689, `position_z`=  4.274 WHERE `guid`= 133116;
UPDATE `creature` SET `position_x`= 2559.874, `position_y`= 5871.110, `position_z`= 27.613 WHERE `guid`= 133117;
UPDATE `creature` SET `position_x`= 2592.794, `position_y`= 5867.375, `position_z`= -9.839 WHERE `guid`= 133118;
UPDATE `creature` SET `position_x`= 2564.476, `position_y`= 5890.039, `position_z`= -8.713 WHERE `guid`= 133121;

-- Bloodspore Harvester, Bloodspore Roaster
UPDATE `creature` SET `unit_flags`= 768 WHERE `guid` IN (132720, 132721, 132722, 132723, 132724);
UPDATE `creature` SET `spawndist`= 0, `MovementType`= 0 WHERE `guid` IN (107309, 107322, 107360, 107386, 107387);

[STARRHELD]

Fixes submitted and provided by TC contributors that needs testing.

-- Surristrasz GOSSIP
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(15,9472,0,0,0,8,0,11733,0,0,0,0,'','Surristrasz - Show Gossip Option 0 if Quest 11733 is rewarded'),

Contributors:
@velinath

[PolarCookie]

Could you add fixing Surristrasz' SAI? His gossip option to fly to Coldara should only be available if you've completed Traversing the Rift.

[aletson]

suggested:

INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(15,9472,0,0,0,8,0,11733,0,0,0,0,'','Surristrasz - Show Gossip Option 0 if Quest 11733 is rewarded'),

needs testing

[ghost]

@STARRHELD : I have a suggestion for your spell 46685 condition, the description part.

-- spell condition for 'Borean Tundra - Quest - Thassarian Flay'
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND  `SourceGroup`=1 AND `SourceEntry`=46685;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES 
(13, 1, 46685, 0, 0, 31, 0, 3, 26173, 0, 0, 0, 0, '', 'spell Thassarian Flay only targets NPC Tanathal');

(I added a suggestion for what the preceding comment line can look like too)

BTW, in an ideal world, your comment post https://github.com/TrinityCore/TrinityCore/issues/20594#issuecomment-335894210 would have links to either wowpedia or wowhead pages (or any other important sources) for each of the related words in bold so reviewers and TC members would not need to look up or search google to verify the information, ;-)

[Killyana]

This is issue still a WIP ?

[STARRHELD]

Well you can check the things and correct and push if you want @killyana

[ghost]

Updated the formatting in your SQL -- mostly the queries below Primal Mighthorn's SAI section (last 5 paragraphs).

[Killyana]

Lot of this scripts were made by TeridanDW, I cannot push without his approval.

[Wyreth]

@Killyana: just credit him in the commit message. If it's visible to everyone (or it was), then it's free game. It's not like SAI scripts can be copyrighted, anyway.

[ghost]

@STARRHELD : I wonder if you would consider changing your list in https://github.com/TrinityCore/TrinityCore/issues/20594#issuecomment-335894210 from using

• bullet points

to use tick boxes - [X] - [ ] instead, like this:

• [X] example of ticked box
• [ ] example of unticked box

to show if the entire list is completed or if there are any missing changes remaining.

[Killyana]

@TeridanDW, Can this be pushed as a big part is your work?

[Killyana]

Cleaned version as some npcs were scripted n previous commits.
``sql -- Unliving Swine SAI SET @ENTRY := 25600; UPDATEcreature_templateSETAIName="SmartAI" WHEREentry=@ENTRY; DELETE FROMsmart_scriptsWHEREentryorguid=@ENTRY ANDsource_type=0; INSERT INTOsmart_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,2000,5000,8000,12000,11,50303,0,0,0,0,0,2,0,0,0,0,0,0,0,"Unliving Swine - In Combat - Cast 'Swine Flu'");

-- En'kilah Necrolord SAI
SET @ENTRY := 25609;
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,0,0,30000,30000,11,50324,0,0,0,0,0,1,0,0,0,0,0,0,0,"En'kilah Necrolord - In Combat - Cast 'Bone Armor'"),
(@ENTRY,0,1,0,0,0,100,0,2000,5000,6000,9000,11,50323,0,0,0,0,0,2,0,0,0,0,0,0,0,"En'kilah Necrolord - In Combat - Cast 'Sharpened Bone'");

-- Bane SAI
SET @ENTRY := 25655;
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,2000,5000,15000,20000,11,50332,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bane - In Combat - Cast 'Fool's Bane'");

-- Kvaldir Mist Lord SAI
SET @ENTRY := 25496;
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,0,0,10000,15000,11,49922,0,0,0,0,0,2,0,0,0,0,0,0,0,"Kvaldir Mist Lord - In Combat - Cast 'Wave Crash'");

-- Kel'Thuzad SAI
SET @ENTRY := 25465;
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,1,1,0,100,0,3000,6000,27000,29000,11,50312,32,0,0,0,0,1,0,0,0,0,0,0,0,"Kel'Thuzad - Out of Combat - Cast 'Unholy Frenzy'"),
(@ENTRY,0,1,0,61,0,100,0,0,0,0,0,4,8818,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kel'Thuzad - Out of Combat - Play Sound 8818"),
(@ENTRY,0,2,0,1,0,100,0,0,0,2000,10000,11,50319,0,0,0,0,0,21,70,0,0,0,0,0,0,"Kel'Thuzad - Out of Combat - Cast 'Soul Flay'");

-- Injured Warsong Shaman SAI
SET @ENTRY := 27108;
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,1,8,0,100,1,47962,0,0,0,85,47967,1,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Shaman - On Spell hit - Cast Killcredit on Invoker"),
(@ENTRY,0,1,0,61,0,100,513,47962,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Injured Warsong Shaman - On Spell hit - Despawn after 1sec"),
(@ENTRY,0,2,0,0,0,100,0,0,2000,6000,14000,11,25025,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Shaman - In Combat - Cast 'Earth Shock'"),
(@ENTRY,0,3,0,0,0,100,0,3000,5000,8000,12000,11,16033,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Shaman - In Combat - Cast 'Chain Lightning'");

-- Injured Warsong Mage SAI
SET @ENTRY := 27107;
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,1,8,0,100,1,47962,0,0,0,85,47967,1,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Mage - On Spell hit - Cast Killcredit on Invoker"),
(@ENTRY,0,1,0,61,0,100,513,47962,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Injured Warsong Mage - On Spell hit - Despawn after 1sec"),
(@ENTRY,0,2,0,0,0,100,0,0,2000,1000,7000,11,34933,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Mage - In Combat - Cast 'Arcane Explosion'"),
(@ENTRY,0,3,0,0,0,100,0,3000,7000,10000,30000,11,17274,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Mage - In Combat - Cast 'Pyroblast'"),
(@ENTRY,0,4,0,0,0,100,0,8000,12000,20000,30000,11,46195,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Mage - In Combat - Cast 'Blizzard'");

-- Injured Warsong Warrior SAI
SET @ENTRY := 27106;
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,2,8,0,100,1,47962,0,0,0,85,47967,1,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Warrior - On Spellhit 'Rescue Injured Soldier' - Invoker Cast 'Soldier Rescued' (No Repeat)"),
(@ENTRY,0,1,0,61,0,100,513,47962,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Injured Warsong Warrior - On Spellhit 'Rescue Injured Soldier' - Despawn Instant (No Repeat)"),
(@ENTRY,0,2,1,61,0,100,0,47962,0,0,0,85,47975,0,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Warrior - On Spellhit 'Rescue Injured Soldier' - Invoker Cast 'Warlord's Bulwark' (No Repeat)"),
(@ENTRY,0,3,0,0,0,100,0,0,3000,7000,14000,11,39047,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Warrior - In Combat - Cast 'Cleave'"),
(@ENTRY,0,4,0,0,0,100,0,3000,6000,7000,14000,11,45026,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Warrior - In Combat - Cast 'Heroic Strike'");

-- Injured Warsong Engineer SAI
SET @ENTRY := 27110;
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,2,8,0,100,1,47962,0,0,0,85,47967,1,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Engineer - On Spellhit 'Rescue Injured Soldier' - Invoker Cast 'Soldier Rescued' (No Repeat)"),
(@ENTRY,0,1,0,61,0,100,513,47962,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Injured Warsong Engineer - On Spellhit 'Rescue Injured Soldier' - Despawn Instant (No Repeat)"),
(@ENTRY,0,2,1,61,0,100,0,47962,0,0,0,85,47969,0,0,0,0,0,7,0,0,0,0,0,0,0,"Injured Warsong Engineer - On Spellhit 'Rescue Injured Soldier' - Invoker Cast 'Tune Up!' (No Repeat)"),
(@ENTRY,0,3,0,0,0,100,0,0,3000,7000,14000,11,44273,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Engineer - In Combat - Cast 'Goblin Dragon Gun'"),
(@ENTRY,0,4,0,0,0,100,0,4000,7000,12000,15000,11,22742,0,0,0,0,0,2,0,0,0,0,0,0,0,"Injured Warsong Engineer - In Combat - Cast 'Super Shrink Ray'");

-- Rockfang SAI
SET @ENTRY := 25774;
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,6,0,100,0,0,0,0,0,11,46221,2,0,0,0,0,7,0,0,0,0,0,0,0,"Rockfang - On Just Died - Cast 'Animal Blood'"),
(@ENTRY,0,1,0,0,0,100,0,3000,5000,6000,9000,11,32918,0,0,0,0,0,2,0,0,0,0,0,0,0,"Rockfang - In Combat - Cast 'Chilling Howl'");

-- Gammothra the Tormentor SAI
SET @ENTRY := 25789;
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,8,0,100,512,46012,0,0,0,36,25790,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gammothra the Tormentor - On Spellhit 'Bloodspore Poison' - Update Template To 'Weakened Gammothra'"),
(@ENTRY,0,1,0,0,0,100,0,0,1000,10000,12000,11,50413,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gammothra the Tormentor - In Combat - Cast 'Magnataur Charge'"),
(@ENTRY,0,2,0,0,0,100,0,3000,5000,6000,10000,11,50410,0,0,0,0,0,2,0,0,0,0,0,0,0,"Gammothra the Tormentor - In Combat - Cast 'Tusk Strike'");

-- Ragnar Drakkarlund SAI
SET @ENTRY := 26451;
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,3000,5000,8000,10000,11,41056,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ragnar Drakkarlund - In Combat - Cast 'Whirlwind'");

-- Crypt Crawler SAI
SET @ENTRY := 25227;
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,2000,3000,2000,3000,11,31600,64,0,0,0,0,2,0,0,0,0,0,0,0,"Crypt Crawler - IC - Cast 'Crypt Scarabs' CMC");

DELETE FROM creature_text WHERE CreatureID = 25514; -- Rocknar
INSERT INTO creature_text (CreatureID, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextId, TextRange, comment) VALUES
(25514,0,0,' Frozen and destroyed. This is all your fleshy corpse is good for.',12,0,100,0,0,0,24727,0,'Rocknar'),
(25514,0,1,' You are not welcome here. Die!',12,0,100,0,0,0,24728,0,'Rocknar'),
(25514,0,2,' Your presence unbalances the land. You must be removed!',12,0,100,0,0,0,24729,0,'Rocknar');

-- Rocknar SAI
SET @ENTRY := 25514;
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,25,0,100,0,0,0,0,0,11,42617,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - On Reset - Cast 'Vertex Color Lt. Blue'"),
(@ENTRY,0,1,0,21,0,100,1,0,0,0,0,11,45776,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - On Reached Home - Cast 'Ice Block' (No Repeat)"),
(@ENTRY,0,2,3,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - On Aggro - Say Line 0"),
(@ENTRY,0,3,0,61,0,100,0,0,0,0,0,28,45776,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - On Aggro - Remove Aura 'Ice Block'"),
(@ENTRY,0,4,0,0,0,100,0,0,3000,8000,10000,11,50094,0,0,0,0,0,2,0,0,0,0,0,0,0,"Rocknar - In Combat - Cast 'Ice Spike'"),
(@ENTRY,0,5,0,11,0,100,1,0,0,0,0,11,45776,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - On Respawn - Cast 'Ice Block' (No Repeat)"),
(@ENTRY,0,6,0,0,0,100,0,4000,7000,14000,16000,11,22693,0,0,0,0,0,1,0,0,0,0,0,0,0,"Rocknar - In Combat - Cast 'Harden Skin'");

DELETE FROM creature_text WHERE CreatureID = 26185; -- Lurid
INSERT INTO creature_text (CreatureID, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextId, TextRange, comment) VALUES
(26185,0,0,' You worship death, little man? Death is here!',12,0,100,35,0,0,25347,0,'Lurid'),
(26185,0,1,' Master... you want... I kill puny priest? Make painful, yes?',12,0,100,35,0,0,25345,0,'Lurid'),
(26185,0,2,' Yes, weakling... beg Lurid for life!',12,0,100,35,0,0,25346,0,'Lurid'),
(26185,1,0,' You Arthas lapdog? You die!',12,0,100,0,0,0,25835,0,'Lurid'),
(26185,1,1,' Time to kill!',12,0,100,0,0,0,17565,0,'Lurid'),
(26185,1,2,' Lurid could get used... to working with you.',12,0,100,0,0,0,25837,0,'Lurid'),
(26185,1,3,' It\'s about time! Lurid was getting bored.',12,0,100,0,0,0,25834,0,'Lurid'),
(26185,1,4,' This not... end well for you!',12,0,100,0,0,0,25836,0,'Lurid');

-- Lurid SAI
SET @ENTRY := 26185;
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,30000,70000,170000,200000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lurid - Out of Combat - Say Line 0"),
(@ENTRY,0,1,0,25,0,100,0,0,0,0,0,8,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lurid - On Reset - Set Reactstate Defensive"),
(@ENTRY,0,2,0,4,0,100,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Lurid - On Aggro - Say Line 1");

-- High Deathpriest Isidorus texts
DELETE FROM creature_text WHERE CreatureID = 26171;
INSERT INTO creature_text (CreatureID, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextId, TextRange, comment) VALUES
(26171,0,0,' Please... all our orders come from Naxxanar... me and my men are kept in the dark!',12,0,100,0,0,0,25353,0,'High Deathpriest Isidorus'),
(26171,0,1,' Mercy! You were once with us! DO you not remember?',12,0,100,0,0,0,25355,0,'High Deathpriest Isidorus'),
(26171,0,2,' I beg you, death knight! Keep your minion away from me! I\'ll do anything!',12,0,100,0,0,0,25354,0,'High Deathpriest Isidorus');

-- High Deathpriest Isidorus SAI
SET @ENTRY := 26171;
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,30000,50000,170000,200000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"High Deathpriest Isidorus - Out of Combat - Say Line 0");

-- Ziggurat Defender SAI
SET @ENTRY := 26202;
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,3000,5000,1000,5000,11,50306,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ziggurat Defender - In Combat - Cast 'Thrash Kick'");

-- spell condition for 'Borean Tundra - Quest - Thassarian Flay'
DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceGroup=1 AND SourceEntry=46685;
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,SourceId,ElseGroup,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,ConditionValue3,NegativeCondition,ErrorType,ErrorTextId,ScriptName,Comment) VALUES
(13, 1, 46685, 0, 0, 31, 0, 3, 26173, 0, 0, 0, 0, '', "Spell 'Thassarian Flay' only targets NPC Tanathal");

-- Fleeing Cultist texts
DELETE FROM creature_text WHERE CreatureID = 26189;
INSERT INTO creature_text (CreatureID, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextId, TextRange, comment) VALUES
(26189,0,0,' The ziggurat\'s lost! Flee to the temple!',12,0,100,0,0,0,25350,0,'Fleeing Cultist'),
(26189,0,1,' The death knight... he\'s mad!',12,0,100,0,0,0,25349,0,'Fleeing Cultist'),
(26189,0,2,' Arthas save us - we\'re doomed!',12,0,100,0,0,0,25348,0,'Fleeing Cultist');

-- Fleeing Cultist SAI
SET @ENTRY := 26189;
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,11,0,33,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Fleeing Cultist - On Respawn - Say Line 0");

DELETE FROM creature_text WHERE CreatureID = 26170 AND groupid = 7; -- Thassarian
INSERT INTO creature_text (CreatureID, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextId, TextRange, comment) VALUES
(26170,7,0,' Speak, Lich! Undeath won\'t save you from what I\'ll put you through!',12,0,100,0,4000,0,25321,0,'Thassarian');

-- Bloodspore Moth
UPDATE creature_template SET InhabitType = 7 WHERE entry = 25464;

-- Bloodmage Laurith SAI
SET @ENTRY := 25381;
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,25,0,100,0,0,0,0,0,8,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bloodmage Laurith - On Reset - Set Reactstate Defensive");

-- Primal Mighthorn SAI
SET @ENTRY := 25380;
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,19,0,100,0,11721,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Primal Mighthorn - On Quest Accept (Gammothra the Tormentor) - Say Line 1"),
(@ENTRY,0,1,0,25,0,100,0,0,0,0,0,8,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Primal Mighthorn - On Reset - Set Reactstate Defensive");

-- Bloodspore Firestarter
UPDATE creature SET position_x= 2560.157, position_y= 5832.141, position_z= 141.855 WHERE guid= 107529;

-- Primal Mighthorn, Bloodmage Laurith
UPDATE creature SET orientation= 0.3736162 WHERE guid= 132640;
UPDATE creature SET orientation= 2.397409 WHERE guid= 132641;
DELETE FROM creature_formations WHERE leaderGUID= 132640;
INSERT INTO creature_formations (leaderGUID,memberGUID,dist,angle,groupAI,point_1,point_2) VALUES
(132640, 132640, 0, 0, 3, 0, 0),
(132640, 132641, 0, 0, 3, 0, 0);

-- Bloodspore Moth, Bloodspore Harvester, Bloodspore Firestarter
DELETE FROM creature WHERE guid IN (132708, 107116, 107253, 107560);
DELETE FROM creature_addon WHERE guid IN (132708,107116,107253,107560);

-- Den Vermin
UPDATE creature SET spawntimesecs= 300, spawndist= 5, MovementType= 1 WHERE guid IN (133116,133117,133118,133121);
UPDATE creature SET position_x= 2649.587, position_y= 5904.689, position_z= 4.274 WHERE guid= 133116;
UPDATE creature SET position_x= 2559.874, position_y= 5871.110, position_z= 27.613 WHERE guid= 133117;
UPDATE creature SET position_x= 2592.794, position_y= 5867.375, position_z= -9.839 WHERE guid= 133118;
UPDATE creature SET position_x= 2564.476, position_y= 5890.039, position_z= -8.713 WHERE guid= 133121;

-- Bloodspore Harvester, Bloodspore Roaster
UPDATE creature SET unit_flags= 768 WHERE guid IN (132720, 132721, 132722, 132723, 132724);
UPDATE creature SET spawndist= 0, MovementType= 0 WHERE guid IN (107309, 107322, 107360, 107386, 107387);

DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup=9472 AND SourceEntry=0;
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,SourceId,ElseGroup,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,ConditionValue3,NegativeCondition,ErrorTextId,ScriptName,Comment) VALUES
(15,9472,0,0,0,8,0,11733,0,0,0,0,'','Surristrasz - Show Gossip Option 0 if Quest 11733 is rewarded');