Page 1 of 1

flg_f_cbet possible bug?

PostPosted: Wed Feb 06, 2008 11:09 am
by SoundMan
I'm trying to to get players cbet percentage.
This is the query I run:
[codezr9]SUM(case when (hhps.flg_f_cbet) then 1 else 0 end) || '/' || SUM(case when (hhps.flg_f_cbet_opp) then 1 else 0 end)[/codezr9]

hhps obviously being holdem_hand_player_statistics.

I get results like 78/12 which is clearly incorrect. Am I missing something or is this a bug?

Re: flg_f_cbet possible bug?

PostPosted: Wed Feb 06, 2008 11:54 am
by Josh
What version of PT3 was used to import these hands?

Re: flg_f_cbet possible bug?

PostPosted: Wed Feb 06, 2008 5:37 pm
by SoundMan
I'm running beta 3 and I'm pretty sure I had to import my hands again after installing this beta.
Just to make sure, I decided to do create a new db and import the hands again, and now everything seems fine.
Running the query on the old db for a certain player returned a result of 135/4.
Running the query for the same player on the new db returns 135/170, which looks a whole lot better.
I guess the old db got corrupted somehow. I'm sorry to have bothered you with this. I should obviously have tried to reimport first.

Anyways, keep up the good work. I'm looking forward to the continued exploration of this great product. All these new stats has me drooling.