Simpel sql queries

[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.

[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.

[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?

[WhiteRider]

You can enable logging and all the SQL queries are logged.

[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

[WhiteRider]

Sorry - I don't know how to do the direct query, but I'm sure someone will help you.

[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?

[WhiteRider]

No, you can't see the query directly in PT3, only in the logs.