Moderator: Moderators
sookmctourie wrote:Well I was so impressed with Kraada's New Hud Config, that I began a humble start on a version for Tourney's. I've started to create positional stats, but ran into a problem. Here is the sql. I can't for the life of me figure out why it won't validate. Any ideas?
sum(if[((tourney_holdem_hand_summary.cnt_players = 4 and tourney_holdem_hand_player_statistics.position = 1) or tourney_holdem_hand_summary.cnt_players = 5 and tourney_holdem_hand_player_statistics.position = 2) or (tourney_holdem_hand_summary.cnt_players = 6 and tourney_holdem_hand_player_statistics.position = 3) or (tourney_holdem_hand_summary.cnt_players = 7 and tourney_holdem_hand_player_statistics.position = 4) or (tourney_holdem_hand_summary.cnt_players = 8 and (tourney_holdem_hand_player_statistics.position = 4 or tourney_holdem_hand_player_statistics.position = 5)) or (tourney_holdem_hand_summary.cnt_players = 9 and (tourney_holdem_hand_player_statistics.position = 5 or tourney_holdem_hand_player_statistics.position = 6)) or (tourney_holdem_hand_summary.cnt_players = 10 and (tourney_holdem_hand_player_statistics.position = 6 or tourney_holdem_hand_player_statistics.position = 7))), 1, 0]
Art
t3hnu7z wrote:To change the colours, you will indeed have to go into each and every stat and modify it. There is no simple way to do this, but your hard work will have its own reward at the tables.
BillyTheBull wrote:t3hnu7z wrote:To change the colours, you will indeed have to go into each and every stat and modify it. There is no simple way to do this, but your hard work will have its own reward at the tables.
Ok, so I went into a couple of stats to set up my own color ranges, but for some reason the changes won't take?? I hit save for each individual color range, and that seems to work, but when I hit save for the overall stat, a "do you want to save" window followed by a "this stat already exists, do you want to overwrite" window appear -- the problem is that I hit "yes" in both of them, but it just keeps going back and forth between these two windows without accepting my confirmation. Do I need to save it under a new name? And if so, wouldn't that screw up my whole HUD layout? Help??
WhiteRider wrote:I assume you're using Beta 26?
There are still a couple of issues with saving colour conditions, although it should work if you save each condition and make sure there is nothing in the Condition Expression box before saving the stat or selecting an existing condition. Do not click on an existing colour condition after changing the selected one.
If you still can't get it to work Please enable logging, reproduce the problem and submit your PokerTracker.log file.
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 6 guests