Suddenly the script has stopped displaying the window - I think it's running, but, by some miracle, haven't lost enough in a single session to have it go off and also been lazy so my hand goal hasn't been reached lately, so not really sure.

Anyone know what to try to get the window back? I like to have the % of hands completed showing so I know whereabouts in my (non-lazy) session I am.

Only thing I can think of related to AHK is that I've done lately, is that I have copied and run the script in this post a few times (it's a script to open a password protected pdf-file without having to manually enter the password every time), but can't see that that should have an effect on other ahk-scripts?

is anyone getting aliases to work in HEM? i'm using a unique alias but the script still doesnt work

Does anyone know what I have to do to get rid of this error? Ty

Hey, Dave? I'm having a lot of trouble getting this script to work. I'm running vista pro, HEM beta 1.09 33, postgresql 8.0. Please, help.

20090921031819 - An Error Occured:

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


Output:
psql:20090921031819_stop_loss_HEM.ahk_6239_in.txt: 3: ERROR: syntax error at or near "62" at character 107
psql:20090921031819_stop_loss_HEM.ahk_6239_in.txt: 3: LINE 2: 62 AND phckc.pokerhand_id > 2272848;
psql:20090921031819_stop_loss_HEM.ahk_6239_in.txt: 3: ^




20090921031819 - An Error Occured:

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


Output:
psql:20090921031819_stop_loss_HEM.ahk_3034_in.txt: 3: ERROR: syntax error at or near "62" at character 119
psql:20090921031819_stop_loss_HEM.ahk_3034_in.txt: 3: LINE 2: 62 AND phckc.pokerhand_id > 2272848;
psql:20090921031819_stop_loss_HEM.ahk_3034_in.txt: 3: ^




20090921031833 - An Error Occured:

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


Output:
psql:20090921031833_stop_loss_HEM.ahk_8022_in.txt: 3: ERROR: syntax error at or near "62" at character 107
psql:20090921031833_stop_loss_HEM.ahk_8022_in.txt: 3: LINE 2: 62 AND phckc.pokerhand_id > 2272848;
psql:20090921031833_stop_loss_HEM.ahk_8022_in.txt: 3: ^




20090921031834 - An Error Occured:

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


Output:
psql:20090921031833_stop_loss_HEM.ahk_2686_in.txt: 3: ERROR: syntax error at or near "62" at character 119
psql:20090921031833_stop_loss_HEM.ahk_2686_in.txt: 3: LINE 2: 62 AND phckc.pokerhand_id > 2272848;
psql:20090921031833_stop_loss_HEM.ahk_2686_in.txt: 3: ^

Do this and ask again if you can't get it to work.

Thanks weegs, that was exactly the problem. So I manually put the player ID and now I have 2 scripts with 1 ID each. However, when I ran them without playing, after a while, 1 script displays my all time hands and money count. The other one stays 0. What gives? No more error logs created this time.

Ok, I just got rid of the problem by creating a unique alias in HEM. One last question, is it possible to make the script a trailing stop loss instead of absolute stop loss? (i.e stop loss trails the session peak by fixed amount) That way we could prevent a winning session from turning into a losing session.

I created unique alias but the script is doing nothing just sitting there without updating anything. Does any1 have the same problem?

As mentioned in #151, the script suddenly stopped working for me. It's not even bringing up the window anymore. I've given up and hope this functionality will be added in HM at some point.

You can vote for it at http://holdemmanager.uservoice.com/p...lost?ref=title

Mine is bringing up the window, it's just not doing anything. Maybe connectivity issue with HEM, I donno.

me too.

hi,guys,i have problems when install it,anyone who can help me,i use holdemmanager,thanks!
1. i download stop_loss_HEM.zip here
http://www.overcards.com/wiki/moin/S...p_loss_HEM.zip

2.when i run stop_loss_HEM.ahk,display:
stop loss sound effect is not found ...
paql.exe not found,please copy ....

first ,i don't know how to fix the sound effect file ,i edit this script ,the default is:
stop_loss_sound_effect := A_ProgramFiles . "\Full Tilt Poker\Waves\Buzzer-2.wav"
stop_win_sound_effect := A_ProgramFiles . "\PartyGaming\PartyPoker\Firework3.wav"
hand_goal_sound_effect := A_WinDir . "\Media\tada.wav"

if my sound file store here" C:\Program Files\a.wav " how should i fix it?

i copy/paste psql.exe from h:\program files\postgresql\8.3\bin to stoploss file folder,when i run stoploss,display can't find ssleay32.dll

stop_loss_sound_effect := "C:\Program Files\a.wav" (and similar for the others) should work.

thank you,MinusEV! it is works!
the other problem is still there.

Did you just copy psql.exe? As _dave_s post says:

you probably also need the supporting .dlls. I just copied all of them to the script folder to be on the safe side, but if you prefer you can copy just the .dll the program is asking for, try again, copy the next it asks for, try it again, copy the next... etc until it runs. The files are pretty small though, so I'd advice just copy the lot of them over.

thank you,MinusEV! this problems is solved!
but it still doesn't work.
i use holdem manger,so i should download stop_loss_HEM,right?
how do i know my database_name?i am not sure if it is "HoldemManager".
this is stop_loss_HEM.ahk_Error_Log.txt :
20091028142337 - An Error Occured:

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


Output:
psql:20091028142337_stop_loss_HEM.ahk_9031_in.txt: 3: ERROR: syntax error at or near "47046"
LINE 2: 47046 AND phckc.pokerhand_id > 2077638;

Do this and ask again if you still have problems.

thank you,weegs.there are still erros.
i use holdem manager, i copy these :
sql := "SELECT player_id from players WHERE playername = '" . sn . "' ORDER BY player_id LIMIT 1;"
pt_id := psql(sql)



; ------------- SETTINGS -----------------------------

sn := "tuliplife"
database_name := "HoldemManager" ; <-- change db name if needed
host_address := "127.0.0.1" ; <-- change db host if needed

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

stop_loss := 2
stop_win := 2
hand_goal := 200
show_money := 1
show_vpp := 0

stop_loss_sound_effect := "E:\music\junhao.wav"
stop_win_sound_effect := "E:\music\junhao.wav"
hand_goal_sound_effect := "E:\music\junhao.wav"

; ------------- END SETTINGS ------------------------

the errors:

20091028204420 - An Error Occured:

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


Output:
psql:20091028204420_stop_loss_HEM.ahk_9249_in.txt: 3: ERROR: syntax error at or near "47046"
LINE 2: 47046 AND phckc.pokerhand_id > 2145053;

You have to insert your id manually. Don't stop reading at #111. Read all the posts, especially #114.

May I suggest visiting, registering and voting for this?

http://holdemmanager.uservoice.com/p...lost?ref=title

It's voting to get stop/loss-functionality added to HEM rather than having to use a separate program/script for it.

MinusEV,i add it.

i am reading,seems a little diffcult to me
thank you,Weegs!

I'm sorry for being so vague earlier, I don't use this script anymore so I had already forgotten what the precise fix was. But I guess all you really had to do is change these lines to or

thank you,weegs.
errors still,i have fix Edit pg_hba.conf,neally try everthing


1. should i add ; before sql := ?
i tried id 47046 53779 10360,but...

sn := "tuliplife"
database_name := "HoldemManager" ; <-- change db name if needed
host_address := "127.0.0.1" ; <-- change db host if needed

sql := "SELECT player_id from players WHERE playername = '" . sn . "';"
pt_id := 10360


2.i play two poker rooms ,and scream names are the same,in my hm alias manager,i add alias the same name as my screem name ,and then add two screen names. is that right?

20091030165709 - An Error Occured:

Input:
\f '\t'
SELECT COUNT(phckc.pokerhand_id) AS hc FROM playerhandscashkeycolumns phckc WHERE phckc.player_id = 53779
10360
47046 AND phckc.pokerhand_id > 2216203;
\q


Output:
psql:20091030165709_stop_loss_HEM.ahk_1781_in.txt: 4: ERROR: syntax error at or near "10360"
LINE 2: 10360

Now I'm lost, it still finds multiple Ids. Could you copy paste the whole script here so I can take a look? Wrap CODE tags around it so it doesn't fill the whole page. We'll get this thing to work