diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-05-06 11:48:13 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-05-06 11:48:13 +0200 |
| commit | f8613dc45fed8f800f5053239364704e08ed7d29 (patch) | |
| tree | 5031fa8253fd0eb2ad2ecaabe65065f9bdd89b6e /crunch_team.sql | |
| parent | 79b3e8b0be084a22d4f30c5933935efe6ec1f743 (diff) | |
| download | cruncher-f8613dc45fed8f800f5053239364704e08ed7d29.tar.gz cruncher-f8613dc45fed8f800f5053239364704e08ed7d29.zip | |
blind fame formula hotfix
Diffstat (limited to 'crunch_team.sql')
| -rw-r--r-- | crunch_team.sql | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/crunch_team.sql b/crunch_team.sql index 4133cf4..fb94418 100644 --- a/crunch_team.sql +++ b/crunch_team.sql @@ -3,8 +3,15 @@ JOIN ( SELECT tm.id AS tm_id, SUM( - (1 + (tm_cnt-2) * 0.3) * - (p.winner * 0.3 + 0.7) * + (CASE + WHEN tm_cnt=1 THEN 0.33 + WHEN tm_cnt=2 THEN 0.66 + WHEN tm_cnt=3 THEN 1.33 + ) * + (CASE + WHEN p.winner THEN 1 + WHEN NOT p.winner THEN 0.7 + ) * (CASE WHEN tm.status='initiate' THEN 10 WHEN tm.status='member' THEN 75 |