filter-bug: flop nr. of player filter broken

[js2002]

Players Seeing Flop Between 2 and 10

filters out all hands

and note tracker result are also zero.

[kraada]

This filter appears to be working properly for me - could you attach a log file to a ticket showing this problem and post the ticket number here for me?

[js2002]

a buddy also beta tester has the same problem.

[js2002]

send u the log per mail

and here the cut part

Code: Select all

2011/12/23 23:20:36.130 [00000]: [- Main -][ptFilterGroup] Resulting in: Players Seeing Flop Between 2 and 8
2011/12/23 23:20:38.002 [01873]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2011/12/23 23:20:38.017 [00009]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2011/12/23 23:20:38.017 [00003]: [00000BCC][Query::QueryThread] Thread [0x00000BCC]: Begin
2011/12/23 23:20:38.017 [00000]: [00000BCC][Query] Connecting to database: PT4_2011_12_16
2011/12/23 23:20:38.017 [00000]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2011/12/23 23:20:38.017 [00000]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2011/12/23 23:20:38.017 [00002]: [00000BCC][Query] Executing SQL (Thread): SELECT (player.player_name) as "str_player_name", (sum((case when(cash_hand_player_statistics.val_curr_conv != 0) then  cash_hand_player_statistics.val_curr_conv * cash_hand_player_statistics.amt_won else  (CASE WHEN cash_limit.limit_currency='EUR' THEN (cash_hand_player_statistics.amt_won * 1.3047) ELSE (CASE WHEN cash_limit.limit_currency='GBP' THEN (cash_hand_player_statistics.amt_won * 1.5672) ELSE (CASE WHEN cash_limit.limit_currency='SEK' THEN (cash_hand_player_statistics.amt_won * 0.1450) ELSE (CASE WHEN cash_limit.limit_currency='TRY' THEN (cash_hand_player_statistics.amt_won * 0.5293) ELSE (CASE WHEN cash_limit.limit_currency='PLY' THEN (cash_hand_player_statistics.amt_won * 0.0000) ELSE cash_hand_player_statistics.amt_won END) END) END) END) END) end))) as "amt_won_curr_conv", (sum((case when(cash_hand_player_statistics.id_hand > 0) then  1 else  0 end))) as "cnt_hands", (sum((case when(cash_hand_player_statistics.flg_won_hand) then  1 else  0 end))) as "cnt_hands_won", (count( distinct cash_hand_player_statistics.id_session)) as "cnt_sessions", (sum( (SELECT (case when( chps_s.amt_won > 0) then  1 else  0 end) FROM cash_table_session_summary chps_s WHERE chps_s.id_session = cash_hand_player_statistics.id_session AND chps_s.date_start=cash_hand_player_statistics.date_played) )) as "cnt_sessions_won", (sum( (CASE WHEN ( cash_limit.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_won * 1.0 )/( cash_limit.amt_bb)) ELSE 0 END) )) as "amt_bb_won", (sum((case when(cash_hand_player_statistics.flg_won_hand AND cash_hand_player_statistics.flg_f_saw) then  1 else  0 end))) as "cnt_f_saw_won", (sum((case when(cash_hand_player_statistics.flg_f_saw) then  1 else  0 end))) as "cnt_f_saw", (sum( (case when(cash_hand_player_statistics.enum_allin='P' OR ((cash_hand_player_statistics.enum_face_allin='P' OR cash_hand_player_statistics.enum_face_allin='p') AND cash_hand_player_statistics.enum_face_allin_action<>'N' AND cash_hand_player_statistics.enum_face_allin_action<>'F')) then  cash_hand_player_statistics.val_equity else  0 end) )) as "val_p_equity", (sum( (case when(cash_hand_player_statistics.enum_allin='F' OR ((cash_hand_player_statistics.enum_face_allin='F' OR cash_hand_player_statistics.enum_face_allin='f') AND cash_hand_player_statistics.enum_face_allin_action<>'N' AND cash_hand_player_statistics.enum_face_allin_action<>'F')) then  cash_hand_player_statistics.val_equity else  0 end) )) as "val_f_equity", (sum( (case when(cash_hand_player_statistics.enum_allin='T' OR ((cash_hand_player_statistics.enum_face_allin='T' OR cash_hand_player_statistics.enum_face_allin='t') AND cash_hand_player_statistics.enum_face_allin_action<>'N' AND cash_hand_player_statistics.enum_face_allin_action<>'F')) then  cash_hand_player_statistics.val_equity else  0 end) )) as "val_t_equity", (sum( (case when(cash_hand_player_statistics.enum_allin='P' OR ((cash_hand_player_statistics.enum_face_allin='P' OR cash_hand_player_statistics.enum_face_allin='p') AND cash_hand_player_statistics.enum_face_allin_action<>'N' AND cash_hand_player_statistics.enum_face_allin_action<>'F')) then  1 else  0 end) )) as "cnt_p_allin", (sum( (case when(cash_hand_player_statistics.enum_allin='F' OR ((cash_hand_player_statistics.enum_face_allin='F' OR cash_hand_player_statistics.enum_face_allin='f') AND cash_hand_player_statistics.enum_face_allin_action<>'N' AND cash_hand_player_statistics.enum_face_allin_action<>'F')) then  1 else  0 end) )) as "cnt_f_allin", (sum( (case when(cash_hand_player_statistics.enum_allin='T' OR ((cash_hand_player_statistics.enum_face_allin='T' OR cash_hand_player_statistics.enum_face_allin='t') AND cash_hand_player_statistics.enum_face_allin_action<>'N' AND cash_hand_player_statistics.enum_face_allin_action<>'F')) then  1 else  0 end) )) as "cnt_t_allin" FROM        cash_hand_summary, cash_hand_player_statistics , cash_limit, player WHERE  (cash_limit.id_limit = cash_hand_player_statistics.id_limit)  AND (player.id_player = cash_hand_player_statistics.id_player)   AND (cash_hand_player_statistics.id_player = (SELECT id_player FROM player WHERE player_name_search='js2002'  AND id_site='100'))   AND (cash_hand_summary.id_hand = cash_hand_player_statistics.id_hand)        AND (((((((cash_hand_summary.cnt_players_f BETWEEN 2 and 8)))))))  GROUP BY (player.player_name)


[WhiteRider]

I see the same - thanks. I have reported this to the person in charge.