User page · Repositories

1 module · 2 exports · 1 repository · 14 e2e tests · 16 routes

OverviewModulesRepositoriesPermissionsSearch params & storageE2E tests

Every table a function queries, its own helpers included, read or written. Calls to other repositories are listed apart, their tables are on their own page.

UserRepository

app/features/user-page/UserRepository.server.ts

Tables

ArtArtUserMetadataBanLogBuildCalendarEventCalendarEventDateCalendarEventResultPlayerCalendarEventResultTeamModNotePlusTierTeamTeamMemberTeamMemberWithSecondaryTournamentTournamentDivisionTierTournamentResultTournamentTeamUnvalidatedUserSubmittedImageUserUserFriendCodeUserResultHighlightUserSearchUserSubmittedImageUserWeaponPoolUserWidgetVideoMatchVideoMatchPlayer

Calls

ArtRepositoryBadgeRepositoryBuildRepositoryFriendRepositoryLeaderboardRepositoryLFGRepositoryLiveStreamRepositoryMatchProfileRepositorySkillRepositoryTeamRepositoryXRankPlacementRepositoryTournamentOrganizationRepositoryTournamentTeamRepositoryTrophyRepositoryVodRepository

Imports

no other modules

Used by

15 loaders18 actions7 routes2 modules3 routines3 scripts12 other

Types

interface

ResultsFilters

no JSDoc:541

export interface ResultsFilters {
	showHighlightsOnly?: boolean;
	tournamentName?: string;
	teamName?: string;
	mateUserId?: number;
	minTier?: TournamentTierNumber;
	maxTier?: TournamentTierNumber;
	maxPlacement?: number;
	fromYear?: number;
	toYear?: number;
	source?: ResultSource;
	minParticipantCount?: number;
}

Only used inside the module

type

UpdatePatronDataArgs

no JSDoc:1528

export type UpdatePatronDataArgs = Array<
	Pick<Tables["User"], "discordId" | "patronTier" | "patronStartedAt">
>;

Otherapp/modules/updater.ts

Functions & values

function

findIdByIdentifier

no JSDoc:48

export function findIdByIdentifier(identifier: string)

TablesUser

Modulesauth/DiscordStrategy.server.ts

Scriptsscripts/benchmark-db/cases.ts

function

findPageUserByIdentifier

:53

Identity of the user a /u/:identifier page is about, incl. what their canonical page URL needs.

export function findPageUserByIdentifier(identifier: string)

TablesUser

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/user-page-middleware.server.ts

function

findCountriesByUserIds

:60

Country codes of the given users keyed by user id, users without a country set absent.

export async function findCountriesByUserIds(userIds: number[])

TablesUser

Loaders/u/:identifier/seasons/summary-graphic

Scriptsscripts/benchmark-db/cases.ts

function

findDiscordIdsByUserIds

:75

Discord ids of the given users keyed by user id. Not for public responses.

export async function findDiscordIdsByUserIds(userIds: number[])

TablesUser

Loaders/to/:id/admin

function

findPlusTiersByUserIds

:88

Plus tiers of the given users keyed by user id, users without a tier absent.

export async function findPlusTiersByUserIds(userIds: number[])

TablesPlusTier

Loaders/to/:id/looking

Scriptsscripts/benchmark-db/cases.ts

function

findBuildFieldsByUserId

no JSDoc:100

export async function findBuildFieldsByUserId(userId: number)

TablesUserUserWeaponPool

Loaders/u/:identifier/builds

Scriptsscripts/benchmark-db/cases.ts

function

findLayoutDataById

no JSDoc:126

export function findLayoutDataById(userId: number, loggedInUserId?: number)

TablesArtArtUserMetadataBuildCalendarEventResultPlayerPlusTierTournamentResultUserUserSubmittedImageVideoMatchVideoMatchPlayer

Loaders/u/:identifier/admin/u/:identifier

Scriptsscripts/benchmark-db/cases.ts

function

findProfileByUserId

no JSDoc:208

export async function findProfileByUserId(userId: number)

TablesPlusTierTeamTeamMemberWithSecondaryUserUserSubmittedImage

Loaders/lfg/new/u/:identifier/edit

Actions/lfg/new

Scriptsscripts/benchmark-db/cases.ts

function

upsertWidgets

no JSDoc:272

export async function upsertWidgets(
	userId: number,
	widgets: Array<Tables["UserWidget"]["widget"]>,
)

TablesUserWidget

Actions/u/:identifier/edit-widgets

Otherapp/db/UserFactory.ts

function

findStoredWidgetsByUserId

no JSDoc:292

export async function findStoredWidgetsByUserId(
	userId: number,
): Promise<Array<Tables["UserWidget"]["widget"]>>

TablesUserUserWidget

Loaders/u/:identifier/edit-widgets

Scriptsscripts/benchmark-db/cases.ts

function

findWidgetsByUserId

no JSDoc:311

export async function findWidgetsByUserId(
	userId: number,
): Promise<LoadedWidget[]>

TablesCalendarEventCalendarEventDateCalendarEventResultPlayerCalendarEventResultTeamTournamentTournamentDivisionTierTournamentResultTournamentTeamUnvalidatedUserSubmittedImageUserUserResultHighlightUserSubmittedImageUserWidget

CallsTrophyRepository.findByOwnerUserIdBadgeRepository.findByOwnerUserIdBadgeRepository.findByAuthorUserIdBadgeRepository.findManagedByUserIdTeamRepository.findAllMemberOfByUserIdTournamentOrganizationRepository.findByUserIdLeaderboardRepository.findSeasonsParticipatedInByUserIdXRankPlacementRepository.findPlacementsByUserIdLeaderboardRepository.findAllXPLeaderboardLeaderboardRepository.findWeaponXPLeaderboardVodRepository.findByUserIdLFGRepository.findByAuthorUserIdXRankPlacementRepository.findPeaksByUserIdBuildRepository.findAllByUserIdArtRepository.findArtsByUserIdMatchProfileRepository.findWeaponPoolByUserIdXRankPlacementRepository.findTenStarWeaponSplIdsByUserIdFriendRepository.findFriendsByUserIdMatchProfileRepository.findMapModePreferencesByUserIdLiveStreamRepository.findByUserIdSkillRepository.findOrderedUserOrdinalsBySeasonLeaderboardRepository.findUserSPLeaderboard

Loaders/u/:identifier

Scriptsscripts/benchmark-db/cases.ts

function

findByCustomUrl

no JSDoc:342

export function findByCustomUrl(customUrl: string)

TablesUser

Actions/u/:identifier/edit

Routes/short/:customUrl

Scriptsscripts/benchmark-db/cases.ts

function

findByFriendCode

no JSDoc:350

export function findByFriendCode(friendCode: string)

TablesUserUserFriendCodeUserSubmittedImage

Loaders/admin

Scriptsscripts/benchmark-db/cases.ts

function

findUsernameById

no JSDoc:359

export async function findUsernameById(id: number)

TablesUser

Loaders/u/:identifier/results/u/:identifier/results/highlights

function

findLeanById

no JSDoc:369

export async function findLeanById(id: number)

TablesPlusTierTeamTeamMemberUserUserFriendCodeUserSubmittedImage

Actions/admin/plus/suggestions/new/scrims/new/q/preparing/to/:id/join/to/:id/register/to/:id/looking

Routes/tournament/:id/teams/:teamId/add-member/user-report/:id

Scriptsscripts/add-leaderboard-teams-to-tournament.ts/add-leaderboard-teams-to-tournament.tsscripts/benchmark-db/cases.tsscripts/benchmark-db.ts/benchmark-db.ts

Otherapi-public/api-auth-middleware.server.tsauth/user-context.server.tsplus-suggestions/plus-suggestions-schemas.server.tstournament-admin/tournament-admin-registration-schemas.server.ts

function

findModInfoById

no JSDoc:429

export function findModInfoById(id: number)

TablesBanLogModNoteUserUserSubmittedImage

Loaders/u/:identifier/admin

Scriptsscripts/benchmark-db/cases.ts

function

findAllPatrons

no JSDoc:472

export function findAllPatrons()

TablesUser

Routes/patrons

Scriptsscripts/benchmark-db/cases.ts

function

findAllPatronsForFooter

:491

Patrons for the footer marquee, reshuffled each UTC day and slimmed to the fields the chip renders.

