PokerStars.com VIP Program and Ring Game Rake Changes effective January 1, 2012
12-30-2011
, 08:05 PM
12-30-2011
, 08:09 PM
12-30-2011
, 08:19 PM
12-30-2011
, 08:32 PM
+1 for Hood.
Need FL representative there too
Need FL representative there too
12-30-2011
, 08:44 PM
12-30-2011
, 09:00 PM
12-30-2011
, 09:14 PM
For users of Hold'em Manager, the below procedure will show you the difference in VPP earnings between weighed contributed and dealt. It should take about five minutes.
1. Open PGAdmin III from your Postgres folder.
2. Connect to your local PostgreSQL server by right clicking and selecting Connect.'
If you are prompted for a Username and Password, the default username is usually 'postgres'. The default password will either be 'postgrespass' or dbpass'.
3. Once connected, click on your HoldemManager database. This is usually 'HoldemManager'. Then, with this database highlighted, click on the icon that shows a piece of paper with 'SQL' written on it. This will open a new window with some text.
4. Highlight all of the text in this window, and paste the following code into the window.
5. Once you have done this, press 'F5'. PostgreSQL will run for a short period of time and then display your rake under the Dealt method and the Weighted Contributed method in the screen below.
This code was kindly provided by 2p2 member GobletTamer.
1. Open PGAdmin III from your Postgres folder.
2. Connect to your local PostgreSQL server by right clicking and selecting Connect.'
If you are prompted for a Username and Password, the default username is usually 'postgres'. The default password will either be 'postgrespass' or dbpass'.
3. Once connected, click on your HoldemManager database. This is usually 'HoldemManager'. Then, with this database highlighted, click on the icon that shows a piece of paper with 'SQL' written on it. This will open a new window with some text.
4. Highlight all of the text in this window, and paste the following code into the window.
Code:
create or replace function amountPreflopInvested(tn playerhandscashmisc, pkh_id integer) returns integer AS $$ DECLARE amount integer := 0; other integer := 0; BEGIN amount := tn.postamountpreflop + tn.betamountpreflop + tn.callamountpreflop; select max(pre.postamountpreflop + pre.betamountpreflop + pre.callamountpreflop) into other from pokerhands join playerhandscashkeycolumns using (pokerhand_id) join playerhandscashmisc pre using (playerhand_id) where pokerhand_id=pkh_id and not ishero; return least(amount, other); END; $$ language plpgsql; create or replace function amountFlopInvested(tn playerhandsflop, pkh_id integer) returns integer AS $$ DECLARE amount integer := 0; other integer := 0; BEGIN amount := tn.betamount + tn.callamount; select max(flop.betamount+flop.callamount) into other from pokerhands join playerhandscashkeycolumns using (pokerhand_id) join playerhandscashmisc using (playerhand_id) join playerhandsflop flop using(playerhand_id) where pokerhand_id=pkh_id and not ishero; return least(amount, other); END; $$ language plpgsql; create or replace function amountTurnInvested(tn playerhandsturn, pkh_id integer) returns integer AS $$ DECLARE amount integer := 0; other integer := 0; BEGIN amount := tn.betamount + tn.callamount; select max(turn.betamount+turn.callamount) into other from pokerhands join playerhandscashkeycolumns using (pokerhand_id) join playerhandscashmisc using (playerhand_id) join playerhandsturn turn using(playerhand_id) where pokerhand_id=pkh_id and not ishero; return least(amount, other); END; $$ language plpgsql; create or replace function amountRiverInvested(tn playerhandsriver, pkh_id integer) returns integer AS $$ DECLARE amount integer := 0; other integer := 0; BEGIN amount := tn.betamount + tn.callamount; select max(river.betamount+river.callamount) into other from pokerhands join playerhandscashkeycolumns using (pokerhand_id) join playerhandscashmisc using (playerhand_id) join playerhandsriver river using(playerhand_id) where pokerhand_id=pkh_id and not ishero; return least(amount, other); END; $$ language plpgsql; select count(*) as "Hands", round(sum(a.rakeamount/a.numberofplayers))/100.0 as "Rake dealt", round ( sum(a.rakeamount * 1.* ( case when (b.maxstreetseen=0 or b.streetwentallin=1) then (amountPreflopInvested(c, a.pokerhand_id)) when (b.maxstreetseen=1 or b.streetwentallin=2) then (c.postamountpreflop + c.betamountpreflop + c.callamountpreflop + amountFlopInvested(f, a.pokerhand_id)) when (b.maxstreetseen=2 or b.streetwentallin=3) then (c.postamountpreflop + c.betamountpreflop + c.callamountpreflop + f.betamount + f.callamount + amountTurnInvested(t, a.pokerhand_id)) else (c.postamountpreflop + c.betamountpreflop + c.callamountpreflop + f.betamount + f.callamount + t.betamount + t.callamount + amountRiverInvested(r, a.pokerhand_id)) end ) / (a.potsize)) ) / 100.0 as "WC Rake" from pokerhands a join playerhandscashkeycolumns b using (pokerhand_id) join playerhandscashmisc c using (playerhand_id) left join playerhandsflop f using(playerhand_id) left join playerhandsturn t using(playerhand_id) left join playerhandsriver r using (playerhand_id) where ishero and potsize>0 and a.handtimestamp>'2011-01-01 00:00:00' and a.site_id=2;
This code was kindly provided by 2p2 member GobletTamer.
12-30-2011
, 09:28 PM
12-30-2011
, 09:28 PM
