ITT We remind thesunfan that he hasn't finished the stat sheet

[devonin]

I might take a look at that this weekend to gauge how hard that would be. I might devise a simple schema that captures like, win/lose for each player, color, role, modkill, etc.

The problem is that this data isn't actually grabbable even if you were somehow trying to just extract it from a big text dump out of the archives, because it will say "Town wins" up at the top, but then for each individual player in the list, it doesn't say 'won' or 'lost' unless they survived to the endgame, otherwise it says 'killed' or 'lynched' and each line only says 'vanilla town' or 'wolf' if the game is basic. Often the role names in the archive are themed and so not clear whether they are town or wolf roles unless you're also checking whether there's any green or red text in the line etc etc.

[the sun fan]

I will pay u to do this btw

[devonin]

Originally Posted by the sun fan

I will pay u to do this btw

paypal.me/devonin

[Red Blaster]

Originally Posted by the sun fan

If the rest of the site has to deal with ur shit, I'm sure they can handle not clicking a thread they arent interested in

Savage.


On topic, wasn't Xiz doing stats for games way back when? I know when I was actively playing there was a TWG spreadsheet in google docs that showed things like win rate and etc.

[DaBackpack]

Originally Posted by devonin

The problem is that this data isn't actually grabbable even if you were somehow trying to just extract it from a big text dump out of the archives, because it will say "Town wins" up at the top, but then for each individual player in the list, it doesn't say 'won' or 'lost' unless they survived to the endgame, otherwise it says 'killed' or 'lynched' and each line only says 'vanilla town' or 'wolf' if the game is basic. Often the role names in the archive are themed and so not clear whether they are town or wolf roles unless you're also checking whether there's any green or red text in the line etc etc.

This is why my past attempts failed basically. I promised sunfan in the past that I would try to parse the game records and do the statistics entirely computationally. But there were too many edge cases in game design, as well as missing data from the history thread (I relied on BBCode color tags for alignment, for example, but this was unreliable because of ill-structured data)

To be clear, my suggestion is that I would manually tidy and collect the data and fit them to a specific schema, which then serves as a structured database which makes computational analysis easier

EDIT: MafiaUniverse has a fairly robust stats system built into the forum. This isn't possible for us, obviously, but I would like to see their schemas to inform a schema that we could adapt/steal for our own use on FFR

[devonin]

Originally Posted by DaBackpack

This is why my past attempts failed basically. I promised sunfan in the past that I would try to parse the game records and do the statistics entirely computationally. But there were too many edge cases in game design, as well as missing data from the history thread (I relied on BBCode color tags for alignment, for example, but this was unreliable because of ill-structured data)

To be clear, my suggestion is that I would manually tidy and collect the data and fit them to a specific schema, which then serves as a structured database which makes computational analysis easier

Once I've passed through it all to do the player win/loss stats page, it would be easy to give you TWG local mod for the purpose of editing the threads in the archive to bring everything into line in terms of tagging and so on to make it easier to parse.

[DaBackpack]

Originally Posted by devonin

Once I've passed through it all to do the player win/loss stats page, it would be easy to give you TWG local mod for the purpose of editing the threads in the archive to bring everything into line in terms of tagging and so on to make it easier to parse.

The tidying doesn't have to be in-place, I was imagining just performing transcription on a text document or something. And then operating on the local transcription to produce database records.

Not that I'd ever pass up the chance to be a local mod fumu

[devonin]

Between Game 161 and now there've been ~81 unique players (I assume several names are just weird other accounts of other people somebody will have to go clarify for me who they are)

Of the players who have 10+ games in that span, the top player so far is inDheart with a 71.43% winrate in 14 games. And the bottom player so far is wayward_vagabond with an 18.18% winrate in 11 games.

[the sun fan]

Originally Posted by DaBackpack

This is why my past attempts failed basically. I promised sunfan in the past that I would try to parse the game records and do the statistics entirely computationally. But there were too many edge cases in game design, as well as missing data from the history thread (I relied on BBCode color tags for alignment, for example, but this was unreliable because of ill-structured data)

To be clear, my suggestion is that I would manually tidy and collect the data and fit them to a specific schema, which then serves as a structured database which makes computational analysis easier

EDIT: MafiaUniverse has a fairly robust stats system built into the forum. This isn't possible for us, obviously, but I would like to see their schemas to inform a schema that we could adapt/steal for our own use on FFR

Talk to AA about that, he used to/does some stats stuff for MU

[devonin]

The best part of parsing the results is when the archive has results like this:

1 - DaBack of Packs - VT
2 - Red Blastoise - VT
3 - rzrzrzrzrzrzrzrzrzr - Wolf
4 - storn420 - Tracker/Vigilante
5 - Tokzic ayy - VT
6 - Plopadop - VT
7 - just a box that is round - Hider
8 - Clownpiece heidy - VT
9 - XelNya the gif lord - VT
10 - thesunfan of flags - Detective
11 - THE Charu - Wolf
12 - YoshL - VT
13 - 27ninjabunnies the lone bunny - Wolf

I have no idea who "Clownpiece heidy" and "27ninjabunnies the lone bunny" are.

[MixMasterLar]

I love how in that game Yosh just gets to be himself lol

Edit: for what it's worth I have never used another account/name for TWG, so nothing in question is me.

[flashflash account]

Clownpiece heidy is probably clownpiece aka dude

[inDheart]

similarly, 27ninjabunnies is 27ninjabunnies

makaze is the person to ask about the schema

[devonin]

Originally Posted by flashflash account

Clownpiece heidy is probably clownpiece aka dude

"clownpiece aka dude" that still doesn't actually tell me much of anything.

Also: For weird non-standard games (Like CXIII: Capture, where everybody was on 2-person teams with no real factions) should those get logged as 3p or town do you think? I assume 3p.

[inDheart]

user Clownpiece here is someone that he also knows as Dude from other venues

[storn42]

Originally Posted by MixMasterLar

I love how in that game Yosh just gets to be himself lol

Edit: for what it's worth I have never used another account/name for TWG, so nothing in question is me.

Im happy nobody will know its me when i go on my alt Storn43.

[MixMasterLar]

Originally Posted by storn42

Im happy nobody will know its me when i go on my alt Storn43.

"StirGuruLar"