Terms & Conditions

Internet Magazine

Non–US new players
Get five 2+2 books


Order Books
Book Translations
Forum Login
 
 
Expand All   Collapse All

 Two Plus Two 
2+2 Magazine Forum
Special Sklansky Forum
2+2 Pokercast
About the Forums

 General Poker Discussion 
Beginners Questions
Books and Publications
Televised Poker
News, Views, and Gossip
Brick and Mortar
Home Poker
Beats, Brags, and Variance
Poker Theory
Poker Legislation

 Coaching/Training 
StoxPoker
DeucesCracked

 German Forums 
Poker Allgemein
Strategie: Holdem NL cash
Strategie: Sonstige
Internet/Online
BBV
Small Talk
German Poker News

 French Forums 
Forum francophone
Strategie
BBV (French)

 Limit Texas Hold'em 
High Stakes Limit
Medium Stakes Limit
Small Stakes Limit
Micro Stakes Limit
Mid-High Short-handed
Small Stakes Shorthanded
Limit––>NL

 PL/NL Texas Hold'em 
High Stakes
Medium Stakes
Small Stakes
Micro Stakes
Small-High Full Ring
Micro Full Ring

 Tournament Poker 
Small Stakes MTT
High Stakes MTT
MTT Community
STT Strategy
Tournament Circuit

 Other Poker 
Omaha/8
Omaha High
Stud
Heads Up Poker
Other Poker Games

 General Gambling 
Probability
Psychology
Sports Betting
Other Gambling Games
Entertainment Betting

 Internet Gambling 
Internet Gambling
Internet Bonuses
Affiliates/RakeBack
Software

 2+2 Communities 
Other Other Topics
The Lounge: Discussion+Review
El Diablo's General Discussion
BBV4Life

 Other Topics 
Golf
Sporting Events
Politics
Business, Finance, and Investing
Travel
Science, Math, and Philosophy
Health and Fitness
Student Life
Puzzles and Other Games
Video Games
Laughs or Links!
Computer Technical Help
Sponsored Support Forums
RakebackNetwork
RakeReduction.com
Other Links
Books
Authors
Abbreviations
Calendar
Order Books
Books by Others
Favorite Links
Feedback
Advertising Information
Home
Posting Hints
Privacy Notice
Forum Archives

The 2+2 Forums

Before using this Forum, please refer to the Terms and Conditions (Last modified: 2/26/2006)

Be sure to read the   Two Plus Two Internet Magazine

This is an archive. The main forums are here

These forums are read only.


 
UBB.threads™ Groupee, Inc.

Internet Gambling >> Software

Pages: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | >> (show all)
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Sklansky bucks calculator (php script)
      #9774803 - 03/30/07 06:46 PM

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?

Post Extras: Print Post   Remind Me!   Notify Moderator  
willw9
Caught in the act


Reged: 11/27/06
Posts: 4235
Loc: where momma keeps the peanut b...
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9774947 - 03/30/07 07:02 PM

This sounds very interesting.

Post Extras: Print Post   Remind Me!   Notify Moderator  
_dave_
_Pooh-Bah_


Reged: 02/17/05
Posts: 2628
Loc: UK
Re: Sklansky bucks calculator (php script) [Re: willw9]
      #9775052 - 03/30/07 07:11 PM

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)


Post Extras: Print Post   Remind Me!   Notify Moderator  
rvg72
STTF Coder Dude


Reged: 06/01/05
Posts: 2342
Loc: Canada
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9775277 - 03/30/07 07:34 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
Phil153
Notable Twit


Reged: 10/18/05
Posts: 4905
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9775535 - 03/30/07 07:56 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
PerDoom
veteran


Reged: 06/21/06
Posts: 1366
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #9775612 - 03/30/07 08:03 PM

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?


Post Extras: Print Post   Remind Me!   Notify Moderator  
rvg72
STTF Coder Dude


Reged: 06/01/05
Posts: 2342
Loc: Canada
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #9775637 - 03/30/07 08:05 PM

very nice!

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: _dave_]
      #9775707 - 03/30/07 08:09 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
RiverFenix
faking winning cars


Reged: 12/18/04
Posts: 3029
Loc: IM FROM THE GHETTO HOMIE
Re: Sklansky bucks calculator (php script) [Re: rvg72]
      #9775732 - 03/30/07 08:11 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Phil153
Notable Twit


Reged: 10/18/05
Posts: 4905
Re: Sklansky bucks calculator (php script) [Re: PerDoom]
      #9775850 - 03/30/07 08:21 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
willw9
Caught in the act


Reged: 11/27/06
Posts: 4235
Loc: where momma keeps the peanut b...
Re: Sklansky bucks calculator (php script) [Re: PerDoom]
      #9778862 - 03/31/07 12:55 AM

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?




Post Extras: Print Post   Remind Me!   Notify Moderator  
LuckyDevil
old hand


Reged: 01/19/05
Posts: 722
Re: Sklansky bucks calculator (php script) [Re: willw9]
      #9780314 - 03/31/07 03:52 AM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
APerfect10
old hand


Reged: 01/22/05
Posts: 979
Loc: PokerTracker 3
Re: Sklansky bucks calculator (php script) [Re: LuckyDevil]
      #9780519 - 03/31/07 04:24 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
TheJared
addict


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: APerfect10]
      #9782447 - 03/31/07 12:27 PM

Awesome. Please keep up updated on this guys. A tool like this would be invaluable.

Post Extras: Print Post   Remind Me!   Notify Moderator  
tautomer
enthusiast


Reged: 10/09/06
Posts: 356
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9787080 - 03/31/07 08:25 PM

Phil, definitely something that I'd be willing to purchase, especially if it includes omaha high.

Post Extras: Print Post   Remind Me!   Notify Moderator  
willw9
Caught in the act


Reged: 11/27/06
Posts: 4235
Loc: where momma keeps the peanut b...
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9807786 - 04/02/07 01:31 PM

Quote:

Awesome. Please keep up updated on this guys. A tool like this would be invaluable.




Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: willw9]
      #9809136 - 04/02/07 02:56 PM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
PLOlover
Novator KS-172 AAM-L


Reged: 06/04/05
Posts: 3465
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9820754 - 04/03/07 09:48 AM

you can download the executable. I think its pokerenum.exe or something.

Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #9843117 - 04/04/07 05:49 PM

Cannnnnnnot wait for this.

Post Extras: Print Post   Remind Me!   Notify Moderator  
rvg72
STTF Coder Dude


Reged: 06/01/05
Posts: 2342
Loc: Canada
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9843570 - 04/04/07 06:22 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: rvg72]
      #9844422 - 04/04/07 07:25 PM

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

Post Extras: Print Post   Remind Me!   Notify Moderator  
RiverFenix
faking winning cars


Reged: 12/18/04
Posts: 3029
Loc: IM FROM THE GHETTO HOMIE
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9845128 - 04/04/07 08:16 PM

Post it!

Post Extras: Print Post   Remind Me!   Notify Moderator  
Phil153
Notable Twit


Reged: 10/18/05
Posts: 4905
Re: Sklansky bucks calculator (php script) [Re: rvg72]
      #9845325 - 04/04/07 08:33 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: RiverFenix]
      #9845680 - 04/04/07 09:01 PM

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");

?>





Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #9845702 - 04/04/07 09:02 PM

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)


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9845717 - 04/04/07 09:03 PM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9847948 - 04/05/07 12:19 AM

Soooooo, anyone with a pokenum walkthrough? I cant even find it through google.

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9848079 - 04/05/07 12:29 AM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
LuckyDevil
old hand


Reged: 01/19/05
Posts: 722
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9848211 - 04/05/07 12:39 AM

Phil,

Will your program support Omaha high?


Post Extras: Print Post   Remind Me!   Notify Moderator  
APerfect10
old hand


Reged: 01/22/05
Posts: 979
Loc: PokerTracker 3
Re: Sklansky bucks calculator (php script) [Re: LuckyDevil]
      #9848867 - 04/05/07 01:35 AM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
Phil153
Notable Twit


Reged: 10/18/05
Posts: 4905
Re: Sklansky bucks calculator (php script) [Re: LuckyDevil]
      #9849270 - 04/05/07 02:17 AM

Devil,

Yes, it does.

Wildzer, nice script. I didn't realize php was that powerful for local programming.


Post Extras: Print Post   Remind Me!   Notify Moderator  
PLOlover
Novator KS-172 AAM-L


