From 64d555ddee02481cac6fee07262d8c7d789fa5fd Mon Sep 17 00:00:00 2001
From: Scragly <29337040+scragly@users.noreply.github.com>
Date: Sun, 21 Apr 2019 20:03:18 +1000
Subject: Fix rank command.

---
 bot/seasons/easter/egg_hunt/cog.py | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'bot')

diff --git a/bot/seasons/easter/egg_hunt/cog.py b/bot/seasons/easter/egg_hunt/cog.py
index 56d4e71d..5120497b 100644
--- a/bot/seasons/easter/egg_hunt/cog.py
+++ b/bot/seasons/easter/egg_hunt/cog.py
@@ -482,8 +482,9 @@ class EggHunt(commands.Cog):
         db = sqlite3.connect(DB_PATH)
         c = db.cursor()
         c.execute(
-            f"SELECT RANK() OVER(ORDER BY score DESC) AS rank FROM user_scores "
-            f"WHERE user_id={member.id}"
+            "SELECT rank FROM "
+            "(SELECT RANK() OVER(ORDER BY score DESC) AS rank, user_id FROM user_scores)"
+            f"WHERE user_id = {member.id};"
         )
         result = c.fetchone()
         db.close()
-- 
cgit v1.2.3