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.
GL!
Good work guys much props!
EVleisure, indeed the changes above do allow for the analysis of non HU games.
The last problem I am having is, How do I remove my own stats from being linked as an alias for the last player in my database as OP mentioned.
PS. There is also a code error for the ALTER TABLE tourney_hand_player_combinations_primary_key line. Beats me what it is so I went into the tree at the left pane and opened the tables manually and dropped the constraints that way without executing the query.
So to summise, my real player name data is aliased to the last player in my player name table and therefore skewing the population data by including my actions and results. I tried deleting the alias within PT4 itself but then I cannot get any heat map info for the rest of the population.
any ideas?