Number of Full tilt poker points earned in 1 session.

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

Number of Full tilt poker points earned in 1 session.

Postby Bombaharris » Tue Aug 12, 2008 12:07 pm

I want to display on table number of points earned in current session.
FTP points = "We offer you one point for every dollar in rake that is dropped, including fractional points"
I did this.

[ img ]

Section - Cash Player Statistic & Holdem Cash Session
[ img ]

The stat won't display on table (it works on Sessions Tab) and i got a strange feeling that im doing it all worng :0

THx in front for solution.
Bombaharris
 
Posts: 3
Joined: Sat Feb 02, 2008 2:13 am

Re: Number of Full tilt poker points earned in 1 session.

Postby WhiteRider » Tue Aug 12, 2008 2:04 pm

Have you filled in the 'format' tab too?
Also, after you add a new stat you will need to restart the HUD.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Number of Full tilt poker points earned in 1 session.

Postby Bombaharris » Tue Aug 12, 2008 4:17 pm

Yeah i filled format tab too and I've been restarting HUD many times trying diffrent formats (money_format,format,number_format).
Bombaharris
 
Posts: 3
Joined: Sat Feb 02, 2008 2:13 am

Re: Number of Full tilt poker points earned in 1 session.

Postby WhiteRider » Tue Aug 12, 2008 4:27 pm

Ah, sorry - I've re-read now..
The way you've built the stat will work in the sessions section because you're using a single database field from the sessions section.
But in the 'holdem cash player statistics' section, looking up a stat from from one session doesn't make sense.
This will go through each hand for the player and build up the stat, so you will need to do something like:
sum( holdem_hand_summary.amt_rake )

(I don't know what fraction of the rake you want, or whether you want the whole lot..)
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Number of Full tilt poker points earned in 1 session.

Postby Bombaharris » Wed Aug 13, 2008 6:23 am

Thank u for solution WhiteRider.
Fractional points means that if the rake is 0.15 $ u recive 0.15 point.

[ img ]

How to do this step by step:

Configure Stats -> Section Cash Player Statistic -> go to tab columns create new amt_ftppoints

Expression: sum( holdem_hand_summary.amt_rake )

Description: Amount of FTP points per session.

Save

Go to tab Statistics:

Create ne stat (FTPpts)

Description: Amount of FTPpts
Value Expression: amt_ftppoints

In tab format set:

format expression: format_number(amt_ftppoints ,1,1 , false )

Just in case if somone gonna need it :)
Bombaharris
 
Posts: 3
Joined: Sat Feb 02, 2008 2:13 am

Re: Number of Full tilt poker points earned in 1 session.

Postby WhiteRider » Wed Aug 13, 2008 6:41 am

Great, glad you got it working!
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Number of Full tilt poker points earned in 1 session.

Postby ibron » Thu Sep 11, 2008 1:00 pm

Great, thanks!
ibron
 
Posts: 34
Joined: Thu Sep 11, 2008 11:42 am


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

Who is online

Users browsing this forum: No registered users and 10 guests