From 4e6439763544f7b96009dd1411035343fb561d2a Mon Sep 17 00:00:00 2001 From: Mar0xy Date: Fri, 6 Oct 2023 02:32:09 +0200 Subject: add: profile backgrounds --- packages/backend/src/core/DriveService.ts | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'packages/backend/src/core/DriveService.ts') diff --git a/packages/backend/src/core/DriveService.ts b/packages/backend/src/core/DriveService.ts index cecbec9638..4b4872a2d6 100644 --- a/packages/backend/src/core/DriveService.ts +++ b/packages/backend/src/core/DriveService.ts @@ -423,6 +423,10 @@ export class DriveService { q.andWhere('file.id != :bannerId', { bannerId: user.bannerId }); } + if (user.backgroundId) { + q.andWhere('file.id != :backgroundId', { backgroundId: user.backgroundId }); + } + //This selete is hard coded, be careful if change database schema q.addSelect('SUM("file"."size") OVER (ORDER BY "file"."id" DESC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)', 'acc_usage'); q.orderBy('file.id', 'ASC'); -- cgit v1.2.3-freya