STOP LOSS AHK REQUEST (Reward) - Page 3 - Poker Software -- Two Plus Two Poker Forums

posgres databases it does not matter where it is on your hard disk - it is all done over IP (127.0.0.1:5432)

For PTO, you'll have to enter your database name (likely PTOPGSQL1 or similar) - and if you are not running postgres 8.2 on port 5432, edit that in the script text (search for port and/or 5432).

port 5433

Quote

07-11-2008 , 05:38 AM

#52

08-15am

newbie

Join Date: Feb 2007 Posts: 34

Quote:

Originally Posted by _dave_

have you got aliases set up? try using the primary screenname.

Hi dave,

I tried every alias that i have setup but it didnt work out. do you have any idea how i can try to set it up for working properly?

thanks in advance!

Andreas

Quote

07-12-2008 , 03:28 PM

#53

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,199

Dave - is there any way to adjust the coordinates where the GUI appears when you launch it?? With Stars Planner and Stars Assistant I could set it in the INI file. Pretty minor, but it would be nice if it appeared in the same spot each time for my grinding layout.

Quote

07-29-2008 , 12:08 AM

#54

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,199

Dave - is it possible to edit/control where the GUI displays when it appears?? I would like it to appear in the lower right of monitor 1 every time, like my stars planner GUI, but it always appears in the center of the monitor. I browsed thru the script quickly, but didn't see any coordinate codes, around the GUI mentions.

Quote

07-29-2008 , 11:55 AM

#55

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

Somehow I missed when you posted that before

Easy

line 73 (I am looking at HEM_TEST version) or thereabouts should read this:

Code:

Gui, 2:Show, w130, %name_version%

Either way, find the first line with "GUI Show".

w is the width, in this case 130 pixels - you can add x/y coordinates here too. so (for lower right you are gonna have to figure your own numbers as it depends on resolution) an example of top/left would be:

Code:

Gui, 2:Show, w130 x0 y0, %name_version%

Quote

07-29-2008 , 12:14 PM

#56

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,199

Perfect thanks.

Quote

07-29-2008 , 06:06 PM

#57

MinusEV

Giftastic!

Join Date: Oct 2005 Posts: 12,233

_dave_ - could you help me with an issue I'm having with this?

When I start this, I don't get the window/gui - I just get a stop_loss_HEM.ahk icon (green with a white H) in the task bar but double clicking or right clicking this and trying the various menu-items brings up various stuff, but not the actual gui.

I did see the gui briefly pop up occationally when trying to get it to run correctly initially, but after having moved all the neccessary .dlls and whatnots to make it run without any error-message, the gui is now nowhere to be found.

Any help would be greatly appreciated!

Quote

07-29-2008 , 06:07 PM

#58

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

sounds very much like you've not set access control to "trust" in pg_hba.conf

Quote

07-29-2008 , 06:51 PM

#59

MinusEV

Giftastic!

Join Date: Oct 2005 Posts: 12,233

Yes, that fixed it, thanks!

I did look through the thread but for some reason didn't connect my problem to your previous post explaining this even though it was in reply to pretty much my exact problem.

Sorry and thanks =)

Quote

07-30-2008 , 01:34 AM

#60

allyasia

veteran

Join Date: Jun 2007 Posts: 2,025

damn
i so want this, must learn AHK

Quote

08-13-2008 , 04:57 AM

#61

HaiaN

adept

Join Date: Aug 2006 Posts: 908

/edit ah problem solved

Quote

08-22-2008 , 04:30 PM

#62

fjbourne

veteran

Join Date: Sep 2006 Posts: 2,386

What happend when you hit the stop loss?

Quote

08-22-2008 , 05:07 PM

#63

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,199

Quote:

Originally Posted by fjbourne

What happend when you hit the stop loss?

Audible Alert every hand you play over any of your trigger values, as well as this popup every hand. It's rather annoying. I typically close the script so it will shut up and I can keep playing.

Quote

08-23-2008 , 08:32 AM

#64

fjbourne

veteran

Join Date: Sep 2006 Posts: 2,386

Quote:

Originally Posted by fozzy71

Audible Alert every hand you play over any of your trigger values, as well as this popup every hand. It's rather annoying. I typically close the script so it will shut up and I can keep playing.

hahaha, thats awesome. def gunna have to get this

Quote

09-19-2008 , 02:16 PM

#65

skreemer7

grinder

Join Date: Feb 2006 Posts: 539

Trying to get this work with HM 1.06.03 and postgres 8.3 on vista. I followed all the directions and I get the little box to pop up, but it never updates. I have a errorlog file in the stoploss folder and the file just contains the bunch of the following:

Code:

20080919003427 - An Error Occured:

Input:
\f '\t'
SELECT COUNT(phckc.pokerhand_id) AS hc FROM playerhandscashkeycolumns phckc WHERE phckc.player_id = 71775
1348 AND phckc.pokerhand_id > 2973154;
\q


Output:
psql:20080919003425_stop_loss_HEM.ahk_2137_in.txt:3: ERROR:  syntax error at or near "1348"
LINE 2: 1348 AND phckc.pokerhand_id > 2973154;
        ^




20080919003430 - An Error Occured:

Input:
\f '\t'
SELECT ROUND(SUM((phckc.netamountwon)))/100 AS net FROM playerhandscashkeycolumns phckc WHERE phckc.player_id = 71775
1348 AND phckc.pokerhand_id > 2973154;
\q


