The Cygnus Project: Actiontypes Table

[Cygnus]

ActionTypes

actiontype_id int4
actionstring bpchar


This appears to be a lookup table for different poker actions (check, call, fold, etc.) using codes for the different actions.

My hunch is that they represent one action, though several seem to be represented in a record.

For example, "B" is obviously bet, but what then is "BR"? Likely it stands for Bet-Raise, but who bet and who raised? My best guess is that it stands for, "Raise, with a bet facing you"

If this is correct, then the code "BRCR" would be "Raise, when faced with a Bet-Raise-Call in front of you."

There's 88 codes here. It seems difficult to capture every one, that is, every possible pattern - on a really weak-loose table you might have bet-call-call-call-call-call and I don't see a "BCCCCC" code. In fact the longest code is 4 letters. So perhaps what he did was make this "BCCC" instead, with the middle 2 "C's" representing 2 or more callers. Or maybe that hand doesn't get a code. It doesn't happen that often so wouldn't be a huge loss.

Actiontypes codes are linked in the following tables.

playerhandscashkeycolumns firstpreflopactiontype_id
playerhandscashkeycolumns preflopplayeractiontype_id
playerhandscashkeycolumns flopplayeractiontype_id
playerhandscashkeycolumns turnplayeractiontype_id
playerhandscashkeycolumns riverplayeractiontype_id
playerhandscashkeycolumns_hero firstpreflopactiontype_id
playerhandscashkeycolumns_hero preflopplayeractiontype_id
playerhandscashkeycolumns_hero flopplayeractiontype_id
playerhandscashkeycolumns_hero turnplayeractiontype_id
playerhandscashkeycolumns_hero riverplayeractiontype_id
playerhandstourneykeycolumns firstpreflopactiontype_id
playerhandstourneykeycolumns preflopplayeractiontype_id
playerhandstourneykeycolumns flopplayeractiontype_id
playerhandstourneykeycolumns turnplayeractiontype_id
playerhandstourneykeycolumns riverplayeractiontype_id
playerhandstourneykeycolumns_hero firstpreflopactiontype_id
playerhandstourneykeycolumns_hero preflopplayeractiontype_id
playerhandstourneykeycolumns_hero flopplayeractiontype_id
playerhandstourneykeycolumns_hero turnplayeractiontype_id
playerhandstourneykeycolumns_hero riverplayeractiontype_id
postflopactions streetactiontype_id
postflopactions_month streetactiontype_id

Cygnus

[Cygnus]

Ok, well looks like my first guess was wrong.

I was examining the FlopBet stat:

Stat GroupName="Flop" ColumnName="FlopBet" ValueExpressions="sum(case when ph.flopplayeractiontype_id between 23 and 44 then 1 else 0 end) as BetFlop

and guess what 23 to 44 look like:

23 BF
24 BCF
25 BCCF
26 BCCC
27 BCCR
28 BCC
29 BCRF
30 BCRC
31 BCRR
32 BCR
33 BC
34 BRF
35 BRCF
36 BRCC
37 BRCR
38 BRC
39 BRRF
40 BRRC
41 BRRR
42 BRR
43 BR
44 B


So the main action must be the *first* letter, not the last. The following letters are what happened *after* the player took his "first letter" action.

Now I'm guessing BRCR means the player bet, then after that came a raise-call-reraise.

I'm still not sure if the RCR part could include the player in question or not. That is, could BRCR be a code in a heads-up situation? Or are the letters following the first letter always referencing other players?

[Rvg72]

Hi, these actions only track the player represented by player_id. So BRR = Bet Raise Raise from that one player meaning he Bet, was raised, he then reraises, was reraised again and then reraised one more time. So in that street he did 3 things, Bet then Raise then Raise.

Roy

[Cygnus]

Wow, I got it wrong twice! What are the odds..

Many thanks for clearing that up.

Cygnus