? tourney_hand_tble_summary ?

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny

? tourney_hand_tble_summary ?

Postby ccamp81318 » Sat Apr 10, 2021 2:59 pm

I don't understand the schema at this point.

ALTER TABLE ONLY tourney_hand_player_statistics ADD CONSTRAINT tourney_hand_player_statistics_primary_key PRIMARY KEY (id_player, id_hand);

yet enum_face_allin and enum_face_allin_action (and perhaps other fields) can have multiple values. How are these values stored in a multiway pot with allin bets or calls being made on multiple streets? Shouldn't these fields be flags on the order of flg_p_face_allin, flg_f_face_allin, flg_t_face_allin and flg_r_face_allin?

Thanks in advance for any help.

CT
ccamp81318
 
Posts: 14
Joined: Tue Mar 16, 2021 7:12 pm

Re: ? tourney_hand_player_statistics ?

Postby ccamp81318 » Sat Apr 10, 2021 9:36 pm

I can't think or type!

The table in question is tourney_hand_player_statistics.

Sorry for any confusion.
ccamp81318
 
Posts: 14
Joined: Tue Mar 16, 2021 7:12 pm

Re: ? tourney_hand_tble_summary ?

Postby Flag_Hippo » Sun Apr 11, 2021 5:47 am

Flag_Hippo
Moderator
 
Posts: 10785
Joined: Tue Jan 31, 2012 7:50 am

Re: ? tourney_hand_tble_summary ?

Postby ccamp81318 » Tue Apr 13, 2021 6:17 pm

Thanks flag_hippo but I'm still confused.
How are the values stored in a multiway pot with people going allin on different streets.
For instance:
the player faces an enum_face_allin of 'p' then of 'f' then of 't' then of 'r' followed finally by 'R'.

What am I missing?
ccamp81318
 
Posts: 14
Joined: Tue Mar 16, 2021 7:12 pm

Re: ? tourney_hand_tble_summary ?

Postby Flag_Hippo » Thu Apr 15, 2021 7:15 am

Only the first value would be stored so in that case enum_face_allin would be 'p'.
Flag_Hippo
Moderator
 
Posts: 10785
Joined: Tue Jan 31, 2012 7:50 am

Re: ? tourney_hand_tble_summary ?

Postby ccamp81318 » Thu Apr 15, 2021 12:44 pm

Thanks for the info but not what I was hoping for.
ccamp81318
 
Posts: 14
Joined: Tue Mar 16, 2021 7:12 pm

Re: ? tourney_hand_tble_summary ?

Postby ccamp81318 » Fri Apr 16, 2021 6:01 pm

One last (I hope) question on this subject.

The test for raise allin pf is

t = tourney_hand_player_statistics
l = lookup_action

if t.enum_allin = 'P' and
t.id_action_p = l.id_action and
l.action_text like '%R'

There is no reason to look at enum_face_allin.

Is the above correct?
ccamp81318
 
Posts: 14
Joined: Tue Mar 16, 2021 7:12 pm

Re: ? tourney_hand_tble_summary ?

Postby Flag_Hippo » Sat Apr 17, 2021 6:24 am

Yes there is no reason to use enum_face_allin.
Flag_Hippo
Moderator
 
Posts: 10785
Joined: Tue Jan 31, 2012 7:50 am

Re: ? tourney_hand_tble_summary ?

Postby ccamp81318 » Sat Apr 17, 2021 10:41 am

Flag_Hippo:

Thanks for the additional help.

C
ccamp81318
 
Posts: 14
Joined: Tue Mar 16, 2021 7:12 pm


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 7 guests

cron