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 Ill 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  
mmorpg
veteran


Reged: 05/24/06
Posts: 1457
Loc: London, England
Re: Sklansky bucks calculator (php script) [Re: FBP]
      #9903625 - 04/11/07 09:00 AM

Did you download the .jar file and put it in the same directory as the script itself? Did you execute the script from the folder all the files are in?

Post Extras: Print Post   Remind Me!   Notify Moderator  
Zaghomat
On a 410k hand downswing


Reged: 06/13/06
Posts: 273
Re: Sklansky bucks calculator (php script) [Re: mmorpg]
      #9903671 - 04/11/07 09:08 AM

Prima network doesn't show mucked hands, so there is a lot of hu allin situation where you won the pot but don't know the opponents cards. I suppose this will screw up the calculation?

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: mmorpg]
      #9903916 - 04/11/07 09:44 AM

Quote:

Did you download the .jar file and put it in the same directory as the script itself? Did you execute the script from the folder all the files are in?




Oh right, simply missed this download.

found 658 headsup allin situations
won: 368 lost: 281 tied: 9
average potsize: $326.56
average ev: 0.5349
money won: $122558.76
money expected (based on allin equity): $121542.04
money difference: $+1016.72
total_bet: $103929.13

So it says my edge in these spots was 3.5%, and i'm a slightly over my EV. Standard.


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: Prickly Pete]
      #9906421 - 04/11/07 01:22 PM

Quote:

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




Just cash.


Post Extras: Print Post   Remind Me!   Notify Moderator  
jukofyork
Carpal \'Tunnel


Reged: 09/16/04
Posts: 2551
Loc: Leeds, UK.
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9906710 - 04/11/07 01:44 PM

Quote:

Quote:

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




Just cash.



Will they ever? How hard would it be to adapt them so they did?

Juk


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: jukofyork]
      #9906907 - 04/11/07 01:56 PM

There's not really any reason they shouldn't work with cash games. I didn't write the query to specifically do anything with tourneys, but I imagine it would either work out of the box with tourneys or would with very small modifications.

Post Extras: Print Post   Remind Me!   Notify Moderator  
jukofyork
Carpal \'Tunnel


Reged: 09/16/04
Posts: 2551
Loc: Leeds, UK.
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #9907112 - 04/11/07 02:10 PM

Quote:

There's not really any reason they shouldn't work with cash games. I didn't write the query to specifically do anything with tourneys, but I imagine it would either work out of the box with tourneys or would with very small modifications.



Cool, I'll have to give it a try later then and see what it shows up.

Juk


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: wildzer0]
      #9907210 - 04/11/07 02:16 PM

I tried with SNGs with no luck. For cash, it worked as advertised.

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


Reged: 12/06/06
Posts: 140
Loc: Univ. Wisconsin-Madison
Re: Sklansky bucks calculator (php script) [Re: Prickly Pete]
      #9907737 - 04/11/07 02:49 PM

Does this work with PT Omaha?

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


Reged: 10/09/06
Posts: 356
Re: Sklansky bucks calculator (php script) [Re: CruNKinTILT]
      #9907911 - 04/11/07 02:59 PM

I tried with PTO, it gives an output but it only looks at two hole cards.

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: CruNKinTILT]
      #9908111 - 04/11/07 03:09 PM

first of all, thanks to the guy that sent me 20 bucks on stars

Quote:

Does this work with PT Omaha?



no but i think Phil153's program will (see earlier in this thread)

Quote:

I tried with SNGs with no luck



it doesnt work with SNGs since its only querying the cashgame database tables atm. after a quick look i think the query could be ported over to use the tourney-tables for calculating this info as well. but then it would be about chipsEV rather than $EV, which is quite a difference in sngs. a badbeat 4 handed is more important to the "running good"-factor than at other stages...

to all the others:
be careful with these numbers. the query doesnt get all allin situations and sometimes the pot numbers of the situations it finds arent right (if there are sidepots, multiple allin, more betting after you are allin etc.)

i could fix this but lets just wait for Phil153's program and see how it does


Post Extras: Print Post   Remind Me!   Notify Moderator  
jukofyork
Carpal \'Tunnel


Reged: 09/16/04
Posts: 2551
Loc: Leeds, UK.
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9909721 - 04/11/07 04:37 PM

Quote:

Quote:

I tried with SNGs with no luck



it doesnt work with SNGs since its only querying the cashgame database tables atm. after a quick look i think the query could be ported over to use the tourney-tables for calculating this info as well. but then it would be about chipsEV rather than $EV, which is quite a difference in sngs. a badbeat 4 handed is more important to the "running good"-factor than at other stages...



I think just knowing if you are losing more/less all-ins than you should would be helpful, but you could also use ICM by finding your "prizepool equity" when you lose/tie/win an all-in and use that in-place of the chip equity itself to get your $EV instead of chipEV. This would show up (magnify) if you are losing/winning the "important all-ins" more often than you should. The ICM calculation is relatively slow though as it's O(n!), but just having 3 prizes and a small n it shouldn't be too bad even for a big DB (for the end of MTTs it could become too slow though...).

Juk


Post Extras: Print Post   Remind Me!   Notify Moderator  
ICMoney
uNL Librarian


Reged: 09/27/05
Posts: 1720
Loc: Watching Vids > Playing
Re: Sklansky bucks calculator (php script) [Re: jukofyork]
      #9911468 - 04/11/07 06:41 PM

Rehost?

Thanks.


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: advis0r]
      #9911877 - 04/11/07 07:09 PM

Cmon Phil!

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


Reged: 09/03/06
Posts: 125
Re: Sklansky bucks calculator (php script) [Re: ICMoney]
      #9911898 - 04/11/07 07:10 PM

First off, nice work .

I've found a little bug with PartyPoker handhistory's. This handhistory:
Quote:

Seat 4 is the button
Total number of players : 6
Seat 3: Bollefranz ( $ 171.02 USD )
Seat 5: Meijland01 ( $ 143.03 USD )
Seat 1: Rambambulle ( $ 146.25 USD )
Seat 6: Hero ( $ 266.55 USD )
Seat 2: Hempels82 ( $ 49.50 USD )
Seat 4: busto_ ( $ 98.50 USD )
Meijland01 posts small blind [$ 0.50 USD].
Hero posts big blind [$ 1 USD].
** Dealing down cards **
Dealt to Hero [ Qs Qh ]
Rambambulle calls [$ 1 USD]
Hempels82 folds.
Bollefranz calls [$ 1 USD]
busto_ raises [$ 5 USD]
Meijland01 folds.
Hero calls [$ 4 USD]
Rambambulle folds.
Bollefranz calls [$ 4 USD]
** Dealing Flop ** [ 6h, 7h, 7d ]
Hero checks.
Bollefranz checks.
busto_ bets [$ 10 USD]
Hero raises [$ 27 USD]
Bollefranz folds.
busto_ raises [$ 34 USD]
Hero is all-In.
busto_ is all-In.
** Dealing Turn ** [ Kc ]
** Dealing River ** [ 2h ]
busto_ shows [ As, Ah ]two pairs, Aces and Sevens.
Hero shows [ Qs, Qh ]two pairs, Queens and Sevens.
Hero wins $ 168.05 USD from side pot #1 with two pairs, Queens and Sevens.
busto_ wins $ 200.50 USD from the main pot with two pairs, Aces and Sevens.



Produces this line of output:
Quote:

[ 2007-04-04 10:36:28+02 ] [ Qs Qh ] [ As Ah ] [ 6h 7h 7d _ Kc 2h ] [ 0.0840 ] [ 368.55$ / 30.96$ / 168.05$ / +137.09$ ] [ NL $100 (6 max) ]



This is obviously wrong since I didn't win any money, yet it says I'm $137 above EV. The problem is caused by the PartyPoker handhistory's, that add "Uncalled bets" to the pot and gives it back through a side pot.

If you're up against short(er)stacks a lot, the output most likely produces a result that tells you you ran much hotter than you in fact did.


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


Reged: 02/24/07
Posts: 1448
Loc: weeee graduated
Re: Sklansky bucks calculator (php script) [Re: Pomtidom]
      #9912434 - 04/11/07 07:49 PM

Very interesting software, advis0r!

My results:

found 510 headsup allin situations
won: 313 lost: 125 tied: 72
average potsize: $98.65
average ev: 0.6281
money won: $30210.06
money expected (based on allin equity): $31511.81
money difference: $-1301.75
total_bet: $24917.94

I expected I ran bad, and actually -$1300 is less bad than I expected


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: Rainclouds]
      #9912491 - 04/11/07 07:52 PM

http://rapidshare.com/files/25520091/AllinCalc_v0.5.zip.html

i "fixed" some small stuff, hope it still works right
now i substract the total_bet difference between hero and villain off the pot and off total_won, should make for some more accurate numbers i guess.

debug_mode=1 shows hand history for every hand


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: RiverFenix]
      #9913227 - 04/11/07 08:44 PM

Quote:

Cmon Phil!




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


Reged: 09/24/06
Posts: 205
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9916476 - 04/12/07 12:54 AM

cant get it to work,

PT and other tools are working fine with my dbs.

latest postgres.

settings.txt :

db_host = localhost
db_name = PARTYPOKER[2007]-PLAYED
db_user = postgres
db_pwd = postgres
screenname = Heroname
filter_date = 2007-01-01
filter_stake = none
filter_maxev = 1.0
filter_minev = 0.0
debug_mode = 0

Output.txt :

-- listing properties --
filter_date=2007-01-01
filter_minev=0.0
db_name=PARTYPOKER[2007]-PLAYED
filter_maxev=1.0
db_user=postgres
filter_stake=none
debug_mode=0
screenname=heroname
db_host=localhost
db_pwd=postgres

SQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
SQLState: 08004
VendorError: 0

whut to do ?

