{"action":"created","issue":{"url":"https://api.github.com/repos/pouetnet/pouet2.0/issues/88","repository_url":"https://api.github.com/repos/pouetnet/pouet2.0","labels_url":"https://api.github.com/repos/pouetnet/pouet2.0/issues/88/labels{/name}","comments_url":"https://api.github.com/repos/pouetnet/pouet2.0/issues/88/comments","events_url":"https://api.github.com/repos/pouetnet/pouet2.0/issues/88/events","html_url":"https://github.com/pouetnet/pouet2.0/issues/88","id":418819175,"node_id":"MDU6SXNzdWU0MTg4MTkxNzU=","number":88,"title":"toplist.php date range checks addedDate instead of actual release date","user":{"login":"psenough","id":808571,"node_id":"MDQ6VXNlcjgwODU3MQ==","avatar_url":"https://avatars1.githubusercontent.com/u/808571?v=4","gravatar_id":"","url":"https://api.github.com/users/psenough","html_url":"https://github.com/psenough","followers_url":"https://api.github.com/users/psenough/followers","following_url":"https://api.github.com/users/psenough/following{/other_user}","gists_url":"https://api.github.com/users/psenough/gists{/gist_id}","starred_url":"https://api.github.com/users/psenough/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/psenough/subscriptions","organizations_url":"https://api.github.com/users/psenough/orgs","repos_url":"https://api.github.com/users/psenough/repos","events_url":"https://api.github.com/users/psenough/events{/privacy}","received_events_url":"https://api.github.com/users/psenough/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2019-03-08T14:52:36Z","updated_at":"2019-05-11T18:03:33Z","closed_at":null,"author_association":"NONE","body":"toplist.php date range seems to be listing when prods were added to the database and not when they were first released.\r\n\r\nas a result we get an empty list of everything released before the year 2000.\r\n\r\nempty list:\r\nhttp://www.pouet.net/toplist.php?type=64k&platform=&limit=20&dateFrom=1991-02-01&dateTo=2000-02-01\r\n\r\nproper list:\r\nhttp://www.pouet.net/toplist.php?type=64k&platform=&limit=20&dateFrom=1991-02-01&dateTo=2001-02-01\r\n\r\nis this by design? if it is, maybe it should be said so more explicitly somewhere, so people searching for stuff from the 90s know about it while searching. if it's not, i can try to submit a patch for it, not sure if sql can handle mixing month and years without getting slow, will have to check.\r\n\r\nor maybe this just ain't worth working on, since it's not really that used and it'll be deprecated by that proper prod query page that it's been talked about for a while now."},"comment":{"url":"https://api.github.com/repos/pouetnet/pouet2.0/issues/comments/491532225","html_url":"https://github.com/pouetnet/pouet2.0/issues/88#issuecomment-491532225","issue_url":"https://api.github.com/repos/pouetnet/pouet2.0/issues/88","id":491532225,"node_id":"MDEyOklzc3VlQ29tbWVudDQ5MTUzMjIyNQ==","user":{"login":"Gargaj","id":1702533,"node_id":"MDQ6VXNlcjE3MDI1MzM=","avatar_url":"https://avatars2.githubusercontent.com/u/1702533?v=4","gravatar_id":"","url":"https://api.github.com/users/Gargaj","html_url":"https://github.com/Gargaj","followers_url":"https://api.github.com/users/Gargaj/followers","following_url":"https://api.github.com/users/Gargaj/following{/other_user}","gists_url":"https://api.github.com/users/Gargaj/gists{/gist_id}","starred_url":"https://api.github.com/users/Gargaj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gargaj/subscriptions","organizations_url":"https://api.github.com/users/Gargaj/orgs","repos_url":"https://api.github.com/users/Gargaj/repos","events_url":"https://api.github.com/users/Gargaj/events{/privacy}","received_events_url":"https://api.github.com/users/Gargaj/received_events","type":"User","site_admin":false},"created_at":"2019-05-11T18:03:33Z","updated_at":"2019-05-11T18:03:33Z","author_association":"MEMBER","body":"Also I just realized that the toplist sorting is based on a formula using addedDate, so it's 1) not possible 2) your fault. :)"}}
{"actor":{"display_login":"Gargaj"}}