Open Side Menu Go to the Top
Register
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

10-21-2009 , 06:37 AM
Once we start getting the snapshot releases out again, I'll do my part and make it even easier for linux users to test this out. Namely, there will be debian/ubuntu packages available.

I'll wait for Karmic to release first, because installed python modules are handled differently between the two ubuntu versions.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 10:14 AM
Quote:
Originally Posted by sorrow
Ok. I've had a better look at this... and it shouldn't fail.

Can you make sure the code for get_default_font looks like:

Code:
    def get_default_font(self, site = 'PokerStars'):
        (font, font_size) = ("Sans", "8")
        if site not in self.supported_sites:
            return ("Sans", "8")
        if self.supported_sites[site].font == "":
            font = "Sans"
        else:
            font = self.supported_sites[site].font
The highlighted lines might have been added after the last official release.

Sorrow

Edit: Forgot to mention - site_path isn't actually used anywhere so I wouldn't worry about it.
Ok, we're getting somewhere. That code wasn't in my Configuration.py. I added it, and now the error has jumped to the colors section.

Code:
HUD_main starting
Using db name = fpdb
C:\Python26\lib\site-packages\MySQLdb\__init__.py:34: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Unhandled exception in thread started by <bound method HUD_main.read_stdin of <__main__.HUD_main object at 0x012A2810>>
Traceback (most recent call last):
  File "HUD_main.py", line 196, in read_stdin
    self.create_HUD(new_hand_id, tablewindow, temp_key, max, poker_game, stat_dict, cards)
  File "HUD_main.py", line 112, in create_HUD
    self.hud_dict[table_name] = Hud.Hud(self, table, max, poker_game, self.config, self.db_connection)
  File "C:\Program Files\fpdb\pyfpdb\Hud.py", line 79, in __init__
    self.colors        = config.get_default_colors(self.table.site)
  File "C:\Program Files\fpdb\pyfpdb\Configuration.py", line 549, in get_default_colors
    if self.supported_sites[site].hudopacity == "":
KeyError: None
Exception KeyError: KeyError(9472,) in <module 'threading' from 'C:\Python26\lib\threading.pyc'> ignored
I still get no overlay, and my HUD Main window looks like this:



So, I put this in the get_default_colors section, and commented out all the other if/else statements:

Code:
if  site not in self.supported_sites:
		colors['hudopacity'] = 1.0
		colors['hudbgcolor'] = "#000000"
		colors['hudfgcolor'] = "#FFFFFF"
Now, my HUD main window looks like this:



And I have the beginnings of my HUD overlay, with only this:



But no other parts of the HUD overlay.

So....it appears to me that it is not identifying the site for some reason, as the HUD main window above shows "None - <Tablename>", instead of "Pokerstars - <Tablename>". Also, by having to change the Configuration.py to tell it how to react "if site is not in supported_sites". Interesting too, is before I changed the bg and fg colors manually in Configuration.py, it was a white bg, and black fg. My HUD_config.xml is set for a black bg, and white fg. It doesn't appear it's reading my HUD_config.xml file for some reason.

The errors now are related to seat position, so I'm sure I could go hack on Hud.py and make this somehow work, by hard coding everything, but I want to make it work the correct way.

But I can verify it IS reading at least parts of the HUD_config.xml, because if I change my DB password, it fails to run with an error of "access denied" on the DB. So, it just appears to be something with the "site", or "supported_sites" of the HUD_config.xml file.

Does that make sense? Am I getting close?

Last edited by BirdRacer; 10-21-2009 at 10:41 AM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 12:08 PM
Quote:
Originally Posted by BirdRacer
So, it just appears to be something with the "site", or "supported_sites" of the HUD_config.xml file.

Does that make sense? Am I getting close?
Yes - site is not being set/passed correctly for some reason.

Can you run Configuration.py on its own from a console please? The SUPPORTED SITES output might give us a clue as to what is/isn't being read.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 12:30 PM
Quote:
Originally Posted by sorrow
(Speculation mode)
How often the hud windows update is entirely dependent on the window it is attached to. The poker software indicates that the fpdb window should redraw, and fpdb does the required db queries and updates itself.

If the window it is attached to asks us to refresh multiple times in a short period of time, a flicker effect would be the result. If this is the case we may be able to throttle how often we update to assist this.