/edit : running Postgres 8.2.3, also tested it the postgresql-8.2-504.jdbc4.jar

Edited by Toasta (04/12/07 01:02 AM)


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


Reged: 03/15/05
Posts: 766
Re: Sklansky bucks calculator (php script) [Re: Pomtidom]
      #9918741 - 04/12/07 06:45 AM

Quote:

First off, nice work .

I've found a little bug with PartyPoker handhistory's. This handhistory:
Quote:

Seat 4 is the button
Total number of players : 6
Seat 3: Bollefranz ( $ 171.02 USD )
Seat 5: Meijland01 ( $ 143.03 USD )
Seat 1: Rambambulle ( $ 146.25 USD )
Seat 6: Hero ( $ 266.55 USD )
Seat 2: Hempels82 ( $ 49.50 USD )
Seat 4: busto_ ( $ 98.50 USD )
Meijland01 posts small blind [$ 0.50 USD].
Hero posts big blind [$ 1 USD].
** Dealing down cards **
Dealt to Hero [ Qs Qh ]
Rambambulle calls [$ 1 USD]
Hempels82 folds.
Bollefranz calls [$ 1 USD]
busto_ raises [$ 5 USD]
Meijland01 folds.
Hero calls [$ 4 USD]
Rambambulle folds.
Bollefranz calls [$ 4 USD]
** Dealing Flop ** [ 6h, 7h, 7d ]
Hero checks.
Bollefranz checks.
busto_ bets [$ 10 USD]
Hero raises [$ 27 USD]
Bollefranz folds.
busto_ raises [$ 34 USD]
Hero is all-In.
busto_ is all-In.
** Dealing Turn ** [ Kc ]
** Dealing River ** [ 2h ]
busto_ shows [ As, Ah ]two pairs, Aces and Sevens.
Hero shows [ Qs, Qh ]two pairs, Queens and Sevens.
Hero wins $ 168.05 USD from side pot #1 with two pairs, Queens and Sevens.
busto_ wins $ 200.50 USD from the main pot with two pairs, Aces and Sevens.



Produces this line of output:
Quote:

[ 2007-04-04 10:36:28+02 ] [ Qs Qh ] [ As Ah ] [ 6h 7h 7d _ Kc 2h ] [ 0.0840 ] [ 368.55$ / 30.96$ / 168.05$ / +137.09$ ] [ NL $100 (6 max) ]



This is obviously wrong since I didn't win any money, yet it says I'm $137 above EV. The problem is caused by the PartyPoker handhistory's, that add "Uncalled bets" to the pot and gives it back through a side pot.

If you're up against short(er)stacks a lot, the output most likely produces a result that tells you you ran much hotter than you in fact did.





I have the same problem

Thanks for fixing


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


Reged: 02/24/07
Posts: 1448
Loc: weeee graduated
Re: Sklansky bucks calculator (php script) [Re: Mig]
      #9918757 - 04/12/07 06:47 AM

Big difference for me with the new version (and more accurate with my own expectations)

found 510 headsup allin situations
won: 313 lost: 135 tied: 62
average potsize: 92.37$
average ev: 0.6335
money won: 27006.17$
money expected (based on allin equity): 29745.86$
money difference: -2739.69$
max money diff: at +0.00$
min money diff: 2007-03-29 13:01:30+02 at -2865.44$
total_bet: 24917.94$


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]
      #9923398 - 04/12/07 02:46 PM

OK, the pre-beta is ready. Apologies for keeping everyone waiting.

I've left some features out that aren't quite ready for a broader release (the HH replayer, range calcs), but you'll be seeing them very soon. I don't want to keep you guys waiting any longer. At this time I'm limiting the beta to a couple of hundred testers as I haven't mapped out all the sites yet, and I really want to get the accuracy perfect before giving it to everyone.

I'd greatly appreciate if people can send me hand histories (hundreds or thousands of them)from non-tested sites so I can finish mapping out all the inaccuracies and issues with the PT database, then do a proper release. Best way is via email. At present you can run the program on any PokerTracker supported site but I can't guarantee it'll be accurate for all sites. Some sites (such as Prima, Ongame) don't save mucked showdown hands, so the results aren't very useful (and possibly completely wrong) on those sites.

I'll be adding a lot of new features shortly, including a much broader range of stats and the things mentioned above. For now, you can use the filtering system and the available stats to do a lot of analysis.

I've put up a site at http://www.pokerevsoftware.com, if you want to beta test you can leave a message in the forum on the site, email phil@pokerevsoftware.com, or PM me here and I'll send you the link. Priority goes to 2+2 software forum posters obviously . The program is free and I don't accept donations. Oh and for the really eager, you'll have to wait about 6 hours till I can reply ; it's 4am here.


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: Phil153]
      #9923685 - 04/12/07 03:06 PM

w00t

(Is w00t still cool btw? )


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


Reged: 12/07/06
Posts: 305
Re: Sklansky bucks calculator (php script) [Re: Jehaim]
      #9924428 - 04/12/07 03:55 PM

The php code mentioned is flawed. It includes situations where there are more than 2 people all-in and therefore overestimates your equity. The java code simply ignores multiway pots altogether. I hope the pokerevsoftware does better.

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]
      #9925909 - 04/12/07 05:33 PM

Phil, you are such a tease

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


Reged: 12/06/06
Posts: 140
Loc: Univ. Wisconsin-Madison
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9927290 - 04/12/07 07:12 PM

I have a few questions:

1. does the average ev number take into account that the pot sizes for each all in is different, or is it just a straight average of every all in situation?

2. what do money won, and money expected mean? my values are positive for those fields even though I have an ev of less than .50


average potsize: 86.44$
average ev: 0.3704
money won: 100.30$
money expected (based on allin equity): 153.90$
money difference: -53.60$
max money diff: at +0.00$
min money diff: 2007-04-12 18:34:04-04 at -53.60$
total_bet: 216.65$


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


Reged: 03/12/06
Posts: 109
Re: Sklansky bucks calculator (php script) [Re: CruNKinTILT]
      #9927645 - 04/12/07 07:36 PM

CrunkinTilt...

1. Avg ev is just a straight average...

2. Money won = $ won from those all ins... and $ expected is how much you were expected to win... so in your case you were expected to win $153.90 but only won $100.30. However the part you are missing is the total_bet : $216.65 which you minus from your $ won... and if you subtract that from $ won or expected you end up with negative # both times due to your avg ev below .5

Hope that makes sense..


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: ImsaKidd]
      #9929238 - 04/12/07 09:58 PM

Advisor:

I shipped you another $25 because this program is keeping me grounded in reality with regards to results. TY soso much.


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


Reged: 12/25/05
Posts: 610
Re: Sklansky bucks calculator (php script) [Re: ImsaKidd]
      #9932343 - 04/13/07 03:30 AM

When I run the script I get a pop up from pokernum.exe that says "This application has failed to start because MSVCR71.dll was not found. Re-installing the application may fix this problem."

Any idea what could be causing this?


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


Reged: 11/08/05
Posts: 1917
Re: Sklansky bucks calculator (php script) [Re: Leobzook]
      #9932777 - 04/13/07 04:35 AM

Still unable to download the script. Can anyone help me out?

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


Reged: 02/24/07
Posts: 1448
Loc: weeee graduated
Re: Sklansky bucks calculator (php script) [Re: PatInTheHat]
      #9933993 - 04/13/07 08:34 AM

Phil, I am SO impressed by your program. Just started testing it out and it's great to see what my actual winrate should be Great 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: Rainclouds]
      #9934452 - 04/13/07 09:38 AM

Hey,
I'll test this out Phil, let me know how.


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


Reged: 12/23/06
Posts: 258
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9934780 - 04/13/07 10:20 AM

Quote:

http://rapidshare.com/files/25520091/AllinCalc_v0.5.zip.html

i "fixed" some small stuff, hope it still works right
now i substract the total_bet difference between hero and villain off the pot and off total_won, should make for some more accurate numbers i guess.

debug_mode=1 shows hand history for every hand




This is so so incredibly hot. This is my last month of poker:



And It might just have something to do with this:

money won: 59094.90$
money expected (based on allin equity): 63226.95$
money difference: -4132.05$

when I break even I'll ship some money


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


Reged: 08/30/04
Posts: 1076
Re: Sklansky bucks calculator (php script) [Re: Leobzook]
      #9940584 - 04/13/07 05:36 PM

Quote:

When I run the script I get a pop up from pokernum.exe that says "This application has failed to start because MSVCR71.dll was not found. Re-installing the application may fix this problem."

Any idea what could be causing this?




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: tmfs]
      #9941195 - 04/13/07 06:30 PM

i guess you are missing the following file: MSVCR71.dll
google it up and put it into windows/system or system32 dir



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


Reged: 11/08/05
Posts: 1917
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #9947126 - 04/14/07 05:48 AM

I always thought i ran bad... to the tune of 10k =[

found 1912 headsup allin situations
won: 1179 lost: 613 tied: 120
average potsize: 258.63$
average ev: 0.5944
money won: 289048.30$
money expected (based on allin equity): 298156.57$
money difference: -9108.27$
max money diff: 2006-12-20 20:22:45-07 at +743.40$
min money diff: 2007-04-11 15:36:00-06 at -10348.80$
total_bet: 261833.42$


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]
      #9947588 - 04/14/07 07:40 AM

be very careful with the numbers, since pots with sidepots are bugged + the query has many more flaws
take them only as a very general idea of how good/bad you are running


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


Reged: 09/24/06
Posts: 205
Re: Sklansky bucks calculator (php script) [Re: Toasta]
      #9948055 - 04/14/07 09:56 AM

Quote:

cant get it to work,

PT and other tools are working fine with my dbs.

latest postgres.

settings.txt :