Reged: 06/04/05
Posts: 3465
Re: Sklansky bucks calculator (php script) [Re: APerfect10]
      #9850494 - 04/05/07 05:40 AM

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/


Post Extras: Print Post   Remind Me!   Notify Moderator  
APerfect10
old hand


Reged: 01/22/05
Posts: 979
Loc: PokerTracker 3
Re: Sklansky bucks calculator (php script) [Re: PLOlover]
      #9850941 - 04/05/07 07:42 AM

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...


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: PLOlover]
      #9851054 - 04/05/07 08:11 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
willw9
Caught in the act


Reged: 11/27/06
Posts: 4235
Loc: where momma keeps the peanut b...
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9852260 - 04/05/07 10:51 AM

Finished product?

Post Extras: Print Post   Remind Me!   Notify Moderator  
skegvegaspoker
old hand


Reged: 04/06/06
Posts: 971
Loc: SSNL, UK
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9852509 - 04/05/07 11:14 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: skegvegaspoker]
      #9852680 - 04/05/07 11:27 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9852704 - 04/05/07 11:29 AM

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");

?>





Post Extras: Print Post   Remind Me!   Notify Moderator  
Wolfskin
newbie


Reged: 04/21/06
Posts: 39
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9852911 - 04/05/07 11:45 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: Wolfskin]
      #9853083 - 04/05/07 11:58 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Wolfskin
newbie


Reged: 04/21/06
Posts: 39
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9854669 - 04/05/07 01:41 PM

thanks a lot, it works like a charm now

Post Extras: Print Post   Remind Me!   Notify Moderator  
YoureToast
old hand


Reged: 11/21/02
Posts: 1084
Re: Sklansky bucks calculator (php script) [Re: Wolfskin]
      #9855448 - 04/05/07 02:33 PM

This is excellent. Any ideas how to automate this so I can results results in a couple of clicks?

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: YoureToast]
      #9855522 - 04/05/07 02:38 PM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
Tractor Puller
stranger


Reged: 04/05/07
Posts: 3
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9856170 - 04/05/07 03:14 PM

I keep getting the following message "Warning: Division by zero in luck.php on line 125"

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: Tractor Puller]
      #9856431 - 04/05/07 03:29 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
TheJared
addict


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9856658 - 04/05/07 03:44 PM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
Tractor Puller
stranger


Reged: 04/05/07
Posts: 3
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9856687 - 04/05/07 03:46 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
TheJared
addict


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9856933 - 04/05/07 04:03 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9857116 - 04/05/07 04:15 PM

Your stake_string is wrong. Should be ($0.50/$1.00)

Post Extras: Print Post   Remind Me!   Notify Moderator  
tautomer
enthusiast


Reged: 10/09/06
Posts: 356
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9857609 - 04/05/07 04:49 PM

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?

Post Extras: Print Post   Remind Me!   Notify Moderator  
Tractor Puller
stranger


Reged: 04/05/07
Posts: 3
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9857657 - 04/05/07 04:52 PM

Ok I´ll wait till "user-friendly" version comes out;) Thanks wildzer0 for your patience and help

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: tautomer]
      #9857708 - 04/05/07 04:55 PM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9857789 - 04/05/07 05:01 PM

Does our DB have to be postgreSQL for this to work?

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9857810 - 04/05/07 05:02 PM

Quote:

Does our DB have to be postgreSQL for this to work?




Yes.


Post Extras: Print Post   Remind Me!   Notify Moderator  
skegvegaspoker
old hand


Reged: 04/06/06
Posts: 971
Loc: SSNL, UK
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9857883 - 04/05/07 05:08 PM

"6. cd to the directory where luck.php and pokenum are"

I'm embarassed to say I don't know what this means.....


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: skegvegaspoker]
      #9857932 - 04/05/07 05:11 PM

say you put your files in c:\luck\ just type cd c:\luck

Post Extras: Print Post   Remind Me!   Notify Moderator  
tautomer
enthusiast


Reged: 10/09/06
Posts: 356
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9858148 - 04/05/07 05:26 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
TheJared
addict


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9858208 - 04/05/07 05:30 PM

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?

Post Extras: Print Post   Remind Me!   Notify Moderator  
TheJared
addict


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9858266 - 04/05/07 05:34 PM



Here is a bigger version: http://img475.imageshack.us/img475/5427/errormessagefe4.jpg

