[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_100":101,"_102":103},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","konnnitiha","name","totteokino-burogu","path","main.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":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/konnnitiha/totteokino-burogu/code/main.ts","extension","id","0070e8e9-8f63-47bd-ad1d-5bba59b8fb05","fileId","50619590-a8eb-11f1-8a86-1607ee4eb77e","parentId","branchId","2b0bf5ca-d8e6-48d3-8f1b-71afa1e89153","branchVersion",10,"latest",true,"createdAt",["D",1788590650779],"version",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",[14],"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",{"_9":10,"_99":53},"org",{"_9":10,"_94":53,"_95":53,"_55":56,"_96":97,"_98":42},"branch",{"_35":30,"_11":85,"_22":28,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":12,"_93":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_78":-5,"_133":134,"_135":136,"_137":138,"_139":42,"_140":42,"_141":42,"_142":32,"_143":-5,"_144":-7,"_145":-7,"_146":62,"_147":42,"_148":42,"_149":-5,"_150":42,"_151":42,"_152":42,"_153":-5},"ENV",{"_104":105,"_106":107,"_108":85,"_109":110,"_111":112,"_113":114,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","9e167d8120a57de5d747867e0b686da51bcc19a4","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"]