This change is being deployed now!

Regardless, I think the last thing to fix is ensuring a leaderboard containing a player with no valid PUUID can still refresh correctly (just ignoring that player) so that they don't break the whole leaderboard.

With a bit more fine-tuning of the script and running it for longer (ie. through more of the matches stored by Riot), it seems possible to recover a few more PUUIDs, but a lot of these leaderboards are inactive.

There were approximately 300 summoners with "dangling entries" where their PUUID was unresolvable via simple lookup.

I wrote a script to go back through related players' match histories to try to search for games with both players in them, and this was able to resolve ~200 of those records.

Pushed another change that should fix the issue with new leaderboard creation. At this point I think the site is back to normal, with the possible exception of some users who name-changed after the last time they refreshed on the site, leaving them PUUID-less (investigating ways to solve this).

I noticed some entries in the database were missing PUUIDs (the new identifier that I needed to migrate to), so I wrote a quick script to backfill whatever values were possible — this should help "fix" more refresh problems.

Fix for leaderboard creation is still pending.

Once I do a bit more testing, I should be able to launch support for VN and TW as well, assuming the Riot API access works the same as it does for everywhere else.

The site did not support SEA until now because back when the SEA servers were run by Garena, the Riot API did not return any data for the region, and I didn't realize that Riot took over server management from Garena back in 2023.

Thanks to the Reddit user who pointed this out to me!

I'd also like to localize into other languages, prioritizing Japanese (since that's where most of my audience is), but I want to do this properly rather than rush it.

Fortunately, I intentionally used minimal writing in the UX, so I like to think it's fairly useable regardless of language already.

One thing that will be much harder to build due to zeal.gg being written as a React SPA is dynamic OpenGraph images, which would allow link previews to render the chart.

This would be super nice, but involves figuring out how to prerender these images dynamically on the backend.