I'll pass that one over to the HUD guys though.
I think it must be something like this. If I move the HUD elements (stats displays for each player) off the Betfair table window there is no flicker/redrawing. So maybe fpdb is db querying and updating when the background the HUD is positioned over redraws. Could that be possible?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 12:37 PM
Quote:
Originally Posted by sorrow
Yes - site is not being set/passed correctly for some reason.

Can you run Configuration.py on its own from a console please? The SUPPORTED SITES output might give us a clue as to what is/isn't being read.

Sorrow
Done.

Here is the supported sites section. I can post the entire output if you need it.

Code:
----------- SUPPORTED SITES -----------
Site = PokerStars
    HH_path = C:\Program Files\PokerStars\HandHistory\BirdRacer
    aux_window =
    converter = passthrough
    decoder = pokerstars_decode_table
    enabled = True
    font = Sans
    font_size = 8
    hudbgcolor = #000000
    hudfgcolor = #FFFFFF
    hudopacity = 1.0
    screen_name = BirdRacer
    site_name = PokerStars
    site_path =
    table_finder = PokerStars.exe
    use_frames =
    Layout = 8 max, width= 792, height = 546, fav_seat = 8
        Locations = (684,61)(689,239)(692,346)(525,402)(259,402)(0,348)(0,240)(0,35)
    Layout = 9 max, width= 792, height = 546, fav_seat = 8
        Locations = (560,0)(679,123)(688,309)(483,370)(444,413)(224,372)(0,307)(0,121)(140,0)
    Layout = 10 max, width= 792, height = 546, fav_seat = 9
        Locations = (684,61)(689,239)(692,346)(586,393)(421,440)(267,440)(0,361)(0,280)(121,280)(46,30)
    Layout = 2 max, width= 792, height = 546, fav_seat = 0
        Locations = (651,288)(10,288)
    Layout = 6 max, width= 792, height = 546, fav_seat = 6
        Locations = (681,119)(681,301)(487,369)(226,369)(0,301)(0,119)

----------- END SUPPORTED SITES -----------
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 01:39 PM
Well...it's working now.

I kinda thought if I ever figured it out, it would be something simple.

In my HUD_config.xml, I had table_finder="PokerStars.exe". I'm not sure where that came from. I think that was the way I received the file, but I took off the ".exe", since I noticed there wasn't one for Full Tilt, and it works now.

Even the HUD_config.xml that I borrowed from the guy a few posts back had "Pokerstars.exe". But it will not work on my PC that way, for whatever reason.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 02:34 PM
Quote:
Originally Posted by sorrow
http://****************/projects/fpdb/files/

3. hhArchiveBase needs to be set. This is a directory that intermediate files are written too for importing. This directory will disappear in later releases, but its required at the moment as an intermediate step as the new import framework still can't insert values directly into the database.

* If you had a custom hud layout that will need to be redone, the options changed format slightly.
A couple of clarifications... on the item#3, hhArchiveBase issue, do we need to create a directory and then insert it somewhere (no jokes please ) Currently my HUD_config file has the following line and the directory c:\temptemptemp\handhistories which I created. That will remain the same?

<import callFpdbHud="True" hhArchiveBase="c:\temptemptemp\HandHistories\" interval="10"/>

And, regarding the/my custom HUD layout, do I just use the format you now have in the HUD_config file and tweak it to add my custom layout. I've only changed it to 2 rows, 4 columns and added two stats. Oh yeah, and changed the font size and type.

I'm a bit afraid to go from a well running fpdb to problems, but here goes... once I get answers to the above. I assume we still import (pokerstars) the same in bulk import. I'm using Mysql or whatever it is. In the past, I could use either "passthrough" the default, or "PokerstarstoFPDB." Is that the same? I don't understand the difference, seems one works better than the other, and then the reverse. Which is the preferred?

Thanks again for the good work. Please respond in "non coder" language...

signed.. Dog (definitely a non-coder)
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 05:17 PM
I d/l package. I was the first dl, that's scary. After viewing the unextracted files in the "tar" file, I found the Windows directory and what appears to be a self installer???

"fpdpenvinstall2.au3"

Do I have to uninstall the previous version 0.11.3 first?

Do I just double click the apparent install file above?

Does it install all the "other" aspects such as graphing and others?

