Author Topic: Rare WR Database  (Read 5299 times)

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Rare WR Database
« on: July 21, 2015, 05:32:07 pm »
Everyone's favorite historian Quentin has been hard at work on a couple WR database related projects driven by requests from Axel.  The first one we have for you, as indicated by the topic title, is the Rare WR Database.  This site contains all the features of the GE and PD WR databases you've come to know and love, with all the data from both of these databases.  Check it out.  It was determined that the best approach here was to use a combined database for all three sites, so the GE and PD databases are now located here and here respectively.

Let one of us know if you encounter any issues or think anything about these sites ought to be tweaked - Quentin is very quick and receptive about these things.  There is another database coming soon (hopefully), so keep your eyes peeled!  ;)

Luke

  • Posts: 6443
  • Zero-Time P.O.M.
    • Luke
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #1 on: July 21, 2015, 05:56:53 pm »
MVP
LAS

#TeamLevelRotation

Boss

  • Posts: 3977
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #2 on: July 21, 2015, 06:09:52 pm »
Pretty sick looking site. Only odd thing I noticed was some of the player's initials are missing (notably Cedric in PD)

T

  • Posts: 719
  • Qweczol
    • GE
    • twitch
Re: Rare WR Database
« Reply #3 on: July 21, 2015, 06:44:18 pm »
Sick, I would consider adding a "suggest an edit" section on the site

One thing I noticed about my WR time page for example is the usage of 2.x which I used for Dam 53 but the site does not list this

Ngamer

  • Posts: 6137
  • Swagger Personified
    • GE
    • PD
    • twitch
    • thengamer.com
Re: Rare WR Database
« Reply #4 on: July 21, 2015, 08:43:29 pm »
Looks awesome, great work guys!
thengamer. com

Taylor

  • Posts: 607
    • TaylorTotFTW
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #5 on: July 21, 2015, 09:31:49 pm »
thanks

yashichi

  • Posts: 71
Re: Rare WR Database
« Reply #6 on: July 21, 2015, 09:32:31 pm »
Hey guys. TaylortotFTW keeps linking me threads he's made and tells me to post in them so that's what I'm doing

AZ

  • Posts: 5796
    • AxZ
    • 2015CommunityContributor
    • 2017SilverStar
Re: Rare WR Database
« Reply #7 on: July 22, 2015, 08:11:07 am »
Absolutely awesome job Quentin and Woll!

Really cool to finally have a rare WR database. I particularly like the new Combined Duration-page.

1   Bryan Bosshardt   234,474 days

^ looks pretty ridic.

Selenium Webdriver

  • Posts: 3859
    • Ace
    • 2017RankingsDev
    • 2017CommunityContributor
Re: Rare WR Database
« Reply #8 on: July 22, 2015, 08:15:47 am »
640+ years.

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #9 on: July 22, 2015, 01:48:34 pm »
Pretty sick looking site. Only odd thing I noticed was some of the player's initials are missing (notably Cedric in PD)

This was an issue with the data transition and affected players that only had WRs in PD.  I fixed up the data for these players.

One thing I noticed about my WR time page for example is the usage of 2.x which I used for Dam 53 but the site does not list this

Fixed.  This brings up something I thought about asking a while back but never got around to it - does anyone see value in having this information in the WR database?  It probably made more sense originally, but seeing how widespread usage of 2.x has become makes it seem like an insignificant thing to highlight in the database anymore.  Just curious what others think here.

Jimbo

  • Posts: 4025
  • Elite Historian
    • GE
    • PD
    • twitch
    • 2015CommunityContributor
    • 2016RankingsDev
Re: Rare WR Database
« Reply #10 on: July 22, 2015, 09:32:45 pm »
Yeah I think taking out 2.x notations is fine at this point.

Alec M.

  • Posts: 2645
  • TroubleClef92
    • GE
    • PD
    • twitch
    • 2016RankingsDev
