holdem_hand_summary question

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

holdem_hand_summary question

Postby avlflush » Wed Feb 09, 2011 8:52 am

The holdem_hand_summary table has an id_winner column that contains the id of the winning player for that hand. What happens if the pot is split?

Thanks
avlflush
 
Posts: 63
Joined: Sat Dec 25, 2010 10:23 am

Re: holdem_hand_summary question

Postby kraada » Wed Feb 09, 2011 9:47 am

Then id_winner = 0, and if you look at the player table, player 0 is named [Split Pot].
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: holdem_hand_summary question

Postby avlflush » Thu Feb 10, 2011 8:41 pm

Shortly after I posted my message I was involved in a split pot hand. I tracked down the 0 that you mentioned. However, there were three of us involved in the pot and only 2 of us split the pot. I then found that the holdem_hand_player_statistics table identified the 2 winners.

However, there was something that I found to be interesting. As I mentioned, there were 3 players that went to the showdown. The hole cards of the 2 players that split the pot were in the PS hand history file. However, the hole cards of the third player were not shown in the PS hand history file.

So, I'm in good shape for now and thanks for your prompt reply.
avlflush
 
Posts: 63
Joined: Sat Dec 25, 2010 10:23 am


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

Who is online

Users browsing this forum: No registered users and 0 guests