[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_151":152,"_153":154},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_114":-5,"_20":115,"_22":116,"_117":118,"_119":120,"_25":121,"_24":-5,"_122":-5,"_123":-5,"_124":53,"_125":126,"_127":44,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","konnnitiha","name","totteokino-burogu","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","0070e8e9-8f63-47bd-ad1d-5bba59b8fb05","main.ts","fileId","50619590-a8eb-11f1-8a86-1607ee4eb77e","parentId","branchId","2b0bf5ca-d8e6-48d3-8f1b-71afa1e89153","branchVersion",10,"latest",true,"createdAt",["D",1788590650779],9,"fileType","http","content","// ==========================================\n// 【完全修正版 1回目：ここから貼り付け】\n// ==========================================\n// 💡 ↓ここだけ！貼り付けたあとに「（どっと）」を半角ドット「.」に手動で直してね！\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// 🔑 管理者用の秘密のパスワード\nconst ADMIN_PASSWORD = \"fj10576890:^\";\n\n// 🛠 データベースの初期化\nasync function initDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS rich_posts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n views INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS post_files (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n post_id INTEGER NOT NULL,\n filename TEXT NOT NULL,\n file_data TEXT NOT NULL,\n file_type TEXT NOT NULL\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS post_comments (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n post_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n text TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n}\n\nexport default async function server(request: Request): Promise {\n const url = new URL(request.url);\n await initDatabase();\n\n if (url.pathname === \"/\" && request.method === \"GET\") {\n await sqlite.execute(\"UPDATE rich_posts SET views = views + 1\");\n }\n\n if (url.pathname === \"/add\" && request.method === \"POST\") {\n const formData = await request.formData();\n const password = formData.get(\"password\") as string;\n const title = formData.get(\"title\") as string || \"無題の記事\";\n const content = formData.get(\"content\") as string || \"\";\n const filesJson = formData.get(\"filesData\") as string || \"[]\";\n\n if (password !== ADMIN_PASSWORD) {\n return new Response(\"認証エラー\", { status: 403 });\n }\n\n const postResult = await sqlite.execute({\n sql: \"INSERT INTO rich_posts (title, content) VALUES (?, ?)\",\n args: [title, content],\n });\n\n const newPostId = Number(postResult.lastInsertRowid);\n const files = JSON.parse(filesJson);\n for (const file of files) {\n await sqlite.execute({\n sql:\n \"INSERT INTO post_files (post_id, filename, file_data, file_type) VALUES (?, ?, ?, ?)\",\n args: [newPostId, file.name, file.data, file.type],\n });\n }\n return Response.redirect(url.origin);\n }\n\n if (url.pathname === \"/comment\" && request.method === \"POST\") {\n const formData = await request.formData();\n const postId = parseInt(formData.get(\"postId\") as string, 10);\n const commentName = formData.get(\"commentName\") as string || \"名無しさん\";\n const commentText = formData.get(\"commentText\") as string;\n\n if (postId && commentText) {\n await sqlite.execute({\n sql: \"INSERT INTO post_comments (post_id, name, text) VALUES (?, ?, ?)\",\n args: [postId, commentName, commentText],\n });\n }\n return Response.redirect(url.origin);\n }\n\n if (url.pathname === \"/delete\" && request.method === \"POST\") {\n const formData = await request.formData();\n const password = formData.get(\"password\") as string;\n const id = parseInt(formData.get(\"id\") as string, 10);\n\n if (password !== ADMIN_PASSWORD) {\n return new Response(\"認証エラー\", { status: 403 });\n }\n\n await sqlite.execute({\n sql: \"DELETE FROM rich_posts WHERE id = ?\",\n args: [id],\n });\n await sqlite.execute({\n sql: \"DELETE FROM post_files WHERE post_id = ?\",\n args: [id],\n });\n await sqlite.execute({\n sql: \"DELETE FROM post_comments WHERE post_id = ?\",\n args: [id],\n });\n return Response.redirect(url.origin);\n }\n\n const postsResult = await sqlite.execute(\n \"SELECT id, title, content, views, created_at FROM rich_posts ORDER BY created_at DESC\",\n );\n const allPosts = [];\n\n if (postsResult && postsResult.rows) {\n for (const row of postsResult.rows) {\n const pId = Number(row.id);\n const pTitle = String(row.title || \"無題の記事\");\n const pContent = String(row.content || \"\");\n const pViews = Number(row.views || 0);\n const pDate = String(row.created_at || new Date().toISOString());\n\n const filesResult = await sqlite.execute({\n sql:\n \"SELECT filename, file_data, file_type FROM post_files WHERE post_id = ?\",\n args: [pId],\n });\n const parsedFiles = (filesResult.rows || []).map((f) => ({\n name: String(f.filename),\n data: String(f.file_data),\n type: String(f.file_type),\n }));\n\n const commentsResult = await sqlite.execute({\n sql:\n \"SELECT name, text, created_at FROM post_comments WHERE post_id = ? ORDER BY created_at ASC\",\n args: [pId],\n });\n const parsedComments = (commentsResult.rows || []).map((c) => ({\n name: String(c.name),\n text: String(c.text),\n date: String(c.created_at),\n }));\n\n allPosts.push({\n id: pId,\n title: pTitle,\n content: pContent,\n views: pViews,\n created_at: pDate,\n files: parsedFiles,\n comments: parsedComments,\n });\n }\n }\n // （※ここから下の続きは「2回目」で送るよ！）\n // ==========================================\n // 【完全修正版 2回目：ここからコピーして下に繋げてね】\n // ==========================================\n\n const allTags = new Set();\n allPosts.forEach((post) => {\n const matches = post.content.match(/#[^\\s#]+/g);\n if (matches) matches.forEach((tag) => allTags.add(tag));\n });\n\n const html = `\n \n \n \n \n \n 最強のポートフォリオブログ\n \n \n \n\n

📝 最強のポートフォリオブログ

\n \n

\n\n \n\n

✨ 新しい作品・記事を投稿する

\n \n

\n\n \n// ==========================================\n// 【完全修正版 3回目：ここからコピーして下に繋げてね】\n// ==========================================\n\n

\n ${\n allPosts.length === 0\n ? '

まだ投稿がありません。ログインして最初の作品を投稿しよう！

'\n : \"\"\n }\n ${\n allPosts.map((post) => `\n

${post.title}

\n 📅 ${\n new Date(post.created_at).toLocaleString(\"ja-JP\", {\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n })\n }\n 👁 ${post.views} 回閲覧\n

\n \n ${\n post.files.length > 0\n ? `\n

📎 添付されたファイル・作品 (${post.files.length}):

\n ${\n post.files.map((file) => {\n if (file.type.startsWith(\"image/\")) {\n return ` $\"${file.name}\"$ `;\n }\n return `\n

\n 📄 ${file.name} (${\n file.type.split(\"/\") || \"file\"\n })\n 💾 ダウンロードして開く\n

\n `;\n }).join(\"\")\n }\n

\n `\n : \"\"\n }\n \n

${post.content}

\n \n

\n\n

💬 コメント (${post.comments.length})

\n ${\n post.comments.length === 0\n ? '

まだコメントはありません。

'\n : \"\"\n }\n ${\n post.comments.map((c) => `\n

\n 👤 ${c.name}\n 🕒 ${\n new Date(c.date).toLocaleString(\"ja-JP\", {\n month: \"2-digit\",\n day: \"2-digit\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n })\n }\n

${c.text}

\n `).join(\"\")\n }\n

\n\n

\n \n

\n `).join(\"\")\n }\n

\n\n \n \n \n `;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=UTF-8\" },\n });\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1788590650779],"children",[],[35],"8e54855c-77bd-4574-8803-7d84fc1620f9",["D",1788586404374],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","e8dc4c42-368d-443a-bdb0-f12c12a7ed90","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a06c07-a416-700f-9d79-6326f651fc92","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_113":19},"org",{"_11":12,"_108":19,"_109":19,"_70":71,"_110":111,"_112":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":147,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":148,"_95":149,"_97":150,"_99":53},[144],"files",[144],"counts",{"_134":77,"_135":136,"_137":77,"_31":138,"_139":140},[132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":133},[35],"pulls","branches",1,"forks",{"_141":77,"_143":77},"connections",{"_141":77,"_142":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":145,"_18":146},[],[35],["D",1788586404374],{"_11":12,"_113":19},{"_11":12,"_108":19,"_109":19,"_70":71,"_110":111,"_112":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_129":184,"_185":186,"_187":188,"_189":53,"_190":53,"_191":53,"_192":44,"_193":-5,"_194":-7,"_195":-7,"_196":77,"_197":53,"_198":53,"_199":-5,"_200":53,"_201":53,"_202":53,"_203":-5},"ENV",{"_155":156,"_157":158,"_159":16,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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"]

Code