From 2d34082353f859c8e09adc8a66794bb96f81822f Mon Sep 17 00:00:00 2001 From: Fuwn Date: Tue, 2 Jan 2024 20:07:51 -0800 Subject: feat(badges): update and delete ui --- src/lib/Database/badges.ts | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'src/lib/Database') diff --git a/src/lib/Database/badges.ts b/src/lib/Database/badges.ts index d56fa27a..1f3267e9 100644 --- a/src/lib/Database/badges.ts +++ b/src/lib/Database/badges.ts @@ -63,3 +63,14 @@ export const removeUserBadge = (userId: number, id: number) => { $id: id }); }; + +export const updateUserBadge = (userId: number, id: number, badge: Badge) => { + if (badge.post === undefined || badge.image === undefined || badge.description === undefined) + return; + + database + .query( + 'UPDATE user_badges SET post = ?1, image = ?2, description = ?3 WHERE id = ?4 AND user_id = ?5' + ) + .run(badge.post || null, badge.image || null, badge.description || null, id, userId); +}; -- cgit v1.2.3