more than one action - value of bets

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

more than one action - value of bets

Postby nicks1657 » Mon Jun 01, 2009 1:19 pm

Hi, i need a litlle help.

let's see this example on turn:
TURN [board cards 9D,8H,8C,QD ]
nicks1657 bets $0.30
player2 calls $0.30,
player3 folds,
player4 bets $0.60,
nicks1657 bets $0.60,
player2 calls $0.60,
player4 bets $0.60,
nicks1657 calls $0.30,
player2 calls $0.30.

so my amt_bet_t = $1.2

but how can i know that this 1.2 is 0.30 (bet) + 0.60 (bet) + 0.30 (call) looking to database fields.

Thanks.
Nicks
nicks1657
 
Posts: 1
Joined: Mon Jun 01, 2009 1:04 pm

Re: more than one action - value of bets

Postby kraada » Mon Jun 01, 2009 1:37 pm

holdem_hand_player_detail.amt_t_bet_made there will be .30, since you never raised amt_t_raise_made = 0. So you can tell that the rest of the bets made were calls. You can figure out how many times you called on the turn in that hand by looking at holdem_hand_player_statistics.cnt_t_call for that hand.
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