Configure a stat to activate after BB <= 100?

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

Configure a stat to activate after BB <= 100?

Postby Wills Dad » Fri Aug 20, 2010 12:29 pm

I'm experimenting with an early game tourney HUD and a late game tourney HUD. To do that, I want to configure a statistic to activate at a certain blind level. For example, suppose I want my HUD to display the number of hands won, but not until the big blind >= 100. And, I don't want it to count hands won before the big blind >= 100.

I thought this would work:

if( var_live_amt_bb >= 100, cnt_won_hand , '' )

But, that just hides the stat until the big blinds = 100, then displays the number of times I've won hands in the entire game.

How would I adjust this to make it count hands won only when the big blind <= 100? I've searched through the forums/how to guides/custom stats repository, and I can't find the solution.

Thanks for your help.
Wills Dad
 
Posts: 6
Joined: Fri Jul 10, 2009 6:09 pm

Re: Configure a stat to activate after BB <= 100?

Postby kraada » Fri Aug 20, 2010 12:35 pm

You'd need to make a custom column that counted only hands won when the big blind is >= 100.

Copy cnt_won_hand and call it cnt_won_hand_late and add "and tourney_holdem_blinds.amt_bb >= 100" inside the if[] statement and then update your cache and use that column and it should work.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Configure a stat to activate after BB <= 100?

Postby Wills Dad » Fri Aug 20, 2010 1:24 pm

That was a fast! Thanks.
Wills Dad
 
Posts: 6
Joined: Fri Jul 10, 2009 6:09 pm

Re: Configure a stat to activate after BB <= 100?

Postby kraada » Fri Aug 20, 2010 2:05 pm

You're welcome :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: MagPie Crawler and 10 guests

cron