Description required of some database columns

[alpatters]

Hi,
I am writing some custom reports after reading your article on how to do so.

So, I have a few questions for you.

Can you tell me the abbreviation to use for the playerhandscashkeycolumns table? (e.g. pokerhands table is referred to as PH in the report)

Can you tell me the difference and meaning of these columns in the playerhandscashkeycolumns table: preflopaction_id, firstpreflopactiontype_id and preflopplayeractiontype_id?

I take it flopplayeractiontype_id and the turn and river versions will have the same meaning as preflopplayeractiontype_id?

Thanks,
Alan

[morny]

Ill move this to the reports section and ask Roy to respond. Thanks

[Rvg72]

playerhandscashkeycolumns = PH
pokerhands = PKH

preflopaction_id is the action facing the hero preflop

0 = Unopened
1 = 1 Limper
2 = 2+ Limpers
3 = Raiser
4 = Raiser + Caller(s)
5 = 2+ Raisers


firstpreflopactiontype_id is the first action the player took preflop

0 = Fold
2 = Call
3 = Raise

preflopplayeractiontype_id is the full set of actions the player took preflop. Ignore the code but you should get the idea, if this value is 67 then that is RF which is Raise Fold. So he raised and then folded to a reraise. X = Check.


if (ActionInt == -1)
return "";
else if (ActionInt == 0)
return "F";
else if (ActionInt == 1)
return "XF";
else if (ActionInt == 2)
return "XCF";
else if (ActionInt == 3)
return "XCCF";
else if (ActionInt == 4)
return "XCCC";
else if (ActionInt == 5)
return "XCCR";
else if (ActionInt == 6)
return "XCC";
else if (ActionInt == 7)
return "XCRF";
else if (ActionInt == 8)
return "XCRC";
else if (ActionInt == 9)
return "XCRR";
else if (ActionInt == 10)
return "XCR";
else if (ActionInt == 11)
return "XC";
else if (ActionInt == 12)
return "XRF";
else if (ActionInt == 13)
return "XRCF";
else if (ActionInt == 14)
return "XRCC";
else if (ActionInt == 15)
return "XRCR";
else if (ActionInt == 16)
return "XRC";
else if (ActionInt == 17)
return "XRRF";
else if (ActionInt == 18)
return "XRRC";
else if (ActionInt == 19)
return "XRRR";
else if (ActionInt == 20)
return "XRR";
else if (ActionInt == 21)
return "XR";
else if (ActionInt == 22)
return "X";
else if (ActionInt == 23)
return "BF";
else if (ActionInt == 24)
return "BCF";
else if (ActionInt == 25)
return "BCCF";
else if (ActionInt == 26)
return "BCCC";
else if (ActionInt == 27)
return "BCCR";
else if (ActionInt == 28)
return "BCC";
else if (ActionInt == 29)
return "BCRF";
else if (ActionInt == 30)
return "BCRC";
else if (ActionInt == 31)
return "BCRR";
else if (ActionInt == 32)
return "BCR";
else if (ActionInt == 33)
return "BC";
else if (ActionInt == 34)
return "BRF";
else if (ActionInt == 35)
return "BRCF";
else if (ActionInt == 36)
return "BRCC";
else if (ActionInt == 37)
return "BRCR";
else if (ActionInt == 38)
return "BRC";
else if (ActionInt == 39)
return "BRRF";
else if (ActionInt == 40)
return "BRRC";
else if (ActionInt == 41)
return "BRRR";
else if (ActionInt == 42)
return "BRR";
else if (ActionInt == 43)
return "BR";
else if (ActionInt == 44)
return "B";
else if (ActionInt == 45)
return "CF";
else if (ActionInt == 46)
return "CCF";
else if (ActionInt == 47)
return "CCCF";
else if (ActionInt == 48)
return "CCCC";
else if (ActionInt == 49)
return "CCCR";
else if (ActionInt == 50)
return "CCC";
else if (ActionInt == 51)
return "CCRF";
else if (ActionInt == 52)
return "CCRC";
else if (ActionInt == 53)
return "CCRR";
else if (ActionInt == 54)
return "CCR";
else if (ActionInt == 55)
return "CC";
else if (ActionInt == 56)
return "CRF";
else if (ActionInt == 57)
return "CRCF";
else if (ActionInt == 58)
return "CRCC";
else if (ActionInt == 59)
return "CRCR";
else if (ActionInt == 60)
return "CRC";
else if (ActionInt == 61)
return "CRRF";
else if (ActionInt == 62)
return "CRRC";
else if (ActionInt == 63)
return "CRRR";
else if (ActionInt == 64)
return "CRR";
else if (ActionInt == 65)
return "CR";
else if (ActionInt == 66)
return "C";
else if (ActionInt == 67)
return "RF";
else if (ActionInt == 68)
return "RCF";
else if (ActionInt == 69)
return "RCCF";
else if (ActionInt == 70)
return "RCCC";
else if (ActionInt == 71)
return "RCCR";
else if (ActionInt == 72)
return "RCC";
else if (ActionInt == 73)
return "RCRF";
else if (ActionInt == 74)
return "RCRC";
else if (ActionInt == 75)
return "RCRR";
else if (ActionInt == 76)
return "RCR";
else if (ActionInt == 77)
return "RC";
else if (ActionInt == 78)
return "RRF";
else if (ActionInt == 79)
return "RRCF";
else if (ActionInt == 80)
return "RRCC";
else if (ActionInt == 81)
return "RRCR";
else if (ActionInt == 82)
return "RRC";
else if (ActionInt == 83)
return "RRRF";
else if (ActionInt == 84)
return "RRRC";
else if (ActionInt == 85)
return "RRRR";
else if (ActionInt == 86)
return "RRR";
else if (ActionInt == 87)
return "RR";
else if (ActionInt == 88)
return "R";

[alpatters]

Thanks for the quick response.

I take it the list you gave is the same as the rows in the actiontype table.

Thanks again,
Alan

[Rvg72]

That's correct

Roy

[mindtrap]

is there any quick way to find out if hero has won the hand? something like the "amount won"...

need this to calculate paid-rake :-)

actually i was quite successfull to add custom reports to calculate the "real" dealt rake which is used for example as basis to calculate the MGR FTPS rakeback 27% are based on. The rake that HM shows is always a bit to low.

I was also able to exactly calculate for example Titan Points or PokerRoom points (which are contributed ).

only paid rake by hero is missing... so some help plz

[morny]

Ok ill ask Roy about this, in the meantime would you like to share these reports so i can add them to the FAQ?

[Rvg72]

There is a NetAmountWon column in the playerhandscashkeycolumns table so > 0 would mean he won the hand. Is that what you are looking for?

[mindtrap]

yes, thanks! that worked.

Though i had to find out myself that the "pokerhandscashkeycolumns" is the "PH.*" in the custom reports, while "PKH.*" seems to be the "pokerhands" table.

i really wonder how you calculate the "rakeamount" which is in "pokerhandscashkeycolumns", because the value i calculate myself seems to be much much better!
You should maybe correct it at least to have correct rakeback calculation :-)

i think i will share my code-snippets later on, yes!