Notifications
Clear all
PokerStars
103
Posts
43
Users
0
Reactions
20.6 K
Views
Originally posted by EmanuelC16
Originally posted by bazerk
This may be dumb, but it seems like logic to me, (maybe I'm dumb), but would lowering requirements for status levels be a good idea?SNG and MTT players are not affected by these rake changes.
They can't mess with requirements.
They can change rake and VPP multipliers/table like some people already suggsested.
I just noticed I get less VPP/sng though... Where I used to get 0.99VPP per $1.5 sng I played, apprently I only get 0.95VPP per sng now. I don't know if this has something to do with the rake changes, or because Belgians will get a different VPP deal.
EDIT: Apparently it's a Belgian thing 
Just have to point out some things:
FTP changed to WC and players moved to stars. Now they can't escape.
The "nits" is going to get better and play lag instead. Which happend at FT
FTP still have worse rakeback/cashback
Multi tabling FR FLH is pretty much dead through this change!
I played 1012 hands yesterday earning 42 vpp's, last year that would have been 82, that almost 50% decrease!!
So no more 16 tabling since there really is no incentive for that anymore. Profits that's all that counts, so it will be BUMPHUNTING * BUMPHUNTING and play far less tables.
It's a loose/loose situation in general.
Everybody, lets go to Cake or Everest there is where they still have a dealt method.
Originally posted by Yoghurt1973
Fishes don't care! They just want to play and see showdowns.
And they're unhappy that you always show set and/or QQ+
Anyway useless to discuss what has already been implemented. So leave Stars! 
I played 3k hands of 5PLO SH today - before I would have earned ~250vpps but today I just had 97. Lol, I don't even think I could reach gold status at this pace.
The games haven't changed though. Yes I am a nit but I won't loosen up just to earn rb
Funny how these so called LAGs are rejoicing and want the nits to go away. Truth is, they don't want the nits to stay and loosen up and start playing back at them. It will make the games tougher for them imo. They just want them to go away. Lol.
Originally posted by sp00nman
I played 3k hands of 5PLO SH today - before I would have earned ~250vpps but today I just had 97. Lol, I don't even think I could reach gold status at this pace.The games haven't changed though. Yes I am a nit but I won't loosen up just to earn rb
Funny how these so called LAGs are rejoicing and want the nits to go away. Truth is, they don't want the nits to stay and loosen up and start playing back at them. It will make the games tougher for them imo. They just want them to go away. Lol.
Guess you are a fish too, putting me on that range with no reads.
Of course i will valuetown with middle pair most of the time....tsss ^^
I did the sit out yesterday and now I can't withdraw. What is that supposed to mean?
Originally posted by pokerski
I did the sit out yesterday and now I can't withdraw. What is that supposed to mean?
Means you broke PokerStars' Terms and Conditions and they could confiscate your funds. I don't think they'll do that but they're restricting you from doing anything until the whole sit-out thing gets thrown off the tables for good.
Best thing you can do is contact support about it.
Good luck!
Originally posted by EmanuelC16
Originally posted by pokerski
I did the sit out yesterday and now I can't withdraw. What is that supposed to mean?Means you broke PokerStars' Terms and Conditions and they could confiscate your funds. I don't think they'll do that but they're restricting you from doing anything until the whole sit-out thing gets thrown off the tables for good.
Best thing you can do is contact support about it.
Good luck!
This.
I believe Stars rep mentioned that things like this would happen if the sit out occured as it was completely against their terms and conditions.
Hope everything gets resolved soon and in a peaceful and amicable manner.
Best regards,
Gary
Originally posted by HollyMichelle
Originally posted by EmanuelC16
Originally posted by pokerski
I did the sit out yesterday and now I can't withdraw. What is that supposed to mean?Means you broke PokerStars' Terms and Conditions and they could confiscate your funds. I don't think they'll do that but they're restricting you from doing anything until the whole sit-out thing gets thrown off the tables for good.
Best thing you can do is contact support about it.
Good luck!
This.
I believe Stars rep mentioned that things like this would happen if the sit out occured as it was completely against their terms and conditions.
Hope everything gets resolved soon and in a peaceful and amicable manner.
Best regards,
Gary
They didn't notify me about this through email. How could I know, I was just using their software option.
What is next? Using the "fold" button to much? " You click the fold button to much, we will unable you to cash out until you loosen up " This is ridiculous.
There was notification in the 2+2 thread where this mass sit out was organised.
It came from PokerStarsSteve and it was just about an hour before the sit-out started.
I'm not taking sides here at all, so if you feel you have been unduly punished I suggest taking it up with PokerStars support in a friendly manner.
Best regards,
Gary
Hi,
I'm trying to run the script to calculate how many VPPs I will get now but it doesn't work 
"Query is running"... And it has been like that for 4-5h ♦ Tried twice. Why doesn't it work?
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", sum(round(b.rakeamount))/100.0 as "Rake dealt",
sum ( round(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;
Samy