{"action":"created","issue":{"url":"https://api.github.com/repos/MarkusHiller/OpenSoccer/issues/18","repository_url":"https://api.github.com/repos/MarkusHiller/OpenSoccer","labels_url":"https://api.github.com/repos/MarkusHiller/OpenSoccer/issues/18/labels{/name}","comments_url":"https://api.github.com/repos/MarkusHiller/OpenSoccer/issues/18/comments","events_url":"https://api.github.com/repos/MarkusHiller/OpenSoccer/issues/18/events","html_url":"https://github.com/MarkusHiller/OpenSoccer/issues/18","id":180096025,"number":18,"title":"SupportController.php","user":{"login":"bornhaeusser","id":6609040,"avatar_url":"https://avatars.githubusercontent.com/u/6609040?v=3","gravatar_id":"","url":"https://api.github.com/users/bornhaeusser","html_url":"https://github.com/bornhaeusser","followers_url":"https://api.github.com/users/bornhaeusser/followers","following_url":"https://api.github.com/users/bornhaeusser/following{/other_user}","gists_url":"https://api.github.com/users/bornhaeusser/gists{/gist_id}","starred_url":"https://api.github.com/users/bornhaeusser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bornhaeusser/subscriptions","organizations_url":"https://api.github.com/users/bornhaeusser/orgs","repos_url":"https://api.github.com/users/bornhaeusser/repos","events_url":"https://api.github.com/users/bornhaeusser/events{/privacy}","received_events_url":"https://api.github.com/users/bornhaeusser/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-09-29T16:18:59Z","updated_at":"2016-09-29T17:33:29Z","closed_at":null,"body":"geht bei mir nur mit der Class:\r\n\r\n`class SupportController {\r\n\r\n    public static function getUnreadedTicketCount($userIds, $status) {\r\n        $supportSql = $status == 'Helfer' || $status == 'Admin' ? \"\" : \" AND visibilityLevel = 0\";\r\n        $sql = \"SELECT COUNT(*) FROM \" . CONFIG_TABLE_PREFIX . \"supportRequests WHERE open = 1 AND '\" . $userIds . \"' NOT IN (SELECT userId FROM \" . CONFIG_TABLE_PREFIX . \"supportRead WHERE anfrageID = id)\" . $supportSql;\r\n        $result = DB::query($sql, FALSE);\r\n        \r\n        return mysql_result($result, 0);\r\n    }\r\n\r\n}`"},"comment":{"url":"https://api.github.com/repos/MarkusHiller/OpenSoccer/issues/comments/250536476","html_url":"https://github.com/MarkusHiller/OpenSoccer/issues/18#issuecomment-250536476","issue_url":"https://api.github.com/repos/MarkusHiller/OpenSoccer/issues/18","id":250536476,"user":{"login":"bornhaeusser","id":6609040,"avatar_url":"https://avatars.githubusercontent.com/u/6609040?v=3","gravatar_id":"","url":"https://api.github.com/users/bornhaeusser","html_url":"https://github.com/bornhaeusser","followers_url":"https://api.github.com/users/bornhaeusser/followers","following_url":"https://api.github.com/users/bornhaeusser/following{/other_user}","gists_url":"https://api.github.com/users/bornhaeusser/gists{/gist_id}","starred_url":"https://api.github.com/users/bornhaeusser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bornhaeusser/subscriptions","organizations_url":"https://api.github.com/users/bornhaeusser/orgs","repos_url":"https://api.github.com/users/bornhaeusser/repos","events_url":"https://api.github.com/users/bornhaeusser/events{/privacy}","received_events_url":"https://api.github.com/users/bornhaeusser/received_events","type":"User","site_admin":false},"created_at":"2016-09-29T17:33:28Z","updated_at":"2016-09-29T17:33:28Z","body":"wurde nicht vergessen:\r\n\r\n<img width=\"899\" alt=\"bildschirmfoto 2016-09-29 um 19 32 54\" src=\"https://cloud.githubusercontent.com/assets/6609040/18964993/948acc16-867b-11e6-9364-d7736d4919ed.png\">\r\n"}}
{"actor":{"display_login":"bornhaeusser"}}