7 files changed, 428 insertions, 332 deletions

diff --git a/src/lib/Database/SB/User/badges.ts b/src/lib/Database/SB/User/badges.ts
index dd6c158e..685e7809 100644
--- a/src/lib/Database/SB/User/badges.ts
+++ b/src/lib/Database/SB/User/badges.ts
@@ -1,124 +1,157 @@
-import { databaseTimeToDate } from '$lib/Utility/time';
-import sb from '../../sb';
+import { databaseTimeToDate } from "$lib/Utility/time";
+import sb from "../../sb";
 
 export interface Badge {
-  id: number;
-  post: string;
-  image: string;
-  hidden: boolean;
-  shadow_hidden: boolean;
-  click_count: number;
-  time?: string;
-  description?: string | null;
-  category?: string | null;
-  source?: string | null;
-  designer?: string | null;
+	id: number;
+	post: string;
+	image: string;
+	hidden: boolean;
+	shadow_hidden: boolean;
+	click_count: number;
+	time?: string;
+	description?: string | null;
+	category?: string | null;
+	source?: string | null;
+	designer?: string | null;
 }
 
 export interface BadgeInput {
-  post?: string;
-  image?: string;
-  description?: string | null;
-  time?: string;
-  category?: string | null;
-  hidden?: boolean;
-  source?: string | null;
-  designer?: string | null;
+	post?: string;
+	image?: string;
+	description?: string | null;
+	time?: string;
+	category?: string | null;
+	hidden?: boolean;
+	source?: string | null;
+	designer?: string | null;
 }
 
 const getPagination = (page: number, size: number) => {
-  const from = page ? page * (size ? +size : 3) : 0;
+	const from = page ? page * (size ? +size : 3) : 0;
 
-  return { from, to: page ? from + size - 1 : size - 1 };
+	return { from, to: page ? from + size - 1 : size - 1 };
 };
 
