New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Gnomeregan] Emote and 'Radiation' cast updates #18737

Closed
Rushor opened this Issue Jan 4, 2017 · 3 comments

Comments

Projects
None yet
3 participants
@Rushor
Contributor

Rushor commented Jan 4, 2017

source: idk what i should tell here since https://github.com/cmangos/wotlk-db, https://github.com/cmangos/classic-db and https://github.com/Looking4Group/L4G_Core/pull/3068/files have these script. Let's say the source is mangos :)

issue:
Irradiated Invader and Irradiated Pillager should cast 'Radiation' on death and do an emote.
If a nearby Caverndeep Burrower, Caverndeep Ambusher, Caverndeep Invader, Caverndeep Looter, Caverndeep Pillager, Caverndeep Reaver, Leprous Technician, Leprous Defender, Leprous Machinesmith, Dark Iron Ambassador, Holdout Warrior or Leprous Assistant was hit by the spell, they should do an emote too and get hit by 'Radiation' aura.

GitHub Logo

Also:

  • Add the Emote and 'Radiation' cast updates for Irradiated Invader and Irradiated Pillager
  • Add green aura for Irradiated Invader and Irradiated Pillager
  • Add Overlord Ramtusk's 'Battle Stance' cast
  • Add aggrotext for Electrocutioner 6000
  • Add combat AI for Mobile Alert System (credits to sunwell here)

Branch(es): 3.3.5 / master (Tell us which branch(es) this issue affects.)
3.3.5

TC rev. hash/commit: bddf15d

Operating system: win 10

@Rushor

This comment has been minimized.

Show comment
Hide comment
@Rushor

Rushor Jan 4, 2017

Contributor

fix:

-- Overlord Ramtusk SAI -- Add 'Battle Stance'
SET @ENTRY := 4420;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=3;
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,3,0,25,0,100,0,0,0,0,0,11,7165,0,0,0,0,0,1,0,0,0,0,0,0,0,"Overlord Ramtusk - On Reset - Cast 'Battle Stance'");

-- Irradiated Invader SAI -- Add abilities, visualspells and texts
SET @ENTRY := 6213;
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,9769,0,0,0,0,0,0,0,0,0,0,0,0,0,"Irradiated Invader - On Reset - Cast 'Radiation'"),
(@ENTRY,0,1,0,25,0,100,0,0,0,0,0,11,21862,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Invader - On Reset - Cast 'Radiation'"),
(@ENTRY,0,2,0,0,0,100,0,3600,7200,3600,7200,11,9771,0,0,0,0,0,2,0,0,0,0,0,0,0,"Irradiated Invader - In Combat - Cast 'Radiation Bolt'"),
(@ENTRY,0,3,4,6,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Invader - On Just Died - Say Line 0"),
(@ENTRY,0,4,0,61,0,100,0,0,0,0,0,11,9798,2,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Invader - On Just Died - Cast 'Radiation'");

-- Irradiated Pillager SAI -- Add visualspells and texts
SET @ENTRY := 6329;
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,75,9798,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - On Reset - Add Aura 'Radiation'"),
(@ENTRY,0,1,0,0,0,100,0,3000,5000,10000,11000,11,9771,64,0,0,0,0,17,0,50,0,0,0,0,0,"Irradiated Pillager - In Combat CMC - Cast 'Radiation Bolt'"),
(@ENTRY,0,2,0,2,0,100,1,0,50,0,0,11,8269,2,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - Between 0-50% Health - Cast 'Frenzy' (No Repeat)"),
(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,11,21862,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - On Reset - Cast 'Radiation'"),
(@ENTRY,0,4,5,6,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - On Just Died - Say Line 0"),
(@ENTRY,0,5,0,61,0,100,0,0,0,0,0,11,9798,2,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - On Just Died - Cast 'Radiation'");

-- Caverndeep Burrower SAI
SET @ENTRY := 6206;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=4;
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,4,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Burrower - On Spellhit 'Radiation' - Say Line 0");

-- Caverndeep Ambusher SAI
SET @ENTRY := 6207;
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,3700,3700,3600,12400,11,2590,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Ambusher - In Combat - Cast 'Backstab'"),
(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Ambusher - Between 0-15% Health - Flee For Assist (No Repeat)"),
(@ENTRY,0,2,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Ambusher - On Spellhit 'Radiation' - Say Line 0");

-- Caverndeep Invader SAI
SET @ENTRY := 6208;
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,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Invader - On Spellhit 'Radiation' - Say Line 0"),
(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Invader - Between 0-15% Health - Flee For Assist (No Repeat)");

-- Caverndeep Looter SAI
SET @ENTRY := 6209;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=1;
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,1,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Looter - On Spellhit 'Radiation' - Say Line 0");

-- Caverndeep Pillager SAI
SET @ENTRY := 6210;
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,8876,32,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Pillager - On Reset - Cast 'Thrash'"),
(@ENTRY,0,1,0,9,0,100,0,0,5,24500,24500,11,1777,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Pillager - Within 0-5 Range - Cast 'Gouge'"),
(@ENTRY,0,2,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Pillager - On Spellhit 'Radiation' - Say Line 0"),
(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Pillager - Between 0-15% Health - Flee For Assist (No Repeat)");

-- Caverndeep Reaver SAI
SET @ENTRY := 6211;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id` >=3;
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,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Reaver - Between 0-15% Health - Flee For Assist (No Repeat)"),
(@ENTRY,0,4,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Caverndeep Reaver - On Spellhit 'Radiation' - Say Line 0");

-- Leprous Technician SAI
SET @ENTRY := 6222;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id` >=3;
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,3,0,1,0,100,0,10000,45000,30000,70000,11,10348,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Technician - Out of Combat - Cast 'Tune Up'"),
(@ENTRY,0,4,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Technician - On Spellhit 'Radiation' - Say Line 0");

-- Leprous Defender SAI
SET @ENTRY := 6223;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=4;
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,4,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Defender - On Spellhit 'Radiation' - Say Line 0");

-- Leprous Machinesmith SAI
SET @ENTRY := 6224;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=3;
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,3,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Machinesmith - On Spellhit 'Radiation' - Say Line 0");

-- Dark Iron Ambassador SAI
SET @ENTRY := 6228;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=6;
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,6,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Ambassador - On Spellhit 'Radiation' - Say Line 0");

-- Holdout Warrior SAI
SET @ENTRY := 6391;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`>=2;
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,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Warrior - Between 0-15% Health - Flee For Assist (No Repeat)"),
(@ENTRY,0,3,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Warrior - On Spellhit 'Radiation' - Say Line 0");

-- Leprous Assistant SAI
SET @ENTRY := 7603;
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,4,0,100,0,0,0,0,0,39,10,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Assistant - On Aggro - Call For Help"),
(@ENTRY,0,1,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Assistant - On Spellhit 'Radiation' - Say Line 0");

-- Electrocutioner 6000 SAI
SET @ENTRY := 6235;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=3;
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,3,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Electrocutioner 6000 - On Aggro - Say Line 0");

-- Mobile Alert System SAI (credits to Sunwell)
SET @ENTRY := 7849;
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,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mobile Alert System - On Reset - Disable Combat Movement"),
(@ENTRY,0,1,0,0,0,100,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mobile Alert System - In Combat - Say Line 0 (No Repeat)"),
(@ENTRY,0,2,0,0,0,100,1,5000,5000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mobile Alert System - In Combat - Say Line 0 (No Repeat)"),
(@ENTRY,0,3,4,0,0,100,0,10000,10000,10000,10000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mobile Alert System - In Combat - Say Line 0"),
(@ENTRY,0,4,5,61,0,100,0,10000,10000,10000,10000,12,7603,4,30000,0,0,0,1,0,0,0,5,0,0,0,"Mobile Alert System - In Combat - Summon Creature 'Leprous Assistant'"),
(@ENTRY,0,5,0,61,0,100,0,10000,10000,10000,10000,12,6223,4,30000,0,0,0,1,0,0,0,-5,0,0,0,"Mobile Alert System - In Combat - Summon Creature 'Leprous Defender'");

DELETE FROM `creature_text` WHERE `entry`=7849;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES 
(7849, 0, 0, 'Warning! Warning! Intruder alert! Intruder alert!', 14, 0, 100, 0, 0, 0, 'Mobile Alert System', 4142);

DELETE FROM `creature_text` WHERE `entry` IN (6213, 6329, 6206, 6207, 6208, 6209, 6210, 6211, 6212, 6222, 6223, 6224, 6228, 6391, 7603, 6235);
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES 
(6213, 0, 0, '%s blood sprays into the air!', 16, 0, 100, 0, 0, 0, 3131, 'Irradiated Invader'),
(6329, 0, 0, '%s blood sprays into the air!', 16, 0, 100, 0, 0, 0, 3131, 'Irradiated Pillager'),
(6206, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Burrower '),
(6207, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Ambusher'),
(6208, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Invader'),
(6209, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Looter'),
(6210, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Pillager'),
(6211, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Reaver'),
(6212, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Dark Iron Agent'),
(6222, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Leprous Technician'),
(6223, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Leprous Defender'),
(6224, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Leprous Machinesmith'),
(6228, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Dark Iron Ambassador'),
(6391, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Holdout Warrior'),
(7603, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Leprous Assistant '),
(6235, 0, 0, 'Electric justice!', 14, 0, 100, 0, 0, 5811, 6177, 'Electrocutioner 6000');
Contributor

Rushor commented Jan 4, 2017

fix:

-- Overlord Ramtusk SAI -- Add 'Battle Stance'
SET @ENTRY := 4420;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=3;
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,3,0,25,0,100,0,0,0,0,0,11,7165,0,0,0,0,0,1,0,0,0,0,0,0,0,"Overlord Ramtusk - On Reset - Cast 'Battle Stance'");

-- Irradiated Invader SAI -- Add abilities, visualspells and texts
SET @ENTRY := 6213;
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,9769,0,0,0,0,0,0,0,0,0,0,0,0,0,"Irradiated Invader - On Reset - Cast 'Radiation'"),
(@ENTRY,0,1,0,25,0,100,0,0,0,0,0,11,21862,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Invader - On Reset - Cast 'Radiation'"),
(@ENTRY,0,2,0,0,0,100,0,3600,7200,3600,7200,11,9771,0,0,0,0,0,2,0,0,0,0,0,0,0,"Irradiated Invader - In Combat - Cast 'Radiation Bolt'"),
(@ENTRY,0,3,4,6,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Invader - On Just Died - Say Line 0"),
(@ENTRY,0,4,0,61,0,100,0,0,0,0,0,11,9798,2,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Invader - On Just Died - Cast 'Radiation'");

-- Irradiated Pillager SAI -- Add visualspells and texts
SET @ENTRY := 6329;
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,75,9798,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - On Reset - Add Aura 'Radiation'"),
(@ENTRY,0,1,0,0,0,100,0,3000,5000,10000,11000,11,9771,64,0,0,0,0,17,0,50,0,0,0,0,0,"Irradiated Pillager - In Combat CMC - Cast 'Radiation Bolt'"),
(@ENTRY,0,2,0,2,0,100,1,0,50,0,0,11,8269,2,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - Between 0-50% Health - Cast 'Frenzy' (No Repeat)"),
(@ENTRY,0,3,0,25,0,100,0,0,0,0,0,11,21862,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - On Reset - Cast 'Radiation'"),
(@ENTRY,0,4,5,6,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - On Just Died - Say Line 0"),
(@ENTRY,0,5,0,61,0,100,0,0,0,0,0,11,9798,2,0,0,0,0,1,0,0,0,0,0,0,0,"Irradiated Pillager - On Just Died - Cast 'Radiation'");

-- Caverndeep Burrower SAI
SET @ENTRY := 6206;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=4;
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,4,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Burrower - On Spellhit 'Radiation' - Say Line 0");

-- Caverndeep Ambusher SAI
SET @ENTRY := 6207;
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,3700,3700,3600,12400,11,2590,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Ambusher - In Combat - Cast 'Backstab'"),
(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Ambusher - Between 0-15% Health - Flee For Assist (No Repeat)"),
(@ENTRY,0,2,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Ambusher - On Spellhit 'Radiation' - Say Line 0");

-- Caverndeep Invader SAI
SET @ENTRY := 6208;
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,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Invader - On Spellhit 'Radiation' - Say Line 0"),
(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Invader - Between 0-15% Health - Flee For Assist (No Repeat)");

-- Caverndeep Looter SAI
SET @ENTRY := 6209;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=1;
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,1,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Looter - On Spellhit 'Radiation' - Say Line 0");

-- Caverndeep Pillager SAI
SET @ENTRY := 6210;
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,8876,32,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Pillager - On Reset - Cast 'Thrash'"),
(@ENTRY,0,1,0,9,0,100,0,0,5,24500,24500,11,1777,0,0,0,0,0,2,0,0,0,0,0,0,0,"Caverndeep Pillager - Within 0-5 Range - Cast 'Gouge'"),
(@ENTRY,0,2,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Pillager - On Spellhit 'Radiation' - Say Line 0"),
(@ENTRY,0,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Pillager - Between 0-15% Health - Flee For Assist (No Repeat)");

-- Caverndeep Reaver SAI
SET @ENTRY := 6211;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id` >=3;
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,3,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Caverndeep Reaver - Between 0-15% Health - Flee For Assist (No Repeat)"),
(@ENTRY,0,4,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Caverndeep Reaver - On Spellhit 'Radiation' - Say Line 0");

-- Leprous Technician SAI
SET @ENTRY := 6222;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id` >=3;
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,3,0,1,0,100,0,10000,45000,30000,70000,11,10348,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Technician - Out of Combat - Cast 'Tune Up'"),
(@ENTRY,0,4,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Technician - On Spellhit 'Radiation' - Say Line 0");

-- Leprous Defender SAI
SET @ENTRY := 6223;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=4;
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,4,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Defender - On Spellhit 'Radiation' - Say Line 0");

-- Leprous Machinesmith SAI
SET @ENTRY := 6224;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=3;
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,3,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Machinesmith - On Spellhit 'Radiation' - Say Line 0");

-- Dark Iron Ambassador SAI
SET @ENTRY := 6228;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=6;
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,6,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dark Iron Ambassador - On Spellhit 'Radiation' - Say Line 0");

-- Holdout Warrior SAI
SET @ENTRY := 6391;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`>=2;
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,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Warrior - Between 0-15% Health - Flee For Assist (No Repeat)"),
(@ENTRY,0,3,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Holdout Warrior - On Spellhit 'Radiation' - Say Line 0");

-- Leprous Assistant SAI
SET @ENTRY := 7603;
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,4,0,100,0,0,0,0,0,39,10,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Assistant - On Aggro - Call For Help"),
(@ENTRY,0,1,0,8,0,100,0,9798,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Leprous Assistant - On Spellhit 'Radiation' - Say Line 0");

-- Electrocutioner 6000 SAI
SET @ENTRY := 6235;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=3;
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,3,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Electrocutioner 6000 - On Aggro - Say Line 0");

-- Mobile Alert System SAI (credits to Sunwell)
SET @ENTRY := 7849;
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,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mobile Alert System - On Reset - Disable Combat Movement"),
(@ENTRY,0,1,0,0,0,100,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mobile Alert System - In Combat - Say Line 0 (No Repeat)"),
(@ENTRY,0,2,0,0,0,100,1,5000,5000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mobile Alert System - In Combat - Say Line 0 (No Repeat)"),
(@ENTRY,0,3,4,0,0,100,0,10000,10000,10000,10000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mobile Alert System - In Combat - Say Line 0"),
(@ENTRY,0,4,5,61,0,100,0,10000,10000,10000,10000,12,7603,4,30000,0,0,0,1,0,0,0,5,0,0,0,"Mobile Alert System - In Combat - Summon Creature 'Leprous Assistant'"),
(@ENTRY,0,5,0,61,0,100,0,10000,10000,10000,10000,12,6223,4,30000,0,0,0,1,0,0,0,-5,0,0,0,"Mobile Alert System - In Combat - Summon Creature 'Leprous Defender'");

DELETE FROM `creature_text` WHERE `entry`=7849;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES 
(7849, 0, 0, 'Warning! Warning! Intruder alert! Intruder alert!', 14, 0, 100, 0, 0, 0, 'Mobile Alert System', 4142);

DELETE FROM `creature_text` WHERE `entry` IN (6213, 6329, 6206, 6207, 6208, 6209, 6210, 6211, 6212, 6222, 6223, 6224, 6228, 6391, 7603, 6235);
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES 
(6213, 0, 0, '%s blood sprays into the air!', 16, 0, 100, 0, 0, 0, 3131, 'Irradiated Invader'),
(6329, 0, 0, '%s blood sprays into the air!', 16, 0, 100, 0, 0, 0, 3131, 'Irradiated Pillager'),
(6206, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Burrower '),
(6207, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Ambusher'),
(6208, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Invader'),
(6209, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Looter'),
(6210, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Pillager'),
(6211, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Caverndeep Reaver'),
(6212, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Dark Iron Agent'),
(6222, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Leprous Technician'),
(6223, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Leprous Defender'),
(6224, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Leprous Machinesmith'),
(6228, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Dark Iron Ambassador'),
(6391, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Holdout Warrior'),
(7603, 0, 0, '%s is splashed by the blood and becomes irradiated!', 16, 0, 100, 0, 0, 0, 3367, 'Leprous Assistant '),
(6235, 0, 0, 'Electric justice!', 14, 0, 100, 0, 0, 5811, 6177, 'Electrocutioner 6000');
@offl

This comment has been minimized.

Show comment
Hide comment
@offl

offl Jan 4, 2017

(6235, 0, 0, 'Electric justice!', 14, 0, 100, 0, 0, 5811, 6177, 'Electrocutioner 6000');

Now with the sound.

offl commented Jan 4, 2017

(6235, 0, 0, 'Electric justice!', 14, 0, 100, 0, 0, 5811, 6177, 'Electrocutioner 6000');

Now with the sound.

@Rushor

This comment has been minimized.

Show comment
Hide comment
@Rushor

Rushor Jan 4, 2017

Contributor

/added

Contributor

Rushor commented Jan 4, 2017

/added

Killyana added a commit that referenced this issue Jan 5, 2017

DB/SAI: Gnomeregan npcs
Closes #18737
By Rushor

Aokromes added a commit to Aokromes/TrinityCore that referenced this issue Jan 7, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment