Stat just for titan poker

[el_hombre]

I want to create a custom stat (a simple stat which calculates affiliate bonus points from the rake), not for the hud, just for the PT3 tables. but i just want to see this stat for one special pokerroom. I think the best way (make this table row disapear for all other pokerrooms) should not be possible, but is it posible to set the stat value to "0" for all other pokerrrooms?
I think i have to use an "if", but what is the variable i have to use to make these if descision?

[kraada]

If you want it to show on the HUD you need to make the stat in the Holdem Cash Player Statistics section.

You'd want to create a new column:

cnt_titan_rake: sum(if[holdem_hand_summary.id_site = '400', holdem_hand_summary.amt_rake, 0])

This will then create a column that's cnt_titan which is the sum of all titan only rake. You can then use that column in your custom stat to manipulate it as need be. In the format expression for the stat you can then have: if( cnt_titan_rake > 0, <<display whatever you want to display here>>, '')

And that will display whatever you put in the <<>> section (though you don't actually want the <<>> characters; something like cnt_titan_rake * .4 or something would be more along the lines of what you want to put there).

[Dilas]

I tried to create this stat in the Holdem Cash Sessions section.

This leads to funny results. Session stats show mor then 100000 hands instead ogf only 100 etc

So my question is: How can I select the rake of a pokerroom (maybe Titan) for the sessions section.

Under "winnings" I would like to see several columns with the rake I paid at Titan, Pokerstars, etc...

[kraada]

In that case use holdem_table_session_summary.id_site instead of holdem_hand_summary.id_site. The other stuff should be the same.

[Dilas]

Same crazy result - all the other stats (on winnings) show funny results after the new stat was added to the list

[kraada]

I just looked back at your column; try also using holdem_table_session_summary.amt_rake instead of holdem_hand_summary.amt_rake.

The former is the rake for a whole session the latter is the rake for an individual hand; using individual hand columns in the sessions section is going to cause problems.

(Sorry I should've caught that the first time :oops: )

[Dilas]

Thx now it works fine

[el_hombre]

sorry for reactivating such an old post, but is there a way to use more specific site ids? id_site=400 ist for all ipoker skins: titan, cdpoker, mansionpoker etc. is there a way to just choose titan or mansion? like id_site=401 or something like that?
After looking into the database scheme i do not think so.

[WhiteRider]

No, there isn't.