Hi Dale--

We would be happy to have another contributor to the project. Python is very easy to get started with and doesn't take long to actually start producing some decent code. After PHP, you might think that you've died and gone to heaven when you start coding in Python. Python isn't basic redux, it has a ton of advanced features that are fun to work with, too.

S0rrow's suggestion for a starting project is a good one. One thing that is going to get a lot of effort over the next couple of weeks is calculating stats from our new internal hand history format. That will be something like 30 fairly short and fairly simple (and some not so simple) functions. We're not quite ready for that, but should be in a few days.

You will probably be happiest and most productive working on things that you want to work on, so just use fpdb and play some poker and see what ideas you have.

In Windows, the graphing libraries for 2.6 do not include compatibility with the GTK libraries that we use for the windowing functions. At least, they didn't last time I looked. If there are official 2.6 versions of these libraries, then that should be there.

I looked at the wiki, but could not find what I was looking for. Is there a list of acceptable stats that can be entered in the HUD config file? Also, with the exact commands as needed to be entered in the HUD config file. Thanks

Dog

http://fpdb.wiki.****************/Howto+HUD is probably the most complete document we have at the moment, and its not that complete...

You can get the up-to-the-minute list by asking the Stats.py module. Open a terminal window and navigate to the pyfpdb folder (where fpdb.py is stored). Then run the Stat.py module. It will print a mess of test info and then the available stats. On my system it looks like this:

On a Windows system the correct command is "python Stats.py".

