Free/open source poker tracking software: FPDB - (Release Candidate 0.29.905) - 17 Feb 2012 - Page 70 - Free Software -- Two Plus Two Poker Forums

The Minder · 02-11-2009, 09:01 AM

@sorrow
I'll try your suggestion tomorrow. Like you I'm in Perth and it's getting late here. Thanks for the suggestion.

sorrow · 02-11-2009, 09:12 AM

Quote:

Originally Posted by The Minder

@sorrow
I'll try your suggestion tomorrow. Like you I'm in Perth and it's getting late here. Thanks for the suggestion.

Heh - just got off a plane from Sydney.

sudo apt-get install python-mysqldb

from a console should do the trick. Synaptics should be able to find that one in ubuntu.

The Minder · 02-11-2009, 09:23 AM

Quote:

Originally Posted by sorrow

Heh - just got off a plane from Sydney.

sudo apt-get install python-mysqldb

from a console should do the trick. Synaptics should be able to find that one in ubuntu.

Damn... ok, I'm still up. Installed everything you said and retried running fpdb.py. I didn't get the popup about postgress this time, but it still errored out.

tried to do the install of python-mysqldb and it says 'is already the newest version'

error logs:
fpdb-error-log.txt:
Traceback (most recent call last):
File "/home/wayne/Desktop/pyfpdb/Configuration.py", line 237, in __init__
doc = xml.dom.minidom.parse(file)
File "/usr/lib/python2.5/xml/dom/minidom.py", line 1915, in parse
return expatbuilder.parse(file)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 924, in parse
result = builder.parseFile(fp)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 207, in parseFile
parser.Parse(buffer, 0)
ExpatError: duplicate attribute: line 227, column 79

HUD-error.txt
HUD_main starting
Using db name = fpdb
Traceback (most recent call last):
File "/home/wayne/Desktop/pyfpdb/Configuration.py", line 237, in __init__
doc = xml.dom.minidom.parse(file)
File "/usr/lib/python2.5/xml/dom/minidom.py", line 1915, in parse
return expatbuilder.parse(file)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 924, in parse
result = builder.parseFile(fp)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 207, in parseFile
parser.Parse(buffer, 0)
ExpatError: duplicate attribute: line 227, column 79

sorrow · 02-11-2009, 09:29 AM

Quote:

Originally Posted by The Minder

Damn... ok, I'm still up. Installed everything you said and retried running fpdb.py. I didn't get the popup about postgress this time, but it still errored out.

tried to do the install of python-mysqldb and it says 'is already the newest version'

error logs:
fpdb-error-log.txt:
Traceback (most recent call last):
File "/home/wayne/Desktop/pyfpdb/Configuration.py", line 237, in __init__
doc = xml.dom.minidom.parse(file)
File "/usr/lib/python2.5/xml/dom/minidom.py", line 1915, in parse
return expatbuilder.parse(file)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 924, in parse
result = builder.parseFile(fp)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 207, in parseFile
parser.Parse(buffer, 0)
ExpatError: duplicate attribute: line 227, column 79

HUD-error.txt
HUD_main starting
Using db name = fpdb
Traceback (most recent call last):
File "/home/wayne/Desktop/pyfpdb/Configuration.py", line 237, in __init__
doc = xml.dom.minidom.parse(file)
File "/usr/lib/python2.5/xml/dom/minidom.py", line 1915, in parse
return expatbuilder.parse(file)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 924, in parse
result = builder.parseFile(fp)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 207, in parseFile
parser.Parse(buffer, 0)
ExpatError: duplicate attribute: line 227, column 79

Thats a problem with the format of the xml file. I'll suggest that you've accidentally deleted or added something to the file making it invalid xml.

You need to copy from the original and edit again, or fix the problem in the current file.

sorrow · 02-11-2009, 09:32 AM

Quote:

Originally Posted by No Ego Thanks

Have you considered to include EV statistics?

Of course - baby steps. We will of course accept patches.

Getting an open source hand eval library thats precompiled and releasable is probably going to be the biggest issue.

The Minder · 02-11-2009, 09:37 AM

Quote:

Originally Posted by sorrow

Thats a problem with the format of the xml file. I'll suggest that you've accidentally deleted or added something to the file making it invalid xml.

You need to copy from the original and edit again, or fix the problem in the current file.

