Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
update tourney_hand_player_statistics as player
set amt_p_effective_stack =
(select min(villains.amt_p_effective_stack)
from tourney_hand_player_statistics as villains
where player.id_hand = villains.id_hand
and player.id_player <> villains.id_player)
from tourney_summary as ts, tourney_table_type as ttt
where player.id_tourney = ts.id_tourney
and ts.id_table_type = ttt.id_table_type
and player.amt_p_effective_stack = 0
and ttt.val_seats = 2
BillGatesIII wrote:For the time being you could run this script, of course at your own risk, to update the effective stacks for heads up tournaments.
- Code: Select all
update tourney_hand_player_statistics as player
set amt_p_effective_stack =
(select min(villains.amt_p_effective_stack)
from tourney_hand_player_statistics as villains
where player.id_hand = villains.id_hand
and player.id_player <> villains.id_player)
from tourney_summary as ts, tourney_table_type as ttt
where player.id_tourney = ts.id_tourney
and ts.id_table_type = ttt.id_table_type
and player.amt_p_effective_stack = 0
and ttt.val_seats = 2
kraada wrote:I'm looking for a way around this issue for people like yourself - limited to heads up tournament play. I don't know if I will find one.
The official PokerTracker company position on this issue is elaborated on in this thread.
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 21 guests