Pinball - Player Profile High Score Corner

[emb417]

Show data around players high score corner tables.

• what percentage of tables with high scores posted
• Rank against other players with high scores posted (leaderboard too?)
• Random high score table without high score to encourage more tables
• Link table to high score corner and link to high score corner for all tables

Split from #15 which has background to this issue.

[emb417]

https://virtualpinballchat.com/#/high-score-corner

https://virtualpinballchat.com:6080/api/v1/scoresByVpsId

https://virtualpinballspreadsheet.github.io/vps-db/db/vpsdb.json

[emb417]

The VPC API returns scores for various versions of tables using the table id. The VPS json file includes the table ids as a nested object (table files) within a larger "table" object. The larger table object includes table files and b2s files, plus other metadata specific to this named table.

The plan:

• Start with the list of tables in the VPS json as the primary set of all tables someone could play.
• Then iterate over the tables in VPC high score API, looking for tables where the player has a score
• Player scores for a table should be deduplicated by the primary set, then count the deduplicated list towards their overall played list

The reason for deduplicating is if someone played version 1 of medieval madness, we shouldn't expect them to play versions 2 through 7 to count towards the overall goal of playing all tables. The more difficult problem to solve is when tables go through revisions...does the counter reset? Do all revisions count towards 100%?