Search:

Basically we have "cap to 99" and "always use 2 digits" to make nice alignment of stats but the whole idea to make nice tables of stats becomes fucked when we see every empty stat as singular sign...

select * from hands where HandTimestamp = {d "2018-03-04 10:06:20 PM"} OR HandTimestamp = {d "2018-03-04 10:07:11 PM"}

select * from hands where HandTimestamp > {d "2018-03-04 10:06:20 PM"} AND HandTimestamp < {d "2018-03-04 10:07:11 PM"}

StatHighCardOnFlop is a stat, not property.

we can't do
select * from hands where StatHighCardOnFlop = 1 limit 100
to find all A-high boards we can do
select * from hands where (boardcard1 = 0...

get all hands where flop was Queen high, I know 1 way to do it with BoardCard1,2,3 but I feel there should be an easier way.

Btw is it me or NOT and != are not working currently?
I tried doing ...

unfortunately it's just for hero

I see, thanks. I thought that I'm doing a wrong request to api since I'm getting error about wrong format type, as PlayerVsPlayerResults wants value to be of System.Collections.Generic.List format.
...

are you talking about filter in HM visual interface or there is one in HMQL?

can't figure out how to do a request for stats against specific player
what format should I use for PlayerVsPlayerResults ?

select StatTotalHands from stats where (NumberOfPlayers = 3) AND...

Hi,

I'm doing this query

select StatTourneyDurationDecimal from stats where HandTimestamp > {d "2017-08-01"}

why is it giving me a little different number every time while I'm not playing?...

shit! Thanks! I was looking in old documentation and couldn't find it. Damn google offered me HoldemManager2APIGuideV3.pdf xD

is it possible to make api request for tournaments played and net winnings usd in tournaments?

downgraded but still had to make a new database and re-import all hands (totally forgot I can do it :) ) to fix incorrect data in tournament HUD

that didn't change situation too, I have "Additional HUD filters" enabled too, anything to change there too? All data in tournament HUD for new players looks simmilar, shows low parameters of...

How can I downgrade to working version? tried installing HmUpdate_Release20thApril-1.exe over but the data is incorrect still, don't tell me I'm loosing database again :(

I don't know if it's database error or new version of HM1 (HM1 - 1.12.10b ) but for newly met players the numbers HUD is showing are totally weird and incorrect, even after 7k hands vs some players...

turbo, it's showing the correct payouts, but ICM calculation is using $62.50 as a 1st place reward for some reason.

hi, I haven't checked anything, just have a feeling that player of my kind can't have $EV at 0% value after 3k trneys. you've broke something in the algoryphms probably.

Also the payouts at 15$...

Let's check if we are talking about the same thing, I'm watching the graph in the tournaments-results-graph tab, where we have 3 checkboxes Rackback, Bonuses, Show Luck Adjusted Winnings. Every time...

same for the rakeback thingie

also signing

is it broken for all networks/sites?

and it doesnt solve it completely, tables r still freezing after some time.

but I remember clearly one moment, when ongame changed the HH format it took 3 (3!!) weeks to fix HEM, when it happened to FTP it took 1 (1!!) day (yes, day!!).

Let's see how much time will this problem take to be solved and how HEM developpers really care about us, ongame players.