Cant edit for some reason, anyways, seems i can auto import hands either, even tough i have given it a direction. So im obv. doing something wrong. A bit frustrating

What OS are you running?
Can you explain 'cant edit'?

I meant edit on the post i did before this one, im running windows vista.

I would like to use my winrate and variance from a session to input into the variance simulator at http://www.evplusplus.com/poker_tool...nce_simulator/.

This requires a winrate in bb/100 as well as a standard deviation in bb/100. The variance is the standard deviation squared so its units are (bb/100)^2,

Using the data from the player stats tabulated view: standard deviation during a 600 hand session is very small. sqrt(1.02)= 1 = 1 bb/100?

Somewhere in SQL.py is the following code:

,avg((hp.totalProfit+hp.rake)/100.0) AS profhndxr
,avg(h.seats+0.0) AS avgseats
,variance(hp.totalProfit/100.0) AS variance

Is it being divided by 100.0 to represent "for every 100 hands"? If that is the case my standard deviation is sqrt(102) = 10. bb/100, which seems to be small by the standards at the variance simulator which defaults to a standard deviation of 80 bb/100.

If someone can clarify how the variance is calculated in FPDB and/or tell me how to get variance in units of (bb/100)^2 it would be greatly appreciated.

That figure is in dollars. The value stored is in cents, hence the divide by 100.

The variance calculation itself uses the aggregate functions provided by the database.

http://****************/apps/mediawik...riance_mean.3F

The function operates per hand, rather than per 100 hands so there is no easy way to generate this at the moment.

Sorrow

In fpdb-log.txt:

2011-01-18 05:34:13,242 - parser ERROR parseSummary: Unable to recognise Tourney Info: 'PokerStars Game #55151721918: Tournament #347752926, $0.25+$0.00 USD Hold'em No Limit - Level I (10/20) - 2010/12/31 15:55:26 ET

Does the issue arise from the ' characters in front of PokerStars? If so what are they?

The wierd characters might be an issue, but more of a problem is that looks like you are attempting to import a hand history file using the summary importer.

Sorrow

Hi,

I just downloaded Free Poker Database, it is working great except for 1 thing:

I installed MySQL but the program still uses Sqlite, i couldn't figure out how to make it use MySQL

I appreciate your help.

PS: I looked into this forum, there was one more person having the same problem and the answers have a broken link on how to solve this problem

(http://****************/apps/mediawik...edit&redlink=1)

Regards.

welcome zaza,

the database connection is defined in the configuration file.

search for HUD_config.xml (on linux in .fpdb, on windows it is a hidden folder, so set the folder options to display hidden).

at the bottom of that file, the database is defined.

Activate the mysql one ( by moving the comment markers <!-- --> from mysql entry to the sqlite entry)
You will need to set the database username/password, and make sure that user has access to the database in mysql.

If you get prompted for site codes when fpdb starts for the first time, just cancel each prompt.

Also, this page includes mysql instructions for ubuntu which might help setting up the username:

http://****************/apps/mediawik...#.28A.29_mysql

thanks gimick

CREATE USER 'username'@'localhost' IDENTIFIED BY 'pass';


grant all privileges on fpdb.* to username@localhost ;

lines on mysql did the trick

aprreciate it!

Hi all,
I read on the FPDB site that
I play on a webbased pokerroom using IE, and each table will open in a new IE windows...
i also have a tool that convert handhistory, in a fulltilt handhistory format..i want to know if there are some HOWTOs on how to create a plugin to parse the site's handhistory files
Thanks

There is no real step-by-step Howto, but the info is in the wiki. If you use that info and follow the PokerStarsToFpdb.py file, creating a new plugin shouldn't be that hard. You need some rudimentary knowledge of Python and regular expressions.

If you are planning on contributing your plug in, or publishing it in a git repo, you will get plenty of help from the devs on the mailing list or on #fpdb on freenode.net. S0rrow is the expert on this but several of us have experience with that code.

Thanks for your reaply..
I tried to take a look, but it is too difficult for me to create a new one...
I thought that since the handhistory is in FullTilt format, it is possible to copy/paste the FullTiltToFpdb.py and edit only some attributes

If it is in Full Tilt format, you might just be able to use the existing Full Tilt converter.

In fact i'm using the Full Tilt converter to import the hand...and there are no problem..
But how can i do for the HUD?

Yeah, when you try to run the HUD, it is looking for a full tilt table to hang the hud on. We need to do some trickery to get it on the right table.

A few questions to get this started:

1. What is the first line of the converted HH?
2. What does is the title bar of the window say?
3. Are you using the exe version or the source version of fpdb?

BTW: Are you able to use your converter to convert the HHs in real time (that is, as you are playing)? The HUD only knows to create/update the hud display when a new hand is imported.

Thanks for your reply..

1. That's an example of a converted hand in a full tilt format
2. That's an example of a the title bar of the table (don't forget that is a pokerroom webbased, so i'm playing using IE, and each table running on a different IE's windows):
3. I'm using the exe version


not exactly in real time, but I think i'll be able to convert hands with a maximum delay of 30 seconds...although the statistics in the HUD are not updated in real time, would be fine too

Hi,

After formatting my computer, I forgot to check save HH's in the full tilt software for a few days, and I downloaded those hands online from full tilt.

At first, when I tried to import these into FPDB, no hands would be imported.

Then I realized there were some formatting differences with how full tilt software saves the HH's, and how they look when you download them from full tilt.

The line looks like normally looks like

Full Tilt Poker Game #27339745116: Table Mach 10 - $0.05/$0.10 - No Limit Hold'em - 18:41:33 ET - 2011/01/16

where as when you download it would be

Full Tilt Poker Game #27339745116: Mach 10, Entry #2 - $0.05/$0.10 - No Limit Hold'em - 18:41:33 ET - 2011/01/16

and between every hand, rather than just 3 spaces

there is an additional

******************** #10 **********************

So I edited the formating using Find/Replace

but my P&L still did not match

Anybody know what could be the problem?

(P&L does match for the hands that were NOT downloaded)

Thank you

OK, so I think you are pasting the converted HHs in to a file that we then need to autoimport in to fpdb.

1. Make a folder for the converted HHs and only store the converted HHs there.
2. Use 1 file for each table being played. A prudent person would try this with just 1 table first.
3. To start the HUD select autoimport and HUD from the import menu.
4. Use the browse button next on the full tilt line to select the folder where you are pasting the converted HHs.
5. Click start auto import. The HUD should pop up a few sec after you paste the 1st HH. (The HH has to be from a table that is on the screen.)

You should probably send us some HHs so we can make a plugin. It probably won't be on the top of anybody's todo list, but it will get done before too long. I'll send you a PM with the email address. This will save you some copy/pasting .

This has been fixed so that the downloaded HHs import OK (I think ). What version of fpdb are you using? Help menu, select about.

Free Poker Database (FPDB) 0.21_rc2

I just downloaded this

are you sure?

I am not sure of anything. Are you using the Windows exe version? It will be possible directly import these archives in the next release of that version.

Right now I think you have them importing but the archive file is so large you are running out of memory. Splitting the file into smaller chunks should do the trick.

Also, s0rrow pointed out to me that you have a multi entry tournament HH. That is probably throwing errors and not importing. But that's not what's fouling up the profit. Could you send me a multi entry HH or 2? I'll PM you my email right now. They need to be compressed and emailed, pasting fouls up the character encoding.

You don't have enough posts to have PM privs. If you want to contribute a couple of multientry HHs, you need to send them to the mailing list or stop by #fpdb on freenode.net. The HHs must be compressed to a .rar (with winrar) or .7z (with 7zip) to preserve the encoding, otherwise they are not useful for testing. (also .tar.gz or just .tar works)

it's multi entry rush poker

and the files are tiny, 100 hands each or something.

i'll send you 1 session with 2 entries if you give me your email, and i'll tell you what my total profit was for that session.

thanks for your help

(PS: i downloaded the multi entries as seperate 2 files, still PnL did not match. and I always play 2 entries, and the PnL matches for the rest of the multi entry rush poker sessions which were not downloaded)

I did not realize i couldnt even receive PM's; my email is zazazaza5000@gmail.com.

let me know

Okay, here's what I am running...

ver 0.21_rc2 (NOT the exe version)
Windows Vista
PokerStars

My config file (specifically the section "mucked" is "fu..ed" Here's what is different. It "seems" as though this started a few weeks ago, just about the time Stars started some of the recent updates, not sure about that. This is ONLY the mucked display I am having the problem with...

I will have four tables open as usual. Importing working fine. I run the tables like this...

A B

C D

Trying to fill the screen as much as possible (22" screen). From an backup file I enter the locations of the where the mucked cards should show on a 10 seat table....here's what I enter in that section

<layout height="546" max="10" width="792">
<location seat="1" x="576" y="166"> </location>
<location seat="2" x="722" y="201"> </location>
<location seat="3" x="736" y="317"> </location>
<location seat="4" x="672" y="420"> </location>
<location seat="5" x="484" y="420"> </location>
<location seat="6" x="389" y="476"> </location>
<location seat="7" x="223" y="461"> </location>
<location seat="8" x="165" y="339"> </location>
<location seat="9" x="208" y="201"> </location>
<location seat="10" x="318" y="176"> </location>
<location common="1" x="392" y="271"> </location>
</layout>

The table in the "A" position above (top left on the screen) will look perfect when the "mucked" cards pops up. Every card right where it belongs for my viewing. Tables B C and D will be ALL over the screen. I've even changed the config file and temporarily made the time it shows to 20 seconds so I could move them into position and save them. It then drives my config file nuts and shows unbelievable positions ... as shown below before I moved hardly anything. Some are minuses, some in the 57666 position

<layout height="546" max="10" width="792">
<location seat="1" x="-2897" y="29000"> </location>
<location seat="2" x="722" y="0"> </location>
<location seat="3" x="-3626" y="57666"> </location>
<location seat="4" x="129" y="18000"> </location>
<location seat="5" x="483" y="333"> </location>
<location seat="6" x="400" y="333"> </location>
<location seat="7" x="225" y="333"> </location>
<location seat="8" x="-768" y="57333"> </location>
<location seat="9" x="212" y="0"> </location>
<location seat="10" x="322" y="0"> </location>
<location common="1" x="-1717" y="52000"> </location>

That's the FIRST problem....
Next problem, possibly related. When the HUD was working properly, if I changed one of the HUD positions on one table, then saved it, it changed all the tables. All I had to do was to slightly move a table and it would snap the hud on that table to the correct positions I had just saved... not any more. Each hud on each table seems to work independently of the other ones, which drives the config file nuts. AND, I have to manually close each table's hud when I leave a table, on the blank screen left after closing, all the hud stats remain until I "kill this hud". I used to just close the table and hud disappears... NOT now.

Maybe I'm wasting my time and I've missed something that shows this problem has already been addressed. Sorry for the long post, just trying to give you the exact details..

Dog

An *extremely* mild bug report: I was trying to load some old PS hand histories and had some "hands" that didn't occur because the BB didn't post, e.g.

PokerStars Game #20349633663: Triple Draw 2-7 Lowball Limit ($1/$2 USD) - 2008/09/12 14:09:41 ET
Table 'Miriam III' 6-max Seat #5 is the button
Seat 5: Hero ($32.75 in chips)
Hero: posts small blind $0.50
VillainA: is sitting out
VillainB: is sitting out
Hand cancelled
*** SUMMARY ***
Seat 5: Hero (button) collected ($0)

This caused the bulk import to freeze up.
Obviously not a big problem as I just deleted all the hands like this, and I don't know if Stars still logs a history for such hands (these were all from 1/29/09 or older). Just thought I'd post as an FYI.