Open limp flagged as open but not limp - why?

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

Open limp flagged as open but not limp - why?

Postby Weedobooty » Fri Nov 28, 2008 5:02 am

Hello.

I just started to create some custom stats. I wanted to know the percentage of folds/not folds after a player has limped and faced a raise.

I found the columns i need for the task, but i also found something that i can't figure out. holdem_hand_player statistics has the columns flg_p_limp and flg_p_open. As far as i can tell, limping after a previous limper is considered a limp but not an open, which is fine, but i found this hand, where a player limps in first and this hand is flagged as open=true and limp=false.

Is this a bug or a feature?

Full Tilt Poker Game #91500xxx: Table Tumbling - $0.50/$1 - No Limit Hold'em - 19:01:28 ET - 2008/11/24
Seat 1: worstplayaever1 ($64.95)
Seat 2: HEEE-AHHH ($44.30)
Seat 3: HERO ($41.35)
Seat 4: ildittatore ($96.50)
Seat 5: Eastland ($213.65)
Seat 6: Gsus4 ($100)
Seat 7: Incorrigible ($162.65)
Seat 8: giorgos4 ($99.75)
Seat 9: DevilPrince ($88)
Gsus4 posts the small blind of $0.50
Incorrigible posts the big blind of $1
The button is in seat #5
*** HOLE CARDS ***
giorgos4 folds
DevilPrince folds
worstplayaever1 folds
HEEE-AHHH folds
HERO calls $1
ildittatore calls $1
Eastland folds
Gsus4 raises to $6
Incorrigible has 15 seconds left to act
Incorrigible folds
HERO calls $5
ildittatore folds
*** FLOP *** [Tc 9h 4d]
Gsus4 bets $10
HERO calls $10
*** TURN *** [Tc 9h 4d] [7c]
Gsus4 has 15 seconds left to act
Gsus4 bets $26
HERO folds
Uncalled bet of $26 returned to Gsus4
Gsus4 mucks
Gsus4 wins the pot ($32.30)
*** SUMMARY ***
Total pot $34 | Rake $1.70
Board: [Tc 9h 4d 7c]
Seat 1: worstplayaever1 didn't bet (folded)
Seat 2: HEEE-AHHH didn't bet (folded)
Seat 3: HERO folded on the Turn
Seat 4: ildittatore folded before the Flop
Seat 5: Eastland (button) didn't bet (folded)
Seat 6: Gsus4 (small blind) collected ($32.30), mucked
Seat 7: Incorrigible (big blind) folded before the Flop
Seat 8: giorgos4 didn't bet (folded)
Seat 9: DevilPrince didn't bet (folded)
Weedobooty
 
Posts: 7
Joined: Sat May 17, 2008 11:40 am

Re: Open limp flagged as open but not limp - why?

Postby WhiteRider » Fri Nov 28, 2008 5:08 am

I'll investigate this hand later on when I have some time.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Open limp flagged as open but not limp - why?

Postby WhiteRider » Fri Nov 28, 2008 12:11 pm

Please send me the full hand history - either PM me the text or attach it to a support ticket and let me know the ticket number.
Thanks.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Open limp flagged as open but not limp - why?

Postby Weedobooty » Thu Dec 04, 2008 1:16 am

I don't think i still have it. I'll find another one. Hang on for a day or two.
Weedobooty
 
Posts: 7
Joined: Sat May 17, 2008 11:40 am

Re: Open limp flagged as open but not limp - why?

Postby WhiteRider » Thu Dec 04, 2008 6:05 am

Sure. I think I replied to your ticket yesterday? Attach the hand history to your ticket when you find it, and PM me.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Open limp flagged as open but not limp - why?

Postby Weedobooty » Wed Dec 17, 2008 9:20 am

WhiteRider wrote:Sure. I think I replied to your ticket yesterday? Attach the hand history to your ticket when you find it, and PM me.


I just sent you a new file.
Weedobooty
 
Posts: 7
Joined: Sat May 17, 2008 11:40 am

Re: Open limp flagged as open but not limp - why?

Postby WhiteRider » Wed Dec 17, 2008 7:29 pm

What is the ticket number?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 1 guest