Villain Stack Size in BB

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

Villain Stack Size in BB

Postby VladimirN » Thu Oct 06, 2011 6:34 pm

Hi, is there any semi accurate stat for villain stack size in BB, currently? Or do I have to wait for PT4?
VladimirN
 
Posts: 63
Joined: Thu May 28, 2009 1:12 pm

Re: Villain Stack Size in BB

Postby WhiteRider » Fri Oct 07, 2011 3:51 am

Do you mean in the HUD?
The 'Live Stats' mechanism allows this, and there are "live stack in BB" stats available for free download from the "Get More" section (posted by me) - search for "live".
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Villain Stack Size in BB

Postby VladimirN » Fri Oct 07, 2011 8:11 am

Yes, that worked. Thank you so much.

I have 1 problem though: When trying to color-code some other stats with #LIVE Stack in BB# in my pop-up, I get this error: Unknown token encountered: var_live_amount_stack
And LIVE Stack in BB is working fine when I'm not using it for color-coding.

Is there a way to make it work? Thanks
VladimirN
 
Posts: 63
Joined: Thu May 28, 2009 1:12 pm

Re: Villain Stack Size in BB

Postby kraada » Fri Oct 07, 2011 8:57 am

I don't believe that will work at this time but please report this problem so that we can take a look into what we need to do to get it fixed.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Villain Stack Size in BB

Postby VladimirN » Sat Oct 08, 2011 10:07 pm

Ok, will do that.

Another question.
I'm trying to Color-Code some stat with itself (Instead of putting Color Ranges in HUD Config), because of the way I made it, it's way easier and faster that way for me

But when I try to check it in the re-player, it stays white. Is it the re-player thing (would it show properly on real tables) or I just cant color-code stat with itself?

(saved, refreshed many times, even restarted PT and it stays white)

PS: As well I would like to ask you Kraada, is there some fast way to color one of those Hand Range HUD's? There's 7 tables, times 169 stats, times like 7 colors = inhuman effort. :lol:
VladimirN
 
Posts: 63
Joined: Thu May 28, 2009 1:12 pm

Re: Villain Stack Size in BB

Postby VladimirN » Sat Oct 08, 2011 10:48 pm

To answer my own question: Yes, it's possible to color code a stat with itself and it's not re-player prob. It prob have something to do with this stat I'm using. Will have to check it tomorrow.
VladimirN
 
Posts: 63
Joined: Thu May 28, 2009 1:12 pm

Re: Villain Stack Size in BB

Postby kraada » Sun Oct 09, 2011 7:52 am

There's no fast way to do it. But the good news is that in PT4 such things will be more or less obsolete.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Villain Stack Size in BB

Postby VladimirN » Sun Oct 09, 2011 10:35 am

Ok, so the stat I'm having trouble with (and similar ones) is:

T Limp (55, 44, 33, 22):
(cnt_limp_show_55_44_33_22 / cnt_limp_known) * 25

cnt_limp_show_55_44_33_22:
sum( if[tourney_holdem_blinds.amt_bb >= 100 AND tourney_holdem_hand_player_statistics.flg_p_limp AND
(tourney_holdem_hand_player_statistics.id_holecard = 154 OR tourney_holdem_hand_player_statistics.id_holecard = 161 OR tourney_holdem_hand_player_statistics.id_holecard = 166 OR tourney_holdem_hand_player_statistics.id_holecard = 169), 1, 0])

cnt_limp_known:
sum( if[tourney_holdem_blinds.amt_bb >= 100 AND tourney_holdem_hand_player_statistics.flg_p_limp AND tourney_holdem_hand_player_statistics.flg_showdown, 1, 0])


And color-code is:

#T Limp (55, 44, 33, 22)# = 0 Sample
#T Limp (55, 44, 33, 22)# < 1 Sample
#T Limp (55, 44, 33, 22)# < 2 Sample
#T Limp (55, 44, 33, 22)# < 3 Sample
#T Limp (55, 44, 33, 22)# < 4 Sample
#T Limp (55, 44, 33, 22)# < 5 Sample
#T Limp (55, 44, 33, 22)# < 7 Sample
#T Limp (55, 44, 33, 22)# < 10 Sample
#T Limp (55, 44, 33, 22)# >= 10 Sample

HUD checked

And it stays white...while, when I color VP$IP (for example) in similar fashion it changes color in the re-player.
Am I doing something wrong?
VladimirN
 
Posts: 63
Joined: Thu May 28, 2009 1:12 pm

Re: Villain Stack Size in BB

Postby kraada » Sun Oct 09, 2011 11:15 am

Try renaming your stat without () or , (e.g. "T Limp Small Pair") and see if that helps.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Villain Stack Size in BB

Postby VladimirN » Sun Oct 09, 2011 1:18 pm

Just tried that, erased both brackets and comas and it didn't help
VladimirN
 
Posts: 63
Joined: Thu May 28, 2009 1:12 pm

Next

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

Who is online

Users browsing this forum: No registered users and 4 guests

cron