AHK HUD - Enjoy

[SoreNuts]

I am not getting mucked cards showing in the last two versions of AHK Hud. I searched the 93 pages of this topic to find a reason/answer with no luck. Can anyone direct me as to where I am going wrong?

Not a problem that has been mentioned i don't think - certainly not one I've experienced.

One thing to try is to rename your layout.ini file, so everything resets to default positions - see if they've somehow saved their positions off-screen? Also check the image files are all present and correct in the "cards" subfolder.

I have no layout.ini file at all. Should I create an empty one with notepad? The cards are in the card folder.

[_dave_]

sorry, my mistake - pt3_ahk_hud.ini it should be. The script will create it when you move a panel.

[omaha]

Hi all, ahk is working well for me. I can multitable on party with it going ok. CPU hits 100%, but is still usable. If i use pt3 hud with the same number of tables, it hits 100% and is unusable. Thus, i think i will be using this in the long term

Two quick questions

i) how do i Add more stats? I would like to add (on the next line) I would like 3bet, fold to 3 bet, cbet and fold to cbet. How do I arrange this?

ii) how is the tweak going to speed things up? A while back, dave mentioned that things could be sped up by only querying the db when the lineup changes. Any news on this? This would be absolutely awesome

[MaxWeiss]

any updates on teh update???

[omaha]

edited

[MaxWeiss]

As far as only querying when the lineup changes, I'm sure Dave will post that sometime here, although for me, there's enough new players that having updated stats that show stats for 60 hands instead of 10 is important enough for me. I just can't wait for the update that lets more than 100 windows open because I have like 30 stats I want for each table, and I play 4-6 tables usually.

As for adding your own stats, you just have to add them into the stats section, as well as a range of colors if you want (and a size -- number of digits), using the same format the other stats are in, and then put them in the stat list at the bottom of the script where you tell it what stats to use. I made some stats using the general format Dave used, including the divider slash in the middle. Feel free to use any and all of these and alter the color ranges, which are just my personal settings. The top ones are the 3bet and cbet stats you wanted which were included in the version I downloaded...

Code: Select all

3bet_pre := "SUM(case when (hhps.flg_p_3bet) then 1 else 0 end) || '/' || SUM(case when (hhps.flg_p_3bet_opp) then 1 else 0 end)"
3bet_pre_range := "2.15=33ddee,4=ff88ee,7=00ff00,9.2=ffaa55,100=ff0000"
3bet_pre_size := 4

fold_3bet_to_4bet := "SUM(case when (hhps.enum_p_4bet_action = 'F') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_p_4bet_def_opp) AND (hhps.flg_p_3bet) then 1 else 0 end)"
fold_3bet_to_4bet_range := "15=ff0000,30=ff9600,80=00ff00"
fold_3bet_to_4bet_size := 2

fold_when_open_is_3bet := "SUM(case when (hhps.flg_p_first_raise) AND (hhps.enum_p_3bet_action = 'F') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_p_first_raise) AND (hhps.flg_p_3bet_def_opp) then 1 else 0 end)"
fold_when_open_is_3bet_range := "45=ff0000,58=ffaa55,72=00ff00,82=ff88ee,100=33ddee"
fold_when_open_is_3bet_size := 4

call_when_open_is_3bet := "SUM(case when (hhps.flg_p_first_raise) AND (hhps.enum_p_3bet_action = 'C') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_p_first_raise) AND (hhps.flg_p_3bet_def_opp) then 1 else 0 end)"
call_when_open_is_3bet_range := "30=00ff00,60=ff0000"
call_when_open_is_3bet_size := 2

raise_when_open_is_3bet := "SUM(case when (hhps.flg_p_first_raise) AND (hhps.enum_p_3bet_action = 'R') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_p_first_raise) AND (hhps.flg_p_3bet_def_opp) then 1 else 0 end)"
raise_when_open_is_3bet_range := "30=00ff00,60=ff0000"
raise_when_open_is_3bet_size := 2

fold_to_flop_cbet := "SUM(case when (hhps.enum_f_cbet_action = 'F') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_f_cbet_def_opp) then 1 else 0 end)"
fold_to_flop_cbet_range := "36=ff0000,48=ffaa55,77=00ff00,84=ff88ee,100=33ddee"
call_to_flop_cbet := "SUM(case when (hhps.enum_f_cbet_action = 'C') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_f_cbet_def_opp) then 1 else 0 end)"
call_to_flop_cbet_range := "30=ff0000,50=ff9600,60=ffff00,80=ff0000"
raise_to_flop_cbet := "SUM(case when (hhps.enum_f_cbet_action = 'R') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_f_cbet_def_opp) then 1 else 0 end)"
raise_to_flop_cbet_range := "30=ff0000,50=ff9600,60=ffff00,80=ff0000"

