View Full Version : SQL Query
jimbos
11-08-2008, 03:21 AM
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
11-09-2008, 03:49 AM
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
11-12-2008, 03:47 PM
Thanks!
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
:)
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! :$
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.