Output:
psql:20080919003427_stop_loss_HEM.ahk_8395_in.txt:3: ERROR:  syntax error at or near "1348"
LINE 2: 1348 AND phckc.pokerhand_id > 2973154;
        ^




20080919003437 - An Error Occured:

Input:
\f '\t'
SELECT COUNT(phckc.pokerhand_id) AS hc FROM playerhandscashkeycolumns phckc WHERE phckc.player_id = 71775
1348 AND phckc.pokerhand_id > 2973154;
\q


Output:
psql:20080919003437_stop_loss_HEM.ahk_2098_in.txt:3: ERROR:  syntax error at or near "1348"
LINE 2: 1348 AND phckc.pokerhand_id > 2973154;
        ^




20080919003437 - An Error Occured:

Input:
\f '\t'
SELECT ROUND(SUM((phckc.netamountwon)))/100 AS net FROM playerhandscashkeycolumns phckc WHERE phckc.player_id = 71775
1348 AND phckc.pokerhand_id > 2973154;
\q


Output:
psql:20080919003437_stop_loss_HEM.ahk_5562_in.txt:3: ERROR:  syntax error at or near "1348"
LINE 2: 1348 AND phckc.pokerhand_id > 2973154;
        ^




20080919003918 - An Error Occured:

Input:
\f '\t'
SELECT COUNT(phckc.pokerhand_id) AS hc FROM playerhandscashkeycolumns phckc WHERE phckc.player_id = 71775
1348 AND phckc.pokerhand_id > 2973155;
\q


Output:
psql:20080919003918_stop_loss_HEM.ahk_4256_in.txt:3: ERROR:  syntax error at or near "1348"
LINE 2: 1348 AND phckc.pokerhand_id > 2973155;

I doublechecked the database, my screenname, and stuff, and I changed the entry in the file to allow access to the database as per post 1. Any ideas?

Quote

09-19-2008 , 02:21 PM

#66

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

looks like a problem with aliases - do you have aliases set up, and are you using the alias name rather than a site screen name?

Quote

09-19-2008 , 02:49 PM

#67

skreemer7

grinder

Join Date: Feb 2006 Posts: 539

Quote:

Originally Posted by _dave_

looks like a problem with aliases - do you have aliases set up, and are you using the alias name rather than a site screen name?

I do not have aliases set up. I do have skreemer7 twice in HM for stars and fulltilt- could that be a problem at all? Do I have to distinguish some how?

EDIT: I made an alias just to try and when I have the alias in the script, the error log isnt generated, but I still get 0s for everything- When I have my sn in there, the 0s become blank and thats about when the error log file starts building. Can I look into postgres or something to look at what it's referring to?

Last edited by skreemer7; 09-19-2008 at 03:09 PM.

Quote

09-19-2008 , 03:12 PM

#68

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

yeah, that'll be it - problem is it is finding two matching "player_id", where it expects only one to exist.

it may fix it is you alias the two screennames together, then give the name of the alias - I'm not entirely sure how Holdem Manager handles the aliasing...

alternatively, you could edit the script, just give it either 1348 or 71775, instead of having it trying to select player_id, dunno if you'd find this easy or have no idea how to do it tho

I'll figure out how to fix this (properly) later on tonight - it only needs a minor edit so it should work with multiple matching screennames anyhow.

Quote

09-19-2008 , 03:24 PM

#69

skreemer7

grinder

Join Date: Feb 2006 Posts: 539

Quote:

Originally Posted by _dave_

I'll figure out how to fix this (properly) later on tonight - it only needs a minor edit so it should work with multiple matching screennames anyhow.

I might know how to do that? Like define player_id to equal one of those numbers? Anyway, thanks a lot for your help on this. Whenever you have time if you figure it out, Id appreciate it.

Quote

09-19-2008 , 03:38 PM

#70

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

Quote:

Originally Posted by skreemer7

I might know how to do that? Like define player_id to equal one of those numbers?

OK, I just looked at the code - find this bit, st the start of the "track:" section...

Code:

sql := "SELECT player_id from players WHERE playername = '" . sn . "';"
pt_id := psql(sql)

These lines assemble the query to find a matching player_id, then stores the result in the variable pt_id.

if you change that to "pt_id := one_of_those_numbers" - it will work (for whichever site the number is for only).

I'll fix properly in a few hours

Quote

09-19-2008 , 06:10 PM

#71

skreemer7

grinder

Join Date: Feb 2006 Posts: 539

Quote:

Originally Posted by _dave_

OK, I just looked at the code - find this bit, st the start of the "track:" section...

Code:

sql := "SELECT player_id from players WHERE playername = '" . sn . "';"
pt_id := psql(sql)

Sure enough that worked perfectly. I was messing around with the line above it, changing the sn to the numbers and stuff... close. Thanks a lot!

Quote

09-20-2008 , 05:34 AM

#72

allyasia

veteran

Join Date: Jun 2007 Posts: 2,025

i am must be the stupid person alive
i still can't figure out how this work.
Dave, is there any way possible to make it like FTTO...more user friendly
i'm happy to pay for it.

Quote

09-20-2008 , 12:00 PM

#73

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

er, there isn't really any way to make it more user friendly, other than bundling all the psql exe and dll files with it - and that is a fairly large security risk imo. I suppose I could make it auto-search for them all if need be... I am presuming it is that bit that is giving you trouble?

post exactly what you do (from the download) and what happens.