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-04-2017 , 12:04 AM
Quote:
Originally Posted by Jochends
Yea.. Already tryed that.
OK. Are there any useful-looking messages in the log files?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-12-2017 , 06:27 PM
From looking at the OP I'll assume it doesn't, but does FPDB support ACR?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-12-2017 , 08:41 PM
Quote:
Originally Posted by Go Get It
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-12-2017 , 11:47 PM
TY
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-13-2017 , 05:07 PM
When I try to run FPDB I get "An invalid DB version or missing tables have been detected"

How to fix?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-13-2017 , 07:47 PM
Quote:
Originally Posted by Go Get It
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-13-2017 , 07:50 PM
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-13-2017 , 09:28 PM
Quote:
Originally Posted by TheDruid
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?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-13-2017 , 09:31 PM
Quote:
Originally Posted by ChazDazzle
I have this version and when I go to Configure -- Site Settings ACR is not an option fwiw.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-14-2017 , 12:12 AM
Quote:
Originally Posted by Go Get It
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.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-14-2017 , 12:16 AM
Quote:
Originally Posted by Go Get It
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-14-2017 , 04:19 PM
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.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-14-2017 , 04:39 PM
Quote:
Originally Posted by Go Get It
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-14-2017 , 05:29 PM
Quote:
Originally Posted by phil_r
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.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-15-2017 , 04:42 PM
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-15-2017 , 05:53 PM
Quote:
Originally Posted by TheDruid
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?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-15-2017 , 06:31 PM
I've sent a dozen files zipped up, and a list of the hands affected.

Hope it helps.

Cheers,
--D
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-17-2017 , 09:41 AM
Quote:
Originally Posted by TheDruid
I've sent a dozen files zipped up, and a list of the hands affected.

Hope it helps.

Cheers,
--D
Thanks. Fixed
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-22-2017 , 07:56 AM
Quote:
Originally Posted by ChazDazzle
Quote:
Originally Posted by Forrest Gump
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?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-22-2017 , 10:23 AM
Quote:
Originally Posted by M709199
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.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-22-2017 , 01:14 PM
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?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-22-2017 , 01:48 PM
Quote:
Originally Posted by ChazDazzle
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.?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-22-2017 , 04:30 PM
Quote:
Originally Posted by M709199
Ok. How to see the list of stats currently available? Command/file/etc.?
https://github.com/philroberts/FPDB-...wiki/HUD-stats
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-22-2017 , 04:32 PM
Quote:
Originally Posted by Tambuz
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.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-22-2017 , 05:39 PM
Quote:
Originally Posted by ChazDazzle
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m