{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":412106443,"defaultBranch":"main","name":"UKPinballLeague","ownerLogin":"PaulGarnerUk","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2021-09-30T14:52:30.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/12997377?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1633014483.769272","currentOid":""},"activityList":{"items":[{"before":"16bdf6ee8e13f89209823743dfbb5e049c58d63c","after":"e9912c36b74d2a12783a1fa790d7e77048792c8e","ref":"refs/heads/main","pushedAt":"2024-05-24T09:01:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Updates to machine-info. Adds new regions to filter. Fixes pluralisation issues.","shortMessageHtmlLink":"Updates to machine-info. Adds new regions to filter. Fixes pluralisat…"}},{"before":"64add0fa4d421dad31ace08d849e8fb474874c82","after":"16bdf6ee8e13f89209823743dfbb5e049c58d63c","ref":"refs/heads/main","pushedAt":"2024-05-11T10:20:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"East Anglia qualifying places","shortMessageHtmlLink":"East Anglia qualifying places"}},{"before":"07dbb853b963244b90ee687771762d79e256413b","after":"64add0fa4d421dad31ace08d849e8fb474874c82","ref":"refs/heads/main","pushedAt":"2024-05-07T20:10:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Change machines.csv to include all machines in db, even those without scores. These are typically machines which have been setup against a competition, prior to competition occurring.","shortMessageHtmlLink":"Change machines.csv to include all machines in db, even those without…"}},{"before":"ff7daf04cd63c60643c6405b7806b195674d6565","after":"07dbb853b963244b90ee687771762d79e256413b","ref":"refs/heads/main","pushedAt":"2024-05-06T18:27:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"This update standardises all score tables to have the same number of rows, so we don't get alignment issues on desktop where different number of players played each machine.  It's an improvement, but still not perfect, as there are edge cases where different players upset the count in different ways\n\nSee leaguemeet.php?season=17&region=m&meet=2 as an example where we generate 34 rows per table, where in reality we could have got away with 33 rows, as per this query... but this query doesn't consider guest players, soooo...\nSELECT MAX(Players) AS MaxPlayers FROM (\nSELECT COUNT(PlayerId) AS Players\nFROM Score\nWHERE CompetitionId = 547\nGROUP BY Score.MachineId) AS PlayerCountByMachine","shortMessageHtmlLink":"This update standardises all score tables to have the same number of …"}},{"before":"d3e2a9b2298e3ef0cc29f73ddbb9e1a55e2b4e1d","after":"ff7daf04cd63c60643c6405b7806b195674d6565","ref":"refs/heads/main","pushedAt":"2024-05-06T17:06:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Add missing regions to filter on machines page.","shortMessageHtmlLink":"Add missing regions to filter on machines page."}},{"before":"735ef6b215b763a4f457112fe6189cc295c5cb15","after":"d3e2a9b2298e3ef0cc29f73ddbb9e1a55e2b4e1d","ref":"refs/heads/main","pushedAt":"2024-05-06T16:13:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"- Add csv export for machines, including average and high score information. This is an optimised version of the query that the machines page runs, though in the unlikely* chance two people get the same highscore it will duplicate rows\n\n- Add header row to each of the csv files","shortMessageHtmlLink":"- Add csv export for machines, including average and high score infor…"}},{"before":"e00378db9cd954084edb2fe30c2ba19e2146a1e6","after":"735ef6b215b763a4f457112fe6189cc295c5cb15","ref":"refs/heads/main","pushedAt":"2024-05-06T10:43:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Change filename to players.csv","shortMessageHtmlLink":"Change filename to players.csv"}},{"before":"6b60a09b3b1ffcd720c44cbbffb858195401f055","after":"e00378db9cd954084edb2fe30c2ba19e2146a1e6","ref":"refs/heads/main","pushedAt":"2024-05-06T10:27:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Ah it needs to be a literal csv file for google, like this","shortMessageHtmlLink":"Ah it needs to be a literal csv file for google, like this"}},{"before":"db5be260efe4c7a510669ccd2d531c1180e3be92","after":"6b60a09b3b1ffcd720c44cbbffb858195401f055","ref":"refs/heads/main","pushedAt":"2024-05-06T10:11:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Add page for exporting player names and ids in csv format for 3rd party integration (eg google sheets IMPORTRANGE)","shortMessageHtmlLink":"Add page for exporting player names and ids in csv format for 3rd par…"}},{"before":"95b029bfbae6fd61039cf30305e01233d13af24b","after":"db5be260efe4c7a510669ccd2d531c1180e3be92","ref":"refs/heads/main","pushedAt":"2024-04-28T11:29:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"South Wales qualifying places","shortMessageHtmlLink":"South Wales qualifying places"}},{"before":"c5ffedcd86748976f4a5afadcfd3499e5a6b820f","after":"95b029bfbae6fd61039cf30305e01233d13af24b","ref":"refs/heads/main","pushedAt":"2024-04-04T18:10:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Highlight excluded player with (*) in results too.","shortMessageHtmlLink":"Highlight excluded player with (*) in results too."}},{"before":"e2634d22ac150c631147e9ca810affa3a0144d22","after":"c5ffedcd86748976f4a5afadcfd3499e5a6b820f","ref":"refs/heads/main","pushedAt":"2024-04-04T18:01:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Update qualifying places","shortMessageHtmlLink":"Update qualifying places"}},{"before":"97fb6d3047886fdc1aa9486f48a315f711b1bd14","after":"e2634d22ac150c631147e9ca810affa3a0144d22","ref":"refs/heads/main","pushedAt":"2024-02-25T18:10:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Fix to sorting on schedule page.","shortMessageHtmlLink":"Fix to sorting on schedule page."}},{"before":"8eb8fcf68c416b1788d8b0d992c999b0fbc76c2c","after":"97fb6d3047886fdc1aa9486f48a315f711b1bd14","ref":"refs/heads/main","pushedAt":"2024-02-17T17:00:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Add info on qualifying positions to SWest and Ireland","shortMessageHtmlLink":"Add info on qualifying positions to SWest and Ireland"}},{"before":"b8dfd28733c9c76874c93bbb5d3527651abee052","after":"8eb8fcf68c416b1788d8b0d992c999b0fbc76c2c","ref":"refs/heads/main","pushedAt":"2024-02-17T16:49:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Add regional finals to schedule page. Still figuring this out a bit. Probably needs a separate info page?  Probably need to show host/location at some point?","shortMessageHtmlLink":"Add regional finals to schedule page. Still figuring this out a bit. …"}},{"before":"f68ff644270f60319c3c022c7727ddcc8647c3f5","after":"b8dfd28733c9c76874c93bbb5d3527651abee052","ref":"refs/heads/main","pushedAt":"2024-02-01T18:58:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Results / South Wales was missing from mobile menu.","shortMessageHtmlLink":"Results / South Wales was missing from mobile menu."}},{"before":"20fcdcfc465760d685da1667a5d95df191dc3ebd","after":"f68ff644270f60319c3c022c7727ddcc8647c3f5","ref":"refs/heads/main","pushedAt":"2024-01-16T21:29:45.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Small updates for league specific things that I still don't have in the database.","shortMessageHtmlLink":"Small updates for league specific things that I still don't have in t…"}},{"before":"86c6d28d3839c72b91523723e6848385ccdcabd0","after":"20fcdcfc465760d685da1667a5d95df191dc3ebd","ref":"refs/heads/main","pushedAt":"2024-01-14T19:57:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Link to Lecari's event page, which is possibly more relevant to UK events than the pinball news diary.","shortMessageHtmlLink":"Link to Lecari's event page, which is possibly more relevant to UK ev…"}},{"before":"97d212f98a0916149ede191aadcc1d3e306b061c","after":"86c6d28d3839c72b91523723e6848385ccdcabd0","ref":"refs/heads/main","pushedAt":"2024-01-12T20:54:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Minor table changes.","shortMessageHtmlLink":"Minor table changes."}},{"before":"a9cc176e6212d763cff1b1bd0e45177180e108b2","after":"97d212f98a0916149ede191aadcc1d3e306b061c","ref":"refs/heads/main","pushedAt":"2024-01-12T20:30:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Show game notes in schedule info.","shortMessageHtmlLink":"Show game notes in schedule info."}},{"before":"85d934722c92a5adf90394a92b769feeb242d689","after":"a9cc176e6212d763cff1b1bd0e45177180e108b2","ref":"refs/heads/main","pushedAt":"2024-01-10T20:54:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Add Guide to schedule info where available.","shortMessageHtmlLink":"Add Guide to schedule info where available."}},{"before":"a4ffd7f5c5111718d626b6c5a58fa87b49da91ea","after":"85d934722c92a5adf90394a92b769feeb242d689","ref":"refs/heads/main","pushedAt":"2024-01-10T20:23:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Updates to schedule info. Pinball videos link. Show region where exact address is not shown. More relevant info when viewing completed event info.","shortMessageHtmlLink":"Updates to schedule info. Pinball videos link. Show region where exac…"}},{"before":"78507b6212490bd3da76bcab84e73f1b263c46cb","after":"a4ffd7f5c5111718d626b6c5a58fa87b49da91ea","ref":"refs/heads/main","pushedAt":"2024-01-10T19:32:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"DB Backup","shortMessageHtmlLink":"DB Backup"}},{"before":"63cbcbd12f837379cb6feb9ca4cd4a5d318f7aea","after":"78507b6212490bd3da76bcab84e73f1b263c46cb","ref":"refs/heads/main","pushedAt":"2024-01-08T20:35:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Added South Wales to the menu.","shortMessageHtmlLink":"Added South Wales to the menu."}},{"before":"257ebee7d7d6961bc6ed9f6c1989ef8861e82700","after":"63cbcbd12f837379cb6feb9ca4cd4a5d318f7aea","ref":"refs/heads/main","pushedAt":"2024-01-08T19:19:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Fix to points calculation when game scores are tied.\n\nThis issue came to light when submitting results for Northern, S17, M1. Shaun Nelson and Alan Jones scored the same for Whitewater (thought this may be corrected since). The spreadsheet awards points by figuring out rank, then awarding : (total # of players on game - rank + 1), so ties would go eg 29, 28, 28, 26.  I was using a reverse sorted RANK, so my ties were going 29, 27, 27, 26.\n\nIn some edge cases (such as N S17 M1) that one point makes a difference! It gives Alan the same points as John Parkins in the overall results, where they tie on 1.5 points each.\n\n(Was slightly tempted to use @TotalPlayers, but there are other edge cases where not all players play a single machine, so this method of using (COUNT(*) OVER (PARTITION BY Score.MachineId)) should just count the players on the individual machine correctly)","shortMessageHtmlLink":"Fix to points calculation when game scores are tied."}},{"before":"a069179a1ac6e1499dbac5c3173f2276365825f1","after":"257ebee7d7d6961bc6ed9f6c1989ef8861e82700","ref":"refs/heads/main","pushedAt":"2024-01-01T00:09:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Typo fix for Shaun  Happy new year :D","shortMessageHtmlLink":"Typo fix for Shaun Happy new year :D"}},{"before":"c07151ec91d95c21ea49059cabb7d41924aec924","after":"a069179a1ac6e1499dbac5c3173f2276365825f1","ref":"refs/heads/main","pushedAt":"2023-12-31T23:20:52.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Merge branch 'main' of https://github.com/PaulGarnerUk/UKPinballLeague","shortMessageHtmlLink":"Merge branch 'main' of <a href=\"https://github.com/PaulGarnerUk/UKPinballLeague\">https://github.com/PaulGarnerUk/UKPinballLeague</a>"}},{"before":"b0ac7937bf7aa93f98c69982675ec8d5513de08f","after":"c07151ec91d95c21ea49059cabb7d41924aec924","ref":"refs/heads/main","pushedAt":"2023-12-07T22:03:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Update index.php","shortMessageHtmlLink":"Update index.php"}},{"before":"abd6e7b87e475c4b44b43735ee89f4087bbc23f9","after":"b0ac7937bf7aa93f98c69982675ec8d5513de08f","ref":"refs/heads/main","pushedAt":"2023-12-07T21:22:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"Update sql-queries.md","shortMessageHtmlLink":"Update sql-queries.md"}},{"before":"299c314fe1749b568d5f501606ed5fe170a1b381","after":"abd6e7b87e475c4b44b43735ee89f4087bbc23f9","ref":"refs/heads/main","pushedAt":"2023-11-07T19:33:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"PaulGarnerUk","name":"Paul G","path":"/PaulGarnerUk","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12997377?s=80&v=4"},"commit":{"message":"- Added email obfuscation function.\n- Rewrote the contacts page to pull regions/etc from db. Probably need to add 'Staff' as a db table to move the other roles from the page into the db. Don't really want unobfuscated addresses even going to github in the meantime.\n- Added contact details to schedule info page.\n- Minor updates to static pages to add new region (woop!)","shortMessageHtmlLink":"- Added email obfuscation function."}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEUtdS0gA","startCursor":null,"endCursor":null}},"title":"Activity · PaulGarnerUk/UKPinballLeague"}