HUD Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 - Page 49 - Poker Software -- Two Plus Two Poker Forums

Very, very impressive guys. I've installed on WinXP, using fpdb v0.10 and the Win installer from Dec. 2, 2008. Had the same problem as panicked in msg #1126 but easily fixed and everything seems to be working well. Downloaded from the git-repository today and I haven't found any bugs yet

but I'll let you know if I do.

There one thing I haven't figured out - I think I must just have missed the relevant information. If I have "favourite seat" set up, say on Stars, the HUD doesn't seem to automatically move the player stats to cope with it. Any clues would be very helpful.

Quote

03-16-2009 , 10:59 PM

#1202

panicked

enthusiast

Join Date: Mar 2009 Posts: 69

Quote:

Originally Posted by tchaz

There one thing I haven't figured out - I think I must just have missed the relevant information. If I have "favourite seat" set up, say on Stars, the HUD doesn't seem to automatically move the player stats to cope with it. Any clues would be very helpful.

How to set preferred seat:

http://fpdb.wiki.****************/Pre...+Seat+on+Stars

Quote

03-16-2009 , 11:55 PM

#1203

tchaz

Carpal \'Tunnel

Join Date: Jul 2008 Posts: 14,832

Panicked - tyvm - that worked super well.

Btw - is there some way to search for info like this?

Quote

03-17-2009 , 12:21 AM

#1204

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by tchaz

Btw - is there some way to search for info like this?

Most of the doco is on the wiki, but... depending on the doc it may be wrong.

Let us know when you find something that doesn't work as advertised and we'll patch it up.

Quote

03-17-2009 , 12:39 AM

#1205

tchaz

Carpal \'Tunnel

Join Date: Jul 2008 Posts: 14,832

Quote:

Originally Posted by sorrow

Most of the doco is on the wiki, but... depending on the doc it may be wrong.

Let us know when you find something that doesn't work as advertised and we'll patch it up.

Yes - I've been searching through that - but, for example, is the link you gave me available through a menu on the wiki somewhere. Sorry for the idiot qs. & congrats again on the software.

Quote

03-17-2009 , 01:29 AM

#1206

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

Quote:

Originally Posted by Eratosthenes

In mysql we are using the inno tables. These are the "industrial strength" tables that allow rollback, etc. The myIsam tables are faster, but less reliable. Anybody that would be OK with using SQLite should be OK with using myIsam. Making inno/myIsam a selectable parameter in the config file would not be a big problem.

This sounds like a possible solution to some of the performance problems others have experienced.

I'm willing to give MyISAM a try. Data integrity is not critical as I keep all the hand histories.

Would it work if I went ahead and simply converted the tables in my database manually with ALTER TABLE [name] ENGINE=MYISAM?

Quote

03-17-2009 , 05:24 AM

#1207

ekdikeo

old hand

Join Date: Aug 2006 Posts: 1,364

We could probably add a stat to the HUD that would show the game-type of the last hand imported for that table - regular HORSE players could set that, and then they'd know what game the info was for (since the first hand of each round would be a different game than the prior hand was, then they could at least differentiate)

This is why I added player name to the stat list, because the player sitting in the seat this hand may not always be the same player as was sitting in the seat last hand. I don't think it's default to have player name in the display though.

I could potentially see down the road, maybe a multi-game HUD, where you can click on it, and it will flip through the stats for each game that it has processed for that table .. not something I'd have the knowledge or opportunity to do, though.

Quote

03-17-2009 , 06:19 AM

#1208

Kris8400

newbie

Join Date: Jun 2008 Posts: 25

Hi, first of all thanks for this program, this realy is great work.
I'm having some trouble with the MySQL part though, this was my error message:

Code:

Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\fpdb.py", line 464, in <module>
    me = fpdb()
  File "D:\Program Files\fpdb\pyfpdb\fpdb.py", line 377, in __init__
    self.load_profile()
  File "D:\Program Files\fpdb\pyfpdb\fpdb.py", line 275, in load_profile
    self.settings['db-password'])
  File "D:\Program Files\fpdb\pyfpdb\fpdb_db.py", line 65, in connect
    self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
  File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
    return Connection(*args, **kwargs)
  File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'fpdb'@'localhost' (using password: YES)")

edit:

edited the fpdb_db.py file to read my settings:

Code:

            if self.host and self.user and self.password:
                self.db = psycopg2.connect(host = 127.0.0.1,
                        user = root, 
                        password = mypassword , 
                        database = fpdb)

But I still get this error:

