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

gimick · 06-13-2012, 05:21 PM

Quote:

Originally Posted by nunoricardovaz

Hi, gimick. Why don´t you use the decimal places?

I dont - just using it as an example that fpdb can round the stats

- by default vpip is shown with 1 decimal place.

Not sure if 15.7% rounded to 16% is going to be significant though for most players.

nunoricardovaz · 06-13-2012, 06:12 PM

Kharnacier · 06-13-2012, 06:51 PM

Quote:

Originally Posted by gimick

These changes are done by editing the config. Take a backup of the config before changing these settings because fpdb will fail if the definitions are not correct.

Here is an example of a more advanced stat:

stat_name="vpip_0" hudcolor="#FFFFFF"
hudprefix="VPIP : " hudsuffix="%"
stat_hicolor="#F05000" stat_hith="35"
stat_locolor="#408000" stat_loth="15"

should give:
VPIP : 31%

explaination:
vpip_0 - means show the vpip stat, but use zero decimal places (so 67.2 becomes 67)
hudcolour #FFFFFF means by default, display this in white text (this is an RGB value in hex)
hudprefix - fixed text to be shown before the VPIP value
hudsuffix - fixed text to be shown after the value
stat_hith="35" + stat_hicolor="#F05000" - if value > 35, use orangey colour
stat_loth="15" + stat_locolor="#408000" - if value < 15, use greeny colour

Thx alot, will try this tomorrow

mclrk · 06-14-2012, 01:42 PM

Quote:

Originally Posted by gimick

Hi,

If you are using the exe package - all the dependencies (including mysql) are pre-compiled so nothing else to install.

To activate mysql, edit the fpdb configuration file (in %appdata%\fpdb\HUD_config.xml) locate the <supported_databases> section, activate the mysql entry, de-activate the sqlite entry. Fill in dbname password etc in the config entry.

Restart fpdb. You might need to select the option database/create recreate tables.

There is a help page here for mysql - it is *nix oriented, but I'm sure the windows setup will be similar.

Hope that makes sense.

great! Thanks for the help. I would like to query the database directly...could you give me sql statements that query the mysql database...I assume this would be in one of your python (.py) files.

nunoricardovaz · 06-14-2012, 02:05 PM

I have my fpdb and hud working and I don´t even know what mysql or sqlite are, lol.
I don´t even know if those programs are in my computer.
I just installed fpdb, create the database tables with wikipedia help, opened the hud_config file to change the stats with notepad and that´s all. Am I missing something?

mclrk · 06-14-2012, 06:18 PM

Quote:

Originally Posted by nunoricardovaz

I have my fpdb and hud working and I don´t even know what mysql or sqlite are, lol.
I don´t even know if those programs are in my computer.
I just installed fpdb, create the database tables with wikipedia help, opened the hud_config file to change the stats with notepad and that´s all. Am I missing something?

If fpdb is working on your system then you do have a database (most likely sqllite).

A database is a way for a program (in this instance a program written in Python) to store and retrieve information (data). A good example of a massive database is facebook; they use mysql to store all of our information. "sql" stands for standard query language; it is a common way to query (ask for data) from a database. In order to use fpdb, or any other program that wraps around a database (facebook), you don't have to know how to operate the database directly; the program does that for you. But it is a good idea to have some basic knowledge about them.

They are amazingly powerful; and free! Educate yourself.

gimick · 06-15-2012, 07:08 AM

Quote:

Originally Posted by mclrk

great! Thanks for the help. I would like to query the database directly...could you give me sql statements that query the mysql database...I assume this would be in one of your python (.py) files.

sql is contained in SQL.py - latest development source is here http://www.assembla.com/code/fpdboz/git/nodes

nunoricardovaz · 06-15-2012, 01:01 PM

I´ll do that. Thanks mclrk.

Kharnacier · 06-17-2012, 11:41 AM

Quote:

Originally Posted by gimick

These changes are done by editing the config. Take a backup of the config before changing these settings because fpdb will fail if the definitions are not correct.

Here is an example of a more advanced stat:

stat_name="vpip_0" hudcolor="#FFFFFF"
hudprefix="VPIP : " hudsuffix="%"
stat_hicolor="#F05000" stat_hith="35"
stat_locolor="#408000" stat_loth="15"

should give:
VPIP : 31%

explaination:
vpip_0 - means show the vpip stat, but use zero decimal places (so 67.2 becomes 67)
hudcolour #FFFFFF means by default, display this in white text (this is an RGB value in hex)
hudprefix - fixed text to be shown before the VPIP value
hudsuffix - fixed text to be shown after the value
stat_hith="35" + stat_hicolor="#F05000" - if value > 35, use orangey colour
stat_loth="15" + stat_locolor="#408000" - if value < 15, use greeny colour

Thx again, it worked like a charm

I've still got a problem. If I try to display the stat "car" (call a raise preflop), the HUD doesn't work anymore

Anyone could help with that, please ?

Btw: I use fpdb v0.30.2 on Pokerstars.fr

I find the solution, the stat_name isn't "car" but "car0". Sorry for the trouble, but maybe it will help someone else

vic22 · 06-20-2012, 01:34 AM

i am using:
Operating System: Windows ('XP', '5.1.2600', 'SP3', 'Uniprocessor Free')
fpdb version: 0.30
database used: mysql
pokerstars/plo-omaha

but the Viewers->Graphs and Viewers->Ring Player Stats are not working properly.
Basically when I give the start&end date in "From" and "To" button -- only a fraction
of the hands are displayed. But this bug is non-existent if I put From as "01-01-2000"
and End as "01-01-2012" i.e the whole/total number of hands played in the database
is displayed correctly. It's just day-specific data which is showing partial results.

btw, other than some small minor bugs, this is a great piece of software -- hud works fast and flawlessly with stars-plo. thanks a bunch for all your efforts.

danakin · 06-20-2012, 12:23 PM

Yesterday I stopped working the hud on pokerstars in cash game. Install the new version of fpdb and the problem persists, please someone can help me, until two days all was right

nunoricardovaz · 06-21-2012, 03:45 PM

Hello. What´s the diference between 0.30.1 and the 0.30.2 release? Is there a page where I can follow the changes of the new releases?
Thanks.

snowboard789 · 06-22-2012, 07:14 AM

what does the steal % means in stud games? 1 or 2 or 3+ positions left from the bring in??

FlushFAAN · 06-23-2012, 08:34 AM

Good Day. Can anyone tell me about my problem?
I' ve done some changes in configuration and now, whe I' m trying to start program, I see this message:
No handlers could be found for logger "config"
Traceback (most recent call last):
File "Configuration.pyc", line 772, in __init__
File "xml\dom\minidom.pyc", line 1911, in parse
File "xml\dom\expatbuilder.pyc", line 924, in parse
File "xml\dom\expatbuilder.pyc", line 207, in parseFile
ExpatError: not well-formed (invalid token): line 35, column 18

ChazDazzle · 06-24-2012, 03:46 PM

Quote:

Originally Posted by FlushFAAN

Good Day. Can anyone tell me about my problem?
I' ve done some changes in configuration and now, whe I' m trying to start program, I see this message:
No handlers could be found for logger "config"
Traceback (most recent call last):
File "Configuration.pyc", line 772, in __init__
File "xml\dom\minidom.pyc", line 1911, in parse
File "xml\dom\expatbuilder.pyc", line 924, in parse
File "xml\dom\expatbuilder.pyc", line 207, in parseFile
ExpatError: not well-formed (invalid token): line 35, column 18

This basically means that the changes you made have broken the xml syntax in some way. It should work again fine if you start over and are quite careful with how you're making edits.