id_x_hand_strength

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: id_x_hand_strength

Postby kraada » Sun Aug 29, 2010 11:10 am

Mary,

The more detail you can give us the better. If it's not too much trouble, could you could create a different ticket for each issue?, It would help us keep track of the issues much more easily in our internal bug tracker.
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: id_x_hand_strength

Postby devolveNZ » Wed Dec 29, 2010 10:50 pm

Within Full House:

0 - Full house on board (valid for river only)
1 - Board trips, pocket pair, low pair
2 - Board trips, pocket pair, middle pair
3 - Board trips, pocket pair, overpari
4 - Board trips, top pair
5 - Board trips, bottom pair
6 - Board paired, two pair, one under (T8 on a T59T8 board)
7 - Board paired, two pair, one over (KJ on a J59JK board)
8 - Set under pair (33 on a 3JJT9 board)
9 - Set over pair (AA on an A3347 board)


How would you look into double paired boards for example AJ on JJTT6 board or AJ on KKJJ6 board?
Thanks Greg
devolveNZ
 
Posts: 31
Joined: Mon Sep 08, 2008 9:27 pm

Re: id_x_hand_strength

Postby kraada » Thu Dec 30, 2010 9:38 am

It appears that AJ on the JJTT6 board is id_r_hand_strength = 6 and AJ on the KKJJ6 board is id_r_hand_strength = 7 (though this seems backwards to me, and I'll mention it to the development team).
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: id_x_hand_strength

Postby pasita » Thu May 08, 2014 7:10 am

Since this seems to be the latest documentation on the subject I could find (how about finally releasing the PT4 schema, how ever ugly and unfinished it may be; we'll help you find the bugs, you know):
Within One Pair:

0 - Board Paired or pocket pair under the board

1 - Bottom Pair


When I use 1, and filter for val_r_hole_cards_used = 1, I get a hit on AJ on board 86QKJ. Is this a) intentional b) to be properly documented c) fixed at some point?
FWIW, PT4 has the quick filter "lower pair", for non-pocket pairs. Having 3rd pair and fifth pair might seem a similar bluff catcher in NLHE specifically, but in other games it can make a big difference...
pasita
 
Posts: 605
Joined: Tue May 06, 2008 4:05 pm

Re: id_x_hand_strength

Postby kraada » Thu May 08, 2014 7:27 am

Cards used means used to make the hand in question, and it does not include kickers. So you used one card to make the pair, and the other card was on the board. Kicker strength is stored elsewhere (in id_x_kicker_strength).
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: id_x_hand_strength

Postby pasita » Thu May 08, 2014 7:53 am

I don't mean kickers... J is 3rd pair on the river, not bottom.
pasita
 
Posts: 605
Joined: Tue May 06, 2008 4:05 pm

Re: id_x_hand_strength

Postby pasita » Thu May 08, 2014 8:36 am

Ok I see how my post was unclear.
The sql generated for "lower pair", using 1 card from hand is
cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.val_r_hole_cards_used = 1 AND cash_hand_player_combinations.id_r_hand_strength <= 1

So the filter works, I guess. But the documentation ITT says "1" is for bottom pair.
pasita
 
Posts: 605
Joined: Tue May 06, 2008 4:05 pm

Re: id_x_hand_strength

Postby kraada » Thu May 08, 2014 10:13 am

I've been told new documentation should be coming for PT4 before too long.
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: id_x_hand_strength

Postby pasita » Thu May 08, 2014 11:07 am

Ok, thanks. In the meanwhile: is there a way to filter for actual bottom pair from PT database? Direct SQL, advanced filters or anything?
pasita
 
Posts: 605
Joined: Tue May 06, 2008 4:05 pm

Re: id_x_hand_strength

Postby kraada » Thu May 08, 2014 12:41 pm

You could manually test your hole card pair against the board if you really wanted, I suppose. It'd be some work though.
kraada
Moderator
 
Posts: 54435
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 5 guests

cron
highfalutin