Sunwell Gauntlet Event after Felmyst death.

Welcome to the Sunwell Plateau there gauntlet event after the murder Felmyst. He started immediately, but after aggro any of the NPC that you are caught first. Kill the Commander of the Clan of the Dark Sword and gauntlet event trigger despawn and stop spawning.
http://www.wowhead.com/npc=25851#abilities
http://www.wowhead.com/npc=25848/gauntlet-imp-trigger
http://www.wowhead.com/npc=25837#abilities
http://www.wowhead.com/npc=25485#abilities
http://www.wowhead.com/npc=25484#abilities
I decided to try to implement it in the database!

DELETE FROM `creature_movement` WHERE `id`=50700;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES
('50700','1','1575.15','531.259','35.2354','1000','2548301','5.04759');

-- Creature id: 25483
REPLACE INTO creature_ai_scripts VALUES 
('2548304','25483','0','0','100','2','1000','1000','0','0','48','2','0','0','0','0','0','0','0','0','0','0','YTDB Shadowsword Manafiend - Start Waypoint Movement on Aggro (special guid) - Start Gauntlet Imp Event and Shadowsword Assassins and Shadowsword Deathbringers'),
('2548305','25483','11','0','100','2','0','0','0','0','21','0','0','0','0','0','0','0','0','0','0','0','YTDB Shadowsword Manafiend - Preevent Combat Movement on Spawn.'),
('2548306','25483','0','0','100','2','3000','3000','0','0','21','1','1','0','0','0','0','0','0','0','0','0','YTDB Shadowsword Manafiend - Allow Combat Movement on IC Timer.'),
('2548307','25483','21','0','100','2','0','0','0','0','11','45769','0','0','0','0','0','0','0','0','0','0','YTDB Shadowsword Manafiend - Cast Sunwell Radiance on Reached Home.');




SET @SHADOWSWORD_COMMANDER:=2000005281;
DELETE FROM `db_script_string` WHERE `entry` = @SHADOWSWORD_COMMANDER;
INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `comment`) VALUES
(@SHADOWSWORD_COMMANDER,'Bring forth the imps!','Бесы, вперёд!','Shadowsword Commander - Yell on Start Gauntlet imp event.');

-- Script id: 2548301
DELETE FROM dbscripts_on_creature_movement WHERE id=2548301;
INSERT INTO dbscripts_on_creature_movement VALUES 
(2548301,0,10,25848,86400000,0,0,0,0,0,0,0,1697.92,502.315,86.4882,1.65806,'Shadowsword Manafiend - Summon Imp Gauntlet Event Trigger.'),
(2548301,0,32,1,0,0,0,0,0,0,0,0,0,0,0,0,'Shadowsword Manafiend - Set Pause Movement.'),
(2548301,0,0,6,0,25837,348086,16,@SHADOWSWORD_COMMANDER,0,0,0,0,0,0,0,'Shadowsword Commander Guid - Yell on Start Gauntlet Imp Event.'),
(2548301,0,31,25848,50000,0,0,8,0,0,0,0,0,0,0,0,'Shadowsword Manafiend - Terminate All script if found alive Gauntlet Event Trigger Imp (start event only first try)');

-- Script id: 25837
DELETE FROM dbscripts_on_creature_death WHERE id=25837;
INSERT INTO dbscripts_on_creature_death VALUES 
(25837,1,18,0,0,25848,1000,4,0,0,0,0,0,0,0,0,'Gauntlet Event Trigger - Force Despawn on Death.');

-- Creature id: 25848
UPDATE creature_template SET AIName='EventAI' WHERE entry=25848;
DELETE FROM creature_ai_scripts WHERE creature_id=25848;
INSERT INTO creature_ai_scripts VALUES 
('2584801','25848','11','0','100','2','0','0','0','0','18','33554432','0','0','21','0','0','0','20','0','0','0','YTDB Gauntlet Imp Event Trigger - Set Not_Selectable Flag and Preevent Combat Movement and Auto Attack.'),
('2584802','25848','11','0','100','2','0','0','0','0','38','0','0','0','0','0','0','0','0','0','0','0','YTDB Gauntlet Imp Event Trigger - Set In Combat With Zone.'),
('2584803','25848','0','0','100','3','3000','3000','15000','15000','12','25851','4','0','0','0','0','0','0','0','0','0','YTDB Gauntlet Imp Event Trigger - Summon Imp.'),
('2584804','25848','0','0','100','35','10000','14000','20000','25000','12','25485','4','0','12','25484','4','0','0','0','0','0','YTDB Gauntlet Imp Event Trigger - Summon Random Shadowsword Assasin or Shadowsword Deathbringer.');


UPDATE `creature_template` SET `ExtraFlags`=`ExtraFlags`|2048 WHERE entry IN (25848, 25851, 25485, 25484);

DELETE FROM `creature` WHERE `id` IN (25848, 25485, 25484);

Had in some cases use guid NPC. Spread the screenshots, so you know about any guid in question!
Thanks YTDB Cata for npc data guid!
http://savepic.org/6908690.jpg Manafiend guid = 50700.
http://savepic.org/6904594.jpg Commander guid = 348086

[Rushor]

hmm how do we archive, that the tempsummoned units 'Shadowsword Assasin or Shadowsword Deathbringer' automatically attack the player? or do they simply stay on their place after the summon?

Gauntlet Event Trigger in my script enter combat on spawn - Summon Assasin or Deathbringer action has flag RANDOM_HOSTILE. Therefore they immediately attack the target. Maybe this is wrong.