Creating stat with "Hand values"

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Creating stat with "Hand values"

Postby xpastorcitox » Thu Jan 05, 2023 10:06 am

Hi, want to build a stat taking into account the Hand strenght, I have a stat created, but want to add the variables for hand strenght. Can't find how to.

Need multiples conditions too, uploading the photo with the filter I need.

Hope you can help me, thanks.

https://postimg.cc/1ngrd5vT
xpastorcitox
 
Posts: 15
Joined: Fri Mar 30, 2012 11:22 am

Re: Creating stat with "Hand values"

Postby Flag_Hippo » Thu Jan 05, 2023 1:29 pm

If you have a built-in filter then you can extract the query you need from the PokerTracker 4 log file - see the end of this post.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Creating stat with "Hand values"

Postby xpastorcitox » Fri Jan 06, 2023 9:48 am

Thanks for the reply.

(((NOT ((((cash_hand_player_combinations.flg_f_1pair AND cash_hand_player_combinations.val_f_hole_cards_used = 2) OR (cash_hand_player_combinations.flg_t_1pair AND cash_hand_player_combinations.val_t_hole_cards_used = 2) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.val_r_hole_cards_used = 2)))OR ((((cash_hand_player_combinations.flg_f_threeoak OR cash_hand_player_combinations.flg_t_threeoak OR cash_hand_player_combinations.flg_r_threeoak))))OR ((((cash_hand_player_combinations.flg_f_straight OR cash_hand_player_combinations.flg_t_straight OR cash_hand_player_combinations.flg_r_straight))))OR ((((cash_hand_player_combinations.flg_f_flush OR cash_hand_player_combinations.flg_t_flush OR cash_hand_player_combinations.flg_r_flush))))OR ((((cash_hand_player_combinations.flg_f_fullhouse OR cash_hand_player_combinations.flg_t_fullhouse OR cash_hand_player_combinations.flg_r_fullhouse))))OR ((((cash_hand_player_combinations.flg_f_fouroak OR cash_hand_player_combinations.flg_t_fouroak OR cash_hand_player_combinations.flg_r_fouroak))))OR ((((cash_hand_player_combinations.flg_f_strflush OR cash_hand_player_combinations.flg_t_strflush OR cash_hand_player_combinations.flg_r_strflush))))OR (((cash_hand_player_combinations.flg_f_1pair AND cash_hand_player_combinations.val_f_hole_cards_used = 2) OR (cash_hand_player_combinations.flg_t_1pair AND cash_hand_player_combinations.val_t_hole_cards_used = 2) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.val_r_hole_cards_used = 2)))OR (((cash_hand_player_combinations.flg_f_1pair AND cash_hand_player_combinations.val_f_hole_cards_used = 1 AND cash_hand_player_combinations.id_f_hand_strength = 3) OR (cash_hand_player_combinations.flg_t_1pair AND cash_hand_player_combinations.val_t_hole_cards_used = 1 AND cash_hand_player_combinations.id_t_hand_strength = 3) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.val_r_hole_cards_used = 1 AND cash_hand_player_combinations.id_r_hand_strength = 3))OR ((cash_hand_player_combinations.flg_f_1pair AND cash_hand_player_combinations.val_f_hole_cards_used = 1 AND cash_hand_player_combinations.id_f_hand_strength = 2) OR (cash_hand_player_combinations.flg_t_1pair AND cash_hand_player_combinations.val_t_hole_cards_used = 1 AND cash_hand_player_combinations.id_t_hand_strength = 2) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.val_r_hole_cards_used = 1 AND cash_hand_player_combinations.id_r_hand_strength = 2)))OR (((cash_hand_player_combinations.flg_f_2pair AND cash_hand_player_combinations.val_f_hole_cards_used = 2 AND cash_hand_player_combinations.id_f_hand_strength >= 7) OR (cash_hand_player_combinations.flg_t_2pair AND cash_hand_player_combinations.val_t_hole_cards_used = 2 AND cash_hand_player_combinations.id_t_hand_strength >= 7) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.val_r_hole_cards_used = 2 AND cash_hand_player_combinations.id_r_hand_strength >= 7)))OR (((cash_hand_player_combinations.flg_f_2pair AND cash_hand_player_combinations.val_f_hole_cards_used = 2 AND cash_hand_player_combinations.id_f_hand_strength BETWEEN 4 and 6) OR (cash_hand_player_combinations.flg_t_2pair AND cash_hand_player_combinations.val_t_hole_cards_used = 2 AND cash_hand_player_combinations.id_t_hand_strength BETWEEN 4 and 6) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.val_r_hole_cards_used = 2 AND cash_hand_player_combinations.id_r_hand_strength BETWEEN 4 and 6)))OR (((cash_hand_player_combinations.flg_f_2pair AND cash_hand_player_combinations.val_f_hole_cards_used = 1 AND cash_hand_player_combinations.id_f_hand_strength BETWEEN 1 and 3) OR (cash_hand_player_combinations.flg_t_2pair AND cash_hand_player_combinations.val_t_hole_cards_used = 1 AND cash_hand_player_combinations.id_t_hand_strength BETWEEN 1 and 3) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.val_r_hole_cards_used = 1 AND cash_hand_player_combinations.id_r_hand_strength BETWEEN 1 and 3))))))))


