CCPF on the repository

[Alexkidd103]

Learning and looking how other people is dealing with the lack of some X_opp columns, i looked into the CCPF colums of badleutenient,and i found out that CCPF_OPP aren't correctly stated. if you run a report on cold called hands, you will find some 105%, 110%, because a some of CCPF_OPP that are possible aren't included in the used colum , wich reads like the following.

cnt_ccpf_btn_opp
sum(if[holdem_hand_player_statistics.flg_p_face_raise and holdem_hand_player_statistics.flg_p_limp = false and holdem_hand_player_detail.amt_blind=0 and holdem_hand_player_statistics.position = 0,1,0 ] )

and
sum( if[ holdem_hand_player_statistics.flg_p_ccall and holdem_hand_player_statistics.position = 0,1,0 ] )

this are for badleutenient in the repository

i think is possible to do it right since there is a CCPF_OPP even if i don't understand it perfectly yet.

[WhiteRider]

My cold call opportunity column is this:

sum( if[ NOT(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 (holdem_hand_player_detail.amt_blind=0), 1 , 0 ] )

This is basically "NOT (facing limpers) AND NOT (in a blind)".

You could add a check for button position to this.

Actually, the best way would just be to duplicate the built-in CCPF stat and add the position check.

I guess this stat was added to the repository before the CCPF stat was corrected.
I've sent a PM to BadLieutenant about this, and we'll see if he wants to update his stat - otherwise we'll get it fixed.