Sil stats hacking

[debo]

Hey guys,

After bitching about shadow spiders for the umpteenth time, I found myself wondering what the "real" stats were surrounding deaths, wins, etc. in Sil. I realize there is a lot of selection bias with the chars that get uploaded to the ladder, but that's all we've got to go on

I wrote a little python script to scrape the ladder, parse all the dumps, and spew out a csv of all the stats for each character.

This includes:
- base/actual stats
- base/total skills
- total XP
- race
- house
- game version
- number of times they said 'fuck' in the notes
- what killed them
- or if they won and/or if they killed V and/or how many sils they got.

I'm going to tweak the script so that you can also dump to SQLite (I hate spreadsheets and I prefer to write queries), and clean it up so that others can use it, and then I'll push to github and share here. However, in the interim, I've attached a CSV of 808/809 Sil dumps on the ladder (one dump was dodging one of my regexps and I was too lazy to fix it).

Hope some of you will somehow find this data useful -- especially half and Scatha for analyzing stuff for future balancing, etc.

As a random starter fact: Here is the average XP of a winning character, bucketed by game version:

1.0 -- We actually didn't have any wins! (I didn't know that.)
1.0.1 = 86,954 (14 wins)
1.0.2 = 89,408 (49 wins)
1.1.0 = 95,356 (45 wins)
1.1.1 = 96,114 (17 wins)

I'm guessing the jump in 1.1.0 was mostly because of all the extra stuff put in the game, but maybe we really did all get a lot better at Sil in that version too. Who knows

Enjoy.

[debo]

Some fun death statistics: What monsters were most deadly in each version? (I used a threshold of 5+ deaths as a criteria, with the exception of 1.1.1)

1.0
(didn't bother)


1.0.1
Out of 134 deaths, most popular killers:

Giant 9
Orc warrior 8
Shadow spider 7
Warg 7
Cat warrior 6
Easterling archer 6
Ururauko 6
Poison 6
Morgoth 5
Shadow 5
Young fire-drake 5


1.0.2
Out of 203 deaths, most popular killers:

Morgoth 12
Warg 12
Poison 11
Ururauko 10
Young fire-drake 6
Cat warrior 6
Greater Werewolf 6
Lurking Horror 5
Fatal wound 5
Creeping Horror 5
Troll guard 5
Ancient Sapphire Serpent 5
Ancalagon the Black 5


1.1.0
Out of 121 deaths, most popular killers:

Morgoth 10
Shadow Spider 6
Cat warrior 6
Shadow 5
Young Fire Drake 5
Poison 5


1.1.1
(I lowered the threshold from 5 to 3 here, since we have fewer dumps)
Out of 70 deaths, most popular killers:

Poison 6
Fatal wound 4
Sulrauko 5
Troll Guard 4
Morgoth 3
Shadow 3
Shadow Spider 3

[debo]

Finally: the top 3 most profane character dumps had fuck counts of 13, 12, and 6, respectively. All three characters also belonged to me

[debo]

OK, I'm really done after this:

Average depth that a character dies at, given that they died in the first place (bucketed by version):

1.0 - 9.5

1.0.1 - 11.9

1.0.2 - 13.2

1.1.0 - 12.7

1.1.1 - 13.6


(This is by floor number, not depth in feet e.g. 9 = 450', 13 = 650')

[scud]

(This is by floor number, not depth in feet e.g. 9 = 450', 13 = 650')

Although the message "You are 10' down the stairs. You slip on a slime mold. Bump bump bump bump BUMP BUMP BUMPITY BUMP. You die." would be hardcore.

[HallucinationMushroom]

Cool stats, but, you didn't list sleep deprivation or alcohol.

Satyr and I actually got 1.0 wins, just before ladder could adopt for the green victor status. I really wanted to be first, but he edged me out. I thought it was cool how we had entirely different ways of playing. He was the first and only hardcore singer/stealth low health for a long time. Did he ever get his artifact put in, or ever recommend one?

http://angband.oook.cz/ladder-show.php?id=12335

http://angband.oook.cz/ladder-show.php?id=12365

[debo]

Oh right, I forgot there wasn't a "you won" message in 1.0.

I like how your style hasn't changed at all since Sil was released

I'm also impressed that one of the earliest Sil wins ever was basically Song-only. I'd have thought that to be almost impossible.

[fph]

He was the first and only hardcore singer/stealth low health for a long time.

Can we call that "Ozzy"?

[HugoVirtuoso]

Oh right, I forgot there wasn't a "you won" message in 1.0.

I like how your style hasn't changed at all since Sil was released

I'm also impressed that one of the earliest Sil wins ever was basically Song-only. I'd have thought that to be almost impossible.

My style has stayed more or the less the same since 1.0.1. e.g., My affinity for 2-handed weapon use, the Fingolfin house, and the Melee/Evasion/Will combination I'm known for.

[debo]

Hey guys,

Just had a free hour to myself and I was too braindead to do anything truly productive, so I put this script up on github:

https://github.com/MichaelDiBernardo/silscraper

I also added the ability to dump to sqlite3 db. Here is a random fun query for you:

select version, round(avg(conbase), 3), round(avg(con), 3) from silchars group by version order by version;

1.0|3.811|4.027
1.0.1|3.44|3.962
1.0.2|4.062|4.989
1.1.0|4.042|5.333
1.1.1|3.783|4.826

Also note that the scraper should be pretty easily extensible to scrape + parse dumps for any other variant on the ladder -- it all depends on how much you love/hate writing regexps

I'd be happy to help if anyone wanted to e.g. make changes to point the barrel of this thing at V or some other variant. It might get hairy if sheets changed drastically across versions, but we could always restrict to a certain version filter / range.