Edited by TheJared (04/05/07 05:38 PM)


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9858381 - 04/05/07 05:42 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: tautomer]
      #9858431 - 04/05/07 05:45 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
TheJared
addict


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9858439 - 04/05/07 05:45 PM

Advis0r, that looks great will you make it avaliable?

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9858463 - 04/05/07 05:46 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9858520 - 04/05/07 05:50 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9858558 - 04/05/07 05:52 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9858628 - 04/05/07 05:57 PM

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)


Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9858858 - 04/05/07 06:10 PM

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?


Post Extras: Print Post   Remind Me!   Notify Moderator  
K䲰䮥n
loves sippin_piss


Reged: 05/03/06
Posts: 3616
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9859031 - 04/05/07 06:20 PM

Any of these apps working with PO?

Post Extras: Print Post   Remind Me!   Notify Moderator  
YoureToast
old hand


Reged: 11/21/02
Posts: 1084
Re: Sklansky bucks calculator (php script) [Re: K䲰䮥n]
      #9860094 - 04/05/07 07:37 PM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: YoureToast]
      #9860342 - 04/05/07 08:01 PM

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)


Post Extras: Print Post   Remind Me!   Notify Moderator  
YoureToast
old hand


Reged: 11/21/02
Posts: 1084
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9860763 - 04/05/07 08:41 PM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: YoureToast]
      #9861048 - 04/05/07 09:06 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9861113 - 04/05/07 09:11 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
YoureToast
old hand


Reged: 11/21/02
Posts: 1084
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9861202 - 04/05/07 09:19 PM

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)


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: YoureToast]
      #9861247 - 04/05/07 09:23 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
YoureToast
old hand


Reged: 11/21/02
Posts: 1084
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9861275 - 04/05/07 09:25 PM

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!


Post Extras: Print Post   Remind Me!   Notify Moderator  
TheJared
addict


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: YoureToast]
      #9861707 - 04/05/07 10:01 PM

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?


Post Extras: Print Post   Remind Me!   Notify Moderator  
TheJared
addict


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9861906 - 04/05/07 10:23 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
TheJared
addict


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9861926 - 04/05/07 10:24 PM

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

Post Extras: Print Post   Remind Me!   Notify Moderator  
TheJared
addict


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9861931 - 04/05/07 10:25 PM

Thanks for everything guys this is awesome.

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: TheJared]
      #9862453 - 04/05/07 11:08 PM

Good to hear you got it working!

Post Extras: Print Post   Remind Me!   Notify Moderator  
tautomer
enthusiast


Reged: 10/09/06
Posts: 356
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9864210 - 04/06/07 02:15 AM

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)


Post Extras: Print Post   Remind Me!   Notify Moderator  
K䲰䮥n
loves sippin_piss


Reged: 05/03/06
Posts: 3616
Re: Sklansky bucks calculator (php script) [Re: K䲰䮥n]
      #9864921 - 04/06/07 04:14 AM

Quote:

Any of these apps working with PO?




Post Extras: Print Post   Remind Me!   Notify Moderator  
jj12
veteran


Reged: 09/14/06
Posts: 1368
Loc: crushing donks
Re: Sklansky bucks calculator (php script) [Re: K䲰䮥n]
      #9865437 - 04/06/07 06:05 AM

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)


Post Extras: Print Post   Remind Me!   Notify Moderator  
canta
journeyman


Reged: 09/23/06
Posts: 95
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9865476 - 04/06/07 06:16 AM

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$ ]


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: canta]
      #9865519 - 04/06/07 06:30 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
canta
journeyman


Reged: 09/23/06
Posts: 95
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9865571 - 04/06/07 06:48 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: canta]
      #9865589 - 04/06/07 06:52 AM

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?


Post Extras: Print Post   Remind Me!   Notify Moderator  
canta
journeyman


Reged: 09/23/06
Posts: 95
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9865626 - 04/06/07 07:04 AM

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$ ]


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: canta]
      #9865711 - 04/06/07 07:34 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
canta
journeyman


Reged: 09/23/06
Posts: 95
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9865830 - 04/06/07 08:11 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: canta]
      #9866102 - 04/06/07 09:16 AM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9867897 - 04/06/07 12:48 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9869587 - 04/06/07 03:16 PM

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

Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9871732 - 04/06/07 06:15 PM

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)


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9873406 - 04/06/07 08:24 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9874638 - 04/06/07 10:20 PM