Re: Rare WR Database
« Reply #11 on: July 22, 2015, 10:42:05 pm »
Yeah I think taking out 2.x notations is fine at this point.
"Train smarter, not harder" -Mike O'Hearn
GoldenEye Proof Moderator as of February 2015

Botched Movie Quotes

  • Posts: 4422
  • Frankly, my dear, I don't care
    • Karl
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #12 on: August 10, 2016, 01:28:04 am »
Is there any way we can remove Duel A and SA from the pd wr tallies etc?
*Creator of 'waiting half a sec more cutscene' on b2 agent*
*Creator of 'bounce boost' on streets agent*
*Creator of 'strafe change laser skip' on inves*

Boss

  • Posts: 3977
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #13 on: August 10, 2016, 04:13:17 pm »
Most people aren't actually being credited for having Duel 3 and in some cases 6 as they probably weren't posted in WR topic. I would be in favor of removing A/SA from the tallies.

Joshua Nash

  • Posts: 516
  • I sell propane and propane accessories.
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #14 on: August 10, 2016, 04:27:10 pm »
Or someone should just get Duel A 0:02 and SA 0:05 :kappa:

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #15 on: August 10, 2016, 05:16:26 pm »
I'll pass it along to Quentin.

Edit - Honestly at this point it probably would make the most sense to just not even show the Duel A/SA records at all since it's never been an accurate list anyway.
« Last Edit: August 10, 2016, 05:27:06 pm by GoldenGreg007 »

Icy

  • Posts: 1907
    • GE
    • PD
    • twitch
    • 2014SilverStar
    • 2015SilverStar
Re: Rare WR Database
« Reply #16 on: August 10, 2016, 06:10:20 pm »
A ton of them have no date, version, or video attached to them, which is why the list is extremely incomplete. Even some of the PA and LTK 0:09s are like that.

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #17 on: September 11, 2016, 10:27:57 pm »
Alright Quentin made a change to the database to now list Duel 3 and 6 as "Not Tracked", so they should not be factored into any of the pages anymore and are essentially just there to make sure the total time is accurate.  Let me know if anyone runs into any issues as a result of this change.

Also I added Marc's Runway 22 a few weeks ago now, thanks for catching that Jezz.

Luke

  • Posts: 6443
  • Zero-Time P.O.M.
    • Luke
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #18 on: September 11, 2016, 10:45:07 pm »
Duel 9 should also be untracked
LAS

#TeamLevelRotation

Boss

  • Posts: 3977
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #19 on: October 30, 2016, 12:31:17 am »
The Combined Duration level pages don't work properly for GE. They only list the players with the most days and no one else. If you go into PD, it shows every player that has had the WR and how many days.

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #20 on: October 31, 2016, 05:28:22 pm »
Thanks Boss - I passed this along to Quentin and he fixed it.

TheFlash

  • Posts: 2761
Re: Rare WR Database
« Reply #21 on: October 31, 2016, 06:17:32 pm »
*reminder of always open offer to put this on rarewrs.the-elite.net if you want*

Botched Movie Quotes

  • Posts: 4422
  • Frankly, my dear, I don't care
    • Karl
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #22 on: December 06, 2016, 01:30:34 am »
To whomever updates the page...

http://rankings.the-elite.net/~Sim+Threat/time/65615

I updated the date on this time. As per http://ngamer.speedrunwiki.com/geocities/pdarktimes/under3hoursPD.html I definitely got this time as an untied. Though it's not in the wr topic for some reason, I was probs too busy being awesome at everything to post it.
*Creator of 'waiting half a sec more cutscene' on b2 agent*
*Creator of 'bounce boost' on streets agent*
*Creator of 'strafe change laser skip' on inves*

Botched Movie Quotes

  • Posts: 4422
  • Frankly, my dear, I don't care
    • Karl
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #23 on: December 06, 2016, 01:35:36 am »
http://rankings.the-elite.net/~Sim+Threat/time/23585

