{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":312678061,"defaultBranch":"master","name":"trends.tf","ownerLogin":"Forty-Bot","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2020-11-13T20:36:56.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/4086155?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1679854523.0","currentOid":""},"activityList":{"items":[{"before":"c67bce77029cb9defad0113ac23e7cf2696bbd7a","after":"8a235698da21156f549b25cb320efbaa4a58bf69","ref":"refs/heads/master","pushedAt":"2024-08-31T03:49:29.000Z","pushType":"push","commitsCount":6,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: Add some IAQ entries about linking logs and matches\n\nAlthough I personally find the conditions in link_matches and link_demos\npretty simple to understand, not everyone is equipped to dive into the\nsource. Add some IAQ entries on the linking conditions for logs and\ndemos.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: Add some IAQ entries about linking logs and matches"}},{"before":"a242072e74a9e8d4d677a0cf12ff8c8234bc0b67","after":"c67bce77029cb9defad0113ac23e7cf2696bbd7a","ref":"refs/heads/master","pushedAt":"2024-07-12T13:20:19.000Z","pushType":"push","commitsCount":6,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"Decrease the sample rate again\n\nWe have too many requests for the free tier, so decrease the sample rate\nagain.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"Decrease the sample rate again"}},{"before":"fdf7439b6512f1aa5916a3d42ce18d32bb14456b","after":"a242072e74a9e8d4d677a0cf12ff8c8234bc0b67","ref":"refs/heads/master","pushedAt":"2024-06-04T04:45:50.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"CI: Install trends package\n\nInstall ourself so that we fetch our javascript deps.\n\nFixes: 117c6fa (\"site: Vendor javascript dependencies\")\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"CI: Install trends package"}},{"before":"2867946b2c02125e4a8764fc811566b4be59c06a","after":"fdf7439b6512f1aa5916a3d42ce18d32bb14456b","ref":"refs/heads/master","pushedAt":"2024-06-04T04:09:51.000Z","pushType":"push","commitsCount":12,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"Add support for killstreaks\n\nAdd support for parsing killstreaks from logs. These can be useful for\nfinding clips for frag movies. I didn't add them to the totals page\nsince as an extrema-based statistic, the only thing we can really show\nis max/count. I think those are better shown on the logs page.\n\nCloses: #75\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"Add support for killstreaks"}},{"before":"27b7cfb370578573c837a54435dd74144ac0c38a","after":"2867946b2c02125e4a8764fc811566b4be59c06a","ref":"refs/heads/master","pushedAt":"2024-05-17T20:01:58.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: Remove space after class icons\n\nClass icons look a bit funny in column headers since they always have\nspace after them (from the trailing newline). Remove it.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: Remove space after class icons"}},{"before":"4edf9ff2d1d4388cbb0954d570d10489e7bfa7f0","after":"27b7cfb370578573c837a54435dd74144ac0c38a","ref":"refs/heads/master","pushedAt":"2024-05-17T17:41:46.000Z","pushType":"push","commitsCount":7,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"schema: Improve medic_cube refresh time\n\nJust before wrapping up 2245249 (\"site: Add medic leaderboard\") I\nswitched to a lateral join. However, this has worse performance than a\nregular join, so switch back.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"schema: Improve medic_cube refresh time"}},{"before":"72995d22d29760b0fbfcf14efa3b56aac43fffa5","after":"4edf9ff2d1d4388cbb0954d570d10489e7bfa7f0","ref":"refs/heads/master","pushedAt":"2024-04-13T20:04:37.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: leaderboard: Fix intra-page sorting\n\nWhile overall sorting might be correct, leaderboard results within a page\nare not sorted correctly. Fix this by ordering again after joining.\n\nFixes: efcdaf0 (\"Add leaderboard\")\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: leaderboard: Fix intra-page sorting"}},{"before":"3d84f7f5c8b93eef74559a0f3fadace01f3b2204","after":"72995d22d29760b0fbfcf14efa3b56aac43fffa5","ref":"refs/heads/master","pushedAt":"2024-04-13T15:24:12.000Z","pushType":"push","commitsCount":5,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"importer: etf2l: Fix since argument parsing\n\nWe expect values of since to be datetimes.\n\nFixes: 481a320 (\"Support importing ETF2L matches\")\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"importer: etf2l: Fix since argument parsing"}},{"before":"1aede63d7df5a4ef635c5058493b0682a7d8a3ed","after":"3d84f7f5c8b93eef74559a0f3fadace01f3b2204","ref":"refs/heads/master","pushedAt":"2024-03-05T05:59:51.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: Fix filtering by players\n\nI forgot a plus.\n\nFixes: 8ab119f (\"site: Fix filtering for players without avatars\")\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: Fix filtering by players"}},{"before":"a9ae28bb42f1b58ff2df3a150dc0c79aec40dd82","after":"1aede63d7df5a4ef635c5058493b0682a7d8a3ed","ref":"refs/heads/master","pushedAt":"2024-02-24T15:17:37.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"Update ban script for playerid\n\nUpdate the ban script to handle playerids.\n\nFixes: d9a4651 (\"Migrate steamid64 to playerid\")\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"Update ban script for playerid"}},{"before":"51f31d276c23d840e809a173f54d39659475e568","after":"a9ae28bb42f1b58ff2df3a150dc0c79aec40dd82","ref":"refs/heads/master","pushedAt":"2024-02-23T03:32:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"importer: Fix updated < time violations due to clock skew\n\nThere can be some clock skew between us and logs.tf. This could result in\nour local updated time being less than the log's time, violating the check\nconstraint. Fix this by taking the greatest of now and time. When updating\nlogs, take the greatest between now and updated + 1 (to ensure updated\nalways changes).\n\nFixes: 7aed5b6 (\"Add updated field to logs\")\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"importer: Fix updated < time violations due to clock skew"}},{"before":"de79028f63c2a5520b0befca449a1d02176c95ed","after":"51f31d276c23d840e809a173f54d39659475e568","ref":"refs/heads/master","pushedAt":"2024-02-23T03:23:27.000Z","pushType":"push","commitsCount":6,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: api: Add score to logs API\n\nAdd score to the logs api. This is effectively free, and makes it possible\nto e.g. do statistics based on who won.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: api: Add score to logs API"}},{"before":"927f7a2309a98138586acf0c10840bdbef0c7c2e","after":"de79028f63c2a5520b0befca449a1d02176c95ed","ref":"refs/heads/master","pushedAt":"2024-02-19T23:20:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: api: Support excluding duplicates from logs results\n\nThis allows excluding duplicates from logs results, which is almost always\nwhat you want unless you are looking for a particular log (or are\ninterested in the duplicates themselves).\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: api: Support excluding duplicates from logs results"}},{"before":"87b9c42b5198797e14a0a57348aa5fabcf103b10","after":"927f7a2309a98138586acf0c10840bdbef0c7c2e","ref":"refs/heads/master","pushedAt":"2024-02-19T22:43:49.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: api: Add a next_page field as the canonical next page\n\nSupply a next_page field which fills in the parameters automatically. This\nwill let us move away from limit/offset paging if I ever get around to\ndoing it. Undocument offset as the canonical way is now next_page. The\nimplementation itself is almost directly lifted from the existing\nnavigation macro.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: api: Add a next_page field as the canonical next page"}},{"before":"b0ddf622a557dda0c5de8a38d31602975f9d00f2","after":"87b9c42b5198797e14a0a57348aa5fabcf103b10","ref":"refs/heads/master","pushedAt":"2024-02-19T22:42:19.000Z","pushType":"push","commitsCount":11,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: api: Add a next_page field as the canonical next page\n\nSupply a next_page field which fills in the parameters automatically. This\nwill let us move away from limit/offset paging if I ever get around to\ndoing it. Undocument offset as the canonical way is now next_page. The\nimplementation itself is almost directly lifted from the existing\nnavigation macro.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: api: Add a next_page field as the canonical next page"}},{"before":"fe2dcbc6d4739f89637b15fbeec4a74c078940c3","after":"b0ddf622a557dda0c5de8a38d31602975f9d00f2","ref":"refs/heads/master","pushedAt":"2024-01-23T02:17:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"importer: Allow re-importing RGL matches\n\nThe original import of RGL matches got the teams swapped around in a few\ncases. Allow re-importing to fix these errors.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"importer: Allow re-importing RGL matches"}},{"before":"2dc24846acc54df19d4fdbda2241e3699f664a96","after":"fe2dcbc6d4739f89637b15fbeec4a74c078940c3","ref":"refs/heads/master","pushedAt":"2023-12-16T16:43:57.000Z","pushType":"push","commitsCount":6,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: Use optint for dpm/hpm/hgm\n\nWhen the duration is 0, we dpm/hmp/hgm will be None. Use optint to make\nthis clearer, instead of coercing to 0.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: Use optint for dpm/hpm/hgm"}},{"before":"a1104158b70c1cda95cc1a52abb806c3811304c6","after":"2dc24846acc54df19d4fdbda2241e3699f664a96","ref":"refs/heads/master","pushedAt":"2023-11-25T16:38:26.000Z","pushType":"push","commitsCount":5,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: player: Show first as well as last competition under teams\n\nIt's a bit confusing to show only the most-recent competition for a player,\nespecially if they have been rostered for multiple competitions. Show the\nlast-recent competition as well, to give a better overview of how long they\nhave been on the team.\n\nFinding the maximal/minimal row is such a pain to do in SQL. Switch from\nthe previous method of using window functions to using a CTE and multiple\nselects. While window functions work fine for grabbing either the minimum\nor maximum, they are really terrible for grabbing both (especially when\nthere are NULL rows to ignore. To ensure we don't do a sequential scan on\nmatches, denormalize the first/last scheduled date into competition.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: player: Show first as well as last competition under teams"}},{"before":"e576215760964a9368521c86623483f213d9bf43","after":"a1104158b70c1cda95cc1a52abb806c3811304c6","ref":"refs/heads/master","pushedAt":"2023-11-24T04:35:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: player: Fix teams not being sorted\n\nWe never actually used the order clause for sorting teams. Fix this, and\nmake sure the default order puts more-recent teams first.\n\nFixes: 6ff791d (\"site: player: Add separate teams page\")\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: player: Fix teams not being sorted"}},{"before":"8f17e688222ca77cd77bda09da7b1a67b5f497d0","after":"e576215760964a9368521c86623483f213d9bf43","ref":"refs/heads/master","pushedAt":"2023-11-24T04:22:35.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"site: team: Add redirect for RGL teamids\n\nNow that our internal teamid is a subset (at least for league='rgl') of\nrgl_teamid, we can make all rgl_teamids redirect to their associated\nteamid. This should make it easy to go directly from an RGL teamid to their\npage (such as by copy-paste).\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"site: team: Add redirect for RGL teamids"}},{"before":"01a2083dbff78d22f8493d1f4b631f16831f5c90","after":"8f17e688222ca77cd77bda09da7b1a67b5f497d0","ref":"refs/heads/master","pushedAt":"2023-11-17T23:12:25.000Z","pushType":"push","commitsCount":12,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"test: Add some more endpoints to the filter test\n\nA few of these were added recently, but the comp/players one was never\nadded before this.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"test: Add some more endpoints to the filter test"}},{"before":"62e68bc01f8e4d3adb281c9fffddccaf1f61edb4","after":"01a2083dbff78d22f8493d1f4b631f16831f5c90","ref":"refs/heads/master","pushedAt":"2023-11-17T18:42:02.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"ci: Only install OS dependencies for act\n\nGithub CI already has these packages installed, so we don't need to install\nthem. However, the smaller images provided by act don't have these\ninstalled.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"ci: Only install OS dependencies for act"}},{"before":"0c8172587fb25b3530136b4d972ff6adb4c80370","after":"62e68bc01f8e4d3adb281c9fffddccaf1f61edb4","ref":"refs/heads/master","pushedAt":"2023-11-17T18:38:47.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"ci: Only install OS dependencies for act\n\nGithub CI already has these packages installed, so we don't need to install\nthem. However, the smaller images provided by act don't have these\ninstalled.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"ci: Only install OS dependencies for act"}},{"before":"aeacaa53e880aed844d67a596b2fd26843d7140e","after":"0c8172587fb25b3530136b4d972ff6adb4c80370","ref":"refs/heads/master","pushedAt":"2023-11-17T18:34:43.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"ci: Cache apt packages\n\nTo (marginally) increase build times...","shortMessageHtmlLink":"ci: Cache apt packages"}},{"before":"741522aa5b7126460aa6250e74f0257181b9e2f2","after":"aeacaa53e880aed844d67a596b2fd26843d7140e","ref":"refs/heads/master","pushedAt":"2023-11-17T18:25:13.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"test","shortMessageHtmlLink":"test"}},{"before":"ecf6b19ac6147bf3358bb383b3a62f3ec521016e","after":"741522aa5b7126460aa6250e74f0257181b9e2f2","ref":"refs/heads/master","pushedAt":"2023-11-17T18:23:16.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"test","shortMessageHtmlLink":"test"}},{"before":"7a63fd0f1f9a06bca779f29c0e174093fe192e8a","after":"ecf6b19ac6147bf3358bb383b3a62f3ec521016e","ref":"refs/heads/master","pushedAt":"2023-11-17T18:17:27.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"test","shortMessageHtmlLink":"test"}},{"before":"79f76278a71a21d09e6229f262726f512f3280a5","after":"7a63fd0f1f9a06bca779f29c0e174093fe192e8a","ref":"refs/heads/master","pushedAt":"2023-11-17T18:07:12.000Z","pushType":"push","commitsCount":6,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"test","shortMessageHtmlLink":"test"}},{"before":"c0f07ce92b612329378b5def36bc68b177e1a1e2","after":"79f76278a71a21d09e6229f262726f512f3280a5","ref":"refs/heads/master","pushedAt":"2023-11-17T02:19:37.000Z","pushType":"push","commitsCount":9,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"test: Test RGL\n\nAdd some RGL matches to test the parser/linker. I didn't keep track of\nproblematic matches like I did for ETF2L because there were so many\nproblems with the RGL API itself. So I just picked a few matches which\neither already had logs in the system or give us a chance to test linked\nteams.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"test: Test RGL"}},{"before":"f8bed245c68b6705f004247861a5efa2d519c2f4","after":"c0f07ce92b612329378b5def36bc68b177e1a1e2","ref":"refs/heads/master","pushedAt":"2023-11-11T23:59:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Forty-Bot","name":null,"path":"/Forty-Bot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4086155?s=80&v=4"},"commit":{"message":"Add github actions\n\nAdd some github actions to run the test suite.\n\nSigned-off-by: Sean Anderson ","shortMessageHtmlLink":"Add github actions"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"Y3Vyc29yOnYyOpK7MjAyNC0wOC0zMVQwMzo0OToyOS4wMDAwMDBazwAAAASpML7d","startCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wOC0zMVQwMzo0OToyOS4wMDAwMDBazwAAAASpML7d","endCursor":"Y3Vyc29yOnYyOpK7MjAyMy0xMS0xMVQyMzo1OToyOS4wMDAwMDBazwAAAAOs_ZEd"}},"title":"Activity ยท Forty-Bot/trends.tf"}