first raise opportunity?

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

first raise opportunity?

Postby spapia00 » Tue Apr 14, 2009 5:33 pm

I want to create a stat which means the opportunity of "first raise". There is flg_p_open_opp but it means there were no limpers before, right?

Lets say I want to know how often a villain raise in every situation he can raise first (which means that there could be some limpers before him).
spapia00
 
Posts: 16
Joined: Fri Apr 04, 2008 3:42 am

Re: first raise opportunity?

Postby js2002 » Fri Feb 08, 2013 10:49 am

That not correct:

tourney_hand_player_statistics.flg_p_first_raise is when Player did the raise
I need sth like:

tourney_hand_player_statistics.flg_p_first_raise_opp, thats not possible?
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: first raise opportunity?

Postby kraada » Fri Feb 08, 2013 11:18 am

Sorry, flg_p_open_opp does imply there are no limpers. If there are limpers and you have a chance to make the first raise, cnt_p_face_limpers is equal to the number of limpers faced.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: first raise opportunity?

Postby js2002 » Fri Feb 08, 2013 11:49 am

That doenst help for cases where the action is: limp limp 2bet and hero limper>0 says true but: This is not chance to "first_raise" / no first_raise_opp.

So how do I check for: first_raise_opp?
I need sth like 2bet_opp.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: first raise opportunity?

Postby kraada » Fri Feb 08, 2013 1:36 pm

In that case for hero, cnt_p_face_limpers = 0. It only is greater than 0 if you personally were in a spot to raise those limpers. It's not the number of total limpers in the hand.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: first raise opportunity?

Postby js2002 » Fri Feb 08, 2013 1:41 pm

ay, yeeeha, thx a lot.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: first raise opportunity?

Postby js2002 » Sat Feb 09, 2013 5:26 am

... done
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany


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

Who is online

Users browsing this forum: No registered users and 7 guests

cron
highfalutin