|
#1
|
|||
|
|||
Re: what is the program that corrects the rake you have paid from PT?
poker grapher
|
#2
|
|||
|
|||
Re: what is the program that corrects the rake you have paid from PT?
[ QUOTE ]
poker grapher [/ QUOTE ] Does anyone know a program that works with PostgreSQL databases? |
#3
|
|||
|
|||
Re: what is the program that corrects the rake you have paid from PT?
[ QUOTE ]
[ QUOTE ] poker grapher [/ QUOTE ] Does anyone know a program that works with PostgreSQL databases? [/ QUOTE ] I think there are some SQL statements that will work with PostgresSQL. I can't remember if they are here on the PT forum. |
#4
|
|||
|
|||
Re: what is the program that corrects the rake you have paid from PT?
Here is the scipt, someone else will have to show you how to use them if you don't know.
select sum(rake / (select count(played_hand) from game_players gp where played_hand = 'Y' and gp.game_id = g.game_id)) as MGR, sum(rake / (select count(played_hand) from game_players gp where played_hand = 'Y' and gp.game_id = g.game_id)) * RAKEBACK as rakeback from game g where (select played_hand from game_players gp where player_id = (select player_id from players where screen_name = 'SCREENNAME') and gp.game_id = g.game_id) = 'Y' and date_part('month', g.date_played) = MONTH Few things: - Change RAKEBACK to a numerical value representing the rakeback percent you get. ie. if you get 25%, change it to 0.25 - Change SCREENNAME to your screenname. ie. if your screenname is DERB, then change it to DERB (leave the quotes there) - Change MONTH to a number from 1-12 representing the month you want to look at. ie. if you want to see your rakeback for this month so far (november) change it to 11 |
#5
|
|||
|
|||
Re: what is the program that corrects the rake you have paid from PT?
is poker grapher still available?
i went to the site and it says work has stopped on the project. |
#6
|
|||
|
|||
Re: what is the program that corrects the rake you have paid from PT?
look up poker patterns or pokerpatterns, it's the new poker grapher
|
#7
|
|||
|
|||
Re: what is the program that corrects the rake you have paid from PT?
dont think PG displays rake info at all?
|
#8
|
|||
|
|||
Re: what is the program that corrects the rake you have paid from PT?
[ QUOTE ]
is poker grapher still available? i went to the site and it says work has stopped on the project. [/ QUOTE ] It's hosted here: www.overcards.com |
#9
|
|||
|
|||
Re: what is the program that corrects the rake you have paid from PT?
thanks, found it - exactly what i was after.
so the rake calc section of poker grapher precicely provides MGR, just to confirm? cheers! |
|
|