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

09-17-2010 , 01:25 PM
Quote:
Originally Posted by yendry
The Hud problem was on PS. But i solved it. The window title text is also localized. Switching PS client language from german to english solved it. Now HUD works for all kinds of tables.

In german, title bar text says:
$1,20 USD No Limit Hold'em - Turnier 312022170 Tisch 1 - Blinds $10/$20 - Eingeloggt als ***********
Thanks for that. Somewhere deep down I knew the HUD would only detect tournaments when the language was English. This is entirely fixable, but I want to think about how for a little while. I'll try to get this in by the next snapshot, it sort of depends on how soon Steffen wants to get the next snap out.

Quote:
Originally Posted by PhenixRising
$0.10 NL Hold'em [Turbo, 360 Players] - Tournament 312088316 Table 9 - Blinds $15/$30 - Logged in as --------
I don't see what's wrong with this, but I'll work on it next.

To expand on what ekdikeo said: The HUD finds the poker client windows by asking the operating system for the list of windows and their titles. Then it sorts through the list to find the windows it needs. It doesn't really matter whether the window in question is on top or hidden.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2010 , 07:00 AM
hey I just got the 20.1 version and the HUD doesn't work. I use a windows 7 OS. Can anyone help? I used to run a earlier version and it worked fine... is there a new python upgrade or something? thx
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2010 , 11:54 AM
I still havent figured out how to access/view handhistory files?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2010 , 06:36 PM
This project is amazing--thank you. It took me 15 seconds of seeing the hud to realize one reason why I am very, very bad at razz.
I have a random question--where do the database files live? There are some things I'd like to do with the data (sort stud hands by starting hand, for example, which I think fpdb doesn't do yet), but I don't know what files they are in.
My database manipulation skills are basically nonexistent, but if I could, say, export the hands into a CSV file, I could at least do a couple things in Excel (weak, I know).
I'm running .20 on Windows 7 with whatever the default database is--sqlite? I have postgresql installed but I don't think it's using it.
Thanks again.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2010 , 10:29 PM
Quote:
Originally Posted by L0s3rAL0t
hey I just got the 20.1 version and the HUD doesn't work. I use a windows 7 OS. Can anyone help? I used to run a earlier version and it worked fine... is there a new python upgrade or something? thx
Were you running FPDB on Windows 7 previously?

Quote:
Originally Posted by Nitrub
I still havent figured out how to access/view handhistory files?
That feature doesn't exist yet Nitrub

Quote:
Originally Posted by gammoner
This project is amazing--thank you. It took me 15 seconds of seeing the hud to realize one reason why I am very, very bad at razz.
I have a random question--where do the database files live? There are some things I'd like to do with the data (sort stud hands by starting hand, for example, which I think fpdb doesn't do yet), but I don't know what files they are in.
My database manipulation skills are basically nonexistent, but if I could, say, export the hands into a CSV file, I could at least do a couple things in Excel (weak, I know).
I'm running .20 on Windows 7 with whatever the default database is--sqlite? I have postgresql installed but I don't think it's using it.
Thanks again.
We had some discussion on how to represent Razz/Stud starting hands a while ago - do you have any suggestions on how this should be done?

The sqlite database is usually called fpdb.db3, and exists in %APPDATA%/fpdb

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-21-2010 , 11:17 AM
Cool, thanks. I was able to export some things into excel but underestimated the size of the database, and I realized that I didn't know how to cross-check what things are in what columns. Also there were commas in the numbers it seems, so converting through a CSV failed. Maybe it's time I actually learn some sql...

