{"action":"created","issue":{"url":"https://api.github.com/repos/scottwainstock/pbm/issues/806","repository_url":"https://api.github.com/repos/scottwainstock/pbm","labels_url":"https://api.github.com/repos/scottwainstock/pbm/issues/806/labels{/name}","comments_url":"https://api.github.com/repos/scottwainstock/pbm/issues/806/comments","events_url":"https://api.github.com/repos/scottwainstock/pbm/issues/806/events","html_url":"https://github.com/scottwainstock/pbm/issues/806","id":279082516,"number":806,"title":"If a user adds a high score, then machine is deleted, there's no way to delete the high score","user":{"login":"RyanTG","id":632682,"avatar_url":"https://avatars3.githubusercontent.com/u/632682?v=4","gravatar_id":"","url":"https://api.github.com/users/RyanTG","html_url":"https://github.com/RyanTG","followers_url":"https://api.github.com/users/RyanTG/followers","following_url":"https://api.github.com/users/RyanTG/following{/other_user}","gists_url":"https://api.github.com/users/RyanTG/gists{/gist_id}","starred_url":"https://api.github.com/users/RyanTG/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RyanTG/subscriptions","organizations_url":"https://api.github.com/users/RyanTG/orgs","repos_url":"https://api.github.com/users/RyanTG/repos","events_url":"https://api.github.com/users/RyanTG/events{/privacy}","received_events_url":"https://api.github.com/users/RyanTG/received_events","type":"User","site_admin":false},"labels":[{"id":525325819,"url":"https://api.github.com/repos/scottwainstock/pbm/labels/admin","name":"admin","color":"fbca04","default":false},{"id":556370794,"url":"https://api.github.com/repos/scottwainstock/pbm/labels/priority","name":"priority","color":"b60205","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-12-04T17:35:27Z","updated_at":"2018-03-23T03:41:27Z","closed_at":null,"author_association":"COLLABORATOR","body":"For example, this user - https://pinballmap.com/users/2038/profile - added a high score (of 1) to Black Rose at WVU Mountainlair. But that machine is no longer at that location. Since the score is 1, it's obviously a mistake, and I thought I'd delete it (so that it's not visible in his profile). But if I log in as a West Virginia admin, and go to https://pinballmap.com/admin/machine_score_xref that high score listing isn't there. So I can't delete it.\r\n\r\nI think it's good that we retain high score for deleted machines. But it would be cool if we could access them within admin.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/scottwainstock/pbm/issues/comments/375535358","html_url":"https://github.com/scottwainstock/pbm/issues/806#issuecomment-375535358","issue_url":"https://api.github.com/repos/scottwainstock/pbm/issues/806","id":375535358,"user":{"login":"scottwainstock","id":179757,"avatar_url":"https://avatars2.githubusercontent.com/u/179757?v=4","gravatar_id":"","url":"https://api.github.com/users/scottwainstock","html_url":"https://github.com/scottwainstock","followers_url":"https://api.github.com/users/scottwainstock/followers","following_url":"https://api.github.com/users/scottwainstock/following{/other_user}","gists_url":"https://api.github.com/users/scottwainstock/gists{/gist_id}","starred_url":"https://api.github.com/users/scottwainstock/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scottwainstock/subscriptions","organizations_url":"https://api.github.com/users/scottwainstock/orgs","repos_url":"https://api.github.com/users/scottwainstock/repos","events_url":"https://api.github.com/users/scottwainstock/events{/privacy}","received_events_url":"https://api.github.com/users/scottwainstock/received_events","type":"User","site_admin":false},"created_at":"2018-03-23T03:41:27Z","updated_at":"2018-03-23T03:41:27Z","author_association":"OWNER","body":"@RyanTG That score IS deleted. The profile page reads from UserSubmissions, not machine_score_xrefs.\r\n\r\n```glowing-dusk-5085::COBALT=> select * from user_submissions where user_id=2038 and submission_type='new_msx';\r\n  id   | submission_type |                                      submission                                      | region_id |         created_at         |         updated_at         | user_id | location_id | machine_id\r\n-------+-----------------+--------------------------------------------------------------------------------------+-----------+----------------------------+----------------------------+---------+-------------+------------\r\n 24093 | new_msx         | User tjgoad (tjgoad@gmail.com) added a score of 1 for Black Rose to WVU Mountainlair |        74 | 2017-07-12 16:53:03.315073 | 2017-07-12 16:53:03.315073 |    2038 |        5691 |        732\r\n(1 row)```\r\n\r\nSo, do we make any changes here?"}}
{"actor":{"display_login":"scottwainstock"}}