Page 1 of 1

New Column in Tournaments Tab

PostPosted: Sat Jan 31, 2009 1:02 pm
by R3mbrandt
Hi all!

I'm new to the custom stats feature of PT3 and wondering, if it's possible to insert a new column in the "Tournaments Tab" right after "$/Hour" which displays the number of played and won hands.
Just "showing the way" to do this would be great!

Thx for your help!

R3mbrandt

Re: New Column in Tournaments Tab

PostPosted: Sat Jan 31, 2009 1:05 pm
by kraada
Click the spanner/wrench icon at the top right of that report and double click a stat from the left column to add it to the report. Likewise double clicking it on the right will remove it from the report.

Re: New Column in Tournaments Tab

PostPosted: Sat Jan 31, 2009 1:09 pm
by R3mbrandt
Okay, that is not the problem. The problem is, the stats I'm interesting in, are not available - so I've to create my own. And here begin my problems - all trials end up, with a "never ending population" of this report. :-(

Re: New Column in Tournaments Tab

PostPosted: Sat Jan 31, 2009 1:37 pm
by kraada
What stat are you trying to build?

Re: New Column in Tournaments Tab

PostPosted: Sat Jan 31, 2009 1:48 pm
by R3mbrandt
Just the number of hands played in the whole tournament and the number of hands won by hero.
I found this field in another table (holdem_table_session_summary.cnt_hands) but i'm not clever enough to bild a stat from this, which i can use as a new column in this report. ;-)

Re: New Column in Tournaments Tab

PostPosted: Sat Jan 31, 2009 2:06 pm
by kraada
That database field is for cash games. All tourney fields start with tourney_

The stats you can put in that area are somewhat limited, as you can't access specific hand data, and as far as I can tell the number of hands in a tourney aren't stored in the tourney_holdem_results table, which means this likely isn't actually possible at this time.

Re: New Column in Tournaments Tab

PostPosted: Sat Jan 31, 2009 2:24 pm
by R3mbrandt
Thank you for clarifying this! Maybe these stats will be available in the future...? :-)

Re: New Column in Tournaments Tab

PostPosted: Sat Jan 31, 2009 2:43 pm
by kraada
There are plans to expand the stat creation system to allow arbitrary SQL queries. I'm not sure how soon that's going to happen but once it does, this information will be available.

highfalutin