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 03-20-2009, 11:25 PM   #1251
freo
enthusiast
 
Join Date: Nov 2008
Posts: 90
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

The player stats and graphs work. I got the git yesterday from the ubuntu guide page by using
git clone git://git.assembla.com/free_poker_tools.git fpdb
freo is offline   Reply With Quote
Old 03-20-2009, 11:57 PM   #1252
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

Quote:
Originally Posted by Kris8400 View Post
Something minor: the graph window isn't cleared when you click Graph more than once, so the graphs show up under one another.
It works correctly on most installs in both linux and windows, but a few people are seeing this. But on some configurations the clear function isn't working and because it doesn't crash i've got no debug to indicate what the issue is.

I might add a bunch of comments in and around the refresh function before the next release to help track this.
sorrow is offline   Reply With Quote
Old 03-21-2009, 12:04 AM   #1253
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

Quote:
Originally Posted by Eleatic Stranger View Post
I've now converted my database to MyISAM and given the HUD a few hours' worth of testing. Nothing untoward happened, and nothing strange appeared in the error logs.

There was not too much noticeable improvement in speed, although I think it was a little faster (but not strikingly so). Remember that I have never had a problem with the speed of the HUD.
Quote:
Originally Posted by Eratosthenes View Post
Thanks for feeding this information back. I am a little disappointed that using the myISAM tables didn't show more improvement.
ES - Did you run a bulk import of any sort? We would see the performance improvements if any, much more clearly there.
sorrow is offline   Reply With Quote
Old 03-21-2009, 02:28 AM   #1254
Eleatic Stranger
journeyman
 
Join Date: Sep 2008
Location: Sydney
Posts: 292
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

Quote:
Originally Posted by tomfmason View Post
is there a way to import large amounts of hands in one swipe?
Quote:
Originally Posted by Eratosthenes View Post
You can also import all the files in a folder by selecting the folder in the BulkImport gui and clicking import.
Is there a standard GTK option that can be changed to permit the selection of multiple files? Currently the interface only lets you select one file (or folder) at a time.

Quote:
Originally Posted by ekdikeo View Post
so, we can move the tables around, and it will move the stat windows around to match, and then if you close the table before the hud, it kills the hud?
No, the HUD does not move with the table. And when the table is closed the HUD stays there; but it does no harm, i.e. the process doesn't crash, which is what matters.

Quote:
Originally Posted by sorrow View Post
ES - Did you run a bulk import of any sort? We would see the performance improvements if any, much more clearly there.
I've changed my database now, so it's a bit too late to compare bulk importing! I don't normally have any reason to use the bulk importer.
Eleatic Stranger is offline   Reply With Quote
Old 03-21-2009, 04:27 AM   #1255
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

Quote:
Originally Posted by Eleatic Stranger View Post
Is there a standard GTK option that can be changed to permit the selection of multiple files? Currently the interface only lets you select one file (or folder) at a time.
I'm sure there is, i've never gotten around to fixing though.
Quote:
Originally Posted by Eleatic Stranger View Post
I've changed my database now, so it's a bit too late to compare bulk importing! I don't normally have any reason to use the bulk importer.
Might have to go through this process myself soon and test.
sorrow is offline   Reply With Quote
Old 03-21-2009, 09:41 AM   #1256
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

Quote:
Originally Posted by Eleatic Stranger View Post
Is there a standard GTK option that can be changed to permit the selection of multiple files? Currently the interface only lets you select one file (or folder) at a time.
There are flags to set that allow extended selection and other cool stuff. I looked at that a while back--I think I didn't change it because the code was written to expect just one folder or file and I didn't want to spend a lot of effort on it at that time. There is a ton of effort going in to the new importer--so fixing this gui will get higher priority soon.
Quote:
No, the HUD does not move with the table. And when the table is closed the HUD stays there; but it does no harm, i.e. the process doesn't crash, which is what matters.
Right now I am trying to fix a few bugs and then get out a release. (The problem is that when I fix one bug, I create two more!) After that I am going to fix Tables.py to support table dragging, autoclosing, etc. on X. While I'm in there I will be able to do some speed/reliability/stability improvements. I will also make it easy(er) for someone to plug in OS/X support in the future.
Eratosthenes is offline   Reply With Quote
Old 03-21-2009, 09:08 PM   #1257
tchaz
Carpal \'Tunnel
 