also updated the date on this time which was an untied as well.
*Creator of 'waiting half a sec more cutscene' on b2 agent*
*Creator of 'bounce boost' on streets agent*
*Creator of 'strafe change laser skip' on inves*

Botched Movie Quotes

  • Posts: 4422
  • Frankly, my dear, I don't care
    • Karl
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #24 on: December 06, 2016, 02:03:21 am »
*Creator of 'waiting half a sec more cutscene' on b2 agent*
*Creator of 'bounce boost' on streets agent*
*Creator of 'strafe change laser skip' on inves*

Botched Movie Quotes

  • Posts: 4422
  • Frankly, my dear, I don't care
    • Karl
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #25 on: December 06, 2016, 02:21:02 am »
As per https://web.archive.org/web/20030327054427/http://www.the-elite.net/PD/

I updated this time http://rankings.the-elite.net/~Sim+Threat/time/44457

was uwr. The archive doesn't show names cause of april fools but shows my color.
*Creator of 'waiting half a sec more cutscene' on b2 agent*
*Creator of 'bounce boost' on streets agent*
*Creator of 'strafe change laser skip' on inves*

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #26 on: December 06, 2016, 08:09:41 pm »
I added these times - thanks Karl.

Botched Movie Quotes

  • Posts: 4422
  • Frankly, my dear, I don't care
    • Karl
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #27 on: December 07, 2016, 12:21:01 pm »
Thanks :)
*Creator of 'waiting half a sec more cutscene' on b2 agent*
*Creator of 'bounce boost' on streets agent*
*Creator of 'strafe change laser skip' on inves*

jezz

  • Posts: 52
    • GE
    • PD
Re: Rare WR Database
« Reply #28 on: March 26, 2017, 10:58:45 pm »
https://www.youtube.com/watch?v=Q1ilZx-PLkE

Come on mate, why not add this to my tally? I don't understand, check the upload date I clearly got it on December 5th 4 days before 3:05.

Selenium Webdriver

  • Posts: 3859
    • Ace
    • 2017RankingsDev
    • 2017CommunityContributor
Re: Rare WR Database
« Reply #29 on: March 27, 2017, 12:46:40 am »
Accidents will happen.

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #30 on: March 28, 2017, 01:19:48 pm »
https://www.youtube.com/watch?v=Q1ilZx-PLkE

Come on mate, why not add this to my tally? I don't understand, check the upload date I clearly got it on December 5th 4 days before 3:05.

A little less attitude is always appreciated, but I added your record to the database.  I wouldn't have intentionally not added it to the database previously, I must have just missed it when it was posted.  I typically go off of the RSS feed of posted times so perhaps something about how it was added to the rankings prevented it from coming up in the feed.  Just guessing at this point.

jezz

  • Posts: 52
    • GE
    • PD
Re: Rare WR Database
« Reply #31 on: March 28, 2017, 05:22:18 pm »
Thanks mate. Lol sorry I made 3 posts here about it ages ago so I thought you weren't putting it up because it was hoarded or something.

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #32 on: March 28, 2017, 10:53:14 pm »
Hey no problem, I'm glad the site is a little more accurate now. If I miss something, best bet is usually to either post about it in this topic or send me a PM.

Gus

  • Posts: 53
  • Gus
    • GE
Re: Rare WR Database
« Reply #33 on: March 28, 2017, 11:05:49 pm »
Can you add my cradle agent 0:34. Thanks in advance.

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #34 on: March 29, 2017, 12:38:19 pm »
Thanks, I added it.

Gelonidres

  • Posts: 75
Re: Rare WR Database
« Reply #35 on: December 01, 2017, 01:08:31 am »
The Combined Duration pages for specific levels seem broken on all three (D)LTK databases, they only show the number one spot (Example). It works fine on the non-LTK databases. Combined Duration Untied also works fine.

