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
by makodim » Sun Oct 13, 2013 10:16 pm
how me can make stats for pt3, VPP pokerstars ?
or say me how me make this stats in pt3 = pt4 stats, sum((cash_hand_player_statistics.amt_bet_ttl / cash_hand_summary.amt_pot) * cash_hand_summary.amt_rake)
-
makodim
-
- Posts: 136
- Joined: Tue Jun 03, 2008 11:46 am
by WhiteRider » Mon Oct 14, 2013 2:55 am
The equivalent of the PT4 database table "cash_hand_player_statistics" is either "holdem_cash_hand_player_statistics" or "omaha_cash_hand_player_statistics", and also add holdem_ or omaha_ to the start of the "cash_hand_summary" table name.
e.g.
sum((holdem_cash_hand_player_statistics.amt_bet_ttl / holdem_cash_hand_summary.amt_pot) * holdem_cash_hand_summary.amt_rake)
-
WhiteRider
- Moderator
-
- Posts: 53972
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by kraada » Mon Oct 14, 2013 7:31 am
Not all required data exists in the PT3 database though - there's no limit currency so you won't be able to differentiate by currency stake in PT3.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 16 guests