Open Side Menu Go to the Top
Register
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

04-07-2010 , 10:15 AM
I just found out about this and could be interested. It's quite a lengthy thread and I couldn't go through all of it, but could someone post/direct me to some screenshots of the way the database looks and the graphs. I'm not interested in HUD pics.

Appreciate it.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-07-2010 , 11:19 AM
Quote:
Originally Posted by Masq
I just found out about this and could be interested. It's quite a lengthy thread and I couldn't go through all of it, but could someone post/direct me to some screenshots of the way the database looks and the graphs. I'm not interested in HUD pics.

Appreciate it.
http://****************/apps/mediawik...le=Screenshots

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-07-2010 , 12:55 PM
Quote:
Originally Posted by 1meandog4u
Thanks, do you know of any screenshots around that show the actual graphs & sessions/tables results?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-07-2010 , 02:37 PM
hi pimpygrub,

I think that your database username and password doesn't agree with the one in hud-config.

in hudconfig the username is set to "fpdb" and the password is set "phetamine"

in mysql you created a user "fpdbuser" with the password "passwdHerre"

to fix:

mysql> GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'phetamine';

to test:

$mysql --user=fpdb --password=phetamine

if this doesn't work, edit the hudconfig and set the username to root (I don't use mysql for anything else, so just used the root username and password.)

Last edited by gimick; 04-07-2010 at 02:50 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-07-2010 , 02:44 PM
Two tips for everyone !

If you are having problems with HUD not using the preferred seat please make sure that your screenname is correctly set in the hud-config (I have discovered that it is CASE SENSITIVE)

if you are getting errors trying to bulk-import pokerstars hand histories, please make sure that the sitefilter drop-down box is set to "pokerstars" (it defaults to the first entry, which is normally fulltilt)

Last edited by gimick; 04-07-2010 at 02:53 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-08-2010 , 02:17 AM
I finally found an error that's been bugging me in the mucked hands. It happens EVERY time, so you developers can chase this one.

Whenever a players mucked cards show, if they had a Queen (i believe of Clubs), it shows the 2 of clubs instead. First time I saw a player cap it and later saw he mucked Q2 offsuit, then looked back on PS's hand replayer and it was QQ. It happened four times tonight, each time the player should have shown Q of Clubs, and mucked hands showed 2 of clubs each time.

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-08-2010 , 02:43 AM
Sorry all - i've been slacking off.

Quote:
Originally Posted by 1meandog4u
Did you change the importer between the Jan release and the March 0307 release? I took both of them just now. The new one using Sqlite db, the older one using Mysql.

Put 1000 files in a directory. The new version died immediately. The old one imported every file with no errors. That makes me think it's not the hh's themselves, but the way they are imported.

Dog
During that timeframe, a couple of small fixes went in, but most of the work was in 'locales' ie. Making umlauts look like umlauts.

I still have your log files Dog - i should be able to take a look early next week. (Wedding this week - not mine)

Quote:
Originally Posted by MOJO_ERASER
i ran the program is says global lock on the command prompt. I leave it running open up the bulk import import 80 -200 hands and the thing never finishes. I waited 30 minutes. What am i doing wrong
Global lock means something hung, or something is still running. More details on your setup please? Platform, database - sites you are trying to import.

Quote:
Originally Posted by uncooper
Update: this is already fixed in latest git.
- I like bugs that are already fixed.

Quote:
Originally Posted by pimpygrub
<supported_databases>
<database db_name="fpdb" db_server="mysql" db_ip="localhost" db_user="fpdb" db_pass="phetamine"/>

<!--
<database db_ip="localhost" db_server="sqlite" db_name="fpdb.db3" db_user="fpdb" db_pass="fpdb"/>
-->
</supported_databases>
If that is a literal copy it is invalid xml. Delete the part in bold.

Quote:
Originally Posted by Masq
Thanks, do you know of any screenshots around that show the actual graphs & sessions/tables results?
Session stats are a work in progress (halted ftm)

I probably should upload a new screen.

Quote:
Originally Posted by gimick
hi pimpygrub,

I think that your database username and password doesn't agree with the one in hud-config.

in hudconfig the username is set to "fpdb" and the password is set "phetamine"

in mysql you created a user "fpdbuser" with the password "passwdHerre"

to fix:

mysql> GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'phetamine';

to test:

$mysql --user=fpdb --password=phetamine

if this doesn't work, edit the hudconfig and set the username to root (I don't use mysql for anything else, so just used the root username and password.)
This is good advice.

Quote:
Originally Posted by 1meandog4u
I finally found an error that's been bugging me in the mucked hands. It happens EVERY time, so you developers can chase this one.

