What is AP's id_site number in 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

What is AP's id_site number in PT3?

Postby feint06 » Tue Jan 06, 2009 12:01 pm

I'm trying to modify the rakeback stat (from repository) with my AP rakeback

sum(if[tourney_holdem_summary.id_site=300 ,tourney_holdem_summary.amt_rake * 0.27,if[tourney_holdem_summary.id_site=400 ,tourney_holdem_summary.amt_rake * 0.30,0]])



Also, does UB have a separate number?
feint06
 
Posts: 859
Joined: Fri Feb 01, 2008 10:18 pm

Re: What is AP's id_site number in PT3?

Postby WhiteRider » Tue Jan 06, 2009 12:14 pm

Cereus is 800, they are treated as one site by PT3.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: What is AP's id_site number in PT3?

Postby kraada » Tue Jan 06, 2009 12:14 pm

800 is the id_site for the CEREUS network; it isn't different for UB and AP.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: What is AP's id_site number in PT3?

Postby feint06 » Tue Jan 06, 2009 12:35 pm

Jinx? LOL thanks.

Does this look correct for 30%

sum(if[tourney_holdem_summary.id_site=300 ,tourney_holdem_summary.amt_rake * 0.27,if[tourney_holdem_summary.id_site=400 ,tourney_holdem_summary.amt_rake * 0.30,if[tourney_holdem_summary.id_site=800 ,tourney_holdem_summary.amt_rake * 0.30,0]]])
feint06
 
Posts: 859
Joined: Fri Feb 01, 2008 10:18 pm

Re: What is AP's id_site number in PT3?

Postby WhiteRider » Tue Jan 06, 2009 12:44 pm

Looks good..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 9 guests