I'm sure I'm reiterating already made points, but for Razz it doesn't seem unreasonable to just list them all, since there are...91 downcard combos*13 upcards = 1183 hands. For stud hi and stud-8 though, hmm...858 3-flushes, 858 unpaired 2-suiters (ignoring which cards are suited), and 858 unpaired rainbow, 13 rolled, 156 wired pairs with a suited kicker, 156 without a suited kicker, 156 split pairs suited, 156 split pairs unsuited. Seems like a lot. You could maybe pare down the flushes by high card (Axxs, Kxxs, ...) although the upcard is fairly important. I guess you could also cut down the unpaired cards by straight possibility--so AKQ, AKJ, AKT would be separate but AKx could be everything else.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-21-2010 , 12:53 PM
Quote:
Originally Posted by gammoner
Cool, thanks. I was able to export some things into excel but underestimated the size of the database, and I realized that I didn't know how to cross-check what things are in what columns. Also there were commas in the numbers it seems, so converting through a CSV failed. Maybe it's time I actually learn some sql...
There is a nice free app to let you sleuth around in sqlite files called sqlitemanager. I use it a lot when debugging my crappy SQL. You still have to use SQL to do much.
Quote:
I'm sure I'm reiterating already made points, but for Razz it doesn't seem unreasonable to just list them all, since there are...91 downcard combos*13 upcards = 1183 hands. For stud hi and stud-8 though, hmm...858 3-flushes, 858 unpaired 2-suiters (ignoring which cards are suited), and 858 unpaired rainbow, 13 rolled, 156 wired pairs with a suited kicker, 156 without a suited kicker, 156 split pairs suited, 156 split pairs unsuited. Seems like a lot. You could maybe pare down the flushes by high card (Axxs, Kxxs, ...) although the upcard is fairly important. I guess you could also cut down the unpaired cards by straight possibility--so AKQ, AKJ, AKT would be separate but AKx could be everything else.
It would be a quick job to populate the startCards for the stud games. Razz first! I was thinking something like rough, smooth 8s and 7s, all 6s, all wheel draws. Then various 2 cards hands. Then everything else. Another way would be to use Dan Abrams's (SGspecial) rating system. I am open to suggestions on this.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-21-2010 , 12:55 PM
Quote:
Originally Posted by L0s3rAL0t
hey I just got the 20.1 version and the HUD doesn't work. I use a windows 7 OS. Can anyone help? I used to run a earlier version and it worked fine... is there a new python upgrade or something? thx
What site? What game (holdem, omaha)? STT|MTT|cash? This sounds like the problem with the client title bar (see a few posts up). If so, I need the contents of the title bar.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-21-2010 , 02:02 PM
I don't know if it's ok to ask beginner questions in here, but I just started using the program and it works fine for NL and PLO cash, also the HUD. Bt I somehow can't get it to track any sngs. what am I doing wrong? In the History folder it shows a summary-txt file and a Nol Limit Hold'Em.txt file for every sng, but I can't graph them or anything.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-21-2010 , 09:55 PM
With game types, fpdb just inserts a new row with a unique ID (right?) when we import a hand from a new limit. Is there merit to taking a similar approach to starting hands? It could ignore hands that hero doesnt VPIP.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-22-2010 , 01:22 AM
Quote:
Originally Posted by gammoner
I'm sure I'm reiterating already made points, but for Razz it doesn't seem unreasonable to just list them all, since there are...91 downcard combos*13 upcards = 1183 hands.
And how would you like them ordered? By upcard then low/high?

You don't happen to know of a complete listing anywhere do you?

Quote:
Originally Posted by M.C.Escher
I don't know if it's ok to ask beginner questions in here, but I just started using the program and it works fine for NL and PLO cash, also the HUD. Bt I somehow can't get it to track any sngs. what am I doing wrong? In the History folder it shows a summary-txt file and a Nol Limit Hold'Em.txt file for every sng, but I can't graph them or anything.
What do you mean by 'track' - it appears your hud is working, are you saying that the HUD isn't working for FTP SnGs?

Quote:
Originally Posted by uncooper
With game types, fpdb just inserts a new row with a unique ID (right?) when we import a hand from a new limit. Is there merit to taking a similar approach to starting hands? It could ignore hands that hero doesnt VPIP.
Sure - but you need an ordered representation.

eg. with holdem we represent:

0 Unknown / Illegal cards
1 22
2 32o
3 42o
...
14 32s
15 33
16 42o
...
170 AA

170 is a manageable number, and fairly useful for seeing where you are leaking in your game over a large sample.

Basically we need to create a 'magical' 1-1 mapping between the actual start cards that is a useful representation for players (32o is much more useful than 3h2c + every other possible combination of 32o)

With Razz it would appear we don't care about suits, only card values and upcards - Still leaving 1183 start hand combos. Studhi/low order, suits and wired/open pairs matter, so another explosion in combos, and contemplating Omaha/8/Badugi/Draw make my brain hurt - especially when I dont play the games at all.

We could already do exact starting hands, but we are looking for something better that comes from what the players themselves actually want.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-22-2010 , 05:30 AM
Quote:
Originally Posted by sorrow


What do you mean by 'track' - it appears your hud is working, are you saying that the HUD isn't working for FTP SnGs?

