{"action":"created","issue":{"url":"https://api.github.com/repos/andrewda/CSGOItemDB.com/issues/6","labels_url":"https://api.github.com/repos/andrewda/CSGOItemDB.com/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/andrewda/CSGOItemDB.com/issues/6/comments","events_url":"https://api.github.com/repos/andrewda/CSGOItemDB.com/issues/6/events","html_url":"https://github.com/andrewda/CSGOItemDB.com/pull/6","id":112425187,"number":6,"title":"Prevent SQL injection attack by escaping query values","user":{"login":"rygine","id":2925672,"avatar_url":"https://avatars.githubusercontent.com/u/2925672?v=3","gravatar_id":"","url":"https://api.github.com/users/rygine","html_url":"https://github.com/rygine","followers_url":"https://api.github.com/users/rygine/followers","following_url":"https://api.github.com/users/rygine/following{/other_user}","gists_url":"https://api.github.com/users/rygine/gists{/gist_id}","starred_url":"https://api.github.com/users/rygine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rygine/subscriptions","organizations_url":"https://api.github.com/users/rygine/orgs","repos_url":"https://api.github.com/users/rygine/repos","events_url":"https://api.github.com/users/rygine/events{/privacy}","received_events_url":"https://api.github.com/users/rygine/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-20T18:01:06Z","updated_at":"2015-10-20T18:16:33Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/andrewda/CSGOItemDB.com/pulls/6","html_url":"https://github.com/andrewda/CSGOItemDB.com/pull/6","diff_url":"https://github.com/andrewda/CSGOItemDB.com/pull/6.diff","patch_url":"https://github.com/andrewda/CSGOItemDB.com/pull/6.patch"},"body":"Noticed you were using query values without escaping them. This will allow anyone to do malicious things to your database. Merge this in ASAP!\n<a href='#crh-start'></a><a href='#crh-data-%7B%22processed%22%3A%20%5B%22https%3A//github.com/andrewda/CSGOItemDB.com/pull/6%23issuecomment-149649216%22%5D%2C%20%22comments%22%3A%20%7B%22General%20Comment%22%3A%20%7B%22html_url%22%3A%20%22https%3A//github.com/andrewda/CSGOItemDB.com/pull/6%23issuecomment-149649216%22%2C%20%22comments%22%3A%20%5B%7B%22body%22%3A%20%22Side%20note%3A%20Since%20I%20don%27t%20know%20the%20structure%20of%20your%20database%2C%20I%27m%20unable%20to%20test%20this.%20Be%20sure%20to%20run%20some%20tests%20before%20merging.%22%2C%20%22created_at%22%3A%20%222015-10-20T18%3A02%3A48Z%22%2C%20%22user%22%3A%20%7B%22avatar_url%22%3A%20%22https%3A//avatars.githubusercontent.com/u/2925672%3Fv%3D3%22%2C%20%22html_url%22%3A%20%22https%3A//github.com/rygine%22%7D%7D%5D%2C%20%22title%22%3A%20%22General%20Comment%22%7D%7D%7D'></a>\n<a href='https://www.codereviewhub.com/'><img src='http://www.codereviewhub.com/site/github-bar.png' height=40></a>\n- [ ] <a href='#crh-comment-General Comment'></a> <img src='http://www.codereviewhub.com/site/github-remaining.png' height=16 width=60>&nbsp;<b><a href='https://github.com/andrewda/CSGOItemDB.com/pull/6#issuecomment-149649216'>General Comment</a></b>\n- <a href='https://github.com/rygine'><img border=0 src='https://avatars.githubusercontent.com/u/2925672?v=3' height=16 width=16'></a> Side note: Since I don't know the structure of your database, I'm unable to test this. Be sure to run some tests before merging.\n\n\n<a href='https://www.codereviewhub.com/andrewda/CSGOItemDB.com/pull/6?mark_as_completed=1'><img src='http://www.codereviewhub.com/site/github-mark-as-completed.png' height=26></a>&nbsp;<a href='https://www.codereviewhub.com/andrewda/CSGOItemDB.com/pull/6?approve=1'><img src='http://www.codereviewhub.com/site/github-approve.png' height=26></a>&nbsp;<a href='https://github.com/andrewda/CSGOItemDB.com/pull/6'><img src='http://www.codereviewhub.com/site/github-refresh.png' height=26></a>\n<a href='#crh-end'></a>"},"comment":{"url":"https://api.github.com/repos/andrewda/CSGOItemDB.com/issues/comments/149652628","html_url":"https://github.com/andrewda/CSGOItemDB.com/pull/6#issuecomment-149652628","issue_url":"https://api.github.com/repos/andrewda/CSGOItemDB.com/issues/6","id":149652628,"user":{"login":"andrewda","id":10191084,"avatar_url":"https://avatars.githubusercontent.com/u/10191084?v=3","gravatar_id":"","url":"https://api.github.com/users/andrewda","html_url":"https://github.com/andrewda","followers_url":"https://api.github.com/users/andrewda/followers","following_url":"https://api.github.com/users/andrewda/following{/other_user}","gists_url":"https://api.github.com/users/andrewda/gists{/gist_id}","starred_url":"https://api.github.com/users/andrewda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andrewda/subscriptions","organizations_url":"https://api.github.com/users/andrewda/orgs","repos_url":"https://api.github.com/users/andrewda/repos","events_url":"https://api.github.com/users/andrewda/events{/privacy}","received_events_url":"https://api.github.com/users/andrewda/received_events","type":"User","site_admin":false},"created_at":"2015-10-20T18:16:33Z","updated_at":"2015-10-20T18:16:33Z","body":"I'll test this out, thanks!"}}