Question about custom 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: Question about custom stat

Postby WhiteRider » Tue Mar 16, 2010 4:25 am

preparac wrote:Or could I use also

AND NOT
(tourney_holdem_hand_player_statistics.enum_allin = 'P' AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action LIKE 'R')

to exclude situations where a players first action is raising allin?

Please note that:
lookup_actions_p.action LIKE 'R'
..is equivalent to
lookup_actions_p.action = 'R'
If you want to incude times when the player made other actions after the initial raise you need to use this:
lookup_actions_p.action LIKE 'R%'
Please see the "Constructing Column Expressions" section of the Tutorial - Custom Reports and Statistics for more information on using LIKE and string comparisons.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Question about custom stat

Postby preparac » Tue Mar 16, 2010 2:55 pm

so to get this clear:

open_opp AND rfi AND (tourney_holdem_hand_player_detail.amt_before != tourney_holdem_hand_player_detail.amt_p_raise_made)

equals

open_opp AND rfi AND NOT (tourney_holdem_hand_player_statistics.enum_allin = 'P' AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action LIKE 'R')

equals

open_opp AND rfi AND NOT (tourney_holdem_hand_player_statistics.enum_allin = 'P' AND tourney_holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action = 'R')

?
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Re: Question about custom stat

Postby kraada » Tue Mar 16, 2010 3:19 pm

Everything other than the open opportunities is in agreement yes, but when you have open_opp and NOT(open_opp and X) no matter what X is, this statement will always be false. If you pull your flg_p_open_opp from the second and third statements inside the NOT() they will all be logically equivalent.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Question about custom stat

Postby jaxx » Sat Mar 20, 2010 1:56 pm

kraada wrote:If you set a HUD Profile as Default for the heads up tournament it should be selected as the default HUD for that kind of tournament in the future.


This does not really work for me (Ipoker).
I choose my profile as default when I play HU STT, but later when I play full ring MTT - it is used again. I change it on the MTT and then it is changed also in the HU STT. So it seems to me that I cannot make it use different profiles for full ring MTT and HU STT?
jaxx
 
Posts: 87
Joined: Thu Oct 09, 2008 3:37 pm

Re: Question about custom stat

Postby WhiteRider » Sat Mar 20, 2010 4:24 pm

All tournament tables of the same size and site will use the same profile.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Question about custom stat

Postby jaxx » Sun Mar 21, 2010 7:12 am

WhiteRider wrote:All tournament tables of the same size and site will use the same profile.


same size? what does this mean?
10 handed MTT table and HU STT table are from the same size?
jaxx
 
Posts: 87
Joined: Thu Oct 09, 2008 3:37 pm

Re: Question about custom stat

Postby kraada » Sun Mar 21, 2010 9:27 am

Anything that shows up in the same Table Type on the General tab of your tournaments section will show the same HUD. We plan on making this more configurable in the future (so any MTT will show the same HUD as any other MTT, same for any SnG (2 Table)).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Question about custom stat

Postby WhiteRider » Sun Mar 21, 2010 1:52 pm

Hmm - I thought it was based on the maximum number of players at the table, so a 10 seat table could use a different profile to a heads up table - that's how it works for cash tables IIRC. My PT3 is busy doing something at the moment so I can't check it just now.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Question about custom stat

Postby jaxx » Thu Mar 25, 2010 5:50 pm

kraada wrote:Anything that shows up in the same Table Type on the General tab of your tournaments section will show the same HUD. We plan on making this more configurable in the future (so any MTT will show the same HUD as any other MTT, same for any SnG (2 Table)).


I am not talking about 2 table STT. I am talking about HU STT (with 2 players). It is very different from multi table MTT
Infact MTT or STT does not matter. the problem is that one is 2 people max, the other is 10 people max and both are treated as the same type?
jaxx
 
Posts: 87
Joined: Thu Oct 09, 2008 3:37 pm

Re: Question about custom stat

Postby kraada » Thu Mar 25, 2010 5:59 pm

At the moment yes, but we are planning on overhauling the tournament interface at which point I believe this will change.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 3 guests

cron
highfalutin