I already have Mysql installed, will it sense that? Or, do I have to completely follow the install and enter my current password, and it overwrites what is there?

You already mentioned we have to recreate a database, and bulk import. As I hinted in the last question, will my old db be overwritten/erased/uninstalled automatically?

Too many questions I guess for this non-coder. I didn't notice anywhere to indicate the hharchive issue you mentioned in a previous post. Where do I enter the directory I have already created and been using?

Thanks...
Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 07:58 PM
Hey dog,

Do your mucked cards show on Vista with the xml file you gave me earlier? They don't work on mine, never have. I didn't mind until I got my XP working and found that I like the mucked cards.

EDIT: Nevermind, I got it working.

Last edited by BirdRacer; 10-21-2009 at 08:12 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 09:21 PM
Quote:
Originally Posted by BirdRacer
Hey dog,

Do your mucked cards show on Vista with the xml file you gave me earlier? They don't work on mine, never have. I didn't mind until I got my XP working and found that I like the mucked cards.

EDIT: Nevermind, I got it working.
It seems you have your answer. I assume you meant when I fold, do those cards show... and yes they do. I love that feature, just as a quick reference... you know, like when I folded 44 this morning and saw the flop come 4 4 A, and was able to instantly see the mucked cards.... I felt like my avatar looks!!!
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 09:44 PM
Quote:
Originally Posted by 1meandog4u
It seems you have your answer. I assume you meant when I fold, do those cards show... and yes they do. I love that feature, just as a quick reference... you know, like when I folded 44 this morning and saw the flop come 4 4 A, and was able to instantly see the mucked cards.... I felt like my avatar looks!!!
LOL
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-21-2009 , 11:09 PM
Quote:
Originally Posted by 1meandog4u
A couple of clarifications... on the item#3, hhArchiveBase issue, do we need to create a directory and then insert it somewhere (no jokes please ) Currently my HUD_config file has the following line and the directory c:\temptemptemp\handhistories which I created. That will remain the same?

<import callFpdbHud="True" hhArchiveBase="c:\temptemptemp\HandHistories\" interval="10"/>
Yes and yes. The directory needs to exist and be writable, if you have that already then you are good to go.

When importing you will find that it ends up containing sub-directories:
c:\temptemptemp\handhistories\PokerStars
c:\temptemptemp\handhistories\Full Tilt Poker
c:\temptemptemp\handhistories\<another site>
c:\temptemptemp\handhistories\....

And in those directories temporary files (Starslike files, matching the current hh files)will be created.
Quote:
Originally Posted by 1meandog4u
And, regarding the/my custom HUD layout, do I just use the format you now have in the HUD_config file and tweak it to add my custom layout. I've only changed it to 2 rows, 4 columns and added two stats. Oh yeah, and changed the font size and type.
Font size and type hasn't chnaged. Layout params haven't changed.

The stat names did change.

ffreq_1 became ffreq1 (i think)

I believe the change was to allow the user to specify the number of decimal places they cared about... i'm not that sure though (anyone else help me here?)
Quote:
Originally Posted by 1meandog4u
I'm a bit afraid to go from a well running fpdb to problems, but here goes... once I get answers to the above. I assume we still import (pokerstars) the same in bulk import. I'm using Mysql or whatever it is. In the past, I could use either "passthrough" the default, or "PokerstarstoFPDB." Is that the same? I don't understand the difference, seems one works better than the other, and then the reverse. Which is the preferred?

Thanks again for the good work. Please respond in "non coder" language...

signed.. Dog (definitely a non-coder)
Passthrough is no longer available. Passthrough meant "Pass the hh file unaltered to the old parsing engine"

The process loosely now is:
1) Load SiteToFpdb
2) Convert file from Site format to a Starslike format and write it out too hhArchiveBase
3) Legacy importer reads the file from hhArchiveBase and imports the file into the database.

The reason that its done this way at the moment is because the new import code is a lot more robust, but still hasn't gained the ability to insert directly into the database yet.

HTH

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 01:28 AM
Quote:
Originally Posted by sorrow
Yes and yes. The directory needs to exist and be writable, if you have that already then you are good to go.

When importing you will find that it ends up containing sub-directories:
c:\temptemptemp\handhistories\PokerStars
I actually understood everything you said, that's scary. On the line I mentioned in my current config...

