Possible Stat problem in beta 19

[Skarfayce]

I just imported your stat, and there is still no (cnt_p_BB_fold_to_SB / cnt_p_BB_fold_to_SB_opp) columns. the only thing added was cnt_steal_success.

[kraada]

In that case I'll just tell you how to build it.

Click Configure --> Stats.

Click on Holdem Cash Player Statistics, switch to the Columns tab.

Click New.
Name the first one cnt_p_BB_fold_to_SB and put

Code: Select all

sum(if[holdem_hand_player_statistics.flg_p_fold AND
holdem_hand_player_statistics.position = 8 AND (holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

in the expression box. The description box doesn't matter, but the official description is "If the BB folded to a SB blind steal.". Summary type should be count.

Save it.

Create a new one called cnt_p_BB_fold_to_SB_opp and put

Code: Select all

sum(if[holdem_hand_player_statistics.position = 8 AND (holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

in as the expression, and the official description is "If the BB faced a blind steal by the SB." Summary type should also be count.

Save this one as well.

Once they're both saved, re-run the cache update on your database and you shouldn't have that error anymore.

[Skarfayce]

seems to be working, ty