Up after a heavy night drinking.. Anyone know if WC method has been implicated into the games yet? Probaly going to see the difference in vpps before deciding I reckon.
Happy New Year to everyone and Good luck for the chase!
Any idea if holdem manager displays them correctly ?
Quote:
Originally Posted by PokerStars Steve
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.
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;
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.
It's so pathetic to behold the number of selfish players supporting Pokerstars's rapaciousness.
You have the means to put pressure on Pokerstars's cupidity, yet you prefer to close your eyes.
Wouldn't you guys give preference to a 4% rake over 5%?
Don't forget that in the middle of difficulty lies opportunity.
Nothing ventured, nothing gained, what do you have to lose? What about a sit-out today?
Cheers to a happy new year.
Sorry, but I can't bear to watch PS tearing down the game we're used to loving.