aboutsummaryrefslogtreecommitdiff
path: root/src/lib/Database
diff options
context:
space:
mode:
authorFuwn <[email protected]>2024-05-27 18:38:30 -0700
committerFuwn <[email protected]>2024-05-27 18:38:30 -0700
commitc4ec98bc96679586f6867870de8e00e043090354 (patch)
treeea3abd178d2387f76b1521d316ce352f0e997335 /src/lib/Database
parentfeat(hololive): parallax image for thumbnails (diff)
downloaddue.moe-c4ec98bc96679586f6867870de8e00e043090354.tar.xz
due.moe-c4ec98bc96679586f6867870de8e00e043090354.zip
feat(badges): click counter for badges
Diffstat (limited to 'src/lib/Database')
-rw-r--r--src/lib/Database/userBadges.ts4
1 files changed, 4 insertions, 0 deletions
diff --git a/src/lib/Database/userBadges.ts b/src/lib/Database/userBadges.ts
index 3ce88d29..d21c3527 100644
--- a/src/lib/Database/userBadges.ts
+++ b/src/lib/Database/userBadges.ts
@@ -12,6 +12,7 @@ export interface Badge {
source?: string | null;
designer?: string | null;
shadow_hidden?: boolean;
+ click_count?: number;
}
export const getUserBadges = async (userId: number): Promise<Badge[]> => {
@@ -100,3 +101,6 @@ export const setShadowHiddenBadge = async (userId: number, id: number, shadowHid
.update({ shadow_hidden: shadowHide })
.eq('id', id)
.eq('user_id', userId);
+
+export const incrementClickCount = async (id: number) =>
+ await supabase.rpc('user_badges_increment_click_count', { user_badge_id: id });