<import callFpdbHud="True" hhArchiveBase="c:\temptemptemp\HandHistories\" interval="10"/>

Where is the proper placement in the new config file? (for Pokerstars in my case) Here's where it is currently located near the end of the file.

</popup_windows>
<import callFpdbHud="True" hhArchiveBase="c:\temptemptemp\HandHistories\" interval="10"/>
<tv combined2B3B="True" combinedPostflop="True" combinedStealFold="True"/>

<supported_databases>


Should it go in about the same place, after popup windows and before supported databases? I have to go to the hospital for a minor operation tomorrow, and will give it a go over the weekend. I'll let you know if we have a go.

The one question you didn't respond to was if the installer will install everything, and do I need to uninstall 11.3 first? Do I have to recreate the database before I install, or does it overwrite the old database automatically.

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 01:42 AM
Quote:
Originally Posted by 1meandog4u
I actually understood everything you said, that's scary. On the line I mentioned in my current config...

<snip>

Should it go in about the same place, after popup windows and before supported databases? I have to go to the hospital for a minor operation tomorrow, and will give it a go over the weekend. I'll let you know if we have a go.


Please use the example config in pyfpdb/ as a basis. The file format hasn't changed that much, but there are a few areas that have changed - it will be a lot easier starting with that than debugging.

hhArchiveBase hasn't moved - it did actually work during the last release if you used SiteToFpdb instead of passthrough, but we weren't recommending its general use at the time.

Quote:
Originally Posted by 1meandog4u
The one question you didn't respond to was if the installer will install everything, and do I need to uninstall 11.3 first? Do I have to recreate the database before I install, or does it overwrite the old database automatically.

Dog
It uses the same libraries as previously, You should be able to extract the tar.gz file to anywhere and fpdb.py from wherever you've extracted it too.

The config file will need to be replaced.

The database will need to be recreated. That can be done from Database->Create or recreate tables.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 05:11 AM
Thread;tldr

I found no instruction how to get it start polling tables, i click the button and it shows nothing. One 0.5/1 Razz Table running. Please help me!
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 06:26 AM
Is this project still active?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 06:40 AM
Quote:
Originally Posted by corsakh
Is this project still active?
Post #1974 was less than 48 hours ago announcing a development snapshot, and we've had 20 posts in this thread in the last couple of days.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 11:33 AM
sorrow,

Where does the HUD get the "n" count? I have over 8,000 hands in the "hands" table of my fpdb database, but the HUD only shows about 800 for the "n" parameter.

Some were older hands that I bulk imported, but it appears to be only counting the ones that were auto-imported.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 11:36 AM
Quote:
Originally Posted by BirdRacer
sorrow,

Where does the HUD get the "n" count? I have over 8,000 hands in the "hands" table of my fpdb database, but the HUD only shows about 800 for the "n" parameter.

Some were older hands that I bulk imported, but it appears to be only counting the ones that were auto-imported.
Tournaments - you are probably only looking at the current blind level

Cash games - same again - current blind level.

The aggregation is a bit broken in the old release i think, in the new release its much more configurable.

hth

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 11:59 AM
Quote:
Originally Posted by sorrow
Tournaments - you are probably only looking at the current blind level

Cash games - same again - current blind level.

The aggregation is a bit broken in the old release i think, in the new release its much more configurable.

hth

Sorrow
Ahhh, OK, gotcha. That makes sense.

Yep, that's exactly what it is:

Code:
mysql> select count(*) from hands
    -> where gametypeId=1;
+----------+
| count(*) |
+----------+
|      819 |
+----------+
1 row in set (0.00 sec)
Thanks for all the support.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 12:15 PM
Quote:
Originally Posted by aufgeschwemm
Thread;tldr

I found no instruction how to get it start polling tables, i click the button and it shows nothing. One 0.5/1 Razz Table running. Please help me!

?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 12:45 PM
Quote:
Originally Posted by aufgeschwemm
I found no instruction how to get it start polling tables, i click the button and it shows nothing. One 0.5/1 Razz Table running. Please help me!
This sounds a bit like configuration problem. What site do you play on, and do you have
  • the site enabled, and
  • the hand history path set correctly?

