by RustyBrooks » Mon Aug 17, 2009 2:36 pm
So the concept of vol_put_money_in_pot as a "whole hand" stat does not seem consistent with what PT holdem (version 2) does. I have this holdem hand in PT holdem, for example, where I am the BB, it limps to me, and I call a bet on the turn. My vol_put_money_in_pot for this hand is 0.
select seat_number, screen_name, vol_put_money_in_pot from game
join game_players using (game_id)
join players on (players.player_id=game_players.real_player_id)
where ub_game_number='6390474053'
1 "swafjto" 0
2 "apple36" 1
3 "cjworks_com" 1
4 "unclbucc" 0
5 "Bobby Hutton" 1
6 "CHIPSDACLOWN" 0
7 "RobBar301" 1
8 "FONZY4" 1
FullTiltPoker Game #6390474053: Table Montagna - $0.50/$1 - Limit Hold'em - 18:48:38 ET - 2008/05/12
Seat 1: swafjto ($34.15)
Seat 2: apple36 ($7.85)
Seat 3: cjworks_com ($52.25)
Seat 4: unclbucc ($16.75)
Seat 5: Bobby Hutton ($12.85)
Seat 6: CHIPSDACLOWN ($5)
Seat 7: RobBar301 ($21.25)
Seat 8: FONZY4 ($22.90)
FONZY4 posts the small blind of $0.25
swafjto posts the big blind of $0.50
The button is in seat #7
*** HOLE CARDS ***
Dealt to swafjto [8s Tc]
apple36 calls $0.50
cjworks_com calls $0.50
unclbucc folds
Bobby Hutton calls $0.50
CHIPSDACLOWN folds
RobBar301 calls $0.50
FONZY4 calls $0.25
swafjto checks
*** FLOP *** [As 2d 2c]
FONZY4 checks
swafjto checks
apple36 checks
cjworks_com checks
Bobby Hutton checks
RobBar301 checks
*** TURN *** [As 2d 2c] [Td]
FONZY4 bets $1
swafjto has 15 seconds left to act
swafjto calls $1
apple36 calls $1
cjworks_com calls $1
Bobby Hutton folds
RobBar301 folds
*** RIVER *** [As 2d 2c Td] [8h]
FONZY4 checks
swafjto bets $1
apple36 has 15 seconds left to act
apple36 folds
cjworks_com folds
FONZY4 calls $1
*** SHOW DOWN ***
swafjto shows [8s Tc] two pair, Tens and Eights
FONZY4 mucks
swafjto wins the pot ($8.55) with two pair, Tens and Eights
*** SUMMARY ***
Total pot $9 | Rake $0.45
Board: [As 2d 2c Td 8h]
Seat 1: swafjto (big blind) showed [8s Tc] and won ($8.55) with two pair, Tens and Eights
Seat 2: apple36 folded on the River
Seat 3: cjworks_com folded on the River
Seat 4: unclbucc didn't bet (folded)
Seat 5: Bobby Hutton folded on the Turn
Seat 6: CHIPSDACLOWN didn't bet (folded)
Seat 7: RobBar301 (button) folded on the Turn
Seat 8: FONZY4 (small blind) mucked [9h Ts] - two pair, Tens and Twos