forked from stadust/pointercrate
-
Notifications
You must be signed in to change notification settings - Fork 1
/
20220601192100_extended_list_buff.down.sql
38 lines (31 loc) · 1.99 KB
/
20220601192100_extended_list_buff.down.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
-- Your SQL goes here
CREATE OR REPLACE FUNCTION record_score(progress FLOAT, demon FLOAT, list_size FLOAT, requirement FLOAT) RETURNS FLOAT AS
$record_score$
SELECT CASE
WHEN progress = 100 THEN
CASE
WHEN 125 < demon AND demon <= 150 THEN
150.0 * EXP(((1.0 - demon) * LN(1.0 / 30.0)) / -149.0)
WHEN 50 < demon AND demon <= 125 THEN
60 * (EXP(LN(2.333) * ((51.0 - demon) * (LN(30.0) / 99.0)))) + 1.884
WHEN 20 < demon AND demon <= 50 THEN
-100.0 * (EXP(LN(1.01327) * (demon - 26.489))) + 200.0
WHEN demon <= 20 THEN
(250 - 100.39) * (EXP(LN(1.168) * (1 - demon))) + 100.39
END
WHEN progress < requirement THEN
0.0
ELSE
CASE
WHEN 125 < demon AND demon <= 150 THEN
150.0 * EXP(((1.0 - demon) * LN(1.0 / 30.0)) / -149.0) * (EXP(LN(5) * (progress - requirement) / (100 - requirement))) / 10
WHEN 50 < demon AND demon <= 125 THEN
(60 * (EXP(LN(2.333) * ((51.0 - demon) * (LN(30.0) / 99.0)))) + 1.884) * (EXP(LN(5) * (progress - requirement) / (100 - requirement))) / 10
WHEN 20 < demon AND demon <= 50 THEN
(-100.0 * (EXP(LN(1.01327) * (demon - 26.489))) + 200.0) * (EXP(LN(5) * (progress - requirement) / (100 - requirement))) / 10
WHEN demon <= 20 THEN
((250 - 100.39) * (EXP(LN(1.168) * (1 - demon))) + 100.39) * (EXP(LN(5) * (progress - requirement) / (100 - requirement))) / 10
END
END;
$record_score$
LANGUAGE SQL IMMUTABLE;