ProsperousOne
03-24-2009, 03:15 PM
I was querying my Holdem Manager Database with the PGADMIN program, and found a descrepancy vs. the info generated by Holdem Manager.
The simple sql query returns the number of hands and total profit for the hero since a specific date and time.
Here's the query:
-- replace "screen_name" with player's name
-- replace "after_date" with date in the form of "YYYY-MM-DD HH:MM:SS", where HH is hour in 24 hour format.
select count(playerhandscashkeycolumns_hero.netamountwon)
, sum(playerhandscashkeycolumns_hero.netamountwon) from players
, playerhandscashkeycolumns_hero where (players.playername = 'screen_name')
and (playerhandscashkeycolumns_hero.handtimestamp > 'after_date');
The results agree with the Hold'em Manager report, until the after_date is more than a few weeks old.
In my data base, with about 10,000 hands, and about February 15, the number of hands disagrees by 4, but the amout won differs by several hundred dollars.
I had a friend run the the same query in his database, and at about 35,000 hands and on March 12, 2009, he ran into a simiar problem; The hands differed by 900, and his profit was off by several hundred dollars.
There either appears to be a bug with HM, or my query is not structured correctly... I wonder which is correct? :rolleyes:
Any help would be greatly appreciated.
TIA!
P1
The simple sql query returns the number of hands and total profit for the hero since a specific date and time.
Here's the query:
-- replace "screen_name" with player's name
-- replace "after_date" with date in the form of "YYYY-MM-DD HH:MM:SS", where HH is hour in 24 hour format.
select count(playerhandscashkeycolumns_hero.netamountwon)
, sum(playerhandscashkeycolumns_hero.netamountwon) from players
, playerhandscashkeycolumns_hero where (players.playername = 'screen_name')
and (playerhandscashkeycolumns_hero.handtimestamp > 'after_date');
The results agree with the Hold'em Manager report, until the after_date is more than a few weeks old.
In my data base, with about 10,000 hands, and about February 15, the number of hands disagrees by 4, but the amout won differs by several hundred dollars.
I had a friend run the the same query in his database, and at about 35,000 hands and on March 12, 2009, he ran into a simiar problem; The hands differed by 900, and his profit was off by several hundred dollars.
There either appears to be a bug with HM, or my query is not structured correctly... I wonder which is correct? :rolleyes:
Any help would be greatly appreciated.
TIA!
P1