From DoomWiki.org
(bah-boom :-)) |
(describe project) |
||
| Line 1: | Line 1: | ||
| + | == Matching and linking speedrunners == | ||
| + | When collecting information about [[speedrunner]]s for their wiki articles, the first problem encountered is that quite a few players go by a variety of names/aliases between the wiki and the former and current Compet-n and DSDA sites, and that the demo sites use different identification systems. | ||
| + | |||
| + | To match them all up, I created a (single-table) database on my home server, with scripts to fill it. Initially all entries in the [[:Category:Speedrunners|speedrunners category]] were loaded, then scripts for each of the demo sites matched up names/aliases and, upon manual verification/approval, added their names, IDs and profile status to the table. | ||
| + | * For former Compet-n, a pre-formatted text listing of the players list was used. | ||
| + | * For current Compet-n, [[Fx]] kindly provides read-only MySQL access. | ||
| + | * For former and current DSDA, the HTML player pages were parsed into SimpleXML objects that could then be traversed. | ||
| + | |||
| + | A listing script produces the table below. Please let me know if you spot any mismatches. | ||
| + | |||
| + | From the table the speedrunners' external links sections will be verified/updated/added, and it will help in compiling record tables for maps and players. | ||
| + | |||
| + | == The list == | ||
| + | The table below matches speedrunner articles with their entries on the demo sites (''state of 2020-05-30 05:13 CDT''). | ||
| + | |||
{| {{prettySortable}} | {| {{prettySortable}} | ||
! rowspan=2 valign="bottom" | Path !! [http://www.doom2.net/compet-n/index.cgi?action=players Old Compet-n] !! colspan=3 | [https://www.doom.com.hr/index.php?page=compet-n_players New Compet-n] !! colspan=3 | [http://doomedsda.us/players.html Old DSDA] !! colspan=2 | [https://dsdarchive.com/players New DSDA] | ! rowspan=2 valign="bottom" | Path !! [http://www.doom2.net/compet-n/index.cgi?action=players Old Compet-n] !! colspan=3 | [https://www.doom.com.hr/index.php?page=compet-n_players New Compet-n] !! colspan=3 | [http://doomedsda.us/players.html Old DSDA] !! colspan=2 | [https://dsdarchive.com/players New DSDA] | ||
| Line 42: | Line 57: | ||
| [[Brad Spencer (Vorpal)]] || || Brad 'Vorpal' Spencer || {{competnuser|id=204|title=204|linkonly=1}} || || Brad Spencer || {{dsdauser|id=19|title=19|linkonly=1}} || || Brad Spencer || {{dsda2user|id=brad_spencer|title=brad_spencer|linkonly=1}} | | [[Brad Spencer (Vorpal)]] || || Brad 'Vorpal' Spencer || {{competnuser|id=204|title=204|linkonly=1}} || || Brad Spencer || {{dsdauser|id=19|title=19|linkonly=1}} || || Brad Spencer || {{dsda2user|id=brad_spencer|title=brad_spencer|linkonly=1}} | ||
|- | |- | ||
| − | | [[Casey Alvis]] || [http://www.doom2.net/compet-n/index.cgi?action=players&page=casey casey] || Casey 'Altima Mantoid' Alvis || {{competnuser|id=21|title=21|linkonly=1}} || {{competnuserp|id=21|title=Yes|linkonly=1}} || Altima Mantoid || {{dsdauser|id=47|title=47|linkonly=1}} || || Altima Mantoid || {{dsda2user|id=altima_mantoid|title=altima_mantoid|linkonly=1}} | + | | [[Casey Alvis (Altima Mantoid)]] || [http://www.doom2.net/compet-n/index.cgi?action=players&page=casey casey] || Casey 'Altima Mantoid' Alvis || {{competnuser|id=21|title=21|linkonly=1}} || {{competnuserp|id=21|title=Yes|linkonly=1}} || Altima Mantoid || {{dsdauser|id=47|title=47|linkonly=1}} || || Altima Mantoid || {{dsda2user|id=altima_mantoid|title=altima_mantoid|linkonly=1}} |
|- | |- | ||
| [[Chris Laverdure (Dashiva)]] || [http://www.doom2.net/compet-n/index.cgi?action=players&page=dashiva dashiva] || Chris 'Dashiva' Laverdure || {{competnuser|id=31|title=31|linkonly=1}} || {{competnuserp|id=31|title=Yes|linkonly=1}} || Dashiva || {{dsdauser|id=4|title=4|linkonly=1}} || || Dashiva || {{dsda2user|id=dashiva|title=dashiva|linkonly=1}} | | [[Chris Laverdure (Dashiva)]] || [http://www.doom2.net/compet-n/index.cgi?action=players&page=dashiva dashiva] || Chris 'Dashiva' Laverdure || {{competnuser|id=31|title=31|linkonly=1}} || {{competnuserp|id=31|title=Yes|linkonly=1}} || Dashiva || {{dsdauser|id=4|title=4|linkonly=1}} || || Dashiva || {{dsda2user|id=dashiva|title=dashiva|linkonly=1}} | ||
| Line 84: | Line 99: | ||
| [[Jacek Dobrzyniecki (JudgeDeadd)]] || || || || || JudgeDeadd || {{dsdauser|id=466|title=466|linkonly=1}} || || JudgeDeadd || {{dsda2user|id=judgedeadd|title=judgedeadd|linkonly=1}} | | [[Jacek Dobrzyniecki (JudgeDeadd)]] || || || || || JudgeDeadd || {{dsdauser|id=466|title=466|linkonly=1}} || || JudgeDeadd || {{dsda2user|id=judgedeadd|title=judgedeadd|linkonly=1}} | ||
|- | |- | ||
| − | | [[Jakub Razák]] || || Jakub 'Method_man' Razak || {{competnuser|id=89|title=89|linkonly=1}} || || Method || {{dsdauser|id=126|title=126|linkonly=1}} || || Method || {{dsda2user|id=method|title=method|linkonly=1}} | + | | [[Jakub Razák (Method)]] || || Jakub 'Method_man' Razak || {{competnuser|id=89|title=89|linkonly=1}} || || Method || {{dsdauser|id=126|title=126|linkonly=1}} || || Method || {{dsda2user|id=method|title=method|linkonly=1}} |
|- | |- | ||
| [[Jason Henry]] || || Jason 'Jason' Henry || {{competnuser|id=69|title=69|linkonly=1}} || || Jason Henry || {{dsdauser|id=50|title=50|linkonly=1}} || || Jason Henry || {{dsda2user|id=jason_henry|title=jason_henry|linkonly=1}} | | [[Jason Henry]] || || Jason 'Jason' Henry || {{competnuser|id=69|title=69|linkonly=1}} || || Jason Henry || {{dsdauser|id=50|title=50|linkonly=1}} || || Jason Henry || {{dsda2user|id=jason_henry|title=jason_henry|linkonly=1}} | ||
| Line 102: | Line 117: | ||
| [[Juho Ruohonen (ocelot)]] || || Juho 'ocelot' Ruohonen || {{competnuser|id=96|title=96|linkonly=1}} || || Ocelot || {{dsdauser|id=6|title=6|linkonly=1}} || || Ocelot || {{dsda2user|id=ocelot|title=ocelot|linkonly=1}} | | [[Juho Ruohonen (ocelot)]] || || Juho 'ocelot' Ruohonen || {{competnuser|id=96|title=96|linkonly=1}} || || Ocelot || {{dsdauser|id=6|title=6|linkonly=1}} || || Ocelot || {{dsda2user|id=ocelot|title=ocelot|linkonly=1}} | ||
|- | |- | ||
| − | | [[Kai-Uwe Humpert]] || [http://www.doom2.net/compet-n/index.cgi?action=players&page=kai kai] || Kai-Uwe 'Gazelle' Humpert || {{competnuser|id=73|title=73|linkonly=1}} || {{competnuserp|id=73|title=Yes|linkonly=1}} || Kai-Uwe Humpert || {{dsdauser|id=111|title=111|linkonly=1}} || || Kai-Uwe Humpert || {{dsda2user|id=kai-uwe_humpert|title=kai-uwe_humpert|linkonly=1}} | + | | [[Kai-Uwe Humpert (Gazelle)]] || [http://www.doom2.net/compet-n/index.cgi?action=players&page=kai kai] || Kai-Uwe 'Gazelle' Humpert || {{competnuser|id=73|title=73|linkonly=1}} || {{competnuserp|id=73|title=Yes|linkonly=1}} || Kai-Uwe Humpert || {{dsdauser|id=111|title=111|linkonly=1}} || || Kai-Uwe Humpert || {{dsda2user|id=kai-uwe_humpert|title=kai-uwe_humpert|linkonly=1}} |
|- | |- | ||
| [[Killer5]] || || || || || Killer5 || {{dsdauser|id=554|title=554|linkonly=1}} || {{dsdauserp|id=554|title=Yes|linkonly=1}} || Killer5 || {{dsda2user|id=killer5|title=killer5|linkonly=1}} | | [[Killer5]] || || || || || Killer5 || {{dsdauser|id=554|title=554|linkonly=1}} || {{dsdauserp|id=554|title=Yes|linkonly=1}} || Killer5 || {{dsda2user|id=killer5|title=killer5|linkonly=1}} | ||
Revision as of 05:17, 30 May 2020
Matching and linking speedrunners
When collecting information about speedrunners for their wiki articles, the first problem encountered is that quite a few players go by a variety of names/aliases between the wiki and the former and current Compet-n and DSDA sites, and that the demo sites use different identification systems.
To match them all up, I created a (single-table) database on my home server, with scripts to fill it. Initially all entries in the speedrunners category were loaded, then scripts for each of the demo sites matched up names/aliases and, upon manual verification/approval, added their names, IDs and profile status to the table.
- For former Compet-n, a pre-formatted text listing of the players list was used.
- For current Compet-n, Fx kindly provides read-only MySQL access.
- For former and current DSDA, the HTML player pages were parsed into SimpleXML objects that could then be traversed.
A listing script produces the table below. Please let me know if you spot any mismatches.
From the table the speedrunners' external links sections will be verified/updated/added, and it will help in compiling record tables for maps and players.
The list
The table below matches speedrunner articles with their entries on the demo sites (state of 2020-05-30 05:13 CDT).
| Path | Old Compet-n | New Compet-n | Old DSDA | New DSDA | |||||
|---|---|---|---|---|---|---|---|---|---|
| ID | Name | ID | Profile | Name | ID | Profile | Name | ID | |
| Adam Hegyi | adam | Adam 'Adamh' Hegyi | 1 | Yes | Adam Hegyi | 45 (archived 🏛) | Adam Hegyi | adam_hegyi | |
| Adam Williamson | adamw | Adam 'Adamw' Williamson | 2 | Yes | Adam Williamson | 46 (archived 🏛) | Yes (archived 🏛) | Adam Williamson | adam_williamson |
| Adolf Vojta (Gusta) | vojta | Adolf 'Gusta' Vojta | 136 | Yes | Gusta | 82 (archived 🏛) | Gusta | gusta | |
| Albert Valls (Vrooomer) | Albert 'Vrooomer' Valls | 132 | Albert Valls | 13 (archived 🏛) | Yes (archived 🏛) | Albert Valls | albert_valls | ||
| Aleks Shahov (Plut) | Plut | 407 (archived 🏛) | Plut | plut | |||||
| Aleksey Kamenev (4shockblast) | Aleksey '4shockblast' Kamenev | 226 | 4shockblast | 430 (archived 🏛) | 4shockblast | 4shockblast | |||
| Anders Johnsen | anders | Anders 'Anders' Johnsen | 5 | Yes | Anders Johnsen | 48 (archived 🏛) | Anders Johnsen | anders_johnsen | |
| Andrea Rovenski (Cyberdemon531) | Cyberdemon531 | 484 (archived 🏛) | Cyberdemon531 | cyberdemon531 | |||||
| Andreas Kren (Anthe) | anthe | Andreas 'Kren' Kren | 80 | Andreas Kren | 234 (archived 🏛) | Andreas Kren | andreas_kren | ||
| Andrew Bassett (AndrewB) | andrew | Andrew 'Andrewb' Bassett | 6 | Yes | Andrew Bassett | 254 (archived 🏛) | Andrew Bassett | andrew_bassett | |
| Andrey Budko (entryway) | Andrey 'Budko' Budko | 20 | Andrey Budko | 56 (archived 🏛) | Andrey Budko | andrey_budko | |||
| Andy Badorek | Andy 'Badorek' Badorek | 12 | Andy Badorek | 140 (archived 🏛) | Andy Badorek | andy_badorek | |||
| Andy Kempling (aurikan) | Andy 'Kempling' Kempling | 75 | Andy Kempling | 88 (archived 🏛) | Andy Kempling | andy_kempling | |||
| Andy Olivera | Andy 'Olivera' Olivera | 98 | Andy Olivera | 59 (archived 🏛) | Yes (archived 🏛) | Andy Olivera | andy_olivera | ||
| Andy Stewart (eschdoom) | eschdoom | 264 (archived 🏛) | eschdoom | eschdoom | |||||
| Anthony Soto (Swedish Fish) | soto | Anthony 'Soto' Soto | 122 | Yes | Anthony Soto | 21 (archived 🏛) | Anthony Soto | anthony_soto | |
| Blake Collins (Rayzik) | Rayzik | 516 (archived 🏛) | Rayzik | rayzik | |||||
| Boris Klimeš (dew) | Boris 'dew' Klimeš | 231 | dew | 217 (archived 🏛) | dew | dew | |||
| Brad Spencer (Vorpal) | Brad 'Vorpal' Spencer | 204 | Brad Spencer | 19 (archived 🏛) | Brad Spencer | brad_spencer | |||
| Casey Alvis (Altima Mantoid) | casey | Casey 'Altima Mantoid' Alvis | 21 | Yes | Altima Mantoid | 47 (archived 🏛) | Altima Mantoid | altima_mantoid | |
| Chris Laverdure (Dashiva) | dashiva | Chris 'Dashiva' Laverdure | 31 | Yes | Dashiva | 4 (archived 🏛) | Dashiva | dashiva | |
| Chris Ratcliff (Ryback) | chris | Chris 'Ryback' Ratcliff | 25 | Yes | Ryback | 34 (archived 🏛) | Ryback | ryback | |
| Daniel Jakobsson (dannebubinga) | dannebubinga | 341 (archived 🏛) | dannebubinga | dannebubinga | |||||
| Daniel Lindgren (Demonlord) | daniel | Daniel 'Demonlord' Lindgren | 29 | Yes | Daniel Lindgren | 124 (archived 🏛) | Daniel Lindgren | daniel_lindgren | |
| David Ficenec (mr.twister) | David 'mr.twister' Ficenec | 130 | Twister | 199 (archived 🏛) | Twister | twister | |||
| David Spring (Springy) | David 'Springy' Spring | 232 | David Spring | 435 (archived 🏛) | Yes (archived 🏛) | David Spring | david_spring | ||
| Doug Merrill (Opulent) | opulent | Doug 'Opulent' Merrill | 99 | Yes | Opulent | 1 (archived 🏛) | Yes (archived 🏛) | Opulent | opulent |
| Drew DeVore (stx-Vile) | drew | Drew 'stx-Vile' DeVore | 39 | Yes | stx-Vile | 35 (archived 🏛) | Vile | vile | |
| Eric Baker (The Green Herring) | Eric 'The Green Herring' Baker | 43 | The Green Herring | 176 (archived 🏛) | The Green Herring | the_green_herring | |||
| Erik Alm | Erik 'Alm' Alm | 8 | Erik Alm | 9 (archived 🏛) | Yes (archived 🏛) | Erik Alm | erik_alm | ||
| Esa Repo (Espi) | Esa 'Espi' Repo | 205 | Espi | 49 (archived 🏛) | Espi | espi | |||
| Esko Koskimaa | esko | Esko 'esko' Koskimaa | 46 | Yes | Esko Koskimaa | 119 (archived 🏛) | Esko Koskimaa | esko_koskimaa | |
| George Bell | George 'Bell' I. Bell | 15 | George Bell | 133 (archived 🏛) | George Bell | george_bell | |||
| Gggmork | gggmork | 221 (archived 🏛) | gggmork | gggmork | |||||
| Graham Burgess (Grazza) | Grazza | 31 (archived 🏛) | Yes (archived 🏛) | Grazza | grazza | ||||
| Henning Skogstø | henning | Henning 'Henning' Skogsto | 61 | Yes | Henning Skogsto | 54 (archived 🏛) | Henning Skogsto | henning_skogsto | |
| Ilya Lazarev (joe-ilya) | Joe-Ilya | 462 (archived 🏛) | Yes (archived 🏛) | Joe-Ilya | joe-ilya | ||||
| Istvan Pataki | istvan | Istvan 'Istvan' Pataki | 64 | Yes | Istvan Pataki | 109 (archived 🏛) | Istvan Pataki | istvan_pataki | |
| J4rio | J4rio 'j4rio' | 166 | j4rio | 287 (archived 🏛) | j4rio | j4rio | |||
| Jacek Dobrzyniecki (JudgeDeadd) | JudgeDeadd | 466 (archived 🏛) | JudgeDeadd | judgedeadd | |||||
| Jakub Razák (Method) | Jakub 'Method_man' Razak | 89 | Method | 126 (archived 🏛) | Method | method | |||
| Jason Henry | Jason 'Jason' Henry | 69 | Jason Henry | 50 (archived 🏛) | Jason Henry | jason_henry | |||
| Jean-Charles Dorne (JCD) | JC 'JC' Dorne | 150 | JC | 196 (archived 🏛) | JCD | jcd | |||
| Jim Leonard (Xit Vono) | vono | Jim 'Xit Vono' Leonard | 137 | Yes | Xit Vono | 3 (archived 🏛) | Xit Vono | xit_vono | |
| Jochen Schneidau (Angus) | Jochen 'Angus' Schneidau | 65 | Angus | 10 (archived 🏛) | Angus | angus | |||
| Joe Abene (DOOMMANN) | joe | Joe 'DOOMMANN' Abene | 71 | Yes | Joe Abene | 367 (archived 🏛) | Joe Abene | joe_abene | |
| Jonas Feragen (Chrozoron) | Jonas 'Chrozoron' Feragen | 200 | Chrozoron | 89 (archived 🏛) | Chrozoron | chrozoron | |||
| Jonathan Rimmer | jonathan | Jonathan 'Jonathan' Rimmer | 72 | Yes | Jonathan Rimmer | 171 (archived 🏛) | Jonathan Rimmer | jonathan_rimmer | |
| Juho Ruohonen (ocelot) | Juho 'ocelot' Ruohonen | 96 | Ocelot | 6 (archived 🏛) | Ocelot | ocelot | |||
| Kai-Uwe Humpert (Gazelle) | kai | Kai-Uwe 'Gazelle' Humpert | 73 | Yes | Kai-Uwe Humpert | 111 (archived 🏛) | Kai-Uwe Humpert | kai-uwe_humpert | |
| Killer5 | Killer5 | 554 (archived 🏛) | Yes (archived 🏛) | Killer5 | killer5 | ||||
| Kim Bach (Torn) | Kim 'Torn' Bach | 168 | Kim "Torn" Bach | 106 (archived 🏛) | Kim "Torn" Bach | kim_torn_bach | |||
| Looper | Looper 'looper' | 84 | Looper | 295 (archived 🏛) | Yes (archived 🏛) | Looper | looper | ||
| M. Phoenix Dailey (Archy) | M. 'Archy' Phoenix Dailey | 155 | Yes | Archy | 261 (archived 🏛) | Archy | archy | ||
| Marijo Sedlić (Sedlo) | sedlo | Marijo 'Sedlo' Sedlić | 85 | Yes | Sedlo | 53 (archived 🏛) | Sedlo | sedlo | |
| Memfis | Memfis | 319 (archived 🏛) | Memfis | memfis | |||||
| Michael Grube (migru) | Michael Grube | 112 (archived 🏛) | Michael Grube | michael_grube | |||||
| Michael Reid (prower) | Mike 'prower' Reid | 109 | Mike Reid | 134 (archived 🏛) | Mike Reid | mike_reid | |||
| NoisyVelvet | NoisyVelvet | 606 (archived 🏛) | NoisyVelvet | noisyvelvet | |||||
| Patrick Martin | Patrick 'Martin' Martin | 87 | Patrick Martin | 123 (archived 🏛) | Patrick Martin | patrick_martin | |||
| Paul Falstad | Paul 'falstad' Falstad | 49 | Paul Falstad | 38 (archived 🏛) | Paul Falstad | paul_falstad | |||
| Peo Sjöblom | peo | Peo 'Peo' Sjoblom | 104 | Yes | Peo Sjoblom | 98 (archived 🏛) | Peo Sjoblom | peo_sjoblom | |
| Phml | Philip 'Phil' Renshaw | 175 | Phml | 266 (archived 🏛) | Phml | phml | |||
| Przemysław Woda (Belial) | Przemysław 'Belial' Woda | 169 | Belial | 90 (archived 🏛) | Belial | belial | |||
| Radek Pecka | radek | Radek 'Radek' Pecka | 112 | Yes | Radek Pecka | 52 (archived 🏛) | Radek Pecka | radek_pecka | |
| Revved | Revved 'Revved' | 152 | Revved | 259 (archived 🏛) | Revved | revved | |||
| Richard J. Sham | Richard 'Sham' J. Sham | 120 | Rich J. Sham | 33 (archived 🏛) | Rich J. Sham | rich_j_sham | |||
| Roger Moraga | Roger Moraga | 135 (archived 🏛) | Roger Moraga | roger_moraga | |||||
| Rudy Jurjako (Hellcat) | Rudy 'Rudy' Jurjako | 116 | Rudy Jurjako | 62 (archived 🏛) | Rudy Jurjako | rudy_jurjako | |||
| Simon Widlake | Simon 'Widlake' Widlake | 143 | Simon Widlake | 344 (archived 🏛) | Simon Widlake | simon_widlake | |||
| Spectre01 | Spectre01 | 595 (archived 🏛) | Spectre01 | spectre01 | |||||
| Steffen Udluft (Rini) | rini | Steffen 'Rini' Udluft | 115 | Yes | Steffen Udluft | 363 (archived 🏛) | Steffen Udluft | steffen_udluft | |
| Tatsuya Ito (Tatsurd-cacocaco) | Tatsuya 'Tatsurd-cacocaco' Ito | 149 | Tatsurd-cacocaco | 178 (archived 🏛) | Tatsurd-cacocaco | tatsurd_cacocaco | |||
| Thomas Kroppen (Poeppy) | poeppy | Thomas 'Poeppy' Kroppen | 106 | Yes | Thomas Kroppen | 366 (archived 🏛) | Thomas Kroppen | thomas_kroppen | |
| TimeOfDeath | Chris 'TimeOfDeath' Balch | 230 | TimeOfDeath | 204 (archived 🏛) | TimeOfDeath | timeofdeath | |||
| Vdgg | Vdgg 'vdgg' | 151 | vdgg | 229 (archived 🏛) | vdgg | vdgg | |||
| Vincent Catalaá (Peroxyd) | vincent | Vincent 'PerOxyd' Catalaa | 135 | Yes | Vincent Catalaa | 55 (archived 🏛) | Vincent Catalaa | vincent_catalaa | |
| Vladimir Monakhov (skepticist) | Vladimir 'Vladimir' Monakhov | 228 | Skepticist | 206 (archived 🏛) | Skepticist | skepticist | |||
| Vladislav Baymurzin (ClumsyDoomer) | ClumsyDoomer | 331 (archived 🏛) | ClumsyDoomer | clumsydoomer | |||||
| William Huber (WH-Wilou84) | William Huber | 240 (archived 🏛) | Yes (archived 🏛) | William Huber | william_huber | ||||
| Yashar Garibzadeh (GeminI) | Yashar 'GeminI' Garibzadeh | 54 | Yashar Garibzadeh | 18 (archived 🏛) | Yashar Garibzadeh | yashar_garibzadeh | |||
| Yonatan Donner | yonatan | Yonatan 'Zem' Donner | 145 | Yes | Yonatan Donner | 11 (archived 🏛) | Yonatan Donner | yonatan_donner | |
| Zachary Stephens (Ribbiks) | Ribbiks | 424 (archived 🏛) | Ribbiks | ribbiks | |||||
| Zvonimir Bužanić (fx) | zvonimir | Zvonimir 'fx' Bužanić | 42 | Yes | Zvonimir Bužanić | 215 (archived 🏛) | Yes (archived 🏛) | Zvonimir Bužanić | zvonimir_buzanic |