Shipped you $10 ty

Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9879703 - 04/09/07 06:49 PM

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?


Post Extras: Print Post   Remind Me!   Notify Moderator  
TheIrishThug
Pooh-Bah


Reged: 01/17/05
Posts: 1819
Loc: Belligerent and numerous
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9880405 - 04/09/07 07:46 PM

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

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
_dave_
_Pooh-Bah_


Reged: 02/17/05
Posts: 2628
Loc: UK
Re: Sklansky bucks calculator (php script) [Re: TheIrishThug]
      #9880872 - 04/09/07 08:22 PM

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?


Post Extras: Print Post   Remind Me!   Notify Moderator  
Fidodell
member


Reged: 03/12/06
Posts: 109
Re: Sklansky bucks calculator (php script) [Re: _dave_]
      #9881580 - 04/09/07 09:08 PM

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??


Post Extras: Print Post   Remind Me!   Notify Moderator  
GoHeels
journeyman


Reged: 03/13/07
Posts: 51
Re: Sklansky bucks calculator (php script) [Re: _dave_]
      #9884083 - 04/10/07 12:00 AM

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

Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: GoHeels]
      #9884167 - 04/10/07 12:06 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9884192 - 04/10/07 12:07 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
GoHeels
journeyman


Reged: 03/13/07
Posts: 51
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9884374 - 04/10/07 12:17 AM

Quote:
"Is your DB in postgreSQL?"

Haha, my ignorance shows even more. I dont know what this means...


Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: GoHeels]
      #9884797 - 04/10/07 12:43 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
GoHeels
journeyman


Reged: 03/13/07
Posts: 51
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9886213 - 04/10/07 02:31 AM

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?

Post Extras: Print Post   Remind Me!   Notify Moderator  
gball
journeyman


Reged: 05/11/06
Posts: 89
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9886914 - 04/10/07 04:15 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
PatInTheHat
Pooh-Bah


Reged: 11/08/05
Posts: 1917
Re: Sklansky bucks calculator (php script) [Re: gball]
      #9887165 - 04/10/07 05:15 AM

Having troubles downloading:
"You have reached the download-limit for free-users. Want to download more?"


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: PatInTheHat]
      #9887664 - 04/10/07 07:29 AM

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)


Post Extras: Print Post   Remind Me!   Notify Moderator  
gball
journeyman


Reged: 05/11/06
Posts: 89
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9887783 - 04/10/07 07:59 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Phil153
Notable Twit


Reged: 10/18/05
Posts: 4905
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9887963 - 04/10/07 08:44 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
GoHeels
journeyman


Reged: 03/13/07
Posts: 51
Re: Sklansky bucks calculator (php script) [Re: GoHeels]
      #9890161 - 04/10/07 12:44 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
shipitkthx
old hand


Reged: 02/12/07
Posts: 936
Loc: Canada
Re: Sklansky bucks calculator (php script) [Re: GoHeels]
      #9890465 - 04/10/07 01:06 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
skylos
member


Reged: 10/20/06
Posts: 184
Re: Sklansky bucks calculator (php script) [Re: GoHeels]
      #9890611 - 04/10/07 01:17 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
GoHeels
journeyman


Reged: 03/13/07
Posts: 51
Re: Sklansky bucks calculator (php script) [Re: skylos]
      #9890926 - 04/10/07 01:37 PM

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...


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: shipitkthx]
      #9890942 - 04/10/07 01:38 PM

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) ?


Post Extras: Print Post   Remind Me!   Notify Moderator  
skylos
member


Reged: 10/20/06
Posts: 184
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9891098 - 04/10/07 01:48 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
GoHeels
journeyman


Reged: 03/13/07
Posts: 51
Re: Sklansky bucks calculator (php script) [Re: skylos]
      #9891243 - 04/10/07 01:56 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: skylos]
      #9891577 - 04/10/07 02:14 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
skylos
member


Reged: 10/20/06
Posts: 184
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9891813 - 04/10/07 02:29 PM

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

Post Extras: Print Post   Remind Me!   Notify Moderator  
GoHeels
journeyman


Reged: 03/13/07
Posts: 51
Re: Sklansky bucks calculator (php script) [Re: skylos]
      #9892113 - 04/10/07 02:48 PM

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 . . .


