These games share the same URL with different capitalization: /batman_returns /Batman_Returns /Ib /ib /mdk2 /MDK2 /Retry <-- /ReTry <-- same names too... /sunset /Sunset
F1 2015 and F1 2016 should be in the Formula One series.
It's based on the runner and the verifier, so no. I have no means to check if something was edited.
Doesn't seem like it, but there could be a sub-category for emulator if there's enough people who want it.
@Ihavenoname248 Looks like the Forums were fixed. Profiles are pretty bad at lower resolutions I agree.
As for the front page, I have a User Style that makes the runs the only thing on front page: http://pastebin.com/Awyx9zLR - May not be an 'official' solution, but it works for those who just want to see runs.
While I'm almost certain this would be included once/if they add a follow button to series, a temporary solution would be to check this link every-so-often for new additions, which is what I do to see what's good to follow. Highlighting "international" lets you find the names quicker.
I do completely agree with you though since it happened to me several times too.
It's just comparing games or users between what they've done.
There weren't that many N64 games released, 388 in total, so I wanted to see how many of them had leaderboards. Impressively, 160 of them (41%) have a speedrun, although not every one of them are on the site yet. I looked through the games without any runs to see if there were any gems worth running. Video links below:
• -- BEATEN! • Forsaken 64 • Lode Runner 3-D • Quake • Chopper Attack • ~~ Starshot: Space Circus Fever ~~ -- No console runs yet. • Command & Conquer • Nuclear Strike 64 • Winback: Covert Operations • Turok: Rage Wars • Battlezone: Rise of the Black Dogs • Armorines: Project S.W.A.R.M. • Extreme-G 2 • Micro Machines 64 Turbo • Hexen • Indiana Jones and the Infernal Machine -- No full-game run • Duke Nukem: Zero Hour • Rat Attack! • Ms. Pac-Man Maze Madness • Turok 2: Seeds of Evil -- No full-game run
I've made it something of a goal to get 50% of the entire N64 library at least one speedrun, collectively. If you're looking for a game with little to no competition, I insist you take at look at some of these.
https://docs.google.com/spreadsheets/d/1jZclEEQSHH6Cs8-cjodlfGqB-Hgo3aMYn9QLhA-wLFY/edit?usp=sharing
Literally every leaderboard on the site. Sort it by median time. You can filter it to only include full-game categories.
I found VMware to be fairly intuitive. I recommend a CD or ISO of Windows XP; there's various places you can obtain one. It guides you through your first installation and shows you how to enter/exit control of the virtual machine. Besides that it's like installing windows on a new computer. There's some tweaks I can recommend once you have everything installed and running.
But if you do get too confused along the way I can help out.
AndrewFord may have a better solution, but my solution was to run the game in a virtual machine. It's fairly convoluted but you get the benefit of windowed mode (without losing an arm) and the equivalent of save states, though for this game isn't as necessary.
Added a sheet for most active moderators in the Miscellaneous section. I'd love to know who submitted the runs so I can add more columns for self submitted, among more ideas. I'm interested in the number of runs where the submitter is neither the runner or verifier.
Edit: I made a big mistake with the ranking formula, which has been fixed. It has changed some of the rankings of users.
Updated the main post (which I'll use from now on) with the user statistics. Enjoy~
Idea: A 'gametype' boolean for licensed or otherwise 'officially released' games. It wouldn't be important to have but nice to filter with. I can even check all the games en masse for which ones are and aren't.
Yoshi's Highland is a ROM Hack of Super Mario World 2: Yoshi's Island. Psycho Waluigi is a fan game. Possibly should go in the Mario Fan Games series. F-1 Race should be in the Formula One series.
I'm pretty sure someone has already said something like this but I'll mention it here anyway. I do think that categories could be classed as something like 4 groups: Primary, Secondary, Miscellaneous, and Arbitrary. Names can be different of course. Primary is always shown, Secondary is shown by default, Miscellaneous is hidden by default, and Arbitrary is always hidden. Most of the 'meme' categories would fall under the bottom group.
I don't think it would require much restructure of the database since it's just converting a boolean to a byte, and the existing categories get set to 0 for main categories and 2 for misc.
I wouldn't see why not seeing how many other games have NG+. It's just be its own category.
I don't think this person quite understands how the site works: https://www.speedrun.com/slendermans_shadow
Not requesting anything, just needed to point that problem out.
@kirkq It's what listed in the API: https://www.speedrun.com/api/v1/gametypes
I like to gather information from the API to see patterns and rankings and would like to share. To use Google Sheets like a pro, hover over the letters above the headers to show a button. Click said button to sort, filter, etc.[section=User Statistics]The complete table can bee seen here. Warning: Very large and laggy https://docs.google.com/spreadsheets/d/14TIzVw8lVjoRV-ayy19E-10f442ptOnFrmd5P4vJF9M/edit?usp=sharing There's also a more compact version, though it's still quite large.
Here are the stats gathered for everyone and used to rank with:
• Game Count • Game Count (with a full game run) • Leaderboard Count • Full Game Leaderboard Count • Run Count • Full Game Run Count • 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 • Sum of Weighted Records (Alternate, see below) • Sum of Weighted Full Game Records (Alternate, see below) • Best Weighted Record • Best Weighted Record (Alternate, see below)
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
Notes/Comments:
- There's separate columns for full game leaderboards. It also requires the median time of the leaderboard to be at least 5 minutes long. This removes virtually all runs that should be considered ILs instead with only a few getting hit with a false positive.
- 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.
- The formula that I used for 'RankWeight' is quite a doozy. People from last time might remember I was trying to improve the previous one and I think I got something pretty solid: [PlayerCount]^0.9375/[Position]^(1/3¤([RunTime]/[WRtime])^8) For leaderboards with only 1 player, that run would be worth 1.0 in ranking. The ^0.9375 is to slightly clamp the max value of a WR for larger leaderboards. Going down the leaderboard divides by the position, but doing that without clamping that too punishes positions close to 1st. If 2nd is practically the same as 1st, it'll still get about 80% of the worth of 1st. That's done so that 1st still has value while comparing to 2nd. But if the times are too different, times below 1st are punished HARD with the ratio between the time and 1st place's time; that's done with ([RunTime]/[WRtime])^8.
- The "alternate" variation of 'RankWeight' uses all runs submitted, instead of only the ones visible on the leaderboard. SMS Any% Has 763 runs visible on the leaderboard, but has had 2759 submissions, and the latter is used. This is beneficial to runners who are adamant on one game.
- Racingmonster has been removed for deliberately gaming the statistics. They're arbitrary as hell, yet he's persisted. If you want to see why, look at his profile. FailFish [section=Top Users]Subjectively, these are some of the 'top' speedrunners on the site based on the significance of all their records. See comments above for the method used: • Vallu -- Has a lot of really good positions on the popular Super Mario games, among others • TGH -- The God-Emperor of Undertale, having WR on nearly every leaderboard • nindiddeh -- SMS Any% WR holder, and top 3 in the two main SM3DW categories • darbian -- Super Mario Bros Any% WR holder, with other notable records • Xiah -- SM64 16 Star WR holder, among a few others • Torje -- OoT Any% WR holder, the leaderboard with the most players • Levaten -- 2nd in SMS Any% and 1st in two other categories • SigotuSM64 -- SM64 70 Star (Emulator) WR holder. Runs a great number of SM64 hacks • Jumpyluff -- Highly prolific runner • skater82297 -- 2nd place OoT Any% holder • cheese05 -- WR holder for SM64 70 and 120 Star on N64, and 2nd for 70 VC and 120 Emu. • GreenDeathFlavor -- Top records in Super Mario World, among a few others • Oatsngoats -- Super Metroid Any% WR holder, along with other categories • Xelna -- ALTTP No Major Glitches {Any%} WR holder, along with other categories • MrsGizamaluke -- King of Diddy Kong Racing for both full-game and track records • werster -- Former Pokémon Red/Blue champ but still maintains great times for the series • Area51 -- SMW 11 Exit WR holder • BiiWiX -- Portal Inbounds WR holder, among other records • SSBMstuff -- Arguably the best Spyro player for the first three games • Snap -- Luigi's Mansion Any% and No OoB WR holder • zoast -- 2nd place in nearly every Super Metroid category. 1st for Low% (Ice) • Aliensqueakytoy -- 2nd for OoT All Dungeons, No IM/WW, and 5th for Any%. • Biinny -- ☕
For individuals with a #1 position (followed by #2): • Game Count ------------------------------- Dugongue @ 351 ---------------- Jumpyluff @ 209 • Game Count (with a full game run) ---- Dugongue @ 278 ---------------- Jumpyluff @ 158 • Leaderboard Count ----------------------- Dugongue @ 593 ---------------- PrinceRallis @ 537 • Full Game Leaderboard Count --------- Dugongue @ 345 ----------------- Jumpyluff @ 245 • Run Count ---------------------------------- Arcxire @ 949 -------------------- PrinceRallis @ 870 • Full Game Run Count -------------------- Cyberdemon531 @ 447 --------- Dugongue @ 348 • World Records Held ---------------------- MannedTooth @ 348 ---------- superlinkgod @ 305 • Full Game World Record Held ---------- RPGodfather @ 67 -------------- sun100 @ 62 • Top 3 Records Held ----------------------- MannedTooth @ 376 ---------- PrinceRallis @ 373 • Full Game Top 3 Records Held --------- Dugongue @ 179 --------------- RPGodfather @ 107 • Sum of Weighted Records --------------- Vallu @ 1188.66 ------------- FreeRunnerGuys @ 968.25 • Sum of Weighted Full Game Records - Vallu @ 988.17 -------- TGH @ 943.67 • Sum of Weighted Records Alt ------------ TGH @ 2223.11 ------------ Vallu @ 2131.28 • Sum of Weighted Full Game Records Alt - TGH @ 2223.11 ----------------- nindiddeh @ 1925.74 • Best Weighted Record -------------------- Torje @ 561.91 (OoT Any%) ------- nindiddeh @ 503.93 (SMS Any%) • Best Weighted Record Alt ---------------- nindiddeh @ 1681.53 (SMS Any%) - Levaten @ 1146.63 (SMS Any%)
The best Jack of All Trades (comparing everyone's worst rank) are:
- Vallu (#231)
- Pull (#236)
- SigotuSM64 (#415)
- Konasumi (#519)
- CartoonBuffoon (#580)
- Jumpyluff (#587)
- werster (#617) 8) Halodude (#619)
- SoloQ (#621)
- Zetrile (#626)
And for average:
- Jumpyluff
- Dugongue
- Vallu
- werster
- RPGodfather
- authorblues
- SigotuSM64 8) darbian
- Toad22484
- Jcool114 [section=Game Statistics]List of all the games on the site by their activity (as of 2017-08-10): https://docs.google.com/spreadsheets/d/1WZZbpN7KWMv5nIbVm6C8uwm6g8kpTJTA9GrHgvGkj88/edit?usp=sharing
The larger the number, the more active a game is. You can sort the columns by hovering above the headers and clicking the arrow. Here's a quick slice of it:
- Super Mario 64 -- 169 active players
- Super Mario World -- 80 active players
- PAYDAY 2 -- 73 active players
- Super Mario Bros. -- 68 active players
- Super Mario Sunshine -- 65 active players
- The Legend of Zelda: A Link to the Past -- 60 active players
- Super Metroid -- 60 active players 8) Destiny -- 56 active players
- Mario Kart Wii -- 55 active players
- Splatoon 2 -- 53 active players
- Portal -- 52 active players
- The Legend of Zelda: Ocarina of Time -- 51 active players
- Mario Kart 8 Deluxe -- 49 active players
- Refunct -- 49 active players
- Super Mario Galaxy -- 46 active players
This sheet includes more columns than the last sheet I had because of the addition of the game stats page. The main activity value being used, player activity, is based only on the number of players running the game and is different from what was used last time.[section=Leaderboard Statistics]This one didn't take long since the base of it was used for the games query. Here's a list of all the leaderboards (with at least one run) on the site by their activity (as of 2017-08-10): https://docs.google.com/spreadsheets/d/1F1mD_8DzZFcqiDO0FLQMakuIo6ufYAabyMLtvFXZASE/edit?usp=sharing
The top ones are similar to the games sheet:
- Super Mario 64 - 16 Star {EMU} -- 54 active players
- Super Mario Bros. - Any% -- 35 active players
- Refunct - Any% {Normal} -- 34 active players
- Super Mario World - 11 Exit -- 35 active players
- Super Mario Sunshine - Any% {Normal} -- 27 active players
- Super Metroid - Any% -- 28 active players
- The End Is Nigh - Friend% -- 25 active players 8) Super Mario 64 - 70 Star {N64} -- 23 active players
- Luigi's Mansion - No OoB -- 22 active players
- Portal - Glitchless -- 20 active players
- Crash Bandicoot: N. Sane Trilogy - Crash Bandicoot {Any%} -- 21 active players
- The Legend of Zelda: A Link to the Past - No Major Glitches {Any%} -- 18 active players
- Super Mario 64 - 16 Star {N64} -- 18 active players
- Super Mario 64 - 120 Star {N64} -- 17 active players
- Super Mario Galaxy - Any% {Mario} -- 17 active players
Things like views aren't included as that's not provided by the API.[section=Miscellaneous Statistics]• Nothing at the moment.
By the way, if there's anything in particular anyone would like a sheet of, you're welcome to make a request.