{"action":"closed","number":6603,"pull_request":{"url":"https://api.github.com/repos/salesagility/SuiteCRM/pulls/6603","id":237985250,"node_id":"MDExOlB1bGxSZXF1ZXN0MjM3OTg1MjUw","html_url":"https://github.com/salesagility/SuiteCRM/pull/6603","diff_url":"https://github.com/salesagility/SuiteCRM/pull/6603.diff","patch_url":"https://github.com/salesagility/SuiteCRM/pull/6603.patch","issue_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/6603","number":6603,"state":"closed","locked":false,"title":"Added/Refactor: Clean MySql Queries in SugarFolders","user":{"login":"code-ph0y","id":542894,"node_id":"MDQ6VXNlcjU0Mjg5NA==","avatar_url":"https://avatars1.githubusercontent.com/u/542894?v=4","gravatar_id":"","url":"https://api.github.com/users/code-ph0y","html_url":"https://github.com/code-ph0y","followers_url":"https://api.github.com/users/code-ph0y/followers","following_url":"https://api.github.com/users/code-ph0y/following{/other_user}","gists_url":"https://api.github.com/users/code-ph0y/gists{/gist_id}","starred_url":"https://api.github.com/users/code-ph0y/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/code-ph0y/subscriptions","organizations_url":"https://api.github.com/users/code-ph0y/orgs","repos_url":"https://api.github.com/users/code-ph0y/repos","events_url":"https://api.github.com/users/code-ph0y/events{/privacy}","received_events_url":"https://api.github.com/users/code-ph0y/received_events","type":"User","site_admin":false},"body":"Fix For My Account Loading Error #5506\r\n\r\n## Description\r\n\r\nThis fix sanitises the data being entered into the queries allowing for special characters to be escaped  \r\n\r\n## Motivation and Context\r\n\r\nBecause it is a security issue and will allow saving data correctly.\r\n\r\n## How To Test This\r\n\r\n## Types of changes\r\n<!--- What types of changes does your code introduce? Put an `x` in all the boxes that apply: -->\r\n- [X] Bug fix (non-breaking change which fixes an issue)\r\n- [ ] New feature (non-breaking change which adds functionality)\r\n- [ ] Breaking change (fix or feature that would cause existing functionality to change)\r\n\r\n### Final checklist\r\n<!--- Go over all the following points and check all the boxes that apply. --->\r\n<!--- If you're unsure about any of these, don't hesitate to ask. We're here to help! --->\r\n- [X] My code follows the code style of this project found [here](https://docs.suitecrm.com/community/contributing-code/coding-standards/).\r\n- [ ] My change requires a change to the documentation.\r\n- [X] I have read the [**How to Contribute**](https://docs.suitecrm.com/community/contributing-code/) guidelines.","created_at":"2018-12-12T10:29:32Z","updated_at":"2018-12-14T10:10:41Z","closed_at":"2018-12-14T10:10:41Z","merged_at":"2018-12-14T10:10:41Z","merge_commit_sha":"7e86c5e2c3930273db3f8a187c31c6f03a48af92","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/salesagility/SuiteCRM/pulls/6603/commits","review_comments_url":"https://api.github.com/repos/salesagility/SuiteCRM/pulls/6603/comments","review_comment_url":"https://api.github.com/repos/salesagility/SuiteCRM/pulls/comments{/number}","comments_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/6603/comments","statuses_url":"https://api.github.com/repos/salesagility/SuiteCRM/statuses/e49fd6f72eef149edff2beb160b740b3545e0c59","head":{"label":"code-ph0y:fix/5506-mail-account-load-error","ref":"fix/5506-mail-account-load-error","sha":"e49fd6f72eef149edff2beb160b740b3545e0c59","user":{"login":"code-ph0y","id":542894,"node_id":"MDQ6VXNlcjU0Mjg5NA==","avatar_url":"https://avatars1.githubusercontent.com/u/542894?v=4","gravatar_id":"","url":"https://api.github.com/users/code-ph0y","html_url":"https://github.com/code-ph0y","followers_url":"https://api.github.com/users/code-ph0y/followers","following_url":"https://api.github.com/users/code-ph0y/following{/other_user}","gists_url":"https://api.github.com/users/code-ph0y/gists{/gist_id}","starred_url":"https://api.github.com/users/code-ph0y/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/code-ph0y/subscriptions","organizations_url":"https://api.github.com/users/code-ph0y/orgs","repos_url":"https://api.github.com/users/code-ph0y/repos","events_url":"https://api.github.com/users/code-ph0y/events{/privacy}","received_events_url":"https://api.github.com/users/code-ph0y/received_events","type":"User","site_admin":false},"repo":{"id":154355508,"node_id":"MDEwOlJlcG9zaXRvcnkxNTQzNTU1MDg=","name":"SuiteCRM","full_name":"code-ph0y/SuiteCRM","private":false,"owner":{"login":"code-ph0y","id":542894,"node_id":"MDQ6VXNlcjU0Mjg5NA==","avatar_url":"https://avatars1.githubusercontent.com/u/542894?v=4","gravatar_id":"","url":"https://api.github.com/users/code-ph0y","html_url":"https://github.com/code-ph0y","followers_url":"https://api.github.com/users/code-ph0y/followers","following_url":"https://api.github.com/users/code-ph0y/following{/other_user}","gists_url":"https://api.github.com/users/code-ph0y/gists{/gist_id}","starred_url":"https://api.github.com/users/code-ph0y/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/code-ph0y/subscriptions","organizations_url":"https://api.github.com/users/code-ph0y/orgs","repos_url":"https://api.github.com/users/code-ph0y/repos","events_url":"https://api.github.com/users/code-ph0y/events{/privacy}","received_events_url":"https://api.github.com/users/code-ph0y/received_events","type":"User","site_admin":false},"html_url":"https://github.com/code-ph0y/SuiteCRM","description":"SuiteCRM - Open source CRM for the world","fork":true,"url":"https://api.github.com/repos/code-ph0y/SuiteCRM","forks_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/forks","keys_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/keys{/key_id}","collaborators_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/teams","hooks_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/hooks","issue_events_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/issues/events{/number}","events_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/events","assignees_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/assignees{/user}","branches_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/branches{/branch}","tags_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/tags","blobs_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/git/refs{/sha}","trees_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/git/trees{/sha}","statuses_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/statuses/{sha}","languages_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/languages","stargazers_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/stargazers","contributors_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/contributors","subscribers_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/subscribers","subscription_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/subscription","commits_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/commits{/sha}","git_commits_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/git/commits{/sha}","comments_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/comments{/number}","issue_comment_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/issues/comments{/number}","contents_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/contents/{+path}","compare_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/compare/{base}...{head}","merges_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/merges","archive_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/downloads","issues_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/issues{/number}","pulls_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/pulls{/number}","milestones_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/milestones{/number}","notifications_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/labels{/name}","releases_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/releases{/id}","deployments_url":"https://api.github.com/repos/code-ph0y/SuiteCRM/deployments","created_at":"2018-10-23T15:47:28Z","updated_at":"2018-11-21T15:30:11Z","pushed_at":"2018-12-13T17:02:02Z","git_url":"git://github.com/code-ph0y/SuiteCRM.git","ssh_url":"git@github.com:code-ph0y/SuiteCRM.git","clone_url":"https://github.com/code-ph0y/SuiteCRM.git","svn_url":"https://github.com/code-ph0y/SuiteCRM","homepage":"https://www.suitecrm.com","size":110706,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"agpl-3.0","name":"GNU Affero General Public License v3.0","spdx_id":"AGPL-3.0","url":"https://api.github.com/licenses/agpl-3.0","node_id":"MDc6TGljZW5zZTE="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"salesagility:hotfix","ref":"hotfix","sha":"dc273555732159507c591aa20fb733dfdcce4f3b","user":{"login":"salesagility","id":1450870,"node_id":"MDEyOk9yZ2FuaXphdGlvbjE0NTA4NzA=","avatar_url":"https://avatars1.githubusercontent.com/u/1450870?v=4","gravatar_id":"","url":"https://api.github.com/users/salesagility","html_url":"https://github.com/salesagility","followers_url":"https://api.github.com/users/salesagility/followers","following_url":"https://api.github.com/users/salesagility/following{/other_user}","gists_url":"https://api.github.com/users/salesagility/gists{/gist_id}","starred_url":"https://api.github.com/users/salesagility/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/salesagility/subscriptions","organizations_url":"https://api.github.com/users/salesagility/orgs","repos_url":"https://api.github.com/users/salesagility/repos","events_url":"https://api.github.com/users/salesagility/events{/privacy}","received_events_url":"https://api.github.com/users/salesagility/received_events","type":"Organization","site_admin":false},"repo":{"id":13044600,"node_id":"MDEwOlJlcG9zaXRvcnkxMzA0NDYwMA==","name":"SuiteCRM","full_name":"salesagility/SuiteCRM","private":false,"owner":{"login":"salesagility","id":1450870,"node_id":"MDEyOk9yZ2FuaXphdGlvbjE0NTA4NzA=","avatar_url":"https://avatars1.githubusercontent.com/u/1450870?v=4","gravatar_id":"","url":"https://api.github.com/users/salesagility","html_url":"https://github.com/salesagility","followers_url":"https://api.github.com/users/salesagility/followers","following_url":"https://api.github.com/users/salesagility/following{/other_user}","gists_url":"https://api.github.com/users/salesagility/gists{/gist_id}","starred_url":"https://api.github.com/users/salesagility/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/salesagility/subscriptions","organizations_url":"https://api.github.com/users/salesagility/orgs","repos_url":"https://api.github.com/users/salesagility/repos","events_url":"https://api.github.com/users/salesagility/events{/privacy}","received_events_url":"https://api.github.com/users/salesagility/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/salesagility/SuiteCRM","description":"SuiteCRM - Open source CRM for the world","fork":false,"url":"https://api.github.com/repos/salesagility/SuiteCRM","forks_url":"https://api.github.com/repos/salesagility/SuiteCRM/forks","keys_url":"https://api.github.com/repos/salesagility/SuiteCRM/keys{/key_id}","collaborators_url":"https://api.github.com/repos/salesagility/SuiteCRM/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/salesagility/SuiteCRM/teams","hooks_url":"https://api.github.com/repos/salesagility/SuiteCRM/hooks","issue_events_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/events{/number}","events_url":"https://api.github.com/repos/salesagility/SuiteCRM/events","assignees_url":"https://api.github.com/repos/salesagility/SuiteCRM/assignees{/user}","branches_url":"https://api.github.com/repos/salesagility/SuiteCRM/branches{/branch}","tags_url":"https://api.github.com/repos/salesagility/SuiteCRM/tags","blobs_url":"https://api.github.com/repos/salesagility/SuiteCRM/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/salesagility/SuiteCRM/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/salesagility/SuiteCRM/git/refs{/sha}","trees_url":"https://api.github.com/repos/salesagility/SuiteCRM/git/trees{/sha}","statuses_url":"https://api.github.com/repos/salesagility/SuiteCRM/statuses/{sha}","languages_url":"https://api.github.com/repos/salesagility/SuiteCRM/languages","stargazers_url":"https://api.github.com/repos/salesagility/SuiteCRM/stargazers","contributors_url":"https://api.github.com/repos/salesagility/SuiteCRM/contributors","subscribers_url":"https://api.github.com/repos/salesagility/SuiteCRM/subscribers","subscription_url":"https://api.github.com/repos/salesagility/SuiteCRM/subscription","commits_url":"https://api.github.com/repos/salesagility/SuiteCRM/commits{/sha}","git_commits_url":"https://api.github.com/repos/salesagility/SuiteCRM/git/commits{/sha}","comments_url":"https://api.github.com/repos/salesagility/SuiteCRM/comments{/number}","issue_comment_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/comments{/number}","contents_url":"https://api.github.com/repos/salesagility/SuiteCRM/contents/{+path}","compare_url":"https://api.github.com/repos/salesagility/SuiteCRM/compare/{base}...{head}","merges_url":"https://api.github.com/repos/salesagility/SuiteCRM/merges","archive_url":"https://api.github.com/repos/salesagility/SuiteCRM/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/salesagility/SuiteCRM/downloads","issues_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues{/number}","pulls_url":"https://api.github.com/repos/salesagility/SuiteCRM/pulls{/number}","milestones_url":"https://api.github.com/repos/salesagility/SuiteCRM/milestones{/number}","notifications_url":"https://api.github.com/repos/salesagility/SuiteCRM/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/salesagility/SuiteCRM/labels{/name}","releases_url":"https://api.github.com/repos/salesagility/SuiteCRM/releases{/id}","deployments_url":"https://api.github.com/repos/salesagility/SuiteCRM/deployments","created_at":"2013-09-23T19:10:08Z","updated_at":"2018-12-13T19:25:30Z","pushed_at":"2018-12-14T10:10:41Z","git_url":"git://github.com/salesagility/SuiteCRM.git","ssh_url":"git@github.com:salesagility/SuiteCRM.git","clone_url":"https://github.com/salesagility/SuiteCRM.git","svn_url":"https://github.com/salesagility/SuiteCRM","homepage":"https://www.suitecrm.com","size":110771,"stargazers_count":1230,"watchers_count":1230,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":934,"mirror_url":null,"archived":false,"open_issues_count":1068,"license":{"key":"agpl-3.0","name":"GNU Affero General Public License v3.0","spdx_id":"AGPL-3.0","url":"https://api.github.com/licenses/agpl-3.0","node_id":"MDc6TGljZW5zZTE="},"forks":934,"open_issues":1068,"watchers":1230,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/salesagility/SuiteCRM/pulls/6603"},"html":{"href":"https://github.com/salesagility/SuiteCRM/pull/6603"},"issue":{"href":"https://api.github.com/repos/salesagility/SuiteCRM/issues/6603"},"comments":{"href":"https://api.github.com/repos/salesagility/SuiteCRM/issues/6603/comments"},"review_comments":{"href":"https://api.github.com/repos/salesagility/SuiteCRM/pulls/6603/comments"},"review_comment":{"href":"https://api.github.com/repos/salesagility/SuiteCRM/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/salesagility/SuiteCRM/pulls/6603/commits"},"statuses":{"href":"https://api.github.com/repos/salesagility/SuiteCRM/statuses/e49fd6f72eef149edff2beb160b740b3545e0c59"}},"author_association":"NONE","merged":true,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":{"login":"samus-aran","id":4041275,"node_id":"MDQ6VXNlcjQwNDEyNzU=","avatar_url":"https://avatars2.githubusercontent.com/u/4041275?v=4","gravatar_id":"","url":"https://api.github.com/users/samus-aran","html_url":"https://github.com/samus-aran","followers_url":"https://api.github.com/users/samus-aran/followers","following_url":"https://api.github.com/users/samus-aran/following{/other_user}","gists_url":"https://api.github.com/users/samus-aran/gists{/gist_id}","starred_url":"https://api.github.com/users/samus-aran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/samus-aran/subscriptions","organizations_url":"https://api.github.com/users/samus-aran/orgs","repos_url":"https://api.github.com/users/samus-aran/repos","events_url":"https://api.github.com/users/samus-aran/events{/privacy}","received_events_url":"https://api.github.com/users/samus-aran/received_events","type":"User","site_admin":false},"comments":2,"review_comments":7,"maintainer_can_modify":false,"commits":7,"additions":1339,"deletions":289,"changed_files":3}}
{"actor":{"display_login":"samus-aran"}}