Whenever a players mucked cards show, if they had a Queen (i believe of Clubs), it shows the 2 of clubs instead. First time I saw a player cap it and later saw he mucked Q2 offsuit, then looked back on PS's hand replayer and it was QQ. It happened four times tonight, each time the player should have shown Q of Clubs, and mucked hands showed 2 of clubs each time.

Dog
This is already fixed...i think around Christmas time - it may not have made the Jan snapshots though. Easiest way to test is to see if '22' exists in the player stats view (which was where it was noticed)

If '22' exists in the stats view then this is another bug.

Sorrow
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-08-2010 , 03:11 AM
Quote:
Originally Posted by sorrow
If '22' exists in the stats view then this is another bug.Sorrow
Must be another bug. I show 145 hands of "22" in the stats. Don't worry. Enjoy the wedding, check out the bride's maids, just keep your hands in your pockets. On second thought....

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-08-2010 , 07:42 AM
Is it possible to make more of the programs minimise to the taskbar in Windows?

Currently only the main FPDB program does, unless it's a local setting....

Also, when you "Save HUD Layout" can it also save the position of the FPDB Menu?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-08-2010 , 04:25 PM
Quote:
Originally Posted by Banzai
Is it possible to make more of the programs minimise to the taskbar in Windows?
How many windows do you have?

On my machine, i have the main fpdb window (which goes to the task bar) and the hud main - which doesn't
Quote:
Originally Posted by Banzai
Currently only the main FPDB program does, unless it's a local setting....

Also, when you "Save HUD Layout" can it also save the position of the FPDB Menu?
+1 for me on this one too.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-08-2010 , 05:24 PM
Quote:
Originally Posted by Banzai
Also, when you "Save HUD Layout" can it also save the position of the FPDB Menu?
I've shortened the hud menu text in preferences, so it takes up much less space
but it would be good to choose to put it elsewhere
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-08-2010 , 05:28 PM
Quote:
Originally Posted by gimick
I've shortened the hud menu text in preferences, so it takes up much less space
but it would be good to choose to put it elsewhere
I too have shortening it to "Menu" but it still covers the previous hand's menu. I move it to just over the dealter's tray above the pot size would be perfect. If I knew which py file it was in, I'd change the coordinates myself.

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-08-2010 , 06:01 PM
Quote:
Originally Posted by 1meandog4u
If I knew which py file it was in, I'd change the coordinates myself.

Dog
hud.py line 132

change

self.main_window.move(self.table.x, self.table.y)

to

self.main_window.move(self.table.x + 350, self.table.y + 90)

where 350 and 90 are offsets of your choice, in pixels
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-08-2010 , 09:18 PM
Quote:
Originally Posted by gimick
hud.py line 132

change

self.main_window.move(self.table.x, self.table.y)

to

self.main_window.move(self.table.x + 350, self.table.y + 90)

where 350 and 90 are offsets of your choice, in pixels
I did that and it had no effect. I even did it as cut n paste to not make a mistake. Then, I changed the offsets to 50 for both x and y axis, just for a test, still no movement, it's jammed into the (I assume 0 0) corner. Also, triple checked I was changing the right line, in the right file hud.py

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-09-2010 , 03:50 AM
Quote:
Originally Posted by 1meandog4u
I did that and it had no effect. I even did it as cut n paste to not make a mistake. Then, I changed the offsets to 50 for both x and y axis, just for a test, still no movement, it's jammed into the (I assume 0 0) corner. Also, triple checked I was changing the right line, in the right file hud.py

Dog
I'm running on Linux and it works fine for me. I'll try to setup a windows version and try it there.

If you are on windows, are you running the "exe" package?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-09-2010 , 04:38 AM
Quote:
Originally Posted by sorrow
How many windows do you have?

On my machine, i have the main fpdb window (which goes to the task bar) and the hud main - which doesn't
I also have a DOS window (like a command console?) which doesn't minimise to the task bar.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-09-2010 , 12:39 PM
Quote:
Originally Posted by gimick
I'm running on Linux and it works fine for me. I'll try to setup a windows version and try it there.
Sorry Dog, confirmed doesn't work on Win.

Maybe try this:

Line 131 - ignore the change suggested, put this back as it was (like this):

self.main_window.move(self.table.x, self.table.y)

Instead, at line 458 change it to something like:

self.main_window.move(x + 500, y + 90)

As before, you will need to tinker with the offsets. I've given this a quick test on XP and it seems to work.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-09-2010 , 05:24 PM
Quote:
Originally Posted by gimick
Sorry Dog, confirmed doesn't work on Win.

Maybe try this:

Line 131 - ignore the change suggested, put this back as it was (like this):

