party poker rake

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

party poker rake

Postby manuausruben » Mon Dec 07, 2009 1:10 pm

i try to generate my first custom statistic............


party poker changed the rake system to dealt rake. 1$ = 2 party points

so i thought it must be possible to create a stat which would stat the points i get at every single table

i tried something like that....

(Sum [holdem_hand_summary.amt rake]) * 2



can someone pls give me a hint?


thx
manuausruben
 
Posts: 20
Joined: Wed Apr 23, 2008 2:41 pm

Re: party poker rake

Postby kraada » Mon Dec 07, 2009 1:59 pm

The easiest way is, in the Holdem Cash Player Statistics section to create a column like this:

cnt_rake_ttl: sum(holdem_hand_player_statistics.amt_rake)

Then when you create the statistic on the Statistics tab, just make it equal to cnt_rake_ttl * 2.

Please see this tutorial for a more detailed walkthrough on statistic creation.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: party poker rake

Postby manuausruben » Mon Dec 07, 2009 3:10 pm

kraada wrote:The easiest way is, in the Holdem Cash Player Statistics section to create a column like this:

cnt_rake_ttl: sum(holdem_hand_player_statistics.amt_rake)

Then when you create the statistic on the Statistics tab, just make it equal to cnt_rake_ttl * 2.

Please see this tutorial for a more detailed walkthrough on statistic creation.


i made it:

name

cnt_rake_ttl

expression

sum(holdem_hand_player_statistics.amt_rake)

descrtiption

party points


but when i want to save it it says "no valid SQL"

what have i done wrong?
manuausruben
 
Posts: 20
Joined: Wed Apr 23, 2008 2:41 pm

Re: party poker rake

Postby kraada » Mon Dec 07, 2009 4:20 pm

My apologies that should have been:
sum(holdem_hand_summary.amt_rake)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: party poker rake

Postby grobin » Tue Dec 08, 2009 7:46 am

New PartyPoints system:
PartyPoints are awarded as follows:

Two points for every $1 you contribute in rake
For example: blinds are $1/2 (no-limit), four players are dealt cards and the pot is $40. The total rake taken is $2 which means each player receives one point.

Note: an individual player's rake contribution is calculated by dividing the total rake collected in that hand by the number of players who were dealt cards. Find out about the PartyPoker.com rake structure here.

So I think it should be "sum(holdem_hand_summary.amt_mgr)"

But there is a problem with Jackpot tables. PT3 considers bad beat jackpot rake like a normal rake. So the calculations are wrong. It would be great if you guys could fix this somehow. PT2 counted jackpot rake separately, but PT3 just combines everything. Monthly Gross Rake is now calculated higher than it should be.
grobin
 
Posts: 12
Joined: Sun Mar 09, 2008 7:58 am

Re: party poker rake

Postby kraada » Tue Dec 08, 2009 10:00 am

With that definition you are right, you do want amt_mgr.

With regards to BBJ rake being kept separate, could you create a support ticket for this issue? That way we will keep track of it and you will get automated notification when there is a fix.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: party poker rake

Postby manuausruben » Tue Dec 08, 2009 11:38 am

until there it works fine, thx a lot

i created a ticket......hope for an answer soon
manuausruben
 
Posts: 20
Joined: Wed Apr 23, 2008 2:41 pm

Re: party poker rake

Postby kraada » Tue Dec 08, 2009 11:57 am

You're welcome, and we'll get back to you in your ticket once we have more information for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 7 guests

cron
highfalutin