Help - Using PT4 to analyse population tendencies - Page 4 - Heads Up SNG and Spin and Gos -- Two Plus Two Poker Forums

Hi guys!

Anyone knows how to show a HUD for an Alias?

I´m doing reports to study population tendencies but is not too clear, so I would like to see the coffeHud with the population tendencies values

+1

Was just about to post the exact same thing

Quote

06-27-2013 , 09:06 AM

#77

evLeisure

stranger

Join Date: Jun 2013 Posts: 5

Hey guys

Have you solved how to do global alias for 6max's?

Quote

06-28-2013 , 01:06 PM

#78

evLeisure

stranger

Join Date: Jun 2013 Posts: 5

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!

Quote

08-08-2013 , 09:10 AM

#79

Matsuri

journeyman

Join Date: Aug 2012 Posts: 236

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?

Quote

11-06-2013 , 09:07 AM

#80

M.K_LOTD

newbie

Join Date: Nov 2011 Posts: 25

Hi all! Looking for advice.
So, I want to make this pop model, I do everything exactly as it is described in this thread (and coffeeyay vid) and it simply doesn't work. I get only my own stats from exported hands. Could this be because I use mac? It's somewhat old thread perhaps there is some changes due to PT4 or postgress updates that I should be aware of? Throughout all steps I get no errors or anything. Any ideas? Thanks a lot

Quote

11-20-2013 , 12:54 PM

#81

laurents

journeyman

Join Date: Jun 2013 Posts: 270

Quote:

Originally Posted by CJSaunders

I tried all of this then also kept having this error when running the SQL query:

Code:

ERROR: duplicate key value violates unique constraint "tourney_hand_player_statistics_primary_key"

Which did not make sense because I definitely did NOT have any observed hands, no other hands than heads up hands, or more than one hero name. Then I found out why.

The id_player corresponding to your screenname is not necessary 1.

In my case it was 2, I am guessing that when PT4 imports the very first HH in your new database, your opponent might get id_player number 1, therefore you get number 2. Talk about a coinflip

So while you're looking at the "players" table to find out who has the last id_player, find out if you have number 1 or 2 (or else maybe). Then in the SQL query, replace all statements with "!=1" by "!=your_own_id_player". For example, if it happens to be 2:

You literally saved my day, thank-you!!

Quote

01-19-2014 , 07:31 AM

#82

BigFredy007

journeyman

Join Date: Feb 2007 Posts: 240

Can someone give mi a hint how to change the sql sequence to create a alias for a HU database with 2 heros?

I thought i can add on additional command to each row but it doesn't work.

Code:

UPDATE tourney_hand_summary SET id_winner = 3091 WHERE id_winner != 2 AND id_winner != 754 AND id_winner != 0 AND id_winner != -1;
UPDATE tourney_hand_player_statistics SET id_player = 3091 WHERE id_player != 2 AND id_player != 754 AND id_player != 0 AND id_player != -1;
UPDATE tourney_hand_player_combinations SET id_player = 3091 WHERE id_player != 2 AND id_player != 754 AND id_player != 0 AND id_player != -1;
UPDATE tourney_summary SET id_winner = 3091 WHERE id_winner != 2 AND id_winner != 754 AND id_winner != 0 AND id_winner != -1;
UPDATE tourney_results SET id_player = 3091 WHERE id_player_real != 2 AND id_player_real != 754 AND id_player_real != 0 AND id_player_real != -1;
UPDATE player SET id_player_alias = 3091 WHERE id_player != 2 AND id_player != 754 AND id_player != 0 AND id_player != -1;

Code:

ERROR: duplicate key value violates unique constraint "tourney_hand_player_combinations_primary_key"
SQL Status:23505
Detail:Key (id_player, id_hand)=(3091, 40181) already exists.

Quote

02-11-2014 , 04:11 AM

#83

tudoncete

stranger

Join Date: Sep 2011 Posts: 10

Hi,

I am trying to create a global alias. I created a new database, exported my current level hyper-turbo HU hands, copy the script in pgadmin III, changed the values of the last player and my own (2), run the script without errors, open PT4, set the new database active, but when I try to see the stats and use the holdem hand range visualizer, I am the only player available in the list and only my frequencies are shown.

What did I do wrong?

How Can I fix it?

P.S: I can't find custom stats such as min-raising 17-30bb, etc.

Thank You Very Much.

Quote

06-02-2014 , 02:36 PM

#84

xkcd

grinder

Join Date: Oct 2011 Posts: 448

Quote:

Originally Posted by tudoncete

To fix the first issue do this:

Quote:

Finally, before you run the SQL query in your new database, launch PT4 and go to view stats -> results, and from the drop down "player" menu, select the name of the player who was last in your "player" SQL table. Then only after that go run the SQL query. If I don't do this before running the query, I cannot select any other player than myself afterwards in PT4, which sort of defeats the whole point. Might have to do with the merging of all player ids, and PT4 getting confused.

For the custom stats I have the same issue, and I have CoffeeHud 2.0.2 and PT4.11.6. Anyone has same problem?

Quote

06-03-2014 , 04:16 AM

#85

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

In the CoffeeHUD premium version (anything 2.0+) the stats do not show for the hand range visualizer. I think it is a bug in the PT4 premium system, and I do not know a way of correcting it.

Quote

06-04-2014 , 08:45 AM

#86

xkcd

grinder

Join Date: Oct 2011 Posts: 448

Quote:

Originally Posted by _dave_

In the CoffeeHUD premium version (anything 2.0+) the stats do not show for the hand range visualizer. I think it is a bug in the PT4 premium system, and I do not know a way of correcting it.

Any chance, coffeeyay can contact the PT4 team to address this issue in a further release? Or them pointing us some hacking solution for this?

Would be very useful!

Quote

09-12-2014 , 04:19 AM

#87

PHISH4CHIPS

newbie

Join Date: Jul 2013 Posts: 30

Hey Guys,

Im having similar trouble to others in the fact that I cant import the CoffeHud stats into the Holdem hand range visualizer.
What default stats would I need to filter for to get Open Shove stats at various stack depths and called Open Shove stats at various stack depths?
Plus can we drill down the default stats into different stack effective stack levels??
Hope this makes sense!!!

Quote

03-28-2015 , 11:24 AM

#88

DonNew

newbie

Join Date: Sep 2009 Posts: 22

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!

I tried to this but i just get an error message:

syntax error at or near "ALTER"
LINE 8: ALTER TABLE tourney_hand_player_combinations DROP CONSTRAINT...
^

********** Error **********

ERROR: syntax error at or near "ALTER"
SQL state: 42601
Character: 919

??

Quote

03-28-2015 , 11:51 AM

#89

DonNew

newbie

Join Date: Sep 2009 Posts: 22

Quote:

Originally Posted by DonNew

Ahh just did it manually like described above,, now how do you exclude urself?

Quote

09-26-2015 , 06:12 AM

#90

Okerchamp

veteran

Join Date: Aug 2009 Posts: 2,104

Quote

12-10-2015 , 06:58 PM

#91

yami

newbie

Join Date: Apr 2015 Posts: 34

Any idea how to do that for n Hero's ?
Like in HM2 version ??

Quote

01-12-2016 , 01:18 AM

#92

XXIV

centurion

Join Date: Dec 2014 Posts: 162

It doesn't seem to work anymore for the new PT4 version.

Quote

01-12-2016 , 01:16 PM

#93

crazyriver

old hand

Join Date: Jun 2010 Posts: 1,732

Still works for me (v4.14.8). Where do you encounter a problem?

Quote

01-12-2016 , 01:34 PM

#94

XXIV

centurion

Join Date: Dec 2014 Posts: 162

After updating the database, the script runs fine, but when I try searching for the last player on the list I'm the only player on the list.

Quote

01-12-2016 , 03:40 PM

#95

crazyriver

old hand

Join Date: Jun 2010 Posts: 1,732

I'm not sure I know what you mean. Why would you want to search for any player if the purpose of the filter/alias (a few posts below the first one) is to show tendencies of the whole population, not a single player?

Quote

01-12-2016 , 05:17 PM

#96

XXIV

centurion

Join Date: Dec 2014 Posts: 162

To use the range visualizer I need to select any of the villains from the population (Since all of them are under the same alias) but I don't see any players to select other than me.

Quote

01-12-2016 , 05:34 PM

#97

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

Open pgadmin, click the little + icons all the way down until you can right click on the table "player" and choose "View data -> View all rows".

look at the column "id_player_alias". they should all be some number, except your screen name and the couple of system ones [split pot] etc - which should be 0 (zero). note this number (you used it earlier in the SQLs)

now find that row by scrolling down the list. When you do, edit it's id_player_alias to zero, and note the screen name of this player. Press enter to save, close the view and now this player should be searchable.

why: it's not "any of the villains in the population" - it's the specific one you chose to alias everyone else to. The SQLs should leave him out but don't - but it doesn't matter if he's already in the search list because it'll work anyway so long as you can pick him. setting his alias to himself prevents being able to find it in the new player search thing on PT4 though.

Quote

01-19-2016 , 08:44 AM

#98

tobakudan

grinder

Join Date: Feb 2014 Posts: 476

Tutorial video explaining how to do this:
https://www.youtube.com/watch?v=WJjLPy5C5pE

Quote

01-20-2016 , 12:18 AM

#99

XXIV

centurion

Join Date: Dec 2014 Posts: 162

It is working now, thanks dave.

Quote

05-11-2016 , 06:52 PM

#100

bettinglife

journeyman

Join Date: Nov 2011 Posts: 246

Is it working for non heads up games?

I just realize all this is oriented towards heads up games.

Is there a code to create a global alias for mtts for example?

Would be very appreciated, thank you.

Quote

Page 4 of 5

First

1 2 3 4 5

Last

Post Reply Subscribe

...

Page 4 of 5

First

1 2 3 4 5

Last