{"action":"created","comment":{"url":"https://api.github.com/repos/pkgodara/eOrg/pulls/comments/111793928","pull_request_review_id":33060198,"id":111793928,"diff_hunk":"@@ -0,0 +1,86 @@\n+<?php\n+\n+/* \n+ * this is to view users category wise\n+ */\n+session_start();\n+\n+if( !( isset( $_SESSION['Username'] ) && isset($_SESSION['Name']) && $_SESSION['Username'] === 'admin' ) )\n+{\n+\techo \"To access this page you need to login as Admin. Please log in first.\";\n+\tdie();\n+}\n+\n+\n+require_once \"../../LocalSettings.php\";\n+require_once \"../Globals.php\";\n+\n+if ( !(isset($_POST['tab']) && isset($_POST['levelId'])) )\n+{\n+\techo \"Sorry, there is some problem<br>\";\n+\tdie ();\n+}\n+\n+\n+\n+$tab = $_POST['tab'];\n+$levId = $_POST['levelId'];\n+\n+\n+$sqlConn = new mysqli( $eorgDBserver , $eorgDBuser , $eorgDBpasswd , $catDB );\n+\n+if( $sqlConn->connect_errno ) \n+{\n+\techo \"Error connecting database. Please check your database credentials and update.\";\n+\tdie();\n+}\n+\n+$newLevId = $levId.\"_[0-9]{1,}\";\n+$qry = \"SELECT * FROM $tab WHERE $levels REGEXP \\\"^$newLevId$\\\"\";\n+$stmt = $sqlConn->prepare($qry);\n+\n+if ( ! $stmt->execute() )\n+{\n+\techo\"there is a problem with database<br>\";\n+\tdie ();\n+}\n+\n+$result = $stmt->get_result ();\n+\n+$catType = str_replace ( \"L\", \"C\", $levId );\n+\n+if ( $result->num_rows == 0 )\n+{\n+\techo \"No further categories are available, now proceed further\";\n+}\n+else\n+{\n+\t$qry2 = \"SELECT * FROM $tab WHERE $levels REGEXP \\\"^$catType$\\\"\";\n+\t$stmt2 = $sqlConn->prepare($qry2);","path":"includes/dashboard/FurtherUserOptions.php","position":59,"original_position":59,"commit_id":"b97a39b41a024b1b9ffbb012b6b99bfd27385130","original_commit_id":"b97a39b41a024b1b9ffbb012b6b99bfd27385130","user":{"login":"pkgodara","id":16938349,"avatar_url":"https://avatars3.githubusercontent.com/u/16938349?v=3","gravatar_id":"","url":"https://api.github.com/users/pkgodara","html_url":"https://github.com/pkgodara","followers_url":"https://api.github.com/users/pkgodara/followers","following_url":"https://api.github.com/users/pkgodara/following{/other_user}","gists_url":"https://api.github.com/users/pkgodara/gists{/gist_id}","starred_url":"https://api.github.com/users/pkgodara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkgodara/subscriptions","organizations_url":"https://api.github.com/users/pkgodara/orgs","repos_url":"https://api.github.com/users/pkgodara/repos","events_url":"https://api.github.com/users/pkgodara/events{/privacy}","received_events_url":"https://api.github.com/users/pkgodara/received_events","type":"User","site_admin":false},"body":"__[code_sniffer]__\n* Spaces must be used to indent lines; tabs are not allowed\n\n<!-- Comment by [SideCI](https://sideci.com) -->","created_at":"2017-04-17T18:41:49Z","updated_at":"2017-04-17T18:41:49Z","html_url":"https://github.com/pkgodara/eOrg/pull/59#discussion_r111793928","pull_request_url":"https://api.github.com/repos/pkgodara/eOrg/pulls/59","_links":{"self":{"href":"https://api.github.com/repos/pkgodara/eOrg/pulls/comments/111793928"},"html":{"href":"https://github.com/pkgodara/eOrg/pull/59#discussion_r111793928"},"pull_request":{"href":"https://api.github.com/repos/pkgodara/eOrg/pulls/59"}}},"pull_request":{"url":"https://api.github.com/repos/pkgodara/eOrg/pulls/59","id":116178729,"html_url":"https://github.com/pkgodara/eOrg/pull/59","diff_url":"https://github.com/pkgodara/eOrg/pull/59.diff","patch_url":"https://github.com/pkgodara/eOrg/pull/59.patch","issue_url":"https://api.github.com/repos/pkgodara/eOrg/issues/59","number":59,"state":"open","locked":false,"title":"general ccs","user":{"login":"NabeelQaiser","id":25105530,"avatar_url":"https://avatars1.githubusercontent.com/u/25105530?v=3","gravatar_id":"","url":"https://api.github.com/users/NabeelQaiser","html_url":"https://github.com/NabeelQaiser","followers_url":"https://api.github.com/users/NabeelQaiser/followers","following_url":"https://api.github.com/users/NabeelQaiser/following{/other_user}","gists_url":"https://api.github.com/users/NabeelQaiser/gists{/gist_id}","starred_url":"https://api.github.com/users/NabeelQaiser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NabeelQaiser/subscriptions","organizations_url":"https://api.github.com/users/NabeelQaiser/orgs","repos_url":"https://api.github.com/users/NabeelQaiser/repos","events_url":"https://api.github.com/users/NabeelQaiser/events{/privacy}","received_events_url":"https://api.github.com/users/NabeelQaiser/received_events","type":"User","site_admin":false},"body":"","created_at":"2017-04-17T18:41:40Z","updated_at":"2017-04-17T18:41:49Z","closed_at":null,"merged_at":null,"merge_commit_sha":"5d10de597ea7c54ef0fc57c7e1c1faf31078b0a8","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/pkgodara/eOrg/pulls/59/commits","review_comments_url":"https://api.github.com/repos/pkgodara/eOrg/pulls/59/comments","review_comment_url":"https://api.github.com/repos/pkgodara/eOrg/pulls/comments{/number}","comments_url":"https://api.github.com/repos/pkgodara/eOrg/issues/59/comments","statuses_url":"https://api.github.com/repos/pkgodara/eOrg/statuses/b97a39b41a024b1b9ffbb012b6b99bfd27385130","head":{"label":"pkgodara:develop","ref":"develop","sha":"b97a39b41a024b1b9ffbb012b6b99bfd27385130","user":{"login":"pkgodara","id":16938349,"avatar_url":"https://avatars3.githubusercontent.com/u/16938349?v=3","gravatar_id":"","url":"https://api.github.com/users/pkgodara","html_url":"https://github.com/pkgodara","followers_url":"https://api.github.com/users/pkgodara/followers","following_url":"https://api.github.com/users/pkgodara/following{/other_user}","gists_url":"https://api.github.com/users/pkgodara/gists{/gist_id}","starred_url":"https://api.github.com/users/pkgodara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkgodara/subscriptions","organizations_url":"https://api.github.com/users/pkgodara/orgs","repos_url":"https://api.github.com/users/pkgodara/repos","events_url":"https://api.github.com/users/pkgodara/events{/privacy}","received_events_url":"https://api.github.com/users/pkgodara/received_events","type":"User","site_admin":false},"repo":{"id":80422762,"name":"eOrg","full_name":"pkgodara/eOrg","owner":{"login":"pkgodara","id":16938349,"avatar_url":"https://avatars3.githubusercontent.com/u/16938349?v=3","gravatar_id":"","url":"https://api.github.com/users/pkgodara","html_url":"https://github.com/pkgodara","followers_url":"https://api.github.com/users/pkgodara/followers","following_url":"https://api.github.com/users/pkgodara/following{/other_user}","gists_url":"https://api.github.com/users/pkgodara/gists{/gist_id}","starred_url":"https://api.github.com/users/pkgodara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkgodara/subscriptions","organizations_url":"https://api.github.com/users/pkgodara/orgs","repos_url":"https://api.github.com/users/pkgodara/repos","events_url":"https://api.github.com/users/pkgodara/events{/privacy}","received_events_url":"https://api.github.com/users/pkgodara/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/pkgodara/eOrg","description":"Open Source Lightweight Application and Leave management software written in PHP under MIT License.","fork":false,"url":"https://api.github.com/repos/pkgodara/eOrg","forks_url":"https://api.github.com/repos/pkgodara/eOrg/forks","keys_url":"https://api.github.com/repos/pkgodara/eOrg/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pkgodara/eOrg/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pkgodara/eOrg/teams","hooks_url":"https://api.github.com/repos/pkgodara/eOrg/hooks","issue_events_url":"https://api.github.com/repos/pkgodara/eOrg/issues/events{/number}","events_url":"https://api.github.com/repos/pkgodara/eOrg/events","assignees_url":"https://api.github.com/repos/pkgodara/eOrg/assignees{/user}","branches_url":"https://api.github.com/repos/pkgodara/eOrg/branches{/branch}","tags_url":"https://api.github.com/repos/pkgodara/eOrg/tags","blobs_url":"https://api.github.com/repos/pkgodara/eOrg/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pkgodara/eOrg/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pkgodara/eOrg/git/refs{/sha}","trees_url":"https://api.github.com/repos/pkgodara/eOrg/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pkgodara/eOrg/statuses/{sha}","languages_url":"https://api.github.com/repos/pkgodara/eOrg/languages","stargazers_url":"https://api.github.com/repos/pkgodara/eOrg/stargazers","contributors_url":"https://api.github.com/repos/pkgodara/eOrg/contributors","subscribers_url":"https://api.github.com/repos/pkgodara/eOrg/subscribers","subscription_url":"https://api.github.com/repos/pkgodara/eOrg/subscription","commits_url":"https://api.github.com/repos/pkgodara/eOrg/commits{/sha}","git_commits_url":"https://api.github.com/repos/pkgodara/eOrg/git/commits{/sha}","comments_url":"https://api.github.com/repos/pkgodara/eOrg/comments{/number}","issue_comment_url":"https://api.github.com/repos/pkgodara/eOrg/issues/comments{/number}","contents_url":"https://api.github.com/repos/pkgodara/eOrg/contents/{+path}","compare_url":"https://api.github.com/repos/pkgodara/eOrg/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pkgodara/eOrg/merges","archive_url":"https://api.github.com/repos/pkgodara/eOrg/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pkgodara/eOrg/downloads","issues_url":"https://api.github.com/repos/pkgodara/eOrg/issues{/number}","pulls_url":"https://api.github.com/repos/pkgodara/eOrg/pulls{/number}","milestones_url":"https://api.github.com/repos/pkgodara/eOrg/milestones{/number}","notifications_url":"https://api.github.com/repos/pkgodara/eOrg/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pkgodara/eOrg/labels{/name}","releases_url":"https://api.github.com/repos/pkgodara/eOrg/releases{/id}","deployments_url":"https://api.github.com/repos/pkgodara/eOrg/deployments","created_at":"2017-01-30T13:15:20Z","updated_at":"2017-04-16T16:24:29Z","pushed_at":"2017-04-17T18:41:40Z","git_url":"git://github.com/pkgodara/eOrg.git","ssh_url":"git@github.com:pkgodara/eOrg.git","clone_url":"https://github.com/pkgodara/eOrg.git","svn_url":"https://github.com/pkgodara/eOrg","homepage":"","size":8496,"stargazers_count":3,"watchers_count":3,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":2,"mirror_url":null,"open_issues_count":6,"forks":2,"open_issues":6,"watchers":3,"default_branch":"master"}},"base":{"label":"pkgodara:master","ref":"master","sha":"4b26d593fff1ade532702f7d43f83bd34b06a03a","user":{"login":"pkgodara","id":16938349,"avatar_url":"https://avatars3.githubusercontent.com/u/16938349?v=3","gravatar_id":"","url":"https://api.github.com/users/pkgodara","html_url":"https://github.com/pkgodara","followers_url":"https://api.github.com/users/pkgodara/followers","following_url":"https://api.github.com/users/pkgodara/following{/other_user}","gists_url":"https://api.github.com/users/pkgodara/gists{/gist_id}","starred_url":"https://api.github.com/users/pkgodara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkgodara/subscriptions","organizations_url":"https://api.github.com/users/pkgodara/orgs","repos_url":"https://api.github.com/users/pkgodara/repos","events_url":"https://api.github.com/users/pkgodara/events{/privacy}","received_events_url":"https://api.github.com/users/pkgodara/received_events","type":"User","site_admin":false},"repo":{"id":80422762,"name":"eOrg","full_name":"pkgodara/eOrg","owner":{"login":"pkgodara","id":16938349,"avatar_url":"https://avatars3.githubusercontent.com/u/16938349?v=3","gravatar_id":"","url":"https://api.github.com/users/pkgodara","html_url":"https://github.com/pkgodara","followers_url":"https://api.github.com/users/pkgodara/followers","following_url":"https://api.github.com/users/pkgodara/following{/other_user}","gists_url":"https://api.github.com/users/pkgodara/gists{/gist_id}","starred_url":"https://api.github.com/users/pkgodara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkgodara/subscriptions","organizations_url":"https://api.github.com/users/pkgodara/orgs","repos_url":"https://api.github.com/users/pkgodara/repos","events_url":"https://api.github.com/users/pkgodara/events{/privacy}","received_events_url":"https://api.github.com/users/pkgodara/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/pkgodara/eOrg","description":"Open Source Lightweight Application and Leave management software written in PHP under MIT License.","fork":false,"url":"https://api.github.com/repos/pkgodara/eOrg","forks_url":"https://api.github.com/repos/pkgodara/eOrg/forks","keys_url":"https://api.github.com/repos/pkgodara/eOrg/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pkgodara/eOrg/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pkgodara/eOrg/teams","hooks_url":"https://api.github.com/repos/pkgodara/eOrg/hooks","issue_events_url":"https://api.github.com/repos/pkgodara/eOrg/issues/events{/number}","events_url":"https://api.github.com/repos/pkgodara/eOrg/events","assignees_url":"https://api.github.com/repos/pkgodara/eOrg/assignees{/user}","branches_url":"https://api.github.com/repos/pkgodara/eOrg/branches{/branch}","tags_url":"https://api.github.com/repos/pkgodara/eOrg/tags","blobs_url":"https://api.github.com/repos/pkgodara/eOrg/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pkgodara/eOrg/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pkgodara/eOrg/git/refs{/sha}","trees_url":"https://api.github.com/repos/pkgodara/eOrg/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pkgodara/eOrg/statuses/{sha}","languages_url":"https://api.github.com/repos/pkgodara/eOrg/languages","stargazers_url":"https://api.github.com/repos/pkgodara/eOrg/stargazers","contributors_url":"https://api.github.com/repos/pkgodara/eOrg/contributors","subscribers_url":"https://api.github.com/repos/pkgodara/eOrg/subscribers","subscription_url":"https://api.github.com/repos/pkgodara/eOrg/subscription","commits_url":"https://api.github.com/repos/pkgodara/eOrg/commits{/sha}","git_commits_url":"https://api.github.com/repos/pkgodara/eOrg/git/commits{/sha}","comments_url":"https://api.github.com/repos/pkgodara/eOrg/comments{/number}","issue_comment_url":"https://api.github.com/repos/pkgodara/eOrg/issues/comments{/number}","contents_url":"https://api.github.com/repos/pkgodara/eOrg/contents/{+path}","compare_url":"https://api.github.com/repos/pkgodara/eOrg/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pkgodara/eOrg/merges","archive_url":"https://api.github.com/repos/pkgodara/eOrg/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pkgodara/eOrg/downloads","issues_url":"https://api.github.com/repos/pkgodara/eOrg/issues{/number}","pulls_url":"https://api.github.com/repos/pkgodara/eOrg/pulls{/number}","milestones_url":"https://api.github.com/repos/pkgodara/eOrg/milestones{/number}","notifications_url":"https://api.github.com/repos/pkgodara/eOrg/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pkgodara/eOrg/labels{/name}","releases_url":"https://api.github.com/repos/pkgodara/eOrg/releases{/id}","deployments_url":"https://api.github.com/repos/pkgodara/eOrg/deployments","created_at":"2017-01-30T13:15:20Z","updated_at":"2017-04-16T16:24:29Z","pushed_at":"2017-04-17T18:41:40Z","git_url":"git://github.com/pkgodara/eOrg.git","ssh_url":"git@github.com:pkgodara/eOrg.git","clone_url":"https://github.com/pkgodara/eOrg.git","svn_url":"https://github.com/pkgodara/eOrg","homepage":"","size":8496,"stargazers_count":3,"watchers_count":3,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":2,"mirror_url":null,"open_issues_count":6,"forks":2,"open_issues":6,"watchers":3,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/pkgodara/eOrg/pulls/59"},"html":{"href":"https://github.com/pkgodara/eOrg/pull/59"},"issue":{"href":"https://api.github.com/repos/pkgodara/eOrg/issues/59"},"comments":{"href":"https://api.github.com/repos/pkgodara/eOrg/issues/59/comments"},"review_comments":{"href":"https://api.github.com/repos/pkgodara/eOrg/pulls/59/comments"},"review_comment":{"href":"https://api.github.com/repos/pkgodara/eOrg/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/pkgodara/eOrg/pulls/59/commits"},"statuses":{"href":"https://api.github.com/repos/pkgodara/eOrg/statuses/b97a39b41a024b1b9ffbb012b6b99bfd27385130"}}}}
{"actor":{"display_login":"pkgodara"}}