vpp pt3

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

vpp pt3

Postby 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

Re: vpp pt3

Postby 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

Re: vpp pt3

Postby 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]

Who is online

Users browsing this forum: No registered users and 16 guests

cron