Statistics: Posted by rathersquidding — Mon Mar 18, 2024 8:38 pm
Statistics: Posted by ggson — Mon Mar 18, 2024 1:44 pm
Statistics: Posted by waltonjb — Mon Mar 18, 2024 1:03 pm
myeari wrote:
Could you please build a simple column and a stat for the examples above, so I can duplicate it for the others?
if[ NOT cash_hand_player_statistics.flg_f_showdown, 0, if[ cash_hand_player_combinations.flg_f_highcard AND cash_hand_player_combinations.id_f_hand_strength = 1, 1, if[ cash_hand_player_combinations.flg_f_highcard AND cash_hand_player_combinations.id_f_hand_strength = 2, 2 ,999]]]
if(this = 0, format('No Showdown'), if(this = 1, format('High Card 1 Over'), if(this = 2, format('High Card 2 Overs'), if(this = 999, format('Error'), ignore_formatting(this)))))
myeari wrote:
I understand from this answer that I could not differ between a draw on a board (player has AK and the board is 6789) from a draw that uses player's hole cards (player has AT and the board us 789K)?
This is of course very problematic. What should I do to differ between these two types of draws?
myeari wrote:
It will be highly helpful if you would insert a conjunction for a draw hand as well in the example stat (for example, high card with flush draw).
cash_hand_player_combinations.flg_f_highcard and cash_hand_player_combinations.flg_f_flush_draw
Statistics: Posted by Flag_Hippo — Sun Mar 17, 2024 2:48 pm
sum(if[tourney_hand_summary.cnt_players = 3 AND tourney_hand_summary.str_actors_p LIKE '9%' AND tourney_hand_player_statistics.position = 8 and exists (select 1 from tourney_hand_player_statistics hero where hero.id_hand = tourney_hand_player_statistics.id_hand and hero.flg_hero and hero.flg_p_open_opp and hero.position = 9), tourney_hand_player_statistics.amt_expected_won, 0])
Statistics: Posted by Flag_Hippo — Sun Mar 17, 2024 2:42 pm
if[ NOT cash_hand_player_statistics.flg_f_saw, 0, if[ cash_hand_player_combinations.flg_f_highcard, 9, if[ cash_hand_player_combinations.flg_f_1pair, 8 , if[ cash_hand_player_combinations.flg_f_2pair, 7, if[ cash_hand_player_combinations.flg_f_threeoak, 6, if[ cash_hand_player_combinations.flg_f_straight, 5 , if[ cash_hand_player_combinations.flg_f_flush, 4, if[ cash_hand_player_combinations.flg_f_fullhouse, 3, if[ cash_hand_player_combinations.flg_f_fouroak, 2, if[ cash_hand_player_combinations.flg_f_strflush, 1, 0]]]]]]]]]]
Flag_Hippo wrote:
val_x_hole_cards_used is only used for made hands and there isn't an equivalent for straight draws.
Statistics: Posted by myeari — Sun Mar 17, 2024 9:47 am
sum(if[tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.position = 8,
tourney_hand_player_statistics.amt_expected_won and exists
(select 1
from tourney_hand_player_statistics hero
where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero and hero.flg_p_open_opp and hero.position = 9), 0])
Statistics: Posted by dave2085 — Sun Mar 17, 2024 9:32 am
Statistics: Posted by Flag_Hippo — Sun Mar 17, 2024 7:36 am
if[ NOT cash_hand_player_statistics.flg_f_saw, 0, if[ cash_hand_player_combinations.flg_f_highcard, 9, if[ cash_hand_player_combinations.flg_f_1pair, 8 , if[ cash_hand_player_combinations.flg_f_2pair, 7, if[ cash_hand_player_combinations.flg_f_threeoak, 6, if[ cash_hand_player_combinations.flg_f_straight, 5 , if[ cash_hand_player_combinations.flg_f_flush, 4, if[ cash_hand_player_combinations.flg_f_fullhouse, 3, if[ cash_hand_player_combinations.flg_f_fouroak, 2, if[ cash_hand_player_combinations.flg_f_strflush, 1, 0]]]]]]]]]]
myeari wrote:
One more question, I would like to add also draws, and I found the relevant schemas (e.g., flg_t_straight_draw).
However, I think I will have the same problem again - this schemas would not differ between a straight draw with one or more of the player's hold cards and between a possible straight draw which exist on the board, using only board cards.
Is there a way to differ between those using another schema, as I used for made hand (i.e., id_f_hand_strength).
Also, If there is a schema like that, I would also need the numbers that are assigned to the various strength.
If there is not such a schema, maybe I can use the val_x_hole_cards_used?
myeari wrote:
One last questions, where can I find a detailed information about the proper and various use of functions (e.g. IF) and Oprators (e.g. NOT)?
For example, I had to find by myself that I can use string 'XX' for IF function.
myeari wrote:
And now I'm trying to use NOT next to a schema in the stat or column, and it doesn't let me (e.g., NOT of flg_showdown) in order to exclude all cases which the players exposed its hole cards, although he didn't reach showdown (and my stat count it as a made hand).
NOT cash_hand_player_statistics.flg_showdown
Statistics: Posted by Flag_Hippo — Sun Mar 17, 2024 7:34 am
cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'Villain')
Statistics: Posted by expost — Fri Mar 15, 2024 12:54 pm