How to get agressor's position from P3T?

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 to get agressor's position from P3T?

Postby EvgenyLo » Sun Oct 18, 2009 2:17 pm

Hello everybody!

PT3 Hud can show, how many % player called in certain position, let's say BB. But it doesn't show from which position BB is attacked.
Would be great if I can split calls, made by player into different variables, depending on the agressor's position :)

I mean, overall call of the shove on BB for player is 20%, but when he faces all-in from SB this percentage is 30%, from UTG is 5%. But I can't understand, how can I get it from PT3 :(

Thanks a lot!
EvgenyLo
 
Posts: 1
Joined: Wed Aug 19, 2009 2:52 pm

Re: How to get agressor's position from P3T?

Postby WhiteRider » Sun Oct 18, 2009 2:27 pm

There is a field in the database which holds the last raiser's position: holdem_hand_player_detail.val_p_raise_aggressor_pos

See this thread for details on the values that this field can have, based on who is the aggressor, as the field will have different values if the active player is the last one to raise.
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 0 guests