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
by TROM » Sat Nov 06, 2010 12:46 am
If I create my own stat can I make query to this stat from another prorgram not pokertraker by SQL?
-
TROM
-
- Posts: 57
- Joined: Mon Jun 16, 2008 6:56 pm
by WhiteRider » Sat Nov 06, 2010 5:37 am
Not directly - the stat value isn't stored in the database, but once you have updated the cache the column values are stored (in the "holdem cache" table, for instance) so you could retrieve those and calculate the stat value outside PT3.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by TROM » Sat Nov 06, 2010 10:28 pm
thanks
now I understand new stats only for pokertraker but new column store in database
But what about Export I dont undersand logic
I want to save my new column and stats
But for column I dont have export button
and dont know what exactly exports when I do it for new stats all new column what I use in this stat too ?
-
TROM
-
- Posts: 57
- Joined: Mon Jun 16, 2008 6:56 pm
by WhiteRider » Sun Nov 07, 2010 5:53 am
When you export a stat any columns or variables it uses are exported too.
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests