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 kraada » Fri Jan 16, 2009 1:06 pm

You'll want tourney_holdem_blinds.amt_sb and amt_bb.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Advanced Hud Config for Tourney's

Postby sookmctourie » Sat Jan 17, 2009 4:31 pm

:D After much time and reading and errors and reading and errors and giving up and going to sleep and taking another look and reading some more, I have now completed a successful mzone stat (color coded). Rather than testing it in the HUD, I decided to create a custom report and tested the output data against my db, by manual calculations of the data in the replayer for random hands. So far, the stat is spot on. I formated the stat to 2 decimal points to reduce the size of the number. But ideally, I would rather have no decimal point. At this time, I don't know how to format for this.

If anyone is interested in taking a look at it, I will need the moderators help in making it available for testing before it goes in the repository.

I'm tired, and my brain hurts. But it was worth it. :lol:

Art
sookmctourie
 
Posts: 202
Joined: Thu Mar 06, 2008 7:52 pm

Re: Advanced Hud Config for Tourney's

Postby kraada » Sat Jan 17, 2009 4:54 pm

Art,

Good for you!

You can use format_number() in the format tab to format the number to have 0 decimal points, see the custom stats & reports FAQ for the exact details.

If you let me know when you submit it to the repository I'll make sure to expedite its acceptance.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Advanced Hud Config for Tourney's

Postby WhiteRider » Sat Jan 17, 2009 4:57 pm

If you're using /%.2f you can just use /%.0f for zero decimal places (and hence no decimal point).
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Advanced Hud Config for Tourney's

Postby sookmctourie » Sun Jan 18, 2009 1:49 pm

Thanks guys, for all your help! I've formated to zero decimal places. Looking back, it all seems simple enough, but with no prior experience or knowledge in database languages, concepts, etc., it was like a walk in the dark. But I learned a lot, and better prepared to begin creating more custom stats. The final hitch for me in getting this stat to work, was the amt_antes. After looking at the data output, and working things out on a calculator, I realized that the expression was only including my ante. So I included *tourney_holdem_hand_summary.cnt_players, and I finally got the right mzone number.

My cable modem broke down just after I posted yesterday, so I'm just getting back now,

Kraada, I will pm you today.

Art
sookmctourie
 
Posts: 202
Joined: Thu Mar 06, 2008 7:52 pm

Re: Advanced Hud Config for Tourney's

Postby kraada » Sun Jan 18, 2009 2:12 pm

No need to double post; I'm glad to hear you got things working and I hope your internet issues have sorted themselves out.

Enjoy the new HUD :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Advanced Hud Config for Tourney's

Postby okguyjames » Sat Jan 24, 2009 1:12 am

this is an amazing thread imo. along similar lines, is there a way to code a HUD statistic that simply displays a players stack size as measured in BB? this of course would be the stack size at the start of the hand and not a dynamically changing number as bets are made. I'm excited about the prospect after reading all of this!
okguyjames
 
Posts: 4
Joined: Thu Jan 22, 2009 7:21 pm

Re: Advanced Hud Config for Tourney's

Postby sookmctourie » Sat Jan 24, 2009 1:35 am

okguyjames wrote:this is an amazing thread imo. along similar lines, is there a way to code a HUD statistic that simply displays a players stack size as measured in BB? this of course would be the stack size at the start of the hand and not a dynamically changing number as bets are made. I'm excited about the prospect after reading all of this!


Your stack size in the database is "amt_before"
Too arrive at how many BB's you have in a tourney, you divide your stack size by the blinds.
amt_before / (amt_bb + amt_sb) equals BB
This works fine until the antes kick in. Your M on the other hand includes the antes and gives you a much better idea of where you truly stand in the trny.
So yes, arriving at how many BB's you have left is straight forward,
sookmctourie
 
Posts: 202
Joined: Thu Mar 06, 2008 7:52 pm

Re: Advanced Hud Config for Tourney's

Postby kraada » Sat Jan 24, 2009 10:31 am

Actually one small note: that'd be your stack from the last hand. The information about the current hand in play isn't stored in the PT3 database anywhere.

You may be able to build current stack out of last stack + amount won/lost in the last hand, but I recall there being a problem with that several months back when someone last tried it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Advanced Hud Config for Tourney's

Postby okguyjames » Sat Jan 24, 2009 11:28 am

would sookmctourie's formula display the starting stack from the previous hand (before the adjustments such as betting, folding blinds etc. occurred), or the end stack amount (after all plays were finished and it is moving on to the current hand) for the hand we're currently playing? if it shows the end stack total from the previous hand, that total would be the starting stack of the new hand. if only it could display the information it saved...I'm thinking that at the beginning of every hand it saves the current stack size. bets are made (or not) and the hand ends. it now can display it's previous total and saves the new one for display for the next hand. if I understood this correctly, is there any way to intercept that total that gets put into the queue and display it? also, I've searched the forums for the thread you referenced kraada but couldn't find it. do you recall the thread/link? I would love to have a look at that also. oh and tylenol please :)
okguyjames
 
Posts: 4
Joined: Thu Jan 22, 2009 7:21 pm

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 5 guests

cron