teddyFBI's hand history program

[illunious]

This is a very simple PT utility, teddiFBI requested it here (http://forumserver.twoplustwo.com/showflat.php?Cat=&Number=2558966&page=0&view=colla psed&sb=5&o=&fpart=1\). I had a similar idea before, and it seemed useful enough to spend a few hours coding it. It lists the most recent hands (hand number / what you had / pot / bet). Double click one and it is added to a list for future export/review. There's a text box for manual hand number entry and a label for how much you won lost in X amount of time.

The target user for this utility is someone that is trying to improve their game through reviewing a sessions tough/questionable hands (both by themselves and on 2+2). You run this while your playing, it displays the last X minutes worth of hands, and you toggle the hands that you want to review later.

Main window:
http://img.photobucket.com/albums/v384/gllen/main.gif

The export button puts all the hand histories in the list in a file and opens that file. You can read through them, use them on bisons coverter, or if you play on a party skin you can copy/paste the entire file into the teamfu (http://teamfu.freeshell.org/) replayer.

I'm hosting the zip on "YouSendIt.com" if someone can mirror a more reliable link, please do. The zip includes the vb 6.0 source code, the exe and an .ini file.

Instructions: Extract the .exe and .ini files to a directory and edit the .ini file:

Line 1: Your PT user ID (you need to search the PT .mdb in the players table for this, usually some low number)
Line 2: # minutes (previously referred to as X) you want to display (change this to something like 15, 355 is what I was using for testing)
Line 3: location of your current ptrack.mdb file (ptrack.mdb is the original)
Line 4: location of your hhdb.mdb file
Line 5: location of your notepad or text editor
http://img.photobucket.com/albums/v384/gllen/hhini.gif

download (http://s51.yousendit.com/d.aspx?id=13H5B8HPB0N6H3E0P8SIM80PTT)

[pokergrader]

mirrored at http://www.pokergrader.com/software/hh.zip

[illunious]

That was quick, thanks!

[pokergrader]

I stalk the software forum.

[Dangergirl]

Great work illunious , I can't wait to try this out tomorrow /images/graemlins/smile.gif

[teddyFBI]

Wow - ask and ye shall receive.
Great work and thanks on behalf of everyone.
Looking fwd to trying this out tonight.

Will it work / i.e. does it pick up all hands played if I'm playing multiple skins at once?

[illunious]

[ QUOTE ]
Will it work / i.e. does it pick up all hands played if I'm playing multiple skins at once?

[/ QUOTE ]

It should, as long as you have aliases set up in PT.

[Supern]

How do I find my PT user ID?
I don't have access.

You can't find the ID within PT?

[astarck]

Does this only work for cash games? I followed the instructions and cannot get this to work for SNGs.

[teddyFBI]

[ QUOTE ]
How do I find my PT user ID?
I don't have access.

You can't find the ID within PT?

[/ QUOTE ]

no, you need to have access (as I also found out)

[Luv2DriveTT]

Has a version been released yet that works with PostgreSQL hoasted databases?

TT /images/graemlins/club.gif

[Nomad84]

[ QUOTE ]
Line 1: Your PT user ID (you need to search the PT .mdb in the players table for this, usually some low number)

[/ QUOTE ]

Do you only need to use the primary username if you have aliases set up? Or do you need to change the ID when you change skins? I suppose I could figure this out myself if I'd just try it, but I haven't DLed it yet.

[astarck]

[ QUOTE ]
Does this only work for cash games? I followed the instructions and cannot get this to work for SNGs.

[/ QUOTE ]

Bump

[_dave_]

For Supern, and others who would like to use this but don't have MS Access, the following JavaScript snippet should help (It works for me, YMMV).

Copy and paste the following code into a notepad, and save as player_id.js, in the same folder as your ptrack.mdb files.

You must change the parts in <font color="blue">blue</font> to match the correct mdb file and screen name.

<font class="small">Code:</font><hr /><pre>var db = new ActiveXObject("ADODB.Recordset");
var cstring = "Driver={Microsoft Access Driver (*.mdb)};DBQ=<font color="blue">ptrack</font>.mdb";
var sql = "SELECT screen_name,player_id FROM players WHERE screen_name='<font color="blue">_dave_</font>';";
db.Open(sql, cstring, 1, 3);
WScript.Echo(db(0) + " - player_id: " + db(1));
db.Close(); </pre><hr />

Double click the player_id.js file you saved, and you will get a message box showing the player_id you searched for.

Hope this helps,

Dave.