{"action":"created","comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/comments/108040582","pull_request_review_id":29051702,"id":108040582,"diff_hunk":"@@ -2,6 +2,6 @@ DELETE FROM `spell_areatrigger` WHERE (`SpellMiscId`=5420 AND `AreaTriggerId`=10\n INSERT INTO `spell_areatrigger` (`SpellMiscId`, `AreaTriggerId`, `MoveCurveId`, `ScaleCurveId`, `MorphCurveId`, `FacingCurveId`, `DecalPropertiesId`, `TimeToTarget`, `TimeToTargetScale`, `VerifiedBuild`) VALUES\n (5420, 10133, 0, 0, 0, 0, 0, 0, 7177, 23420); -- SpellId : 5740\n \n-DELETE FROM `spell_script_names` WHERE `spell_id`=5740;\n+DELETE FROM `spell_script_names` WHERE `spell_id`=5740 OR `ScriptName`=\"spell_warl_rain_of_fire\";","path":"sql/updates/world/master/9999_99_99_19345_world.sql","position":null,"original_position":5,"commit_id":"42591e59c87f441f3c9d91fa86dd00437bc9aeac","original_commit_id":"42591e59c87f441f3c9d91fa86dd00437bc9aeac","user":{"login":"ariel-","id":9031719,"avatar_url":"https://avatars0.githubusercontent.com/u/9031719?v=3","gravatar_id":"","url":"https://api.github.com/users/ariel-","html_url":"https://github.com/ariel-","followers_url":"https://api.github.com/users/ariel-/followers","following_url":"https://api.github.com/users/ariel-/following{/other_user}","gists_url":"https://api.github.com/users/ariel-/gists{/gist_id}","starred_url":"https://api.github.com/users/ariel-/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ariel-/subscriptions","organizations_url":"https://api.github.com/users/ariel-/orgs","repos_url":"https://api.github.com/users/ariel-/repos","events_url":"https://api.github.com/users/ariel-/events{/privacy}","received_events_url":"https://api.github.com/users/ariel-/received_events","type":"User","site_admin":false},"body":"OR is not AND, it should delete only by ScriptName, not by spell_id","created_at":"2017-03-25T17:09:28Z","updated_at":"2017-03-25T17:09:28Z","html_url":"https://github.com/TrinityCore/TrinityCore/pull/19345#discussion_r108040582","pull_request_url":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/19345","_links":{"self":{"href":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/comments/108040582"},"html":{"href":"https://github.com/TrinityCore/TrinityCore/pull/19345#discussion_r108040582"},"pull_request":{"href":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/19345"}}},"pull_request":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/19345","id":111906936,"html_url":"https://github.com/TrinityCore/TrinityCore/pull/19345","diff_url":"https://github.com/TrinityCore/TrinityCore/pull/19345.diff","patch_url":"https://github.com/TrinityCore/TrinityCore/pull/19345.patch","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/19345","number":19345,"state":"open","locked":false,"title":"Scripts/Spells: Warlock Rain of Fire","user":{"login":"Traesh","id":9392905,"avatar_url":"https://avatars3.githubusercontent.com/u/9392905?v=3","gravatar_id":"","url":"https://api.github.com/users/Traesh","html_url":"https://github.com/Traesh","followers_url":"https://api.github.com/users/Traesh/followers","following_url":"https://api.github.com/users/Traesh/following{/other_user}","gists_url":"https://api.github.com/users/Traesh/gists{/gist_id}","starred_url":"https://api.github.com/users/Traesh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Traesh/subscriptions","organizations_url":"https://api.github.com/users/Traesh/orgs","repos_url":"https://api.github.com/users/Traesh/repos","events_url":"https://api.github.com/users/Traesh/events{/privacy}","received_events_url":"https://api.github.com/users/Traesh/received_events","type":"User","site_admin":false},"body":"**Changes proposed:**\r\n\r\n-  Fix Warlock spell \"Rain of Fire\" (http://www.wowhead.com/spell=5740). The Warlock can have multiple \"Rain of Fire\" areatrigger spawned, but a single target will always receive damage only once per tick\r\n-  Minor cleanup (delete 1 old spell, removed from game)\r\n\r\n**Target branch(es):**\r\n\r\n- [x] master\r\n\r\n**Issues addressed:** None\r\n\r\n\r\n**Tests performed:** (Does it build, tested in-game, etc.)\r\nCompiled, tested ingame\r\n\r\n**Known issues and TODO list:**\r\n- None","created_at":"2017-03-22T00:06:32Z","updated_at":"2017-03-25T17:09:28Z","closed_at":null,"merged_at":null,"merge_commit_sha":"8d9e0cbe68c08756f681c017cdd2512a1bd23210","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/19345/commits","review_comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/19345/comments","review_comment_url":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/comments{/number}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/19345/comments","statuses_url":"https://api.github.com/repos/TrinityCore/TrinityCore/statuses/42591e59c87f441f3c9d91fa86dd00437bc9aeac","head":{"label":"Traesh:spell_warl_rain_of_fire","ref":"spell_warl_rain_of_fire","sha":"42591e59c87f441f3c9d91fa86dd00437bc9aeac","user":{"login":"Traesh","id":9392905,"avatar_url":"https://avatars3.githubusercontent.com/u/9392905?v=3","gravatar_id":"","url":"https://api.github.com/users/Traesh","html_url":"https://github.com/Traesh","followers_url":"https://api.github.com/users/Traesh/followers","following_url":"https://api.github.com/users/Traesh/following{/other_user}","gists_url":"https://api.github.com/users/Traesh/gists{/gist_id}","starred_url":"https://api.github.com/users/Traesh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Traesh/subscriptions","organizations_url":"https://api.github.com/users/Traesh/orgs","repos_url":"https://api.github.com/users/Traesh/repos","events_url":"https://api.github.com/users/Traesh/events{/privacy}","received_events_url":"https://api.github.com/users/Traesh/received_events","type":"User","site_admin":false},"repo":{"id":69283017,"name":"TrinityCore","full_name":"Traesh/TrinityCore","owner":{"login":"Traesh","id":9392905,"avatar_url":"https://avatars3.githubusercontent.com/u/9392905?v=3","gravatar_id":"","url":"https://api.github.com/users/Traesh","html_url":"https://github.com/Traesh","followers_url":"https://api.github.com/users/Traesh/followers","following_url":"https://api.github.com/users/Traesh/following{/other_user}","gists_url":"https://api.github.com/users/Traesh/gists{/gist_id}","starred_url":"https://api.github.com/users/Traesh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Traesh/subscriptions","organizations_url":"https://api.github.com/users/Traesh/orgs","repos_url":"https://api.github.com/users/Traesh/repos","events_url":"https://api.github.com/users/Traesh/events{/privacy}","received_events_url":"https://api.github.com/users/Traesh/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/Traesh/TrinityCore","description":"TrinityCore Open Source MMO Framework","fork":true,"url":"https://api.github.com/repos/Traesh/TrinityCore","forks_url":"https://api.github.com/repos/Traesh/TrinityCore/forks","keys_url":"https://api.github.com/repos/Traesh/TrinityCore/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Traesh/TrinityCore/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Traesh/TrinityCore/teams","hooks_url":"https://api.github.com/repos/Traesh/TrinityCore/hooks","issue_events_url":"https://api.github.com/repos/Traesh/TrinityCore/issues/events{/number}","events_url":"https://api.github.com/repos/Traesh/TrinityCore/events","assignees_url":"https://api.github.com/repos/Traesh/TrinityCore/assignees{/user}","branches_url":"https://api.github.com/repos/Traesh/TrinityCore/branches{/branch}","tags_url":"https://api.github.com/repos/Traesh/TrinityCore/tags","blobs_url":"https://api.github.com/repos/Traesh/TrinityCore/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Traesh/TrinityCore/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Traesh/TrinityCore/git/refs{/sha}","trees_url":"https://api.github.com/repos/Traesh/TrinityCore/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Traesh/TrinityCore/statuses/{sha}","languages_url":"https://api.github.com/repos/Traesh/TrinityCore/languages","stargazers_url":"https://api.github.com/repos/Traesh/TrinityCore/stargazers","contributors_url":"https://api.github.com/repos/Traesh/TrinityCore/contributors","subscribers_url":"https://api.github.com/repos/Traesh/TrinityCore/subscribers","subscription_url":"https://api.github.com/repos/Traesh/TrinityCore/subscription","commits_url":"https://api.github.com/repos/Traesh/TrinityCore/commits{/sha}","git_commits_url":"https://api.github.com/repos/Traesh/TrinityCore/git/commits{/sha}","comments_url":"https://api.github.com/repos/Traesh/TrinityCore/comments{/number}","issue_comment_url":"https://api.github.com/repos/Traesh/TrinityCore/issues/comments{/number}","contents_url":"https://api.github.com/repos/Traesh/TrinityCore/contents/{+path}","compare_url":"https://api.github.com/repos/Traesh/TrinityCore/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Traesh/TrinityCore/merges","archive_url":"https://api.github.com/repos/Traesh/TrinityCore/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Traesh/TrinityCore/downloads","issues_url":"https://api.github.com/repos/Traesh/TrinityCore/issues{/number}","pulls_url":"https://api.github.com/repos/Traesh/TrinityCore/pulls{/number}","milestones_url":"https://api.github.com/repos/Traesh/TrinityCore/milestones{/number}","notifications_url":"https://api.github.com/repos/Traesh/TrinityCore/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Traesh/TrinityCore/labels{/name}","releases_url":"https://api.github.com/repos/Traesh/TrinityCore/releases{/id}","deployments_url":"https://api.github.com/repos/Traesh/TrinityCore/deployments","created_at":"2016-09-26T19:01:21Z","updated_at":"2017-03-10T18:09:32Z","pushed_at":"2017-03-25T13:26:48Z","git_url":"git://github.com/Traesh/TrinityCore.git","ssh_url":"git@github.com:Traesh/TrinityCore.git","clone_url":"https://github.com/Traesh/TrinityCore.git","svn_url":"https://github.com/Traesh/TrinityCore","homepage":"http://www.trinitycore.org","size":408653,"stargazers_count":1,"watchers_count":1,"language":"C++","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":0,"forks":1,"open_issues":0,"watchers":1,"default_branch":"master"}},"base":{"label":"TrinityCore:master","ref":"master","sha":"464ba05dd4ba6f37762fcabd909c1d58748621e8","user":{"login":"TrinityCore","id":539602,"avatar_url":"https://avatars0.githubusercontent.com/u/539602?v=3","gravatar_id":"","url":"https://api.github.com/users/TrinityCore","html_url":"https://github.com/TrinityCore","followers_url":"https://api.github.com/users/TrinityCore/followers","following_url":"https://api.github.com/users/TrinityCore/following{/other_user}","gists_url":"https://api.github.com/users/TrinityCore/gists{/gist_id}","starred_url":"https://api.github.com/users/TrinityCore/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TrinityCore/subscriptions","organizations_url":"https://api.github.com/users/TrinityCore/orgs","repos_url":"https://api.github.com/users/TrinityCore/repos","events_url":"https://api.github.com/users/TrinityCore/events{/privacy}","received_events_url":"https://api.github.com/users/TrinityCore/received_events","type":"Organization","site_admin":false},"repo":{"id":1204412,"name":"TrinityCore","full_name":"TrinityCore/TrinityCore","owner":{"login":"TrinityCore","id":539602,"avatar_url":"https://avatars0.githubusercontent.com/u/539602?v=3","gravatar_id":"","url":"https://api.github.com/users/TrinityCore","html_url":"https://github.com/TrinityCore","followers_url":"https://api.github.com/users/TrinityCore/followers","following_url":"https://api.github.com/users/TrinityCore/following{/other_user}","gists_url":"https://api.github.com/users/TrinityCore/gists{/gist_id}","starred_url":"https://api.github.com/users/TrinityCore/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TrinityCore/subscriptions","organizations_url":"https://api.github.com/users/TrinityCore/orgs","repos_url":"https://api.github.com/users/TrinityCore/repos","events_url":"https://api.github.com/users/TrinityCore/events{/privacy}","received_events_url":"https://api.github.com/users/TrinityCore/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/TrinityCore/TrinityCore","description":"TrinityCore Open Source MMO Framework","fork":false,"url":"https://api.github.com/repos/TrinityCore/TrinityCore","forks_url":"https://api.github.com/repos/TrinityCore/TrinityCore/forks","keys_url":"https://api.github.com/repos/TrinityCore/TrinityCore/keys{/key_id}","collaborators_url":"https://api.github.com/repos/TrinityCore/TrinityCore/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/TrinityCore/TrinityCore/teams","hooks_url":"https://api.github.com/repos/TrinityCore/TrinityCore/hooks","issue_events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/events{/number}","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/events","assignees_url":"https://api.github.com/repos/TrinityCore/TrinityCore/assignees{/user}","branches_url":"https://api.github.com/repos/TrinityCore/TrinityCore/branches{/branch}","tags_url":"https://api.github.com/repos/TrinityCore/TrinityCore/tags","blobs_url":"https://api.github.com/repos/TrinityCore/TrinityCore/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/TrinityCore/TrinityCore/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/TrinityCore/TrinityCore/git/refs{/sha}","trees_url":"https://api.github.com/repos/TrinityCore/TrinityCore/git/trees{/sha}","statuses_url":"https://api.github.com/repos/TrinityCore/TrinityCore/statuses/{sha}","languages_url":"https://api.github.com/repos/TrinityCore/TrinityCore/languages","stargazers_url":"https://api.github.com/repos/TrinityCore/TrinityCore/stargazers","contributors_url":"https://api.github.com/repos/TrinityCore/TrinityCore/contributors","subscribers_url":"https://api.github.com/repos/TrinityCore/TrinityCore/subscribers","subscription_url":"https://api.github.com/repos/TrinityCore/TrinityCore/subscription","commits_url":"https://api.github.com/repos/TrinityCore/TrinityCore/commits{/sha}","git_commits_url":"https://api.github.com/repos/TrinityCore/TrinityCore/git/commits{/sha}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/comments{/number}","issue_comment_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments{/number}","contents_url":"https://api.github.com/repos/TrinityCore/TrinityCore/contents/{+path}","compare_url":"https://api.github.com/repos/TrinityCore/TrinityCore/compare/{base}...{head}","merges_url":"https://api.github.com/repos/TrinityCore/TrinityCore/merges","archive_url":"https://api.github.com/repos/TrinityCore/TrinityCore/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/TrinityCore/TrinityCore/downloads","issues_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues{/number}","pulls_url":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls{/number}","milestones_url":"https://api.github.com/repos/TrinityCore/TrinityCore/milestones{/number}","notifications_url":"https://api.github.com/repos/TrinityCore/TrinityCore/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels{/name}","releases_url":"https://api.github.com/repos/TrinityCore/TrinityCore/releases{/id}","deployments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/deployments","created_at":"2010-12-28T23:40:07Z","updated_at":"2017-03-25T16:22:39Z","pushed_at":"2017-03-25T16:54:20Z","git_url":"git://github.com/TrinityCore/TrinityCore.git","ssh_url":"git@github.com:TrinityCore/TrinityCore.git","clone_url":"https://github.com/TrinityCore/TrinityCore.git","svn_url":"https://github.com/TrinityCore/TrinityCore","homepage":"http://www.trinitycore.org","size":424302,"stargazers_count":3717,"watchers_count":3717,"language":"C++","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":3721,"mirror_url":null,"open_issues_count":1315,"forks":3721,"open_issues":1315,"watchers":3717,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/19345"},"html":{"href":"https://github.com/TrinityCore/TrinityCore/pull/19345"},"issue":{"href":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/19345"},"comments":{"href":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/19345/comments"},"review_comments":{"href":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/19345/comments"},"review_comment":{"href":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/19345/commits"},"statuses":{"href":"https://api.github.com/repos/TrinityCore/TrinityCore/statuses/42591e59c87f441f3c9d91fa86dd00437bc9aeac"}}}}
{"actor":{"display_login":"ariel-"}}