summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorschneefux <schneefux+commit@schneefux.xyz>2016-06-24 13:19:24 +0200
committerschneefux <schneefux+commit@schneefux.xyz>2016-06-24 13:19:24 +0200
commitfd2be561b96d1c4ea59d038aa164e712d33ee7f1 (patch)
treec0ef8294db51a6b01bc35944d6c9eedb94bdad67
parenteeeffa7945befb68ee24d2739b1c4c118cc714be (diff)
downloadjokevote-fd2be561b96d1c4ea59d038aa164e712d33ee7f1.tar.gz
jokevote-fd2be561b96d1c4ea59d038aa164e712d33ee7f1.zip
weight superuser's votes like user votes
-rw-r--r--app.py3
1 files changed, 2 insertions, 1 deletions
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