{"action":"created","issue":{"url":"https://api.github.com/repos/florianpreusner/test/issues/2","repository_url":"https://api.github.com/repos/florianpreusner/test","labels_url":"https://api.github.com/repos/florianpreusner/test/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/florianpreusner/test/issues/2/comments","events_url":"https://api.github.com/repos/florianpreusner/test/issues/2/events","html_url":"https://github.com/florianpreusner/test/pull/2","id":166417613,"number":2,"title":"Test Hook #1","user":{"login":"florianpreusner","id":728558,"avatar_url":"https://avatars.githubusercontent.com/u/728558?v=3","gravatar_id":"","url":"https://api.github.com/users/florianpreusner","html_url":"https://github.com/florianpreusner","followers_url":"https://api.github.com/users/florianpreusner/followers","following_url":"https://api.github.com/users/florianpreusner/following{/other_user}","gists_url":"https://api.github.com/users/florianpreusner/gists{/gist_id}","starred_url":"https://api.github.com/users/florianpreusner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/florianpreusner/subscriptions","organizations_url":"https://api.github.com/users/florianpreusner/orgs","repos_url":"https://api.github.com/users/florianpreusner/repos","events_url":"https://api.github.com/users/florianpreusner/events{/privacy}","received_events_url":"https://api.github.com/users/florianpreusner/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/florianpreusner/test/labels/invalid","name":"invalid","color":"e6e6e6"},{"url":"https://api.github.com/repos/florianpreusner/test/labels/Review%20OK","name":"Review OK","color":"0e8a16"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-19T19:46:56Z","updated_at":"2016-08-07T22:09:11Z","closed_at":"2016-08-06T21:58:15Z","pull_request":{"url":"https://api.github.com/repos/florianpreusner/test/pulls/2","html_url":"https://github.com/florianpreusner/test/pull/2","diff_url":"https://github.com/florianpreusner/test/pull/2.diff","patch_url":"https://github.com/florianpreusner/test/pull/2.patch"},"body":"| Q                          | A\r\n| ----------------------- | ---\r\n| Language             | php\r\n| Description           | Convert german date field into \"MySQL Date\"\r\n| Search Keywords | php, mysql, date, time, convert\r\n\r\n\r\n\r\n```php\r\n/**\r\n * Converts Date Field from dd.mm.yyyy to yyyy-mm-dd or yyyy-mm-dd hh:ii:ss\r\n *\r\n * @param  string  $date\r\n * @param  boolean $with_time\r\n * @return string  mysql-fitting date\r\n */\r\nfunction generateMySQLDate($date, $with_time) {\r\n\r\n  if($with_time) :\r\n\r\n    $buffer = explode(' ', $date);\r\n    $date   = explode('.', $buffer[0]);\r\n    $time   = explode(':', $buffer[1]);\r\n    return $buffer[2].'-'.$buffer[1].'-'.$buffer[0].' '.$time[0].':'.$time[1].':'.$time[2];\r\n  else :\r\n\r\n    $buffer = explode('.', $date);\r\n    return $buffer[2].'-'.$buffer[1].'-'.$buffer[0];\r\n  endif;\r\n}\r\n```"},"comment":{"url":"https://api.github.com/repos/florianpreusner/test/issues/comments/238111701","html_url":"https://github.com/florianpreusner/test/pull/2#issuecomment-238111701","issue_url":"https://api.github.com/repos/florianpreusner/test/issues/2","id":238111701,"user":{"login":"qwot","id":20564986,"avatar_url":"https://avatars.githubusercontent.com/u/20564986?v=3","gravatar_id":"","url":"https://api.github.com/users/qwot","html_url":"https://github.com/qwot","followers_url":"https://api.github.com/users/qwot/followers","following_url":"https://api.github.com/users/qwot/following{/other_user}","gists_url":"https://api.github.com/users/qwot/gists{/gist_id}","starred_url":"https://api.github.com/users/qwot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/qwot/subscriptions","organizations_url":"https://api.github.com/users/qwot/orgs","repos_url":"https://api.github.com/users/qwot/repos","events_url":"https://api.github.com/users/qwot/events{/privacy}","received_events_url":"https://api.github.com/users/qwot/received_events","type":"User","site_admin":false},"created_at":"2016-08-07T22:09:11Z","updated_at":"2016-08-07T22:09:11Z","body":"Found following stuff: state: open\ncreated at: 19.07.2016 19:46:56\ntitle: Test Hook #1\nuser name: florianpreusner\nlabel name: Review OK\ncontent: | Q                          | A\r\n| ----------------------- | ---\r\n| Language             | php\r\n| Description           | Convert german date field into \"MySQL Date\"\r\n| Search Keywords | php, mysql, date, time, convert\r\n\r\n\r\n\r\n```php\r\n/**\r\n * Converts Date Field from dd.mm.yyyy to yyyy-mm-dd or yyyy-mm-dd hh:ii:ss\r\n *\r\n * @param  string  $date\r\n * @param  boolean $with_time\r\n * @return string  mysql-fitting date\r\n */\r\nfunction generateMySQLDate($date, $with_time) {\r\n\r\n  if($with_time) :\r\n\r\n    $buffer = explode(' ', $date);\r\n    $date   = explode('.', $buffer[0]);\r\n    $time   = explode(':', $buffer[1]);\r\n    return $buffer[2].'-'.$buffer[1].'-'.$buffer[0].' '.$time[0].':'.$time[1].':'.$time[2];\r\n  else :\r\n\r\n    $buffer = explode('.', $date);\r\n    return $buffer[2].'-'.$buffer[1].'-'.$buffer[0];\r\n  endif;\r\n}\r\n```\nlanguage: php\ndescription: Convert german date field into \"MySQL Date\"\r\nkeywords: php;mysql;date;time;convert\r\ncode: \n/**\r\n * Converts Date Field from dd.mm.yyyy to yyyy-mm-dd or yyyy-mm-dd hh:ii:ss\r\n *\r\n * @param  string  $date\r\n * @param  boolean $with_time\r\n * @return string  mysql-fitting date\r\n */\r\nfunction generateMySQLDate($date, $with_time) {\r\n\r\n  if($with_time) :\r\n\r\n    $buffer = explode(' ', $date);\r\n    $date   = explode('.', $buffer[0]);\r\n    $time   = explode(':', $buffer[1]);\r\n    return $buffer[2].'-'.$buffer[1].'-'.$buffer[0].' '.$time[0].':'.$time[1].':'.$time[2];\r\n  else :\r\n\r\n    $buffer = explode('.', $date);\r\n    return $buffer[2].'-'.$buffer[1].'-'.$buffer[0];\r\n  endif;\r\n}\r\n\n"}}
{"actor":{"display_login":"qwot"}}