{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14411","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14411/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14411/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14411/events","html_url":"https://github.com/TrinityCore/TrinityCore/pull/14411","id":63109462,"number":14411,"title":"FIX - Quest - Exorcism of Colonel Jules","user":{"login":"danlapps","id":10377775,"avatar_url":"https://avatars.githubusercontent.com/u/10377775?v=3","gravatar_id":"","url":"https://api.github.com/users/danlapps","html_url":"https://github.com/danlapps","followers_url":"https://api.github.com/users/danlapps/followers","following_url":"https://api.github.com/users/danlapps/following{/other_user}","gists_url":"https://api.github.com/users/danlapps/gists{/gist_id}","starred_url":"https://api.github.com/users/danlapps/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danlapps/subscriptions","organizations_url":"https://api.github.com/users/danlapps/orgs","repos_url":"https://api.github.com/users/danlapps/repos","events_url":"https://api.github.com/users/danlapps/events{/privacy}","received_events_url":"https://api.github.com/users/danlapps/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Feedback-PatchFix","name":"Feedback-PatchFix","color":"d7e102"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-19T22:53:12Z","updated_at":"2015-03-19T23:42:04Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/14411","html_url":"https://github.com/TrinityCore/TrinityCore/pull/14411","diff_url":"https://github.com/TrinityCore/TrinityCore/pull/14411.diff","patch_url":"https://github.com/TrinityCore/TrinityCore/pull/14411.patch"},"body":"Taken from https://github.com/WoW-Studio/TrinityCore/commit/0aa81ca7a0e1ef69728a7e16ce47915324e35949\r\n\r\n```SQL\r\nUPDATE `creature_template` SET `ScriptName`= 'npc_barada' WHERE `entry`= 22431;\r\nUPDATE `creature_template` SET `ScriptName`= 'npc_colonel_jules' WHERE `entry`= 22431;\r\n\r\nDELETE FROM `creature_text` WHERE `entry` IN(22431, 22432);\r\n\r\n-- Barada\r\nINSERT INTO `creature_text` VALUES (22431, 0, 0, 'It is time. The rite of exorcism will now commence...', 12, 0, 100, 0, 0, 0, 'Barada', 0);\r\nINSERT INTO `creature_text` VALUES (22431, 1, 0, 'Prepare yourself. Do not allow the ritual to be interrupted or we may lose our patient...', 12, 0, 100, 0, 0, 0, 'Barada', 0);\r\nINSERT INTO `creature_text` VALUES (22431, 2, 0, 'Back foul beings of darkness! You have no power here!', 12, 0, 100, 0, 0, 0, 'Barada', 0);\r\nINSERT INTO `creature_text` VALUES (22431, 3, 0, 'I... must not... falter', 12, 0, 100, 0, 0, 0, 'Barada', 0);\r\nINSERT INTO `creature_text` VALUES (22431, 4, 0, 'The Light is my guide... it is my sustenance!', 12, 0, 100, 0, 0, 0, 'Barada', 0);\r\nINSERT INTO `creature_text` VALUES (22431, 5, 0, 'The power of light compells you! Back to your pit!', 12, 0, 100, 0, 0, 0, 'Barada', 0);\r\nINSERT INTO `creature_text` VALUES (22431, 6, 0, 'Be cleansed with Light, human! Let not the demonic corruption overwhelm you.', 12, 0, 100, 0, 0, 0, 'Barada', 0);\r\nINSERT INTO `creature_text` VALUES (22431, 7, 0, 'Back! I cast you back... corruptor of faith! Author of pain! Do not return, or suffer the same fate as you did here today!', 12, 0, 100, 0, 0, 0, 'Barada', 0);\r\n\r\n-- Colonel Jules\r\nINSERT INTO `creature_text` VALUES (22432, 0, 0, 'Keep away. The fool is mine.', 12, 0, 100, 0, 0, 0, 'Colonel Jules', 0);\r\nINSERT INTO `creature_text` VALUES (22432, 1, 0, 'Ah! Cease the incantations, Anchorite! Cease, or I will show you such pain that your pathetic people have never imagined!', 12, 0, 100, 0, 0, 0, 'Colonel Jules', 0);\r\nINSERT INTO `creature_text` VALUES (22432, 2, 0, 'This is fruitless, draenei! You and your little helper cannot wrest control of this pathetic human. He is mine!', 12, 0, 100, 0, 0, 0, 'Colonel Jules', 0);\r\nINSERT INTO `creature_text` VALUES (22432, 3, 0, 'I see your ancestors, Anchorite! They writhe and scream in the darkness... they are with us!', 12, 0, 100, 0, 0, 0, 'Colonel Jules', 0);\r\nINSERT INTO `creature_text` VALUES (22432, 4, 0, 'I will tear your soul into morsels and slow roast them over demon fire.', 12, 0, 100, 0, 0, 0, 'Colonel Jules', 0);\r\n```"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/83810405","html_url":"https://github.com/TrinityCore/TrinityCore/pull/14411#issuecomment-83810405","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14411","id":83810405,"user":{"login":"Nyeriah","id":2879479,"avatar_url":"https://avatars.githubusercontent.com/u/2879479?v=3","gravatar_id":"","url":"https://api.github.com/users/Nyeriah","html_url":"https://github.com/Nyeriah","followers_url":"https://api.github.com/users/Nyeriah/followers","following_url":"https://api.github.com/users/Nyeriah/following{/other_user}","gists_url":"https://api.github.com/users/Nyeriah/gists{/gist_id}","starred_url":"https://api.github.com/users/Nyeriah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Nyeriah/subscriptions","organizations_url":"https://api.github.com/users/Nyeriah/orgs","repos_url":"https://api.github.com/users/Nyeriah/repos","events_url":"https://api.github.com/users/Nyeriah/events{/privacy}","received_events_url":"https://api.github.com/users/Nyeriah/received_events","type":"User","site_admin":false},"created_at":"2015-03-19T23:42:04Z","updated_at":"2015-03-19T23:42:04Z","body":"There are minor things to solve but otherwise it looks cool"}}