Thanks for this. Does everyone else see many duplicate hands in their DB? Will this affect the stats?
Many thanks.
I have the same problem. It is importing the same hand for each player, which is expected. But the "cards" and the "line" is considering just one of the players in the hand. Its affecting the stats.
Looking through this thread, it doesn't appear so.
I'd like to thank everyone for their work on this, particularly tigerjack89, as his summary of how to create a global alias (post 58) has always worked flawlessly for me.
Has anyone been able to work out how to adjust that code to create an alias for say nits <20.5 vpip with a 75 hand or greater sample? I see there is something in notecaddy that does this, but I find doing anything in notecaddy slows down my HEM a bit.
I have the same issue. Anyone found a fix? (have >100k players in alias)
This is from the Pokertracker 4 thread about this but it is probably THE issue youre having here. Read below:
Quote:
Originally Posted by evLeisure
If someone is interested in making global alias in 6max, 9man, 180s etc.
We have to take down primary key's by using this:
Code:
ALTER TABLE tourney_hand_player_statistics DROP CONSTRAINT tourney_hand_player_statistics_primary_key
ALTER TABLE tourney_hand_player_combinations DROP CONSTRAINT tourney_hand_player_combinations_primary_key
ALTER TABLE tourney_results DROP CONSTRAINT tourney_results_primary_key
Then everything like in OP post.
Ps.
Code:
UPDATE tourney_hand_summary SET id_winner = 19580 WHERE id_winner != 19580 AND id_winner != 1 AND id_winner != 0 AND id_winner != -1;
UPDATE tourney_hand_player_statistics SET id_player = 19580 WHERE id_player != 19580 AND id_player != 1 AND id_player != 0 AND id_player != -1;
UPDATE tourney_hand_player_combinations SET id_player = 19580 WHERE id_player != 19580 AND id_player != 1 AND id_player != 0 AND id_player != -1;
UPDATE tourney_summary SET id_winner = 19580 WHERE id_winner != 19580 AND id_winner != 1 AND id_winner != 0 AND id_winner != -1;
UPDATE tourney_results SET id_player = 19580 WHERE id_player_real != 19580 AND id_player_real != 1 AND id_player_real != 0 AND id_player_real != -1;
UPDATE player SET id_player_alias = 19580 WHERE id_player != 19580 AND id_player != 1 AND id_player != 0 AND id_player != -1;
I bold small improvement in your code. We don't want to assign as an alias last player also, because we're choosing him as a active player who has assigned other players as an aliases.
