PDA

View Full Version : SQL query



Lespaulka001
10-04-2010, 01:30 PM
Hello!

I would like to get from HM database, the following datas:

all players name, vpip, pfr, hand number.

How should I write the query in pgadmin?

Thanks for your help!

netsrak
10-06-2010, 04:38 AM
You know how to use the pgadmin query tool?

I can't give the exact SQL statement for what you are looking for but this should help you:

Close down HM and open the holdemmanager.config with notepad and change
<setting name="LogDatabaseCommands">False
To
<setting name="LogDatabaseCommands">True

Now run the report and when it finishes look in the logs folder for a file named dbtrace.log and open it with Wordpad and go to the bottom of the file and you will see the query.