From 213bf999b9bc5e6a1cabe6486ffda28541601f74 Mon Sep 17 00:00:00 2001 From: jesopo Date: Thu, 9 Aug 2018 13:49:44 +0100 Subject: Changed find_all_by_setting to not return setting, added !richest --- Database.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'Database.py') diff --git a/Database.py b/Database.py index 8e698bc7..b2529b2a 100644 --- a/Database.py +++ b/Database.py @@ -132,12 +132,12 @@ class UserSettings(Table): return default def find_all_by_setting(self, server_id, setting, default=[]): values = self.database.execute_fetchall( - """SELECT nickname, setting, value FROM user_settings WHERE + """SELECT nickname, value FROM user_settings WHERE server_id=? AND setting=?""", [server_id, setting]) if values: for i, value in enumerate(values): - values[i] = value[0], value[1], json.loads(value[2]) + values[i] = value[0], json.loads(value[1]) return values return default def find(self, server_id, nickname, pattern, default=[]): -- cgit v1.3.1-10-gc9f91