Bug fixed ? Schema updated?

[Duxx]

Re: stat: BB folds when SB opens
by APerfect10 on Fri Aug 08, 2008 1:17 pm

This appears to be a bug which I have added to our bug list and we will get resolved.

9 should always be the SB
8 should always be the BB

Has this been resolved?

If so, then the schema should mention it so that simple souls such as myself don't suffer brain-damage from too much head scratching.

[WhiteRider]

Can you link to the original thread, please.
IIRC this isn't the standard position stats, it's PF Aggressor or something?

[Duxx]

viewtopic.php?f=18&t=9911&st=0&sk=t&sd=a&start=10

I'd also appreciate it if you could give me an idea as to why when I run a certain report with a cusom stat of my own that a column containing "NA"
several times together with the required value is returned. As is, I am unable to incorporate this stat in the HUD. I have updated the cache.

I am trying to get an attempted steal from SB stat using the quotient of the following columns:

sum( if[holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp AND position = 9, 1, 0])

sum(if[holdem_hand_player_statistics.flg_p_open_opp AND position = 9, 1, 0])

BTW,if I use sum( if[holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_p_open_opp AND position = 9, 1, 0]) I get a VP$IP from SB instead. I also get "NA" several times in the report column in this case.

Thanks in advance.

[Duxx]

Just found a stat for this in the repository. It gives the same result as my stat but without the extra rows in the column (when run as a report). It should worh in the HUD now.

[WhiteRider]

Just found a stat for this in the repository. It gives the same result as my stat but without the extra rows in the column (when run as a report). It should worh in the HUD now.

So do you have the stat you want now?

FWIW; there is no point checking:
holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_p_open_opp
because "open" can't be true unless "open_opp" is true.

I'm not sure whether the "val_p_raise_aggressor_pos" has been fixed yet - I'll try to test later and check it out for you.

[Duxx]

[quote="WhiteRider
So do you have the stat you want now?
[/quote]

Yes thanks. It even works in the HUD and displays in a report as a one row column.

I'm still curious as to why "my stat" (now thankfully redundant) should show extra rows though in the report window.

BTW, if(holdem_hand_player_statistics.flg_p_open AND position = 9) is true <=> VP$IP from SB is true. It says in the schema that holdem_hand_player_statistics.flg_p_open pertains to an openraise. This is incorrect at least when applied to the SB.

Thanks for your help. Everything appears to be working although I am a little confused as to the whys and wherefores.

[WhiteRider]

holdem_hand_player_statistics.flg_p_open only implies the first action, call or raise.

If that doesn't explain your issue, you'll have to explain a little more clearly exactly what you mean?

[Duxx]

If you look in the schema documentation under holdem_hand_player_statistics.flg_p_open and holdem_hand_player_statistics.position you will see exactly what I mean. What you say makes perfect sense. What the schema says is not only clearly wrong but misleading which is somewhat frustrating when unexpected results occur. It would save some peoples time if the schema doc. were to be corrected. Thanks once again for your help.

[WhiteRider]

You're quite right - I hadn't looked back at the schema for a while.
Thanks for pointing this out.

[APerfect10]

Yes, I am aware that the database documentation is outdated. We will get this updated shortly. Thank for bringing this to our attention as a reminder :)

Best regards,

Derek