Code:

Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\fpdb.py", line 37, in <module>
    import fpdb_db
  File "D:\Program Files\fpdb\pyfpdb\fpdb_db.py", line 72
    self.db = psycopg2.connect(host = 127.0.0.1,
                                            ^
SyntaxError: invalid syntax

Last edited by Kris8400; 03-17-2009 at 06:31 AM. Reason: problem solving

Quote

03-17-2009 , 09:06 AM

#1209

Knudsen

enthusiast

Join Date: Jan 2007 Posts: 57

hi.
i have a qestion. does the hud show dead cards in stud games and is there an eta for cereus network support?

thanks

Quote

03-17-2009 , 09:16 AM

#1210

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by Knudsen

hi.
i have a qestion. does the hud show dead cards in stud games and is there an eta for cereus network support?

thanks

The HUD can only show cards from previous hands, we do not have a screen reader as yet.

We don't have any Cereus HHs to attempt to work on at the moment. If you are willing to send a few hundred hands for each cash game type you play we should be able to get support in fairly quickly.

That goes for all sites actually. From an email I sent to the fpdb mailing list last week:

"""
The new HH import code has come a long way in the last 6 months, to
the point where I was able to add preliminary import support for
Betfair NLHE in just under 2 hours of work.

I'm looking to increase the number of sites supported, and the number of

I'm chasing HH files for all sites at the moment.

Particularly i'm interested in:
PokerStars draw games
FTP draw games.
Betfair Omaha, Stud and Draw
Ongame Omaha, Stud, Draw
Carbon Omaha, Stud, Draw
Any other site with a text format

Thanks
"""

pm me for my email address.

Quote

03-17-2009 , 09:25 AM

#1211

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by Kris8400

Hi, first of all thanks for this program, this realy is great work.
I'm having some trouble with the MySQL part though, this was my error message:

Code:

Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\fpdb.py", line 464, in <module>
    me = fpdb()
  File "D:\Program Files\fpdb\pyfpdb\fpdb.py", line 377, in __init__
    self.load_profile()
  File "D:\Program Files\fpdb\pyfpdb\fpdb.py", line 275, in load_profile
    self.settings['db-password'])
  File "D:\Program Files\fpdb\pyfpdb\fpdb_db.py", line 65, in connect
    self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
  File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
    return Connection(*args, **kwargs)
  File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'fpdb'@'localhost' (using password: YES)")

Error message 1045 from mysql is very likely to be an incorrect username or password. You need to set username/password in your HUD_config.xml file. That line should look something like this:

Code:

<database db_ip="localhost" db_name="fpdb" db_pass="newPassword" db_server="mysql" db_type="fpdb" db_user="fpdb">    </database>

The wiki has a semi-decent page on setting up mysql. There is also a wiki page on how to find your config file. Also if you run fpdb.py from a terminal window, it will print the location and file name of the config file it is using. The config file is getting pretty big and the database line should be near the bottom.

Quote:

edit:

edited the fpdb_db.py file to read my settings:

Code:

            if self.host and self.user and self.password:
                self.db = psycopg2.connect(host = 127.0.0.1,
                        user = root, 
                        password = mypassword , 
                        database = fpdb)

But I still get this error:

Code:

Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\fpdb.py", line 37, in <module>
    import fpdb_db
  File "D:\Program Files\fpdb\pyfpdb\fpdb_db.py", line 72
    self.db = psycopg2.connect(host = 127.0.0.1,
                                            ^
SyntaxError: invalid syntax

Regarding these last 2 code boxes: You should be setting password and user via the config file, but these code changes are changing the postgres driver not the mysql driver. The mysql driver is the one named MySQLdb. Secondly your text entries should be in quotes: host = "127.0.0.0" and user = "root" etc.

Quote

03-17-2009 , 09:26 AM

#1212

Kris8400

newbie

Join Date: Jun 2008 Posts: 25

Ok I fixed the db problem myself, and the program now starts. The only problem now is it doesn't seem to "do" much.

After I click "auto import and HUD" the terminal repeats the guiautoimport bit, but no HUD shows up, and when I run tables.py it returns "none". I'm also lost on where the FTP auto import folder should be...

Quote

03-17-2009 , 09:33 AM

#1213

tchaz

Carpal \'Tunnel

Join Date: Jul 2008 Posts: 14,832

Quote:

Originally Posted by tchaz

Yes - I've been searching through that - but, for example, is the link you gave me available through a menu on the wiki somewhere. Sorry for the idiot qs. & congrats again on the software.

Found this - menu on the left-hand side of the wiki page (for anyone else who didn't see at first glance).

Quote

03-17-2009 , 09:58 AM

#1214

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by Kris8400

Probably the first thing to do after you have installed and can see the gui is to bulk import some files. Select Bulk Import from the menu, then navigate to some existing hand histories. Bulk import will let you import a file or a whole folder--a folder might take hours, so just import a file first. When the bulk import is complete, take a look at graphs and player stats under the Viewers menu--you should have something to see.

Hmmm, once upon a time I wrote a howto HUD, it isn't in the wiki. For the HUD to work:

You must be playing on a supported site. Basically, auto import waits until it sees a new hand in you hand history folder and then tells the HUD about it. The HUD will display info from that hand.
Also click the browse buttons on the autoimport gui to make sure it is pointed at the correct folders. The default folders can be specified in the config file. Then click "Start Autoimport".

Quote

03-17-2009 , 12:21 PM

#1215

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by Eleatic Stranger

That alter table statement looks like it would work, sort of. We have also defined a whole bunch of foreign keys which are not supported by myISAM, so they would have to be dropped before you can alter the tables. There are also a ton of commit statements in the code. They would do nothing with myISAM tables (I'm pretty sure they don't cause an error.), but they would still take some time.

We drop the foreign keys at about line 133 in fpdb_simple.py. It is pretty simple. We currently don't use the foreign keys right now (but probably should with stuff like cascading deletes).

Quote

03-17-2009 , 02:48 PM

#1216

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by ekdikeo

My half-baked plan for HORSE support in the HUD is this:

Put a true/false entry in the config file that would be check-mixed, or something.
If check-mixed is True then when a new hand comes in we'll check the title bar of the window to get the game being played. (using xlibs in Linux or hwnd in windows--these are pretty fast so it won't slow updating). People who don't play mixed games can set check-mixed to False and will have no slowdown at all from this.
So when we update the HUD display, we'll use the stats for the game in the title bar, not the game played in the last hand.

I don't like the idea of showing stats from the previous game because "good" stats are somewhat different in the different games.

comments always welcome

Quote

03-17-2009 , 02:59 PM

#1217

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by uncooper

I'm looking in to this, and I suspect the answer is an AppleScript.

edit: meh maybe not. i'll search more tomorrow.

I would be happy to work with you on this. To get the HUD to support OS/X we'll need:

To have the gui working.
Some way to get the location of the poker table window.
Some way to read the title bar so you can get the table name, the game played, etc.
Preferrably some way to get the owner of the window (e. g., PokerStars.exe or whatever). We can program around this, probably.

One thing we do in Linux and Windows is nail the HUD to a particular poker table window so that the correct stat windows are showing when the windows are stacked. That is probably pretty optional.

edit to say that this might be helpful

Last edited by Eratosthenes; 03-17-2009 at 03:02 PM. Reason: Thought of something else. :)

Quote

03-17-2009 , 04:19 PM

#1218

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by Eratosthenes

I would be happy to work with you on this. To get the HUD to support OS/X we'll need:

To have the gui working.
Some way to get the location of the poker table window.
Some way to read the title bar so you can get the table name, the game played, etc.
Preferrably some way to get the owner of the window (e. g., PokerStars.exe or whatever). We can program around this, probably.

One other thing on this. We will also need to have a routine to identify the pc as a Mac. We currently use the os.name string to tell Linux from Windows. I am pretty sure that both Linux and OS/X report os.name as "posix".

OK, those are my 5 demands. + a getaway car

Quote

03-17-2009 , 09:31 PM

#1219

GrindUnumb

old hand

Join Date: Oct 2006 Posts: 1,359

Quote:

Originally Posted by Eratosthenes

My half-baked plan for HORSE support in the HUD is this:

Put a true/false entry in the config file that would be check-mixed, or something.
If check-mixed is True then when a new hand comes in we'll check the title bar of the window to get the game being played. (using xlibs in Linux or hwnd in windows--these are pretty fast so it won't slow updating). People who don't play mixed games can set check-mixed to False and will have no slowdown at all from this.
So when we update the HUD display, we'll use the stats for the game in the title bar, not the game played in the last hand.

I don't like the idea of showing stats from the previous game because "good" stats are somewhat different in the different games.

comments always welcome

This is an interesting idea to the question that plagued me of, how could the HUD recognize the game switch until after the 2nd hand. This is especially good when you get to the Razz/Stud/Stud8 stretch. Not having the right stats could easily get confusing.

Quote

03-18-2009 , 01:04 AM

#1220

Eleatic Stranger

journeyman

