Advanced Hud Config for Tourney's

[preparac]

Kraada, I cleaned up your stats and they are working ok, as soon you wipe out the double tourney_tourney_ ...

One exeption: Your limp/Fold stats allways give me the value 0. Perhaps you want to fix this also (and tell me what the problem was with them, because I anyway want to rebuild them with my an openlimp/fold stat ...).

Two remarks more:
- The W$SD-stat doesn't make much so sense in the M Zone popup I think, because this value almost doesn't change in average through the different Zones ...
- It's quite anoying, that we cannot define your new HUD (or any selfmade Hud) as the default HUD, because allways when we are seated at a new table, this will bring back the default stat ... Will this be possible in a next release.

thanks again for your great work.

You want that I PM you the cleaned stats, so that you can bring them out faster?

[WhiteRider]

Kraada already has the clean stats, they're working fine for him - the problem is added either in the export or the import.
We hope it's in the export so that when we get a new version he can re-export and it will work for everyone, but we don't know exactly when this will be yet.

[preparac]

Ah yeah... and I also have an Error, when I try to make housekeeping ...

There were errors during the housekeeping process:
Unable to execute query: CREATE TABLE tourney_holdem_cache (id_player integer NOT NULL, id_blinds integer NOT NULL, cnt_players integer NOT NULL, cnt_hands integer, cnt_vpip integer, cnt_blind integer, cnt_bb integer, cnt_sb integer, cnt_vpip_sb integer, cnt_sb_steal_fold integer, cnt_bb_steal_fold integer, cnt_steal_def_opp_sb integer, cnt_steal_def_opp_bb integer, cnt_steal_att integer, cnt_steal_opp integer, cnt_won_hand integer, cnt_won_showdown integer, cnt_first_limp integer, cnt_prev_callers_limp integer, cnt_prev_callers_raise integer, cnt_f_saw_won integer, cnt_wtsd integer, cnt_wtsd_won integer, cnt_f_saw integer, cnt_t_saw integer, cnt_r_saw integer, cnt_p_raise integer, cnt_pfr integer, cnt_p_call integer, cnt_p_ccall integer, cnt_p_fold integer, cnt_p_pfr_call integer, cnt_p_pfr_call_opp integer, cnt_f_check integer, cnt_f_check_raise integer, cnt_f_check_raise_opp integer, cnt_f_bet integer, cnt_f_raise integer, cnt_f_call integer, cnt_f_fold integer, cnt_t_check integer, cnt_t_check_raise integer, cnt_t_check_raise_opp integer, cnt_t_bet integer, cnt_t_raise integer, cnt_t_raise_wtsd integer, cnt_t_raise_wtsd_won integer, cnt_t_call integer, cnt_t_fold integer, cnt_r_check integer, cnt_r_check_raise integer, cnt_r_check_raise_opp integer, cnt_r_bet integer, cnt_r_raise integer, cnt_r_raise_wtsd integer, cnt_r_raise_wtsd_won integer, cnt_r_call integer, cnt_r_fold integer, amt_won numeric(11,2), amt_blind numeric(11,2), cnt_p_3bet integer, cnt_p_3bet_opp integer, cnt_p_3bet_def_opp integer, cnt_p_3bet_def_action_fold integer, cnt_p_3bet_def_action_call integer, cnt_p_3bet_def_action_raise integer, cnt_f_3bet integer, cnt_f_3bet_opp integer, cnt_f_3bet_def_opp integer, cnt_f_3bet_def_action_fold integer, cnt_f_3bet_def_action_call integer, cnt_t_3bet integer, cnt_t_3bet_opp integer, cnt_t_3bet_def_opp integer, cnt_t_3bet_def_action_fold integer, cnt_t_3bet_def_action_call integer, cnt_t_3bet_def_action_raise integer, cnt_r_3bet integer, cnt_r_3bet_def_action_call integer, cnt_r_3bet_def_action_fold integer, cnt_r_3bet_def_action_raise integer, cnt_r_3bet_opp integer, cnt_f_4bet integer, cnt_f_4bet_def_action_call integer, cnt_f_4bet_def_action_fold integer, cnt_f_4bet_def_action_raise integer, cnt_f_4bet_def_opp integer, cnt_f_4bet_opp integer, cnt_p_4bet integer, cnt_p_4bet_def_action_call integer, cnt_p_4bet_def_action_fold integer, cnt_p_4bet_def_action_raise integer, cnt_p_4bet_def_opp integer, cnt_p_4bet_opp integer, cnt_r_4bet integer, cnt_r_4bet_def_action_call integer, cnt_r_4bet_def_action_fold integer, cnt_r_4bet_def_action_raise integer, cnt_r_4bet_def_opp integer, cnt_r_4bet_opp integer, cnt_t_4bet integer, cnt_t_4bet_def_action_call integer, cnt_t_4bet_def_action_fold integer, cnt_t_4bet_def_action_raise integer, cnt_t_4bet_def_opp integer, cnt_t_4bet_opp integer, cnt_f_cbet integer, cnt_f_cbet_def_action_call integer, cnt_f_cbet_def_action_fold integer, cnt_f_cbet_def_action_raise integer, cnt_f_cbet_def_opp integer, cnt_f_cbet_opp integer, cnt_t_cbet integer, cnt_t_cbet_def_action_call integer, cnt_t_cbet_def_action_fold integer, cnt_t_cbet_def_action_raise integer, cnt_t_cbet_def_opp integer, cnt_t_cbet_opp integer, cnt_r_cbet integer, cnt_r_cbet_def_action_call integer, cnt_r_cbet_def_action_fold integer, cnt_r_cbet_def_action_raise integer, cnt_r_cbet_def_opp integer, cnt_r_cbet_opp integer, cnt_f_bet_def_opp integer, cnt_f_bet_def_action_fold integer, cnt_f_bet_def_action_call integer, cnt_f_bet_def_action_raise integer, cnt_f_raise_def_opp integer, cnt_f_raise_def_action_fold integer, cnt_f_raise_def_action_call integer, cnt_t_bet_def_action_call integer, cnt_t_bet_def_action_fold integer, cnt_t_bet_def_action_raise integer, cnt_t_bet_def_opp integer, cnt_t_raise_def_action_call integer, cnt_t_raise_def_action_fold integer, cnt_t_raise_def_opp integer, cnt_r_bet_def_action_call integer, cnt_r_bet_def_action_fold integer, cnt_r_bet_def_action_raise integer, cnt_r_bet_def_opp integer, amt_bb_won numeric(11,2), cnt_p_first_raise integer, cnt_r_raise_def_action_call integer, cnt_r_raise_def_action_fold integer, cnt_r_raise_def_opp integer, cnt_f_3bet_def_action_raise integer, cnt_r_3bet_def_opp integer, cnt_r_donk integer, cnt_r_donk_def_action_call integer, cnt_r_donk_def_action_fold integer, cnt_r_donk_def_action_raise integer, cnt_r_donk_def_opp integer, cnt_r_donk_opp integer, cnt_r_float integer, cnt_r_float_def_action_call integer, cnt_r_float_def_action_fold integer, cnt_r_float_def_action_raise integer, cnt_r_float_def_opp integer, cnt_r_float_opp integer, cnt_t_donk integer, cnt_t_donk_def_action_call integer, cnt_t_donk_def_action_fold integer, cnt_t_donk_def_action_raise integer, cnt_t_donk_def_opp integer, cnt_t_donk_opp integer, cnt_t_float integer, cnt_t_float_def_action_call integer, cnt_t_float_def_action_fold integer, cnt_t_float_def_action_raise integer, cnt_t_float_def_opp integer, cnt_t_float_opp integer, cnt_p_face_raise integer, cnt_p_ccall_opp integer, cnt_hands_with_flop integer, cnt_p_raise_first_in integer, cnt_p_open_opp integer, cnt_fold_when_p_bet_raise integer, cnt_p_bet_raise_hands integer, cnt_steal_att_fold integer, cnt_p_bb_fold_to_sb integer, cnt_p_bb_fold_to_sb_opp integer, cnt_steal_def_opp_bb_win_sd integer, cnt_steal_def_opp_bb_wtsd integer, cnt_steal_def_opp_bb_win_wo_sd integer, cnt_steal_def_opp_bb_nosd integer, cnt_f_total_actions integer, cnt_total_actions integer, cnt_p_total_actions integer, cnt_p_check integer, cnt_t_total_actions integer, cnt_r_total_actions integer, cnt_fold_when_f_bet_raise integer, cnt_f_bet_raise_hands integer, cnt_fold_when_r_bet_raise integer, cnt_r_bet_raise_hands integer, cnt_fold_when_t_bet_raise integer, cnt_t_bet_raise_hands integer, cnt_fold_when_f_call integer, cnt_f_call_hands integer, cnt_fold_when_p_call integer, cnt_p_call_hands integer, cnt_fold_when_r_call integer, cnt_r_call_hands integer, cnt_fold_when_t_call integer, cnt_t_call_hands integer, cnt_pfr_f_bet integer, cnt_pfr_f_call integer, cnt_pfr_f_check integer, cnt_pfr_f_checkraise integer, cnt_pfr_f_fold integer, cnt_pfr_f_none integer, cnt_pfr_f_raise integer, cnt_steal_def_opp_sb_win_sd integer, cnt_steal_def_opp_sb_wtsd integer, cnt_steal_def_opp_sb_win_wo_sd integer, cnt_steal_def_opp_sb_nosd integer, cnt_steal_success integer, cnt_steal_win_sd integer, cnt_steal_att_wtsd integer, cnt_steal_win_wo_sd integer, cnt_steal_att_no_sd integer, cnt_wtsd_won_when_f_bet_raise integer, cnt_wtsd_won_when_p_bet_raise integer, cnt_wtsd_won_when_r_bet_raise integer, cnt_wtsd_won_when_t_bet_raise integer, cnt_wtsd_won_when_f_call integer, cnt_wtsd_won_when_p_call integer, cnt_wtsd_won_when_r_call integer, cnt_wtsd_won_when_t_call integer, cnt_wtsd_when_f_bet_raise integer, cnt_wtsd_when_p_bet_raise integer, cnt_wtsd_when_r_bet_raise integer, cnt_wtsd_when_t_bet_raise integer, cnt_wtsd_when_f_call integer, cnt_wtsd_when_p_call integer, cnt_wtsd_when_r_call integer, cnt_wtsd_when_t_call integer, cnt_wwosd_f_bet_raise integer, cnt_wwosd_p_bet_raise integer, cnt_wwosd_r_bet_raise integer, cnt_wwosd_t_bet_raise integer, cnt_wwosd_f_call integer, cnt_wwosd_p_call integer, cnt_wwosd_r_call integer, cnt_wwosd_t_call integer, cnt_p_facing_limpers integer, cnt_p_raise_limpers integer, cnt_pfr_blinds integer, cnt_hands_blinds integer, cnt_pfr_ep integer, cnt_hands_ep integer, cnt_pfr_lp integer, cnt_hands_lp integer, cnt_pfr_mp integer, cnt_hands_mp integer, cnt_p_limp_raise_ep integer, cnt_p_limp_faceraise_ep integer, cnt_p_limp_raise_lp integer, cnt_p_limp_faceraise_lp integer, cnt_p_limp_raise_mp integer, cnt_p_limp_faceraise_mp integer, cnt_sb_steal_raise integer, cnt_bb_steal_raise integer, cnt_f_saw_blinds integer, cnt_f_saw_ep integer, cnt_f_saw_lp integer, cnt_f_saw_mp integer, cnt_vpip_blinds integer, cnt_vpip_ep integer, cnt_vpip_lp integer, cnt_vpip_mp integer, cnt_wtsd_won_blinds integer, cnt_wtsd_blinds integer, cnt_wtsd_won_ep integer, cnt_wtsd_ep integer, cnt_wtsd_won_lp integer, cnt_wtsd_lp integer, cnt_wtsd_won_mp integer, cnt_wtsd_mp integer, cnt_p_pfr_call_mp integer, cnt_p_pfr_call_opp_mp integer, cnt_f_donk integer, cnt_f_donk_opp integer, cnt_f_float integer, cnt_f_float_opp integer, cnt_p_3bet_f_cbet_def_action_fold integer, cnt_p_3bet_f_cbet_def_opp integer, cnt_steal_reraise_def_action_fold integer, cnt_steal_reraise_def_opp integer, cnt_f_donk_def_opp_action_fold integer, cnt_f_donk_def_opp integer, cnt_p_3bet_def_action_fold_when_open_raised_blinds integer, cnt_p_3bet_def_opp_when_open_raised_blinds integer, cnt_p_3bet_def_action_fold_when_open_raised_ep integer, cnt_p_3bet_def_opp_when_open_raised_ep integer, cnt_p_3bet_def_action_fold_when_open_raised_lp integer, cnt_p_3bet_def_opp_when_open_raised_lp integer, cnt_p_3bet_def_action_fold_when_open_raised_mp integer, cnt_p_3bet_def_opp_when_open_raised_mp integer, cnt_p_3bet_def_action_fold_when_open_raised integer, cnt_p_3bet_def_opp_when_open_raised integer, cnt_p_pfr_call_lp integer, cnt_p_pfr_call_opp_lp integer, cnt_p_3bet_blinds integer, cnt_p_3bet_opp_blinds integer, cnt_p_3bet_ep integer, cnt_p_3bet_opp_ep integer, cnt_p_3bet_lp integer, cnt_p_3bet_opp_lp integer, cnt_p_3bet_mp integer, cnt_p_3bet_opp_mp integer, cnt_p_4bet_blinds integer, cnt_p_4bet_opp_blinds integer, cnt_p_4bet_ep integer, cnt_p_4bet_opp_ep integer, cnt_p_4bet_lp integer, cnt_p_4bet_opp_lp integer, cnt_p_4bet_mp integer, cnt_p_4bet_opp_mp integer, cnt_p_pfr_call_blinds integer, cnt_p_pfr_call_opp_blinds integer, cnt_p_pfr_call_ep integer, cnt_p_pfr_call_opp_ep integer, cnt_p_limp_fold integer, cnt_p_face_raise_after_limp integer, cnt_p_3bet_def_action_fold_when_raised_first integer, cnt_p_3bet_def_action_fold_when_raised_first_blinds integer, cnt_p_3bet_def_action_fold_when_raised_first_ep integer, cnt_p_3bet_def_action_fold_when_raised_first_lp integer, cnt_p_3bet_def_action_fold_when_raised_first_mp integer, cnt_p_3bet_def_opp_when_raised_first integer, cnt_p_3bet_def_opp_when_raised_first_blinds integer, cnt_p_3bet_def_opp_when_raised_first_ep integer, cnt_p_3bet_def_opp_when_raised_first_p integer, cnt_p_3bet_def_opp_when_raised_first_mp integer, cnt_hands_ep_old integer, cnt_hands_mp_old integer, cnt_hands_lp_old integer, cnt_p_3bet_def_opp_when_raised_first_lp integer, cnt_p_open_opp_ep integer, cnt_p_open_opp_mp integer, cnt_p_open_opp_lp integer, cnt_p_raise_first_in_ep integer, cnt_p_raise_first_in_mp integer, cnt_p_raise_first_in_lp integer, cnt_p_raise_first_in_blinds integer, cnt_p_openlimp_call integer, cnt_p_face_raise_after_openlimp integer, cnt_p_openlimp_fold integer, cnt_p_openlimp integer, cnt_p_openlimp_raise integer, cnt_p_openlimp_ep integer, cnt_p_openlimp_mp integer, cnt_p_openlimp_lp integer, cnt_p_openlimp_fold_ep integer, cnt_p_openlimp_fold_mp integer, cnt_p_openlimp_fold_lp integer, cnt_p_limp_faceraise integer, cnt_p_openlimp_faceraise integer, cnt_p_openlimp_faceraise_ep integer, cnt_p_openlimp_faceraise_mp integer, cnt_p_openlimp_faceraise_lp integer, cnt_p_limp_raise integer, cnt_p_openlimp_faceraise_sb integer, cnt_p_openlimp_fold_sb integer, cnt_p_open_opp_sb integer, cnt_p_open_opp_notsb integer, cnt_p_openlimp_sb integer, cnt_p_3bet_nvs_bst integer, cnt_p_3bet_opp_nvs_bst integer, cnt_p_4bet_def_action_fold_after3bet_nvs_bst integer, cnt_p_4bet_def_opp_after3bet_nvs_bst integer, cnt_p_4bet_def_action_fold_after3bet_vs_bst integer, cnt_p_4bet_def_opp_after3bet_vs_bst integer, cnt_p_4bet_won integer, cnt_p_4bet_notwon integer, cnt_p_4bet_showdown integer, cnt_p_openlimp_raise_ep integer, cnt_p_openlimp_raise_mp integer, cnt_p_openlimp_raise_lp integer, cnt_p_openlimp_raise_sb integer, cnt_p_limp_call integer, cnt_p_ccall_won_hand integer, cnt_p_limp_call_ep integer, cnt_p_limp_call_lp integer, cnt_p_limp_call_mp integer, cnt_p_limp_call_sb integer, cnt_p_limp_faceraise_sb integer, cnt_p_limp_raise_sb integer, cnt_p_limp_call_f_cbet_def_opp integer, cnt_p_limp_call_f_cbet_def_action_fold integer, cnt_p_ccall_f_fold_face_cbet integer, cnt_p_ccall_f_face_cbet integer, cnt_p_ccall_f_cbet_def_opp integer, cnt_p_ccall_f_cbet_def_action_fold integer, cnt_p_pfr_call_opp_bl integer, cnt_p_pfr_call_bl integer, cnt_p_pfr_call_bl_f_cbet_def_action_fold integer, cnt_p_pfr_call_bl_f_cbet_def_opp integer, cnt_bb_steal_call integer, cnt_sb_steal_call integer, cnt_bb_steal_raise_fold integer, cnt_bb_steal_call_f_cbet_def_opp integer, cnt_bb_steal_call_f_cbet_def_action_fold integer, cnt_sb_steal_call_f_cbet_def_action_fold integer, cnt_sb_steal_call_f_cbet_def_opp integer, cnt_sb_steal_raise_fold integer, cnt_sb_steal_raise_4bet_def_opp integer, cnt_bb_steal_raise_4bet_def_opp integer, cnt_p_rfi_btn integer, cnt_p_open_opp_btn integer, cnt_p_rfi_co integer, cnt_p_open_opp_co integer, cnt_p_rfi_hj integer, cnt_p_open_opp_hj integer, cnt_p_rfi_mp2 integer, cnt_p_open_opp_mp2 integer, cnt_p_rfi_utgp1 integer, cnt_p_open_opp_utgp1 integer, cnt_p_rfi_utg integer, cnt_p_open_opp_utg integer, cnt_vpip_btn integer, cnt_btn integer, cnt_vpip_co integer, cnt_co integer, cnt_vpip_hj integer, cnt_hj integer, cnt_vpip_mp2 integer, cnt_mp2 integer, cnt_vpip_utgp1 integer, cnt_utgp1 integer, cnt_vpip_utg integer, cnt_utg integer, cnt_check_raise integer, cnt_check_raise_andlost integer, cnt_p_3bet_fold_ep integer, cnt_p_3bet_fold_mp integer, cnt_p_3bet_fold_lp integer, cnt_p_3bet_fold_blinds integer, cnt_vpip_rz integer, cnt_hands_rz integer, cnt_vpip_oz integer, cnt_hands_oz integer, cnt_vpip_yz integer, cnt_hands_yz integer, cnt_vpip_gz integer, cnt_hands_gz integer, cnt_vpip_bz integer, cnt_hands_bz integer, cnt_pfr_rz integer, cnt_pfr_oz integer, cnt_pfr_yz integer, cnt_pfr_gz integer, cnt_pfr_bz integer, cnt_p_limp_fold_rz integer, cnt_p_limp_faceraise_rz integer, cnt_p_limp_fold_oz integer, cnt_p_limp_faceraise_oz integer, cnt_p_limp_fold_yz integer, cnt_p_limp_faceraise_yz integer, cnt_p_limp_fold_gz integer, cnt_p_limp_faceraise_gz integer, cnt_p_limp_fold_bz integer, cnt_p_limp_faceraise_bz integer, cnt_steal_att_rz integer, cnt_steal_opp_rz integer, cnt_steal_att_oz integer, cnt_steal_opp_oz integer, cnt_steal_att_yz integer, cnt_steal_opp_yz integer, cnt_steal_att_gz integer, cnt_steal_opp_gz integer, cnt_steal_att_bz integer, cnt_steal_opp_bz integer, cnt_p_push_rz integer, cnt_p_push_oz integer, cnt_p_push_yz integer, cnt_p_push_gz integer, cnt_p_push_bz integer, cnt_p_call_shove_rz integer, cnt_p_call_shove_opp_rz integer, cnt_p_call_shove_oz integer, cnt_p_call_shove_opp_oz integer, cnt_p_call_shove_yz integer, cnt_p_call_shove_opp_yz integer, cnt_p_call_shove_gz integer, cnt_p_call_shove_opp_gz integer, cnt_p_call_shove_bz integer, cnt_p_call_shove_opp_bz integer, cnt_p_call_stack_rz integer, cnt_p_call_stack_opp_rz integer, cnt_p_call_stack_oz integer, cnt_p_call_stack_opp_oz integer, cnt_p_call_stack_yz integer, cnt_p_call_stack_opp_yz integer, cnt_p_call_stack_gz integer, cnt_p_call_stack_opp_gz integer, cnt_p_call_stack_bz integer, cnt_p_call_stack_opp_bz integer, cnt_f_bigpot_fold_rz integer, cnt_f_bigpot_rz integer, cnt_f_bigpot_fold_oz integer, cnt_f_bigpot_oz integer, cnt_f_bigpot_fold_yz integer, cnt_f_bigpot_yz integer, cnt_f_bigpot_fold_gz integer, cnt_f_bigpot_gz integer, cnt_f_bigpot_fold_bz integer, cnt_f_bigpot_bz integer, cnt_wtsd_rz integer, cnt_f_saw_rz integer, cnt_wtsd_oz integer, cnt_f_saw_oz integer, cnt_wtsd_yz integer, cnt_f_saw_yz integer, cnt_wtsd_gz integer, cnt_f_saw_gz integer, cnt_wtsd_bz integer, cnt_f_saw_bz integer, cnt_wtsd_won_rz integer, cnt_wtsd_won_oz integer, cnt_wtsd_won_yz integer, cnt_wtsd_won_gz integer, cnt_wtsd_won_bz integer, cnt_f_float_def_opp_action_fold integer, cnt_f_float_def_opp integer, amt_total_avg_f_bet numeric(11,2), amt_total_avg_t_bet numeric(11,2), amt_total_avg_r_bet numeric(11,2), cnt_p_3bet_def_action_fold_when_open_raised integer);; Reason: Fatal Error (ERROR: column "cnt_p_3bet_def_action_fold_when_open_raised" specified more than once )