db_host = localhost
db_name = PARTYPOKER[2007]-PLAYED
db_user = postgres
db_pwd = postgres
screenname = Heroname
filter_date = 2007-01-01
filter_stake = none
filter_maxev = 1.0
filter_minev = 0.0
debug_mode = 0

Output.txt :

-- listing properties --
filter_date=2007-01-01
filter_minev=0.0
db_name=PARTYPOKER[2007]-PLAYED
filter_maxev=1.0
db_user=postgres
filter_stake=none
debug_mode=0
screenname=heroname
db_host=localhost
db_pwd=postgres

SQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
SQLState: 08004
VendorError: 0

whut to do ?

/edit : running Postgres 8.2.3, also tested it the postgresql-8.2-504.jdbc4.jar




*still looking for help*


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


Reged: 10/03/05
Posts: 108
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #9965700 - 04/15/07 08:00 PM

Any updates on this?

Post Extras: Print Post   Remind Me!   Notify Moderator  
Split Suit
Carpal \'Tunnel


Reged: 05/23/06
Posts: 2590
Loc: Forever Downswinging
Re: Sklansky bucks calculator (php script) [Re: britdevine]
      #9966917 - 04/15/07 09:26 PM

Phil...id like to try to ur program ouut. either PM me, or AIM: jaecurse

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


Reged: 10/18/05
Posts: 4905
Re: Sklansky bucks calculator (php script) [Re: britdevine]
      #9967037 - 04/15/07 09:35 PM

Quote:

Any updates on this?



It's still in testing with about 100 beta users; once I'm happy with accuracy/bugs I'll make the beta publicly available. I don't want people getting bogus results. It'll be under two weeks.


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


Reged: 03/02/06
Posts: 451
Re: Sklansky bucks calculator (php script) [Re: Split Suit]
      #9967086 - 04/15/07 09:40 PM

Hey Phil,

You sent me the link originally but I haven't recieved the password since you protected the d/l. Could you please pm me with it, i'm anxious to use the program. Thanks.


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


Reged: 10/01/06
Posts: 448
Loc: Portland
Re: Sklansky bucks calculator (php script) [Re: numbnuts007]
      #9967660 - 04/15/07 10:25 PM

hey phil, will your version be SNG compatible at all? or is it cash strictly?

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


Reged: 10/03/05
Posts: 108
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #9979453 - 04/16/07 05:35 PM

Quote:

Quote:

Any updates on this?



It's still in testing with about 100 beta users; once I'm happy with accuracy/bugs I'll make the beta publicly available. I don't want people getting bogus results. It'll be under two weeks.




Thx


Post Extras: Print Post   Remind Me!   Notify Moderator  
Unknown Soldier
Carpal \'Tunnel


Reged: 09/14/06
Posts: 8587
Re: Sklansky bucks calculator (php script) [Re: britdevine]
      #10008952 - 04/18/07 11:18 AM

db_host = localhost
db_name = PTPGSQL1
db_user = postgres
db_pwd = ?????
screenname = myname
filter_date = 2007-04-01
filter_stake = ($0.5/$1.00)


is the rest right? Password to what?


Post Extras: Print Post   Remind Me!   Notify Moderator  
HP
Carpal \'Tunnel


Reged: 10/22/04
Posts: 2783
Loc: DZ-015
Re: Sklansky bucks calculator (php script) [Re: Unknown Soldier]
      #10009143 - 04/18/07 11:35 AM

sounds like you don't have a Postgre SQL database. Do you?

If not, go to poker tracker forums to find out how to get it


Post Extras: Print Post   Remind Me!   Notify Moderator  
Unknown Soldier
Carpal \'Tunnel


Reged: 09/14/06
Posts: 8587
Re: Sklansky bucks calculator (php script) [Re: HP]
      #10009270 - 04/18/07 11:45 AM

well probably not, since I don't know what it is I'll try the forums 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: braminc]
      #10009621 - 04/18/07 12:12 PM

Quote:

hey phil, will your version be SNG compatible at all? or is it cash strictly?



It wouldn't be hard to add SNGs, all the framework is there and the database tables are similar. But I don't know how useful you guys would find it without extra work such as factoring in $EV from chip EV, adding a heap of filters and providing other stats. But I'm happy to do the basics after the cash game beta, and get some feedback on what else you want. Perhaps someone else like Juk can develop it after that.


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


Reged: 11/21/02
Posts: 1084
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #10010435 - 04/18/07 01:18 PM

Quote:

Quote:

hey phil, will your version be SNG compatible at all? or is it cash strictly?



It wouldn't be hard to add SNGs, all the framework is there and the database tables are similar. But I don't know how useful you guys would find it without extra work such as factoring in $EV from chip EV, adding a heap of filters and providing other stats. But I'm happy to do the basics after the cash game beta, and get some feedback on what else you want. Perhaps someone else like Juk can develop it after that.




Phil, I think adding SNGs and Tourney functionality would be nice (I would keep it simple at first and then deal with some of the unique situations if you felt inclined.). I am just starting to use the beta, and my reaction so far is that this is an absolutely outstanding piece of software. For those that don't have it yet, look out for the release because Phil has come up with something special. I will try to provide more insightful feedback after I get a chance to delve into it more.

One thing I would change is the requirement to click 2 buttons to load the hands and then read the hands. I'd like a one-click version so I could check how I'm doing during a session. Another really cool feature would be to track the hands as your playing a session automatically and spit out your EV after showdown hands occur.

I also found some bugs when trying to do certain graphing functions (it basically plopped up the Visual Studio error message, but then let me keep on using it).

Bottom line: its fantastic and can't wait to seeing what I can do to help you improve it even more.

Toast


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


Reged: 10/18/05
Posts: 4905
Re: Sklansky bucks calculator (php script) [Re: YoureToast]
      #10011192 - 04/18/07 02:05 PM

Toast,

Thanks! Glad you find it useful.

Just a note: for you and anyone else using it, I've found a couple of bugs in the calculation of SB in a few specific situations, which may throw out your aggregate results. Most NetSB results will be correct but some won't be. I made a post in the forum about it. So just be cautious about the results for a couple of days until the next private version comes out.


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


Reged: 01/11/06
Posts: 651
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #10014472 - 04/18/07 05:48 PM

What's the syntax for the stakes in the settings file?

Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10015346 - 04/18/07 06:47 PM

Quote:

postgresql-8.2-504.jdbc3.jar not found




Any ideas ? I just installed teh newest Java Runtime 6.1.


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: ImsaKidd]
      #10015836 - 04/18/07 07:27 PM

Punter, you need the other two linkes in this quote (copy them in to tha allincalc folder)

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






Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: _dave_]
      #10016689 - 04/18/07 08:25 PM

Thanks very much. Its awesome ! and I was running bad :-) (-15k).
Is it possible to graph it ?


Post Extras: Print Post   Remind Me!   Notify Moderator  
HP
Carpal \'Tunnel


Reged: 10/22/04
Posts: 2783
Loc: DZ-015
Re: Sklansky bucks calculator (php script) [Re: punter11235]
      #10019760 - 04/18/07 11:59 PM

for punter et all

I would recomend taking the time to set up wildzer0's php script, since it takes into account side pot hands

As advis0r himself has said, his program does not. However it is much easier to use


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: ata]
      #10019843 - 04/19/07 12:06 AM

Quote:

What's the syntax for the stakes in the settings file?




Type none and run it that way. Check the output and copy/past it from there. No brackets or anything.


Post Extras: Print Post   Remind Me!   Notify Moderator  
jukofyork
Carpal \'Tunnel


Reged: 09/16/04
Posts: 2551
Loc: Leeds, UK.
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #10022003 - 04/19/07 03:35 AM

Quote:

Quote:

hey phil, will your version be SNG compatible at all? or is it cash strictly?



It wouldn't be hard to add SNGs, all the framework is there and the database tables are similar. But I don't know how useful you guys would find it without extra work such as factoring in $EV from chip EV, adding a heap of filters and providing other stats. But I'm happy to do the basics after the cash game beta, and get some feedback on what else you want. Perhaps someone else like Juk can develop it after that.



Cool, it would be very interesting to see how it works for SNGs. Sometimes it's pretty hard to tell if you're having a massive downswing because you're just having bad luck on crucial all-ins, or whether you've started tilting and playing sub-optimally. Also, if you try out something new and try to adjust your strategy slightly then it takes 1000s of SNGs before you can begin to factor out the luck... Perhaps something like this would let you test ideas and plug possible leaks much quicker?

As far as going from chip EV to $EV, then it's actually fairly simple to implement a recursive ICM function and I don't think it would be too hard to map between the two equities, eg:

If you got all-in in a cash game with $100 as a 60/40 favorite, then your "Sklansky Bucks" stack after that all-in would be:

100 + 0.6*100 - 0.4*100 = $120

but in a SNG if you got all-in vs another player for 100 chips (assuming even stacks) as a 60/40 favorite then you would work out your $EV using ICM for the case where you won (ie: you get 200 chips and he busts) and work out your $EV for the case where you lost (ie: you lose/bust-out [and he gets the 200 chips]) and then take the weighted average of the two outcomes:

0.6*$EV_Win + 0.4*$EV_Lose

You have to do this because the ICM model in non-linear, and thus you can't just run ICM once on the "average" outcome (ie: you having a stack of 120 and your opponent having a stack of 80).

My example ignores ties and there were only two players involved in the hand, but if you have more than two players you will need to weight each possible outcome correctly and the tree of possibilities grows exponentially as you add more and more players... Even so, I don't think in practice this would cause too many problems as the vast majority of all-ins will only involve 2/3 players.

Juk


Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: jukofyork]
      #10024718 - 04/19/07 10:42 AM

Hmm are you sure it working correctly ?
I am running it on my db's and I am unlucky in all of them


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


Reged: 04/12/07
Posts: 29
Loc: France
Re: Sklansky bucks calculator (php script) [Re: punter11235]
      #10026437 - 04/19/07 12:53 PM

