{"action":"created","comment":{"url":"https://api.github.com/repos/ChurchCRM/CRM/pulls/comments/48612022","id":48612022,"diff_hunk":"@@ -1,49 +1,41 @@\n <?php\n \n class FamilyService {\n-\n     function search($searchTerm) {\n-       $fetch = 'SELECT fam_ID, fam_Name, fam_City, fam_State FROM family_fam WHERE family_fam.fam_Name LIKE \\'%'.$searchTerm.'%\\' LIMIT 15';\n-       $result=mysql_query($fetch);\n-\n+        $fetch = 'SELECT fam_ID, fam_Name, fam_City, fam_State FROM family_fam WHERE family_fam.fam_Name LIKE \\'%'.$searchTerm.'%\\' LIMIT 15';\n+        $result=mysql_query($fetch);\n         $families = array();\n         while($row=mysql_fetch_array($result)) {\n             $row_array['id']=$row['fam_ID'];\n             $row_array['familyName']=$row['fam_Name'];\n             $row_array['city']=$row['fam_City'];\n             $row_array['displayName']=$row['fam_Name'].\" - \".$row['fam_City'];\n-\n+            $row_array['uri'] = \"FamilyView.php?FamilyID=\".$row['fam_ID'];","path":"churchinfo/service/FamilyService.php","position":18,"original_position":18,"commit_id":"a57eed939d40d44e97409794cdb3e826c1b2214e","original_commit_id":"a57eed939d40d44e97409794cdb3e826c1b2214e","user":{"login":"DawoudIO","id":554959,"avatar_url":"https://avatars.githubusercontent.com/u/554959?v=3","gravatar_id":"","url":"https://api.github.com/users/DawoudIO","html_url":"https://github.com/DawoudIO","followers_url":"https://api.github.com/users/DawoudIO/followers","following_url":"https://api.github.com/users/DawoudIO/following{/other_user}","gists_url":"https://api.github.com/users/DawoudIO/gists{/gist_id}","starred_url":"https://api.github.com/users/DawoudIO/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DawoudIO/subscriptions","organizations_url":"https://api.github.com/users/DawoudIO/orgs","repos_url":"https://api.github.com/users/DawoudIO/repos","events_url":"https://api.github.com/users/DawoudIO/events{/privacy}","received_events_url":"https://api.github.com/users/DawoudIO/received_events","type":"User","site_admin":false},"body":"ok... i can see how this is better","created_at":"2015-12-30T16:02:02Z","updated_at":"2015-12-30T16:02:02Z","html_url":"https://github.com/ChurchCRM/CRM/pull/123#discussion_r48612022","pull_request_url":"https://api.github.com/repos/ChurchCRM/CRM/pulls/123","_links":{"self":{"href":"https://api.github.com/repos/ChurchCRM/CRM/pulls/comments/48612022"},"html":{"href":"https://github.com/ChurchCRM/CRM/pull/123#discussion_r48612022"},"pull_request":{"href":"https://api.github.com/repos/ChurchCRM/CRM/pulls/123"}}},"pull_request":{"url":"https://api.github.com/repos/ChurchCRM/CRM/pulls/123","id":54775011,"html_url":"https://github.com/ChurchCRM/CRM/pull/123","diff_url":"https://github.com/ChurchCRM/CRM/pull/123.diff","patch_url":"https://github.com/ChurchCRM/CRM/pull/123.patch","issue_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/123","number":123,"state":"open","locked":false,"title":"Feature/omnisearch","user":{"login":"crossan007","id":11679900,"avatar_url":"https://avatars.githubusercontent.com/u/11679900?v=3","gravatar_id":"","url":"https://api.github.com/users/crossan007","html_url":"https://github.com/crossan007","followers_url":"https://api.github.com/users/crossan007/followers","following_url":"https://api.github.com/users/crossan007/following{/other_user}","gists_url":"https://api.github.com/users/crossan007/gists{/gist_id}","starred_url":"https://api.github.com/users/crossan007/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crossan007/subscriptions","organizations_url":"https://api.github.com/users/crossan007/orgs","repos_url":"https://api.github.com/users/crossan007/repos","events_url":"https://api.github.com/users/crossan007/events{/privacy}","received_events_url":"https://api.github.com/users/crossan007/received_events","type":"User","site_admin":false},"body":"Search both Families and Persons from the upper left search box.","created_at":"2015-12-30T03:19:48Z","updated_at":"2015-12-30T16:02:02Z","closed_at":null,"merged_at":null,"merge_commit_sha":"be69f3cdcd30f967fb78a427288b4d0617257596","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/ChurchCRM/CRM/pulls/123/commits","review_comments_url":"https://api.github.com/repos/ChurchCRM/CRM/pulls/123/comments","review_comment_url":"https://api.github.com/repos/ChurchCRM/CRM/pulls/comments{/number}","comments_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/123/comments","statuses_url":"https://api.github.com/repos/ChurchCRM/CRM/statuses/a57eed939d40d44e97409794cdb3e826c1b2214e","head":{"label":"ChurchCRM:feature/omnisearch","ref":"feature/omnisearch","sha":"a57eed939d40d44e97409794cdb3e826c1b2214e","user":{"login":"ChurchCRM","id":11025185,"avatar_url":"https://avatars.githubusercontent.com/u/11025185?v=3","gravatar_id":"","url":"https://api.github.com/users/ChurchCRM","html_url":"https://github.com/ChurchCRM","followers_url":"https://api.github.com/users/ChurchCRM/followers","following_url":"https://api.github.com/users/ChurchCRM/following{/other_user}","gists_url":"https://api.github.com/users/ChurchCRM/gists{/gist_id}","starred_url":"https://api.github.com/users/ChurchCRM/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ChurchCRM/subscriptions","organizations_url":"https://api.github.com/users/ChurchCRM/orgs","repos_url":"https://api.github.com/users/ChurchCRM/repos","events_url":"https://api.github.com/users/ChurchCRM/events{/privacy}","received_events_url":"https://api.github.com/users/ChurchCRM/received_events","type":"Organization","site_admin":false},"repo":{"id":30856851,"name":"CRM","full_name":"ChurchCRM/CRM","owner":{"login":"ChurchCRM","id":11025185,"avatar_url":"https://avatars.githubusercontent.com/u/11025185?v=3","gravatar_id":"","url":"https://api.github.com/users/ChurchCRM","html_url":"https://github.com/ChurchCRM","followers_url":"https://api.github.com/users/ChurchCRM/followers","following_url":"https://api.github.com/users/ChurchCRM/following{/other_user}","gists_url":"https://api.github.com/users/ChurchCRM/gists{/gist_id}","starred_url":"https://api.github.com/users/ChurchCRM/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ChurchCRM/subscriptions","organizations_url":"https://api.github.com/users/ChurchCRM/orgs","repos_url":"https://api.github.com/users/ChurchCRM/repos","events_url":"https://api.github.com/users/ChurchCRM/events{/privacy}","received_events_url":"https://api.github.com/users/ChurchCRM/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ChurchCRM/CRM","description":"ChurchWebCRM is a Fork of the ChurchInfo project, it uses ChurchInfo as  the starting point and adds new features and responsive UI.","fork":true,"url":"https://api.github.com/repos/ChurchCRM/CRM","forks_url":"https://api.github.com/repos/ChurchCRM/CRM/forks","keys_url":"https://api.github.com/repos/ChurchCRM/CRM/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ChurchCRM/CRM/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ChurchCRM/CRM/teams","hooks_url":"https://api.github.com/repos/ChurchCRM/CRM/hooks","issue_events_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/events{/number}","events_url":"https://api.github.com/repos/ChurchCRM/CRM/events","assignees_url":"https://api.github.com/repos/ChurchCRM/CRM/assignees{/user}","branches_url":"https://api.github.com/repos/ChurchCRM/CRM/branches{/branch}","tags_url":"https://api.github.com/repos/ChurchCRM/CRM/tags","blobs_url":"https://api.github.com/repos/ChurchCRM/CRM/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ChurchCRM/CRM/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ChurchCRM/CRM/git/refs{/sha}","trees_url":"https://api.github.com/repos/ChurchCRM/CRM/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ChurchCRM/CRM/statuses/{sha}","languages_url":"https://api.github.com/repos/ChurchCRM/CRM/languages","stargazers_url":"https://api.github.com/repos/ChurchCRM/CRM/stargazers","contributors_url":"https://api.github.com/repos/ChurchCRM/CRM/contributors","subscribers_url":"https://api.github.com/repos/ChurchCRM/CRM/subscribers","subscription_url":"https://api.github.com/repos/ChurchCRM/CRM/subscription","commits_url":"https://api.github.com/repos/ChurchCRM/CRM/commits{/sha}","git_commits_url":"https://api.github.com/repos/ChurchCRM/CRM/git/commits{/sha}","comments_url":"https://api.github.com/repos/ChurchCRM/CRM/comments{/number}","issue_comment_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/comments{/number}","contents_url":"https://api.github.com/repos/ChurchCRM/CRM/contents/{+path}","compare_url":"https://api.github.com/repos/ChurchCRM/CRM/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ChurchCRM/CRM/merges","archive_url":"https://api.github.com/repos/ChurchCRM/CRM/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ChurchCRM/CRM/downloads","issues_url":"https://api.github.com/repos/ChurchCRM/CRM/issues{/number}","pulls_url":"https://api.github.com/repos/ChurchCRM/CRM/pulls{/number}","milestones_url":"https://api.github.com/repos/ChurchCRM/CRM/milestones{/number}","notifications_url":"https://api.github.com/repos/ChurchCRM/CRM/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ChurchCRM/CRM/labels{/name}","releases_url":"https://api.github.com/repos/ChurchCRM/CRM/releases{/id}","created_at":"2015-02-16T06:38:40Z","updated_at":"2015-12-24T03:20:40Z","pushed_at":"2015-12-30T15:59:35Z","git_url":"git://github.com/ChurchCRM/CRM.git","ssh_url":"git@github.com:ChurchCRM/CRM.git","clone_url":"https://github.com/ChurchCRM/CRM.git","svn_url":"https://github.com/ChurchCRM/CRM","homepage":"http://www.ChurchCRM.io","size":11211,"stargazers_count":8,"watchers_count":8,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":8,"mirror_url":null,"open_issues_count":42,"forks":8,"open_issues":42,"watchers":8,"default_branch":"master"}},"base":{"label":"ChurchCRM:develop","ref":"develop","sha":"593789591d37b61d5f844d7b82faa78ea0548f9f","user":{"login":"ChurchCRM","id":11025185,"avatar_url":"https://avatars.githubusercontent.com/u/11025185?v=3","gravatar_id":"","url":"https://api.github.com/users/ChurchCRM","html_url":"https://github.com/ChurchCRM","followers_url":"https://api.github.com/users/ChurchCRM/followers","following_url":"https://api.github.com/users/ChurchCRM/following{/other_user}","gists_url":"https://api.github.com/users/ChurchCRM/gists{/gist_id}","starred_url":"https://api.github.com/users/ChurchCRM/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ChurchCRM/subscriptions","organizations_url":"https://api.github.com/users/ChurchCRM/orgs","repos_url":"https://api.github.com/users/ChurchCRM/repos","events_url":"https://api.github.com/users/ChurchCRM/events{/privacy}","received_events_url":"https://api.github.com/users/ChurchCRM/received_events","type":"Organization","site_admin":false},"repo":{"id":30856851,"name":"CRM","full_name":"ChurchCRM/CRM","owner":{"login":"ChurchCRM","id":11025185,"avatar_url":"https://avatars.githubusercontent.com/u/11025185?v=3","gravatar_id":"","url":"https://api.github.com/users/ChurchCRM","html_url":"https://github.com/ChurchCRM","followers_url":"https://api.github.com/users/ChurchCRM/followers","following_url":"https://api.github.com/users/ChurchCRM/following{/other_user}","gists_url":"https://api.github.com/users/ChurchCRM/gists{/gist_id}","starred_url":"https://api.github.com/users/ChurchCRM/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ChurchCRM/subscriptions","organizations_url":"https://api.github.com/users/ChurchCRM/orgs","repos_url":"https://api.github.com/users/ChurchCRM/repos","events_url":"https://api.github.com/users/ChurchCRM/events{/privacy}","received_events_url":"https://api.github.com/users/ChurchCRM/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ChurchCRM/CRM","description":"ChurchWebCRM is a Fork of the ChurchInfo project, it uses ChurchInfo as  the starting point and adds new features and responsive UI.","fork":true,"url":"https://api.github.com/repos/ChurchCRM/CRM","forks_url":"https://api.github.com/repos/ChurchCRM/CRM/forks","keys_url":"https://api.github.com/repos/ChurchCRM/CRM/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ChurchCRM/CRM/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ChurchCRM/CRM/teams","hooks_url":"https://api.github.com/repos/ChurchCRM/CRM/hooks","issue_events_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/events{/number}","events_url":"https://api.github.com/repos/ChurchCRM/CRM/events","assignees_url":"https://api.github.com/repos/ChurchCRM/CRM/assignees{/user}","branches_url":"https://api.github.com/repos/ChurchCRM/CRM/branches{/branch}","tags_url":"https://api.github.com/repos/ChurchCRM/CRM/tags","blobs_url":"https://api.github.com/repos/ChurchCRM/CRM/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ChurchCRM/CRM/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ChurchCRM/CRM/git/refs{/sha}","trees_url":"https://api.github.com/repos/ChurchCRM/CRM/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ChurchCRM/CRM/statuses/{sha}","languages_url":"https://api.github.com/repos/ChurchCRM/CRM/languages","stargazers_url":"https://api.github.com/repos/ChurchCRM/CRM/stargazers","contributors_url":"https://api.github.com/repos/ChurchCRM/CRM/contributors","subscribers_url":"https://api.github.com/repos/ChurchCRM/CRM/subscribers","subscription_url":"https://api.github.com/repos/ChurchCRM/CRM/subscription","commits_url":"https://api.github.com/repos/ChurchCRM/CRM/commits{/sha}","git_commits_url":"https://api.github.com/repos/ChurchCRM/CRM/git/commits{/sha}","comments_url":"https://api.github.com/repos/ChurchCRM/CRM/comments{/number}","issue_comment_url":"https://api.github.com/repos/ChurchCRM/CRM/issues/comments{/number}","contents_url":"https://api.github.com/repos/ChurchCRM/CRM/contents/{+path}","compare_url":"https://api.github.com/repos/ChurchCRM/CRM/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ChurchCRM/CRM/merges","archive_url":"https://api.github.com/repos/ChurchCRM/CRM/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ChurchCRM/CRM/downloads","issues_url":"https://api.github.com/repos/ChurchCRM/CRM/issues{/number}","pulls_url":"https://api.github.com/repos/ChurchCRM/CRM/pulls{/number}","milestones_url":"https://api.github.com/repos/ChurchCRM/CRM/milestones{/number}","notifications_url":"https://api.github.com/repos/ChurchCRM/CRM/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ChurchCRM/CRM/labels{/name}","releases_url":"https://api.github.com/repos/ChurchCRM/CRM/releases{/id}","created_at":"2015-02-16T06:38:40Z","updated_at":"2015-12-24T03:20:40Z","pushed_at":"2015-12-30T15:59:35Z","git_url":"git://github.com/ChurchCRM/CRM.git","ssh_url":"git@github.com:ChurchCRM/CRM.git","clone_url":"https://github.com/ChurchCRM/CRM.git","svn_url":"https://github.com/ChurchCRM/CRM","homepage":"http://www.ChurchCRM.io","size":11211,"stargazers_count":8,"watchers_count":8,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":8,"mirror_url":null,"open_issues_count":42,"forks":8,"open_issues":42,"watchers":8,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/ChurchCRM/CRM/pulls/123"},"html":{"href":"https://github.com/ChurchCRM/CRM/pull/123"},"issue":{"href":"https://api.github.com/repos/ChurchCRM/CRM/issues/123"},"comments":{"href":"https://api.github.com/repos/ChurchCRM/CRM/issues/123/comments"},"review_comments":{"href":"https://api.github.com/repos/ChurchCRM/CRM/pulls/123/comments"},"review_comment":{"href":"https://api.github.com/repos/ChurchCRM/CRM/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/ChurchCRM/CRM/pulls/123/commits"},"statuses":{"href":"https://api.github.com/repos/ChurchCRM/CRM/statuses/a57eed939d40d44e97409794cdb3e826c1b2214e"}}}}