self.main_window.move(self.table.x, self.table.y)

Instead, at line 458 change it to something like:

self.main_window.move(x + 500, y + 90)

As before, you will need to tinker with the offsets. I've given this a quick test on XP and it seems to work.

It worked! I'm running Window's Vista. I usually 4-table and entered this for my size tables:

self.main_window.move(x + 275, y - 25)

I found it will accept the "-" and that helped put it dead center (over the chip tray, the 275) and I tested successfully using the minus 25 to take it into the table header and above the pot size.

Thanks for the efforts.

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-11-2010 , 03:58 PM
I know the stats aren't working fully just now, but I think the devs might be interested in cases where they work and do not.

On Stars, FPDB does not always identify continuation bets.

The behaviour occurs frequently, Hopefully the following isolated hand demostrates one case:

Firstly, this hand calculates the CB correctly:

Someone limps, there is a button raise, the BB calls and the limper folds, and the raiser continues on the flop (note that the BB checking the flop does not get written to the hand history). FPDB credits the raiser with the continuation bet.

Quote:
PokerStars Game #111111111111: Tournament #111111111, $5.00+$0.40 USD Hold'em No Limit - Level I (10/20) - 2010/03/29 18:57:02 WET [2010/03/29 13:57:02 ET]
Table '111111111 1' 10-max Seat #1 is the button
Seat 1: Se (1500 in chips)
Seat 2: PR (1500 in chips)
Seat 3: An (1500 in chips)
Seat 4: Am (1500 in chips)
Seat 5: ro (1500 in chips)
Seat 6: Ma (1500 in chips)
Seat 7: Ba (1500 in chips) is sitting out
Seat 8: Mq (1500 in chips)
Seat 9: dd (1500 in chips)
Seat 10: er (1500 in chips)
PR: posts small blind 10
An: posts big blind 20
*** HOLE CARDS ***
Dealt to Ma [2s Td]
Ba is connected
Ba has returned
Am: folds
ro: folds
Ma: folds
Ba: calls 20
Mq: folds
dd: folds
er: folds
Se: folds
PR: raises 40 to 60
An: calls 40
Ba: folds
*** FLOP *** [8h 6h 3h]
PR: bets 100
An: folds
Uncalled bet (100) returned to PR
PR collected 140 from pot
PR: doesn't show hand
*** SUMMARY ***
Total pot 140 | Rake 0
Board [8h 6h 3h]
Seat 1: Se (button) folded before Flop (didn't bet)
Seat 2: PR (small blind) collected (140)
Seat 3: An (big blind) folded on the Flop
Seat 4: Am folded before Flop (didn't bet)
Seat 5: ro folded before Flop (didn't bet)
Seat 6: Ma folded before Flop (didn't bet)
Seat 7: Ba folded before Flop
Seat 8: Mq folded before Flop (didn't bet)
Seat 9: dd folded before Flop (didn't bet)
Seat 10: er folded before Flop (didn't bet)
This time here is an example where the CB on the flop is not recognised.

Mid position opens for a raise, there is a cold call behind and the big blind calls also, the midposition raiser continues on the flop (note that the HH shows the BB check this time)
This time FPDB correctly sets street1CBchance true, but (incorrectly) street1CBdone is false.
Quote:
PokerStars Game #22222222222: Tournament #222222222, $5.00+$0.40 USD Hold'em No Limit - Level I (10/20) - 2010/03/28 23:23:51 WET [2010/03/28 18:23:51 ET]
Table '222222222 1' 10-max Seat #1 is the button
Seat 1: ge (1500 in chips)
Seat 2: Ke (1500 in chips)
Seat 3: Ba (1500 in chips)
Seat 4: do (1500 in chips)
Seat 5: Al (1500 in chips)
Seat 6: To (1500 in chips)
Seat 7: #n (1500 in chips)
Seat 8: dm (1500 in chips) is sitting out
Seat 9: Ol (1500 in chips)
Seat 10: Ma (1500 in chips)
Ke: posts small blind 10
Ba: posts big blind 20
*** HOLE CARDS ***
Dealt to Ma [5h Tc]
dm is connected
dm has returned
do: folds
Al: folds
To: folds
#n: folds
dm: folds
Ol: folds
Ma: raises 60 to 80
ge: calls 80
Ke: folds
Ba: calls 60
*** FLOP *** [3c Qh 4h]
Ba: checks
Ma: bets 100
ge: folds
Ba: folds
Uncalled bet (100) returned to Ma
Ma collected 250 from pot
Ma: doesn't show hand
*** SUMMARY ***
Total pot 250 | Rake 0
Board [3c Qh 4h]
Seat 1: ge (button) folded on the Flop
Seat 2: Ke (small blind) folded before Flop
Seat 3: Ba (big blind) folded on the Flop
Seat 4: do folded before Flop (didn't bet)
Seat 5: Al folded before Flop (didn't bet)
Seat 6: To folded before Flop (didn't bet)
Seat 7: #n folded before Flop (didn't bet)
Seat 8: dm folded before Flop (didn't bet)
Seat 9: Ol folded before Flop (didn't bet)
Seat 10: Ma collected (250)
If "Ba: checks" is deleted, FPDB correctly sets street1CBdone to true.

Summary,
  • Stars HH sometimes omits a flop check action.
  • If Stars HH misses the check to raiser action, then fpdb correctly credits the CB.
  • if stars HH writes the check to raiser action, FPDB does not credit the player with the CB.

I've not worked out the pattern for Stars to miss the check action.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-11-2010 , 10:12 PM
Quote:
Originally Posted by gimick

On Stars, FPDB does not always identify continuation bets.
I've had a closer look at this, and have spotted a couple of issues in the CB code.

Am testing changes to the code now and will post results here.

The Stars HH issue is largely irrelevant, I think.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-11-2010 , 11:08 PM
Is there an uninstall for fpdb or do I have to do it manually?

PS:It works fine it's just that Im not playing poker anymore so I have no use for it.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-12-2010 , 12:27 AM
Quote:
Originally Posted by edwardr36
Is there an uninstall for fpdb or do I have to do it manually?

PS:It works fine it's just that Im not playing poker anymore so I have no use for it.
Here's the step-by-step instructions for removing fpdp....

1. Delete it

Seriously, it's manual. You'll have to decide if you want to delete all the associated programs such as Mysql, Python and so on. Why not, if you have the space, just leave it there and if you happen to decide to play in the future, it will be as ready as a $500 hooker on a slow night.

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-12-2010 , 11:03 AM
I nine table and I would like to change the height and width of the hud display.

Any way of doing this?

Also, how do i go about knowing the location (x,y) of a table. For example where would (125, 456) be on a table. Would (125, 456) be in different in a different location on a small sized table compared to a big size table?

Hope these questions make sense to you guys?

Thank you!
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-12-2010 , 12:14 PM
I'll take a layman's shot at some of your questions. I'm sure the guys that really know the program will correct any errors I mistate.

Quote:
Originally Posted by arsenal6
I nine table and I would like to change the height and width of the hud display.
I was told in the past that the size of the box expands or contracts based on the information you are asking for. If you have more stats, it sizes itself taller, or wider, depending on the number of rows or columns of data/stats.

Also, the size of the font, and font style affect it as well. I multi table, but only about 4 tables. I increased the default (8pt) to 9pt for these tired old eyes. In the hud_config.xml file, in the section "supported sites" you will see "font size" and "font style". You could change that to, for example, 6 if you think you can read it that small. And, you could use a smaller font style. One that is smaller would be something like "Arial Narrow" which most computers have. Just be sure when changing it that you type in the EXACT name of the font on your computer or the config file won't find it. Spelling counts!!

Quote:
Also, how do i go about knowing the location (x,y) of a table. For example where would (125, 456) be on a table. Would (125, 456) be in different in a different location on a small sized table compared to a big size table?
This is difficult to explain, but I use the rough estimate of each 110 bytes is about one inch on the size tables you will probably have if you are multi tabling 9 tables. If I understand it right, it's the number of bytes and would depend on how small the bytes (tables in your case) might be. Smaller tables = smaller bytes

Any experts feel free to jump in and correct my idiot mistates..

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-12-2010 , 02:55 PM
Quote:
Originally Posted by Eratosthenes
Yeah, I just looked at cbet stats. They look wrong and so does the code that calculates them.

Here is a patch which may resolve many, but not all issues with the CBet statistic being too low.

Currently CBets are only counted if your bet is the first entry in the Hand History (issue identified by padre_maronno in post #2827).

in DerivedStats.py, the method betStreet is changed as follows:


Code:
    
    def betStreet(self, street, player):
        """Returns true if player bet/raised the street as their first action"""
        betOrRaise = False
        for act in self.hand.actions[street]:

	#	if act[0] == player and act[1] in ('bets', 'raises'):
	#		betOrRaise = True
	#	else:
 	#		break
 
	#  Old code above.
	#  Only recognised the continuation bet if the bet was the first entry in the hand history.
 	#  suggested change below.

            if act[0] == player: 
		if act[1] in ('bets', 'raises'):
                	betOrRaise = True
			break
	        else:
			# player found but did not bet or raise as their first action
			break
	    else:
		# haven't found player's first action yet
		continue

        return betOrRaise
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m