well, it does nothing. I can't graph them, can't get stats. Just doesnt convert them?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-22-2010 , 09:22 AM
Quote:
Originally Posted by M.C.Escher
well, it does nothing. I can't graph them, can't get stats. Just doesnt convert them?
never mind. I misread your message.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-22-2010 , 04:46 PM
I haven't been here in awhile. Im still using fpdb-0.20pre3, but i notice that there have been some new releases. What's new in fpdb-0.20.1noSSE.exe?

Any stat changes or additions?


Thank you!
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-22-2010 , 06:51 PM
Quote:
Originally Posted by arsenal6
I haven't been here in awhile. Im still using fpdb-0.20pre3, but i notice that there have been some new releases. What's new in fpdb-0.20.1noSSE.exe?

Any stat changes or additions?


Thank you!
Here's the details to the most recent major release

http://forumserver.twoplustwo.com/sh...postcount=3803

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-23-2010 , 05:45 AM
Quote:
Originally Posted by M.C.Escher
well, it does nothing. I can't graph them, can't get stats. Just doesnt convert them?
FPDB has been primarily focused on cash games, and until _very_ recently there was no way for tourney results to actually be imported, and from a user perspective it is still very limited.

In the development tree to be released in the next week or so, there is a way to import Stars tourney results from email using IMAP, and a command line way to import some FTP results.

Should you manage to actually import the results:

http://****************/apps/wordpres...esults-graphs/

Basically, this is a feature in its infancy right now an will take a couple of months to become usable.

Sorrow.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-23-2010 , 06:42 PM
I've had an on-going problem over several releases. Today, I deleted all my log files so that if it happened during today's play, I'd have clean logs with just today's data.

I will be playing along, and suddenly I can hear my HD going into hyper drive. The screen will lock up. I can't respond to PStars. Since this as been increasing (five times today), I've been opening "Task Manager" and keeping it in the background. The only way my screen unlocks is to quickly jump to Task Manager and close the two "python.exe" files that are running. I have no idea why two always run. I assume one for the database, one for the hud.

After shutting down just now, I looked at my logs and I keep getting the following error, it seems, just before the harddrive activity starts in. it is "errno 9 bad file descriptor".... is that similar to "Love Potion #9". Now, I can't get that song out of my head.

Sorrow, I've zipped the four log files, and the HH file for what "seems" to have started the most recent crash. I'll email them all to you zipped. Thanks

Dog

p.s. Forgot to mention, running 20-906 the source version, not the exe version on Vista.
If I should not have sent those files to you, Sorrow, tell me who to forward them to instead. Thanks again.

Last edited by 1meandog4u; 09-23-2010 at 06:53 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-24-2010 , 03:10 AM
Quote:
Originally Posted by 1meandog4u
After shutting down just now, I looked at my logs and I keep getting the following error, it seems, just before the harddrive activity starts in. it is "errno 9 bad file descriptor".... is that similar to "Love Potion #9". Now, I can't get that song out of my head.
The logging function is dying for some reason - i've no idea why.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-24-2010 , 08:49 AM
Quote:
Originally Posted by 1meandog4u
I've had an on-going problem over several releases. Today, I deleted all my log files so that if it happened during today's play, I'd have clean logs with just today's data.

I will be playing along, and suddenly I can hear my HD going into hyper drive. The screen will lock up. I can't respond to PStars. Since this as been increasing (five times today), I've been opening "Task Manager" and keeping it in the background. The only way my screen unlocks is to quickly jump to Task Manager and close the two "python.exe" files that are running. I have no idea why two always run. I assume one for the database, one for the hud.
I'm not familiar with how this works with windows, but yeah, you should have 2 processes, 1 for fpdb = importer, etc and 1 for the hud. Fpdb starts and stops the hud process as needed.
Quote:
After shutting down just now, I looked at my logs and I keep getting the following error, it seems, just before the harddrive activity starts in. it is "errno 9 bad file descriptor".... is that similar to "Love Potion #9". Now, I can't get that song out of my head.
I closed my eyes, I took a drink.
Quote:
Sorrow, I've zipped the four log files, and the HH file for what "seems" to have started the most recent crash. I'll email them all to you zipped. Thanks

Dog

p.s. Forgot to mention, running 20-906 the source version, not the exe version on Vista.
If I should not have sent those files to you, Sorrow, tell me who to forward them to instead. Thanks again.
As a temp fix, I think you can start fpdb with the -x command line option and it will log to the terminal instead of the log file.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-24-2010 , 06:30 PM
Quote:
Originally Posted by Eratosthenes
I closed my eyes, I took a drink.
http://www.youtube.com/watch?v=7rXhXLsNJL8