SQLException: FATAL: password authentication failed for user "postgres"
SQLState: 28000
VendorError: 0

where do I find/change this password? I have no idea what it is


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


Reged: 10/01/06
Posts: 448
Loc: Portland
Re: Sklansky bucks calculator (php script) [Re: jukofyork]
      #10028599 - 04/19/07 03:06 PM

Quote:

Quote:

Quote:

hey phil, will your version be SNG compatible at all? or is it cash strictly?



It wouldn't be hard to add SNGs, all the framework is there and the database tables are similar. But I don't know how useful you guys would find it without extra work such as factoring in $EV from chip EV, adding a heap of filters and providing other stats. But I'm happy to do the basics after the cash game beta, and get some feedback on what else you want. Perhaps someone else like Juk can develop it after that.



Cool, it would be very interesting to see how it works for SNGs. Sometimes it's pretty hard to tell if you're having a massive downswing because you're just having bad luck on crucial all-ins, or whether you've started tilting and playing sub-optimally. Also, if you try out something new and try to adjust your strategy slightly then it takes 1000s of SNGs before you can begin to factor out the luck... Perhaps something like this would let you test ideas and plug possible leaks much quicker?

As far as going from chip EV to $EV, then it's actually fairly simple to implement a recursive ICM function and I don't think it would be too hard to map between the two equities, eg:

If you got all-in in a cash game with $100 as a 60/40 favorite, then your "Sklansky Bucks" stack after that all-in would be:

100 + 0.6*100 - 0.4*100 = $120

but in a SNG if you got all-in vs another player for 100 chips (assuming even stacks) as a 60/40 favorite then you would work out your $EV using ICM for the case where you won (ie: you get 200 chips and he busts) and work out your $EV for the case where you lost (ie: you lose/bust-out [and he gets the 200 chips]) and then take the weighted average of the two outcomes:

0.6*$EV_Win + 0.4*$EV_Lose

You have to do this because the ICM model in non-linear, and thus you can't just run ICM once on the "average" outcome (ie: you having a stack of 120 and your opponent having a stack of 80).

My example ignores ties and there were only two players involved in the hand, but if you have more than two players you will need to weight each possible outcome correctly and the tree of possibilities grows exponentially as you add more and more players... Even so, I don't think in practice this would cause too many problems as the vast majority of all-ins will only involve 2/3 players.

Juk




juk, thats a great point about possible finding leaks and things much more quickly that having to play over 1000 sngs to see how your roi is affected. if this ever does come about i would be THRILLED and more than willing to shell out some $$


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: HP]
      #10032799 - 04/19/07 07:23 PM

Quote:

for punter et all

I would recomend taking the time to set up wildzer0's php script, since it takes into account side pot hands

As advis0r himself has said, his program does not. However it is much easier to use




i started my program as a copy of the php script.
the reason i filtered out multiway allins (more than 2 people go to showdown) is because the pot size was being used to calculate your equity in the php script.

code:
$equity = $ev * $pot;
...
$all_equity += $equity;

also, even if it finds multiway allins, the calculation of your pot equity only uses 1 opponents hand.

code:
$exec_string = "pokenum -h " . $my_hole_card_1 . " " . $my_hole_card_2 . " - " . $v_hole_card_1 . " " . $v_hole_card_2;

so if you are allin preflop with 10$ against 2 players and the final pot is 1000$, your equity will be completely wrong since $ev is versus 1 player only and multiplied with the total potsize.

so actually, the php script is even more inaccurate by taking sidepots into consideration

i could completely rework my program and make sure sidepots are considered 100% accurately, but Phils program is great already - so everybody better wait for him to release it and dont conclude too much from the results u get from the scripts in this thread.

when checking if you are running bad or playing bad there is ONE SIMPLE AND COMPLETE CONCLUSION: always play your best and always look to improve your game

Edited by advis0r (04/19/07 07:26 PM)


Post Extras: Print Post   Remind Me!   Notify Moderator  
1p0kerboy
Carpal \'Tunnel


Reged: 11/14/03
Posts: 6026
Loc: 492k
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10033067 - 04/19/07 07:39 PM

I'm looking forward to this.

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


Reged: 03/07/06
Posts: 476
Re: Sklansky bucks calculator (php script) [Re: 1p0kerboy]
      #10035987 - 04/19/07 11:16 PM

SQLException: ERROR: relation "game" does not exist
SQLState: 42P01
VendorError: 0

Any ideas?


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


Reged: 04/14/06
Posts: 2115
Loc: value shoving
Re: Sklansky bucks calculator (php script) [Re: Musgale]
      #10036281 - 04/19/07 11:35 PM

Quote:

SQLException: FATAL: password authentication failed for user "postgres"
SQLState: 28000
VendorError: 0

where do I find/change this password? I have no idea what it is




It's the password you entered when you first installed PostgreSQL. I forget exactly, but postgres may also be the password by default. If that doesn't work, look at the PostgreSQL installation FAQ on the Poker Tracker website and it may help you remember what you entered.


Post Extras: Print Post   Remind Me!   Notify Moderator  
MyTurn2Raise
The drug-free MVP


Reged: 06/28/05
Posts: 18508
Loc: Evolving Day-By-Day
Re: Sklansky bucks calculator (php script) [Re: Musgale]
      #10038816 - 04/20/07 04:06 AM

Quote:

SQLException: FATAL: password authentication failed for user "postgres"
SQLState: 28000
VendorError: 0

where do I find/change this password? I have no idea what it is




how to get your password


Post Extras: Print Post   Remind Me!   Notify Moderator  
Reef
Carpal \'Tunnel


Reged: 07/31/04
Posts: 13198
Loc: PCPforums
Re: Sklansky bucks calculator (php script) [Re: MyTurn2Raise]
      #10038908 - 04/20/07 04:22 AM

What would be awesome if this thing could calculate the total BY STREET.. might get complicated but is probably possible.

Post Extras: Print Post   Remind Me!   Notify Moderator  
Cashane
stranger


Reged: 01/22/06
Posts: 22
Re: Sklansky bucks calculator (php script) [Re: Reef]
      #10039783 - 04/20/07 07:51 AM

