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 10-18-2016, 03:19 PM   #126
Baraky
newbie
 
Join Date: May 2011
Posts: 40
Re: Script to analyze population tendency on HEM

No matter what I do, it always crashes. It has only 2,3k players and still crashes.

How do I fix it?
Baraky is offline   Reply With Quote
Old 10-18-2016, 04:21 PM   #127
Baraky
newbie
 
Join Date: May 2011
Posts: 40
Re: Script to analyze population tendency on HEM

Quote:
Originally Posted by Baraky View Post
No matter what I do, it always crashes. It has only 2,3k players and still crashes.

How do I fix it?
I got it. It's the method in page 2 or 3 of this thread, for HM2. Thanks.
Baraky is offline   Reply With Quote
Old 12-08-2016, 03:07 AM   #128
african princee
veteran
 
Join Date: Aug 2010
Location: byron bay
Posts: 2,091
Re: Script to analyze population tendency on HEM

What am I looking for in pga? Theres nothing in there that is related to my hem2 database?
african princee is offline   Reply With Quote
Old 02-14-2017, 12:34 PM   #129
Brokenstars
Carpal \'Tunnel
 
Brokenstars's Avatar
 
Join Date: Jul 2012
Location: Check out my PGC!!!
Posts: 11,788
Re: Script to analyze population tendency on HEM

Anyone got time to help me with this through skype?
Brokenstars is offline   Reply With Quote
Old 02-17-2017, 07:03 PM   #130
poker-hero
journeyman
 
Join Date: Jan 2010
Posts: 381
Re: Script to analyze population tendency on HEM

Hi,

I followed the instructions and it seems to work fine with HEM2 (10150 players).

Then I realized a few players are not included in the global alias.
I did it again and again, and the same Villains remain out of the global alias.
A friend of mine did a few SQL queries and told me that my Global alias included only 9041 players so more than 1.000 are missing.

Is tere any explanation about this?
How can I include all the field?
poker-hero is offline   Reply With Quote
Old 06-16-2017, 02:39 PM   #131
NORMAN86
stranger
 
Join Date: Aug 2013
Posts: 4
Re: Script to analyze population tendency on HEM

hi, somebody can tell me how to create an alias with less than 5000 players in hm2 please? i mean what enter in the query 1 in postgres and what enter in the 2nd? thanks
NORMAN86 is offline   Reply With Quote
Old 08-03-2017, 08:25 PM   #132
SickCall
enthusiast
 
Join Date: Dec 2010
Posts: 66
Re: Script to analyze population tendency on HEM

I think this just broke my hem2.....
SickCall is offline   Reply With Quote
Old 08-25-2017, 12:00 PM   #133
thegibson
grinder
 
thegibson's Avatar
 
Join Date: Sep 2013
Posts: 531
Re: Script to analyze population tendency on HEM

So I did exactly what you said for hm2. Every went off without a hitch. No errors, nothing. When I open hem2 though and go to player up top, I have no new aliases or player names. Is it possible I missed something? Also will I be able to view the hud stats for the global alias? I have a ton of custom stats in notecaddy that would help tremendously to get pop. Tend. Thanks for any help!
thegibson is offline   Reply With Quote
Old 06-22-2018, 07:04 PM   #134
Adgey
newbie
 
Join Date: Mar 2017
Posts: 37
Re: Script to analyze population tendency on HEM

Can this be done for HM3 somehow?
Adgey is offline   Reply With Quote
Old 06-23-2018, 11:30 AM   #135
_dave_
_Pooh_Bah_
 
Join Date: Feb 2005
Location: UK (or what remains of it)
Posts: 12,778
Re: Script to analyze population tendency on HEM

I'm not too familiar with it, but I believe HM3 doesn't use a real database so in that case no.
_dave_ is online now   Reply With Quote
Old 07-10-2018, 07:52 AM   #136
alberthofmann
enthusiast
 
Join Date: Nov 2016
Posts: 88
Re: Script to analyze population tendency on HEM

Hey, i read the whole thread, but couldnt find a working answer.

Did all the coding in pgadmin, no errors. Global Alias with alle players is created in HM2, i can see it, but when i click on it so select it, HM just crashes.

Tried everything but i cannot make it work. Its a huge database.