I extracted this from the log which correspond to hand strenght, but if I add "AND" and all of this, it says "The statement is not valid SQL"


Ideas?
xpastorcitox
 
Posts: 15
Joined: Fri Mar 30, 2012 11:22 am

Re: Creating stat with "Hand values"

Postby Flag_Hippo » Fri Jan 06, 2023 1:45 pm

There are too many brackets and a mismatch so that needs to be changed. Remove the brackets before the NOT and then 4 from the end:

Code: Select all
NOT ((((cash_hand_player_combinations.flg_f_1pair AND cash_hand_player_combinations.val_f_hole_cards_used = 2) OR (cash_hand_player_combinations.flg_t_1pair AND cash_hand_player_combinations.val_t_hole_cards_used = 2) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.val_r_hole_cards_used = 2)))OR ((((cash_hand_player_combinations.flg_f_threeoak OR cash_hand_player_combinations.flg_t_threeoak OR cash_hand_player_combinations.flg_r_threeoak))))OR ((((cash_hand_player_combinations.flg_f_straight OR cash_hand_player_combinations.flg_t_straight OR cash_hand_player_combinations.flg_r_straight))))OR ((((cash_hand_player_combinations.flg_f_flush OR cash_hand_player_combinations.flg_t_flush OR cash_hand_player_combinations.flg_r_flush))))OR ((((cash_hand_player_combinations.flg_f_fullhouse OR cash_hand_player_combinations.flg_t_fullhouse OR cash_hand_player_combinations.flg_r_fullhouse))))OR ((((cash_hand_player_combinations.flg_f_fouroak OR cash_hand_player_combinations.flg_t_fouroak OR cash_hand_player_combinations.flg_r_fouroak))))OR ((((cash_hand_player_combinations.flg_f_strflush OR cash_hand_player_combinations.flg_t_strflush OR cash_hand_player_combinations.flg_r_strflush))))OR (((cash_hand_player_combinations.flg_f_1pair AND cash_hand_player_combinations.val_f_hole_cards_used = 2) OR (cash_hand_player_combinations.flg_t_1pair AND cash_hand_player_combinations.val_t_hole_cards_used = 2) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.val_r_hole_cards_used = 2)))OR (((cash_hand_player_combinations.flg_f_1pair AND cash_hand_player_combinations.val_f_hole_cards_used = 1 AND cash_hand_player_combinations.id_f_hand_strength = 3) OR (cash_hand_player_combinations.flg_t_1pair AND cash_hand_player_combinations.val_t_hole_cards_used = 1 AND cash_hand_player_combinations.id_t_hand_strength = 3) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.val_r_hole_cards_used = 1 AND cash_hand_player_combinations.id_r_hand_strength = 3))OR ((cash_hand_player_combinations.flg_f_1pair AND cash_hand_player_combinations.val_f_hole_cards_used = 1 AND cash_hand_player_combinations.id_f_hand_strength = 2) OR (cash_hand_player_combinations.flg_t_1pair AND cash_hand_player_combinations.val_t_hole_cards_used = 1 AND cash_hand_player_combinations.id_t_hand_strength = 2) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.val_r_hole_cards_used = 1 AND cash_hand_player_combinations.id_r_hand_strength = 2)))OR (((cash_hand_player_combinations.flg_f_2pair AND cash_hand_player_combinations.val_f_hole_cards_used = 2 AND cash_hand_player_combinations.id_f_hand_strength >= 7) OR (cash_hand_player_combinations.flg_t_2pair AND cash_hand_player_combinations.val_t_hole_cards_used = 2 AND cash_hand_player_combinations.id_t_hand_strength >= 7) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.val_r_hole_cards_used = 2 AND cash_hand_player_combinations.id_r_hand_strength >= 7)))OR (((cash_hand_player_combinations.flg_f_2pair AND cash_hand_player_combinations.val_f_hole_cards_used = 2 AND cash_hand_player_combinations.id_f_hand_strength BETWEEN 4 and 6) OR (cash_hand_player_combinations.flg_t_2pair AND cash_hand_player_combinations.val_t_hole_cards_used = 2 AND cash_hand_player_combinations.id_t_hand_strength BETWEEN 4 and 6) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.val_r_hole_cards_used = 2 AND cash_hand_player_combinations.id_r_hand_strength BETWEEN 4 and 6)))OR (((cash_hand_player_combinations.flg_f_2pair AND cash_hand_player_combinations.val_f_hole_cards_used = 1 AND cash_hand_player_combinations.id_f_hand_strength BETWEEN 1 and 3) OR (cash_hand_player_combinations.flg_t_2pair AND cash_hand_player_combinations.val_t_hole_cards_used = 1 AND cash_hand_player_combinations.id_t_hand_strength BETWEEN 1 and 3) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.val_r_hole_cards_used = 1 AND cash_hand_player_combinations.id_r_hand_strength BETWEEN 1 and 3))))

If you copy an expression into Notepad++ it will highlight matching brackets automatically. If it still does not validate when adding to the rest of your expression you will need to copy/paste that entire expression instead.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Creating stat with "Hand values"

Postby xpastorcitox » Fri Jan 06, 2023 8:01 pm

Amazing, ty!
xpastorcitox
 
Posts: 15
Joined: Fri Mar 30, 2012 11:22 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 23 guests

cron