Nice little program, but with not really any practical use, unless I missed something?
If I understand correctly how this works, a player who steals 3 120$ pots at turn (with semi-bluffs or pure bluffs, ie most likely without the best hand, winning 70$ everytime) and then gets caught on his 4th turn shove with a flush draw vs a set and sucks out and wins a 350$ pot (meaning he'd lose 170$ 80ish% of the time and wins 180 20ish%), will be noted as running very good but being a bad player?

And also, the player who reraises "almost all in" preflop for 199$ with AA vs KK and notices he didn't put his last 1$ and pushes it on flop, where a K showed up, will be considered a bad player (even though for a very small amount) and running very good if A shows on turn?

And as a last point, the player who sucks out a few times during a month, and didn't get sucked out once, but who on the other hand found himself thrice in a set vs overset situation, and twice in KK vs AA etc.. and never the reverse, will be considered as running good?

Basically I think the only thing this program shows is wether you're rather conservative (or weak) about going all in or not, compared to your average opponents. Which absolutely doesn't mean you're better than them .

Still a nice program but, but I thought it might be useful to mention its results don't really mean much .

Even if somehow you could get hands history where you see what every player has even when there is no showdown, it still would be nearly impossible to make a program that tests wether you run good or not (because running good/bad isn't only about losing or not when you put the money while ahead.. there is the frequency of various setups, there is the frequency at which you hit your flop, etc..).


Post Extras: Print Post   Remind Me!   Notify Moderator  
stinkypete
world-class ratholer


Reged: 07/26/04
Posts: 5723
Loc: lost my luckbox
Re: Sklansky bucks calculator (php script) [Re: Reef]
      #10046867 - 04/20/07 06:05 PM

Quote:

What would be awesome if this thing could calculate the total BY STREET.. might get complicated but is probably possible.




that would be completely useless. it would tell you nothing, because so much information is lost on hands that don't go to showdown.


Post Extras: Print Post   Remind Me!   Notify Moderator  
stinkypete
world-class ratholer


Reged: 07/26/04
Posts: 5723
Loc: lost my luckbox
Re: Sklansky bucks calculator (php script) [Re: Cashane]
      #10046915 - 04/20/07 06:08 PM

Quote:

Nice little program, but with not really any practical use, unless I missed something?
If I understand correctly how this works, a player who steals 3 120$ pots at turn (with semi-bluffs or pure bluffs, ie most likely without the best hand, winning 70$ everytime) and then gets caught on his 4th turn shove with a flush draw vs a set and sucks out and wins a 350$ pot (meaning he'd lose 170$ 80ish% of the time and wins 180 20ish%), will be noted as running very good but being a bad player?

And also, the player who reraises "almost all in" preflop for 199$ with AA vs KK and notices he didn't put his last 1$ and pushes it on flop, where a K showed up, will be considered a bad player (even though for a very small amount) and running very good if A shows on turn?




this program doesn't attempt to determine whethere you're a good or bad player. it just tells you how you're running on all in pots.

Quote:

And as a last point, the player who sucks out a few times during a month, and didn't get sucked out once, but who on the other hand found himself thrice in a set vs overset situation, and twice in KK vs AA etc.. and never the reverse, will be considered as running good?




it only considers how you're running after the money goes in.

Quote:

Basically I think the only thing this program shows is wether you're rather conservative (or weak) about going all in or not, compared to your average opponents. Which absolutely doesn't mean you're better than them .




no, it shows how you're running on all in pots after the money goes in.

Quote:

Still a nice program but, but I thought it might be useful to mention its results don't really mean much .




the results mean a lot.

Quote:

Even if somehow you could get hands history where you see what every player has even when there is no showdown, it still would be nearly impossible to make a program that tests wether you run good or not (because running good/bad isn't only about losing or not when you put the money while ahead.. there is the frequency of various setups, there is the frequency at which you hit your flop, etc..).




you're missing the point of the program. it's not to calculate how you're running. it's to calculate how you're running on all in pots after the money goes in.


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


Reged: 02/24/07
Posts: 1448
Loc: weeee graduated
Re: Sklansky bucks calculator (php script) [Re: Reef]
      #10047813 - 04/20/07 07:16 PM

Quote:

What would be awesome if this thing could calculate the total BY STREET.. might get complicated but is probably possible.



Phil153's program does this.


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


Reged: 02/24/07
Posts: 1448
Loc: weeee graduated
Re: Sklansky bucks calculator (php script) [Re: stinkypete]
      #10047837 - 04/20/07 07:17 PM

Quote:

Quote:

What would be awesome if this thing could calculate the total BY STREET.. might get complicated but is probably possible.




that would be completely useless. it would tell you nothing, because so much information is lost on hands that don't go to showdown.



But it does tell EVERYTHING about hands that did went to showdown. I wouldn't call that 'completely useless'. In fact, it's 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: Cashane]
      #10048747 - 04/20/07 08:30 PM

Quote:

Nice little program, but with not really any practical use, unless I missed something?...etc




This can give some kind of indication of skill over a large sample size but the primary reason I wrote this program was a sanity check. If your not consistently making really dumb mistakes like leaving a dollar behind, etc. you can get a decent idea of the sort of equity you have going in, and the total amount you bet vs your total equity is pretty interesting too I think. I especially like the total bet vs. total equity figure because if you have a bunch of hands vs very short stacks where you're might not be a favorite but you're geting good odds to call, it could skew your average ev, but your total bet vs. total equity will reflect that.

I dunno, this is basically a nice little toy, I wouldn't infer a huge amount of meaning for it (especially since, as people have pointed out, it's not 100% accurate) - I find it hugely helpful for my sanity though.

BTW, I haven't really participated much in this thread because I was being absolutely swamped with suppo rt requests. In general, I was annoyed by the tone of a lot of them (several people rudely demanded help and bitched me out about whatever perceived flaws they saw or problems they had) - it doesn't really encourage me to post this sort of stuff as I don't get anything out it but headaches. If you're still having trouble, just wait. Phil's program will make you wet your pants. Seriously this guy's [censored] amazing.

Edited by wildzer0 (04/20/07 08:37 PM)


Post Extras: Print Post   Remind Me!   Notify Moderator  
1p0kerboy
Carpal \'Tunnel


Reged: 11/14/03
Posts: 6026
Loc: 492k
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #10049764 - 04/20/07 10:05 PM

Question:

When I download the necessary files, how do I put them in the same folder together?

Edited by 1p0kerboy (04/20/07 10:07 PM)


Post Extras: Print Post   Remind Me!   Notify Moderator  
1p0kerboy
Carpal \'Tunnel


Reged: 11/14/03
Posts: 6026
Loc: 492k
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #10054839 - 04/21/07 09:16 AM

I am getting UnsupportedClassVersionError.

Help?


Post Extras: Print Post   Remind Me!   Notify Moderator  
Cashane
stranger


Reged: 01/22/06
Posts: 22
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #10056918 - 04/21/07 02:07 PM

Quote:


I dunno, this is basically a nice little toy, I wouldn't infer a huge amount of meaning for it (especially since, as people have pointed out, it's not 100% accurate) - I find it hugely helpful for my sanity though.




Aye, I shouldn t have said it's not very useful. It is, actually .
Good to know I m only at .55, probably means I gamble a bit too often when my fe isn't big enough. And from the screenshots seen so far the one of phil seems even more interesting.

I just posted that because there were many posts of ppl deducing from the results that they were running good or bad. The part where luck has the biggest role in NLHE (and maybe poker in general) is the fact of having rushes at the right time and facing the right hands, IMO.


Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: Cashane]
      #10061466 - 04/21/07 09:22 PM

Anybody got +sklansky bucks score over some decent sample ?
Either I am really unlucky last months or the script have some serious bugs. I tried to verify by hand if it calcute the scores correctly and it seems ok (checked only a few pots though).


Post Extras: Print Post   Remind Me!   Notify Moderator  
MyTurn2Raise
The drug-free MVP


Reged: 06/28/05
Posts: 18508
Loc: Evolving Day-By-Day
Re: Sklansky bucks calculator (php script) [Re: punter11235]
      #10062094 - 04/21/07 10:12 PM

I'm plus


looks like I'll have to look elsewhere for excuses


Post Extras: Print Post   Remind Me!   Notify Moderator  
prodonkey
Carpal \'Tunnel


Reged: 10/12/06
Posts: 5993
Loc: underrating women on teh inter...
Re: Sklansky bucks calculator (php script) [Re: MyTurn2Raise]
      #10063026 - 04/21/07 11:29 PM

I'm having a problem when you start to run AllinCalc

it says java.lang.classnotfoundexception: org.postgresql.driver
at java.net.urlclassloader$1.run<unknown Source>
at java.security.accesscontroller.doprivleged<native method>
at java.net.urlclassloader.findclass<unknown source>

it goes on for a few more lines.. I'm assuming the top one is the important one showing that it's not recognizing my postgresql driver? How do I fix this?


Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: prodonkey]
      #10063651 - 04/22/07 12:27 AM

I am pretty sure something is wrong with the calcs.
I run them for many plaeyrs from my DB (unfortunately I dont have any huge db in handy) and most of them are in big minus and only rare are at small plus. I dont know what teh problem is yet but I think there is 99.5% chance that the results are not correct.


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


Reged: 10/26/05
Posts: 947
Loc: Running bad, playing worse
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #10063901 - 04/22/07 12:53 AM

I'm having a weird issue with the Java one. It works fine with one of my screen names but not with another. At ifrst I thought it was because the second was an alias under the first, but I tried taking off the alias, and I'm still getting this:


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$
max money diff: at +0.00$
min money diff: at +0.00$
total_bet: 0.00$


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


Reged: 12/06/05
Posts: 1950
Re: Sklansky bucks calculator (php script) [Re: poisonxfree]
      #10066014 - 04/22/07 07:03 AM

Using advisors program, I am -4k in expectation over about 95k hands of 200nl. This would mean that during this time period, my 'true winrate' is about 30% higher than the winrate I have. I kind of think this is unlikely, even though I think I have definitely been running bad my whole life.

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: wrschultz]
      #10067732 - 04/22/07 12:28 PM

I can't really vouch for advisor's program, I haven't looked at the source code. I know the php script has been extensively tested and seems to be reasonably accurate.

Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #10067908 - 04/22/07 12:49 PM

Quote:

I can't really vouch for advisor's program, I haven't looked at the source code. I know the php script has been extensively tested and seems to be reasonably accurate.




Ok, Java program makes simple mistakes. I dont know what the issue is but here is an example :

[ 2007-04-22 12:13:22+02 ] [ 5s 4s ] [ Ad Ac ] [ 2h 8h 5d _ 6c Th ] [ 0.2120 ] [ 927.40$ / 196.61$ / -213.80$ / -410.41$ ] [ NL $400 ]

In that pot we went allin on the flop and my equity was 0.2120 which is correct but the pot was 1144$ so I got unlucky for 242$ not 410$.
Any chances to get it fixed ?


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]
      #10068920 - 04/22/07 02:31 PM

Quote:

I know the php script has been extensively tested and seems to be reasonably accurate.




about the accuracy: did you read my post on page 20 ? i think its pretty wrong for multiway-allins and also when someone bets more than his opponent has it comes up with wrong numbers (regarding final potsize and thus equity)

as i said earlier in the thread, i know the query/program has flaws and i could fix them all but lets just wait for phil to release his program so work hasnt to be done twice


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


Reged: 10/26/05
Posts: 947
Loc: Running bad, playing worse
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #10069289 - 04/22/07 03:05 PM

Quote:

I can't really vouch for advisor's program, I haven't looked at the source code. I know the php script has been extensively tested and seems to be reasonably accurate.




I'm getting divide by zero on line 125 of the php script. Here is exactly how I have the inputs set up [maybe some of them shouldn't be in quotes?].:

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

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

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

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


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: punter11235]
      #10069452 - 04/22/07 03:19 PM

Quote:

Ok, Java program makes simple mistakes. I dont know what the issue is but here is an example :

[ 2007-04-22 12:13:22+02 ] [ 5s 4s ] [ Ad Ac ] [ 2h 8h 5d _ 6c Th ] [ 0.2120 ] [ 927.40$ / 196.61$ / -213.80$ / -410.41$ ] [ NL $400 ]

In that pot we went allin on the flop and my equity was 0.2120 which is correct but the pot was 1144$ so I got unlucky for 242$ not 410$.
Any chances to get it fixed ?




the 3rd numbers should never be negative (since its amount won -> 0 or more).

try this version and tell me if this still occures, i did improve some other stuff too but still not 100% accurate

http://rapidshare.com/files/27373991/AllinCalc_v0.6.zip.html


Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10069594 - 04/22/07 03:31 PM

I got null pointer exception when trying to run this one.
It would be awesome if you could fix it beacuse your script display all the pots in output and thats awesome feature.


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: punter11235]
      #10069693 - 04/22/07 03:39 PM

can you post the whole error message?

Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10069745 - 04/22/07 03:42 PM

Exception in thread "main" java.lang.NullPointerException at AllinCalc.main(AllinCalc.java:77)

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: punter11235]
      #10069790 - 04/22/07 03:44 PM

use the settings.txt that comes along in the 0.6 and adjust it, dont use your old one.

Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10069802 - 04/22/07 03:45 PM

Ok, give me 2minutes

Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: punter11235]
      #10069880 - 04/22/07 03:49 PM

I will check the calcs by hand later (Iam leaving in 30minutes) but it seems that its working now (it gives correct scores for previous mentioned pot). THanks for the update

