From f23e018224a9d9a59ec1ca7b9192a893d63cb135 Mon Sep 17 00:00:00 2001
From: Georgios Atheridis <atheridis@tutamail.com>
Date: Tue, 10 May 2022 08:54:23 +0000
Subject: [PATCH] fixed bug on moveup and down

---
 skgyorugo/commands/movedown.py | 8 ++++----
 skgyorugo/commands/moveup.py   | 8 ++++----
 2 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/skgyorugo/commands/movedown.py b/skgyorugo/commands/movedown.py
index df3566a..f6deda7 100644
--- a/skgyorugo/commands/movedown.py
+++ b/skgyorugo/commands/movedown.py
@@ -60,7 +60,7 @@ def main(bot: Bot, message: Message):
                             FROM
                                 lol_queue
                             WHERE
-                                name = ?
+                                twitch_id = ?
                         )
                 ) + (
                     SELECT
@@ -68,7 +68,7 @@ def main(bot: Bot, message: Message):
                     FROM
                         lol_queue
                     WHERE
-                        name = ?
+                        twitch_id = ?
                 ) - position
             WHERE
                 position in (
@@ -84,7 +84,7 @@ def main(bot: Bot, message: Message):
                                 FROM
                                     lol_queue
                                 WHERE
-                                    name = ?
+                                    twitch_id = ?
                             )
                     ),
                     (
@@ -93,7 +93,7 @@ def main(bot: Bot, message: Message):
                         FROM
                             lol_queue
                         WHERE
-                            name = ?
+                            twitch_id = ?
                     )
                 );
             """,
diff --git a/skgyorugo/commands/moveup.py b/skgyorugo/commands/moveup.py
index 43c6b39..8363787 100644
--- a/skgyorugo/commands/moveup.py
+++ b/skgyorugo/commands/moveup.py
@@ -60,7 +60,7 @@ def main(bot: Bot, message: Message):
                             FROM
                                 lol_queue
                             WHERE
-                                name = ?
+                                twitch_id = ?
                         )
                 ) + (
                     SELECT
@@ -68,7 +68,7 @@ def main(bot: Bot, message: Message):
                     FROM
                         lol_queue
                     WHERE
-                        name = ?
+                        twitch_id = ?
                 ) - position
             WHERE
                 position in (
@@ -84,7 +84,7 @@ def main(bot: Bot, message: Message):
                                 FROM
                                     lol_queue
                                 WHERE
-                                    name = ?
+                                    twitch_id = ?
                             )
                     ),
                     (
@@ -93,7 +93,7 @@ def main(bot: Bot, message: Message):
                         FROM
                             lol_queue
                         WHERE
-                            name = ?
+                            twitch_id = ?
                     )
                 );
             """,
-- 
2.30.2