A brainstorm idea I had was 4 kinds of category types (at least for full game). Primary, which is always shown; Secondary, which is visible by default; Tertiary, hidden by default; and Arbitrary, always hidden until clicked by the viewer.
They do plan on adding months to the release date, which should fix that.
I've noticed the issue for some time and it became obvious once I did the same thing as you. Real Time and No Loads fill the same spot when the one of the two is missing. I've mentioned it on GitHub and SgtKabukiman plans on fixing it (at least for the API). Lighnat0r has mentioned the back end is currently a swamp.
It would make a 'sweet jesus get out of my way I just want to click that thing' problem.
It's because of milliseconds. PredAtr1990's run is saved as 2:54.250 in the database, even though it's not showing.
I know custom deci/centi/millisecond displays are planned; it'd also be nice to enable entering them regardless of settings. Displaying milliseconds has to deal with how organized the leaderboards look. For archival/position reasons it should always be an option to enter, but how it displays remains as a setting.
Relevant to this thread. List of games with pending runs (on 2016-06-05): https://docs.google.com/spreadsheets/d/1ejpOksK7KDkH9csdJfz35vsbJsBpAEoBAXVMFT8RZbw/edit?usp=sharing
As per this thread you can ignore the games whose total days waited are less than 21 days. Positive difference means how long it's been since the last verification in the game. Negative difference means the runs are either being deliberately ignored or bugged in the database.
They've added the Guardians faction since. They can be added as a category once someone has a run, so it doesn't look to cluttered.
Try messaging the game's moderators or asking about it on the game's forum: https://www.speedrun.com/sh3/forum
Added a means to exclude most absurdly long runs from being added into Total Time. Runs with times higher than the upper limit of the interquartile range of the leaderboard aren't included in time related calculations. Runs that are too extreme are removed entirely. ZooKetra and Stingrayy should be ashamed of themselves D:<
It's not fool proof, mods who want to skew their stats up can just make enough fake runs, though if I catch anyone doing that intentionally I'll permanently remove them from the stats. If they try to use someone else, I'll notice by submitter/verifier.
There are a few run that really should be included, but aren't, so I'll adjusted it until it looks right.
Posting is fine, but ^ doesn't really contribute anything to the threads, especially when the relevant users have already seen the post. Try using the Like button instead.
AFAIK it's not considered emulation since it's just hosting the operating system. I use it for the games I run since they don't work properly without full screen, and it's a work around it.
[quote=andypanther]Could you get "Unique Run Count"? I'm just assuming that you currently count obsolete times too.[/quote]
Unique Leaderboard Count/CategoryCountAll is exactly that.
Separate post for reading sake.
For individuals with a #1 position (followed by #2):
• Run Count ------------------------------------- Nordicboa @ 543 ------------------------ Racingmonster @ 542 • Full Game Run Count ----------------------- Jumpyluff @ 302 ------------------------ Cyberdemon531 @ 187 • Unique Game Count ------------------------ Jumpyluff @ 159 ------------------------- Dugongue @ 141 • Unique Leaderboard Count ---------------- Racingmonster @ 480 ----------------- Jumpyluff @ 355 • Unique Full Game Leaderboard Count - Jumpyluff @ 236 ------------------------ Dugongue @ 185 • Total Time ------------------------------------- Baffan @ 1476:09:38 ------------------- 360Chrism @ 645:40:35 • Total Full Game Time ----------------------- Baffan @ 1476:09:38 ------------------- 360Chrism @ 645:40:35 • Run Activity ------------------------------------ portal @ 118.07 -------------------------- Racingmonster @ 101.81 • Full Game Run Activity --------------------- portal @ 55.07 ---------------------------- Twyn_o @ 42.20 • Time Activity ----------------------------------- Baffan @ 84.15 -------------------------- portal @ 58.70 • Full Game Time Activity -------------------- Baffan @ 84.15 -------------------------- portal @ 57.29 • Combined Activity ---------------------------- portal @ 176.77 -------------------------- Racingmonster @ 117.53 • Full Game Combined Activity ------------- portal @ 112.36 -------------------------- Baffan @ 85.69 • World Records Held ------------------------- Racingmonster @ 224 ----------------- Fe @ 183 • Full Game World Record Held ------------ werster @ 59 ----------------------------- Dugongue @ 56 • Top 3 Records Held ------------------------- Racingmonster @ 387 ----------------- Dugongue @ 242 • Full Game Top 3 Records Held ---------- Dugongue @ 121 ------------------------ Jumpyluff @ 113 • Sum of Weighted Records ----------------- Racingmonster @ 389.95 ------------- TheWinslinator @ 297.96 • Sum of Weighted Full Game Records -- Jumpyluff @ 172.40 --------------------- Dugongue @ 135.45 • Best Weighted Record ---------------------- skater82297 @ 27.44 (OoT Any%) - bounceyboy @ 24.00 (SMS Any%)
The best Jack of All Trades (comparing everyone's worst rank) are:
- Mhmd_FVC (#157)
- TheFuncannon (#304)
- Vallu (#324)
- Racingmonster (#332)
- Jumpyluff (#398)
- Kobral (#469)
- Saiyanz (#474) 8) Rubberduckyassassin3 (#481)
- pikachulikespie (#544)
- ThePackle (#575)
And for average:
- Jumpyluff
- Racingmonster
- Cyberdemon531
- portal
- Rubberduckyassassin3
- Mhmd_FVC
- Redlof 8) 360Chrism
- TheFuncannon
- crrool
Notable mentions: • RPGodfather - The gap between his worst and 2nd worst rank is the largest (2988 vs 281). He could the 2nd best Jack of All Trades if he can improve his Best Rank, though to get there he'd need a WR run that beats about 27 other players. • Cyberdemon531 - All his other ranks would put him above Mhmd_FVC in Jack of All Trades, but like with the above, he'd need a better Best Rank. He'd need a WR run that beats at least 43 other players to get there, ouch. • Removing Activity from the calculations doesn't make a huge change in positions, but portal takes a huge fall since his top stats are all for activity, while Dugongue gets the largest boost since he's been gone for a little while. Kobral would be the #1 Jack if it wasn't for activity. • werster, Pull, Jcool114, and mike89 would be in the top 10 Jack of All Trades, if activity was excluded. • Opting to use standard deviation over ranking results in mostly the same. Best positions remain identical; Demolition14 and Nord enter the top 10 jack of all trades; and Dugongue, werster, PrinceRallis, and Deln enter the top 10 average.
Bonus -- The best median users:
I made a sheet with player statistics. Warning, it's fairly large and may be a bit laggy: https://docs.google.com/spreadsheets/d/1NsM3cCofvnlpUeZcrluS8q7fUMHAjFb0-susGnI9mM4/edit?usp=sharing
Here are the stats I gathered for everyone and used to rank with:
• Run Count • Full Game Run Count • Unique Game Count • Unique Leaderboard Count • Unique Full Game Leaderboard Count • Total Time • Total Full Game Time • Run Activity • Full Game Run Activity • Time Activity • Full Game Time Activity • Combined Activity • Full Game Combined Activity • World Records Held • Full Game World Record Held • Top 3 Records Held • Full Game Top 3 Records Held • Sum of Weighted Records • Sum of Weighted Full Game Records • Best Weighted Record
To the right of the sheet are rankings, depending on how you value things. • MasterOfOne ranks a player's best rank, from any one stat • AverageRanking does exactly that • JackOfAllTrades ranks a player's worst rank, from any one stat • MasterOfMasters compares everyone's best rank, across all ranks • AverageAverage works similar to the above and below • JackOfJacks compares everyone's worst rank, across all ranks • And Weakest Link is what the player's lowest rank is. Most peoples' are Best Weighted Record.
Notes/Comments:
- Separate Full Game was used since ILs can inflate positions more than they should. That, and people generally like full game runs more than individual levels, except for best of compilations, which I enjoy (doing).
- Combined Activity is the same as Activity on the site for games. It's Run Activity + Time Activity.
- Weighted records are [NumberOfPlayers]^0.5/[Position]. Ocarina of Time Any% has 753 records, so the WR holder would have 27.44, 2nd place 13.72, 3rd 9.15, etc. It's slightly skewed as it includes emulator runs regardless of settings. I may end up changing how it's calculated.
- Proper separation of Full Game and Level is dependent on the games' moderators. Halo Co-op is an example where level categories are classified as full game. I can't do much about it unless I manually adjust them when calculating.
- It does not know when a leaderboard is sorted descending, such as Metroid Prime's Frigate Escape. The API currently does not supply that information. Even if it did, I'm not entirely sure how to go about implementing it.
- -- Found a work-around. Using Excel to help with this for now. Shaved off 11% of the total time, most of which were from fake runs. Next time I make stats it'll exclude those runs' times.
Here's the link until they do:
http://www.ludumdare.com/compo/ludum-dare-16/?action=preview&uid=1081
The game is an absolute blast. I played the translated version about ten years ago and revisit it every so often. It plays like Fire Emblem but with Dragons . You can also raise your Dragons into what you like, with LOTS of variety. It doesn't have any connection to the Final Fantasy series but is great on its own. I strongly recommend playing it at least casually.
Determining the right moderators for a game will always be a problem. One might think they have better direction with a game than another. Actually running the game gives credibility but there's feuds between runners as well. There's no easy solution for the admins to implement and has to be handled case-by-case.
Once someone has done a run of it, preferably.