PDA

View Full Version : Database Query [fold vs sqz]



d1mon
10-27-2012, 07:16 AM
Hello!
I want to recieve manually next stats:
Fold vs squeeze (as Caller),
Fold vs squeeze (as Raiser).

Can you help to build database query? (player_id is known)
Thank you very much!

d1mon ;)

d1mon
10-27-2012, 07:35 AM
yes, i have seen HM1StatsDefinitions.txt. But there are no stats that i need.

udbrky
10-28-2012, 04:58 AM
I'm sorry to hear you're having issues with this and I apologize for the delay. I have escalated this to our 2nd level support techs and have explained the issues you are having and they will be in touch shortly to help resolve the problem.

d1mon
10-29-2012, 06:52 PM
Can you update HM1StatsDefinitions.txt ?

udbrky
10-30-2012, 01:50 AM
I passed this along. I do not have an answer yet on the first question.

d1mon
10-30-2012, 05:29 PM
I hope recieve the answer, I really need this))
Thank you

d1mon;)

d1mon
11-07-2012, 05:06 AM
what about answer?

udbrky
11-07-2012, 01:26 PM
I just asked again - we've been pretty busy lately with FTP stuff.

fozzy71
11-07-2012, 06:45 PM
Unfortunately this is not anything we will be able to help with for HM1. It is beyond the technical knowledge of our forum support technicians and would require assistance from our developers but all of their time and effort is focused on HM2 going forward as HM1 only receives developer attention for critical bugs with existing features.

On the bright side both of these stats are included by default in HM2 Reports and HUD.

d1mon
11-08-2012, 04:15 PM
On the bright side both of these stats are included by default in HM2 Reports and HUD.

Yes, these stats are included by dafault but i need to know how to grab them from database, becase i want to make more complicated stats.

fozzy71
11-08-2012, 07:53 PM
Yes, they are stats by dafault but i need to know how to grab them from database, becase i want to make more complicated stats.

Are you trying to make these new 'more complicated' stats in HM1 or HM2? As mentioned earlier, this is not something we can spend developer time to help with in HM1.

In the near future HM2 will have a HMQL (Holdem Manager Query Language) which we will expose for programmers and third party developers to access the HM2 database. This might help in doing what you want to do but it is all a bit over my head to be honest so I am not sure if it will do exactly what you want. We will begin to expose this HMQL feature after our next release but it will be a slow process as we expose parts of it and document it in our FAQs, and then expose/document more of it in the future.

d1mon
11-10-2012, 12:43 PM
Fozzy71, maybe you have access to new version of HM1StatsDefinitions.txt ? Can you update this file?

I'm about Formulas for every HM1 Stat! (Updated Nov 12, 2009)

fozzy71
11-10-2012, 03:37 PM
That is the latest version as far as I know and it is not something we plan to update.

See this thread - http://forums.holdemmanager.com/manager-general/11051-show-sql-queries-hm-run-against-postgresql.html

Close HM2 and open the config file - C:\Program Files (x86)\RVG Software\Holdem Manager\Config\HoldemManager.config

Change this config variable to True:


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

Then all logs are shown here: C:\Program Files (x86)\RVG Software\Holdem Manager\Logs\DBTrace.log

d1mon
11-10-2012, 08:49 PM
Thank you very much )))