tchaz's Avatar
 
Join Date: Jul 2008
Posts: 11,600
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

More clueless noob questions I'm afraid.

I've pulled the git from git://git.assembla.com/free_poker_tools.git on 20/3 & that worked fine. (I'm still doing this experimenting under XP.)

The flop_mucked aux_window is awesome (provided one doesn't move ones tables!). Automating configuration for this and the HUD would be nice - but not at the top of the list of things to do imo.

Instant switching tabs (below the drop down menus) - Am I missing some obvious way of closing these? (Another tiny point: in the "Positional" is spelt "Ppositional.)

Graphing - I have what presumably is the common problem. When I ask for a second graph (different dates) I get two copies of the second graph displayed. If I ask for a third I then get three copies of the third (newest) graph - and so on. One other strange this is that to generate the graph for 21st March 2009, say, I have to input start and end dates of 2009-03-22 and 2009-03-23.

Filters - It would be nice if one could have filters for different games/limits as well as dates. Conversely date &/or session filters for the tabulated player and positional stats would be good.

HUD - I removed the % signs, make player_names displayed lowercase and truncated to some reasonable number of letters by making light edits in Stats.py. (Changing the second ("1") value of the various tuples.) That seems to work - but maybe there's a better way. I'ld like to be able to have the stats in each column line-up - say all be right-justified. (Or maybe ideally, choosable for each displayed stat.) By default they seem to be centered. Presumably this is easy, but I haven't quite seen where to change up to now. Something that may be more tricky (& tbf I haven't tried to sort this out) that I would like is to have HERO's stats for each just display this session's stats for that table rather than `lifetime at the limit'. Can anyone give me a clue/head start on that?

Once again thanks to all the devs.
tchaz is offline   Reply With Quote
Old 03-22-2009, 10:17 AM   #1258
tchaz
Carpal \'Tunnel
 
tchaz's Avatar
 
Join Date: Jul 2008
Posts: 11,600
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

One more HUD question. PokerStars pops up a table when - and only once - the player needs to take action - great for multitabling. When the HUD updates itself it seems to auto-pop up the table in question, taking the focus away from where one is trying to take action. Is there a quick work-around for this?
tchaz is offline   Reply With Quote
Old 03-23-2009, 05:58 AM   #1259
ekdikeo
old hand
 
Join Date: Aug 2006
Posts: 1,307
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

tchaz, linux or windows, what window manager if linux?

not experiencing this in windows, at least not on poker4ever or full tilt .. although from what i understand, most places have rolled their own bring-forward code, so some of it may affect things differently. Using the mucked-card-window in the current builds however does do this, but usually the table stays in the background anyway, if there's another table awaiting input.
ekdikeo is offline   Reply With Quote
Old 03-23-2009, 07:05 AM   #1260
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

Quote:
Originally Posted by tchaz View Post
The flop_mucked aux_window is awesome (provided one doesn't move ones tables!). Automating configuration for this and the HUD would be nice - but not at the top of the list of things to do imo.
I'm sure this will become part of the example config pretty soon. There are still a few bugs to iron out yet, but it will likely be part of the default config on the next release i'd guess.
Quote:
Originally Posted by tchaz View Post
Instant switching tabs (below the drop down menus) - Am I missing some obvious way of closing these? (Another tiny point: in the "Positional" is spelt "Ppositional.)
No your not, there isn't a way to close that yet. You'd think I would have noticed that typo too.
Quote:
Originally Posted by tchaz View Post
Graphing - I have what presumably is the common problem. When I ask for a second graph (different dates) I get two copies of the second graph displayed. If I ask for a third I then get three copies of the third (newest) graph - and so on. One other strange this is that to generate the graph for 21st March 2009, say, I have to input start and end dates of 2009-03-22 and 2009-03-23.
re: multiple plots in same image. Are you getting 3 of the same plot, or 3 slightly different plots (i assume you are refreshing your current session)

This is something i've been unable to trigger - I think I may be refreshing the plot incorrectly, but it works on all the developers machines, making this difficult to track.

re: Dates... there are a couple of things that need fixing there. Assuming Stars files, what timezone do you have set. Its pretty close to accurate if you leave it at ET from memory
Quote:
Originally Posted by tchaz View Post
Filters - It would be nice if one could have filters for different games/limits as well as dates. Conversely date &/or session filters for the tabulated player and positional stats would be good.
Agreed. I want this too, so it will eventually happen. It needs a few things in place before we can do this. FWIW its only a couple of notches down onmy todo list, but its probably not going to happen for the next release.
Quote:
Originally Posted by tchaz View Post
HUD - I removed the % signs, make player_names displayed lowercase and truncated to some reasonable number of letters by making light edits in Stats.py. (Changing the second ("1") value of the various tuples.) That seems to work - but maybe there's a better way. I'ld like to be able to have the stats in each column line-up - say all be right-justified. (Or maybe ideally, choosable for each displayed stat.) By default they seem to be centered. Presumably this is easy, but I haven't quite seen where to change up to now. Something that may be more tricky (& tbf I haven't tried to sort this out) that I would like is to have HERO's stats for each just display this session's stats for that table rather than `lifetime at the limit'. Can anyone give me a clue/head start on that?

Once again thanks to all the devs.
This is Eratosthenes/ekdikeos area so i'll let them comment. On session stats - yes we want them too so watch this space.
sorrow is offline   Reply With Quote
Old 03-23-2009, 11:02 PM   #1261
tchaz
Carpal \'Tunnel
 
tchaz's Avatar
 
Join Date: Jul 2008
Posts: 11,600
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

sorrow - Thanks very much for your comments

Quote:
Originally Posted by sorrow View Post
re: multiple plots in same image. Are you getting 3 of the same plot, or 3 slightly different plots (i assume you are refreshing your current session)

This is something i've been unable to trigger - I think I may be refreshing the plot incorrectly, but it works on all the developers machines, making this difficult to track.
(Recall - this is WinXP running a git grab from free-poker-tools)

By "refreshing your current session" do you mean clearing the dates or something more. I don't see any options for doing a more thorough refresh.

Anyway I get identical copies of the plots. So on the nth input of new dates I get n identical copies of the correct plot for the nth pair of dates.

I did scrabble around in GuiGraphViewer.py on Sunday afternoon, but without reaching any conclusions. I seemed to be able to comment out
the two lines (ll.51-52) without effecting what I see,

if self.canvas is not None:
self.canvas.destroy()

so I imagine that somehow we aren't clearGraphData(self):-ing correctly.


Quote:
Originally Posted by sorrow View Post
re: Dates... there are a couple of things that need fixing there. Assuming Stars files, what timezone do you have set. Its pretty close to accurate if you leave it at ET from memory
I have GMT set. But I don't think it is a problem with ET/GMT conflicts - I've tried generating a graph in the afternoon (yesterday as now is since it is 2.30am my time!) for data collected exclusively that day (from both the pov of ET & GMT) - and I still have the same curiosity.
tchaz is offline   Reply With Quote
Old 03-23-2009, 11:35 PM   #1262
tchaz
Carpal \'Tunnel
 
tchaz's Avatar
 
Join Date: Jul 2008
Posts: 11,600
Thumbs up Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

I've also had an initial attempt at getting fpdb running under a linux distro just now. Here's a little feedback from that.

I'm running VectorLinux 6.0 - which is some stripped-down but tarted-up version of Slackware 12.1.0 which will run well on less powerful machines but has a little more in the way of creature comforts than Slackware itself. The computer is a generic laptop - dual processor 1.5 years old 1G mem - pretty standard imo.

I read the Install in Ubuntu section (seemed likely to be closer than Gentoo)(??) and modified ad-lib.

I grabbed git from the VL repository (with gslapt) and pulled the free-poker-tools fpdb. No problems. I then installed MySQL with gslapt. I then spent quite a lot of time searching with google for clues on how exactly to get mysql running healthily. (If I'ld looked in the FAQ I would have found some info.)

Eventually key steps included

chown -R mysql:mysql /var/lib/mysql

and following the info at

http://www.debianhelp.co.uk/mysqlroot.htm

This worked in the end. And "Then use the mysql shell.." from the Ubuntu page went smoothly. I copied over the HUD_Config.xml from WinXP and edited the pathnames to be readable under Unix (mounting the windows hh & program directories).

Next I went to www.slackbuilds.org and downloaded the mysqldb, matplotlib and numpy slackbuilds and the sources from sourceforge and installed them. No problem. (Do numpy before matplotlib.) (I didn't see matplotlib-data & numeric - maybe they are included in mathplotlib, numpy resp - I haven't checked this out yet.)

Then I opened fpdb. Some success and some fail.

Successes:

The main window opens correctly & one can use the gui to select directories.

I bulk imported hhs into the database reasonably successfully. (I have one or two failures, but I'm 99% certain that's bad hhs & nothing to do with fpdb.) The process didn't end gracefully - I seemed to be in some loop - I can find the log if you're interested, so I killed the terminal.

Opening fpdb again the import the process appears to have gone well. I generate and display player & positional stats correctly.

Less successful so far:

I don't see any sign of the HUD appearing on my PokerStars (6max NLHold'Em) table running under wine. However stop/start auto-import give some signs of life - the main window toggles between them.

Graphing complains it can't find numpy and matplotlib - so I can't report back on the many copies problem. I haven't thought about what is actually happening here yet - & it's getting late so maybe tomorrow.
(btw should I really need pylab - the ubuntu page doesn't mention it but I thought I saw it somewhere else?).

Hopefully I can sort these out with some pointers & so it looks (more or less) like another successful linux install.
tchaz is offline   Reply With Quote
Old 03-24-2009, 12:33 AM   #1263
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

Quote:
Originally Posted by tchaz View Post
Less successful so far:

I don't see any sign of the HUD appearing on my PokerStars (6max NLHold'Em) table running under wine. However stop/start auto-import give some signs of life - the main window toggles between them.
Are you getting anything in console here like '........' when you leave autoimport on?

If you are only getting .'s then its not detecting that your HH dir is updating.
Quote:
Originally Posted by tchaz View Post
Graphing complains it can't find numpy and matplotlib - so I can't report back on the many copies problem. I haven't thought about what is actually happening here yet - & it's getting late so maybe tomorrow.
(btw should I really need pylab - the ubuntu page doesn't mention it but I thought I saw it somewhere else?).
Sounds like numpy/etc installed to a non python site-packages directory, on ubuntu its installed into /usr/lib/python2.5/site-packages/.

There was a post a couple of pages back for the Mac that had the same issue, i posted a solution there.

You may also need to recompile numpy/etc with specific gtk options.
sorrow is offline   Reply With Quote
Old 03-24-2009, 02:43 AM   #1264
tchaz
Carpal \'Tunnel
 
tchaz's Avatar
 
Join Date: Jul 2008
Posts: 11,600
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

Quote:
Originally Posted by sorrow View Post
Are you getting anything in console here like '........' when you leave autoimport on?

If you are only getting .'s then its not detecting that your HH dir is updating.

Sounds like numpy/etc installed to a non python site-packages directory, on ubuntu its installed into /usr/lib/python2.5/site-packages/.

There was a post a couple of pages back for the Mac that had the same issue, i posted a solution there.

You may also need to recompile numpy/etc with specific gtk options.
Thanks for the numpy hint - I'll look into it.

autoimport: yes exactly this I'm getting dots continuously (1 every 5 secs or so)
tchaz is offline   Reply With Quote
Old 03-24-2009, 10:35 PM   #1265
freo
enthusiast
 
Join Date: Nov 2008
Posts: 90
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

Quote:
Originally Posted by freo View Post
Are positional stats working? I select it from the menu and nothing happens.
Any thoughts on this? My graphs and player stats are working fine. Could it be the GIT version that i used?
freo is offline   Reply With Quote
Old 03-24-2009, 10:44 PM   #1266
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-

Quote:
Originally Posted by freo View Post
Any thoughts on this? My graphs and player stats are working fine. Could it be the GIT version that i used?
Hi freo--

Please pull the latest from the git repo and import again. (First clear the database, by selecting create/recreate tables from the database menu.) I was scattering some bugs in the import code at about the same time you cloned the git repo. I am pretty sure those bugs are now squashed. I am not sure this will help, but it is worth a try.
Eratosthenes is offline   Reply With Quote
Old 03-25-2009, 05:50 AM   #1267
Kris8400
newbie
 
Join Date: Jun 2008
Posts: 26
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-2008

How should preferred seat be set up for FTP? I always sit at the bottom seat in 6max and followed the instructions for Stars, but the HUD labels are all over the place.
Kris8400 is offline   Reply With Quote
Old 03-25-2009, 10:25 AM   #1268
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-2008

Quote:
Originally Posted by Kris8400 View Post
How should preferred seat be set up for FTP? I always sit at the bottom seat in 6max and followed the instructions for Stars, but the HUD labels are all over the place.
For FTP 6 max tables the centered seat is 3.

So the 6 max layout under Full Tilt needs to start like this:
<layout fav_seat="3" height="547" max="6" width="794">

other fav_seats at FTP:
8 max -- fav_seat="4"
9 max -- fav_seat="5"
2 max -- fav_seat="1"
Eratosthenes is offline   Reply With Quote
Old 03-26-2009, 05:06 AM   #1269
Kris8400
newbie
 
Join Date: Jun 2008
Posts: 26
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-2008

Quote:
Originally Posted by Eratosthenes View Post
For FTP 6 max tables the centered seat is 3.

So the 6 max layout under Full Tilt needs to start like this:
<layout fav_seat="3" height="547" max="6" width="794">

other fav_seats at FTP:
8 max -- fav_seat="4"
9 max -- fav_seat="5"
2 max -- fav_seat="1"
Thanks, very useful info!

Now you don't happen to know the resolution of the FTP/PS mini windows do you?
Kris8400 is offline   Reply With Quote
Old 03-26-2009, 10:24 AM   #1270
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-2008

Quote:
Originally Posted by Kris8400 View Post
Thanks, very useful info!

Now you don't happen to know the resolution of the FTP/PS mini windows do you?
You can ignore the width and height parameters in that element (at least for now). I put those in to give the HUD a reference for moving the stat windows when the user resizes a poker client. I have not implemented that behavior yet. (That was answering the question you didn't ask.)

Sorry--I don't know the minimum table sizes on those sites.
Eratosthenes is offline   Reply With Quote
Old 03-26-2009, 09:01 PM   #1271
tchaz
Carpal \'Tunnel
 
tchaz's Avatar
 
Join Date: Jul 2008
Posts: 11,600
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-2008

Eratosthenes - any feedback on posts #1257 & #1258 you can give would be wonderful - but thanks for the super hud in any case.
tchaz is offline   Reply With Quote
Old 03-27-2009, 01:48 AM   #1272
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-2008

Quote:
Originally Posted by tchaz View Post
The flop_mucked aux_window is awesome (provided one doesn't move ones tables!).
I spent a day on this and was a miserable failure. I'll give it another shot
Quote:
Automating configuration for this and the HUD would be nice - but not at the top of the list of things to do imo.
This and fancier stats are the next big thing that I'm goint to do. I've been thinking a lot about how to support do these 2 things--I am almost ready to actually start coding it.
Quote:
Instant switching tabs (below the drop down menus) - Am I missing some obvious way of closing these?
No way to close as of now.
Quote:
Filters - It would be nice if one could have filters for different games/limits as well as dates. Conversely date &/or session filters for the tabulated player and positional stats would be good.
A really good filter widget would help the stats and graph screens. I don't think that is too near the top of anybodies todo list right now.
Quote:
HUD - I removed the % signs, make player_names displayed lowercase and truncated to some reasonable number of letters by making light edits in Stats.py. (Changing the second ("1") value of the various tuples.) That seems to work - but maybe there's a better way. I'ld like to be able to have the stats in each column line-up - say all be right-justified. (Or maybe ideally, choosable for each displayed stat.) By default they seem to be centered. Presumably this is easy, but I haven't quite seen where to change up to now.
Here is how to center, etc. stats in labels. Your edits in Stats.py probably make sense--that will all be part of the facier stats routine and config.
Quote:
Something that may be more tricky (& tbf I haven't tried to sort this out) that I would like is to have HERO's stats for each just display this session's stats for that table rather than `lifetime at the limit'. Can anyone give me a clue/head start on that?
Session stats are something I want to do, as is a method for having a different set of stats for the hero. There are some design decisions that have made this tricky. I will write some more on this later.
Quote:
Originally Posted by tchaz View Post
One more HUD question. PokerStars pops up a table when - and only once - the player needs to take action - great for multitabling. When the HUD updates itself it seems to auto-pop up the table in question, taking the focus away from where one is trying to take action. Is there a quick work-around for this?
Windows and Linux seem to behave differently on this. I don't think there is a quick work-around. I really don't like the way the HUD interacts with the poker clients and plan to do some more work on that as soon as I put out a new release.
Eratosthenes is offline   Reply With Quote
Old 03-27-2009, 04:24 AM   #1273
Eleatic Stranger
journeyman
 
Join Date: Sep 2008
Location: Sydney
Posts: 292
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-2008

I've come across a problem with one of the HUD statistics. The problem appears to be new, and I have been using the HUD for many months by now.

The 3-bet pre-flop statistic no longer seems to make sense. In one of my NL HE games I have 17,000 hands recorded, but my 3-bet frequency is listed as 1/19 (5.3 %). The figure may be correct as a percentage, but I have obviously three-bet many more times than once in 17,000 hands! The same effect occurs with other players.

Could someone perhaps suggest a test I can perform to try to determine what is going wrong, e.g. some SQL to see whether the database is consistent?

Remember that I have manually converted my MySQL tables from INNODB to MyISAM; but everything else still seems to be correct, so I wouldn't attribute the fault to this.
Eleatic Stranger is offline   Reply With Quote
Old 03-27-2009, 04:31 AM   #1274
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-2008

Quote:
Originally Posted by Eleatic Stranger View Post
The 3-bet pre-flop statistic no longer seems to make sense. In one of my NL HE games I have 17,000 hands recorded, but my 3-bet frequency is listed as 1/19 (5.3 %).
I've seen this behavior using the fastStoreHudCache function initially in Postgres, and more recently in MySQL. I haven't been able to track down when this happens as yet.

Can you switch off that variable for me and see whether your counter increases properly?
sorrow is offline   Reply With Quote
Old 03-27-2009, 05:43 AM   #1275
Eleatic Stranger
journeyman
 
Join Date: Sep 2008
Location: Sydney
Posts: 292
Re: New Free/open source poker tracking software: FPDB - (Alpha9 - updates) - 10-Nov-2008

Quote:
Originally Posted by sorrow View Post
I've seen this behavior using the fastStoreHudCache function initially in Postgres, and more recently in MySQL. I haven't been able to track down when this happens as yet.

Can you switch off that variable for me and see whether your counter increases properly?
Aha. I recently switched fastStoreHudCache on. It does look as if there's something wrong with the function. (But there shouldn't be; it looks so simple!) I'll let you know what happens when I switch it back off. Thanks for the pointer.

I don't suppose there is any way of regenerating the correct cache values (which are now all wrong) other than by wiping out the database and re-importing everything, is there? (not that this is much of an inconvenience, but I like to have something to moan about).
Eleatic Stranger 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 07:41 AM.


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