Post Extras: Print Post   Remind Me!   Notify Moderator  
HP
Carpal \'Tunnel


Reged: 10/22/04
Posts: 2783
Loc: DZ-015
Re: Sklansky bucks calculator (php script) [Re: FluffyTiger]
      #10083531 - 04/23/07 01:06 PM

Quote:


when I break even I'll ship some money




er, I ended up using wildzer0's since it can calculate side pots correctly. Since I broke even, I'd like to ship you some monies wildzer0, do you have UB or Neteller? you can PM me if you prefer


Post Extras: Print Post   Remind Me!   Notify Moderator  
schwza
Carpal \'Tunnel


Reged: 04/02/03
Posts: 10485
Loc: get more chips than chips ahoy
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #10084870 - 04/23/07 02:42 PM

do any of these programs work if you're not using postgre? i'm playing stars if that matters. thanks.

also, i'm just looking for equity once you're all-in in a heads up pot, i don't need to know street-by-street equity.


Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: schwza]
      #10085632 - 04/23/07 03:29 PM

One more bug (in java version) : the script accounts for rake while calculating (EV - actual result). It adds up for a lot if there are a lot of pots.

Example :
Ah Jd ] [ Ad Kd ] [ _ 9h Tc Jc 6s 7h ] [ 0.2510 ] [ 62.00$ / 15.56$ / 59.00$ / +43.44$ ]

"wins 59$" should be 62$ because if we will deduct rake here it will cause results to be lower than actual "luck". (Being raked isnt being unlucky.. or is it ?)

Edited by punter11235 (04/23/07 03:32 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: punter11235]
      #10086488 - 04/23/07 04:22 PM

we had the rake discussion earlier in this thread. the funny thing is: some hands show up correctly with the rake being substracted from the total potsize and others dont. this seems to vary from site to site. two example hands from by db:
[ 2006-12-20 18:04:23+01 ] [ Ah As ] [ Js Jd ] [ _ 5h Kh 3c 8d 3d ] [ 0,8110 ] [ 192,50$ / 156,12$ / 189,50$ / +33,38$ ] [ NL ($0.50) (6 max) ]
rake: 3.0
the rake is not being substracted

[ 2007-04-11 16:39:49+02 ] [ Ad Ac ] [ Ks Qc ] [ 2d Kd 3h _ 5c 9d ] [ 0,8240 ] [ 95,40$ / 78,61$ / 95,40$ / +16,79$ ] [ NL $100 (6 max) ]
rake: 3.0
the rake is being substracted

so Pokertracker seems to vary its "storing policy". Phil had to write lots of code to work around those inconsistencies. so it aint a "bug" in my program ;P

but thanks for rechecking the hands "by hand", you might want to use debugmode=1 (prints HHs) or =2 (prints HHs and more) to do your checking


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


Reged: 08/11/05
Posts: 2168
Re: Sklansky bucks calculator (php script) [Re: punter11235]
      #10086689 - 04/23/07 04:33 PM

Quote:

One more bug (in java version) : the script accounts for rake while calculating (EV - actual result). It adds up for a lot if there are a lot of pots.

Example :
Ah Jd ] [ Ad Kd ] [ _ 9h Tc Jc 6s 7h ] [ 0.2510 ] [ 62.00$ / 15.56$ / 59.00$ / +43.44$ ]

"wins 59$" should be 62$ because if we will deduct rake here it will cause results to be lower than actual "luck". (Being raked isnt being unlucky.. or is it ?)




I figure that most of my all-ins make a $60 pot and so $3 in rake. Call it an average or $2.50 and I win 60% of them so taking $1.50/pot ($2.5*0.60) gives me an idea of how much to adjust the the difference to account for rake?


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: mikechops]
      #10086841 - 04/23/07 04:41 PM

i made a quick fix that will substract the rake from the potsize if total_won+rake == potsize. this should fix this special situation ;P

http://rapidshare.com/files/27557853/AllinCalc_v0.7.zip.html

and yes, it only works with a postgres db


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


Reged: 09/12/06
Posts: 305
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10101750 - 04/24/07 02:55 PM

Any other place to get this besides RapidShare. It tells me this?

You have requested http://rapidshare.com/files/27557853/AllinCalc_v0.7.zip (11 KB)
Your IP-address xxx is already downloading a file. You have to wait until it is finished.
Premium-accounts can download many files at the same time. Get your own Premium-Account now. Instant download-access!
If you are not downloading anything, you are using a proxy-server or a shared IP-address. A Premium-account solves this problem as well.


Post Extras: Print Post   Remind Me!   Notify Moderator  
jukofyork
Carpal \'Tunnel


Reged: 09/16/04
Posts: 2551
Loc: Leeds, UK.
Re: Sklansky bucks calculator (php script) [Re: ematz]
      #10103480 - 04/24/07 05:05 PM

Quote:

Any other place to get this besides RapidShare. It tells me this?

You have requested http://rapidshare.com/files/27557853/AllinCalc_v0.7.zip (11 KB)
Your IP-address xxx is already downloading a file. You have to wait until it is finished.
Premium-accounts can download many files at the same time. Get your own Premium-Account now. Instant download-access!
If you are not downloading anything, you are using a proxy-server or a shared IP-address. A Premium-account solves this problem as well.



This happens because your ISP is using a transparent proxy server and as far as I know their is no way round it (I get this too).

Juk


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: jukofyork]
      #10103855 - 04/24/07 05:27 PM

another download link for v0.7:
http://www.megaupload.com/?d=K4T6G90G


Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10108938 - 04/24/07 10:10 PM

There are some concerns if the script is clean ? Is there any way we can be sure ?

Post Extras: Print Post   Remind Me!   Notify Moderator  
-zero-
OHgasmic


Reged: 02/24/06
Posts: 5071
Loc: Busting shortstackers
Re: Sklansky bucks calculator (php script) [Re: punter11235]
      #10110125 - 04/24/07 11:34 PM

Quote:

There are some concerns if the script is clean ? Is there any way we can be sure ?




I was just about to download it and now you scared me.


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: punter11235]
      #10113013 - 04/25/07 03:55 AM

Quote:

There are some concerns if the script is clean ? Is there any way we can be sure ?




what concerns do you mean? the posts by emats and jukofyork?
they're discussing general problems associated with downloading files from rapidshare


Post Extras: Print Post   Remind Me!   Notify Moderator  
punter11235
Carpal \'Tunnel


Reged: 03/06/05
Posts: 3239
Loc: Check out my blog
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10113648 - 04/25/07 05:40 AM

Quote:

what concerns do you mean?




My only concern is that people in general are careful when downloading things from unknown source. I am using the script every day since you publish it and I am pretty sure its safe. I am not a programmer but I think its about impossible to code something malicious in java still somebody asked me if I can vouch for the script being safe and I dont have a proof so I ask how we can be sure it doesnt have keylogger inside

(Once again, I am using the script, I trust its safe and its really great toy I just ask if there is a way to prove it doesnt have something malicious inside. Its the issue with all the things published here)


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: punter11235]
      #10114523 - 04/25/07 09:06 AM

if you want to be really sure about it, you would have to learn about coding java, look through the sourcecode and compile it yourself.

everything else is just about believing what someone else is telling you (i.e. me when i upload binaries of the program, someone who has seen the source, a friend of yours, a stranger on a forum etc.)


Post Extras: Print Post   Remind Me!   Notify Moderator  
schwza
Carpal \'Tunnel


Reged: 04/02/03
Posts: 10485
Loc: get more chips than chips ahoy
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10115492 - 04/25/07 10:59 AM

i have a few questions about the inaccuracies.

do you know if they tend to cause the program to overreport good luck or bad luck?

as i see it, there could be a problem in one of three steps.
- finding the appropriate hands from the database
- parsing a HH into the relevant hands, board, bet size, etc.
- doing the EV calc

do you know which step(s) have the errors? i don't mean to sound ungrateful because this program is great.

also, how do you use filter_stake for 2/4? i've tried a lot of combos.


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: schwza]
      #10116197 - 04/25/07 01:31 PM

Quote:

i have a few questions about the inaccuracies.

do you know if they tend to cause the program to overreport good luck or bad luck?

as i see it, there could be a problem in one of three steps.
- finding the appropriate hands from the database
- parsing a HH into the relevant hands, board, bet size, etc.
- doing the EV calc

do you know which step(s) have the errors? i don't mean to sound ungrateful because this program is great.




hello,
first of all i dont parse the HHs i read the parsed values from the pokertracker db (which are sometimes not consistent).

the program is inaccurate at the moment because:
- it doesnt consider hands where more than 2 people go to showdown
- sidepots make the final potsize bigger than it should be, i.e. you get a small stack allin on the flop, but another player u play against folds on the river after some more betting, so your equity vs the shortstack is calculated by using the potsize that partly consists of the third players bets. but the wrong potsizes shouldnt be biased towards good / bad luck i guess.
- consider a hand where you bet 95% of your stack preflop with AA vs KK and the flop comes king high and u put in the rest of your chips drawing very thin. actually u got unlucky but the allin-street was the flop so it wont be considered unlucky since u got it allin drawing very slim.

so if u still think this program is useful and want it to be improved (i could remove most of the listed inaccuracies by using multiple queries etc) you might consider donating some $$$ coz usually i'd rather spend my free time playing some poker or coach me

other than that: just wait for Phil's program to be publically available (how often did i say this in this thread? )

Quote:

also, how do you use filter_stake for 2/4? i've tried a lot of combos.




when u set it to "none" at first, the very last string of each output is the Stake-string that can be filtered, for example:

