[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_107":108,"_109":110},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","kubeniz","name","arthion-atlas","path","db.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/kubeniz/arthion-atlas/code/db.ts","extension","id","49f84e93-325f-49d7-b64a-373f447e81f4","fileId","01a07e97-dc4a-73bc-8d45-7b429ccda84a","parentId","branchId","1c5a54fc-7258-41d1-a35b-94740edbafba","branchVersion",233,"latest",true,"createdAt",["D",1789515739795],"version",15,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Entry {\n id: number;\n map_name: string;\n category: string;\n entry_name: string;\n notes: string | null;\n submitted_by: string | null;\n pin_x: number;\n pin_y: number;\n created_at: string;\n edit_token: string;\n}\n\nexport interface MapInfo {\n name: string;\n image_url: string;\n display_order: number;\n}\n\nexport interface LeaderboardRow {\n submittedBy: string;\n total: number;\n byCategory: Record;\n}\n\nexport const CATEGORIES: { value: string; label: string }[] = [\n { value: \"boss\", label: \"Boss\" },\n { value: \"miniboss\", label: \"Mini-Boss\" },\n { value: \"npc\", label: \"NPC\" },\n { value: \"resource\", label: \"Resource\" },\n { value: \"metin\", label: \"Metin\" },\n { value: \"other\", label: \"Other\" },\n];\n\nexport const EDIT_WINDOW_MS = 60 * 60 * 1000; // 1 hour\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS maps (\n name TEXT PRIMARY KEY,\n image_url TEXT NOT NULL,\n display_order INTEGER NOT NULL DEFAULT 0\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS entries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n map_name TEXT NOT NULL,\n category TEXT NOT NULL,\n entry_name TEXT NOT NULL,\n notes TEXT,\n submitted_by TEXT,\n pin_x REAL NOT NULL,\n pin_y REAL NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n edit_token TEXT NOT NULL DEFAULT ''\n)`);\n\n// Defensive migration: if this table already existed from before edit_token was introduced,\n// make sure the column is there (no-op / throws harmlessly if it already exists).\ntry {\n await sqlite.execute(`ALTER TABLE entries ADD COLUMN edit_token TEXT NOT NULL DEFAULT ''`);\n} catch {\n // column already exists — fine\n}\n\nexport function isEntryEditable(entry: Pick): boolean {\n const createdMs = new Date(entry.created_at.replace(\" \", \"T\") + \"Z\").getTime();\n return Date.now() - createdMs <= EDIT_WINDOW_MS;\n}\n\nexport function canManage(\n entry: Pick,\n opts: { isAdmin: boolean; token: string | null },\n): boolean {\n if (opts.isAdmin) return true;\n return !!opts.token && opts.token === entry.edit_token && entry.edit_token !== \"\";\n}\n\nexport async function listMaps(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM maps ORDER BY display_order ASC\");\n return result.rows as unknown as MapInfo[];\n}\n\nexport async function getMap(name: string): Promise {\n const result = await sqlite.execute({ sql: \"SELECT * FROM maps WHERE name = ?\", args: [name] });\n return (result.rows[0] as unknown as MapInfo) ?? null;\n}\n\nexport async function addEntry(entry: {\n mapName: string;\n category: string;\n entryName: string;\n notes: string;\n submittedBy: string;\n pinX: number;\n pinY: number;\n}): Promise<{ id: number; editToken: string }> {\n const editToken = crypto.randomUUID();\n const result = await sqlite.execute({\n sql:\n \"INSERT INTO entries (map_name, category, entry_name, notes, submitted_by, pin_x, pin_y, edit_token) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\",\n args: [\n entry.mapName,\n entry.category,\n entry.entryName,\n entry.notes || null,\n entry.submittedBy || null,\n entry.pinX,\n entry.pinY,\n editToken,\n ],\n });\n return { id: Number(result.lastInsertRowid), editToken };\n}\n\nexport async function getEntry(id: number): Promise {\n const result = await sqlite.execute({ sql: \"SELECT * FROM entries WHERE id = ?\", args: [id] });\n return (result.rows[0] as unknown as Entry) ?? null;\n}\n\nexport async function updateEntry(id: number, fields: {\n category: string;\n entryName: string;\n notes: string;\n pinX: number;\n pinY: number;\n}) {\n await sqlite.execute({\n sql: \"UPDATE entries SET category = ?, entry_name = ?, notes = ?, pin_x = ?, pin_y = ? WHERE id = ?\",\n args: [fields.category, fields.entryName, fields.notes || null, fields.pinX, fields.pinY, id],\n });\n}\n\nexport async function deleteEntry(id: number) {\n await sqlite.execute({ sql: \"DELETE FROM entries WHERE id = ?\", args: [id] });\n}\n\nexport async function listEntriesForMap(mapName: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM entries WHERE map_name = ? ORDER BY created_at ASC, id ASC\",\n args: [mapName],\n });\n return result.rows as unknown as Entry[];\n}\n\nexport async function countEntriesByMap(): Promise> {\n const result = await sqlite.execute(\"SELECT map_name, COUNT(*) as c FROM entries GROUP BY map_name\");\n const rows = result.rows as unknown as { map_name: string; c: number }[];\n return Object.fromEntries(rows.map((r) => [r.map_name, Number(r.c)]));\n}\n\nexport async function countEntries(): Promise {\n const result = await sqlite.execute(\"SELECT COUNT(*) as c FROM entries\");\n return Number((result.rows[0] as unknown as { c: number }).c);\n}\n\nexport async function listLeaderboard(): Promise {\n const [entryResult, upgradeResult] = await Promise.all([\n sqlite.execute(\n \"SELECT submitted_by, category, COUNT(*) as c FROM entries WHERE submitted_by IS NOT NULL AND TRIM(submitted_by) != '' GROUP BY submitted_by, category\",\n ),\n sqlite.execute(\n \"SELECT submitted_by, COUNT(*) as c FROM upgrade_submissions WHERE status = 'confirmed' AND submitted_by IS NOT NULL AND TRIM(submitted_by) != '' GROUP BY submitted_by\",\n ),\n ]);\n const rows = entryResult.rows as unknown as { submitted_by: string; category: string; c: number }[];\n const upgradeRows = upgradeResult.rows as unknown as { submitted_by: string; c: number }[];\n\n const byName = new Map();\n for (const row of rows) {\n const existing = byName.get(row.submitted_by) ?? { submittedBy: row.submitted_by, total: 0, byCategory: {} };\n existing.total += Number(row.c);\n existing.byCategory[row.category] = Number(row.c);\n byName.set(row.submitted_by, existing);\n }\n for (const row of upgradeRows) {\n const existing = byName.get(row.submitted_by) ?? { submittedBy: row.submitted_by, total: 0, byCategory: {} };\n existing.total += Number(row.c);\n existing.byCategory[\"upgrade\"] = (existing.byCategory[\"upgrade\"] ?? 0) + Number(row.c);\n byName.set(row.submitted_by, existing);\n }\n\n return Array.from(byName.values()).sort((a, b) => b.total - a.total || a.submittedBy.localeCompare(b.submittedBy));\n}\n\n// --- Upgrade material discovery wiki ---\n\nexport interface UpgradeItem {\n id: number;\n name: string;\n weapon_type: string;\n level_requirement: number;\n status: \"undiscovered\" | \"confirmed\";\n image_url: string | null;\n created_at: string;\n}\n\nexport interface LevelMaterials {\n materials: string[];\n gold: number | null;\n}\n\nexport type ParsedUpgradeData = Record; // key: \"1\"..\"9\"\n\nexport interface UpgradeSubmission {\n id: string;\n item_id: number;\n screenshot_blob_key: string;\n parsed_data: string | null; // JSON string of ParsedUpgradeData\n submitted_by: string | null;\n status: \"pending_review\" | \"confirmed\" | \"rejected\";\n created_at: string;\n confirmed_at: string | null;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS upgrade_items (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n weapon_type TEXT NOT NULL,\n level_requirement INTEGER NOT NULL DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'undiscovered',\n image_url TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS upgrade_submissions (\n id TEXT PRIMARY KEY,\n item_id INTEGER NOT NULL REFERENCES upgrade_items(id),\n screenshot_blob_key TEXT NOT NULL,\n parsed_data TEXT,\n submitted_by TEXT,\n status TEXT NOT NULL DEFAULT 'pending_review',\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n confirmed_at TEXT\n)`);\n\nexport async function listUpgradeItems(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM upgrade_items ORDER BY weapon_type ASC, level_requirement ASC, name ASC\",\n );\n return result.rows as unknown as UpgradeItem[];\n}\n\nexport async function getUpgradeItem(id: number): Promise {\n const result = await sqlite.execute({ sql: \"SELECT * FROM upgrade_items WHERE id = ?\", args: [id] });\n return (result.rows[0] as unknown as UpgradeItem) ?? null;\n}\n\nexport async function getConfirmedSubmissionForItem(itemId: number): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM upgrade_submissions WHERE item_id = ? AND status = 'confirmed' ORDER BY confirmed_at DESC LIMIT 1\",\n args: [itemId],\n });\n return (result.rows[0] as unknown as UpgradeSubmission) ?? null;\n}\n\nexport async function getLatestSubmissionForItem(itemId: number): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM upgrade_submissions WHERE item_id = ? ORDER BY created_at DESC LIMIT 1\",\n args: [itemId],\n });\n return (result.rows[0] as unknown as UpgradeSubmission) ?? null;\n}\n\nexport interface PendingSubmission extends UpgradeSubmission {\n item_name: string;\n weapon_type: string;\n}\n\nexport async function listPendingSubmissions(): Promise {\n const result = await sqlite.execute(\n `SELECT us.*, ui.name as item_name, ui.weapon_type as weapon_type\n FROM upgrade_submissions us\n JOIN upgrade_items ui ON ui.id = us.item_id\n WHERE us.status = 'pending_review'\n ORDER BY us.created_at ASC`,\n );\n return result.rows as unknown as PendingSubmission[];\n}\n\n// Used by the admin bulk-download feature. \"all\" covers every submission regardless of status\n// (pending_review / confirmed / rejected) so a full-archive download is possible too.\nexport async function listSubmissionsByStatus(\n status: \"pending_review\" | \"confirmed\" | \"rejected\" | \"all\",\n): Promise {\n const result = status === \"all\"\n ? await sqlite.execute(\n `SELECT us.*, ui.name as item_name, ui.weapon_type as weapon_type\n FROM upgrade_submissions us\n JOIN upgrade_items ui ON ui.id = us.item_id\n ORDER BY us.created_at ASC`,\n )\n : await sqlite.execute({\n sql:\n `SELECT us.*, ui.name as item_name, ui.weapon_type as weapon_type\n FROM upgrade_submissions us\n JOIN upgrade_items ui ON ui.id = us.item_id\n WHERE us.status = ?\n ORDER BY us.created_at ASC`,\n args: [status],\n });\n return result.rows as unknown as PendingSubmission[];\n}\n\nexport async function countPendingSubmissions(): Promise {\n const result = await sqlite.execute(\n \"SELECT COUNT(*) as c FROM upgrade_submissions WHERE status = 'pending_review'\",\n );\n return Number((result.rows[0] as unknown as { c: number }).c);\n}\n\nexport async function createUpgradeSubmission(fields: {\n itemId: number;\n screenshotBlobKey: string;\n parsedData: ParsedUpgradeData | null;\n submittedBy: string;\n}): Promise {\n const id = crypto.randomUUID();\n await sqlite.execute({\n sql:\n \"INSERT INTO upgrade_submissions (id, item_id, screenshot_blob_key, parsed_data, submitted_by) VALUES (?, ?, ?, ?, ?)\",\n args: [\n id,\n fields.itemId,\n fields.screenshotBlobKey,\n fields.parsedData ? JSON.stringify(fields.parsedData) : null,\n fields.submittedBy || null,\n ],\n });\n const result = await sqlite.execute({ sql: \"SELECT * FROM upgrade_submissions WHERE id = ?\", args: [id] });\n return result.rows[0] as unknown as UpgradeSubmission;\n}\n\nexport async function getUpgradeSubmission(id: string): Promise {\n const result = await sqlite.execute({ sql: \"SELECT * FROM upgrade_submissions WHERE id = ?\", args: [id] });\n return (result.rows[0] as unknown as UpgradeSubmission) ?? null;\n}\n\nexport async function confirmUpgradeSubmission(id: string, parsedData: ParsedUpgradeData): Promise {\n const submission = await getUpgradeSubmission(id);\n if (!submission) throw new Error(\"Submission not found\");\n // If every level was left blank, don't mark this \"confirmed\" — that would hide the screenshot's\n // real data behind a blank level table with no way back into the pending queue. Save it as\n // pending_review instead so it stays visible on /upgrades/pending until someone fills it in.\n const hasAnyData = Object.values(parsedData).some((row) => row.gold != null || row.materials.length > 0);\n await sqlite.execute({\n sql: \"UPDATE upgrade_submissions SET status = ?, parsed_data = ?, confirmed_at = ? WHERE id = ?\",\n args: [\n hasAnyData ? \"confirmed\" : \"pending_review\",\n JSON.stringify(parsedData),\n hasAnyData ? new Date().toISOString().replace(\"T\", \" \").slice(0, 19) : null,\n id,\n ],\n });\n if (hasAnyData) {\n await sqlite.execute({\n sql: \"UPDATE upgrade_items SET status = 'confirmed' WHERE id = ?\",\n args: [submission.item_id],\n });\n }\n}\n\nexport async function rejectUpgradeSubmission(id: string): Promise {\n await sqlite.execute({ sql: \"UPDATE upgrade_submissions SET status = 'rejected' WHERE id = ?\", args: [id] });\n}\n\nexport async function deleteUpgradeSubmission(id: string): Promise {\n await sqlite.execute({ sql: \"DELETE FROM upgrade_submissions WHERE id = ?\", args: [id] });\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS material_icons (\n name TEXT PRIMARY KEY,\n image_url TEXT NOT NULL\n)`);\n\nexport async function listMaterialIcons(): Promise> {\n const result = await sqlite.execute(\"SELECT name, image_url FROM material_icons\");\n const rows = result.rows as unknown as { name: string; image_url: string }[];\n return Object.fromEntries(rows.map((r) => [r.name, r.image_url]));\n}\n\n// Splits a submitted materials entry like \"Piece of Ice+ x2\" into its base name and quantity,\n// so the name can be looked up in the material_icons table regardless of how much was needed.\nexport function parseMaterialEntry(entry: string): { name: string; qty: string | null } {\n const m = entry.match(/^(.*?)\\s*[xX]\\s*(\\d+)\\s*$/);\n if (m) return { name: m[1].trim(), qty: m[2] };\n return { name: entry.trim(), qty: null };\n}\n\nexport async function countUndiscoveredItems(): Promise<{ total: number; undiscovered: number }> {\n const result = await sqlite.execute(\n \"SELECT COUNT(*) as total, SUM(CASE WHEN status = 'undiscovered' THEN 1 ELSE 0 END) as undiscovered FROM upgrade_items\",\n );\n const row = result.rows[0] as unknown as { total: number; undiscovered: number };\n return { total: Number(row.total), undiscovered: Number(row.undiscovered) };\n}\n","deleted",false,"label",[14],"599c3621-9315-4d74-9cc5-4cfca3f7fd3c",["D",1788830276477],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Metin2 Arthion guild boss & drop location guide","imageUrl","userId","b71e33f8-d99a-4cff-b095-38f58c0a5236","pinnedFileId","01a07e97-dc4a-73bc-8d45-7ce11e31c01a","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019fd3a0-5b29-72d9-8429-c2783b92627c","tursoName","599c362193154d749cc54cfca3f7fd3c","tursoHostname","599c362193154d749cc54cfca3f7fd3c-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_106":102},"org",{"_9":10,"_99":100,"_101":102,"_55":56,"_103":104,"_105":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",240,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Valentino Rodrigues","avatar","https://lh3.googleusercontent.com/a/ACg8ocLUTO6MzdqeXpcs4pmDUIuBGqLrhsGH0xN-uIFC_LP0kPooCA=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_140":141,"_142":143,"_144":145,"_146":42,"_147":42,"_148":42,"_149":32,"_150":-5,"_151":-7,"_152":-7,"_153":63,"_154":42,"_155":42,"_156":-5,"_157":42,"_158":42,"_159":42,"_160":-5},"ENV",{"_111":112,"_113":114,"_115":90,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]