@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
1UPDATE {$NAMESPACE}_herald.herald_action a
2 JOIN {$NAMESPACE}_herald.herald_rule r
3 ON a.ruleID = r.id
4 SET a.action = 'subscribers.add'
5 WHERE r.ruleType != 'personal'
6 AND a.action = 'addcc';
7
8UPDATE {$NAMESPACE}_herald.herald_action a
9 JOIN {$NAMESPACE}_herald.herald_rule r
10 ON a.ruleID = r.id
11 SET a.action = 'subscribers.self.add'
12 WHERE r.ruleType = 'personal'
13 AND a.action = 'addcc';
14
15UPDATE {$NAMESPACE}_herald.herald_action a
16 JOIN {$NAMESPACE}_herald.herald_rule r
17 ON a.ruleID = r.id
18 SET a.action = 'subscribers.remove'
19 WHERE r.ruleType != 'personal'
20 AND a.action = 'remcc';
21
22UPDATE {$NAMESPACE}_herald.herald_action a
23 JOIN {$NAMESPACE}_herald.herald_rule r
24 ON a.ruleID = r.id
25 SET a.action = 'subscribers.self.remove'
26 WHERE r.ruleType = 'personal'
27 AND a.action = 'remcc';