Bet River (Vs Hero)

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Bet River (Vs Hero)

Postby Doninorrez » Wed Dec 07, 2022 8:27 am

Hello,

I was trying to build this stat but i am not sure if I am doing it right...

Bet River stat is configured like this:

(cnt_r_bet / (cnt_r_bet + cnt_r_check)) * 100

Where:

cnt_r_bet:
sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])
cnt_r_check:
sum(if[cash_hand_player_statistics.flg_r_check, 1, 0])

----

Bet River (Vs Hero) could be configured like this:(cnt_r_bet_vs_hero / (cnt_r_bet_vs_hero + cnt_r_check_vs_hero)) * 100

Where:

cnt_r_bet_vs_hero:

sum(if[cash_hand_player_statistics.flg_r_bet and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and ((hero.flg_r_open_opp and hero.flg_r_check) or (hero.flg_r_has_position and not hero.flg_r_open_opp))), 1, 0]) ??

cnt_r_check_vs_hero: ??
...

If the Villain is betting in river, I have to define in the subset Heros actions in this river? Maybe It could be enough to say that hero is facing a bet in river but no idea about how to do it...
Can someone help me on this please? :?:
Thank you!
Doninorrez
 
Posts: 44
Joined: Sat Jan 09, 2016 11:25 am

Re: Bet River (Vs Hero)

Postby Flag_Hippo » Thu Dec 08, 2022 6:25 am

Doninorrez wrote:Maybe It could be enough to say that hero is facing a bet in river but no idea about how to do it...

If a player is facing a bet on the river the following is true:

Code: Select all
cash_hand_player_statistics.amt_r_bet_facing > 0
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Bet River (Vs Hero)

Postby Doninorrez » Thu Dec 08, 2022 6:39 am

Hi! thanks for the quick response.
But I cant use this expression in the subset, right? :cry:
Doninorrez
 
Posts: 44
Joined: Sat Jan 09, 2016 11:25 am

Re: Bet River (Vs Hero)

Postby Flag_Hippo » Thu Dec 08, 2022 6:58 am

It works:

Code: Select all
sum(if[cash_hand_player_statistics.flg_r_bet and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.amt_r_bet_facing > 0), 1, 0])
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Bet River (Vs Hero)

Postby Doninorrez » Thu Dec 08, 2022 12:16 pm

Wow ok! was easyer than I thought.
¿Can I add any expression like this to the subset including "hero." in the beginning?

Ty again ;)
Doninorrez
 
Posts: 44
Joined: Sat Jan 09, 2016 11:25 am

Re: Bet River (Vs Hero)

Postby Flag_Hippo » Thu Dec 08, 2022 1:44 pm

As long as it's from cash_hand_player_statistics.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Bet River (Vs Hero)

Postby Doninorrez » Thu Dec 08, 2022 3:47 pm

Thank you again! ;)
Doninorrez
 
Posts: 44
Joined: Sat Jan 09, 2016 11:25 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 21 guests

cron