Well, you know how you can look at your stats on the Ring Player Stats tab? If you change your screen name on that page to the screen name of someone else you can look at their stats.

Probably not much fun if you want to do it for a lot of players but ok for occasional use.

Edit:

If you know what you're doing and have the ability to run queries on the database you could check out the stats calculation queries and rig something up. I can only imagine there would be pain involved though.

Actually im studying computer sciences and I'll have to go through running queries at some point but, until then I'd rather pass for now

Switching the Ring Player Stats "PokerStars id" works just fine for anyone wanting to dig up the stats for a certain player while running hand history reviews.

Thank you very much Phil, you guys are doing a great job! I hope I can free up some time to learn python to help you guys develop fpdb further!
Thanks again!

Hi,

I'm trying to install fpdb on Ubuntu 14.04 using a MySQL database. I followed the installation instructions on http://fpdb.wikidot.com/install:_main for Ubuntu. Everything seemed to work perfectly until I eventually tried to run fpdb. Upon running it by i get the following error in terminal:

Python 2.7...

Reading configuration file /home/darragh/fpdb/HUD_config.xml

config : ERROR Error parsing example file /usr/share/python-fpdb/HUD_config.xml.example. See error log file.
Loading site PokerStars
Loading site Full Tilt Poker
Loading site Everleaf
Loading site Win2day
Loading site Absolute
Loading site PartyPoker
Loading site Carbon
Loading site OnGame
Loading site PKR
Loading site Winamax
Loading site Everest

Logfile is /home/darragh/.fpdb/log/fpdb-log.txt

Failed to read settings table - please recreate tables

I also get a warning : An invalid DB version or missing tables have been detected. This error is not necessarily fatal but it is strongly recommended that you recreate the tables using the Database menu. Not doing this will likely lead to misbehavior including fpdb crashes, corrupt data etc.

Unfortunately I can't recreate the tables as fpdb won't open

I've looked through the thread for a solution but can't seem to find any.

Any help would be much appreciated

Thanks,
Darragh

Hmm, those install instructions are... vintage. Did you download a release or clone from git?

I used clone, Should I download a release instead?

In a perfect world to make it easy for me to help you I'd get you to clone my repository. Unfortunately it has new dependencies (PyQt) that are not available in ubuntu stable to my knowledge. So, yeah, maybe try the 0.40.5 release from sourceforge?

Also, you might try deleting the HUD_config.xml file you created. At some point things changed so FPDB would create that for you, probably in ~/.fpdb/ - it seems like something in the config loading code is dying on you at startup.

Thanks for the help, I'll try that and let you know how I get on

Hi!

Will software will work with new full tilt 5 and 6 max tables? Lookigg hud 5max

Yes but you need to edit the config file a little bit. Search the thread for full tilt or 5max or something and you should find some posts explaining what to do.

Thank you for fast answer, i will look for another threads.

Does hud works with new seal with clubs? i try to configure and it does not work.

No, there is no support for new seals.

Hi!

First things first: THANK YOU SO MUCH! You've rescued a great tool for up and coming poker players from the grave and gave it new light!

I've been able to get it working to the point where I'm not even running the trials of the "big guys" any more, but have a few nagging issues that I wanted to ask about.

Perhaps you are already aware of these. I tried to find a "known issues" list, but came up empty.

APP related: The hole cards filter does not seem to work at all, nothing happens when I click a card button and even worse the app crashes whenever I click any of the 3 check boxes below (all/suited/off suit). I've checked the log files, and they have absolutely nothing in them related to a crash.

HUD related: The HUD doesn't seem to match the data to the correct seat. It remembers the positions of the boxes, but gets the contents incorrect (I'm playing almost exclusively PS 6-max ring games).

HUD related: Popups are 100% broken. If I right click on a HUD stat, the HUD app crashes. Again zero debug information written to the logs .

I'm more than willing to help debug, I'm a programmer by trade, however I have little to no python knowledge.

(OS: Windows 10 pro).

I'm assuming from this that you're running my latest github release, 0.41.0-rc7?

Just tested this (on OSX). Hole cards filters do work (albeit a bit clunky) for me. The checkboxes don't do anything but they don't crash it either.

Sounds like you have a preferred seat set in pokerstars, but it's not configured in FPDB? Search the thread for 'fav_seat'.

I'll have to investigate this one. It's possible the popups are misconfigured.

Edit: could not repro on OSX. Will try with my windows VM...

I'll do some testing on windows 7 and get back to you if I can't reproduce any of these issues. Cheers!

Indeed I am, though the issue also happened with rc6.

Interesting. QT issue perhaps? When I click on the card buttons, nothing happens at all. I assume they're supposed to get highlighted in some way (background/border change)? All 3 checkboxes simply exit the app instantly, no hanging, no "not responding", nothing.. Almost as if I hit Alt-F4 or hit the app close button (X).

