diff options
| author | Mar0xy <marie@kaifa.ch> | 2023-10-06 02:32:09 +0200 |
|---|---|---|
| committer | Mar0xy <marie@kaifa.ch> | 2023-10-06 02:32:09 +0200 |
| commit | 4e6439763544f7b96009dd1411035343fb561d2a (patch) | |
| tree | 6f0d183391c27f383297ee1713e821ade4e60d20 /packages/backend/src/core/DriveService.ts | |
| parent | merge: add speakAsCat extension and non-nya speech option (diff) | |
| download | sharkey-4e6439763544f7b96009dd1411035343fb561d2a.tar.gz sharkey-4e6439763544f7b96009dd1411035343fb561d2a.tar.bz2 sharkey-4e6439763544f7b96009dd1411035343fb561d2a.zip | |
add: profile backgrounds
Diffstat (limited to 'packages/backend/src/core/DriveService.ts')
| -rw-r--r-- | packages/backend/src/core/DriveService.ts | 4 |
1 files changed, 4 insertions, 0 deletions
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'); |