fold_to_turn_cbet := "SUM(case when (hhps.enum_t_cbet_action = 'F') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_t_cbet_def_opp) then 1 else 0 end)"
fold_to_turn_cbet_range := "30=ff0000,50=ff9600,60=ffff00,80=ff0000"
call_to_turn_cbet := "SUM(case when (hhps.enum_t_cbet_action = 'C') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_t_cbet_def_opp) then 1 else 0 end)"
call_to_turn_cbet_range := "30=ff0000,50=ff9600,60=ffff00,80=ff0000"
raise_to_turn_cbet := "SUM(case when (hhps.enum_t_cbet_action = 'R') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_t_cbet_def_opp) then 1 else 0 end)"
raise_to_turn_cbet_range := "30=ff0000,50=ff9600,60=ffff00,80=ff0000"


fold_to_river_cbet := "SUM(case when (hhps.enum_r_cbet_action = 'F') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_r_cbet_def_opp) then 1 else 0 end)"
fold_to_river_cbet_range := "30=ff0000,50=ff9600,60=ffff00,80=ff0000"
call_to_river_cbet := "SUM(case when (hhps.enum_r_cbet_action = 'C') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_r_cbet_def_opp) then 1 else 0 end)"
call_to_river_cbet_range := "30=ff0000,50=ff9600,60=ffff00,80=ff0000"
raise_to_river_cbet := "SUM(case when (hhps.enum_r_cbet_action = 'R') then 1 else 0 end) || '/' || SUM(case when (hhps.flg_r_cbet_def_opp) then 1 else 0 end)"
raise_to_river_cbet_range := "30=ff0000,50=ff9600,60=ffff00,80=ff0000"

; cbet stats
cbets_flop := "SUM(case when (hhps.flg_f_cbet) then 1 else 0 end) || '/' || SUM(case when (hhps.flg_f_cbet_opp) then 1 else 0 end)"
cbets_flop_range := "43=33ddee,55=ff88ee,72.5=00ff00,83=ffaa55,100=ff0000"
cbets_turn := "SUM(case when (hhps.flg_t_cbet) then 1 else 0 end) || '/' || SUM(case when (hhps.flg_t_cbet_opp) then 1 else 0 end)"
cbets_turn_range := cbets_flop_range
cbets_river := "SUM(case when (hhps.flg_r_cbet) then 1 else 0 end) || '/' || SUM(case when (hhps.flg_r_cbet_opp) then 1 else 0 end)"
cbets_river_range := cbets_flop_range

;;;;;;;;;;Below are stats I made myself that were not included in Dave's script;;;;;;;;;;;;;

flop_aggression_frequency := "SUM(CASE WHEN hhps.flg_f_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_f_raise) || '/' || SUM(hhps.cnt_f_call) + SUM(CASE WHEN hhps.flg_f_fold THEN 1 ELSE 0 END) + SUM(CASE WHEN hhps.flg_f_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_f_raise)"
flop_aggression_frequency_range := "29=33ddee,42=ff88ee,63=00ff00,74=ffaa55,100=ff0000"

turn_aggression_frequency := "SUM(CASE WHEN hhps.flg_t_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_t_raise) || '/' || SUM(hhps.cnt_t_call) + SUM(CASE WHEN hhps.flg_t_fold THEN 1 ELSE 0 END) + SUM(CASE WHEN hhps.flg_t_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_t_raise)"
turn_aggression_frequency_range := "28.5=33ddee,37=ff88ee,56=00ff00,68.5=ffaa55,100=ff0000"

river_aggression_frequency := "SUM(CASE WHEN hhps.flg_r_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_r_raise) || '/' || SUM(hhps.cnt_r_call) + SUM(CASE WHEN hhps.flg_r_fold THEN 1 ELSE 0 END) + SUM(CASE WHEN hhps.flg_r_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_r_raise)"
river_aggression_frequency_range := "22=33ddee,35=ff88ee,55=00ff00,66=ffaa55,100=ff0000"

total_aggression_frequency := "SUM(CASE WHEN hhps.flg_f_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_f_raise) + SUM(CASE WHEN hhps.flg_t_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_t_raise) + SUM(CASE WHEN hhps.flg_r_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_r_raise) || '/' || SUM(hhps.cnt_f_call) + SUM(CASE WHEN hhps.flg_f_fold THEN 1 ELSE 0 END) + SUM(CASE WHEN hhps.flg_f_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_f_raise) + SUM(hhps.cnt_t_call) + SUM(CASE WHEN hhps.flg_t_fold THEN 1 ELSE 0 END) + SUM(CASE WHEN hhps.flg_t_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_t_raise) + SUM(hhps.cnt_r_call) + SUM(CASE WHEN hhps.flg_r_fold THEN 1 ELSE 0 END) + SUM(CASE WHEN hhps.flg_r_bet THEN 1 ELSE 0 END) + SUM(hhps.cnt_r_raise)"
total_aggression_frequency_range := "30=33ddee,41=ff88ee,55=00ff00,68.5=ffaa55,100=ff0000"

