custom stats

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

custom stats

Postby makodim » Mon Apr 19, 2010 9:19 pm

hi, in filters PT3 have options TEXTURE-Turn - "Turn is an overcard", how i can make this options in custom stats ?
makodim
 
Posts: 136
Joined: Tue Jun 03, 2008 11:46 am

Re: custom stats

Postby WhiteRider » Tue Apr 20, 2010 3:30 am

Please see my reply to this thread.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: custom stats

Postby makodim » Tue Apr 20, 2010 12:20 pm

in this post, me can see strength our hands, me need know how me make custom stats when turn be Overcards ( example : flop 29T , turn J or Q or K or A, strength My cards are not important)
)
makodim
 
Posts: 136
Joined: Tue Jun 03, 2008 11:46 am

Re: custom stats

Postby WhiteRider » Tue Apr 20, 2010 12:24 pm

The board cards use the same (single card) values. The database fields for board cards are holdem_hand_summary.card_1 to .card_5.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: custom stats

Postby makodim » Mon May 03, 2010 2:53 am

Can give an example, this stats ? (true = turn overcard)

example : flop 29T , turn J or Q or K or A, strength My cards are not important
makodim
 
Posts: 136
Joined: Tue Jun 03, 2008 11:46 am

Re: custom stats

Postby kraada » Mon May 03, 2010 9:03 am

The easiest way to define a turn overcard would be:

holdem_hand_summary.card_1 % 13 > 0 and holdem_hand_summary.card_2 % 13 > 0 and holdem_hand_summary.card_3 % 13 > 0 and
((holdem_hand_summary.card_4 % 13 = 0) or (holdem_hand_summary.card_4 % 13 > holdem_hand_summary.card_1 % 13 and
holdem_hand_summary.card_4 % 13 > holdem_hand_summary.card_2 % 13 and holdem_hand_summary.card_4 % 13 > holdem_hand_summary.card_3 % 13))

First we check that there was no ace on the flop (card_x % 13 = 0 for aces, 1 for deuces, 2 for treys and so on), then if there was no ace on the flop we know the turn is an overcard if either the turn is an ace, or card_4 % 13 is larger than all three of the other cards.
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 2 guests