by MMark516 » Thu Jan 31, 2008 8:39 pm
[quote="_dave_"99y][quote="MMark516"99y]ok...so i havev found if i drag the boxes around it will show the players names...however the boxes appear in nowhere near the correct location....also stats arnt showing....any ideas[/quote99y]
Turn off full tilt auto-center. Then they'll be near the seats - drag them about to taste.
You probably need to add the "trust" lone in pg_hba.conf, or set database name correctly (or both). are you getting error logs? look in them see what it complains about.[/quote99y]
this is the most recent error thing
20080130212753 - An Error Occured:
Input:
\f '\t'
BEGIN ISOLATION LEVEL SERIALIZABLE;SELECT player_name, count (hhps.id_player),SUM(case when (hhps.flg_vpip) then 1 else 0 end) || '/' || count (hhps.id_player),SUM(case when (hhps.cnt_p_raise > 0) then 1 else 0 end) || '/' || count (hhps.id_player),SUM (hhps.amt_won),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),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),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),SUM(hhps.cnt_f_raise) + SUM(case when (hhps.flg_f_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_f_call),SUM(hhps.cnt_t_raise) + SUM(case when (hhps.flg_t_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_t_call),SUM(hhps.cnt_r_raise) + SUM(case when (hhps.flg_r_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_r_call),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),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),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),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) FROM holdem_hand_player_statistics hhps, player p WHERE hhps.id_player = p.id_player AND p.player_name = 'Mike Litt' GROUP BY player_name;
SELECT player_name, count (hhps.id_player),SUM(case when (hhps.flg_vpip) then 1 else 0 end) || '/' || count (hhps.id_player),SUM(case when (hhps.cnt_p_raise > 0) then 1 else 0 end) || '/' || count (hhps.id_player),SUM (hhps.amt_won),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),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),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),SUM(hhps.cnt_f_raise) + SUM(case when (hhps.flg_f_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_f_call),SUM(hhps.cnt_t_raise) + SUM(case when (hhps.flg_t_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_t_call),SUM(hhps.cnt_r_raise) + SUM(case when (hhps.flg_r_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_r_call),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),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),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),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) FROM holdem_hand_player_statistics hhps, player p WHERE hhps.id_player = p.id_player AND p.player_name = 'HooksASate' GROUP BY player_name;
SELECT player_name, count (hhps.id_player),SUM(case when (hhps.flg_vpip) then 1 else 0 end) || '/' || count (hhps.id_player),SUM(case when (hhps.cnt_p_raise > 0) then 1 else 0 end) || '/' || count (hhps.id_player),SUM (hhps.amt_won),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),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),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),SUM(hhps.cnt_f_raise) + SUM(case when (hhps.flg_f_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_f_call),SUM(hhps.cnt_t_raise) + SUM(case when (hhps.flg_t_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_t_call),SUM(hhps.cnt_r_raise) + SUM(case when (hhps.flg_r_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_r_call),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),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),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),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) FROM holdem_hand_player_statistics hhps, player p WHERE hhps.id_player = p.id_player AND p.player_name = 'HighLife06' GROUP BY player_name;
SELECT player_name, count (hhps.id_player),SUM(case when (hhps.flg_vpip) then 1 else 0 end) || '/' || count (hhps.id_player),SUM(case when (hhps.cnt_p_raise > 0) then 1 else 0 end) || '/' || count (hhps.id_player),SUM (hhps.amt_won),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),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),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),SUM(hhps.cnt_f_raise) + SUM(case when (hhps.flg_f_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_f_call),SUM(hhps.cnt_t_raise) + SUM(case when (hhps.flg_t_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_t_call),SUM(hhps.cnt_r_raise) + SUM(case when (hhps.flg_r_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_r_call),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),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),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),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) FROM holdem_hand_player_statistics hhps, player p WHERE hhps.id_player = p.id_player AND p.player_name = 'gulliver' GROUP BY player_name;
SELECT player_name, count (hhps.id_player),SUM(case when (hhps.flg_vpip) then 1 else 0 end) || '/' || count (hhps.id_player),SUM(case when (hhps.cnt_p_raise > 0) then 1 else 0 end) || '/' || count (hhps.id_player),SUM (hhps.amt_won),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),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),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),SUM(hhps.cnt_f_raise) + SUM(case when (hhps.flg_f_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_f_call),SUM(hhps.cnt_t_raise) + SUM(case when (hhps.flg_t_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_t_call),SUM(hhps.cnt_r_raise) + SUM(case when (hhps.flg_r_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_r_call),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),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),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),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) FROM holdem_hand_player_statistics hhps, player p WHERE hhps.id_player = p.id_player AND p.player_name = 'JBDALTON' GROUP BY player_name;
SELECT player_name, count (hhps.id_player),SUM(case when (hhps.flg_vpip) then 1 else 0 end) || '/' || count (hhps.id_player),SUM(case when (hhps.cnt_p_raise > 0) then 1 else 0 end) || '/' || count (hhps.id_player),SUM (hhps.amt_won),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),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),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),SUM(hhps.cnt_f_raise) + SUM(case when (hhps.flg_f_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_f_call),SUM(hhps.cnt_t_raise) + SUM(case when (hhps.flg_t_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_t_call),SUM(hhps.cnt_r_raise) + SUM(case when (hhps.flg_r_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_r_call),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),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),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),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) FROM holdem_hand_player_statistics hhps, player p WHERE hhps.id_player = p.id_player AND p.player_name = 'Gavljari85' GROUP BY player_name;
SELECT player_name, count (hhps.id_player),SUM(case when (hhps.flg_vpip) then 1 else 0 end) || '/' || count (hhps.id_player),SUM(case when (hhps.cnt_p_raise > 0) then 1 else 0 end) || '/' || count (hhps.id_player),SUM (hhps.amt_won),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),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),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),SUM(hhps.cnt_f_raise) + SUM(case when (hhps.flg_f_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_f_call),SUM(hhps.cnt_t_raise) + SUM(case when (hhps.flg_t_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_t_call),SUM(hhps.cnt_r_raise) + SUM(case when (hhps.flg_r_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_r_call),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),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),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),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) FROM holdem_hand_player_statistics hhps, player p WHERE hhps.id_player = p.id_player AND p.player_name = 'risonson' GROUP BY player_name;
SELECT player_name, count (hhps.id_player),SUM(case when (hhps.flg_vpip) then 1 else 0 end) || '/' || count (hhps.id_player),SUM(case when (hhps.cnt_p_raise > 0) then 1 else 0 end) || '/' || count (hhps.id_player),SUM (hhps.amt_won),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),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),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),SUM(hhps.cnt_f_raise) + SUM(case when (hhps.flg_f_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_f_call),SUM(hhps.cnt_t_raise) + SUM(case when (hhps.flg_t_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_t_call),SUM(hhps.cnt_r_raise) + SUM(case when (hhps.flg_r_bet) THEN 1 ELSE 0 END) || '/' || SUM(hhps.cnt_r_call),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),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),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),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) FROM holdem_hand_player_statistics hhps, player p WHERE hhps.id_player = p.id_player AND p.player_name = 'OhoyMstrchief' GROUP BY player_name;
COMMIT;
\q
that repeats, im assumeing or each player...i did change the file to say trust