Wrote a java app that pulls the data from the spreadsheets and displays them in a leaderboard.
Get it here: https://github.com/Karyoplasma/TheHunt2018Leaderboard/releases
Report problems in this thread and have fun watching or hunting!
3 Likes
This is brilliant, thank you. Works flawlessly for me.
1 Like
You’re welcome. I am thinking about creating some client secrets and let people just download it, so they only need a google account. Quota shouldn’t be a problem, it’s 500 requests per 100 seconds per project, no way people are gonna reach that.
1 Like
Hey! I’ve been using the leaderboard yesterday and it was working like a charm. But when i tried to see the leaderboard today it didn’t work. Any ideas how can i fix it? I already tried downloading the json and other files again and it did not help.
1 Like
sadly there is no way to track people like me who dont update their progress regularely but instead only fill in their findings at the end of the hunt
1 Like
It was an error in the code. The Integer.parseInt() method threw a NumberFormatException because one (or more) of the participants blanked out their score. Formerly, I was only checking if there was an error in the spreadsheet (cell content is “#ERROR!”), but I fixed it now by scoring them with 0 points should an exception occur (because that means that they are not properly using the sheet anyway). New release is up! https://github.com/Karyoplasma/TheHunt2018Leaderboard/releases
1 Like
For the next year’s hunt, I’ll write something that edits your progress to the spreadsheet. I am thinking of choosing the drop in the list and then call the sheet API to edit the cell. Not sure how I could prevent abuse and that is my main issue with something like that, but I’ll figure something out for next year (if there will be a Hunt 2019 ofc).
1 Like
give out keys (if that is supported on github). everyone can register and get their own key for their twitch channel that way (maybe make it so that the key is handed out by sending a message from their twitch account to a bot account, that guarantees the key getting into the right hand)
1 Like