Ok... deleted the old xml file and copied/modified a new version... the only thing I changed was the password in the 'supported databases' section (I think that's what the section was).

Still got some errors and will post tomorrow (something about an incorrect db version), but the fpdb program is up... will also play more tomorrow. Thanks mate... hope to see you at the tables.

Eratosthenes · 02-11-2009, 01:43 PM

Quote:

Originally Posted by xaiviax

@TheMinder: Ignore Eratosthenes reply to you. Pay close heed to all replies from him in the future.

@Eratosthenes: TheMinder is using Ubuntu. I believe you mistakingly thought he was on windows.

sorry! I see an installation problem and start babbling about Windows.

If one of you guys will post the exact package names for Ubuntu (or any other distro), I'll add them to the wiki page.

I think these are the generic names:
pyGTK - Gtk windowing system
matplotlib - 2d plotting library, optional, required for graphs
numpy - numeric computing library, optional, required for graphs

plus
mysql (need both client and server)
MySQLdb - mysql database interface
or
postgresql (pgadmin would be a good idea, too)
psycopg2 - postgresql database interface

pypoker-eval - not needed yet, but soon. Does anybody have experience using this on windows?

xaiviax · 02-11-2009, 03:58 PM

Quote:

Originally Posted by The Minder

Still got some errors and will post tomorrow (something about an incorrect db version), but the fpdb program is up... will also play more tomorrow.

In Database Menu, select Create or Recreate Tables

sorrow · 02-11-2009, 09:08 PM

Quote:

Originally Posted by Eratosthenes

If one of you guys will post the exact package names for Ubuntu (or any other distro), I'll add them to the wiki page.

Just added them to the Ubuntu install page.

Quote:

Originally Posted by Eratosthenes

pypoker-eval - not needed yet, but soon. Does anybody have experience using this on windows?

I did the research into this, there doesn't appear to be a precompiled release of this anywhere for windows. Most fo the hits I got were problems compiling in cygwin.

Its a stock package on Debian/Ubuntu and Fedora (so I assume most other distros)

The Minder · 02-11-2009, 10:26 PM

@sorrow and @xaiviax
Thank you for your assistance last night. My fpdb HUD is up and working although only tested on FTP so far, but I am an optimist.

The graph function doesn't appear to be working but that may be due to a lack of data as I am starting from scratch with my HHs. I tried to find my HHs on my Windoze puter but HEM seems to have absconded with them.

@all windoze users.
Folks, you really do need to take the plunge and get into a Linux distro. HEM was my remaining holdout for retaining a Windoze box and now even that has gone. Linux is faster, more secure yadda yadda yadda.

@Stephen/developers
I know you folks have a lot on your plate but I'm going to add my 2c worth for a request or two. These may already be available, but I've read through this entire thread and didn't find anything pertinent.

First, I only want 3 things displayed in the HUD. VP, Aggression Factor and pre-flop raises. How do I configure fpdb to only display these elements.

Second, and this is a direct feed from HEM, I'd like to be able to set color ranges for the above items so that when a break point is reached the factor color changes. ie, red for a warning, orange for neutral and green for good/acceptable. Like they say, a visual cue is more readily accepted than straight data.

fpdb is a great program, you have my total support.

Cheers

ekdikeo · 02-12-2009, 12:30 AM

The Minder:

Take a careful look through your HUD_config.xml file, and you should see how to change the stats displayed for each game type. I would recommend everyone add player name to the stats, as I showed in my examples a page or two back, but that's just me.

After using Linux and OS/2 pretty much exclusively since 1992, I switched to Windows in 2004. You guys can have all your superior stability, I'll take a system that I don't have to spend hours of every day monkeying with to keep it running and updated.

You can set a particular color for a particular stat, currently, but there's no way to do ranges with different colors, currently.

Eratosthenes · 02-12-2009, 12:37 AM

Quote:

Originally Posted by The Minder

First, I only want 3 things displayed in the HUD. VP, Aggression Factor and pre-flop raises. How do I configure fpdb to only display these elements.

That is pretty easy to do with the config file. You need to find the game element for the game you are playing. It probably looks like this:

Code:

        <game cols="3" db="fpdb" game_name="holdem" rows="2">
            <stat click="tog_decorate" col="0" popup="default" row="0" stat_name="vpip" tip="tip1"> </stat>
            <stat click="tog_decorate" col="1" popup="default" row="0" stat_name="pfr" tip="tip1"> </stat>
            <stat click="tog_decorate" col="2" popup="default" row="0" stat_name="ffreq_1" tip="tip1"> </stat>
            <stat click="tog_decorate" col="0" popup="default" row="1" stat_name="n" tip="tip1"> </stat>
            <stat click="tog_decorate" col="1" popup="default" row="1" stat_name="wtsd" tip="tip1"> </stat>
            <stat click="tog_decorate" col="2" popup="default" row="1" stat_name="wmsd" tip="tip1"> </stat>
        </game>

That is the default, and has the stats in a 3x2 grid. To change to a 3x1 grid change the

Code:

rows="2"

to

Code:

rows="1"

Now get rid of the stat elements where the row is "1" and it looks like this:

Code:

        <game cols="3" db="fpdb" game_name="holdem" rows="2">
            <stat click="tog_decorate" col="0" popup="default" row="0" stat_name="vpip" tip="tip1"> </stat>
            <stat click="tog_decorate" col="1" popup="default" row="0" stat_name="pfr" tip="tip1"> </stat>
            <stat click="tog_decorate" col="2" popup="default" row="0" stat_name="ffreq_1" tip="tip1"> </stat>
        </game>

Last change the "ffreq_1" to "a_freq_123" to make the 3rd stat be post flop aggression frequency.

Now your game element looks like this:

Code:

        <game cols="3" db="fpdb" game_name="holdem" rows="2">
            <stat click="tog_decorate" col="0" popup="default" row="0" stat_name="vpip" tip="tip1"> </stat>
            <stat click="tog_decorate" col="1" popup="default" row="0" stat_name="pfr" tip="tip1"> </stat>
            <stat click="tog_decorate" col="2" popup="default" row="0" stat_name="a_freq_123" tip="tip1"> </stat>
        </game>

You could have just copied/pasted that, but what would have been the fun in that? Don't forget to save. I don't remember why aggression factor isn't one of the available stats, I'll take a look later.

These are the currently available stats:

Code:

WMsF               Won $ when saw flop/4th.
a_freq_1           Flop/4th aggression frequency.
a_freq_123         Post-Flop aggression frequency.
a_freq_123_0       Post-Flop aggression frequency (no decimals).
a_freq_2           Turn/5th aggression frequency.
a_freq_3           River/6th aggression frequency.
a_freq_4           7th street aggression frequency.
cb_1               Flop continuation bet.
cb_2               Turn continuation bet.
cb_3               River continuation bet.
cb_4               7th street continuation bet.
f_BB_steal         Folded BB to steal.
f_SB_steal         Folded SB to steal.
ffreq_1            Flop/4th fold frequency.
ffreq_2            Turn/5th fold frequency.
ffreq_3            River/6th fold frequency.
ffreq_4            7th fold frequency.
fold_f             Folded flop/4th.
n                  Number of hands played.
pfr                Preflop (3rd street) raise.
pfr_0              Preflop (3rd street) raise (no decimals).
playername         Player Name.
profit100_0        Profit won per 100 hands (no decimal places).
saw_f              Saw flop/4th.
steal              Steal %.
three_B_0          Three bet preflop/3rd.
vpip               Voluntarily put $ in the pot.
vpip_0             Voluntarily put $ in the pot (no decimals).
wmsd               Won $ at showdown.
wtsd               Went to SD when saw flop/4th

some stats don't work for some games

Quote:

Second, and this is a direct feed from HEM, I'd like to be able to set color ranges for the above items so that when a break point is reached the factor color changes. ie, red for a warning, orange for neutral and green for good/acceptable. Like they say, a visual cue is more readily accepted than straight data.

I am designing a stat object that will give the user much more control about how each stat looks, so that a loose player could have a green vpip and a tight one a red vpip, with yellow in between (for example). I have been liberally using the ideas in this thread, plus some of my own. If people have bright ideas about what the stats in a HUD should look like, now would be a good time to tell me. That design has to coordinated with how it will be respresented in the config file and how a configuration gui will present it to the user. I have decided to be in no hurry on this, because I would like to get it right this time.

Eratosthenes · 02-12-2009, 12:59 AM

Quote:

Originally Posted by ekdikeo

After using Linux and OS/2 pretty much exclusively since 1992, I switched to Windows in 2004. You guys can have all your superior stability, I'll take a system that I don't have to spend hours of every day monkeying with to keep it running and updated.

As you can see from this link, your closed-source, proprietary operating system is clearly doomed. You capitalist running dogs will soon be playing "The Internationale" on your Linux systems.

But seriously, I doubt that I spend an hour a month (0 hours most months, but every now and then...) monkeying with my configuration--I think the guys that do like to spend hours messing with their system are naturally drawn to Linux, but there are plenty of guys who waste untold hours reconfiguring their Windows systems, too. Typing "yum update" about once/week keeps OS and applications updated--I think that is far superior to the Windows system where the OS automatically updates itself and the apps are left on their own.

ekdikeo · 02-13-2009, 03:00 AM

Before we de-rail this thread, lets call an end to the operating system argument.

mach2speedy · 02-14-2009, 02:24 PM

hi, im new to 2+2 and i came across this thread, and i thought it was a gem, as it was exactly the program i was looking for. however i'm having troubles installing it (im a mac user) so as not to clutter up this threat, i have set up a thread here: http://forumserver.twoplustwo.com/69...7/#post8777826
where you guys could hopefully reply to, (it says a bit about what im trying to do, just starting off in the online poker world