Quote:
As a temp fix, I think you can start fpdb with the -x command line option and it will log to the terminal instead of the log file.
Tried it. It was fine for about 45 mins, then the hard drive kicked in, logs showed the "errno 9 bad file descriptor" and she locked up.. thanks for the try. Guess I'll just live with it and keep Task Manager open so I can quickly close python.exe if necessary.

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-25-2010 , 01:00 AM
1meandog, are you using an external database such as mysql or pgsql ? or are you using the built in sqlite?

it sounds to me like the connection to the database is closing unexpectedly, perhaps the database is crashing? unsure.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-25-2010 , 01:04 AM
Quote:
Originally Posted by ekdikeo
1meandog, are you using an external database such as mysql or pgsql ? or are you using the built in sqlite?

it sounds to me like the connection to the database is closing unexpectedly, perhaps the database is crashing? unsure.
I'm using the default sqlite that comes with the source version 20-906

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-25-2010 , 11:42 AM
Quote:
Originally Posted by 1meandog4u
It was fine for about 45 mins, then the hard drive kicked in, logs showed the "errno 9 bad file descriptor" and she locked up..
Do you by any chance have a separate, automated HH archiver running? The importer doesn't check the existence of the file at every read (it was there when it was opened, so we pretty much assume it remains in place). The behaviour you describe sounds a lot like the HH file itself has been suddenly removed.

Just a wild guess, but it would make sense.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-25-2010 , 12:02 PM
Quote:
Originally Posted by Bostik
Do you by any chance have a separate, automated HH archiver running?
Since I don't know what that is, probably not. Every night at 9pm local time/midnight Eastern time I sit down manually. I zip all that day's HH with WinRar and store them on a separate backup drive I keep. Winrar, by setup, clears and deletes the zipped files. So, I start every "new day" with a clean HH file in c:\Program Files\PokerStars\HandHistory\xxxxx there's not even a build up there to cause this problem.

I have no virus. I have the cpu set to auto start thru the bios early morning, run AVG scan, run a defrag, then faithfully wait for me to finish my morning mug of tea and cig. It starts as clean as anything can start every day.

I can have nothing else running in the background... browser, email client etc etc, all closed down, and it still happens. The only thing running is a clipboard extender program. But that's been there since day one with no problems. I even closed it for a day, and it still locked up. Hard to trace this "errno 9 bad file descriptor"... and that might not even be related, just a coincidence.

Thanks for still thinking about it. Going to go delete all my log files again, and start fresh this morning. If/when it locks up, I will zip and save all the log files at that instant.

Dog

Last edited by 1meandog4u; 09-25-2010 at 12:09 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-25-2010 , 02:28 PM
Okay, it just locked up after about and hour and a half of playing. No hand errors or other errors appeared in either "fpdb-errors.txt" or "hud-errors.txt" files.

But... in the "hud-log.txt" file here is what appeared...

HTML Code:
HUD_main: starting ... Traceback (most recent call last): File "C:\Python26\lib\logging\handlers.py", line 74, in emit if self.shouldRollover(record): File "C:\Python26\lib\logging\handlers.py", line 145, in shouldRollover msg = "%s\n" % self.format(record) File "C:\Python26\lib\logging\__init__.py", line 637, in format return fmt.format(record) File "C:\Python26\lib\logging\__init__.py", line 425, in format record.message = record.getMessage() File "C:\Python26\lib\logging\__init__.py", line 295, in getMessage msg = msg % self.args TypeError: not all arguments converted during string formatting Traceback (most recent call last): File "C:\Python26\lib\logging\handlers.py", line 74, in emit if self.shouldRollover(record): File "C:\Python26\lib\logging\handlers.py", line 145, in shouldRollover msg = "%s\n" % self.format(record) File "C:\Python26\lib\logging\__init__.py", line 637, in format return fmt.format(record) File "C:\Python26\lib\logging\__init__.py", line 425, in format record.message = record.getMessage() File "C:\Python26\lib\logging\__init__.py", line 295, in getMessage msg = msg % self.args TypeError: not all arguments converted during string formatting -----------------------------------------------------------Creating hud from hand 13173 -----------------------------------------------------------Creating hud from hand 13175 -----------------------------------------------------------Creating hud from hand 13179 -----------------------------------------------------------Creating hud from hand 13181 C:\Program Files\fpdb906\pyfpdb\Hud.py:507: GtkWarning: gdkwindow-win32.c:2066: SetWindowLongPtr failed: Invalid window handle. s.window.destroy() C:\\Program Files\\fpdb906\\pyfpdb\HUD_main.pyw:133: GtkWarning: gdkwindow-win32.c:2066: SetWindowLongPtr failed: Invalid window handle. HUD_main: starting ...
Traceback (most recent call last):
  File "C:\Python26\lib\logging\handlers.py", line 74, in emit
    if self.shouldRollover(record):
  File "C:\Python26\lib\logging\handlers.py", line 145, in shouldRollover
    msg = "%s\n" % self.format(record)
  File "C:\Python26\lib\logging\__init__.py", line 637, in format
    return fmt.format(record)
  File "C:\Python26\lib\logging\__init__.py", line 425, in format
    record.message = record.getMessage()
  File "C:\Python26\lib\logging\__init__.py", line 295, in getMessage
    msg = msg % self.args