Post Extras: Print Post   Remind Me!   Notify Moderator  
advis0r
journeyman


Reged: 04/02/07
Posts: 99
Loc: Southern Germany
Re: Sklansky bucks calculator (php script) [Re: GoHeels]
      #9892177 - 04/10/07 02:53 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #9892211 - 04/10/07 02:55 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
GoHeels
journeyman


Reged: 03/13/07
Posts: 51
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9892505 - 04/10/07 03:14 PM

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.

Post Extras: Print Post   Remind Me!   Notify Moderator  
Fidodell
member


Reged: 03/12/06
Posts: 109
Re: Sklansky bucks calculator (php script) [Re: GoHeels]
      #9893603 - 04/10/07 04:24 PM

Does anyone have any results that say they are running better than they should?? All of my results say negative difference...

Post Extras: Print Post   Remind Me!   Notify Moderator  
GoHeels
journeyman


Reged: 03/13/07
Posts: 51
Re: Sklansky bucks calculator (php script) [Re: Fidodell]
      #9893830 - 04/10/07 04:38 PM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
r1base14
enthusiast


Reged: 07/03/05
Posts: 277
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9895988 - 04/10/07 07:04 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
PatInTheHat
Pooh-Bah


Reged: 11/08/05
Posts: 1917
Re: Sklansky bucks calculator (php script) [Re: r1base14]
      #9896534 - 04/10/07 07:49 PM

Can someone please rehost this script for me?

Post Extras: Print Post   Remind Me!   Notify Moderator  
wildzer0
Pooh-Bah


Reged: 05/27/05
Posts: 2211
Loc: Balmer, hon
Re: Sklansky bucks calculator (php script) [Re: skylos]
      #9897253 - 04/10/07 08:38 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
hra146
Hand of Reality


Reged: 06/11/06
Posts: 4041
Loc: Amsterdam, bitches
Re: Sklansky bucks calculator (php script) [Re: PatInTheHat]
      #9897321 - 04/10/07 08:44 PM

tytytytytytyt for this... finally Im certain about the fact that I am THE LUCKIEST BITCH ALIVE.

+20% on EV or sth.

ship it


Post Extras: Print Post   Remind Me!   Notify Moderator  
shipitkthx
old hand


Reged: 02/12/07
Posts: 936
Loc: Canada
Re: Sklansky bucks calculator (php script) [Re: hra146]
      #9897963 - 04/10/07 09:31 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
Jehaim
Hero bets $1


Reged: 11/02/05
Posts: 3375
Loc: His love is everlasting
Re: Sklansky bucks calculator (php script) [Re: shipitkthx]
      #9898103 - 04/10/07 09:43 PM

Wow, this is awesome. Thanks!

Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: Fidodell]
      #9900638 - 04/11/07 12:34 AM

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 ><


Post Extras: Print Post   Remind Me!   Notify Moderator  
Jehaim
Hero bets $1


Reged: 11/02/05
Posts: 3375
Loc: His love is everlasting
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9900871 - 04/11/07 12:58 AM

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...


Post Extras: Print Post   Remind Me!   Notify Moderator  
ImsaKidd
CHOOO CHOO


Reged: 08/25/05
Posts: 11074
Loc: CHOO CHOO
Re: Sklansky bucks calculator (php script) [Re: Jehaim]
      #9900933 - 04/11/07 01:03 AM

Jehaim:

I ran terrible at my normal stakes, moved up to 3/6 yesterday and ran hotter than god. Good times will come


Post Extras: Print Post   Remind Me!   Notify Moderator  
Jehaim
Hero bets $1


Reged: 11/02/05
Posts: 3375
Loc: His love is everlasting
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9901025 - 04/11/07 01:12 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Prickly Pete
old hand


Reged: 05/29/03
Posts: 905
Loc: VA
Re: Sklansky bucks calculator (php script) [Re: Jehaim]
      #9902283 - 04/11/07 03:53 AM

Do either of these programs work with Sit n Go's or are they just for cash games?

Post Extras: Print Post   Remind Me!   Notify Moderator  
FBP
old hand


Reged: 10/10/05
Posts: 715
Loc: Bluffville
Re: Sklansky bucks calculator (php script) [Re: Prickly Pete]
      #9903053 - 04/11/07 06:48 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator