{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14269","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14269/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14269/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14269/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/14269","id":59402724,"number":14269,"title":"DB/Quest: The Delicate Sound of Thunder / Lightning Infused Relics","user":{"login":"Killyana","id":6587064,"avatar_url":"https://avatars.githubusercontent.com/u/6587064?v=3","gravatar_id":"","url":"https://api.github.com/users/Killyana","html_url":"https://github.com/Killyana","followers_url":"https://api.github.com/users/Killyana/followers","following_url":"https://api.github.com/users/Killyana/following{/other_user}","gists_url":"https://api.github.com/users/Killyana/gists{/gist_id}","starred_url":"https://api.github.com/users/Killyana/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Killyana/subscriptions","organizations_url":"https://api.github.com/users/Killyana/orgs","repos_url":"https://api.github.com/users/Killyana/repos","events_url":"https://api.github.com/users/Killyana/events{/privacy}","received_events_url":"https://api.github.com/users/Killyana/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Comp-Database","name":"Comp-Database","color":"FF6600"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Feedback-FixOutdatedMissingWip","name":"Feedback-FixOutdatedMissingWip","color":"d7e102"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-03-01T16:12:19Z","updated_at":"2015-03-12T14:37:25Z","closed_at":null,"body":"WIP\r\nhttp://www.wowhead.com/quest=11495\r\nhttp://www.wowhead.com/quest=11494\r\nTo do:\r\n* Transport with Iron Dwarf Rune\r\n``` sql\r\nSET @SUMMON := 49991;\r\nSET @GOLEM  := 24825;\r\nSET @BENCH  := 186958;\r\nSET @Relic := 24824;\r\nSET @Triggger :=24845;\r\nSET @IronDwarf :=24846;\r\nSET @LOKEN := 24847;\r\nSET @Ouvrier:= 23672;\r\nSET @Maitre:=23675;\r\nSET @Garde:=23673;\r\nSET @IRONGolem:=24271;\r\nSET @Earth:=24340; \r\n\r\nDELETE FROM `spell_target_position` WHERE `id` in (49992); \r\nINSERT INTO `spell_target_position` (`id`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`) VALUES\r\n(49992, 571, 478.951782, -5941.529297, 308.749969, 0.419872);\r\n\r\nUPDATE `creature_template` SET `spell1`=44608, `spell2`=44610, `spell3`=44609,`AIName`='SmartAI', `InhabitType`=5 WHERE `entry`=@GOLEM;\r\nUPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@LOKEN, @IronDwarf, @Triggger, @Relic, @Ouvrier, @Maitre, @Garde, @IRONGolem, @Earth);\r\nUPDATE `creature_template` SET `faction`= 1954 WHERE `entry`=@LOKEN;\r\nUPDATE `creature_template` SET `flags_extra`= 0 WHERE `entry`=@Triggger;\r\n\r\nDELETE FROM `creature` WHERE `id` IN (24846, 24847);\r\nDELETE FROM `creature_addon` WHERE `guid` =97731;\r\nUPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `id`= @Triggger;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@GOLEM AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Relic AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@BENCH AND `source_type`=1 AND `id` IN (6,7);\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Triggger AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Triggger*100 AND `source_type`=9;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@IronDwarf AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@IronDwarf*100 AND `source_type`=9;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@LOKEN AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@LOKEN*100 AND `source_type`=9;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Garde AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Garde*100 AND `source_type`=9;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Garde*100+1 AND `source_type`=9;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Ouvrier AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Ouvrier*100 AND `source_type`=9;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Ouvrier*100+1 AND `source_type`=9;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Earth AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Maitre AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Maitre*100 AND `source_type`=9;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@Maitre*100+1 AND `source_type`=9;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@IRONGolem AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@IRONGolem*100 AND `source_type`=9;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@IRONGolem*100+1 AND `source_type`=9;\r\nINSERT 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\r\n(@BENCH,1,6,7,62,0,100,0,9024,3,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Work Bench - Gossip select - Close gossip'),\r\n(@BENCH,1,7,0,61,0,100,0,0,0,0,0,85,@SUMMON,2,0,0,0,0,7,0,0,0,0,0,0,0,'Work Bench - Gossip select - Summon Iron Rune Construct'),\r\n(@GOLEM,0,0,0,54,0,100,0,0,0,0,0,75,44643,0,0,0,0,0,23,0,0,0,0,0,0,0,'Iron Rune Construct - Just Summoned - Add aura to owner'),\r\n(@GOLEM,0,1,0,28,0,100,0,0,0,0,0,28,44643,0,0,0,0,0,23,0,0,0,0,0,0,0,'Iron Rune Construct - Passenger removed - remove aura from owner'),\r\n(@Relic,0,0,0,8,0,100,0,44610,0,0,0,41,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Relict - SpellHit - Despawn'),\r\n(@Triggger,0,0,0,10,0,100,0,1,20,180000,180000,80,@Triggger*100,2,0,0,0,0,1,0,0,0,0,0,0,0,'Triggger - LOS - Action list'),\r\n(@Triggger*100,9,0,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,306.098907, -5706.150391, 102.435051, 4.96977,'Triggger - Action list - Summon'),\t\r\n(@Triggger*100,9,1,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,311.025482, -5702.801270, 101.934959, 5.187225,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,2,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,309.754456, -5703.156250, 102.070854, 5.187225,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,3,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,308.222504, -5703.797363, 102.231758, 5.187225,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,4,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,307.043610, -5704.315430, 102.356087, 5.187225,'Triggger - Action list - Summon'),  \r\n(@Triggger*100,9,5,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,304.169464, -5706.838379, 102.696602, 5.187225,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,6,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,303.129547, -5707.277344, 102.978165, 5.187225,'Triggger - Action list - Summon'),  \r\n(@Triggger*100,9,7,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,297.246,-5726.82,96.2681,0.347607,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,8,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,292.82,-5726.04,96.5843,0.347607,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,9,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,292.562,-5728.57,96.5857,0.347607,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,10,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,292.15,-5727.42,96.5874,0.347607,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,11,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,294.578,-5730.09,96.2958,0.347607,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,12,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,296.196,-5730.17,96.0082,0.347607,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,13,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,297.603,-5730.79,95.6955,0.347607,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,14,0,0,0,100,0,0,0,0,0,12,@IronDwarf,5,0,0,0,0,8,0,0,0,299.397,-5729.56,95.7274,0.347607,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,15,0,0,0,100,0,0,0,0,0,12,@LOKEN,5,0,0,0,0,8,0,0,0,315.101,-5723.06,96.2541,3.05433,'Triggger - Action list - Summon'),\r\n(@Triggger*100,9,16,0,0,0,100,0,70000,70000,0,0,41,0,0,0,0,0,0,11,@IronDwarf,40,0,0,0,0,0,'Triggger - Action List - Despawn'),\r\n(@Triggger,0,1,0,25,0,100,0,0,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Triggger - On reset - set Invisible'),\r\n(@IronDwarf,0,0,0,54,0,100,0,0,0,0,0,80,@IronDwarf*100,2,0,0,0,0,1,0,0,0,0,0,0,0,'IronDwarf - Just Summoned - Action List'),\r\n(@IronDwarf*100,9,0,0,0,0,100,0,0,0,0,0,59,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'IronDwarf - Action List - Set run off'),\r\n(@IronDwarf*100,9,1,0,0,0,100,0,0,0,0,0,46,8,0,0,0,0,0,1,0,0,0,0,0,0,0,'IronDwarf - Action List - Move forward'),\r\n(@IronDwarf*100,9,2,0,0,0,100,0,4000,4000,0,0,11,68442,0,0,0,0,0,1,0,0,0,0,0,0,0,'IronDwarf - Action List - Cast Kneels'),\r\n(@LOKEN,0,0,0,54,0,100,0,0,0,0,0,80,@LOKEN*100,2,0,0,0,0,1,0,0,0,0,0,0,0,'LOKEN - Just Summoned - Action List'),\r\n(@LOKEN*100,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'LOKEN - Action List - Talk'),\r\n(@LOKEN*100,9,1,0,0,0,100,0,6000,6000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'LOKEN - Action List - Talk'),\r\n(@LOKEN*100,9,2,0,0,0,100,0,6000,6000,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'LOKEN - Action List - Talk'),\r\n(@LOKEN*100,9,3,0,0,0,100,0,8000,8000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'LOKEN - Action List - Talk'),\r\n(@LOKEN*100,9,4,0,0,0,100,0,9000,9000,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,'LOKEN - Action List - Talk'),\r\n(@LOKEN*100,9,5,0,0,0,100,0,9000,9000,0,0,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0,'LOKEN - Action List - Talk'),\r\n(@LOKEN*100,9,6,0,0,0,100,0,7000,7000,0,0,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0,'LOKEN - Action List - Talk'),\r\n(@LOKEN*100,9,7,0,0,0,100,0,0,0,0,0,11,44682,0,0,0,0,0,21,40,0,0,0,0,0,0,'LOKEN - Action List - Cast Credit'),\r\n(@LOKEN*100,9,8,0,0,0,100,0,2000,2000,0,0,41,0,0,0,0,0,0,11,@IronDwarf,40,0,0,0,0,0,'LOKEN - Action List - Despawn Dwarfs'),\r\n(@LOKEN*100,9,9,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'LOKEN - Action List - Despawn'),\r\n(@IronDwarf,0,1,0,4,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'IronDwarf - On aggro - despawn'),\r\n(@LOKEN,0,1,0,4,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'LOKEN - On aggro - despawn'),\r\n(@Garde,0,0,0,10,0,20,0,1,9,60000,60000,80,@Garde*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Garde - LOS - Action list'),\r\n(@Garde*100,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Garde - Action list - TALK'),\r\n(@Garde*100,9,1,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Garde - Action list - Set Event phase1'),\r\n(@Garde*100,9,2,0,0,0,100,0,0,0,0,0,103,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Garde - Action list - Root'),\r\n(@Garde*100,9,3,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,19,@GOLEM,20,0,0,0,0,0,'Garde - Action list - Set Orientation'),\r\n(@Garde*100,9,4,0,0,0,100,0,10000,10000,0,0,103,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Garde - Action list - remove root'),\r\n(@Garde*100,9,5,0,0,1,100,0,0,0,0,0,28,44643,0,0,0,0,0,21,50,0,0,0,0,0,0,'Garde - Action list - remove Aura'),\r\n(@Garde*100,9,6,0,0,1,100,0,0,0,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,'Garde - Action list - Talk'),\r\n(@Garde,0,1,0,8,1,100,0,44609,0,0,0,80,@Garde*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Garde - spell hit - action list'),\r\n(@Garde*100+1,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Garde - Action list - Set Event phase 0'),\r\n(@Garde*100+1,9,1,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,19,@GOLEM,20,0,0,0,0,0,'Garde - Action list - TALK'),\r\n(@Garde*100+1,9,2,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Garde - Action list - TALK'),\r\n(@Garde,0,2,0,0,0,100,0,5000,5000,30000,30000,11,42580,0,0,0,0,0,2,0,0,0,0,0,0,0,'Garde - IC - Cast'),\r\n(@Garde,0,3,0,4,0,100,0,0,0,0,0,11,49758,0,0,0,0,0,2,0,0,0,0,0,0,0,'Garde - On aggro - Cast'),\r\n(@Ouvrier,0,0,0,10,0,20,0,1,9,60000,60000,80,@Ouvrier*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ouvrier - LOS - Action list'),\r\n(@Ouvrier*100,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ouvrier - Action list - TALK'),\r\n(@Ouvrier*100,9,1,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ouvrier - Action list - Set Event phase1'),\r\n(@Ouvrier*100,9,2,0,0,0,100,0,0,0,0,0,103,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ouvrier - Action list - Root'),\r\n(@Ouvrier*100,9,3,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,19,@GOLEM,20,0,0,0,0,0,'Ouvrier - Action list - Set Orientation'),\r\n(@Ouvrier*100,9,4,0,0,0,100,0,10000,10000,0,0,103,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ouvrier - Action list - remove root'),\r\n(@Ouvrier*100,9,5,0,0,1,100,0,0,0,0,0,28,44643,0,0,0,0,0,21,50,0,0,0,0,0,0,'Ouvrier - Action list - remove Aura'),\r\n(@Ouvrier*100,9,6,0,0,1,100,0,0,0,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,'Ouvrier - Action list - Talk'),\r\n(@Ouvrier,0,1,0,8,1,100,0,44609,0,0,0,80,@Ouvrier*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ouvrier - spell hit - action list'),\r\n(@Ouvrier*100+1,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ouvrier - Action list - Set Event phase 0'),\r\n(@Ouvrier*100+1,9,1,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,19,@GOLEM,20,0,0,0,0,0,'Ouvrier - Action list - TALK'),\r\n(@Ouvrier*100+1,9,2,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ouvrier - Action list - TALK'),\r\n(@Ouvrier,0,2,0,0,0,100,0,5000,5000,5000,8000,11,49749,0,0,0,0,0,2,0,0,0,0,0,0,0,'Ouvrier - IC - Cast'),\r\n(@Maitre,0,0,0,10,0,20,0,1,9,60000,60000,80,@Maitre*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Maitre - LOS - Action list'),\r\n(@Maitre*100,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Maitre - Action list - TALK'),\r\n(@Maitre*100,9,1,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Maitre - Action list - Set Event phase1'),\r\n(@Maitre*100,9,2,0,0,0,100,0,0,0,0,0,103,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Maitre - Action list - Root'),\r\n(@Maitre*100,9,3,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,19,@GOLEM,20,0,0,0,0,0,'Maitre - Action list - Set Orientation'),\r\n(@Maitre*100,9,4,0,0,0,100,0,10000,10000,0,0,103,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Maitre - Action list - remove root'),\r\n(@Maitre*100,9,5,0,0,1,100,0,0,0,0,0,28,44643,0,0,0,0,0,21,50,0,0,0,0,0,0,'Maitre - Action list - remove Aura'),\r\n(@Maitre*100,9,6,0,0,1,100,0,0,0,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,'Maitre - Action list - Talk'),\r\n(@Maitre,0,1,0,8,1,100,0,44609,0,0,0,80,@Maitre*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Maitre - spell hit - action list'),\r\n(@Maitre*100+1,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Maitre - Action list - Set Event phase 0'),\r\n(@Maitre*100+1,9,1,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,19,@GOLEM,20,0,0,0,0,0,'Maitre - Action list - TALK'),\r\n(@Maitre*100+1,9,2,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Maitre - Action list - TALK'),\r\n(@Maitre,0,2,0,0,0,100,0,5000,5000,7000,10000,11,49753,0,0,0,0,0,2,0,0,0,0,0,0,0,'Garde - IC - Cast'),\r\n(@IRONGolem,0,0,0,10,0,20,0,1,9,60000,60000,80,@IRONGolem*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'IRONGolem - LOS - Action list'),\r\n(@IRONGolem*100,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'IRONGolem - Action list - TALK'),\r\n(@IRONGolem*100,9,1,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'IRONGolem - Action list - Set Event phase1'),\r\n(@IRONGolem*100,9,2,0,0,0,100,0,0,0,0,0,103,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'IRONGolem - Action list - Root'),\r\n(@IRONGolem*100,9,3,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,19,@GOLEM,20,0,0,0,0,0,'IRONGolem - Action list - Set Orientation'),\r\n(@IRONGolem*100,9,4,0,0,0,100,0,10000,10000,0,0,103,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'IRONGolem - Action list - remove root'),\r\n(@IRONGolem*100,9,5,0,0,1,100,0,0,0,0,0,28,44643,0,0,0,0,0,21,50,0,0,0,0,0,0,'IRONGolem - Action list - remove Aura'),\r\n(@IRONGolem*100,9,6,0,0,1,100,0,0,0,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,'IRONGolem - Action list - talk'),\r\n(@IRONGolem,0,1,0,8,1,100,0,44609,0,0,0,80,@IRONGolem*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,'IRONGolem - spell hit - action list'),\r\n(@IRONGolem*100+1,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'IRONGolem - Action list - Set Event phase 0'),\r\n(@IRONGolem*100+1,9,1,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,19,@GOLEM,20,0,0,0,0,0,'IRONGolem - Action list - TALK'),\r\n(@IRONGolem*100+1,9,2,0,0,0,100,0,5000,5000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'IRONGolem - Action list - TALK'),\r\n(@IRONGolem,0,2,0,0,0,100,0,5000,5000,7000,10000,11,49729,0,0,0,0,0,2,0,0,0,0,0,0,0,'IRONGolem - IC - Cast'),\r\n(@IRONGolem,0,3,0,1,0,100,0,50000,60000,60000,90000,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'IRONGolem - ooc - talk'),\r\n(@Earth,0,0,0,0,0,100,0,2000,5000,6000,8000,11,49742,0,0,0,0,0,2,0,0,0,0,0,0,0,'IRONGolem - IC - Cast');\r\n\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=@Triggger;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES\r\n(22,1,@Triggger,0,31,3,24825,0,0,'','event require npc 24825');\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=@IRONGolem;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES\r\n(22,1,@IRONGolem,0,31,3,24825,0,0,'','event require npc 24825');\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=@Garde;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES\r\n(22,1,@Garde,0,31,3,24825,0,0,'','event require npc 24825');\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=@Maitre;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES\r\n(22,1,@Maitre,0,31,3,24825,0,0,'','event require npc 24825');\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=@Ouvrier;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES\r\n(22,1,@Ouvrier,0,31,3,24825,0,0,'','event require npc 24825');\r\n\r\nDELETE FROM `creature_text` WHERE `entry`IN (@LOKEN, @GOLEM, @Garde, @Ouvrier, @Maitre, @IRONGolem); \r\nINSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`, `BroadcastTextID`) VALUES\r\n(@LOKEN,0,0,\"The sound of thunder roars throughout the cavern.\",41,9,100,0,0,0,'LOKEN', 23927),\r\n(@LOKEN,1,0,\"Come, minions! Your master calls!\",14,9,100,0,0,0,'LOKEN', 23922),\r\n(@LOKEN,2,0,\"The work of your brothers in the Storm Peaks has reached a frenzied pace. Soon, Father will be freed.\",14,9,100,0,0,0,'LOKEN', 23923),\r\n(@LOKEN,3,0,\"Your brothers to the north have subjugated the stone behemoths and set them on the path to Ulduar. Soon, the remaining defenses of the Pantheon will be neutralized.\",14,9,100,0,0,0,'LOKEN', 23924),\r\n(@LOKEN,4,0,\"The three fissures opened by the mortals of this region must be silenced. The earth hears and sees what we do and will continue to interfere with our efforts if the way is not closed.\",14,9,100,0,0,0,'LOKEN', 23925),\r\n(@LOKEN,5,0,\"Bury this place! Your master demands it!\",14,9,100,0,0,0,'LOKEN', 23926),\r\n(@LOKEN,6,0,\"The sound of thunder dissipates.\",41,9,100,0,0,0,'LOKEN', 23928),\r\n(@GOLEM,0,0,\"Alert! Alert! Construct senses that enemies have breeched our defenses. Increase pace.\",12,9,100,0,0,0,'GOLEM', 23895),\r\n(@GOLEM,0,1,\"Construct class carrier reporting for duty. Primary function: Overseeing.\",12,9,100,0,0,0,'GOLEM', 23896),\r\n(@GOLEM,0,2,\"There is nothing to see here. Proceed with your mandated duties.\",12,9,100,0,0,0,'GOLEM', 23897),\r\n(@GOLEM,0,3,\"To interfere with construct's function results in termination. Move along.\",12,9,100,0,0,0,'GOLEM', 23899),\r\n(@GOLEM,0,4,\"Construct must not be questioned by iron dwarf servant. Commence deconstruction.\",12,9,100,0,0,0,'GOLEM', 23900),\r\n(@GOLEM,0,5,\"Construct is not authorized to communicate with lesser beings. Being must double their efforts.\",12,9,100,0,0,0,'GOLEM', 23901),\r\n(@GOLEM,0,6,\"Did you lose your wallet? Construct has found wallet with overabundance of currency.\",12,9,100,0,0,0,'GOLEM', 23902),\r\n(@Garde,0,0,\"Halt! Identify yourself immediately!\",12,9,100,0,0,0,'Garde', 23903),\r\n(@Garde,0,1,\"This section is off-limits!\",12,9,100,0,0,0,'Garde', 23904),\r\n(@Garde,0,2,\"I've never seen one of you around here.\",12,9,100,0,0,0,'Garde', 23905),\r\n(@Garde,0,3,\"Hold it! Stop!\",12,9,100,0,0,0,'Garde', 23906),\r\n(@Garde,0,4,\"Stop!! Stop!!! Scrap metal moves itself now?\",12,9,100,0,0,0,'Garde', 23907),\r\n(@Garde,1,2,\"Right... my bad. Now where was I?\",12,9,100,0,0,0,'Garde', 23910),\r\n(@Garde,1,3,\"All hail the great creator!\",12,9,100,0,0,0,'Garde', 23911),\r\n(@Garde,1,4,\"You're right, of course. Carry on.\",12,9,100,0,0,0,'Garde', 23912),\r\n(@Garde,1,5,\"Forgive my insolence!\",12,9,100,0,0,0,'Garde', 23913),\r\n(@Garde,1,6,\"We will double our efforts!\",12,9,100,0,0,0,'Garde', 23915),\r\n(@Garde,2,0,\"Destroy earthen infestation.\",12,9,100,0,0,0,'Garde', 23921),\r\n(@Garde,2,1,\"Wrong answer!\",12,9,100,0,0,0,'Garde', 23908),\r\n(@Ouvrier,0,0,\"Halt! Identify yourself immediately!\",12,9,100,0,0,0,'Garde', 23903),\r\n(@Ouvrier,0,1,\"This section is off-limits!\",12,9,100,0,0,0,'Garde', 23904),\r\n(@Ouvrier,0,2,\"I've never seen one of you around here.\",12,9,100,0,0,0,'Garde', 23905),\r\n(@Ouvrier,0,3,\"Hold it! Stop!\",12,9,100,0,0,0,'Garde', 23906),\r\n(@Ouvrier,0,4,\"Stop!! Stop!!! Scrap metal moves itself now?\",12,9,100,0,0,0,'Garde', 23907),\r\n(@Ouvrier,1,2,\"Right... my bad. Now where was I?\",12,9,100,0,0,0,'Garde', 23910),\r\n(@Ouvrier,1,3,\"All hail the great creator!\",12,9,100,0,0,0,'Garde', 23911),\r\n(@Ouvrier,1,4,\"You're right, of course. Carry on.\",12,9,100,0,0,0,'Garde', 23912),\r\n(@Ouvrier,1,5,\"Forgive my insolence!\",12,9,100,0,0,0,'Garde', 23913),\r\n(@Ouvrier,1,6,\"We will double our efforts!\",12,9,100,0,0,0,'Garde', 23915),\r\n(@Ouvrier,2,0,\"Destroy earthen infestation.\",12,9,100,0,0,0,'Garde', 23921),\r\n(@Ouvrier,2,1,\"Wrong answer!\",12,9,100,0,0,0,'Garde', 23908),\r\n(@Maitre,0,0,\"Halt! Identify yourself immediately!\",12,9,100,0,0,0,'Garde', 23903),\r\n(@Maitre,0,1,\"This section is off-limits!\",12,9,100,0,0,0,'Garde', 23904),\r\n(@Maitre,0,2,\"I've never seen one of you around here.\",12,9,100,0,0,0,'Garde', 23905),\r\n(@Maitre,0,3,\"Hold it! Stop!\",12,9,100,0,0,0,'Garde', 23906),\r\n(@Maitre,0,4,\"Stop!! Stop!!! Scrap metal moves itself now?\",12,9,100,0,0,0,'Garde', 23907),\r\n(@Maitre,1,2,\"Right... my bad. Now where was I?\",12,9,100,0,0,0,'Garde', 23910),\r\n(@Maitre,1,3,\"All hail the great creator!\",12,9,100,0,0,0,'Garde', 23911),\r\n(@Maitre,1,4,\"You're right, of course. Carry on.\",12,9,100,0,0,0,'Garde', 23912),\r\n(@Maitre,1,5,\"Forgive my insolence!\",12,9,100,0,0,0,'Garde', 23913),\r\n(@Maitre,1,6,\"We will double our efforts!\",12,9,100,0,0,0,'Garde', 23915),\r\n(@Maitre,2,0,\"Destroy earthen infestation.\",12,9,100,0,0,0,'Garde', 23921),\r\n(@Maitre,2,1,\"Wrong answer!\",12,9,100,0,0,0,'Garde', 23908),\r\n(@IRONGolem,0,0,\"Halt! Identify yourself immediately!\",12,9,100,0,0,0,'Garde', 23903),\r\n(@IRONGolem,0,1,\"This section is off-limits!\",12,9,100,0,0,0,'Garde', 23904),\r\n(@IRONGolem,0,2,\"I've never seen one of you around here.\",12,9,100,0,0,0,'Garde', 23905),\r\n(@IRONGolem,0,3,\"Hold it! Stop!\",12,9,100,0,0,0,'Garde', 23906),\r\n(@IRONGolem,0,4,\"Stop!! Stop!!! Scrap metal moves itself now?\",12,9,100,0,0,0,'Garde', 23907),\r\n(@IRONGolem,1,2,\"Right... my bad. Now where was I?\",12,9,100,0,0,0,'Garde', 23910),\r\n(@IRONGolem,1,3,\"All hail the great creator!\",12,9,100,0,0,0,'Garde', 23911),\r\n(@IRONGolem,1,4,\"You're right, of course. Carry on.\",12,9,100,0,0,0,'Garde', 23912),\r\n(@IRONGolem,1,5,\"Forgive my insolence!\",12,9,100,0,0,0,'Garde', 23913),\r\n(@IRONGolem,1,6,\"We will double our efforts!\",12,9,100,0,0,0,'Garde', 23915),\r\n(@IRONGolem,2,0,\"Destroy earthen infestation.\",12,9,100,0,0,0,'Garde', 23921),\r\n(@IRONGolem,2,1,\"Wrong answer!\",12,9,100,0,0,0,'Garde', 23908),\r\n(@IRONGolem,3,0,\"Continue deconstruction.\",12,9,100,0,0,0,'Garde', 23919),\r\n(@IRONGolem,3,1,\"Do not loiter.\",12,9,100,0,0,0,'Garde', 23918),\r\n(@IRONGolem,3,2,\"Work must continue. Double your efforts.\",12,9,100,0,0,0,'Garde', 23916),\r\n(@IRONGolem,3,3,\"Brontes sees all.\",12,9,100,0,0,0,'Garde', 23917),\r\n(@IRONGolem,3,4,\"Reinforcements en route. Function must be unabated.\",12,9,100,0,0,0,'Garde', 23920),\r\n(@IRONGolem,3,5,\"Do you bring word from the creator?\",12,9,100,0,0,0,'Garde', 23914),\r\n(@IRONGolem,3,6,\"All hail the great creator.\",12,9,100,0,0,0,'Garde', 23898);\r\n\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=44609;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES\r\n(13, 1, 44609, 0, 31, 3, 24271, 0, 0, '', 'Bluff target'),\r\n(13, 1, 44609, 1, 31, 3, 23673, 0, 0, '', 'Bluff target'),\r\n(13, 1, 44609, 2, 31, 3, 23672, 0, 0, '', 'Bluff target'),\r\n(13, 1, 44609, 3, 31, 3, 23675, 0, 0, '', 'Bluff target');\r\n\r\nSET @ID := 9024;\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=@ID AND `SourceEntry`=3;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES\r\n(15,@ID,3,0,9,11495,0,0,0,'','Show gossip option if player has quest The Delicate Sound of Thunder'),\r\n(15,@ID,3,1,9,11494,0,0,0,'','Show gossip option if player has quest Lightning Infused Relics');\r\n\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=44610;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES\r\n(13, 1, 44610, 0, 31, 3, 24824, 0, 0, '', 'Collect Data target');\r\n```"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/78491751","html_url":"https://github.com/TrinityCore/TrinityCore/issues/14269#issuecomment-78491751","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14269","id":78491751,"user":{"login":"Rushor","id":5568820,"avatar_url":"https://avatars.githubusercontent.com/u/5568820?v=3","gravatar_id":"","url":"https://api.github.com/users/Rushor","html_url":"https://github.com/Rushor","followers_url":"https://api.github.com/users/Rushor/followers","following_url":"https://api.github.com/users/Rushor/following{/other_user}","gists_url":"https://api.github.com/users/Rushor/gists{/gist_id}","starred_url":"https://api.github.com/users/Rushor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rushor/subscriptions","organizations_url":"https://api.github.com/users/Rushor/orgs","repos_url":"https://api.github.com/users/Rushor/repos","events_url":"https://api.github.com/users/Rushor/events{/privacy}","received_events_url":"https://api.github.com/users/Rushor/received_events","type":"User","site_admin":false},"created_at":"2015-03-12T14:37:25Z","updated_at":"2015-03-12T14:37:25Z","body":"The script is already updated:\r\n```sql\r\n(@LOKEN*100,9,7,0,0,0,100,0,0,0,0,0,11,44682,0,0,0,0,0,21,40,0,0,0,0,0,0,'LOKEN - Action List - Cast Credit'),\r\n```\r\n\r\nreappling the sql adds the distancechange ^^"}}