2 quick simple questions

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

2 quick simple questions

Postby bloodndef » Wed Apr 01, 2009 2:10 am

Is:

holdem_hand_player_statistics.cnt_p_raise>0

including all preflop raises, 3bets, 4,bets, etc?

And will:

NOT holdem_hand_player_statistics.flg_p_open_opp

return instances where a player was not the first into the pot?

Thank you!
bloodndef
 
Posts: 99
Joined: Fri Feb 27, 2009 1:28 am

Re: 2 quick simple questions

Postby bloodndef » Wed Apr 01, 2009 4:33 am

Is there a difference between:

NOT holdem_hand_player_statistics.flg_p_open_opp

and

holdem_hand_player_statistics.flg_p_open = false

?


Thanks
bloodndef
 
Posts: 99
Joined: Fri Feb 27, 2009 1:28 am

Re: 2 quick simple questions

Postby WhiteRider » Wed Apr 01, 2009 7:36 am

bloodndef wrote:Is:

holdem_hand_player_statistics.cnt_p_raise>0

including all preflop raises, 3bets, 4,bets, etc?

Yes - cnt_p_raise is how many times you raised preflop.

And will:

NOT holdem_hand_player_statistics.flg_p_open_opp

return instances where a player was not the first into the pot?


flg_p_open_opp is true when the player had the opportunity to open the pot, regardless of whether they did or not.
So "NOT flg_p_open_opp" is true when someone has opened the pot before their first action.
(So yes, you're right, but it doesn't actually say they entered the pot.)

bloodndef wrote:Is there a difference between:

NOT holdem_hand_player_statistics.flg_p_open_opp

and

holdem_hand_player_statistics.flg_p_open = false

Yes, they are different situations as mentioned above.

flg_p_open : true means the player opened the pot - i.e. was the first one to put money in (other than the blinds); false means they didn't open the pot - either they didn't play or someone had already opened it.
flg_p_open_opp : true means they had the opportunity to open the pot (no-one had bet before them); false means they didn't have the opportunity to open the pot.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: 2 quick simple questions

Postby bloodndef » Wed Apr 15, 2009 4:44 am

Ok, ok. Last one.

Is

NOT holdem_hand_player_statistics.flg_p_open_opp

the same as

holdem_hand_player_statistics.flg_p_open_opp = false


Thanks again.
bloodndef
 
Posts: 99
Joined: Fri Feb 27, 2009 1:28 am

Re: 2 quick simple questions

Postby kraada » Wed Apr 15, 2009 11:48 am

Yes.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests