PDA

View Full Version : VIP points of Ongame (winamax)



squalzen
06-03-2009, 05:48 PM
Heuu...

On ongame networks the VIP points are calculated like this !

The miles

In cash game, every players having participated in the pot win 1.67 points per raked $
The maximum rake per flop is 3$
All player win the same amount of miles even if they have only paid the BB and even if they have fold at the flop.

Example: Pot 40$ -> rake = 2$ -> So every players having participed in the pot will win 3,34 Miles (2$ * 1.67).


The rake:

In cash game, the rake is 5%. It can't be more than 3$ on tables with more than 5 players whatever is the amount of the pot. On tables with 2 players the maximum amout raked is 1$. On tables with 3, 4 ou 5 players the maximum amount raked is 2$ per pot.

In holdem manager, I don't know how the Rake column is calculated. Does it come from the imported hands or does it calculated ?

So to apply this to ongame networks room, we have to know the total raked amount per pot and multiply it per 1.67 (not our part but the total raked amount taken by the room)

or if HoldemManager doesn't calculated the good rakeAmount does it oursefl
FinalPotSize*0.05*1.67


We could do something like this :


Stat GroupName="Default" ColumnName="OngameMiles" ValueExpressions="sum(case when PH.didvpip = TRUE or PH.PositionType_ID < 2 and PKH.numberofplayerssawflop > 1 then (((PKH.potsize+PKH.rakeamount)*0.05*1.67)/100) else 0 end) as OngameMiles" Evaluate="OngameMiles" ColumnHeader="OngameMiles" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Ongame Miles" />

Looking the database the table POKERHANDS seems to hold the good data.
BUT For ongame network the RAKEAMOUNT in this room is NOT well defined. Indeed we don't have Potsize*5% = rakeamount !!!!

For example I'have done this SQL query

select handtimestamp, numberofplayerssawflop, potsize, rakeamount, potsize+rakeamount as potsizetot, (potsize+rakeamount)*5.0/100 as rakeCalc from pokerhands where site_id=9 and gametype_id = 9 and numberofplayerssawflop > 0 order by handtimestamp

And I don't find the result we should

For example


handtimestamp NbrPlrSawFlop potsize rakeamount potsizetot rakecalc
22/05/2009 14:30 3 225 5 230 11,50
22/05/2009 14:31 3 162 8 170 8,50
22/05/2009 14:33 2 1445 53 1498 74,90
22/05/2009 14:33 2 156 4 160 8,00
22/05/2009 14:35 3 48 2 50 2,50
22/05/2009 14:35 4 38 2 40 2,00
22/05/2009 14:36 4 190 10 200 10,00
22/05/2009 14:38 3 216 4 220 11,00
22/05/2009 14:39 3 162 8 170 8,50



So we can't use the rake amount, and using the (potsize+rake amount)*5%*1.67 doesn't give me same result than on my poker room


Stat GroupName="Default" ColumnName="OngameMiles" ValueExpressions="sum(case when PH.didvpip = TRUE or PH.PositionType_ID < 2 and PKH.numberofplayerssawflop > 1 then (((PKH.potsize+PKH.rakeamount)*0.05*1.67)/100) else 0 end) as OngameMiles" Evaluate="OngameMiles" ColumnHeader="OngameMiles" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Ongame Miles" />

And here I don't understand why !!

SO more information is need from HM or HM guru


Pascal

squalzen
06-05-2009, 01:42 PM
Hmm this one is very near ongame site reports me


Stat GroupName="Default" ColumnName="OngameMiles" ValueExpressions="sum(case when PH.player_id = 17 and (PH.positiontype_id < 2 or PH.didvpip = true) and PH.maxstreetseen > 1 then PKH.potsize+PKH.rakeamount else 0 end) as totsizepotplayed" Evaluate="(totsizepotplayed*0.05*1.67)/100" ColumnHeader="OngameMiles" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Ongame Miles" />