PF limp / call stat ?!

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

Re: PF limp / call stat ?!

Postby js2002 » Thu Sep 04, 2008 12:23 pm

WhiteRider wrote:Those database fields are set just once for each hand, so for instance:
holdem_hand_player_statistics.cnt_p_call
..is a count of how many times the player called preflop IN THIS HAND.

The expression will be evaluated once for each hand, so you will either get 1 or 0 for the hand, and the SUM will count these up, one value per hand.

Is that clear?


NOPE ! It was clear that this is only for one hand. But there can be several action in one hand: fe: I can limp/call and limp/call during ONE hand !(with more players in the hand) And I meant that this would cause the value to be 2. Wrong, because I cant limp (AND ...) twice in ONE hand?!
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: PF limp / call stat ?!

Postby WhiteRider » Thu Sep 04, 2008 12:29 pm

The database fields only relate to the actions of a single player, and that one player can only limp once per hand - i.e. on their first preflop action if there is no raise, and they call.
Hence "holdem_hand_player_statistics.flg_p_limp" is a flag, because it is either true or false for a single hand.

The player can, however, call preflop more than once in a hand, so "holdem_hand_player_statistics.cnt_p_call " is a count, because it can be 0, 1, 2, ...

So we could define an additional (less useful database field), flg_p_call, where
flg_p_call = (cnt_p_call > 0)
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: PF limp / call stat ?!

Postby js2002 » Thu Sep 04, 2008 12:32 pm

Thx, everything is clear now!
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: PF limp / call stat ?!

Postby WhiteRider » Thu Sep 04, 2008 12:52 pm

Good!
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: PF limp / call stat ?!

Postby jockodundee » Mon Sep 22, 2008 4:45 pm

WhiteRider,
It appears that in HU play, if I open limp in SB and the BB raises and I call, flg_p_limp is set to false.

Is this a bug?
jockodundee
 
Posts: 23
Joined: Tue Feb 05, 2008 3:42 pm

Re: PF limp / call stat ?!

Postby WhiteRider » Mon Sep 22, 2008 5:02 pm

That bug was fixed - what version of PT3 are you using?
It needed a re-import, though..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: PF limp / call stat ?!

Postby jockodundee » Mon Sep 22, 2008 6:08 pm

Using PT3 beta 17. I reimported this hand in my test database.
In this hand, flg_p_open = true, flg_vpip = true, flg_p_limp = false for Me.


PokerStars Game #20352594684: Hold'em Limit ($50/$100) - 2008/09/12 16:06:25 ET
Table 'Hapag' 6-max Seat #1 is the button
Seat 1: Me ($1190 in chips)
Seat 5: Digs65 ($2785 in chips)
Me: posts small blind $25
Digs65: posts big blind $50
*** HOLE CARDS ***
Dealt to Me [2d Jc]
Me: calls $25
Digs65: raises $50 to $100
Me: calls $50
*** FLOP *** [6s 3h 9d]
Digs65: bets $50
Me: folds
Uncalled bet ($50) returned to Digs65
Digs65 collected $199 from pot
Digs65: doesn't show hand
*** SUMMARY ***
Total pot $200 | Rake $1
Board [6s 3h 9d]
Seat 1: Me (button) (small blind) folded on the Flop
Seat 5: Digs65 (big blind) collected ($199)
jockodundee
 
Posts: 23
Joined: Tue Feb 05, 2008 3:42 pm

Re: PF limp / call stat ?!

Postby js2002 » Tue Sep 23, 2008 2:02 am

Can somebody plz test my limp stats?
I actually teste it and wounder why limp / call works for old hands, but when I play live and see such a hand the limp / call stat doesnt change.

Can someone explain that?

http://rapidshare.com/files/147617986/l ... s.rar.html

The denominator ist now a failed limp (faced raise).
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: PF limp / call stat ?!

Postby WhiteRider » Tue Sep 23, 2008 4:32 am

jockodundee wrote:Using PT3 beta 17. I reimported this hand in my test database.
In this hand, flg_p_open = true, flg_vpip = true, flg_p_limp = false for Me.


Please attach the full original hand history to a ticket on the Support system so that we can investigate.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: PF limp / call stat ?!

Postby WhiteRider » Tue Sep 23, 2008 4:33 am

js2002 wrote:Can somebody plz test my limp stats?
I actually teste it and wounder why limp / call works for old hands, but when I play live and see such a hand the limp / call stat doesnt change.

Can someone explain that?

http://rapidshare.com/files/147617986/l ... s.rar.html

The denominator ist now a failed limp (faced raise).

I'll try to have a look at this later if I have time.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 0 guests