export async function findAllPatronsForFooter()

TablesUser

Routes/patrons-list

function

findAllPlusServerMembers

no JSDoc:517

export function findAllPlusServerMembers()

TablesPlusTierUser

Routes/plus/list

Routinesapp/routines/notifyPlusServerVoting.ts

Scriptsscripts/benchmark-db/cases.ts

Otherleaderboards/leaderboards.server.ts

function

existingUserIds

no JSDoc:529

export async function existingUserIds(userIds: Array<number>)

TablesUser

Actions/trophies/new

function

findResultsByUserId

no JSDoc:785

export async function findResultsByUserId(
	userId: number,
	{
		limit,
		offset,
		...filters
	}: ResultsFilters & {
		limit?: number;
		offset?: number;
	} = {},
)

TablesCalendarEventCalendarEventDateCalendarEventResultPlayerCalendarEventResultTeamTournamentTournamentDivisionTierTournamentResultTournamentTeamUnvalidatedUserSubmittedImageUserUserResultHighlightUserSubmittedImage

Loaders/u/:identifier/results/u/:identifier/results/highlights

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

countResultsByUserId

no JSDoc:936

export async function countResultsByUserId(
	userId: number,
	filters: ResultsFilters = {},
)

TablesCalendarEventCalendarEventDateCalendarEventResultPlayerCalendarEventResultTeamTournamentTournamentDivisionTierTournamentResultTournamentTeamUserResultHighlight

Loaders/u/:identifier/results/u/:identifier/results/highlights

Scriptsscripts/benchmark-db/cases.ts

function

hasHighlightedResultsByUserId

no JSDoc:958

export async function hasHighlightedResultsByUserId(userId: number)

TablesTournamentResultUserResultHighlight

Loaders/u/:identifier/results/u/:identifier/results/highlights

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findResultPlacementsByUserId

no JSDoc:981

export async function findResultPlacementsByUserId(userId: number)

TablesCalendarEventResultPlayerCalendarEventResultTeamTournamentResult

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

search

no JSDoc:1013

export async function search({
	query,
	limit,
}: {
	query: string;
	limit: number;
})

TablesPlusTierUserUserSearchUserSubmittedImage

Routes/search

Scriptsscripts/benchmark-db/cases.ts

function

searchExact

no JSDoc:1093

export function searchExact(args: {
	id?: number;
	discordId?: string;
	customUrl?: string;
})

TablesPlusTierUserUserSubmittedImage

Routes/search

Scriptsscripts/benchmark-db/cases.ts

function

findCurrentFriendCodeByUserId

no JSDoc:1125

export async function findCurrentFriendCodeByUserId(userId: number)

TablesUserFriendCode

Loaders/q/u/:identifier/edit

Actions/q

Scriptsscripts/benchmark-db/cases.ts

function

findFriendCodesByUserId

:1140

All friend codes a user has ever submitted.

export async function findFriendCodesByUserId(userId: number)

TablesUserUserFriendCode

Loaders/u/:identifier/admin

Scriptsscripts/benchmark-db/cases.ts

function

clearFriendCodesCache

:1157

Drops the cached friend codes, for when the table was written to behind this module's back.

export function clearFriendCodesCache()

Otherapi-private/refresh-caches.server.ts

function

findAllCurrentFriendCodes

no JSDoc:1161

export async function findAllCurrentFriendCodes()

TablesUserFriendCode

Actions/q

Scriptsscripts/benchmark-db/cases.ts

function

findInGameNameByUserId

no JSDoc:1189

export async function findInGameNameByUserId(userId: number)

TablesUser

Scriptsscripts/add-leaderboard-teams-to-tournament.ts/add-leaderboard-teams-to-tournament.tsscripts/benchmark-db/cases.ts

function

findPatronStartedAtByUserId

no JSDoc:1199

export async function findPatronStartedAtByUserId(userId: number)

TablesUser

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findDivByUserId

:1210

Division and season of the last LUTI the user placed in, null when they never have.

export async function findDivByUserId(userId: number)

TablesUser

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findJoinOrderByUserId

no JSDoc:1222

export async function findJoinOrderByUserId(userId: number)

TablesUser

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findCommissionsByUserId

no JSDoc:1237

export async function findCommissionsByUserId(userId: number)

TablesUser

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

insertFriendCode

no JSDoc:1249

export function insertFriendCode(args: TablesInsertable["UserFriendCode"])

TablesUserFriendCode

Actions/admin/q

Otherapp/db/UserFactory.ts

function

upsert

:1256

Inserts or updates the user by Discord id. The avatar is stored separately via {@link replaceSyncedAvatar}.

export function upsert(
	args: Pick<
		TablesInsertable["User"],
		| "discordId"
		| "discordName"
		| "discordUniqueName"
		| "twitch"
		| "youtubeId"
		| "youtubeName"
		| "bsky"
	>,
)

TablesUser

Modulesauth/DiscordStrategy.server.ts

Otherapp/db/UserFactory.ts/auth/auth/callback/auth/refresh/auth/create-link/auth/login/auth/logout/auth/impersonate/auth/impersonate/stop

function

replaceSyncedAvatar

:1296

Points the user's synced avatar at a newly stored image file (null = no avatar) and deletes the previous image row. Returns the previous file name so its files can be deleted from storage.

export function replaceSyncedAvatar({
	userId,
	discordAvatar,
	fileName,
}: {
	userId: number;
	/** Hash of the Discord avatar the file was copied from. */
	discordAvatar: string | null;
	fileName: string | null;
})

TablesUnvalidatedUserSubmittedImageUser

Modulesauth/DiscordAvatar.server.ts

Otherapp/db/UserFactory.ts

function

updateOwnProfile

no JSDoc:1364

export function updateOwnProfile(args: UpdateProfileArgs)

TablesUnvalidatedUserSubmittedImageUser

CallsTournamentTeamRepository.updateOwnMemberInGameNameForNonStarted

Actions/u/:identifier/edit

Otherapp/db/UserFactory.ts

function

updateManyDivs

:1420

Bulk-sets each user's latest LUTI division. Used by the ComputeLutiDivs routine.

export function updateManyDivs(
	updates: Array<{ userId: number; div: string; divSeason: number | null }>,
)

TablesUser

Routinesapp/routines/computeLutiDivs.ts

Otherapp/db/UserFactory.ts

function

updateOwnCustomTheme

no JSDoc:1436

export function updateOwnCustomTheme(css: CustomTheme | null)

TablesUser

Actions/settings

Otherapp/db/UserFactory.ts

function

updateOwnPreferences

no JSDoc:1446

export function updateOwnPreferences(newPreferences: UserPreferences)

TablesUser

Actions/events/calendar/scrims/settings

Otherapp/db/UserFactory.ts

function

updateOwnResultHighlights

no JSDoc:1477

export function updateOwnResultHighlights(args: UpdateResultHighlightsArgs)

TablesTournamentResultUserResultHighlight

Actions/u/:identifier/results/highlights

Otherapp/db/ResultHighlightFactory.ts

function

updateOwnBuildSorting

no JSDoc:1520

export function updateOwnBuildSorting(buildSorting: BuildSort[] | null)

TablesUser

Actions/u/:identifier/builds

function

updatePatronData

no JSDoc:1531

export function updatePatronData(users: UpdatePatronDataArgs)

TablesUser

Otherapp/modules/updater.ts

function

anyUserPrefersNoScreen

no JSDoc:1562

export async function anyUserPrefersNoScreen(
	userIds: number[],
): Promise<boolean>

TablesUser

Loaders/scrims/:id/to/:id/matches/:mid

Scriptsscripts/benchmark-db/cases.ts

function

findSocialLinksByUserId

no JSDoc:1577

export async function findSocialLinksByUserId(userId: number)

TablesUser

Scriptsscripts/benchmark-db/cases.ts

Otheruser-page/portfolio-loaders.server.ts

function

findIdsByStreamAccounts

:1639

Users whose connected Twitch login or YouTube channel id is among the given ones.

export function findIdsByStreamAccounts({
	twitchNames,
	youtubeIds,
}: {
	twitchNames: string[];
	youtubeIds: string[];
})

TablesUser

Routinesapp/routines/syncLiveStreams.ts

Scriptsscripts/benchmark-db/cases.ts