How detect the number of callers before hero action

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

How detect the number of callers before hero action

Postby TROM » Fri Jun 08, 2012 2:52 pm

I want to know how many callers was on preflop when Hero have for example flg_p_3bet_opp = true or flg_p_4bet_opp = true
I want to know count of callers only in moment when Hero have opportunity to make 3bet or 4bet not all callers on preflop
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: How detect the number of callers before hero action

Postby kraada » Fri Jun 08, 2012 3:53 pm

If yours was the last action you can check the number of players that saw the flop in holdem_hand_summary.cnt_players_f - there had to be one caller for every person other than yourself.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: How detect the number of callers before hero action

Postby TROM » Fri Jun 08, 2012 4:00 pm

but if I dont know last or not my action on preflop
No way to detect count of callers before Hero Action ?
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: How detect the number of callers before hero action

Postby kraada » Fri Jun 08, 2012 4:38 pm

Unfortunately there is no way to do that in PT3 at this time due to the database structure.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: How detect the number of callers before hero action

Postby TROM » Fri Jun 08, 2012 5:23 pm

kraada wrote:Unfortunately there is no way to do that in PT3 at this time due to the database structure.

in PT4 it can be possible ?
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: How detect the number of callers before hero action

Postby kraada » Fri Jun 08, 2012 6:47 pm

Yes, it's a bit complicated but I think it can be done there. The string cash_hand_summary.str_actors_p gives you the list of all people who call or raise, so you can compare that to the cash_hand_summary.str_aggressors_p string which gives you the list of all aggressive actions and find the people who just called.
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 6 guests