Diplay amount won in realtime

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Diplay amount won in realtime

Postby hans32 » Tue Nov 18, 2008 8:08 am

Hi

I want the "amount won" field(http://img204.imageshack.us/my.php?imag ... 068mv1.jpg) displayed realtime on a webpage or any oher solution proposed.

I want it that way to avoid switching between poker software and poker tracker to see amout won. Maybe a sql query done on a webpage can do it for me?

Any suggestions?
hans32
 
Posts: 52
Joined: Tue Nov 18, 2008 7:38 am

Re: Diplay amount won in realtime

Postby WhiteRider » Tue Nov 18, 2008 8:13 am

I had something like this set up in a webpage for a PT2 access DB, but I haven't done it for PT3.
What I'm hoping is that we'll get a 'Refresh' button on "expanded" reports, so that we can have an 'active sessions' report open in it's own window and either click to refresh it or may have it on a timed refresh.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Diplay amount won in realtime

Postby hans32 » Tue Nov 18, 2008 9:01 am

is there a way to see the sql query used for obtaining "amount won"?
hans32
 
Posts: 52
Joined: Tue Nov 18, 2008 7:38 am

Re: Diplay amount won in realtime

Postby WhiteRider » Tue Nov 18, 2008 12:38 pm

I think that all the queries are written to the log file, so enable logging and search in the file: c:\Program Files\PokerTracker 3\PokerTracker.log
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Diplay amount won in realtime

Postby hans32 » Thu Nov 20, 2008 2:25 am

I believe I can get code from log file. But how do I diplay the result of the query in a little windows in a tiny area of the screen?
hans32
 
Posts: 52
Joined: Tue Nov 18, 2008 7:38 am

Re: Diplay amount won in realtime

Postby WhiteRider » Thu Nov 20, 2008 5:24 am

I don't know, but I'm sure someone will be able to tell you.
(I'd be interested in seeing this too)
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Diplay amount won in realtime

Postby hans32 » Fri Nov 21, 2008 3:25 am

the logfile generates a lot of data. Could somebody please tell me the exact query to obtain amount won a specific day?
hans32
 
Posts: 52
Joined: Tue Nov 18, 2008 7:38 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 30 guests

cron