Hand history not from holdem_hand_histories

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

Hand history not from holdem_hand_histories

Postby yaqb_pl » Mon Feb 21, 2011 12:52 pm

Hi,

is it possible to get all infromation about an hand history from tables other then holdem_hand_histories?
they are holdem_hand_player_detail and holdem_hand_player_statistics but i think not everything is there.

in example amounts of bets. there is total amount per street, first amount on street, last amount on street. but what if player made more then 3 bets?

in other words, is it possible to replay hand based only on tables other then holdem_hand_histories?

if not, then i have to prepare conversion to all sites hand history formats.
yaqb_pl
 
Posts: 20
Joined: Thu Dec 18, 2008 9:29 am

Re: Hand history not from holdem_hand_histories

Postby kraada » Mon Feb 21, 2011 2:10 pm

You'd need some pretty complex joining I think in order to get everything you need. Technically it's probably possible (you'd also want to look at holdem_hand_summary) I think, but for our replayer we use the text in the hand history itself.
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 0 guests