Silly question - Identify hole cards

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

Silly question - Identify hole cards

Postby bschaef » Sat Jan 03, 2009 4:32 pm

New to PT3 but not to SQL,

I am trying to write some SQL against my PT3 database, but I can't seem to find a table to ID my hole cards, holdem_hand_player_detail has columns for holecard_1 and holecard_2 (smallint, 1-52) but I cant find how to I what card is what... anyone know?

All I see is lookup_hole_cards but that only lists them as two card hands: AKs, AKo etc. I need Ad, Ac etc. as they are in holecard_1 etc.

Thanks
bschaef
 
Posts: 6
Joined: Tue Sep 02, 2008 8:25 pm

Re: Silly question - Identify hole cards

Postby kraada » Sun Jan 04, 2009 10:48 am

See this post which explains the setup of those fields.
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