From 9429c5c09ab1b7ce081c0786e080da4ee78ad22c Mon Sep 17 00:00:00 2001
From: Flam3rboy <34555296+Flam3rboy@users.noreply.github.com>
Date: Mon, 13 Sep 2021 12:22:59 +0200
Subject: :bug: fix In() query

---
 api/src/routes/auth/register.ts          | 2 +-
 api/src/routes/guilds/#guild_id/roles.ts | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

(limited to 'api/src')

diff --git a/api/src/routes/auth/register.ts b/api/src/routes/auth/register.ts
index e0af1d6d..e70e01ed 100644
--- a/api/src/routes/auth/register.ts
+++ b/api/src/routes/auth/register.ts
@@ -137,7 +137,7 @@ router.post("/", route({ body: "RegisterSchema" }), async (req: Request, res: Re
 
 	if (!register.allowMultipleAccounts) {
 		// TODO: check if fingerprint was eligible generated
-		const exists = await User.findOne({ where: { fingerprints: In(fingerprint) } });
+		const exists = await User.findOne({ where: { fingerprints: fingerprint } });
 
 		if (exists) {
 			throw FieldErrors({
diff --git a/api/src/routes/guilds/#guild_id/roles.ts b/api/src/routes/guilds/#guild_id/roles.ts
index 6b2902d9..5c549262 100644
--- a/api/src/routes/guilds/#guild_id/roles.ts
+++ b/api/src/routes/guilds/#guild_id/roles.ts
@@ -132,7 +132,7 @@ router.patch("/", route({ body: "RolePositionUpdateSchema" }), async (req: Reque
 
 	await Promise.all(body.map(async (x) => Role.update({ guild_id, id: x.id }, { position: x.position })));
 
-	const roles = await Role.find({ guild_id, id: In(body.map((x) => x.id)) });
+	const roles = await Role.find({ where: body.map((x) => ({ id: x.id, guild_id })) });
 
 	await Promise.all(
 		roles.map((x) =>
-- 
cgit 1.5.1