Rakeback custom stats depending on playing during happy hour

[NastyRabbit]

Hi, i'm playing on winamax .fr and want to create a custom rakeback stat.

The ususal rakeback expression is this one : amt_rake_contributed * 4 * (your status coefficient)

But during happy hours ( 7pm>8.30pm and 0am>1.30am) rakeback is multiplicate by 1.5.


Is there a way i can create that custom stat ?

[kraada]

Yes, the date a hand was played is cash_hand_player_statistics.date_played - you can extract the time from there.

date_played is between the intervals you want when the following is true:

extract(hour from cash_hand_player_statistics.date_played) = 19 OR extract(hour from cash_hand_player_statistics.date_played) = 0 OR
(extract(hour from cash_hand_player_statistics.date_played) = 20 AND extract(minute from cash_hand_player_statistics.date_played) < 30) OR (extract(hour from cash_hand_player_statistics.date_played) = 1 AND extract(minute from cash_hand_player_statistics.date_played) < 30)

The easiest thing to do is probably create a separate rakeback column using the normal rakeback value and the above addition just for happy hour bonus then you can track it separately or create a separate statistic to add it to the non-happy hour values.