[ 2007-04-03 20:11:10+02 ] [ 9s 7s ] [ Kd Td ] [ Ts Js 4s 5c _ Ac ] [ 1,0000 ] [ 134,05$ / 134,05$ / 134,05$ / +0,00$ ] [ NL $50 (6 max) ]
[ 2007-04-04 18:11:57+02 ] [ Th Tc ] [ 5d 2d ] [ Td 2c Qd _ 7h 4s ] [ 0,7170 ] [ 147,60$ / 105,83$ / 147,60$ / +41,77$ ] [ NL $100 (6 max) ]

here i can search for NL games by using "NL" as filter_stake, also i can use "6 max" for shorthanded games or "NL $100 (6 max)", which will only find exactly matching NL100SH hands.

so if filter_stake is a "substring" of the filter-string the hand will get added to the results.

Edited by advis0r (04/25/07 01:32 PM)


Post Extras: Print Post   Remind Me!   Notify Moderator  
schwza
Carpal \'Tunnel


Reged: 04/02/03
Posts: 10485
Loc: get more chips than chips ahoy
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10119602 - 04/25/07 04:32 PM

alright, i've had a lot of fun messing around with this, i'll send you a donation. can i give you a stars xfer?

Post Extras: Print Post   Remind Me!   Notify Moderator  
Praetor
Carpal \'Tunnel


Reged: 05/22/06
Posts: 6248
Re: Sklansky bucks calculator (php script) [Re: schwza]
      #10120647 - 04/25/07 05:25 PM

intl3_svn.dll is not installed

anyone else get this error?


Post Extras: Print Post   Remind Me!   Notify Moderator  
-zero-
OHgasmic


Reged: 02/24/06
Posts: 5071
Loc: Busting shortstackers
Re: Sklansky bucks calculator (php script) [Re: Praetor]
      #10124706 - 04/25/07 09:56 PM

Is it possible to filter between dates like 2007/04/01-2007/04/07 instead of just doing since 2007/04/01?

Post Extras: Print Post   Remind Me!   Notify Moderator  
schwza
Carpal \'Tunnel


Reged: 04/02/03
Posts: 10485
Loc: get more chips than chips ahoy
Re: Sklansky bucks calculator (php script) [Re: -zero-]
      #10125619 - 04/25/07 11:06 PM

Quote:

Is it possible to filter between dates like 2007/04/01-2007/04/07 instead of just doing since 2007/04/01?




i don't know if there is a real way, but i've been just doing:

(4/1 and on) - (4/7 and on) = 4/1 to 4/7


Post Extras: Print Post   Remind Me!   Notify Moderator  
-zero-
OHgasmic


Reged: 02/24/06
Posts: 5071
Loc: Busting shortstackers
Re: Sklansky bucks calculator (php script) [Re: schwza]
      #10125976 - 04/25/07 11:33 PM

Quote:

Quote:

Is it possible to filter between dates like 2007/04/01-2007/04/07 instead of just doing since 2007/04/01?




i don't know if there is a real way, but i've been just doing:

(4/1 and on) - (4/7 and on) = 4/1 to 4/7




Good idea, thanks.


Post Extras: Print Post   Remind Me!   Notify Moderator  
kkcountry
BBV MS Paint Rapid Response Squad


Reged: 06/28/06
Posts: 3599
Loc: selling my location, pm 4 deta...
Re: Sklansky bucks calculator (php script) [Re: -zero-]
      #10128915 - 04/26/07 03:51 AM

some of the talk in this thread is making my eyes glaze over, can somebody tell me if this project is at the point where somebody who isn't 1337 can download a script/program/whatever and find out how they're running?

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


Reged: 10/18/05
Posts: 4905
Re: Sklansky bucks calculator (php script) [Re: kkcountry]
      #10129388 - 04/26/07 04:50 AM

To punter, et al:

The main reason I'm keeping the beta limited for a few more days is to get all sites supported, catch any final accuracy bugs, and hook up the rest of the features. Finishing everything will take a lot longer if I have to support hundreds or thousands of average users who don't understand the limitations of beta software.

But everyone in this thread is fairly computer/poker savvy, so you're welcome to use it now. Just send me a 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: -zero-]
      #10134301 - 04/26/07 02:21 PM

Quote:

Is it possible to filter between dates like 2007/04/01-2007/04/07 instead of just doing since 2007/04/01?




new version:
http://rapidshare.com/files/28070393/AllinCalc_v0.8.zip.html

i renamed filter_date to filter_since and added filter_until
so use the new settings.txt and adjust it.
hf

ps: my stars acc.name is "advis0r" (thats a zero)


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


Reged: 02/22/05
Posts: 2321
Loc: sitting here in ventrilo
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10143163 - 04/27/07 12:13 AM

Quote:

some of the talk in this thread is making my eyes glaze over, can somebody tell me if this project is at the point where somebody who isn't 1337 can download a script/program/whatever and find out how they're running?



OK, can someone please post a summary of what to do (from start to finish)? there's too much goin on to keep track. badass idea though.


Post Extras: Print Post   Remind Me!   Notify Moderator  
10K-in-Clay
old hand


Reged: 02/03/06
Posts: 1092
Loc: "I have a boner!"
Re: Sklansky bucks calculator (php script) [Re: Phil153]
      #10152281 - 04/27/07 09:08 PM

Quote:

To punter, et al:

The main reason I'm keeping the beta limited for a few more days is to get all sites supported, catch any final accuracy bugs, and hook up the rest of the features. Finishing everything will take a lot longer if I have to support hundreds or thousands of average users who don't understand the limitations of beta software.

But everyone in this thread is fairly computer/poker savvy, so you're welcome to use it now. Just send me a PM.




phil does ur program require postregSQL or w/e as well? Sorry if this is a stupid question i'm terrible with this stuff.


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: 10K-in-Clay]
      #10152346 - 04/27/07 09:15 PM

Quote:


phil does ur program require postregSQL





Even if not, is there a reason to ever NOT use postrgres?


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


Reged: 04/05/05
Posts: 2173
Loc: Texas
Re: Sklansky bucks calculator (php script) [Re: poker1O1]
      #10153083 - 04/27/07 10:29 PM

Quote:

Quote:

some of the talk in this thread is making my eyes glaze over, can somebody tell me if this project is at the point where somebody who isn't 1337 can download a script/program/whatever and find out how they're running?



OK, can someone please post a summary of what to do (from start to finish)? there's too much goin on to keep track. badass idea though.




Please?


Post Extras: Print Post   Remind Me!   Notify Moderator  
10K-in-Clay
old hand


Reged: 02/03/06
Posts: 1092
Loc: "I have a boner!"
Re: Sklansky bucks calculator (php script) [Re: _dave_]
      #10153758 - 04/27/07 11:32 PM

Quote:

Quote:


phil does ur program require postregSQL





Even if not, is there a reason to ever NOT use postrgres?




My system is a FAT32 or something like this and i read on the website that it is not recommended that you run postregSQL on that type. Something to do with security of data or wutever, like i said tho i'm stupid when it comes to this stuff.


Post Extras: Print Post   Remind Me!   Notify Moderator  
-zero-
OHgasmic


Reged: 02/24/06
Posts: 5071
Loc: Busting shortstackers
Re: Sklansky bucks calculator (php script) [Re: SirFelixCat]
      #10155064 - 04/28/07 01:27 AM

Quote:

Quote:

Quote:

some of the talk in this thread is making my eyes glaze over, can somebody tell me if this project is at the point where somebody who isn't 1337 can download a script/program/whatever and find out how they're running?



OK, can someone please post a summary of what to do (from start to finish)? there's too much goin on to keep track. badass idea though.




Please?




Create a new directory and put each of the following files in it:

Download pokenum.exe from here.

Download postgres8.2 here.

Download the script from here and extract it.

Open the settings file and edit it like this:

db_host = localhost
db_name = [Pokertracker database name] - case sensitive
db_user = postgres
db_pwd = [postgres password]
outputfile = output.txt
screenname = [hero] - your original screen name in PT, not any aliases, case sensitive
filter_since = 2006-12-01
filter_until = 2006-12-31
filter_stake = none
filter_maxev = 1.0
filter_minev = 0.0
debug_mode = 0

Double-click run_allin_calc and let it run.

The analysis is available in output.txt


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


Reged: 10/18/05
Posts: 4905
Re: Sklansky bucks calculator (php script) [Re: 10K-in-Clay]
      #10155237 - 04/28/07 01:44 AM

Quote:

phil does ur program require postregSQL or w/e as well? Sorry if this is a stupid question i'm terrible with this stuff.



It works on any database in PT.


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


Reged: 02/22/05
Posts: 2321
Loc: sitting here in ventrilo
Re: Sklansky bucks calculator (php script) [Re: -zero-]
      #10156235 - 04/28/07 04:07 AM

Quote:

Download pokenum.exe from here.




here 's a good link

Quote:

db_pwd = [postgres password]



how/where do i get this password?

because this is my output:
Quote:

SQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
SQLState: 08004
VendorError: 0




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


Reged: 10/16/04
Posts: 1962
Re: Sklansky bucks calculator (php script) [Re: poker1O1]
      #10156760 - 04/28/07 05:54 AM

good stuff, shipped you a few bucks

im guessing it would take a ton of effort but id love to see a pokergrapher type program that can graph your ev on top of your results.

also adding tourney support to the script would be pretty nice, it would be pretty easy to approximate $ev for sngs using icm or whatever... tho i dunno if mtts would be worth the trouble since it would be so much tougher to determine $ev.


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


Reged: 02/14/05
Posts: 1353
Loc: IL
Re: Sklansky bucks calculator (php script) [Re: schwah]
      #10157571 - 04/28/07 09:29 AM

Does this work for SNG's/MTT's as well?

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


Reged: 10/12/06
Posts: 441
Re: Sklansky bucks calculator (php script) [Re: poker1O1]
      #10158004 - 04/28/07 10:58 AM

Quote:

Quote:

db_pwd = [postgres password]



how/where do i get this password?





