sequell VS DCSSReplay

Major thanks to this subreddit, the wiki (so glad it’s back!), the learndb and the knowledge bots, listgame and Sequell, and the #crawl IRC channel for being incredibly valuable resources for learning about DCSS. And my profound gratitude to the Devteam for putting together an incredible game and continuing the development in the open (I lurk #crawl-dev sometimes), and Linley Henzell for writing the original Crawl back in the day.

Full manual for sequell bot commands is here: https://github.com/crawl/sequell/blob/master/docs/listgame.md

If you play online, you can use listgame to query for games, either on IRC, the Discord, or maybe in the in-game chat. For example, !log . xl=1 d:3 -2 will link to the morgue for your (".") second-to-most recent ("-2") XL 1 death on D3.

To add up, if someone wants to list/filter games happening between all servers you can use the !lg (!lg documentation) command in IRC or Discord chat servers.

So if data is what you are interested in, familiarize yourself with sequell / !lg it allows you to query morgue files. It's fairly advanced already and you can "easily" ask questions like "How many people died to Natasha in the last week". So if you want to do data analysis, that's where I would start.

If you want, I could help you walk through the setup process to get a local database of the data. I more or less just followed the readme instructions at https://github.com/crawl/sequell but if there are specific questions or your get stuck feel free to DM me. Once you have that, you can run a SQL client to do queries on the database and generate csvs of whatever raw data you want. Then process them accordingly and do any number of analytics.

Interesting, it looks like some metadata file gets shared across servers which is likely exactly what is getting pulled into (https://github.com/crawl/sequell).

Yeah, I'm not even doing direct SQL calls. It's through an api called sequell. Referece: https://github.com/crawl/sequell/blob/master/docs/listgame.md

The code is available in the uno-platform-dcsstv branch on GitHub. It should work on pretty much all modern browsers, only 80x24 TTyrecs are supported(this is the default).

All online sessions are recorded as ttyrecs - this is console (i.e. text) output, not tiles. However, this app can take ttyrecs and simulate tiles output: https://github.com/Rytisgit/DCSSReplay.

Windows only for now: Download installer from https://github.com/Rytisgit/DCSSReplay/releases/tag/1.0.0 After installing either ctrl+g to open download ttyrec interface or get them manually and open from disk with ctrl+o.

In addition to the skilling board you’ll find at the bottom (usually) of morgue file (also more info like learnt spells, most used action or equipped items, stat points, etc…), I suggest you use some ttyrec playback tool. Here are some suggestions.

Yeah that's me, I've already done pretty much everything that's mentioned in the main post, the project is here: https://github.com/Rytisgit/DCSSReplay I've done some pretty interesting additional development on a branch, but didn't finish it fully so it just sat there for a few months.

Actually there is a ttyrec player that I didn't get to build on my current linux machine yet: https://github.com/Rytisgit/DCSSReplay Can this be implemented into a website? I have no expierience with web applications/websites, so please forgive my noob ideas.

And there is also a tiles version: https://github.com/Rytisgit/DCSSReplay