dkforest

commit 7adba2993880d5a29981802b1d269d7b3ffda2a9
parent 503e6aec68993baccf5fa84bbfdbb64e0304ab15
Author: n0tr1v <n0tr1v@protonmail.com>
Date:   Fri, 26 May 2023 06:28:54 -0700

better query

Diffstat:
M
pkg/database/tableUsers.go
 | 
5
+++--

1 file changed, 3 insertions(+), 2 deletions(-)
diff --git a/pkg/database/tableUsers.go b/pkg/database/tableUsers.go
@@ -305,8 +305,9 @@ func (u *User) UnHellBan(db *DkfDB) {
 
 // GetUserBySessionKey ...
 func (d *DkfDB) GetUserBySessionKey(user *User, sessionKey string) error {
-	return d.db.Joins("INNER JOIN sessions s ON s.token = ? AND s.expires_at > DATETIME('now') AND s.deleted_at IS NULL AND s.user_id = users.id", sessionKey).
-		Where("users.verified = 1").
+	return d.db.
+		Joins("INNER JOIN sessions s ON s.user_id = users.id").
+		Where("s.token = ? AND users.verified = 1 AND s.deleted_at IS NULL AND s.expires_at > DATETIME('now')", sessionKey).
 		First(user).Error
 }