FranceThe migration is over and the Discord bot has been updated!
Again, don't forget to subscribe to the new category extensions there: https://www.speedrun.com/sbace , if you want to be aware of the new missions and races records!
This post is cross-posted on Discord.
TL;DR: last migration of runs today, don't forget to subscribe to the new category extensions!
Hi everyone,
Last week, we finally unlocked "Category extensions". Category extensions are an extra place for runs that do not fit in the typical categories. As said in the original post of this thread and as discussed on Discord, there are still some runs in the full-game leaderboard that i'm precisely planning to move to the new category extensions: missions and races. This done, since individual levels runs have already been moved away from the full-game leaderboard, there will be only full-game runs left there 🥳.
Thus, today (February 3), around 1 PM UTC, i will do the second and last part of this migration. This time, only around 80 runs will be moved with the help of the bot. The migration plan is about the same as last time, but this time i don't need to look for ways to work around the bugs and limitations of SPEEDRUN.COM, so it should be much faster 😅.
Again, you will likely get a bunch of notifications, so sorry for the inconvenience. This is the last time, i promise!
What does it change for you? After the migration, you will find the moved runs and also will be able to submit your new runs at the following addresses:
- Missions: https://www.speedrun.com/sbace/Missions
- Races: https://www.speedrun.com/sbace/Races If you want to be notified of any new world record, any new run in these two categories etc., don't forget to also follow the new category extensions: https://www.speedrun.com/sbace
The migration is over and the Discord bot has been updated!
The whole automatic part of the migration was planned to take 16min 30s, however i discovered 2 SPEEDRUN.COM bugs, so i had to find and implement 2 workarounds and to manually edit each of the 619 runs that were moved. Therefore it took me about 7 hours 😅.
Sorry again for all the notifications and feel free to tell me if you see any error!
Sorry for the double post.
I'm trying the workaround, and it seems the API has another orthogonal bug.
In the replacement runs, i set the value of the level, the category and each subcategory i want the run to be in. However the API now responds with HTTP 400 errors, saying something like that: "You have not specified a value for variable xxxxxxxx (Name), but the variable is mandatory.".
The API seems to claim i have to set the value of all IL subcategories, even those that are not in the same category or not even in the same level. This is nonsense, since a given run can't be in several levels and in several categories at the same time.
I found a workaround, but with a major downside:
- Before migrating the runs, uncheck "sub-category" and "required" in the game settings for each variable of the destination leaderboards that is supposed to be mandatory. Unfortunately this erase all the rules, so make sure to have a copy of them somewhere
- Submit the replacement runs
- Go back to the settings and check the checkboxes that you have previously unchecked and add the rules that were previsously deleted by the site
Update on the status of the migration
It appears that SPEEDRUN.COM is buggy and that i can't do the third step automatically without errors. I'm currently exploring a way of splitting the step 3 into two sub-steps: the first would be automatic and the second unfortunately manual. Therefore it will take much more time than expected.
I tried with a bot, but this is actually not a viable way to do that, because the server almost exclusively responds with HTTP 500 errors. It appears you can't submit a run via API on behalf of another user.
In fact, this seems to be a known issue, reported about 2 years ago on GitHub: https://github.com/speedruncomorg/api/issues/87 . Someone, in the GitHub issue, seems to have found a workaround: do not verify runs automatically and do not include any information about the actual player, and then manually verify all the runs and edit the player informations. I have not tried that yet.
This is better than nothing, but manually editing more than 600 runs will take ages.
Does someone actually maintain this API?
This post is cross-posted on Discord.
TL;DR: migration of a lot of runs today, sorry for the notifications!
Hi everyone,
As discussed on Discord several times since last November, i am in the process of moving most of the runs from existing full-game categories to individual levels categories and hopefully also category extensions. This will avoid polluting the full-game leaderboard with runs that do not actually cover the full game, will make the statistics page more clear, and will enable more flexibility for adding new subcategories in the future.
Later today (January 19), around 1 PM UTC, i will proceed to the first part of this migration, that is to say introducing individual levels. More than 600 runs will be moved to brand new leaderboards divided into four levels. Unfortunately, in this case, SPEEDRUN.COM does not provide a way to directly move this runs just by editing them, even for game moderators, so the only way to move these runs is to delete them and resubmit them elsewhere. Obviously, this will not be done fully by hand, but partially automatically with the help of a dedicated bot.
More details are given below.
Migration plan The migration plan is as follow:
- Manually creating empty individual levels leaderboards (already done)
- Automatically taking and saving a snapshot of all the runs that are intended to be moved
- Automatically submitting a copy of these runs to the new leaderboards on my behalf
- Manually restoring the name of the player and verifying each replacement run
- Automatically rejecting the original runs
- Manually updating all the rules
- Manually deleting the old empty leaderboards
- Waiting at most 6 hours
- Updating the Discord bot so it can supports individual levels
What does it change for you? After the migration, you will find the moved runs and also will be able to submit your new runs at the following addresses:
- Turtle Village: https://www.speedrun.com/sba/Turtle_Village
- Snow Valley: https://www.speedrun.com/sba/Snow_Valley
- Beemothep Desert: https://www.speedrun.com/sba/Beemothep_Desert
- Giant House: https://www.speedrun.com/sba/Giant_House Starting version 1.9.6, the links in the game itself will also be updated to point to the new leaderboards, as agreed with the developer of the game.
History conservation During the process, the comment part of your run will be edited to include the informations that would otherwise be lost. At the end of the comments, you will find something like that: "Moderator's note: this run was originally submitted by user [submitter] on [date] and verified by [examiner] on [date]".
Potential issues If you find any error (a run at the wrong place, a run with the wrong time etc.), please let me know and i will do my best to fix it. As said earlier, a snapshot of the runs will be done and will be used to restore any information that may be lost by mistake.
Notifications That said, you will likely get a lot of notifications all at once if you subscribed to the game (maybe not, as notifications are reported to be broken for a few days now). Sorry for the inconvenience.
Fingers crossed!
In a game i moderate, all the existing runs have until now been submitted as "full-game" runs, despite the fact most of them are actually "individual levels" runs.
I'm in the process of moving these runs to equivalent individual levels categories i recently created. But as far as i know, there's no way to move these runs just by editing them.
I considered deleting and resubmitting them manually or with the help of a dedicated bot. However i have concerns about losing some data, in particular the identity of the original examiner, the original verify date and the date the runs were originally submitted.
Is there a better way of doing that, if possible without losing any information?
I don't know if the following bug is already reported. If this is the case, i apologize for the duplicate.
https://www.speedrun.com/sba#Snow_Valley (Maxime subcategory)
On the SBA leaderboard, there's a run whose milliseconds are not displayed.
It shows "0m 12s 000ms" but the actual in-game time is "0m 12s 580ms", as can be seen on the page of the run.
EDIT: i removed the "000" milliseconds in the non-in-game time and it's seems to have fixed the issue as a workaround (it just didn't update immediately in the leaderboard).
By the way, i also confirm the lag that affects new verified runs and that others have already reported.
Since September 19, 2020, the game is also available on iOS (iPhone and iPad).
It would be nice to add the iOS platform in the dropdown when submitting a run for those who would like to speedrun on this platform ;)
The 1.9 update introduced 10 daily missions.
Most of the missions do not show a in-game timer, but some of them have one:
- Rally in Beemothep Desert (i don't know why)
- Egg hunt in Snow Valley (a countdown)
- Egg hunt in Turtle Village (a countdown) So i thought a new miscellaneous category with three sub-categories (one for each mission) would be very cool!
I already recorded one run for each one. The timer disappears when the mission is completed, so i took the previous frame for the time. And for the egg hunt missions, i took the initial time (5min) minus the final time, since the timer decreases.
Could a mod add these categories?
Thanks! I don't think the old runs in the "Giant House" category go in the "All Bears" subcategory: the time is too unrealistic (Viper only takes 3 minutes) But since the videos were deleted...
Could a moderator add the following categories in the "Giant House" tab ? :
- All bears
- All bears except Toast
- Viper
- Thomas
- Joseph
- Toast
- Maya
- Junior
- Claptrap
- Felix The rules would be the same as for the other levels
