Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > > >

Notices

Free Software Discussion of Free / Freeware / Donationware / Open Source poker software and Free Graphics mods

Reply
 
Thread Tools Display Modes
Old 04-04-2017, 12:04 AM   #9051
phil_r
adept
 
Join Date: Sep 2011
Location: 0.41.0-rc8
Posts: 775
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by Jochends View Post
Yea.. Already tryed that.
OK. Are there any useful-looking messages in the log files?
phil_r is offline   Reply With Quote
Old 04-12-2017, 06:27 PM   #9052
Go Get It
Carpal \'Tunnel
 
Join Date: Feb 2010
Location: Doesn't have a leg to stand on.
Posts: 11,296
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

From looking at the OP I'll assume it doesn't, but does FPDB support ACR?
Go Get It is offline   Reply With Quote
Old 04-12-2017, 08:41 PM   #9053
ChazDazzle
adept
 
ChazDazzle's Avatar
 
Join Date: Aug 2005
Location: Casino Night Zone
Posts: 929
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by Go Get It View Post
From looking at the OP I'll assume it doesn't, but does FPDB support ACR?
Newest version does
https://github.com/philroberts/FPDB-...tag/0.41.0-rc8
ChazDazzle is offline   Reply With Quote
Old 04-12-2017, 11:47 PM   #9054
Go Get It
Carpal \'Tunnel
 
Join Date: Feb 2010
Location: Doesn't have a leg to stand on.
Posts: 11,296
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

TY
Go Get It is offline   Reply With Quote
Old 04-13-2017, 05:07 PM   #9055
Go Get It
Carpal \'Tunnel
 
Join Date: Feb 2010
Location: Doesn't have a leg to stand on.
Posts: 11,296
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

When I try to run FPDB I get "An invalid DB version or missing tables have been detected"

How to fix?
Go Get It is offline   Reply With Quote
Old 04-13-2017, 07:47 PM   #9056
TheDruid
centurion
 
Join Date: Jan 2011
Posts: 124
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by Go Get It View Post
When I try to run FPDB I get "An invalid DB version or missing tables have been detected"

How to fix?
If you're sure that you have no data to lose, then on the main menu choose "Maintenance" then "Create or Recreate Tables"

If you need (or want) to save your data, then how you do that depends on which database engine you're using.

When I switched to the new version, I had to do this, and then manually import all my hands. This is tedious, but may be worth the effort..

Cheers,
--D
TheDruid is offline   Reply With Quote
Old 04-13-2017, 07:50 PM   #9057
TheDruid
centurion
 
Join Date: Jan 2011
Posts: 124
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

I'm trying to write a script that will export a hand in text for posting in forums.

While doing this, I encountered the table "handsstove".
I think that there may be information in there that I could use.

How do I interpret the "Value" and "cards" columns?

Thanks,
--D
TheDruid is offline   Reply With Quote
Old 04-13-2017, 09:28 PM   #9058
Go Get It
Carpal \'Tunnel
 
Join Date: Feb 2010
Location: Doesn't have a leg to stand on.
Posts: 11,296
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by TheDruid View Post
If you're sure that you have no data to lose, then on the main menu choose "Maintenance" then "Create or Recreate Tables"

If you need (or want) to save your data, then how you do that depends on which database engine you're using.

When I switched to the new version, I had to do this, and then manually import all my hands. This is tedious, but may be worth the effort..

Cheers,
--D
I have no hands right now that I care about. Seems like I'd be good just to follow those steps and thereafter I should be good?
Go Get It is offline   Reply With Quote
Old 04-13-2017, 09:31 PM   #9059
Go Get It
Carpal \'Tunnel
 
Join Date: Feb 2010
Location: Doesn't have a leg to stand on.
Posts: 11,296
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by ChazDazzle View Post
I have this version and when I go to Configure -- Site Settings ACR is not an option fwiw.
Go Get It is offline   Reply With Quote
Old 04-14-2017, 12:12 AM   #9060
TheDruid
centurion
 
Join Date: Jan 2011
Posts: 124
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by Go Get It View Post
I have no hands right now that I care about. Seems like I'd be good just to follow those steps and thereafter I should be good?
When you follow those steps, your existing database (if any) is replaced by an empty database -- so yeah, it should be good to go.
TheDruid is offline   Reply With Quote
Old 04-14-2017, 12:16 AM   #9061
TheDruid
centurion
 
Join Date: Jan 2011
Posts: 124
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by Go Get It View Post
I have this version and when I go to Configure -- Site Settings ACR is not an option fwiw.
If you go to Configure | Site Settings
you will find "Winning Poker" -- that is the entry for ACR

I don't play there, so I can't help beyond that.

Cheers,
--D
TheDruid is offline   Reply With Quote
Old 04-14-2017, 04:19 PM   #9062
Go Get It
Carpal \'Tunnel
 
Join Date: Feb 2010
Location: Doesn't have a leg to stand on.
Posts: 11,296
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Here is what I see when I do that, also put the version number in there just to be safe.



