If anyone is willing to write an AHK stop loss script to work in conjunction w/ Holdem Manager I will xfer $100 on stars/ftp...

How can no one be interested in this? OK, 200...

You reminded me.

I will have this done for you tomorrow, if RVG checks his PMs - probably even if he does not (1000 hands of trial remaining)

Dave I will love you! I have some serious tilt issues, lol...

How can you make this? Can you make it for PT3?

Yes, I will update it to support both HEM and PT3 (as well as the current PT2 support).

lol,

I know if I got close to the stop loss I would just exit the AHK

Just like my GreaseMonkey Invisibilty Cloak I use, to keep me from browsing 2+2 til after a certain time of day... I just right-click disable it.

this would be sick.

I asked for this same thing 3 months ago and people were like LOL DEGENAMENTS, GA MEETINGS ETC. Funny how opinion has changed.

He did, so here we are

Download this, extract to a folder.
http://www.overcards.com/wiki/moin.c...s-HEM_TEST.zip

You will need to copy/paste psql.exe (and maybe supportting DLL files) from C:\Program Files\PostgreSQL\8.2\bin - to the script's folder, so it can access databases.

You will need to edit the script with your screenname (sn) instead of mine (case sensitive I think). You may need to change your database name / host, if they are not default.

You may well want to adjust the loss / win / hand numbers also.

And you may need / want to set alternative sound effects.

Once you verify it is working properly, it is wise to turn off "show_money" - otherwise this can easy become a tilt magnifier!

All these settings are at the start of the script.

Please report success / failure, and I'll get to adding some more features

Thanks Dave!
I've been wanting to try out this script.

Couldn't get it working. Changed the database name, the screen name, and copied psql.exe and all dll files to the folder. The window that shows hands etc doesn't appear.
It keep writing files with this in my stoploss folder.

Oops, I forgot to mention an important step, only required if you've never set up postgresql to allow "no password" access yet... this is required for any database-accessing scripts at this time, and is not a big security problem unless you don't trust your own computer.

The script is getting denied, since it does not know your postgresql password.


You must set the postgresql authentication mode for localhost (127.0.0.1) to "trust".

Do this:
Click: "Start -> Programs -> PostgreSQL 8.x -> Configuration files -> Edit pg_hba.conf"

It will open a notepad with some text.

Scroll all the way to the bottom, you should see a line reading this:
Edit the "md5" to "trust", no quotes. It should now read:

Save the pg_hba.conf file, and close notepad.

Click: "Start -> Programs -> PostgreSQL 8.x -> Reload configuration"


Now try script again, it should now work with any luck

OK it works now. I tested it out on the penny tables and in the window it said "money: $2.00" (brag). Does the script just round to whole dollars?

It might do, I think I've made a typo - it is supposed to round to cents

HEM confused me storing only cents in it's database AFAIK - ehrn I first tested I won $75 stealing the blinds at nl50, or so it claimed

I can get the box to show up but it stays blank and doesnt seem to be reading the tables. Any ideas how to fix?

In my error log its saying my database doesnt exist. I copied psgl.exe to the folder but I wasnt sure what else to copy.

If it doesn't give you "missing DLL pop-ups, that is all you need copy - this part is fine

Check the name of your database in Holdem Manager's "database Management" window... Edit the script accordingly. This is case-sensitive.

Ok now I feel like an idiot for not reading the OP more closely to see that this was for holdem manager. I'm trying to use it with poker tracker.

Not updated for PT3 yet, the old version is good for PT2 however:

http://overcards.com/wiki/moin.cgi/StopLoss

thanks Dave. I set that up but still nothing is showing up I cant figure out what I'm doing wrong.

I was poking around the overcards site and noticed that StopLoss had been modified to work with Holdem Manager. Any chance of getting it to work for PT3?

Dave, did you ever recieve the $200?

bump this is v useful.

Hello,

i have managed to get the script running as far as to show me the window. but it is not corresponding with the database.

the error logs are as follows:

20080626233048 - An Error Occured:

Input:
\f '\t'
SELECT COUNT(g.game_id) AS hc FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = 8
39001 AND g.game_id > 717999;
\q


Output:
psql:20080626233048_stop_loss-v0.2.ahk_4094_in.txt:3: ERROR: syntax error at or near "39001"
LINE 2: 39001 AND g.game_id > 717999;
^




20080626233049 - An Error Occured:

Input:
\f '\t'
SELECT SUM(gp.total_won - gp.total_bet) AS net FROM game g, game_players gp WHERE g.game_id = gp.game_id AND gp.player_id = 8
39001 AND g.game_id > 717999;
\q


Output:
psql:20080626233048_stop_loss-v0.2.ahk_8526_in.txt:3: ERROR: syntax error at or near "39001"
LINE 2: 39001 AND g.game_id > 717999;
^

do you have any idea what i can do to set it up properly?

I run on Vista.

Regards
Andreas