facing bet having position

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

facing bet having position

Postby marvin » Tue Oct 13, 2009 11:50 am

if im facing a bet made by a player oop (relative me), is correct use only this condition (on turn):(holdem_hand_player_detail.val_t_bet_aggressor_pos<holdem_hand_player_statistics.position)

or i must add some like (NOT FLAG_T_OPEN_OPP)? IN OTHER WORD, the condition :(holdem_hand_player_detail.val_t_bet_aggressor_pos<holdem_hand_player_statistics.position)is false only if im not facing a bet, or if the bettor has position better than me.
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: facing bet having position

Postby kraada » Tue Oct 13, 2009 12:32 pm

val_t_bet_aggressor_pos is the position of the person who made the first bet.

For the position of the last raiser, that would be val_t_raise_aggressor_pos.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: facing bet having position

Postby marvin » Tue Oct 13, 2009 1:10 pm

yes but5 im thinking only about a faced bet
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: facing bet having position

Postby kraada » Tue Oct 13, 2009 1:35 pm

holdem_hand_player_detail.val_t_bet_aggressor_pos<holdem_hand_player_statistics.position

Is true if either: you are facing a bet and the bettor has position on you, or you made the bet (ad then val_t_bet_aggressor_pos = -1. If you check to make sure that it's >= 0, then it's true only if he bet and has position on you and false otherwise.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: facing bet having position

Postby marvin » Tue Oct 13, 2009 3:22 pm

TY. i had to think my self sorry... :mrgreen:
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: facing bet having position

Postby kraada » Tue Oct 13, 2009 4:08 pm

No worries :D
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