Find how many players were dealt cards in the last 2 hands

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Find how many players were dealt cards in the last 2 hands

Postby 4StarGen » Fri Aug 12, 2022 2:21 pm

I'd like to find the players deal in the hand in the last hand and the previous one.

This expression work but I don't know how I can find the exact hand I'm looking for
Code: Select all
CASE WHEN cash_hand_summary.cnt_players = 2 THEN 2 ELSE 0 END


I need 2 sepated stats
4StarGen
 
Posts: 928
Joined: Sat Mar 08, 2014 6:58 am

Re: Find how many players were dealt cards in the last 2 han

Postby Flag_Hippo » Sat Aug 13, 2022 4:59 am

The information required to create statistics which are based on 'last x hands' are not stored in the database. It may be possible to build something using ORDER BY and LIMIT but unfortunately that's beyond my own SQL knowledge.
Flag_Hippo
Moderator
 
Posts: 14440
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 16 guests

cron
highfalutin