I had a near crash today and it got me thinking...(first time in a long time

I have a great backup program and need to know specifically what file/directory should I be backing up to save my database. Is it the Mysql directory itself? I don't see a database file. Or, is it hidden in the AppData directory somewhere.

I'm running Window's Vista. Thanks... I just went and looked under c:\Program Files\MySQl and there is a file "mysqld.pdb" which is the largest file and I assumed to be the database. Otherwise, I will just continue backing up that whole directory.

Dog

Short answer: If you installed mysql by my instructions you have a program called something like "Mysql Administrator" that should be in your start menu. It is a gui program that can backup and restore your db.

My typical long answer:
MySQL uses different file locations for different OSs, trying to put them where they belong for the particular OS. On my XP system the database files are in:
MySQL makes a file for each database table. On my linux box it looks like this:
Vista probably sticks the files somewhere else. You could probably do the "find files" thing and look for HandsPlayers.frm

I think you can back up by just backing up the .../fpdb folder (there may be complications in doing it this way). MySQL supplies an easier to use backup program called MySQLdump (they could get the marketing dept working on that name). Here is the command I use to back up my mythtv database:
user name - its in the HUD_config file
name of database - ditto
BU file name
it will prompt for your mysql password, also in the config

Note to git repo users:

The code in the git repos is getting a lot of work right now and is spectacularly broken. Now would be a good time to NOT update from the repo.

I'm going to try to get things working and I'll post here again when it is safe to use the repos.

I made a clear table and bulk import

I'm trying to autoimport a live PS game and it says following: failed to read a single hand from file: <closed file 'C\location of the game file

so far I'm not able to do anything with this poker tracker besides making succesful install(?).

my guess is it should be possible to analyze old hands/SnG/tournaments and be able to have live stats on other players preflop raises and so on..(?) similar to commercial pokertracker and other apps?

anyone know what my problems?

edit---> I start the pokertracker though fpdb.py doubleclick

Has anyone gotten this to work on a Vista 64-bit system? If so, which version of python did you install, 32-bit or 64-bit? Better yet, if anyone has successfully gotten this to work on a Vista 64-bit system then please list the exact software packages you used. I keep getting:

"Traceback (most recent call last):
File "HUD_main.py", line 52, in <module>
import Hud
File "H:\Poker Software\fpdb project\fpdb_0.11.2\pyfpdb\Hud.py", line 36, in <module>
import win32gui
ImportError: No module named win32gui"

in the HUD-errors.txt file. I have searched in the Python25 directory for any files named win32gui and can't find them, so can't get hud to work at all.

Getting fpdb to work on vista is mildly painful--the environment installer doesn't work with Vista. The immediate problem is that you don't have the win32gui module installed. See this post for the easy way to get the required modules installed on Vista.

As a non programmer, I probably shouldn't even respond to this. But, I am running it and getting the hud and stats, on Vista with the 64bit dual processor. Have patience and faith, it does work, and well.... well, it works but am anxious to see further development.

I am running Python 2.6 and MySql 5.1 (which is not the latest as I have recently seen newer versions) but "if it ain't broke, why fix it?" is my motto. And I am running FPDB version 11.1

I did one thing that seemed to help. I set up the directory and all the files in Python to "run as administrator" just to make sure, as well as Mysql. I did the "properties" opening and any file in those two directories that would allow me to change the "run as administrator", then I clicked that box. Also, it wanted to put Python, by default, in c:\Program Files\Python26 directory. But after having problems, I read some docs on that site and it suggested the root c:\Pyton26 instead.

Between all the changes to "run as admin" and moving/installing Python26 to the root c: directory, one or many of them seemed to do the trick. I also had some password problems with Mysql and with help from Sorrow, got that fixed. Can't remember what we did though... my mind is too old to remember beyond a couple of days ago

Keep at it. I love how mine works. I gave up three times, but then it worked and while not yet polished, I feel I'm at least part of the pack.

Dog

Thanks for this Dog. I'm going to make a "Random Vista Advice" page on the wiki and put this and the link to ekdikeo's files on it. (unless one of you quickly objects)


Regarding versions of mysql, etc. Any modern version of mysql or postgesql (etc.) should be fine. We are not using any bleeding edge features of the modules we depend on. Any 5.x version of mysql should be fine.

Python 2.5 was the current version when we made our first release and we sort of made that the minimum Python version, though I chatted with a guy who was running on 2.4 with no problems. Python 2.6 has some neat features--one is multiprocessing, the ability to use more than 1 core on multicore processors. We will add the ability to use multiple cores, but we'll try to make it compatible with previous Python versions. If keeping compatibility is too big of a problem, upgrading to Python 2.6 is not a big deal.

Fpdb will not run on Python 3.x. Python 3.x is not ready for prime time (and that is from the python devs). Going from 2.x to 3.x will requrire a significant amount of work to update source code (I think) and give us the opportunity to introduce subtle (and not-so-suble) bugs. We won't even think about it until all of the 3rd party modules have 3.x compatible versions--that could be a while.

I have vista business is this the reason why I see no hud or any kind of stats when usung fpdb.py?

is there any poker tracking software that is vista friendly?

Vista is not very software-friendly. But, yes, FPDB can and does work on Vista.
The package that I put together which was mentioned a couple of posts back should work for it, although I don't have Vista on any of the family computers anymore save one that I'm not allowed to play poker from, so I can't check what needs to be done.

era - Python 2.5/2.6 may be where it stops - a huge quantity of the modules out there aren't even being compiled for 2.6 let alone 3.0. They're already moving on to 3.1 or 3.2 or something like that, when 3.0 isn't even useful.

2.6 works fine, although in Windows, graphing won't work. I'm getting a new hard drive in about a week, so maybe I'll have space to fix some of these issues with python modules not being compiled for 2.6.

There are two patches - something between bugfixes and hacks
1. i think program has to check and create folders before writing HH
2. it seems that ftp changed their HH format. So there are 'fix'. It's working for me

code

P.S. Patches for the latest revision 0c36ab0bdaf...

Thanks grindi - We Linux people haven't ahd Fulltilt working since the update.

I'll take a look this evening.

Well, get ready. In the Software Improvement thread PokerStars employee "Alex" who oversees that thread, announced that a new update will more than likely be out tomorrow (Thursday) morning. While he would not give the details of all changes, he did "mention" that there was a change to the HH format, so be ready for reading/file problems. Just thought I'd pass that along. Here's the link..... which you will prob understand better than me.

http://forumserver.twoplustwo.com/45...2009-a-538315/

Dog

Thanks Dog--

I look at that thread every few days, but would have certainly missed this.

This will break 0.11.2 (and earlier). I'll get out 0.12 (or something) ASAP (<-- P stands for possible!). I'm not really happy about releasing this now because the new database schema is only partially implemented. (for example, stud players will see stats in the HUD, but not in the player stats window and tournaments don't import at all) Everyone using 0.11.* will have to recreate their db and reimport all their hand histories with the new release.

I just installed FPDB in hopes of using it and I have followed the steps listed on the wiki that was posted somewhere in this thread.

Whenever I click on the FPDB.py i get an error that says that it failed to load the libraries for graphing and that I should install numpy and matplotlib even though I have installed them.

Also, how do I get this thing to work. Sorry. I'm not really familiar with everything that is going on here. =[

Those warnings about numpy and matplotlib just affect graphing. (That is graphing won't work unless you install them.) If everything else is installed properly you should be OK.

You should see the main gui. Go to Import menu and select Bulk Import. You should be able to import Stars or FTP files. Then look at the Player Stats page under the Viewers menu.

Alright I did that. But i don't get how I can get the HUD to work while I play. When i go to the Player's Stats I can see my stats and everything but when I play how do i see the VPIP or PFR of my opponents?

Patch 1

Patch 2

Eratosthenses will pull this in to his repo soon.

What do you think, would it be a hell of work taking the importer sourcecode and modify it in order to match the HM database structur in order to have a faster hand importer? I think a standalone importer maybe with multiple threads would be a lot faster. How fast does the FPDB import hands?

HEM doesn't work on Linux and most of the devs do, so its unlikely to ever happen. We are open source, so if you'd like to try you are more than welcome.

Writing to import into HEM is a lot of work but doable.

Hand parsing is quite fast on fpdb, but actual inserts into the database are slow. We are working on that, but it's not that high on the priority list.