Open Side Menu Go to the Top
Register
Sklansky bucks calculator (php script) Sklansky bucks calculator (php script)

04-05-2007 , 04:52 PM
Ok IŽll wait till "user-friendly" version comes out Thanks wildzer0 for your patience and help
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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.
Sklansky bucks calculator (php script) Quote
04-05-2007 , 05:01 PM
Does our DB have to be postgreSQL for this to work?
Sklansky bucks calculator (php script) Quote
04-05-2007 , 05:02 PM
Quote:
Does our DB have to be postgreSQL for this to work?
Yes.
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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.....
Sklansky bucks calculator (php script) Quote
04-05-2007 , 05:11 PM
say you put your files in c:\luck\ just type cd c:\luck
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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.
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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?
Sklansky bucks calculator (php script) Quote
04-05-2007 , 05:34 PM
04-05-2007 , 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
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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.
Sklansky bucks calculator (php script) Quote
04-05-2007 , 05:45 PM
Advis0r, that looks great will you make it avaliable?
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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.
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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.
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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/...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?
Sklansky bucks calculator (php script) Quote
04-05-2007 , 06:20 PM
Any of these apps working with PO?
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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.
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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.
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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.
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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.
Sklansky bucks calculator (php script) Quote
04-05-2007 , 09:11 PM
ok i uploaded my version:

http://rapidshare.com/files/24545277..._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/...-504.jdbc3.jar

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

have fun
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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?!?
Sklansky bucks calculator (php script) Quote
04-05-2007 , 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
Sklansky bucks calculator (php script) Quote

      
m