{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/4458","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/4458/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/4458/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/4458/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/4458","id":2649158,"number":4458,"title":"[QUEST] The Thunderspike (10526)","user":{"login":"nelegalno","id":937520,"avatar_url":"https://avatars.githubusercontent.com/u/937520?v=3","gravatar_id":"","url":"https://api.github.com/users/nelegalno","html_url":"https://github.com/nelegalno","followers_url":"https://api.github.com/users/nelegalno/followers","following_url":"https://api.github.com/users/nelegalno/following{/other_user}","gists_url":"https://api.github.com/users/nelegalno/gists{/gist_id}","starred_url":"https://api.github.com/users/nelegalno/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nelegalno/subscriptions","organizations_url":"https://api.github.com/users/nelegalno/orgs","repos_url":"https://api.github.com/users/nelegalno/repos","events_url":"https://api.github.com/users/nelegalno/events{/privacy}","received_events_url":"https://api.github.com/users/nelegalno/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Feedback-PatchFix","name":"Feedback-PatchFix","color":"d7e102"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Sub-Quests","name":"Sub-Quests","color":"e10c02"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2011-12-23T17:56:48Z","updated_at":"2015-04-06T13:17:53Z","closed_at":"2011-12-25T15:45:11Z","body":"When you try to pick up The Thunderspike GO - Gor Grimgut ( http://old.wowhead.com/npc=21319 ) should spawn but he doesn't appear.\r\n\r\nhash: 3982990"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/90061073","html_url":"https://github.com/TrinityCore/TrinityCore/issues/4458#issuecomment-90061073","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/4458","id":90061073,"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},"created_at":"2015-04-06T13:17:53Z","updated_at":"2015-04-06T13:17:53Z","body":"``` sql\r\nDELETE FROM `event_scripts` WHERE id IN (13685);\r\n\r\nUPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI', `ScriptName`='', `data2`=0, `data3`=120000 WHERE `entry`=184729;\r\nUPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=21319;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=184729 AND `source_type`=1;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=21319 AND `source_type`=0;\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(184729,1,0,0,70,0,100,0,2,0,0,0,12,21319,1,120000,0,0,0,8,0,0,0,1316.748,6695.007,-18.810,5.052,'The Thunderspike -  Activated - Summon Grimgut'),\r\n(21319, 0, 0, 1, 63, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 21, 20, 0, 0, 0, 0, 0,0,'Gor Grimgut- Just Summoned - Talk'),\r\n(21319, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 20, 0, 0, 0, 0, 0,0,'Gor Grimgut- Just Summoned - Attack'),\r\n(21319, 0, 2, 0, 0, 0, 100, 0, 3000, 5000, 7000, 10000, 75, 35492, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0,0,'Gor Grimgut - In Combat - Cast Exhaustion'),\r\n(21319, 0, 3, 0, 0, 0, 100, 0, 10000, 12000, 12000, 15000, 11, 35491, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0,0,'Gor Grimgut - In Combat - Cast Furious Rage');\r\n\r\nDELETE FROM `creature_text` WHERE `entry` IN (21319);\r\nINSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES \r\n(21319, 0, 0, 'Puny $r cannot lift spear.  Gor lift spear!', 12, 0, 100, 0, 0, 0, 18980, 0, 'Gor Grimgut'),\r\n(21319, 0, 1, 'Hah!  The Thunderspike is mine.  Die!', 12, 0, 100, 0, 0, 0, 18979, 0, 'Gor Grimgut');"}}