Join Date: Sep 2008 Posts: 292

Quote:

Originally Posted by Eratosthenes

I'll try it out, then, proceeding very cautiously. MyISAM ought to be somewhat faster: the few minutes of research I did indicated that INNODB can be noticeably faster where there are multiple simultaneous insertions into the same table taking place, since it locks individual rows, not whole tables. Evidently INNODB is often faster in server applications. But Fpdb, I think, only updates or inserts one thing at a time, being strictly a single-user application.

At any rate, this is not something to be decided theoretically. I'll report back on results if I can get it to work.

The lack of support for foreign keys was one of the objections to SQLite. I think they would be dispensable if Fpdb were very careful with how it deletes records.

Quote

03-18-2009 , 04:31 AM

#1221

BandiChime

banned

Join Date: May 2008 Posts: 1,787

wow, fpdb is coming along nicely

Quote

03-18-2009 , 11:31 AM

#1222

Kris8400

newbie

Join Date: Jun 2008 Posts: 25

So I finally got things more or less working and I'm still deeply impressed by this app.

Some more questions that I couldn't answer by reading the thread:

-is there a definitive solution to make the HUD labels "stick" to a player? Right now they're all over my desktop/table

-does graphing work? I know it doesn't for me, I did install the necesary python libs

Also color in the HUD would be nice but I guess I'm not the first to come up with that brilliant plan

Quote

03-18-2009 , 12:15 PM

#1223

Kris8400

newbie

Join Date: Jun 2008 Posts: 25

Oh, also: the path to the HH files needs to be entered again at each startup.

Please tell me if I'm nagging and pointing out the obvious.

About the graphing: console displays error "Either 0 or more than 1 site matched-EEK"

Here's my error log:

Code:

D:\Program Files\fpdb\pyfpdb\fpdb.py:247: DeprecationWarning: use gtk.UIManager
  self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\GuiGraphViewer.py", line 59, in generateGraph
    sitenos.append(self.siteid[site])
KeyError: u'Full Tilt'
Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\GuiGraphViewer.py", line 59, in generateGraph
    sitenos.append(self.siteid[site])
KeyError: u'Full Tilt'
Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\GuiGraphViewer.py", line 59, in generateGraph
    sitenos.append(self.siteid[site])
KeyError: u'Full Tilt'
Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\GuiGraphViewer.py", line 59, in generateGraph
    sitenos.append(self.siteid[site])
KeyError: u'Full Tilt'
Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\GuiGraphViewer.py", line 59, in generateGraph
    sitenos.append(self.siteid[site])
KeyError: u'Full Tilt'
Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\GuiGraphViewer.py", line 296, in exportGraph
    self.fig.savefig(self.exportDir, format="png")
AttributeError: 'GuiGraphViewer' object has no attribute 'fig'
D:\Program Files\fpdb\pyfpdb\GuiAutoImport.py:92: GtkWarning: gtk_file_system_win32_get_parent: assertion `g_path_is_absolute (filename)' failed
  dia_chooser.set_filename(current_path)
D:\Program Files\fpdb\pyfpdb\GuiBulkImport.py:93: GtkWarning: gtk_file_system_win32_get_parent: assertion `g_path_is_absolute (filename)' failed
  self.chooser.set_filename(self.settings['bulkImport-defaultPath'])
Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\GuiGraphViewer.py", line 59, in generateGraph
    sitenos.append(self.siteid[site])
KeyError: u'Full Tilt'
Traceback (most recent call last):
  File "D:\Program Files\fpdb\pyfpdb\GuiGraphViewer.py", line 59, in generateGraph
    sitenos.append(self.siteid[site])
KeyError: u'Full Tilt'

Last edited by Kris8400; 03-18-2009 at 12:21 PM.

Quote

03-18-2009 , 12:18 PM

#1224

Kris8400

newbie

Join Date: Jun 2008 Posts: 25

wtf double post, now I'm really ****ing up the thread.

Quote

03-18-2009 , 12:21 PM

#1225

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by Kris8400

Oh, also: the path to the HH files needs to be entered again at each startup.

Please tell me if I'm nagging and pointing out the obvious.

Set HH_path in the config to make this persistent. Not being able to save this setting back to config is an old "bug"

We've had good intentions of writing a config dialog for a while now.

Quote

Page 49 of 377

First

29 39 44 45 46 47 48 49 50 51 52 53 54 59 69 99 149 249

Last

Post Reply Subscribe

...

Page 49 of 377

First

29 39 44 45 46 47 48 49 50 51 52 53 54 59 69 99 149 249

Last