From 879db7012c1c77891895c227ab4094bea8a29ff1 Mon Sep 17 00:00:00 2001 From: Johannes Löthberg Date: Tue, 13 Mar 2018 21:04:31 +0100 Subject: notify: Send vote reminders to TUs that are also devs MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Johannes Löthberg Signed-off-by: Lukas Fleischer --- aurweb/scripts/notify.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'aurweb/scripts') diff --git a/aurweb/scripts/notify.py b/aurweb/scripts/notify.py index 2d0f7575..693abffc 100755 --- a/aurweb/scripts/notify.py +++ b/aurweb/scripts/notify.py @@ -140,7 +140,7 @@ def get_request_recipients(conn, reqid): def get_tu_vote_reminder_recipients(conn, vote_id): cur = conn.execute('SELECT Email FROM Users ' + - 'WHERE AccountTypeID = 2 AND ID NOT IN ' + + 'WHERE AccountTypeID IN (2, 4) AND ID NOT IN ' + '(SELECT UserID FROM TU_Votes ' + 'WHERE TU_Votes.VoteID = ?)', [vote_id]) return [row[0] for row in cur.fetchall()] -- cgit v1.2.3-24-g4f1b