diff options
Diffstat (limited to 'src/lib/Database')
| -rw-r--r-- | src/lib/Database/badges.ts | 11 |
1 files changed, 11 insertions, 0 deletions
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); +}; |