J'ai fait une custom stat pour les miles de winamasque (miles de base avant multiplicateur de statut) :
Citation :
<Stat GroupName="Default" ColumnName="Winamax Miles" ValueExpressions="
Sum((case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 10 and 19 then 0.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 20 and 29 then 0.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 30 and 39 then 0.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 40 and 49 then 0.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 50 and 59 then 0.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 60 and 69 then 0.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 70 and 79 then 0.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 80 and 89 then 0.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 90 and 99 then 0.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 100 and 109 then 1.0 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 110 and 119 then 1.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 120 and 129 then 1.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 130 and 139 then 1.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 140 and 149 then 1.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 150 and 159 then 1.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 160 and 169 then 1.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 170 and 179 then 1.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 180 and 189 then 1.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 190 and 199 then 1.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 200 and 209 then 2.0 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 210 and 219 then 2.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 220 and 229 then 2.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 230 and 239 then 2.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 240 and 249 then 2.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 250 and 259 then 2.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 260 and 269 then 2.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 270 and 279 then 2.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 280 and 289 then 2.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 290 and 299 then 2.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >=300 then 3 else 0 end))*1.67
as Winamiles" Evaluate="Winamiles" ColumnHeader="Winamax\nMiles" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Winamax miles earned" />
|
Cette stat c'est pour si on est bronze :
Citation :
<Stat GroupName="Default" ColumnName="Winamax Miles Bronze" ValueExpressions="
Sum((case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 10 and 19 then 0.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 20 and 29 then 0.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 30 and 39 then 0.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 40 and 49 then 0.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 50 and 59 then 0.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 60 and 69 then 0.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 70 and 79 then 0.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 80 and 89 then 0.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 90 and 99 then 0.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 100 and 109 then 1.0 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 110 and 119 then 1.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 120 and 129 then 1.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 130 and 139 then 1.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 140 and 149 then 1.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 150 and 159 then 1.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 160 and 169 then 1.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 170 and 179 then 1.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 180 and 189 then 1.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 190 and 199 then 1.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 200 and 209 then 2.0 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 210 and 219 then 2.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 220 and 229 then 2.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 230 and 239 then 2.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 240 and 249 then 2.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 250 and 259 then 2.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 260 and 269 then 2.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 270 and 279 then 2.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 280 and 289 then 2.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 290 and 299 then 2.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >=300 then 3 else 0 end))*1.67*1.25
as WinamilesBronze" Evaluate="WinamilesBronze" ColumnHeader="Winamax\nMiles Bronze" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Winamax miles bronze" />
|
Si jamais on est silver ou +, il suffit de changer le "*1.25" à la fin de l'avant dernière ligne par le multiplicateur souhaité. (le mieux c'est de copier tout le bloc et de changer les titres et tout pour faire une autre custom stat spéciale pour ce statut, si vous comprenez rien dites moi quel statut vous voulez je le fais)
A coller dans customstats.txt du dossier HEM/reports
Message édité par glod 2 le 08-01-2010 à 23:14:09