new: openlimp / fold validate plz!

[js2002]

sum(if[holdem_hand_player_statistics.position = 9 AND
holdem_hand_player_statistics.flg_p_open_opp AND
holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND
holdem_hand_player_statistics.flg_p_fold
, 1, 0])
_____________________________________________
sum(if[holdem_hand_player_statistics.position = 9 AND
holdem_hand_player_statistics.flg_p_open_opp AND
holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND

, 1, 0])

ok? should I build-in a cnt_p_call = 0 ? Or does p_limp put cnt_p_call +1 ???
EDIT: I tested and all with the p_call=0 show 0/0 so i guess it counts +1, how do I check for limpfold algain with this string ala "CF" ?!

[js2002]

hmmm to less sample in my DB, cant really say if it counts +1. someone tell me plz...

Does lookup_actions_p.action = 'CF' deliver me the wanted result? So, in other words: Is an (open)limp followed by a fold CF? or does sth like 'LF' exist?

[kraada]

You want lookup_actions_p.action LIKE 'CF'. The options for the action string are: C (call), F (fold), B (Bet), R (Raise), X (Check).

[js2002]

sum(if[holdem_hand_player_statistics.position = 9 AND
holdem_hand_player_statistics.flg_p_open_opp AND
holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND
lookup_actions_p.action = 'CF' AND
holdem_hand_player_statistics.flg_p_fold
, 1, 0])

sum(if[holdem_hand_player_statistics.position = 9 AND
holdem_hand_player_statistics.flg_p_open_opp AND
holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND
lookup_actions_p.action = 'CF'
, 1, 0])

done, I hope it is good. n8

[kraada]

Given the actions like CF you don't need cnt_p_raise = 0 - you've already explicitly stated the actions the player has taken preflop so no need to test for something that can't happen.

[WhiteRider]

If you are using:

lookup_actions_p.action = 'CF'

..you don't need any of the rest of this:

holdem_hand_player_statistics.flg_p_limp AND
holdem_hand_player_statistics.flg_p_face_raise AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND
holdem_hand_player_statistics.flg_p_fold

..because the actions define exactly what the player did.
They MUST have limped, faced a raise (in order to then fold), not raised, and folded.