Poketracker->Utilities menu->PostgresSQL settings. You set it when you download and install SQL 8.2 I believe.


Post Extras: Print Post   Remind Me!   Notify Moderator  
jukofyork
Carpal \'Tunnel


Reged: 09/16/04
Posts: 2551
Loc: Leeds, UK.
Re: Sklansky bucks calculator (php script) [Re: GutPunch]
      #10158024 - 04/28/07 11:01 AM

Quote:

Does this work for SNG's/MTT's as well?



For SNGs it should be possible to use the ICM model to compute the $EVs, but for MTTs it might turn out that there are just too many places/players and the ICM algorithm will take too long to compute the $EVs.

Juk


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: TheJared]
      #10159374 - 04/28/07 01:32 PM

Quote:

Quote:

Quote:

db_pwd = [postgres password]



how/where do i get this password?





Poketracker->Utilities menu->PostgresSQL settings. You set it when you download and install SQL 8.2 I believe.




Pokertracker wont give you that PW. You did indeed set it when you installed SQL.

Take a look in the registry, its somewhere in there.


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


Reged: 06/10/04
Posts: 1173
Loc: Sweden
Re: Sklansky bucks calculator (php script) [Re: hra146]
      #10219427 - 05/03/07 12:29 AM

money won: 20533,03$
money expected (based on allin equity): 19569,18$
money difference: +963,85$


haha holy moly, first one who is rungoot?


Post Extras: Print Post   Remind Me!   Notify Moderator  
Fiksdal
banned


Reged: 08/22/06
Posts: 4444
Re: Sklansky bucks calculator (php script) [Re: SirFelixCat]
      #10223876 - 05/03/07 11:44 AM

Quote:

Quote:

Quote:

some of the talk in this thread is making my eyes glaze over, can somebody tell me if this project is at the point where somebody who isn't 1337 can download a script/program/whatever and find out how they're running?



OK, can someone please post a summary of what to do (from start to finish)? there's too much goin on to keep track. badass idea though.




Please?




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: Fiksdal]
      #10224380 - 05/03/07 12:26 PM

Just take a look at my posts in the beginning of this thread, the instructions are all there in a clear and concise format.

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


Reged: 10/17/06
Posts: 782
Re: Sklansky bucks calculator (php script) [Re: wildzer0]
      #10226314 - 05/03/07 02:35 PM

I would love to beta test anything. I've been trying to instructions @ the begginning of the thread but have a problem. When trying to run the command I get htis Error "this application has failed to start because intl3_svn.dll was not found. Re-installing the application may fix this problem" but re-installing xampp has fixed nothing. Any help?

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


Reged: 02/07/06
Posts: 805
Re: Sklansky bucks calculator (php script) [Re: igetbadbeat]
      #10226858 - 05/03/07 03:11 PM

wow i love this script

here are some results for my cashgame

nl 200:
found 247 headsup allin situations
won: 128 lost: 97 tied: 22
average potsize: 222.04$
average ev: 0.5320
money won: 27151.89$
money expected (based on allin equity): 28259.20$
money difference: -1107.31$
max money diff: at +0.00$
min money diff: 2007-04-15 14:56:44+02 at -2360.48$
total_bet: 32491.75$

nl 100:
found 292 headsup allin situations
won: 178 lost: 99 tied: 15
average potsize: 103.16$
average ev: 0.5634
money won: 17674.64$
money expected (based on allin equity): 16477.38$
money difference: +1197.26$
max money diff: 2007-03-22 14:18:02+01 at +1299.14$
min money diff: 2007-03-02 11:58:13+01 at -302.17$
total_bet: 17863.70$


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


Reged: 02/04/04
Posts: 150
Loc: 5th-street, US
Re: Sklansky bucks calculator (php script) [Re: vortex86]
      #10228285 - 05/03/07 04:50 PM

I cant figure out my DB name, or the name I think I should use consists of two word with a space between them, could the space be why I get a data base does not exist message???

Edit:
Never mind DB name is NOT case sensitive, it should be ALL CAPS

Edited by Optisizer (05/03/07 05:18 PM)


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


Reged: 02/04/04
Posts: 150
Loc: 5th-street, US
Re: Sklansky bucks calculator (php script) [Re: Optisizer]
      #10228781 - 05/03/07 05:25 PM

And I knew I had been running bad last month, oh how good it feels to prove it with numbers. Sanity can prevail (or return rather):
found 594 headsup allin situations
won: 303 lost: 230 tied: 61
average potsize: 75.46$
average ev: 0.5161
money won: 20449.02$
money expected (based on allin equity): 21284.40$
money difference: -835.38$
max money diff: 2007-04-19 05:56:25+02 at +268.97$
min money diff: 2007-05-02 18:22:32+02 at -835.38$


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


Reged: 11/13/06
Posts: 203
Re: Sklansky bucks calculator (php script) [Re: Optisizer]
      #10229188 - 05/03/07 05:56 PM

Hey, can anyone give a quick overview of how to use the stake filter part? I want it to not include the time I made a tilt jump up to 400nl and lost 2 buyins lol.

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: igetbadbeat]
      #10230709 - 05/03/07 07:51 PM

Quote:

I would love to beta test anything. I've been trying to instructions @ the begginning of the thread but have a problem. When trying to run the command I get htis Error "this application has failed to start because intl3_svn.dll was not found. Re-installing the application may fix this problem" but re-installing xampp has fixed nothing. Any help?




You're trying to use the php script? I've never seen that error so I can't help ya with this one, but you could try advis0r's java exe later in the thread - it's much easier to get up and running.


Post Extras: Print Post   Remind Me!   Notify Moderator  
ben wb
enthusiast


Reged: 09/04/06
Posts: 378
Re: Sklansky bucks calculator (php script) [Re: igetbadbeat]
      #10231328 - 05/03/07 08:36 PM

Quote:

I would love to beta test anything. I've been trying to instructions @ the begginning of the thread but have a problem. When trying to run the command I get htis Error "this application has failed to start because intl3_svn.dll was not found. Re-installing the application may fix this problem" but re-installing xampp has fixed nothing. Any help?


I got the same error with the php script but the java one worked ok.

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


Reged: 09/08/06
Posts: 291
Re: Sklansky bucks calculator (php script) [Re: ben wb]
      #10236507 - 05/04/07 04:41 AM

My database is in access. Apparently I can't download PostgreSQL because my C Drive is FAT not NTFL (I'm a luddite so this means nothing to me). Is there any way to get round this, as it looks like a cool little programme, to get me out of my "I'm so unlucky mentality".

Otherwise are there any plans for it to work using the Access database?

Nice work guys.


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: ThePlan]
      #10237659 - 05/04/07 08:43 AM

Quote:

Hey, can anyone give a quick overview of how to use the stake filter part? I want it to not include the time I made a tilt jump up to 400nl and lost 2 buyins lol.




did you read the readme.txt?
you can filter for a particular stake, but u cant filter out a signle stake yet (i.e. all except nl400)


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


Reged: 09/22/05
Posts: 513
Loc: 4354th @ Party Sunday Million
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10237858 - 05/04/07 09:23 AM

nice work!

I'm running g000t

NL 600
found 897 headsup allin situations
won: 478 lost: 380 tied: 39
average potsize: 791.96$
average ev: 0.5114
money won: 367358.23$
money expected (based on allin equity): 347090.78$
money difference: +20267.45$
max money diff: 2007-02-14 16:46:59+01 at +20928.05$
min money diff: 2006-08-26 22:45:30+02 at -4813.56$
total_bet: 443653.86$

NL 1000
found 406 headsup allin situations
won: 237 lost: 159 tied: 10
average potsize: 1382.11$
average ev: 0.5308
money won: 330044.61$
money expected (based on allin equity): 303631.34$
money difference: +26413.27$
max money diff: 2007-05-03 17:04:36+02 at +27245.58$
min money diff: 2006-11-02 16:36:28+01 at -3735.03$
total_bet: 337508.73$


Post Extras: Print Post   Remind Me!   Notify Moderator  
Reef
Carpal \'Tunnel


Reged: 07/31/04
Posts: 13198
Loc: PCPforums
Re: Sklansky bucks calculator (php script) [Re: TheIrishThug]
      #10253995 - 05/05/07 06:28 PM





I also downloaded / installed xammp.

when I click start >> run >> cmd and type in the stuff it says,
Quote:

'Program' is not recognized as an internal or external command, operable program or batch file




edited the few lines in luck.php ... changed the settings file .. looked up my sqlr settings and password


soooooo freakin lost with this stuff


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


Reged: 05/25/05
Posts: 229
Re: Sklansky bucks calculator (php script) [Re: Reef]
      #10255451 - 05/05/07 08:32 PM

I keep on getting SQLException: The connection attempt failed.

Any ideas??


Post Extras: Print Post   Remind Me!   Notify Moderator  
jonyy6788
banned


Reged: 07/27/06
Posts: 3649
Loc: ON AIM
Re: Sklansky bucks calculator (php script) [Re: TheIrishThug]
      #10258477 - 05/06/07 03:33 AM

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




was having same problem....

Make sure you use the name of the actual file of ur PT DB (mine was PTPGSQL1). Don't use the name you chose in PT.


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: Reef]
      #10259712 - 05/06/07 09:06 AM

Quote:

soooooo freakin lost with this stuff




wow i'm actually surprised that u can post screenshots of your problems but not get the programs to run
however, heres your solution:
there are 2 programs, the php script (which requires a webserver/php interpreter like it is included in xampp) or my stand alone java program (allincalc).

if you want to use the latter, dont doubleclick on the postgres.jar but doubleclick the run_allin_calc.bat file after you have adjusted your settings.txt accordingly.

this should work


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


Reged: 12/05/03
Posts: 778
Loc: here and there
Re: Sklansky bucks calculator (php script) [Re: advis0r]
      #10260147 - 05/06/07 11:00 AM