*** Mass Sitout - Pokerstars - Jan 1st - Details Thread ***
12-30-2011
, 09:18 PM
Also, for those of you who haven't already seen Goblet's post and calculated how this change will affect you; Steve has now posted it again with added screenshots to help.
Remember, in compliance with the Mod's request, please do not post in this thread unless it is to quote the allowed bump. Please continue all discussion on the main Sitout thread HERE and I will do my best to relay the main points here.
Quote:
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.
