{"action":"closed","issue":{"url":"https://api.github.com/repos/unified-db/Database/issues/33","labels_url":"https://api.github.com/repos/unified-db/Database/issues/33/labels{/name}","comments_url":"https://api.github.com/repos/unified-db/Database/issues/33/comments","events_url":"https://api.github.com/repos/unified-db/Database/issues/33/events","html_url":"https://github.com/unified-db/Database/issues/33","id":58469646,"number":33,"title":"Sunwell Gauntlet Event after Felmyst death.","user":{"login":"Ulduar","id":2470094,"avatar_url":"https://avatars.githubusercontent.com/u/2470094?v=3","gravatar_id":"","url":"https://api.github.com/users/Ulduar","html_url":"https://github.com/Ulduar","followers_url":"https://api.github.com/users/Ulduar/followers","following_url":"https://api.github.com/users/Ulduar/following{/other_user}","gists_url":"https://api.github.com/users/Ulduar/gists{/gist_id}","starred_url":"https://api.github.com/users/Ulduar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ulduar/subscriptions","organizations_url":"https://api.github.com/users/Ulduar/orgs","repos_url":"https://api.github.com/users/Ulduar/repos","events_url":"https://api.github.com/users/Ulduar/events{/privacy}","received_events_url":"https://api.github.com/users/Ulduar/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-02-21T18:36:26Z","updated_at":"2015-03-16T19:04:44Z","closed_at":"2015-03-16T19:04:44Z","body":"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.\r\nhttp://www.wowhead.com/npc=25851#abilities\r\nhttp://www.wowhead.com/npc=25848/gauntlet-imp-trigger\r\nhttp://www.wowhead.com/npc=25837#abilities\r\nhttp://www.wowhead.com/npc=25485#abilities\r\nhttp://www.wowhead.com/npc=25484#abilities\r\nI decided to try to implement it in the database!\r\n``` SQL\r\nDELETE FROM `creature_movement` WHERE `id`=50700;\r\nINSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `orientation`) VALUES\r\n('50700','1','1575.15','531.259','35.2354','1000','2548301','5.04759');\r\n\r\n-- Creature id: 25483\r\nREPLACE INTO creature_ai_scripts VALUES \r\n('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'),\r\n('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.'),\r\n('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.'),\r\n('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.');\r\n\r\n\r\n\r\n\r\nSET @SHADOWSWORD_COMMANDER:=2000005281;\r\nDELETE FROM `db_script_string` WHERE `entry` = @SHADOWSWORD_COMMANDER;\r\nINSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc8`, `comment`) VALUES\r\n(@SHADOWSWORD_COMMANDER,'Bring forth the imps!','Бесы, вперёд!','Shadowsword Commander - Yell on Start Gauntlet imp event.');\r\n\r\n-- Script id: 2548301\r\nDELETE FROM dbscripts_on_creature_movement WHERE id=2548301;\r\nINSERT INTO dbscripts_on_creature_movement VALUES \r\n(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.'),\r\n(2548301,0,32,1,0,0,0,0,0,0,0,0,0,0,0,0,'Shadowsword Manafiend - Set Pause Movement.'),\r\n(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.'),\r\n(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)');\r\n\r\n-- Script id: 25837\r\nDELETE FROM dbscripts_on_creature_death WHERE id=25837;\r\nINSERT INTO dbscripts_on_creature_death VALUES \r\n(25837,1,18,0,0,25848,1000,4,0,0,0,0,0,0,0,0,'Gauntlet Event Trigger - Force Despawn on Death.');\r\n\r\n-- Creature id: 25848\r\nUPDATE creature_template SET AIName='EventAI' WHERE entry=25848;\r\nDELETE FROM creature_ai_scripts WHERE creature_id=25848;\r\nINSERT INTO creature_ai_scripts VALUES \r\n('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.'),\r\n('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.'),\r\n('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.'),\r\n('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.');\r\n\r\n\r\nUPDATE `creature_template` SET `ExtraFlags`=`ExtraFlags`|2048 WHERE entry IN (25848, 25851, 25485, 25484);\r\n\r\nDELETE FROM `creature` WHERE `id` IN (25848, 25485, 25484);\r\n```\r\nHad in some cases use guid NPC. Spread the screenshots, so you know about any guid in question!\r\nThanks YTDB Cata for npc data guid!\r\nhttp://savepic.org/6908690.jpg         Manafiend guid = 50700.\r\nhttp://savepic.org/6904594.jpg        Commander guid = 348086\r\n"}}