I will say I didn't get the error message this time, so TY for help with that.
Go Get It is offline   Reply With Quote
Old 04-14-2017, 04:39 PM   #9063
phil_r
adept
 
Join Date: Sep 2011
Location: 0.41.0-rc8
Posts: 775
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by Go Get It View Post
Here is what I see when I do that, also put the version number in there just to be safe.



I will say I didn't get the error message this time, so TY for help with that.
If I've been following correctly you had an old version installed at some point, so you'll need to delete your config file so FPDB recreates it with WPN/ACR support:

http://forumserver.twoplustwo.com/sh...postcount=8900
phil_r is offline   Reply With Quote
Old 04-14-2017, 05:29 PM   #9064
Go Get It
Carpal \'Tunnel
 
Join Date: Feb 2010
Location: Doesn't have a leg to stand on.
Posts: 11,296
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by phil_r View Post
If I've been following correctly you had an old version installed at some point, so you'll need to delete your config file so FPDB recreates it with WPN/ACR support:

http://forumserver.twoplustwo.com/sh...postcount=8900
This helped a ton, thank you.
Go Get It is offline   Reply With Quote
Old 04-15-2017, 04:42 PM   #9065
TheDruid
centurion
 
Join Date: Jan 2011
Posts: 124
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

I came across a bug where certain Boss hands are read as having antes, when they do not.

I think that it happens when a dead small blind is posted:
<ACTION TYPE="HAND_BLINDS" PLAYER="XtraMayo" KIND="HAND_SB" VALUE="0.15"></ACTION>
<ACTION TYPE="HAND_BLINDS" PLAYER="maugris" KIND="HAND_BB" VALUE="0.30"></ACTION>
<ACTION TYPE="HAND_BLINDS" PLAYER="DEVILS" KIND="HAND_DSB" VALUE="0.15"></ACTION> ;this line does not show in the handsactions table
<ACTION TYPE="HAND_BLINDS" PLAYER="DEVILS" KIND="HAND_BB" VALUE="0.30"></ACTION>

The value of the dead blind is attributed to each of the other players as an ante.
In this case, it works out evenly, since there are 5 players.

I haven't figured out yet what happens when there are 6 or more players.

Cheers,
--D
TheDruid is offline   Reply With Quote
Old 04-15-2017, 05:53 PM   #9066
ChazDazzle
adept
 
ChazDazzle's Avatar
 
Join Date: Aug 2005
Location: Casino Night Zone
Posts: 929
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by TheDruid View Post
I came across a bug where certain Boss hands are read as having antes, when they do not.

I think that it happens when a dead small blind is posted:
<ACTION TYPE="HAND_BLINDS" PLAYER="XtraMayo" KIND="HAND_SB" VALUE="0.15"></ACTION>
<ACTION TYPE="HAND_BLINDS" PLAYER="maugris" KIND="HAND_BB" VALUE="0.30"></ACTION>
<ACTION TYPE="HAND_BLINDS" PLAYER="DEVILS" KIND="HAND_DSB" VALUE="0.15"></ACTION> ;this line does not show in the handsactions table
<ACTION TYPE="HAND_BLINDS" PLAYER="DEVILS" KIND="HAND_BB" VALUE="0.30"></ACTION>

The value of the dead blind is attributed to each of the other players as an ante.
In this case, it works out evenly, since there are 5 players.

I haven't figured out yet what happens when there are 6 or more players.

Cheers,
--D
Would love to see this hh. Can you post or send to support@pokeit.co?
ChazDazzle is offline   Reply With Quote
Old 04-15-2017, 06:31 PM   #9067
TheDruid
centurion
 
Join Date: Jan 2011
Posts: 124
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

I've sent a dozen files zipped up, and a list of the hands affected.

Hope it helps.

Cheers,
--D
TheDruid is offline   Reply With Quote
Old 04-17-2017, 09:41 AM   #9068
ChazDazzle
adept
 
ChazDazzle's Avatar
 
Join Date: Aug 2005
Location: Casino Night Zone
Posts: 929
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by TheDruid View Post
I've sent a dozen files zipped up, and a list of the hands affected.

Hope it helps.

Cheers,
--D
Thanks. Fixed
ChazDazzle is offline   Reply With Quote
Old 04-22-2017, 07:56 AM   #9069
M709199
stranger
 
Join Date: Apr 2017
Posts: 3
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by ChazDazzle View Post
Quote:
Originally Posted by Forrest Gump View Post
Hi, anyone knows how can I customize stats or create a new one like pat frequency? What do I need to use? What files to edit? etc
Thanks in advance
We don't track stand pats as a stat, and it's not possible to easily create a custom query for it in the fpdb application. If you wanted to track it manually, you could write a query for it. Should look something like this (for Draw One):

