Full Tilt Points Custom Stat

[MartL]

Im wanting a bit of help making the above stat to have in my database. I tried following the instructions in another thread about adapting a stat that is already in the repositary but it got me totally stumped. The points are as follows but i just cant work out how to implement them. Every player who is dealt in a hand recieves points. The points are $1 of rake is equal to 1 FTP, fractional points are also given so i need it to be to 2 decimal points. This is up to a maximum of 3 FTP`s. I would be very grateful for any help.

[kraada]

Note: This stat won't take into account things like happy hour; there's really no good way to do that perfectly at this point, especially since there are often unscheduled happy hours.

Note #2: This stat will be for cash games; you'll need to make a separate one for tournaments, but the steps will be nearly identical. See this tutorial if you need more assistance.

As you said, FTP points = amount of rake taken from hands you were dealt in. Click Configure --> Configure Statistics, click on Holdem Cash Player Statistics, click on the Columns tab and click New.

Give it a title (say amt_ftps), and the following expression:

sum(holdem_hand_summary.amt_rake)

Give it whatever description you want.

amt_rake is the amount of money paid in rake per hand. (You can't use the column amt_rake because it checks to see if you won the hand first, as amt_rake is the rake you yourself actually paid.)

Click on the Stats tab and click New. Give your new stat a name and description.

You want to use the value expression: amt_ftps

On the Format tab, give it a title (FTPs), a width (which you may want to be as high as 70 or 80 depending on what sort of report you want to use this in), and the format expression /%.2f

Add whatever categories you like, save, update your cache, and you should be all set. You can use this stat in the HUD or in any report using the HCPS section.

[MartL]

Thanks a lot for that, just one more thing ive managed to get it to work in the player statistics tab but i cant seem to get it to work in the Winnings tab which is the place that i really want it.Any ideas?

[kraada]

Unfortunately you can't get that stat working in that report, as that report needs stats in the Holdem Cash Sessions area. Stats and columns build in that section can't access individual hand details, just data from the whole session. As a result you can't sum up the individual rake paid by anybody (amt_rake in that section is the amount of rake you paid from winning hands), and you don't know how many players you have on average for the session so you can't use amt_mgr and build backwards.

[MartL]

No worries. I just wanted to see how many i was gaining on the winnings page per day but using the filters i can do that anyway. Ta for the help again.