Page 1 of 1

What is AP's id_site number in PT3?

PostPosted: Tue Jan 06, 2009 12:01 pm
by feint06
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?

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

PostPosted: Tue Jan 06, 2009 12:14 pm
by WhiteRider
Cereus is 800, they are treated as one site by PT3.

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

PostPosted: Tue Jan 06, 2009 12:14 pm
by kraada
800 is the id_site for the CEREUS network; it isn't different for UB and AP.

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

PostPosted: Tue Jan 06, 2009 12:35 pm
by feint06
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]]])

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

PostPosted: Tue Jan 06, 2009 12:44 pm
by WhiteRider
Looks good..