flg_p_limp_opp Q?

[warrior04]

i'm having trouble building a stat to check limp_opp...

was thinking something like:

Code: Select all

select ....
from....
where
NOT flg_p_open_opp
AND NOT flg_p_face_raise

but it doesn't cover the case if a player limp then faced a raise.
any idea of how can i make it right?

[kraada]

The following will give you your list of limp opportunities:

(NOT(holdem_hand_player_statistics.flg_p_face_raise) OR (holdem_hand_player_statistics.flg_p_limp) OR (holdem_hand_player_statistics.flg_p_first_raise)) AND NOT(holdem_hand_player_statistics.flg_blind_b)

[warrior04]

tnx... :)
one more query

flg_p_limp_behind_opp.... what do i need to add to see if someone limped behind me?

[kraada]

cnt_p_limp_after_limpers_opp is defined by default - it's a count of how often a player limped behind other limpers. Figuring out if anybody limped after you is going to be incredibly difficult unless you're restricting yourself to unraised pots (at which point you just check to make sure you're not in position).

[warrior04]

a small correction... i meant a flg query to see if someone had limp before me...

and try to build the query in sql...

[kraada]

If you click Configure --> Configure Statistics go to the Holdem Cash Player Statistics section and highlight cnt_p_limp_after_limpers_opp you can see how we do it.