PokerTracker 3
05-20-2008
, 09:20 PM
05-20-2008
, 10:19 PM
05-21-2008
, 01:19 PM
Quote:
Then perhaps the misinterpretation I'm having is in the lookup_positions table. It won't register a flagged position if the position > cnt_players. Perhaps the lookup_position table isn't intended to be linked to the hhps or hhs tables? Let me know your thoughts.
Much appreciated.
Much appreciated.
Quote:
Sorry for my vague description of the problem...
Every statistic I create shows 0's. I've even tried debugging to see if something as simple as "count: player is in SB AND player flat calls" will output anything on the screen (of course the syntax is correct as it validates correctly), and I get 0's still. I even imported someone's random stat (I believe it's call turn cbet in 3bet pot) and I get the same. I would imagine if you mess with columns that it takes a while to populate and that it's obviously not retroactive, since that column didn't exist... but I've let it work for several hours and every stat I have shows 0's. I'm 90% my formatting of the output is correct.
Here are some of the stats/columns I created... please keep in mind that I play HU exclusively. Is it technically a limp in HU if they just complete the SB?
COLUMNS:
cnt_p_limp_call_opp
Description: Number of times player has opportunity to limp call
Expression:
sum(if[holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise, 1, 0])
cnt_p_limp_call
Description: Number of times player limps and calls a raise
Expression:
sum(if[holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_f_saw, 1, 0])
Statistic:
LC%
Description: Percentage of the time a player elects to limp call
Value Expression:
(cnt_p_limp_call / cnt_p_limp_call_opp) * 100
Format:
Title: LC%
Format Expression: /%.2f
I've looked that code over a hojillion times and it seems to be fine unless I'm mistaken about some of the "axioms" like exactly what cold calling preflop means and what limping preflop means in a HU match. But I have to assume something is wrong with PT3 or my set up of PT3 if I can't even get an imported stat to display anything but 0's.
Every statistic I create shows 0's. I've even tried debugging to see if something as simple as "count: player is in SB AND player flat calls" will output anything on the screen (of course the syntax is correct as it validates correctly), and I get 0's still. I even imported someone's random stat (I believe it's call turn cbet in 3bet pot) and I get the same. I would imagine if you mess with columns that it takes a while to populate and that it's obviously not retroactive, since that column didn't exist... but I've let it work for several hours and every stat I have shows 0's. I'm 90% my formatting of the output is correct.
Here are some of the stats/columns I created... please keep in mind that I play HU exclusively. Is it technically a limp in HU if they just complete the SB?
COLUMNS:
cnt_p_limp_call_opp
Description: Number of times player has opportunity to limp call
Expression:
sum(if[holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise, 1, 0])
cnt_p_limp_call
Description: Number of times player limps and calls a raise
Expression:
sum(if[holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_f_saw, 1, 0])
Statistic:
LC%
Description: Percentage of the time a player elects to limp call
Value Expression:
(cnt_p_limp_call / cnt_p_limp_call_opp) * 100
Format:
Title: LC%
Format Expression: /%.2f
I've looked that code over a hojillion times and it seems to be fine unless I'm mistaken about some of the "axioms" like exactly what cold calling preflop means and what limping preflop means in a HU match. But I have to assume something is wrong with PT3 or my set up of PT3 if I can't even get an imported stat to display anything but 0's.
Quote:
There is nothing to count. I tired grouping by hole cards and counting hole cards and filtering for rake >=0.40 and <3.00 or rake >=3.00 and only get an error. When I try to run the report using only "Hands" it lists the hole cards filtered by my above rake filter. It doesn't count anything however.
Quote:
just started messing around with PT3, tried to set an alias and got this message:
"Unable to execute query: UPDATE tourney_holdem_results SET id_player = 1054 WHERE id_player_real = 8176; Reason: Fatal Error ()"
the original name has one sng in the database, and the alias doesn't have any tourney info, if that helps. also, both names are on ftp - using a combination of the original from ftp and an alias from pokerstars does work, though.
"Unable to execute query: UPDATE tourney_holdem_results SET id_player = 1054 WHERE id_player_real = 8176; Reason: Fatal Error ()"
the original name has one sng in the database, and the alias doesn't have any tourney info, if that helps. also, both names are on ftp - using a combination of the original from ftp and an alias from pokerstars does work, though.
Quote:
have an ridiculous problem with reports. I have a huge DB and a simple report take 30 minutes. When it is ready i wanna take a note over a x player, i did double click over player and report reload taking 30 minutes extra :S
My other problem is that HUD dont work Ipoker but in b10, and previous versions worked OK.
My other problem is that HUD dont work Ipoker but in b10, and previous versions worked OK.
Does the PT icon appear on your iPoker tables?
I'm working hard to get the next release out. It's taking longer than I thought, but early results seem to indicate all lag problems will be completely gone!
Crashed every 5 minutes ... and so on. beta 11 was better than final release lol
05-21-2008
, 01:41 PM
05-21-2008
, 01:42 PM
05-21-2008
, 02:14 PM
05-21-2008
, 02:31 PM
05-21-2008
, 03:06 PM
05-21-2008
, 08:42 PM
05-21-2008
, 09:33 PM
05-21-2008
, 11:59 PM
