Stats by effective stack size

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: Stats by effective stack size

Postby Lakestone » Wed Feb 01, 2012 10:43 am

kraada wrote:Are you experiencing the same problems with these kinds of stats in our latest beta version?


No sorry I'm using the latest stable version of PT3.
Quick question instead creating a new thread for all my nembie questions: What is "flg"?
"cn" is explained as count in the basic section. I don't know if I should use flg_p_open or just cnt_raise for a preflop raise on the button :?:
Also I tried following the custom statistics tutorial, but I just got "invalid SQL" using your code in the section "Holdem Cash Player Statistics", but it worked in "Holdem Cash Hand". What's the difference between these and how do I know what queries work and don't in them?

There's so much to grasp for a beginner like me, so please bare with my silly questions :oops:.
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Stats by effective stack size

Postby kraada » Wed Feb 01, 2012 11:45 am

I'd recommend upgrading to our latest beta version - it contains a large number of fixes over our latest stable version at this point in time.

flg stands for "flag" - flg values in the database are either true or false, where as cnt values have a number associated with them. For example flg_vpip is either true or false - you either put money in voluntarily or you didn't. cnt_p_raise is a number - the number of times you raised preflop, so it could be 0 or 1 or 2 or 5.

Which code was giving you invalid SQL?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stats by effective stack size

Postby Lakestone » Thu Feb 02, 2012 11:04 am

kraada wrote:Which code was giving you invalid SQL?


I found out I was reading the wrong tutorial after a while, no wonder why I didn't learn and had so many questions...
[ img ]

Laters :D
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Previous

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

Who is online

Users browsing this forum: No registered users and 3 guests