For example, the default setting for stars looks like this:
Code:
<site enabled="True" 
              site_name="PokerStars" 
              table_finder="PokerStars.exe" 
              screen_name="YOUR SCREEN NAME HERE" 
              site_path="C:/Program Files/PokerStars/" 
              HH_path="C:/Program Files/PokerStars/HandHistory/YOUR SCREEN NAME HERE/"
...
So even if the site is enabled, fpdb doesn't know where to look for hand histories. The tables are not scanned real-time, the hands are read and processed as they become available in the history files.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 12:54 PM
Quote:
Originally Posted by sorrow
It uses the same libraries as previously, You should be able to extract the tar.gz file to anywhere and fpdb.py from wherever you've extracted it too.

The config file will need to be replaced.

The database will need to be recreated. That can be done from Database->Create or recreate tables.
Please excuse my lameness this morning (or evening where you are). This "seems" too simple to me. So, if I'm running 11.3 now, and it's working... I can forget all the other files in the tar.gz file... then

1) Take the extracted fpdb.py (0.12) and drop it in my current directory c:\Program Files\FPDB\pyfpdb\ so that it overwrites the old file (11.3)

2) Take the extracted HUD_config.xml ......change password, screen name and any other personal preferences, noting some stats have different abbreviations, and be sure the hharchive indicates the directory I have currently. When done, drop that into the same directory so it will overwrite the old config.

3)Open/run the fpdb.py (which we KNOW will run perfect ) and recreate my Mysql database.

4) Bulk import the hands I've so carefully zipped away in a safe place knowing I was not done "recreating" my database.

5) Sit at a .01 table on PS's and see if the hud and importing all is working.....

6) Make another post here either commending all the coders on a great job, or..... curse, swear, THEN make an amiable post explaining how it is not working...

Gotta run,

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-22-2009 , 02:59 PM
Quote:
Originally Posted by 1meandog4u
Please excuse my lameness this morning (or evening where you are). This "seems" too simple to me. So, if I'm running 11.3 now, and it's working... I can forget all the other files in the tar.gz file... then

1) Take the extracted fpdb.py (0.12) and drop it in my current directory c:\Program Files\FPDB\pyfpdb\ so that it overwrites the old file (11.3)

2) Take the extracted HUD_config.xml ......change password, screen name and any other personal preferences, noting some stats have different abbreviations, and be sure the hharchive indicates the directory I have currently. When done, drop that into the same directory so it will overwrite the old config.

3)Open/run the fpdb.py (which we KNOW will run perfect ) and recreate my Mysql database.

4) Bulk import the hands I've so carefully zipped away in a safe place knowing I was not done "recreating" my database.

5) Sit at a .01 table on PS's and see if the hud and importing all is working.....

6) Make another post here either commending all the coders on a great job, or..... curse, swear, THEN make an amiable post explaining how it is not working...

Gotta run,

Dog
Dog - I've just (last week) updated from "11.3". Imo, really, the easy way here for you (& for sorrow ) is for you just to make a folder c:\program Files\newfpdb (or whatever you want to call it) and unpack the whole shebang there. Recreat your database (unavoidable - but I had no hiccups at all there) and, after editing the new Hud_example file as needs be, fire up Stars. Stars went super smoothly for me. (I've made a couple of posts about another site recently, but to be honest I think that was only that the devs had had so little feedback/useers about it that they forgot about it 'on the back burner'.)

Unilke some other software you can have multiple different versions of fpdb on your computer without causing conflicts. (Obv, you have to go to, eg,
c:\program files\newfpdb\pyfpdb and click on fpdb.py to start it rather than clicking on a shortcut that points to your original version.)

Assuming it all works - & it really shouldn't be problematic, you can then rename the directory fpdb to oldfpdb and newfpdb to fpdb etc - according to taste.

tl;dr Just install the new version in a new directory & you'll be good to go.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
10-23-2009 , 12:03 AM
Quote:
Originally Posted by 1meandog4u
Please excuse my lameness this morning (or evening where you are). This "seems" too simple to me. So, if I'm running 11.3 now, and it's working... I can forget all the other files in the tar.gz file... then
No, as tchaz said extracting it to c:\program Files\fpdb\ - or putting it in hte same place as your previous directory is a good idea.

Taking the example config from the fpdb-0.12-200910xx/pyfpdb/ folder and placing it over your existing config (then editing ofcourse) should be enough.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m