Donkey Kong Forum

General Donkey Kong Discussion => General Donkey Kong Discussion => Topic started by: WCopeland on September 21, 2016, 07:06:47 pm

Title: Donkey Kong Statistics Database
Post by: WCopeland on September 21, 2016, 07:06:47 pm
(http://i.imgur.com/olW3hQ6.png)

http://kongtrackr.herokuapp.com

Many will recall the tournament almost a year ago from today where I broke the world record, followed by Robbie breaking it after 6 hours, followed by Dean taking 1st place with a score of 1.177m. Shortly after the tournament, it occurred to me that it was very likely that even though Dean's 1.177m game was one of the greatest of all time, it was bound to be lost to history.

Knowing this, I set out to build Kongtrac.kr, a Donkey Kong high scores database. My goal was to capture every recorded game, player, and event in history. Jeremy Young over the last year has meticulously helped me with this, and as of this writing we're currently sitting on a database of 1570 games from 399 players.

Not only are we able to store all this data, we're able to analyze it in ways that before now simply weren't possible or took an incredible amount of manual effort. Here's a quick highlight of all the features that are being publicly released:

Automatic HSL
(http://i.imgur.com/IBftf4p.png)

Easy Compare
(http://i.imgur.com/aTbfbQo.png)

Game Comparison
(http://i.imgur.com/nJlKGXT.png)

Timelines
(http://i.imgur.com/auxMV9z.png)

Auto-generated Game Stats
(http://i.imgur.com/Wjl9FhO.png)

Easy Player Comparisons
Red dots are arcade scores. Blue dots are MAME scores.
(http://i.imgur.com/bNgzB7i.png)

Interesting URLs to Check Out:
Top Games List (http://kongtrackr.herokuapp.com/#/ranking/games)
World Record Timelines (http://kongtrackr.herokuapp.com/#/timeline/worldrecord)
The "Average Game" (http://kongtrackr.herokuapp.com/#/game/averageGame/summary)
Comparison of the Big Three (http://kongtrackr.herokuapp.com/#/compare/players/allenStaal&brianAllen&jasonCoreyBrittain)
Robbie Lakeman 1,206,900 vs Dean Saglio 1,206,800 (http://kongtrackr.herokuapp.com/#/compare/games/-K-VqgC-Kgr2ikzm02kB&-KKqQgk-XWRCnqfk88P0/summary)
The Legendary DKO (http://kongtrackr.herokuapp.com/#/event/-K1WWDMlGx_o9jf85_sT)
Hank Chien's Player Profile (http://kongtrackr.herokuapp.com/#/player/hankChien)

Lots of features are planned, including support for every DK, DKJr, and CK variant... and then support for games outside of the DK franchise altogether. Feature requests are welcome. Enjoy.
Title: Re: Donkey Kong Statistics Database
Post by: VON on September 21, 2016, 07:28:15 pm
Wow!  Great work guys.

Question: How do you plan to keep the database up to date?  Do you have some way of polling DKF/TG/MARP submissions, or do you expect players to also submit their scores to KongTrackr?
Title: Re: Donkey Kong Statistics Database
Post by: YesAffinity on September 21, 2016, 09:58:15 pm
Really cool!  Great work, guys!

Interesting to note (if I read the KS timeline correctly) that the 7 most recent kill screens have all been achieved on arcade, and there has never previously been a trend of 7 arcade kill screens, in the history of the game.
Title: Re: Donkey Kong Statistics Database
Post by: Barra on September 22, 2016, 01:27:07 am
I like this. I like this a lot. Stats Kreygasm

Is it worthwhile us submitting a bunch of our own games if we have record of them? I learned DK when I was still using Retro Uprising and so any time I got a PB I'd submit there.

Or is the goal to only track worthwhile games? I notice the "average" game is 1,003,200 and so I'm thinking that mostly only first-time killscreens and PBs over 1m have been stored so far

Great stuff anyway. Bloody amazing. You guys deserve a fkn badge

:)

Edit: an awesome piece of information that I just noticed: The top 50 all-time games are 1.1m. Wes' 1,100,000 is 50th. Much  Kreygasm very  <YSG>
Title: Re: Donkey Kong Statistics Database
Post by: marinomitch13 on September 22, 2016, 01:35:46 am
Incredible. Kreygasm I had a dream of something like this back in 2011 but have never had the time and skills to pull it off. Well done, gents!
Title: Re: Donkey Kong Statistics Database
Post by: muscleandfitness on September 22, 2016, 03:46:35 am
Omfg im in here lit this is amazing. This should be recomended for the Archobald peace prise lit ..we <Allen> <Billy>ll done.  <Allen>
Title: Re: Donkey Kong Statistics Database
Post by: xelnia on September 22, 2016, 04:09:15 am
Wow!  Great work guys.

Question: How do you plan to keep the database up to date?  Do you have some way of polling DKF/TG/MARP submissions, or do you expect players to also submit their scores to KongTrackr?

Wes can answer the player submission thing better than I can, but I believe there will be a sort of of moderating system set up where people could potentially submit scores and then they'd be approved by an admin/mod/whatever.

My plan is to always update it when a new score comes into the DKF/TG/MARP, which is what I do for the DKF HSL anyway. I'm obviously always hanging around DKF, but I check TG and MARP almost daily for new scores and add them to the DKF HSL if appropriate.

KT has actually been around for quite awhile, in secret, and I've been working on and off in compiling stats for games. I had a hard drive failure this summer, but I believe my records are still accurate. At last count, there should be roughly 250 games on KT with full stats, about 500 games on my computer left to analyze (inp and video), about 750 games on KT that will probably never have stats, and maybe 75 or so more that I need to do some more research on. I have a spreadsheet (lol) that indicates I have info on 1,644 games and that I could potentially have complete data on 827 of them (most positive outlook).

Anyway, the long and short of it is: I will keep the database as up-to-date as possible while slowly adding backlog data.
Title: Re: Donkey Kong Statistics Database
Post by: TheSunshineFund on September 22, 2016, 05:36:52 am
Very impressive work guys.   <Mruczek>
Title: Re: Donkey Kong Statistics Database
Post by: LMDAVE on September 22, 2016, 05:47:45 am
Amazing work! I haven't got into looking at all the things this does, but just seeing what I saw is awesome.
Title: Re: Donkey Kong Statistics Database
Post by: WCopeland on September 22, 2016, 06:49:04 am
Wow!  Great work guys.

Question: How do you plan to keep the database up to date?  Do you have some way of polling DKF/TG/MARP submissions, or do you expect players to also submit their scores to KongTrackr?

There's a larger feature being worked on that will let people submit their own data and then let a mod approve it. This can be full-game data or just "I got X score on X date". Editing is also WIP, which would turn the DB into a wiki-style system.
Title: Re: Donkey Kong Statistics Database
Post by: Barra on September 22, 2016, 11:42:07 am
^Answered my question too. I saw the "submit" and automatically assumed anyone could. Lit

 <Pigger>
Title: Re: Donkey Kong Statistics Database
Post by: JCHarrist on September 22, 2016, 11:44:57 am
Amazing work, guys. Kreygasm
Title: Re: Donkey Kong Statistics Database
Post by: homerwannabee on September 22, 2016, 12:45:07 pm
This is really cool.  Great job!
Title: Re: Donkey Kong Statistics Database
Post by: QAOP Spaceman on September 22, 2016, 01:57:40 pm

Tremendous work, Wes & Jry - well done.


(http://i262.photobucket.com/albums/ii105/scoozna/misc/applause.gif)
Title: Re: Donkey Kong Statistics Database
Post by: Shamrock on October 03, 2016, 11:39:40 pm
Wow. I am absolutely beyond impressed. I am blown away. This is an incredible tool and I plan to use it. Well done gentlemen  8) 8)