Custom Table Selection

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

Custom Table Selection

Postby checkits » Wed Jul 09, 2008 12:38 pm

I want to score tables based on the sum of scores for individual players (i.e., I want this to do for me what SpadeEye does). For example, I want to say...

if Player VP$IP > 40, then score +10 points
if Player Total Aggression < 1.5, then score +10 points
if Player Total Agression >= 1.5 and < 1.9, then score +6 points
if Player is short stacked, then score -5 points
if John Doe is sitting at table, then score +20 points
etc.
etc.

Then I want to sum the scores of each individual at the table to get a table score. Then I'd like to rank tables based on this score.

I'm willing to put a bunch of work into this and share it with the community if someone can help me get started. I know some SQL, but I'm not great w/ it. If PT3 wants to include any of my work in the release -- and charge me and everyone for using it -- I'm happy w/ that as well. I just want to be able to use PT3 for this instead of other applications that access my PT database and do the same thing.
checkits
 
Posts: 19
Joined: Thu May 22, 2008 6:55 pm

Re: Custom Table Selection

Postby checkits » Thu Jul 10, 2008 6:19 pm

Is there a way to create the Table Tracker in Custom Reports -- so that I can make edits/changes to it -- to add the scoring described above?
checkits
 
Posts: 19
Joined: Thu May 22, 2008 6:55 pm

Re: Custom Table Selection

Postby WhiteRider » Fri Jul 11, 2008 4:20 am

Not at the moment, and I doubt it would be done that way round. What is more likely is the option to add Custom Stats to the Table Tracker - you can already do this on the list of individual tables at the bottom.
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 3 guests