Donk fold stat

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

Donk fold stat

Postby SteveSize » Sat Mar 20, 2010 11:13 am

Hi all

Ive been searching the stats for my hud and im looking for a stat which shows how often a player folds their flop donk bet to a raise. Does this stat exist?

Steve
SteveSize
 
Posts: 9
Joined: Tue Feb 09, 2010 4:38 pm

Re: Donk fold stat

Postby kraada » Sat Mar 20, 2010 11:43 am

I've built it already and attached it to this post for you.
Attachments
Donk_Fold Flop.zip
(716 Bytes) Downloaded 275 times
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Donk fold stat

Postby SteveSize » Sat Mar 20, 2010 11:51 am

Wow thanks! Awsome support here!
SteveSize
 
Posts: 9
Joined: Tue Feb 09, 2010 4:38 pm

Re: Donk fold stat

Postby SteveSize » Sat Mar 20, 2010 12:01 pm

I have downloaded the attachment, where do i put the file? Im running windows xp sp3.

Thanks for your help

Steve
SteveSize
 
Posts: 9
Joined: Tue Feb 09, 2010 4:38 pm

Re: Donk fold stat

Postby kraada » Sat Mar 20, 2010 12:07 pm

Unzip the file, click Configure --> Configure Statistics, go to the Stats tab, click the Import button and select the .pt3stat file. Click Import one more time, then update your cache and you should be all set.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Donk fold stat

Postby SteveSize » Sat Mar 20, 2010 12:44 pm

All done thanks.
SteveSize
 
Posts: 9
Joined: Tue Feb 09, 2010 4:38 pm

Re: Donk fold stat

Postby bender » Fri Mar 18, 2011 6:51 pm

I looked inside the definition of the stat and it looks like this part "lookup_actions_p.action SIMILAR TO 'B_%'" is responsible for selecting cases only when donk bet got raised. Is it really sufficient? I don't see any reference to a raise in this statement. Perhaps "_" does it. What if player who donked calls raise instead of folding? Won't this case be counted as it was raised?
bender
 
Posts: 70
Joined: Wed Apr 30, 2008 3:50 pm

Re: Donk fold stat

Postby WhiteRider » Sat Mar 19, 2011 5:36 am

In pattern matching (using LIKE) the _ underscore means any single character.
So 'B_%' means a bet, then at least one more action (meaning that you faced a raise after betting). % means zero or more characters, so that pattern matches any of these: BF, BCF, BRRRR. But NOT 'B'.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests