Graph including rakeback

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Graph including rakeback

Postby JimmSlimm » Wed Apr 29, 2009 12:12 pm

Is there anyone out there who did this?

I made a little program myself to show this kind of graph but it doesnt work with splitted pots...

This is the query I am doing the graph with:
SELECT holdem_hand_player_detail.amt_bet_ttl, holdem_hand_summary.amt_pot, holdem_hand_summary.amt_rake, holdem_hand_summary.id_winner, holdem_hand_summary.cnt_players FROM holdem_hand_summary INNER JOIN holdem_hand_player_detail ON holdem_hand_player_detail.id_hand = holdem_hand_summary.id_hand WHERE holdem_hand_player_detail.id_player=" + id_player + " AND holdem_hand_summary.id_site=" + sSiteID + ""
JimmSlimm
 
Posts: 16
Joined: Tue Oct 14, 2008 5:32 pm

Re: Graph including rakeback

Postby kraada » Wed Apr 29, 2009 2:30 pm

Improved graphing is something we are planning on implementing, but I don't know when it will become available.

You might want to talk to alonalbert, who wrote Holdem Luck since that parses split pots properly; he might know quicker what to do to fix your application.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests