see my edited post above. got it working....excellent work!

Toast,
I am having the same issue, getting zero hands, what am I missing or doing wrong?

Tried everything, here are the variables I am putting in the script:
db_host = localhost
db_name = PTDATA
db_user = postgres
db_pwd = password
screenname = BLACKGOBLIN
filter_date = 2007-01-01
filter_stake = none

It accessses the database and outputs zero hands. I am trying to get all hands I have played since the beginning of the year on this computer which is about 25k.

Looks like it just may be the capitalization. First I miscapped the database then I miscapped my username. Both of these are case sensitive.

Thanks for everything guys this is awesome.

Good to hear you got it working!

Ok, that worked but now there's a new message that says "Could not open input file: c:\path\to\luck.php"

I changed directories to the correct place so maybe my luck.php file is in the wrong format? I went back and saved it as "all files" instead of as a .txt file and now it says it's a .php file. But, that still doesn't make it work. Oh well, thanks for your help.

It doesn't work for some reason. I am getting the divide by zero:


//put your pokersite screen name here
$screen_name = "jj12";

//put the stake string here (just edit the dollar amounts to match your stake
$stake_string = "($2.00/$4.00)";

//this is the date to begin with in pokertracker, it'll go from this date to the present.
$since_date = "2007-01-01";

//connection info - put all your postgres pt db connection info into these variables.
$db_name = "PTPGSQL10";
$host = "localhost";
$user = "postgres";
$password = "asdf";

I have two PTPGSQL10 databases (both have 2/4 hands with my screen name). One is postgre 8 the other is postgre 8.2. The 8.2 one is on port 5433.


----------

I realized I had the incorrect string since I was playing FTP. Maybe you should edit the original instructions. Also I have two PTPGSQL10 databases can I make sure that the script is using the one on port 5434?

Did the program calculate the avg potsize, avg EV and so on, or do you have to do that by hand?
I only get the hands in my output.txt, no summary, like this:

-- listing properties --
db_name=PTPGSQL1
filter_stake=None
db_host=localhost
db_pwd=password
screenname=Screenname
filter_date=2007-04-04
db_user=postgres

[ 2007-04-04 09:06:36+02 ] [ 8s 5s ] [ Ks 9s ] [ _ Ah 2s 9h Qs Js ] [ 0.3380 ] [ 60.00$ / 20.28$ / 0.00$ / -20.28$ ]
[ 2007-04-04 09:08:08+02 ] [ Qd 9h ] [ Jc Jd ] [ _ Qh 7h 4d 3h 5d ] [ 0.2890 ] [ 39.00$ / 11.27$ / 39.00$ / +27.73$ ]
[ 2007-04-04 09:24:18+02 ] [ 4s 4d ] [ Qh 8d ] [ _ 6h 6s 4c 6c Ts ] [ 0.5320 ] [ 132.52$ / 70.50$ / 132.52$ / +62.02$ ]
[ 2007-04-04 09:29:59+02 ] [ As Jd ] [ Jc 7c ] [ Jh 9d 7d _ 6c 4c ] [ 0.3060 ] [ 192.20$ / 58.81$ / 0.00$ / -58.81$ ]
[ 2007-04-04 09:36:53+02 ] [ 9h 3h ] [ 9c 7c ] [ 8h 2h 9s 3d _ Qc ] [ 0.8860 ] [ 337.54$ / 299.06$ / 337.54$ / +38.48$ ]
[ 2007-04-04 09:50:19+02 ] [ Kh Kc ] [ Qd Td ] [ Ts 8h 7h _ Js 3c ] [ 0.8100 ] [ 75.00$ / 60.75$ / 75.00$ / +14.25$ ]

these stats should be written automatically at the very end of output.txt

wildzer0: i've gotten reports that the SQL query gathers 3 way allins as 2 headsup allins resulting in wrong results, i will send u a pm

Ok, they dont show in my output.txt. Maybe i'll try downloading the program again.

is there any unusual on screen output when running the batch?

Not sure what you mean. Theres nothing unusual going on. A window pos up:



And then my Output.txt look like this:

-- listing properties --
db_name=PTPGSQL1
filter_stake=None
db_host=localhost
db_pwd=password
screenname=screenname
filter_date=2007-04-03
db_user=postgres

[ 2007-04-03 14:05:07+02 ] [ Qh 9c ] [ Qc Jc ] [ Jd 8c Td 8h _ Kd ] [ 0.8750 ] [ 102.70$ / 89.86$ / 102.70$ / +12.84$ ]
[ 2007-04-03 14:43:07+02 ] [ Ah Jh ] [ Ad Ac ] [ 2h 8s 3h _ 6s 4c ] [ 0.3680 ] [ 190.92$ / 70.26$ / 0.00$ / -70.26$ ]
[ 2007-04-03 17:27:51+02 ] [ As Qc ] [ 4d 2d ] [ Ad Qd 3c 5c _ 4s ] [ 0.0910 ] [ 353.08$ / 32.13$ / 0.00$ / -32.13$ ]
[ 2007-04-03 17:51:39+02 ] [ Ah Ad ] [ 9s 6h ] [ 7s 5c Kd 8d _ 6c ] [ 0.0000 ] [ 337.28$ / 0.00$ / 0.00$ / +0.00$ ]
[ 2007-04-04 09:06:36+02 ] [ 8s 5s ] [ Ks 9s ] [ _ Ah 2s 9h Qs Js ] [ 0.3380 ] [ 60.00$ / 20.28$ / 0.00$ / -20.28$ ]
[ 2007-04-04 09:08:08+02 ] [ Qd 9h ] [ Jc Jd ] [ _ Qh 7h 4d 3h 5d ] [ 0.2890 ] [ 39.00$ / 11.27$ / 39.00$ / +27.73$ ]
[ 2007-04-04 09:24:18+02 ] [ 4s 4d ] [ Qh 8d ] [ _ 6h 6s 4c 6c Ts ] [ 0.5320 ] [ 132.52$ / 70.50$ / 132.52$ / +62.02$ ]
[ 2007-04-04 09:29:59+02 ] [ As Jd ] [ Jc 7c ] [ Jh 9d 7d _ 6c 4c ] [ 0.3060 ] [ 192.20$ / 58.81$ / 0.00$ / -58.81$ ]
[ 2007-04-04 09:36:53+02 ] [ 9h 3h ] [ 9c 7c ] [ 8h 2h 9s 3d _ Qc ] [ 0.8860 ] [ 337.54$ / 299.06$ / 337.54$ / +38.48$ ]
[ 2007-04-04 09:50:19+02 ] [ Kh Kc ] [ Qd Td ] [ Ts 8h 7h _ Js 3c ] [ 0.8100 ] [ 75.00$ / 60.75$ / 75.00$ / +14.25$ ]

yes thats what i meant with unusual output: a NumberFormatException when parsing the output of a pokenum.exe run

i made a new version for exactly this kind of problem: (send me a screen of the new output plz)

http://rapidshare.com/files/24598665..._v0.2.zip.html

note: i wont really keep improving this programm since Phil's will be much better anyway and i dont have much time

No prob



-- listing properties --
db_name=PTPGSQL1
filter_stake=none
db_host=localhost
db_pwd=password
screenname=screenname
filter_date=2007-04-04
db_user=postgres

[ 2007-04-04 09:06:36+02 ] [ 8s 5s ] [ Ks 9s ] [ _ Ah 2s 9h Qs Js ] [ 0.3380 ] [ 60.00$ / 20.28$ / 0.00$ / -20.28$ ]
[ 2007-04-04 09:08:08+02 ] [ Qd 9h ] [ Jc Jd ] [ _ Qh 7h 4d 3h 5d ] [ 0.2890 ] [ 39.00$ / 11.27$ / 39.00$ / +27.73$ ]
[ 2007-04-04 09:24:18+02 ] [ 4s 4d ] [ Qh 8d ] [ _ 6h 6s 4c 6c Ts ] [ 0.5320 ] [ 132.52$ / 70.50$ / 132.52$ / +62.02$ ]
[ 2007-04-04 09:29:59+02 ] [ As Jd ] [ Jc 7c ] [ Jh 9d 7d _ 6c 4c ] [ 0.3060 ] [ 192.20$ / 58.81$ / 0.00$ / -58.81$ ]
[ 2007-04-04 09:36:53+02 ] [ 9h 3h ] [ 9c 7c ] [ 8h 2h 9s 3d _ Qc ] [ 0.8860 ] [ 337.54$ / 299.06$ / 337.54$ / +38.48$ ]
[ 2007-04-04 09:50:19+02 ] [ Kh Kc ] [ Qd Td ] [ Ts 8h 7h _ Js 3c ] [ 0.8100 ] [ 75.00$ / 60.75$ / 75.00$ / +14.25$ ]
single usage: pokenum.exe [-t] [-O] [-mc niter]
[-h|-h8|-o|-o8|-7s|-7s8|-7snsq|-r|-5d|-5d8|-5dnsq|-l|-l27]
<pocket1> - <pocket2> - ... [ -- <board> ] [ / <dead> ] ]
streaming usage: pokenum.exe -i < argsfile
[ 2007-04-04 13:51:03+02 ] [ 9s 9h ] [ Ad 5d ] [ Th 7d 2d Tc _ Kd ] [ 0.7730 ] [ 214.18$ / 165.56$ / 0.00$ / -165.56$ ]
[ 2007-04-04 14:39:31+02 ] [ Ts 7s ] [ Ad 8h ] [ 8s As 3s Jc _ 2d ] [ 0.9090 ] [ 245.00$ / 222.71$ / 245.00$ / +22.29$ ]
[ 2007-04-04 16:06:56+02 ] [ Kc Jd ] [ 9s 8c ] [ 6h Jc Tc _ 7s As ] [ 0.6980 ] [ 108.20$ / 75.52$ / 0.00$ / -75.52$ ]
[ 2007-04-04 19:24:06+02 ] [ Ac Js ] [ Jd 7h ] [ 4s 2s Jc _ 8c Qc ] [ 0.8810 ] [ 210.86$ / 185.77$ / 210.86$ / +25.09$ ]
[ 2007-04-04 20:16:05+02 ] [ Qh Qs ] [ Ad Ks ] [ _ Tc 4h Jh 8d 5s ] [ 0.5680 ] [ 64.26$ / 36.50$ / 64.26$ / +27.76$ ]

found 11 headsup allin situations
won: 7 lost: 4 tied: 0
average potsize: $152.61
average ev: 0.6355
money won: $1104.18
money expected (based on allin equity): $1206.73
money difference: $-102.55
total_bet: $826.88

OK, looks like the program is a little skewed when it comes to 3-way all ins, good catch. I don't know if I'll have time to work on this today, but I'll try to get the query fixed in the nxt couple of day.

Gah, i'm getting 0's WTF

-- listing properties --
db_name=NL
filter_stake=($1.00/$2.00)
db_host=localhost
db_pwd=blahblah
screenname=IMSAKIDD
filter_date=2007-04-02
db_user=postgres


found 0 headsup allin situations
won: 0 lost: 0 tied: 0
average potsize: $NaN
average ev: NaN
money won: $0.00
money expected (based on allin equity): $0.00
money difference: $+0.00
total_bet: $0.00

i guess the stakefilter u use istn working, set it back to "none" and try again

I got results. Now to see if they are right.

Advisor: Give me your stars SN and ill ship you some moniez.

EDIT2: Def. Messes up with sidepots.

ok i had some time and reworked the query:
http://nopaste.codersnet.org/index.php?id=883

it should now filter out all multiway allins and also provide better stake filtering support

here's an updated version:
http://rapidshare.com/files/24702315..._v0.3.zip.html

if you really find the program useful you can ship me some my stars screenname is "advis0r" (thats a zero), thx if you do so

hf

Shipped you $10 ty

thx again (lol @ forum, 1 day downtime for a crappy update and then revert it with data loss)

latest version:
http://rapidshare.com/files/24938246..._v0.4.zip.html

you have to put pokenum.exe into the same directory
http://download.gna.org/pokersource/arch...les/pokenum.exe

and also the postgres jdbc drivers (im using 8.2)
http://jdbc.postgresql.org/download/...-504.jdbc3.jar

put everything into the same folder, edit settings.txt and run the bat file

have fun

ImsaKidd: did you read my answer about the special allin situation u came up with?

My database name is "NL (STARTED 12/1/05)".

Error Message:
SQLException: FATAL: database "NL (STARTED 12" does not exist
SQLState: 3D000
VendorError: 0

At a guess you will have to escape those slashes... e.g.


"NL (STARTED 12\/1\/05)"

not sure what java uses for escapes... this is for advis0r's java version right?