Two Plus Two Publishing LLC
Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Notices

Heads Up SNG and Spin and Gos Discussion of heads up Sit & Go and Spin and Go poker games. Sponsored by HUSNG.com, the leading heads up poker video site.

Reply
 
Thread Tools Display Modes
Old 05-04-2013, 02:34 AM   #76
push&rebuy
enthusiast
 
push&rebuy's Avatar
 
Join Date: Jul 2011
Posts: 57
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by Nidel View Post
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
push&rebuy is offline   Reply With Quote
Old 06-27-2013, 09:06 AM   #77
evLeisure
stranger
 
evLeisure's Avatar
 
Join Date: Jun 2013
Posts: 5
Re: Help - Using PT4 to analyse population tendencies

Hey guys

Have you solved how to do global alias for 6max's?
evLeisure is offline   Reply With Quote
Old 06-28-2013, 01:06 PM   #78
evLeisure
stranger
 
evLeisure's Avatar
 
Join Date: Jun 2013
Posts: 5
Re: Help - Using PT4 to analyse population tendencies

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!
evLeisure is offline   Reply With Quote
Old 08-08-2013, 09:10 AM   #79
Matsuri
journeyman
 
Join Date: Aug 2012
Location: East Asia
Posts: 236
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by evLeisure View Post
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?
Matsuri is offline   Reply With Quote
Old 11-06-2013, 09:07 AM   #80
M.K_LOTD
newbie
 
M.K_LOTD's Avatar
 
Join Date: Nov 2011
Posts: 25
Re: Help - Using PT4 to analyse population tendencies

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
M.K_LOTD is offline   Reply With Quote
Old 11-20-2013, 12:54 PM   #81
laurents
journeyman
 
Join Date: Jun 2013
Posts: 270
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by CJSaunders View Post
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!!
laurents is offline   Reply With Quote
Old 01-19-2014, 07:31 AM   #82
BigFredy007
journeyman
 
Join Date: Feb 2007
Location: Poker Heaven
Posts: 240
Re: Help - Using PT4 to analyse population tendencies

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.
BigFredy007 is offline   Reply With Quote
Old 02-11-2014, 04:11 AM   #83
tudoncete
stranger
 
Join Date: Sep 2011
Posts: 10
Re: Help - Using PT4 to analyse population tendencies

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.
tudoncete is offline   Reply With Quote
Old 06-02-2014, 02:36 PM   #84
xkcd
grinder
 
xkcd's Avatar
 
Join Date: Oct 2011
Posts: 448
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by tudoncete View Post
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.

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?
xkcd is offline   Reply With Quote
Old 06-03-2014, 04:16 AM   #85
_dave_
_Pooh_Bah_
 
Join Date: Feb 2005
Location: UK (or what remains of it)
Posts: 12,776
Re: Help - Using PT4 to analyse population tendencies

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.
_dave_ is offline   Reply With Quote
Old 06-04-2014, 08:45 AM   #86
xkcd
grinder
 
xkcd's Avatar
 
Join Date: Oct 2011
Posts: 448
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by _dave_ View Post
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!
xkcd is offline   Reply With Quote
Old 09-12-2014, 04:19 AM   #87
PHISH4CHIPS
newbie
 
Join Date: Jul 2013
Posts: 30
Re: Help - Using PT4 to analyse population tendencies

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!!!
PHISH4CHIPS is offline   Reply With Quote
Old 03-28-2015, 11:24 AM   #88
DonNew
newbie
 
Join Date: Sep 2009
Posts: 22
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by evLeisure View Post
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

??
DonNew is offline   Reply With Quote
Old 03-28-2015, 11:51 AM   #89
DonNew
newbie
 
Join Date: Sep 2009
Posts: 22
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by DonNew View Post
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

??
Ahh just did it manually like described above,, now how do you exclude urself?
DonNew is offline   Reply With Quote
Old 09-26-2015, 06:12 AM   #90
Okerchamp
veteran
 
Okerchamp's Avatar
 
Join Date: Aug 2009
Location: in the spins
Posts: 2,100
Re: Help - Using PT4 to analyse population tendencies

.
Okerchamp is offline   Reply With Quote
Old 12-10-2015, 06:58 PM   #91
yami
newbie
 
Join Date: Apr 2015
Posts: 34
Re: Help - Using PT4 to analyse population tendencies

Any idea how to do that for n Hero's ?
Like in HM2 version ??
yami is offline   Reply With Quote
Old 01-12-2016, 01:18 AM   #92
XXIV
centurion
 
XXIV's Avatar
 
Join Date: Dec 2014
Posts: 127
Re: Help - Using PT4 to analyse population tendencies

It doesn't seem to work anymore for the new PT4 version.
XXIV is offline   Reply With Quote
Old 01-12-2016, 01:16 PM   #93
crazyriver
old hand
 
crazyriver's Avatar
 
Join Date: Jun 2010
Posts: 1,726
Re: Help - Using PT4 to analyse population tendencies

Still works for me (v4.14.8). Where do you encounter a problem?
crazyriver is offline   Reply With Quote
Old 01-12-2016, 01:34 PM   #94
XXIV
centurion
 
XXIV's Avatar
 
Join Date: Dec 2014
Posts: 127
Re: Help - Using PT4 to analyse population tendencies

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.
XXIV is offline   Reply With Quote
Old 01-12-2016, 03:40 PM   #95
crazyriver
old hand
 
crazyriver's Avatar
 
Join Date: Jun 2010
Posts: 1,726
Re: Help - Using PT4 to analyse population tendencies

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?
crazyriver is offline   Reply With Quote
Old 01-12-2016, 05:17 PM   #96
XXIV
centurion
 
XXIV's Avatar
 
Join Date: Dec 2014
Posts: 127
Re: Help - Using PT4 to analyse population tendencies

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.
XXIV is offline   Reply With Quote
Old 01-12-2016, 05:34 PM   #97
_dave_
_Pooh_Bah_
 
Join Date: Feb 2005
Location: UK (or what remains of it)
Posts: 12,776
Re: Help - Using PT4 to analyse population tendencies

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.
_dave_ is offline   Reply With Quote
Old 01-19-2016, 08:44 AM   #98
tobakudan
grinder
 
tobakudan's Avatar
 
Join Date: Feb 2014
Location: Japan
Posts: 467
Re: Help - Using PT4 to analyse population tendencies

Tutorial video explaining how to do this:
https://www.youtube.com/watch?v=WJjLPy5C5pE
tobakudan is offline   Reply With Quote
Old 01-20-2016, 12:18 AM   #99
XXIV
centurion
 
XXIV's Avatar
 
Join Date: Dec 2014
Posts: 127
Re: Help - Using PT4 to analyse population tendencies

It is working now, thanks dave.
XXIV is offline   Reply With Quote
Old 05-11-2016, 06:52 PM   #100
bettinglife
journeyman
 
Join Date: Nov 2011
Location: Portugal
Posts: 243
Re: Help - Using PT4 to analyse population tendencies

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.
bettinglife is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 11:52 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright © 2008-2017, Two Plus Two Interactive
 
 
Poker Players - Streaming Live Online