Anyone here made it work for big samplesize of players?

I have a ssd, i5, 16gb ram etc... so not bad, but still it crashes everytime
alberthofmann is offline   Reply With Quote
Old 07-10-2018, 10:24 AM   #137
fozzy71
Carpal \'Tunnel
 
fozzy71's Avatar
 
Join Date: Mar 2007
Location: 8 Mile + 2.5
Posts: 37,168
Re: Script to analyze population tendency on HEM

Can you change to other players or manually created aliases? If you have NoteCaddy Premium and create an alias with color ranges can you select that alias in the reports? Have you tried creating a smaller test database and doing the pgadmin alias steps again to see if it works in a smaller database?

If you want to send a download link to your \HM2Logs files to me via PM here or a support ticket on the hm.com site I can take a look and see if there is anything obvious. Chances are something you did in pgadmin corrupted the alias or the database.
fozzy71 is offline   Reply With Quote
Old 08-14-2018, 08:57 PM   #138
mls2323
grinder
 
Join Date: Jun 2009
Posts: 426
Re: Script to analyze population tendency on HEM

Quote:
Originally Posted by Wisher View Post
Yes. In HEM, unlike in PT4, there is a column in the players table which notes the number of tourney and number of cash game hands the opponent has played.
So you can just extend the WHERE clause of the query to have "AND tourney_hands > 30".
Note: Above is sample extension, not sure if I recall the column name exactly.

tl;dl; Yes. It is possible.
Where exactly do we enter this extra data?

I'm using HM2 so this is what it would look normally...

INSERT INTO aliases
SELECT 12345, p1.player_id
FROM players p1
WHERE p1.player_id NOT IN
(
SELECT a1.player_id
FROM aliases a1
WHERE a1.aliasplayer_id = 12345
-- to exclude players yet inserted
)
AND p1.player_id NOT IN
(
SELECT a2.player_id
FROM players p2 JOIN aliases a2 ON p2.player_id = a2.aliasplayer_id
WHERE p2.pokersite_id = -1 and p2.playername = 'Hero'
-- to exclude hero nicknames from the insert
)
AND p1.pokersite_id <> -1
-- to exclude other aliases
;

Which part would we add the hands requirement? I have 216k player DB and need to cut this down significantly so that my HM2 doesnt crash.

Thanks!
mls2323 is offline   Reply With Quote
Old 08-28-2018, 04:55 PM   #139
Ssslipnssslide
grinder
 
Join Date: Jan 2010
Posts: 523
Re: Script to analyze population tendency on HEM

Will pay $ for someone to walk me through the process of backing up postgreSQL and create a population alias.
Please have successfully done this before.

PM me.
Ssslipnssslide is offline   Reply With Quote
Old 10-02-2018, 05:39 AM   #140
rowhousepd
grinder
 
rowhousepd's Avatar
 
Join Date: Jun 2009
Location: Philadelphia, PA
Posts: 602
Re: Script to analyze population tendency on HEM

I think I got this to work for HM2 after reading the instructions above. Hallelujah!

Anyhow, this may be a dumb question, but how exactly are you reviewing this data in HM2 to evaluate general population read-less tendencies? I'm mean specifically in the software, are you looking at the Opponents > Player Analysis screen? Are you running reports for specific scenarios and looking at the hole card grid?
rowhousepd is offline   Reply With Quote
Old 11-11-2018, 12:31 PM   #141
meale
Carpal \'Tunnel
 
meale's Avatar
 
Join Date: May 2013
Location: Pattaya, Thailand
Posts: 7,999
Re: Script to analyze population tendency on HEM

Just tried this and now every time I go to click on Select Player in HEM it just crashes :/ any ideas?
meale is offline   Reply With Quote
Old Yesterday, 07:06 AM   #142
Chewey89
newbie
 
Chewey89's Avatar
 
Join Date: May 2011
Location: Kildare Ireland
Posts: 35
Re: Script to analyze population tendency on HEM

Has anyone compared there results from their global alias with the opponents>summaries tab on hm2. They show very different results and not sure what to make of this? Cbet turn/river with the global alias is close to 50% for example. While on opponents > summaries that number is much lower closer to around 30%. Same for river cbet, and fold to turn and river cbets.
Chewey89 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 07:15 PM.


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