[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_163":164,"_165":166},"routes/_app.x.$handle.$name",{"_103":102,"_38":51,"_111":93,"_33":59,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_26":-5,"_122":-5,"_123":-5,"_124":31,"_125":126,"_127":31,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":-5,"_63":31,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":31},"version",10,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","5a4e1e01-69c6-409f-83d9-f6fa7586fcc5","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","7a9c56ce-5e9a-11f1-98aa-1607ee4eb77e","name","fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Ensure tables exist\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS malcraft_last_online (\n username TEXT PRIMARY KEY,\n seen_at INTEGER NOT NULL\n )\n`);\n\n// Track when each player joined the current session (cleared when they go offline)\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS malcraft_session_start (\n username TEXT PRIMARY KEY,\n joined_at INTEGER NOT NULL\n )\n`);\n\n// Returns <@discord_id> if the username is in the malcraft_discord_id table, else returns the username as-is\nasync function resolveDisplayName(username: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT discord_id FROM malcraft_discord_id WHERE username = ? COLLATE NOCASE LIMIT 1`,\n args: [username],\n });\n if (result.rows.length > 0) {\n return `<@${result.rows[0][0]}>`;\n }\n return username;\n}\n\nexport default async function (interval: Interval) {\n const DISCORD_TOKEN = Deno.env.get(\"DISCORD_TOKEN\");\n const DISCORD_CHANNEL_ID = Deno.env.get(\"DISCORD_CHANNEL_ID\");\n\n if (!DISCORD_TOKEN || !DISCORD_CHANNEL_ID) {\n throw new Error(\"Missing DISCORD_TOKEN or DISCORD_CHANNEL_ID env vars\");\n }\n\n // --- 1. Fetch Minecraft server status ---\n const statusRes = await fetch(\n \"https://api.mcstatus.io/v2/status/java/malcraft.lloc.ca\",\n );\n if (!statusRes.ok) throw new Error(`mcstatus API error: ${statusRes.status}`);\n const status = await statusRes.json();\n\n const onlinePlayers: string[] = (status.players?.list ?? []).map(\n (p: { name_clean: string }) => p.name_clean,\n );\n const nowMs = Date.now();\n const nowSec = Math.floor(nowMs / 1000);\n\n let topic: string;\n\n if (onlinePlayers.length > 0) {\n // --- 2a. Players online ---\n\n // Find who's currently tracked as in a session\n const sessionResult = await sqlite.execute(\n `SELECT username FROM malcraft_session_start`,\n );\n const inSession = new Set(sessionResult.rows.map((r) => String(r[0])));\n\n // Start sessions for newly-joined players\n for (const username of onlinePlayers) {\n if (!inSession.has(username)) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO malcraft_session_start (username, joined_at) VALUES (?, ?)`,\n args: [username, nowMs],\n });\n }\n }\n\n // Remove sessions for players who left\n for (const username of inSession) {\n if (!onlinePlayers.includes(username)) {\n await sqlite.execute({\n sql: `DELETE FROM malcraft_session_start WHERE username = ?`,\n args: [username],\n });\n }\n }\n\n // Upsert last-seen for each online player\n for (const username of onlinePlayers) {\n await sqlite.execute({\n sql: `INSERT INTO malcraft_last_online (username, seen_at) VALUES (?, ?)\n ON CONFLICT(username) DO UPDATE SET seen_at = excluded.seen_at`,\n args: [username, nowMs],\n });\n }\n\n // Build topic: show each player with their session start time\n const playerStrings: string[] = [];\n for (const username of onlinePlayers) {\n const sessionRow = await sqlite.execute({\n sql: `SELECT joined_at FROM malcraft_session_start WHERE username = ?`,\n args: [username],\n });\n const joinedAt = sessionRow.rows.length > 0\n ? Math.floor(Number(sessionRow.rows[0][0]) / 1000)\n : nowSec;\n const displayName = await resolveDisplayName(username);\n playerStrings.push(`${displayName} (online since )`);\n }\n\n topic = `Malcraft - Online: ${playerStrings.join(\", \")}`;\n } else {\n // --- 2b. No players online: clear all sessions ---\n await sqlite.execute(`DELETE FROM malcraft_session_start`);\n\n // Find most recently seen player\n const result = await sqlite.execute(\n `SELECT username, seen_at FROM malcraft_last_online ORDER BY seen_at DESC LIMIT 1`,\n );\n\n if (result.rows.length > 0) {\n const row = result.rows[0];\n const username = String(row[0]);\n const seenAtSec = Math.floor(Number(row[1]) / 1000);\n topic = `Malcraft - Last online: ${username} `;\n } else {\n topic = \"Malcraft - No recent activity\";\n }\n }\n\n // --- 3. Fetch current channel topic and only update if changed ---\n const channelRes = await fetch(\n `https://discord.com/api/v10/channels/${DISCORD_CHANNEL_ID}`,\n {\n headers: {\n Authorization: `Bot ${DISCORD_TOKEN}`,\n },\n },\n );\n if (!channelRes.ok) {\n const err = await channelRes.text();\n throw new Error(`Discord GET channel error ${channelRes.status}: ${err}`);\n }\n const channelData = await channelRes.json();\n const currentTopic: string = channelData.topic ?? \"\";\n\n if (currentTopic === topic) {\n console.log(`Topic unchanged, skipping update: \"${topic}\"`);\n return;\n }\n\n // --- 4. Update Discord channel topic ---\n const discordRes = await fetch(\n `https://discord.com/api/v10/channels/${DISCORD_CHANNEL_ID}`,\n {\n method: \"PATCH\",\n headers: {\n Authorization: `Bot ${DISCORD_TOKEN}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ topic }),\n },\n );\n\n if (!discordRes.ok) {\n const err = await discordRes.text();\n throw new Error(`Discord PATCH error ${discordRes.status}: ${err}`);\n }\n\n console.log(`Updated channel topic to: \"${topic}\"`);\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Ensure tables exist\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS malcraft_last_online (\n username TEXT PRIMARY KEY,\n seen_at INTEGER NOT NULL\n )\n`);\n\n// Track when each player joined the current session (cleared when they go offline)\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS malcraft_session_start (\n username TEXT PRIMARY KEY,\n joined_at INTEGER NOT NULL\n )\n`);\n\n// Returns <@discord_id> if the username is in the malcraft_discord_id table, else returns the username as-is\nasync function resolveDisplayName(username: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT discord_id FROM malcraft_discord_id WHERE username = ? COLLATE NOCASE LIMIT 1`,\n args: [username],\n });\n if (result.rows.length > 0) {\n return `<@${result.rows[0][0]}>`;\n }\n return username;\n}\n\nexport default async function (interval: Interval) {\n const DISCORD_TOKEN = Deno.env.get(\"DISCORD_TOKEN\");\n const DISCORD_CHANNEL_ID = Deno.env.get(\"DISCORD_CHANNEL_ID\");\n\n if (!DISCORD_TOKEN || !DISCORD_CHANNEL_ID) {\n throw new Error(\"Missing DISCORD_TOKEN or DISCORD_CHANNEL_ID env vars\");\n }\n\n // --- 1. Fetch Minecraft server status ---\n const statusRes = await fetch(\n \"https://api.mcstatus.io/v2/status/java/malcraft.lloc.ca\",\n );\n if (!statusRes.ok) throw new Error(`mcstatus API error: ${statusRes.status}`);\n const status = await statusRes.json();\n\n const onlinePlayers: string[] = (status.players?.list ?? []).map(\n (p: { name_clean: string }) => p.name_clean,\n );\n const nowMs = Date.now();\n const nowSec = Math.floor(nowMs / 1000);\n\n let topic: string;\n\n if (onlinePlayers.length > 0) {\n // --- 2a. Players online ---\n\n // Find who's currently tracked as in a session\n const sessionResult = await sqlite.execute(\n `SELECT username FROM malcraft_session_start`,\n );\n const inSession = new Set(sessionResult.rows.map((r) => String(r[0])));\n\n // Start sessions for newly-joined players\n for (const username of onlinePlayers) {\n if (!inSession.has(username)) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO malcraft_session_start (username, joined_at) VALUES (?, ?)`,\n args: [username, nowMs],\n });\n }\n }\n\n // Remove sessions for players who left\n for (const username of inSession) {\n if (!onlinePlayers.includes(username)) {\n await sqlite.execute({\n sql: `DELETE FROM malcraft_session_start WHERE username = ?`,\n args: [username],\n });\n }\n }\n\n // Upsert last-seen for each online player\n for (const username of onlinePlayers) {\n await sqlite.execute({\n sql: `INSERT INTO malcraft_last_online (username, seen_at) VALUES (?, ?)\n ON CONFLICT(username) DO UPDATE SET seen_at = excluded.seen_at`,\n args: [username, nowMs],\n });\n }\n\n // Build topic: show each player with their session start time\n const playerStrings: string[] = [];\n for (const username of onlinePlayers) {\n const sessionRow = await sqlite.execute({\n sql: `SELECT joined_at FROM malcraft_session_start WHERE username = ?`,\n args: [username],\n });\n const joinedAt = sessionRow.rows.length > 0\n ? Math.floor(Number(sessionRow.rows[0][0]) / 1000)\n : nowSec;\n const displayName = await resolveDisplayName(username);\n playerStrings.push(`${displayName} (online since )`);\n }\n\n topic = `Malcraft - Online: ${playerStrings.join(\", \")}`;\n } else {\n // --- 2b. No players online: clear all sessions ---\n await sqlite.execute(`DELETE FROM malcraft_session_start`);\n\n // Find most recently seen player\n const result = await sqlite.execute(\n `SELECT username, seen_at FROM malcraft_last_online ORDER BY seen_at DESC LIMIT 1`,\n );\n\n if (result.rows.length > 0) {\n const row = result.rows[0];\n const username = String(row[0]);\n const seenAtSec = Math.floor(Number(row[1]) / 1000);\n const displayName = await resolveDisplayName(username);\n topic = `Malcraft - Last online: ${displayName} `;\n } else {\n topic = \"Malcraft - No recent activity\";\n }\n }\n\n // --- 3. Fetch current channel topic and only update if changed ---\n const channelRes = await fetch(\n `https://discord.com/api/v10/channels/${DISCORD_CHANNEL_ID}`,\n {\n headers: {\n Authorization: `Bot ${DISCORD_TOKEN}`,\n },\n },\n );\n if (!channelRes.ok) {\n const err = await channelRes.text();\n throw new Error(`Discord GET channel error ${channelRes.status}: ${err}`);\n }\n const channelData = await channelRes.json();\n const currentTopic: string = channelData.topic ?? \"\";\n\n if (currentTopic === topic) {\n console.log(`Topic unchanged, skipping update: \"${topic}\"`);\n return;\n }\n\n // --- 4. Update Discord channel topic ---\n const discordRes = await fetch(\n `https://discord.com/api/v10/channels/${DISCORD_CHANNEL_ID}`,\n {\n method: \"PATCH\",\n headers: {\n Authorization: `Bot ${DISCORD_TOKEN}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ topic }),\n },\n );\n\n if (!discordRes.ok) {\n const err = await discordRes.text();\n throw new Error(`Discord PATCH error ${discordRes.status}: ${err}`);\n }\n\n console.log(`Updated channel topic to: \"${topic}\"`);\n}\n","createdAt",["D",1780980435683],"branchVersion","branchId","7a9888c8-5e9a-11f1-98aa-1607ee4eb77e","id","7a978e8c-5e9a-11f1-98aa-1607ee4eb77e","malcraft-discord-status",["D",1780415299991],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","a1d0e4c8-d265-47e7-85e3-a6792491909e","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","7f65624b-9d7b-4602-8ad8-76f192e91e6d","tursoName","7a978e8c5e9a11f198aa1607ee4eb77e","tursoHostname","7a978e8c5e9a11f198aa1607ee4eb77e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789497655664],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_110":106},"org",{"_103":102,"_104":-5,"_105":106,"_19":61,"_107":108,"_109":31},"branch",{"_13":14,"_38":93,"_49":48,"_94":50,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":51,"_101":102},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","malloc","handle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2P7WUduqm1PfyC50trwmmnvym5L.jpeg","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_49":50,"_38":51,"_44":158,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":-5,"_63":31,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":159,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":160,"_88":161,"_90":162,"_92":31},"tree",[153],"files",[153],"counts",{"_141":67,"_142":143,"_144":67,"_145":146,"_147":148},"contents",[132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":133,"_38":34,"_36":37,"_134":-5,"_47":48,"_46":14,"_135":136,"_44":137,"_13":138,"_39":40,"_41":43,"_30":31,"_139":-5,"_33":140},"1be8491b-b582-48f9-ae56-13a7bd14a048","parentId","latest",true,["D",1780980435683],9,"label",[34],"pulls","branches",1,"forks","envVars",{"_149":151,"_152":67},"connections",{"_149":67,"_150":67},"count","unfilledCount",2,"emptyCount",{"_49":133,"_38":34,"_36":37,"_134":-5,"_47":48,"_46":14,"_135":136,"_44":154,"_13":138,"_39":40,"_41":43,"_30":31,"_139":-5,"_155":156,"_33":157},["D",1780980435683],"children",[],[34],["D",1780415299991],["D",1789497655664],{"_103":102,"_110":106},{"_103":102,"_104":-5,"_105":106,"_19":61,"_107":108,"_109":31},{"_13":14,"_38":93,"_49":48,"_94":50,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":51,"_101":102},"ctx",{"_86":-5,"_129":196,"_197":198,"_199":200,"_201":31,"_202":31,"_203":31,"_204":136,"_205":-5,"_206":-7,"_207":-7,"_208":67,"_209":31,"_210":31,"_211":-5,"_212":31,"_213":31,"_214":31,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":93,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v10