SQL Query

[jimbos]

Guys,

I'm trying to build some queries to check the results vs short stacks.
First, could anyone of you tell in which table I can find the details of the players in a hand (to check their stack sizes)? I don't seem to be find that ...

Thanks!

[Rvg72]

Hi, you can get the pokerhand_id somehow and then a

select * from playerhandscashkeycolumns where pokerhand_id = 12345

will get you info from all the players in hand 12345

Roy

[jimbos]

Thanks!

[oksi]

edit the holdemmanager.config file and change the

<setting name="LogDatabaseCommands">False</setting>
To
<setting name="LogDatabaseCommands">True</setting>

Then relaunch HM and run the report. Then look
for the DBTrace.log file and it will show the queries that were used.


That's the solution!
Thx to RVG72

[oksi]

edit the holdemmanager.config file and change the

<setting name="LogDatabaseCommands">False</setting>
To
<setting name="LogDatabaseCommands">True</setting>

Then relaunch HM and run the report. Then look
for the DBTrace.log file and it will show the queries that were used.


That's the solution!
Thx to RVG72

Sorry I really messed up. This post is not to be here! :$