-export const getUserBadges = async (userId: number, page = 0, size = -1): Promise<Badge[]> => {
-  const { from, to } = getPagination(page, size);
-  let query = sb.from('user_badges').select('*').eq('user_id', userId);
+export const getUserBadges = async (
+	userId: number,
+	page = 0,
+	size = -1,
+): Promise<Badge[]> => {
+	const { from, to } = getPagination(page, size);
+	let query = sb.from("user_badges").select("*").eq("user_id", userId);
 
-  if (size !== -1) query = query.range(from, to);
+	if (size !== -1) query = query.range(from, to);
 
-  const { data, error } = await query;
+	const { data, error } = await query;
 
-  if (error) return [];
+	if (error) return [];
 
-  return data.sort((a, b) =>
-    databaseTimeToDate((a as Badge).time ?? '').getTime() >
-    databaseTimeToDate((b as Badge).time ?? '').getTime()
-      ? -1
-      : 1
-  ) as Badge[];
+	return data.sort((a, b) =>
+		databaseTimeToDate((a as Badge).time ?? "").getTime() >
+		databaseTimeToDate((b as Badge).time ?? "").getTime()
+			? -1
+			: 1,
+	) as Badge[];
 };
 
 export const addUserBadge = async (userId: number, badge: BadgeInput) => {
-  const { post, image, description, time, category, hidden, source, designer } = badge;
-
-  if (post === undefined || image === undefined) return;
-
-  if (time) {
-    await sb.from('user_badges').insert({
-      user_id: userId,
-      post,
-      image,
-      description,
-      time,
-      category,
-      hidden,
-      source,
-      designer
-    });
-  } else {
-    await sb
-      .from('user_badges')
-      .insert({ user_id: userId, post, image, description, category, hidden, source, designer });
-  }
+	const { post, image, description, time, category, hidden, source, designer } =
+		badge;
+
+	if (post === undefined || image === undefined) return;
+
+	if (time) {
+		await sb.from("user_badges").insert({
+			user_id: userId,
+			post,
+			image,
+			description,
+			time,
+			category,
+			hidden,
+			source,
+			designer,
+		});
+	} else {
+		await sb
+			.from("user_badges")
+			.insert({
+				user_id: userId,
+				post,
+				image,
+				description,
+				category,
+				hidden,
+				source,
+				designer,
+			});
+	}
 };
 
 export const removeUserBadge = async (userId: number, id: number) => {
-  if (!isNaN(id)) await sb.from('user_badges').delete().eq('id', id).eq('user_id', userId);
+	if (!isNaN(id))
+		await sb.from("user_badges").delete().eq("id", id).eq("user_id", userId);
 };
 
-export const updateUserBadge = async (userId: number, id: number, badge: BadgeInput) => {
-  if (badge.post === undefined || badge.image === undefined) return;
-
-  await sb
-    .from('user_badges')
-    .update({
-      post: badge.post,
-      image: badge.image,
-      description: badge.description,
-      category: badge.category,
-      time: badge.time,
-      hidden: badge.hidden,
-      source: badge.source,
-      designer: badge.designer
-    })
-    .eq('id', id)
-    .eq('user_id', userId);
+export const updateUserBadge = async (
+	userId: number,
+	id: number,
+	badge: BadgeInput,
+) => {
+	if (badge.post === undefined || badge.image === undefined) return;
+
+	await sb
+		.from("user_badges")
+		.update({
+			post: badge.post,
+			image: badge.image,
+			description: badge.description,
+			category: badge.category,
+			time: badge.time,
+			hidden: badge.hidden,
+			source: badge.source,
+			designer: badge.designer,
+		})
+		.eq("id", id)
+		.eq("user_id", userId);
 };
 
-export const renameCategory = async (userId: number, oldName: string, newName: string) =>
-  await sb
-    .from('user_badges')
-    .update({ category: newName })
-    .eq('category', oldName)
-    .eq('user_id', userId);
+export const renameCategory = async (
+	userId: number,
+	oldName: string,
+	newName: string,
+) =>
+	await sb
+		.from("user_badges")
+		.update({ category: newName })
+		.eq("category", oldName)
+		.eq("user_id", userId);
 
 export const removeAllUserBadges = async (userId: number) =>
-  await sb.from('user_badges').delete().eq('user_id', userId);
-
-export const migrateCategory = async (userId: number, oldName: string, newName: string) =>
-  await sb
-    .from('user_badges')
-    .update({ category: newName })
-    .eq('category', oldName)
-    .eq('user_id', userId);
+	await sb.from("user_badges").delete().eq("user_id", userId);
+
+export const migrateCategory = async (
+	userId: number,
+	oldName: string,
+	newName: string,
+) =>
+	await sb
+		.from("user_badges")
+		.update({ category: newName })
+		.eq("category", oldName)
+		.eq("user_id", userId);
 
 export const setShadowHidden = async (userId: number, shadowHide: boolean) =>
-  await sb.from('user_badges').update({ shadow_hidden: shadowHide }).eq('user_id', userId);
+	await sb
+		.from("user_badges")
+		.update({ shadow_hidden: shadowHide })
+		.eq("user_id", userId);
 
 export const setShadowHiddenBadge = async (id: number, shadowHide: boolean) =>
-  await sb.from('user_badges').update({ shadow_hidden: shadowHide }).eq('id', id);
+	await sb
+		.from("user_badges")
+		.update({ shadow_hidden: shadowHide })
+		.eq("id", id);
 
 export const incrementClickCount = async (id: number) =>
-  await sb.rpc('user_badges_increment_click_count', { user_badge_id: id });
+	await sb.rpc("user_badges_increment_click_count", { user_badge_id: id });
diff --git a/src/lib/Database/SB/User/configuration.ts b/src/lib/Database/SB/User/configuration.ts
index ab1373da..6007e41b 100644
--- a/src/lib/Database/SB/User/configuration.ts
+++ b/src/lib/Database/SB/User/configuration.ts
@@ -1,47 +1,56 @@
-import sb from '../../sb';
+import sb from "../../sb";
 
 interface UserConfiguration {
-  user_id: number;
-  configuration: object;
-  created_at: string;
-  updated_at: string;
+	user_id: number;
+	configuration: object;
+	created_at: string;
+	updated_at: string;
 }
 
 interface NewUserConfiguration {
-  configuration: object;
-  updated_at?: string;
+	configuration: object;
+	updated_at?: string;
 }
 
 export const getUserConfiguration = async (userId: number) => {
-  const { data, error } = await sb.from('user_configuration').select('*').eq('user_id', userId);
+	const { data, error } = await sb
+		.from("user_configuration")
+		.select("*")
+		.eq("user_id", userId);
 
-  if (error || data.length === 0 || data[0].user_id !== userId) return null;
+	if (error || data.length === 0 || data[0].user_id !== userId) return null;
 
-  return data[0] as UserConfiguration;
+	return data[0] as UserConfiguration;
 };
 
-export const setUserConfiguration = async (userId: number, configuration: NewUserConfiguration) => {
-  const { data, error } = await sb
-    .from('user_configuration')
-    .upsert(
-      {
-        user_id: userId,
-        configuration: configuration.configuration,
-        updated_at: configuration.updated_at || new Date().toISOString()
-      },
-      { onConflict: 'user_id' }
-    )
-    .select();
-
-  if (error || !data || (data as []).length === 0) return null;
-
-  return data[0].configuration as UserConfiguration;
+export const setUserConfiguration = async (
+	userId: number,
+	configuration: NewUserConfiguration,
+) => {
+	const { data, error } = await sb
+		.from("user_configuration")
+		.upsert(
+			{
+				user_id: userId,
+				configuration: configuration.configuration,
+				updated_at: configuration.updated_at || new Date().toISOString(),
+			},
+			{ onConflict: "user_id" },
+		)
+		.select();
+
+	if (error || !data || (data as []).length === 0) return null;
+
+	return data[0].configuration as UserConfiguration;
 };
 
 export const deleteUserConfiguration = async (userId: number) => {
-  const { data, error } = await sb.from('user_configuration').delete().eq('user_id', userId);
+	const { data, error } = await sb
+		.from("user_configuration")
+		.delete()
+		.eq("user_id", userId);
 
-  if (error || !data) return null;
+	if (error || !data) return null;
 
-  return data;
+	return data;
 };
diff --git a/src/lib/Database/SB/User/notifications.ts b/src/lib/Database/SB/User/notifications.ts
index b30896a2..75dd5941 100644
--- a/src/lib/Database/SB/User/notifications.ts
+++ b/src/lib/Database/SB/User/notifications.ts
@@ -1,38 +1,45 @@
-import sb from '../../sb';
+import sb from "../../sb";
 
 export interface UserNotifications {
-  created_at: string;
-  updated_at: string;
-  user_id: number;
-  subscription: JSON;
-  fingerprint: string;
+	created_at: string;
+	updated_at: string;
+	user_id: number;
+	subscription: JSON;
+	fingerprint: string;
 }
 
 export const getUserSubscription = async (userId: number) =>
-  await sb.from('user_notifications').select('*').eq('user_id', userId);
+	await sb.from("user_notifications").select("*").eq("user_id", userId);
 
 export const getUserSubscriptions = async () => {
-  const { data, error } = await sb.from('user_notifications').select('*');
+	const { data, error } = await sb.from("user_notifications").select("*");
 
-  if (error) return [];
+	if (error) return [];
 
-  return data as UserNotifications[];
+	return data as UserNotifications[];
 };
 
-export const deleteUserSubscription = async (userId: number, fingerprint: string) =>
-  await sb.from('user_notifications').delete().eq('user_id', userId).eq('fingerprint', fingerprint);
+export const deleteUserSubscription = async (
+	userId: number,
+	fingerprint: string,
+) =>
+	await sb
+		.from("user_notifications")
+		.delete()
+		.eq("user_id", userId)
+		.eq("fingerprint", fingerprint);
 
 export const setUserSubscription = async (
-  userId: number,
-  subscription: JSON,
-  fingerprint: string
+	userId: number,
+	subscription: JSON,
+	fingerprint: string,
 ) =>
-  await sb.from('user_notifications').upsert(
-    {
-      user_id: userId,
-      updated_at: new Date().toISOString(),
-      subscription: subscription,
-      fingerprint
-    },
-    { onConflict: 'user_id' }
-  );
+	await sb.from("user_notifications").upsert(
+		{
+			user_id: userId,
+			updated_at: new Date().toISOString(),
+			subscription: subscription,
+			fingerprint,
+		},
+		{ onConflict: "user_id" },
+	);
diff --git a/src/lib/Database/SB/User/preferences.ts b/src/lib/Database/SB/User/preferences.ts
index d773d898..f0a49397 100644
--- a/src/lib/Database/SB/User/preferences.ts
+++ b/src/lib/Database/SB/User/preferences.ts
@@ -1,156 +1,186 @@
-import sb from '../../sb';
+import sb from "../../sb";
 
 export interface UserPreferences {
-  created_at: string;
-  updated_at: string;
-  user_id: number;
-  pinned_hololive_streams: string[];
-  hide_missing_badges: boolean;
-  biography: string | null;
-  badge_wall_css: string;
-  hide_awc_badges: boolean;
-  pinned_badge_wall_categories: string[];
+	created_at: string;
+	updated_at: string;
+	user_id: number;
+	pinned_hololive_streams: string[];
+	hide_missing_badges: boolean;
+	biography: string | null;
+	badge_wall_css: string;
+	hide_awc_badges: boolean;
+	pinned_badge_wall_categories: string[];
 }
 
 interface NewUserPreferences {
-  updated_at?: string;
-  pinned_hololive_streams?: string[];
-  hide_missing_badges?: boolean;
-  badge_wall_css?: string;
-  biography?: string;
-  hide_awc_badges?: boolean;
-  pinned_badge_wall_categories?: string[];
+	updated_at?: string;
+	pinned_hololive_streams?: string[];
+	hide_missing_badges?: boolean;
+	badge_wall_css?: string;
+	biography?: string;
+	hide_awc_badges?: boolean;
+	pinned_badge_wall_categories?: string[];
 }
 
 export const getUserPreferences = async (userId: number) => {
-  const { data, error } = await sb.from('user_preferences').select('*').eq('user_id', userId);
+	const { data, error } = await sb
+		.from("user_preferences")
+		.select("*")
+		.eq("user_id", userId);
 
-  if (error || data.length === 0 || data[0].user_id !== userId) return null;
+	if (error || data.length === 0 || data[0].user_id !== userId) return null;
 
-  return data[0] as UserPreferences;
+	return data[0] as UserPreferences;
 };
 
-export const setUserPreferences = async (userId: number, preferences: NewUserPreferences) => {
-  const userPreferences = await getUserPreferences(userId);
-  const { data, error } = await sb
-    .from('user_preferences')
-    .upsert(
-      {
-        user_id: userId,
-        updated_at: preferences.updated_at || new Date().toISOString(),
-        pinned_hololive_streams:
-          preferences.pinned_hololive_streams ||
-          (userPreferences ? userPreferences.pinned_hololive_streams : []),
-        hide_missing_badges: preferences.hide_missing_badges || false,
-        biography: preferences.biography || (userPreferences ? userPreferences.biography : null),
-        badge_wall_css:
-          preferences.badge_wall_css || (userPreferences ? userPreferences.badge_wall_css : ''),
-        hide_awc_badges: preferences.hide_awc_badges || false,
-        pinned_badge_wall_categories:
-          preferences.pinned_badge_wall_categories ||
-          (userPreferences ? userPreferences.pinned_badge_wall_categories : '')
-      },
-      { onConflict: 'user_id' }
-    )
-    .select();
-
-  if (error || !data || (data as []).length === 0) return null;
-
-  return data[0] as UserPreferences;
+export const setUserPreferences = async (
+	userId: number,
+	preferences: NewUserPreferences,
+) => {
+	const userPreferences = await getUserPreferences(userId);
+	const { data, error } = await sb
+		.from("user_preferences")
+		.upsert(
+			{
+				user_id: userId,
+				updated_at: preferences.updated_at || new Date().toISOString(),
+				pinned_hololive_streams:
+					preferences.pinned_hololive_streams ||
+					(userPreferences ? userPreferences.pinned_hololive_streams : []),
+				hide_missing_badges: preferences.hide_missing_badges || false,
+				biography:
+					preferences.biography ||
+					(userPreferences ? userPreferences.biography : null),
+				badge_wall_css:
+					preferences.badge_wall_css ||
+					(userPreferences ? userPreferences.badge_wall_css : ""),
+				hide_awc_badges: preferences.hide_awc_badges || false,
+				pinned_badge_wall_categories:
+					preferences.pinned_badge_wall_categories ||
+					(userPreferences ? userPreferences.pinned_badge_wall_categories : ""),
+			},
+			{ onConflict: "user_id" },
+		)
+		.select();
+
+	if (error || !data || (data as []).length === 0) return null;
+
+	return data[0] as UserPreferences;
 };
 
-export const toggleHololiveStreamPinning = async (userId: number, streamId: string) => {
-  const userPreferences = await getUserPreferences(userId);
+export const toggleHololiveStreamPinning = async (
+	userId: number,
+	streamId: string,
+) => {
+	const userPreferences = await getUserPreferences(userId);
 
-  if (!userPreferences) return null;
+	if (!userPreferences) return null;
 
-  const pinnedStreams = userPreferences.pinned_hololive_streams;
-  const index = pinnedStreams.indexOf(streamId);
+	const pinnedStreams = userPreferences.pinned_hololive_streams;
+	const index = pinnedStreams.indexOf(streamId);
 
-  if (index === -1) pinnedStreams.push(streamId);
-  else pinnedStreams.splice(index, 1);
+	if (index === -1) pinnedStreams.push(streamId);
+	else pinnedStreams.splice(index, 1);
 
-  return await setUserPreferences(userId, {
-    updated_at: new Date().toISOString(),
-    pinned_hololive_streams: pinnedStreams,
-    hide_missing_badges: userPreferences.hide_missing_badges
-  });
+	return await setUserPreferences(userId, {
+		updated_at: new Date().toISOString(),
+		pinned_hololive_streams: pinnedStreams,
+		hide_missing_badges: userPreferences.hide_missing_badges,
+	});
 };
 
 export const toggleHideMissingBadges = async (userId: number) => {
-  const userPreferences = await getUserPreferences(userId);
-
-  return await setUserPreferences(userId, {
-    updated_at: new Date().toISOString(),
-    pinned_hololive_streams: userPreferences ? userPreferences.pinned_hololive_streams : [],
-    hide_missing_badges: userPreferences ? !userPreferences.hide_missing_badges : false
-  });
+	const userPreferences = await getUserPreferences(userId);
+
+	return await setUserPreferences(userId, {
+		updated_at: new Date().toISOString(),
+		pinned_hololive_streams: userPreferences
+			? userPreferences.pinned_hololive_streams
+			: [],
+		hide_missing_badges: userPreferences
+			? !userPreferences.hide_missing_badges
+			: false,
+	});
 };
 
 export const toggleHideAWCBadges = async (userId: number) => {
-  const userPreferences = await getUserPreferences(userId);
+	const userPreferences = await getUserPreferences(userId);
 
-  return await setUserPreferences(userId, {
-    updated_at: new Date().toISOString(),
-    hide_awc_badges: userPreferences ? !userPreferences.hide_awc_badges : false
-  });
+	return await setUserPreferences(userId, {
+		updated_at: new Date().toISOString(),
+		hide_awc_badges: userPreferences ? !userPreferences.hide_awc_badges : false,
+	});
 };
 
 export const setCSS = async (userId: number, css: string) => {
-  const userPreferences = await getUserPreferences(userId);
-
-  return await setUserPreferences(userId, {
-    updated_at: new Date().toISOString(),
-    pinned_hololive_streams: userPreferences ? userPreferences.pinned_hololive_streams : [],
-    hide_missing_badges: userPreferences ? userPreferences.hide_missing_badges : false,
-    badge_wall_css:
-      css ||
-      "/* Use classes and IDs such as .badges, #badges, .badge, or standard elements like body and details, or anything, as long as it's valid CSS! */"
-  });
+	const userPreferences = await getUserPreferences(userId);
+
+	return await setUserPreferences(userId, {
+		updated_at: new Date().toISOString(),
+		pinned_hololive_streams: userPreferences
+			? userPreferences.pinned_hololive_streams
+			: [],
+		hide_missing_badges: userPreferences
+			? userPreferences.hide_missing_badges
+			: false,
+		badge_wall_css:
+			css ||
+			"/* Use classes and IDs such as .badges, #badges, .badge, or standard elements like body and details, or anything, as long as it's valid CSS! */",
+	});
 };
 
 export const setBiography = async (userId: number, biography: string) => {
-  const userPreferences = await getUserPreferences(userId);
-
-  return await setUserPreferences(userId, {
-    updated_at: new Date().toISOString(),
-    pinned_hololive_streams: userPreferences ? userPreferences.pinned_hololive_streams : [],
-    hide_missing_badges: userPreferences ? userPreferences.hide_missing_badges : false,
-    badge_wall_css: userPreferences ? userPreferences.badge_wall_css : '',
-    biography: biography || '\n'
-  });
+	const userPreferences = await getUserPreferences(userId);
+
+	return await setUserPreferences(userId, {
+		updated_at: new Date().toISOString(),
+		pinned_hololive_streams: userPreferences
+			? userPreferences.pinned_hololive_streams
+			: [],
+		hide_missing_badges: userPreferences
+			? userPreferences.hide_missing_badges
+			: false,
+		badge_wall_css: userPreferences ? userPreferences.badge_wall_css : "",
+		biography: biography || "\n",
+	});
 };
 
-export const togglePinnedBadgeWallCategory = async (userId: number, category: string) => {
-  const userPreferences = await getUserPreferences(userId);
+export const togglePinnedBadgeWallCategory = async (
+	userId: number,
+	category: string,
+) => {
+	const userPreferences = await getUserPreferences(userId);
 
-  if (!userPreferences) return null;
+	if (!userPreferences) return null;
 
-  const pinnedCategories = userPreferences.pinned_badge_wall_categories;
-  const index = pinnedCategories.indexOf(category);
+	const pinnedCategories = userPreferences.pinned_badge_wall_categories;
+	const index = pinnedCategories.indexOf(category);
 
-  if (index === -1) pinnedCategories.push(category);
-  else pinnedCategories.splice(index, 1);
+	if (index === -1) pinnedCategories.push(category);
+	else pinnedCategories.splice(index, 1);
 
-  return await setUserPreferences(userId, {
-    updated_at: new Date().toISOString(),
-    pinned_hololive_streams: userPreferences.pinned_hololive_streams,
-    hide_missing_badges: userPreferences.hide_missing_badges,
-    badge_wall_css: userPreferences.badge_wall_css,
-    pinned_badge_wall_categories: pinnedCategories
-  });
+	return await setUserPreferences(userId, {
+		updated_at: new Date().toISOString(),
+		pinned_hololive_streams: userPreferences.pinned_hololive_streams,
+		hide_missing_badges: userPreferences.hide_missing_badges,
+		badge_wall_css: userPreferences.badge_wall_css,
+		pinned_badge_wall_categories: pinnedCategories,
+	});
 };
 
-export const setPinnedBadgeWallCategories = async (userId: number, categories: string[]) => {
-  const userPreferences = await getUserPreferences(userId);
-
-  if (!userPreferences) return null;
-
-  return await setUserPreferences(userId, {
-    updated_at: new Date().toISOString(),
-    pinned_hololive_streams: userPreferences.pinned_hololive_streams,
-    hide_missing_badges: userPreferences.hide_missing_badges,
-    badge_wall_css: userPreferences.badge_wall_css,
-    pinned_badge_wall_categories: categories
-  });
+export const setPinnedBadgeWallCategories = async (
+	userId: number,
+	categories: string[],
+) => {
+	const userPreferences = await getUserPreferences(userId);
+
+	if (!userPreferences) return null;
+
+	return await setUserPreferences(userId, {
+		updated_at: new Date().toISOString(),
+		pinned_hololive_streams: userPreferences.pinned_hololive_streams,
+		hide_missing_badges: userPreferences.hide_missing_badges,
+		badge_wall_css: userPreferences.badge_wall_css,
+		pinned_badge_wall_categories: categories,
+	});
 };
diff --git a/src/lib/Database/SB/badges.ts b/src/lib/Database/SB/badges.ts
index 27f8d13c..a287f01b 100644
--- a/src/lib/Database/SB/badges.ts
+++ b/src/lib/Database/SB/badges.ts
@@ -1,48 +1,57 @@
-import sb from '../sb';
+import sb from "../sb";
 
 interface Badge {
-  id: number;
-  created_at: string;
-  updated_at: string;
-  image_url: string;
-  image_artist: string;
-  description: string;
-  event: number;
-  group: number;
+	id: number;
+	created_at: string;
+	updated_at: string;
+	image_url: string;
+	image_artist: string;
+	description: string;
+	event: number;
+	group: number;
 }
 
 interface NewBadge {
-  updated_at?: string;
-  image_url: string;
-  image_artist: string;
-  description: string;
+	updated_at?: string;
+	image_url: string;
+	image_artist: string;
+	description: string;
 }
 
 interface GetBy {
-  event?: number;
-  group?: number;
+	event?: number;
+	group?: number;
 }
 
 export const getBadges = async (getBy?: GetBy) => {
-  let data: unknown[] | null = null;
-  let error: unknown = null;
-
-  if (getBy?.event) [data, error] = await sb.from('badges').select('*').eq('event', getBy.event);
-  else if (getBy?.group)
-    [data, error] = await sb.from('badges').select('*').eq('group', getBy.group);
-  else [data, error] = await sb.from('badges').select('*');
-
-  if (error) return [];
-
-  return data as Badge[];
+	let data: unknown[] | null = null;
+	let error: unknown = null;
+
+	if (getBy?.event)
+		[data, error] = await sb
+			.from("badges")
+			.select("*")
+			.eq("event", getBy.event);
+	else if (getBy?.group)
+		[data, error] = await sb
+			.from("badges")
+			.select("*")
+			.eq("group", getBy.group);
+	else [data, error] = await sb.from("badges").select("*");
+
+	if (error) return [];
+
+	return data as Badge[];
 };
 
-export const createBadge = async (badge: NewBadge) => await sb.from('badges').insert(badge);
+export const createBadge = async (badge: NewBadge) =>
+	await sb.from("badges").insert(badge);
 
-export const deleteBadge = async (id: number) => await sb.from('badges').delete().eq('id', id);
+export const deleteBadge = async (id: number) =>
+	await sb.from("badges").delete().eq("id", id);
 
 export const updateBadge = async (id: number, badge: NewBadge) => {
-  if (!badge.updated_at) badge.updated_at = new Date().toISOString();
+	if (!badge.updated_at) badge.updated_at = new Date().toISOString();
 
-  return await sb.from('badges').update(badge).eq('id', id);
+	return await sb.from("badges").update(badge).eq("id", id);
 };
diff --git a/src/lib/Database/SB/events.ts b/src/lib/Database/SB/events.ts
index aa914f95..de213185 100644
--- a/src/lib/Database/SB/events.ts
+++ b/src/lib/Database/SB/events.ts
@@ -1,45 +1,50 @@
-import type { Group } from '$lib/Database/SB/groups';
-import sb from '../sb';
+import type { Group } from "$lib/Database/SB/groups";
+import sb from "../sb";
 
 export interface Event {
-  id: number;
-  created_at: string;
-  updated_at: string;
-  title: string;
-  description: string;
-  group: Group;
-  banner: string;
-  anilist_url: string;
+	id: number;
+	created_at: string;
+	updated_at: string;
+	title: string;
+	description: string;
+	group: Group;
+	banner: string;
+	anilist_url: string;
 }
 
 interface NewEvent {
-  updated_at?: string;
-  title: string;
-  description: string;
+	updated_at?: string;
+	title: string;
+	description: string;
 }
 
 export const getEvents = async () => {
-  const { data, error } = await sb.from('events').select('*, group:groups(*)');
+	const { data, error } = await sb.from("events").select("*, group:groups(*)");
 
-  if (error) return [];
+	if (error) return [];
 
-  return data as Event[];
+	return data as Event[];
 };
 
 export const getGroupEvents = async (group: string) => {
-  const { data, error } = await sb.from('events').select('*').eq('group', group);
+	const { data, error } = await sb
+		.from("events")
+		.select("*")
+		.eq("group", group);
 
-  if (error) return [];
+	if (error) return [];
 
-  return data as Event[];
+	return data as Event[];
 };
 
-export const createEvent = async (event: NewEvent) => await sb.from('events').insert(event);
+export const createEvent = async (event: NewEvent) =>
+	await sb.from("events").insert(event);
 
-export const deleteEvent = async (id: number) => await sb.from('events').delete().eq('id', id);
+export const deleteEvent = async (id: number) =>
+	await sb.from("events").delete().eq("id", id);
 
 export const updateEvent = async (id: number, event: NewEvent) => {
-  if (!event.updated_at) event.updated_at = new Date().toISOString();
+	if (!event.updated_at) event.updated_at = new Date().toISOString();
 
-  return await sb.from('events').update(event).eq('id', id);
+	return await sb.from("events").update(event).eq("id", id);
 };
diff --git a/src/lib/Database/SB/groups.ts b/src/lib/Database/SB/groups.ts
index 92afc80c..8cecb08f 100644
--- a/src/lib/Database/SB/groups.ts
+++ b/src/lib/Database/SB/groups.ts
@@ -1,32 +1,35 @@
-import sb from '../sb';
+import sb from "../sb";
 
 export interface Group {
-  id: number;
-  created_at: string;
-  updated_at?: string;
-  members: number[];
-  avatar: string;
-  banner: string;
-  description?: string;
-  name: string;
-  anilist_id: number;
-  anilist_username: string;
-  badge?: string;
-  badge_description?: string;
+	id: number;
+	created_at: string;
+	updated_at?: string;
+	members: number[];
+	avatar: string;
+	banner: string;
+	description?: string;
+	name: string;
+	anilist_id: number;
+	anilist_username: string;
+	badge?: string;
+	badge_description?: string;
 }
 
 export const getGroups = async () => {
-  const { data, error } = await sb.from('groups').select('*');
+	const { data, error } = await sb.from("groups").select("*");
 
-  if (error) return [];
+	if (error) return [];
 
-  return data as Group[];
+	return data as Group[];
 };
 
 export const getGroup = async (slug: string) => {
-  const { data, error } = await sb.from('groups').select('*').eq('anilist_username', slug);
+	const { data, error } = await sb
+		.from("groups")
+		.select("*")
+		.eq("anilist_username", slug);
 
-  if (error || data.length === 0) return null;
+	if (error || data.length === 0) return null;
 
-  return data[0] as Group;
+	return data[0] as Group;
 };