Offers.

[SS24]

In the scheme of a database there is table with the structure description bord, that that no type «cash_hand_player_combinations» only for cards bord. If there would be such table the big possibilities on creation stats with the account bord would open. NoteTraсker certainly allows to create similar stats, but we have a number of lacks (there is no presentation, the account goes only in those situations when pocket cards are known).

I apologise for my English, I use the electronic translator.

[kraada]

What kinds of statistics would you be looking for?

[SS24]

For example: as often player bets, raise, fold, check/raise on pair flop, low flop (turn, river), on 2suit flop and a lot of other statistics.

[kraada]

Those can certainly be built with the data available in the database.

[SS24]

Now such stats in my opinion to create very difficultly (I anyway did not manage to create workers for HUD).

If it is not difficult, write an example created stats percent of rates of the player on pair flop (cnt_f_bet_pairflop / cnt_f_bet_pairflop_oop * 100). Then I by analogy will try to create others stats.

[kraada]

You're right that it isn't easy, but it can be done.

The ones you want are:

cnt_f_bet_pairflop: sum(if[(holdem_hand_summary.card_1 % 13 in (holdem_hand_summary.card_2 % 13, holdem_hand_summary.card_3 % 13) OR holdem_hand_summary.card_2 % 13 in (holdem_hand_summary.card_1 % 13, holdem_hand_summary.card_3 % 13)) and holdem_hand_player_statistics.flg_f_bet, 1, 0])

cnt_f_bet_pairflop_opp: cnt_f_bet_pairflop: sum(if[(holdem_hand_summary.card_1 % 13 in (holdem_hand_summary.card_2 % 13, holdem_hand_summary.card_3 % 13) OR holdem_hand_summary.card_2 % 13 in (holdem_hand_summary.card_1 % 13, holdem_hand_summary.card_3 % 13)) and holdem_hand_player_detail.flg_f_open_opp, 1, 0])

Note: this will include flops with trips - you could exclude those if you wanted by adding AND NOT(holdem_hand_summary.card_1 % 13 = holdem_hand_summary.card_2 % 13 AND holdem_hand_summary.card_2 % 13 = holdem_hand_summary.card_3 % 13)

Edit to add: This is in PT3 form - to convert it for use in PT4 change "holdem" to "cash".

[SS24]

del

[SS24]

Thanks for the description stats. But nevertheless, for the usual user creation similar stats will be very inconvenient especially for turn and river (connected). The table considerably would facilitate the given process of creation stats.

[kraada]

Yes, but doing the calculation to store that information at import time would add a considerable amount of time to the import and thus it was decided to not isolate texture based information further when importing.