Also, when I try to set a different date on the Combined Duration page for a specific level, I end up on the Longest Standing UWRs page for that level. This apllies to Combined Duration untied as well and seems to be the case on all six databases.

TheFlash

  • Posts: 2761
Re: Rare WR Database
« Reply #36 on: December 02, 2017, 03:36:07 am »
I can't help but I'll repeat my offer to the operators of this site that I'd love to see it hosted under the the-elite.net domain, whether on their own server or ours.

vitorr

  • Posts: 217
    • GE
    • PD
    • twitch
    • 2017RankingsDev
Re: Rare WR Database
« Reply #37 on: December 02, 2017, 07:57:37 am »
^

Gelonidres

  • Posts: 75
Re: Rare WR Database
« Reply #38 on: December 12, 2017, 12:48:33 pm »
Some discrepancies for current WRs between Elite and WR DB:

Elite has Frigate A 0:23 by Wodahs, WR DB does not.
Elite has Control A 3:56 by Clemens, WR DB does not (note the player comment).

WR DB has Cradle A 0:34 by Guilherme Alberto, Elite does not (don't know what happened there).
WR DB has Rescue SA 2:13 by Illu, Elite does not (was backrolled I think).

Selenium Webdriver

  • Posts: 3859
    • Ace
    • 2017RankingsDev
    • 2017CommunityContributor
Re: Rare WR Database
« Reply #39 on: December 12, 2017, 12:56:12 pm »
About Control...

Clemens is credited with having the first 3:58, despite only having proof of one after I got it.

Likewise with his 00 Agent 4:09. He never had proof of one until 2.5 years later (well after I got it).

flicker

  • Posts: 1443
  • Shadows of the Empire N64 World Champion
    • Flickerform
    • GE
    • PD
    • twitch
    • 2016RankingsDev
    • 2017RankingsDev
Re: Rare WR Database
« Reply #40 on: December 12, 2017, 01:11:37 pm »
WR DB has Cradle A 0:34 by Guilherme Alberto, Elite does not (don't know what happened there).

Hmm, seems like Alberto only posted in the WR thread and not to the rankings, so his 34 was never proof called. Checked his channel for a video and only saw uploads from 3 years ago. Odd that it made it onto the database, but from what I can tell, the process for adding times to the database (which is done manually) has changed from using posts in the WR thread to using the proof call thread with confirmed PROVEN times

AZ

  • Posts: 5796
    • AxZ
    • 2015CommunityContributor
    • 2017SilverStar
Re: Rare WR Database
« Reply #41 on: December 12, 2017, 03:20:57 pm »
Nice catches Gelonidres.

Yeah somehow Guilherme only claimed the time but never provided a video or submitted 0:34 to the rankings.

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #42 on: December 13, 2017, 02:43:25 pm »
Quote
The Combined Duration pages for specific levels seem broken on all three (D)LTK databases, they only show the number one spot (Example). It works fine on the non-LTK databases. Combined Duration Untied also works fine.

Also, when I try to set a different date on the Combined Duration page for a specific level, I end up on the Longest Standing UWRs page for that level. This apllies to Combined Duration untied as well and seems to be the case on all six databases.

I passed these along to Quentin the other day.  He fixed the first issue but I don't think he got around to the second issue yet.

Quote
I can't help but I'll repeat my offer to the operators of this site that I'd love to see it hosted under the the-elite.net domain, whether on their own server or ours.

Noted - this is more on the Quentin side of things so I did bring it up to him.  I'll send you a PM shortly to try to get this conversation moving.

Quote
Elite has Frigate A 0:23 by Wodahs, WR DB does not.
Elite has Control A 3:56 by Clemens, WR DB does not (note the player comment).

WR DB has Cradle A 0:34 by Guilherme Alberto, Elite does not (don't know what happened there).
WR DB has Rescue SA 2:13 by Illu, Elite does not (was backrolled I think).

I added the two missing records and removed the two backrolled records.

Quote
About Control...

Clemens is credited with having the first 3:58, despite only having proof of one after I got it.

Likewise with his 00 Agent 4:09. He never had proof of one until 2.5 years later (well after I got it).

This is due to the database storing both "achieved" and "published" dates.  This distinction was primarily created for hoarded times and similar situations (such as Wouter first joining the rankings), but it seemed to fit these situations as well.  For these records I had used the original date as the "achieved" date and the duped date as the "published" date.  I can update these if needed, though there may be some other ones out there.  I'm not sure what exactly occurred with his 3:56 either as I see that one was also a dupe?

Quote
Odd that it made it onto the database, but from what I can tell, the process for adding times to the database (which is done manually) has changed from using posts in the WR thread to using the proof call thread with confirmed PROVEN times

The process currently makes use of the RSS feed of the times posted on the rankings, and I try to keep an eye on the proof calls and remove records as needed to stay consistent.  I do try to compare directly with the rankings on some sort of regular basis to catch any others that slip by (and Axel sometimes reaches out directly with these) but I hadn't lately so that's why we had a few discrepancies out there.

Selenium Webdriver

  • Posts: 3859
    • Ace
    • 2017RankingsDev
    • 2017CommunityContributor
Re: Rare WR Database
« Reply #43 on: December 13, 2017, 03:48:53 pm »
He had proof of a 3:56 when he first got it, but it was in webcam quality and didn't meet proof standards so it was backrolled, with a clause stating he could claim the original date of achievement if he duped it in good quality, which he did recently.

Icy

  • Posts: 1907
    • GE
    • PD
    • twitch
    • 2014SilverStar
    • 2015SilverStar
Re: Rare WR Database
« Reply #44 on: December 20, 2017, 08:58:08 pm »
Clemens is listed for Defense SA a few times, despite his current PR being N/A.

Botched Movie Quotes

  • Posts: 4422
  • Frankly, my dear, I don't care
    • Karl
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #45 on: December 20, 2017, 09:15:26 pm »
hey Greg. May i ask how you track wouters records from 99? Because from memory he was not a part of the rankings until 2000.
*Creator of 'waiting half a sec more cutscene' on b2 agent*
*Creator of 'bounce boost' on streets agent*
*Creator of 'strafe change laser skip' on inves*

Boss

  • Posts: 3977
    • GE
    • PD
    • twitch
Re: Rare WR Database
« Reply #46 on: December 20, 2017, 11:30:07 pm »
Duel PA should no longer be counting for anything here.

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #47 on: December 21, 2017, 05:37:14 pm »
Clemens is listed for Defense SA a few times, despite his current PR being N/A.

I removed these.

hey Greg. May i ask how you track wouters records from 99? Because from memory he was not a part of the rankings until 2000.

Correct - this is why all of his early records have a published date of 12/30/2000.  The achieved dates on these old records came from Wouter's log of PRs that he kept before he joined the rankings.

Duel PA should no longer be counting for anything here.

I removed the records and set the level as "Not Tracked" as we have with Duel A/SA.

GoldenGreg007

  • Posts: 3373
  • The Factory
    • GE
    • PD
Re: Rare WR Database
« Reply #48 on: January 02, 2018, 01:06:27 pm »
Quote
The Combined Duration pages for specific levels seem broken on all three (D)LTK databases, they only show the number one spot (Example). It works fine on the non-LTK databases. Combined Duration Untied also works fine.

Also, when I try to set a different date on the Combined Duration page for a specific level, I end up on the Longest Standing UWRs page for that level. This apllies to Combined Duration untied as well and seems to be the case on all six databases.

I passed these along to Quentin the other day.  He fixed the first issue but I don't think he got around to the second issue yet.

Quentin messaged me the other day and let me know that he fixed the second issue now as well.

Gelonidres

  • Posts: 75
Re: Rare WR Database
« Reply #49 on: January 02, 2018, 01:59:04 pm »
Yeah, everything I reported works fine now. Thanks!