Angband.oook.cz
Angband.oook.cz
AboutVariantsLadderForumCompetitionComicScreenshotsFunniesLinks

Go Back   Angband Forums > Angband > Sil

Reply
 
Thread Tools Display Modes
Old March 23, 2013, 04:07   #1
debo
Veteran
 
debo's Avatar
 
Join Date: Oct 2011
Location: Toronto, Canada
Posts: 2,340
debo is on a distinguished road
Sil stats hacking

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.
Attached Files
File Type: zip silstats.csv.zip (49.1 KB, 83 views)
debo is offline   Reply With Quote
Old March 23, 2013, 04:25   #2
debo
Veteran
 
debo's Avatar
 
Join Date: Oct 2011
Location: Toronto, Canada
Posts: 2,340
debo is on a distinguished road
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 is offline   Reply With Quote
Old March 23, 2013, 04:32   #3
debo
Veteran
 
debo's Avatar
 
Join Date: Oct 2011
Location: Toronto, Canada
Posts: 2,340
debo is on a distinguished road
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 is offline   Reply With Quote
Old March 23, 2013, 04:43   #4
debo
Veteran
 
debo's Avatar
 
Join Date: Oct 2011
Location: Toronto, Canada
Posts: 2,340
debo is on a distinguished road
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')
debo is offline   Reply With Quote
Old March 23, 2013, 05:21   #5
scud
Swordsman
 
Join Date: Jan 2011
Location: Sarf Laaaahdon
Posts: 323
scud is on a distinguished road
Quote:
Originally Posted by debo View Post
(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.
scud is offline   Reply With Quote
Old March 23, 2013, 13:26   #6
HallucinationMushroom
Knight
 
HallucinationMushroom's Avatar
 
Join Date: Apr 2007
Location: Indiana, U.S.A.
Age: 39
Posts: 769
HallucinationMushroom is on a distinguished road
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
__________________
You are on something strange
HallucinationMushroom is offline   Reply With Quote
Old March 23, 2013, 13:37   #7
debo
Veteran
 
debo's Avatar
 
Join Date: Oct 2011
Location: Toronto, Canada
Posts: 2,340
debo is on a distinguished road
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.
debo is offline   Reply With Quote
Old March 23, 2013, 16:11   #8
fph
Knight
 
Join Date: Apr 2009
Location: Berlin / Italy
Posts: 583
fph is on a distinguished road
Quote:
Originally Posted by HallucinationMushroom View Post
He was the first and only hardcore singer/stealth low health for a long time.
Can we call that "Ozzy"?
__________________
Dive fast, die young, leave a high-CHA corpse.
--
You read a scroll labeled 'lol gtfo' of Teleport Level.
fph is offline   Reply With Quote
Old March 23, 2013, 17:42   #9
HugoTheGreat2011
Knight
 
HugoTheGreat2011's Avatar
 
Join Date: Jan 2012
Location: Mid-Atlantic, U.S.
Age: 35
Posts: 967
HugoTheGreat2011 is on a distinguished road
Quote:
Originally Posted by debo View Post
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.
HugoTheGreat2011 is offline   Reply With Quote
Old March 28, 2013, 20:12   #10
debo
Veteran
 
debo's Avatar
 
Join Date: Oct 2011
Location: Toronto, Canada
Posts: 2,340
debo is on a distinguished road
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:

Code:
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.
debo is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
New stats Magnate v4 8 December 13, 2011 09:58
diff between Fight stats and Melee stats? fbas Vanilla 8 November 3, 2010 23:31
another DaJAngband hacking question will_asher Development 10 March 9, 2009 15:40
DaJAngband hacking: help with the code (please, I wont ask much!) will_asher Variants 19 April 21, 2008 01:41
Stat hacking Old Man Vanilla 1 October 12, 2007 15:13


All times are GMT +1. The time now is 10:13.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2018, vBulletin Solutions Inc.