@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.)
hq.recaptime.dev/wiki/Phorge
phorge
phabricator
1/* Migrate old badge quality transactions */
2
3UPDATE {$NAMESPACE}_badges.badges_transaction
4 SET oldValue = 140
5 WHERE oldValue = '"grey"' AND transactionType = 'badges:quality';
6
7UPDATE {$NAMESPACE}_badges.badges_transaction
8 SET oldValue = 120
9 WHERE oldValue = '"white"' AND transactionType = 'badges:quality';
10
11UPDATE {$NAMESPACE}_badges.badges_transaction
12 SET oldValue = 100
13 WHERE oldValue = '"green"' AND transactionType = 'badges:quality';
14
15UPDATE {$NAMESPACE}_badges.badges_transaction
16 SET oldValue = 80
17 WHERE oldValue = '"blue"' AND transactionType = 'badges:quality';
18
19UPDATE {$NAMESPACE}_badges.badges_transaction
20 SET oldValue = 60
21 WHERE oldValue = '"indigo"' AND transactionType = 'badges:quality';
22
23UPDATE {$NAMESPACE}_badges.badges_transaction
24 SET oldValue = 40
25 WHERE oldValue = '"orange"' AND transactionType = 'badges:quality';
26
27UPDATE {$NAMESPACE}_badges.badges_transaction
28 SET oldValue = 20
29 WHERE oldValue = '"yellow"' AND transactionType = 'badges:quality';
30
31
32
33UPDATE {$NAMESPACE}_badges.badges_transaction
34 SET newValue = 140
35 WHERE newValue = '"grey"' AND transactionType = 'badges:quality';
36
37UPDATE {$NAMESPACE}_badges.badges_transaction
38 SET newValue = 120
39 WHERE newValue = '"white"' AND transactionType = 'badges:quality';
40
41UPDATE {$NAMESPACE}_badges.badges_transaction
42 SET newValue = 100
43 WHERE newValue = '"green"' AND transactionType = 'badges:quality';
44
45UPDATE {$NAMESPACE}_badges.badges_transaction
46 SET newValue = 80
47 WHERE newValue = '"blue"' AND transactionType = 'badges:quality';
48
49UPDATE {$NAMESPACE}_badges.badges_transaction
50 SET newValue = 60
51 WHERE newValue = '"indigo"' AND transactionType = 'badges:quality';
52
53UPDATE {$NAMESPACE}_badges.badges_transaction
54 SET newValue = 40
55 WHERE newValue = '"orange"' AND transactionType = 'badges:quality';
56
57UPDATE {$NAMESPACE}_badges.badges_transaction
58 SET newValue = 20
59 WHERE newValue = '"yellow"' AND transactionType = 'badges:quality';