PFR and VIP Positional for Full Ring

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

PFR and VIP Positional for Full Ring

Postby faintinggoat » Tue Sep 16, 2008 7:26 pm

I'm having a little trouble converting

MaxWeiss did the stats for 6max

BB:
SB:
Button:
CO:
MP2: (HiJack)
MP1: VPIP from UTG (6 max only, it would be 4 off the button in full ring games)
UTG+2:
UTG+1:
UTG: Want to Do for full ring
--- CODE ---
The Current Code for UTG (6max) or MP Full ring is
VPIP_UTG_Numerator
sum(if[holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 3,1,0])

I'm trying to add:
VPIP_UTG3_Numerator
sum(if[holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 4,1,0])

I'm getting an error of: Expression in NOT valid!

What I'm i missing
faintinggoat
 
Posts: 11
Joined: Sun May 11, 2008 11:40 am

Re: PFR and VIP Positional for Full Ring

Postby faintinggoat » Tue Sep 16, 2008 7:55 pm

I guess I figured it out.

If i press SAVE it says invalid express

If i press APPLY it works
faintinggoat
 
Posts: 11
Joined: Sun May 11, 2008 11:40 am

Re: PFR and VIP Positional for Full Ring

Postby faintinggoat » Tue Sep 16, 2008 10:25 pm

Think it was my problem. Maybe because AutoImport was on.

I restarted and it began working.
faintinggoat
 
Posts: 11
Joined: Sun May 11, 2008 11:40 am

Re: PFR and VIP Positional for Full Ring

Postby WhiteRider » Wed Sep 17, 2008 4:26 am

I've had the odd problem getting stats to validate/save when they appear to be correct, but you can usually get it to work with a little re-arrangement..
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 2 guests