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