TypeError: not all arguments converted during string formatting
Traceback (most recent call last):
  File "C:\Python26\lib\logging\handlers.py", line 74, in emit
    if self.shouldRollover(record):
  File "C:\Python26\lib\logging\handlers.py", line 145, in shouldRollover
    msg = "%s\n" % self.format(record)
  File "C:\Python26\lib\logging\__init__.py", line 637, in format
    return fmt.format(record)
  File "C:\Python26\lib\logging\__init__.py", line 425, in format
    record.message = record.getMessage()
  File "C:\Python26\lib\logging\__init__.py", line 295, in getMessage
    msg = msg % self.args
TypeError: not all arguments converted during string formatting
------------------------------------------------------------
Creating hud from hand 13173
------------------------------------------------------------
Creating hud from hand 13175
------------------------------------------------------------
Creating hud from hand 13179
------------------------------------------------------------
Creating hud from hand 13181
C:\Program Files\fpdb906\pyfpdb\Hud.py:507: GtkWarning: gdkwindow-win32.c:2066: SetWindowLongPtr failed: Invalid window handle.
  s.window.destroy()
C:\\Program Files\\fpdb906\\pyfpdb\HUD_main.pyw:133: GtkWarning: gdkwindow-win32.c:2066: SetWindowLongPtr failed: Invalid window handle.
  self.hud_dict[table].main_window.destroy()
And, in the fpdb-log.txt file this appeared ....

HTML Code:
fpdb starting ...Traceback (most recent call last):
  File "C:\Python26\lib\logging\__init__.py", line 766, in emit
    self.flush()
  File "C:\Python26\lib\logging\__init__.py", line 740, in flush
    self.stream.flush()
IOError: [Errno 9] Bad file descriptor
Traceback (most recent call last):
  File "C:\Python26\lib\logging\__init__.py", line 766, in emit
    self.flush()
  File "C:\Python26\lib\logging\__init__.py", line 740, in flush
    self.stream.flush()
IOError: [Errno 9] Bad file descriptor
Traceback (most recent call last):
  File "C:\Python26\lib\logging\__init__.py", line 766, in emit
    self.flush()
  File "C:\Python26\lib\logging\__init__.py", line 740, in flush
    self.stream.flush()
IOError: [Errno 9] Bad file descriptor
Traceback (most recent call last):
  File "C:\Python26\lib\logging\__init__.py", line 766, in emit
    self.flush()
  File "C:\Python26\lib\logging\__init__.py", line 740, in flush
    self.stream.flush()
IOError: [Errno 9] Bad file descriptor
C:\Program Files\fpdb906\pyfpdb\fpdb.pyw:1255: Warning: g_main_context_prepare() called recursively from within a source's check() or prepare() member.
  gtk.main()
C:\Program Files\fpdb906\pyfpdb\fpdb.pyw:1255: Warning: g_main_context_check() called recursively from within a source's check() or prepare() member.
  gtk.main()
Not sure if that will help point anything out or not. I had to close using Task Manager again, by closing the two python.exe files.

One other question.. until I get this resolved I can't risk a lock-up during a critical hand. So, can I just run the auto import when I sit out for a break, then shut it down while I'm playing and the hud should still show, right? Then at an opportune time (waiting for blinds while sitting out etc etc) just click auto import to update the hud, then stop it till the next convenient pause in the action... that should work (meaning the hud will show the updated info)... right?

Dog

Last edited by 1meandog4u; 09-25-2010 at 02:36 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m