Update charges rows on user deletion

* Add noindex to pages that should be private

* fix unused

apps/frontend/src/locales/en-US/index.json

@@ -1064,12 +1064,6 @@
   "frog.altText": {
     "message": "A photorealistic painting of a frog labyrinth"
   },
-  "frog.froggedPeople": {
-    "message": "{count, plural, one {{count} more person} other {{count} more people}} were also frogged!"
-  },
-  "frog.sinceOpened": {
-    "message": "This page was opened {ago}"
-  },
   "frog.title": {
     "message": "Frog"
   },

apps/frontend/src/pages/[type]/[id].vue

@@ -2057,6 +2057,10 @@ if (!route.name.startsWith('type-id-settings')) {
 				? 'all'
 				: 'noindex',
 	})
+} else {
+	useSeoMeta({
+		robots: 'noindex',
+	})
 }
 
 const onUserCollectProject = useClientTry(userCollectProject)

apps/frontend/src/pages/admin.vue

@@ -0,0 +1,8 @@
+<script setup lang="ts">
+useSeoMeta({
+	robots: 'noindex',
+})
+</script>
+<template>
+	<NuxtPage />
+</template>

apps/frontend/src/pages/auth.vue

@@ -2,6 +2,10 @@
 definePageMeta({
 	middleware: ['launcher-auth'],
 })
+
+useSeoMeta({
+	robots: 'noindex',
+})
 </script>
 <template>
 	<NuxtPage class="auth-container universal-card" />

apps/frontend/src/pages/dashboard.vue

@@ -60,5 +60,9 @@ definePageMeta({
 	middleware: 'auth',
 })
 
+useSeoMeta({
+	robots: 'noindex',
+})
+
 const route = useNativeRoute()
 </script>

apps/frontend/src/pages/flags.vue

@@ -29,6 +29,10 @@ const filteredFlags = computed(() => {
 	}
 	return fuse.value.search(searchQuery.value).map((result) => result.item)
 })
+
+useSeoMeta({
+	robots: 'noindex',
+})
 </script>
 
 <template>

apps/frontend/src/pages/frog.vue

@@ -1,5 +1,5 @@
 <script setup lang="ts">
-import { defineMessages, useRelativeTime, useVIntl } from '@modrinth/ui'
+import { defineMessages, useVIntl } from '@modrinth/ui'
 
 const vintl = useVIntl()
 const { formatMessage } = vintl
@@ -17,36 +17,11 @@ const messages = defineMessages({
 		id: 'frog.altText',
 		defaultMessage: 'A photorealistic painting of a frog labyrinth',
 	},
-	frogSinceOpened: {
-		id: 'frog.sinceOpened',
-		defaultMessage: 'This page was opened {ago}',
-	},
-	frogFroggedPeople: {
-		id: 'frog.froggedPeople',
-		defaultMessage:
-			'{count, plural, one {{count} more person} other {{count} more people}} were also frogged!',
-	},
 })
 
-const formatCompactNumber = useCompactNumber()
-
-const formatRelativeTime = useRelativeTime()
-
-const pageOpen = useState('frogPageOpen', () => Date.now())
-const peopleFrogged = useState('frogPeopleFrogged', () => Math.round(Math.random() * 100_000_000))
-const peopleFroggedCount = computed(() => formatCompactNumber(peopleFrogged.value))
-
-let interval: ReturnType<typeof setTimeout>
-
-const formattedOpenedCounter = ref(formatRelativeTime(Date.now()))
-
-onMounted(() => {
-	interval = setInterval(() => {
-		formattedOpenedCounter.value = formatRelativeTime(pageOpen.value)
-	}, 1000)
+useSeoMeta({
+	robots: 'noindex',
 })
-
-onUnmounted(() => clearInterval(interval))
 </script>
 
 <template>
@@ -54,8 +29,6 @@ onUnmounted(() => clearInterval(interval))
 		<h1>{{ formatMessage(messages.frogTitle) }}</h1>
 		<p>{{ formatMessage(messages.frogDescription) }}</p>
 		<img src="https://cdn.modrinth.com/frog.png" :alt="formatMessage(messages.frogAltText)" />
-		<p>{{ formatMessage(messages.frogSinceOpened, { ago: formattedOpenedCounter }) }}</p>
-		<p>{{ formatMessage(messages.frogFroggedPeople, { count: peopleFroggedCount }) }}</p>
 	</div>
 </template>
 

apps/frontend/src/pages/hosting/admin/index.vue

@@ -1,11 +0,0 @@
-<template>
-	<div class="flex h-full w-full flex-col">
-		<div
-			class="flex items-center justify-between gap-2 border-0 border-b border-solid border-bg-raised p-3"
-		>
-			<h2 class="m-0 text-2xl font-bold text-contrast">Admin</h2>
-		</div>
-	</div>
-</template>
-
-<script setup lang="ts"></script>

apps/frontend/src/pages/moderation.vue

@@ -26,6 +26,10 @@ definePageMeta({
 	middleware: 'auth',
 })
 
+useSeoMeta({
+	robots: 'noindex',
+})
+
 const { formatMessage } = useVIntl()
 const route = useRoute()
 const router = useRouter()

apps/frontend/src/pages/organization/[id].vue

@@ -300,6 +300,12 @@ const config = useRuntimeConfig()
 
 const orgId = useRouteId()
 
+if (route.path.includes('settings')) {
+	useSeoMeta({
+		robots: 'noindex',
+	})
+}
+
 // hacky way to show the edit button on the corner of the card.
 const routeHasSettings = computed(() => route.path.includes('settings'))
 

apps/frontend/src/pages/settings.vue

@@ -101,4 +101,8 @@ const { formatMessage } = useVIntl()
 
 const route = useNativeRoute()
 const auth = await useAuth()
+
+useSeoMeta({
+	robots: 'noindex',
+})
 </script>

apps/labrinth/.sqlx/query-f1f93419f4394c702f256fe3e5de0368ee972ed20bd4d4b2490c655fde999dda.json

@@ -0,0 +1,15 @@
+{
+  "db_name": "PostgreSQL",
+  "query": "\n                UPDATE charges\n                SET user_id = $1\n                WHERE user_id = $2\n                ",
+  "describe": {
+    "columns": [],
+    "parameters": {
+      "Left": [
+        "Int8",
+        "Int8"
+      ]
+    },
+    "nullable": []
+  },
+  "hash": "f1f93419f4394c702f256fe3e5de0368ee972ed20bd4d4b2490c655fde999dda"
+}

apps/labrinth/src/database/models/user_item.rs

@@ -797,6 +797,18 @@ impl DBUser {
             .execute(&mut *transaction)
             .await?;
 
+            sqlx::query!(
+                "
+                UPDATE charges
+                SET user_id = $1
+                WHERE user_id = $2
+                ",
+                deleted_user as DBUserId,
+                id as DBUserId,
+            )
+            .execute(&mut *transaction)
+            .await?;
+
             let open_subscriptions =
                 DBUserSubscription::get_all_user(id, &mut *transaction).await?;
 

packages/utils/changelog.ts

@@ -10,6 +10,13 @@ export type VersionEntry = {
 }
 
 const VERSIONS: VersionEntry[] = [
+	{
+		date: `2026-01-30T13:10:00-08:00`,
+		product: 'web',
+		body: `## Improvements
+- Fixed more version caching issues.
+- Disabled indexing on many non-public pages.`,
+	},
 	{
 		date: `2026-01-30T08:00:00-08:00`,
 		product: 'web',