Page 1 of 1

Simpel sql queries

PostPosted: Fri Nov 21, 2008 5:09 pm
by hans32
Hi

1: in what table is the data regarding a player located? I need this information:amount won a specific day.

2: I have made notes on poker players on the Ongame Network. Can I put the notes into the poker tracker 3 db, and how do I do it?

Thx in advance.

Re: Simpel sql queries

PostPosted: Fri Nov 21, 2008 5:15 pm
by kraada
You can filter to a specific day using the PT3 filters: click Filters, and choose Specific Date and pick the day you want, then go to that player and it will show you how much they've won.

There is no automated way of getting your notes from OnGame into PT3 at this time, but we are hoping to expand notes functionality at some point in the future. Unfortunately I cannot give an exact time when this might be available.

Re: Simpel sql queries

PostPosted: Fri Nov 21, 2008 5:19 pm
by hans32
Thx for the reply.

I need the sql code used for getting the result mentioned in question 1. When I have it I can build a program which displays my stats in realtime so I dont have to switch between poker room software and Poker Tracker that much. Is there a way to obtain the sql code?

Re: Simpel sql queries

PostPosted: Fri Nov 21, 2008 6:01 pm
by WhiteRider
You can enable logging and all the SQL queries are logged.

Re: Simpel sql queries

PostPosted: Fri Nov 21, 2008 6:39 pm
by hans32
ok but how can I choose what queries I need to be runned? I need this data showed in screenshoot: http://img232.imageshack.us/my.php?imag ... 171wz6.jpg

Re: Simpel sql queries

PostPosted: Fri Nov 21, 2008 6:54 pm
by WhiteRider
Sorry - I don't know how to do the direct query, but I'm sure someone will help you.

Re: Simpel sql queries

PostPosted: Fri Nov 21, 2008 7:02 pm
by hans32
It's ok you dont know it but is there not a simple way to make program show query useds when highlighting a column field i PT3?

Re: Simpel sql queries

PostPosted: Fri Nov 21, 2008 7:11 pm
by WhiteRider
No, you can't see the query directly in PT3, only in the logs.

highfalutin