Holdem Manager Support - Page 290 - Commercial Software -- Two Plus Two Poker Forums

AnTiC____iPaTiOn · 05-06-2008, 04:28 AM

I'm trying to find out how many of my database are winners and losers. Is there an easy way to find this like there was w/ PokerTracker?

I really need to know within the hour if anyone could help, thanks.

whitfcd · 05-06-2008, 05:31 AM

Quote:

Originally Posted by HighSteaks

The folder pg_log in may Postgres data folder is 8GB

It's full of text files like below, can I delete them?

This is one way to stop these coming back.

Launch C:\Program Files\PostgreSQL\8.2\bin\pgAdmin3.exe

Select File > Open postgresql.conf

Navigate to C:\Program Files\PostgreSQL\8.2\data and open postgresql.conf

Scroll down about 2/3rds of the way until you see the following keys.

Set their values as above. To change an entry, double click it, check the Selected box and enter the correct value.

Select File > Save and exit everything.

Changes will probably take effect after a reboot.

You can then delete all the datemarked logs in C:\Program Files\PostgreSQL\8.2\data\pg_log (e.g. postgresql-2008-05-06_182909.log)

You will only ever have 7 logfiles in this directory - one for each day so they will not accumulate.

effang · 05-06-2008, 05:43 AM

Quote:

Originally Posted by rvg72

Yes, this is definitely needed and is on the list

You could try a Vacuum Analyze using pgadmin - there will be some more options coming soon as I add more DB maintenance functionality.

rvg

when is 1.05.05 coming out? and how do we currently do clusters and vacuums?

thanks

Hand_Crasher · 05-06-2008, 11:52 AM

Thank you whitfcd x)

awjpoker · 05-06-2008, 03:24 PM

Quote:

Originally Posted by good_gamble

Hi Roy,
Pasted from HEM forums:

Crypto GBP games are still being imported as USD. Eg. when I play £1/£2 it imports as $1/$2 which mixes up with my actual $1/$2 hands. Please could you fix this ASAP as I am unable to use HEM while this is the case.

Thanks,

Alan

I would also need this before i could use it, and will buy full version as soon as it handles GBP (£)

PS When is the next release due, any chance this will be in it?

sccl · 05-06-2008, 07:11 PM

Support of currencis is a must. £, € and if possible TRY (for Boss games). If you support different currencies and exchange rates, then the user should be able to specify in which currency is his bankroll for each network.
Other things I would like to be added :
- allow more than 3 pots in the HUD table preferences
- been able to have different hud configuration for heads up, max and full ring table
- 3 differents rake calculation (dealt, contributed, fully contributed)

rvg72 · 05-06-2008, 09:12 PM

Quote:

Originally Posted by Entity

Is the process of adding a database to set these ranges difficult? I'd love to set the ranges but it would be even nicer to just be able to plugin ~2million hands of 6max *LHE* (for us limidonks) to get ranges autogenerated.

Rob

It was actually getting really time consuming doing this for the NL 6 max stats I had so I wrote a program to help me out. There is a very good chance this program will be posted for people to use with their own stats.

Quote:

I don't know where I'm expected to post problems, so sorry in advance if I'm on the wrong place.
Earlier today I bought HEM and so far I'm very happy with it but I get the following error when I go to the tab Report->Reports Name: Hand at Showdown:

"The following error occurred when running this report: ERROR: 42803:
column "ph.netamountwon" must appear in the GROUP BY clause or be used in aggregate function"

hmmm... I think it must be your filter - if it is still happening could you tell me what you have in your filter? After clearing it does it still give you an error?

Quote:

I ran the pgAdmin "Analyze" command and got the following reponse in the "Messages" window. "Query returned successfully with no result in 518906 ms."

I ran the report for the "Last 3 Months" and once again got the following error: "The following error occurred when running the report: ERROR: 57014: canceling statement due to user request."

I have played probably about 150,000 hands in the last 3 months and am using a Q6600 quad core processor w/ 4GB of RAM.

I'm using the following stats in my report: $, bb/100, VPIP%, PFR%, 3bet%, WTSD%, W$SD%, Agg, Sqz%, vs 3bet Raise%, Steal Pct, W$WSF, Flop Agg, Turn Agg, and River Agg.

I can't understand why this would happen.. I've had million hand player db's (ie the infamous fgators db) and didn't have issues. Postgtes is definitely messing up the query plan. I'll need to think about this a bit since the analyze did not seem to help.

Quote:

Hi Roy,
Pasted from HEM forums:

Crypto GBP games are still being imported as USD. Eg. when I play £1/£2 it imports as $1/$2 which mixes up with my actual $1/$2 hands. Please could you fix this ASAP as I am unable to use HEM while this is the case.

Thanks,

Alan

Multi currency is one of the big todo items before 1.06 is released.

Quote:

I'm trying to find out how many of my database are winners and losers. Is there an easy way to find this like there was w/ PokerTracker?

I really need to know within the hour if anyone could help, thanks.

Players Tab along the top - you can do a LOT more than just find winners or losers but that is in there.

Roy

LMON · 05-06-2008, 09:45 PM

Quote:

Originally Posted by rvg72

hmmm... I think it must be your filter - if it is still happening could you tell me what you have in your filter? After clearing it does it still give you an error?

I have nothing in my filter

rvg72 · 05-06-2008, 10:29 PM

Quote:

Originally Posted by LMON

I have nothing in my filter

Can you try this, close HM and open the holdemmanager.config file
Change:

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

to

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

Then, relaunch HM and run this report. Then send the dbtrace.log file to support@holdemmanager.net. You should probably then go back and turn logging off after this because it can slow things down.

**goofyballer** · 05-07-2008, 06:19 AM

Sometimes HM gets in a state where the mouse cursor turns into the hourglass and never goes back to a pointer - kinda a pain as it's hard to tell when it's actually doing work. I just got this by going to vs players and loading all my hands (took ~30 seconds to load), changing min bb's to 10 and refreshing, and the mouse is now perma-hourglassed in the upper panel, even if I change tabs.

Also - one thing I really like about PT2 is that when looking at a hand in the Game Notes tab, it had a panel at the bottom which had pretty much all the details about the hand:

Some things about it are awkward, but it has some really important info in it - namely, the hole cards (if known) of everyone that took part in the hand. When scanning through hands this makes it easy to recall what you were up against - in HM, you have to replay the hand, or open up the HH, or something like that to get that kind of information. I love the way the current hand tab displays the action (the "RC pre, XR flop, etc" stuff) as it makes it easy to reconstruct the action in a hand, but at the very least some easy way to see what cards people held at showdown without doing a bunch of clicking and opening and closing of windows would be really helpful.

Borned_Luckbox1 · 05-07-2008, 10:30 AM

Ongame db support and Boss media support? When? Days, weeks, months?

fnord_too · 05-07-2008, 10:45 AM

Just checking before I make my final decision on the next generation tracking software:
There are still no plans to support omaha and stud with holdem manager? Before you said no, and I didn't see it on your web site, but I thought I would confirm.

thac · 05-07-2008, 11:17 AM

Quote:

Originally Posted by fnord_too

Just checking before I make my final decision on the next generation tracking software:
There are still no plans to support omaha and stud with holdem manager? Before you said no, and I didn't see it on your web site, but I thought I would confirm.

I think someone asked this a few months ago and rvg said omaha would be supported by the end of the year.

edit - yah, right here:
http://forumserver.twoplustwo.com/sh...postcount=3493

Quote:

No Omaha version although I would expect to have an Omaha version before the end of the year. Hold'em is the priority at this point though although almost all of the functionality can be moved to Omaha and things can be added / modified where it makes sense.

Catyoul · 05-07-2008, 11:43 AM

If you want to know your standard deviation, you can run this query :

Code:

SELECT gametypedescription as stakes,COUNT(*) as hands,100*AVG(netamountwon)/bigblind as winrate,10*STDDEV(netamountwon)/(2*bigblind) as SD
FROM playerhandscashkeycolumns,gametypes
WHERE player_id in (SELECT player_id FROM players WHERE playername ILIKE '**********YouShouldPutYourScreenNameHere************')
      AND gametypes.gametype_id=playerhandscashkeycolumns.gametype_id
GROUP BY gametypes.gametypedescription,gametypes.bigblind

It will output your winrate in bb/100 and SD in PTBB/100 (just for the sake of comparison with known values, you can remove the 2* if you prefer bb/100 for the SD as well). Don't forget to change your screenname. If you have several screenanems use :

Code:

WHERE playername ILIKE 'FirstName' OR playername ILIKE 'SecondName' etc.)

Anycall · 05-07-2008, 01:11 PM

I just purchased HM and it looks great.
However, I have encountered some problems when I tried across a few sites.

At NoIQ(Ipoker), table manager recognizes tables but HM's not grabbing any hands. I set the autoimport default folder as C:\Poker\NoIQ Poker\History. no HUD.

At Eurolinx, it's the same as NoIQ. no hands are being imported but tables are recognized. C:\Microgaming\Poker\EurolinxPokerMPP. no HUD

At Absolute, autoimport works well, stats are updated when I refreshed them.. But table manager doesn't recognize any tables. obv no HUD.
Anyone had similar problems? Thanks for your help in advance.