United StatesHere's a list of PC Platformers on the site I could dig up: http://pastebin.com/1f5q1XVk
It's not all encompassing, it's the games that have Platformer tagged on them.
They're hard deleted, unfortunately. But you're in luck, I crawled the database about 10 days ago and seem to have found your runs. You'll have to resubmit them manually.
https://docs.google.com/spreadsheets/d/1S5Ejpk5hOj715DClNttykLnyQMISJHg8bJDwlRtMqOU/edit?usp=sharing
And some other runs the sheet doesn't have: /run/7z0n418m /run/pydgx50y /run/jy96q0ny /run/9mee5x8m /run/pydgx60y /run/8m724qwz /run/9mrope7m
The Mega Man leaderboards aren't here at request of the runners at Mega Man RTA Leaderboards. You can submit your run over at http://megamanleaderboards.net/index.php?game=28 .
[quote=kirkq]Also user contact info buttons appear to be broken right now, at least for me?[/quote]
You mean the links to things like Twitch and Twitter? Those work just fine for me.
That's odd. I checked the API and there doesn't appear to be duplicates. The page has been updated and seems to have resolved itself. If it comes up again be sure post here again.
I have no knowledge how the backend database is structured, but would creating Leaderboard IDs help streamline things?
Keeping track of speedrunning records come down to two core things, the speedruns and the leaderboards. While speedruns can have a large number of variables (Platform, Platform version/edition, Game, Game version/edition, category [what the run does]), leaderboards combine different runs if they met the conditions. This means that if a run meets all the requirements of a leaderboard, it's added to it. This means from the database's point-of-view, leaderboards are the collection/query of runs that that meet a criteria, sorted and ranked based on a leaderboard's settings.
How it gets organized/managed on the frontend is its own issue. Since leaderboards are technically independent of their game(s), they'll need a place to stay. Most leaderboards won't have complications since they're tied to one kind of game, but for games with leaderboards that are both combined and separate (eg Any% allows two versions but 100% has them separate) it gets tricky. The 'games' on the website are a very effective method of organizing them, since they don't have to have strict definitions of game/platform/region/etc; they're like the leaderboards in being a collection/query of runs, but instead, leaderboards. Once in a 'game' they can be customized how they're organized and displayed (tabs/sub-tabs for full-game, tables for levels, etc).
A benefit to this would let users add PBs with leaderboards not being displayed, so as an example I could submit a run for Super Metroid that would display in my profile, but wouldn't appear on any visible leaderboard (rank would display as nothing). This would also address the difficulty category problem I mentioned a while ago.
There are some problems with this, but with possible solutions. • If leaderboards are independent of 'games', that would mean moderators would be tied to them. They could be inherited by the 'games' they're categorized into. For leaderboards shared across 'games', most of said 'games' would have the same moderators so there's no major conflict. • People can individually make their own leaderboards, without needing to ask moderators for a 'game'. This is stopped by the moderators deciding to allow the leaderboard on the 'game'. If they attempt to make a new 'game', site moderators would catch those, and if it manages to still slide by, they can be contacted. Whether or not a leaderboard deserves a spot on the site is a problem that exists now, but this could potentially help relieve that. • How a 'game' manages all the leaderboards could turn into a swamp if there's a large number of them (Portal Ball has 7058). 'Game' and leaderboard metadata would let them be grouped them together so they can be edited in bulk if necessary.
[quote=Gyoo]That's why I delete games that don't even have a category set up 2 weeks after their creation.[/quote]
If the moderator(s) aren't even willing to put forth the effort into making a category, then they probably shouldn't have been made moderator(s) in the first place. Removing the game in that case is completely justified.
Having games with no runs has its pros and cons. If a game has no run and someone searches for it, there may be motivation to do a run since there's no competition; it lets people know the game can be ran. That, and it lets there be a forum for discussing the game. However, run-less games would clutter the site and possibly bog the database down.
I would help with this thread, but kirkq's message suggested only staff should handle the requests.
[quote=kirkq]Also for anyone not aware, only Admin (badge) and Full Mod (Yellow sword) are official posts in this thread.[/quote]
Sure, just ask here https://www.speedrun.com/The_Site/thread/be179 :)
/run/7yl727rm & /api/v1/runs/7yl727rm <- How does the site report the time as no loads but the API reports the time as real time? I assume it's related to how they're both dealt with on the backend?
You can make a thread to discuss allowing/banning the glitch; I would even suggest doing so.
I dug in the API to find the run you're referring to.
[quote=LivingLooneyBin]Rejected: If you do the infinite ammo glitch, it needs to be part of the run and timed. This is the case with all games that have a glitch that is done before starting[/quote]
and the rules for "NG+ any% PC" state
[quote]Single segment, rta, must create a new game + save file.[/quote]
If it's not stated in the rules, then it's not an invalid run. The glitch is similar to how Banjo-Kazooie and Donkey Kong 64 handle their NG+ categories (which is what they are, whether or not they want to admit it). This glitch should have been discussed beforehand. If it satisfies the conditions of the rules, then it's a valid run; do not enforce something that's not in the rules.
And as for "This is the case with all games that have a glitch that is done before starting" -- Banjo-Kazooie does exactly NOT this.
Since you've set the precedent by being the first runner for a later campaign, you can decide how it's allowed. You could require Illidan's inventory be empty, simplifying things in several ways, or allow item importing, which would have the runs include routing the Human Campaign to get the best setup. The latter would really be NG+ since said setup wouldn't be included in the time (which is frustrating when other games allow it).
[quote=andypanther]With many new runs appearing on the front page, there is a noticeable delay until they actually appear on their leaderboards as well. Am I the only one to get this?[/quote]
I think there's a order things get updated. I've noticed new posts in games I follow before being notified about it.
