Custom Database Fields

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 Database Fields

Postby BuracaStyle » Mon Aug 30, 2010 10:35 am

Hi,

I'm currently using PT, but I would like to have access to more info/stats to help me in my p/f strat.

The thing here is that I have a personal parser that I use to retrieve custom stats. Right now, I would like to display my info via PT and its HUD.

My concrete question is:

Is is possible for me to alter the "holdem_hand_player_statistics" table, adding it my columns (i.e. SQL command ALTER TABLE)? Would this interfear with PT's runtime(there are ways to query/manipulate SQL tables that are not affected by adding columns, that's why I'm asking)?

Anyway, I could have my app asynchronously filling my columns. The idea would be to later use the new columns at the "Configure Stats" dialogue, so that new info could be displayed at the HUD.

Is this possible at all? If not, are there any alternatives so that I can pull this off?

Thanks,
Much appreciated
BuracaStyle
 
Posts: 3
Joined: Mon Aug 30, 2010 9:58 am

Re: Custom Database Fields

Postby WhiteRider » Mon Aug 30, 2010 11:56 am

Depending on what the additional stats are you may be able to build them as custom stats - what are you wanting to build?
You will not be able to change the"holdem_hand_player_statistics" table - adding columns to that will stop the importer working.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom Database Fields

Postby BuracaStyle » Mon Aug 30, 2010 6:24 pm

I would like to get stats like:

limp,
shove
open shove
shove limpers
shove raiser
shove 3bet
etc

And it gets trickier, because I collect a lot more details and stats about shoves. I do the same stuff for Shove-Calls and Re-Shoves. I had a quick read trough PT's manual, and I didn't find any of this (right?).

Since I cant alter PT's schema, can I define new tables and access them at the "custom stat" Poker Tracker dialog (defining new custom columns)?

Thanks for the help!
BuracaStyle
 
Posts: 3
Joined: Mon Aug 30, 2010 9:58 am

Re: Custom Database Fields

Postby WhiteRider » Tue Aug 31, 2010 4:15 am

I think you can build all of those as custom stats within PT3.
Limp stats are already built in, and there are a few others in the "Get More" section.

Some links to threads about building allin stats:

link
link
link
link
link

Tutorial: Custom Reports and Statistics

The Database Schema documents the database fields.

If you have any questions about building a specific stat please let us know and we'll help you out.
We've looked at adding custom tables and columns before for custom stats and I don't remember finding a working solution.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom Database Fields

Postby BuracaStyle » Tue Aug 31, 2010 7:41 am

Good stuff ma man, good stuff.

Thx for the help
BuracaStyle
 
Posts: 3
Joined: Mon Aug 30, 2010 9:58 am


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

Who is online

Users browsing this forum: No registered users and 0 guests