wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
I was bored the other day and wrote a sklansky bucks calculator shell script(not just sklansky bucks, but gives you an idea of how you're getting your money in, etc) using php. It queries your PT database to find hands where one or more players were all in and calculates your equity. Currently I don't want to release the script because it hits twodimes.net and parses the html and I don't want to hammer the site or anything. I know twodimes.net uses the free pokenum program which is written in C. Does anyone out there know if I can use their C libraries with my php script or care to help me develop this a little more for free release?
|
willw9
Caught in the act
Reged: 11/27/06
Posts: 4235
Loc: where momma keeps the peanut b...
|
|
This sounds very interesting.
|
_dave_
_Pooh-Bah_
Reged: 02/17/05
Posts: 2628
Loc: UK
|
|
Hi wildzer0,
you can use the PHP function exec() to run pokenum on the local machine.
Pokenum demonstrates the use of the libraries (I've been trying to figure it out a little lately), but if already have working setup using twodimes, pokenum on it's own does enough already, no?
dave.
Edited by _dave_ (03/30/07 07:12 PM)
|
rvg72
STTF Coder Dude
Reged: 06/01/05
Posts: 2342
Loc: Canada
|
|
Really cool idea. Every time I have an ugly downswing I begin working on a project like this but then scrap it as soon as I win a 20/80 
If you do this in PHP.NET (not a PHP programmer so don't know if this is a simple switch) you could use the C# Poker Eval libraries right in your code.
rvg
|
Phil153
Notable Twit
Reged: 10/18/05
Posts: 4905
|
|
I've already written a program which does this. I'm going beta on April 7th. It was originally written for Omaha/8 (which I play) but I've expanded to include holdem and written a HH Replayer that has stats overlay and a built in range calculator.
Here are some screenshots from the old Omaha version which was just for personal/friends' use (these are about 3 months old). Statistics and other features have been added which you'll see in the beta.
http://img91.imageshack.us/img91/8206/aamaysepft8.gif http://img252.imageshack.us/img252/3375/aabystreetmaysepnv7.gif http://img296.imageshack.us/img296/2149/aabypotsizecy4.png http://img334.imageshack.us/img334/9513/otkfilterskw5.gif
|
PerDoom
veteran
Reged: 06/21/06
Posts: 1366
|
|
Quote:
I've already written a program which does this. I'm going beta on April 7th. It was originally written for Omaha/8 (which I play) but I've expanded to include holdem and written a HH Replayer that has stats overlay and a built in range calculator.
Here are some screenshots from the old Omaha version which was just for personal/friends' use (these are about 3 months old). Statistics and other features have been added which you'll see in the beta.
http://img91.imageshack.us/img91/8206/aamaysepft8.gif http://img138.imageshack.us/img138/4121/weeksum1712ep0.png http://img252.imageshack.us/img252/3375/aabystreetmaysepnv7.gif http://img296.imageshack.us/img296/2149/aabypotsizecy4.png http://img334.imageshack.us/img334/9513/otkfilterskw5.gif
This looks awesome. Is this going to be free?
|
rvg72
STTF Coder Dude
Reged: 06/01/05
Posts: 2342
Loc: Canada
|
|
very nice!
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
Hi wildzer0,
you can use the PHP function exec() to run pokenum on the local machine.
Pokenum demonstrates the use of the libraries (I've been trying to figure it out a little lately), but if already have working setup using twodimes, pokenum on it's own does enough already, no?
dave.
Thanks dave, that's exactly what I was looking for. Twodimes.net works perfectly with the script and it is functional right now, but the problem is that it has the ability to clobber twodimes.net if you're not careful so I don't want to put it out so twodimes.net basically gets attacked inadvertently. I'll finish up this script with pokenum (maybe this weekend, but probably monday) and post it here for whoever wants it.
Phil's will probably be much more user friendly as this is a command line jones but everyone's welcome to it once I rework it a bit.
|
RiverFenix
faking winning cars
Reged: 12/18/04
Posts: 3029
Loc: IM FROM THE GHETTO HOMIE
|
|
Wildzer and Phil,
Please include the ability to run the analysis on any pot not just ai ones. Say if I want to know if the pot is over X bb's what are my sklansky bucks results. Thanks.
|
Phil153
Notable Twit
Reged: 10/18/05
Posts: 4905
|
|
Quote:
This looks awesome. Is this going to be free?
At the moment I'm thinking of having a basic version which is free and having an upgrade with all the premium features.
It all depends on feedback during the beta phase - if it's not worth my time to do commercial support or if the support load is light then it'll stay free. I have my own business already so it depends a lot on how much extra work this will create.
Quote:
Please include the ability to run the analysis on any pot not just ai ones. Say if I want to know if the pot is over X bb's what are my sklansky bucks results. Thanks.
Been done. It also accounts for side pots, rake, etc.
|
willw9
Caught in the act
Reged: 11/27/06
Posts: 4235
Loc: where momma keeps the peanut b...
|
|
Quote:
Quote:
I've already written a program which does this. I'm going beta on April 7th. It was originally written for Omaha/8 (which I play) but I've expanded to include holdem and written a HH Replayer that has stats overlay and a built in range calculator.
Here are some screenshots from the old Omaha version which was just for personal/friends' use (these are about 3 months old). Statistics and other features have been added which you'll see in the beta.
http://img91.imageshack.us/img91/8206/aamaysepft8.gif http://img138.imageshack.us/img138/4121/weeksum1712ep0.png http://img252.imageshack.us/img252/3375/aabystreetmaysepnv7.gif http://img296.imageshack.us/img296/2149/aabypotsizecy4.png http://img334.imageshack.us/img334/9513/otkfilterskw5.gif
This looks awesome. Is this going to be free?
|
LuckyDevil
old hand
Reged: 01/19/05
Posts: 722
|
|
Sounds awesome. I would pay for such a program as long as it was moderately fast and accurate. I hope it does Omaha high, along with high/low.
|
APerfect10
old hand
Reged: 01/22/05
Posts: 979
Loc: PokerTracker 3
|
|
Awesome! I've been wanting to code something like this for quite some time now but I've been too lazy...or busy with other things.
wildzer0, If you wouldnt sending me a PM with the details...I would be more than glad to help clean up the PHP and add pokernum via the exec(), if you want.
|
TheJared
addict
Reged: 10/12/06
Posts: 441
|
|
Awesome. Please keep up updated on this guys. A tool like this would be invaluable.
|
tautomer
enthusiast
Reged: 10/09/06
Posts: 356
|
|
Phil, definitely something that I'd be willing to purchase, especially if it includes omaha high.
|
willw9
Caught in the act
Reged: 11/27/06
Posts: 4235
Loc: where momma keeps the peanut b...
|
|
Quote:
Awesome. Please keep up updated on this guys. A tool like this would be invaluable.
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
I'm actually not really sure how to hook up pokenum as I've never really coded anything but web applications using php and java. So somehow, when presented with some C files, I don't actually know what to do with them. I forwarded my code onto APerfect10, hopefully he can do something with it. Anyone else that feels like explaining how to get pokenum running locally is welcome to PM me and maybe we can get this running.
|
PLOlover
Novator KS-172 AAM-L
Reged: 06/04/05
Posts: 3465
|
|
you can download the executable. I think its pokerenum.exe or something.
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Cannnnnnnot wait for this.
|
rvg72
STTF Coder Dude
Reged: 06/01/05
Posts: 2342
Loc: Canada
|
|
One of the great things about something like this is that you can calculate your "real" winrate with a far smaller sample size (due to a WAY lower standard deviation) so the Sklansky Bucks graph is far from fluff in terms of value.
rvg
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
OK, got a little help from _dave_, posting this thing in a little bit. I'll warn you guys know, it's completely non-user friendly, and it only works for all in hands, but it'll work until Phil's comes out
|
RiverFenix
faking winning cars
Reged: 12/18/04
Posts: 3029
Loc: IM FROM THE GHETTO HOMIE
|
|
Post it!
|
Phil153
Notable Twit
Reged: 10/18/05
Posts: 4905
|
|
Yeah, I've actually found it most useful for loading up after each session. Sometimes you think you played great and discover you barely made SB. It really made me think about my game, the short term swings in this game are amazing.
Just a note: I was releasing on April 7th but just realized the forums will be down that day due to the upgrade. I'll be away on Sunday, so I'm going to realease it on the 10th instead so I can deal with problems right away (there are always problems when putting out new software) Thanks for the PMs of interest.
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
OK, here it is. Hopefully it'll be of help to someone. Instructions for getting php running are below, you'll also need a copy of pokenum (it's free) running on you system. I really have no idea how to get it running on windows, but you need it in your system path. Hopefully someone who knows more about it than I do can post a short tutorial on how to do that on windows.
It'll probably a pain in the ass for people to get running, I'll say that right now, but it does work. If anyone generous person out there feels like hosting this, that could make things easier for people too.
Quote:
<?php /* ok, to use this script you need php installed. The easiest way to do this is to go to http://www.apachefriends.org/en/xampp.html and download the windows installer. Instant php! Now you just need to edit the variables below (above the big line). Save this as luck.php
You can use the windows command line to run this script then. Just go to start->run and type in cmd. When the windows comes up, type c:\Program Files\xampp\php\php.exe c:\path\to\luck.php It'll spit out 3 numbers. The first number is the amount you won. The 2nd number is the amount you "should have" one (sklansky bucks or whatever). The 3rd number is the total amount of money you put into these pots. */
//put your pokersite screen name here $screen_name = "screenname";
//put the stake string here (just edit the dollar amounts to match your stake $stake_string = "($1.00/$2.00)";
//this is the date to begin with in pokertracker, it'll go from this date to the present. $since_date = "2007-04-04";
//connection info - put all your postgres pt db connection info into these variables. $db_name = "PTPGSQL1"; $host = "localhost"; $user = "postgres"; $password = "password";
//***************************************DON'T EDIT BELOW THIS POINT*********************************
$conn_string = "dbname=" . $db_name ." host=" . $host . " user=" . $user . " password=" . $password; $conn = pg_connect($conn_string); if(!$conn) { echo("there was an error\n"); }
$query = "select hh.hand_history, gp.hole_card_1, gp.hole_card_2, gp2.hole_card_1, gp2.hole_card_2, g.flop_1, g.flop_2, g.flop_3, g.turn, g.river, gp.pre_flop_bet, gp.flop_bet, gp.turn_bet, gp.river_bet, gp.won_hand, g.pot, gp.total_won, g.game_number, gp.total_bet from game g join hand_histories hh on g.game_number = hh.game_number join game_players gp on g.game_id = gp.game_id join game_players gp2 on g.game_id = gp2.game_id join players p on p.player_id = gp.player_id join players p2 on p2.player_id = gp2.player_id where p.screen_name = '" . $screen_name . "' and p2.screen_name != '" . $screen_name . "' and (gp.pre_flop_bet + gp.flop_bet + gp.turn_bet + gp.river_bet >= gp.chip_count or gp2.pre_flop_bet + gp2.flop_bet + gp2.turn_bet + gp2.river_bet >= gp2.chip_count) and gp2.went_to_showdown_n = 1 and gp.went_to_showdown_n = 1 and g.date_played >= '" . $since_date . "' and hh.hand_history like '%" . $stake_string . "%' order by g.game_number";
$result = pg_query ($conn, $query); if(!$result) { echo("An error occured.\n"); } $a = 0; while($row = pg_fetch_row($result)) { if($last_game_number == $row[17]) { // echo("\n skipping " . $last_game_number); } else { $a++; $hh = $row[0]; $my_hole_card_1 = $row[1]; $my_hole_card_2 = $row[2]; $v_hole_card_1 = $row[3]; $v_hole_card_2 = $row[4]; $flop_1 = $row[5]; $flop_2 = $row[6]; $flop_3 = $row[7]; $turn = $row[8]; $river = $row[9]; $pre_flop_bet = $row[10]; $flop_bet = $row[11]; $turn_bet = $row[12]; $river_bet = $row[13]; $i_won_hand = $row[14]; $pot = $row[15]; $total_won = $row[16]; $last_game_number = $row[17]; $total_bet = $row[18];
$exec_string = "pokenum -h " . $my_hole_card_1 . " " . $my_hole_card_2 . " - " . $v_hole_card_1 . " " . $v_hole_card_2; if($flop_bet > 0 || $turn_bet > 0 || $river_bet > 0) { $exec_string .= " -- " . $flop_1 . " " . $flop_2 . " " . $flop_3; }
if($turn_bet >0 || $river_bet > 0) { $exec_string .= " " . $turn; } if($river_bet > 0) { $exec_string .= " " . $river; }
unset($pokenum_output); exec($exec_string, $pokenum_output);
unset($new_arr);
$line_arr = explode(" ", $pokenum_output[2]); $arr_count = 0; for($i=1;$i<count($line_arr);$i++) { if(!$line_arr[$i] == "") { $new_arr[$arr_count] = $line_arr[$i]; $arr_count++; } }
$sizeof_arr = sizeof($new_arr) - 1; $ev = $new_arr[$sizeof_arr]; $equity = $ev * $pot;
$all_won += $total_won; $all_equity += $equity; $all_bet += $total_bet; $total_ev += $ev;
echo("\n" . $exec_string ." "); echo($ev);
} } echo("\n" . $a . " hands played with an average ev of " . $total_ev / $a); echo("\nwon: " . $all_won); echo("\nequity: " . $all_equity); echo("\n total bet: " . $all_bet . "\n");
?>
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
Yeah, I've actually found it most useful for loading up after each session. Sometimes you think you played great and discover you barely made SB. It really made me think about my game, the short term swings in this game are amazing.
Just a note: I was releasing on April 7th but just realized the forums will be down that day due to the upgrade. I'll be away on Sunday, so I'm going to realease it on the 10th instead so I can deal with problems right away (there are always problems when putting out new software) Thanks for the PMs of interest.
Yeah, of course the numbers converge after a while, but I love this tool for evaluating individual sessions. I never set it up for more than a week at a time. The other thing I love about my script (can't speak for yours yet, but I can't wait to check it out!) is the ability to see how much you bet vs the amount of equity you had. Really helpful for identifying those sessions when you weren't playing at the top of your game
Edited by wildzer0 (04/04/07 09:05 PM)
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Also, I'll probably be of limited help in supporting this, but feel free to PM me anyway, and I'll do what I can.
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Soooooo, anyone with a pokenum walkthrough? I cant even find it through google.
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Yeah, sorry I can't be more helpful with that part. I got it running on linux with a fair amount of difficulty, I know it works on windows, and there may even be a pokenum.exe file floating out there.
|
LuckyDevil
old hand
Reged: 01/19/05
Posts: 722
|
|
Phil,
Will your program support Omaha high?
|
APerfect10
old hand
Reged: 01/22/05
Posts: 979
Loc: PokerTracker 3
|
|
I'm working on adding pokenum. I have all of the source code, I just need to compile it on Windows. Having a little difficulty since I'm not using Vista. I'm not sure how much time I'll have either, as I have a ton of stuff going on in my life right now and have very little free time.
|
Phil153
Notable Twit
Reged: 10/18/05
Posts: 4905
|
|
Devil,
Yes, it does.
Wildzer, nice script. I didn't realize php was that powerful for local programming.
|
PLOlover
Novator KS-172 AAM-L
Reged: 06/04/05
Posts: 3465
|
|
Quote:
I'm working on adding pokenum. I have all of the source code, I just need to compile it on Windows
it's somewhere 4 download, not sure exactly where
http://download.gna.org/pokersource/archives/poker-eval/windows/windows/xp/poker-eval/examples/
|
APerfect10
old hand
Reged: 01/22/05
Posts: 979
Loc: PokerTracker 3
|
|
Quote:
Quote:
I'm working on adding pokenum. I have all of the source code, I just need to compile it on Windows
it's somewhere 4 download, not sure exactly where
http://download.gna.org/pokersource/archives/poker-eval/windows/windows/xp/poker-eval/examples/
Great find. I've been scouring all of these directories and couldnt find the executible anywhere! This should save me some time...
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
Quote:
I'm working on adding pokenum. I have all of the source code, I just need to compile it on Windows
it's somewhere 4 download, not sure exactly where
http://download.gna.org/pokersource/archives/poker-eval/windows/windows/xp/poker-eval/examples/
holy crap! I must've looked for that .exe file for hours. nice find ! This script's pretty much a piece of cake to run now.
|
willw9
Caught in the act
Reged: 11/27/06
Posts: 4235
Loc: where momma keeps the peanut b...
|
|
Finished product?
|
skegvegaspoker
old hand
Reged: 04/06/06
Posts: 971
Loc: SSNL, UK
|
|
Quote:
Quote:
Quote:
I'm working on adding pokenum. I have all of the source code, I just need to compile it on Windows
it's somewhere 4 download, not sure exactly where
http://download.gna.org/pokersource/archives/poker-eval/windows/windows/xp/poker-eval/examples/
holy crap! I must've looked for that .exe file for hours. nice find ! This script's pretty much a piece of cake to run now.
Help! I've downloaded php and copied that script into notepad and renamed it luck.php. Then opened the php program and put the location of luck.php into it. Nothing happens. Just moves onto the next line.
Now on my desktop the notepad file is now a php file, but when I double click it in opens php for a second and then closes without "spitting out" any info. Any idea where I'm going wrong.
This is an excellent idea btw. Respect.
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
sounds like you've gotten reasonably far! Here's a quick tutorial that I hope everyone can use.
1. Go to http://www.apachefriends.org/en/xampp.html and download the windows installer. This is just an easy way to install php on your system.
2. Go to http://download.gna.org/pokersource/archives/poker-eval/windows/windows/xp/poker-eval/examples/ and download pokenum.exe
3. Copy the script I'm about to paste below into a text document, call it luck.php (keep it in the same folder as pokenum.exe).
4. Open up luck.php in notepad and change the variables at the top to match your settings (there are notes in the file to walk you through it, it's easy.
5. Open up your windows command line, easiest way is to go to Start->run and type "cmd"
6. cd to the directory where luck.php and pokenum are
7. type: "c:\Program Files\xampp\php\php.exe" luck.php"
8. Wait for it to finish (could take a while)
9. Bask in the glory of your earned Sklansky bucks.
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Here's a version of the script with a quick change to make it easier to use on windows systems. If you're on windows, use this instead of the code I pasted above.
Quote:
<?php /* ok, to use this script you need php installed. The easiest way to do this is to go to http://www.apachefriends.org/en/xampp.html and download the windows installer. Instant php! Now you just need to edit the variables below (above the big line). Save this as luck.php
You can use the windows command line to run this script then. Just go to start->run and type in cmd. When the windows comes up, type c:\Program Files\xampp\php\php.exe c:\path\to\luck.php It'll spit out 3 numbers. The first number is the amount you won. The 2nd number is the amount you "should have" one (sklansky bucks or whatever). The 3rd number is the total amount of money you put into these pots. */
//put your pokersite screen name here $screen_name = "sceenname";
//put the stake string here (just edit the dollar amounts to match your stake $stake_string = "($1.00/$2.00)";
//this is the date to begin with in pokertracker, it'll go from this date to the present. $since_date = "2007-04-01";
//connection info - put all your postgres pt db connection info into these variables. $db_name = "PTPGSQL1"; $host = "localhost"; $user = "postgres"; $password = "password";
//***************************************DON'T EDIT BELOW THIS POINT*********************************
$conn_string = "dbname=" . $db_name ." host=" . $host . " user=" . $user . " password=" . $password; $conn = pg_connect($conn_string); if(!$conn) { echo("there was an error\n"); }
$query = "select hh.hand_history, gp.hole_card_1, gp.hole_card_2, gp2.hole_card_1, gp2.hole_card_2, g.flop_1, g.flop_2, g.flop_3, g.turn, g.river, gp.pre_flop_bet, gp.flop_bet, gp.turn_bet, gp.river_bet, gp.won_hand, g.pot, gp.total_won, g.game_number, gp.total_bet from game g join hand_histories hh on g.game_number = hh.game_number join game_players gp on g.game_id = gp.game_id join game_players gp2 on g.game_id = gp2.game_id join players p on p.player_id = gp.player_id join players p2 on p2.player_id = gp2.player_id where p.screen_name = '" . $screen_name . "' and p2.screen_name != '" . $screen_name . "' and (gp.pre_flop_bet + gp.flop_bet + gp.turn_bet + gp.river_bet >= gp.chip_count or gp2.pre_flop_bet + gp2.flop_bet + gp2.turn_bet + gp2.river_bet >= gp2.chip_count) and gp2.went_to_showdown_n = 1 and gp.went_to_showdown_n = 1 and g.date_played >= '" . $since_date . "' and hh.hand_history like '%" . $stake_string . "%' order by g.game_number";
$result = pg_query ($conn, $query); if(!$result) { echo("An error occured.\n"); } $a = 0; while($row = pg_fetch_row($result)) { if($last_game_number == $row[17]) { // echo("\n skipping " . $last_game_number); } else { $a++; $hh = $row[0]; $my_hole_card_1 = $row[1]; $my_hole_card_2 = $row[2]; $v_hole_card_1 = $row[3]; $v_hole_card_2 = $row[4]; $flop_1 = $row[5]; $flop_2 = $row[6]; $flop_3 = $row[7]; $turn = $row[8]; $river = $row[9]; $pre_flop_bet = $row[10]; $flop_bet = $row[11]; $turn_bet = $row[12]; $river_bet = $row[13]; $i_won_hand = $row[14]; $pot = $row[15]; $total_won = $row[16]; $last_game_number = $row[17]; $total_bet = $row[18];
$exec_string = "pokenum.exe -h " . $my_hole_card_1 . " " . $my_hole_card_2 . " - " . $v_hole_card_1 . " " . $v_hole_card_2;
if($flop_bet > 0 || $turn_bet > 0 || $river_bet > 0) { $exec_string .= " -- " . $flop_1 . " " . $flop_2 . " " . $flop_3; }
if($turn_bet >0 || $river_bet > 0) { $exec_string .= " " . $turn; }
if($river_bet > 0) { $exec_string .= " " . $river; }
unset($pokenum_output); exec($exec_string, $pokenum_output);
unset($new_arr);
$line_arr = explode(" ", $pokenum_output[2]); $arr_count = 0; for($i=1;$i<count($line_arr);$i++) { if(!$line_arr[$i] == "") { $new_arr[$arr_count] = $line_arr[$i]; $arr_count++; } }
$sizeof_arr = sizeof($new_arr) - 1; $ev = $new_arr[$sizeof_arr]; $equity = $ev * $pot;
$all_won += $total_won; $all_equity += $equity; $all_bet += $total_bet; $total_ev += $ev;
} } echo("\n" . $a . " hands played with an average ev of " . $total_ev / $a); echo("\nwon: " . $all_won); echo("\nequity: " . $all_equity); echo("\n total bet: " . $all_bet . "\n");
?>
|
Wolfskin
newbie
Reged: 04/21/06
Posts: 39
|
|
Anyone getting this to work?
I followed all the steps above and edited the screen name, stake, date and password. I also put the pokenum.exe in the same directory as the luck.php script. This is what I get with the script for Linux and the recently posted one for Windows:
Fatal error: Call to undefinded function pg_connect() in C:\path\luck.php on line 32
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
Anyone getting this to work?
I followed all the steps above and edited the screen name, stake, date and password. I also put the pokenum.exe in the same directory as the luck.php script. This is what I get with the script for Linux and the recently posted one for Windows:
Fatal error: Call to undefinded function pg_connect() in C:\path\luck.php on line 32
Almost there! I forgot that postgres support is disabled in xampp by default. This is easy.
1. Open up c:\Program Files\xampp\php\php.ini in notepad or something similar.
2. Search for this line: Quote:
extension=php_pdo_pgsql.dll
3. Delete the semicolon at the beginning of the line.
4. Do the same thing for this line: Quote:
extension=php_pgsql.dll
5. Save the file.
|
Wolfskin
newbie
Reged: 04/21/06
Posts: 39
|
|
thanks a lot, it works like a charm now
|
YoureToast
old hand
Reged: 11/21/02
Posts: 1084
|
|
This is excellent. Any ideas how to automate this so I can results results in a couple of clicks?
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Well, once you get it all set up, all you need to do is change the date if you feel like it and type the c:\Program Files\xampp\php\php.exe luck.php line. pretty simple.
|
Tractor Puller
stranger
Reged: 04/05/07
Posts: 3
|
|
I keep getting the following message "Warning: Division by zero in luck.php on line 125"
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
I keep getting the following message "Warning: Division by zero in luck.php on line 125"
The only way you would get that is if you're not getting any qualifying hands from the db. Check the variables at the top, make sure everything is set correctly.
|
TheJared
addict
Reged: 10/12/06
Posts: 441
|
|
Where do I get the info for my pokertracker database to put into the script having trouble finding where each variable is located and can be modified in pokertracker? Where is the username and password info? Do I have to convert the database to SQL to use the script? Have got everything else setup.
|
Tractor Puller
stranger
Reged: 04/05/07
Posts: 3
|
|
Thanks for the reply wildzer0... my variables are:
$stake_string = "0.50/1.00";
$since_date = "2007-04-01";
$db_name = "PTPGSQL1"; $host = "localhost"; $user = "postgres"; $password = "1234";
Are these in correct format? (stake)
Checked them over few times before posting... many thanks for helping me out.
|
TheJared
addict
Reged: 10/12/06
Posts: 441
|
|
Quote:
Where do I get the info for my pokertracker database to put into the script having trouble finding where each variable is located and can be modified in pokertracker? Where is the username and password info? Do I have to convert the database to SQL to use the script? Have got everything else setup.
Nevermind figured it all out.
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Your stake_string is wrong. Should be ($0.50/$1.00)
|
tautomer
enthusiast
Reged: 10/09/06
Posts: 356
|
|
Do we need to open the php application at all? Someone mentioned telling php where the luck.php file was located and I have no idea what that means or how to do it. Another thing, where should pokenum and luck.php be saved? I have them in a folder on my desktop and that doesn't seem to be working. Computer illiterate here lol. Oh and the luck.php is just a notepad file, does it need to be converted or something?
|
Tractor Puller
stranger
Reged: 04/05/07
Posts: 3
|
|
Ok I´ll wait till "user-friendly" version comes out;) Thanks wildzer0 for your patience and help
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
You shouldn't have to open any kind of php application, don't worry about that part. Save the files wherever you want. Just followthe instructions above as carefully as possible and let me know, with as many details as possible, where you're getting stuck.
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Does our DB have to be postgreSQL for this to work?
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
Does our DB have to be postgreSQL for this to work?
Yes.
|
skegvegaspoker
old hand
Reged: 04/06/06
Posts: 971
Loc: SSNL, UK
|
|
"6. cd to the directory where luck.php and pokenum are"
I'm embarassed to say I don't know what this means.....
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
say you put your files in c:\luck\ just type cd c:\luck
|
tautomer
enthusiast
Reged: 10/09/06
Posts: 356
|
|
I get this message after I type the line you gave: 'c:\Program' is not recognized as an internal or external command, operable program, or batch file.
I'm not sure what this means but that's where I'm stuck.
|
TheJared
addict
Reged: 10/12/06
Posts: 441
|
|
Been trying to get this to work for a few hours. Got everything installed but it is coming up with an error claiming it cannot find my SQL pokertracker database. The database works fine in pokertracker and is named "PTdata" in pokertracker. Is there some other form of this name in SQL I need to put as the variable for the php script or is the name in pokertracker the same, and if not what could the problem be?
|
TheJared
addict
Reged: 10/12/06
Posts: 441
|
|

Here is a bigger version: http://img475.imageshack.us/img475/5427/errormessagefe4.jpg
Edited by TheJared (04/05/07 05:38 PM)
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
i tried using this with php at first... but this kind of usage pretty much sucks ;D
i made my own version in java as a stand alone program... here's sample output:
Quote:
[ Kh Kd ] [ Qd Jd ] [ 6c 5h Js _ Qc Ad ] [ 0,8160 ] [ 100,70$ / 82,17$ / 0,00$ / -82,17$ ] [ 9c 8c ] [ Ac Js ] [ Jh 6c Tc _ 6s 5h ] [ 0,5060 ] [ 24,70$ / 12,50$ / 0,00$ / -12,50$ ] [ Ah Jc ] [ Ad Qh ] [ _ 6d 7h Kh 2d Jh ] [ 0,2650 ] [ 31,45$ / 8,33$ / 31,45$ / +23,12$ ] [ Qd Qc ] [ Ac Ah ] [ 7s 4s 3c _ 4h Th ] [ 0,0920 ] [ 97,75$ / 8,99$ / 0,00$ / -8,99$ ] ... [ Qd Qs ] [ 9h 9s ] [ 4d 7s 4c 2h _ 9c ] [ 0,9550 ] [ 90,28$ / 86,22$ / 0,00$ / -86,22$ ] found 213 headsup allin situations won: 130 lost: 67 tied: 16 average potsize: $55,47 average ev: 0,6117 money won: $7935,18 money expected (based on allin equity): $7571,05 money difference: $+364,13 total_bet: $6076,56
so... i was running good ;D the _ indicates where we got it allin after the board theres EV, potsize, money im expected to win (equity), money i really won, difference
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
I get this message after I type the line you gave: 'c:\Program' is not recognized as an internal or external command, operable program, or batch file.
I'm not sure what this means but that's where I'm stuck.
umm, you can use tab completely for typing in the path to xampp. Ie type c:\Progr then hit tab to automatically complete to Program Files,I'm not sure if windows needs to escape the space inthe name or not, but if you do it that way it'll do it automatically. Try that, and let me know if it's not working.
|
TheJared
addict
Reged: 10/12/06
Posts: 441
|
|
Advis0r, that looks great will you make it avaliable?
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
i tried using this with php at first... but this kind of usage pretty much sucks ;D
i made my own version in java as a stand alone program...
Please please please post this.
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
Been trying to get this to work for a few hours. Got everything installed but it is coming up with an error claiming it cannot find my SQL pokertracker database. The database works fine in pokertracker and is named "PTdata" in pokertracker. Is there some other form of this name iren SQL I need to put as the variable for the php script or is the name in pokertracker the same, and if not what could the problem be?
The name of the db should be the same as it is in pokertracker. Make sure your other db settings are correct. If you double check everything and still aren't able to check, let me know and I'll post a test script for you to try that should give us a bit better diagnostic message.
I realize this is really freakin' hard to set up, especially if people don't know a lot about this sort of thing. I'm happy to help as much as I can, if you're really stuck, it looks like someone else has a stand alone version ready to release and phil's super fancy one is coming out soon.
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
ok, when i have time to make the screenname, date, database parameters etc customizable (via an external file), i will make it available
should be in less than 24hours
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
ok, when i have time to make the screenname, date, database parameters etc customizable (via an external file), i will make it available
should be in less than 24hours
Awesome, I knew this thing would be really difficult to support - but I thought it was cool so wanted to release it. I should have written it in java from the beginning but I default to php for tasks like this too much. If you don't mind, can you post or PM me with the source code when it's finished? I'd like to continue developing this (even though phil's will likely blow mine away ) but I'd like to switch it over to Java. I've pretty much figured out how to run it for non-all in hands so I'dlike to add that in. Let's just hope Gelford-dollars don't become the norm or I'll pull my hair out
Edited by wildzer0 (04/05/07 05:59 PM)
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Quote:
sounds like you've gotten reasonably far! Here's a quick tutorial that I hope everyone can use.
1. Go to http://www.apachefriends.org/en/xampp.html and download the windows installer. This is just an easy way to install php on your system.
2. Go to http://download.gna.org/pokersource/archives/poker-eval/windows/windows/xp/poker-eval/examples/ and download pokenum.exe
3. Copy the script I'm about to paste below into a text document, call it luck.php (keep it in the same folder as pokenum.exe).
4. Open up luck.php in notepad and change the variables at the top to match your settings (there are notes in the file to walk you through it, it's easy.
5. Open up your windows command line, easiest way is to go to Start->run and type "cmd"
6. cd to the directory where luck.php and pokenum are
7. type: "c:\Program Files\xampp\php\php.exe" luck.php"
8. Wait for it to finish (could take a while)
9. Bask in the glory of your earned Sklansky bucks.
What is 6? 6. cd to the directory where luck.php and pokenum are
How do I do this if luck is in my desktop?
|
K䲰䮥n
loves sippin_piss
Reged: 05/03/06
Posts: 3616
|
|
Any of these apps working with PO?
|
YoureToast
old hand
Reged: 11/21/02
Posts: 1084
|
|
Can't get this to work. I think it has something to do with the usage of the SQL line involving the stake amount. I keep gettin division by zero errors. Have tried plugging in the SQL into pgAdmin and can get results only if I use the all caps version of my username and change the stake amount. But I can't convert these results to the script.
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Imsakidd. cd is just the windows command for change directory. If you want to make it really easy on yourself, just put the folder on the c drive so you can just go cd c:\yourFolderName
Karpanen: You would need to change the sql query for it to work with PO. If you PM, I can help you with this.
YourToast: There seems to be a small amount of confusion with the stake string parameter. I just realized that since I only play on PokerStars, I didn't even think about setting it up for any other site. This shoudl still work with any site, you'll just have to find out the format your site uses for the stakes in the hand histories. For example, pokerstars histories all start out with a line like this:
Quote:
POKERSTARS GAME #7730049390: HOLD'EM NO LIMIT ($0.50/$1.00) - 2007/01/02 - 14:46:05 (ET)
The stake_string is just the part that identifies the stakes, in this case ($0.50/$1.00), - exactly how it appears in that line different sites will have different strings like this, so just put whatever your site happens to use in the $stake_string parameter. Also, if you don't care about only selecting certain stakes, you could just leave that parameter empty, and it'll still work.
Edited by wildzer0 (04/05/07 08:03 PM)
|
YoureToast
old hand
Reged: 11/21/02
Posts: 1084
|
|
wild, I tried that. I think now the problem is the SQL code refers to player_id rather than alias_id. Not sure exactly how to change this to fix the fact that I play on different sites, etc. I think you haven't had to deal with this because you only play on 1 site.
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
wild, I tried that. I think now the problem is the SQL code refers to player_id rather than alias_id. Not sure exactly how to change this to fix the fact that I play on different sites, etc. I think you haven't had to deal with this because you only play on 1 site.
Ah, yeah I didn't think of that. I'll amend the script tomorrow morning and post a new site independent one.
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
ok i uploaded my version:
http://rapidshare.com/files/24545277/AllinCalc_v0.1.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/postgresql-8.2-504.jdbc3.jar
put everything into the same folder, edit settings.txt and run the bat file
have fun
|
YoureToast
old hand
Reged: 11/21/02
Posts: 1084
|
|
no dice...cant get it to work...says 0 hands
edit: nevermind...got it working....this is excellent....who wants to create a script to allow us to click 1 button and get the current day's data?!?
Edited by YoureToast (04/05/07 09:24 PM)
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
what settings did you use?
u better leave filter_stake set to "none" at first ( and try finding a good value for it later )
and also the screenname has to be the one you used to combine your aliases from different sites
|
YoureToast
old hand
Reged: 11/21/02
Posts: 1084
|
|
Quote:
what settings did you use?
u better leave filter_stake set to "none" at first ( and try finding a good value for it later )
and also the screenname has to be the one you used to combine your aliases from different sites
see my edited post above. got it working....excellent work!
|
TheJared
addict
Reged: 10/12/06
Posts: 441
|
|
Quote:
no dice...cant get it to work...says 0 hands
edit: nevermind...got it working....this is excellent....who wants to create a script to allow us to click 1 button and get the current day's data?!?
Toast, I am having the same issue, getting zero hands, what am I missing or doing wrong?
|
TheJared
addict
Reged: 10/12/06
Posts: 441
|
|
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.
|
TheJared
addict
Reged: 10/12/06
Posts: 441
|
|
Looks like it just may be the capitalization. First I miscapped the database then I miscapped my username. Both of these are case sensitive.
|
TheJared
addict
Reged: 10/12/06
Posts: 441
|
|
Thanks for everything guys this is awesome.
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Good to hear you got it working!
|
tautomer
enthusiast
Reged: 10/09/06
Posts: 356
|
|
Quote:
Quote:
I get this message after I type the line you gave: 'c:\Program' is not recognized as an internal or external command, operable program, or batch file.
I'm not sure what this means but that's where I'm stuck.
umm, you can use tab completely for typing in the path to xampp. Ie type c:\Progr then hit tab to automatically complete to Program Files,I'm not sure if windows needs to escape the space inthe name or not, but if you do it that way it'll do it automatically. Try that, and let me know if it's not 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.
Edited by tautomer (04/06/07 02:20 AM)
|
K䲰䮥n
loves sippin_piss
Reged: 05/03/06
Posts: 3616
|
|
Quote:
Any of these apps working with PO?
|
jj12
veteran
Reged: 09/14/06
Posts: 1368
Loc: crushing donks
|
|
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?
Edited by jj12 (04/06/07 06:27 AM)
|
canta
journeyman
Reged: 09/23/06
Posts: 95
|
|
Quote:
i made my own version in java as a stand alone program... here's sample output:
Quote:
[ Kh Kd ] [ Qd Jd ] [ 6c 5h Js _ Qc Ad ] [ 0,8160 ] [ 100,70$ / 82,17$ / 0,00$ / -82,17$ ] [ 9c 8c ] [ Ac Js ] [ Jh 6c Tc _ 6s 5h ] [ 0,5060 ] [ 24,70$ / 12,50$ / 0,00$ / -12,50$ ] [ Ah Jc ] [ Ad Qh ] [ _ 6d 7h Kh 2d Jh ] [ 0,2650 ] [ 31,45$ / 8,33$ / 31,45$ / +23,12$ ] [ Qd Qc ] [ Ac Ah ] [ 7s 4s 3c _ 4h Th ] [ 0,0920 ] [ 97,75$ / 8,99$ / 0,00$ / -8,99$ ] ... [ Qd Qs ] [ 9h 9s ] [ 4d 7s 4c 2h _ 9c ] [ 0,9550 ] [ 90,28$ / 86,22$ / 0,00$ / -86,22$ ] found 213 headsup allin situations won: 130 lost: 67 tied: 16 average potsize: $55,47 average ev: 0,6117 money won: $7935,18 money expected (based on allin equity): $7571,05 money difference: $+364,13 total_bet: $6076,56
so... i was running good ;D the _ indicates where we got it allin after the board theres EV, potsize, money im expected to win (equity), money i really won, difference
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$ ]
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
Quote:
Did the program calculate the avg potsize, avg EV and so on, or do you have to do that by hand?
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
|
canta
journeyman
Reged: 09/23/06
Posts: 95
|
|
Quote:
these stats should be written automatically at the very end of output.txt
Ok, they dont show in my output.txt. Maybe i'll try downloading the program again.
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
Quote:
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?
|
canta
journeyman
Reged: 09/23/06
Posts: 95
|
|
Quote:
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$ ]
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
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/AllinCalc_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
|
canta
journeyman
Reged: 09/23/06
Posts: 95
|
|
Quote:
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
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
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.
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
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
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
i guess the stakefilter u use istn working, set it back to "none" and try again
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Quote:
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.
Edited by ImsaKidd (04/06/07 06:19 PM)
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
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/AllinCalc_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
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Shipped you $10 ty
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
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/AllinCalc_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/postgresql-8.2-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?
|
TheIrishThug
Pooh-Bah
Reged: 01/17/05
Posts: 1819
Loc: Belligerent and numerous
|
|
My database name is "NL (STARTED 12/1/05)".
Error Message: SQLException: FATAL: database "NL (STARTED 12" does not exist SQLState: 3D000 VendorError: 0
|
_dave_
_Pooh-Bah_
Reged: 02/17/05
Posts: 2628
Loc: UK
|
|
Quote:
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?
|
Fidodell
member
Reged: 03/12/06
Posts: 109
|
|
Very cool program advis0r...
Just couple questions...
Is the rake supposed to be taken into consideration at all? Example equity =1.000 pot size =100.00 / expected win =100.00 / actual won =97.00 / Result = -3.00
Which leads to my next question... I ran my numbers for each month so far this year... each month my average EV is over 0.56+ but each month the money difference is negative... does that mean I'm just running bad every month so far?? or could that have something to do with the rake??
Any way to take results from multiple DB's, and merge the results?
Finally what would be optimal #'s??
|
GoHeels
journeyman
Reged: 03/13/07
Posts: 51
|
|
Ok Im a software idiot. I downloaded advis0r's 3 files and put them in the same folder. But I have no idea what to type in for my settings to make it work. Can anyone point me in the right direction? Also is the settings file the only thing I need to edit? Thanks
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Quote:
Ok Im a software idiot. I downloaded advis0r's 3 files and put them in the same folder. But I have no idea what to type in for my settings to make it work. Can anyone point me in the right direction? Also is the settings file the only thing I need to edit? Thanks
Is your DB in postgreSQL?
Previous poster: The rake isnt calculated. Just realized this, so some #'s are def. gonna be off.
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Quote:
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/AllinCalc_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/postgresql-8.2-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?
RE: It not being addressed byo a single query? Yeah, I saw that.
|
GoHeels
journeyman
Reged: 03/13/07
Posts: 51
|
|
Quote: "Is your DB in postgreSQL?"
Haha, my ignorance shows even more. I dont know what this means...
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Quote:
Quote: "Is your DB in postgreSQL?"
Haha, my ignorance shows even more. I dont know what this means...
Search around the pokertracker site and you will find how to convert it. makes it run faster, as well as compatibility for this calc.
|
GoHeels
journeyman
Reged: 03/13/07
Posts: 51
|
|
Ok, im in postgreSQL and I entered my stuff in the settings, but when I run the .bat file, it says to check the output.txt, however this is completly blank. Any ideas?
|
gball
journeyman
Reged: 05/11/06
Posts: 89
|
|
The program seems to give positive results for pots that are lost, if the all-in push is large compared to villain's stack:
[ 2007-03-31 17:16:03+03 ] [ Qs Jd ] [ Qc 9c ] [ Js 8s 6h Th _ 2h ] [ 0.0340 ] [ 194.40$ / 6.61$ / 130.60$ / +123.99$ ] [ NL ($0.50) ]
Seat 5: Hero ($162.75 in chips) DEALER Seat 8: Villain ($32.15 in chips) Seat 10: dddrrr ($72.75 in chips) Villain: Post SB $0.25 dddrrr: Post BB $0.50 *** HOLE CARDS *** Dealt to Villain [C9 CQ] Dealt to Hero [DJ SQ] Hero: Raise $2.00 Villain: Call $1.75 dddrrr: Fold *** FLOP *** [SJ S8 H6] Villain: Check Hero: Bet $3.50 Villain: Call $3.50 *** TURN *** [H10] Villain: Check Hero: Allin $157.25 Villain: Allin $26.65 *** RIVER *** [H2] *** SUMMARY *** Total pot $194.40 Rake $1.00 Hero: wins $130.60 Villain: wins $63.80
|
PatInTheHat
Pooh-Bah
Reged: 11/08/05
Posts: 1917
|
|
Having troubles downloading: "You have reached the download-limit for free-users. Want to download more?"
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
Quote:
Is the rake supposed to be taken into consideration at all? Example equity =1.000 pot size =100.00 / expected win =100.00 / actual won =97.00 / Result = -3.00
actually i dont know wether the rake should be substracted from the potsize or not. i dont know how pokertracker saves this because here is a hand from my db: [ 7h 7s ] [ Ac Qc ] [ 6d 6c 2s 7c _ Jh ] [ 1,0000 ] [ 131,25$ / 131,25$ / 131,25$ / +0,00$ ] [ NL ($0.50) (6 max) ]
the rake saved with this hand by pokertracker is 2.0, how come its +0,00$ in this hand? pokertracker experts may comment on the connections between potsize, rake etc? does it save it differently for different sites?
Quote:
The program seems to give positive results for pots that are lost, if the all-in push is large compared to villain's stack:
what site is the hh from? is it common for all pokersites to include uncalled bets in the total pot? if so, using the potsize to make these equity calculations is pretty flawed indeed.
Quote:
Having troubles downloading: "You have reached the download-limit for free-users. Want to download more?"
You recently downloaded from rapidshare as a free user and thus have to wait a lil bit till you can download again (or dial in again to get a new ip)
|
gball
journeyman
Reged: 05/11/06
Posts: 89
|
|
Quote:
Quote:
The program seems to give positive results for pots that are lost, if the all-in push is large compared to villain's stack:
what site is the hh from? is it common for all pokersites to include uncalled bets in the total pot?
The hh is from iPoker network. I don't know how this program pulls the hands from PT, but I would assume PT does the hh parsing before storing them in common format to the database, and this program reads from there. So this would affect hh's from all sites. Dunno for sure though.
|
Phil153
Notable Twit
Reged: 10/18/05
Posts: 4905
|
|
You have to take rake into account. For small numbers of hands you can fudge it from the total rake stored in pokertracker database. The only solution when working with large numbers of hands is to have rake tables for every site and level, otherwise crossing the rake boundary on later streets can lead to an increasing divergence from the true EV line.
Quote:
the rake saved with this hand by pokertracker is 2.0, how come its +0,00$ in this hand? pokertracker experts may comment on the connections between potsize, rake etc? does it save it differently for different sites?
Yes. Overbets are stored differently too. The PokerTracker database has quite a few flaws and inaccuracies - which are a major pain in the ass. I'd estimate 1/3 of my development time (22,000 lines of code) has been spent working around this stuff. The other problem is that people sometimes import after a hand history change or when pokertracker has bugs, then forget to do a purge and reimport. That can send the EV line haywire, depending on what data gets screwed up. For some of the more obscure sites there's no solution but to pull up the hand history and parse it yourself. I do it anyway for the replayer but it kills performance during the calc.
Re the program, I'm still not happy with the hand history replayer, the documentation and a few other things, so I'm going to do a trimmed down pre-beta release tomorrow so that you guys can start using it. I'll make a post tomorrow.
|
GoHeels
journeyman
Reged: 03/13/07
Posts: 51
|
|
Quote:
Ok, im in postgreSQL and I entered my stuff in the settings, but when I run the .bat file, it says to check the output.txt, however this is completly blank. Any ideas?
Was I supposed to edit anything other than the setting file? I have tried many times to get this to work, but the output file is always blank. Thanks guys.
|
shipitkthx
old hand
Reged: 02/12/07
Posts: 936
Loc: Canada
|
|
SQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. SQLState: 08004 VendorError: 0
Can someone tell me what to put in the settings to send it to Port 5433? My postgres runs there instead of 5432.
|
skylos
member
Reged: 10/20/06
Posts: 184
|
|
Quote:
Quote:
Ok, im in postgreSQL and I entered my stuff in the settings, but when I run the .bat file, it says to check the output.txt, however this is completly blank. Any ideas?
Was I supposed to edit anything other than the setting file? I have tried many times to get this to work, but the output file is always blank. Thanks guys.
Yeah I got this same problem. I edited the settings and this is what the blank output text looks like for me:
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
|
GoHeels
journeyman
Reged: 03/13/07
Posts: 51
|
|
Quote:
Quote:
Quote:
Ok, im in postgreSQL and I entered my stuff in the settings, but when I run the .bat file, it says to check the output.txt, however this is completly blank. Any ideas?
Was I supposed to edit anything other than the setting file? I have tried many times to get this to work, but the output file is always blank. Thanks guys.
Yeah I got this same problem. I edited the settings and this is what the blank output text looks like for me:
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
You got more than I did. My output file is completly blank, i dont have any text at all...
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
Quote:
Was I supposed to edit anything other than the setting file? I have tried many times to get this to work, but the output file is always blank.
is output.txt completely blank or does it say it finds 0 hands? if it finds 0 hands do your filter-settings make sense? leave filter_stake to "none" at first and see if it connects to the db and finds anything at all. and also you could set filter_date to something like 2000-01-01 at first.
if you find 0 hands and think its not your fault at least show your settings and be sure that screenname, filter_stake etc do make sense for your db 
Quote:
Can someone tell me what to put in the settings to send it to Port 5433? My postgres runs there instead of 5432.
did you try setting "db_host=localhost:5433" ?
we all should be looking forward to your program Phil153  what language do you code in? why did you spend 1/3 of your dev-time to work around the flawed PT-Datebase (if you have to parse some handhistories anyway) ?
|
skylos
member
Reged: 10/20/06
Posts: 184
|
|
These were the settings that I used:
db_host = localhost db_name = PTPGSQL1 (this is the real name of my db) db_user = postgres db_pwd = password (i used my real pw not password) screenname = screenname (i used my real screename) filter_date = 2007-01-01 filter_stake = none
I somehow managed to get wildzer0's program running and working even though I don't much at all about computers and I thought this one would be easier and it would be cool to compare the results from the two but I have no idea what I'm doing wrong. I even tried the 2000-01-01 you just suggested.
|
GoHeels
journeyman
Reged: 03/13/07
Posts: 51
|
|
here are my settings, it gives me a completly blank output, no text at all.
db_host = localhost db_name = PTPGSQL1 db_user = postgres db_pwd = mypassword screenname = myscreenname filter_date = 2006-03-01 filter_stake = none
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
hmmm, your settings look fine, some things that might cause finding 0 hands: - you used a screenname that you combined in pokertracker with a screenname from another site. if so, you should be using the "master-screenname" in your settings.txt - you accidently entered some whitespace behind some settings (like screenname)
GoHeels: does the command window that comes up when running the batch show any unusual output? (more than "running AllinCalc... done ... see output.txt")
i hate seeing the program having so many problems, but it was just planned as a quick standalone of the php version and since Phil153 is working on a better program i dont think i will really work it over with multiple queries, correct sidepots etc.
|
skylos
member
Reged: 10/20/06
Posts: 184
|
|
Awesome. Your a genius. There was some white space behind my screename and now it works perfectly. Thanks so much. It is a bit different result from wildzer0's I guess due to the headsup vs. multiway? Not sure haven't really looked hard but over 70k hands yours says I'm owed 13 buyins and wildzers say 17. And thanks a ton to you also wildzer0. Now I know I'm not just paranoid and really am running bad
|
GoHeels
journeyman
Reged: 03/13/07
Posts: 51
|
|
Here is the output from the .bat file.
running AllinCalc... Exception in thread "main" java.lang.UnsupportedClassVersionError: AllinCalc (Un supported major.minor version 49.0) at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(Unknown Source) at java.security.SecureClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.access$100(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) done ... see output.txt Press any key to continue . . .
|
advis0r
journeyman
Reged: 04/02/07
Posts: 99
Loc: Southern Germany
|
|
you have an older version of java installed than i used to create the program (class files) with.
check www.java.com for the latest version (something like "JRE Java Runtime Environment Version 6 Update 1") and it should work
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
I retract my earlier statement about rake. I got a 6 and 8 confused in the HH I looked at, but the calc does take potsize (post rake) when calculating equity, so no worries.
You have no idea how much I am looking forward to the beta.
|
GoHeels
journeyman
Reged: 03/13/07
Posts: 51
|
|
Prefect, it works now. Much thanks. Now I need to figure out how to change my luck and not be down over 10% from my EV.
|
Fidodell
member
Reged: 03/12/06
Posts: 109
|
|
Does anyone have any results that say they are running better than they should?? All of my results say negative difference...
|
GoHeels
journeyman
Reged: 03/13/07
Posts: 51
|
|
Quote:
Does anyone have any results that say they are running better than they should?? All of my results say negative difference...
Check out advis0r's results earlier in the thread. He is aboove his EV.
|
r1base14
enthusiast
Reged: 07/03/05
Posts: 277
|
|
I can't for hte life of me get this to produce a result. Below are my paramters:
db_host = localhost db_name = PTPGSQL2 db_user = postgres db_pwd = 303909 screenname = odub303 filter_date = 2007-02-01 filter_stake = $0.25/$0.50
any ideas?
Ryan
|
PatInTheHat
Pooh-Bah
Reged: 11/08/05
Posts: 1917
|
|
Can someone please rehost this script for me?
|
wildzer0
Pooh-Bah
Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
|
|
Quote:
Awesome. Your a genius. There was some white space behind my screename and now it works perfectly. Thanks so much. It is a bit different result from wildzer0's I guess due to the headsup vs. multiway? Not sure haven't really looked hard but over 70k hands yours says I'm owed 13 buyins and wildzers say 17. And thanks a ton to you also wildzer0. Now I know I'm not just paranoid and really am running bad
Wow that's some bad luck dude. I haven't really taken a look at how advisor modified the query so I could be wrong here, but I believe he just eliminated the hands where multiple people saw a showdown, whereas in mine, I believe those hands were being counted multiple times (I have a fix for that, but been sick and lazy the last few days). So that could definitely account for a 4 buy-in difference.
I'm just the guy with the good ideas, I need other people to actually make 'em work
|
hra146
Hand of Reality
Reged: 06/11/06
Posts: 4041
Loc: Amsterdam, bitches
|
|
tytytytytytyt for this... finally Im certain about the fact that I am THE LUCKIEST BITCH ALIVE.
+20% on EV or sth.
ship it
|
shipitkthx
old hand
Reged: 02/12/07
Posts: 936
Loc: Canada
|
|
My last 5 days of 1/2NL:
found 201 headsup allin situations won: 122 lost: 58 tied: 21 average potsize: $220.26 average ev: 0.5616 money won: $27188.16 money expected (based on allin equity): $24239.44 money difference: $+2948.72 total_bet: $22663.04
|
Jehaim
Hero bets $1
Reged: 11/02/05
Posts: 3375
Loc: His love is everlasting
|
|
Wow, this is awesome. Thanks!
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Quote:
Does anyone have any results that say they are running better than they should?? All of my results say negative difference...
i ran like 1.3k below equity while shortstacking 1/2 this weekend (8k hands), then i ran like 1.5k above when at 2/4 and 3/6. this is shortstacking and YMMV.
Does anyone else feel like a little kid on christmas eve waiting for the beta tomorrow? I forsee spending like 3 hours just looking through pots and stuff, it really looks awesome tho. Maybe im just a math nerd ><
|
Jehaim
Hero bets $1
Reged: 11/02/05
Posts: 3375
Loc: His love is everlasting
|
|
I'm running -18% at the stake I'm taking shots at.
I'm running +18% at my "Im Tired - Lets play Low" stake.
STANDARD 
I'm running +4% at my normal stake though...
|
ImsaKidd
CHOOO CHOO
Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
|
|
Jehaim:
I ran terrible at my normal stakes, moved up to 3/6 yesterday and ran hotter than god. Good times will come
|
Jehaim
Hero bets $1
Reged: 11/02/05
Posts: 3375
Loc: His love is everlasting
|
|
Quote:
Jehaim:
I ran terrible at my normal stakes, moved up to 3/6 yesterday and ran hotter than god. Good times will come
True.
Best tactic would obviously be to leave my normal stake where im due a downswing and move up to where I'm due a hot streak.
|
Prickly Pete
old hand
Reged: 05/29/03
Posts: 905
Loc: VA
|
|
Do either of these programs work with Sit n Go's or are they just for cash games?
|
FBP
old hand
Reged: 10/10/05
Posts: 715
Loc: Bluffville
|
|
output.txt says : postgresql-8.2-504.jdbc3.jar not found
My settings are:
db_host = localhost db_name = GRIND (i think this is the name of the freshly converted SQLdb, where i can doublecheck?) db_user = postgres db_pwd = mypassword screenname = myscreenname (don't need to do it for each alias right?) filter_date = 2001-01-01 filter_stake = none
I'll def send a few bucks if i can get this going.
|