Page 1 of 2
PokerStars: Prohibit use of custom stats?
Posted:
Thu Mar 21, 2019 2:38 pm
by 44twiglet
From the release notes:
PokerStars: Prohibit use of custom stats, derived from player hole cards or board cards, from displaying on PokerStars tables.
I am using these two, which are coming up as prohibited.
River Bet Bluff Frequency - (cnt_r_bet_bluff / cnt_r_bet_known) * 100
and
River Raise Bluff Frequency - (cnt_r_raise_bluff / cnt_r_raise_known) * 100
They are stats to determine river bluffs, which I would expect to be OK from the above.
Am I missing something?
Re: PokerStars: Prohibit use of custom stats?
Posted:
Fri Mar 22, 2019 9:00 am
by Flag_Hippo
I cannot tell how your custom statistic is defined from just the column names so please post the expressions from your custom columns here, via PM or in a
Support Ticket.
Re: PokerStars: Prohibit use of custom stats?
Posted:
Sat Mar 23, 2019 5:53 am
by 44twiglet
Flag_Hippo wrote:I cannot tell how your custom statistic is defined from just the column names so please post the expressions from your custom columns here, via PM or in a
Support Ticket.
Sorry. I think this is what you need:
cnt_r_bet_bluff
sum(if[((cash_hand_player_combinations.flg_r_highcard) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength < 3) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 4) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 5) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength < 3) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 4) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 5) OR (cash_hand_player_combinations.flg_r_threeoak AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_straight AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_flush AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_fullhouse AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_fouroak AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_strflush AND cash_hand_player_combinations.id_r_hand_strength = 0)) AND (cash_hand_player_statistics.flg_r_bet) AND NOT (cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand), 1, 0])
cnt_r_bet_known
sum(if[cash_hand_player_statistics.flg_r_bet AND cash_hand_player_statistics.id_holecard>0, 1, 0])
cnt_r_raise_bluff
sum(if[((cash_hand_player_combinations.flg_r_highcard) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength < 3) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 4) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 5) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength < 3) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 4) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 5) OR (cash_hand_player_combinations.flg_r_threeoak AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_straight AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_flush AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_fullhouse AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_fouroak AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_strflush AND cash_hand_player_combinations.id_r_hand_strength = 0)) AND (cash_hand_player_statistics.cnt_r_raise > 0) AND NOT (cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand), 1, 0])
cnt_r_raise_known
sum(if[(cash_hand_player_statistics.cnt_r_raise > 0) AND (cash_hand_player_statistics.id_holecard>0), 1, 0])
Re: PokerStars: Prohibit use of custom stats?
Posted:
Sat Mar 23, 2019 10:01 am
by Flag_Hippo
Anything using cash_hand_player_statistics.id_holecard is blocked for PokerStars so use cash_hand_player_statistics.flg_showdown for your known columns instead.
Re: PokerStars: Prohibit use of custom stats?
Posted:
Sun Mar 24, 2019 8:31 am
by 44twiglet
Thanks for swift replies guys. I am not database savvy so I gotta ask for some hand holding, I have tried (8 hours!).
I tried to simply substitute
cash_hand_player_statistics.id_holecard
with
cash_hand_player_statistics.flg_showdown
giving the expression
sum(if[cash_hand_player_statistics.flg_r_bet AND cash_hand_player_statistics.flg_showdown>0, 1, 0])
This comes up invalid.
Then tried a lot of guesswork editing, some came up valid some not, but nothing produced a result in the HUD.
So before I crack up completely, can I ask for specific changes for these two columns, thanks.
cnt_r_bet_known
sum(if[cash_hand_player_statistics.flg_r_bet AND cash_hand_player_statistics.id_holecard>0, 1, 0])
and
cnt_r_raise_known
sum(if[(cash_hand_player_statistics.cnt_r_raise > 0) AND (cash_hand_player_statistics.id_holecard>0), 1, 0])
Re: PokerStars: Prohibit use of custom stats?
Posted:
Sun Mar 24, 2019 8:38 am
by Flag_Hippo
cnt_r_bet_known- Code: Select all
sum(if[cash_hand_player_statistics.flg_r_bet AND cash_hand_player_statistics.flg_showdown, 1, 0])
cnt_r_raise_known- Code: Select all
sum(if[(cash_hand_player_statistics.cnt_r_raise > 0) AND (cash_hand_player_statistics.flg_showdown), 1, 0])
Re: PokerStars: Prohibit use of custom stats?
Posted:
Sun Mar 24, 2019 8:59 am
by 44twiglet
Flag_Hippo - that is nothing short of first class service, minutes after I posted. Thank you very much.
All fixed, tested and working as expected.
Thank you again.
Re: PokerStars: Prohibit use of custom stats?
Posted:
Sun Jan 24, 2021 8:08 am
by IA06
So I changed the
cnt_r_bet_known
sum(if[cash_hand_player_statistics.flg_r_bet AND cash_hand_player_statistics.id_holecard>0, 1, 0])
to
cnt_r_bet_known
sum(if[cash_hand_player_statistics.flg_r_bet AND cash_hand_player_statistics.flg_showdown, 1, 0])
But then
River Bet Bluff Frequency - (cnt_r_bet_bluff / cnt_r_bet_known) * 100
ends up showing me numbers above 100. Shouldn´t the value be between 0-100 here?
I´m still using
cnt_r_raise_bluff
sum(if[((cash_hand_player_combinations.flg_r_highcard) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength < 3) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 4) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 5) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength < 3) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 4) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 5) OR (cash_hand_player_combinations.flg_r_threeoak AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_straight AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_flush AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_fullhouse AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_fouroak AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_strflush AND cash_hand_player_combinations.id_r_hand_strength = 0)) AND (cash_hand_player_statistics.cnt_r_raise > 0) AND NOT (cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand), 1, 0])
Re: PokerStars: Prohibit use of custom stats?
Posted:
Mon Jan 25, 2021 6:51 am
by Flag_Hippo
Have you rebuilt your custom database cache (Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild) after making the change?
Re: PokerStars: Prohibit use of custom stats?
Posted:
Tue Feb 23, 2021 6:47 pm
by IA06
I did rebuild the database and then it worked fine. Until no when it´s back to values above 100. Tried to do it all over again from the beginning, restarted everything but now nothing seems to help.