Rebuys in PS

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

Rebuys in PS

Postby Big Pink Monkey » Tue Oct 28, 2008 3:58 pm

I'm having to reimport everything because I'm an idiot that got a virus and had to rebuild my computer. I'd like to get a report that tells me how many rebuys I had in a given tournament. Is there a column that will tell me my stack size on a given hand and perhaps how much I lost on a given hand? I thinking I could check my stack size on a hand, how much I lost and stack size on the following hand. Is this possible?
Big Pink Monkey
 
Posts: 2
Joined: Sun May 18, 2008 2:22 am

Re: Rebuys in PS

Postby WhiteRider » Tue Oct 28, 2008 5:01 pm

You will be able to do most of this, but not quite all I don't think.
You can tell your starting stack and how much you lost in a hand, but you can't do anything about the "next" hand.
Are you registered? You will need to use Custom Stats for this.

I think the best way would be to make a Custom Stat to show when you lost your whole stack - then you could add this stat to the 'Tournament Hands' report and sort it in the order you played the hands; so that when you see this 'bust out' stat is true but isn't the last hand of your tournament you'll know you rebought.

These DB fields should be more than enough:
tourney_holdem_hand_player_detail.amt_before
tourney_holdem_hand_player_detail.amt_bet_ttl
tourney_holdem_hand_player_statistics.flg_won_hand
tourney_holdem_hand_player_statistics.amt_won

Have a look at the Custom Statistics and Reports FAQ.
If you get stuck, please ask.
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 2 guests