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 marvin » Wed Oct 28, 2009 8:04 am
ON FLOP:
SB: BET - BUTTON: CALL
1) ABOUT button: holdem_hand_player_detail.val_f_bet_aggressor_pos= 9
2) about SB holdem_hand_player_detail.val_f_bet_aggressor_pos= -1 (WHY HE IS THE BETTOR)
now, there arent raise in this action then..............
3) about SB holdem_hand_player_detail.val_f_raise_aggressor_pos= ??
4) about BUTTON holdem_hand_player_detail.val_f_raise_aggressor_pos = ??
-
marvin
-
- Posts: 327
- Joined: Tue Jul 08, 2008 10:17 am
by kraada » Wed Oct 28, 2009 9:11 am
It looks like for both players the value is -1. You can then distinguish -1 from times they were the actual raise aggressor by looking for times they did indeed raise via another condition.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by marvin » Wed Oct 28, 2009 9:31 am
ok, this is not a problem,
QUESTION: can i be sure that theese conditions will not change in future :?: ? i dont want write a ton of columns supposing a certain conditions that can be modified in future (i.e. if in new version will be made that raise_agg_pos is=-1 if the raiser is the hero and raise_agg_pos =-2 if the street has not been raised)... :mrgreen: :ugeek: :?
-
marvin
-
- Posts: 327
- Joined: Tue Jul 08, 2008 10:17 am
by kraada » Wed Oct 28, 2009 9:47 am
There are no plans to change the value of these database fields that I have heard of.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 2 guests