You are correct sir, when I get back home I'll take a look through the thread.

I haven't tried starting with a default hud config, however the issue happened before I started changing much (if any) of the config.

Thanks so very much for the quick response, it's much appreciated.

Hi again! I have been using FPDB with my own modifications in order to be able to import hands from a regulated site (.es in my case).

I wanted to ask a couple of things:

1) Is it possible to display positional stats (and positional stats vs certain position) in the HUD? Something like "3BetBTN" or "BBRaiseToStealvsCO".

2) For phil_r: in your next release, would it be possible for you to add the possibility of importing the 888.es hands? It would mean just adding the option "888.es" to the PacificToFPDB.py (besides "Cassava" and "888poker". I'm asking because I do it myself, but it is giving me problems when compiling, and I see that your versions are neat and give no problems at all :P

Since I suppose that the answer for question 1 will be "No", I will anticipate it and ask: is it very complicated to create new stats? I had a look at the files you told me last time, but it looks quite messy to edit things...

I don't think those are currently supported. The closest thing would be the steal stats, which look at actions only in CO/BTN/SB/BB and responses thereto.

I just added it to my local version, so it will appear in my next release. I have no timeline for this.

Question: do your tournament summaries also have 888.es in them instead of Cassava? I'll make a similar change to PacificPokerSummary.py if you could check for me.

It depends. In the worst case, you might need to make a database schema change and re-import all your hands.

In the slightly less worse case, you might need to modify the SQL query that generates raw stats.

In the best case, you just need to add a new method for your stat in Stats.py, and you will be able to compute your new stat from information that is already in the raw stats dictionary.

I think your position-specific stats might be the middle one, but I have not investigated too deeply.

Yes, the tournaments summaries have the same structure, i.e., 888.es instead of Cassava. Thank you very much!

I will have a look and try to create the stats I *need*. If I succeed, I will let you know.

Thank you phil_r!

Hi guys, i have two problems with fpdb.
1) I can not import the 888 hands while with pokerstars works great at this

2) I can not change the position of the hud by default. All the time it appears to the left seat (lets say position 5 in a 6max table)

Are you playing in 888.com or in a regulated 888 site? (.es, .fr, .it ...). If this is the case, then fpdb does not import hands because the hand history format has a slight difference from that of 888.com. If you play in 888.com, then I don't know what the problem might be.

Again, 888 works a bit weird with SH tables. Just try different preferred sites for the 6max layout, until you find the one that corresponds to your seat.

------------

For phil_r: I have been looking for the code parts in which the stats are defined, both in SQL.py and Stats.py. However, although I can see clearly how the stats are defined in Stats.py (and it seems easy to create new stats from the raw ones) I am not able to find how these raw stats are defined.

Let's suppose I want to know how "vpi" stat is defined. In this case, in the Stats.py file, there is a function definition for this, and the mathematical operation is the following:

"stat = float(stat_dict[player]['vpip'])/float(stat_dict[player]['vpip_opp'])"

Then, I want to know how vpip is computed. Then, I run a string search on all the files in the directory "pyfpdb", obtaining the following (in SQL.py):

"sum(hc.street0VPI) AS vpip,"

I understand that this is the definition of vpip, but then, when I look for the place where "hc.street0VPI" is defined, I find that there are plenty of lines in SQL.py where it is mentioned, but I am not able to find the one where it get some value assigned. I mean, from the hands, how is the vol. putting money in computed? There should be some place in which it is stated something like

"if call OR raise preflop, then vpip=vpip+1"

I dont know if I'm being clear about this. It is a bit complicated indeed :P Is there some metadata or some information on how the database and the program is organized?

I play at 888.com, tryied the fpdb at stars and ipoker and works. I change the hand history folder and would try again. Meanwhile i can not find the right position of the hud even at stars, i change my own position and it iw weird for me that position. Anyway this is not big deal, i am interested for the 888 importing more. Thanks

I don't know of any collected documentation on the database schema. When I need to know something I read the code and try to figure it out.

In this case, towards the bottom of that query you may notice the following lines:

The "HudCache hc" part means hc is an alias for HudCache. It turns out these values are updated in the rebuildCache query:

This is very interesting. Would you be willing to email me one of your hand histories? philip.roberts@gmail.com

Done

Still a question about the favourite seat. As I understood you are supposed to edit the config file, which config file are you talking about? Where can I find it, what is the exact name of it? Is it a text document? Thank you!

If you go to the help menu in fpdb there should be an option "About, License and Copying". Somewhere on that dialog it should tell you where your config file is. It's an xml file, which is a text document that follows some rules.