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
by 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
by 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: 1502
- Joined: Fri Feb 15, 2008 5:44 am
- Location: Germany
by 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: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by 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: 1502
- Joined: Fri Feb 15, 2008 5:44 am
- Location: Germany
by 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: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by js2002 » Fri Feb 08, 2013 1:41 pm
ay, yeeeha, thx a lot.
-
js2002
-
- Posts: 1502
- Joined: Fri Feb 15, 2008 5:44 am
- Location: Germany
by js2002 » Sat Feb 09, 2013 5:26 am
... done
-
js2002
-
- Posts: 1502
- Joined: Fri Feb 15, 2008 5:44 am
- Location: Germany
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests