Advanced Hud Config for Tourney's

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Re: Advanced Hud Config for Tourney's

Postby WhiteRider » Wed Apr 01, 2009 4:46 pm

Open the stat (which you're not getting colour for) in the Custom Stats window and look at the Color tab and you will see which stat is being referenced.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Advanced Hud Config for Tourney's

Postby kosbios » Sat Apr 11, 2009 6:22 am

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
kosbios
 
Posts: 1
Joined: Sat Apr 11, 2009 5:32 am

Re: Advanced Hud Config for Tourney's

Postby kraada » Sat Apr 11, 2009 8:34 am

You need a close parenthesis at the very end of that statement, to close the sum().
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Advanced Hud Config for Tourney's

Postby BillyTheBull » Sat Apr 11, 2009 4:18 pm

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??
BillyTheBull
 
Posts: 57
Joined: Wed Feb 06, 2008 6:16 pm
Location: Denver, CO

Re: Advanced Hud Config for Tourney's

Postby WhiteRider » Sun Apr 12, 2009 4:03 am

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??

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 to the Support system , and link to this thread in the reference field of the ticket so that we can investigate.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Advanced Hud Config for Tourney's

Postby EthanH27 » Sun Apr 12, 2009 5:59 pm

PLease can someone update us About the tourney's Hud Config stats?. This is the hardest config to find any infomation on and the little thats out there is confusing. as far as i can see it is not in the repository for download, but lots are talking as if they are using it?. iv seen some post saying it's being updated but none as to where to get the old version.
any update would be very greatfull. and would love even the old version as would like a challege if it needs fixing.

thanks
EthanH27
 
Posts: 4
Joined: Fri Mar 13, 2009 12:26 pm

Re: Advanced Hud Config for Tourney's

Postby WhiteRider » Sun Apr 12, 2009 6:27 pm

It is in the Repository, on the Layouts tab.
See also the How To: Advanced HUD Configuration thread.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Advanced Hud Config for Tourney's

Postby EthanH27 » Sun Apr 12, 2009 6:32 pm

Then yes im a noob,
But there are two showing in the repository ones Advance cash witch i have downloaded and using and the other says its the default HUD.
so again i ask for more infomation about the ever so much talked about tourny hud layout????

thanks anyone
EthanH27
 
Posts: 4
Joined: Fri Mar 13, 2009 12:26 pm

Re: Advanced Hud Config for Tourney's

Postby EthanH27 » Sun Apr 12, 2009 6:59 pm

don't worry after alot of chasing around i now have the layout. NOTE: you have to be logged in to see attachments in posts.
EthanH27
 
Posts: 4
Joined: Fri Mar 13, 2009 12:26 pm

Re: Advanced Hud Config for Tourney's

Postby BillyTheBull » Sun Apr 12, 2009 9:53 pm

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.

Done -- yes, using beta 26 . . . tried it again to make sure I had the expression box empty, but same issue. For the record, my newly configured color stats ARE being saved, but the original ones come back (after I remove them individually) after my unsuccessful save attempts.
BillyTheBull
 
Posts: 57
Joined: Wed Feb 06, 2008 6:16 pm
Location: Denver, CO

PreviousNext

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 6 guests

cron
highfalutin