From 8052754a4bcc3d07208d11aad764d2bb3492166d Mon Sep 17 00:00:00 2001 From: Pinapelz Date: Wed, 5 Nov 2025 15:52:09 -0800 Subject: add profile page to navbar --- backend/src/routes/user.ts | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'backend') diff --git a/backend/src/routes/user.ts b/backend/src/routes/user.ts index 7e030fd..96a452e 100644 --- a/backend/src/routes/user.ts +++ b/backend/src/routes/user.ts @@ -31,7 +31,8 @@ export const handleMeRoute = async (req: express.Request, res: express.Response) FROM "Score" s INNER JOIN "Game" g ON g."internalName" = s."gameInternalName" WHERE s."userId" = ${parseInt(userId as string)} - ORDER BY s."gameInternalName", s."timestamp" DESC; + ORDER BY s."gameInternalName", s."timestamp" DESC + LIMIT 5; `; const scoreCountByGame: SafeGameCount[] = await prisma.$queryRaw` SELECT -- cgit v1.2.3