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"

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

newhud beta2 is a very old release. Please use latest 0.30.2.

Recreate configuration and database before use.

configuration and database are normally in folder %appdata% \ fpdb

Hello,

I am running windowsXP; I have an existing WAMP (windows apache mysql php) running. I would like to use your software with my existing mysql database. I have installed your software (including the mysql-python package), but cant seem to get it to work. Under "manage database" there is only an sqlite option. There isn't an Sqllite database on my system. Can't import hand histories...because there is no database. How do I configure with Mysql?

Thanks,
Matt

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.

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.

Thx alot, will try this tomorrow

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.

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.

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

I´ll do that. Thanks mclrk.

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

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.

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

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.

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

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.

Is there a way to add a HUD stat for # of BB"S ?

Hi guys. Thanks for the great work.

I need some help understanding the hud tourney stats settings. I wan't the HUD to:
- show hero stats for the session but with all blind levels played in a tourney: so... hero_stat_range: S;
aggregate_hero_tourney_stats: True;
hero_aggregation_level_multiplier: This is where i get lost. How is it compatible to set the previous one to 'True' and have this one defaulted to '1' or other number? What shoube that numberld in order to include all the blinds of the tourney?

-show villain's stats with all the blinds, with lifestats:
stat_range : A
aggregate_tourney_stats : True
aggregation_level_multiplier : ?!


Also:

Where can i learn what codes (as #F05000 and ="#408000) corresponds to which colour?


@nunoricardovaz: Can you, or someone, share what you did to the config file to get ur HUD as it is?

Thanks

For example here
http://www.w3schools.com/html/html_colors.asp

So it's RGB in Hex and for example #F05000 means Red = F0, Green=50, Blue=00.

On the "16 Million Different Colors" table you choose your red and click on #F00000
and get this table
http://www.w3schools.com/html/html_c....asp?color=240
where you choose you Green and Blue


If you don't need all 16 millions you could try this small table
http://web.njit.edu/~kevin/rgb.txt.html

No.

Session stats are pretty much for cash games not tourneys, i'm not sure they play nice together. I don't play many tournaments so ymmv.

From the docs:

Aggregate just means 'show more than the current blind level', the multiplier is just to control how many blind levels are shown.

3 positions.