cold_call_preflop := "SUM(CASE WHEN (hhps.cnt_p_call > 1 OR hhps.flg_p_ccall) AND hhps.flg_p_face_raise THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_p_face_raise THEN 1 ELSE 0 END)"
cold_call_preflop_range := "0.5=33ddee,2=ff88ee,3.5=00ff00,5.5=ffaa55,100=ff0000"

went_to_showdown := "SUM(CASE WHEN hhps.flg_showdown AND hhps.flg_vpip THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN flg_vpip THEN 1 ELSE 0 END)"
went_to_showdown_range := "10.8=33ddee,14.5=ff88ee,19.2=00ff00,24=ffaa55,100=ff0000"

won_at_showdown := "SUM(CASE WHEN hhps.flg_showdown AND hhps.flg_won_hand THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_showdown THEN 1 ELSE 0 END)"
won_at_showdown_range := "35=ff0000,46=ffaa55,60=00ff00,67.5=ff88ee,100=33ddee"

win_percentage := "SUM(CASE WHEN hhps.flg_won_hand THEN 1 ELSE 0 END) || '/' || COUNT(hhps.id_player)"
win_percentage_range := "8.25=ff0000,11=ffaa55,18=00ff00,23=ff88ee,100=33ddee"

won_when_saw_flop := "SUM(CASE WHEN hhps.flg_won_hand AND hhps.flg_f_saw THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_f_saw THEN 1 ELSE 0 END)"
won_when_saw_flop_range := "29=ff0000,35=ffaa55,45=00ff00,50=ff88ee,100=33ddee"

attempt_to_steal := "SUM(CASE WHEN hhps.flg_steal_att THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_steal_opp THEN 1 ELSE 0 END)"
attempt_to_steal_range := "17=33ddee,25=ff88ee,38=00ff00,44=ffaa55,100=ff0000"

fold_bb_to_steal := "SUM(CASE WHEN hhps.flg_bb_steal_fold THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_blind_def_opp AND hhps.flg_blind_b THEN 1 ELSE 0 END)"
fold_bb_to_steal_range := "62=ff0000,79=ffaa55,88.5=00ff00,92=ff88ee,100=33ddee"

raise_steal_attempt := "SUM(CASE WHEN hhps.flg_blind_def_opp AND hhps.flg_blind_b AND hhps.cnt_p_raise > 0 THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_blind_def_opp AND hhps.flg_blind_b THEN 1 ELSE 0 END)"
raise_steal_attempt_range := "3=33ddee,3.5=ff88ee,8=00ff00,18=ffaa55,100=ff0000"

fold_steal_to_blind_reraise := "SUM(CASE WHEN hhps.flg_steal_att AND hhps.flg_p_3bet_def_opp AND hhps.enum_p_3bet_action = 'f' THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_steal_att AND hhps.flg_p_3bet_def_opp THEN 1 ELSE 0 END)"
fold_steal_to_blind_reraise_range := "31.5=ff0000,40=ffaa55,70=00ff00,81.75=ff88ee,100=33ddee"

bet_flop := "SUM(CASE WHEN hhps.flg_f_bet THEN 1 ELSE 0 END) || '/' || (SUM(CASE WHEN hhps.flg_f_bet THEN 1 ELSE 0 END) + SUM(CASE WHEN hhps.flg_f_check THEN 1 ELSE 0 END))"
;bet_flop_range := ""

bet_turn := "SUM(CASE WHEN hhps.flg_t_bet THEN 1 ELSE 0 END) || '/' || (SUM(CASE WHEN hhps.flg_t_bet THEN 1 ELSE 0 END) + SUM(CASE WHEN hhps.flg_t_check THEN 1 ELSE 0 END))"
;bet_turn_range := ""

bet_river := "SUM(CASE WHEN hhps.flg_r_bet THEN 1 ELSE 0 END) || '/' || (SUM(CASE WHEN hhps.flg_r_bet THEN 1 ELSE 0 END) + SUM(CASE WHEN hhps.flg_r_check THEN 1 ELSE 0 END))"
bet_river_range := "18.5=33ddee,29=ff88ee,41=00ff00,55=ffaa55,100=ff0000"

raise_flop := "SUM(CASE WHEN hhps.flg_f_face_raise=false AND hhps.flg_f_bet=false AND hhps.cnt_f_raise > 0 THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_f_face_raise=false AND hhps.flg_f_bet=false THEN 1 ELSE 0 END)"
raise_flop_range := "7.25=33ddee,11=ff88ee,18=00ff00,28.5=ffaa55,100=ff0000"

raise_turn := "SUM(CASE WHEN hhps.flg_t_face_raise=false AND hhps.flg_t_bet=false AND hhps.cnt_t_raise > 0 THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_t_face_raise=false AND hhps.flg_t_bet=false THEN 1 ELSE 0 END)"
raise_turn_range := "3.5=33ddee,5=ff88ee,17=00ff00,28=ffaa55,100=ff0000"

raise_river := "SUM(CASE WHEN hhps.flg_r_face_raise=false AND hhps.flg_r_bet=false AND hhps.cnt_r_raise > 0 THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_r_face_raise=false AND hhps.flg_r_bet=false THEN 1 ELSE 0 END)"
raise_river_range := "3=33ddee,6=ff88ee,12=00ff00,26=ffaa55,100=ff0000"

/*
;;;;;;; These don't work unless you alter the SQL query to include "AND holdem_hand_player_detail hhpd" after the "holdem_hand_player_statistics hhps";;;;;
fold_to_flop_bet := "SUM(CASE WHEN hhpd.amt_f_bet_facing > 0 AND hhps.flg_f_fold THEN 1 ELSE o END) || '/' || SUM(CASE WHEN hhpd.amt_f_bet_facing > 0 THEN 1 ELSE o END)"
fold_to_flop_bet_range := "42.5=ff0000,58=ffaa55,82.5=00ff00,88.5=ff88ee,100=33ddee"
fold_to_turn_bet := "SUM(CASE WHEN hhpd.amt_t_bet_facing > 0 AND hhps.flg_t_fold THEN 1 ELSE o END) || '/' || SUM(CASE WHEN hhpd.amt_t_bet_facing > 0 THEN 1 ELSE o END)"
fold_to_turn_bet_range := "37.3=ff0000,50=ffaa55,70=00ff00,84=ff88ee,100=33ddee"
fold_to_river_bet := "SUM(CASE WHEN hhpd.amt_r_bet_facing > 0 AND hhps.flg_r_fold THEN 1 ELSE o END) || '/' || SUM(CASE WHEN hhpd.amt_r_bet_facing > 0 THEN 1 ELSE o END)"
fold_to_river_bet_range := "37.5=ff0000,55=ffaa55,71.5=00ff00,82=ff88ee,100=33ddee"
*/

fold_to_flop_raise := "SUM(CASE WHEN hhps.flg_f_face_raise AND hhps.flg_f_fold THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_f_face_raise THEN 1 ELSE 0 END)"
fold_to_flop_raise_range := "35.15=ff0000,46=ffaa55,64=00ff00,78=ff88ee,100=33ddee"

fold_to_turn_raise := "SUM(CASE WHEN hhps.flg_t_face_raise AND hhps.flg_t_fold THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_t_face_raise THEN 1 ELSE 0 END)"
fold_to_turn_raise_range := "31=ff0000,38=ffaa55,55=00ff00,75=ff88ee,100=33ddee"

fold_to_river_raise := "SUM(CASE WHEN hhps.flg_r_face_raise AND hhps.flg_r_fold THEN 1 ELSE 0 END) || '/' || SUM(CASE WHEN hhps.flg_r_face_raise THEN 1 ELSE 0 END)"
fold_to_river_raise_range := "30=ff0000,40=ffaa55,80=00ff00,88=ff88ee,100=33ddee"


[_dave_]

Aggression frequency, fantastic!

I've been meaning to do that for ages, but it is quite the extensive sql statement - so I've been living with Agg. factor for ages

[MaXXXstAkd]

Full Tilt: Unable to import hand (#7504419909). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: index "hhps:idx1-id_hand" contains unexpected zero page at block 0 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_player_statistics, line 1: "173281 2353 2353 0 6 9679 2008/08/04 05:25:16 4 f t 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f f f ..." )



THIS IS THE ERROR MESSAGE I AM RECIECING ...IT STILL STORES THE STATS BUT THE PROBLEM LIES IN THE HUD..WILL NOT DISPLAY STATS ON TABLE♦

[_dave_]

Full Tilt: Unable to import hand (#7504419909). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: index "hhps:idx1-id_hand" contains unexpected zero page at block 0 HINT: Please REINDEX it. CONTEXT: COPY holdem_hand_player_statistics, line 1: "173281 2353 2353 0 6 9679 2008/08/04 05:25:16 4 f t 0 f 0 f t f f f 0 f 0 f f f f f 0 f 0 f f f f f ..." )



THIS IS THE ERROR MESSAGE I AM RECIECING ...IT STILL STORES THE STATS BUT THE PROBLEM LIES IN THE HUD..WILL NOT DISPLAY STATS ON TABLE♦

wrong thread for that - either do what it says "REINDEX hhps:idx1-id_hand", or post in the postgresql section.

[MarsMPK]

Hello All,

I have some problem to read in english, can somebody make a translate in french for intall AHK in FTP.

Thanks a lot