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
by Trip_L » Mon Mar 30, 2009 8:00 am
I have noticed while looking at the limits from fulltilt that unless the limit name contains the small blind amount this field in set to 1
example:
limit_name amt_sb amt_bb
$1000 NL (6 max) 1.00 1000.00
$0.50 NL 1.00 0.50
$0.50/$1 0.50 1.00
Is this correct behavior? and would setting the small blind to being the right amount affect anything?
Thanks
-
Trip_L
-
- Posts: 23
- Joined: Mon Mar 17, 2008 5:53 pm
- Location: UK
by WhiteRider » Mon Mar 30, 2009 9:46 am
Good spot - I don't know why that is happening but I'll add it to our bug tracker to get fixed.
Thanks.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by timooo » Thu May 28, 2009 9:51 am
I also looked at these stats and your pdf doc says amt_bb of table holdem_limit is the amount of the big blind.
It seems to me that it is infact the amount of the big bet. I also use amt_bb to calculate the winrate and not amt_won/(2 * amt_bb) and get the results of the software. So there should be just a mistake in the documentation...
limit_name amt_sb amt_bb
$0.50/$1 0.50 1.00
limit names are always given in small bet /big bet and not smallblind / bigblind?!?
-
timooo
-
- Posts: 6
- Joined: Sat May 09, 2009 3:20 pm
by kraada » Thu May 28, 2009 12:30 pm
amt_bb is the size of the big blind and the BB won stats in PT3 are all for big bets though (and if you look at the stat definitions you'll note that they multiply by val_nlpl_mult, which is 2).
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests