Re: bah-boom[edit]

Hi Xymph,

Not sure whether you're seeking detailed feedback yet, but I'll emphasize that this is extremely interesting.  :D  I suppose I should follow those forum threads in case DSDA staff offer more information.

"Please let me know if you spot any mismatches"   — Superficially it looks fine, but (due to the size and heterogeneity of the databases) there are many possible points of failure between the original upload and our published link.  My best idea is to read (some!) LMP text files and verify that each "signature" matches the article title.  Would that actually help you at this stage?  If so, I'll try it.

Thank you for making time for this!  Ryan W (living fossil) 06:25, 3 June 2020 (CDT)

Hey, it's been on my to-do list for only 3+ years. ;-)   I have no intention of overloading anyone with lots of manual work, but if that's how you can and are willing to help verify correctness, feel free. And thanks for your feedback. --Xymph (talk) 14:17, 3 June 2020 (CDT)
If I find a batch method, then I'll do it.  I (and hopefully others) will have more to say about the link tables when you reach that step, because AFAICT no single filter is endorsed by all demo-fans — records can now have forks, like software.  HTH, Ryan W (living fossil) 16:40, 3 June 2020 (CDT)

And of course, as soon as I save...  :>  Arnaud Florian (Oxyde) is listed twice in the first column.  Ryan W (living fossil) 06:37, 3 June 2020 (CDT)

Yes, because as far as I've been able to determine (both coop-ed with JCD), he's listed with two different aliases on Compet-n and DSDA, and thus ends up with two sets of links. My guess is that the demo sites weren't aware of the aliases belonging to the same person -- or that I am entirely mistaken. --Xymph (talk) 14:17, 3 June 2020 (CDT)
I would have needed an entire scrape to locate those posts.  :>  Fair enough.  Ryan W (living fossil) 16:40, 3 June 2020 (CDT)
Thought I'd mention that I've raised the Oxyde issue, along with another where Natalya Shilyaeva (QWERTY)'s Heretic demos were listed under her QWERTY alias, to the current DSDA maintainers and they have merged the pages. All of these speedrunners' demos can now be found under the Oxyde and QWERTY aliases, respectively.  Andromeda (talk) 12:08, 24 August 2020 (CDT)
Thanks for the heads-up, all updated. --Xymph (talk) 12:46, 24 August 2020 (CDT)--Xymph (talk) 12:46, 24 August 2020 (CDT)

Comment feature on[edit]

Fx kindly provides read-only MySQL access   — That's indeed very civil.  I don't wish to overload anyone with coding work either, but how difficult would it be to extract all non-null comments into a flat listing like

File Date User Comment
rq09-528 20.10.2014 18:55 fx A bit annoying map for my taste but well done.
f1m4-145 21.01.2014 23:30 fx Yeah, he had great moves and route improvements.<p>Shame he's now occupied with beer and football :D
f1m4-145 21.01.2014 22:00 brenton Improving your own record twice, each time a near 10% improvement... very good :)

It wouldn't need to be a table, or posted on-wiki at all, or even formatted, just whatever default layout your library produced.

I ask this because:

  • To search the front end, I must navigate to the LMP history for each combination of WAD, map slot, and style.  (If I don't specify both level and style, I see only current records.)
  • Even when comments are found, a bug often prevents them from rendering. [1] (working link)
  • Vanilla competition has been a walled garden for years.  If there exist insights from expert players published nowhere else, I'd like to see them in case they can be incorporated into our map articles.

Hope that makes some sense (no caffeine today).  Thanks, Ryan W (living fossil) 03:38, 6 June 2020 (CDT)

Hi! Xymph told me you want to extract comments but I'd rather avoid doing that since comments are a bit hacky and there might be issues with it. All comments are in one table but I think they should be separated per game (compet-n/cndoom/coop/etc...) and I plan to fix that later this year so if you can wait a bit... -- User:Fx 13:21, 08 Julyne 2020 (UTC)
Hello!  It's definitely not urgent and I know you have larger development projects to address.  FWIW I think it's a great feature since the forum threads tend to be diffuse and off-topic even after a major release; I wish more players used it.  Thanks for any time you can spend on this, in any year.  Ryan W (living fossil) 07:33, 8 June 2020 (CDT)
I originally didn't have access to the comments table in the database, so asked Fx for input here. Now, with access, it turns out there are only 78 comments, 26 of which pertaining to expired records so that the corresponding wad/map/record is no longer available. I sent you a download link of the resulting .tsv file via IRC. Enjoy :) --Xymph (talk) 08:47, 10 June 2020 (CDT)
Well, using the .tsv file I have dispersed the substantive content to the relevant TODOs.  (The micron-thin silver lining of low traffic, in this case, is that I immediately guessed the missing filenames based on date stamp and identifying the runner from their comment text.)  Thanks again!  Ryan W (living fossil) 04:28, 16 June 2020 (CDT)