exact meaning of the cnt_players from the holdem_cache table

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

exact meaning of the cnt_players from the holdem_cache table

Postby Yuhuru » Fri Dec 23, 2011 11:56 am

Hi,
I'm in doubt of how to interpret the cnt_players from table holdem_cache. Does it equal
a) to the number of players who were dealt into the hand (as in table holdem_hand_summary), or
b) to the number of players who are still at cards at some moment in the middle of the hand at which PT3 registers an event e.g. "donk on the river" (against cnt_players-1 opponents)?
I expect second option, but would like to know it for sure.
Thx
Yuhuru
 
Posts: 3
Joined: Fri Dec 23, 2011 11:03 am

Re: exact meaning of the cnt_players from the holdem_cache t

Postby kraada » Fri Dec 23, 2011 1:22 pm

It's the number of players who were dealt into the hand - that value is used for filtering by Player Ranges (see the Hud Options tab in the Configure --> Configure Hud window).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: exact meaning of the cnt_players from the holdem_cache t

Postby Yuhuru » Sun Jan 29, 2012 12:57 pm

And, as I understand, the meaning (b) can't be derived from existing database values without re-parsing hand histories. This feature looks so useful for me, that I think of doing some coding to get it. But before start spending time I'd like to be sure that the feature (b) isn't going to emerge suddenly in near future releases of PT software and database. Has anybody competent opinion about possibility of this?
Yuhuru
 
Posts: 3
Joined: Fri Dec 23, 2011 11:03 am

Re: exact meaning of the cnt_players from the holdem_cache t

Postby WhiteRider » Mon Jan 30, 2012 4:18 am

You can tell the number of players at the start of each street using "holdem_hand_summary.cnt_players_f" for the flop, or _t or _r for the turn or river, but you can't tell the number of players active in the middle of a street. At the point of a bet, though, no-one will have folded since the start of that street (usually).
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: exact meaning of the cnt_players from the holdem_cache t

Postby Yuhuru » Mon Jan 30, 2012 10:23 am

Yes, cnt_players_f or _t or _r works perfect before the point of a bet (usually, :D , those funny folds are rather rare), but thereafter it doesn't always do alas.
Yuhuru
 
Posts: 3
Joined: Fri Dec 23, 2011 11:03 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 19 guests

cron
highfalutin