[preparac]

please can you edit/delete my previous message:
must have to do with a double definition of a column after import...: Fatal Error (ERROR: column "cnt_p_3bet_def_action_fold_when_open_raised" specified more than once )[/quote]

[Olaf72]

Hmm... i can't find the download-link.
Could someone help me?

[sookmctourie]

The download link has been removed until the issues are fixed

[sookmctourie]

After removing the duplicate column "cnt_p_3bet_def_action_fold_when_open_raised", I ran full housekeeping overnight and received no further errors. Prior to this, PT3 was telling me that I did not have a populated cash. After removing the duplicate column last night, I was able to get the new Hud up and running. Now that I have ran housekeeping, I'm no longer getting a unpopulated cache error message

Edit: The only difference between the 2 copies of the file was found in the description
1.Number of times player folded to a 3 bet when having open raised
2Number of times player folded to a 3 bet when having open raised and not made a steal attempt.
The name and expression were identical

[kraada]

I'm not sure what other side effects would be caused by the tourney_tourney_ errors . . . and I truly wish I had a timeline for this fix. I've asked the development team to see if I can get a clearer timeline on when this issue would be fixed. I will exert what pressure I can to get it fixed faster, unfortunately I can only do so much.

[sookmctourie]

Its too bad that you ran into this unforeseen issue. Its a great piece of work. In the process of having to make the necessary changes to get it up an running, it became very apparent how much thought and detail went into this project. Now that I have it up and running, its great to have PT3 more tailored to tournaments through this HUD. You've done a great job here Kraada, and thanks again.

Art

[preparac]

sookmctourie, you do not have this issue: limp/Fold stats allways give me the value 0 ?
Besides of this everything now everything works ok for me and thanks to Kraada also from my part!