From fd2be561b96d1c4ea59d038aa164e712d33ee7f1 Mon Sep 17 00:00:00 2001 From: schneefux Date: Fri, 24 Jun 2016 13:19:24 +0200 Subject: weight superuser's votes like user votes --- app.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/app.py b/app.py index 9f8a38d..ce6b042 100644 --- a/app.py +++ b/app.py @@ -291,7 +291,8 @@ class DBProxy(object): def score(self, jokeid): users = self.c.execute("SELECT id FROM " + self.prefix + - "_users WHERE role='user'").fetchall() + "_users WHERE role='user' " + + "OR role='super'").fetchall() users = [u['id'] for u in users] votewhere = "SELECT COUNT(*) FROM " + self.prefix + "_votes WHERE " # TODO optimize queries -- cgit v1.3.1