Regs player list hands

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Regs player list hands

Postby BloMur » Mon Jul 29, 2024 3:50 am

I would like to separate hands played against regs. So far I was just typing and searching their nicknames one by one and tagging selected hands. Is there a faster way to do it ?
BloMur
 
Posts: 58
Joined: Fri Nov 24, 2017 7:47 pm

Re: Regs player list hands

Postby Flag_Hippo » Mon Jul 29, 2024 6:33 am

If you are defining a "reg" as someone that has statistics within a specified range then you can build a custom filter for that - see this thread.
Flag_Hippo
Moderator
 
Posts: 15219
Joined: Tue Jan 31, 2012 7:50 am

Re: Regs player list hands

Postby BloMur » Mon Jul 29, 2024 11:26 am

I defining reg as someone I played most tournaments/hands against and I have a treshold number for this. Is it even possible to filter this ?
BloMur
 
Posts: 58
Joined: Fri Nov 24, 2017 7:47 pm

Re: Regs player list hands

Postby Flag_Hippo » Mon Jul 29, 2024 12:21 pm

Code: Select all
tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having (sum(tc.cnt_hands) >= x and not thps.flg_hero))

where 'x' is the minimum number of hands you want.
Flag_Hippo
Moderator
 
Posts: 15219
Joined: Tue Jan 31, 2012 7:50 am

Re: Regs player list hands

Postby BloMur » Mon Jul 29, 2024 5:19 pm

How would I also go about adding specific position on reg in question ? In 3-way (BTN, BB, SB) and HU spots ?
BloMur
 
Posts: 58
Joined: Fri Nov 24, 2017 7:47 pm

Re: Regs player list hands

Postby Flag_Hippo » Tue Jul 30, 2024 6:05 am

Code: Select all
tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having (sum(tc.cnt_hands) >= x and not thps.flg_hero and thps.position = y))

where 'y' is the player position.
Flag_Hippo
Moderator
 
Posts: 15219
Joined: Tue Jan 31, 2012 7:50 am

Re: Regs player list hands

Postby BloMur » Tue Jul 30, 2024 6:57 am

What about 3way and HU, How to differentiate if there was 2 or 3 player preflop.
BloMur
 
Posts: 58
Joined: Fri Nov 24, 2017 7:47 pm

Re: Regs player list hands

Postby BloMur » Tue Jul 30, 2024 8:01 am

This method works, but the problem is database size. On big database I was unable to load hands, It is stuck on "loading..." for several hours. Is there a way to speed up this process ?
BloMur
 
Posts: 58
Joined: Fri Nov 24, 2017 7:47 pm

Re: Regs player list hands

Postby Flag_Hippo » Tue Jul 30, 2024 12:04 pm

BloMur wrote:How to differentiate if there was 2 or 3 player preflop.

Code: Select all
tourney_hand_summary.cnt_players = z and tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having (sum(tc.cnt_hands) >= x and not thps.flg_hero and thps.position = y))

where 'z' is the number of players dealt into the hand.
BloMur wrote:This method works, but the problem is database size. On big database I was unable to load hands, It is stuck on "loading..." for several hours. Is there a way to speed up this process ?

Did you start using a built-in filter for the number of players? If you did then clear that and filter for everything you need inside the expression filter.
Flag_Hippo
Moderator
 
Posts: 15219
Joined: Tue Jan 31, 2012 7:50 am

Re: Regs player list hands

Postby BloMur » Tue Jul 30, 2024 12:34 pm

I only used expression filter and still it is stuck in "loading...". I even deleted all the info about hand (like time, hole cards etc) and left only hand# and it did not helped.
BloMur
 
Posts: 58
Joined: Fri Nov 24, 2017 7:47 pm

Next

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: WhiteRider and 8 guests

cron