Is it Possible to Distinguish Merge Skins?

[sfifield]

The title says it all. I signed up for a merge skin for a bonus, but don't get rakeback on the second skin. I'd like to combine my stats for review (as an alias), but count rakeback only for hands on the skin where I get rakeback. I came up with a stat with the following value, but can't seem to be added to the graph:

if (id_site=2100 and id_player = 'SN on Skin W Rakeback', amt_weighted_contributed_rake * .35, 0)

The session stats function on the graph doesn't appear to show stats with a boolean operator in their value. Is there a way around this?

[WhiteRider]

Are your screennames different at the different skins?
It might be possible to build a custom stat to check for the real player name as part of the expression, but that's the only way I can think of doing it once your names are aliased together.

[sfifield]

Are your screennames different at the different skins?
It might be possible to build a custom stat to check for the real player name as part of the expression, but that's the only way I can think of doing it once your names are aliased together.

Yes. The screen names are different at different skins (since the skins share a player pool, Merge disallows the same screenname to be duplicated on a different skin).

However, this custom stat doesn't appear on the menu when I click configure after Session Stats on the graph. It doesn't appear when I simplify it to: "if(id_site=2100, amt_weighted_contributed_rake * .35, 0)"

However, it does appear if I change it to just "amt_weighted_contributed_rake * .35", so I think the if function is throwing this off somehow.

-Sean

[kraada]

Which section are you building this stat in?

[sfifield]

Which section are you building this stat in?

Player Stats (so that it can be used in the graph).

Unfortunately, I've figured now that the id_site variable returns the site ID associated with the player (i.e., the hands of an FT account with a merge account "aliased" into it all have a id_site=300 rather than 2100 for the merge hands and 300 for the old FT hands). I suspect that the id_player will simply return the "main" id_player (whether or not the hands were played by an alias or not).

[sfifield]

Confirmed. The str_player_name and id_player values become identical for hands played under different screen names (and on other sites) when merged together using aliases. Any way around this?

[WhiteRider]

Yes - there is an id_player_real field in holdem_hand_player_statistics for instance, which holds the original player name.

[sfifield]

Thanks. I was able to create a new column, amt_rakeback_merge, for Merge rakeback:

Code: Select all

sum(if[holdem_hand_summary.id_site=2100 and holdem_hand_player_statistics.id_player_real = 387595, 0.35, 0] * if[holdem_hand_player_detail.amt_bet_ttl > 0, (holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot) * holdem_hand_summary.amt_rake, 0])

The new stat for Amount Won w/Rakeback was "amt_won + amt_rakeback_merge" and it shows up in reports and graphs correctly. (When I built the stat from existing columns, it would show up in reports, but I couldn't add it to the graph).

While I'm at it, I'd like to create amt_rakeback_ft for my old FT hands. Since they changed their rakeback scheme, I've come up with the following:

sum(if[holdem_hand_summary.id_site=300, 0.27, 0] * if[holdem_hand_player_statistics.date_played > ????, if[holdem_hand_player_detail.amt_bet_ttl > 0, (holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot) * holdem_hand_summary.amt_rake, 0], holdem_hand_summary.amt_mgr])

However, I can't figure out what the appropriate value (and format) is for October 1, 2010, 12:00:01 am EST.

[WhiteRider]

You can use:
>= 'October 01 2010'::timestamp

i.e.
sum(if[holdem_hand_summary.id_site=300, 0.27, 0] * if[holdem_hand_player_statistics.date_played >= 'October 01 2010'::timestamp, if[holdem_hand_player_detail.amt_bet_ttl > 0, (holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot) * holdem_hand_summary.amt_rake, 0], holdem_hand_summary.amt_mgr])

[sfifield]

Thanks.