Code:
SELECT case when sum(b.street1StandPatChance) = 0 then -1 else 100.0*sum(a.street1StandPat)/sum(b.street1StandPatChance) end AS patfq1 
FROM
(SELECT count(*) AS street1StandPat
FROM Hands H
INNER JOIN HandsActions HA ON (H.id = HA.handId)
INNER JOIN Gametypes G ON (H.gametypeId = G.id)
INNER JOIN Players P ON (P.id = HA.playerId)
INNER JOIN Actions A ON (HA.actionId = A.id)
WHERE G.base = 'draw' 
AND P.name = '%PLAYERNAME%'
AND HA.street = 1
AND A.name = 'stands pat') as a
JOIN
(SELECT sum(street1Seen) AS street1StandPatChance
FROM Hands H
INNER JOIN HandsPlayers HP ON (H.id = HP.handId)
INNER JOIN Gametypes G ON (H.gametypeId = G.id)
INNER JOIN Players P ON (P.id = HP.playerId)
WHERE G.base = 'draw' AND P.name = '%PLAYERNAME%') as b
ChazDazzle, what and where exactly it is necessary to write for create unique stats (for NLH)? And where can find file with standart stats?
M709199 is offline   Reply With Quote
Old 04-22-2017, 10:23 AM   #9070
ChazDazzle
adept
 
ChazDazzle's Avatar
 
Join Date: Aug 2005
Location: Casino Night Zone
Posts: 929
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by M709199 View Post
ChazDazzle, what and where exactly it is necessary to write for create unique stats (for NLH)? And where can find file with standart stats?
There still isn't a way to create custom hud stats. Here's the list of stats currently available.
ChazDazzle is offline   Reply With Quote
Old 04-22-2017, 01:14 PM   #9071
Tambuz
enthusiast
 
Join Date: Apr 2009
Posts: 99
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Hi, I'm using fpdb on pokerstars and the HUD appears in the wrong seat. In PS I have seat 1 as the preferred seat, so I edited the HUD_config.xml file as explained in the wiki, and now it looks like this:

<supported_sites>
<site site_name="PokerStars"
enabled="True"
screen_name="Tambuz"
site_path="C:/Program Files/PokerStars/"
HH_path="C:/Program Files/PokerStars/HandHistory/Tambuz/"
TS_path="C:/Program Files/PokerStars/TournSummary/Tambuz/"
aux_enabled="True" hud_menu_xshift="20" hud_menu_yshift="-20">
<email fetchType="request-summary" host="YOUR_EMAIL_SERVER"
username="YOUR_EMAIL_USERNAME" password="YOUR_EMAIL_PASSWORD"
useSsl="True" folder="INBOX"/>
<layout_set game_type="ring" ls="ps_default"/>
<layout_set game_type="tour" ls="ps_default"/>
<fav max="2" fav_seat="1"/>
<fav max="4" fav_seat="1"/>
<fav max="6" fav_seat="1"/>
<fav max="7" fav_seat="1"/>
<fav max="8" fav_seat="1"/>
<fav max="9" fav_seat="1"/>
<fav max="10" fav_seat="0"/>
</site>

The results were the same, HUD showing the wrong seat.

Then I restored the original .xml file and disabled the preferred seat in PS and the HUD was still appearing in a random seat.

I don't know why it says this is the HH path: HH_path="C:/Program Files/PokerStars/HandHistory/Tambuz/ (originally YOUR SCREEN NAME before I changed it) , I set it up correctly in the automatic import file, which is why the HUD appears in the first place, maybe it has something to do with that?
Tambuz is offline   Reply With Quote
Old 04-22-2017, 01:48 PM   #9072
M709199
stranger
 
Join Date: Apr 2017
Posts: 3
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by ChazDazzle View Post
There still isn't a way to create custom hud stats. Here's the list of stats currently available.
Ok. How to see the list of stats currently available? Command/file/etc.?
M709199 is offline   Reply With Quote
Old 04-22-2017, 04:30 PM   #9073
ChazDazzle
adept
 
ChazDazzle's Avatar
 
Join Date: Aug 2005
Location: Casino Night Zone
Posts: 929
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by M709199 View Post
Ok. How to see the list of stats currently available? Command/file/etc.?
https://github.com/philroberts/FPDB-...wiki/HUD-stats
ChazDazzle is offline   Reply With Quote
Old 04-22-2017, 04:32 PM   #9074
ChazDazzle
adept
 
ChazDazzle's Avatar
 
Join Date: Aug 2005
Location: Casino Night Zone
Posts: 929
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by Tambuz View Post
Hi, I'm using fpdb on pokerstars and the HUD appears in the wrong seat.
You don't happen to be trying to play a Zoom table are you? fpdb isn't set up to work with Zoom.
ChazDazzle is offline   Reply With Quote
Old 04-22-2017, 05:39 PM   #9075
Tambuz
enthusiast
 
Join Date: Apr 2009
Posts: 99
Re: Free/open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

Quote:
Originally Posted by ChazDazzle View Post
You don't happen to be trying to play a Zoom table are you? fpdb isn't set up to work with Zoom.
no, normal cash games and tournaments
Tambuz is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 12:03 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © 2008-2010, Two Plus Two Interactive
 
Poker Players - Streaming Live Online