chips left when the bubble breaks

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

chips left when the bubble breaks

Postby mtagliaf » Sun Aug 16, 2009 2:40 pm

I am trying to come up with a way to write a query that shows me how many chips I have in a 9 man SNG immediately after the bubble breaks - that is, the first hand that there are three players at the table.

Is there a way to do this?
mtagliaf
 
Posts: 45
Joined: Tue Feb 12, 2008 10:30 pm

Re: chips left when the bubble breaks

Postby WhiteRider » Sun Aug 16, 2009 3:00 pm

Each hand is stored in the database indepedently, so this isn't easy.
Someone was asking about something like this before and I think that Kradda did some work on it, although I'm not sure that it was possible. I'm sure he'll get back to you tomorrow but I think he's off for the rest of today.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: chips left when the bubble breaks

Postby mtagliaf » Sun Aug 16, 2009 9:28 pm

I can do this outside of PT3 if I can get an export from a custom report with the following info:

Tourney #
Date/Time (so I can sort in order)
Chips

Then I can filter where Players at table=3, and export.

the problem is that tourney# doesn't seem to be available in a "Holdem Tournament Hand" report. Can you join a report of type "Holdem Tournament Hand" to get columns in "Holdem Tournament Tournament"?
mtagliaf
 
Posts: 45
Joined: Tue Feb 12, 2008 10:30 pm

Re: chips left when the bubble breaks

Postby WhiteRider » Mon Aug 17, 2009 4:24 am

You could use the database field "tourney_holdem_hand_summary.id_tourney" to find the tournament ID for a hand.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests