holdem_hand_player_detail.flg_t_open

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

holdem_hand_player_detail.flg_t_open

Postby rekyl » Fri Sep 26, 2008 8:21 am

Hi,
Just need a confirmation that I understand this field right. Will this flag be TRUE only after a BET or will a CHECK also set this flag? In lack of having a field like "flg_t_face_bet" I'm hoping I can use the field like this: "holdem_hand_player_detail.flg_t_open = False" and this would equal a flag for facing a bet on Turn?
rekyl
 
Posts: 43
Joined: Thu Feb 14, 2008 8:45 pm

Re: holdem_hand_player_detail.flg_t_open

Postby WhiteRider » Fri Sep 26, 2008 11:27 am

Only a bet will set that flag to true.
However, if it is false, that doesn't necessarily mean that you faced (specifically) a bet. It might just have been checked round, or even if you call, you might face a [bet and] raise.

You might find "holdem_hand_player_detail.amt_t_bet_facing" useful for this, though. You can check for this value being non-zero.
There is also "holdem_hand_player_detail.amt_t_raise_facing", but I'm not sure that this is specifically a "raise" (i.e. 2-bet) - I suspect it is the first turn raise you face regardless of whether this is a 2-bet or 3-bet..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: holdem_hand_player_detail.flg_t_open

Postby rekyl » Sun Sep 28, 2008 12:59 am

WhiteRider wrote:Only a bet will set that flag to true.
However, if it is false, that doesn't necessarily mean that you faced (specifically) a bet. It might just have been checked round, or even if you call, you might face a [bet and] raise.

You might find "holdem_hand_player_detail.amt_t_bet_facing" useful for this, though. You can check for this value being non-zero.
There is also "holdem_hand_player_detail.amt_t_raise_facing", but I'm not sure that this is specifically a "raise" (i.e. 2-bet) - I suspect it is the first turn raise you face regardless of whether this is a 2-bet or 3-bet..


Hi WhiteRider, Thanks for your answer!
I knew, the moment I submitted that last post, that I had forgot the check around situation :) Anyway, that "holdem_hand_player_detail.amt_t_bet_facing" field looks like exactly what I need, so thanks again :) Will it be enough to use this field alone or should I use it in combination with "holdem_hand_player_detail.flg_t_open" so I'm sure that it is the FIRST bet I'm facing?
rekyl
 
Posts: 43
Joined: Thu Feb 14, 2008 8:45 pm

Re: holdem_hand_player_detail.flg_t_open

Postby WhiteRider » Sun Sep 28, 2008 4:19 am

I'm fairly confident that's all you'll need, but you might want to set it up and check it with a few different types of hands.
There is also a field "holdem_hand_player_detail.amt_t_raise_facing" though, so I'm pretty sure the 'facing bet' field does what it says on the tin.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests