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

Melchiades · 05-25-2008, 01:08 PM

Quote:

Originally Posted by steel108

A great stat is how often someone folds their steal to a 3 bet

+2

peyote · 05-25-2008, 01:34 PM

Roy, I read here that the mgr (rake) number in the report includes the BBJ contributions at Party. I need this number without it to track the unmentionable

I've written a sql statement to get the BBJ contribution so I can subtract it from the mgr. How can I run it as a custom report/stat and does it look correct?

Code:

SELECT SUM(50.0/numberofplayers)/100.0 AS bbj 
 FROM playerhandscashkeycolumns 
  WHERE player_id = 123456
   AND pokerhand_id IN 
    (SELECT pokerhand_id FROM pokerhands p, tables t
      WHERE p.table_id = t.table_id
       AND t.tablename LIKE 'Jackpot%'
       AND p.handtimestamp >= '2008-05-01 00:00:00'
       AND numberofplayers >= 4)
   AND rakeamount >= 100.0 / numberofplayers

willwonka · 05-25-2008, 02:05 PM

Quote:

Originally Posted by Dread Wings

I did the same thing.

I'm glad I wasn't the only person to do this...

stupandaus · 05-25-2008, 03:25 PM

Quote:

Make sure you installed the full install and also make sure you have .net 2.0 installed properly.

I initially installed .net 3.5 before realizing .net 2.0 was required. Is that an issue? I uninstalled .net 3.5 and downloaded .net 2.0 to install it, but during installation I get an error message saying this installation of .net is not compatible with a previous version. Please help!

effang · 05-25-2008, 03:41 PM

Quote:

Originally Posted by rvg72

If you go to Control Panel - Admin - Services do you see postgresql there? If so right click and hit start. If not then reinstall it and when you get to the part of the install that has a check box for "initialize cluster" uncheck that. You should then be able to reattach to the DB (hopefully)

Roy

Roy,

I did this. This prompt followed after completion...

"the postgreSQL database server 8.3 service on Local Computer started and then stopped Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

i then proceeded to do what you told me before, see if i can access the server from pgAdmin III, but still no luck.

I am waiting on your word to reinstall...

http://wwwmaster.postgresql.org/down...ql-8.3.0-1.zip

Edit:

i downloaded this version, and installed it. but no luck, and i never got a "cluster" notice...is this the wrong version?

thanks

**_dave_** · 05-25-2008, 04:41 PM

Quote:

i downloaded this version, and installed it. but no luck, and i never got a "cluster" notice...is this the wrong version?

you need whatever version you were running prior to the crash.

I'm presuming you didn't do a postgresql backup (dump) recently? that would make things easy.

FrogMouth · 05-25-2008, 04:48 PM

I have been checking my stats for the last 5 months (120k hands) and it takes forever to refresh the stats. It easliy takes 5 minutes every time I make a change or refresh the filters. I just vacumed the DB and that was no help, and my comp is pretty decent 1.66 Intel Duo & 1.5gb ram. Is there something I'm doing wrong? Is there anything I can do to speed it up?

Thanks for a great product BTW!

effang · 05-25-2008, 05:00 PM

Quote:

Originally Posted by _dave_

you need whatever version you were running prior to the crash.

I'm presuming you didn't do a postgresql backup (dump) recently? that would make things easy.

nope...did not.

ok, i uninstalled, and tried reinstalling again.

regardless of what i'm trying to do, i can't get past the Service Configuration page...

I do not know why it isn't accepting my account password...i have tried every possible combination.

so...yeah stuck on that. would it be helpful/beneficial at all if i created a new account name instead of "postgres"?

rvg72 · 05-25-2008, 05:25 PM

Quote:

Originally Posted by peyote

Roy, I read here that the mgr (rake) number in the report includes the BBJ contributions at Party. I need this number without it to track the unmentionable

I've written a sql statement to get the BBJ contribution so I can subtract it from the mgr. How can I run it as a custom report/stat and does it look correct?

Code:

SELECT SUM(50.0/numberofplayers)/100.0 AS bbj 
 FROM playerhandscashkeycolumns 
  WHERE player_id = 123456
   AND pokerhand_id IN 
    (SELECT pokerhand_id FROM pokerhands p, tables t
      WHERE p.table_id = t.table_id
       AND t.tablename LIKE 'Jackpot%'
       AND p.handtimestamp >= '2008-05-01 00:00:00'
       AND numberofplayers >= 4)
   AND rakeamount >= 100.0 / numberofplayers

I actually found a bug with rake calcs that I'll need to fix - your rake will be a little less than actual with the current formula when I import hands. Anyways, here are 2 custom stats, one for the fixed rake paid and one for fixed rake paid wo BBJ. Put these in your customstats.txt file

<Stat ColumnName="Fixed Rake" ValueExpressions="sum((PKH.rakeamount)/100.0/PKH.numberofplayers) as totalfixedrake" Evaluate="TotalFixedRake" ColumnHeader="Rake*" ColumnFormat="$0.00" ColumnWidth="60" Tooltip="Rake with bug fixed" />

<Stat ColumnName="Rake wo BBJ" ValueExpressions="sum((PKH.rakeamount - case when TABLES.Tablename like 'Jackpot%' and PKH.rakeamount >= 50 then 50 else 0 end)/100.0/PKH.numberofplayers) as totalrakewobbj" Evaluate="TotalRakewoBBJ" ColumnHeader="Rake wo BBJ" ColumnFormat="$0.00" ColumnWidth="60" Tooltip="Rake without BBJ" />

Quote:

I initially installed .net 3.5 before realizing .net 2.0 was required. Is that an issue? I uninstalled .net 3.5 and downloaded .net 2.0 to install it, but during installation I get an error message saying this installation of .net is not compatible with a previous version. Please help!

Try reinstalling 3.5 - I believe it should all be backwards compatible.

Quote:

nope...did not.

ok, i uninstalled, and tried reinstalling again.

regardless of what i'm trying to do, i can't get past the Service Configuration page...

I do not know why it isn't accepting my account password...i have tried every possible combination.

so...yeah stuck on that. would it be helpful/beneficial at all if i created a new account name instead of "postgres"?

Dave might have a better answer but you should be able to change it from postgres to say postgresEffang and then continue with the installation.

Quote:

I have been checking my stats for the last 5 months (120k hands) and it takes forever to refresh the stats. It easliy takes 5 minutes every time I make a change or refresh the filters. I just vacumed the DB and that was no help, and my comp is pretty decent 1.66 Intel Duo & 1.5gb ram. Is there something I'm doing wrong? Is there anything I can do to speed it up?

Thanks for a great product BTW!

Can you try going into pgadmin and typing "analyze". This will analyze all the tables and hopefully get postgres using the right decision trees when grabbing info. I've heard of a few people with similar issues.

Also, some stats force joining of more tables which can definitely slow things down. Try just returning total amount won and see if that still take a few minutes or if it comes back immediately to help narrow down the issue.

Roy

rvg72 · 05-25-2008, 05:30 PM

Still working on 1.05.08c but just about done so should be releasing tonight. Here is the change list so far

* (1.05.08c BUG) Fixed issue with FTP 9-max cash games appearing as 10-max in the hud and positioning would be off
* (1.05.08c NEW) Added Check Raise Flop as PFR, as 3bet, Check Raise raised flop
* (1.05.08c NEW) Added many default .popup files and assigned them to all of the stats
* (1.05.08c NEW) Rebuilt the HUD Popup form to make things easier to use and added all of the recent stats. Please note, Default popups can not be edited however they can now be cloned and the clone can be edited. This is because we will be updating the defaults with more stats in future releases and do not want to overwrite your changes.
* (1.05.08c NEW) Added the option to have multiple lines per panel when using multi panels
* (1.05.08c BUG) Fixed bug when using mouse over popups. When going from one stat to the next, if they had the same panel the second one would appear blank.
* (1.05.08c BUG) Fixed full ring in the replayer - in the last build the positions of everything is off.

**_dave_** · 05-25-2008, 05:33 PM

Quote:

I do not know why it isn't accepting my account password...i have tried every possible combination.

It is asking for a postgres password during postgres installation? or is this holdem manager?

What kind of crash did you have... I was assuming up until this point you had formatted / reinstalled windows - not so?

fozzy71 · 05-25-2008, 05:36 PM

default password possibilities = postgrespass , dbpass .

rvg72 · 05-25-2008, 05:41 PM

Quote:

Originally Posted by fozzy71

default password possibilities = postgrespass , dbpass .

I think he's referring to the postgres setup screen where sometimes the postgres account already exists from a previous installation and it gets all goofy unless you change the username from postgres to something else.

Roy

fozzy71 · 05-25-2008, 05:43 PM

I C - I was multi-tasking while attempting to post that one sentence. And saw about 5 new posts afterwards, that taught me my reading comprehension needs some work.

effang · 05-25-2008, 05:44 PM

Quote:

Originally Posted by rvg72

Dave might have a better answer but you should be able to change it from postgres to say postgresEffang and then continue with the installation.

Roy

Ok, hell yes!!! i am not sure what i did, or what happened, but HM finally opened.

options, notes, exports notes...and i'm set?
i can now reformat, reinstall everything, and then import? no issues at all (no going back after this)...

Thanks!!!